{"id":"https://openalex.org/W2139682845","doi":"https://doi.org/10.1109/icdew.2008.4498281","title":"Automated physical design in database caches","display_name":"Automated physical design in database caches","publication_year":2008,"publication_date":"2008-04-01","ids":{"openalex":"https://openalex.org/W2139682845","doi":"https://doi.org/10.1109/icdew.2008.4498281","mag":"2139682845"},"language":"en","primary_location":{"id":"doi:10.1109/icdew.2008.4498281","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icdew.2008.4498281","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2008 IEEE 24th International Conference on Data Engineering Workshop","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://infoscience.epfl.ch/record/133257","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5071436717","display_name":"Tanu Malik","orcid":"https://orcid.org/0009-0007-9656-727X"},"institutions":[{"id":"https://openalex.org/I145311948","display_name":"Johns Hopkins University","ror":"https://ror.org/00za53h95","country_code":"US","type":"education","lineage":["https://openalex.org/I145311948"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Tanu Malik","raw_affiliation_strings":["Johns Hopkins University, USA","Johns Hopkins University, baltimore, MD"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Johns Hopkins University, USA","institution_ids":["https://openalex.org/I145311948"]},{"raw_affiliation_string":"Johns Hopkins University, baltimore, MD","institution_ids":["https://openalex.org/I145311948"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100395120","display_name":"Xiaodan Wang","orcid":"https://orcid.org/0000-0003-2785-9539"},"institutions":[{"id":"https://openalex.org/I145311948","display_name":"Johns Hopkins University","ror":"https://ror.org/00za53h95","country_code":"US","type":"education","lineage":["https://openalex.org/I145311948"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Xiaodan Wang","raw_affiliation_strings":["Johns Hopkins University, USA","Johns Hopkins University, baltimore, MD"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Johns Hopkins University, USA","institution_ids":["https://openalex.org/I145311948"]},{"raw_affiliation_string":"Johns Hopkins University, baltimore, MD","institution_ids":["https://openalex.org/I145311948"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084849539","display_name":"Randal Burns","orcid":"https://orcid.org/0000-0002-2924-1997"},"institutions":[{"id":"https://openalex.org/I145311948","display_name":"Johns Hopkins University","ror":"https://ror.org/00za53h95","country_code":"US","type":"education","lineage":["https://openalex.org/I145311948"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Randal Burns","raw_affiliation_strings":["Johns Hopkins University, USA","Johns Hopkins University, baltimore, MD"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Johns Hopkins University, USA","institution_ids":["https://openalex.org/I145311948"]},{"raw_affiliation_string":"Johns Hopkins University, baltimore, MD","institution_ids":["https://openalex.org/I145311948"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5110913907","display_name":"Debabrata Dash","orcid":null},"institutions":[{"id":"https://openalex.org/I74973139","display_name":"Carnegie Mellon University","ror":"https://ror.org/05x2bcf33","country_code":"US","type":"education","lineage":["https://openalex.org/I74973139"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Debabrata Dash","raw_affiliation_strings":["Carnegie Mellon University, USA","Carnegie Mellon Univ (USA)"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Carnegie Mellon University, USA","institution_ids":["https://openalex.org/I74973139"]},{"raw_affiliation_string":"Carnegie Mellon Univ (USA)","institution_ids":["https://openalex.org/I74973139"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5070907021","display_name":"Anastasia Ailamaki","orcid":null},"institutions":[{"id":"https://openalex.org/I74973139","display_name":"Carnegie Mellon University","ror":"https://ror.org/05x2bcf33","country_code":"US","type":"education","lineage":["https://openalex.org/I74973139"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Anastasia Ailamaki","raw_affiliation_strings":["Carnegie Mellon University, USA","Carnegie Mellon Univ (USA)"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Carnegie Mellon University, USA","institution_ids":["https://openalex.org/I74973139"]},{"raw_affiliation_string":"Carnegie Mellon Univ (USA)","institution_ids":["https://openalex.org/I74973139"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.055,"has_fulltext":false,"cited_by_count":21,"citation_normalized_percentile":{"value":0.92833473,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"27","last_page":"34"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9991999864578247,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9991999864578247,"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/T11478","display_name":"Caching and Content Delivery","score":0.9990000128746033,"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/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"}}],"keywords":[{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.901637077331543},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8276748657226562},{"id":"https://openalex.org/keywords/physical-design","display_name":"Physical design","score":0.6024624705314636},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.5062126517295837},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.4707050025463104},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.43948468565940857},{"id":"https://openalex.org/keywords/proxy","display_name":"Proxy (statistics)","score":0.42497795820236206},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.3572433590888977},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3461267948150635},{"id":"https://openalex.org/keywords/computer-network","display_name":"Computer network","score":0.22357994318008423},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.1982552409172058},{"id":"https://openalex.org/keywords/embedded-system","display_name":"Embedded system","score":0.17239335179328918},{"id":"https://openalex.org/keywords/circuit-design","display_name":"Circuit design","score":0.11501428484916687},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.09899923205375671}],"concepts":[{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.901637077331543},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8276748657226562},{"id":"https://openalex.org/C188817802","wikidata":"https://www.wikidata.org/wiki/Q13426855","display_name":"Physical design","level":3,"score":0.6024624705314636},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.5062126517295837},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.4707050025463104},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.43948468565940857},{"id":"https://openalex.org/C2780148112","wikidata":"https://www.wikidata.org/wiki/Q1432581","display_name":"Proxy (statistics)","level":2,"score":0.42497795820236206},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.3572433590888977},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3461267948150635},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.22357994318008423},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.1982552409172058},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.17239335179328918},{"id":"https://openalex.org/C190560348","wikidata":"https://www.wikidata.org/wiki/Q3245116","display_name":"Circuit design","level":2,"score":0.11501428484916687},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.09899923205375671},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1109/icdew.2008.4498281","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icdew.2008.4498281","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2008 IEEE 24th International Conference on Data Engineering Workshop","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.211.2539","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.211.2539","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.jhu.edu/%7Exwang/papers/wang_smdb08.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.357.2813","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.357.2813","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://hssl.cs.jhu.edu/papers/malik_sds08.pdf","raw_type":"text"},{"id":"pmh:oai:infoscience.epfl.ch:133257","is_oa":true,"landing_page_url":"http://infoscience.epfl.ch/record/133257","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:133257","is_oa":true,"landing_page_url":"http://infoscience.epfl.ch/record/133257","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":31,"referenced_works":["https://openalex.org/W78548535","https://openalex.org/W1485782945","https://openalex.org/W1536753495","https://openalex.org/W1558573344","https://openalex.org/W1585730347","https://openalex.org/W1851390469","https://openalex.org/W1997375126","https://openalex.org/W2028800250","https://openalex.org/W2029763499","https://openalex.org/W2039795745","https://openalex.org/W2055468282","https://openalex.org/W2065871817","https://openalex.org/W2076006018","https://openalex.org/W2084961399","https://openalex.org/W2097706874","https://openalex.org/W2099918651","https://openalex.org/W2103412498","https://openalex.org/W2108490710","https://openalex.org/W2109403713","https://openalex.org/W2114538202","https://openalex.org/W2122816893","https://openalex.org/W2127126492","https://openalex.org/W2166559705","https://openalex.org/W2406557711","https://openalex.org/W3136803825","https://openalex.org/W4243533704","https://openalex.org/W6632064309","https://openalex.org/W6633412492","https://openalex.org/W6638867933","https://openalex.org/W6666635439","https://openalex.org/W6678597633"],"related_works":["https://openalex.org/W2000785801","https://openalex.org/W986318368","https://openalex.org/W2384410913","https://openalex.org/W2352878646","https://openalex.org/W2004734601","https://openalex.org/W2130149817","https://openalex.org/W2990194547","https://openalex.org/W1480123525","https://openalex.org/W2620865396","https://openalex.org/W2414054180"],"abstract_inverted_index":{"Performance":[0],"of":[1,12,33,58,87,94,110],"proxy":[2,38,56],"caches":[3],"for":[4,26,73],"database":[5],"federations":[6],"that":[7,77,105,123],"serve":[8],"a":[9,34,65],"large":[10],"number":[11],"users":[13],"is":[14,51],"crucially":[15],"dependent":[16],"on":[17,30,139],"its":[18],"physical":[19,27,75,88,115,151],"design.":[20],"Current":[21],"techniques,":[22],"automated":[23,74],"or":[24],"otherwise,":[25],"design":[28,76,89,116,152],"depend":[29],"the":[31,55,80,84,92,107,130,134,140,150,156],"identification":[32],"representative":[35],"workload.":[36,68,136],"In":[37],"caches,":[39],"however,":[40],"such":[41],"techniques":[42,72,119],"are":[43,120],"inadequate":[44],"since":[45],"workload":[46,81,157],"characteristics":[47],"change":[48],"rapidly.":[49],"This":[50],"remarkably":[52],"shown":[53],"at":[54],"cache":[57],"SkyQuery,":[59],"an":[60],"Astronomy":[61],"federation,":[62],"which":[63],"receives":[64],"continuously":[66],"evolving":[67],"We":[69],"present":[70],"novel":[71],"adapt":[78],"with":[79,91,163],"and":[82,102,113],"balance":[83],"performance":[85],"benefits":[86],"decisions":[90],"cost":[93,109],"implementing":[95],"these":[96],"decisions.":[97],"These":[98],"include":[99],"both":[100],"competitive":[101],"incremental":[103],"algorithms":[104],"optimize":[106],"combined":[108],"query":[111],"evaluation":[112],"making":[114],"changes.":[117],"Our":[118],"general":[121],"in":[122,146],"they":[124],"do":[125],"not":[126],"make":[127],"assumptions":[128],"about":[129],"underlying":[131],"schema":[132],"nor":[133],"incoming":[135],"Preliminary":[137],"experiments":[138],"TPC-D":[141],"benchmark":[142],"demonstrate":[143],"significant":[144],"improvement":[145],"response":[147],"time":[148],"when":[149],"continually":[153],"adapts":[154],"to":[155],"using":[158],"our":[159],"online":[160],"algorithm":[161],"compared":[162],"offline":[164],"techniques.":[165]},"counts_by_year":[{"year":2021,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2017,"cited_by_count":2},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}