Parallel OLAP with the Sidera server

  • Authors:
  • Todd Eavis;George Dimitrov;Ivan Dimitrov;David Cueva;Alex Lopez;Ahmad Taleb

  • Affiliations:
  • Concordia University, Montreal, Canada;Concordia University, Montreal, Canada;Concordia University, Montreal, Canada;Concordia University, Montreal, Canada;Concordia University, Montreal, Canada;Concordia University, Montreal, Canada

  • Venue:
  • Future Generation Computer Systems
  • Year:
  • 2010

Quantified Score

Hi-index 0.00

Visualization

Abstract

Online Analytical Processing (OLAP) has become a primary component of today's pervasive Decision Support systems. As the underlying databases grow into the multi-terabyte range, however, single CPU OLAP servers are being stretched beyond their limits. In this paper, we present a comprehensive model for a fully parallelized OLAP server. Our multi-node platform actually consists of a series of largely independent sibling servers that are ''glued'' together with a lightweight MPI-based Parallel Service Interface (PSI). Physically, we target the commodity-oriented, ''shared nothing'' Linux cluster, an architecture that provides an extremely cost effective alternative to the ''shared everything'' commercial platforms often used in high-end database environments. Experimental results demonstrate both the viability and robustness of the design.