QAGen: Generating Query-Aware Test Databases
Summary: QAGen: a query-aware test DB generator that, given a query and constraints, yields databases that force specific results. Guarantees the test query yields prescribed outputs, allowing evaluation of memory management and cardinality estimation. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Carsten Binnig (ETH Zurich)
- 2. Donald Kossmann (ETH Zurich)
- 3. Eric Lo (ETH Zurich)
- 4. M. Tamer Özsu (University of Waterloo)
BibTeX Citation
@inproceedings{binnig_sigmod07,
title = {{QAGen: Generating Query-Aware Test Databases}},
author = {Binnig, Carsten and Kossmann, Donald and Lo, Eric and Özsu, M. Tamer},
series = {{SIGMOD} '07},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/1247480.1247520},
url = {https://dl.acm.org/doi/10.1145/1247480.1247520},
year = {2007}
}Incoming Citations (Sorted by Pagerank)
Showing 31 of 31 citing papers.
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 6 of 6 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 105 | Quickly Generating Billion-Record Synthetic Databases | 1994 | SIGMOD | 0.00033877899 |
| 129 | Optimization of Nested SQL Queries Revisited | 1987 | SIGMOD | 0.0003068101 |
| 392 | Massive Stochastic Testing of SQL | 1998 | VLDB | 0.00019342814 |
| 938 | Flexible Database Generators | 2005 | VLDB | 0.00013089351 |
| 1,578 | Simple and Realistic Data Generation | 2006 | VLDB | 0.00010309264 |
| 2,690 | Generating Thousand Benchmark Queries in Seconds | 2004 | VLDB | 8.2519326e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 3,903 | Keep It Simple: Testing Databases via Differential Query Plans | 2024 | SIGMOD |
| 2 | 5,169 | LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning | 2022 | SIGMOD |
| 3 | 2,369 | Data Generation using Declarative Constraints | 2011 | SIGMOD |
| 4 | 2,044 | Detecting Logic Bugs of Join Optimizations in DBMS | 2023 | SIGMOD |
| 5 | 2,690 | Generating Thousand Benchmark Queries in Seconds | 2004 | VLDB |
| 6 | 5,113 | Test Data for Relational Queries (Extended abstract) | 1986 | PODS |
| 7 | 10,702 | A Query-Aware Enormous Database Generator For System Performance Evaluation | 2025 | SIGMOD |
| 8 | 10,406 | Test Data Generation for Complex SQL Queries | 2026 | SIGMOD |
| 9 | 4,111 | A genetic approach for random testing of database systems | 2007 | VLDB |
| 10 | 2,069 | Generating Targeted Queries for Database Testing | 2008 | SIGMOD |