{"id":"https://openalex.org/W2798820143","doi":"https://doi.org/10.1145/3183713.3193565","title":"Joins over UNION ALL Queries in Teradata\u00ae","display_name":"Joins over UNION ALL Queries in Teradata\u00ae","publication_year":2018,"publication_date":"2018-05-25","ids":{"openalex":"https://openalex.org/W2798820143","doi":"https://doi.org/10.1145/3183713.3193565","mag":"2798820143"},"language":"en","primary_location":{"id":"doi:10.1145/3183713.3193565","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3183713.3193565","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2018 International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5012231119","display_name":"Mohammed Al-Kateb","orcid":null},"institutions":[{"id":"https://openalex.org/I4210158714","display_name":"Teradata (United States)","ror":"https://ror.org/04vkkat38","country_code":"US","type":"company","lineage":["https://openalex.org/I4210158714"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Mohammed Al-Kateb","raw_affiliation_strings":["Teradata Labs, El Segundo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Labs, El Segundo, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5000582349","display_name":"Paul Sinclair","orcid":null},"institutions":[{"id":"https://openalex.org/I4210158714","display_name":"Teradata (United States)","ror":"https://ror.org/04vkkat38","country_code":"US","type":"company","lineage":["https://openalex.org/I4210158714"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Paul Sinclair","raw_affiliation_strings":["Teradata Labs, El Segundo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Labs, El Segundo, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5108760137","display_name":"Grace Au","orcid":null},"institutions":[{"id":"https://openalex.org/I4210158714","display_name":"Teradata (United States)","ror":"https://ror.org/04vkkat38","country_code":"US","type":"company","lineage":["https://openalex.org/I4210158714"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Grace Au","raw_affiliation_strings":["Teradata Labs, El Segundo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Labs, El Segundo, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5112480765","display_name":"Sanjay Nair","orcid":null},"institutions":[{"id":"https://openalex.org/I4210158714","display_name":"Teradata (United States)","ror":"https://ror.org/04vkkat38","country_code":"US","type":"company","lineage":["https://openalex.org/I4210158714"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sanjay Nair","raw_affiliation_strings":["Teradata Labs, El Segundo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Labs, El Segundo, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5039009041","display_name":"Mark Sirek","orcid":null},"institutions":[{"id":"https://openalex.org/I4210158714","display_name":"Teradata (United States)","ror":"https://ror.org/04vkkat38","country_code":"US","type":"company","lineage":["https://openalex.org/I4210158714"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mark Sirek","raw_affiliation_strings":["Teradata Labs, Rancho Bernardo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Labs, Rancho Bernardo, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5110796347","display_name":"Lu Ma","orcid":null},"institutions":[{"id":"https://openalex.org/I4210158714","display_name":"Teradata (United States)","ror":"https://ror.org/04vkkat38","country_code":"US","type":"company","lineage":["https://openalex.org/I4210158714"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Lu Ma","raw_affiliation_strings":["Teradata Labs, Rancho Bernardo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Labs, Rancho Bernardo, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5074322354","display_name":"Mohamed Y. Eltabakh","orcid":"https://orcid.org/0000-0002-6344-8246"},"institutions":[{"id":"https://openalex.org/I4210158714","display_name":"Teradata (United States)","ror":"https://ror.org/04vkkat38","country_code":"US","type":"company","lineage":["https://openalex.org/I4210158714"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mohamed Y. Eltabakh","raw_affiliation_strings":["Teradata Labs, El Segundo, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Labs, El Segundo, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5012231119"],"corresponding_institution_ids":["https://openalex.org/I4210158714"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.04484754,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"200","issue":null,"first_page":"1705","last_page":"1708"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9986000061035156,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10799","display_name":"Data Visualization and Analytics","score":0.9940000176429749,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.9113162755966187},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8151506185531616},{"id":"https://openalex.org/keywords/rendering","display_name":"Rendering (computer graphics)","score":0.6523439288139343},{"id":"https://openalex.org/keywords/metadata","display_name":"Metadata","score":0.5661218166351318},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.5591663718223572},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.549635648727417},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.4880179464817047},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.4104345440864563},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.39137163758277893},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3846651613712311},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.1639341115951538},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.1335315704345703},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.10402774810791016}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.9113162755966187},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8151506185531616},{"id":"https://openalex.org/C205711294","wikidata":"https://www.wikidata.org/wiki/Q176953","display_name":"Rendering (computer graphics)","level":2,"score":0.6523439288139343},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.5661218166351318},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.5591663718223572},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.549635648727417},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4880179464817047},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.4104345440864563},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.39137163758277893},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3846651613712311},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1639341115951538},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.1335315704345703},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.10402774810791016},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3183713.3193565","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3183713.3193565","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2018 International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.550000011920929,"display_name":"Life in Land","id":"https://metadata.un.org/sdg/15"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":5,"referenced_works":["https://openalex.org/W1621358038","https://openalex.org/W1976625500","https://openalex.org/W2040428289","https://openalex.org/W2210805426","https://openalex.org/W3012414718"],"related_works":["https://openalex.org/W2393491644","https://openalex.org/W4206577045","https://openalex.org/W3086237447","https://openalex.org/W650102067","https://openalex.org/W1550806730","https://openalex.org/W2589740103","https://openalex.org/W2172084996","https://openalex.org/W1966967794","https://openalex.org/W1501284171","https://openalex.org/W2397450670"],"abstract_inverted_index":{"The":[0],"UNION":[1,31,59,75,107],"ALL":[2,32,60,76,108],"set":[3,168],"operator":[4],"is":[5,25],"useful":[6],"for":[7,55,182,191],"combining":[8],"data":[9,20,24],"from":[10],"multiple":[11,29,140,145],"sources.":[12],"With":[13],"the":[14,67,122,155,159,176],"emergence":[15],"and":[16,62,69,142,186],"prevalence":[17],"of":[18,66,72,104,121,135,169,173,178],"big":[19],"ecosystems":[21],"in":[22,38,52,97],"which":[23,87,164],"typically":[26],"stored":[27],"on":[28],"systems,":[30],"has":[33],"become":[34],"even":[35],"more":[36],"important":[37],"many":[39],"analytical":[40],"queries.":[41],"In":[42,154],"this":[43],"project,":[44],"we":[45,92,157],"demonstrate":[46,93],"novel":[47],"cost-based":[48],"optimization":[49],"techniques":[50,95],"implemented":[51],"Teradata":[53,98,160],"Database":[54,99],"join":[56,85,116,133,138,146,152],"queries":[57],"involving":[58],"views":[61],"derived":[63],"tables.":[64],"Instead":[65],"naive":[68],"traditional":[70],"way":[71],"spooling":[73],"each":[74,183],"branch":[77],"to":[78,83,115,125,139],"a":[79,136,149,166],"common":[80],"spool":[81],"prior":[82,114],"performing":[84],"operations,":[86],"can":[88],"be":[89],"prohibitively":[90],"expensive,":[91],"new":[94],"developed":[96],"including:":[100],"1)":[101],"Cost-based":[102],"pushing":[103],"joins":[105],"into":[106,148],"branches,":[109],"2)":[110],"Branch":[111],"grouping":[112],"strategy":[113],"pushing,":[117],"3)":[118],"Geography":[119],"adjustment":[120],"pushed":[123,137],"relations":[124],"avoid":[126],"unnecessary":[127],"redistribution":[128],"or":[129],"duplication,":[130],"4)":[131],"Iterative":[132],"decomposition":[134],"joins,":[141],"5)":[143],"Combining":[144],"steps":[147],"single":[150],"multisource":[151],"step.":[153],"demonstration,":[156],"use":[158],"Visual":[161],"Explain":[162],"tool,":[163],"offers":[165],"rich":[167],"visual":[170],"rendering":[171],"capabilities":[172],"query":[174],"plans,":[175],"display":[177],"various":[179],"metadata":[180],"information":[181],"plan":[184],"step,":[185],"several":[187],"interactive":[188],"UGI":[189],"options":[190],"end-users.":[192]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}