Efficient Data Distribution for DWS

10 years 8 months ago
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...
Raquel Almeida, Jorge Vieira, Marco Vieira, Henriq
Added 19 Oct 2010
Updated 19 Oct 2010
Type Conference
Year 2008
Authors Raquel Almeida, Jorge Vieira, Marco Vieira, Henrique Madeira, Jorge Bernardino
Comments (0)