{"id":"https://openalex.org/W1531910333","doi":"https://doi.org/10.1109/icde.2015.7113378","title":"Accelerating Big Data analytics with Collaborative Planning in Teradata Aster 6","display_name":"Accelerating Big Data analytics with Collaborative Planning in Teradata Aster 6","publication_year":2015,"publication_date":"2015-04-01","ids":{"openalex":"https://openalex.org/W1531910333","doi":"https://doi.org/10.1109/icde.2015.7113378","mag":"1531910333"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2015.7113378","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2015.7113378","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 IEEE 31st International Conference on Data Engineering","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/A5028316643","display_name":"Aditi Pandit","orcid":"https://orcid.org/0009-0003-9361-5521"},"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":"Aditi Pandit","raw_affiliation_strings":["Teradata Aster, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5087185379","display_name":"Derrick Kondo","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":"Derrick Kondo","raw_affiliation_strings":["Teradata Aster, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5020641159","display_name":"David Simmen","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":"David Simmen","raw_affiliation_strings":["Teradata Aster, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5036218679","display_name":"Anjali Norwood","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":"Anjali Norwood","raw_affiliation_strings":["Teradata Aster, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5109351823","display_name":"Tongxin Bai","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":"Tongxin Bai","raw_affiliation_strings":["Teradata Aster, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, USA","institution_ids":["https://openalex.org/I4210158714"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5028316643"],"corresponding_institution_ids":["https://openalex.org/I4210158714"],"apc_list":null,"apc_paid":null,"fwci":0.6656,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.72357639,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"18","issue":null,"first_page":"1304","last_page":"1315"},"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.9987000226974487,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.998199999332428,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8697803020477295},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6259392499923706},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.6239858865737915},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.5966236591339111},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.5560116171836853},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5115114450454712},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4817492961883545},{"id":"https://openalex.org/keywords/implementation","display_name":"Implementation","score":0.4653549790382385},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.4303795099258423},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.417636513710022},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.26340949535369873},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.26195400953292847},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.22474828362464905},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.18423515558242798},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.1530238687992096}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8697803020477295},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6259392499923706},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.6239858865737915},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.5966236591339111},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.5560116171836853},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5115114450454712},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4817492961883545},{"id":"https://openalex.org/C26713055","wikidata":"https://www.wikidata.org/wiki/Q245962","display_name":"Implementation","level":2,"score":0.4653549790382385},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.4303795099258423},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.417636513710022},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.26340949535369873},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.26195400953292847},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.22474828362464905},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.18423515558242798},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.1530238687992096},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde.2015.7113378","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2015.7113378","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 IEEE 31st International Conference on Data Engineering","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","score":0.46000000834465027,"id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":20,"referenced_works":["https://openalex.org/W135863099","https://openalex.org/W1519876418","https://openalex.org/W1756536912","https://openalex.org/W2029036662","https://openalex.org/W2036971997","https://openalex.org/W2079806729","https://openalex.org/W2109025447","https://openalex.org/W2112485457","https://openalex.org/W2134876510","https://openalex.org/W2147722789","https://openalex.org/W2151251992","https://openalex.org/W2153329411","https://openalex.org/W2160963784","https://openalex.org/W2173213060","https://openalex.org/W2296349066","https://openalex.org/W3009408579","https://openalex.org/W6605485969","https://openalex.org/W6631248092","https://openalex.org/W6676247822","https://openalex.org/W6680052129"],"related_works":["https://openalex.org/W1977331029","https://openalex.org/W50436801","https://openalex.org/W1943557536","https://openalex.org/W2941854747","https://openalex.org/W4361194359","https://openalex.org/W4379799305","https://openalex.org/W2168708570","https://openalex.org/W2051852836","https://openalex.org/W1968775523","https://openalex.org/W4230252752"],"abstract_inverted_index":{"The":[0,113,163],"volume,":[1],"velocity,":[2],"and":[3,13,55,80,91,133,154,176,182,195,224],"variety":[4],"of":[5,11,20,93,124,130,143,151,159,165,185,206,226],"Big":[6,61],"Data":[7,62],"necessitate":[8],"the":[9,89,121,128,149,166,174,177,193,196,204,207,222,230],"development":[10],"new":[12],"innovative":[14,141],"data":[15,34],"processing":[16,74],"software.":[17],"A":[18],"multitude":[19],"SQL":[21,46,110],"implementations":[22,47],"on":[23],"distributed":[24],"systems":[25],"have":[26],"emerged":[27],"in":[28,40,44,60,148,218,229,251,256],"recent":[29],"years":[30],"to":[31,52,71,107,118,210],"enable":[32],"large-scale":[33],"analysis.":[35],"User-Defined":[36],"Table":[37,65],"operators":[38,66,96],"(written":[39],"procedural":[41],"languages)":[42],"embedded":[43,213],"these":[45,94,200],"are":[48,190],"a":[49,104,108,155,170,257],"powerful":[50],"mechanism":[51],"succinctly":[53],"express":[54],"perform":[56],"analytic":[57],"operations":[58,153,189],"typical":[59,109],"discovery":[63],"workloads.":[64],"can":[67],"be":[68],"easily":[69],"customized":[70],"implement":[72],"different":[73],"models":[75],"such":[76],"as":[77,100,103,247,249],"map,":[78],"reduce":[79],"graph":[81],"execution.":[82],"Despite":[83],"an":[84,140],"inherently":[85],"parallel":[86],"execution":[87,245],"model,":[88],"performance":[90],"scalability":[92],"table":[95,125,178,197,208],"is":[97,115,221],"greatly":[98],"restricted":[99],"they":[101],"appear":[102],"black":[105],"box":[106],"query":[111,160,167,187,244],"optimizer.":[112],"optimizer":[114,194],"not":[116],"able":[117],"infer":[119],"even":[120],"basic":[122],"properties":[123,181,201],"operators,":[126],"prohibiting":[127],"application":[129],"optimization":[131,164],"rules":[132],"strategies.":[134],"In":[135],"this":[136,219],"paper,":[137],"we":[138,238],"introduce":[139],"concept":[142],"\u201cCollaborative":[144],"Planning\u201d,":[145],"which":[146],"results":[147],"removal":[150],"redundant":[152],"more":[156],"optimal":[157],"rearrangement":[158],"plan":[161,188],"operators.":[162],"proceeds":[168],"through":[169],"collaborative":[171],"exchange":[172],"between":[173,192],"planner":[175],"operator.":[179,198],"Plan":[180],"context":[183],"information":[184],"surrounding":[186],"exchanged":[191],"Knowing":[199],"also":[202],"allows":[203],"author":[205],"operator":[209],"optimize":[211],"its":[212],"logic.":[214],"Our":[215],"main":[216],"contribution":[217],"paper":[220],"design":[223],"implementation":[225],"Collaborative":[227,241],"Planning":[228,242],"Teradata":[231],"Aster":[232],"6":[233],"system.":[234],"Using":[235],"real-world":[236],"workloads,":[237],"show":[239],"that":[240],"reduces":[243],"times":[246],"much":[248],"90.0%":[250],"common":[252],"use":[253],"cases,":[254],"resulting":[255],"24x":[258],"speedup.":[259]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2016,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}