{"id":"https://openalex.org/W2439850722","doi":"https://doi.org/10.1109/icdew.2016.7495612","title":"Aggressive buffer pool warm-up after restart in SQL Server","display_name":"Aggressive buffer pool warm-up after restart in SQL Server","publication_year":2016,"publication_date":"2016-05-01","ids":{"openalex":"https://openalex.org/W2439850722","doi":"https://doi.org/10.1109/icdew.2016.7495612","mag":"2439850722"},"language":"en","primary_location":{"id":"doi:10.1109/icdew.2016.7495612","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icdew.2016.7495612","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2016 IEEE 32nd International Conference on Data Engineering Workshops (ICDEW)","raw_type":"proceedings-article"},"type":"conference-paper","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/A5010089204","display_name":"Kwanghyun Park","orcid":"https://orcid.org/0000-0003-0757-2725"},"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":"Kwanghyun Park","raw_affiliation_strings":["Computer Science Department, University of Wisconsin-Madison"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Science Department, University of Wisconsin-Madison","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5024989829","display_name":"Jaeyoung Do","orcid":"https://orcid.org/0000-0003-1275-1621"},"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":"Jaeyoung Do","raw_affiliation_strings":["Microsoft Jim Gray systems Lab"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Jim Gray systems Lab","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5028211011","display_name":"Nikhil Teletia","orcid":null},"institutions":[{"id":"https://openalex.org/I1316064682","display_name":"LinkedIn (United States)","ror":"https://ror.org/02fyxhe35","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I1316064682"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Nikhil Teletia","raw_affiliation_strings":["Linked In Corp"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Linked In Corp","institution_ids":["https://openalex.org/I1316064682"]}]},{"author_position":"last","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":"Jignesh M. Patel","raw_affiliation_strings":["Computer Science Department, University of Wisconsin-Madison"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Science Department, University of Wisconsin-Madison","institution_ids":["https://openalex.org/I135310074"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"31","last_page":"38"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9998999834060669,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9998999834060669,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9994000196456909,"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.9993000030517578,"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.8405108451843262},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.7363061904907227},{"id":"https://openalex.org/keywords/autocommit","display_name":"Autocommit","score":0.5795549154281616},{"id":"https://openalex.org/keywords/snapshot","display_name":"Snapshot (computer storage)","score":0.5720913410186768},{"id":"https://openalex.org/keywords/log-shipping","display_name":"Log shipping","score":0.5594635009765625},{"id":"https://openalex.org/keywords/buffer","display_name":"Buffer (optical fiber)","score":0.4743170440196991},{"id":"https://openalex.org/keywords/server","display_name":"Server","score":0.4488973617553711},{"id":"https://openalex.org/keywords/database-server","display_name":"Database server","score":0.4307805299758911},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.42930692434310913},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.3997402489185333},{"id":"https://openalex.org/keywords/internet-authentication-service","display_name":"Internet Authentication Service","score":0.34923359751701355}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8405108451843262},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.7363061904907227},{"id":"https://openalex.org/C33882796","wikidata":"https://www.wikidata.org/wiki/Q4826222","display_name":"Autocommit","level":5,"score":0.5795549154281616},{"id":"https://openalex.org/C55282118","wikidata":"https://www.wikidata.org/wiki/Q252683","display_name":"Snapshot (computer storage)","level":2,"score":0.5720913410186768},{"id":"https://openalex.org/C94925161","wikidata":"https://www.wikidata.org/wiki/Q6666854","display_name":"Log shipping","level":4,"score":0.5594635009765625},{"id":"https://openalex.org/C145018004","wikidata":"https://www.wikidata.org/wiki/Q4985944","display_name":"Buffer (optical fiber)","level":2,"score":0.4743170440196991},{"id":"https://openalex.org/C93996380","wikidata":"https://www.wikidata.org/wiki/Q44127","display_name":"Server","level":2,"score":0.4488973617553711},{"id":"https://openalex.org/C205295232","wikidata":"https://www.wikidata.org/wiki/Q76320","display_name":"Database server","level":2,"score":0.4307805299758911},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.42930692434310913},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.3997402489185333},{"id":"https://openalex.org/C166930804","wikidata":"https://www.wikidata.org/wiki/Q573731","display_name":"Internet Authentication Service","level":3,"score":0.34923359751701355},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icdew.2016.7495612","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icdew.2016.7495612","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2016 IEEE 32nd International Conference on Data Engineering Workshops (ICDEW)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.4399999976158142,"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320332195","display_name":"Samsung","ror":"https://ror.org/04w3jy968"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W1512730440","https://openalex.org/W1975148716","https://openalex.org/W2054308357","https://openalex.org/W2061328792","https://openalex.org/W2133671413","https://openalex.org/W4241687679","https://openalex.org/W6666034830"],"related_works":["https://openalex.org/W2357250331","https://openalex.org/W2388916228","https://openalex.org/W2385226910","https://openalex.org/W2381712871","https://openalex.org/W933925366","https://openalex.org/W2392953802","https://openalex.org/W2362000604","https://openalex.org/W2379273002","https://openalex.org/W2581822898","https://openalex.org/W2349501796"],"abstract_inverted_index":{"In":[0,138],"many":[1],"settings,":[2],"a":[3,14,27,39,51,56,62,143,167,190],"database":[4,28,46,59,77,90,100],"server":[5,47,163],"has":[6],"to":[7,13,20,33,185],"be":[8],"restarted":[9],"either":[10],"in":[11,18,65],"response":[12,19],"failure":[15,136],"event,":[16],"or":[17,194],"an":[21],"operational":[22],"decision":[23],"such":[24,36,104],"as":[25,43,105],"moving":[26],"service":[29],"from":[30],"one":[31],"machine":[32],"another.":[34],"However,":[35,116],"restarts":[37],"pose":[38],"potential":[40],"performance":[41,66,133,188],"problem":[42],"the":[44,58,69,74,76,87,89,154,157,162,170,183,197],"new":[45,144],"starts":[48],"off":[49],"with":[50,82,166],"cold":[52],"buffer":[53,78,91,113,158,171],"pool.":[54],"As":[55],"result,":[57],"application":[60],"experiences":[61],"dramatic":[63],"reduction":[64],"right":[67],"after":[68,86],"restart,":[70],"since":[71],"just":[72],"before":[73],"restart":[75,88],"pool":[79,92,114,172],"was":[80],"filled":[81],"hot":[83,128],"pages":[84],"and":[85,111,135,160],"is":[93],"empty.":[94],"To":[95],"address":[96],"these":[97,117],"issues,":[98],"traditional":[99],"systems":[101],"use":[102],"mechanisms":[103],"SQL":[106,147],"Server's":[107],"aggressive":[108],"page":[109,129],"expansion":[110],"MySQL's":[112],"preloading.":[115],"approaches":[118],"have":[119],"key":[120],"limitations":[121],"including":[122],"long":[123],"warm-up":[124],"times,":[125],"possible":[126],"early":[127],"eviction,":[130],"user":[131],"query":[132],"saturation,":[134],"restart.":[137,174],"this":[139],"paper,":[140],"we":[141],"present":[142],"framework":[145],"for":[146],"Server":[148],"that":[149,179],"allows":[150],"continual":[151],"capturing":[152],"of":[153,156,169,192],"state":[155,164],"pool,":[159],"restoring":[161],"quickly":[165],"snapshot":[168],"at":[173],"Our":[175],"empirical":[176],"evaluation":[177],"demonstrates":[178],"our":[180],"method":[181],"reduces":[182],"time":[184],"regain":[186],"peak":[187],"by":[189],"factor":[191],"2X":[193],"more":[195],"over":[196],"previous":[198],"approaches.":[199]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}