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
h51ec719d98f6552b
Venue
SIGMOD
Year
2016
Pagerank
7.7721951e-05
Overall Rank
2,993 | 79.88%
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
896 Froid: Optimization of Imperative Programs in a Relational Database 2018 VLDB 0.00013209291
1,786 Procedural Extensions of SQL: Understanding their usage in the wild 2021 VLDB 9.6326265e-05
2,207 Magpie: Python at Speed and Scale using Cloud Backends 2021 CIDR 8.8487039e-05
3,194 One WITH RECURSIVE is Worth Many GOTOs 2021 SIGMOD 7.5498012e-05
4,061 Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates 2020 SIGMOD 6.824809e-05
4,149 SQLCheck: Automated Detection and Diagnosis of SQL Anti-Patterns 2020 SIGMOD 6.7796171e-05
4,654 Automatically Leveraging MapReduce Frameworks for Data-Intensive Applications 2018 SIGMOD 6.4849398e-05
5,230 Babelfish: Efficient Execution of Polyglot Queries 2022 VLDB 6.2189001e-05
5,809 Snakes on a Plan: Compiling Python Functions into Plain SQL Queries 2022 SIGMOD 5.987479e-05
6,088 Iterative Query Processing based on Unified Optimization Techniques 2019 SIGMOD 5.8908778e-05
6,400 Functional-Style SQL UDFs With a Capital 'F' 2020 SIGMOD 5.7981078e-05
6,575 WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications 2024 SIGMOD 5.7453775e-05
7,438 DBridge: Translating Imperative Code to SQL 2017 SIGMOD 5.5272264e-05
7,983 Efficient Execution of User-Defined Functions in SQL Queries 2023 VLDB 5.4131297e-05
8,345 MONSOON: Multi-Step Optimization and Execution of Queries with Partially Obscured Predicates 2020 SIGMOD 5.3511996e-05
8,900 Translation of Array-Based Loops to Distributed Data-Parallel Programs 2020 VLDB 5.2559789e-05
9,588 The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining 2025 VLDB 5.156809e-05
10,223 SQL Engines Excel at the Execution of Imperative Programs 2024 VLDB 5.0572221e-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
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