I-Rex: An Interactive Relational Query Explainer for SQL
Summary: Interactive SQL trace preserving syntax for complex queries with correlated subqueries to explain evaluation. Small counterexample provenance for SQL to diagnose incorrect results vs a reference query, enabling focused debugging and regression testing. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Zhengjie Miao
- 2. Tiangang Chen
- 3. Alexander Bendeck
- 4. Kevin Day
- 5. Sudeepa Roy
- 6. Jun Yang
Incoming Citations (Sorted by Pagerank)
Showing 3 of 3 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 6,565 | Toward Interpretable and Actionable Data Analysis with Explanations and Causality | 2022 | VLDB | 5.0081626e-05 |
| 9,710 | QO-Insight: Inspecting Steered Query Optimizers | 2023 | VLDB | 4.299267e-05 |
| 10,860 | Exploring Exploratory Querying | 2025 | VLDB | 4.1945683e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 2 of 2 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 31 | Provenance Semirings | 2007 | PODS | 0.0007857786 |
| 4,735 | A SQL Debugger Built from Spare Parts: Turning a SQL:1999 Database System into Its Own Debugger | 2015 | SIGMOD | 5.9612875e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 7,556 | Interactive Query Explanations Using Fine Grained Provenance | 2022 | SIGMOD | 4.7117814e-05 |
| 5,452 | QueryVis: Logic-based Diagrams help Users Understand Complicated SQL Queries Faster | 2020 | SIGMOD | 5.4999397e-05 |
| 2,717 | REGAL+: Reverse Engineering SPJA Queries | 2018 | VLDB | 8.2425675e-05 |
| 8,954 | Understanding Queries by Conditional Instances | 2022 | SIGMOD | 4.4221863e-05 |
| 7,604 | ConEx: A System for Monitoring Queries | 2007 | SIGMOD | 4.6980644e-05 |
| 6,095 | QRelX: Generating Meaningful Queries that Provide Cardinality Assurance | 2010 | SIGMOD | 5.2128855e-05 |
| 9,029 | Provenance for SQL through Abstract Interpretation: Value-less, but Worthwhile | 2015 | VLDB | 4.4040532e-05 |
| 9,638 | TracEx: Understanding and Analyzing Database Traces | 2024 | CIDR | 4.3109052e-05 |
| 5,733 | Explaining Wrong Queries Using Small Examples | 2019 | SIGMOD | 5.3483446e-05 |
| 11,666 | RATest: Explaining Wrong Relational Queries Using Small Examples | 2019 | SIGMOD | 4.1945683e-05 |