Abstract
In the Forward Engineering phase, the designer modifies the database conceptual schema and produces a logical and physical schema containing some “spurious” relations dictated by design tricks and DBMS's limitations. Therefore the rebuilding of the database conceptual schema from the physical database structure is a fundamental issue in the re-engineering and design recovery processes. Some proposed methodologies try to get the necessary information from the schema and from the content of the database, paying little attention to the analysis of the usage that the programs make of the data, while this can be thought as the most reliable source of information. In this paper we present an approach to the reverse engineering based on the identification of schema, primary key, SQL and procedural indicators that lead to the assertion of Prolog facts and, by some heuristic rules, to the rebuilding of the conceptual schema.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
References
Batini C., Ceri S., Navathe S.B.: Conceptual Database Design: An Entity-Relationship Approach, The Benjamin/Cummings Publishing Company,Inc., 1992.
Canfora G., Cimitile A., Munro M.: A Reverse Engineering Method for Identifying Reusable Abstract Data Type, Proceedings of IEEE Working Conference on Reverse Engineering, Baltimore 1993 (ISBN 0-8186-3780-3)
Ceri S., Gottlob G.: Normalization of Relations and Prolog, Communications of the ACM, June 1986, Vol. 29, No. 6.
Chiang R.H.L., Barron T.M., Storey V.C.: Reverse engineering of relational databases: Extraction of an EER model from a relational database, Data & Knowledge Engineeering, Vol. 12, No. 2 (March 1994), pp. 107–142
Chikofsky E.J., Cross II J.H.: Reverse Engineering and Design Recovery: A Taxonomy, IEEE Software, 7(1): 13–17, January 1990.
Date C.J., White C.J.: A guide to DB2 — Second edition, Addison-Wesley(1987)
Hainaut J-L., Chandelon M., Tonneau C., Joris M.: Contribution to a Theory of Database Reverse Engineering, Proceedings of IEEE Working Conference on Reverse Engineering, Baltimore 1993 (ISBN 0-8186-3780-3)
Information technology — Database languages — SQL2; ISO standard N. 9075
Korth H.F., Silberschatz A.: Database System Concepts, McGraw-Hill International Editions, Second Edition, 1991.
Premerlani W.J., Blaha M.R.: An Approach for Reverse Engineering of Relational Databases, Proceedings of IEEE Working Conference on Reverse Engineering, Baltimore 1993 (ISBN 0-8186-3780-3)
Signore O., Loffredo M.: Re-Engineering towards Object-Oriented Environments: the TROOP Project, Proceedings of The Eighth International Symposium on Computer and Information Sciences (ISCIS VIII), November 3–5, 1993, Istanbul, Turkey (Sponsored by IEEE)
Signore O., Loffredo M.: A Repository based Tool for Re-Engineering towards an Object Oriented Environment, ERCIM Database Research Group Workshop 4, May 3–5, 1993, ICS-FORTH, Crete, Greece
Teorey T.J., Yang D., Fry J.P.: A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Model, ACM Computing Surveys, Vol. 18, No.2, June 1986.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1994 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Signore, O., Loffredo, M., Gregori, M., Cima, M. (1994). Reconstruction of ER schema from database applications: a cognitive approach. 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_92
Download citation
DOI: https://doi.org/10.1007/3-540-58786-1_92
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