PLP: Page Latch-Free Shared-Everything OLTP

Download Now Free registration required

Executive Summary

Scaling the performance of shared-everything transaction processing systems to highly-parallel multicore hardware remains a challenge for database system designers. Recent proposals alleviate locking and logging bottlenecks in the system, leaving page latching as the next potential problem. To tackle the page latching problem, the authors propose PhysioLogical Partitioning (PLP). The PLP design applies logical-only partitioning; maintaining the desired properties of shared-everything designs, and introduces a Multi-Rooted B+Tree index structure (MRBTree) which enables the partitioning of the accesses at the physical page level.

  • Format: PDF
  • Size: 866 KB