O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Designing spatial data storage methods

The support of SQL CLR allows applications to manage rich user-defined data such as mathematical or geographical based data. SQL Server 2008 enables the native support of .NET CLR data types by providing two data types: GEOMETRY and GEOGRAPHY.

Managing a spatial type of data will require high-performance and high-end hardware with a massive data storage solution. However, SQL Server features on these two new data types have enabled the applications to support various methods that will allow for creation, comparison, analysis, and spatial data retrieval. In this recipe, we will go through the process of designing spatial data storage methods using SQL Server 2008 R2.

Note

For more on OGC and the WKT/WKB/GML XML ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required