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.9605343e-05
Overall Rank
10,914 | 26.85%
DOI
10.14778/3836663.3836670
PDF
Download (CC BY-NC-ND 4.0)

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.0023948467
163 Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation 2024 VLDB 0.00027456647
275 Extensible Query Processing in Starburst 1989 SIGMOD 0.000224395
340 Trio: A System for Data, Uncertainty, and Lineage 2006 VLDB 0.00020548826
382 Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources 2018 SIGMOD 0.0001946654
389 Why Not? 2009 SIGMOD 0.00019254758
624 On the Provenance of Non-Answers to Queries over Extracted Data 2008 VLDB 0.00015438077
787 Cosette: An Automated Prover for SQL 2017 CIDR 0.00013959502
1,562 Titian: Data Provenance Support in Spark 2016 VLDB 0.00010192248
1,678 Axiomatic Foundations and Algorithms for Deciding Semantic Equivalences of SQL Queries 2018 VLDB 9.8966017e-05
1,722 SMOKE: Fine-grained Lineage at Interactive Speed 2018 VLDB 9.781628e-05
1,776 Putting Lipstick on Pig: Enabling Database-style Workflow Provenance 2012 VLDB 9.6661217e-05
2,656 Explore-by-Example: An Automatic Query Steering Framework for Interactive Data Exploration 2014 SIGMOD 8.1460698e-05
2,766 Answering (Unions of) Conjunctive Queries using Random Access and Random-Order Enumeration 2020 PODS 8.0221503e-05
2,899 SQL QueRIE Recommendations 2010 VLDB 7.8825624e-05
2,971 Proving Query Equivalence Using Linear Integer Arithmetic 2023 SIGMOD 7.7851336e-05
3,081 Pushing Data-Induced Predicates Through Joins in Big-Data Clusters 2020 VLDB 7.6515625e-05
4,116 QED: A Powerful Query Equivalence Decider for SQL 2024 VLDB 6.7846764e-05
4,638 QueryVis: Logic-based Diagrams help Users Understand Complicated SQL Queries Faster 2020 SIGMOD 6.4750914e-05
4,714 Tractable Orders for Direct Access to Ranked Answers of Conjunctive Queries 2021 PODS 6.4395938e-05
4,871 Explaining Wrong Queries Using Small Examples 2019 SIGMOD 6.3583165e-05
4,885 A SQL Debugger Built from Spare Parts: Turning a SQL:1999 Database System into Its Own Debugger 2015 SIGMOD 6.3553053e-05
5,506 Beyond Equi-joins: Ranking, Enumeration and Factorization 2021 VLDB 6.0883761e-05
5,856 Pando: Enhanced Data Skipping with Logical Data Partitioning 2023 VLDB 5.9514226e-05
7,766 I-Rex: An Interactive Relational Query Explainer for SQL 2020 VLDB 5.4399564e-05
7,840 You Say ‘What’, I Hear ‘Where’ and ‘Why’ — (Mis-)Interpreting SQL to Derive Fine-Grained Provenance 2018 VLDB 5.4260988e-05
8,176 Predicate Pushdown for Data Science Pipelines 2023 SIGMOD 5.3688159e-05
8,505 Provenance-based Data Skipping 2022 VLDB 5.3126038e-05
9,001 Qr-Hint: Actionable Hints Towards Correcting Wrong SQL Queries 2024 SIGMOD 5.2260584e-05
9,090 Understanding Queries by Conditional Instances 2022 SIGMOD 5.2092307e-05
Previous Page 1 / 1 Next

Semantically Similar Papers