DBScholar

Back to papers

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)

Paper ID
5179
Venue
SIGMOD
Year
2016
Pagerank
7.9395908e-05
Overall Rank
2,939 | 79.84%
DOI
10.1145/2882903.2882926

Incoming Non-self Citations Over Time

Authors

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.

Rank Citing Paper Year Venue Pagerank
894 Froid: Optimization of Imperative Programs in a Relational Database 2018 VLDB 0.00013367658
1,892 Procedural Extensions of SQL: Understanding their usage in the wild 2021 VLDB 9.5277793e-05
2,651 Magpie: Python at Speed and Scale using Cloud Backends 2021 CIDR 8.2918086e-05
3,257 One WITH RECURSIVE is Worth Many GOTOs 2021 SIGMOD 7.590651e-05
3,992 Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates 2020 SIGMOD 6.9695338e-05
4,082 SQLCheck: Automated Detection and Diagnosis of SQL Anti-Patterns 2020 SIGMOD 6.9164719e-05
4,599 Automatically Leveraging MapReduce Frameworks for Data-Intensive Applications 2018 SIGMOD 6.6122875e-05
5,301 Babelfish: Efficient Execution of Polyglot Queries 2022 VLDB 6.2750553e-05
5,684 Snakes on a Plan: Compiling Python Functions into Plain SQL Queries 2022 SIGMOD 6.1224825e-05
5,991 Iterative Query Processing based on Unified Optimization Techniques 2019 SIGMOD 6.0171458e-05
6,328 Functional-Style SQL UDFs With a Capital 'F' 2020 SIGMOD 5.9113895e-05
6,475 WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications 2024 SIGMOD 5.8687157e-05
7,297 DBridge: Translating Imperative Code to SQL 2017 SIGMOD 5.6525237e-05
8,096 Efficient Execution of User-Defined Functions in SQL Queries 2023 VLDB 5.4875738e-05
8,211 MONSOON: Multi-Step Optimization and Execution of Queries with Partially Obscured Predicates 2020 SIGMOD 5.4658735e-05
8,738 Translation of Array-Based Loops to Distributed Data-Parallel Programs 2020 VLDB 5.3766157e-05
9,415 The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining 2025 VLDB 5.2742285e-05
10,040 SQL Engines Excel at the Execution of Imperative Programs 2024 VLDB 5.1723558e-05
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
543 Orthogonal Optimization of Subqueries and Aggregation 2001 SIGMOD 0.0001682612
1,261 Rewriting Procedures for Batched Bindings 2008 VLDB 0.0001143305
1,313 Reverse Engineering Complex Join Queries 2013 SIGMOD 0.00011186284
3,155 Query Shredding: Efficient Relational Evaluation of Queries over Nested Multisets 2014 SIGMOD 7.695861e-05
5,759 Holistic Optimization by Prefetching Query Results 2012 SIGMOD 6.0962298e-05
6,714 Towards Unified Ad-hoc Data Processing 2014 SIGMOD 5.7959651e-05
7,264 AJAXSearch: Crawling, Indexing and Searching Web 2.0 Applications 2008 VLDB 5.6607496e-05
Previous Page 1 / 1 Next

Semantically Similar Papers