By Topic

Recovery of functional dependencies from data-intensive business programs

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$31 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

2 Author(s)
Hee Beng Kuan Tan ; Dept. of Inf. Syst. & Comput. Sci., Nat. Univ. of Singapore, Singapore ; Tok Wang Ling

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

Published in:

System Sciences, 1997, Proceedings of the Thirtieth Hawaii International Conference on  (Volume:5 )

Date of Conference:

7-10 Jan 1997