DocumentCode :
2695684
Title :
Clustering relations into abstract ER schemas for database reverse engineering
Author :
Sousa, Pedro ; Pedro-de-Jesus, Lurdes ; Pereira, Gonçalo ; Abreu, Fernando Brito e
Author_Institution :
IST, INESC, Lisbon, Portugal
fYear :
1999
fDate :
1999
Firstpage :
169
Lastpage :
176
Abstract :
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. We present 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
Keywords :
data models; divide and conquer methods; entity-relationship modelling; relational databases; reverse engineering; very large databases; ER modeling; abstract ER schemas; bottom-up nature; conceptual data models; database reverse engineering; divide-and-conquer approach; entity relationship modeling; high level abstract schema; large database systems; relational schema; Data engineering; Electrical capacitance tomography; Erbium; Hip; Proposals; Read only memory; Relational databases; Reverse engineering;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Software Maintenance and Reengineering, 1999. Proceedings of the Third European Conference on
Conference_Location :
Amsterdam
Print_ISBN :
0-7695-0090-0
Type :
conf
DOI :
10.1109/CSMR.1999.756694
Filename :
756694
Link To Document :
بازگشت