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.