loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
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
Pedro Manuel Antunes Sousa, Instituto Superior Tecnico
Maria de Lurdes Pedro-de-Jesus, Instituto Superior Tecnico
Goncalo Pereira, Instituto Superior Tecnico
Fernando Brito e Abreu, Instituto Superior Tecnico
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
Usage of this product signifies your acceptance of the Terms of Use.