Database engines on multicores scale

Joao Soares, Nuno Preguica
2015 Proceedings of the 30th Annual ACM Symposium on Applied Computing - SAC '15  
Multicore processors are available for over a decade, being the norm for current computer systems, but general purpose database management systems (DBMS) still cannot fully explore the computational resources of these platforms. We focus on In-Memory DBMS since these are becoming widely adopted, due to the increasing amount of memory installed in today's systems, and are expected to scale on multicore machines, by not incurring in I/O bottlenecks. This paper presents a practical study on
more » ... ry DBMS and shows that contention imposed by concurrency control mechanisms, such as locking, are limiting factors for both performance and scalability of these systems on multicores. Additionally, we discuss a simple database engine modification that allows an almost 10 fold performance improvement, over the original engine, also allowing databases to scale on multicores.
doi:10.1145/2695664.3200145 fatcat:ytpt6ce4cbbkfizz3qhphseajy