A SQL Debugger Built from Spare Parts: Turning a SQL:1999 Database System into Its Own Debugger
Summary: Habitat turns any SQL:1999 RDBMS into its own debugger by instrumenting queries with SQL facilities alone. It supports recursive SQL and pre/post-aggregation row-group observations, produced inside the host DB without exposing engine internals, enabling orthogonal in-database debugging. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Benjamin Dietrich (University of Tübingen)
- 2. Torsten Grust (University of Tübingen)
BibTeX Citation
@inproceedings{dietrich_sigmod15,
title = {{A SQL Debugger Built from Spare Parts: Turning a SQL:1999 Database System into Its Own Debugger}},
author = {Dietrich, Benjamin and Grust, Torsten},
series = {{SIGMOD} '15},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/2732372.2735358},
url = {https://dl.acm.org/doi/10.1145/2732372.2735358},
year = {2015}
}Incoming Citations (Sorted by Pagerank)
Showing 4 of 4 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 7,614 | I-Rex: An Interactive Relational Query Explainer for SQL | 2020 | VLDB | 5.5815004e-05 |
| 8,834 | Qr-Hint: Actionable Hints Towards Correcting Wrong SQL Queries | 2024 | SIGMOD | 5.3599176e-05 |
| 9,305 | The Power of Constraints in Natural Language to SQL Translation | 2025 | VLDB | 5.289545e-05 |
| 9,846 | QO-Insight: Inspecting Steered Query Optimizers | 2023 | VLDB | 5.2094004e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 1 of 1 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 129 | Optimization of Nested SQL Queries Revisited | 1987 | SIGMOD | 0.0003068101 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 13,558 | Towards Creating Application-Specific Database Management Systems | 2015 | CIDR |
| 2 | 5,429 | Detecting Metadata-Related Logic Bugs in Database Systems via Raw Database Construction | 2024 | VLDB |
| 3 | 13,735 | Bridging the Application and DBMS Divide Using Static Analysis and Dynamic Profiling | 2009 | SIGMOD |
| 4 | 7,756 | Semantic Conformance Testing of Relational DBMS | 2025 | VLDB |
| 5 | 8,145 | You Say ‘What’, I Hear ‘Where’ and ‘Why’ — (Mis-)Interpreting SQL to Derive Fine-Grained Provenance | 2018 | VLDB |
| 6 | 9,045 | Causality-Guided Adaptive Interventional Debugging | 2020 | SIGMOD |
| 7 | 9,351 | DBG-PT: A Large Language Model Assisted Query Performance Regression Debugger | 2024 | VLDB |
| 8 | 7,570 | Debugging Transactions and Tracking their Provenance with Reenactment | 2017 | VLDB |
| 9 | 8,482 | A Demonstration of DLBD: Database Logic Bug Detection System | 2023 | VLDB |
| 10 | 9,241 | Provenance for SQL through Abstract Interpretation: Value-less, but Worthwhile | 2015 | VLDB |