Skip to main content
Article
A Unit Test Approach for Database Schema Evolution
Information and Software Technology
  • Katarina Grolinger, Western University
  • Miriam A M Capretz, Western University
Document Type
Article
Publication Date
1-1-2011
URL with Digital Object Identifier
http://dx.doi.org/10.1016/j.infsof.2010.10.002
Abstract

Context: The constant changes in today’s business requirements demand continuous database revisions. Hence, database structures, not unlike software applications, deteriorate during their lifespan and thus require refactoring in order to achieve a longer life span. Although unit tests support changes to application programs and refactoring, there is currently a lack of testing strategies for database schema evolution.

Objective: This work examines the challenges for database schema evolution and explores the possibility of using various testing strategies to assist with schema evolution. Specifically, the work proposes a novel unit test approach for the application code that accesses databases with the objective of proactively evaluating the code against the altered database.

Method: The approach was validated through the implementation of a testing framework in conjunction with a sample application and a relatively simple database schema. Although the database schema in this study was simple, it was nevertheless able to demonstrate the advantages of the proposed approach.

Results: After changes in the database schema, the proposed approach found all SELECT statements as well as the majority of other statements requiring modifications in the application code. Due to its efficiency with SELECT statements, the proposed approach is expected to be more successful with database warehouse applications where SELECT statements are dominant.

Conclusion: The unit test approach that accesses databases has proven to be successful in evaluating the application code against the evolved database. In particular, the approach is simple and straightforward to implement, which makes it easily adoptable in practice.

Notes

NOTICE: this is the author‟s version of a work that was accepted for publication in Information and Software Technology. Changes resulting from the publishing process, such as peer review, editing, corrections, structural formatting, and other quality control mechanisms may not be reflected in this document. Changes may have been made to this work since it was submitted for publication. A definitive version was subsequently published in Information and Software Technology, [VOL 53, ISSUE 2, February 2011] DOI http://dx.doi.org/10.1016/j.infsof.2010.10.002

Citation Information
Katarina Grolinger and Miriam A M Capretz. "A Unit Test Approach for Database Schema Evolution" Information and Software Technology Vol. 53 Iss. 2 (2011) p. 159 - 170
Available at: http://works.bepress.com/miriam_capretz/15/