Database Reverse Engineering
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...
KeywordsReverse Engineering Conceptual Schema Relationship Type Database Design Logical Schema
- 2.Blaha MR, Premerlani WJ. Observed idiosyncrasies of relational database designs. In: Proceedings of the 2nd IEEE Working Conference on Reverse Engineering; 1995. p. 116.Google Scholar
- 5.Davis KH, Aiken PH. Data reverse engineering: a historical view. In: Proceedings of the 7th Working Conference on Reverse Engineering; 2000. p. 70–8.Google Scholar
- 6.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.Google Scholar
- 7.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.Google Scholar
- 8.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
- 10.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.Google Scholar
- 12.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. North-Holland; 1987. p. 305–33.Google Scholar