Authors:
Tekaya Karima
;
Abdellaziz Abdelatif
and
Habib Ounalli
Affiliation:
Faculty of Sciences of Tunis, Tunisia
Keyword(s):
Distributed data warehouse, Fragment Evaluator, Fragmentation, Allocation, Primary and derived horizontal fragmentation.
Related
Ontology
Subjects/Areas/Topics:
Artificial Intelligence
;
Impact Measurement of Knowledge Management
;
Knowledge Management and Information Sharing
;
Knowledge-Based Systems
;
Studies, Metrics & Benchmarks
;
Symbolic Systems
Abstract:
Since a relational data warehouse has the same physical structure as a classical database, it can enjoy all the benefits realized during the past in distributed databases such us data availability, simplicity, rapid local data access and transparent access to remote sites. So, it would be interesting to test its decentralization by adapting the most adequate fragmentation and allocation technique. In this paper, we present a data warehouse fragmentation and allocation approach in a distributed context. We conduct first, computation studies using a mathematical cost model. Then, we test our approach on a real data warehouse by using the APB1 benchmark data set on Oracle11G.