{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,4,24]],"date-time":"2026-04-24T18:28:46Z","timestamp":1777055326081,"version":"3.51.4"},"reference-count":38,"publisher":"Association for Computing Machinery (ACM)","issue":"10","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2020,6]]},"abstract":"<jats:p>OLTP applications are usually executed by a high number of clients in parallel and are typically faced with high throughput demand as well as a constraint latency requirement for individual statements. Interestingly, OLTP workloads are often read-heavy and comprise similar query patterns, which provides a potential to share work of statements belonging to different transactions. Consequently, OLAP techniques for sharing work have started to be applied also to OLTP workloads, lately.<\/jats:p>\n          <jats:p>In this paper, we present an approach for merging read statements within interactively submitted multi-statement transactions consisting of reads and writes. We first define a formal framework for merging transactions running under a given isolation level and provide insights into a prototypical implementation of merging within a commercial database system. In our experimental evaluation, we show that, depending on the isolation level, the load in the system and the read-share of the workload, an improvement of the transaction throughput by up to a factor of 2.5X is possible without compromising the transactional semantics.<\/jats:p>","DOI":"10.14778\/3401960.3401967","type":"journal-article","created":{"date-parts":[[2021,3,10]],"date-time":"2021-03-10T19:15:14Z","timestamp":1615403714000},"page":"1696-1708","source":"Crossref","is-referenced-by-count":7,"title":["Sharing opportunities for OLTP workloads in different isolation levels"],"prefix":"10.14778","volume":"13","author":[{"given":"Robin","family":"Rehrmann","sequence":"first","affiliation":[{"name":"TU Dresden, Dresden, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Carsten","family":"Binnig","sequence":"additional","affiliation":[{"name":"TU Darmstadt, Darmstadt, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Alexander","family":"B\u00f6hm","sequence":"additional","affiliation":[{"name":"SAP SE, Walldorf, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Kihong","family":"Kim","sequence":"additional","affiliation":[{"name":"SAP Labs, Seoul, Korea"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Wolfgang","family":"Lehner","sequence":"additional","affiliation":[{"name":"TU Dresden, Dresden, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2021,3,10]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1145\/568271.223785"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/319996.319998"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-011-0221-2"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1002\/cpe.4676"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/971697.602261"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.14778\/3282495.3282502"},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1109\/RELDIS.2005.14"},{"key":"e_1_2_1_8_1","volume-title":"Microsoft","author":"Emily Wilson M. R.","year":"2010","unstructured":"M. R. Emily Wilson and T. Kejser . Analyzing I\/O Characteristics and Sizing Storage Systems for SQL Server Database Applications. Technical report , Microsoft , 2010 . M. R. Emily Wilson and T. Kejser. Analyzing I\/O Characteristics and Sizing Storage Systems for SQL Server Database Applications. Technical report, Microsoft, 2010."},{"key":"e_1_2_1_9_1","volume-title":"The sap hana database - an architecture overview. Bulletin of the Technical Committee on Data Engineering \/ IEEE Computer Society, 35(1):28--33","author":"F\u00e4rber F.","year":"2012","unstructured":"F. F\u00e4rber , N. May , W. Lehner , P. Gro\u00dfe , I. M\u00fcller , H. Rauhe , and J. Dees . The sap hana database - an architecture overview. Bulletin of the Technical Committee on Data Engineering \/ IEEE Computer Society, 35(1):28--33 , 2012 . F. F\u00e4rber, N. May, W. Lehner, P. Gro\u00dfe, I. M\u00fcller, H. Rauhe, and J. Dees. The sap hana database - an architecture overview. Bulletin of the Technical Committee on Data Engineering \/ IEEE Computer Society, 35(1):28--33, 2012."},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/1071610.1071615"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-030-26075-0_30"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.14778\/2168651.2168654"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066201"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/3299869.3314041"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.14778\/2047485.2047491"},{"key":"e_1_2_1_16_1","volume-title":"Oracle","author":"Lance Ashdown T. K.","year":"2018","unstructured":"T. K. Lance Ashdown and J. McCormack . Oracle\u00ae Database Database Concepts. Technical report , Oracle , August 2018 . T. K. Lance Ashdown and J. McCormack. Oracle\u00ae Database Database Concepts. Technical report, Oracle, August 2018."},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.5555\/1325851.1325999"},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.14778\/2095686.2095689"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.14778\/3368289.3368299"},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.14778\/2904121.2904124"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3035959"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1145\/3267809.3267822"},{"key":"e_1_2_1_23_1","volume-title":"December","author":"May K.","year":"2015","unstructured":"K. May . Airline system look-to-book ratios soar , expected to go 10x higher. https:\/\/www.phocuswire.com\/Airline-system-look-to-book-ratios-soar-expected-to-go-10x-higher , December 2015 . [Online; accessed 15-March-2019]. K. May. Airline system look-to-book ratios soar, expected to go 10x higher. https:\/\/www.phocuswire.com\/Airline-system-look-to-book-ratios-soar-expected-to-go-10x-higher, December 2015. [Online; accessed 15-March-2019]."},{"key":"e_1_2_1_24_1","first-page":"545","volume-title":"Datenbanksysteme f\u00fcr Business, Technologie und Web (BTW","author":"May N.","year":"2017","unstructured":"N. May , A. B\u00f6hm , and W. Lehner . SAP HANA - The Evolution of an In-Memory DBMS from Pure OLAP Processing Towards Mixed Workloads . In B. Mitschang, D. Nicklas, F. Leymann, H. Sch\u00f6ning, M. Herschel, J. Teubner, T. H\u00e4rder, O. Kopp, and M. Wieland, editors, Datenbanksysteme f\u00fcr Business, Technologie und Web (BTW 2017 ), pages 545 -- 546 . Gesellschaft f\u00fcr Informatik, Bonn , 2017. N. May, A. B\u00f6hm, and W. Lehner. SAP HANA - The Evolution of an In-Memory DBMS from Pure OLAP Processing Towards Mixed Workloads. In B. Mitschang, D. Nicklas, F. Leymann, H. Sch\u00f6ning, M. Herschel, J. Teubner, T. H\u00e4rder, O. Kopp, and M. Wieland, editors, Datenbanksysteme f\u00fcr Business, Technologie und Web (BTW 2017), pages 545--546. Gesellschaft f\u00fcr Informatik, Bonn, 2017."},{"key":"e_1_2_1_25_1","volume-title":"IBM Research Division","author":"Ohad Rodeh H. H.","year":"2013","unstructured":"H. H. Ohad Rodeh and D. Chambliss . Visualizing Block IO Workloads. Technical report , IBM Research Division , October 2013 . H. H. Ohad Rodeh and D. Chambliss. Visualizing Block IO Workloads. Technical report, IBM Research Division, October 2013."},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.14778\/1920841.1920959"},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1145\/2588555.2594514"},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.14778\/1453856.1453924"},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.14778\/3229863.3229866"},{"key":"e_1_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.1145\/3395032.3395326"},{"key":"e_1_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.1145\/319702.319729"},{"key":"e_1_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.1145\/42201.42203"},{"key":"e_1_2_1_34_1","volume-title":"CIDR 2020, 10th Conference on Innovative Data Systems Research, Amsterdam, The Netherlands, January 12-15, 2020, Online Proceedings. www.cidrdb.org","author":"Shang Z.","year":"2020","unstructured":"Z. Shang , X. Liang , D. Tang , C. Ding , A. J. Elmore , S. Krishnan , and M. J. Franklin . Crocodiledb: Efficient database execution through intelligent deferment . In CIDR 2020, 10th Conference on Innovative Data Systems Research, Amsterdam, The Netherlands, January 12-15, 2020, Online Proceedings. www.cidrdb.org , 2020 . Z. Shang, X. Liang, D. Tang, C. Ding, A. J. Elmore, S. Krishnan, and M. J. Franklin. Crocodiledb: Efficient database execution through intelligent deferment. In CIDR 2020, 10th Conference on Innovative Data Systems Research, Amsterdam, The Netherlands, January 12-15, 2020, Online Proceedings. www.cidrdb.org, 2020."},{"key":"e_1_2_1_35_1","volume-title":"Telecommunication application transaction processing (TATP) benchmark description. Technical report","author":"Simo Neuvonen M. M.","year":"2009","unstructured":"M. M. Simo Neuvonen , Antoni Wolski and V. Raatikka . Telecommunication application transaction processing (TATP) benchmark description. Technical report , IBM Software Group Information Management , March 2009 . M. M. Simo Neuvonen, Antoni Wolski and V. Raatikka. Telecommunication application transaction processing (TATP) benchmark description. Technical report, IBM Software Group Information Management, March 2009."},{"key":"e_1_2_1_36_1","volume-title":"TPC BENCHMARK\u2122 C Standard Specification Revision 5.11. Technical report","author":"H.","year":"2010","unstructured":"TPC- H. TPC BENCHMARK\u2122 C Standard Specification Revision 5.11. Technical report , Transaction Processing Performance Council (TPC) , February 2010 . TPC-H. TPC BENCHMARK\u2122 C Standard Specification Revision 5.11. Technical report, Transaction Processing Performance Council (TPC), February 2010."},{"key":"e_1_2_1_37_1","doi-asserted-by":"publisher","DOI":"10.14778\/1687627.1687707"},{"key":"e_1_2_1_38_1","unstructured":"D. V. A. Zeyuan Shang and A. Pavlo. Carnegie Mellon Database Application Catalog (CMDBAC). http:\/\/cmdbac.cs.cmu.edu 2018. [Online; accessed 01-March-2018].  D. V. A. Zeyuan Shang and A. Pavlo. Carnegie Mellon Database Application Catalog (CMDBAC). http:\/\/cmdbac.cs.cmu.edu 2018. [Online; accessed 01-March-2018]."},{"key":"e_1_2_1_39_1","doi-asserted-by":"publisher","DOI":"10.5555\/1325851.1325934"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3401960.3401967","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T11:11:18Z","timestamp":1672225878000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3401960.3401967"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2020,6]]},"references-count":38,"journal-issue":{"issue":"10","published-print":{"date-parts":[[2020,6]]}},"alternative-id":["10.14778\/3401960.3401967"],"URL":"https:\/\/doi.org\/10.14778\/3401960.3401967","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2020,6]]}}}