PLP: Page Latch-Free Shared-Everything OLTP
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.