{"id":"https://openalex.org/W2098009409","doi":"https://doi.org/10.1145/1559845.1559946","title":"Dynamic plan generation for parameterized queries","display_name":"Dynamic plan generation for parameterized queries","publication_year":2009,"publication_date":"2009-06-29","ids":{"openalex":"https://openalex.org/W2098009409","doi":"https://doi.org/10.1145/1559845.1559946","mag":"2098009409"},"language":"en","primary_location":{"id":"doi:10.1145/1559845.1559946","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1559845.1559946","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2009 ACM SIGMOD 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/A5111758876","display_name":"Ahmad Ghazal","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":"Ahmad Ghazal","raw_affiliation_strings":["Teradata Corporation, Elsegundo, CA, USA","Teradata Corporation, Elsegundo , CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Corporation, Elsegundo, CA, USA","institution_ids":["https://openalex.org/I4210158714"]},{"raw_affiliation_string":"Teradata Corporation, Elsegundo , CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027373849","display_name":"Dawit Seid","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":"Dawit Seid","raw_affiliation_strings":["Teradata Corporation, Elsegundo, CA, USA","Teradata Corporation, Elsegundo , CA, USA"],"affiliations":[{"raw_affiliation_string":"Teradata Corporation, Elsegundo, CA, USA","institution_ids":["https://openalex.org/I4210158714"]},{"raw_affiliation_string":"Teradata Corporation, Elsegundo , CA, USA","institution_ids":["https://openalex.org/I4210158714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5023002176","display_name":"Ramesh Bhashyam","orcid":null},"institutions":[{"id":"https://openalex.org/I108650528","display_name":"Teradata (United Kingdom)","ror":"https://ror.org/00gze1672","country_code":"GB","type":"company","lineage":["https://openalex.org/I108650528","https://openalex.org/I4210158714"]},{"id":"https://openalex.org/I4210101034","display_name":"Birla Institute of Technology and Science - Hyderabad Campus","ror":"https://ror.org/014ctt859","country_code":"IN","type":"education","lineage":["https://openalex.org/I4210101034","https://openalex.org/I74796645"]}],"countries":["GB","IN"],"is_corresponding":false,"raw_author_name":"Bhashyam Ramesh","raw_affiliation_strings":["Teradata, Hyderabad, India","Teradata, Hyderabad, India#TAB#"],"affiliations":[{"raw_affiliation_string":"Teradata, Hyderabad, India","institution_ids":["https://openalex.org/I4210101034"]},{"raw_affiliation_string":"Teradata, Hyderabad, India#TAB#","institution_ids":["https://openalex.org/I108650528"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041372923","display_name":"Alain Crolotte","orcid":null},"institutions":[{"id":"https://openalex.org/I108650528","display_name":"Teradata (United Kingdom)","ror":"https://ror.org/00gze1672","country_code":"GB","type":"company","lineage":["https://openalex.org/I108650528","https://openalex.org/I4210158714"]},{"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":["GB","US"],"is_corresponding":false,"raw_author_name":"Alain Crolotte","raw_affiliation_strings":["Teradata, Elsegundo, CA, USA","Teradata, Elsegundo, CA, USA#TAB#"],"affiliations":[{"raw_affiliation_string":"Teradata, Elsegundo, CA, USA","institution_ids":["https://openalex.org/I4210158714"]},{"raw_affiliation_string":"Teradata, Elsegundo, CA, USA#TAB#","institution_ids":["https://openalex.org/I108650528"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5075129441","display_name":"Manjula Koppuravuri","orcid":null},"institutions":[{"id":"https://openalex.org/I108650528","display_name":"Teradata (United Kingdom)","ror":"https://ror.org/00gze1672","country_code":"GB","type":"company","lineage":["https://openalex.org/I108650528","https://openalex.org/I4210158714"]},{"id":"https://openalex.org/I4210101034","display_name":"Birla Institute of Technology and Science - Hyderabad Campus","ror":"https://ror.org/014ctt859","country_code":"IN","type":"education","lineage":["https://openalex.org/I4210101034","https://openalex.org/I74796645"]}],"countries":["GB","IN"],"is_corresponding":false,"raw_author_name":"Manjula Koppuravuri","raw_affiliation_strings":["Teradata, Hyderabad, India","Teradata, Hyderabad, India#TAB#"],"affiliations":[{"raw_affiliation_string":"Teradata, Hyderabad, India","institution_ids":["https://openalex.org/I4210101034"]},{"raw_affiliation_string":"Teradata, Hyderabad, India#TAB#","institution_ids":["https://openalex.org/I108650528"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5022681823","display_name":"G Vinod","orcid":null},"institutions":[{"id":"https://openalex.org/I4210101034","display_name":"Birla Institute of Technology and Science - Hyderabad Campus","ror":"https://ror.org/014ctt859","country_code":"IN","type":"education","lineage":["https://openalex.org/I4210101034","https://openalex.org/I74796645"]},{"id":"https://openalex.org/I108650528","display_name":"Teradata (United Kingdom)","ror":"https://ror.org/00gze1672","country_code":"GB","type":"company","lineage":["https://openalex.org/I108650528","https://openalex.org/I4210158714"]}],"countries":["GB","IN"],"is_corresponding":false,"raw_author_name":"Vinod G","raw_affiliation_strings":["Teradata, Hyderabad, India","Teradata, Hyderabad, India#TAB#"],"affiliations":[{"raw_affiliation_string":"Teradata, Hyderabad, India","institution_ids":["https://openalex.org/I4210101034"]},{"raw_affiliation_string":"Teradata, Hyderabad, India#TAB#","institution_ids":["https://openalex.org/I108650528"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5111758876"],"corresponding_institution_ids":["https://openalex.org/I4210158714"],"apc_list":null,"apc_paid":null,"fwci":1.0285,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.78309284,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"909","last_page":"916"},"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.9997000098228455,"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.9997000098228455,"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.9972000122070312,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9923999905586243,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.8674106597900391},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6546293497085571},{"id":"https://openalex.org/keywords/parameterized-complexity","display_name":"Parameterized complexity","score":0.6342467069625854},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.6200607419013977},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5398136973381042},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.49773553013801575},{"id":"https://openalex.org/keywords/predicate","display_name":"Predicate (mathematical logic)","score":0.4509907066822052},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.4445701837539673},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.44303956627845764},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.4160228371620178},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.32150453329086304},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.2808740437030792},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.24297556281089783},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.23437875509262085},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.20649197697639465},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.1740420162677765},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.17114272713661194},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.0970287024974823}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8674106597900391},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6546293497085571},{"id":"https://openalex.org/C165464430","wikidata":"https://www.wikidata.org/wiki/Q1570441","display_name":"Parameterized complexity","level":2,"score":0.6342467069625854},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.6200607419013977},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5398136973381042},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.49773553013801575},{"id":"https://openalex.org/C140146324","wikidata":"https://www.wikidata.org/wiki/Q1144319","display_name":"Predicate (mathematical logic)","level":2,"score":0.4509907066822052},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.4445701837539673},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.44303956627845764},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4160228371620178},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.32150453329086304},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.2808740437030792},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.24297556281089783},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.23437875509262085},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.20649197697639465},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.1740420162677765},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.17114272713661194},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0970287024974823},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1559845.1559946","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1559845.1559946","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2009 ACM SIGMOD International Conference on Management of data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/8","score":0.46000000834465027,"display_name":"Decent work and economic growth"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":8,"referenced_works":["https://openalex.org/W1963741421","https://openalex.org/W1972348463","https://openalex.org/W1975731516","https://openalex.org/W1987645871","https://openalex.org/W2041563709","https://openalex.org/W2131413649","https://openalex.org/W2148646461","https://openalex.org/W2171438172"],"related_works":["https://openalex.org/W3125756434","https://openalex.org/W906795786","https://openalex.org/W2469357693","https://openalex.org/W175663584","https://openalex.org/W2106082581","https://openalex.org/W2152149667","https://openalex.org/W2413368787","https://openalex.org/W2614542053","https://openalex.org/W2401447141","https://openalex.org/W2406556739"],"abstract_inverted_index":{"Query":[0,69],"processing":[1],"in":[2,74,88,185,230],"a":[3,58,67,124,204,219],"DBMS":[4],"typically":[5],"involves":[6],"two":[7,155],"distinct":[8],"phases:":[9],"compilation,":[10],"which":[11,23,227],"generates":[12],"the":[13,41,45,63,75,174,198,231],"best":[14],"plan":[15,53],"and":[16,21,51,96,106,114,134,145,162,212,223],"its":[17,52],"corresponding":[18],"execution":[19,126],"steps,":[20],"execution,":[22,180],"evaluates":[24],"these":[25,151],"steps":[26],"against":[27],"database":[28],"objects.":[29],"For":[30],"some":[31],"queries,":[32],"considerable":[33],"resource":[34],"savings":[35],"can":[36],"be":[37,121],"achieved":[38],"by":[39,153],"skipping":[40],"compilation":[42,199],"phase":[43],"when":[44],"same":[46,64,76],"query":[47,108,139],"was":[48,54],"previously":[49],"submitted":[50,73],"already":[55],"cached.":[56],"In":[57,189],"number":[59],"of":[60,157,173,221],"important":[61],"applications":[62],"query,":[65],"called":[66],"Parameterized":[68],"(PQ),":[70],"is":[71],"repeatedly":[72],"basic":[77],"form":[78],"but":[79],"with":[80,104],"different":[81],"parameter":[82,176,181,192],"values.":[83,177],"PQ's":[84,216],"are":[85,101,167,171,183,194,228],"extensively":[86],"used":[87],"both":[89],"data":[90,97,132],"update":[91,94],"(e.g.":[92],"batch":[93],"programs)":[95],"access":[98],"queries.":[99],"There":[100],"tradeoffs":[102,152],"associated":[103],"caching":[105],"re-using":[107],"plans":[109,119,158,166,169,214],"such":[110],"as":[111],"space":[112],"utilization":[113],"maintenance":[115],"cost.":[116],"Besides,":[117],"pre-compiled":[118,168],"may":[120],"suboptimal":[122],"for":[123,159,207,215],"particular":[125],"due":[127],"to":[128,136,179,186,197],"various":[129],"reasons":[130],"including":[131],"skew":[133],"inability":[135],"exploit":[137],"value-based":[138],"transformation":[140],"like":[141],"materialized":[142],"view":[143],"rewrite":[144],"unsatisfiable":[146],"predicate":[147],"elimination.":[148],"We":[149],"address":[150],"distinguishing":[154],"types":[156],"PQ's:":[160],"generic":[161,187,213],"specific":[163,190,211],"plans.":[164,188],"Generic":[165],"that":[170],"independent":[172],"actual":[175],"Prior":[178],"values":[182,193],"plugged":[184,195],"plans,":[191],"prior":[196],"phase.":[200],"This":[201],"paper":[202],"provides":[203],"practical":[205],"framework":[206],"dynamically":[208],"deciding":[209],"between":[210],"based":[217,225],"on":[218],"mix":[220],"rule":[222],"cost":[224],"heuristics":[226],"implemented":[229],"Teradata":[232],"12.0":[233],"DBMS.":[234]},"counts_by_year":[{"year":2021,"cited_by_count":2},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}