{"id":"https://openalex.org/W3000173466","doi":"https://doi.org/10.14778/3372716.3372724","title":"Optimizing databases by learning hidden parameters of solid state drives","display_name":"Optimizing databases by learning hidden parameters of solid state drives","publication_year":2019,"publication_date":"2019-12-09","ids":{"openalex":"https://openalex.org/W3000173466","doi":"https://doi.org/10.14778/3372716.3372724","mag":"3000173466"},"language":"en","primary_location":{"id":"doi:10.14778/3372716.3372724","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3372716.3372724","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/A5029848318","display_name":"Aarati Kakaraparthy","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Aarati Kakaraparthy","raw_affiliation_strings":["University of Wisconsin"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Wisconsin","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069237428","display_name":"Jignesh M. Patel","orcid":"https://orcid.org/0000-0003-3653-2538"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jignesh M. Patel","raw_affiliation_strings":["University of Wisconsin"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Wisconsin","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5010089204","display_name":"Kwanghyun Park","orcid":"https://orcid.org/0000-0003-0757-2725"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Kwanghyun Park","raw_affiliation_strings":["Microsoft Gray Systems Lab"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Gray Systems Lab","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5085163415","display_name":"Brian Kroth","orcid":"https://orcid.org/0000-0002-5108-6743"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Brian P. Kroth","raw_affiliation_strings":["Microsoft Gray Systems Lab"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Gray Systems Lab","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.7797,"has_fulltext":false,"cited_by_count":13,"citation_normalized_percentile":{"value":0.77459704,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":"13","issue":"4","first_page":"519","last_page":"532"},"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/T11478","display_name":"Caching and Content Delivery","score":0.9947999715805054,"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/T11269","display_name":"Algorithms and Data Compression","score":0.9879999756813049,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.8006823062896729},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.7118141055107117},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.5772056579589844},{"id":"https://openalex.org/keywords/binary-number","display_name":"Binary number","score":0.5227082967758179},{"id":"https://openalex.org/keywords/throughput","display_name":"Throughput","score":0.5157316327095032},{"id":"https://openalex.org/keywords/state","display_name":"State (computer science)","score":0.5138052105903625},{"id":"https://openalex.org/keywords/flash","display_name":"Flash (photography)","score":0.4145764112472534},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.36120015382766724},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.22133922576904297},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.21246013045310974}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8006823062896729},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.7118141055107117},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.5772056579589844},{"id":"https://openalex.org/C48372109","wikidata":"https://www.wikidata.org/wiki/Q3913","display_name":"Binary number","level":2,"score":0.5227082967758179},{"id":"https://openalex.org/C157764524","wikidata":"https://www.wikidata.org/wiki/Q1383412","display_name":"Throughput","level":3,"score":0.5157316327095032},{"id":"https://openalex.org/C48103436","wikidata":"https://www.wikidata.org/wiki/Q599031","display_name":"State (computer science)","level":2,"score":0.5138052105903625},{"id":"https://openalex.org/C2777526259","wikidata":"https://www.wikidata.org/wiki/Q221836","display_name":"Flash (photography)","level":2,"score":0.4145764112472534},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.36120015382766724},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.22133922576904297},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.21246013045310974},{"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/C94375191","wikidata":"https://www.wikidata.org/wiki/Q11205","display_name":"Arithmetic","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},{"id":"https://openalex.org/C555944384","wikidata":"https://www.wikidata.org/wiki/Q249","display_name":"Wireless","level":2,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3372716.3372724","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3372716.3372724","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":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":28,"referenced_works":["https://openalex.org/W1982935918","https://openalex.org/W2006425633","https://openalex.org/W2020930775","https://openalex.org/W2022636838","https://openalex.org/W2041282763","https://openalex.org/W2047949525","https://openalex.org/W2062487414","https://openalex.org/W2072198668","https://openalex.org/W2074968498","https://openalex.org/W2095575400","https://openalex.org/W2099316199","https://openalex.org/W2106117073","https://openalex.org/W2106436364","https://openalex.org/W2108783070","https://openalex.org/W2109597634","https://openalex.org/W2112479717","https://openalex.org/W2125499854","https://openalex.org/W2154809801","https://openalex.org/W2158347038","https://openalex.org/W2604445413","https://openalex.org/W2605461040","https://openalex.org/W2742513757","https://openalex.org/W2752233761","https://openalex.org/W2753126577","https://openalex.org/W2884664388","https://openalex.org/W2953498285","https://openalex.org/W6683356785","https://openalex.org/W6764791836"],"related_works":["https://openalex.org/W986318368","https://openalex.org/W2000785801","https://openalex.org/W2384410913","https://openalex.org/W2352878646","https://openalex.org/W2990194547","https://openalex.org/W2004734601","https://openalex.org/W2130149817","https://openalex.org/W1480123525","https://openalex.org/W2620865396","https://openalex.org/W2414054180"],"abstract_inverted_index":{"Solid":[0],"State":[1],"Drives":[2],"(SSDs)":[3],"are":[4],"complex":[5],"devices":[6],"with":[7],"varying":[8],"internal":[9,121],"implementations,":[10],"resulting":[11],"in":[12,15,147],"subtle":[13],"differences":[14],"behavior":[16,84,134],"between":[17],"devices.":[18],"In":[19],"this":[20],"paper,":[21],"we":[22,118,127,142,158],"demonstrate":[23],"how":[24],"a":[25,32,61,64,136],"database":[26,62,91,137,165],"engine":[27],"can":[28,41],"be":[29],"optimized":[30],"for":[31,59,63],"particular":[33],"device":[34],"by":[35,92,181,195,210,216,228,234],"learning":[36,71],"its":[37],"hidden":[38,73],"parameters.":[39,122],"This":[40],"not":[42],"only":[43],"improve":[44],"an":[45,104],"application's":[46],"performance,":[47],"but":[48],"also":[49,187],"potentially":[50],"increase":[51],"the":[52,55,72,76,82,86,90,107,112,132,173,189,199,207,225,229],"lifetime":[53],"of":[54,68,75,85,95,103,135,177,191],"SSD.":[56],"Our":[57],"approach":[58],"optimizing":[60,89],"given":[65],"SSD":[66],"consists":[67],"three":[69,160],"steps:":[70],"parameters":[74],"device,":[77],"proposing":[78],"rules":[79,129],"to":[80,130,162],"analyze":[81,131],"I/O":[83,133,145],"database,":[87],"and":[88,111,149,179,183,218],"eliminating":[93],"violations":[94],"these":[96,125,140,164],"rules.":[97],"We":[98],"obtain":[99],"two":[100],"different":[101],"characteristics":[102],"SSD,":[105],"namely":[106],"request":[108],"size":[109],"profile":[110,114],"location":[113],",":[115],"from":[116],"which":[117,171,223],"learn":[119],"multiple":[120],"Based":[123],"on":[124,153,169,193,198,204,221],"parameters,":[126],"propose":[128],"engine.":[138],"Using":[139],"rules,":[141],"uncover":[143],"sub-optimal":[144],"patterns":[146],"SQLite3":[148,178,211],"MariaDB":[150,180,194,230],"when":[151],"running":[152],"our":[154],"experimental":[155],"SSDs.":[156],"Finally,":[157],"present":[159],"techniques":[161],"optimize":[163],"engines:":[166],"(1)":[167],"use-hot-locations":[168],"SSD-S,":[170],"improves":[172,188],"SELECT":[174],"operation":[175],"throughput":[176],"29%":[182],"27%":[184],"respectively;":[185],"it":[186],"performance":[190],"YCSB":[192],"1%-22%":[196],"depending":[197],"workload":[200],"mix,":[201],"(2)":[202],"write-aligned-stripes":[203],"SSD-T,":[205,222],"reduces":[206,224],"wear-out":[208,226],"caused":[209,227],"write-ahead":[212],"log":[213,232],"(WAL)":[214],"file":[215,233],"3.1%,":[217],"(3)":[219],"contain-write-in-flash-page":[220],"binary":[231],"6.7%.":[235]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":2},{"year":2023,"cited_by_count":4},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":3},{"year":2016,"cited_by_count":1}],"updated_date":"2026-07-15T18:14:33.161393","created_date":"2025-10-10T00:00:00"}