Data Reverse Engineering of Legacy Databases to Object Oriented Conceptual Schemas

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

[1]  Julia E. Hodges,et al.  Reverse Engineering Relational Schemas to Object-Orient ed Schemas , 1996 .

[2]  Paul Johannesson,et al.  A method for transforming relational schemas into conceptual schemas , 1989, Proceedings of 1994 IEEE 10th International Conference on Data Engineering.

[3]  Jean-François Boulicaut,et al.  Towards the reverse engineering of renormalized relational databases , 1996, Proceedings of the Twelfth International Conference on Data Engineering.

[4]  Vincent Englebert,et al.  Structure elicitation in database reverse engineering , 1996, Proceedings of WCRE '96: 4rd Working Conference on Reverse Engineering.

[5]  Veda C. Storey,et al.  A Framework for the Design and Evaluation of Reverse Engineering Methods for Relational Databases , 1996, Data Knowl. Eng..

[6]  Narciso Martí-Oliet,et al.  The Maude System , 1999, RTA.

[7]  William J. Premerlani,et al.  An approach for reverse engineering of relational databases , 1993, [1993] Proceedings Working Conference on Reverse Engineering.

[8]  J PremerlaniWilliam,et al.  An approach for reverse engineering of relational databases , 1994 .

[9]  Veda C. Storey,et al.  Reverse Engineering of Relational Databases: Extraction of an EER Model from a Relational Database , 1994, Data Knowl. Eng..

[10]  Martin Andersson,et al.  Extracting an Entity Relationship Schema From a Relational Database Through Reverse Engineering , 1994, Int. J. Cooperative Inf. Syst..