News

SQL Server 2008 To Offer Spatial Data Type Support

sQL Server 2008 offers new support for spatial data types that some analysts say should deliver a real boost to geospatial applications and data sharing.

Microsoft's soon-to-be-released SQL Server 2008 offers new support for spatial data types that some analysts say should deliver a real boost to geospatial applications and data sharing.

Expected to ship in the third quarter, the new version of SQL Server will allow storage of spatial data -- in the form of points, lines and polygons -- in SQL tables. The software will also offer a set of functions to allow the manipulation of this data and new spatial indexes to support the execution of these functions.

The move is especially important, according to John Baleja, senior product manager at mapping software provider ESRI, because about half the company's customer base now uses SQL Server. ESRI is the dominant vendor of geospatial software in the federal sector.

"I would say that the request for SQL access to the spatial types is probably over the last two years the No. 1 request that we received here at ESRI for new functionality," Baleja said. "We've been in discussions with Microsoft for quite a few years about adding a spatial type, so we are really excited to see this coming out in SQL Server 2008."

Since 1996, ESRI customers who wanted to use SQL Server as a data repository had to use an ESRI Web service add-on to manage the data. The biggest advantages to having native SQL support for spatial data, Baleja said, will be easier integration with other applications, more security and possibly better performance.

"Going through SQL Server, you can take advantage of a transaction management and security features that are built into SQL Server," Baleja said.

About the Author

Patrick Marshall is the technology editor of Government Computer News (GCN.com).

comments powered by Disqus

Featured

  • Hands On: New VS Code Insiders Build Creates Web Page from Image in Seconds

    New Vision support with GitHub Copilot in the latest Visual Studio Code Insiders build takes a user-supplied mockup image and creates a web page from it in seconds, handling all the HTML and CSS.

  • Naive Bayes Regression Using C#

    Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of the naive Bayes regression technique, where the goal is to predict a single numeric value. Compared to other machine learning regression techniques, naive Bayes regression is usually less accurate, but is simple, easy to implement and customize, works on both large and small datasets, is highly interpretable, and doesn't require tuning any hyperparameters.

  • VS Code Copilot Previews New GPT-4o AI Code Completion Model

    The 4o upgrade includes additional training on more than 275,000 high-quality public repositories in over 30 popular programming languages, said Microsoft-owned GitHub, which created the original "AI pair programmer" years ago.

  • Microsoft's Rust Embrace Continues with Azure SDK Beta

    "Rust's strong type system and ownership model help prevent common programming errors such as null pointer dereferencing and buffer overflows, leading to more secure and stable code."

  • Xcode IDE from Microsoft Archrival Apple Gets Copilot AI

    Just after expanding the reach of its Copilot AI coding assistant to the open-source Eclipse IDE, Microsoft showcased how it's going even further, providing details about a preview version for the Xcode IDE from archrival Apple.

Subscribe on YouTube

Upcoming Training Events