Parallel database systems: the future of high performance database systems
Communications of the ACM
An overview of data warehousing and OLAP technology
ACM SIGMOD Record
Join synopses for approximate query answering
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom
Query Processing in Parallel Relational Database Systems
Query Processing in Parallel Relational Database Systems
Approximate Query Answering Using Data Warehouse Striping
Journal of Intelligent Information Systems - Special issue on data warehousing and knowledge discovery
The Gamma Database Machine Project
IEEE Transactions on Knowledge and Data Engineering
Experimental Evaluation of a New Distributed Partitioning Technique for Data Warehouses
IDEAS '01 Proceedings of the International Database Engineering & Applications Symposium
Horizontal fragmentation as a technique to improve the performance of drill-down and roll-up queries
Proceedings of the 2007 ACM symposium on Applied computing
Consistency-aware evaluation of OLAP queries in replicated data warehouses
Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
Hi-index | 0.00 |
The DWS (Data Warehouse Striping) technique allows the distribution of large data warehouses through a cluster of computers. The data partitioning approach partition the facts tables through all nodes and replicates the dimension tables. The replication of the dimension tables creates a limitation to the applicability of the DWS technique to data warehouses with big dimensions. This paper proposes a strategy to handle large dimensions in a distributed DWS system and evaluates the proposed strategy experimentally. With the proposed strategy the performance speed up and scale up obtained in the DWS technique are not affected by the presence of big dimensions. Furthermore, it extends the scope of the technique to queries that browse big dimensions that can also benefit of the performance increase of the DWS technique.