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.
Keywords
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsReferences
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)
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)
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)
Badard, T.: L’open source au service du géospatial et de l’intelligence d’affaires. Geomatics Sciences Department (avril 2011)
Badard, T., Dubé, E.: Enabling geospatial business intelligence. Geomatics Sciences Department, Semptember 2009
Bédard, Y., Han, J.: Geographic Data Mining and Knowledge Discovery, 2e edn. Taylor & Francis, Boca Raton (2009)
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)
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)
Burke, R.: Hybrid recommender systems: survey and experiments. User Model. User-Adap. Inter. 12(4), 331–370 (2002)
Giacometti, A., Marcel, P., Negre, E., Soulet, A.: Query recommendations for OLAP discovery-driven analysis. IJDWM 7(2), 1–25 (2011)
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)
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)
Layouni, O., Alahmari, F., Akaichi, J.: Recommending multidimensional spatial olap queries. In: Intelligent Interactive Multimedia Systems and Services 2016, pp. 405–415. Springer (2016)
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)
Marketos, G.: Data Warehousing & Mining Techniques for Moving Object Databases. Ph.D. thesis, Department of Informatics, University of Piraeus (2009)
Melville, P., Sindhwani, P.: Recommender systems. In: Encyclopedia of Machine Learning, pp. 829–838 (2010)
Negre, E.: Exploration collaborative de cubes de données. Ph.D. thesis, Université François Rabelais of Tours, France (2009)
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)
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)
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)
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)
Sarawagi, S.: User-adaptive exploration of multidimensional data. In: VLDB, pp. 307–316. Morgan Kaufmann (2000)
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)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights 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)