Skip to main content
SpringerLink
Log in
Book cover

International Conference on Business Informatics Research

BIR 2010: Perspectives in Business Informatics Research pp 188–202Cite as

OLAP Personalization with User-Describing Profiles

  • Conference paper

Part of the book series: Lecture Notes in Business Information Processing ((LNBIP,volume 64))

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 pointed out applicability of personalization to OLAP schema elements in these approaches. The comparative analysis has been made in order to highlight a certain personalization approach. A new method has been proposed, which provides exhaustive description of interaction between user and data warehouse, using the concept of Zachman Framework [1, 2], according to which a set of user-describing profiles (user, preference, temporal, spatial, preferential and recommendational) have been developed. Methods of profile data gathering and processing are described in this paper.

This is a preview of subscription content, 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   39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.99
Price excludes VAT (USA)
  • Compact, lightweight 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

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Zachman, J.A.: The Zachman Framework: A Primer for Enterprise Engineering and Manufacturing. In: Zachman International (2003)

    Google Scholar 

  2. The Zachman FrameworkTM for Enterprise Architecture, http://www.zachmaninternational.com/index.php/the-zachman-framework

  3. Koutrika, G., Ioannidis, Y.E.: Personalization of Queries in Database Systems. In: Proceedings of 20th International Conference on Data Engineering (ICDE’04), Boston, MA, USA, March 30-April 2, pp. 597–608 (2004)

    Google Scholar 

  4. Garrigós, I., Pardillo, J., Mazón, J.-N., Trujillo, J.: A Conceptual Modeling Approach for OLAP Personalization. In: Laender, A.H.F. (ed.) ER 2009. LNCS, vol. 5829, pp. 401–414. Springer, Heidelberg (2009)

    Google Scholar 

  5. Golfarelli, M., Rizzi, S.: Expressing OLAP Preferences. In: Winslett, M. (ed.) SSDBM 2009. LNCS, vol. 5566, pp. 83–91. Springer, Heidelberg (2009)

    Google Scholar 

  6. Giacometti, A., Marcel, P., Negre, E., Soulet, A.: Query Recommendations for OLAP Discovery Driven Analysis. In: Proceedings of 12th ACM International Workshop on Data Warehousing and OLAP (DOLAP’09), Hong Kong, November 6, pp. 81–88 (2009)

    Google Scholar 

  7. Jerbi, H., Ravat, F., Teste, O., Zurfluh, G.: Preference-Based Recommendations for OLAP Analysis. In: Pedersen, T.B., Mohania, M.K., Tjoa, A.M. (eds.) Data Warehousing and Knowledge Discovery. LNCS, vol. 5691, pp. 467–478. Springer, Heidelberg (2009)

    Chapter  Google Scholar 

  8. Mansmann, S., Scholl, M.H.: Exploring OLAP Aggregates with Hierarchical Visualization Techniques. In: Proceedings of 22nd Annual ACM Symposium on Applied Computing (SAC’07), Multimedia & Visualization Track, Seoul, Korea, March 2007, pp. 1067–1073 (2007)

    Google Scholar 

  9. Mansmann, S., Scholl, M.H.: 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, July 24-26, pp. 59–66 (2008)

    Google Scholar 

  10. Solodovnikova, D.: Data Warehouse Evolution Framework. In: Proceedings of the Spring Young Researcher’s Colloquium on Database and Information Systems SYRCoDIS, Moscow, Russia (2007), http://ceur-ws.org/Vol-256/submission_4.pdf

  11. Thalhammer, T., Schrefl, M., Mohania, M.: Active Data Warehouses: Complementing OLAP with Active Rules. In: Data & Knowledge Engineering, December 2001, vol. 39(3), pp. 241–269. Elsevier Science Publishers B. V., Amsterdam (2001)

    Google Scholar 

  12. Garrigós, I., Gómez, J.: Modeling User Behaviour Aware WebSites with PRML. In: Proceedings of the CAISE’06 Third International Workshop on Web Information Systems Modeling (WISM ’06), Luxemburg, June 5-9, pp. 1087–1101 (2006)

    Google Scholar 

  13. Ravat, F., Teste, O.: Personalization and OLAP Databases. In: Annals of Information Systems. New Trends in Data Warehousing and Data Analysis, vol. 3. Springer, US (2009)

    Google Scholar 

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

    Google Scholar 

  15. Kozmina, N., Niedrite, L.: Research Directions of OLAP Personalizaton. In: Proceedings of 19th International Conference on Information Systems Development (ISD’10), Prague, Czech Republic (August 2010)

    Google Scholar 

  16. Jones, M.E., Song, I.-Y.: Dimensional Modeling: Identifying, Classifying & Applying Patterns. In: Proc. of ACM 8th International Workshop on Data Warehousing and OLAP (DOLAP’05), Bremen, Germany, pp. 29–37 (2005)

    Google Scholar 

  17. Suh, Y., Woo, W.: Context-based User Profile Management for Personalized Services. In: Ubicomp Workshop (ubiPCMM), pp. 64–73 (2005)

    Google Scholar 

  18. Kimball, R., Ross, M.: The Data Warehouse Toolkit, The Complete Guide to Dimensional Modeling, 2nd edn., p. 421. John Wiley & Sons, Inc., New York (2002)

    Google Scholar 

  19. Silverston, L.: The Data Model Resource Book, Revised edn., vol. 1, p. 542. John Wiley & Sons, USA (2001)

    Google Scholar 

  20. Jensen, C.S., Kligys, A., Pedersen, T.B., Timko, I.: Multidimensional Data Modeling for Location-based Services. The VLDB Journal — The International Journal on Very Large Data Bases 13(1), 1–21 (2004)

    Article  Google Scholar 

  21. Poole, J., Chang, D., Tolbert, D., Mellor, D.: Common Warehouse Metamodel Developers Guide, p. 704. Wiley Publishing, Chichester (2003)

    Google Scholar 

  22. Microsoft Technet Library, http://technet.microsoft.com/en-us/library/cc917644.aspx

  23. Imhoff, C., Galemmo, N., Geiger, J.G.: Mastering Data Warehouse Design: Relational and Dimensional Techniques, p. 456. Wiley Publishing, USA (2003)

    Google Scholar 

  24. IP Address Geolocation to Identify Website Visitor’s Geographical Location, http://www.ip2location.com/

  25. My Browser Info, http://mybrowserinfo.com/

  26. Find IP Address: IP Lookup, http://www.find-ip-address.org/

  27. Solodovņikova, D.: Building Queries on Multiple Versions of Data Warehouse. In: Proceedings of the 8th International Baltic Conference on Databases and Information Systems, Tallinn, Estonia, pp. 75–86 (2008)

    Google Scholar 

  28. Drachsler, H., Hummel, H.G.K., Koper, R.: Personal Recommender Systems for Learners in Lifelong Learning Networks: the Requirements, Techniques and Model. International Journal of Learning Technology 3(4), 404–423 (2008)

    Article  Google Scholar 

  29. Ji, J.Z., Liu, C.N., Sha, Z.Q., Zhong, N.: Personalized Recommendation Based on a Multilevel Customer Model. International Journal of Pattern Recognition and Artificial Intelligence, World Scientific 19(7), 895–916 (2005)

    Article  Google Scholar 

  30. Pazzani, M.J.: A Framework for Collaborative, Content-Based and Demographic Filtering. Artificial Intelligence Review 13(5-6), 393–408 (1999)

    Article  Google Scholar 

  31. Rich, E.: User Modeling via Stereotypes. International Journal of Cognitive Science 3, 329–354 (1979)

    Article  Google Scholar 

  32. Burke, R.: Hybrid Web Recommender Systems. In: Brusilovsky, P., Kobsa, A., Nejdl, W. (eds.) Adaptive Web 2007. LNCS, vol. 4321, pp. 377–408. Springer, Heidelberg (2007)

    Chapter  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Faculty of Computing, University of Latvia, Riga, LV-1586, 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

Editor information

Editors and Affiliations

  1. Lehrstuhl für Softwaretechnik, Universität Rostock, Albert-Einstein-Str. 21, 18059, Rostock, Germany

    Peter Forbrig

  2. Lehrstuhl für Wirtschaftsinformatik, Universität Rostock, Albert-Einstein-Str. 21, 18059, Rostock, Germany

    Horst Günther

Rights and permissions

Reprints and permissions

Copyright information

© 2010 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Kozmina, N., Niedrite, L. (2010). OLAP Personalization with User-Describing Profiles. In: Forbrig, P., Günther, H. (eds) Perspectives in Business Informatics Research. BIR 2010. Lecture Notes in Business Information Processing, vol 64. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-16101-8_15

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-16101-8_15

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-16100-1

  • Online ISBN: 978-3-642-16101-8

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation