Skip to main content
SpringerLink
Log in

Recommending Multidimensional Spatial OLAP Queries

  • Conference paper
  • First Online:
Intelligent Interactive Multimedia Systems and Services 2016

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

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.

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

Institutional subscriptions

Similar content being viewed by others

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)

    Google Scholar 

  2. Badard, T.: Lopen source au service du gospatial et de lintelligence daffaires. Geomatics Sciences Department, avril 2011

    Google Scholar 

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

    Google Scholar 

  4. 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)

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

  9. Bruns, H.T., Egenhofer, M.J.: Similarity of spatial scenes. In: 7th Symposium on Spatial Data Handling, pp. 31–42 (1996)

    Google Scholar 

  10. Clementini, E., Felice, P.D.: A comparison of methods for representing topological relationships. Inf. Sci. Appl. 3(3), 149–178 (1995)

    Google Scholar 

  11. 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)

    Google Scholar 

  12. 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)

    Google Scholar 

  13. Franklin, C.: An introduction to geographic information systems: linking maps to databases. Database 15(2), 12–21 (1992)

    MathSciNet  Google Scholar 

  14. 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)

    Article  Google Scholar 

  15. Kleinberg, J.M.: Authoritative sources in a hyperlinked environment. J. ACM 46(5), 604–632 (1999)

    Article  MathSciNet  MATH  Google Scholar 

  16. Li, B., Fonseca, F.: Tdd: a comprehensive model for qualitative spatial similarity assessment. Spat. Cogn. Comput. 6(1), 31–62 (2006)

    Google Scholar 

  17. 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)

    Google Scholar 

  18. Egenhofer, M.J., Franzosa, R.D..: Point-set topological spatial relations. Int. J. Geogr. Inf. Syst. 2(5), 161–174 (1991)

    Google Scholar 

  19. Marketos, G.: Data warehousing & mining techniques for moving object databases. Ph.D. thesis, Department of Informatics, University of Piraeus (2009)

    Google Scholar 

  20. Negre, E.: Exploration collaborative de cubes de donnes. Ph.D. thesis, Universit Franois Rabelais of Tours, France (2009)

    Google Scholar 

  21. 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)

    Article  Google Scholar 

  22. 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)

    Google Scholar 

  23. 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)

    Chapter  Google Scholar 

  24. 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)

    Google Scholar 

  25. 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)

    Google Scholar 

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

    Google Scholar 

  27. 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)

    Google Scholar 

  28. 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)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. BESTMOD Laboratory, Université de Tunis, ISG - Tunis, Tunis, Tunisia

    Olfa Layouni

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

    Fahad Alahmari & Jalel Akaichi

Authors
  1. Olfa Layouni
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Fahad Alahmari
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. 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. Institute for High-Perfor Computing Netw, National Research Council of Italy, Naples, Italy

    Giuseppe De Pietro

  2. Institute for High-Perfo Computing Netwo, National Research Council of Italy, Naples, Italy

    Luigi Gallo

  3. KES International, Shoreham-by-sea, United Kingdom

    Robert J. Howlett

  4. University of Canberra, Canberra, South Australia, Australia

    Lakhmi C. Jain

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer International Publishing Switzerland

About this paper

Cite this paper

Layouni, O., Alahmari, F., Akaichi, J. (2016). Recommending Multidimensional Spatial OLAP Queries . In: Pietro, G., Gallo, L., Howlett, R., Jain, L. (eds) Intelligent Interactive Multimedia Systems and Services 2016. Smart Innovation, Systems and Technologies, vol 55. Springer, Cham. https://doi.org/10.1007/978-3-319-39345-2_35

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-39345-2_35

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-39344-5

  • Online ISBN: 978-3-319-39345-2

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics

Search

Navigation