Personalized OLAP queries under Hierarchical Visualization Constraint*
Ghassen Hamdi, Mohamed Nazih Omri · 2023
Decision makers do not evaluate all decision facts in the same way since their requirements differ greatly depending on their specialty, levels of knowledge, and other factors. Everyone has the right to have their own tastes and needs. The multidimensional model is intended for a group of decision-makers and consists of a set of data studied according to different dimensions. It contains all the indicators and analysis axes for a particular domain. They do not take into account the preferences of each decision-maker. A personalization phase of this diagram according to the preferences of these decision-makers would enrich the decision-making process. Another problem for consumers is the inability of mobile devices (smartphones, tablets, etc.) to display the results of OLAP queries. This paper presents a new approach in which preferences are expressed as visualization constraints that are applied sequentially to the schema to represent the result. This approach makes it possible to adapt the output to the profile choices while keeping in mind the constraint of visualization. Our strategy is based on the personalization of concepts and multidimensional data using a quantitative approach. This model interprets new preferences not expressed by the user based on the hierarchical structure of the data in the warehouse. We implemented our approach by considering three standard metrics, namely precision, recall, and F-measure. The results we obtained are very encouraging and confirm the feasibility of our proposed approach.