Testing Relational Database Using SQLLint

Database systems are an important element of any web based systems. As such, it is very important to test database systems adequately because if any defects go undetected in the design and/or implementation of database systems, it may jeopardize dependability of web based systems. Web-based systems are examples of systems that heavily relay on databases, they are expected to be highly available and reliable. From time to time, database may require changing. As such, any application that is relying on the database needs to be considered for the changes before any changes that can be made to databases. Examples of changes include semantics of the database query language. In this paper, we discuss an approach for generating test cases for queries whose meaning may have been altered by changes in query semantics.