Data warehouse decentralization strategy
A Data Warehouse (DW) is characterized by huge amount of data centralized in a single database. This centralization has negative impacts on its performance especially for distributed companies; such us elevated storage cost, high query execution time and hard maintenance task. 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 like data availability, simplicity, rapid local data access and transparent access to remote sites. Then, it would be interesting to manage and test its decentralization on several distant sites. However, very few studies have considered this topic. In this paper, we present a relational DW decentralization strategy. We show experimentally with the use of the APB-1 release II benchmark that DW decentralization gives better performance than the centralized context. Global queries execution time is reduced by 80％.
Distributed data warehouse Allocation Fragment Evaluator.
Tekaya karima Abdellaziz Abdelatif Ounalli Habib
Data-processing Department Faculty of sciences of Tunis Tunisia, ElManar2
国际会议
2010 IEEE International Conference on e-Business Engineering(2010年电子商务工程国际研讨会 ICEBE 2010)
上海
英文
72-76
2010-11-10（万方平台首次上网日期，不代表论文的发表时间）