{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,19]],"date-time":"2026-03-19T02:25:52Z","timestamp":1773887152154,"version":"3.50.1"},"reference-count":22,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2017,8]]},"abstract":"<jats:p>Modern in-memory database systems are facing the need of efficiently supporting mixed workloads of OLTP and OLAP. A conventional approach to this requirement is to rely on ETL-style, application-driven data replication between two very different OLTP and OLAP systems, sacrificing real-time reporting on operational data. An alternative approach is to run OLTP and OLAP workloads in a single machine, which eventually limits the maximum scalability of OLAP query performance. In order to tackle this challenging problem, we propose a novel database replication architecture called Asynchronous Parallel Table Replication (ATR). ATR supports OLTP workloads in one primary machine, while it supports heavy OLAP workloads in replicas. Here, row-store formats can be used for OLTP transactions at the primary, while column-store formats are used for OLAP analytical queries at the replicas. ATR is designed to support elastic scalability of OLAP query performance while it minimizes the overhead for transaction processing at the primary and minimizes CPU consumption for replayed transactions at the replicas. ATR employs a novel optimistic lock-free parallel log replay scheme which exploits characteristics of multi-version concurrency control (MVCC) in order to enable real-time reporting by minimizing the propagation delay between the primary and replicas. Through extensive experiments with a concrete implementation available in a commercial database system, we demonstrate that ATR achieves sub-second visibility delay even for update-intensive workloads, providing scalable OLAP performance without notable overhead to the primary.<\/jats:p>","DOI":"10.14778\/3137765.3137767","type":"journal-article","created":{"date-parts":[[2017,9,7]],"date-time":"2017-09-07T13:35:53Z","timestamp":1504791353000},"page":"1598-1609","source":"Crossref","is-referenced-by-count":27,"title":["Parallel replication across formats in SAP HANA for scaling out mixed OLTP\/OLAP workloads"],"prefix":"10.14778","volume":"10","author":[{"given":"Juchang","family":"Lee","sequence":"first","affiliation":[{"name":"SAP Labs Korea, Seoul, Korea"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"SeungHyun","family":"Moon","sequence":"additional","affiliation":[{"name":"Pohang University of Science and Technology (POSTECH), Pohang, Korea"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Kyu Hwan","family":"Kim","sequence":"additional","affiliation":[{"name":"SAP Labs Korea, Seoul, Korea"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Deok Hoe","family":"Kim","sequence":"additional","affiliation":[{"name":"SAP Labs Korea, Seoul, Korea"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Sang Kyun","family":"Cha","sequence":"additional","affiliation":[{"name":"Seoul National University, Seoul, Korea"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Wook-Shin","family":"Han","sequence":"additional","affiliation":[{"name":"Pohang University of Science and Technology (POSTECH), Pohang, Korea"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2017,8]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2011.5767897"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/304182.304191"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376691"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.14778\/2732967.2732970"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/2491245"},{"key":"e_1_2_1_6_1","first-page":"715","volume-title":"VLDB conference","author":"Daudjee K.","year":"2006","unstructured":"K. Daudjee and K. Salem . Lazy database replication with snapshot isolation . In VLDB conference , pages 715 -- 726 , 2006 . K. Daudjee and K. Salem. Lazy database replication with snapshot isolation. In VLDB conference, pages 715--726, 2006."},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/1217935.1217947"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/235968.233330"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2013.6544908"},{"key":"e_1_2_1_10_1","first-page":"134","volume-title":"VLDB conference","author":"Kemme B.","year":"2000","unstructured":"B. Kemme and G. Alonso . Don't be lazy, be consistent: Postgres-R, A new way to implement database replication . In VLDB conference , pages 134 -- 143 , 2000 . B. Kemme and G. Alonso. Don't be lazy, be consistent: Postgres-R, A new way to implement database replication. In VLDB conference, pages 134--143, 2000."},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2011.5767867"},{"key":"e_1_2_1_12_1","first-page":"173","volume-title":"IEEE ICDE conference","author":"Lee J.","year":"2001","unstructured":"J. Lee , K. Kim , and S. K. Cha . Differential logging: A commutative and associative logging scheme for highly parallel main memory database . In IEEE ICDE conference , pages 173 -- 182 , 2001 . J. Lee, K. Kim, and S. K. Cha. Differential logging: A commutative and associative logging scheme for highly parallel main memory database. In IEEE ICDE conference, pages 173--182, 2001."},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2013.6544906"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2903734"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.14778\/2350229.2350261"},{"key":"e_1_2_1_16_1","first-page":"155","volume-title":"ACM USENIX middleware conference","author":"Plattner C.","year":"2004","unstructured":"C. Plattner and G. Alonso . Ganymed: Scalable replication for transactional web applications . In ACM USENIX middleware conference , pages 155 -- 174 , 2004 . C. Plattner and G. Alonso. Ganymed: Scalable replication for transactional web applications. In ACM USENIX middleware conference, pages 155--174, 2004."},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/1559845.1559846"},{"key":"e_1_2_1_18_1","first-page":"97","volume-title":"Technology Conference on Performance Evaluation and Benchmarking","author":"Psaroudakis I.","year":"2014","unstructured":"I. Psaroudakis , F. Wolf , N. May , T. Neumann , A. B\u00f6hm , A. Ailamaki , and K.-U. Sattler . Scaling up mixed workloads: a battle of data freshness, flexibility, and scheduling . In Technology Conference on Performance Evaluation and Benchmarking , pages 97 -- 112 . Springer , 2014 . I. Psaroudakis, F. Wolf, N. May, T. Neumann, A. B\u00f6hm, A. Ailamaki, and K.-U. Sattler. Scaling up mixed workloads: a battle of data freshness, flexibility, and scheduling. In Technology Conference on Performance Evaluation and Benchmarking, pages 97--112. Springer, 2014."},{"key":"e_1_2_1_19_1","unstructured":"SAP. High availability for SAP HANA. https:\/\/archive.sap.com\/documents\/docs\/DOC-65585.  SAP. High availability for SAP HANA. https:\/\/archive.sap.com\/documents\/docs\/DOC-65585."},{"key":"e_1_2_1_20_1","unstructured":"SAP. SAP LT (SLT) replication server. http:\/\/www.sap.com\/community\/topic\/lt-replication-server.html.  SAP. SAP LT (SLT) replication server. http:\/\/www.sap.com\/community\/topic\/lt-replication-server.html."},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2005.103"},{"key":"e_1_2_1_22_1","volume-title":"Transactional information systems: theory, algorithms, and the practice of concurrency control and recovery","author":"Weikum G.","year":"2001","unstructured":"G. Weikum and G. Vossen . Transactional information systems: theory, algorithms, and the practice of concurrency control and recovery . Elsevier , 2001 . G. Weikum and G. Vossen. Transactional information systems: theory, algorithms, and the practice of concurrency control and recovery. Elsevier, 2001."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3137765.3137767","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:07:19Z","timestamp":1672222039000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3137765.3137767"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2017,8]]},"references-count":22,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2017,8]]}},"alternative-id":["10.14778\/3137765.3137767"],"URL":"https:\/\/doi.org\/10.14778\/3137765.3137767","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2017,8]]}}}