DataBound Episode 2 - Semantic Search

Download this episode

Download Video

Description

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.

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    • User profile image
      BLinden

      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?

    • User profile image
      srikalyan

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

      Questions:

      How is the ontology stored RDF, OWL etc?

      Can we view those files??

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

       

    • User profile image
      M.Rys

      @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.

    • User profile image
      M.Rys
      One update, the languages supported now include several different versions of Chinese Smiley
    • User profile image
      M.Rys
      @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.
    • User profile image
      rdoherty

    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.