Loading user information from Channel 9

Something went wrong getting user information from Channel 9

Latest Achievement:

Loading user information from MSDN

Something went wrong getting user information from MSDN

Visual Studio Achievements

Latest Achievement:

Loading Visual Studio Achievements

Something went wrong getting the Visual Studio Achievements

DataBound Episode 2 - Semantic Search

18 minutes, 59 seconds


Right click “Save as…”

Join Roger and guest Michael Rys from the SQL Server Engineering team as they discuss an exciting new improvement in SQL Server Code Name "Denali" called semantic search which makes it possible to automatically build tag clouds over libraries of documents and perform powerful searches which compare documents based upon their meaning.  Semantic search will enable a wide range of capabilities for developers building content management solutions, and we'll show a sample app called MySemanticSearch which demonstrates some of the possibilities.


Follow the discussion

  • Oops, something didn't work.

    Getting subscription
    Subscribe to this conversation
  • Awesome!  What about other types of files?  XML or HTML? Will it ignore XML tags or HTML tags when generating semantic search, or will all my XML tags be "ranked" up top?

  • Great video. I will install it and play with it.


    How is the ontology stored RDF, OWL etc?

    Can we view those files??

    What about access previleges and authentication (windows or TCP authenticaiton)?


  • @BLinden:All the SQL Server Full-text iFilters are supported. So in the case of XML or HTML, we will not index the markup tags or attribute names. If you want PDF support, you will need to install a third-party PDF iFilter such as Adobe's or FoxIt's.

  • One update, the languages supported now include several different versions of Chinese Smiley
  • @srikalyan: There is not really an ontology behind it (yet). We are extracting keyphrases or tags (in this case only 1-grams, although the algorithms could also handle n-grams). That information is made accessible in relational form through the table-valued functions. Generating and supporting ontologies is definitively something we are looking into for the future. How close that future is depends on many things though. What do you mean with access priviledges and authentication? This feature is integrated into SQL Server with Fulltext search so you have the standard SQL Server access controls.
  • Roger Dohertyrdoherty Roger Doherty


    Go get it!

Remove this comment

Remove this thread


Comments closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.