The notions of consistency and predicate locks in a database system
Communications of the ACM
Automating physical database design in a parallel database
Proceedings of the 2002 ACM SIGMOD international conference on Management of data
DBMSs on a Modern Processor: Where Does Time Go?
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
Handling Data Skew in Multiprocessor Database Computers Using Partition Tuning
VLDB '91 Proceedings of the 17th International Conference on Very Large Data Bases
Physical database design decision algorithms and concurrent reorganization for parallel database systems
Integrating vertical and horizontal partitioning into automated physical database design
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
The end of an architectural era: (it's time for a complete rewrite)
VLDB '07 Proceedings of the 33rd international conference on Very large data bases
OLTP through the looking glass, and what we found there
Proceedings of the 2008 ACM SIGMOD international conference on Management of data
Data partitioning on chip multiprocessors
Proceedings of the 4th international workshop on Data management on new hardware
Shore-MT: a scalable storage manager for the multicore era
Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology
Online reorganization of databases
ACM Computing Surveys (CSUR)
Improving OLTP scalability using speculative lock inheritance
Proceedings of the VLDB Endowment
Low overhead concurrency control for partitioned main memory databases
Proceedings of the 2010 ACM SIGMOD International Conference on Management of data
Schism: a workload-driven approach to database replication and partitioning
Proceedings of the VLDB Endowment
Data-oriented transaction execution
Proceedings of the VLDB Endowment
Principles of Distributed Database Systems
Principles of Distributed Database Systems
PLP: page latch-free shared-everything OLTP
Proceedings of the VLDB Endowment
On predictive modeling for optimizing transaction execution in parallel OLTP systems
Proceedings of the VLDB Endowment
Scalability of write-ahead logging on multicore and multisocket hardware
The VLDB Journal — The International Journal on Very Large Data Bases
Skew-aware automatic database partitioning in shared-nothing, parallel OLTP systems
SIGMOD '12 Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data
Hi-index | 0.00 |
Web applications like social networking and online shopping are growing rapidly, forcing the OLTP systems to have the ability to efficiently handle numbers of concurrent transactions. Shared-everything models used in conventional OLTP systems, however, face significant problems in concurrency and scalability. With the increment of concurrent threads, the contention among threads increases sharply and degrades the system performance significantly. Shared-nothing models, on the other hand, are ideal for scalability but suffer a lot from data skew problem. In this paper, we propose bCATE, a novel concurrent transaction execution model which divides the database into conflict partitions and detects the conflicts between transactions in each partition. bCATE adopts an efficient thread assignment strategy to alleviate the performance degradation caused by contention and data skew. We conduct extensive empirical studies on our implementation of bCATE on Shore-MT [1] and demonstrate that bCATE can achieve up to 50% performance promotion against other models.