ABSTRACT
OLAP 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, we propose a framework for personalizing OLAP queries. In this framework, the user is asked to give his (her) preferences and a visualization constraint, that can be for instance the limitations imposed by the device used to display the answer to a query. Given this, for each query, our method computes the part of the answer that respects both the user preferences and the visualization constraint. In addition, a personalized structure for the visualization is proposed.
- R. Agrawal and E. L. Wimmers. A framework for expressing and combining preferences. In W. Chen, J. F. Naughton, and P. A. Bernstein, editors, Proceedings of the 2000 ACM SIGMOD International Conference on Management of Data, May 16-18, 2000, Dallas, Texas, USA, pages 297--306. ACM, 2000. Google ScholarDigital Library
- L. Bellatreche and K. Boukhalfa. An evolutionary approach to schema partitioning selection in a data warehouse environment. To appear in Proceeding of the International Conference on Data Warehousing and Knowledge Discovery (DAWAK'2005), pages 115--125, 2005. Google ScholarDigital Library
- L. Bellatreche, A. Giacometti, D. Laurent, P. Marcel, and H. Mouloudi. A framework for combining rule-based and cost-based approaches to optimize OLAP queries. Numéro spécial, Entrepôts de Données et Analyse en ligne, RNTI, to be published., 2005.Google Scholar
- S. Chaudhuri. Index selection for databases: A hardness study and a principled heuristic solution. IEEE Transactions on Knowledge and Data Engineering, 16(11):1313--1323, November 2004. Google ScholarDigital Library
- S. Chaudhuri and U. Dayal. An overview of data warehousing and olap technology. Sigmod Record, 26(1):65--74, March 1997. Google ScholarDigital Library
- J. Chomicki. Preference formulas in relational queries. ACM Trans. Database Syst., 28(4):427--466, 2003. Google ScholarDigital Library
- M. Corporation. OLEDB for OLAP. Available at http://www.microsoft.com/ data/oledb/olap, 1998.Google Scholar
- B. Ganter and R. Wille. Formal Concept Analysis: Mathematical Foundations. Springer-Verlag New York, Inc., Secaucus, NJ, USA, 1997. Translator-C. Franzke. Google ScholarDigital Library
- M. R. Garey and D. S. Johnson. Computers and Intractability: A Guide to the Theory of NP-Completeness. Freeman, San Francisco, 1979. Google ScholarDigital Library
- H. Gupta, V. Harinarayan, A. Rajaraman, and J. Ullman. Index selection for olap. Proceedings of the International Conference on Data Engineering (ICDE), pages 208--219, 1997. Google ScholarDigital Library
- W. Kießling. Foundations of preferences in database systems. In Proceedings of 28th International Conference on Very Large Data Bases, pages 311--322. Morgan Kaufmann, 2002. Google ScholarDigital Library
- G. Koutrika and Y. E. Ioannidis. Personalization of queries in database systems. In ICDE, pages 597--608. IEEE Computer Society, 2004. Google ScholarDigital Library
- A. S. Maniatis, P. Vassiliadis, S. Skiadopoulos, and Y. Vassiliou. Advanced visualization for olap. In DOLAP '03: Proceedings of the 6th ACM international workshop on Data warehousing and OLAP, pages 9--16, New York, NY, USA, 2003. ACM Press. Google ScholarDigital Library
- P. Marcel. Modeling and querying multidimensional databases: An overview. Networking and Information Systems Journal, 2(5-6):515--548, 1999.Google Scholar
- P. E. O'Neil and D. Quass. Improved query performance with variant indexes. In J. Peckham, editor, Proceedings of ACM SIGMOD International Conference on Management of Data, pages 38--49. ACM Press, 1997. Google ScholarDigital Library
- M. T. Özsu and P. Valduriez. Principles of Distributed Database Systems : Second Edition. Prentice Hall, 1999. Google ScholarDigital Library
Index Terms
- A personalization framework for OLAP queries
Recommendations
A framework for recommending OLAP queries
DOLAP '08: Proceedings of the ACM 11th international workshop on Data warehousing and OLAPAn 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 ...
A framework for OLAP content personalization
ADBIS'10: Proceedings of the 14th east European conference on Advances in databases and information systemsA perennial challenge faced by many organizations is the management of their increasingly large multidimensional databases (MDB) that can contain millions of data instances. The problem is exacerbated by the diversity of the users' specific needs. ...
Rule-based query personalization in digital libraries
Searching a digital library is typically a tedious task. A system can improve information access by building on knowledge about a user acquired in a user profile in order to customize information access both in terms of the information returned in ...
Comments