HKUST Library Institutional Repository Banner

HKUST Institutional Repository >
Computer Science and Engineering >
CSE Master Theses  >

Please use this identifier to cite or link to this item:
Title: Extending white box testing to database applications
Authors: Chan, Man Yee
Issue Date: 1999
Abstract: Faults are intolerable in database applications since these could result in unrecoverable data corruption. Database applications should be thoroughly tested before they are released to production. In this thesis, we study the utilization of white box testing techniques on database applications. We have found that conventional white box techniques have not explicitly considered input database instances in test cases generation. As such, faults that occur in some, but not all, database instances for the same test outcomes may not be detected. To address this, we propose a technique that transforms embedded SQL statements into query trees and examines input relations and relational algebraic operations in these query trees in the generation of test cases, which cover certain classes of input database instances and user inputs. In addition, we have found no previous work on the problem of test data preparation for database applications. Consequently, we introduce a framework for the generation of database instances and user inputs for testing database applications by reducing the problem of test data preparation to the problem of constraint satisfaction. The framework also allows utilization of domain knowledge for detecting faults common in the application domain.
Description: Thesis (M.Phil.)--Hong Kong University of Science and Technology, 1999
xv, 172 leaves : ill. ; 30 cm
HKUST Call Number: Thesis COMP 1999 ChanMY
Appears in Collections:CSE Master Theses

Files in This Item:

File Description SizeFormat

All items in this Repository are protected by copyright, with all rights reserved.