Using Table Valued Functions in SQL Server 2005 To Implement a Spatial Data Library

Jim Gray,Alex Szalay,Gyorgy Fekete
DOI: https://doi.org/10.48550/arXiv.cs/0701163
2007-01-26
Abstract:This article explains how to add spatial search functions (point-near-point and point in polygon) to Microsoft SQL Server 2005 using C# and table-valued functions. It is possible to use this library to add spatial search to your application without writing any special code. The library implements the public-domain C# Hierarchical Triangular Mesh (HTM) algorithms from Johns Hopkins University. That C# library is connected to SQL Server 2005 via a set of scalar-valued and table-valued functions. These functions act as a spatial index.
Databases,Computational Engineering, Finance, and Science
What problem does this paper attempt to address?