Optimizer and Scheduling for the Community Data Warehouse Architecture

Authors

Abstract

In today’s internet-connected data driven world, the demand on high performance data management systems is progressively growing. The data warehouse (DW) concept has evolved from a centralized local repository into a broader concept that encompasses a community service with unique storage and processing capabilities. This increase in popularity has lead to the appearance of new DW architectures and optimizations. In this chapter we propose two key inter-related enabler technologies for this vision: a parallel query optimizer which is able to optimize queries in any parallel DW independently of the underlying database management system (DBMS), and a scheduling approach for Grid DWs, which decides in which Grid site a query should be executed.We experimentally prove that the approaches allow the community Data Warehouse to work efficiently.

Keywords

query scheduling, data warehouse, paralllel databases, distributed databases

Subject

Scheduling query execution over parallel and distributed warehouses

Book Chapter

Methods and Supporting Technologies for Data Analysis, II, pp. 21-55, Springer, July 2009