Title :
Implementing OLAP Query Fragment Aggregation and Recombination for the OLAP Enabled Grid
Author :
Lawrence, Michael ; Dehne, Frank ; Rau-Chaplin, Andrew
Author_Institution :
Dept. of Comput. Sci., British Columbia Univ., Vancouver, BC
Abstract :
In this paper we propose a new query processing method for the OLAP enabled grid, which blends sophisticated cache extraction techniques and data grid scheduling to efficiently satisfy OLAP queries in a distributed fashion. The heart of our approach is our query fragment aggregation and recombination (FAR) strategy that partitions OLAP queries into subqueries which can be effectively answered by retrieving and aggregating multiple fragments of cached data from nearby grid sources, or as a last resort, more remote backend data warehouses. We have implemented and experimentally evaluated our query processing method and found that our strategy reduces query time between 50% and 60% for practical user cache sizes and network parameters.
Keywords :
data mining; data warehouses; grid computing; query processing; scheduling; OLAP query fragment aggregation; cache extraction; data grid scheduling; data warehouses; online analytical processing; query processing; Computer science; Data mining; Data warehouses; Heart; Information retrieval; Job shop scheduling; Manufacturing; Marketing and sales; Processor scheduling; Query processing;
Conference_Titel :
Parallel and Distributed Processing Symposium, 2007. IPDPS 2007. IEEE International
Conference_Location :
Long Beach, CA
Print_ISBN :
1-4244-0910-1
Electronic_ISBN :
1-4244-0910-1
DOI :
10.1109/IPDPS.2007.370552