Presentation 2021-07-15
Proposal of API design method using ER diagram
Tomoki Sugimoto, Masataka Mizukoshi, Shinsaku Numata, Kunio Hato,
PDF Download Page PDF download Page Link
Abstract(in Japanese) (See Japanese page)
Abstract(in English) In recent years, migration from monolithic applications to microservice architectures has been actively pursued. In the process of converting monolithic applications to microservices, database accesses are sometimes cut out and converted to APIs. However, to convert an existing SQL query into an API, it is necessary to read the content of the query and replace it with an HTTP request. In the case of monolithic applications, there are a wide variety of queries, and it is not possible to create an API with the same functionality by simply creating an API, which requires manual API design. In this paper, we propose a method for creating APIs for a wide variety of queries using a logic that can realize APIs using the ER diagram of a database maintained by a monolithic application. By using this method, the DB access part of a hypothetical monolithic application is automatically converted into an API, and a REST API with a hierarchical structure is designed.
Keyword(in Japanese) (See Japanese page)
Keyword(in English) Monolithic / microservice architecture / microservice architecture / API / ER diagram
Paper # ICM2021-9
Date of Issue 2021-07-08 (ICM)

Conference Information
Committee ICM
Conference Date 2021/7/15(2days)
Place (in Japanese) (See Japanese page)
Place (in English) Online
Topics (in Japanese) (See Japanese page)
Topics (in English)
Chair Kazuhiko Kinoshita(Tokushima Univ.)
Vice Chair Haruo Ooishi(NTT) / Eiji Takahashi(NEC)
Secretary Haruo Ooishi(Bosco) / Eiji Takahashi(Fujitsu)
Assistant Yoshifumi Kato(NTT)

Paper Information
Registration To Technical Committee on Information and Communication Management
Language JPN
Title (in Japanese) (See Japanese page)
Sub Title (in Japanese) (See Japanese page)
Title (in English) Proposal of API design method using ER diagram
Sub Title (in English)
Keyword(1) Monolithic
Keyword(2) microservice architecture
Keyword(3) microservice architecture
Keyword(4) API
Keyword(5) ER diagram
1st Author's Name Tomoki Sugimoto
1st Author's Affiliation Internet Multifeed Co.(MF)
2nd Author's Name Masataka Mizukoshi
2nd Author's Affiliation Internet Multifeed Co.(MF)
3rd Author's Name Shinsaku Numata
3rd Author's Affiliation Internet Multifeed Co.(MF)
4th Author's Name Kunio Hato
4th Author's Affiliation Internet Multifeed Co.(MF)
Date 2021-07-15
Paper # ICM2021-9
Volume (vol) vol.121
Number (no) ICM-114
Page pp.pp.1-5(ICM),
#Pages 5
Date of Issue 2021-07-08 (ICM)