Feature-based recommendation framework on OLAP
نویسندگان
چکیده
The queries in Online Analytical Processing (OLAP) are user-guided. OLAP is based on a multidimensional data model for complex analytical and ad-hoc queries with a rapid execution time. Those queries are either routed or on-demand revolved around the OLAP task. Most such queries are reusable and optimized in the system. Therefore, the queries recorded in the query logs for completing various OLAP tasks may be reusable. The query logs usually contain a sequence of SQL queries that show the action flows of users for their preference, their interests, and their behaviours during the action. This research investigates the feature extraction to identify query patterns and user behaviours from historical query logs. The expected results will be used to recommend forthcoming queries to help decision makers with data analysis. The purpose of this work is to improve the efficiency and effectiveness of OLAP in terms of computation cost and response time. Furthermore, the proposed OLAP system will be able to adjust some parameters for finding common behaviours from different users that make the recommendation system flexible and user-adaptive. .
منابع مشابه
Personnalisation d'analyses décisionnelles sur des données multidimensionnelles
This thesis investigates OLAP analysis personalization within multidimensional databases.OLAP analyse is modeled through a graph where nodes represent the analysis contexts andgraph edges represent the user operations. The analysis context regroups the user query aswell as result. It is well described by a specific tree structure that is independent on thevisualization structure...
متن کاملPreference-Based Recommendations for OLAP Analysis
This paper presents a framework for integrating OLAP and recommendations. We focus on the anticipatory recommendation process that assists the user during his OLAP analysis by proposing to him the forthcoming analysis step. We present a context-aware preference model that matches decisionmakers intuition, and we discuss a preference-based approach for generating personalized recommendations.
متن کاملTowards a logical framework for OLAP query log manipulation
This paper proposes a manipulation language tailored for OLAP query logs, stemming from the relational algebra. This language is based on binary relations over sequences of queries (called sessions). We propose two such relations allowing to group and order sessions. Examples of expressions in this language illustrate its interest for various user-centric approaches, like query recommendation o...
متن کاملPredicting Your Next OLAP Query Based on Recent Analytical Sessions
In Business Intelligence systems, users interact with data warehouses by formulating OLAP queries aimed at exploring multidimensional data cubes. Being able to predict the most likely next queries would provide a way to recommend interesting queries to users on the one hand, and could improve the efficiency of OLAP sessions on the other. In particular, query recommendation would proactively gui...
متن کاملSM4MQ: A Semantic Model for Multidimensional Queries
On-Line Analytical Processing (OLAP) is a data analysis approach to support decision-making. On top of that, Exploratory OLAP is a novel initiative for the convergence of OLAP and the Semantic Web (SW) that enables the use of OLAP techniques on SW data. Moreover, OLAP approaches exploit different metadata artifacts (e.g., queries) to assist users with the analysis. However, modeling and sharing...
متن کامل