Back to papers
EPSC: Testing Database Management Systems via Equivalent Prepared Statement Construction
Summary: EPSC differentially tests DBMSs by comparing equivalent ordinary and prepared SQL, exposing logic bugs via result inconsistencies. Evaluation across seven mature systems found 52 unique bugs, including cases missed by prior techniques.
(summarized by gpt-5.6-luna on Jul 26 2026)
Paper ID
h8412d6233d9423a5
Venue
SIGMOD
Year
2026
Pagerank
5.2032182e-05
Overall Rank
9,228 | 37.98%
DOI
10.1145/3802053
PDF
Download
(CC BY 4.0)
Incoming Non-self Citations Over Time
BibTeX Citation
Copy BibTeX
@inproceedings{zhang_sigmod26,
title = {{EPSC: Testing Database Management Systems via Equivalent Prepared Statement Construction}},
author = {Zhang, Chi and Liang, Jie and Wu, Zhiyong and Shi, Dalong and Wang, Linzhang and Jiang, Yu},
series = {{SIGMOD} '26},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/3802053},
url = {https://dl.acm.org/doi/10.1145/3802053},
year = {2026}
}
Incoming Citations (Sorted by Pagerank)
Showing 1 of 1 citing papers.
Outgoing Citations (Sorted by Pagerank)
Showing 14 of 14 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
Rank
Cited Paper
Year
Venue
Pagerank
71
DuckDB: an Embeddable Analytical Database
2019
SIGMOD
0.00037724477
185
CockroachDB: The Resilient Geo-Distributed SQL Database
2020
SIGMOD
0.00026060465
234
TiDB: A Raft-based HTAP Database
2020
VLDB
0.00023756332
383
Massive Stochastic Testing of SQL
1998
VLDB
0.00019474868
748
QAGen: Generating Query-Aware Test Databases
2007
SIGMOD
0.00014277246
896
Froid: Optimization of Imperative Programs in a Relational Database
2018
VLDB
0.00013203085
1,930
Detecting Logic Bugs of Join Optimizations in DBMS
2023
SIGMOD
9.3522789e-05
3,396
Variance Aware Optimization of Parameterized Queries
2010
SIGMOD
7.3386533e-05
3,652
Keep It Simple: Testing Databases via Differential Query Plans
2024
SIGMOD
7.1293371e-05
4,760
SQLite: Past, Present, and Future
2022
VLDB
6.4288554e-05
5,042
Leveraging Query Logs and Machine Learning for Parametric Query Optimization
2022
VLDB
6.2995365e-05
5,081
Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees
2017
SIGMOD
6.2830143e-05
6,102
Constant Optimization Driven Database System Testing
2025
SIGMOD
5.8840867e-05
7,307
Dynamic Plan Generation for Parameterized Queries
2009
SIGMOD
5.5567262e-05
Semantically Similar Papers
#
Overall Rank
Paper
Year
Venue
1
9,229
Finding Missed Optimizations in DBMSs through Unbalanced Short-Circuit Query Construction
2026
SIGMOD
2
8,624
A Demonstration of DLBD: Database Logic Bug Detection System
2023
VLDB
3
10,444
DBugScribe: Automatic Database Bug Reproduction from Community Reports
2026
SIGMOD
4
10,675
One DBMS, Two Modes, and a Bunch of Bugs: Catching Logic Bugs in Distributed DBMSs via Differential Testing
2026
SIGMOD
5
10,881
Detecting Data-Type-Related Logic Bugs in Relational DBMSs via Compatible Database Construction
2026
VLDB
6
5,058
Detecting Metadata-Related Logic Bugs in Database Systems via Raw Database Construction
2024
VLDB
7
1,930
Detecting Logic Bugs of Join Optimizations in DBMS
2023
SIGMOD
8
6,102
Constant Optimization Driven Database System Testing
2025
SIGMOD
9
9,412
Detecting Schema-Related Logic Bugs in Relational DBMSs via Equivalent Database Construction
2025
VLDB
10
10,570
Detecting Logic Bugs in DBMSs via Equivalent Data Construction
2026
SIGMOD