Skip to main content
SpringerLink
Log in

OLAP Query Personalisation and Recommendation: An Introduction

  • Chapter
Business Intelligence (eBISS 2011)

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

Included in the following conference series:

Summary

The aim of this lecture is to present how popular user-centric techniques, namely personalisation and recommendation, can be adapted to an OLAP context. The presentation begins with an overview of query personalisation and query recommendation in relational databases. Then it introduces the approaches proposed for personalising OLAP queries with user preferences, and the approaches proposed for recommending OLAP queries. All the approaches are characterized in terms of formulation effort, prescriptiveness, proactiveness, expressiveness, and in terms of the data leveraged: the current state of the database, its history, or external information.

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 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

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. The Economist: A special report on managing information: Data, data everywhere (February 2010), http://www.economist.com/node/15557443

  2. Jagadish, H.V., Chapman, A., Elkiss, A., Jayapandian, M., Li, Y., Nandi, A., Yu, C.: Making database systems usable. In: Proceedings of the ACM SIGMOD International Conference on Management of Data, Beijing, China, June 12-14, pp. 13–24 (2007)

    Google Scholar 

  3. Chen, P.Y., Wu, S.Y., Yoon, J.: The Impact of Online Recommendations and Consumer Feedback on Sales. In: Proceedings of the International Conference on Information Systems, ICIS 2004, Washington, DC, USA, December 12-15, pp. 711–724 (2004)

    Google Scholar 

  4. Sarawagi, S.: User-Adaptive Exploration of Multidimensional Data. In: VLDB 2000, Proceedings of 26th International Conference on Very Large Data Bases, Cairo, Egypt, September 10-14, pp. 307–316 (2000)

    Google Scholar 

  5. Rizzi, S.: New Frontiers in Business Intelligence: Distribution and Personalization. In: Catania, B., Ivanović, M., Thalheim, B. (eds.) ADBIS 2010. LNCS, vol. 6295, pp. 23–30. Springer, Heidelberg (2010)

    Chapter  Google Scholar 

  6. Abiteboul, S., Hull, R., Vianu, V.: Foundations of Databases. Addison-Wesley (1995)

    Google Scholar 

  7. Golfarelli, M., Rizzi, S.: Data Warehouse Design: Modern Principles and Methodologies. McGraw-Hill (2009)

    Google Scholar 

  8. Marcel, P., Negre, E.: A survey of query recommendation techniques for data warehouse exploration. In: 7èmes journées francophones sur les Entrepôts de Données et l’Analyse en ligne (EDA 2011), Clermont-Ferrand, Paris, Hermann. RNTI, vol. B-7, pp. 119–134 (June 2011)

    Google Scholar 

  9. Marcel, P.: Personalization and recommendation of OLAP queries (2011), http://www.info.univ-tours.fr/~marcel/BD/ebiss2011.pptx

  10. Stefanidis, K., Koutrika, G., Pitoura, E.: A survey on representation, composition and application of preferences in database systems. ACM Trans. Database Syst. 36(3), 19 (2011)

    Article  Google Scholar 

  11. Kießling, W.: Foundations of Preferences in Database Systems. In: VLDB 2002: Proceedings of 28th International Conference on Very Large Data Bases, August 20-23, Hong Kong, China, pp. 311–322 (2002)

    Google Scholar 

  12. Chomicki, J.: Preference formulas in relational queries. ACM Trans. Database Syst. 28(4), 427–466 (2003)

    Article  Google Scholar 

  13. Adomavicius, G., Tuzhilin, A.: 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)

    Article  Google Scholar 

  14. Goel, S., Broder, A.Z., Gabrilovich, E., Pang, B.: Anatomy of the long tail: ordinary people with extraordinary tastes. In: Proceedings of the Third International Conference on Web Search and Web Data Mining, WSDM 2010, New York, NY, USA, February 4-6, pp. 201–210 (2010)

    Google Scholar 

  15. Adomavicius, G., Tuzhilin, A., Zheng, R.: REQUEST: A Query Language for Customizing Recommendations. Information Systems Research 22(1), 99–117 (2011)

    Article  Google Scholar 

  16. Kadlag, A., Wanjari, A.V., Freire, J., Haritsa, J.R.: Supporting Exploratory Queries in Databases. In: Lee, Y., Li, J., Whang, K.-Y., Lee, D. (eds.) DASFAA 2004. LNCS, vol. 2973, pp. 594–605. Springer, Heidelberg (2004)

    Chapter  Google Scholar 

  17. Mishra, C., Koudas, N.: Interactive query refinement. In: EDBT 2009: Proceedings of 12th International Conference on Extending Database Technology, Saint Petersburg, Russia, March 24-26, pp. 862–873 (2009)

    Google Scholar 

  18. Golfarelli, M.: Personalization of OLAP queries. In: 6émes journées francophones sur les Entrepôts de Données et l’Analyse en ligne (EDA 2010), Djerba, Tunisie, Toulouse, Cépadués. RNTI, vol. B-6 (June 2010); 1 Article invité

    Google Scholar 

  19. Stefanidis, K., Drosou, M., Pitoura, E.: ”You May Also Like” Results in Relational Databases. In: Amer-Yahia, S., Koutrika, G. (eds.) PersDB 2009, 3rd International Workshop on Personalized Access, Profile Management, and Context Awareness in Databases in Conjunction with VLDB 2009, Lyon, France, August 28, pp. 37–42 (2009)

    Google Scholar 

  20. Börzsönyi, S., Kossmann, D., Stocker, K.: The Skyline Operator. In: Proceedings of the 17th International Conference on Data Engineering, Heidelberg, Germany, April 2-6, pp. 421–430 (2001)

    Google Scholar 

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

    Google Scholar 

  22. Koutrika, G., Ioannidis, Y.E.: Personalized Queries under a Generalized Preference Model. In: Proceedings of the 21st International Conference on Data Engineering, ICDE 2005, Tokyo, Japan, April 5-8, pp. 841–852 (2005)

    Google Scholar 

  23. Chatzopoulou, G., Eirinaki, M., Polyzotis, N.: Query Recommendations for Interactive Database Exploration. In: Winslett, M. (ed.) SSDBM 2009. LNCS, vol. 5566, pp. 3–18. Springer, Heidelberg (2009)

    Chapter  Google Scholar 

  24. Akbarnejad, J., Eirinaki, M., Koshy, S., On, D., Polyzotis, N.: SQL QueRIE Recommendations: a query fragment-based approach. In: Catarci, T., Stavrakas, Y. (eds.) PersDB 2010, 4th International Workshop on Personalized Access, Profile Management, and Context Awareness in Databases in Conjunction with VLDB 2010, Singapore, September 13 (2010)

    Google Scholar 

  25. Khoussainova, N., Kwon, Y., Balazinska, M., Suciu, D.: SnipSuggest: Context-Aware Autocompletion for SQL. PVLDB 4(1), 22–33 (2010)

    Google Scholar 

  26. Chaudhuri, S., Dayal, U.: An Overview of Data Warehousing and OLAP Technology. SIGMOD Record 26(1), 65–74 (1997)

    Article  Google Scholar 

  27. Sarawagi, S., Agrawal, R., Megiddo, N.: Discovery-Driven Exploration of OLAP Data Cubes. In: Schek, H.-J., Saltor, F., Ramos, I., Alonso, G. (eds.) EDBT 1998. LNCS, vol. 1377, pp. 168–182. Springer, Heidelberg (1998)

    Chapter  Google Scholar 

  28. Rizzi, S.: OLAP preferences: a research agenda. In: DOLAP 2007: Proceedings of ACM 10th International Workshop on Data Warehousing and OLAP, Lisbon, Portugal, November 9, pp. 99–100 (2007)

    Google Scholar 

  29. Bellatreche, L., Giacometti, A., Marcel, P., Mouloudi, H., Laurent, D.: A personalization framework for OLAP queries. In: DOLAP 2005: Proceedings of ACM 8th International Workshop on Data Warehousing and OLAP, Bremen, Germany, November 4-5, pp. 9–18 (2005)

    Google Scholar 

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

    Chapter  Google Scholar 

  31. Han, J., Kamber, M.: Data Mining: Concepts and Techniques. Morgan Kaufmann (2000)

    Google Scholar 

  32. Microsoft: MDX reference (2009), http://msdn.microsoft.com/

  33. Sarawagi, S.: Explaining Differences in Multidimensional Aggregates. In: VLDB 1999: Proceedings of 25th International Conference on Very Large Data Bases, Edinburgh, Scotland, UK, September 7-10, pp. 42–53 (1999)

    Google Scholar 

  34. Ordonez, C., Chen, Z.: Evaluating Statistical Tests on OLAP Cubes to Compare Degree of Disease. IEEE Transactions on Information Technology in Biomedicine 13(5), 756–765 (2009)

    Article  Google Scholar 

  35. Biondi, P., Golfarelli, M., Rizzi, S.: myOLAP: An Approach to Express and Evaluate OLAP Preferences. IEEE Trans. Know. Data Eng. 23(7), 1050–1064 (2011)

    Article  Google Scholar 

  36. 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.) DaWaK 2009. LNCS, vol. 5691, pp. 467–478. Springer, Heidelberg (2009)

    Chapter  Google Scholar 

  37. Jerbi, H., Ravat, F., Teste, O., Zurfluh, G.: A Framework for OLAP Content Personalization. In: Catania, B., Ivanović, M., Thalheim, B. (eds.) ADBIS 2010. LNCS, vol. 6295, pp. 262–277. Springer, Heidelberg (2010)

    Chapter  Google Scholar 

  38. Cariou, V., Cubillé, J., Derquenne, C., Goutier, S., Guisnel, F., Klajnmic, H.: Built-In Indicators to Discover Interesting Drill Paths in a Cube. In: Song, I.-Y., Eder, J., Nguyen, T.M. (eds.) DaWaK 2008. LNCS, vol. 5182, pp. 33–44. Springer, Heidelberg (2008)

    Chapter  Google Scholar 

  39. Sathe, G., Sarawagi, S.: Intelligent Rollups in Multidimensional OLAP Data. In: VLDB 2001: Proceedings of 27th International Conference on Very Large Data Bases, Roma, Italy, September 11-14, pp. 531–540 (2001)

    Google Scholar 

  40. Giacometti, A., Marcel, P., Negre, E.: A framework for recommending OLAP queries. In: DOLAP 2008: Proceedings of ACM 11th International Workshop on Data Warehousing and OLAP, Napa Valley, California, USA, October 30, pp. 73–80 (2008)

    Google Scholar 

  41. Giacometti, A., Marcel, P., Negre, E.: Recommending Multidimensional Queries. In: Pedersen, T.B., Mohania, M.K., Tjoa, A.M. (eds.) DaWaK 2009. LNCS, vol. 5691, pp. 453–466. Springer, Heidelberg (2009)

    Chapter  Google Scholar 

  42. Sapia, C.: On Modeling and Predicting Query Behavior in OLAP Systems. In: Proceedings of the Intl. Workshop on Design and Management of Data Warehouses, DMDW 1999, Heidelberg, Germany, June 14-15, p. 2 (1999)

    Google Scholar 

  43. Sapia, C.: ROMISE: Predicting Query Behavior to Enable Predictive Caching Strategies for OLAP Systems. In: Kambayashi, Y., Mohania, M., Tjoa, A.M. (eds.) DaWaK 2000. LNCS, vol. 1874, pp. 224–233. Springer, Heidelberg (2000)

    Chapter  Google Scholar 

  44. Giacometti, A., Marcel, P., Negre, E., Soulet, A.: Query recommendations for OLAP discovery driven analysis. In: DOLAP 2009: Proceedings of ACM 12th International Workshop on Data Warehousing and OLAP, Hong Kong, China, November 6, pp. 81–88 (2009)

    Google Scholar 

  45. Giacometti, A., Marcel, P., Negre, E., Soulet, A.: Query Recommendations for OLAP Discovery-Driven Analysis. IJDWM 7(2), 1–25 (2011)

    Google Scholar 

  46. Broder, A.Z.: A taxonomy of web search. SIGIR Forum 36(2), 3–10 (2002)

    Article  Google Scholar 

  47. Aligon, J., Golfarelli, M., Marcel, P., Rizzi, S., Turricchia, E.: Mining Preferences from OLAP Query Logs for Proactive Personalization. In: Eder, J., Bielikova, M., Tjoa, A.M. (eds.) ADBIS 2011. LNCS, vol. 6909, pp. 84–97. Springer, Heidelberg (2011)

    Chapter  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Laboratoire d’Informatique, Université François Rabelais Tours, France

    Patrick Marcel

Authors
  1. Patrick Marcel
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. MAS Laboratory, Ecole Centrale Paris, 92 295, Châtenay-Malabry Cedex, France

    Marie-Aude Aufaure

  2. Department of Computer & Decision Engineering (CoDE) CP 165/15, Universite Libre de Bruxelles, 1050, Brussels, Belgium

    Esteban Zimányi

Rights and permissions

Reprints and permissions

Copyright information

© 2012 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Marcel, P. (2012). OLAP Query Personalisation and Recommendation: An Introduction. In: Aufaure, MA., Zimányi, E. (eds) Business Intelligence. eBISS 2011. Lecture Notes in Business Information Processing, vol 96. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-27358-2_3

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-27358-2_3

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-27357-5

  • Online ISBN: 978-3-642-27358-2

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation