Please use this identifier to cite or link to this item:
Title: Recovery of functional dependencies from data-intensive business programs
Authors: Tan, Hee Beng Kuan 
Ling, Tok Wang 
Issue Date: 1997
Citation: Tan, Hee Beng Kuan,Ling, Tok Wang (1997). Recovery of functional dependencies from data-intensive business programs. Proceedings of the Hawaii International Conference on System Sciences 5 : 81-88. ScholarBank@NUS Repository.
Abstract: 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.
Source Title: Proceedings of the Hawaii International Conference on System Sciences
ISBN: 0818677430
ISSN: 10603425
DOI: 10.1109/HICSS.1997.663162
Appears in Collections:Staff Publications

Show full item record
Files in This Item:
There are no files associated with this item.

Page view(s)

checked on Oct 6, 2022

Google ScholarTM



Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.