Skip to main content
SpringerLink
Log in

Research Directions of OLAP Personalizaton

  • Conference paper
  • First Online:
Information Systems Development

Abstract

In this paper we have highlighted five existing approaches for introducing personalization in OLAP: preference constructors, dynamic personalization, visual OLAP, recommendations with user session analysis and recommendations with user profile analysis and have analyzed research papers within these directions. We have provided an evaluation in order to point out (i) personalization options, described in these approaches, and its applicability to OLAP schema elements, aggregate functions, OLAP operations, (ii) the type of constraints (hard, soft or other), used in each approach, (iii) the methods for obtaining user preferences and collecting user information. The goal of our paper is to systematize the ideas proposed already in the field of OLAP personalization to find out further possibility for extending or developing new features of OLAP personalization.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 259.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 329.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 329.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Koutrika G, Ioannidis YE (2004) Personalization of queries in database systems. In: Proceedings of 20th international conference on data engineering (ICDE’04), Boston, 30 Mar–2 Apr 2004, pp 597–608

    Google Scholar 

  2. Garrigós I, Pardillo J, Mazón J-N, Trujillo J (2009) A conceptual modeling approach for OLAP personalization. In: Conceptual modeling—ER 2009, LNCS 5829. Springer, Heidelberg, 401–414

    Google Scholar 

  3. Golfarelli M, Rizzi S (2009) Expressing OLAP preferences, LNCS 5566/2009. Scientific and Statistical Database Management, Berlin/Heidelberg, pp 83–91

    Google Scholar 

  4. Giacometti A, Marcel P, Negre E, Soulet A (2009) Query recommendations for OLAP discovery driven analysis. In: Proceedings of 12th ACM international workshop on data warehousing and OLAP (DOLAP’09), Hong Kong, 6 Nov 2009, pp 81–88

    Google Scholar 

  5. Jerbi H, Ravat F, Teste O, Zurfluh G (2009) Preference-based recommendations for OLAP analysis. In: Proceedings of the 11th international conference on data warehousing and knowledge discovery (DaWaK’09), Linz, Austria, 31 Aug–Sept 2009, pp 467–478

    Google Scholar 

  6. Mansmann S, Scholl MH (2007) Exploring OLAP aggregates with hierarchical visualization techniques. In: Proceedings of 22nd annual ACM symposium on applied computing (SAC’07), Multimedia and visualization track, Mar 2007, Seoul, Korea, pp 1067–1073

    Google Scholar 

  7. Mansmann S, Scholl MH (2008) Visual OLAP: a new paradigm for exploring multidimensonal aggregates. In: Proceedings of IADIS international conference on computer graphics and visualization (MCCSIS’08), Amsterdam, The Netherlands, 24–26 July 2008, pp 59–66

    Google Scholar 

  8. Solodovnikova D (2007) Data warehouse evolution framework. In: Proceedings of the spring young researcher’s colloquium on database and information systems SYRCoDIS, Moscow, Russia. http://ceur-ws.org/Vol-256/submission_4.pdf

    Google Scholar 

  9. Thalhammer T, Schrefl M, Mohania M (2001) Active data warehouses: complementing OLAP with active rules. Data Knowl Eng 39(3):241–269, Dec 2001, Elsevier Science Publishers B. V., Amsterdam, The Netherlands

    Google Scholar 

  10. Garrigós I, Gómez J (2006) Modeling user behaviour aware websites with PRML. In: Proceedings of the CAISE’06 3rd international workshop on web information systems modeling (WISM’06), Luxemburg, 5–9 June 2006, pp 1087–1101

    Google Scholar 

  11. Ravat F, Teste O (2009) Personalization and OLAP databases. Ann Inf Syst 3:1–22, New Trends in Data Warehousing and Data Analysis, Springer US

    Google Scholar 

  12. Bellatreche L, Giacometti A, Marcel P, Mouloudi H (2006) Personalization of MDX queries. In: Proceedings of XXIIemes journees Bases de Donnees Avancees (BDA’06), Lille, France

    Google Scholar 

  13. Kimball R, Ross M (2002) The data warehouse toolkit: the complete guide to dimensional modeling, 2nd edn. Wiley, New York

    Google Scholar 

  14. Lenz H-J, Thalheim B (2009) A formal framework of aggregation for the OLAP-OLTP model. J Universal Comput Sci 15(1):273–303

    MathSciNet  MATH  Google Scholar 

  15. Inmon WH (2002) Building the data warehouse, 3rd edn. Wiley Computer Publishing, New York, 428 p

    Google Scholar 

  16. Adamson C (2006) Mastering data warehouse aggregates: solutions for star schema performance. Wiley Computer Publishing, New York, 384 p

    Google Scholar 

  17. Agrawal R, Wimmers E (2000) A framework for expressing and combining preferences. In: Proceedings of the ACM SIGMOD international conference on management of data. ACM, New York, pp 297–306

    Google Scholar 

  18. Borzsonyi S, Kossmann D, Stocker K (2001) The skyline operator. In: Proceedings of 17th international conference on data engineering, Heidelberg, April 2001

    Google Scholar 

  19. Kießling W (2002) Foundations of preferences in database systems. In: Proceedings the international conference on very large databases (VLDB’02), Hong Kong, China, pp 311–322

    Google Scholar 

  20. Chomicki J (2003) Preference formulas in relational queries. ACM TODS 28(4):427–466

    Article  MathSciNet  Google Scholar 

  21. Kießling W, Köstler G (2002) Preference SQL-design, implementation, experiences. In: Proceedings of the international conference on very large databases (VLDB’02), Hong Kong, China, pp 990–1001

    Google Scholar 

  22. Pu P, Faltings B, Torrens M (2003) User-involved preference elicitation. In: IJCAI’03 workshop on configuration, Acapulco, Mexico

    Google Scholar 

  23. Hafenrichter B, Kießling W (2005) Optimization of relational preference queries. In: Proceedings of the 16th Australasian database conference, ADC 2005, vol 39, Newcastle, Australia, 31 Jan–3 Feb 2005, pp 175–184

    Google Scholar 

  24. Kießling W (2006) Preference handling in database systems. Talk at L3S, University of Hannover, 6 Feb 2006

    Google Scholar 

  25. Kießling W (2005) Preference queries with SV-semantics. In: Proceedings of COMAD’05, Goa, India, pp 15–26

    Google Scholar 

  26. Sarawagi S (1999) Explaining differences in multidimensional aggregates. In: Proceedings of the international conference on very large databases (VLDB’99), 7–10 Sept 1999, Edinburgh, Scotland, UK, pp 42–53

    Google Scholar 

  27. Gauch S, Speretta M, Chandramouli A., Micarelli A (2007) User profiles for personalized information access. In: Brusilovsky P, Kobsa A, Nejdl W (eds) The adaptive web (Chap. 2), LNCS 4321. Springer, Berlin, pp 54–87

    Google Scholar 

  28. Kelly D, Teevan J (2003) Implicit feedback for inferring user preference: a bibliography. ACM SIGIR Forum 37(2):18–28

    Article  Google Scholar 

  29. Burke R (2002) Hybrid recommender systems: survey and experiments. User Model User Adapted Interact 12(4):331–370, Kluwer Academic Publishers, Norwell

    Article  Google Scholar 

  30. Viappiani P, Pu P, Faltings B (2002) Acquiring user preferences for personal agents. Technical report for American Association for Artificial Intelligence (AAAI Press). http://liawww.epfl.ch/Publications/Archive/Viappiani2002.pdf

    Google Scholar 

  31. Shearin S, Lieberman H (2001) Intelligent profiling by example. In: Proceedings of IUI’01, Santa Fe, New Mexico, USA, 14–17 Jan 2001, pp 145–151

    Google Scholar 

Download references

Acknowledgments

This work has been supported by ESF project No.2009/0216/1DP/1.1.1.2.0/09/APIA/VIAA/044.

Author information

Authors and Affiliations

  1. Faculty of Computing, University of Latvia, Riga LV-1586, Riga, Latvia

    Natalija Kozmina & Laila Niedrite

Authors
  1. Natalija Kozmina
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Laila Niedrite
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Natalija Kozmina .

Editor information

Editors and Affiliations

  1. Fac. Mathematics & Physics, Dept. Software Engineering, Charles University Praha, Malostranske nam. 25, Praha 1, 118 00, Czech Republic

    Jaroslav Pokorny

  2. Dept. Information Technologies, Attn. Prof. Jiri Vorisek, Prague University of Economics, Nam. W. Churchilla 4, Praha, 130 67, Czech Republic

    Vaclav Repa

  3. Fac. Mathematics & Physics, Charles University, Praha, Malostranske nam. 25, Praha 1, 118 00, Czech Republic

    Karel Richta

  4. College of Business & Economics, Dept. Information Technology &, Boise State University, Univesity Dr. 1910, Boise, 83725-1615, Idaho, USA

    Wita Wojtkowski

  5. Fac. Information Technology, Monash University, Clayton, 3800, Victoria, Australia

    Henry Linger

  6. Dept. Accountancy & Finance, National University of Ireland, University Road, Galway, Ireland

    Chris Barry

  7. Dept. Accountancy & Finance, National University of Ireland, University Road, Galway, Ireland

    Michael Lang

Rights and permissions

Reprints and permissions

Copyright information

© 2011 Springer Science+Business Media, LLC

About this paper

Cite this paper

Kozmina, N., Niedrite, L. (2011). Research Directions of OLAP Personalizaton. In: Pokorny, J., et al. Information Systems Development. Springer, New York, NY. https://doi.org/10.1007/978-1-4419-9790-6_28

Download citation

  • DOI: https://doi.org/10.1007/978-1-4419-9790-6_28

  • Published:

  • Publisher Name: Springer, New York, NY

  • Print ISBN: 978-1-4419-9645-9

  • Online ISBN: 978-1-4419-9790-6

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation