ABSTRACT
An OLAP analysis session can be defined as an interactive session during which a user launches queries to navigate within a cube. Very often choosing which part of the cube to navigate further, and thus designing the forthcoming query, is a difficult task. In this paper, we propose to use what the OLAP users did during their former exploration of the cube as a basis for recommending OLAP queries to the user. We present a generic framework that allows to recommend OLAP queries based on the OLAP server query log. This framework is generic in the sense that changing its parameters changes the way the recommendations are computed. We show how to use this framework for recommending simple MDX queries and we provide some experimental results to validate our approach.
- T. Abeel. Java machine learning library. Available at http://sourceforge.net/projects/java-ml, 2008.Google Scholar
- G. Adomavicius and A. Tuzhilin. Toward the next generation of recommender systems: A survey of the state-of-the-art and possible extensions. IEEE Trans. Knowl. Data Eng., 17(6):734--749, 2005. Google ScholarDigital Library
- R. A. Baeza-Yates, C. A. Hurtado, and M. Mendoza. Query recommendation using query logs in search engines. In EDBT Workshops, pages 588--596, 2004.Google ScholarDigital Library
- R. A. Baeza-Yates and B. A. Ribeiro-Neto. Modern Information Retrieval. ACM Press / Addison-Wesley, 1999. Google ScholarDigital Library
- L. Bellatreche, A. Giacometti, P. Marcel, H. Mouloudi, and D. Laurent. A personalization framework for olap queries. In DOLAP, pages 9--18, 2005. Google ScholarDigital Library
- R. W. Hamming. Error detecting and error correcting codes. Syst. Tech. J., 29:147--160, 1950.Google ScholarCross Ref
- F. Hausdorff. Grundzüge der Mengenlehre. von Veit, 1914.Google Scholar
- L. Kaufmann and P. J. Rousseeuw. Clustering by means of medoids. In Y. Dodge, editor, Statistical Data Analysis based on the L1 Norm, pages 405--416. Elsevier/North Holland, Amsterdam, 1987.Google Scholar
- J. M. Kleinberg. Authoritative sources in a hyperlinked environment. J. ACM, 46(5):604--632, 1999. Google ScholarDigital Library
- G. Matheron. Random Sets and Integral Geometry. John Wiley and sons, 1975.Google Scholar
- Microsoft Corporation. Multidimensional expressions (MDX) reference. Available at http://msdn.microsoft.com/en-us/library/ms145506.aspx, 2008.Google Scholar
- G. Navarro. A guided tour to approximate string matching. ACM Comput. Surv., 33(1):31--88, 2001. Google ScholarDigital Library
- OLAP Council. APB-1 OLAP benchmark - release II. Available at http://www.olapcouncil.org/research/bmarkly.htm, 1998.Google Scholar
- C. Sapia. On modeling and predicting query behavior in olap systems. In DMDW, pages 2.1--2.10, 1999.Google Scholar
- C. Sapia. Promise: Predicting query behavior to enable predictive caching strategies for olap systems. In DaWaK, pages 224--233, 2000. Google ScholarDigital Library
- S. Sarawagi. User-adaptive exploration of multidimensional data. In VLDB, pages 307--316, 2000.Google Scholar
- J. Srivastava, R. Cooley, M. Deshpande, and P.-N. Tan. Web usage mining: Discovery and applications of usage patterns from web data. SIGKDD Explorations, 1(2):12--23, 2000. Google ScholarDigital Library
Index Terms
- A framework for recommending OLAP queries
Recommendations
Query recommendations for OLAP discovery driven analysis
DOLAP '09: Proceedings of the ACM twelfth international workshop on Data warehousing and OLAPRecommending database queries is an emerging and promising field of investigation. This is of particular interest in the domain of OLAP systems where the user is left with the tedious process of navigating large datacubes. In this paper we present a ...
A personalization framework for OLAP queries
DOLAP '05: Proceedings of the 8th ACM international workshop on Data warehousing and OLAPOLAP users heavily rely on visualization of query answers for their interactive analysis of massive amounts of data. Very often, these answers cannot be visualized entirely and the user has to navigate through them to find relevant facts.In this paper, ...
Constructing OLAP cubes based on queries
DOLAP '01: Proceedings of the 4th ACM international workshop on Data warehousing and OLAPAn On-Line Analytical Processing (OLAP) user often follows a train of thought, posing a sequence of related queries against the data warehouse. Although their details are not known in advance, the general form of those queries is apparent beforehand. ...
Comments