Please use this identifier to cite or link to this item: https://doi.org/10.1109/TKDE.2002.1019216
Title: Exploring into programs for the recovery of data dependencies designed
Authors: Tan, H.B.K.
Ling, T.W. 
Goh, C.H.
Keywords: Database reverse engineering
Design of data dependencies
Design recovery
Legacy database
Program analysis
Issue Date: 2002
Source: Tan, H.B.K.,Ling, T.W.,Goh, C.H. (2002). Exploring into programs for the recovery of data dependencies designed. IEEE Transactions on Knowledge and Data Engineering 14 (4) : 825-835. ScholarBank@NUS Repository. https://doi.org/10.1109/TKDE.2002.1019216
Abstract: Data dependencies play an important role in the design of a database. Many legacy database applications have been developed on old generation database management systems and conventional file systems. As a result, most of the data dependencies in legacy databases are not enforced in the database management systems. As such, they are not explicitly defined in database schema and are enforced in the transactions, which update the databases. It is very difficult and time consuming to find out the designed data dependencies manually during the maintenance and reengineering of database applications. In software engineering, program analysis has long been developed and proven as a useful aid in many areas. With the use of program analysis, this paper proposes a novel approach for the recovery of common data dependencies, i.e., functional dependencies, key constraints, inclusion dependencies, referential constraints, and sum dependencies, designed in a database from the behavior of transactions, which update the database. The approach is based on detecting program path patterns for implementing most commonly used methods to enforce these data dependencies.
Source Title: IEEE Transactions on Knowledge and Data Engineering
URI: http://scholarbank.nus.edu.sg/handle/10635/38966
ISSN: 10414347
DOI: 10.1109/TKDE.2002.1019216
Appears in Collections:Staff Publications

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

SCOPUSTM   
Citations

10
checked on Dec 4, 2017

Page view(s)

42
checked on Dec 8, 2017

Google ScholarTM

Check

Altmetric


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