Data Reverse Engineering of Legacy Databases to Object Oriented Conceptual Schemas

• Published in: Electronic notes in theoretical computer science Vol. 72; no. 4; pp. 7 - 19
• Main Authors: Pérez, J., Ramos, I., Anaya, V., Cubel, J.M., Domínguez, F., Boronat, A., Carsí, J.A.
• Format: Journal Article
• Language: English
• Published: Elsevier B.V 01.03.2003
• Subjects: ADT (Abstract Data Type); Algebraic expressions; Data reverse engineering; Re-engineering; Reverse engineering; Rewriting rules; Terms rewriting system (TRS); Reverse engineering; Re-engineering; Data reverse engineering; Algebraic expressions; Terms rewriting system (TRS); ADT (Abstract Data Type); Rewriting rules
• ISSN: 1571-0661; 1571-0661
• DOI: 10.1016/S1571-0661(04)80622-4

This paper presents a solution and a methodology to recover legacy databases of most DBMS using formal-method based techniques. These formal methods (terms rewriting systems) are applied during the data reverse engineering process and allow for an automatic approach. This automatic approach reduces the time invested and the number of people involved in the data reverse engineering and data migration processes. This solution is being implemented in the RELS (Re-Engineering of Legacy Systems) tool. The RELS tool is under development in the Department of Information Systems and Computation of the Valencia University of Technology in collaboration with the industrial partner CARE-Technologies. RELS is used together with the model compiler Sosy Technology® of CARE-Technologies and provides a complete solution to the re-engineering proccess.