Database Engines on Multicores Scale: A Practical Approach

João Soares, Nuno Preguiça

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review


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 In-Memory 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 modifica-
tion that allows an almost 10 fold performance improvement, over the original engine, also allowing databases to scale on multicores.
Original languageEnglish
Title of host publicationProceedings of the 30th Annual ACM Symposium on Applied Computing
Place of PublicationNew York, NY, USA
ISBN (Print)978-1-4503-3196-8
Publication statusPublished - 2015

Publication series

NameSAC '15


  • cache
  • concurrency control
  • distributed systems
  • multi-version
  • partial data replication


Dive into the research topics of 'Database Engines on Multicores Scale: A Practical Approach'. Together they form a unique fingerprint.

Cite this