Microsoft SQL Server implements extensive support for location-based data. Pro Spatial with SQL Server 2012 introduces SQL Server’s spatial feature set, and covers everything you'll need to know to store, manipulate, and analyze information about the physical location of objects in space. You’ll learn about the geography and geometry datatypes, and how to apply them in practical situations involving the spatial relationships of people, places, and things on Earth.
Pro Spatial with SQL Server 2012 goes beyond just the database. You’ll learn about standard formats for data interchange, including how to syndicate location-based data using GeoRSS. You’ll learn to visually present query results using outside tools such as Bing Maps and SQL Server Reporting Service’s new Map component. The book also covers C# and .NET support for spatial data, helping you to move data seamlessly between your database and application layers.
- Explains spatial concepts from the ground up—no prior knowledge is necessary
- Provides comprehensive guidance for every stage of working with spatial data, from importing through cleansing and storing, to querying, and finally for retrieval and display of spatial data in an application layer
- Brilliantly illustrated with code examples that run on all versions of SQL Server 2012
- Includes the freely-available Express Edition
What you’ll learn
- The fundamental concepts involved in working with spatial data, including spatial references and co-ordinate systems
- How to create and store spatial data using the geometry and geography data types
- How to use of spatial indexes in the design of highly-performant databases
- Write spatial queries to answer practical, business questions
- Visualize query results through tools such as Microsoft Virtual Earth, Bing Maps, and the SQL Server Reporting Services Map component
- Pass spatial data seamlessly between database and application layers using T-SQL and C#
- Overcome common issues with spatial data, including how to deal with invalid, imprecise, or erroneous spatial data
- Apply advanced techniques such as routefinding and clustering
Who this book is for
Pro Spatial with SQL Server 2012 is the go-to book for anyone involved in spatial applications involving Microsoft SQL Server 2012. The book helps database administrators create and optimize the performance of spatial database. The book gives developers what they need to know in order to make effective use of the extensive support for location-based data provided by SQL Server, T-SQL, and C#.
Comments