Reverse Engineering of Relational Database Applications

This paper presents techniques for reverse engineering of relational database applications. The target of such an effort is the definition of a fully equipped object-oriented view of the relational database, including methods and constraints. Such views can be seen as a full specification of the database semantics, aiding for example in the identification of semantic heterogeneity among interoperable databases. The general problem of translating from an imperative programming language environment to a declarative context such as provided by our target OODML is very hard. However, we show that the specific features of database application software allow for the development of a framework geared towards the particular problems encountered in this context.

[1]  Veda C. Storey,et al.  Reverse Engineering of Relational Databases: Extraction of an EER Model from a Relational Database , 1994, Data Knowl. Eng..

[2]  Maurice van Keulen,et al.  The IMPRESS DDT: a database design toolbox based on a formal specification language , 1994, SIGMOD '94.

[3]  Peter M. G. Apers,et al.  Object-Oriented Views of Relational Databases Incorporating Behaviour , 1995, DASFAA.

[4]  S. Dao,et al.  Construction of a relational front-end for object-oriented database systems , 1993, Proceedings of IEEE 9th International Conference on Data Engineering.

[5]  Roger King,et al.  Report of the Workshop on Semantic Heterogeneity and Interpolation in multidatabase Systems , 1993, SGMD.

[6]  Herman Balsters,et al.  Typed Sets as a Basis for Object-Oriented Database Schemas , 1993, ECOOP.

[7]  Peter M.G. Apers,et al.  A framework for reverse engineering of relational database applications , 1995 .

[8]  Paul Johannesson,et al.  A method for transforming relational schemas into conceptual schemas , 1989, Proceedings of 1994 IEEE 10th International Conference on Data Engineering.

[9]  Malú Castellanos,et al.  A Methodology for Semantically Enriching Interoperable Databases , 1993, BNCOD.

[10]  Herman Lam,et al.  Transformation of data traversals and operations in application programs to account for semantic changes of databases , 1981, TODS.

[11]  Umeshwar Dayal,et al.  Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers , 1987, VLDB.