, 14:23 | Cite as

User defined topological predicates in database systems

  • Thomas BehrEmail author
  • Ralf Hartmut Güting


Current database systems cannot only store standard data like \(\underline{integer}\), \(\underline{string}\), and \(\underline{real}\) values, but also spatial data like \(\underline{points}\), \(\underline{lines}\), and \(\underline{regions}\). The importance of topological relationships between spatial objects has been recognized a long time ago. Using the well known 9-intersection model for describing such relationships, a lot of different topological relationships can be distinguished. For the query language of a database system it is not desirable to have such a large number of topological predicates. Particularly the query language should not be extended by a lot of predicate names. It is desirable to build new relationships from existing ones, for example to coarse the granularity. This paper describes how a database system user can define and use her own topological predicates. We show algorithms for computing such predicates in an efficient way. Last, we compare these general versions with specialized implementations of topological predicates.


Topological predicate Topological relationships Spatial database User defined topological predicate 


  1. 1.
    Clementini E, di Felice P (1996) A model for representing topological relationships between complex geometric features in spatial databases. Inf Sci 90(1–4):121–136CrossRefGoogle Scholar
  2. 2.
    Clementini E, Di Felice P, Califano G (1995) Composite regions in topological queries. IS 20(7):579–594Google Scholar
  3. 3.
    Clementini E, Felice PD (1993) An object calculus for geographic databases. In: SAC ’93: Proceedings of the 1993 ACM/SIGAPP symposium on applied computing. New York, NY, USA, ACM, pp 302–308CrossRefGoogle Scholar
  4. 4.
    Clementini E, Felice PD, van Oosterom P (1993) A small set of formal topological relationships suitable for end-user interaction. In: SSD: advances in spatial databases. LNCS, SpringerGoogle Scholar
  5. 5.
    Egenhofer M, Clementini E, Di Felice P (1994) Topological relations between regions with holes. Int J Geographic Inf Syst 8(2):128–142Google Scholar
  6. 6.
    Egenhofer MJ (1989) A formal definition of binary topological relationships. In: Litwin W, Schek H (eds) Third international conference on foundations of data organization and algorithms (FODO). Lecture Notes in Computer Science, vol 367. Springer, pp 457–472, JuneGoogle Scholar
  7. 7.
    Egenhofer MJ, Herring JR (1990) Categorizing binary topological relations between regions, lines, and points in geographic databases. Technical report, Department of Surveying Engineering, University of Maine, MaineGoogle Scholar
  8. 8.
    Gaal SA (1964) Point set topology. Academic, New YorkGoogle Scholar
  9. 9.
    Güting RH (1993) Second-order signature: a tool for specifying data models, query processing, and optimization. In: Proc. of the ACM SIGMOD international conf. on management of data, pp 277–286Google Scholar
  10. 10.
    Güting RH, Behr T, Almeida V, Ding Z, Hoffmann F, Spiekermann M (2004) SECONDO: an extensible dbms architecture and prototype. Technical report, FernUniversität HagenGoogle Scholar
  11. 11.
    Güting RH, de Almeida VT, Ansorge D, Behr T, Ding Z, Höse T, Hoffmann F, Spiekermann M, Telle U (2005) SECONDO: an extensible dbms platform for research prototyping and teaching. In: ICDE. IEEE Computer Society, pp 1115–1116Google Scholar
  12. 12.
    Güting RH, Ding Z (2004) A simple but effective improvement to the plumb-line algoritm. Inf Process Lett 91(6):251–257CrossRefGoogle Scholar
  13. 13.
    Güting RH, Schneider M (1995) Realm-based spatial data types: the ROSE algebra. VLDB J 4(2):243–286CrossRefGoogle Scholar
  14. 14.
    Kothuri R, Godfrind A, Beinat E (2007) Pro oracle spatial for oracle database 11g. Springer, New YorkGoogle Scholar
  15. 15.
    Open GIS Consortium, Inc. (1999) OpenGIS simple features specification for SQL Revision 1.1, OpenGIS Project Document 99-049, MayGoogle Scholar
  16. 16.
    OpenGeoDB (2008) OpenGeoDB., 2008-02-14
  17. 17.
    Reasey Praing MS (2008) Efficient implementation techniques for topological predicates on complex spatial objects. GeoInformatica 12(3):313–356CrossRefGoogle Scholar
  18. 18.
    Schneider M (2002) Implementing topological predicates for complex regions. In: Proceedings of the international symposium on spatial data handling, pp 313–328Google Scholar
  19. 19.
    Schneider M (2004) Computing the topological relationship of complex regions. In: DEXA, pp 844–853Google Scholar
  20. 20.
    Schneider M, Behr T (2006) Topological relationships between complex spatial objects. ACM Trans Database Syst 31(1):39–81CrossRefGoogle Scholar
  21. 21.
    Shamos MI, Hoey D (1976) Geometric intersection problems. In: FOCS. IEEE, pp 208–215Google Scholar
  22. 22.
    Stonebraker M, Frew J, Gardels K, Meredith J (1993) The sequoia 2000 benchmark. In: Buneman P, Jajodia S (eds) Proceedings of the 1993 ACM SIGMOD international conference on management of data. Washington, D.C., 26–28 May, ACM, New York, pp 2–11CrossRefGoogle Scholar

Copyright information

© Springer Science+Business Media, LLC 2009

Authors and Affiliations

  1. 1.FernUniversität in HagenHagenGermany

Personalised recommendations