Skip to main content
SpringerLink
Log in
Book cover

International Conference on Intelligent Interactive Multimedia Systems and Services

KES-IIMSS-18 2018: Intelligent Interactive Multimedia Systems and Services 2017 pp 333–342Cite as

Query Recommendation Systems Based on the Exploration of OLAP and SOLAP Data Cubes

  • Conference paper
  • First Online:

  • 1643 Accesses

Part of the book series: Smart Innovation, Systems and Technologies ((SIST,volume 76))

Abstract

Business Intelligence systems refer to technologies and tools responsible for collecting, storing and analyzing data to improve decision-making. In BI systems, users interact with data warehouse by formulating and launching sequences of queries aimed at exploring multidimensional data cubes. However, the volumes of data stored in a data warehouse can be very large and diversified. So, a big amount of irrelevant information returned as results to the user could make the data exploration process inefficient. That’s why, it’s necessary to help the user by guiding him in his exploration. In fact, query recommendation systems play a major role in reducing the effort of decision-makers to find the most interesting information. Several works dealing with query recommendation systems were presented in the last few years. This paper aims at providing a comprehensive review of literature on a query recommendation based on the exploration of data cubes. A benchmarking study of query recommendation methods is proposed. Several evaluation criteria are used to identify the existence of new investigations and future researches.

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   169.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   219.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD   219.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

Learn about institutional subscriptions

References

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

  2. Aissi, S., Gouider, M.S., Sboui, T., Said, L.B.: Enhancing spatial data warehouse exploitation: a solap recommendation approach. In: Computer and Information Science, pp. 131–147. Springer (2016)

    Google Scholar 

  3. Aufaure, M., Kuchmann-Beauger, N., Marcel, P., Rizzi, S., Vanrompay, Y.: Predicting your next OLAP query based on recent analytical sessions. In: Proceedings Data Ware-housing and Knowledge Discovery - 15th International Conference, DaWaK 2013, Prague, Czech Republic, 26–29 August, pp. 134–145 (2013)

    Google Scholar 

  4. Badard, T.: L’open source au service du géospatial et de l’intelligence d’affaires. Geomatics Sciences Department (avril 2011)

    Google Scholar 

  5. Badard, T., Dubé, E.: Enabling geospatial business intelligence. Geomatics Sciences Department, Semptember 2009

    Google Scholar 

  6. Bédard, Y., Han, J.: Geographic Data Mining and Knowledge Discovery, 2e edn. Taylor & Francis, Boca Raton (2009)

    Google Scholar 

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

    Google Scholar 

  8. Bellatreche, L., Mouloudi, H., Giacometti, A., Marcel, P.: Personalization of MDX queries. In: 22èmes Journées Bases de Données Avancées, BDA 2006, Lille, 17–20 octobre 2006, Actes (Informal Proceedings) (2006)

    Google Scholar 

  9. Burke, R.: Hybrid recommender systems: survey and experiments. User Model. User-Adap. Inter. 12(4), 331–370 (2002)

    Article  MATH  Google Scholar 

  10. Giacometti, A., Marcel, P., Negre, E., Soulet, A.: Query recommendations for OLAP discovery-driven analysis. IJDWM 7(2), 1–25 (2011)

    Google Scholar 

  11. Jerbi, H.: Personnalisation d’analyses décisionnelles sur des données multidimensionnelles. Ph.D. thesis, Institut de Recherche en Informatique de Toulouse - UMR 5505, France (2012)

    Google Scholar 

  12. Layouni, O., Akaichi, J.: A novel approach for a collaborative exploration of a spatial data cube. IJCCE Int. J. Comput. Commun. Eng. 3(1), 63–68 (2014)

    Article  Google Scholar 

  13. Layouni, O., Alahmari, F., Akaichi, J.: Recommending multidimensional spatial olap queries. In: Intelligent Interactive Multimedia Systems and Services 2016, pp. 405–415. Springer (2016)

    Google Scholar 

  14. Marcel, P., Missaoui, R., Rizzi, S.: Towards intensional answers to OLAP queries for analytical sessions. In: Proceedings DOLAP 2012, ACM 15th International Workshop on Data Warehousing and OLAP, Maui, HI, USA, November 2, pp. 49–56 (2012)

    Google Scholar 

  15. Marketos, G.: Data Warehousing & Mining Techniques for Moving Object Databases. Ph.D. thesis, Department of Informatics, University of Piraeus (2009)

    Google Scholar 

  16. Melville, P., Sindhwani, P.: Recommender systems. In: Encyclopedia of Machine Learning, pp. 829–838 (2010)

    Google Scholar 

  17. Negre, E.: Exploration collaborative de cubes de données. Ph.D. thesis, Université François Rabelais of Tours, France (2009)

    Google Scholar 

  18. Sapia, C.: On modeling and predicting query behavior in olap systems. In: Proceedings INT’L Workshop on Design and Management of Data Warehouses (DMDW 99), SWISS LIFE, pp. 1–10 (1999)

    Google Scholar 

  19. Sapia, C.: PROMISE: Predicting query behavior to enable predictive caching strategies for OLAP systems. In: Kambayashi, Y., Mohania, M., Tjoa, A (eds.) Data Warehousing and Knowledge Discovery, Lecture Notes in Computer Science, vol. 1874, pp. 224–233. Springer, Heidelberg (2000)

    Google Scholar 

  20. Sapia, C., Alexander, F., Erlangen-nürnberg, U.: Promise: modeling and predicting user behavior for online analytical processing applications. Ph.D. thesis submitted, Technische Universität München (2001)

    Google Scholar 

  21. Sarawagi, S.: Explaining differences in multidimensional aggregates. In: Proceedings of the 25th International Conference on Very Large Data Bases, VLDB 1999, pp. 42–53. Morgan Kaufmann Publishers Inc., San Francisco (1999)

    Google Scholar 

  22. Sarawagi, S.: User-adaptive exploration of multidimensional data. In: VLDB, pp. 307–316. Morgan Kaufmann (2000)

    Google Scholar 

  23. Sathe, G., Sarawagi, S.: Intelligent rollups in multidimensional olap data. In: Proceedings of the 27th International Conference on Very Large Data Bases, VLDB 2001, pp. 531–540. Morgan Kaufmann Publishers Inc., San Francisco (2001)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. BESTMOD Laboratory, Institut Supérieur de Gestion de Tunis, Université de Tunis, Tunis, Tunisia

    Olfa Layouni, Assawer Zekri & Marwa Massaâbi

  2. College of Computer Science, King Khalid University, Abha, Saudi Arabia

    Jalel Akaichi

Authors
  1. Olfa Layouni
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Assawer Zekri
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Marwa Massaâbi
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Jalel Akaichi
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Olfa Layouni .

Editor information

Editors and Affiliations

  1. National Research Council of Italy (CNR-ICAR), Institute for High-Performance Computing and Networking, Naples, Italy

    Giuseppe De Pietro

  2. National Research Council of Italy (CNR-ICAR), Institute for High-Performance Computing and Networking, Naples, Italy

    Luigi Gallo

  3. Fern Barrow, Bournemouth University, Poole, Dorset, United Kingdom

    Robert J. Howlett

  4. University of Canberra, Canberra, Aust Capital Terr, Australia

    Lakhmi C. Jain

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer International Publishing AG

About this paper

Cite this paper

Layouni, O., Zekri, A., Massaâbi, M., Akaichi, J. (2018). Query Recommendation Systems Based on the Exploration of OLAP and SOLAP Data Cubes. In: De Pietro, G., Gallo, L., Howlett, R., Jain, L. (eds) Intelligent Interactive Multimedia Systems and Services 2017. KES-IIMSS-18 2018. Smart Innovation, Systems and Technologies, vol 76. Springer, Cham. https://doi.org/10.1007/978-3-319-59480-4_33

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-59480-4_33

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-59479-8

  • Online ISBN: 978-3-319-59480-4

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics

Search

Navigation