Mitch Pronschinske is the Lead Research Analyst at DZone. Researching and compiling content for DZone's research guides is his primary job. He likes to make his own ringtones, watches cartoons/anime, enjoys card and board games, and plays the accordion. Mitch is a DZone Zone Leader and has posted 2578 posts at DZone. You can read more from them at their website. View Full User Profile

Semantic Search - How SQL Server will do it

  • submit to reddit

Semantic search will be important as it emerges on the web, as well as in other areas like Microsoft's SQL Server database.  There's currently some documentation on MSDN for the new semantic search capabilities coming to the next version of SQL Server aka. "Denali".  Here are some of the things the how-to covers so far:

  • Key phrases in a document
  • Similar or related documents
  • Key phrases that make documents similar or related


Semantic search builds upon the existing full-text search feature in SQL Server, but enables new scenarios that extend beyond keyword searches. While full-text search lets you query the words in a document, semantic search lets you query the meaning of the document. Solutions that are now possible include automatic tag extraction, related content discovery, and hierarchical navigation across similar content. For example, you can query the index of key phrases to build the taxonomy for an organization, or for a corpus of documents. Or, you can query the document similarity index to identify resumes that match a job description. --MSDN


The semantic indexes are queried by using three Transact-SQL rowset functions to retrieve the results as structured data.