{"id":"https://openalex.org/W2099280312","doi":"https://doi.org/10.1109/icdew.2010.5452737","title":"Caching all plans with just one optimizer call","display_name":"Caching all plans with just one optimizer call","publication_year":2010,"publication_date":"2010-01-01","ids":{"openalex":"https://openalex.org/W2099280312","doi":"https://doi.org/10.1109/icdew.2010.5452737","mag":"2099280312"},"language":"en","primary_location":{"id":"doi:10.1109/icdew.2010.5452737","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icdew.2010.5452737","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2010 IEEE 26th International Conference on Data Engineering Workshops (ICDEW 2010)","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://infoscience.epfl.ch/record/152503","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5110913907","display_name":"Debabrata Dash","orcid":null},"institutions":[{"id":"https://openalex.org/I5124864","display_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","ror":"https://ror.org/02s376052","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I5124864"]}],"countries":["CH"],"is_corresponding":true,"raw_author_name":"Debabrata Dash","raw_affiliation_strings":["Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne, Switzerland","Ecole Polytechnique Federale de Lausanne  (Switzerland)"],"affiliations":[{"raw_affiliation_string":"Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne, Switzerland","institution_ids":["https://openalex.org/I5124864"]},{"raw_affiliation_string":"Ecole Polytechnique Federale de Lausanne  (Switzerland)","institution_ids":["https://openalex.org/I5124864"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5005113663","display_name":"Ioannis Alagiannis","orcid":null},"institutions":[{"id":"https://openalex.org/I5124864","display_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","ror":"https://ror.org/02s376052","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I5124864"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Ioannis Alagiannis","raw_affiliation_strings":["Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne, Switzerland","Ecole Polytechnique Federale de Lausanne  (Switzerland)"],"affiliations":[{"raw_affiliation_string":"Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne, Switzerland","institution_ids":["https://openalex.org/I5124864"]},{"raw_affiliation_string":"Ecole Polytechnique Federale de Lausanne  (Switzerland)","institution_ids":["https://openalex.org/I5124864"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5052936846","display_name":"Cristina Maier","orcid":null},"institutions":[{"id":"https://openalex.org/I5124864","display_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","ror":"https://ror.org/02s376052","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I5124864"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Cristina Maier","raw_affiliation_strings":["Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne, Switzerland","Ecole Polytechnique Federale de Lausanne  (Switzerland)"],"affiliations":[{"raw_affiliation_string":"Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne, Switzerland","institution_ids":["https://openalex.org/I5124864"]},{"raw_affiliation_string":"Ecole Polytechnique Federale de Lausanne  (Switzerland)","institution_ids":["https://openalex.org/I5124864"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5070907021","display_name":"Anastasia Ailamaki","orcid":null},"institutions":[{"id":"https://openalex.org/I5124864","display_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","ror":"https://ror.org/02s376052","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I5124864"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Anastasia Ailamaki","raw_affiliation_strings":["Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne, Switzerland","Ecole Polytechnique Federale de Lausanne  (Switzerland)"],"affiliations":[{"raw_affiliation_string":"Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne, Switzerland","institution_ids":["https://openalex.org/I5124864"]},{"raw_affiliation_string":"Ecole Polytechnique Federale de Lausanne  (Switzerland)","institution_ids":["https://openalex.org/I5124864"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5110913907"],"corresponding_institution_ids":["https://openalex.org/I5124864"],"apc_list":null,"apc_paid":null,"fwci":1.1157,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.80177392,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"105","last_page":"110"},"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.9998999834060669,"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.9998999834060669,"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.9998000264167786,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9901999831199646,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8951843976974487},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.7126858234405518},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.6985995769500732},{"id":"https://openalex.org/keywords/pruning","display_name":"Pruning","score":0.5280521512031555},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5180297493934631},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.5165625810623169},{"id":"https://openalex.org/keywords/initialization","display_name":"Initialization","score":0.4786568880081177},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.4672538936138153},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.435077428817749},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.4274534285068512},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.25359824299812317},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.14528590440750122},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.10380065441131592}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8951843976974487},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.7126858234405518},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.6985995769500732},{"id":"https://openalex.org/C108010975","wikidata":"https://www.wikidata.org/wiki/Q500094","display_name":"Pruning","level":2,"score":0.5280521512031555},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5180297493934631},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.5165625810623169},{"id":"https://openalex.org/C114466953","wikidata":"https://www.wikidata.org/wiki/Q6034165","display_name":"Initialization","level":2,"score":0.4786568880081177},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.4672538936138153},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.435077428817749},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.4274534285068512},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.25359824299812317},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.14528590440750122},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.10380065441131592},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C6557445","wikidata":"https://www.wikidata.org/wiki/Q173113","display_name":"Agronomy","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/icdew.2010.5452737","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icdew.2010.5452737","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2010 IEEE 26th International Conference on Data Engineering Workshops (ICDEW 2010)","raw_type":"proceedings-article"},{"id":"pmh:oai:infoscience.epfl.ch:152503","is_oa":true,"landing_page_url":"http://infoscience.epfl.ch/record/152503","pdf_url":null,"source":{"id":"https://openalex.org/S4306400487","display_name":"Infoscience (Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Text"}],"best_oa_location":{"id":"pmh:oai:infoscience.epfl.ch:152503","is_oa":true,"landing_page_url":"http://infoscience.epfl.ch/record/152503","pdf_url":null,"source":{"id":"https://openalex.org/S4306400487","display_name":"Infoscience (Ecole Polytechnique F\u00e9d\u00e9rale de Lausanne)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Text"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":11,"referenced_works":["https://openalex.org/W1553825122","https://openalex.org/W1851390469","https://openalex.org/W2053228377","https://openalex.org/W2108883953","https://openalex.org/W2111983929","https://openalex.org/W2153329411","https://openalex.org/W2168362821","https://openalex.org/W2168780254","https://openalex.org/W3021961968","https://openalex.org/W6638867933","https://openalex.org/W6684915945"],"related_works":["https://openalex.org/W3204184292","https://openalex.org/W3176564347","https://openalex.org/W1985458517","https://openalex.org/W2355833770","https://openalex.org/W3031039437","https://openalex.org/W3095877357","https://openalex.org/W183202219","https://openalex.org/W2951598131","https://openalex.org/W4221159459","https://openalex.org/W3138851421"],"abstract_inverted_index":{"Modern":[0],"database":[1,37],"management":[2],"systems":[3],"(DBMS)":[4],"answer":[5],"a":[6,71,153,184],"multitude":[7],"of":[8,18,50,115,124,141,170],"complex":[9],"queries":[10,20],"on":[11,176],"increasingly":[12],"larger":[13],"datasets.":[14],"Given":[15],"the":[16,19,22,36,47,68,76,89,95,101,109,113,118,122,126,130,148,160,166,177,190,199],"complexities":[17],"and":[21,44,104,168],"numerous":[23],"design":[24,27,65],"features,":[25],"manual":[26],"is":[28,38,78,83,132],"no":[29],"longer":[30],"an":[31,62,80],"option.":[32],"Instead,":[33],"automatically":[34],"designing":[35],"vital":[39],"to":[40,45,117,128,158,194],"maximize":[41],"its":[42],"performance":[43],"reduce":[46,159],"total":[48],"cost":[49,72,123,191],"ownership.":[51],"For":[52,183],"this":[53,144],"purpose,":[54],"commercial":[55],"DBMS":[56],"feature":[57],"automated":[58],"physical":[59],"designers":[60],"suggesting":[61],"efficient":[63],"DB":[64],"by":[66,86,173],"using":[67],"optimizer":[69,77,127,157],"as":[70],"model.":[73],"Unfortunately,":[74],"consulting":[75],"time-consuming,":[79],"effect":[81],"which":[82],"typically":[84],"counter-acted":[85],"drastically":[87],"pruning":[88],"search":[90],"space,":[91],"thereby":[92],"potentially":[93],"missing":[94],"optimal":[96],"solution.":[97],"Recently":[98],"techniques":[99,172,188],"cache":[100,131,161],"optimizer's":[102],"output":[103],"evaluate":[105],"some":[106],"plans":[107],"with":[108,139],"cached":[110],"results,":[111],"reducing":[112],"number":[114],"calls":[116],"optimizer.":[119,182],"Still,":[120],"however,":[121],"invoking":[125],"fill":[129],"nontrivial,":[133],"undermining":[134],"scalability":[135],"when":[136],"running":[137],"workloads":[138],"thousands":[140],"queries.":[142],"In":[143],"paper,":[145],"we":[146],"use":[147],"intermediate":[149],"optimization":[150],"results":[151],"in":[152],"dynamic":[154],"programming":[155],"based":[156],"initialization":[162],"overhead.":[163],"We":[164],"demonstrate":[165],"accuracy":[167],"efficiency":[169],"our":[171,187],"implementing":[174],"them":[175],"PostgreSQL":[178],"open":[179],"source":[180],"query":[181],"star-schema":[185],"workload,":[186],"build":[189],"model":[192],"5":[193],"10":[195],"times":[196],"faster":[197],"than":[198],"conventional":[200],"approach,":[201],"while":[202],"preserving":[203],"accuracy.":[204]},"counts_by_year":[{"year":2014,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}