Early detection of faults related to database schematic changes

Modern software applications consisting of a multi-tiered application structure have often a database as an essential tier. The correct functioning of a multi-tiered application is dependent on its correct database connectivity. The modifications in the schema of the database may result in faults and may end up in the non-functionality of a software application. To test for the modifications in the database schema, testers normally execute all the test cases for the application. In this paper, we primarily focus on the database schematic changes of a multi-tiered software application and suggest a new technique to detect the faults early that are related to database schematic changes. Our approach is based on an improved technique for the selection and prioritization of the test cases. Our new approach results in the early detection of faults related to database schematic changes and reduction of test suite execution time.