Data Management

Low Overhead Concurrency Control for Partitioned Main Memory Databases

Download Now Date Added: Jun 2010
Format: PDF

Database partitioning is a technique for improving the performance of distributed OLTP databases, since "Single partition" transactions that access data on one partition do not need coordination with other partitions. For workloads that are amenable to partitioning, some argue that transactions should be executed serially on each partition without any concurrency at all. This strategy makes sense for a main memory database where there are no disk or user stalls, since the CPU can be fully utilized and the overhead of traditional concurrency control, such as two-phase locking, can be avoided.