Identifying Data Inconsistencies Using After-State Database Testing (ASDT) Framework

Database applications retrieve data from database, process the data and then store them for future processing. If the data from database is incorrect or inconsistent with the application's business rules, the output of the application will be misleading. When such data is retrieved by the appli...

Full description

Saved in:
Bibliographic Details
Main Authors: Setiadi, Robert, Man Fai Lau
Format: Conference Proceeding
Language:English
Subjects:
black-box approach
data consistency
database testing
Engines
Remuneration
Software
Testing
Unified modeling language
Online Access:Request full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:Database applications retrieve data from database, process the data and then store them for future processing. If the data from database is incorrect or inconsistent with the application's business rules, the output of the application will be misleading. When such data is retrieved by the application for further processing, it may lead to incorrect results even though the program is correct. In this paper, we investigate methods in revealing inconsistent data stored in a database. We propose a framework to test the consistency of data with respect to the system specifications and design choices of the database applications. It is a black-box testing approach focusing on finding data inconsistency in database state after the execution of applications. We also build a prototype to demonstrate that our method is capable of handling different types of system rules, regardless of how they are implemented in the system.
ISSN:1550-6002
2332-662X
DOI:10.1109/QSIC.2014.39