Browse > Article
http://dx.doi.org/10.6109/jkiice.2019.23.5.523

Database Reverse Engineering Using Master Data in Microservice Architecture  

Shin, Kwang-chul (The Graduate of Business IT, Kookmin University)
Lee, Choon Y. (The Graduate of Business IT, Kookmin University)
Publication Information
Journal of the Korea Institute of Information and Communication Engineering / v.23, no.5, 2019 , pp. 523-532 More about this Journal
Abstract
Microservice architecture focuses on dividing it into small and lightweight services to build for the purpose of performing very close business functions. So it tends to concentrate only on agility, productivity, reliability, and ease of deployment of software development. Microservice architecture considers database as just a file or storage for storing and extracting data, emphasizing that data quality can be sacrificed for convenience and scalability of software development. Database reverse engineering for understanding database structure and data semantics is needed for data utilization for business decision making. However, it is difficult that reverse database engineering is applied in microservice architecture that neglects data quality. This study proposes database reverse engineering method that utilizes master data to restore the conceptual data model as a solution. The proposed method is applied to the return service database implemented by microservice architecture and verified its applicability.
Keywords
Database Reverse Engineering; Master Data; Microservice Architecture; Data Modeling;
Citations & Related Records
연도 인용수 순위
  • Reference
1 K. C. Shin, C. H. Hwang, and H. K. Jung, "Study on NoSQL Data Modeling," In INTERNATIONAL CONFERENCE ON FUTURE INFORMATION & COMMUNICATION ENGINEERING, vol. 8, no. 1, pp. 285-287, 2016.
2 P. Atzeni, F. Bugiotti, L. Cabibbo, and R. Torlone , "Data modeling in the NoSQL world," Computer Standards & Interfaces, 2016.
3 D. Pasqualin, G. Souza, E. L. Buratti, E. C. de Almeida, M. D. Del Fabro, and D. Weingaertner, "A case study of the aggregation query model in read-mostly nosql document stores," In Proceedings of the 20th International Database Engineering & Applications Symposium, pp. 224-229, Jul. 2016.
4 K. Shin, C. Hwang, and H. Jung, "NoSQL database design using UML conceptual data model based on Peter Chen's framework," International Journal of Applied Engineering Research, vol. 12, no. 5, pp. 632-636, 2017.
5 C. Y. Lee, Business Ingelligence & Data Analysis, Kookmin University Press, 2016.
6 J. L. Hainaut, J. Henrard, D. Roland, V. Englebert, and J. M. Hick, "Structure elicitation in database reverse engineering. In Reverse Engineering," Proceedings of the Third Working Conference on IEEE, pp. 131-140, Nov. 1996.
7 M. Blaha, "On reverse engineering of vendor databases," Proceedings Fifth Working Conference on Reverse Engineering, Honolulu: Hl, pp. 183-190, Oct. 1998.
8 H. L. Chiang, T. M. Barron, and V. C. Storey, "Reverse engineering of relational databases: Extraction of an EER model from a relational database," Data & Knowledge Engineering, vol. 12, no. 2, pp. 107-142, Mar. 1994.   DOI
9 C. Batini, S. Ceri, S. B. Navathe, "Conceptual Database Design - An Entity-Relationship Approach," Benjamin/Cummings, 1992.
10 J. M. Petit, J. Kouloumdjian, J. F. Boulicaut, and F. Toumani, "Using Queries to Improve Database Reverse Engineering," Proceeding ER '94 Proceedings of the13th International Conference on the Entity-Relationship Approach, Manchester, pp. 369-386, Dec. 1994.
11 W. J. Premerlani, and M. R. Blaha, "An approach for Reverse Engineering of Relational Databases," Proceedings Working Conference on Reverse Engineering, Baltimore, pp. 151-160, May. 1993.
12 D. Yeh, Y. Li, and W Chu, "Extracting entity relationship diagram from a table-based legacy database," Journal of Systems and Software, vol. 81, no. 5, pp. 746-771, May. 2008.
13 N. Mfourga, "Extracting Entity-Relationship Schemas from Relational Databases A Form-driven Approach," Proceedings of the Fourth Working Conference on Reverse Engineering, Amsterdam, pp. 184-193, Oct. 1997.
14 D. Tsichritzis, and A Klug, "The ANSI/X3/SPARC DBMS framework report of the study group on database management systems," Information systems, vol. 3, no. 3, pp. 173-191, 1978.   DOI
15 A. Chebotko, A. Kashlev, and S. Lu, "A big data modeling methodology for Apache Cassandra," In 2015 IEEE International Congress on Big Data, pp. 238-245, Jun. 2015.
16 R. Alhajj, "Extracting the extended entity-relationship model from a legacy relational database," Information Systems, vol. 28, vol. 6, pp. 597-618, 2003.   DOI
17 M. Fowler, and J. Lewis, Microservices a definition of this new architectural term [Internet]. Available: http://martinfowler.com/articles/microservices.html , 2014.
18 R. Rodger, The Tao of Microservices. Manning Publications Company, 2016.
19 F. Bugiotti, L. Cabibbo, P. Atzeni, and R. Torlone, "Database design for NoSQL systems," In International Conference on Conceptual Modeling, pp. 223-231, Oct. 2014.
20 R. Hernandez, Y. Becerra, and J. Torres, "Automatic query driven data modelling in Cassandra," Procedia Computer Science, 51, pp. 2822-2826, 2015.   DOI