Efficient Data Distribution for DWS

The DWS (Data Warehouse Striping) technique is a data partitioning approach especially designed for distributed data warehousing environments. In DWS the fact tables are distributed by an arbitrary number of low-cost computers and the queries are executed in parallel by all the computers, guarantying a nearly optimal speed up and scale up. Data loading in data warehouses is typically a heavy process that gets even more complex when considering distributed environments. Data partitioning brings the need for new loading algorithms that conciliate a balanced distribution of data among nodes with an efficient data allocation (vital to achieve low and uniform response times and, consequently, high performance during the execution of queries). This paper evaluates several alternative algorithms and proposes a generic approach for the evaluation of data distribution algorithms in the context of DWS. The experimental results show that the effective loading of the nodes in a DWS system must con...

• Type: Conference
• Year: 2008
• Where: DAWAK
• Authors: Raquel Almeida, Jorge Vieira, Marco Vieira, Henrique Madeira, Jorge Bernardino
• Keywords: Data Partitioning Approach, Data Warehouses, Data Warehousing, DAWAK 2008, Information Management