{"id":"https://openalex.org/W2422562092","doi":"https://doi.org/10.1109/icde.2016.7498323","title":"SQL-SA for big data discovery polymorphic and parallelizable SQL user-defined scalar and aggregate infrastructure in Teradata Aster 6.20","display_name":"SQL-SA for big data discovery polymorphic and parallelizable SQL user-defined scalar and aggregate infrastructure in Teradata Aster 6.20","publication_year":2016,"publication_date":"2016-05-01","ids":{"openalex":"https://openalex.org/W2422562092","doi":"https://doi.org/10.1109/icde.2016.7498323","mag":"2422562092"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2016.7498323","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2016.7498323","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2016 IEEE 32nd International Conference on Data Engineering (ICDE)","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/A5101650475","display_name":"Xin Tang","orcid":"https://orcid.org/0000-0002-3810-7386"},"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":"Xin Tang","raw_affiliation_strings":["Teradata Aster, San Carlos, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, San Carlos, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5024182007","display_name":"Robert Wehrmeister","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":"Robert Wehrmeister","raw_affiliation_strings":["Teradata Aster, San Carlos, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, San Carlos, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5067872485","display_name":"James Shau","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":"James Shau","raw_affiliation_strings":["Teradata Aster, San Carlos, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, San Carlos, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5091420972","display_name":"Abhirup Chakraborty","orcid":"https://orcid.org/0000-0001-7252-3175"},"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":"Abhirup Chakraborty","raw_affiliation_strings":["Teradata Aster, San Carlos, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, San Carlos, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5043088883","display_name":"Daley Alex","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":"Daley Alex","raw_affiliation_strings":["Teradata Aster, San Carlos, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, San Carlos, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5007306325","display_name":"Awny Al Omari","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":"Awny Al Omari","raw_affiliation_strings":["Teradata Aster, San Carlos, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, San Carlos, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5068210336","display_name":"Feven Atnafu","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":"Feven Atnafu","raw_affiliation_strings":["Teradata Aster, San Carlos, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, San Carlos, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5029011871","display_name":"Jeff Davis","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":"Jeff Davis","raw_affiliation_strings":["Teradata Aster, San Carlos, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, San Carlos, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5045696914","display_name":"Litao Deng","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":"Litao Deng","raw_affiliation_strings":["Teradata Aster, San Carlos, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, San Carlos, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5068981859","display_name":"Deepak Jaiswal","orcid":"https://orcid.org/0000-0002-4077-3919"},"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":"Deepak Jaiswal","raw_affiliation_strings":["Teradata Aster, San Carlos, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, San Carlos, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5012778634","display_name":"Chittaranjan Keswani","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":"Chittaranjan Keswani","raw_affiliation_strings":["Teradata Aster, San Carlos, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, San Carlos, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5029506224","display_name":"Yafeng Lu","orcid":"https://orcid.org/0000-0002-3978-9550"},"institutions":[{"id":"https://openalex.org/I55732556","display_name":"Arizona State University","ror":"https://ror.org/03efmqc40","country_code":"US","type":"education","lineage":["https://openalex.org/I55732556"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yafeng Lu","raw_affiliation_strings":["Arizona State University, Tempe, AZ, USA"],"affiliations":[{"raw_affiliation_string":"Arizona State University, Tempe, AZ, USA","institution_ids":["https://openalex.org/I55732556"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5006376214","display_name":"Chao Ren","orcid":"https://orcid.org/0000-0002-2591-6619"},"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":"Chao Ren","raw_affiliation_strings":["Teradata Aster, San Carlos, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, San Carlos, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027104585","display_name":"Tom Reyes","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":"Tom Reyes","raw_affiliation_strings":["Teradata Aster, San Carlos, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, San Carlos, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5109527244","display_name":"Kashif Siddiqui","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":"Kashif Siddiqui","raw_affiliation_strings":["Teradata Aster, San Carlos, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, San Carlos, CA, 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/I4210160892","display_name":"Splunk (United States)","ror":"https://ror.org/05tr8ks89","country_code":"US","type":"company","lineage":["https://openalex.org/I4210160892"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"David Simmen","raw_affiliation_strings":["Splunk Inc, San Francisco, CA, USA"],"affiliations":[{"raw_affiliation_string":"Splunk Inc, San Francisco, CA, USA","institution_ids":["https://openalex.org/I4210160892"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069991242","display_name":"Devendra Vidhani","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":"Devendra Vidhani","raw_affiliation_strings":["Teradata Aster, San Carlos, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, San Carlos, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5067621763","display_name":"Ling Wang","orcid":"https://orcid.org/0000-0003-1226-2801"},"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":"Ling Wang","raw_affiliation_strings":["Teradata Aster, San Carlos, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, San Carlos, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101826024","display_name":"Shuai Yang","orcid":"https://orcid.org/0009-0004-5444-7104"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Shuai Yang","raw_affiliation_strings":["Fuzzy Logix, Charlotte, NC, USA"],"affiliations":[{"raw_affiliation_string":"Fuzzy Logix, Charlotte, NC, USA","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5110168041","display_name":"Daniel Yu","orcid":"https://orcid.org/0009-0000-6988-2804"},"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":"Daniel Yu","raw_affiliation_strings":["Teradata Aster, San Carlos, CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Aster, San Carlos, CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":20,"corresponding_author_ids":["https://openalex.org/A5101650475"],"corresponding_institution_ids":["https://openalex.org/I4210158714"],"apc_list":null,"apc_paid":null,"fwci":0.5791,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.70699514,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"12","issue":null,"first_page":"1182","last_page":"1193"},"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.9983999729156494,"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.9983999729156494,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9973000288009644,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T12292","display_name":"Graph Theory and Algorithms","score":0.9965999722480774,"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/computer-science","display_name":"Computer science","score":0.8117357492446899},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.700352132320404},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.5864527821540833},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5236327648162842},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.2784600853919983}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8117357492446899},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.700352132320404},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.5864527821540833},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5236327648162842},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2784600853919983}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde.2016.7498323","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2016.7498323","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2016 IEEE 32nd International Conference on Data Engineering (ICDE)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","score":0.6499999761581421,"id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":15,"referenced_works":["https://openalex.org/W1531910333","https://openalex.org/W1997020216","https://openalex.org/W2024680396","https://openalex.org/W2029866183","https://openalex.org/W2065419751","https://openalex.org/W2067650870","https://openalex.org/W2086906616","https://openalex.org/W2098935637","https://openalex.org/W2110086534","https://openalex.org/W2112485457","https://openalex.org/W2170616854","https://openalex.org/W2173213060","https://openalex.org/W2259857913","https://openalex.org/W4239354938","https://openalex.org/W4245645271"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2748952813","https://openalex.org/W4390608645","https://openalex.org/W4247566972","https://openalex.org/W4394895745","https://openalex.org/W2960264696","https://openalex.org/W3090563135","https://openalex.org/W2497432351","https://openalex.org/W4206777497","https://openalex.org/W2910064364"],"abstract_inverted_index":{"There":[0],"is":[1,187],"increasing":[2],"demand":[3],"to":[4,26,31,69,75,83,99,130,175,190],"integrate":[5,176],"big":[6,23,48,78],"data":[7,24,49,64,73,79,94,173,193],"analytic":[8,29,86,90],"systems":[9],"using":[10,138],"SQL.":[11],"Given":[12],"the":[13,89],"vast":[14],"ecosystem":[15],"of":[16,35],"SQL":[17,20,113,140,183],"applications,":[18],"enabling":[19],"capabilities":[21,129],"allows":[22],"platforms":[25,82],"expose":[27],"their":[28,85],"potential":[30],"a":[32,109,181,200,210],"wide":[33],"variety":[34],"end":[36],"users,":[37],"accelerating":[38],"discovery":[39],"processes":[40],"and":[41,81,101,111,115,127,135,153,161,167,195,205,218],"providing":[42],"significant":[43,211],"business":[44,203],"value.":[45],"Most":[46],"existing":[47],"frameworks":[50],"are":[51,66],"based":[52],"on":[53],"one":[54],"particular":[55],"programming":[56,178],"model":[57],"such":[58],"as":[59],"MapReduce":[60,126,166],"or":[61],"Graph.":[62],"However,":[63],"scientists":[65,174],"often":[67],"forced":[68],"manually":[70],"create":[71],"adhoc":[72],"pipelines":[74,95],"connect":[76],"various":[77],"tools":[80],"serve":[84],"needs.":[87],"When":[88],"tasks":[91],"change,":[92],"these":[93,157],"may":[96],"be":[97],"costly":[98],"modify":[100],"maintain.":[102],"In":[103],"this":[104],"paper":[105],"we":[106],"present":[107],"SQL-SA,":[108],"polymorphic":[110,132],"parallelizable":[112],"scalar":[114,134,160],"aggregate":[116,136,162],"infrastructure":[117,122],"in":[118,180,197],"Aster":[119,124,146,165,170,207],"6.20.":[120],"This":[121],"extends":[123],"6's":[125],"Graph":[128,168],"support":[131],"user-defined":[133,159],"functions":[137,163],"flexible":[139],"syntax.":[141],"The":[142,185],"implementation":[143],"enhances":[144],"main":[145],"components":[147],"including":[148],"query":[149],"syntax,":[150],"API,":[151],"planning":[152],"execution":[154],"extensively.":[155],"Integrating":[156],"new":[158],"with":[164],"functions,":[169],"6.20":[171,208],"enables":[172],"diverse":[177],"models":[179],"single":[182],"statement.":[184],"statement":[186],"automatically":[188],"converted":[189],"an":[191],"optimal":[192],"pipeline":[194],"executed":[196],"parallel.":[198],"Using":[199],"real":[201],"world":[202],"problem":[204],"data,":[206],"demonstrates":[209],"performance":[212],"advantage":[213],"(25%+)":[214],"over":[215],"Hadoop":[216],"Pig":[217],"Hive.":[219]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2019,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}