{"id":"https://openalex.org/W2089527922","doi":"https://doi.org/10.1145/2699484","title":"Online Updates on Data Warehouses via Judicious Use of Solid-State Storage","display_name":"Online Updates on Data Warehouses via Judicious Use of Solid-State Storage","publication_year":2015,"publication_date":"2015-03-25","ids":{"openalex":"https://openalex.org/W2089527922","doi":"https://doi.org/10.1145/2699484","mag":"2089527922"},"language":"en","primary_location":{"id":"doi:10.1145/2699484","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2699484","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://infoscience.epfl.ch/record/208385","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5053040916","display_name":"Manos Athanassoulis","orcid":"https://orcid.org/0000-0003-1837-0010"},"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":"Manos Athanassoulis","raw_affiliation_strings":["\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne, Lausanne, Switzerland"],"affiliations":[{"raw_affiliation_string":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne, Lausanne, Switzerland","institution_ids":["https://openalex.org/I5124864"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101499113","display_name":"Shimin Chen","orcid":"https://orcid.org/0009-0000-1043-6236"},"institutions":[{"id":"https://openalex.org/I19820366","display_name":"Chinese Academy of Sciences","ror":"https://ror.org/034t30j35","country_code":"CN","type":"funder","lineage":["https://openalex.org/I19820366"]},{"id":"https://openalex.org/I4210161752","display_name":"Beijing Haidian Hospital","ror":"https://ror.org/058x5eq06","country_code":"CN","type":"healthcare","lineage":["https://openalex.org/I4210161752"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Shimin Chen","raw_affiliation_strings":["Chinese Academy of Sciences, Haidian District Beijing, China","Chinese Academy of Sciences, Haidian District, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Chinese Academy of Sciences, Haidian District Beijing, China","institution_ids":["https://openalex.org/I4210161752","https://openalex.org/I19820366"]},{"raw_affiliation_string":"Chinese Academy of Sciences, Haidian District, Beijing, China","institution_ids":["https://openalex.org/I19820366"]}]},{"author_position":"middle","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":["\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne, Lausanne, Switzerland"],"affiliations":[{"raw_affiliation_string":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne, Lausanne, Switzerland","institution_ids":["https://openalex.org/I5124864"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5047529677","display_name":"Philip B. Gibbons","orcid":null},"institutions":[{"id":"https://openalex.org/I1343180700","display_name":"Intel (United States)","ror":"https://ror.org/01ek73717","country_code":"US","type":"company","lineage":["https://openalex.org/I1343180700"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Philip B. Gibbons","raw_affiliation_strings":["Intel Labs, Pittsburgh, PA","Intel Labs, Pittsburgh, PA#TAB#"],"affiliations":[{"raw_affiliation_string":"Intel Labs, Pittsburgh, PA","institution_ids":["https://openalex.org/I1343180700"]},{"raw_affiliation_string":"Intel Labs, Pittsburgh, PA#TAB#","institution_ids":["https://openalex.org/I1343180700"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5091823418","display_name":"Radu Stoica","orcid":"https://orcid.org/0009-0005-8089-866X"},"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":"Radu Stoica","raw_affiliation_strings":["\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne, Lausanne, Switzerland"],"affiliations":[{"raw_affiliation_string":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne, Lausanne, Switzerland","institution_ids":["https://openalex.org/I5124864"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5053040916"],"corresponding_institution_ids":["https://openalex.org/I5124864"],"apc_list":null,"apc_paid":null,"fwci":1.9969,"has_fulltext":false,"cited_by_count":12,"citation_normalized_percentile":{"value":0.8811084,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"40","issue":"1","first_page":"1","last_page":"42"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","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/T11181","display_name":"Advanced Data Storage Technologies","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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9986000061035156,"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.9984999895095825,"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/computer-science","display_name":"Computer science","score":0.9136724472045898},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.725305438041687},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.7116168737411499},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.5845423936843872},{"id":"https://openalex.org/keywords/throughput","display_name":"Throughput","score":0.48810967803001404},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.44581910967826843},{"id":"https://openalex.org/keywords/online-algorithm","display_name":"Online algorithm","score":0.44373035430908203},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.4147328734397888},{"id":"https://openalex.org/keywords/range","display_name":"Range (aeronautics)","score":0.4139370322227478},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.37035906314849854},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.3610050082206726},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.2629769444465637},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.15480861067771912},{"id":"https://openalex.org/keywords/wireless","display_name":"Wireless","score":0.1259322166442871},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.12410575151443481}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9136724472045898},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.725305438041687},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.7116168737411499},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.5845423936843872},{"id":"https://openalex.org/C157764524","wikidata":"https://www.wikidata.org/wiki/Q1383412","display_name":"Throughput","level":3,"score":0.48810967803001404},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.44581910967826843},{"id":"https://openalex.org/C196921405","wikidata":"https://www.wikidata.org/wiki/Q786431","display_name":"Online algorithm","level":2,"score":0.44373035430908203},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.4147328734397888},{"id":"https://openalex.org/C204323151","wikidata":"https://www.wikidata.org/wiki/Q905424","display_name":"Range (aeronautics)","level":2,"score":0.4139370322227478},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.37035906314849854},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.3610050082206726},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.2629769444465637},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.15480861067771912},{"id":"https://openalex.org/C555944384","wikidata":"https://www.wikidata.org/wiki/Q249","display_name":"Wireless","level":2,"score":0.1259322166442871},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.12410575151443481},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/2699484","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2699484","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"},{"id":"pmh:oai:infoscience.epfl.ch:208385","is_oa":true,"landing_page_url":"http://infoscience.epfl.ch/record/208385","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:208385","is_oa":true,"landing_page_url":"http://infoscience.epfl.ch/record/208385","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":[{"score":0.7599999904632568,"id":"https://metadata.un.org/sdg/10","display_name":"Reduced inequalities"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":55,"referenced_works":["https://openalex.org/W87143622","https://openalex.org/W100509257","https://openalex.org/W640404332","https://openalex.org/W1494049834","https://openalex.org/W1544653352","https://openalex.org/W1564774435","https://openalex.org/W1605782097","https://openalex.org/W1739920298","https://openalex.org/W1967106146","https://openalex.org/W1967930269","https://openalex.org/W1970298499","https://openalex.org/W1981029608","https://openalex.org/W2006296837","https://openalex.org/W2019998825","https://openalex.org/W2041423790","https://openalex.org/W2051435086","https://openalex.org/W2057567813","https://openalex.org/W2058178853","https://openalex.org/W2068739275","https://openalex.org/W2075018787","https://openalex.org/W2077850713","https://openalex.org/W2081991734","https://openalex.org/W2087946700","https://openalex.org/W2088398920","https://openalex.org/W2091527603","https://openalex.org/W2100099053","https://openalex.org/W2100587833","https://openalex.org/W2103106131","https://openalex.org/W2108783070","https://openalex.org/W2111451400","https://openalex.org/W2112312025","https://openalex.org/W2116117441","https://openalex.org/W2117917070","https://openalex.org/W2118385974","https://openalex.org/W2118995957","https://openalex.org/W2120113238","https://openalex.org/W2120684426","https://openalex.org/W2126998350","https://openalex.org/W2127241402","https://openalex.org/W2141048674","https://openalex.org/W2142644005","https://openalex.org/W2151181047","https://openalex.org/W2152563679","https://openalex.org/W2156448604","https://openalex.org/W2158347038","https://openalex.org/W2158643472","https://openalex.org/W2159115664","https://openalex.org/W2159886933","https://openalex.org/W2161131159","https://openalex.org/W2624304035","https://openalex.org/W2752061190","https://openalex.org/W2752853835","https://openalex.org/W3004616691","https://openalex.org/W3023647491","https://openalex.org/W3138367763"],"related_works":["https://openalex.org/W2088925915","https://openalex.org/W2382891957","https://openalex.org/W2393491644","https://openalex.org/W2067184662","https://openalex.org/W3047837489","https://openalex.org/W2622139626","https://openalex.org/W2133660117","https://openalex.org/W2104496206","https://openalex.org/W3013303285","https://openalex.org/W2081416538"],"abstract_inverted_index":{"Data":[0],"warehouses":[1,104],"have":[2],"been":[3],"traditionally":[4],"optimized":[5],"for":[6,21,25,98,155],"read-only":[7],"query":[8,72,128,167,227],"performance,":[9,73],"allowing":[10],"only":[11,206],"offline":[12],"updates":[13,44,65,79,101,132,147],"at":[14],"night,":[15],"essentially":[16],"trading":[17],"off":[18],"data":[19,103,141],"freshness":[20],"performance.":[22],"The":[23,60],"need":[24],"24x7":[26],"operations":[27],"in":[28,66,102,224],"global":[29],"markets":[30],"and":[31,36,145,159,177,189,223],"the":[32,107,125,140,146,186,193,197,233],"rise":[33],"of":[34,52,63,109,116,127,136,175,185,196,238],"online":[35,43,100],"other":[37],"quickly":[38],"reacting":[39],"businesses":[40],"make":[41],"concurrent":[42],"increasingly":[45],"desirable.":[46],"Unfortunately,":[47],"state-of-the-art":[48],"approaches":[49,111],"fall":[50],"short":[51],"supporting":[53,99],"fast":[54],"analysis":[55],"queries":[56],"over":[57],"fresh":[58],"data.":[59],"conventional":[61],"approach":[62,97],"performing":[64,156],"place":[67],"can":[68],"dramatically":[69],"slow":[70],"down":[71],"while":[74,230],"prior":[75,110],"proposals":[76],"using":[77],"differential":[78,131],"either":[80],"require":[81],"large":[82],"in-memory":[83],"buffers":[84],"or":[85],"may":[86],"incur":[87],"significant":[88],"update":[89,234],"migration":[90,174],"cost.":[91],"This":[92],"article":[93],"presents":[94],"a":[95,134,225],"novel":[96],"that":[105,203],"overcomes":[106],"limitations":[108],"by":[112,236],"making":[113],"judicious":[114],"use":[115],"available":[117],"SSDs":[118],"to":[119,208,221],"cache":[120],"incoming":[121],"updates.":[122],"We":[123,151,181],"model":[124],"problem":[126],"processing":[129],"with":[130,162],"as":[133],"type":[135],"outer":[137],"join":[138],"between":[139],"residing":[142,148],"on":[143,149,212],"disks":[144],"SSDs.":[150],"present":[152,182],"MaSM":[153,198,204],"algorithms":[154],"such":[157],"joins":[158],"periodic":[160],"migrations,":[161],"small":[163],"memory":[164],"footprints,":[165],"low":[166,169],"overhead,":[168],"SSD":[170],"writes,":[171],"efficient":[172],"in-place":[173],"updates,":[176],"correct":[178],"ACID":[179],"support.":[180],"detailed":[183],"modeling":[184],"proposed":[187],"approach,":[188],"provide":[190],"proofs":[191],"regarding":[192],"fundamental":[194],"properties":[195],"algorithms.":[199],"Our":[200],"experimentation":[201],"shows":[202],"incurs":[205],"up":[207],"7%":[209],"overhead":[210],"both":[211],"synthetic":[213],"range":[214,217],"scans":[215],"(varying":[216],"size":[218],"from":[219],"4KB":[220],"100GB)":[222],"TPC-H":[226],"replay":[228],"study,":[229],"also":[231],"increasing":[232],"throughput":[235],"orders":[237],"magnitude.":[239]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":3},{"year":2016,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}