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.2056825e-05
Overall Rank
9,218 | 38.03%
DOI
10.1145/3802053
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.00037720227
185
CockroachDB: The Resilient Geo-Distributed SQL Database
2020
SIGMOD
0.00026072278
234
TiDB: A Raft-based HTAP Database
2020
VLDB
0.00023765806
383
Massive Stochastic Testing of SQL
1998
VLDB
0.00019484034
747
QAGen: Generating Query-Aware Test Databases
2007
SIGMOD
0.00014283935
896
Froid: Optimization of Imperative Programs in a Relational Database
2018
VLDB
0.00013209291
1,928
Detecting Logic Bugs of Join Optimizations in DBMS
2023
SIGMOD
9.3567082e-05
3,396
Variance Aware Optimization of Parameterized Queries
2010
SIGMOD
7.3418098e-05
3,651
Keep It Simple: Testing Databases via Differential Query Plans
2024
SIGMOD
7.1327136e-05
4,758
SQLite: Past, Present, and Future
2022
VLDB
6.4318211e-05
5,039
Leveraging Query Logs and Machine Learning for Parametric Query Optimization
2022
VLDB
6.3023214e-05
5,078
Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees
2017
SIGMOD
6.2857912e-05
6,100
Constant Optimization Driven Database System Testing
2025
SIGMOD
5.8868734e-05
7,304
Dynamic Plan Generation for Parameterized Queries
2009
SIGMOD
5.5593451e-05
Semantically Similar Papers
#
Overall Rank
Paper
Year
Venue
1
9,219
Finding Missed Optimizations in DBMSs through Unbalanced Short-Circuit Query Construction
2026
SIGMOD
2
8,615
A Demonstration of DLBD: Database Logic Bug Detection System
2023
VLDB
3
10,432
DBugScribe: Automatic Database Bug Reproduction from Community Reports
2026
SIGMOD
4
10,664
One DBMS, Two Modes, and a Bunch of Bugs: Catching Logic Bugs in Distributed DBMSs via Differential Testing
2026
SIGMOD
5
10,872
Detecting Data-Type-Related Logic Bugs in Relational DBMSs via Compatible Database Construction
2026
VLDB
6
5,054
Detecting Metadata-Related Logic Bugs in Database Systems via Raw Database Construction
2024
VLDB
7
1,928
Detecting Logic Bugs of Join Optimizations in DBMS
2023
SIGMOD
8
6,100
Constant Optimization Driven Database System Testing
2025
SIGMOD
9
9,403
Detecting Schema-Related Logic Bugs in Relational DBMSs via Equivalent Database Construction
2025
VLDB
10
10,559
Detecting Logic Bugs in DBMSs via Equivalent Data Construction
2026
SIGMOD