Open Source Databases and Their Spatial Extensions

  • Rongguo Chen
  • Jiong Xie
Part of the Advances in Geographic Information Science book series (AGIS, volume 2)


This chapter discusses Open Source databases including two modes of spatial data management, two different key standards for spatial databases, the leading Open Source databases including MySQL, PostgreSQL, FireBird, Ingres and MaxDB, and summarises extending methods and the use of PostGIS and MySQL.


Geographic Information System Spatial Extension Structure Query Language Environmental System Research Institute Open Geospatial Consortium 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. Ashworth M, Cotton P, Kucera H, Brien D (1998) Comparison of spatial schema in ISO/TC 211, OGC, and SQL/MM, ISO Expert ContributionGoogle Scholar
  2. Baars M (2003) A comparison between ESRI geodatabase topology and laser-scan radius topology. Available: Scholar
  3. Borrie H (2006) Firebird databases as the back-end to enterprise software systems. Firebird Enterprise White Paper. Available: paper-fbent.htmlGoogle Scholar
  4. Breunig M, Türker C, Böhlen MH, Dieker S, Güting RH, Jensen CS, Relly L, Rigaux P, Schek H-J, Scholl M (2003) Spatio-temporal databases: The CHOROCHRONOS approach – Chapter 7. Springer-Verlag, HeidelbergGoogle Scholar
  5. Camara G, CartaxoR, Monteiro A, Ferreira K, Vinhas L, Carvalho M, Casanova M (2004) TerraLib: An open source GIS library for spatio-temporal databases. Available: http://, Unpublished manuscriptGoogle Scholar
  6. Clementini E, Felice PD, Oosterom P (1993) A small set of formal topological relationships suitable for end-user interaction. In: Abel D, Ooi BC (eds), Advances in spatial databases -Third International Symposium, SSD’93, Singapore. Springer, Berlin, pp 277–295Google Scholar
  7. Dieker S, Güting RH (2000) Plug and play with query algebras: SECONDO, a Generic DBMS development environment. In: Proc. of the Int. Database Engineering and Applications Symp., Yokohama, Japan, pp 380–392Google Scholar
  8. ESRI White Paper (2005) GIS topology. Available: topology.pdfGoogle Scholar
  9. Ewald G, Hans-Jürgen S (2001) PostgreSQL developer’s handbook. Sams Publishing, USAGoogle Scholar
  10. Fabalabs Research Paper (2005) Comparison of the enterprise functionalities of open source database management systems. Available: FabalabsResearchPaper-OSDBMS-Eval.pdfGoogle Scholar
  11. Ingres (2006) Ingres 2006 release summary. Available: rs.pdfGoogle Scholar
  12. ISO/IEC (2005) Information technology—SQL multimedia and application packages – part 3: spatial 3rd edGoogle Scholar
  13. Karlsson A (2004) GIS and spatial extensions with MySQL. Available: tech-resources/articles/4.1/gis-with-mysql.htmlGoogle Scholar
  14. Lemmen C (2007) Product survey on geo-databases. GIM International, 21(5)Google Scholar
  15. MaxDB (2005) MaxDB – The professional DBMS (MaxDB Whitepaper). Available:>Google Scholar
  16. OGC (2006a) OpenGIS implementation specification for geographic information – simple feature access – Part 1: Common ArchitectureGoogle Scholar
  17. OGC (2006b) OpenGIS implementation specification for geographic information – simple feature access – Part 2: SQL OptionGoogle Scholar
  18. Oosterom P, Stoter JE, Quak CW, Zlatanova S (2002) The balance between geometry and topology. In: Richardson D, Oosterom P (eds) Advances in spatial data handling, 10th International Symposium on Spatial Data Handling, Springer-Verlag, Berlin, pp 209–224Google Scholar
  19. Patel JM, Yu JB, Kabra N, Tufte K, Nag B, Burger J, Hall NE, Ramasamy K, Lueder R, Ellman C, Kupsch J, Guo S, DeWitt DJ, Naughton J (1997) Building a scalable geo-spatial DBMS: technology, implementation, and evaluation. Proceedings ACM SIGMOD Conference, 336–347.Google Scholar
  20. Pelekis N, Theodoulidis B, Kopanakis I, Theodoridis Y (2004) Literature review of spatio-temporal database models. Knowledge Eng Rev J, 19(3):235–274Google Scholar
  21. Ramsey P (2006) The state of open source GIS. Refraction Research. Available:>Google Scholar
  22. Reiner B, Hahn K, Höfling G, Baumann P (2002) Hierarchical storage support and management for large-scale multidimensional array database management systems. In: 3th International Conference on Database and Expert Systems Applications (DEXA). Aix en Provence, FranceGoogle Scholar
  23. Relly L, Schek H-J, Henricsson O, Nebiker S (1997) Physical database design for raster images in CONCERT. In: 5th International Symposium on Spatial Databases (SSD’97). Springer, Berlin, pp 259–279Google Scholar
  24. Stolze K (2003) Sql/mm spatial – the standard to manage spatial data in a relational database system. In: Weikum G, Schöning H, Rahm E (eds) BTW 2003. pp 247–264Google Scholar
  25. Vinhas L, Souza RCM, Camara G (2003) Image data handling in spatial databases. In: Geoinfo 2003. INPEGoogle Scholar
  26. Wang X, Zhou XF, Lu SL (2000) Spatiotemporal data modeling and management: a survey. In: Proceedings of the 36th International Conference on Technology of Object-Oriented Languages and Systems (TOOLS-Asia’00). IEEE Press, pp 202–211Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2008

Authors and Affiliations

  • Rongguo Chen
    • 1
  • Jiong Xie
    • 1
  1. 1.State Key Laboratory of Resources and Environmental Information SystemChinese Academy of SciencesBeijingChina

Personalised recommendations