SQL SERVER – What is Spatial Database? – Developing with SQL Server Spatial and Deep Dive into Spatial Indexing

What is 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. (Source: Wikipedia)

Today I will be talking about the same subject at Microsoft TechEd India. If you want to learn about how to spatial aspect of data and how to integrate them with SQL Server this is the perfect session for you. Spatial is very special concept of SQL Server and I really like how it is implemented in SQL Server. In general Performance Tuning and Query Optimization is something I always have enjoyed in my professional life. Index are my best friends and many time, by implementing and many time by removing I have improved the performance of the system. In this session, I will be talking about Index along with Spatial Data. As Spatial Database is very interesting concept, I will cover super short but very interesting 10 quick slides about this subject. I will make sure in very first 20 mins, you will understand following topics

  • Introduction to Spatial Database
    • One line definition
  • Understanding Spatial Indexing
    • Index Internals
    • Query/Performance Tuning
    • Query Hinting/Cost Analysis
  • Spatial Index Catalog Views
  • Performance Troubleshooting
    • Finding Optimal Index using Spatial Index SP
    • Common Errors
  • Index Maintenance

This slides decks will be followed by around 30 mins demo which will have story of geometry, geography, index internals and performance tuning. If you are interested in learning how GIS works and how SQL Server out of the box supports this wonderful tools, you will really like how the story is told. I am sure all people who attend the event will know how the Bangalore is positioned on the map of India. I will take example of Bangalore and Hyderabad and demonstrate how index can improve the performance. Well there are lots of story to tell in the session, and I will be opening this session with the beautiful script of Botticelli’s Birth of Venus created by Michael J. Swart.

I will also demonstrate few real life scenario where I will be talking about Spatial Database and its usage.

Do not miss this session. At the end of session there will be book awarded to best participant.

My session details:

Session 3: Developing with SQL Server Spatial and Deep Dive into Spatial Indexing
Date: April 14, 2010 Time: 5:00pm-6:00pm

Microsoft SQL Server 2008 delivers new spatial data types that enable you to consume, use, and extend location-based data through spatial-enabled applications. Attend this session to learn how to use spatial functionality in next version of SQL Server to build and optimize spatial queries. This session outlines the new geography data type to store geodetic spatial data and perform operations on it, use the new geometry data type to store planar spatial data and perform operations on it, take advantage of new spatial indexes for high performance queries, use the new spatial results tab to quickly and easily view spatial query results directly from within Management Studio, extend spatial data capabilities by building or integrating location-enabled applications through support for spatial standards and specifications and much more.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

About these ads

11 thoughts on “SQL SERVER – What is Spatial Database? – Developing with SQL Server Spatial and Deep Dive into Spatial Indexing

  1. Hi Friend,

    if you know about SAP Business Module then there is one Module Inventroty Management system.

    Now , I want to Develop same module in Web Application.In SAP Module there are around 250 Tables and each table contain around 200,249 columns…

    I am new in SAP Business module..I am not able to integrate that system into web..can any one help me how to start so i can easily learn.??????

    Thanks a lot in advance…

    Thanks & Regards,
    Ashish Pujara.

    Like

  2. Hi Pinal,
    I am very curious to know Spatial databases and technology. Apart from playing around with spatial data types here and there, i would like to get a good understanding of this subject. Is there a way you could post or send out a tutorial without breaching any contractual stuff.

    Thank you
    Ramdas

    Like

  3. I get error “value does not fall within the specified range” in the web application configuration.

    I already configured the web app but MDM site never asked me for credentials and provided me error codes etc.

    Any help appreciated!

    Timo

    Like

  4. “I am very curious to know Spatial databases and technology. Apart from playing around with spatial data types here and there, i would like to get a good understanding of this subject. Is there a way you could post or send out a tutorial without breaching any contractual stuff.”

    yeah same here. that would be cool

    Like

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

  6. Hello pinal,actual i want 2 know the more detailed information should u provide it or the link or any material regarding 2 spatial database with its latest update and application…!!!

    Like

  7. Pingback: SQL SERVER – Weekly Series – Memory Lane – #025 | SQL Server Journey with SQL Authority

  8. Hi Pinal,

    I am a regular reader of your blogs for years and would like to really thank you for the work you have been doing for SQL Server community over so many years. You have enlighten DBA’s like myself with very practical and simple to understand information every day.

    While going thru your old blogs, I discovered that on April 14,2010 you had a session in Bangalore during which you covered SPATIAL databases and SPATIAL Indexing subject. As a Sr. level DBA who just got involved in working with Spatial data in Florida, I would like to know if you can shed some light on how to set up ( what to look for) and tune these indexes. We used geography data (very confusing for a starter) . If you have already talked about this subject in the past in one of your earlier blogs or know of any good book to purchase, please direct me there.

    Again thank you so much for your remarkable work.

    Hemant Korde
    Florida

    Like

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