Skip to main content
Top

2016 | OriginalPaper | Chapter

Recommending Multidimensional Spatial OLAP Queries

Authors : Olfa Layouni, Fahad Alahmari, Jalel Akaichi

Published in: Intelligent Interactive Multimedia Systems and Services 2016

Publisher: Springer International Publishing

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

Abstract

Huge volumes of data are stored in a spatial data warehouse. Stored data is explored and analyzed by different users. The users interrogate spatial data cube through Spatial OLAP queries which are generally misspoke, leading to non-pertinent results. Therefore, we propose in this paper a Spatial OLAP queries recommendation system based on the SOLAP server query log; that helps and guides users in their exploration. Compared to the users needs, the proposed queries return more relevant results.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Literature
1.
go back to reference 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) 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)
2.
go back to reference Badard, T.: Lopen source au service du gospatial et de lintelligence daffaires. Geomatics Sciences Department, avril 2011 Badard, T.: Lopen source au service du gospatial et de lintelligence daffaires. Geomatics Sciences Department, avril 2011
3.
go back to reference Badard, T., Dubé, E.: Enabling geospatial business intelligence. Geomatics Sciences Department, Sept 2009 Badard, T., Dubé, E.: Enabling geospatial business intelligence. Geomatics Sciences Department, Sept 2009
4.
go back to reference Bdard, Y., Rivest, S., jose Proulx, M.: Spatial on-line analytical processing (solap): Concepts, architectures, and solutions from a geomatics engineering perspective. In: Data Warehouses and OLAP: Concepts, Architecture, and Solutions, pp. 298–319. Press (2006) Bdard, Y., Rivest, S., jose Proulx, M.: Spatial on-line analytical processing (solap): Concepts, architectures, and solutions from a geomatics engineering perspective. In: Data Warehouses and OLAP: Concepts, Architecture, and Solutions, pp. 298–319. Press (2006)
5.
go back to reference Bellatreche, L., Giacometti, A., Marcel, P., Mouloudi, H., Laurent, D.: A personalization framework for OLAP queries. In: Proceedings of DOLAP 2005, ACM 8th International Workshop on Data Warehousing and OLAP, pp. 9–18, Bremen, Germany, 4–5 Nov 2005 Bellatreche, L., Giacometti, A., Marcel, P., Mouloudi, H., Laurent, D.: A personalization framework for OLAP queries. In: Proceedings of DOLAP 2005, ACM 8th International Workshop on Data Warehousing and OLAP, pp. 9–18, Bremen, Germany, 4–5 Nov 2005
6.
go back to reference 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, Actes (Informal Proceedings), 17–20 octobre 2006 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, Actes (Informal Proceedings), 17–20 octobre 2006
7.
8.
go back to reference Brouard, C.: Comparaison du modèle vectoriel et de la pondération tf*idf associée avec une méthode de propagation d’activation. In: CORIA, pp. 1–10. Neuchâtel, France, Apr 2013 Brouard, C.: Comparaison du modèle vectoriel et de la pondération tf*idf associée avec une méthode de propagation d’activation. In: CORIA, pp. 1–10. Neuchâtel, France, Apr 2013
9.
go back to reference Bruns, H.T., Egenhofer, M.J.: Similarity of spatial scenes. In: 7th Symposium on Spatial Data Handling, pp. 31–42 (1996) Bruns, H.T., Egenhofer, M.J.: Similarity of spatial scenes. In: 7th Symposium on Spatial Data Handling, pp. 31–42 (1996)
10.
go back to reference Clementini, E., Felice, P.D.: A comparison of methods for representing topological relationships. Inf. Sci. Appl. 3(3), 149–178 (1995) Clementini, E., Felice, P.D.: A comparison of methods for representing topological relationships. Inf. Sci. Appl. 3(3), 149–178 (1995)
11.
go back to reference Egenhofer, M.J., Al-Taha, K.K.: Reasoning about gradual changes of topological relationships. In: Frank, A.U., Campari, I., Formentini, U. (eds.) Theories and Methods of Spatio-Temporal Reasoning in Geographic Space: Proceedings of the International Conference GIS, pp. 196–219. Springer, Berlin, Heidelberg (1992) Egenhofer, M.J., Al-Taha, K.K.: Reasoning about gradual changes of topological relationships. In: Frank, A.U., Campari, I., Formentini, U. (eds.) Theories and Methods of Spatio-Temporal Reasoning in Geographic Space: Proceedings of the International Conference GIS, pp. 196–219. Springer, Berlin, Heidelberg (1992)
12.
go back to reference Fablet, R., Bouthemy, P.: Motion-based feature extraction and ascendant hierarchical classification for video indexing and retrieval. In: Proceedings of the 3rd International Conference on Visual Information Systems, VISual99. Lecture Notes in Computer Science, vol. 1614, pp. 221–228. Springer Verlag, Amsterdam, The Netherland (1999) Fablet, R., Bouthemy, P.: Motion-based feature extraction and ascendant hierarchical classification for video indexing and retrieval. In: Proceedings of the 3rd International Conference on Visual Information Systems, VISual99. Lecture Notes in Computer Science, vol. 1614, pp. 221–228. Springer Verlag, Amsterdam, The Netherland (1999)
13.
go back to reference Franklin, C.: An introduction to geographic information systems: linking maps to databases. Database 15(2), 12–21 (1992)MathSciNet Franklin, C.: An introduction to geographic information systems: linking maps to databases. Database 15(2), 12–21 (1992)MathSciNet
14.
go back to reference Glorio, O., Mazón, J.N., Garrigós, I., Trujillo, J.: A personalization process for spatial data warehouse development. Decis. Support Syst. 52(4), 884–898 (2012)CrossRef Glorio, O., Mazón, J.N., Garrigós, I., Trujillo, J.: A personalization process for spatial data warehouse development. Decis. Support Syst. 52(4), 884–898 (2012)CrossRef
16.
go back to reference Li, B., Fonseca, F.: Tdd: a comprehensive model for qualitative spatial similarity assessment. Spat. Cogn. Comput. 6(1), 31–62 (2006) Li, B., Fonseca, F.: Tdd: a comprehensive model for qualitative spatial similarity assessment. Spat. Cogn. Comput. 6(1), 31–62 (2006)
17.
go back to reference Li, J.Z., Zsu, M.T., Tamer, M.: Point-set topological relations processing in image databases. In: In First International Forum on Multimedia and Image Processing, pp. 1–54 (1998) Li, J.Z., Zsu, M.T., Tamer, M.: Point-set topological relations processing in image databases. In: In First International Forum on Multimedia and Image Processing, pp. 1–54 (1998)
18.
go back to reference Egenhofer, M.J., Franzosa, R.D..: Point-set topological spatial relations. Int. J. Geogr. Inf. Syst. 2(5), 161–174 (1991) Egenhofer, M.J., Franzosa, R.D..: Point-set topological spatial relations. Int. J. Geogr. Inf. Syst. 2(5), 161–174 (1991)
19.
go back to reference Marketos, G.: Data warehousing & mining techniques for moving object databases. Ph.D. thesis, Department of Informatics, University of Piraeus (2009) Marketos, G.: Data warehousing & mining techniques for moving object databases. Ph.D. thesis, Department of Informatics, University of Piraeus (2009)
20.
go back to reference Negre, E.: Exploration collaborative de cubes de donnes. Ph.D. thesis, Universit Franois Rabelais of Tours, France (2009) Negre, E.: Exploration collaborative de cubes de donnes. Ph.D. thesis, Universit Franois Rabelais of Tours, France (2009)
21.
go back to reference Rivest, S., Bdard, Y., Proulx, M., Nadeau, M., Hubert, F., Pastor, J.: Solap technology: merging business intelligence with geospatial technology for interactive spatio-temporal exploration and analysis of data. J. Photogram. Remote Sens. (ISPRS) 60(1), 17–33 (2005)CrossRef Rivest, S., Bdard, Y., Proulx, M., Nadeau, M., Hubert, F., Pastor, J.: Solap technology: merging business intelligence with geospatial technology for interactive spatio-temporal exploration and analysis of data. J. Photogram. Remote Sens. (ISPRS) 60(1), 17–33 (2005)CrossRef
22.
go back to reference Sapia, C.: On modeling and predicting query behavior in olap systems. In: Proceedings of INTL Workshop on Design and Management of Data Warehouses (DMDW 99), SWISS LIFE, pp. 1–10 (1999) Sapia, C.: On modeling and predicting query behavior in olap systems. In: Proceedings of INTL Workshop on Design and Management of Data Warehouses (DMDW 99), SWISS LIFE, pp. 1–10 (1999)
23.
go back to reference 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, Berlin Heidelberg (2000)CrossRef 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, Berlin Heidelberg (2000)CrossRef
24.
go back to reference Sapia, C., Alexander, F., Erlangen-nrnberg, U.: Promise: modeling and predicting user behavior for online analytical processing applications. Ph.D. thesis, Technische Universitt Mnchen (2001) Sapia, C., Alexander, F., Erlangen-nrnberg, U.: Promise: modeling and predicting user behavior for online analytical processing applications. Ph.D. thesis, Technische Universitt Mnchen (2001)
25.
go back to reference Sarawagi, S.: Explaining differences in multidimensional aggregates. In: Proceedings of the 25th International Conference on Very Large Data Bases, VLDB ’99, pp. 42–53. Morgan Kaufmann Publishers Inc., San Francisco, CA, USA (1999) Sarawagi, S.: Explaining differences in multidimensional aggregates. In: Proceedings of the 25th International Conference on Very Large Data Bases, VLDB ’99, pp. 42–53. Morgan Kaufmann Publishers Inc., San Francisco, CA, USA (1999)
26.
go back to reference Sarawagi, S.: User-adaptive exploration of multidimensional data. In: VLDB, pp. 307–316. Morgan Kaufmann (2000) Sarawagi, S.: User-adaptive exploration of multidimensional data. In: VLDB, pp. 307–316. Morgan Kaufmann (2000)
27.
go back to reference Sathe, G., Sarawagi, S.: Intelligent rollups in multidimensional olap data. In: Proceedings of the 27th International Conference on Very Large Data Bases, VLDB ’01, pp. 531–540. Morgan Kaufmann Publishers Inc., San Francisco, CA, USA (2001) Sathe, G., Sarawagi, S.: Intelligent rollups in multidimensional olap data. In: Proceedings of the 27th International Conference on Very Large Data Bases, VLDB ’01, pp. 531–540. Morgan Kaufmann Publishers Inc., San Francisco, CA, USA (2001)
28.
go back to reference Stefanovic, N., Han, J., Koperski, K.: Object-based selective materialization for efficient implementation of spatial data cubes. IEEE Trans. Knowl. Data Eng. 12(6), 938–958 (2000)CrossRef Stefanovic, N., Han, J., Koperski, K.: Object-based selective materialization for efficient implementation of spatial data cubes. IEEE Trans. Knowl. Data Eng. 12(6), 938–958 (2000)CrossRef
Metadata
Title
Recommending Multidimensional Spatial OLAP Queries
Authors
Olfa Layouni
Fahad Alahmari
Jalel Akaichi
Copyright Year
2016
DOI
https://doi.org/10.1007/978-3-319-39345-2_35

Premium Partner