Third European Conference on Software Maintenance and Reengineering
Clustering Relations into Abstract ER Schemas for Database Reverse Engineering
Amsterdam, Netherlands
March 03-March 05
ISBN: 0-7695-0090-0
Database Reverse Engineering (DBRE) methods recover conceptual data models from physical databases. The bottom-up nature of these methods imposes two major limitations. First, they do not provide an initial high level abstract schema suitable for use as a basis for reasoning about the application domain: a single detailed schema is only produced at the very end of the project. Second, they provide no support for a divide-and-conquer approach: the entire database schema must be analysed and processed as a unit, and cannot be divided into smaller database schemas. This paper presents a simple solution to overcome both limitations. In our proposal, relations are grouped based on their primary keys. Each group can be perceived in two ways: as a relational schema that can be reversed engineered as a standalone DBRE project; and as an element, either an entity or a relationship, of a high-level abstract schema that provides initial insight about the application domain. We also present examples from actual large database systems.
Index Terms:
Database Reverse Engineering, Relational model, Clustering
Citation:
Pedro Manuel Antunes Sousa, Maria de Lurdes Pedro-de-Jesus, Goncalo Pereira, Fernando Brito e Abreu, "Clustering Relations into Abstract ER Schemas for Database Reverse Engineering," csmr, pp.169, Third European Conference on Software Maintenance and Reengineering, 1999