An extended solution to recommend fuzzy MDX queries for decision-makers by a collaborative filtering profile. (4th March 2021)

• Record Type: Journal Article
• Authors: Hammouche, Djamila; Atif, Karim
• Is Part Of: International journal of decision support systems. Volume 4:Number 3(2021)
• Page Start: 257
• Page End: 270
• Publication Date: 2021-03-04
• Subjects: decision support systems -- data warehouse -- MDX -- profile -- fuzzy logic -- recommendation; Decision making -- Data processing -- Periodicals; 658.40302856312
• Languages: English
• ISSNs: 2050-6988

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.