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 | Citation: | 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.
Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.