{"id":"https://openalex.org/W4366660614","doi":"https://doi.org/10.14778/3583140.3583159","title":"NV-SQL: Boosting OLTP Performance with Non-Volatile DIMMs","display_name":"NV-SQL: Boosting OLTP Performance with Non-Volatile DIMMs","publication_year":2023,"publication_date":"2023-02-01","ids":{"openalex":"https://openalex.org/W4366660614","doi":"https://doi.org/10.14778/3583140.3583159"},"language":"en","primary_location":{"id":"doi:10.14778/3583140.3583159","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3583140.3583159","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"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":"Proceedings of the VLDB Endowment","raw_type":"journal-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/A5031872461","display_name":"Mijin An","orcid":"https://orcid.org/0000-0002-8749-5506"},"institutions":[{"id":"https://openalex.org/I848706","display_name":"Sungkyunkwan University","ror":"https://ror.org/04q78tk20","country_code":"KR","type":"education","lineage":["https://openalex.org/I848706"]}],"countries":["KR"],"is_corresponding":true,"raw_author_name":"Mijin An","raw_affiliation_strings":["Sungkyunkwan University"],"affiliations":[{"raw_affiliation_string":"Sungkyunkwan University","institution_ids":["https://openalex.org/I848706"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101898807","display_name":"Jong-Hyeok Park","orcid":"https://orcid.org/0000-0001-8296-7781"},"institutions":[{"id":"https://openalex.org/I83436808","display_name":"Hankuk University of Foreign Studies","ror":"https://ror.org/051q2m369","country_code":"KR","type":"education","lineage":["https://openalex.org/I83436808"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Jonghyeok Park","raw_affiliation_strings":["Hankuk University of Foreign Studies"],"affiliations":[{"raw_affiliation_string":"Hankuk University of Foreign Studies","institution_ids":["https://openalex.org/I83436808"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101598171","display_name":"Tianzheng Wang","orcid":"https://orcid.org/0000-0003-0965-9592"},"institutions":[{"id":"https://openalex.org/I18014758","display_name":"Simon Fraser University","ror":"https://ror.org/0213rcc28","country_code":"CA","type":"education","lineage":["https://openalex.org/I18014758"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Tianzheng Wang","raw_affiliation_strings":["Simon Fraser University"],"affiliations":[{"raw_affiliation_string":"Simon Fraser University","institution_ids":["https://openalex.org/I18014758"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084877960","display_name":"Beomseok Nam","orcid":"https://orcid.org/0000-0001-5481-6070"},"institutions":[{"id":"https://openalex.org/I848706","display_name":"Sungkyunkwan University","ror":"https://ror.org/04q78tk20","country_code":"KR","type":"education","lineage":["https://openalex.org/I848706"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Beomseok Nam","raw_affiliation_strings":["Sungkyunkwan University"],"affiliations":[{"raw_affiliation_string":"Sungkyunkwan University","institution_ids":["https://openalex.org/I848706"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100360904","display_name":"Sang-Won Lee","orcid":"https://orcid.org/0000-0002-4206-3718"},"institutions":[{"id":"https://openalex.org/I848706","display_name":"Sungkyunkwan University","ror":"https://ror.org/04q78tk20","country_code":"KR","type":"education","lineage":["https://openalex.org/I848706"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Sang-Won Lee","raw_affiliation_strings":["Sungkyunkwan University"],"affiliations":[{"raw_affiliation_string":"Sungkyunkwan University","institution_ids":["https://openalex.org/I848706"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5031872461"],"corresponding_institution_ids":["https://openalex.org/I848706"],"apc_list":null,"apc_paid":null,"fwci":2.2944,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.89866182,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":97,"max":98},"biblio":{"volume":"16","issue":"6","first_page":"1453","last_page":"1465"},"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.9998000264167786,"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.9998000264167786,"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.9998000264167786,"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.9983000159263611,"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.8454002737998962},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6191096901893616},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.6074473857879639},{"id":"https://openalex.org/keywords/commit","display_name":"Commit","score":0.5180070996284485},{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"Online transaction processing","score":0.5141409039497375},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.5113620162010193},{"id":"https://openalex.org/keywords/in-memory-processing","display_name":"In-Memory Processing","score":0.5057265758514404},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4901750683784485},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.4319967031478882},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.3471977114677429},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.293146550655365},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.22873204946517944},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.1755659580230713},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.12033477425575256}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8454002737998962},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6191096901893616},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.6074473857879639},{"id":"https://openalex.org/C153180980","wikidata":"https://www.wikidata.org/wiki/Q19776675","display_name":"Commit","level":2,"score":0.5180070996284485},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.5141409039497375},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.5113620162010193},{"id":"https://openalex.org/C123593499","wikidata":"https://www.wikidata.org/wiki/Q6008583","display_name":"In-Memory Processing","level":5,"score":0.5057265758514404},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4901750683784485},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.4319967031478882},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.3471977114677429},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.293146550655365},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.22873204946517944},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.1755659580230713},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.12033477425575256},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3583140.3583159","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3583140.3583159","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"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":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Responsible consumption and production","id":"https://metadata.un.org/sdg/12","score":0.4000000059604645}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":24,"referenced_works":["https://openalex.org/W1515932031","https://openalex.org/W1558000032","https://openalex.org/W1974817122","https://openalex.org/W1988852271","https://openalex.org/W1996031850","https://openalex.org/W2000345607","https://openalex.org/W2104954161","https://openalex.org/W2164999122","https://openalex.org/W2168968494","https://openalex.org/W2294111665","https://openalex.org/W2352208637","https://openalex.org/W2398564056","https://openalex.org/W2578260324","https://openalex.org/W2765864547","https://openalex.org/W2798607736","https://openalex.org/W2981876273","https://openalex.org/W2999454777","https://openalex.org/W3081764054","https://openalex.org/W3149201378","https://openalex.org/W6630918672","https://openalex.org/W6653526251","https://openalex.org/W6680213524","https://openalex.org/W6735946348","https://openalex.org/W6840512135"],"related_works":["https://openalex.org/W1571368810","https://openalex.org/W1784146144","https://openalex.org/W2354954952","https://openalex.org/W1985467476","https://openalex.org/W2377040749","https://openalex.org/W2014977566","https://openalex.org/W2386931872","https://openalex.org/W1999533607","https://openalex.org/W2099483949","https://openalex.org/W2484233542"],"abstract_inverted_index":{"When":[0],"running":[1,196],"OLTP":[2,220],"workloads,":[3],"relational":[4],"DBMSs":[5],"with":[6,197,207],"flash":[7],"SSDs":[8],"still":[9],"suffer":[10],"from":[11,53],"the":[12,22,27,32,61,70,81,102,120,143,149,161,180,188,191,203,232],"durability":[13,33,233],"overhead.":[14],"Heavy":[15],"writes":[16,51,189],"to":[17,55,129,139,159,190,231],"SSD":[18,56],"not":[19],"only":[20],"limit":[21],"performance":[23],"but":[24],"also":[25],"shorten":[26],"storage":[28],"lifespan.":[29],"To":[30],"mitigate":[31],"overhead,":[34],"this":[35,112],"paper":[36],"proposes":[37,80,127],"a":[38,47,65,198,227],"new":[39,71],"database":[40],"architecture,":[41,72],"NV-SQL.":[42],"NV-SQL":[43,73,146,178,194,225],"aims":[44],"at":[45],"absorbing":[46],"large":[48],"fraction":[49],"of":[50,215],"written":[52],"DRAM":[54,209],"by":[57,169,210],"introducing":[58],"NVDIMM":[59,166,200],"into":[60],"memory":[62],"hierarchy":[63],"as":[64],"durable":[66],"write":[67],"cache.":[68],"On":[69],"makes":[74],"two":[75],"technical":[76],"contributions.":[77],"First,":[78],"it":[79],"re-update":[82],"interval-based":[83],"admission":[84],"policy":[85],"that":[86,101,115,224],"determines":[87],"which":[88],"write-hot":[89],"pages":[90,117,132],"qualify":[91],"for":[92,165,218],"being":[93],"cached":[94],"in":[95,100,176,213],"NVDIMM.":[96],"It":[97],"is":[98,105,226],"novel":[99],"page":[103,121],"hotness":[104],"based":[106],"solely":[107],"on":[108],"pages'":[109],"LSN.":[110],"Second,":[111],"study":[113],"finds":[114],"NVDIMM-resident":[116],"can":[118,155],"violate":[119],"action":[122],"consistency":[123],"upon":[124],"crash":[125],"and":[126,137,152,163,174,182,185],"how":[128,138,148],"detect":[130],"inconsistent":[131],"using":[133,142],"per-page":[134],"in-update":[135],"flag":[136],"rectify":[140],"them":[141],"redo":[144,172],"log.":[145],"demonstrates":[147],"ARIES-like":[150],"logging":[151],"recovery":[153,164],"techniques":[154],"be":[156],"elegantly":[157],"extended":[158],"support":[160],"caching":[162],"data.":[167],"Additionally,":[168],"placing":[170],"write-intensive":[171,219],"buffer":[173],"DWB":[175],"NVDIMM,":[177],"eliminates":[179],"log-force-at-commit":[181],"WAL":[183],"protocols":[184],"further":[186],"halves":[187],"storage.":[192],"Our":[193],"prototype":[195],"real":[199],"device":[201],"outperforms":[202],"same-priced":[204],"vanilla":[205],"MySQL":[206],"larger":[208],"several":[211],"folds":[212],"terms":[214],"transaction":[216],"throughput":[217],"benchmarks.":[221],"This":[222],"confirms":[223],"cost-performance":[228],"efficient":[229],"solution":[230],"problem.":[234]},"counts_by_year":[{"year":2025,"cited_by_count":5}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}