Welcome to the InfoSci Platform
Automated Insertion of Exception Handling for Key and Referential Constraints

Automated Insertion of Exception Handling for Key and Referential Constraints

Kaiping Liu, Hee Beng Kuan Tan, Xu Chen
Copyright: © 2013 |Volume: 24 |Issue: 1 |Pages: 19
ISSN: 1063-8016|EISSN: 1533-8010|EISBN13: 9781466630437|DOI: 10.4018/jdm.2013010101
Cite Article Cite Article

MLA

Liu, Kaiping, et al. "Automated Insertion of Exception Handling for Key and Referential Constraints." JDM vol.24, no.1 2013: pp.1-19. http://doi.org/10.4018/jdm.2013010101

APA

Liu, K., Tan, H. B., & Chen, X. (2013). Automated Insertion of Exception Handling for Key and Referential Constraints. Journal of Database Management (JDM), 24(1), 1-19. http://doi.org/10.4018/jdm.2013010101

Chicago

Liu, Kaiping, Hee Beng Kuan Tan, and Xu Chen. "Automated Insertion of Exception Handling for Key and Referential Constraints," Journal of Database Management (JDM) 24, no.1: 1-19. http://doi.org/10.4018/jdm.2013010101

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

Key and referential constraints are two main integrity constraints in database applications. These constraints can be automatically enforced by the Database Management System with their exception—violation from these constraints—handled by programmers. This paper proposes an approach to relieve the burden of programmers from mechanical coding for handling exceptions of these constraints violation by using program transformation. We first propose an extended abstract syntax tree to include SQL query semantics. Based on it, each code pattern that requires exception handling together with the exception handling code to be inserted is represented as a transformation rule. We provide two alternatives to handle the exceptions: one is to handle the exceptions in conjunction with the built-in enforcement feature in Database Management System; the other is handling them without using the feature provided in Database Management System. Hence, two types of transformation rules are provided accordingly. A tool GEHPHP (Generation of Exception Handling for PHP Systems) has been developed to implement the proposed approach. Experiments have also been conducted to evaluate the applicable of the approach.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.