Abstract
This paper describes a method aiming at the extraction of generalization/specialization hierarchies contained in a relational database. This reverse engineering approach takes advantage of two major characteristies: first, we use DDL and DML specifications as well as data in a combined way, secondly, we provide not only generalization/specialization hierarchies but also integrity constraints allowing us to elicit the generalization/specialization links hidden in the structures and instances of the database. The result of the process consists of an enriched conceptual representation of the relational database. This approach is mainly based on heuristics. The heuristic rules map a relational meta-model onto a conceptual one. They are divided into three categories: semantics suspicion rules, reinforcement rules and confirmation rules. We illustrate our approach using a fairly complex example. Some extensions are discussed.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Laudon M, Laudon M, Management Information Systems-A Contemporary Perspective, Macinillan Publishing Company, New York, 1991.
Davis K.H, Arora A.K, Converting a Relational Database Model into an Entity-Relationship Model, Proceedings 6th Int. Conf. on ER Approach, New York, USA, 1987.
Hainaut J.L, Tonneau C, Joris M, Chandelon M, Schema Transformation Techniques for Database Reverse Engineering, Proceedings 12th Intern. Conf. on Entity-Relationship Approach, Arlington, Texas, 1993.
Fonkam M.M, Gray W.K, An Approach to Eliciting the Semantics of Relational Databases, Proc. of 4th Int. Conf. on Advance Information Systems Engineering-CAiSE’92, Springer-Verlag, 1992.
Markowitz V.M., Makowsky, J.A., Identifying Extended Entity-Relationship Object Structures in Relational Schemas, IEEE Transactions on Software Engineering, Vol 16(8), 1990.
Petit J.M, Kouloumdjian J, Boulicaut J.F, Toumani F, Using Queries to Improve Database Reverse Engineering, Proceedings 13th International Conference on ER Approach, Manchester, 1994.
Signore O, Loffredo M, Gregori M, Cima M, Reconstruction of ER Schema from Database Applications: a Cognitive Approach, Proceedings 13th Int. Conf. on ER Approach, Manchester, UK, 1994.
Premerlani W.J, Blaha M.R, An Approach for Reverse Engineering of Relational Databases, Communications of the ACM, Vol. 37, No5, 1994.
Jeusfeld M.A, Johnen U.A, An Executable Meta-Model for Reengineering of Database Schemas, Proceedings 13th Int. Conf. on ER Approach, Manchester, UK, 1994.
Missaoui R., Gagnon J. M., Godin R., Mapping an Extended Entity-Relationship Schema into a Schema of Complex Objets. OOER’95, Springer Verlag LNCS 1021, Gold Coast, Australia, December 95.
Ramanathan S, Hodges J, Extraction of Object-Oriented Structures from Existing Relational Databases. SIGMOD Record, vol 26, no 1, March 97.
Fong J., Converting Relational to Object-Oriented Databases. SIGMOD Record, vol 26, no 1, March 97.
Chiang R.H.L, Barron T.M, Storey V.C, Reverse Engineering of Relational Database.: Extraction of an EER model from a relational database, Data et Knowledge Engineering Vol no 12, 1994.
Comyn-Wattiau I, Akoka J, Reverse Engineering of Relational Database Physical Schemas, Proceedings 15th International Entity Relationship Conference, Cottbus, Germany, 1996.
Comyn-Wattiau I, Akoka J, Relational Database Reverse Engineering — Logical Schema Conceptualization, Network and Information Systems, to appear, 1999.
Lammari N., Lalcau R., Jouve M., Multiple, viewpoints of Is_A Inheritance Hierarchies through Normalization and Denormalization Mechanisms. OOIS’98 (International Conference on Object-Oriented Information systems) Proceedings, Springer-Vcrlag, Paris, Sept 1998.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1999 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Akoka, J., Comyn-Wattiau, I., Lammari, N. (1999). Relational Database Reverse Engineering. In: Chen, P.P., Embley, D.W., Kouloumdjian, J., Liddle, S.W., Roddick, J.F. (eds) Advances in Conceptual Modeling. ER 1999. Lecture Notes in Computer Science, vol 1727. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-48054-4_15
Download citation
DOI: https://doi.org/10.1007/3-540-48054-4_15
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-66653-0
Online ISBN: 978-3-540-48054-9
eBook Packages: Springer Book Archive