{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T04:33:13Z","timestamp":1750221193975,"version":"3.41.0"},"publisher-location":"New York, NY, USA","reference-count":9,"publisher":"ACM","license":[{"start":{"date-parts":[[2018,5,27]],"date-time":"2018-05-27T00:00:00Z","timestamp":1527379200000},"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":[[2018,5,27]]},"DOI":"10.1145\/3183713.3193565","type":"proceedings-article","created":{"date-parts":[[2018,5,25]],"date-time":"2018-05-25T12:39:28Z","timestamp":1527251968000},"page":"1705-1708","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":0,"title":["Joins over UNION ALL Queries in Teradata\u00ae"],"prefix":"10.1145","author":[{"given":"Mohammed","family":"Al-Kateb","sequence":"first","affiliation":[{"name":"Teradata Labs, El Segundo, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Paul","family":"Sinclair","sequence":"additional","affiliation":[{"name":"Teradata Labs, El Segundo, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Grace","family":"Au","sequence":"additional","affiliation":[{"name":"Teradata Labs, El Segundo, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Sanjay","family":"Nair","sequence":"additional","affiliation":[{"name":"Teradata Labs, El Segundo, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Mark","family":"Sirek","sequence":"additional","affiliation":[{"name":"Teradata Labs, Rancho Bernardo, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Lu","family":"Ma","sequence":"additional","affiliation":[{"name":"Teradata Labs, Rancho Bernardo, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Mohamed Y.","family":"Eltabakh","sequence":"additional","affiliation":[{"name":"Teradata Labs, El Segundo, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2018,5,27]]},"reference":[{"key":"e_1_3_2_1_1_1","volume-title":"Optimizing UNION ALL Join Queries in Teradata. ICDE","author":"Al-Kateb Mohammed","year":"2017","unstructured":"Mohammed Al-Kateb , Paul Sinclair , Alain Crolotte , Lu Ma , Grace Au , and Sanjay Nair . 2017. Optimizing UNION ALL Join Queries in Teradata. ICDE ( 2017 ). Mohammed Al-Kateb, Paul Sinclair, Alain Crolotte, Lu Ma, Grace Au, and Sanjay Nair. 2017. Optimizing UNION ALL Join Queries in Teradata. ICDE (2017)."},{"key":"e_1_3_2_1_2_1","unstructured":"Teradata Unified Data Architecture. 2016. \"www.teradata.com\/ solutions-and-industries\/unified-data-architecture\". (2016).  Teradata Unified Data Architecture. 2016. \"www.teradata.com\/ solutions-and-industries\/unified-data-architecture\". (2016)."},{"key":"e_1_3_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/191843.191944"},{"key":"e_1_3_2_1_4_1","volume":"200","author":"Ghazal A.S.","unstructured":"A.S. Ghazal and W. J. McKenna. 200 9. Pushing Joins across a Union. (2009). www.google.dj\/patents\/US20090313211. A.S. Ghazal and W.J. McKenna. 2009. Pushing Joins across a Union. (2009). www.google.dj\/patents\/US20090313211.","journal-title":"J. McKenna."},{"volume-title":"TPC-DS Queries","year":"2000","key":"e_1_3_2_1_5_1","unstructured":"GitHub : TPC-DS Queries . 2000 . https:\/\/github.com\/Agirish\/tpcds. (2000). GitHub: TPC-DS Queries. 2000. https:\/\/github.com\/Agirish\/tpcds. (2000)."},{"key":"e_1_3_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/1989323.1989330"},{"key":"e_1_3_2_1_7_1","unstructured":"QueryGrid. 2014. www.teradata.com\/products-and-services\/query-grid. (2014).  QueryGrid. 2014. www.teradata.com\/products-and-services\/query-grid. (2014)."},{"key":"e_1_3_2_1_8_1","unstructured":"H. Su R. Ahmed A. Lee M. Zait and T. Cruanes. 2010. Join Factorization of Union\/Union All Queries. (2010). US Patent 7 644 062.  H. Su R. Ahmed A. Lee M. Zait and T. Cruanes. 2010. Join Factorization of Union\/Union All Queries. (2010). US Patent 7 644 062."},{"key":"e_1_3_2_1_9_1","volume-title":"Partitioning in DB2 Using the UNION ALL View. (July 11","author":"Zuzarte Calisto","year":"2005","unstructured":"Calisto Zuzarte , Robert Neugebauer , Natt Sutyanyong , Xiaoyan Qian , and Berger Rick . 2005. Partitioning in DB2 Using the UNION ALL View. (July 11 2005 ). www.ibm.com\/developerworks\/data\/library\/techarticle\/dm-0202zuzarte. Calisto Zuzarte, Robert Neugebauer, Natt Sutyanyong, Xiaoyan Qian, and Berger Rick. 2005. Partitioning in DB2 Using the UNION ALL View. (July 11 2005). www.ibm.com\/developerworks\/data\/library\/techarticle\/dm-0202zuzarte."}],"event":{"name":"SIGMOD\/PODS '18: International Conference on Management of Data","sponsor":["SIGMOD ACM Special Interest Group on Management of Data"],"location":"Houston TX USA","acronym":"SIGMOD\/PODS '18"},"container-title":["Proceedings of the 2018 International Conference on Management of Data"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3183713.3193565","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3183713.3193565","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T01:39:17Z","timestamp":1750210757000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3183713.3193565"}},"subtitle":["Demonstration of Optimized Execution"],"short-title":[],"issued":{"date-parts":[[2018,5,27]]},"references-count":9,"alternative-id":["10.1145\/3183713.3193565","10.1145\/3183713"],"URL":"https:\/\/doi.org\/10.1145\/3183713.3193565","relation":{},"subject":[],"published":{"date-parts":[[2018,5,27]]},"assertion":[{"value":"2018-05-27","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}