Regression Test Selection for Database Applications

Regression Test Selection for Database Applications

Ramzi A. Haraty (Lebanese American University, Lebanon), Nashat Mansour (Lebanese American University, Lebanon) and Bassel A. Daou (University of Ottawa, Canada)
Copyright: © 2004 |Pages: 25
DOI: 10.4018/978-1-59140-255-8.ch008
OnDemand PDF Download:


Database applications features such as Structured Query Language programming, exception handling, integrity constraints, and table triggers pose difficulties for maintenance activities, especially for regression testing that follows modifying database applications. In this chapter, we address these difficulties and propose a two-phase regression testing methodology. In phase 1, we explore control flow and data flow analysis issues of database applications. Then, we propose an impact analysis technique that is based on dependencies that exist among the components of database applications. This analysis leads to selecting test cases from the initial test suite for regression testing the modified application. In phase 2, we propose two algorithms for reducing the number of regression test cases. The Graph Walk algorithm walks through the control flow graph of database modules and selects a safe set of test cases to retest. The Call Graph Firewall algorithm uses a firewall for the inter-procedural level. Our experience with this regression testing methodology shows that the impact analysis technique is adequate for selecting regression tests and that phase 2 techniques can be used for further reduction in the number of these tests.

Complete Chapter List

Search this Book:
Table of Contents
Keng Siau
Chapter 1
Zoran Stojanovic, Ajantha Dahanayake, Henk Sol
Agile software development methods have been proposed as the way to address the problem of delivering high-quality software on time under constantly... Sample PDF
Agile Development Methods and Component-Orientation: A Review and Analysis
Chapter 2
Terry Halpin
This chapter provides metamodels for some of the main database modeling notations used in industry. Two Entity Relationship (ER) notations... Sample PDF
Comparing Metamodels for ER, ORM and UML Data Models
Chapter 3
Zoran Stojanovic, Ajantha Dahanayake, Henk Sol
Components-Based Development (CBD) and Web Services (WS) nowadays are prominent paradigms for implementing and deploying advanced distributed... Sample PDF
An Evaluation Framework for Component-Based and Service-Oriented System Development Methodologies
Chapter 4
Eladio Dominguez, Angel L. Rubio, María A. Zapata
A clear understanding of the dynamic semantics of languages involved in the representation of behavior is essential for a large and varied audience... Sample PDF
Improving the Understandability of Dynamic Semantics: An Enhanced Metamodel for UML State Machines
Chapter 5
Hajo A. Reijers
On the way to process automation, an important issue is the definition of the various activities or work tasks within the respective business... Sample PDF
Metrics for Workflow Design: How an Information Processing View on Business Processes Helps to Make Good Designs
Chapter 6
Jóse Galindo, Angélica Urrutia, Mario Piattini
Some approaches about fuzzy ER/EER model have been published recently. Few of these works study how to relax constraints and other aspects expressed... Sample PDF
Fuzzy Aggregations and Fuzzy Specializations in Eindhoven Fuzzy EER Model
Chapter 7
George C. Philip
This chapter discusses normalization of relations when the candidate keys of a relation have missing information represented by nulls. The chapter... Sample PDF
Normalization of Relations with Nulls in Candidate Keys: Traditional and Domain Key Normal Forms
Chapter 8
Ramzi A. Haraty, Nashat Mansour, Bassel A. Daou
Database applications features such as Structured Query Language programming, exception handling, integrity constraints, and table triggers pose... Sample PDF
Regression Test Selection for Database Applications
Chapter 9
Oscar Dieste, Marcela Genero, Natalia Juristo, Ana M. Moreno
Most development methods need to be adapted before they can be used in a specific development project. This is because each method can be applied to... Sample PDF
An Attempt to Establish a Correspondence between Development Methods and Problem Domains
Chapter 10
Heikki Topi, V. Ramesh
This study reviews and synthesizes over 15 years of research on human factors issues in conceptual data modeling. In addition to analyzing the... Sample PDF
Toward an Extended Framework for Human Factors Research on Data Modeling
Chapter 11
Jan L.G. Dietz, Terry Halpin
The Demo Engineering Methodology for Organizations (DEMO) enables business processes of organizations to be modeled at a conceptual level... Sample PDF
Using DEMO and ORM in Concert: A Case Study
Chapter 12
Wai Y. Mok, David Paper
In this chapter, we model business workflows using Harel’s statecharts. We demonstrate that mapping to statecharts allows one to systematically... Sample PDF
Revisiting Workflow Modeling with Statecharts
Chapter 13
Akos Ledeczi, Miklos Matoti, Peter Volgyesi
This chapter introduces the concepts and techniques required for developing graphical, domain-specific modeling and program synthesis environments.... Sample PDF
Framework for the Rapid Development of Modeling Environments
Chapter 14
Kyoung-Il Bae, Soon-Young Huh
Process information sharing is a beneficial tool through which a company can monitor and control its outsourced business process transparently, as... Sample PDF
Federated Process Framework for Transparent Process Monitoring in Business Process Outsourcing
Chapter 15
Joseph Fong, Hing K. Wong, Anthony Fong
The WWW and its associated distributed information services provide rich world-wide online information services, where objects are linked together... Sample PDF
Online Analytical Mining for Web Access Patterns
Chapter 16
Roy Gelbard, Israel Spiegler
The research proposes a model for the representation and storage of motion data that enables the communication, storage, and analysis of patterns of... Sample PDF
Modeling Motion: Building Blocks of a Motion Database
About the Editor
About the Authors