Database Schema Elicitation to Modernize Relational Databases

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

2012

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.

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

@conference{iceis12,
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,},
year={2012},
pages={126-132},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003980801260132},
isbn={978-989-8565-10-5},
}

in EndNote Style

TY - CONF
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