By Topic

Data mining based fragmentation technique for distributed data warehouses environment Using predicate construction technique

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$31 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

3 Author(s)
Karima, T. ; Data-Process. Dept., Fac. of Sci. of Tunis, Tunis, Tunisia ; Abdellatif, A. ; Ounalli, H.

Distributed Data Warehouses (DDWs) afford several advantages over traditional environments. Such architecture improves system performance by allowing data to be spread across data marts. Subsequently, queries can be run over smaller data sets and therefore their execution time reduces. To design an effective distributed model, it is important to manage an appropriate methodology for data fragmentation and fragment allocation. Nevertheless, very little works address this problem in a distributed context. This paper is focuses on DDW. It proposes a data mining-based horizontal fragmentation methodology for a relational DDW environment. This methodology combines the known predicate construction technique with a clustering method to fragment Data Warehouse (DW) relations. Fragments are then allocated to the corresponding site according to their frequency of use. We show experimentally with the use of the APB-1 release II benchmark that DW decentralization gives better performance. Global queries execution time is fewer by 80%.

Published in:

Networked Computing and Advanced Information Management (NCM), 2010 Sixth International Conference on

Date of Conference:

16-18 Aug. 2010