{"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","alternate_titles":[],"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","doi":"https://doi.org/10.1109/icdew.2008.4498281","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icdew.2008.4498281","pdf_url":null,"source":{"id":"https://openalex.org/S7407088866","display_name":"IEEE International Conference on Data Engineering Workshops (ICDEW)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"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"},"parent_works":[],"lineage":["https://openalex.org/W2139682845"],"child_works_count":0,"type":"conference-paper","is_traditional":true,"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","observed_orcids":["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","observed_orcids":["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 C. Burns","orcid":"https://orcid.org/0000-0002-2924-1997","observed_orcids":["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,"observed_orcids":[]},"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":"https://orcid.org/0000-0002-9949-3639","observed_orcids":["https://orcid.org/0000-0002-9949-3639"]},"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":2.6281,"has_fulltext":false,"cited_by_count":24,"citation_normalized_percentile":{"value":0.91037537,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":87,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"27","last_page":"34"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9926999807357788,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9926999807357788,"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/T11478","display_name":"Caching and Content Delivery","score":0.0007999999797903001,"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.00039999998989515007,"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/proxy-cache","display_name":"proxy cache","score":0.9089999794960022},{"id":"https://openalex.org/keywords/database-federation","display_name":"database federation","score":0.878000020980835},{"id":"https://openalex.org/keywords/dynamic-workloads","display_name":"dynamic workloads","score":0.47600001096725464},{"id":"https://openalex.org/keywords/online-algorithms","display_name":"online algorithms","score":0.703000009059906},{"id":"https://openalex.org/keywords/incremental-algorithms","display_name":"incremental algorithms","score":0.7170000076293945},{"id":"https://openalex.org/keywords/query-evaluation-cost","display_name":"query evaluation cost","score":0.7070000171661377},{"id":"https://openalex.org/keywords/tpc-ds","display_name":"TPC-DS","score":0.8629999756813049}],"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":5,"locations":[{"id":"doi:10.1109/icdew.2008.4498281","doi":"https://doi.org/10.1109/icdew.2008.4498281","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icdew.2008.4498281","pdf_url":null,"source":{"id":"https://openalex.org/S7407088866","display_name":"IEEE International Conference on Data Engineering Workshops (ICDEW)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"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:infoscience.epfl.ch:133257","doi":null,"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,"listed_in":[],"host_organization":"https://openalex.org/I5124864","host_organization_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","host_organization_lineage":["https://openalex.org/I5124864"],"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"},{"id":"pmh:oai:infoscience.tind.io:133257","doi":null,"is_oa":true,"landing_page_url":"https://infoscience.epfl.ch/handle/20.500.14299/34329","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,"listed_in":[],"host_organization":"https://openalex.org/I5124864","host_organization_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","host_organization_lineage":["https://openalex.org/I5124864"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"conference proceedings"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.211.2539","doi":null,"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","doi":null,"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"}],"best_oa_location":{"id":"pmh:oai:infoscience.epfl.ch:133257","doi":null,"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,"listed_in":[],"host_organization":"https://openalex.org/I5124864","host_organization_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","host_organization_lineage":["https://openalex.org/I5124864"],"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":[{"score":0.4943999946117401,"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":27,"referenced_works":["https://openalex.org/W66807521","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/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/W3136803825","https://openalex.org/W4236078745","https://openalex.org/W4243533704","https://openalex.org/W7096347532"],"related_works":["https://openalex.org/W1487508655","https://openalex.org/W2108490710","https://openalex.org/W2108883953","https://openalex.org/W7099681125","https://openalex.org/W2159154943","https://openalex.org/W371957946","https://openalex.org/W2962782576","https://openalex.org/W2145466803","https://openalex.org/W7095197079","https://openalex.org/W7203970035"],"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]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2139682845","counts_by_year":[{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":1},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
