DBScholar

Back to papers

Detecting Metadata-Related Logic Bugs in Database Systems via Raw Database Construction

Summary: Introduce Radar: construct a “raw” DB by stripping metadata while preserving data and compare query results between original and raw to expose metadata-related logic bugs from incorrect metadata-driven optimizations. Adds metadata-oriented testing to prioritize unseen metadata patterns; evaluated on five DBMSs, found 42 bugs (38 new, 16 fixed). (summarized by gpt-5-mini on Feb 09 2026)

Paper ID
ha5206bb960523a61
Venue
VLDB
Year
2024
Pagerank
6.2944842e-05
Overall Rank
5,054 | 66.03%
DOI
10.14778/3659437.3659445

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{song_vldb24,
        title = {{Detecting Metadata-Related Logic Bugs in Database Systems via Raw Database Construction}},
        author = {Song, Jiansen and Dou, Wensheng and Gao, Yu and Cui, Ziyu and Zheng, Yingying and Wang, Dong and Wang, Wei and Wei, Jun and Huang, Tao},
        journal = {PVLDB},
        series = {{VLDB} '24},
        volume = {17},
        number = {8},
        pages = {1884--1897},
        doi = {10.14778/3659437.3659445},
        url = {https://doi.org/10.14778/3659437.3659445},
        year = {2024}
}

Incoming Citations (Sorted by Pagerank)

Showing 10 of 10 citing papers.

Rank Citing Paper Year Venue Pagerank
9,403 Detecting Schema-Related Logic Bugs in Relational DBMSs via Equivalent Database Construction 2025 VLDB 5.1833519e-05
10,060 Simple Testing Can Expose Most Critical Transaction Bugs: Understanding and Detecting Write-Specific Serializability Violations in Database Systems 2025 VLDB 5.0875952e-05
10,415 Automated Discovery of Test Oracles for Database Management Systems Using LLMs 2026 SIGMOD 4.9793485e-05
10,432 DBugScribe: Automatic Database Bug Reproduction from Community Reports 2026 SIGMOD 4.9793485e-05
10,536 Testing Graph Databases with Synthesized Queries 2026 SIGMOD 4.9793485e-05
10,559 Detecting Logic Bugs in DBMSs via Equivalent Data Construction 2026 SIGMOD 4.9793485e-05
10,664 One DBMS, Two Modes, and a Bunch of Bugs: Catching Logic Bugs in Distributed DBMSs via Differential Testing 2026 SIGMOD 4.9793485e-05
10,782 Testing Graph Databases via Transformations Between Fixed-Length and Variable-Length Queries 2026 VLDB 4.9793485e-05
10,832 ReSequel: Robust LLM-assisted Query Rewriting and Optimization using Templatization and Sampling 2026 VLDB 4.9793485e-05
10,872 Detecting Data-Type-Related Logic Bugs in Relational DBMSs via Compatible Database Construction 2026 VLDB 4.9793485e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 13 of 13 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
106 Quickly Generating Billion-Record Synthetic Databases 1994 SIGMOD 0.00033526937
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
955 Flexible Database Generators 2005 VLDB 0.00012866364
1,102 Elle: Inferring Isolation Anomalies from Experimental Observations 2021 VLDB 0.00012004972
1,602 Simple and Realistic Data Generation 2006 VLDB 0.00010101626
1,832 APOLLO: Automatic Detection and Diagnosis of Performance Regressions in Database Systems 2020 VLDB 9.5430971e-05
1,928 Detecting Logic Bugs of Join Optimizations in DBMS 2023 SIGMOD 9.3567082e-05
3,447 Complete Yet Practical Search for Minimal Query Reformulations Under Constraints 2014 SIGMOD 7.2941472e-05
3,651 Keep It Simple: Testing Databases via Differential Query Plans 2024 SIGMOD 7.1327136e-05
4,250 Exploiting Constraint-Like Data Characterizations in Query Optimization 2001 SIGMOD 6.7027541e-05
5,486 Analysis of Recovery in a Database System Using a Write-Ahead Log Protocol 1992 SIGMOD 6.1097144e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 9,218 EPSC: Testing Database Management Systems via Equivalent Prepared Statement Construction 2026 SIGMOD
2 10,664 One DBMS, Two Modes, and a Bunch of Bugs: Catching Logic Bugs in Distributed DBMSs via Differential Testing 2026 SIGMOD
3 10,536 Testing Graph Databases with Synthesized Queries 2026 SIGMOD
4 1,928 Detecting Logic Bugs of Join Optimizations in DBMS 2023 SIGMOD
5 7,919 Semantic Conformance Testing of Relational DBMS 2025 VLDB
6 10,872 Detecting Data-Type-Related Logic Bugs in Relational DBMSs via Compatible Database Construction 2026 VLDB
7 6,100 Constant Optimization Driven Database System Testing 2025 SIGMOD
8 8,615 A Demonstration of DLBD: Database Logic Bug Detection System 2023 VLDB
9 10,559 Detecting Logic Bugs in DBMSs via Equivalent Data Construction 2026 SIGMOD
10 9,403 Detecting Schema-Related Logic Bugs in Relational DBMSs via Equivalent Database Construction 2025 VLDB