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,766 | I-Rex: An Interactive Relational Query Explainer for SQL | 2020 | VLDB | 5.4399564e-05 |
| 7,972 | The Power of Constraints in Natural Language to SQL Translation | 2025 | VLDB | 5.3993508e-05 |
| 9,001 | Qr-Hint: Actionable Hints Towards Correcting Wrong SQL Queries | 2024 | SIGMOD | 5.2260584e-05 |
| 10,074 | QO-Insight: Inspecting Steered Query Optimizers | 2023 | VLDB | 5.0732737e-05 |
| 10,914 | I-Rex: An Interactive Debugger for SQL | 2026 | VLDB | 4.9605343e-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 |
|---|---|---|---|---|
| 133 | Optimization of Nested SQL Queries Revisited | 1987 | SIGMOD | 0.0003015194 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 4,748 | Detecting Metadata-Related Logic Bugs in Database Systems via Raw Database Construction | 2024 | VLDB |
| 2 | 14,092 | Bridging the Application and DBMS Divide Using Static Analysis and Dynamic Profiling | 2009 | SIGMOD |
| 3 | 7,221 | Semantic Conformance Testing of Relational DBMS | 2025 | VLDB |
| 4 | 7,840 | You Say ‘What’, I Hear ‘Where’ and ‘Why’ — (Mis-)Interpreting SQL to Derive Fine-Grained Provenance | 2018 | VLDB |
| 5 | 8,540 | Causality-Guided Adaptive Interventional Debugging | 2020 | SIGMOD |
| 6 | 7,768 | DBG-PT: A Large Language Model Assisted Query Performance Regression Debugger | 2024 | VLDB |
| 7 | 7,334 | Debugging Transactions and Tracking their Provenance with Reenactment | 2017 | VLDB |
| 8 | 8,640 | A Demonstration of DLBD: Database Logic Bug Detection System | 2023 | VLDB |
| 9 | 9,449 | Provenance for SQL through Abstract Interpretation: Value-less, but Worthwhile | 2015 | VLDB |
| 10 | 10,914 | I-Rex: An Interactive Debugger for SQL | 2026 | VLDB |