{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,2,11]],"date-time":"2026-02-11T14:51:39Z","timestamp":1770821499756,"version":"3.50.1"},"publisher-location":"New York, NY, USA","reference-count":22,"publisher":"ACM","license":[{"start":{"date-parts":[[2020,5,31]],"date-time":"2020-05-31T00:00:00Z","timestamp":1590883200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2020,6,11]]},"DOI":"10.1145\/3318464.3389736","type":"proceedings-article","created":{"date-parts":[[2020,5,29]],"date-time":"2020-05-29T17:12:33Z","timestamp":1590772353000},"page":"559-573","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":20,"title":["Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates"],"prefix":"10.1145","author":[{"given":"Surabhi","family":"Gupta","sequence":"first","affiliation":[{"name":"Microsoft Research India, Bengaluru, India"}]},{"given":"Sanket","family":"Purandare","sequence":"additional","affiliation":[{"name":"Harvard University, Cambridge, MA, USA"}]},{"given":"Karthik","family":"Ramachandra","sequence":"additional","affiliation":[{"name":"Microsoft Research India, Bengaluru, India"}]}],"member":"320","published-online":{"date-parts":[[2020,5,31]]},"reference":[{"key":"e_1_3_2_2_1_1","doi-asserted-by":"publisher","DOI":"10.1145\/3183713.3196891"},{"key":"e_1_3_2_2_2_1","volume-title":"Ullman","author":"Aho Alfred V.","year":"2006","unstructured":"Alfred V. Aho , Monica S. Lam , Ravi Sethi , and Jeffrey D . Ullman . 2006 . Compilers : Principles, Techniques, and Tools .Addison-Wesley. Alfred V. Aho, Monica S. Lam, Ravi Sethi, and Jeffrey D. Ullman. 2006. Compilers: Principles, Techniques, and Tools .Addison-Wesley."},{"key":"e_1_3_2_2_3_1","volume-title":"Automatic Partitioning of Database Applications. In Intl. Conf. on Very Large Databases.","author":"Cheung Alvin","year":"2012","unstructured":"Alvin Cheung , Samuel Madden , Owen Arden ,, and Andrew C Myers . 2012 . Automatic Partitioning of Database Applications. In Intl. Conf. on Very Large Databases. Alvin Cheung, Samuel Madden, Owen Arden,, and Andrew C Myers. 2012. Automatic Partitioning of Database Applications. In Intl. Conf. on Very Large Databases."},{"key":"e_1_3_2_2_4_1","doi-asserted-by":"crossref","unstructured":"Alvin Cheung Armando Solar-Lezama and Samuel Madden. 2013. Optimizing database-backed applications with query synthesis (PLDI). 3--14. https:\/\/doi.org\/10.1145\/2462156.2462180  Alvin Cheung Armando Solar-Lezama and Samuel Madden. 2013. Optimizing database-backed applications with query synthesis (PLDI). 3--14. https:\/\/doi.org\/10.1145\/2462156.2462180","DOI":"10.1145\/2499370.2462180"},{"key":"e_1_3_2_2_5_1","doi-asserted-by":"crossref","unstructured":"Sara Cohen. 2006. User-defined Aggregate Functions: Bridging Theory and Practice. In ACM SIGMOD. 49--60.  Sara Cohen. 2006. User-defined Aggregate Functions: Bridging Theory and Practice. In ACM SIGMOD. 49--60.","DOI":"10.1145\/1142473.1142480"},{"key":"e_1_3_2_2_6_1","first-page":"1909","volume-title":"Article arXiv:1909.03291 (Sep","author":"Duta Christian","year":"2019","unstructured":"Christian Duta , Denis Hirn , and Torsten Grust . 2019. Compiling PL\/SQL Away . arXiv e-prints , Article arXiv:1909.03291 (Sep 2019 ), bibinfonumpagesarXiv: 1909 .03291 pages.arxiv: cs.DB\/1909.03291 Christian Duta, Denis Hirn, and Torsten Grust. 2019. Compiling PL\/SQL Away. arXiv e-prints, Article arXiv:1909.03291 (Sep 2019), bibinfonumpagesarXiv:1909.03291 pages.arxiv: cs.DB\/1909.03291"},{"key":"e_1_3_2_2_7_1","doi-asserted-by":"crossref","unstructured":"K. Venkatesh Emani Karthik Ramachandra Subhro Bhattacharya and S. Sudarshan. 2016. Extracting Equivalent SQL from Imperative Code in Database Applications (ACM SIGMOD). 16. https:\/\/doi.org\/10.1145\/2882903.2882926  K. Venkatesh Emani Karthik Ramachandra Subhro Bhattacharya and S. Sudarshan. 2016. Extracting Equivalent SQL from Imperative Code in Database Applications (ACM SIGMOD). 16. https:\/\/doi.org\/10.1145\/2882903.2882926","DOI":"10.1145\/2882903.2882926"},{"key":"e_1_3_2_2_8_1","volume-title":"Cobra: A Framework for Cost-Based Rewriting of Database Applications. In 2018 IEEE 34th International Conference on Data Engineering (ICDE). IEEE, 689--700","author":"Venkatesh Emani K","year":"2018","unstructured":"K Venkatesh Emani and S Sudarshan . 2018 . Cobra: A Framework for Cost-Based Rewriting of Database Applications. In 2018 IEEE 34th International Conference on Data Engineering (ICDE). IEEE, 689--700 . K Venkatesh Emani and S Sudarshan. 2018. Cobra: A Framework for Cost-Based Rewriting of Database Applications. In 2018 IEEE 34th International Conference on Data Engineering (ICDE). IEEE, 689--700."},{"key":"e_1_3_2_2_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/24039.24041"},{"key":"e_1_3_2_2_10_1","volume-title":"SQLoop: High Performance Iterative Processing in Data Management. In 38th IEEE International Conference on Distributed Computing Systems, ICDCS 2018","author":"Floratos Sofoklis","year":"2018","unstructured":"Sofoklis Floratos , Yanfeng Zhang , Yuan Yuan , Rubao Lee , and Xiaodong Zhang . 2018 . SQLoop: High Performance Iterative Processing in Data Management. In 38th IEEE International Conference on Distributed Computing Systems, ICDCS 2018 , Vienna, Austria, July 2--6 , 2018. 1039--1051. https:\/\/doi.org\/10.1109\/ICDCS.2018.00104 Sofoklis Floratos, Yanfeng Zhang, Yuan Yuan, Rubao Lee, and Xiaodong Zhang. 2018. SQLoop: High Performance Iterative Processing in Data Management. In 38th IEEE International Conference on Distributed Computing Systems, ICDCS 2018, Vienna, Austria, July 2--6, 2018. 1039--1051. https:\/\/doi.org\/10.1109\/ICDCS.2018.00104"},{"key":"e_1_3_2_2_11_1","volume-title":"Galindo-Legaria and Milind Joshi","author":"C\u00e9","year":"2001","unstructured":"C\u00e9 sar A. Galindo-Legaria and Milind Joshi . 2001 . Orthogonal Optimization of Subqueries and Aggregation. In SIGMOD. 571--581. https:\/\/doi.org\/10.1145\/375663.375748 C\u00e9 sar A. Galindo-Legaria and Milind Joshi. 2001. Orthogonal Optimization of Subqueries and Aggregation. In SIGMOD. 571--581. https:\/\/doi.org\/10.1145\/375663.375748"},{"key":"e_1_3_2_2_12_1","volume-title":"Technical Report: Optimizing Cursor Loops In Relational Databases. ArXiv e-prints (April","author":"Gupta S.","year":"2020","unstructured":"S. Gupta , S. Purandare , and K. Ramachandra . 2020 . Technical Report: Optimizing Cursor Loops In Relational Databases. ArXiv e-prints (April 2020). http:\/\/aka.ms\/TR-Aggify S. Gupta, S. Purandare, and K. Ramachandra. 2020. Technical Report: Optimizing Cursor Loops In Relational Databases. ArXiv e-prints (April 2020). http:\/\/aka.ms\/TR-Aggify"},{"key":"e_1_3_2_2_13_1","volume-title":"Rewriting Procedures for Batched Bindings. In Intl. Conf. on Very Large Databases.","author":"Guravannavar Ravindra","year":"2008","unstructured":"Ravindra Guravannavar and S Sudarshan . 2008 . Rewriting Procedures for Batched Bindings. In Intl. Conf. on Very Large Databases. Ravindra Guravannavar and S Sudarshan. 2008. Rewriting Procedures for Batched Bindings. In Intl. Conf. on Very Large Databases."},{"key":"e_1_3_2_2_14_1","volume-title":"Allen","author":"Kennedy Ken","year":"2002","unstructured":"Ken Kennedy and John R . Allen . 2002 . Optimizing Compilers for Modern Architectures: A Dependence-based Approach .Morgan Kaufmann Publishers Inc . Ken Kennedy and John R. Allen. 2002. Optimizing Compilers for Modern Architectures: A Dependence-based Approach .Morgan Kaufmann Publishers Inc."},{"key":"e_1_3_2_2_15_1","volume-title":"Data Flow Analysis: Theory and Practice","author":"Khedker Uday","unstructured":"Uday Khedker , Amitabha Sanyal , and Bageshri Karkare . 2009. Data Flow Analysis: Theory and Practice . CRC Press . Uday Khedker, Amitabha Sanyal, and Bageshri Karkare. 2009. Data Flow Analysis: Theory and Practice .CRC Press."},{"key":"e_1_3_2_2_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/141484.130301"},{"key":"e_1_3_2_2_17_1","volume-title":"Advanced Compiler Design and Implementation","author":"Muchnick Steven S.","unstructured":"Steven S. Muchnick . 1997. Advanced Compiler Design and Implementation . Morgan Kaufmann Publishers Inc ., San Francisco, CA, USA. Steven S. Muchnick. 1997. Advanced Compiler Design and Implementation. Morgan Kaufmann Publishers Inc., San Francisco, CA, USA."},{"key":"e_1_3_2_2_18_1","doi-asserted-by":"publisher","DOI":"10.1145\/3299869.3324960"},{"key":"e_1_3_2_2_19_1","doi-asserted-by":"publisher","DOI":"10.1145\/2660193.2660228"},{"key":"e_1_3_2_2_20_1","first-page":"432","article-title":"Froid: Optimization of Imperative Programs in a Relational Database","volume":"11","author":"Ramachandra Karthik","year":"2017","unstructured":"Karthik Ramachandra , Kwanghyun Park , K. Venkatesh Emani , Alan Halverson , C\u00e9sar Galindo-Legaria , and Conor Cunningham . 2017 . Froid: Optimization of Imperative Programs in a Relational Database . PVLDB , Vol. 11 , 4 (2017), 432 -- 444 . Karthik Ramachandra, Kwanghyun Park, K. Venkatesh Emani, Alan Halverson, C\u00e9sar Galindo-Legaria, and Conor Cunningham. 2017. Froid: Optimization of Imperative Programs in a Relational Database. PVLDB, Vol. 11, 4 (2017), 432--444.","journal-title":"PVLDB"},{"key":"e_1_3_2_2_21_1","volume-title":"ICDE","author":"Simhadri V.","year":"2014","unstructured":"V. Simhadri , K. Ramachandra , A. Chaitanya , R. Guravannavar , and S. Sudarshan . 2014. Decorrelation of user defined function invocations in queries . In ICDE 2014 . 532--543. V. Simhadri, K. Ramachandra, A. Chaitanya, R. Guravannavar, and S. Sudarshan. 2014. Decorrelation of user defined function invocations in queries. In ICDE 2014. 532--543."},{"key":"e_1_3_2_2_22_1","volume-title":"Yan and Per bike Larson","author":"Weipeng","year":"1995","unstructured":"Weipeng P. Yan and Per bike Larson . 1995 . Eager aggregation and lazy aggregation. In In VLDB. 345--357. Weipeng P. Yan and Per bike Larson. 1995. Eager aggregation and lazy aggregation. In In VLDB. 345--357."}],"event":{"name":"SIGMOD\/PODS '20: International Conference on Management of Data","location":"Portland OR USA","acronym":"SIGMOD\/PODS '20","sponsor":["SIGMOD ACM Special Interest Group on Management of Data"]},"container-title":["Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3318464.3389736","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3318464.3389736","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,17]],"date-time":"2025-06-17T22:38:44Z","timestamp":1750199924000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3318464.3389736"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2020,5,31]]},"references-count":22,"alternative-id":["10.1145\/3318464.3389736","10.1145\/3318464"],"URL":"https:\/\/doi.org\/10.1145\/3318464.3389736","relation":{},"subject":[],"published":{"date-parts":[[2020,5,31]]},"assertion":[{"value":"2020-05-31","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}