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. 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 in SQL Server 2012, that you can adapt and use as the basis for your own projects.

Pro Spatial with SQL server 2012 : harness the power of sql server's spatial features set to create location-based analysis and visualization tools

Pro Spatial with SQL Server 2012 (Expert's Voice in Databases)

by Alastair Aitchison

Aitchison, Alastair

Apress; Imprint: Apress

Expert's voice in databases, Berkeley, Calif.], New York, ©2012

The expert's voice in databases, Berkley, 2012

United States, United States of America

Springer Nature, [New York], 2012

Berkeley, CA, United States, 2012

1st ed. 2012, Berkeley, CA, 2012

New edition, New York, 2012

1st ed., PS, 2012

Dordrecht, 2012

May 15, 2012

{"container_title":"Pro Spatial with SQL Server 2012","first_page":387,"last_page":418,"parent_isbns":["1430234911","143023492X","9781430234913","9781430234920"],"publisher":"Apress"}

MiU

Source title: Pro Spatial with SQL Server 2012 (Expert's Voice in Databases)

<p>Microsoft SQL Server implements extensive support for location-based data. <b>Pro Spatial with SQL Server 2012</b> introducesSQL 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.</p>
<p>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.</p>
<ul>
<li>Explains spatial concepts from the ground up—no prior knowledge is necessary</li>
<li>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</li>
<li>Brilliantly illustrated with code examplesthat run in SQL Server 2012, that you can adapt and use as the basis for your own projects.</li>
</ul>
<p class="null1">What you’ll learn</p>
<ul>
<li>The fundamental concepts involved in working with spatial data, including spatial references and co-ordinate systems</li>
<li>How to create and store spatial data using the geometry and geography data types</li>
<li>How to use of spatial indexes in the design of highly-performant databases</li>
<li>Write spatial queries to answer practical, business questions</li>
<li>Pass spatial data seamlessly between database and application layers using T-SQL and C#</li>
<li>Overcome common issues, including how to deal with invalid, imprecise, or erroneous spatial data</li>
<li>Apply advanced techniques such as routefinding and clustering</li>
</ul>
<b>Who this book is for</b>
<p><b>Pro Spatial with SQL Server 2012</b>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#.</p>
<p><b>Table of Contents</b>1. Spatial Reference Systems</p>
<p>2. Spatial Features</p>
<p>3. Spatial Datatypes</p>
<p>4. Creating Spatial Data</p>
<p>5. Importing Spatial Data</p>
<p>6. Geocoding</p>
<p>7. Precision, Validity, and Errors</p>
<p>8.Transformation and Reprojection</p>
<p>9. Examining Spatial Properties</p>
<p>10.Modification and Simplification</p>
<p>11. Aggregation and Combination</p>
<p>12. Testing Spatial Relationships</p>
<p>13. Clustering and Distribution Analysis</p>
<p>14. Route Finding</p>
<p>15. Triangulation and Tesselation</p>
<p>16. Visualization and User Interface</p>
<p>17. Reporting Services</p>
<p>18. Indexing</p>
<p>19.</p>

Annotation Microsoft SQL Server implements extensive support for location-based data. Pro Spatial with SQL Server 2011introduces SQL Servers 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. Youll 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 2011goes beyond just the database. Youll learn about standard formats for data interchange, including how to syndicate location-based data using GeoRSS. Youll learn to visually present query results using outside tools such as Bing Maps and SQL Server Reporting Services 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 upno prior knowledge is necessaryProvides 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 layerBrilliantly illustrated with code examples that run on all versions of SQL Server 2011Includes the freely-available Express EditionWhat youll learnThe fundamental concepts involved in working with spatial data, including spatial references and co-ordinate systemsHow to create and store spatial data using the geometry and geography data typesHow to use of spatial indexes in the design of highly-performant databasesWrite spatial queries to answer practical, business questionsVisualize query results through tools such as Microsoft Virtual Earth, Bing Maps, and the SQL Server Reporting Services Map componentPass 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 dataApply advanced techniques such as routefinding and clusteringWho this book is forPro Spatial with SQL Server 2011 is the go-to book for anyone involved in spatial applications involving Microsoft SQL Server 2011. 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♯

Keine Beschreibung vorhanden.
Erscheinungsdatum: 15.05.2012