1 / 9

Testing spatial methods in SQL Server 11.0

Testing spatial methods in SQL Server 11.0. Branislav Uzelac Nemanja Matkovic Microsoft Development Center Serbia. Danica Porobic EPFL Lausanne, Switzerland. Introduction to Spatial. Geometry Geography. Testing strategy at a glance. Input Data. Verification methods. Testing methods.

sharis
Download Presentation

Testing spatial methods in SQL Server 11.0

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. Testing spatial methods in SQL Server 11.0 BranislavUzelac Nemanja Matkovic Microsoft Development Center Serbia DanicaPorobic EPFL Lausanne, Switzerland

  2. Introduction to Spatial • Geometry • Geography

  3. Testing strategy at a glance Input Data Verification methods Testing methods World data Reference library “Exact equal” Transformed World data Static cases “Approximate equal” Identity cases Generated Data Repro minimization Minimize File a bug!

  4. Data generators • Objects tailored for specific aspects of testing

  5. Data generators

  6. Testing strategy Identity formula = = = A / B = B / A = u • Mathematical identities A B

  7. Minimization of bug repro steps • Large objects may have thousands of points • Hard to analyze and pinpoint the problem • Solution: minimize!

  8. Minimization of bug repro steps • Success rate

  9. Questions? • More on spatial: http://www.microsoft.com/sqlserver/2008/en/us/spatial-data.aspx • Contact authors • BranislavUzelac, bruzel@microsoft.com • Nemanja Matkovic, nemanjam@microsoft.com • DanicaPorobic, danica.porobic@epfl.ch

More Related