Carleton University
Technical Report TR-07-02
January 26, 2007
Parallel ROLAP Data Cubes Performance Comparison and Analysis
Wei Shi, Qi Deng, Boyong Liang
Abstract
The pre-computation of data cubes is critical to improving the response time of On-Line Analytical Processing (OLAP) systems and can be instrumental in accelerating data mining tasks in large data warehouses.
In order to meet the need for improved performance created by growing data sizes, parallel solutions for generating the data cube are becoming increasingly important. This Project Report reports the test result of building and querying data cube between large parallel database: DB2 and Panda system. We have investigated two large parallel databases: DB2 and Oracle 9i.
Under the default setup of DB2 and Panda system, we tested the performance of building a cube in both Panda system and DB2 and also some data cube queries. We mainly studied the Partition difference between Panda system and DB2, then analyze the reason of the test result after the serious study of these two systems.