{"id":"https://openalex.org/W2816443788","doi":"https://doi.org/10.1145/3221269.3223041","title":"Optimizer time estimation for SQL queries","display_name":"Optimizer time estimation for SQL queries","publication_year":2018,"publication_date":"2018-07-09","ids":{"openalex":"https://openalex.org/W2816443788","doi":"https://doi.org/10.1145/3221269.3223041","mag":"2816443788"},"language":"en","primary_location":{"id":"doi:10.1145/3221269.3223041","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3221269.3223041","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 30th International Conference on Scientific and Statistical Database Management","raw_type":"proceedings-article"},"type":"conference-paper","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/A5023002176","display_name":"Ramesh Bhashyam","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Bhashyam Ramesh","raw_affiliation_strings":["Teradata India Pvt. Ltd"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Teradata India Pvt. Ltd","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5081351816","display_name":"C Jaiprakash","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"C Jaiprakash","raw_affiliation_strings":["Teradata India Pvt. Ltd"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Teradata India Pvt. Ltd","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035329722","display_name":"Naveen Sankaran","orcid":"https://orcid.org/0000-0003-3318-4443"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Naveen Sankaran","raw_affiliation_strings":["Teradata India Pvt. Ltd"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Teradata India Pvt. Ltd","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5007487076","display_name":"Jitendra Yasaswi","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jitendra Yasaswi","raw_affiliation_strings":["Teradata India Pvt. Ltd"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Teradata India Pvt. Ltd","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.0595354,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"4"},"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.9973000288009644,"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.9973000288009644,"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/T12016","display_name":"Web Data Mining and Analysis","score":0.9936000108718872,"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/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.9883999824523926,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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.9335594177246094},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.7615310549736023},{"id":"https://openalex.org/keywords/parsing","display_name":"Parsing","score":0.6055933833122253},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5982553362846375},{"id":"https://openalex.org/keywords/execution-time","display_name":"Execution time","score":0.5472814440727234},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.49568283557891846},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.4628668427467346},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.4592457115650177},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.45635417103767395},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.443158894777298},{"id":"https://openalex.org/keywords/speedup","display_name":"Speedup","score":0.42985284328460693},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3707340955734253},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.36335232853889465},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.2991575598716736},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.24763190746307373},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2433585524559021},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.1750841736793518},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.14112120866775513}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9335594177246094},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.7615310549736023},{"id":"https://openalex.org/C186644900","wikidata":"https://www.wikidata.org/wiki/Q194152","display_name":"Parsing","level":2,"score":0.6055933833122253},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5982553362846375},{"id":"https://openalex.org/C2989134064","wikidata":"https://www.wikidata.org/wiki/Q288510","display_name":"Execution time","level":2,"score":0.5472814440727234},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.49568283557891846},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4628668427467346},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.4592457115650177},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.45635417103767395},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.443158894777298},{"id":"https://openalex.org/C68339613","wikidata":"https://www.wikidata.org/wiki/Q1549489","display_name":"Speedup","level":2,"score":0.42985284328460693},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3707340955734253},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.36335232853889465},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2991575598716736},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.24763190746307373},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2433585524559021},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.1750841736793518},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.14112120866775513}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3221269.3223041","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3221269.3223041","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 30th International Conference on Scientific and Statistical Database Management","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":4,"referenced_works":["https://openalex.org/W1522301498","https://openalex.org/W2081728040","https://openalex.org/W2103702871","https://openalex.org/W2532136333"],"related_works":["https://openalex.org/W319014924","https://openalex.org/W906795786","https://openalex.org/W1548279772","https://openalex.org/W2955368753","https://openalex.org/W2897196530","https://openalex.org/W2970853428","https://openalex.org/W2094438898","https://openalex.org/W2406556739","https://openalex.org/W2152149667","https://openalex.org/W2106125778"],"abstract_inverted_index":{"Predicting":[0,77],"the":[1,18,40,48,52,62,66,71,82,91,131,170,177,208,219,242],"amount":[2],"of":[3,26,33,65,74,138,197,205],"time":[4,32,41,49,73,79,89,97,118,144,159,179,245],"a":[5,34,45,75,203,214],"SQL":[6,209,247],"query":[7,19,35,46,92,105,189,210],"takes":[8],"to":[9,85,111,129,149,156,162,181,217],"execute":[10],"can":[11,36,80,108,126,134,153,168],"help":[12],"in":[13,93,114,160,233],"prioritizing,":[14],"optimizing":[15,90],"and":[16,47,133,212],"scheduling":[17],"execution.":[20,54],"This":[21],"also":[22],"helps":[23],"inoptimal":[24],"utilization":[25,137],"hardware":[27],"resources.":[28],"The":[29],"total":[30],"execution":[31,102,106,113,123,139,150,171],"be":[37,109,154],"split":[38],"into":[39],"taken":[42,50],"for":[43,51,246],"parsing/optimizing":[44],"actual":[53],"In":[55,191],"this":[56,192,234],"work,":[57,193],"we":[58,125,194],"focus":[59],"on":[60],"solving":[61],"first":[63],"part":[64],"problem,":[67],"that":[68],"is":[69,98,119,145,180],"predicting":[70,176,241],"optimization":[72,78,117,143],"query.":[76],"hint":[81],"optimizer":[83,152],"not":[84,128],"spend":[86,157],"too":[87],"much":[88,99,120],"case":[94],"when":[95],"parse":[96,178,220,244],"higher":[100],"than":[101,122],"time.":[103,172,221],"Such":[104],"plans":[107],"cached":[110],"speed-up":[112],"future.":[115],"If":[116,142],"lower":[121],"time,":[124,151],"choose":[127],"cache":[130],"plan":[132,140,166],"make":[135],"better":[136,164],"cache.":[141],"relatively":[146],"low":[147],"compared":[148],"hinted":[155],"more":[158],"parsing":[161],"produce":[163],"optimized":[165],"which":[167],"reduce":[169],"One":[173],"method":[174],"towards":[175],"use":[182,213],"some":[183],"heuristic":[184],"information":[185],"by":[186,201],"looking":[187],"at":[188],"text.":[190],"take":[195],"advantage":[196],"machine":[198],"learning":[199],"techniques":[200],"designing":[202],"set":[204],"features":[206],"from":[207],"text":[211],"neural":[215],"network":[216],"predict":[218],"We":[222,236],"have":[223],"tried":[224],"both":[225],"regression":[226],"as":[227,229],"well":[228],"classification":[230],"based":[231],"approaches":[232],"work.":[235],"report":[237],"high":[238],"accuracy":[239],"while":[240],"elapsed":[243],"queries.":[248]},"counts_by_year":[{"year":2025,"cited_by_count":1}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}