Title
Supporting the adaptation of open-source database applications through extracting data lifecycles.
Abstract
The adaptation of open-source database applications is common in the industry. Most open-source database applications are incomplete. During adaptation, users usually have to implement additional data maintenance. Hence, the completeness of an application is an important concern for the adaptation as a key factor to indicate how much additional effort is required before using a system. From our study of database applications with complete functionalities, we observe that data in a database has common patterns of lifecycles. Anomaly in data lifecycles provides a good indicator on the completeness of database applications. In this paper, we propose a novel approach to automatically extract the data lifecycles out of the source code of database applications through inter-procedural static program analysis. This representative information can benefit the adaptation of database applications specifically for selection, maintenance and extension. We have developed a tool to implement the proposed approach for PHP (Hypertext Preprocessor)-based database applications. Case studies have shown that the proposed approach is useful in assisting adaptation and detecting faults of open-source database applications. © The Institution of Engineering and Technology 2013.
Year
DOI
Venue
2013
10.1049/iet-sen.2012.0105
Software, IET
Field
DocType
Volume
Database tuning,Database model,Computer science,View,Database testing,Database design,Database schema,Database theory,Database,Surrogate key
Journal
7
Issue
ISSN
Citations 
4
1751-8806
0
PageRank 
References 
Authors
0.34
16
3
Name
Order
Citations
PageRank
Kaiping Liu1135.33
Hee Beng Kuan Tan248945.05
Xi Chen333370.76