THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Michael Rys: Musings on XML, XQuery and more...

Taking SQL Server Code Name Denali Beyond Relational in CTP3

Over the last couple of months the SQL engineering team has been busy preparing SQL Server Code Name “Denali” CTP3. As part of that effort, I have been driving the Beyond Relational scenario, that is adding some useful, cool and in some cases long awaited capabilities to SQL Server in the context of managing unstructured data and spatial data management. The video below gives you a quick overview of what we have added in “Denali:”

http://www.youtube.com/watch?v=LTpIb9j06qI

In the area of providing a rich experience over unstructured data we:

  • have done lots of performance and scale work in Full-Text Search!
  • add customizable NEAR in Full-Text Search
  • add the ability to search only within document properties instead of the full document
  • provide semantic similarity search between documents. This provides you the ability to answer questions such as: "Find documents that talk about the same thing as this other document!"
  • achieved better scalability and performance for FileStream data, including the ability to store the data in multiple containers
  • offer full Win 32 application compatibility for unstructured data stored in a new table called FILETABLE. You create a Filetable and can drag and drop your documents into the database and run your favorite Windows applications on them (e.g., Office, Windows Explorer).

In the spatial area we have added a lot of additional items including:

  • Circular arc support
  • GEOMETRY and GEOGRAPHY method parity
  • FullGlobe support for GEOGRAPHY
  • Spatial aggregation
  • Performance improvements for methods
  • Better predictable default index
  • Index support for nearest neighbor queries
  • and more

You can also see a slightly more detailed presentation on Channel 9 and if you haven’t already, be sure to download SQL Server Code Name “Denali” CTP3 and begin exploring it today!

Published Thursday, August 11, 2011 11:46 PM by mrys

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement