Title: Performance optimisation of the decision-support queries by the horizontal fragmentation of the data warehouse

Authors: Mohamed Kechar; Safia Nait-Bahloul

Addresses: Lab. LITIO, University of Oran1, Ahmed Ben Bella, Algeria ' Lab. LITIO, University of Oran1, Ahmed Ben Bella, Algeria

Abstract: The horizontal fragmentation of the data warehouse is considered as one of the important performance optimisation techniques of the decision-support queries. This optimisation is reached only if the large data volume of the fact table is horizontally fragmented. For that, the fragments of the fact table are always derived from the fragments of the dimension tables. Unfortunately, in this type of fragmentation, the fragments number can dramatically increase, and their maintenance becomes quite hard and costly. Thus, to reduce the number of the fragments and to further optimise the decision-support queries performances, we propose to fragment horizontally only the fact table by exploiting jointly: the selectivities of the selection predicates, their occurrence numbers, and their access frequencies. To prove the effectiveness of our fragmentation technique, we present at the end, a set of experimental results conducted under Oracle 10g on the APB-1 benchmark.

Keywords: decision support system; data warehouse; query performance optimisation; horizontal fragmentation; selection predicates; fragmentation predicates.

DOI: 10.1504/IJBIS.2017.087750

International Journal of Business Information Systems, 2017 Vol.26 No.4, pp.506 - 537

Received: 23 Oct 2015
Accepted: 19 Jun 2016
Published online: 01 Nov 2017 *

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