Title: An extended solution to recommend fuzzy MDX queries for decision-makers by a collaborative filtering profile

Authors: Djamila Hammouche; Karim Atif

Addresses: Department of Computer Science, Faculty of Exact Sciences and Informatics, Hassiba Ben Bouali University of Chlef, P.O. Box 78, 02000, Ouled Fares Chlef, Algeria ' Department of Computer Science, Faculty of Electronics and Computer Science, University of Sciences and Technology Houari Boumediene, Algiers, Algeria

Abstract: Education decision-makers need to analyse the success rate of the baccalaureate according to different criteria. In this paper, we propose to extend our previous solution where we have defined only three terms in natural language. Our extended solution consists modelling a data warehouse according to the Fasel model. It allows the recommendation of MDX queries which contain these terms in natural language according to the decision-maker's profile. We present an overview of the work related to our subject and we present the fuzzy data model together with the meta tables and the modelling of the membership functions. Finally, we present our results. Furthermore, we have carried out a comparative study between the use of SQL and MDX requests and we have concluded that the use of MDX made the system more efficient.

Keywords: decision support systems; data warehouse; MDX; profile; fuzzy logic; recommendation.

DOI: 10.1504/IJDSS.2021.113767

International Journal of Decision Support Systems, 2021 Vol.4 No.3, pp.257 - 270

Received: 04 Mar 2020
Accepted: 30 Jul 2020
Published online: 22 Mar 2021 *