arrow
返回

Checking enforcement of integrity constraints in database applications based on code patterns

delete2011-12-01
delete13
PRE
AI
张
张宏玉 (Hongyu Zhang) *
H
Hee Beng Kuan Tan
L
Lu Zhang
X
Xi Lin
X
Xiaoyin Wang
张纯 封面图
张纯 (Chun Zhang)
洪梅 封面图
洪梅 (Mei Hong)
DOI:10.1016/j.jss.2011.06.044delete
delete原文链接
delete原文求助
delete分享
delete收藏
摘要

摘要

En 中文
Integrity constraints (including key, referential and domain constraints) are unique features of database applications. Integrity constraints are crucial for ensuring accuracy and consistency of data in a database. It is important to perform integrity constraint enforcement (ICE) at the application level to reduce the risk of database corruption. We have conducted an empirical analysis of open-source PHP database applications and found that ICE does not receive enough attention in real-world programming practice. We propose an approach for automatic detection of ICE violations at the application level based on identification of code patterns. We define four patterns that characterize the structures of code implementing integrity constraint enforcement. Violations of these patterns indicate the missing of integrity constraint enforcement. Our work contributes to quality improvement of database applications. Our work also demonstrates that it is feasible to effectively identify bugs or problematic code by mining code patterns in a specific domain/application area. (C) 2011 Elsevier Inc. All rights reserved.
Keyword:
Integrity constraint enforcement
Code patterns
PHP
Static analysis
Code quality
AI总结

AI总结

对已上传原文的论文进行重点信息的提取,主要内容包括:简要概述、研究摘要、背景介绍、关键亮点、图文解析、展望与总结。

期刊

Journal of Systems and Software 封面图
Journal of Systems and Software
IF:
4.1
论文数:
5.5K
被引数:
8.4K

机构

T
tsinghua university
学者数:
11.9W
论文数: 10.0W
被引数: 137
N
Nanyang Technological University
学者数:
4.9W
论文数: 4.8W
被引数: 8.1W
P
peking university
学者数:
11.9W
论文数: 8.7W
被引数: 146
学者 查看更多机构
引用论文

引用论文

Wrapper-based evolution of legacy information systems
err2006-10-01
err28
errOAAI
errThiran, Philippe; Hainaut, Jean-Luc; Houben, Geert-Jan; Benslimane, Djamal
err分享
err收藏
没有更多内容