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.
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 *