{"id":"https://openalex.org/W2061328792","doi":"https://doi.org/10.1109/icde.2013.6544903","title":"Fast peak-to-peak behavior with SSD buffer pool","display_name":"Fast peak-to-peak behavior with SSD buffer pool","publication_year":2013,"publication_date":"2013-04-01","ids":{"openalex":"https://openalex.org/W2061328792","doi":"https://doi.org/10.1109/icde.2013.6544903","mag":"2061328792"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2013.6544903","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2013.6544903","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2013 IEEE 29th International Conference on Data Engineering (ICDE)","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/A5024989829","display_name":"Jaeyoung Do","orcid":"https://orcid.org/0000-0003-1275-1621"},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Jaeyoung Do","raw_affiliation_strings":["Computer Sciences Department, University of Wisconsin, Madison, USA","Comput. Sci. Dept., Univ. of Wisconsin-Madison, Madison, WI, USA"],"affiliations":[{"raw_affiliation_string":"Computer Sciences Department, University of Wisconsin, Madison, USA","institution_ids":["https://openalex.org/I135310074"]},{"raw_affiliation_string":"Comput. Sci. Dept., Univ. of Wisconsin-Madison, Madison, WI, USA","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5055783509","display_name":"Donghui Zhang","orcid":"https://orcid.org/0000-0001-5363-3344"},"institutions":[{"id":"https://openalex.org/I4210120419","display_name":"Paradigm Pharmaceuticals (United States)","ror":"https://ror.org/02krbtc48","country_code":"US","type":"company","lineage":["https://openalex.org/I4210120419"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Donghui Zhang","raw_affiliation_strings":["Paradigm4, Australia","Paradigm4"],"affiliations":[{"raw_affiliation_string":"Paradigm4, Australia","institution_ids":[]},{"raw_affiliation_string":"Paradigm4","institution_ids":["https://openalex.org/I4210120419"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069237428","display_name":"Jignesh M. Patel","orcid":"https://orcid.org/0000-0003-3653-2538"},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"J. M. Patel","raw_affiliation_strings":["Computer Sciences Department, University of Wisconsin, Madison, USA","Comput. Sci. Dept., Univ. of Wisconsin-Madison, Madison, WI, USA"],"affiliations":[{"raw_affiliation_string":"Computer Sciences Department, University of Wisconsin, Madison, USA","institution_ids":["https://openalex.org/I135310074"]},{"raw_affiliation_string":"Comput. Sci. Dept., Univ. of Wisconsin-Madison, Madison, WI, USA","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5055300310","display_name":"David J. DeWitt","orcid":"https://orcid.org/0009-0007-5037-5205"},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"D. J. DeWitt","raw_affiliation_strings":["Microsoft Jim Gray Systems Laboratory, USA","Microsoft Jim Gray Systems Lab"],"affiliations":[{"raw_affiliation_string":"Microsoft Jim Gray Systems Laboratory, USA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"Microsoft Jim Gray Systems Lab","institution_ids":["https://openalex.org/I1290206253"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5024989829"],"corresponding_institution_ids":["https://openalex.org/I135310074"],"apc_list":null,"apc_paid":null,"fwci":3.6246,"has_fulltext":false,"cited_by_count":11,"citation_normalized_percentile":{"value":0.93566707,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"1129","last_page":"1140"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":1.0,"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":1.0,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9987999796867371,"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.9976000189781189,"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.8609726428985596},{"id":"https://openalex.org/keywords/write-buffer","display_name":"Write buffer","score":0.8143422603607178},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.6458680033683777},{"id":"https://openalex.org/keywords/buffer","display_name":"Buffer (optical fiber)","score":0.593779981136322},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.5761700868606567},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.4877372682094574},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.48128169775009155},{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"Online transaction processing","score":0.41570845246315},{"id":"https://openalex.org/keywords/flash","display_name":"Flash (photography)","score":0.4134480357170105},{"id":"https://openalex.org/keywords/cpu-cache","display_name":"CPU cache","score":0.3448385000228882},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.29719001054763794},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.2894776165485382},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.2686726152896881},{"id":"https://openalex.org/keywords/cache-algorithms","display_name":"Cache algorithms","score":0.14560741186141968}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8609726428985596},{"id":"https://openalex.org/C89089495","wikidata":"https://www.wikidata.org/wiki/Q8038418","display_name":"Write buffer","level":5,"score":0.8143422603607178},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.6458680033683777},{"id":"https://openalex.org/C145018004","wikidata":"https://www.wikidata.org/wiki/Q4985944","display_name":"Buffer (optical fiber)","level":2,"score":0.593779981136322},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.5761700868606567},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.4877372682094574},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.48128169775009155},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.41570845246315},{"id":"https://openalex.org/C2777526259","wikidata":"https://www.wikidata.org/wiki/Q221836","display_name":"Flash (photography)","level":2,"score":0.4134480357170105},{"id":"https://openalex.org/C189783530","wikidata":"https://www.wikidata.org/wiki/Q352090","display_name":"CPU cache","level":3,"score":0.3448385000228882},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.29719001054763794},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.2894776165485382},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.2686726152896881},{"id":"https://openalex.org/C38556500","wikidata":"https://www.wikidata.org/wiki/Q13404475","display_name":"Cache algorithms","level":4,"score":0.14560741186141968},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde.2013.6544903","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2013.6544903","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2013 IEEE 29th International Conference on Data Engineering (ICDE)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":13,"referenced_works":["https://openalex.org/W201688651","https://openalex.org/W1540873593","https://openalex.org/W1975148716","https://openalex.org/W1981029608","https://openalex.org/W2022239314","https://openalex.org/W2082317049","https://openalex.org/W2100587833","https://openalex.org/W2104954161","https://openalex.org/W2133671413","https://openalex.org/W2134170416","https://openalex.org/W2141048674","https://openalex.org/W2152563679","https://openalex.org/W6608181384"],"related_works":["https://openalex.org/W1571368810","https://openalex.org/W2506225776","https://openalex.org/W1784146144","https://openalex.org/W1616582327","https://openalex.org/W2379400621","https://openalex.org/W1484089092","https://openalex.org/W1524225265","https://openalex.org/W1558545464","https://openalex.org/W2121253564","https://openalex.org/W2011648306"],"abstract_inverted_index":{"A":[0],"promising":[1],"use":[2,31,100],"of":[3,44,182],"flash":[4],"SSDs":[5],"in":[6,39,61,110,126,186,197,243],"a":[7,30,73,78,82,101,249],"DBMS":[8],"is":[9,55,67,90,98],"to":[10,35,56,86,94,99,104,112,115,133,143,230,254],"extend":[11],"the":[12,26,40,45,51,59,62,65,106,134,144,159,171,180,183,187,205,234,245],"main":[13],"memory":[14],"buffer":[15,27,53,108,136,161,173,189],"pool":[16,54],"by":[17],"caching":[18,210],"selected":[19],"pages":[20],"that":[21,225],"have":[22,192],"been":[23,33],"evicted":[24],"from":[25,72],"pool.":[28,190],"Such":[29],"has":[32,248],"shown":[34],"produce":[36,228],"significant":[37],"gains":[38],"steady":[41],"state":[42],"performance":[43,89,241,256],"DBMS.":[46],"One":[47,92,156],"strategy":[48],"for":[49],"using":[50,163],"SSD":[52,63,107,135,160,172,188,209],"throw":[57],"away":[58],"data":[60,184],"when":[64,70],"system":[66],"restarted":[68],"(either":[69],"recovering":[71],"crash":[74],"or":[75],"restarting":[76],"after":[77],"shutdown),":[79],"and":[80,175,207,219],"consequently":[81],"long":[83],"\u201cramp-up\u201d":[84],"period":[85],"regain":[87],"peak":[88],"needed.":[91],"approach":[93,247],"eliminate":[95],"this":[96,122,148],"limitation":[97],"memory-mapped":[102,145],"file":[103],"store":[105],"table":[109,137,162],"order":[111],"be":[113],"able":[114],"restore":[116],"its":[117],"contents":[118],"on":[119,233],"restart.":[120],"However,":[121],"design":[123,157,168],"can":[124],"result":[125],"lower":[127],"sustained":[128],"performance,":[129,238],"because":[130],"every":[131],"update":[132],"may":[138],"incur":[139],"an":[140],"I/O":[141],"operation":[142],"file.":[146],"In":[147],"paper":[149],"we":[150],"propose":[151],"two":[152,215],"new":[153],"alternative":[154],"designs.":[155],"reconstructs":[158],"transactional":[164],"logs.":[165],"The":[166],"other":[167],"asynchronously":[169],"flushes":[170],"table,":[174],"upon":[176],"restart,":[177],"lazily":[178],"verifies":[179],"integrity":[181],"cached":[185],"We":[191],"implemented":[193],"these":[194],"three":[195],"designs":[196,227],"SQL":[198],"Server":[199],"2012.":[200],"For":[201],"each":[202],"design,":[203],"both":[204],"write-through":[206],"write-back":[208],"policies":[211],"were":[212],"implemented.":[213],"Using":[214],"OLTP":[216],"benchmarks":[217],"(TPC-C":[218],"TPC-E),":[220],"our":[221,226],"experimental":[222],"results":[223],"show":[224],"up":[229,253],"3.8X":[231],"speedup":[232,251],"interval":[235],"between":[236],"peak-to-peak":[237],"with":[239],"negligible":[240],"loss;":[242],"contrast,":[244],"previous":[246],"similar":[250],"but":[252],"54%":[255],"loss.":[257]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":4},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}