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 5 of 5 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 7,746 | I-Rex: An Interactive Relational Query Explainer for SQL | 2020 | VLDB | 5.4605889e-05 |
| 7,952 | The Power of Constraints in Natural Language to SQL Translation | 2025 | VLDB | 5.4198293e-05 |
| 8,972 | Qr-Hint: Actionable Hints Towards Correcting Wrong SQL Queries | 2024 | SIGMOD | 5.2458797e-05 |
| 10,030 | QO-Insight: Inspecting Steered Query Optimizers | 2023 | VLDB | 5.0925155e-05 |
| 10,843 | I-Rex: An Interactive Debugger for SQL | 2026 | VLDB | 4.9793485e-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 |
|---|---|---|---|---|
| 132 | Optimization of Nested SQL Queries Revisited | 1987 | SIGMOD | 0.00030241193 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 5,054 | Detecting Metadata-Related Logic Bugs in Database Systems via Raw Database Construction | 2024 | VLDB |
| 2 | 14,047 | Bridging the Application and DBMS Divide Using Static Analysis and Dynamic Profiling | 2009 | SIGMOD |
| 3 | 7,919 | Semantic Conformance Testing of Relational DBMS | 2025 | VLDB |
| 4 | 7,819 | You Say ‘What’, I Hear ‘Where’ and ‘Why’ — (Mis-)Interpreting SQL to Derive Fine-Grained Provenance | 2018 | VLDB |
| 5 | 8,517 | Causality-Guided Adaptive Interventional Debugging | 2020 | SIGMOD |
| 6 | 7,764 | DBG-PT: A Large Language Model Assisted Query Performance Regression Debugger | 2024 | VLDB |
| 7 | 7,313 | Debugging Transactions and Tracking their Provenance with Reenactment | 2017 | VLDB |
| 8 | 8,615 | A Demonstration of DLBD: Database Logic Bug Detection System | 2023 | VLDB |
| 9 | 9,414 | Provenance for SQL through Abstract Interpretation: Value-less, but Worthwhile | 2015 | VLDB |
| 10 | 10,843 | I-Rex: An Interactive Debugger for SQL | 2026 | VLDB |