Parallel OLAP query processing in database clusters with data replication - Inria - Institut national de recherche en sciences et technologies du numérique Accéder directement au contenu
Article Dans Une Revue Distributed and Parallel Databases Année : 2009

Parallel OLAP query processing in database clusters with data replication

Résumé

We consider the problem of improving the performance of OLAP applications in a database cluster (DBC), which is a low cost and effective parallel solution for query processing. Current DBC solutions for OLAP query processing provide for intra-query parallelism only, at the cost of full replication of the database. In this paper, we proposemore efficient distributed database design alternatives which combine physical/virtual partitioning with partial replication.We also propose a new load balancing strategy that takes advantage of an adaptive virtual partitioning to redistribute the load to the replicas. Our experimental validation is based on the implementation of our solution on the SmaQSS DBC middleware prototype. Our experimental results using the TPC-H benchmark and a 32-node cluster show very good speedup.

Dates et versions

inria-00473537 , version 1 (15-04-2010)

Identifiants

Citer

Alexandre A.B. Lima, Camille Furtado, Patrick Valduriez, Marta Mattoso. Parallel OLAP query processing in database clusters with data replication. Distributed and Parallel Databases, 2009, 25 (1-2), pp.97-123. ⟨10.1007/s10619-009-7037-8⟩. ⟨inria-00473537⟩
22 Consultations
0 Téléchargements

Altmetric

Partager

Gmail Facebook X LinkedIn More