DataBound Episode 2 - Semantic Search

Posted: Oct 04, 2011 at 8:11 PM

By: Roger Doherty

(2)

25,752 Views

6 Comments

Video format

Option selected may change based on video formats available and browser capability.

Auto

Use our suggested format for this video.

Smooth Streaming

Adaptive bitrate streaming - little buffering but lower video quality at times of low bandwidth. Silverlight 5 required

Progressive

Traditional buffered video format. Silverlight 5 required

HTML5

For browsers that support H.264 MP4 or WebM video playback such as:
IE9+, Firefox 4+, Chrome 5+, or Safari 4+.

Flash

For browsers that have the Adobe Flash Player plugin installed.

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

Follow
Oops, something didn't work.

Try again?

Sign In to be begin to follow these comments

What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in. You need to be signed in to Channel 9 to use this feature.

Getting "follow" information

Stop following these comments

Start following these comments

What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in and view them all on your notifications page.

Removing your "follow"

Setting up your "follow"

Did you know you can
sign up for email notifications?
- Subscribe to this comments

BLinden

Oct 07, 2011 at 11:15 AM

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?
srikalyan

Oct 07, 2011 at 7:32 PM

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)?
M.Rys

Oct 08, 2011 at 2:20 AM

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

Oct 08, 2011 at 2:20 AM

One update, the languages supported now include several different versions of Chinese
M.Rys

Oct 08, 2011 at 2:26 AM

@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.
rdoherty Roger Doherty

Nov 03, 2011 at 12:07 PM

http://mysemanticsearch.codeplex.com
Go get it!