Sharing Opportunities for OLTP Workloads in Different Isolation Levels

Summary: Merges read statements across OLTP transactions under different isolation levels to share work. Formal framework for read-sharing in multi-statement OLTP workloads, with a prototype in a commercial DB and up to 2.5x throughput, preserving semantics. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 12261
Venue: VLDB
Year: 2020
Pagerank: 5.2473912e-05
Overall Rank: 9,607 | 34.09%
DOI: 10.14778/3401960.3401967

Incoming Non-self Citations Over Time

Authors

1. Robin Rehrmann (Technical University of Dresden)
2. Carsten Binnig (Technical University of Darmstadt)
3. Alexander Böhm (SAP)
4. Kihong Kim (SAP)
5. Wolfgang Lehner (Technical University of Dresden)

BibTeX Citation

@article{rehrmann_vldb20,
        title = {{Sharing Opportunities for OLTP Workloads in Different Isolation Levels}},
        author = {Rehrmann, Robin and Binnig, Carsten and Böhm, Alexander and Kim, Kihong and Lehner, Wolfgang},
        journal = {PVLDB},
        series = {{VLDB} '20},
        volume = {13},
        number = {10},
        pages = {1696--1708},
        doi = {10.14778/3401960.3401967},
        url = {https://doi.org/10.14778/3401960.3401967},
        year = {2020}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,890	GaccO - A GPU-accelerated OLTP DBMS	2022	SIGMOD	7.0435206e-05
9,740	SwitchTx: Scalable In-Network Coordination for Distributed Transaction Processing	2022	VLDB	5.227679e-05

Outgoing Citations (Sorted by Pagerank)

Showing 18 of 18 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
7	Implementation Techniques For Main Memory Database Systems	1984	SIGMOD	0.00083340894
19	A Critique of ANSI SQL Isolation Levels	1995	SIGMOD	0.00058720861
172	High-Performance Concurrency Control Mechanisms for Main-Memory Databases	2012	VLDB	0.00027281663
256	Data-Oriented Transaction Execution	2010	VLDB	0.00023172982
383	QPipe: A Simultaneously Pipelined Relational Query Engine	2005	SIGMOD	0.00019520728
670	SharedDB: Killing One Thousand Queries With One Stone	2012	VLDB	0.00015157572
696	Main-Memory Scan Sharing For Multi-Core CPUs	2008	VLDB	0.00014891322
761	Cooperative Scans: Dynamic Bandwidth Sharing in a DBMS	2007	VLDB	0.00014254351
1,238	BatchDB: Efficient Isolated Execution of Hybrid OLTP+OLAP Workloads for Interactive Applications	2017	SIGMOD	0.00011543368
1,315	Fast Updates on Read-Optimized Databases Using Multi-Core CPUs	2012	VLDB	0.00011181796
1,334	Improving Optimistic Concurrency Control Through Transaction Batching and Operation Reordering	2019	VLDB	0.00011123567
1,347	X-Engine: An Optimized Storage Engine for Large-scale E-commerce Transaction Processing	2019	SIGMOD	0.00011073571
1,879	Predictable Performance for Unpredictable Workloads	2009	VLDB	9.5613416e-05
4,639	MQJoin: Efficient Shared Execution of Main-Memory Joins	2016	VLDB	6.5918791e-05
5,686	OLTPShare: The Case for Sharing in OLTP Workloads	2018	VLDB	6.1220514e-05
6,194	Incorporating Super-Operators in Big-Data Query Optimizers	2020	VLDB	5.9470844e-05
6,684	CrocodileDB: Efficient Database Execution through Intelligent Deferment	2020	CIDR	5.8036476e-05
9,723	Reactive and Proactive Sharing Across Concurrent Analytical Queries	2014	SIGMOD	5.2317252e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	10,893	Using Read Promotion and Mixed Isolation Levels for Performant Yet Serializable Execution of Transaction Programs	2025	VLDB
2	6,982	Intra-Transaction Parallelism in the Mapping of an Object Model to a Relational Multi-Processor System	1996	VLDB
3	1,964	OLTP on Hardware Islands	2012	VLDB
4	2,646	Allocating Isolation Levels to Transactions	2005	PODS
5	4,792	Analysis of Dynamic Load Balancing Strategies for Parallel Shared Nothing Database Systems	1993	VLDB
6	11,622	Workload Interference Analysis for HTAP*	2021	CIDR
7	3,292	Compacting Transactional Data in Hybrid OLTP&OLAP Databases	2012	VLDB
8	11,113	Oligolithic Cross-task Optimizations across Isolated Workloads*	2024	CIDR
9	12,316	Interactive Performance Monitoring of a Composite OLTP and OLAP Workload	2012	SIGMOD
10	5,686	OLTPShare: The Case for Sharing in OLTP Workloads	2018	VLDB