Title: Exploiting data access for dynamic fragmentation in data warehouse

Authors: Hacène Derrar; Mohamed Ahmed-Nacer; Omar Boussaid

Addresses: LSI Laboratory, Faculty of Electronic and Computer Science, USTHB, Bp 32 El Alia 16111, Bab Ezzouar, Algiers, Algeria ' LSI Laboratory, Faculty of Electronic and Computer Science, USTHB, Bp 32 El Alia 16111, Bab Ezzouar, Algiers, Algeria ' ERIC Laboratory, University of Lyon 2, 5 Avenue Pierre Mendes-France 69676 Bron Cedex, France

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.

Keywords: data fragmentation; query performance; optimisation; intelligent information; database systems; data warehousing; OLAP queries; statistical data access; query response time; data management; accessibility.

DOI: 10.1504/IJIIDS.2013.051736

International Journal of Intelligent Information and Database Systems, 2013 Vol.7 No.1, pp.34 - 52

Received: 30 Aug 2011
Accepted: 06 Mar 2012
Published online: 31 Mar 2014 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article