Synonyms
Database design recovery; Database redocumentation
Definition
Database reverse engineering is the process through which the logical and conceptual schemas of a legacy database, or of a set of files, are reconstructed from various information sources such as DDL code, data dictionary contents, database contents or the source code of application programs that use the database.
Basically, database reverse engineering comprises three processes, namely physical schema extraction, logical schema reconstruction, and schema conceptualization. The first process consists in parsing the DDL code or the contents of an active data dictionary in order to extract the physical schema of the database. Reconstructing the logical schema implies analyzing additional sources such as the data and the source code of the application programs to discover implicit constraints and data structures, that is, constructs that have not been declared but that are managed by the information system or by its...
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Recommended Reading
Baxter I, Mehlich M. Reverse engineering is reverse forward engineering. Sci Comput Program. 2000;36(2):131–47.
Blaha MR, Premerlani WJ. Observed idiosyncrasies of relational database designs. In: Proceedings of the 2nd IEEE Working Conference on Reverse Engineering; 1995. p. 116.
Casanova MA, Amaral de Sa JE. Mapping uninterpreted schemes into entity-relationship diagrams: two applications to conceptual schema design. IBM J Res Dev. 1984;28(1):82–94.
Chikofsky EJ, Cross II JH. Reverse engineering and design recovery: a taxonomy. IEEE Softw. 1990;7(1):13–7.
Davis KH, Aiken PH. Data reverse engineering: a historical view. In: Proceedings of the 7th Working Conference on Reverse Engineering; 2000. p. 70–8.
Davis KH, Arora AK. A methodology for translating a conventional file system into an entity-relationship model. In: Proceedings of the 4th International Conference on Entity-Relationship Approach; 1985. p. 148–59.
Edwards HM, Munro M. Deriving a logical model for a system using recast method. In: Proceedings of the 2nd IEEE Working Conference on Reverse Engineering; 1995. p. 126–35.
Hainaut J-L. Introduction to database reverse engineering, LIBD lecture notes. Belgium: University of Namur; 2002, p. 160. Retrieved Oct 2007 from http://www.info.fundp.ac.be/~dbm/publication/2002/DBRE-2002.pdf
Hainaut J-L. The transformational approach to database engineering. In: Lämmel R, Saraiva J, Visser J, editors. Generative and transformational techniques in software engineering, LNCS, vol. 4143. Berlin: Springer; 2006. p. 89–138.
Hainaut J-L, Clève A, Henrard J, Hick J-M. Migration of legacy information systems. In: Mens T, Demeyer S, editors. Software evolution. Berlin: Springer; 2007. p. 107–38.
Hainaut J-L, Roland D, Hick J-M, Henrard J, Englebert V. Database reverse engineering: from requirements to CARE tools. J Autom Softw Eng. 1996;3(1/2):9–45.
Navathe SB, Awong A. Abstracting relational and hierarchical data with a semantic data model. In: Proceedings of the Entity-Relationship Approach: A Bridge to the User; 1987. p. 305–33.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Hainaut, JL., Henrard, J., Englebert, V., Roland, D., Hick, JM. (2018). Database Reverse Engineering. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_646
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_646
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering