Database Engines on Multicores Scale: A Practical Approach

João Soares, Nuno Preguiça

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

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
PublisherACM
Pages1297–1302
ISBN (Print)978-1-4503-3196-8
Publication statusPublished - 2015

Publication series

NameSAC '15
PublisherACM

Keywords

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

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

  • Cite this

    Soares, J., & Preguiça, N. (2015). Database Engines on Multicores Scale: A Practical Approach. In Proceedings of the 30th Annual ACM Symposium on Applied Computing (pp. 1297–1302). (SAC '15). New York, NY, USA: ACM.