Authors: F. Dehne, M. Lawrence, A. Rau-Chaplin
Addresses: School of Computer Science, Carleton University, Ottawa, Canada. ' Department of Computer Science, University of British Columbia, Vancouver, Canada. ' Faculty of Computer Science, Dalhousie University, Halifax, NS, Canada
Abstract: In this paper, we propose a grid-based On-Line Analytical Processing (OLAP) application which distributes query computation across an enterprise grid. Our application follows a two-tiered process for answering queries based on sharing Cached OLAP data between the users at the local grid site and using grid scheduling approaches to execute the remaining parts of a query amongst a distributed set of OLAP Servers. A new technique for extraction and aggregation of shared Cached OLAP data is proposed, along with an efficient, aggregate-aware Cache controller. An experimental evaluation of the proposed query processing and cooperative Caching methods shows a significant reduction in query times compared to previously proposed methods.
Keywords: OLAP; grid computing; cooperative caching; on-line analytical processing; query computation; answering queries; cache controller; query processing; query time reduction.
International Journal of Grid and Utility Computing, 2009 Vol.1 No.2, pp.169 - 181
Received: 22 Dec 2007
Accepted: 22 Aug 2008
Published online: 16 Dec 2008 *