Voltar
Capítulo de livro Produção Nacional Revisado por pares
BIBTEX RIS

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

2006; Springer Science+Business Media; Linguagem: Inglês

10.1007/11896548_49

ISSN

1611-3349

Autores

Bernardo Miranda, Alexandre A. B. Lima, Patrick Valduriez, Marta Mattoso,

Tópico(s)

Advanced Data Storage Technologies

Resumo

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.

Referência(s)