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. https://doi.org/10.1109/HICSS.1997.663162||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||URI:||http://scholarbank.nus.edu.sg/handle/10635/99586||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.
checked on Mar 28, 2020
Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.