Test input generation for database programs using relational constraints

Michaël Marcozzi, Wim Vanhoof, Jean-Luc Hainaut

Research output: Contribution in Book/Catalog/Report/Conference proceedingConference contribution

375 Downloads (Pure)


Databases are ubiquitous in software and testing of programs manipulating databases is thus essential to enhance the reliability of software. In this paper, we describe a clean and unified approach to automatically generate test inputs for such database programs. First, we propose a formal language, called ImperDB, to model database programs. ImperDB allows to model common program behaviors and data structures, as well as typical interaction scenarios between programs and databases. Secondly, we present a static analysis technique to generate test inputs for ImperDB programs, according to any chosen structural adequacy criterion. The technique considers an ImperDB program as a sequence of operations over a set of relational variables, modeling both the database original content and the program inputs. The problem of finding test inputs forcing the execution of a given path can then be transformed into the problem of solving constraints over the relational variables associated to the program. These constraints are expressed with the Alloy language and solved by the Alloy analyzer.
Original languageEnglish
Title of host publicationProceedings of the Fifth International Workshop on Testing Database Systems
Place of PublicationNew York, NY, USA
PublisherACM Press
Number of pages6
Publication statusPublished - 2012

Publication series

NameDBTest '12


Dive into the research topics of 'Test input generation for database programs using relational constraints'. Together they form a unique fingerprint.
  • ACM SIGMOD/PODS Conference

    Michaël Marcozzi (Contributor)

    20 May 201224 May 2012

    Activity: Participating in or organising an event typesParticipation in conference

Cite this