BCC
Authors:
Open Access
- 1 January 2016
- journal article
- Published by Association for Computing Machinery (ACM) in Proceedings of the VLDB Endowment
- Vol. 9 (6) , 504-515
Abstract
The Optimistic Concurrency Control (OCC) method has been commonly used for in-memory databases to ensure transaction serializability --- a transaction will be aborted if its read set has been changed during execution. This simple criterion to abort transactions causes a large proportion of false positives, leading to excessive transaction aborts. Transactions aborted false-positively (i.e. false aborts) waste system resources and can significantly degrade system throughput (as much as 3.68x based on our experiments) when data contention is intensive. Modern in-memory databases run on systems with increasingly parallel hardware and handle workloads with growing concurrency. They must efficiently deal with data contention in the presence of greater concurrency by minimizing false aborts. This paper presents a new concurrency control method named Balanced Concurrency Control (BCC) which aborts transactions more carefully than OCC does. BCC detects data dependency patterns which can more reliably indicate unserializable transactions than the criterion used in OCC. The paper studies the design options and implementation techniques that can effectively detect data contention by identifying dependency patterns with low overhead. To test the performance of BCC, we have implemented it in Silo and compared its performance against that of the vanilla Silo system with OCC and two-phase locking (2PL). Our extensive experiments with TPC-W-like, TPC-C-like and YCSB workloads demonstrate that when data contention is intensive, BCC can increase transaction throughput by more than 3x versus OCC and more than 2x versus 2PL; meanwhile, BCC has comparable performance with OCC for workloads with low data contention.Keywords
This publication has 25 references indexed in Scilit:
- Lightweight locking for main memory database systemsProceedings of the VLDB Endowment, 2012
- Serializable snapshot isolation in PostgreSQLProceedings of the VLDB Endowment, 2012
- OLTP on hardware islandsProceedings of the VLDB Endowment, 2012
- High-performance concurrency control mechanisms for main-memory databasesProceedings of the VLDB Endowment, 2011
- Data-oriented transaction executionProceedings of the VLDB Endowment, 2010
- Making snapshot isolation serializableACM Transactions on Database Systems, 2005
- A read-only transaction anomaly under snapshot isolationACM SIGMOD Record, 2004
- On optimistic methods for concurrency controlACM Transactions on Database Systems, 1981
- System level concurrency control for distributed database systemsACM Transactions on Database Systems, 1978
- Notes on data base operating systems1978