Title: Improving QoS in real-time data warehouses by using feedback control scheduling

Authors: Issam Hamdi; Emna Bouazizi; Saleh Alshomrani; Jamel Feki

Addresses: MIRACL Laboratory, University of Sfax, Sfax 3018, Tunisia ' MIRACL Laboratory, University of Sfax, Sfax 3018, Tunisia ' Faculty of Computing and IT, University of Jeddah, Jeddah, Saudi Arabia ' Faculty of Computing and IT, University of Jeddah, Jeddah, Saudi Arabia; MIRACL Laboratory, University of Sfax, Sfax 3018, Tunisia

Abstract: Nowadays the update frequency for traditional data warehouses cannot meet the objectives of real-time data analysis relying on data freshness. To alleviate this problem, the real-time data warehouse (RTDW) technology has emerged. A RTDW allows decision makers to access and analyse fresh data as fast as possible in order to support real-time decision processes. The RTDW must often deal with transient usage charges, due to the unpredictability of access to data. The purpose of this paper is two-fold: to maintain the behaviour of the RTDW at a stable state, as well as the reduction of the number of transactions responsible for not meeting their deadline. Moreover, we focus on optimisation techniques to speed up query processing; in particular, a query response time optimisation and storage space optimisation. This paper proposes our FCSA-RTDW architecture (feedback control scheduling architecture for RTDW) which deals with quality of service management by optimising the resources used and reducing significantly the RTDW overloads.

Keywords: real-time data warehouse; RTDW; real-time transactions; quality of service; QoS; materialised views; data partitioning.

DOI: 10.1504/IJIDS.2018.093933

International Journal of Information and Decision Sciences, 2018 Vol.10 No.3, pp.181 - 211

Received: 11 Apr 2016
Accepted: 01 Apr 2017
Published online: 09 Aug 2018 *

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