DBScholar

Back to papers

I-Rex: An Interactive Debugger for SQL

Summary: I-Rex brings GPL-style interactive debugging—stepping, watchpoints, and visual inspection—to SQL’s logical execution. Selective materialization and query rewriting enable arbitrary jumps without database preparation, persistent state, or runtime overhead. (summarized by gpt-5.6-luna on Aug 28 2026)

Paper ID
h9029f204b2afa883
Venue
VLDB
Year
2026
Pagerank
4.9793485e-05
Overall Rank
10,843 | 27.10%
DOI
10.14778/3836663.3836670

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

BibTeX Citation

@article{hu_vldb26,
        title = {{I-Rex: An Interactive Debugger for SQL}},
        author = {Hu, Yihao and Chen, Zian and Leong, Zhiming and Sokhi, Sharan and Zheng, Zachary and Chao, Alex and Stephens-Martinez, Kristin and Roy, Sudeepa and Yang, Jun},
        journal = {PVLDB},
        series = {{VLDB} '26},
        volume = {19},
        number = {11},
        pages = {3020--3033},
        doi = {10.14778/3836663.3836670},
        url = {https://doi.org/10.14778/3836663.3836670},
        year = {2026}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank Citing Paper Year Venue Pagerank
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 30 of 30 cited papers.

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

Rank Cited Paper Year Venue Pagerank
1 Access Path Selection in a Relational Database Management System 1979 SIGMOD 0.0023947656
174 Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation 2024 VLDB 0.00026790979
273 Extensible Query Processing in Starburst 1989 SIGMOD 0.00022504729
337 Trio: A System for Data, Uncertainty, and Lineage 2006 VLDB 0.00020621631
379 Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources 2018 SIGMOD 0.00019514689
391 Why Not? 2009 SIGMOD 0.00019238698
622 On the Provenance of Non-Answers to Queries over Extracted Data 2008 VLDB 0.00015484312
790 Cosette: An Automated Prover for SQL 2017 CIDR 0.00013976438
1,564 Titian: Data Provenance Support in Spark 2016 VLDB 0.00010222394
1,680 Axiomatic Foundations and Algorithms for Deciding Semantic Equivalences of SQL Queries 2018 VLDB 9.9031411e-05
1,746 SMOKE: Fine-grained Lineage at Interactive Speed 2018 VLDB 9.7341914e-05
1,765 Putting Lipstick on Pig: Enabling Database-style Workflow Provenance 2012 VLDB 9.6955585e-05
2,648 Explore-by-Example: An Automatic Query Steering Framework for Interactive Data Exploration 2014 SIGMOD 8.1761271e-05
2,757 Answering (Unions of) Conjunctive Queries using Random Access and Random-Order Enumeration 2020 PODS 8.0525756e-05
2,883 SQL QueRIE Recommendations 2010 VLDB 7.9108916e-05
2,961 Proving Query Equivalence Using Linear Integer Arithmetic 2023 SIGMOD 7.8068219e-05
3,073 Pushing Data-Induced Predicates Through Joins in Big-Data Clusters 2020 VLDB 7.6777283e-05
4,102 QED: A Powerful Query Equivalence Decider for SQL 2024 VLDB 6.8070264e-05
4,617 QueryVis: Logic-based Diagrams help Users Understand Complicated SQL Queries Faster 2020 SIGMOD 6.49965e-05
4,698 Tractable Orders for Direct Access to Ranked Answers of Conjunctive Queries 2021 PODS 6.4640177e-05
4,847 Explaining Wrong Queries Using Small Examples 2019 SIGMOD 6.3823876e-05
4,857 A SQL Debugger Built from Spare Parts: Turning a SQL:1999 Database System into Its Own Debugger 2015 SIGMOD 6.3794096e-05
5,482 Beyond Equi-joins: Ranking, Enumeration and Factorization 2021 VLDB 6.111411e-05
5,854 Pando: Enhanced Data Skipping with Logical Data Partitioning 2023 VLDB 5.9708829e-05
7,746 I-Rex: An Interactive Relational Query Explainer for SQL 2020 VLDB 5.4605889e-05
7,819 You Say ‘What’, I Hear ‘Where’ and ‘Why’ — (Mis-)Interpreting SQL to Derive Fine-Grained Provenance 2018 VLDB 5.4466474e-05
8,153 Predicate Pushdown for Data Science Pipelines 2023 SIGMOD 5.3891786e-05
8,495 Provenance-based Data Skipping 2022 VLDB 5.3304338e-05
8,972 Qr-Hint: Actionable Hints Towards Correcting Wrong SQL Queries 2024 SIGMOD 5.2458797e-05
9,061 Understanding Queries by Conditional Instances 2022 SIGMOD 5.2289882e-05
Previous Page 1 / 1 Next

Semantically Similar Papers