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 guide users in data exploration and improve the quality of their interactive experience. In this paper, we propose a framework to predict the most likely next query and recommend this to the user. Our framework relies on a probabilistic user behavior model built by analyzing previous OLAP sessions and exploiting a query similarity metric. To gain insight in the recommendation precision and on what parameters it depends, we evaluate our approach using different quality assessments.
منابع مشابه
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...
متن کاملPROMISE: Predicting Query Behavior to Enable Predictive Caching Strategies for OLAP Systems
This paper discusses the PROMISE (Predicting User Behavior in Multidimensional Information System Environments) approach, that deploys information about characteristic patterns in the user’s multidimensional data access in order to improve caching algorithms of OLAP systems. The paper motivates this approach by presenting results of an analysis of the user behavior in a real-world OLAP environm...
متن کاملMinimizing the MOLAP/ROLAP Divide: You Can Have Your Performance and Scale It Too
Over the past generation, data warehousing and online analytical processing (OLAP) applications have become the cornerstone of contemporary decision support environments. Typically, OLAP servers are implemented on top of either proprietary array-based storage engines (MOLAP) or as extensions to conventional relational DBMSs (ROLAP). While MOLAP systems do indeed provide impressive performance o...
متن کاملInteracting with Statistical Linked Data via OLAP Operations
Online Analytical Processing (OLAP) promises an interface to analyse Linked Data containing statistics going beyond other interaction paradigms such as follow-your-nose browsers, faceted-search interfaces and query builders. Transforming statistical Linked Data into a star schema to populate a relational database and applying a common OLAP engine do not allow to optimise OLAP queries on RDF or ...
متن کاملOptimization Research of the OLAP Query Technology Based on P2P
With the increasing data of the application system, the fast and efficient access to the information of support decision-making analysis has become more and more difficult. At the same time, analysis of the data is no longer on a single server or a single enterprise data, but on multiple servers, multiple departments or multiple enterprise data. So, the original OLAP technologies have also reve...
متن کامل