Database Schema Elicitation to Modernize Relational Databases

Ricardo Pérez-Castillo, Ignacio García Rodríguez de Guzmán, Danilo Caivano, Mario Piattini


Legacy enterprise systems mainly consist of two kinds of artefacts: source code and databases. Typically, the maintenance of those artefacts is carried out through re-engineering processes in isolated manners. However, for a more effective maintenance of the whole system both should be analysed and evolved jointly according to ADM (Architecture-Driven Modernization) approach. Thus, the ROI and the lifespan of the legacy system are expected to improve. In this sense, this paper proposes the schema elicitation technique for recovering the relational database schema that is minimally used by the source code. For this purpose, the technique analyses database queries embedded in the legacy source code in order to remove the dead parts of the database schema. Also, this proposal has been validated throughout a real-life case study.


  1. Bianchi, A., Caivano, D., Marengo, V. and Visaggio, G. 2003. Iterative Reengineering of Legacy Systems. IEEE Trans. Softw. Eng., 29, 225-241.
  2. Blaha, M. Year. A Retrospective On Industrial Database Reverse Engineering Projects-Part 1. In: Proceedings of The 8th Working Conference on Reverse Engineering (WCRÓ01), 2001 Suttgart, Germany. Ieee Computer Society, 136-147.
  3. Cohen, Y. and Feldman, Y. A. 2003. Automatic HighQuality Reengineering of Database Programs By Abstraction, Transformation and Reimplementation. ACM Trans. Softw. Eng. Methodol., 12, 285-316.
  4. Fong, J., 1997. Converting Relational to Object-oriented Databases. ACM SIGMOD Record, 26, 53-58.
  5. Hainaut, J.-L., Henrard, J., Hick, J.-M., Roland, D. and Englebert, V. 1996. Database Design Recovery. Proceedings of The 8th International Conference on Advances Information System Engineering. SpringerVerlag.
  6. ISO/IEC. 1992. ISO/IEC 9075:1992, Database Language Sql.
  7. ISO/IEC. 2009. ISO/IEC Dis 19506. Knowledge Discovery Meta-Model (KDM), V1.1 (ArchitectureDriven Modernization).
  8. Khusidman, V. And Ulrich, W. 2007. Architecture-Driven Modernization: Transforming the Enterprise. Draft V.5. andHttp://Www.Omg.Org/Docs/Admtf/07-12-01. Pdf. Omg.
  9. Lewis, G. A., Smith, D. B. and Kontogiannis, K., 2010. A Research Agenda for Service-Oriented Architecture (Soa): Maintenance and Evolution of Service-oriented Systems. Software Engineering Institute.
  10. Moyer, B., 2009. Software Archeology. Modernizing Old Systems. Embedded Technology Journal [Online], 1. Available: Http://Adm.Omg.Org/Docs/Software_ ArcheoLogy_4-Mar-2009.Pdf [Accessed Junio 2009].
  11. Omg 2008. Qvt. Meta Object Facility (Mof) 2.0 Query/View/Transformation Specification. Http:// Www.Omg.Org/Spec/Qvt/1.0/Pdf. Omg.
  12. Omg. 2009. Architecture-Driven Modernization Standards Roadmap. [Online]. Omg. Available: Http://Adm. Omg.Org/Admtf%20roadmap.Pdf [Accessed 29/10/2009].
  13. Pérez-Castillo, R., García-Rodríguez De Guzmán, I., Caballero, I., Polo, M. And Piattini, M. 2009. Preciso: A Reengineering Process and a Tool for Database Modernisation Through Web Services 24th ACM Symposium on Applied Computing. P. 2126-2133.
  14. Pérez-Castillo, R., García Rodríguez De Guzmán, I. and Piattini, M. 2011. Architecture-Driven Modernization. In: Dogru, A. H. And Bier, V. (Eds.) Modern Software Engineering Concepts And Practices: Advanced Approaches. Igi Global.
  15. Polo, M., García-Rodríguez De Guzmán, I. And Piattini, M. 2007. An Mda-based Approach For Database ReEngineering. J. Softw. Maint. Evol., 19, 383-417.
  16. Ramanathan, S. And Hodges, J. 1997. Extraction of Object-oriented Structures From Existing Relational Databases. ACM SIGMOD Record, 26, 59-64.
  17. Reus, T., Geers, H. And Deursen, A. V. Year. Harvesting Software for MDA-based Recovering. In: European Conference on Model Driven Architecture - Foundations and Applications, 2006 Bilbao (Spain). Springer-Verlag Berlin Heidelberg.
  18. Sneed, H. M., 2005. Estimating The Costs of a Reengineering Project, IEEE Computer Society.
  19. Ulrich, W. M. and Newcomb, P. H., 2010. Information Systems Transformation. Architecture Driven Modernization Case Studies, Burlington, MA, Morgan Kauffman.
  20. Visaggio, G., 2001. Ageing of a Data-intensive Legacy System: Symptoms and Remedies. Journal Of Software Maintenance, 13, 281-308.
  21. Wu, W., Reinwald, B., Sismanis, Y. and Manjrekar, R. Year. Discovering Topical Structures of Databases. In: ACM SIGMOD International Conference on Management of Data, 2008 Vancouver, Canada. Acm, 1019-1030.

Paper Citation

in Harvard Style

Pérez-Castillo R., García Rodríguez de Guzmán I., Caivano D. and Piattini M. (2012). Database Schema Elicitation to Modernize Relational Databases . In Proceedings of the 14th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8565-10-5, pages 126-132. DOI: 10.5220/0003980801260132

in Bibtex Style

author={Ricardo Pérez-Castillo and Ignacio García Rodríguez de Guzmán and Danilo Caivano and Mario Piattini},
title={Database Schema Elicitation to Modernize Relational Databases},
booktitle={Proceedings of the 14th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},

in EndNote Style

JO - Proceedings of the 14th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - Database Schema Elicitation to Modernize Relational Databases
SN - 978-989-8565-10-5
AU - Pérez-Castillo R.
AU - García Rodríguez de Guzmán I.
AU - Caivano D.
AU - Piattini M.
PY - 2012
SP - 126
EP - 132
DO - 10.5220/0003980801260132