Papers Papers/2022 Papers Papers/2022



Paper Unlock

Authors: Ricardo Pérez-Castillo 1 ; Ignacio García Rodríguez de Guzmán 1 ; Danilo Caivano 2 and Mario Piattini 1

Affiliations: 1 University of Castilla-La Mancha, Spain ; 2 University of Bari, Italy

Keyword(s): Database Modernization, Legacy Systems, ADM, KDM, SQL, Metamodel, Model Transformations, QVT.

Related Ontology Subjects/Areas/Topics: Artificial Intelligence ; Data Mining ; Databases and Information Systems Integration ; Enterprise Information Systems ; Information Systems Analysis and Specification ; Legacy Systems ; Model Driven Architectures and Engineering ; Sensor Networks ; Signal Processing ; Soft Computing

Abstract: 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.


Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
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 2: ICEIS; ISBN 978-989-8565-10-5; ISSN 2184-4992, SciTePress, pages 126-132. DOI: 10.5220/0003980801260132

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 2: ICEIS},


JO - Proceedings of the 14th International Conference on Enterprise Information Systems - Volume 2: ICEIS
TI - Database Schema Elicitation to Modernize Relational Databases
SN - 978-989-8565-10-5
IS - 2184-4992
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
PB - SciTePress