Principles of distributed database systems
Principles of distributed database systems
Implementing data cubes efficiently
SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
An overview of data warehousing and OLAP technology
ACM SIGMOD Record
A horizontal fragmentation algorithm for the fact relation in a distributed data warehouse
Proceedings of the eighth international conference on Information and knowledge management
Selecting and materializing horizontally partitioned warehouse views
Data & Knowledge Engineering
Algorithms for Materialized View Design in Data Warehousing Environment
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Maintaining Horizontally Partitioned Warehouse Views
DaWaK 2000 Proceedings of the Second International Conference on Data Warehousing and Knowledge Discovery
FRAGTIQUE: An OO Distribution Design Methodology
DASFAA '99 Proceedings of the Sixth International Conference on Database Systems for Advanced Applications
A UML-based Metamodeling Architecture for Database Design
IDEAS '01 Proceedings of the International Database Engineering & Applications Symposium
A Case for Parallelism in Data Warehousing and OLAP
DEXA '98 Proceedings of the 9th International Workshop on Database and Expert Systems Applications
| Hi-index | 0.00 |
We propose a strategy for distribution of a relational data warehouse organized according to a star schema. We adapt fragmentation and allocation strategies that were developed for OO databases. We split the most-often-accessed dimension table into fragments by using primary horizontal fragmentation. The derived fragmentation then divides the fact table into fragments. Other dimension tables are not fragmented since they are presumed to be sufficiently small. Allocation of fragments encompasses duplication of non-fragmented dimension tables that we call a closure.