{"id":"https://openalex.org/W2012168564","doi":"https://doi.org/10.1587/transinf.e97.d.976","title":"Performance Improvement of Database Compression for OLTP Workloads","display_name":"Performance Improvement of Database Compression for OLTP Workloads","alternate_titles":[],"publication_year":2014,"publication_date":"2014-01-01","ids":{"openalex":"https://openalex.org/W2012168564","doi":"https://doi.org/10.1587/transinf.e97.d.976","mag":"2012168564"},"language":"en","primary_location":{"id":"doi:10.1587/transinf.e97.d.976","doi":"https://doi.org/10.1587/transinf.e97.d.976","is_oa":true,"landing_page_url":"https://doi.org/10.1587/transinf.e97.d.976","pdf_url":"https://www.jstage.jst.go.jp/article/transinf/E97.D/4/E97.D_976/_pdf","source":{"id":"https://openalex.org/S2486202937","display_name":"IEICE Transactions on Information and Systems","issn_l":"0916-8532","issn":["0916-8532","1745-1361"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","jufo-1","norway-1","poland-20","russia-white-list-3"],"host_organization":"https://openalex.org/P4320800604","host_organization_name":"Institute of Electronics, Information and Communication Engineers","host_organization_lineage":["https://openalex.org/P4320800604"],"host_organization_lineage_names":["Institute of Electronics, Information and Communication Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEICE Transactions on Information and Systems","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W2012168564"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://www.jstage.jst.go.jp/article/transinf/E97.D/4/E97.D_976/_pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5091742813","display_name":"Kihoon Lee","orcid":"https://orcid.org/0000-0003-4661-0982","observed_orcids":["https://orcid.org/0000-0003-4661-0982"]},"institutions":[{"id":"https://openalex.org/I161024014","display_name":"Kwangwoon University","ror":"https://ror.org/02e9zc863","country_code":"KR","type":"education","lineage":["https://openalex.org/I161024014"]}],"countries":["KR"],"is_corresponding":true,"raw_author_name":"Ki-Hoon LEE","raw_affiliation_strings":["Department of Computer Engineering, Kwangwoon University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Engineering, Kwangwoon University","institution_ids":["https://openalex.org/I161024014"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5091742813"],"corresponding_institution_ids":["https://openalex.org/I161024014"],"apc_list":null,"apc_paid":null,"fwci":2.02,"has_fulltext":true,"cited_by_count":5,"citation_normalized_percentile":{"value":0.88445178,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":96},"biblio":{"volume":"E97.D","issue":"4","first_page":"976","last_page":"980"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9458000063896179,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9458000063896179,"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.03310000151395798,"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.019700000062584877,"subfield":{"id":"https://openalex.org/subfields/2614","display_name":"Theoretical Computer Science"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/database-compression","display_name":"database compression","score":0.9929999709129333},{"id":"https://openalex.org/keywords/oltp-workloads","display_name":"OLTP workloads","score":0.9449999928474426},{"id":"https://openalex.org/keywords/write-intensive-workloads","display_name":"write-intensive workloads","score":0.9710000157356262},{"id":"https://openalex.org/keywords/lock-contention","display_name":"lock contention","score":0.8349999785423279},{"id":"https://openalex.org/keywords/space-saving","display_name":"space saving","score":0.609000027179718},{"id":"https://openalex.org/keywords/throughput","display_name":"throughput","score":0.5090000033378601},{"id":"https://openalex.org/keywords/tpc-c","display_name":"TPC-C","score":0.7720000147819519},{"id":"https://openalex.org/keywords/innodb","display_name":"InnoDB","score":0.7429999709129333}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8639189600944519},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.7963863611221313},{"id":"https://openalex.org/C157764524","wikidata":"https://www.wikidata.org/wiki/Q1383412","display_name":"Throughput","level":3,"score":0.685068666934967},{"id":"https://openalex.org/C162478608","wikidata":"https://www.wikidata.org/wiki/Q4011369","display_name":"Uncompressed video","level":4,"score":0.6381989121437073},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.6306253671646118},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6303547620773315},{"id":"https://openalex.org/C180016635","wikidata":"https://www.wikidata.org/wiki/Q2712821","display_name":"Compression (physics)","level":2,"score":0.5123168230056763},{"id":"https://openalex.org/C78548338","wikidata":"https://www.wikidata.org/wiki/Q2493","display_name":"Data compression","level":2,"score":0.4708782136440277},{"id":"https://openalex.org/C25797200","wikidata":"https://www.wikidata.org/wiki/Q828137","display_name":"Compression ratio","level":3,"score":0.4615042805671692},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.38714104890823364},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.31521594524383545},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.2322215735912323},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.09847626090049744},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C511840579","wikidata":"https://www.wikidata.org/wiki/Q12757","display_name":"Internal combustion engine","level":2,"score":0.0},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.0},{"id":"https://openalex.org/C202474056","wikidata":"https://www.wikidata.org/wiki/Q1931635","display_name":"Video tracking","level":3,"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/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C171146098","wikidata":"https://www.wikidata.org/wiki/Q124192","display_name":"Automotive engineering","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1587/transinf.e97.d.976","doi":"https://doi.org/10.1587/transinf.e97.d.976","is_oa":true,"landing_page_url":"https://doi.org/10.1587/transinf.e97.d.976","pdf_url":"https://www.jstage.jst.go.jp/article/transinf/E97.D/4/E97.D_976/_pdf","source":{"id":"https://openalex.org/S2486202937","display_name":"IEICE Transactions on Information and Systems","issn_l":"0916-8532","issn":["0916-8532","1745-1361"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","jufo-1","norway-1","poland-20","russia-white-list-3"],"host_organization":"https://openalex.org/P4320800604","host_organization_name":"Institute of Electronics, Information and Communication Engineers","host_organization_lineage":["https://openalex.org/P4320800604"],"host_organization_lineage_names":["Institute of Electronics, Information and Communication Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEICE Transactions on Information and Systems","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1587/transinf.e97.d.976","doi":"https://doi.org/10.1587/transinf.e97.d.976","is_oa":true,"landing_page_url":"https://doi.org/10.1587/transinf.e97.d.976","pdf_url":"https://www.jstage.jst.go.jp/article/transinf/E97.D/4/E97.D_976/_pdf","source":{"id":"https://openalex.org/S2486202937","display_name":"IEICE Transactions on Information and Systems","issn_l":"0916-8532","issn":["0916-8532","1745-1361"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","jufo-1","norway-1","poland-20","russia-white-list-3"],"host_organization":"https://openalex.org/P4320800604","host_organization_name":"Institute of Electronics, Information and Communication Engineers","host_organization_lineage":["https://openalex.org/P4320800604"],"host_organization_lineage_names":["Institute of Electronics, Information and Communication Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEICE Transactions on Information and Systems","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320321374","display_name":"Kwangwoon University","ror":"https://ror.org/02e9zc863"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2012168564.pdf","grobid_xml":"https://content.openalex.org/works/W2012168564.grobid-xml"},"referenced_works_count":6,"referenced_works":["https://openalex.org/W1993819379","https://openalex.org/W2051488261","https://openalex.org/W2058040776","https://openalex.org/W2151131744","https://openalex.org/W2153084230","https://openalex.org/W2341510490"],"related_works":["https://openalex.org/W2340110490","https://openalex.org/W4413361128","https://openalex.org/W1993819379","https://openalex.org/W4399912369","https://openalex.org/W1873909800","https://openalex.org/W4413827489","https://openalex.org/W2609659378","https://openalex.org/W2586703715","https://openalex.org/W2098315581","https://openalex.org/W2737624592"],"abstract_inverted_index":{"As":[0],"data":[1,4,61],"volumes":[2],"explode,":[3],"storage":[5],"costs":[6,19],"become":[7],"a":[8,43,88],"large":[9],"fraction":[10],"of":[11,50,90,92,106],"total":[12],"IT":[13],"costs.":[14],"We":[15,57,95],"can":[16],"reduce":[17,83],"the":[18,48,120,146,161],"substantially":[20],"by":[21,86,166],"using":[22,126],"compression.":[23],"However,":[24],"it":[25],"is":[26,32],"generally":[27],"known":[28],"that":[29,59,112,132],"database":[30],"compression":[31,163],"not":[33],"suitable":[34],"for":[35,53,103],"write-intensive":[36,54],"workloads.":[37,56],"In":[38,76],"this":[39],"paper,":[40],"we":[41,82],"provide":[42],"comprehensive":[44],"solution":[45],"to":[46,78,115],"improve":[47],"performance":[49],"compressed":[51,65,101],"databases":[52],"OLTP":[55],"find":[58],"storing":[60],"too":[62],"densely":[63],"in":[64,99,119],"pages":[66],"incurs":[67],"many":[68],"future":[69,104],"page":[70,84,102,110,117],"splits,":[71],"which":[72],"require":[73],"exclusive":[74],"locks.":[75],"order":[77],"avoid":[79],"lock":[80],"contention,":[81],"splits":[85,118],"sacrificing":[87],"couple":[89],"percent":[91],"space":[93,98,142,158],"savings.":[94],"reserve":[96],"enough":[97],"each":[100],"updates":[105],"records":[107],"and":[108,129,149],"prevent":[109],"merges":[111],"are":[113],"prone":[114],"incur":[116],"near":[121],"future.":[122],"The":[123],"experimental":[124],"results":[125],"TPC-C":[127],"benchmark":[128],"MySQL/InnoDB":[130],"show":[131],"our":[133],"method":[134,164],"gives":[135],"1.5":[136],"times":[137,151],"higher":[138,152],"throughput":[139,153],"with":[140,145,154,160],"33%":[141],"savings":[143],"compared":[144,159],"uncompressed":[147],"counterpart":[148],"1.8":[150],"only":[155],"1%":[156],"more":[157],"state-of-the-art":[162],"developed":[165],"Facebook.":[167]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2012168564","counts_by_year":[{"year":2020,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":1}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
