1 / 14

Building Location-Aware Applications with the SQL Server Spatial Library.

SVR33. Building Location-Aware Applications with the SQL Server Spatial Library. Ed Katibah, Torsten Grabs and Olivier Meyer SQL Server Microsoft Corporation. SQL Server 2008 Spatial Summary. OVERVIEW. FEATURES. 2 Spatial Data Types (CLR UDT) Comprehensive set of Spatial Methods

daniel_millan
Download Presentation

Building Location-Aware Applications with the SQL Server Spatial Library.

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SVR33 Building Location-Aware Applications with the SQL Server Spatial Library. Ed Katibah, Torsten Grabs and Olivier Meyer SQL Server Microsoft Corporation

  2. SQL Server 2008 Spatial Summary OVERVIEW FEATURES • 2 Spatial Data Types (CLR UDT) • Comprehensive set of Spatial Methods • High Performance Spatial Indexes • Spatial Library • Sink/Builder APIs • Management Studio Integration • 2D Vector Data Support • Open Geospatial Consortium Simple • Features for SQL compatible • Supported By Major GIS Vendors • ESRI, Intergraph, Autodesk, Pitney Bowes, Safe, etc. • Standard feature in SQL Server • Express, Workgroup, Web, Standard, Enterprise and • Developer • Support for very large spatial objects DETAILS • Geography data type for geodetic Data • Geometry data type for planar Data • Standard spatial methods • STIntersects, STBuffer, STLength, STArea, etc. • Standard spatial format support • WKT, WKB and GML • Multiple spatial indexes per column • Create new CLR-based spatial methods • with the Builder API • Redistributable Spatial Library • SQLSysClrTypes

  3. SQL Server Spatial Library Resources SQL SERVER SPATIAL LIBRARY Microsoft SQL Server System CLR Types The SQL Server System CLR Types package contains the components implementing the geometry, geography, and hierarchy id types in SQL Server 2008 R2. This component can be installed separately from the server to allow client applications to use these types outside of the server. X86 Package(SQLSysClrTypes_x86.msi) – 3,342 KBX64 Package (SQLSysClrTypes._x64msi) – 3,459 KBIA64 Package(SQLSysClrTypes_ia64.msi) – 5,352 KB Search for: Microsoft SQL Server 2008 Feature Pack, October 2008 --- CODEPLEX SQL Server Spatial Tools Code Samples Utilizing the SQL Server Spatial Library SQL Server Spatial Tools– including source code for tools Search for: Codeplex SQL Server Spatial Tools

  4. Future Spatial Library ImprovementsCandidate Enhancements • 2D Enhancements • Aggregates, Validation Methods, etc. • Full Globe Support • New Methods, Relaxation of Validity Constraints • Terrain Mesh • Support for viewsheds, slope / aspect aggregates, etc. All are subject to change.

  5. Excel Spatial Spreadsheet demo Olivier Meyer Senior Program Manager SQL Server

  6. StreamInsight™ Goes Spatial demo Torsten Grabs Senior Program Manager Lead SQL Server

  7. What is CEP? Event Complex Event Processing (CEP) is the continuous and incremental processing of event streams from multiple sources based on declarative query and pattern specifications with near-zero latency. request output stream input stream response

  8. Shuttle Tracker 519,000+ data points, covering 1 day of operation

  9. Other Resources • Blogs • http://blogs.msdn.com/edkatibah • http://blogs.msdn.com/streaminsight • http://blogs.msdn.com/oliviermeyer • Forums • http://social.msdn.microsoft.com/Forums/en-US/sqlspatial/ • http://social.msdn.microsoft.com/Forums/en-US/streaminsight • Books • Beginning Spatial with SQL Server 2008, Apress. • Inside SQL Server 2008:T-SQL Programming, MSPress.

  10. YOUR FEEDBACK IS IMPORTANT TO US! Please fill out session evaluation forms online at MicrosoftPDC.com

  11. Learn More On Channel 9 • Expand your PDC experience through Channel 9. • Explore videos, hands-on labs, sample code and demos through the new Channel 9 training courses. channel9.msdn.com/learn Built by Developers for Developers….

More Related