Abstract
This paper presents a method for extracting a conceptual schema from a relational database. The method is based on an analysis of data manipulation statements in the code of an application using a relational DBMS. Attributes representing references between tables in the relational schema, and possible keys are determined by an analysis of join conditions in queries and view definitions. Knowledge about which attributes link tables is used to investigate the database extension in a selective manner. When the keys cannot be unambiguously determined, possible solutions are generated by the system under guidance of the user. The approach makes it possible to efficiently construct a conceptual schema from only rudimentary information.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
H. Briand, C. Ducateau, Y. Hebrail, D. Herin-Aime, J. Kouloumdjian: From Minimal Cover to Entity-Relationship Diagram. Proceedings of the International Conference on the Entity Relationship Approach, 1987
M. L. Brodie: The Promise of Distributed Computing and the Challenge of Legacy Information Systems. IFIP TC2/WG2.6 Conference on Semantics of Interoperable Database Systems (1993)
M. Castellanos, F. Saltor: Extraction of Data Dependencies. Information Modelling and Knowledge bases V, 1993
P. P. Chen: The Entity-Relationship Model — Towards a Unified View of Data ACM Transactions On Database Systems, pages 9–36, 1976.
R. H. L. Chiang, T. M. Barren, V. C. Storey: Reverse Engineering of Relational Databases: Extraction of an EER Model from a Relational Database. Data & Data Engineering, 10(12):107–142, 1994.
H. K. Davis, A. K. Arora: Converting a Relational Database Model into an Entity-Relationship model. Proceedings of the 7th International Conference on the Entity Relationship Approach, 1988
M. M. Fonkam, W. A. Gray: An Approach to Eliciting the Semantics of Relational Databases. Proceedings of the 4th International Conference on Computer Aided Software Engineering (CAiSE), 1992.
J. L. Hainaut, C. Tonneau, M. Joris, M. Chandelon: Schema Transformation Techniques for Database Reverse Engineering. Proceedings of the International Conference on the Entity Relationship Approach, 1993
P. Johannesson, K. Kalman: A Method for Translating Relational Schemas into Conceptual Schemas. Proceedings of the 8th International Conference on the Entity Relationship Approach, 1989
P. Johannesson: A Method for Translating Relational Schemas into Conceptual Schemas. Proceedings of the Tenth International Conference on Data Engineering, 1994
V. M. Markowitz, J. A. Makowsky: Identifying Extended Entity-Relationship Object Structures in Relational Schemas. IEEE Transactions on Software Engineering, Vol. 16, 8, 1990.
S. Navathe, A. Awong: Abstracting Relational and Hierarchical Data With a Semantic Data Model Proceedings of the 6th International Conference on the Entity Relationship Approach, 1987
C. Parent, S. Spaccapietra: ERC+: an Object Based Entity-Relationship Approach Conceptual Modelling, Databases and CASE: An Integrated View of Information Systems Development, eds, P. Loucopoulos and R. Zicari, John Wiley, 1992.
W. J. Premerlani, M. R. Blaha: An Approach for Reverse Engineering of Relational Databases Proceedings of the IEEE Working Conference on Reverse Engineering, 1993.
P. Shoval, N. Schreiber: Database Reverse Engineering: From the Relational to the Binary Relational Model Data and Knowledge Engineering, Elsevier Science Publishers, North-Holland, 1993.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1994 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Andersson, M. (1994). Extracting an entity relationship schema from a relational database through reverse engineering. In: Loucopoulos, P. (eds) Entity-Relationship Approach — ER '94 Business Modelling and Re-Engineering. ER 1994. Lecture Notes in Computer Science, vol 881. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-58786-1_93
Download citation
DOI: https://doi.org/10.1007/3-540-58786-1_93
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-58786-6
Online ISBN: 978-3-540-49100-2
eBook Packages: Springer Book Archive