{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,12,7]],"date-time":"2025-12-07T16:01:35Z","timestamp":1765123295882},"reference-count":33,"publisher":"Association for Computing Machinery (ACM)","issue":"11","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2012,7]]},"abstract":"<jats:p>Growing main memory sizes have facilitated database management systems that keep the entire database in main memory. The drastic performance improvements that came along with these in-memory systems have made it possible to reunite the two areas of online transaction processing (OLTP) and online analytical processing (OLAP): An emerging class of hybrid OLTP and OLAP database systems allows to process analytical queries directly on the transactional data. By offering arbitrarily current snapshots of the transactional data for OLAP, these systems enable real-time business intelligence.<\/jats:p>\n          <jats:p>\n            Despite memory sizes of several Terabytes in a single commodity server, RAM is still a precious resource: Since free memory can be used for intermediate results in query processing, the amount of memory determines query performance to a large extent. Consequently, we propose the\n            <jats:italic>compaction<\/jats:italic>\n            of memory-resident databases. Compaction consists of two tasks: First, separating the mutable working set from the immutable \"frozen\" data. Second, compressing the immutable data and optimizing it for efficient, memory-consumption-friendly snapshotting. Our approach reorganizes and compresses transactional data online and yet hardly affects the mission-critical OLTP throughput. This is achieved by unburdening the OLTP threads from all additional processing and performing these tasks asynchronously.\n          <\/jats:p>","DOI":"10.14778\/2350229.2350258","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"1424-1435","source":"Crossref","is-referenced-by-count":36,"title":["Compacting transactional data in hybrid OLTP&amp;OLAP databases"],"prefix":"10.14778","volume":"5","author":[{"given":"Florian","family":"Funke","sequence":"first","affiliation":[{"name":"TU M\u00fcnchen, Munich, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Alfons","family":"Kemper","sequence":"additional","affiliation":[{"name":"TU M\u00fcnchen, Munich, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Thomas","family":"Neumann","sequence":"additional","affiliation":[{"name":"TU M\u00fcnchen, Munich, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2012,7]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1145\/1142473.1142548"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.5555\/645481.653274"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/1559845.1559877"},{"key":"e_1_2_1_4_1","first-page":"225","volume-title":"CIDR","author":"Boncz P. A.","year":"2005"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/1989323.1989352"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/375663.375692"},{"key":"e_1_2_1_7_1","first-page":"273","volume-title":"NSDI","author":"Clark C.","year":"2005"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/1988842.1988850"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/318898.318923"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/363095.363141"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/2094114.2094126"},{"key":"e_1_2_1_12_1","unstructured":"F. Funke. {s390} introduce dirty bit for kvm live migration. Patch integrated in Linux kernel 2.6.28 Oct 2008. http:\/\/git.kernel.org\/?p=linux\/kernel\/git\/stable\/linux-stable.git;a=commit;h=15e86b0c752d50e910b2cca6e83ce74c4440d06c.  F. Funke. {s390} introduce dirty bit for kvm live migration. Patch integrated in Linux kernel 2.6.28 Oct 2008. http:\/\/git.kernel.org\/?p=linux\/kernel\/git\/stable\/linux-stable.git;a=commit;h=15e86b0c752d50e910b2cca6e83ce74c4440d06c."},{"key":"e_1_2_1_13_1","volume-title":"Prentice Hall PTR","author":"Gorman M.","year":"2004"},{"key":"e_1_2_1_14_1","first-page":"22","volume-title":"Data Compression and Database Performance. In In ACM\/IEEE-CS Symposium On Applied Computing","author":"Graefe G.","year":"1991"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/1807167.1807227"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247525"},{"key":"e_1_2_1_17_1","first-page":"68","volume-title":"CIDR","author":"Idreos S.","year":"2007"},{"issue":"2","key":"e_1_2_1_18_1","first-page":"1496","article-title":"H-Store: A High-Performance","volume":"1","author":"Kallman R.","year":"2008","journal-title":"Distributed Main Memory Transaction Processing System. PVLDB"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2011.5767867"},{"key":"e_1_2_1_20_1","unstructured":"A. Kivity Y. Kamay D. Laor U. Lublin and A. Liguori. kvm: the Linux Virtual Machine Monitor. kernel.org 2007.  A. Kivity Y. Kamay D. Laor U. Lublin and A. Liguori. kvm: the Linux Virtual Machine Monitor. kernel.org 2007."},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-12098-5_23"},{"issue":"1","key":"e_1_2_1_22_1","first-page":"61","volume":"5","author":"Kr\u00fcger J.","year":"2012","journal-title":"Fast Updates on Read-Optimized Databases Using Multi-Core CPUs. PVLDB"},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/320521.320540"},{"key":"e_1_2_1_24_1","first-page":"339","volume-title":"Dissecting CPU and Memory Optimization Effects. In VLDB","author":"Manegold S.","year":"2000"},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.1145\/1995441.1995444"},{"key":"e_1_2_1_26_1","first-page":"539","volume-title":"VLDB","author":"Neumann T.","year":"2011"},{"key":"e_1_2_1_27_1","volume-title":"Whitepaper","year":"2011"},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2008.4497414"},{"key":"e_1_2_1_29_1","unstructured":"Transaction Processing Performance Council. TPC-C specification. www.tpc.org\/tpcc\/spec\/TPC-C\\_v5-11.pdf 2010.  Transaction Processing Performance Council. TPC-C specification. www.tpc.org\/tpcc\/spec\/TPC-C\\_v5-11.pdf 2010."},{"key":"e_1_2_1_30_1","unstructured":"VoltDB. Technical Overview. http:\/\/www.voltdb.com March 2010.  VoltDB. Technical Overview. http:\/\/www.voltdb.com March 2010."},{"key":"e_1_2_1_31_1","unstructured":"VoltDB Community. VoltDB TPC-C-like Benchmark Comparison-Benchmark Description. http:\/\/community.voltdb.com\/node\/134 2010.  VoltDB Community. VoltDB TPC-C-like Benchmark Comparison-Benchmark Description. http:\/\/community.voltdb.com\/node\/134 2010."},{"key":"e_1_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.1145\/362084.362137"},{"key":"e_1_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2006.150"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/2350229.2350258","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T11:28:50Z","timestamp":1672226930000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/2350229.2350258"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2012,7]]},"references-count":33,"journal-issue":{"issue":"11","published-print":{"date-parts":[[2012,7]]}},"alternative-id":["10.14778\/2350229.2350258"],"URL":"https:\/\/doi.org\/10.14778\/2350229.2350258","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2012,7]]}}}