6533b825fe1ef96bd1282660

RESEARCH PRODUCT

Fragtique: Applying an OO Database Distribution Strategy to Data Warehouse

Marie-noëlle TerrasseMarinette Savonnet

subject

Theoretical computer scienceDatabaseComputer scienceRelational databaseFragmentation (computing)Dimension tableA* search algorithmFact tablecomputer.software_genreData warehouselaw.inventionData cubelawSchema (psychology)Data miningcomputer

description

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.

yearjournalcountryeditionlanguage
2001-01-01
https://doi.org/10.1007/3-540-44801-2_33