[Искра]

Pro Spatial with SQL Server 2012


Год: 2012 (May)
Автор: Alastair Aitchison
Издательство: Apress
ISBN: 978-1-4302-3491-3
Серия: The Expert's Voice In Databases
Язык: Английский
Формат: PDF/EPUB
Качество: Изначально компьютерное (eBook)
Интерактивное оглавление: Да
Количество страниц: 554
Описание: 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.

Author Alastair Aitchison first introduces you to SQL Server’s spatial feature set and the fundamental concepts involved in working with spatial data, including spatial references and co-ordinate systems. You’ll learn to query, analyze, and interpret spatial data using tools such as Bing Maps and SQL Server Reporting Services. Throughout, you’ll find helpful code examples that you can adopt and extend as a basis for your own projects.

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
Pass spatial data seamlessly between database and application layers using T-SQL and C#
Overcome common issues, including how to deal with invalid, imprecise, or erroneous spatial data
Apply advanced techniques such as routefinding and clustering

1. Spatial Reference Systems
2. Spatial Features
3. Spatial Datatypes
4. Creating Spatial Data
5. Importing Spatial Data
6. Geocoding
7. Precision, Validity, and Errors
8. Transformation and Reprojection
9. Examining Spatial Properties
10. Modification and Simplification
11. Aggregation and Combination
12. Testing Spatial Relationships
13. Clustering and Distribution Analysis
14. Route Finding
15. Triangulation and Tesselation
16. Visualization and User Interface
17. Reporting Services
Indexing