Title
Exploiting Single-Threaded Model in Multi-Core In-Memory Systems.
Abstract
The widely adopted single-threaded OLTP model assigns a single thread to each static partition of the database for processing transactions in a partition. This simplifies concurrency control while retaining parallelism. However, it suffers performance loss arising from skewed workloads as well as transactions that span multiple partitions. In this paper, we present a dynamic single-threaded in-memory OLTP system, called LADS, that extends the simplicity of the single-threaded model. The key innovation in LADS is the separation of dependency resolution and execution into two non-overlapping phases for batches of transactions. After the first phase of dependency resolution, the record actions of the transactions are partitioned and ordered. Each independent partition is then executed sequentially by a single thread, avoiding the need for locking. By careful mapping of the tasks to be performed to threads, LADS is able to achieve a high degree of balanced parallelism. We evaluate LADS against H-Store, a partition-based database; DORA, a data-oriented transaction processing system; and SILO, a multi-core in-memory OLTP engine. The experimental study shows that LADS achieves up to 20x higher throughput than existing systems and exhibits better robustness with various workloads.
Year
DOI
Venue
2016
10.1109/TKDE.2016.2578319
IEEE Trans. Knowl. Data Eng.
Keywords
Field
DocType
Databases,Protocols,Concurrency control,Instruction sets,Message systems,Parallel processing,Hardware
Concurrency control,Instruction set,Computer science,Parallel computing,Online transaction processing,Robustness (computer science),Thread (computing),Throughput,Multi-core processor,Transaction processing system,Distributed computing
Journal
Volume
Issue
ISSN
28
10
1041-4347
Citations 
PageRank 
References 
6
0.41
29
Authors
7
Name
Order
Citations
PageRank
Chang Yao1322.64
Divyakant Agrawal282011674.75
Gang Chen371275.60
Qian Lin49611.17
Beng Chin Ooi578731076.70
Weng-fai Wong6101983.39
Meihui Zhang761842.24