Chapter

Current Trends in Database Technology – EDBT 2006

Volume 4254 of the series Lecture Notes in Computer Science pp 649-661

Apuama: Combining Intra-query and Inter-query Parallelism in a Database Cluster

  • Bernardo MirandaAffiliated withComputer Science Department, COPPE, Federal University of Rio de Janeiro
  • , Alexandre A. B. LimaAffiliated withComputer Science Department, COPPE, Federal University of Rio de JaneiroSchool of Engineering and Computer Science, University of Grande Rio
  • , Patrick ValduriezAffiliated withAtlas Group, INRIA and LINA, University of Nantes
  • , Marta MattosoAffiliated withComputer Science Department, COPPE, Federal University of Rio de Janeiro

* Final gross prices may vary according to local VAT.

Get Access

Abstract

Database clusters provide a cost-effective solutionn for high performance query processing. By using either inter- or intra-query parallelism on replicated data, they can accelerate individual queries and increase throughput. However, there is no database cluster that combines inter- and intra-query parallelism while supporting intensive update transactions. C-JDBC is a successful database cluster that offers inter-query parallelism and controls database replica consistency but cannot accelerate individual heavy-weight queries, typical of OLAP. In this paper, we propose the Apuama Engine, which adds intra-query parallelism to C-JDBC. The result is an open-source package that supports both OLTP and OLAP applications. We validated Apuama on a 32-node cluster running OLAP queries of the TPC-H benchmark on top of PostgreSQL. Our tests show that the Apuama Engine yields super-linear speedup and scale-up in read-only environments. Furthermore, it yields excellent performance under data update operations.