High-performance Query Processing of a Real-world OLAP Database with ParGRES
Melissa Paes (COPPE/UFRJ; IBGE, Rio de Janeiro, Brazil)Alexandre A.B. Lima (UNIGRANRIO, Rio de Janeiro, Brazil)
Patrick Valduriez (Atlas Group, INRIA and LINA, University of Nantes, France)
Marta Mattoso (COPPE/UFRJ, Rio de Janeiro, Brazil)
Abstract:
Typical OLAP queries take a long time to be processed so speeding up the execution of each single query is imperative to decision making. ParGRES is an open-source database cluster middleware for high performance OLAP query processing. By exploiting intra-query parallelism on PC clusters, ParGRES has shown excellent performance using the TPC-H benchmark. In this paper, we evaluate ParGRES on a real-world OLAP database. Through adaptive virtual partitioning of the database, ParGRES yields linear and very often super-linear speedup for frequent queries. This shows that ParGRES is a very cost-effective solution for OLAP query processing in real settings.
Keywords:
Parallel and Distributed Computing, Cluster Computing, Data-Centric Computing
