Extracting Equivalent SQL from Imperative Code in Database Applications
Summary: Holistic optimization derives algebraic D-IR representations of program variables in database apps and translates them into F-IR and SQL. Conditionals, loops, and aggregates from imperative code can be rewritten as SQL to reduce data movement and round trips. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. K. Venkatesh Emani (Indian Institute of Technology Mumbai)
- 2. Subhro Bhattacharya (Citrix Systems; Indian Institute of Technology Mumbai)
- 3. Karthik Ramachandra (Indian Institute of Technology Mumbai; Microsoft)
- 4. S. Sudarshan (Indian Institute of Technology Mumbai)
BibTeX Citation
@inproceedings{emani_sigmod16,
title = {{Extracting Equivalent SQL from Imperative Code in Database Applications}},
author = {Emani, K. Venkatesh and Bhattacharya, Subhro and Ramachandra, Karthik and Sudarshan, S.},
series = {{SIGMOD} '16},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/2882903.2882926},
url = {https://dl.acm.org/doi/10.1145/2882903.2882926},
year = {2016}
}
Incoming Citations (Sorted by Pagerank)
Showing 18 of 18 citing papers.
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 7 of 7 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 552 | Orthogonal Optimization of Subqueries and Aggregation | 2001 | SIGMOD | 0.0001653835 |
| 1,274 | Rewriting Procedures for Batched Bindings | 2008 | VLDB | 0.00011247334 |
| 1,345 | Reverse Engineering Complex Join Queries | 2013 | SIGMOD | 0.00010953079 |
| 3,212 | Query Shredding: Efficient Relational Evaluation of Queries over Nested Multisets | 2014 | SIGMOD | 7.5328945e-05 |
| 5,876 | Holistic Optimization by Prefetching Query Results | 2012 | SIGMOD | 5.9628805e-05 |
| 6,840 | Towards Unified Ad-hoc Data Processing | 2014 | SIGMOD | 5.6669233e-05 |
| 7,408 | AJAXSearch: Crawling, Indexing and Searching Web 2.0 Applications | 2008 | VLDB | 5.5345052e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 689 | Query Optimization in the Presence of Foreign Functions | 1993 | VLDB |
| 2 | 630 | A Rule-Based View of Query Optimization | 1987 | SIGMOD |
| 3 | 1,898 | Querying Multiple Features of Groups in Relational Databases | 1996 | VLDB |
| 4 | 896 | Froid: Optimization of Imperative Programs in a Relational Database | 2018 | VLDB |
| 5 | 10,223 | SQL Engines Excel at the Execution of Imperative Programs | 2024 | VLDB |
| 6 | 6,055 | Translating and Optimizing SQL Queries Having Aggregates | 1987 | VLDB |
| 7 | 4,653 | Translating Aggregate Queries into Iterative Programs | 1986 | VLDB |
| 8 | 7,438 | DBridge: Translating Imperative Code to SQL | 2017 | SIGMOD |
| 9 | 13,330 | Investigation of Algebraic Query Optimisation for Database Programming Languages | 1994 | VLDB |
| 10 | 7,261 | Rule-Based Translation of Relational Queries into Iterative Programs | 1986 | SIGMOD |