{"id":"https://openalex.org/W3216159031","doi":"https://doi.org/10.1109/nas51552.2021.9605481","title":"Improving Relational Database Upon the Arrival of Storage Hardware with Built-in Transparent Compression","display_name":"Improving Relational Database Upon the Arrival of Storage Hardware with Built-in Transparent Compression","publication_year":2021,"publication_date":"2021-10-01","ids":{"openalex":"https://openalex.org/W3216159031","doi":"https://doi.org/10.1109/nas51552.2021.9605481","mag":"3216159031"},"language":"en","primary_location":{"id":"doi:10.1109/nas51552.2021.9605481","is_oa":false,"landing_page_url":"https://doi.org/10.1109/nas51552.2021.9605481","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2021 IEEE International Conference on Networking, Architecture and Storage (NAS)","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/A5074531400","display_name":"Yifan Qiao","orcid":"https://orcid.org/0000-0001-5717-2637"},"institutions":[{"id":"https://openalex.org/I165799507","display_name":"Rensselaer Polytechnic Institute","ror":"https://ror.org/01rtyzb94","country_code":"US","type":"education","lineage":["https://openalex.org/I165799507"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Yifan Qiao","raw_affiliation_strings":["Rensselaer Polytechnic Institute"],"affiliations":[{"raw_affiliation_string":"Rensselaer Polytechnic Institute","institution_ids":["https://openalex.org/I165799507"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102858837","display_name":"Xubin Chen","orcid":"https://orcid.org/0000-0003-1370-4237"},"institutions":[{"id":"https://openalex.org/I165799507","display_name":"Rensselaer Polytechnic Institute","ror":"https://ror.org/01rtyzb94","country_code":"US","type":"education","lineage":["https://openalex.org/I165799507"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Xubin Chen","raw_affiliation_strings":["Rensselaer Polytechnic Institute"],"affiliations":[{"raw_affiliation_string":"Rensselaer Polytechnic Institute","institution_ids":["https://openalex.org/I165799507"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5036663770","display_name":"Jingpeng Hao","orcid":null},"institutions":[{"id":"https://openalex.org/I165799507","display_name":"Rensselaer Polytechnic Institute","ror":"https://ror.org/01rtyzb94","country_code":"US","type":"education","lineage":["https://openalex.org/I165799507"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jingpeng Hao","raw_affiliation_strings":["Rensselaer Polytechnic Institute"],"affiliations":[{"raw_affiliation_string":"Rensselaer Polytechnic Institute","institution_ids":["https://openalex.org/I165799507"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103013700","display_name":"Jiangpeng Li","orcid":"https://orcid.org/0009-0000-1908-5057"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jiangpeng Li","raw_affiliation_strings":["ScaleFlux Inc"],"affiliations":[{"raw_affiliation_string":"ScaleFlux Inc","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5070420565","display_name":"Qi Wu","orcid":"https://orcid.org/0000-0001-8511-7766"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Qi Wu","raw_affiliation_strings":["ScaleFlux Inc"],"affiliations":[{"raw_affiliation_string":"ScaleFlux Inc","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5107393060","display_name":"Jingqiang Wang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jingqiang Wang","raw_affiliation_strings":["ScaleFlux Inc"],"affiliations":[{"raw_affiliation_string":"ScaleFlux Inc","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100355797","display_name":"Yang Liu","orcid":"https://orcid.org/0000-0002-1109-0756"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yang Liu","raw_affiliation_strings":["ScaleFlux Inc"],"affiliations":[{"raw_affiliation_string":"ScaleFlux Inc","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100378820","display_name":"Tong Zhang","orcid":"https://orcid.org/0000-0003-2477-7140"},"institutions":[{"id":"https://openalex.org/I165799507","display_name":"Rensselaer Polytechnic Institute","ror":"https://ror.org/01rtyzb94","country_code":"US","type":"education","lineage":["https://openalex.org/I165799507"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Tong Zhang","raw_affiliation_strings":["Rensselaer Polytechnic Institute"],"affiliations":[{"raw_affiliation_string":"Rensselaer Polytechnic Institute","institution_ids":["https://openalex.org/I165799507"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":8,"corresponding_author_ids":["https://openalex.org/A5074531400"],"corresponding_institution_ids":["https://openalex.org/I165799507"],"apc_list":null,"apc_paid":null,"fwci":0.6113,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.70914204,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"9"},"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/T11269","display_name":"Algorithms and Data Compression","score":0.9998000264167786,"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"}},{"id":"https://openalex.org/T10742","display_name":"Peer-to-Peer Network Technologies","score":0.9941999912261963,"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.8057880401611328},{"id":"https://openalex.org/keywords/computer-hardware","display_name":"Computer hardware","score":0.5684654116630554},{"id":"https://openalex.org/keywords/computer-data-storage","display_name":"Computer data storage","score":0.5263263583183289},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5038127303123474},{"id":"https://openalex.org/keywords/embedded-system","display_name":"Embedded system","score":0.4697112441062927},{"id":"https://openalex.org/keywords/data-compression","display_name":"Data compression","score":0.46456968784332275},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.4400445818901062},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.43737637996673584},{"id":"https://openalex.org/keywords/leverage","display_name":"Leverage (statistics)","score":0.4102393388748169},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.2870680093765259},{"id":"https://openalex.org/keywords/computer-network","display_name":"Computer network","score":0.14758267998695374}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8057880401611328},{"id":"https://openalex.org/C9390403","wikidata":"https://www.wikidata.org/wiki/Q3966","display_name":"Computer hardware","level":1,"score":0.5684654116630554},{"id":"https://openalex.org/C194739806","wikidata":"https://www.wikidata.org/wiki/Q66221","display_name":"Computer data storage","level":2,"score":0.5263263583183289},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5038127303123474},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.4697112441062927},{"id":"https://openalex.org/C78548338","wikidata":"https://www.wikidata.org/wiki/Q2493","display_name":"Data compression","level":2,"score":0.46456968784332275},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.4400445818901062},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.43737637996673584},{"id":"https://openalex.org/C153083717","wikidata":"https://www.wikidata.org/wiki/Q6535263","display_name":"Leverage (statistics)","level":2,"score":0.4102393388748169},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.2870680093765259},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.14758267998695374},{"id":"https://openalex.org/C126042441","wikidata":"https://www.wikidata.org/wiki/Q1324888","display_name":"Frame (networking)","level":2,"score":0.0},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.0},{"id":"https://openalex.org/C31972630","wikidata":"https://www.wikidata.org/wiki/Q844240","display_name":"Computer vision","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/nas51552.2021.9605481","is_oa":false,"landing_page_url":"https://doi.org/10.1109/nas51552.2021.9605481","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2021 IEEE International Conference on Networking, Architecture and Storage (NAS)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure","score":0.6399999856948853}],"awards":[],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W11308288","https://openalex.org/W1558322811","https://openalex.org/W1600355623","https://openalex.org/W1964802076","https://openalex.org/W1968105141","https://openalex.org/W1993819379","https://openalex.org/W2005112390","https://openalex.org/W2056007277","https://openalex.org/W2060108852","https://openalex.org/W2060768583","https://openalex.org/W2098315581","https://openalex.org/W2105326258","https://openalex.org/W2107745473","https://openalex.org/W2108392934","https://openalex.org/W2122962290","https://openalex.org/W2129652681","https://openalex.org/W2153084230","https://openalex.org/W2167911783","https://openalex.org/W2247185367","https://openalex.org/W6600458396","https://openalex.org/W6636023781","https://openalex.org/W6691197194"],"related_works":["https://openalex.org/W2181722423","https://openalex.org/W2347222412","https://openalex.org/W2085601491","https://openalex.org/W2375996887","https://openalex.org/W2152099439","https://openalex.org/W4322723290","https://openalex.org/W2368976073","https://openalex.org/W2376548177","https://openalex.org/W1984163603","https://openalex.org/W2912031806"],"abstract_inverted_index":{"This":[0],"paper":[1],"presents":[2],"an":[3],"approach":[4],"to":[5,55,78,188],"enable":[6],"relational":[7,69],"database":[8,70,90],"take":[9],"full":[10],"advantage":[11],"of":[12,46,59,139,145,163,201],"modern":[13,73],"storage":[14,21,52,61,74,101,115,194],"hardware":[15,62],"with":[16,63,174],"built-in":[17,64,175],"transparent":[18,65,176],"compression.":[19,66,177],"Advanced":[20],"appliances":[22],"(e.g.,":[23],"all-flash":[24],"array)":[25],"and":[26,40,165],"some":[27],"latest":[28],"SSDs":[29],"(solid-state":[30],"drives)":[31],"can":[32,110,122,185],"perform":[33],"hardware-based":[34,47],"data":[35,128,134,147],"compression,":[36],"transparently":[37],"from":[38],"OS":[39],"applications.":[41],"Moreover,":[42],"the":[43,56,94,125,137,143,152,182,193],"growing":[44],"deployment":[45],"compression":[48,140],"capability":[49],"in":[50,89],"Cloud":[51],"infrastructure":[53],"leads":[54],"imminent":[57],"arrival":[58],"cloud-based":[60],"To":[67],"make":[68],"better":[71,112],"leverage":[72],"hardware,":[75],"we":[76],"propose":[77],"deploy":[79],"a":[80,104,171,198],"dual":[81],"in-memory":[82],"vs.":[83],"on-storage":[84,126],"page":[85,99,127],"format:":[86],"While":[87],"pages":[88],"cache":[91],"memory":[92],"retain":[93],"conventional":[95],"row-based":[96],"format,":[97],"each":[98],"on":[100,142,170,192],"devices":[102],"has":[103],"column-based":[105],"format":[106],"so":[107],"that":[108,121,181],"it":[109],"be":[111],"compressed":[113],"by":[114,157],"hardware.":[116],"We":[117,136,150],"present":[118],"design":[119,153],"techniques":[120,154],"further":[123],"improve":[124],"compressibility":[129],"through":[130],"additional":[131,190],"light-weight":[132],"column":[133,146],"transformation.":[135],"impact":[138],"algorithms":[141],"selection":[144],"transformation":[148],"techniques.":[149],"integrated":[151],"into":[155],"MySQL/InnoDB":[156],"adding":[158],"only":[159,197],"about":[160],"600":[161],"lines":[162],"code,":[164],"ran":[166],"Sysbench":[167],"OLTP":[168],"workloads":[169],"commercial":[172],"SSD":[173],"The":[178],"results":[179],"show":[180],"proposed":[183],"solution":[184],"bring":[186],"up":[187],"45%":[189],"reduction":[191],"cost":[195],"at":[196],"few":[199],"percentage":[200],"performance":[202],"degradation.":[203]},"counts_by_year":[{"year":2025,"cited_by_count":3},{"year":2023,"cited_by_count":3},{"year":2021,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}