{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,1]],"date-time":"2026-06-01T20:37:26Z","timestamp":1780346246275,"version":"3.54.1"},"publisher-location":"New York, NY, USA","reference-count":26,"publisher":"ACM","license":[{"start":{"date-parts":[[2024,6,9]],"date-time":"2024-06-09T00:00:00Z","timestamp":1717891200000},"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":[[2024,6,9]]},"DOI":"10.1145\/3626246.3653369","type":"proceedings-article","created":{"date-parts":[[2024,5,23]],"date-time":"2024-05-23T10:26:39Z","timestamp":1716459999000},"page":"18-30","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":7,"title":["Unified Query Optimization 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":[{"vocabulary":"crossref","role":"author"}]},{"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":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0009-0001-0769-1700","authenticated-orcid":false,"given":"Milind","family":"Joshi","sequence":"additional","affiliation":[{"name":"Microsoft, Redmond, WA, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0009-0002-3769-6526","authenticated-orcid":false,"given":"Esteban","family":"Calvo Vargas","sequence":"additional","affiliation":[{"name":"Microsoft, Redmond, WA, United States"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0009-0002-7194-030X","authenticated-orcid":false,"given":"Kabita","family":"Mahapatra","sequence":"additional","affiliation":[{"name":"Microsoft, Redmond, WA, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0009-0009-3833-8035","authenticated-orcid":false,"given":"Sharon","family":"Ravindran","sequence":"additional","affiliation":[{"name":"Microsoft, Redmond, WA, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0009-0008-8711-4567","authenticated-orcid":false,"given":"Guoheng","family":"Chen","sequence":"additional","affiliation":[{"name":"Microsoft, Redmond, WA, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-4808-4082","authenticated-orcid":false,"given":"Ernesto","family":"Cervantes Ju\u00e1rez","sequence":"additional","affiliation":[{"name":"Microsoft, Redmond, WA, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0009-0008-8115-7021","authenticated-orcid":false,"given":"Beysim","family":"Sezgin","sequence":"additional","affiliation":[{"name":"Microsoft, Redmond, WA, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2024,6,9]]},"reference":[{"key":"e_1_3_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415545"},{"key":"e_1_3_2_1_2_1","volume-title":"Extending Polaris To Support Transactions. In SIGMOD '24: International Conference on Management of Data. ACM","author":"Aguilar-Saborit Josep","year":"2024","unstructured":"Josep Aguilar-Saborit, Raghu Ramakrishnan, Kevin Bocksrocker, Alan Halverson, Konstantin Kosinsky, Ryan O'Connor, Nadejda Poliakova, Moe Shafiei, Haris Mahmood Ansari, Bogdan Crivat, Conor Cunningham, Taewoo Kim, Phil Kon Kim, Ishan Rajesh Madan, Blazej Matuszyk, Matt Miles, Sumin Mohanan, Cristian Petculescu, Emma Rose Wirshing, and Elias Yousefi Amin Abadi. 2024. Extending Polaris To Support Transactions. In SIGMOD '24: International Conference on Management of Data. ACM, Santiago, Chile, June 9 - June 25, 2024."},{"key":"e_1_3_2_1_3_1","volume-title":"Amazon Redshift Re-invented. In SIGMOD '22: International Conference on Management of Data. ACM","author":"Armenatzoglou Nikos","year":"2022","unstructured":"Nikos Armenatzoglou, Sanuj Basu, Naga Bhanoori, Mengchu Cai, Naresh Chainani, Kiran Chinta, Venkatraman Govindaraju, Todd J. Green, Monish Gupta, Sebastian Hillig, Eric Hotinger, Yan Leshinksy, Jintian Liang, Michael McCreedy, Fabian Nagel, Ippokratis Pandis, Panos Parchas, Rahul Pathak, Orestis Polychroniou, Foyzur Rahman, Gaurav Saxena, Gokul Soundararajan, Sriram Subramanian, and Doug Terry. 2022. Amazon Redshift Re-invented. In SIGMOD '22: International Conference on Management of Data. ACM, Philadelphia, PA, USA, June 12 - 17, 2022, 2205--2217."},{"key":"e_1_3_2_1_4_1","volume-title":"A TPC-D Model for Database Query Optimization in Cascades. Master's thesis","author":"Billings Keith","unstructured":"Keith Billings. 1997. A TPC-D Model for Database Query Optimization in Cascades. Master's thesis. Portland State University."},{"key":"e_1_3_2_1_5_1","volume-title":"VLDB'96","author":"Celis Pedro","year":"1996","unstructured":"Pedro Celis. 1996. The Query Optimizer in Tandem's new ServerWare SQL Product. In VLDB'96, Proceedings of 22th International Conference on Very Large Data Bases. Morgan Kaufmann, Mumbai (Bombay), India, 592."},{"key":"e_1_3_2_1_6_1","volume-title":"The Snowflake Elastic Data Warehouse. In SIGMOD '16: International Conference on Management of Data. ACM","author":"Cruanes Thierry","year":"2016","unstructured":"Beno^i t Dageville, Thierry Cruanes, Marcin Zukowski, Vadim Antonov, Artin Avanes, Jon Bock, Jonathan Claybaugh, Daniel Engovatov, Martin Hentschel, Jiansheng Huang, Allison W. Lee, Ashish Motivala, Abdul Q. Munir, Steven Pelley, Peter Povinec, Greg Rahn, Spyridon Triantafyllis, and Philipp Unterbrunner. 2016. The Snowflake Elastic Data Warehouse. In SIGMOD '16: International Conference on Management of Data. ACM, San Francisco, CA, USA, June 26 - July 01, 2016, 215--226."},{"key":"e_1_3_2_1_7_1","unstructured":"delta-io. 2020. Delta Lake. https:\/\/github.com\/delta-io\/delta."},{"key":"e_1_3_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/1385269.1385273"},{"key":"e_1_3_2_1_9_1","unstructured":"Apache Software Foundation. 2021. Apache Parquet. https:\/\/parquet.apache.org."},{"key":"e_1_3_2_1_10_1","first-page":"19","article-title":"The Cascades Framework for Query Optimization","volume":"18","author":"Graefe Goetz","year":"1995","unstructured":"Goetz Graefe. 1995. The Cascades Framework for Query Optimization. IEEE Data Eng. Bull. , Vol. 18, 3 (1995), 19--29.","journal-title":"IEEE Data Eng. Bull."},{"key":"e_1_3_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.1996.492100"},{"key":"e_1_3_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415568"},{"key":"e_1_3_2_1_13_1","volume-title":"Understanding the New SQL: A Complete Guide","author":"Melton Jim","unstructured":"Jim Melton. 2000. Understanding the New SQL: A Complete Guide, Second Edition, Volume I. Morgan Kaufmann, Ed."},{"key":"e_1_3_2_1_14_1","unstructured":"Microsoft. 2022. Azure Synapse SQL architecture. https:\/\/learn.microsoft.com\/en-us\/azure\/synapse-analytics\/sql\/overview-architecture."},{"key":"e_1_3_2_1_15_1","unstructured":"Microsoft. 2023 a. https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/performance\/live-query-statistics. https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/performance\/live-query-statistics."},{"key":"e_1_3_2_1_16_1","unstructured":"Microsoft. 2023 b. Microsoft Fabric. https:\/\/www.microsoft.com\/en-us\/microsoft-fabric."},{"key":"e_1_3_2_1_17_1","unstructured":"Microsoft. 2023 c. Optimized plan forcing with Query Store. https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/performance\/optimized-plan-forcing-query-store."},{"key":"e_1_3_2_1_18_1","volume-title":"Cloud-Native Transactions and Analytics in SingleStore. In SIGMOD '22: International Conference on Management of Data, Zachary G. Ives, Angela Bonifati, and Amr El Abbadi (Eds.). ACM","author":"Prout Adam","year":"2022","unstructured":"Adam Prout, Szu-Po Wang, Joseph Victor, Zhou Sun, Yongzhu Li, Jack Chen, Evan Bergeron, Eric N. Hanson, Robert Walzer, Rodrigo Gomes, and Nikita Shamgunov. 2022. Cloud-Native Transactions and Analytics in SingleStore. In SIGMOD '22: International Conference on Management of Data, Zachary G. Ives, Angela Bonifati, and Amr El Abbadi (Eds.). ACM, Philadelphia, PA, USA, June 12 - 17, 2022, 2340--2352."},{"key":"e_1_3_2_1_19_1","volume-title":"SIGMOD '79: International Conference on Management of Data. ACM","author":"Selinger Patricia G.","unstructured":"Patricia G. Selinger, Morton M. Astrahan, Donald D. Chamberlin, Raymond A. Lorie, and Thomas G. Price. 1979. Access Path Selection in a Relational Database Management System. In SIGMOD '79: International Conference on Management of Data. ACM, Boston, Massachusetts, USA, 23--34."},{"key":"e_1_3_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1145\/2213836.2213953"},{"key":"e_1_3_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/2588555.2595637"},{"key":"e_1_3_2_1_22_1","volume-title":"Substrait: Cross-Language Serialization for Relational Algebra. https:\/\/github.com\/substrait-io\/substrait.","year":"2021","unstructured":"substrait-io. 2021. Substrait: Cross-Language Serialization for Relational Algebra. https:\/\/github.com\/substrait-io\/substrait."},{"key":"e_1_3_2_1_23_1","unstructured":"Teradata. 2016. Teradata Unified Data Architecture. www.teradata.com\/ solutions-and-industries\/unified-data-architecture."},{"key":"e_1_3_2_1_24_1","unstructured":"TPC. 2023. TPC Benchmarks. https:\/\/www.tpc.org\/."},{"key":"e_1_3_2_1_25_1","volume-title":"Beyond Conventional Data Warehousing - Massively Parallel Data Processing with Greenplum Database. In Business Intelligence for the Real-Time Enterprise BIRTE. Springer","author":"Waas Florian M.","year":"2008","unstructured":"Florian M. Waas. 2008. Beyond Conventional Data Warehousing - Massively Parallel Data Processing with Greenplum Database. In Business Intelligence for the Real-Time Enterprise BIRTE. Springer, Auckland, New Zealand, 89--96."},{"key":"e_1_3_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-012-0280-z"}],"event":{"name":"SIGMOD\/PODS '24: International Conference on Management of Data","location":"Santiago AA Chile","acronym":"SIGMOD\/PODS '24","sponsor":["SIGMOD ACM Special Interest Group on Management of Data"]},"container-title":["Companion of the 2024 International Conference on Management of Data"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3626246.3653369","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3626246.3653369","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,8,22]],"date-time":"2025-08-22T11:29:09Z","timestamp":1755862149000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3626246.3653369"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024,6,9]]},"references-count":26,"alternative-id":["10.1145\/3626246.3653369","10.1145\/3626246"],"URL":"https:\/\/doi.org\/10.1145\/3626246.3653369","relation":{},"subject":[],"published":{"date-parts":[[2024,6,9]]},"assertion":[{"value":"2024-06-09","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}