{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,18]],"date-time":"2026-05-18T10:19:00Z","timestamp":1779099540223,"version":"3.51.4"},"publisher-location":"New York, NY, USA","reference-count":24,"publisher":"ACM","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2025,6,22]]},"DOI":"10.1145\/3722212.3724448","type":"proceedings-article","created":{"date-parts":[[2025,6,17]],"date-time":"2025-06-17T09:01:44Z","timestamp":1750150904000},"page":"297-309","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":1,"title":["Query Decorrelation in the Fabric Data Warehouse"],"prefix":"10.1145","author":[{"ORCID":"https:\/\/orcid.org\/0009-0007-3951-0998","authenticated-orcid":false,"given":"Nicolas","family":"Bruno","sequence":"first","affiliation":[{"name":"Microsoft, Redmond, WA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0009-0006-5344-9495","authenticated-orcid":false,"given":"C\u00e9sar","family":"Galindo-Legaria","sequence":"additional","affiliation":[{"name":"Microsoft, Redmond, WA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0009-0001-0769-1700","authenticated-orcid":false,"given":"Milind","family":"Joshi","sequence":"additional","affiliation":[{"name":"Microsoft, Redmond, WA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2025,6,22]]},"reference":[{"key":"e_1_3_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1016\/S0306-4379(02)00051-0"},{"key":"e_1_3_2_1_2_1","first-page":"42","article-title":"System R","volume":"12","author":"Astrahan Morton M.","year":"1979","unstructured":"Morton M. Astrahan, Mike W. Blasgen, Donald D. Chamberlin, Jim Gray, W. Frank King III, Bruce G. Lindsay, Raymond A. Lorie, James W. Mehl, Thomas G. Price, Gianfranco R. Putzolu, Mario Schkolnick, Patricia G. Selinger, Donald R. Slutz, H. Raymond Strong, Paolo Tiberio, Irving L. Traiger, Bradford W. Wade, and Robert A. Yost. 1979. System R: A Relational Data Base Management System. Computer, Vol. 12, 5 (1979), 42--48.","journal-title":"A Relational Data Base Management System. Computer"},{"key":"e_1_3_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.14778\/1687553.1687563"},{"key":"e_1_3_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2007.367850"},{"key":"e_1_3_2_1_5_1","volume-title":"Unified Query Optimization in the Fabric Data Warehouse. In SIGMOD '24: International Conference on Management of Data. ACM","author":"Bruno Nicolas","year":"2024","unstructured":"Nicolas Bruno, C\u00e9sar Galindo-Legaria, Milind Joshi, Esteban Calvo, Kabita Mahapatra, Sharon Ravindran, Guoheng Chen, Ernesto Cervantes Ju\u00e1rez, and Beysim Sezgin. 2024. Unified Query Optimization in the Fabric Data Warehouse. In SIGMOD '24: International Conference on Management of Data. ACM, Santiago, Chile, June 9 - June 25, 2024, 18--30."},{"key":"e_1_3_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.1997.583381"},{"key":"e_1_3_2_1_7_1","volume-title":"VLDB'87, Proceedings of 13th International Conference on Very Large Data Bases, September 1--4","author":"Dayal Umeshwar","year":"1987","unstructured":"Umeshwar Dayal. 1987. Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers. In VLDB'87, Proceedings of 13th International Conference on Very Large Data Bases, September 1--4, 1987, Peter M. Stocker, William Kent, and Peter Hammersley (Eds.). Morgan Kaufmann, Brighton, England, 197--208."},{"key":"e_1_3_2_1_8_1","unstructured":"DuckDB. 2024. DuckDB documentation. https:\/\/duckdb.org\/docs\/sql\/query_syntax\/from."},{"key":"e_1_3_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247598"},{"key":"e_1_3_2_1_10_1","volume-title":"SQL. In 14th Conference on Innovative Data Systems Research, CIDR 2024","author":"Franz Kai","year":"2024","unstructured":"Kai Franz, Samuel Arch, Denis Hirn, Torsten Grust, Todd C. Mowry, and Andrew Pavlo. 2024. Dear User-Defined Functions, Inlining isn't working out so great for us. Let's try batching to make our relationship work. Sincerely, SQL. In 14th Conference on Innovative Data Systems Research, CIDR 2024. www.cidrdb.org, Chaminade, HI, USA, January 14--17, 2024."},{"key":"e_1_3_2_1_11_1","volume-title":"Proceedings of the 2001 ACM SIGMOD International conference on Management of data. ACM","author":"C\u00e9sar","year":"2001","unstructured":"C\u00e9sar A. Galindo-Legaria and Milind Joshi. 2001. Orthogonal Optimization of Subqueries and Aggregation. In Proceedings of the 2001 ACM SIGMOD International conference on Management of data. ACM, Santa Barbara, CA, USA, May 21--24, 2001, 571--581."},{"key":"e_1_3_2_1_12_1","unstructured":"Google. 2024. Query syntax in GoogleSQL. https:\/\/cloud.google.com\/spanner\/docs\/reference\/standard-sql\/query-syntax#correlated_join."},{"key":"e_1_3_2_1_13_1","volume-title":"Executing Nested Queries. In BTW","volume":"77","author":"Graefe Goetz","year":"2003","unstructured":"Goetz Graefe. 2003. Executing Nested Queries. In BTW 2003, Datenbanksysteme f\u00fcr Business, Technologie und Web, Tagungsband der 10. BTW-Konferenz (LNI, Vol. P-26), Gerhard Weikum, Harald Sch\u00f6ning, and Erhard Rahm (Eds.). GI, Leipzig, Germany, 58--77."},{"key":"e_1_3_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.14778\/3457390.3457402"},{"key":"e_1_3_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.14778\/1453856.1453975"},{"key":"e_1_3_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.5555\/1286760.1286782"},{"key":"e_1_3_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/319732.319745"},{"key":"e_1_3_2_1_18_1","unstructured":"Microsoft. 2023. SQL Server documentation. https:\/\/learn.microsoft.com\/en-us\/sql\/t-sql\/queries\/from-transact-sql?view=sql-server-ver16#using-apply."},{"key":"e_1_3_2_1_19_1","unstructured":"Microsoft. 2024. SQL Server documentation. https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/showplan-logical-and-physical-operators-reference?view=sql-server-ver16#operator-descriptions."},{"key":"e_1_3_2_1_20_1","volume-title":"Datenbanksysteme f\u00fcr Business, Technologie und Web (BTW), 16. Fachtagung des GI-Fachbereichs ''Datenbanken und Informationssysteme'' (DBIS), 4.-6.3.2015 (LNI","author":"Neumann Thomas","unstructured":"Thomas Neumann and Alfons Kemper. 2015. Unnesting Arbitrary Queries. In Datenbanksysteme f\u00fcr Business, Technologie und Web (BTW), 16. Fachtagung des GI-Fachbereichs ''Datenbanken und Informationssysteme'' (DBIS), 4.-6.3.2015 (LNI, Vol. P-241). GI, Hamburg, Germany, 383--402. https:\/\/dl.gi.de\/handle\/20.500.12116\/2418"},{"key":"e_1_3_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/3186728.3164140"},{"key":"e_1_3_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.1996.492194"},{"key":"e_1_3_2_1_23_1","volume-title":"4th International Conference on Extending Database Technology (Lecture Notes in Computer Science","volume":"350","author":"Steenhagen Hennie J.","unstructured":"Hennie J. Steenhagen, Peter M. G. Apers, and Henk M. Blanken. 1994. Optimization of Nested Queries in a Complex Object Model. In Advances in Database Technology - EDBT'94. 4th International Conference on Extending Database Technology (Lecture Notes in Computer Science, Vol. 779), Matthias Jarke, Janis A. Bubenko Jr., and Keith G. Jeffery (Eds.). Springer, Cambridge, United Kingdom, 337--350."},{"key":"e_1_3_2_1_24_1","unstructured":"TPC. 2023. TPC-DS Benchmark. https:\/\/www.tpc.org\/tpcds\/."}],"event":{"name":"SIGMOD\/PODS '25: International Conference on Management of Data","location":"Berlin Germany","acronym":"SIGMOD\/PODS '25","sponsor":["SIGMOD ACM Special Interest Group on Management of Data"]},"container-title":["Companion of the 2025 International Conference on Management of Data"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3722212.3724448","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,9,10]],"date-time":"2025-09-10T22:37:30Z","timestamp":1757543850000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3722212.3724448"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,6,22]]},"references-count":24,"alternative-id":["10.1145\/3722212.3724448","10.1145\/3722212"],"URL":"https:\/\/doi.org\/10.1145\/3722212.3724448","relation":{},"subject":[],"published":{"date-parts":[[2025,6,22]]},"assertion":[{"value":"2025-06-22","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}