An integrated database reengineering architecture-a generic approach

Methods and tools have been proposed and developed to facilitate database design recovery under the framework of reverse engineering and reengineering. These tools and methods are usually limited to a particular scenario and requirement. They are not adaptive, or general enough, to suit other scenarios. In most cases, new tools and methods will have to be redeveloped to suit these scenarios. This can result in a tremendous waste of effort and cost. In this paper we describe an integrated generic architecture for reengineering legacy databases. The goal of this research is to formalize an integrated generic architecture that is applicable to different database reengineering scenarios and requirements. We examine the conceptual and technical requirement for enabling such an architecture. An overview of the database reengineering process, which serves as a guideline for practitioners and tool developers, is presented. The results of a preliminary feasibility study based on the results of an implementation of relational database reverse engineering tools within the content of the architecture is also provided.

[1]  Tok Wang Ling.  A Normal Form For Entity-Relationship Diagrams , 1985, ER.

[2]  Kathi Hogshead Davis,et al.  Converting A Relational Database Model into an Entity-Relationship Model , 1987, ER.

[3]  Jean-Luc Hainaut,et al.  Contribution to a theory of database reverse engineering , 1993, [1993] Proceedings Working Conference on Reverse Engineering.

[4]  L. Campbell.  Reverse Engineering Using Verbalization Techniques , 1995, Australasian Database Conference.

[5]  Jean-François Boulicaut,et al.  Towards the reverse engineering of renormalized relational databases , 1996, Proceedings of the Twelfth International Conference on Data Engineering.

[6]  James H. Cross,et al.  Reverse engineering and design recovery: a taxonomy , 1990, IEEE Software.

[7]  Ivar Jacobson,et al.  Re-engineering of Old Systems to an Object-Oriented Database , 1991, Conference on Object-Oriented Programming Systems, Languages, and Applications.

[8]  Peretz Shoval,et al.  Database Reverse Engineering: From the Relational to the Binary Relationship model , 1993, Data Knowl. Eng..

[9]  Manfred A. Jeusfeld,et al.  An Executable Meta Model for Re-Engineering of Database Schemas , 1994, Int. J. Cooperative Inf. Syst..

[10]  Kathryn A. Ingle,et al.  Reverse Engineering , 1996, Springer US.

[11]  William J. Premerlani,et al.  An approach for reverse engineering of relational databases , 1993, [1993] Proceedings Working Conference on Reverse Engineering.

[12]  Jean-Luc Hainaut,et al.  Transformation-based Database Reverse Engineering , 1993 .

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

[14]  Peter P. Chen.  The Entity-Relationship Model: Towards a unified view of Data , 1976 .

[15]  Peter P. Chen.  The entity-relationship model: toward a unified view of data , 1975, VLDB '75.

[16]  Kathi Hogshead Davis,et al.  August-II: a tool for step-by-step data model reverse engineering , 1995, Proceedings of 2nd Working Conference on Reverse Engineering.