Exploiting data access for dynamic fragmentation in data warehouse. (1st January 2013)

• Record Type: Journal Article
• Authors: Derrar, Hacène; Ahmed-Nacer, Mohamed; Boussaid, Omar
• Is Part Of: International journal of intelligent information and database systems. Volume 7:Number 1(2013)
• Page Start: 34
• Page End: 52
• Publication Date: 2013-01-01
• Subjects: fragmentation -- performance -- optimisation -- intelligent information -- database systems -- data warehouse -- OLAP queries; Database management -- Computer programs -- Periodicals; Information retrieval -- Computer programs -- Periodicals; Information storage and retrieval systems -- Computer programs -- Periodicals; Artificial intelligence -- Periodicals; Expert systems (Computer science) -- Periodicals; Intelligent agents (Computer software) -- Periodicals; 006.33
• Languages: English
• ISSNs: 1751-5858

Abstract

The large size of a data warehouse and the complexity of OLAP queries constitute query performance challenges. Several techniques have been developed to reduce query response time. Data fragmentation improves significantly data management, accessibility and query execution time. Optimal fragmentation schema is designed from workload gathered from data exploitation. So, in context of relational- and object-oriented databases these techniques remain adapted because the workload is almost stable. However, the specific characteristics of data warehouse and more particularly the nature of OLAP queries makes data model and workload very dynamic and consequently an ineffective designed fragmentation schema. To achieve this problem, we propose in this paper an approach based on exploitation of recent statistical data access for dynamic data fragmentation in data warehouse.