loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
30th Hawaii International Conference on System Sciences (HICSS) Volume 5: Advanced Technology Track
Maui, Hawaii
January 03-January 06
ISBN: 0-8186-7743-0
Hee Beng Kuan Tan, National University of Singapore
Tok Wang Ling, National University of Singapore
Data integrity constraints usually form a major component in a data-intensive business system. To successfully reengineer a data-intensive business system, its data integrity constraints must be understood. Functional dependencies constitute an important type of data integrity constraints. Due to the nature of system development, a significant amount of functional dependencies is usually omitted during the initial system development stage and only discovered during the system maintenance stage. Usually, these dependencies are enforced in the programs which update the databases, and are not shown elsewhere including the databases. Existing approaches for the discovery of functional dependencies from databases cannot find such functional dependencies. We develop a theory for inferring functional dependencies in a database from the programs which update the database. With the use of the theory, a comprehensive approach for the recovery of functional dependencies from both database schemas and programs is consequently proposed. The proposed approach can recover those functional dependencies which cannot be found by the existing approaches. The functional dependencies recovered from the proposed approach are proven.
Citation:
Hee Beng Kuan Tan, Tok Wang Ling, "Recovery of Functional Dependencies from Data-Intensive Business Programs," hicss, vol. 5, pp.81, 30th Hawaii International Conference on System Sciences (HICSS) Volume 5: Advanced Technology Track, 1997
Usage of this product signifies your acceptance of the Terms of Use.