Skip to main content
SpringerLink
Log in

Query rewriting for semantic query optimization in spatial databases

  • Published:
GeoInformatica Aims and scope Submit manuscript

Abstract

Query processing is an important challenge for spatial databases due to the use of complex data types that represent spatial attributes. In particular, due to the cost of spatial joins, several optimization algorithms based on indexing structures exist. The work in this paper proposes a strategy for semantic query optimization of spatial join queries. The strategy detects queries with empty results and rewrites queries to eliminate unnecessary spatial joins or to replace spatial by thematic joins. This is done automatically by analyzing the semantics imposed by the database schema through topological dependencies and topological referential integrity constraints. In this way, the strategy comes to complement current state-of-art algorithms for processing spatial join queries. The experimental evaluation with real data sets shows that the optimization strategy can achieve a decrease in the time cost of a join query using indexing structures in a spatial database management system (SDBMS).

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3
Fig. 4

Similar content being viewed by others

Notes

  1. The names given in [9] have their equivalence in the relations in [19].

  2. Note that PostGIS uses the name Touches instead of relation Meet.

  3. http://www.census.gov/geo/maps-data/data/tiger.html

References

  1. Popa L, Deutsch A, Tannen V (2005) Query Reformulation with Constraints

  2. Aref Walid G, Samet Hanan (1991) Optimization for spatial query processing. In: 17th international conference on very large data bases, september 3-6, 1991, barcelona, catalonia, spain, proceedings, pp 81–90

  3. Bogorny V, Engel PM, Alvares LOC (2005) Towards the reduction of spatial join for knowledge discovery in geographic databases using geo-ontologies and spatial integrity constraints. In: Proc of the ECML/PKDD second workshop on knowledge discovery and ontologies (KDO’2005), pp 51–58

  4. Bravo L, Rodríguez AM (2012) Formalization and reasoning about spatial semantic integrity constraints. Data Knowl Eng 72:63–82

    Article  Google Scholar 

  5. Clementini E, Sharma J, Egenhofer MJ (1994) Modelling topological spatial relations: strategies for query processing. Comput Graph 18(6):815–822

    Article  Google Scholar 

  6. Deutsch A, Ludäscher B, Nash A (2007) Rewriting queries using views with access patterns under integrity constraints. Theor Comput Sci 371(3):200–226

    Article  Google Scholar 

  7. Deutsch A, Popa L, Tannen V (1999) Physical data independence, constraints, and optimization with universal plans. In: VLDB, pp 459–470

  8. Deutsch A, Popa L, Tannen V (2006) Query reformulation with constraints. SIGMOD Rec 35(1):65–73

    Article  Google Scholar 

  9. Egenhofer M, Al-Taha K (1992) Reasoning about gradual change of topological relationships. In: Frank A, Campari I, Formentini U (eds) Theories and methods of spatio-temporal reasoning in geographic space, LNCS 636, Springer, pp 196–219

  10. Egenhofer MJ, Franzosa RD (1991) Point-set topological spatial relations. Int J Geogr Inf Syst 5:161–174

    Article  Google Scholar 

  11. Egenhofer MJ, Herring J (1990) Categorizing binary topological relations between regions, lines and points in geographic databases, the 9-intersection. Formalism and its Use for Natural Language Spatial Predicates Santa Barbara CA National Center for Geographic Information and Analysis Technical Report 94:1–28

    Google Scholar 

  12. Egenhofer MJ (1994) Deriving the composition of binary topological relations. J Vis Lang Comput 5(2):133–149

    Article  Google Scholar 

  13. Grant J, Gryz J, Minker J, Raschid L (2000) Logic-based query optimization for object databases. IEEE Trans Knowl Data Eng 12(4):529–547

    Article  Google Scholar 

  14. Jacox EH, Samet H (2007) Spatial join techniques. ACM Trans Database Syst 32(1):7

    Article  Google Scholar 

  15. Lee SG, Henschen LJ, Chun J, Lee T (2000) Identifying relevant constraints for semantic query optimization. Inf Softw Technol 42(13):899–914

    Article  Google Scholar 

  16. Mamoulis N, Theodoridis Y, Papadias D (2005) Spatial joins: algorithms, cost models and optimization techniques. In: Manolopoulos Y, Papadopoulos A, Vassilakopoulos M (eds) Spatial databases: technologies, techniques and trends, idea group, pp 155–184

  17. Maher MJ, Wang J (2000) Optimizing queries in extended relational databases. In: DEXA, vol 1873 of lecture notes in computer science. Springer, pp 386–396

  18. OpenGis (1999) Opengis simple features specification for sql. Technical report Open GIS Consortium

  19. Randell DA, Cui Z, Cohn AG (1992) A spatial logic based on regions and connection. In: KR, pp 165–176

  20. Ray S, Simion B, Brown AD (2011) Jackpine: a benchmark to evaluate spatial database performance. In: Proceedings of the 27th international conference on data engineering. ICDE 2011, April 11-16, 2011, Hannover, Germany, pp 1139–1150

  21. Stock O (1997) Spatial and temporal reasoning. Kluwer Acaddemic Publishers

  22. Worboys M (1992) A geometric model for planar geographical objects. Int J Geogr Inf Syst 6(5):353–372

    Article  Google Scholar 

Download references

Acknowledgements

This work has been funded by Fondecyt 1170497 and by the Millennium Institute for Foundational Research on Data, Chile.

Author information

Authors and Affiliations

  1. Computer Science Department, Millenium Institute for Foundational Research on Data, Universidad de Concepción, Concepción, Chile

    Eduardo Mella, M. Andrea Rodríguez & Diego Gatica

  2. Data Science Institute, Universidad del Desarrollo, Santiago, Chile

    Loreto Bravo

Authors
  1. Eduardo Mella
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. M. Andrea Rodríguez
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Loreto Bravo
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Diego Gatica
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to M. Andrea Rodríguez.

Additional information

Publisher’s note

Springer Nature remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Mella, E., Rodríguez, M.A., Bravo, L. et al. Query rewriting for semantic query optimization in spatial databases. Geoinformatica 23, 79–104 (2019). https://doi.org/10.1007/s10707-018-00335-w

Download citation

  • Received:

  • Revised:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s10707-018-00335-w

Keywords

Search

Navigation