DocumentCode :
3373016
Title :
Towards the reverse engineering of renormalized relational databases
Author :
Petit, J.-M. ; Toumani, F. ; Boulicaut, J.-F. ; Kouloumdjian, J.
Author_Institution :
Lab. d´´Ingenierie des Syst. d´´Inf., Inst. Nat. des Sci. Appliquees, Villeurbanne, France
fYear :
1996
fDate :
26 Feb-1 Mar 1996
Firstpage :
218
Lastpage :
227
Abstract :
The paper describes a method to cope with denormalized relational schemas in a database reverse engineering process. We propose two main steps to improve the understanding of data semantics. Firstly we extract inclusion dependencies by analyzing the equi join queries embedded in application programs and by querying the database extension. Secondly we show how to discover only functional dependencies which influence the way attributes should be restructured. The method is interactive since an expert user has to validate the presumptions on the elicited dependencies. Moreover, a restructuring phase leads to a relational schema in third normal form provided with key constraints and referential integrity constraints. Finally, we sketch how an entity relationship schema can be derived from such information
Keywords :
entity-relationship modelling; query processing; relational databases; reverse engineering; data semantics; database extension queries; database reverse engineering process; denormalized relational schemas; elicited dependencies; entity relationship schema; equi join queries; expert user; functional dependencies; inclusion dependencies; referential integrity constraints; relational schema; renormalized relational databases; restructuring phase; reverse engineering; third normal form; Data mining; Data models; Erbium; Information resources; Process design; Relational databases; Reverse engineering;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Data Engineering, 1996. Proceedings of the Twelfth International Conference on
Conference_Location :
New Orleans, LA
ISSN :
1063-6382
Print_ISBN :
0-8186-7240-4
Type :
conf
DOI :
10.1109/ICDE.1996.492110
Filename :
492110
Link To Document :
بازگشت