MacroDB: scaling database engines on multicores

  • Authors:
  • João Soares;João Lourenço;Nuno Preguiça

  • Affiliations:
  • CITI/DI-FCT, Univ. Nova de Lisboa, Portugal;CITI/DI-FCT, Univ. Nova de Lisboa, Portugal;CITI/DI-FCT, Univ. Nova de Lisboa, Portugal

  • Venue:
  • Euro-Par'13 Proceedings of the 19th international conference on Parallel Processing
  • Year:
  • 2013

Quantified Score

Hi-index 0.00

Visualization

Abstract

Multicore processors are available for over a decade, but general purpose database management systems (DBMS) still cannot fully explore the computational resources of these platforms. This paper explores a simple and easy to deploy approach for improving DBMS performance in multicore platforms, by maintaining multiple database engines running in parallel, rather than a single instance, thus circumventing the increase in contention due to load interactions. Unlike previous works, we focus on in-memory DBMS, exploring different design solutions that combine distributed systems and concurrent programming techniques. We show that we are able to improve performance over standalone solutions, without modifying either database or application code, by up to 3 times while minimizing response times.