{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,1,11]],"date-time":"2026-01-11T05:10:37Z","timestamp":1768108237455,"version":"3.49.0"},"publisher-location":"New York, NY, USA","reference-count":17,"publisher":"ACM","license":[{"start":{"date-parts":[[2007,6,11]],"date-time":"2007-06-11T00:00:00Z","timestamp":1181520000000},"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":[[2007,6,11]]},"DOI":"10.1145\/1247480.1247598","type":"proceedings-article","created":{"date-parts":[[2007,9,14]],"date-time":"2007-09-14T16:07:37Z","timestamp":1189786057000},"page":"993-1004","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":40,"title":["Execution strategies for SQL subqueries"],"prefix":"10.1145","author":[{"given":"Mostafa","family":"Elhemali","sequence":"first","affiliation":[{"name":"Microsoft Corp., Redmond, WA"}]},{"given":"C\u00e9sar A.","family":"Galindo-Legaria","sequence":"additional","affiliation":[{"name":"Microsoft Corp., Redmond, WA"}]},{"given":"Torsten","family":"Grabs","sequence":"additional","affiliation":[{"name":"Microsoft Corp., Redmond, WA"}]},{"given":"Milind M.","family":"Joshi","sequence":"additional","affiliation":[{"name":"Microsoft Corp., Redmond, WA"}]}],"member":"320","published-online":{"date-parts":[[2007,6,11]]},"reference":[{"key":"e_1_3_2_1_1_1","volume-title":"Document ISO\/IEC 9075","author":"International Organization for Standardization (ISO)","year":"1992","unstructured":"International Organization for Standardization (ISO) : Data-base Language SQL , Document ISO\/IEC 9075 : 1992 . International Organization for Standardization (ISO): Data-base Language SQL, Document ISO\/IEC 9075: 1992."},{"key":"e_1_3_2_1_2_1","unstructured":"XQuery 1.0: An XML Query Language http:\/\/www.w3.org\/TR\/xquery\/  XQuery 1.0: An XML Query Language http:\/\/www.w3.org\/TR\/xquery\/"},{"key":"e_1_3_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/319732.319745"},{"key":"e_1_3_2_1_4_1","first-page":"241","volume":"1985","author":"Kie\u00dfling W.","unstructured":"W. Kie\u00dfling : On Semantic Reefs and Efficient Processing of Correlation Queries with Aggregates. VLDB 1985 : 241 -- 250 . W. Kie\u00dfling: On Semantic Reefs and Efficient Processing of Correlation Queries with Aggregates. VLDB 1985: 241--250.","journal-title":"VLDB"},{"key":"e_1_3_2_1_5_1","volume-title":"H. K. T. Wong: Optimization of Nested SQL Queries Revisited. SIGMOD Conference 1987:  23--33","author":"Ganski R. A.","unstructured":"R. A. Ganski , H. K. T. Wong: Optimization of Nested SQL Queries Revisited. SIGMOD Conference 1987: 23--33 . R. A. Ganski, H. K. T. Wong: Optimization of Nested SQL Queries Revisited. SIGMOD Conference 1987: 23--33."},{"key":"e_1_3_2_1_6_1","first-page":"235","volume":"1987","author":"von B\u00fcltzingsloewen G.","unstructured":"G. von B\u00fcltzingsloewen : Translating and Optimizing SQL Queries Having Aggregates. VLDB 1987 : 235 -- 243 . G. von B\u00fcltzingsloewen: Translating and Optimizing SQL Queries Having Aggregates. VLDB 1987: 235--243.","journal-title":"Translating and Optimizing SQL Queries Having Aggregates. VLDB"},{"key":"e_1_3_2_1_7_1","first-page":"91","volume":"1992","author":"Muralikrishna M.","unstructured":"M. Muralikrishna : Improved Unnesting Algorithms for Join Aggregate SQL Queries. VLDB 1992 : 91 -- 102 . M. Muralikrishna: Improved Unnesting Algorithms for Join Aggregate SQL Queries. VLDB 1992: 91--102.","journal-title":"Improved Unnesting Algorithms for Join Aggregate SQL Queries. VLDB"},{"key":"e_1_3_2_1_8_1","volume-title":"T. Y. C. Leung: Complex Query Decorrelation. ICDE 1996:  450--458","author":"Seshadri P.","unstructured":"P. Seshadri , H. Pirahesh , T. Y. C. Leung: Complex Query Decorrelation. ICDE 1996: 450--458 . P. Seshadri, H. Pirahesh, T. Y. C. Leung: Complex Query Decorrelation. ICDE 1996: 450--458."},{"key":"e_1_3_2_1_9_1","volume-title":"M. Joshi: Orthogonal Optimization of Subqueries and Aggregation. SIGMOD Conference 2001:  571--581","author":"Galindo-Legaria C. A.","unstructured":"C. A. Galindo-Legaria , M. Joshi: Orthogonal Optimization of Subqueries and Aggregation. SIGMOD Conference 2001: 571--581 . C. A. Galindo-Legaria, M. Joshi: Orthogonal Optimization of Subqueries and Aggregation. SIGMOD Conference 2001: 571--581."},{"key":"e_1_3_2_1_10_1","volume-title":"Ding: Dynamic Materialized Views, to appear in: ICDE","author":"Zhou J.","year":"2007","unstructured":"J. Zhou , P. Larson , J. Goldstein , L. Ding: Dynamic Materialized Views, to appear in: ICDE 2007 . J. Zhou, P. Larson, J. Goldstein, L. Ding: Dynamic Materialized Views, to appear in: ICDE 2007."},{"key":"e_1_3_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/244810.244812"},{"key":"e_1_3_2_1_12_1","volume-title":"Moerkotte: Unnesting Scalar SQL Queries in the Presence of Disjunction, to appear in: ICDE","author":"Brantner M.","year":"2007","unstructured":"M. Brantner , N. May , G. Moerkotte: Unnesting Scalar SQL Queries in the Presence of Disjunction, to appear in: ICDE 2007 . M. Brantner, N. May, G. Moerkotte: Unnesting Scalar SQL Queries in the Presence of Disjunction, to appear in: ICDE 2007."},{"key":"e_1_3_2_1_13_1","first-page":"2000","volume-title":"Microsoft","author":"Galindo-Legaria C. A.","year":"2001","unstructured":"C. A. Galindo-Legaria . Parameterized queries and nesting equivalences. Technical report , Microsoft , 2001 . MSR-TR- 2000 - 2031 . C. A. Galindo-Legaria. Parameterized queries and nesting equivalences. Technical report, Microsoft, 2001. MSR-TR-2000-31."},{"key":"e_1_3_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/152610.152611"},{"key":"e_1_3_2_1_15_1","volume-title":"Joseph Burger: Nested Loops Revisited. PDIS 1993:  230--242","author":"DeWitt David J.","unstructured":"David J. DeWitt , Jeffrey F. Naughton , Joseph Burger: Nested Loops Revisited. PDIS 1993: 230--242 . David J. DeWitt, Jeffrey F. Naughton, Joseph Burger: Nested Loops Revisited. PDIS 1993: 230--242."},{"key":"e_1_3_2_1_16_1","first-page":"19","author":"D.","year":"1968","unstructured":"D. Michie: \"Memo\" Functions and Machine Learning. Nature (218) , April 1968 : 19 -- 22 . D. Michie: \"Memo\" Functions and Machine Learning. Nature (218), April 1968: 19--22.","journal-title":"Functions and Machine Learning. Nature (218)"},{"key":"e_1_3_2_1_17_1","volume-title":"SIGMOD Conference 1996:  423--434","author":"Naughton J. M.","unstructured":"Hellerstein, J. M. , Naughton , J. F. : Query execution techniques for caching expensive methods . SIGMOD Conference 1996: 423--434 . Hellerstein, J. M., Naughton, J. F.: Query execution techniques for caching expensive methods. SIGMOD Conference 1996: 423--434."}],"event":{"name":"SIGMOD\/PODS07: International Conference on Management of Data","location":"Beijing China","acronym":"SIGMOD\/PODS07","sponsor":["SIGMOD ACM Special Interest Group on Management of Data","ACM Association for Computing Machinery"]},"container-title":["Proceedings of the 2007 ACM SIGMOD international conference on Management of data"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1247480.1247598","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/1247480.1247598","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T14:47:38Z","timestamp":1750258058000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1247480.1247598"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2007,6,11]]},"references-count":17,"alternative-id":["10.1145\/1247480.1247598","10.1145\/1247480"],"URL":"https:\/\/doi.org\/10.1145\/1247480.1247598","relation":{},"subject":[],"published":{"date-parts":[[2007,6,11]]},"assertion":[{"value":"2007-06-11","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}