Skip to main content

2016 | OriginalPaper | Buchkapitel

Recommending Multidimensional Spatial OLAP Queries

verfasst von : Olfa Layouni, Fahad Alahmari, Jalel Akaichi

Erschienen in: Intelligent Interactive Multimedia Systems and Services 2016

Verlag: Springer International Publishing

Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.

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.

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

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!

Literatur
1.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat Bellogin, A., Castells, P., Cantador, I.: Precision-oriented evaluation of recommender systems: an algorithmic comparison. In: Proceedings of the Fifth ACM Conference on Recommender Systems, RecSys ’11, pp. 333–336. ACM, New York, NY, USA (2011). http://doi.acm.org/10.1145/2043932.2043996 Bellogin, A., Castells, P., Cantador, I.: Precision-oriented evaluation of recommender systems: an algorithmic comparison. In: Proceedings of the Fifth ACM Conference on Recommender Systems, RecSys ’11, pp. 333–336. ACM, New York, NY, USA (2011). http://​doi.​acm.​org/​10.​1145/​2043932.​2043996
8.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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.
Zurück zum Zitat 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
Metadaten
Titel
Recommending Multidimensional Spatial OLAP Queries
verfasst von
Olfa Layouni
Fahad Alahmari
Jalel Akaichi
Copyright-Jahr
2016
DOI
https://doi.org/10.1007/978-3-319-39345-2_35