In this paper, we describe the SPAR Test Suite Generator (STSG), a new test-suite generator for SQL style database systems. This tool produced an entire test suite (data, queries, and ground-truth answers) as a unit and in response to a user's specification. Thus, database evaluators could use this tool to craft test suites for particular aspects of a specific database system. The inclusion of ground-truth answers in the produced test suite, furthermore, allowed this tool to support both benchmarking (at various scales) and correctness-checking in a repeatable way. Lastly, the test-suite generator of this document was extensively profiled and optimized, and was designed for test-time agility.
[1]
Robert K. Cunningham,et al.
Automated Assessment of Secure Search Systems
,
2015,
OPSR.
[2]
Surajit Chaudhuri,et al.
Flexible Database Generators
,
2005,
VLDB.
[3]
Nick Koudas,et al.
Generating targeted queries for database testing
,
2008,
SIGMOD Conference.
[4]
Donald R. Slutz,et al.
Massive Stochastic Testing of SQL
,
1998,
VLDB.
[5]
Sanjay Ghemawat,et al.
MapReduce: Simplified Data Processing on Large Clusters
,
2004,
OSDI.
[6]
Meikel Pöss,et al.
MUDD: a multi-dimensional data generator
,
2004,
WOSP '04.