Using Database Schemas of Legacy Applications for Microservices Identification: A Mapping Study
Article No.: 11, Pages 1 - 7
Abstract
The extraction of software components or services from a legacy system, is a very active field of research especially after the introduction of the microservices architectures. There are many different proposed approaches to solve this complex problem with the help of static and dynamic analysis of the source code, domain driven business dataflow diagrams etc. When we are dealing with a legacy system (e.g., a system with monolithic architecture) the most common asset that we inherit, aside from the application's code itself, is the database schema and its data. The source code isn't always available for analysis and the dataflow diagrams although helpful to some extent, they do not provide any reuse of the system's source code. The purpose of this research is to systematically identify primary studies that are using the database artefacts for microservice extraction, analyse the type of the artefacts and the degree they are used, and lastly investigate if the proposed methods support automation. We will then try to verbally analyse their viability in a real world scenario based on our many year experience working with legacy systems. In the context of this research, we conducted a systematic mapping study regarding the usage of database artefacts for the identification of components or services. This article presents the results of this study. Our future research goal is to use the database schema, state of data, dependencies, foreign keys etc., for identifying discrete business units within the legacy system database. Each such unit will have loose coupling with other units and be highly cohesive making it a potential microservice.
References
[1]
Abdellatif, M., Shatnawi, A., Mili, H., Moha, N., Boussaidi, G.E., Hecht, G., Privat, J. and Guéhéneuc, Y.-G. 2021. A taxonomy of service identification approaches for legacy software systems modernization. Journal of Systems and Software. 173, (Mar. 2021), 110868.
[2]
Alwis, A.A.C.D., Barros, A., Fidge, C. and Polyvyanyy, A. 2020. Remodularization Analysis for Microservice Discovery Using Syntactic and Semantic Clustering. International Conference on Advanced Information Systems Engineering (2020), 3–19.
[3]
Amiri, M., Parsa, S. and Lajevardi Mohammadzade, A. 2016. Multifaceted service identification: Process, requirement and data. Computer Science and Information Systems. 13, 2 (2016), 335–358.
[4]
Baghdadi, Y. 2007. Reverse engineering relational databases to identify and specify basic Web services with respect to service oriented computing. Information Systems Frontiers. 8, 5 (Jan. 2007), 395–410.
[5]
Carvalho, L., Garcia, A., Assunção, W.K.G., Bonifácio, R., Tizzei, L.P. and Colanzi, T.E. 2019. Extraction of Configurable and Reusable Microservices from Legacy Systems: An Exploratory Study. Proceedings of the 23rd International Systems and Software Product Line Conference - Volume A (New York, NY, USA, 2019), 26–31.
[6]
De Alwis, A.A.C., Barros, A., Fidge, C. and Polyvyanyy, A. 2018. Discovering Microservices in Enterprise Systems Using a Business Object Containment Heuristic. On the Move to Meaningful Internet Systems. OTM 2018 Conferences. H. Panetto, C. Debruyne, H.A. Proper, C.A. Ardagna, D. Roman, and R. Meersman, eds. Springer International Publishing. 60–79.
[7]
De Alwis, A.A.C., Barros, A., Polyvyanyy, A. and Fidge, C. 2018. Function-Splitting Heuristics for Discovery of Microservices in Enterprise Systems. Service-Oriented Computing. C. Pahl, M. Vukovic, J. Yin, and Q. Yu, eds. Springer International Publishing. 37–53.
[8]
De Alwis, A.A.C., Barros, A.P., Fidge, C.J. and Polyvyanyy, A. 2018. Using business object patterns for discovery of microservices in enterprise systems. (2018).
[9]
Deb, K., Pratap, A., Agarwal, S. and Meyarivan, T. 2002. A fast and elitist multiobjective genetic algorithm: NSGA-II. IEEE Transactions on Evolutionary Computation. 6, 2 (2002), 182–197.
[10]
Del Grosso, C., Di Penta, M. and de Guzman, I.G.-R. 2007. An approach for mining services in database oriented applications. 11th European Conference on Software Maintenance and Reengineering (CSMR’07) (Amsterdam, The Netherlands, 2007), 287–296.
[11]
Department of Computer Science, King Mongkut's Institute of Technology Ladkrabang, Bangkok, Thailand, Raksawat, C. and Charoenporn, P. 2021. Software Testing System Development Based on ISO 29119. Journal of Advances in Information Technology. 12, 2 (2021), 128–134.
[12]
Fowler 2014. Microservices. Microservices.
[13]
Gomes Barbosa, M.H. and M. Maia, P.H. 2020. Towards Identifying Microservice Candidates from Business Rules Implemented in Stored Procedures. 2020 IEEE International Conference on Software Architecture Companion (ICSA-C) (Salvador, Brazil, Mar. 2020), 41–48.
[14]
Huergo, R.S., Pires, P.F. and Delicato, F.C. 2014. A method to identify services using master data and artifact-centric modeling approach. Proceedings of the 29th Annual ACM Symposium on Applied Computing (Gyeongju Republic of Korea, Mar. 2014), 1225–1230.
[15]
Kitchenham, B.A. 2007. Guidelines for performing systematic literature reviews in software engineering. Technical report, EBSE Technical Report EBSE-2007-01. (Jul. 2007).
[16]
Levcovitz, A., Terra, R. and Valente, M.T. 2016. Towards a Technique for Extracting Microservices from Monolithic Enterprise Systems. arXiv:1605.03175 [cs]. (May 2016).
[17]
Mazlami, G., Cito, J. and Leitner, P. 2017. Extraction of Microservices from Monolithic Software Architectures. 2017 IEEE International Conference on Web Services (ICWS) (2017), 524–531.
[18]
Nooijen, E.H.J., van Dongen, B.F. and Fahland, D. 2013. Automatic Discovery of Data-Centric and Artifact-Centric Processes. Business Process Management Workshops. M. La Rosa and P. Soffer, eds. Springer Berlin Heidelberg. 316–327.
[19]
Ponce Mella, F., Márquez, G. and Astudillo, H. 2019. Migrating from monolithic architecture to microservices: A Rapid Review. (Sep. 2019).
[20]
Romani, Y., Tibermacine, O. and Tibermacine, C. 2022. Towards Migrating Legacy Software Systems to Microservice-based Architectures: a Data-Centric Process for Microservice Identification. 2022 IEEE 19th International Conference on Software Architecture Companion (ICSA-C) (Honolulu, HI, USA, Mar. 2022), 15–19.
[21]
S. da Silva, H., Carneiro, G. and Monteiro, M. 2019. Towards a Roadmap for the Migration of Legacy Software Systems to a Microservice based Architecture: Proceedings of the 9th International Conference on Cloud Computing and Services Science (Heraklion, Crete, Greece, 2019), 37–47.
[22]
Saha, D. 2015. Service Mining from Legacy Database Applications. 2015 IEEE International Conference on Web Services (New York, NY, USA, Jun. 2015), 448–455.
[23]
Shehab, M.A., Tashtoush, Y.M., Hussien, W.A., Alandoli, M.N. and Jararweh, Y. 2015. An Accumulated Cognitive Approach to Measure Software Complexity. Journal of Advances in Information Technology. (2015), 27–33.
[24]
Wohlin, C. 2014. Guidelines for snowballing in systematic literature studies and a replication in software engineering. Proceedings of the 18th International Conference on Evaluation and Assessment in Software Engineering - EASE ’14 (London, England, United Kingdom, 2014), 1–10.
Index Terms
- Using Database Schemas of Legacy Applications for Microservices Identification: A Mapping Study
Recommendations
Modernizing Legacy Systems with Microservices: A Roadmap
EASE '21: Proceedings of the 25th International Conference on Evaluation and Assessment in Software EngineeringLegacy systems are long-lived applications, with obsolete technology and degraded architecture. These systems hamper digital transformation and innovation, and require a great amount of resources for maintenance. The modernization of monolithic legacy ...
Monolith Migration Complexity Tuning Through the Application of Microservices Patterns
Software ArchitectureAbstractThe microservices architecture has become mainstream for the development of business applications because it supports the adaptation of scalability to the type of demand, but, most importantly, because it fosters an agile development process based ...
Improving microservices extraction using evolutionary search
Abstract Context:Microservices constitute a modern style of building software applications as collections of small, cohesive, and loosely coupled services, i.e., modules, that are developed, deployed, and scaled independently.
...
Comments
Information & Contributors
Information
Published In
September 2022
132 pages
ISBN:9781450397407
DOI:10.1145/3564982
Copyright © 2022 ACM.
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]
Publisher
Association for Computing Machinery
New York, NY, United States
Publication History
Published: 30 January 2023
Check for updates
Author Tags
Qualifiers
- Research-article
- Research
- Refereed limited
Conference
ICACS 2022
ICACS 2022: 2022 The 6th International Conference on Algorithms, Computing and Systems
September 16 - 18, 2022
Larissa, Greece
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- 0Total Citations
- 458Total Downloads
- Downloads (Last 12 months)235
- Downloads (Last 6 weeks)19
Reflects downloads up to 01 Jan 2025
Other Metrics
Citations
View Options
View options
View or Download as a PDF file.
PDFeReader
View online with eReader.
eReaderHTML Format
View this article in HTML Format.
HTML FormatLogin options
Check if you have access through your login credentials or your institution to get full access on this article.
Sign in