SQL SERVER – Spatial Database Definition and Research Documents

Recently I was asked in meeting of SQL SERVER user group, what my opinion about spatial database. I answered from my basic knowledge. Spatial database is like database of space (not the star wars or star trek kind space). SQL Server database can understand the numeric and string values. If we ask to SQL Server what is multiplication of 6 and 3 it will provide answer as 18. If we ask to SQL Server what is distance between two points in polygon, it will be not able to answer using native functions. Custom SQL code written by user can do similar coding. In short spatial database is about lines, points, polygons and their interesting features. SQL Server is not spatial database system.

After I came back from home I searched more about it and found some interesting research and documentation. I am posting here assuming it will be interesting to all of my readers.

Another example of spatial and non spatial query is here:
Non-spatial: List the names of all company with more than 100 employees.
Spatial: List the names of all company within 10 miles of Las Vegas.

Here is the definition from Wikipedia about spatial database :
A spatial database is a database that is optimized to store and query data related to objects in space, including points, lines and polygons. While typical databases can understand various numeric and character types of data, additional functionality needs to be added for databases to process spatial data types.

Very interesting paper written by An Introduction to Spatial Database Systems by Ralf Hartmut Güting.
Author defines Spatial Database as
(1) A spatial database system is a database system.
(2) It offers spatial data types (SDTs) in its data model and query language.
(3) It supports spatial data types in its implementation, providing at least spatial indexing and efficient algorithms for spatial join.
Tutorial in form of slide show can be found here.

Reference for books and slide shows can be found here.
Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

4 thoughts on “SQL SERVER – Spatial Database Definition and Research Documents

  1. Hi Pinal,
    Does Microsoft SQL Server 2005 support Spatial Databases?
    If yes, where can I find information on how to use it. I have done spatial database stuff with Oracle 10g before and have some background on it.

    -Premal.

    Like

  2. I am working on SQL Server 2008. I would like to use Geospatial SQL functions such as STArea, STDistance …

    Is this system functions or user functions?

    In Postgres, I can import from free template without manually programming. Can i do same with SQL server 2008?

    Thanks,
    Ho Nguyen

    Like

  3. Pingback: SQL SERVER – Spatial Database Queries – What About BLOB – T-SQL Tuesday #006 Journey to SQL Authority with Pinal Dave

  4. Pingback: SQL SERVER – Weekly Series – Memory Lane – #033 | Journey to SQL Authority with Pinal Dave

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s