Book Image

Mastering Geoserver

By : Colin Henderson
Book Image

Mastering Geoserver

By: Colin Henderson

Overview of this book

Table of Contents (19 chapters)
Mastering GeoServer
About the Author
About the Reviewers

Chapter 3. Working with Vector Data in Spatial Databases

In the previous chapter, we looked at how we can optimize our raster datasets in to be able to serve them more efficiently. In this chapter, we will take a look at how we can work with vector datasets in a production environment, with our focus being on serving the data through spatial database platforms. Although GeoServer is very good at serving data from flat file formats such as Esri shapefiles, you can't beat the performance benefits from utilizing a spatial database platform in a production environment with large datasets. Out of the box, GeoServer will support connecting to a PostGIS database; however, GeoServer's pluggable architecture can be used to support other platforms. At the time of writing this book, there are official extensions for the following database platforms:

  • Esri ArcSDE (database extensions for use with the Esri technology)

  • DB2

  • MySQL

  • Oracle

  • Microsoft SQL Server and SQL Azure

  • Teradata

Additional database platforms...