Taking SQL Server Code Name Denali Beyond Relational in CTP3

mrys — Fri, 12 Aug 2011 05:46:00 GMT

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!

Search results matching tags 'denali', 'SQL Server', and 'Beyond Relational'

Taking SQL Server Code Name Denali Beyond Relational in CTP3