1 / 9

Testing Spatial Methods in SQL Server: Strategies and Data Management Techniques

This paper presents a comprehensive approach to testing spatial methods in SQL Server 11.0. It covers strategies for verifying input data, along with methods for testing geographical and geometrical data. Key techniques include using exact and approximate equality checks, identity cases, and data generators tailored for specific testing requirements. The goal is to minimize steps in bug reproduction, making it easier to identify and resolve issues within large spatial datasets. Contact details for the authors are provided for further inquiries.

sharis
Télécharger la présentation

Testing Spatial Methods in SQL Server: Strategies and Data Management Techniques

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