Looking for a killer SQL Server 2012 demo?
Well look no further! I’m pleased to announce that the MySemanticSearch Sample is now available on CodePlex at:
MySemanticSearch allows a user to upload Word documents into a SQL Server 2012 table, then visualize the semantic content of the documents in it using tag clouds that are automatically built by semantic search. The user can then find similar documents by comparing their tag clouds.
As seen in Quentin Clark’s Day 2 Keynote at PASS Summit 2011, this simple but elegant content management application shows off the power of several key improvements in SQL Server 2012 including:
- Database blob storage (FILESTREAM)
- Database blob storage file sharing (FileTables)
- Full-text search
- Semantic search
Go ahead and give it a try! Post your feedback and comments on CodePlex.
Comments
Anonymous
October 30, 2011
Superb - I have been blogging about Semantic Search recently and have only been testing the basic features and also pushing the performance of the engine. This sample demo is excellent. Will give it a go on a number of document collections of various sizes. Thanks for sharing it. Can you tell me if Keyphrases are working in CTP3 not just keywords?Anonymous
October 31, 2011
@sqlartist: I'm pretty sure semantic search is based upon term extraction only, not phrase extraction. For that you would probably need to use standard full-text search.Anonymous
November 05, 2011
The comment has been removedAnonymous
November 16, 2011
i received this error: "Invoke operation 'CheckServerConnection' failed. [HttpWebRequest_WebException_RemoteServer] Arguments: NotFound Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See go.microsoft.com/fwlink could somebody help me please? regards!Anonymous
January 22, 2012
Awesome Application Does it support HTML documents instead of WORD documents ? What languages are supported for indexing text ? RegardsAnonymous
February 10, 2012
Is there anything I need to do to get it to work for Excel Speadsheets? select * from Documents returns one row for test1.xlsx and one for test1.csv SELECT * FROM semantickeyphrasetable(Documents, *) returns null SELECT name, document_key, keyphrase, score FROM semantickeyphrasetable(Documents, *) INNER JOIN Documents ON stream_id = document_key ORDER BY name, score DESC returns null Following the SQL Server 2012 Training Kit. I replaced word documents with the Excel Spreadsheet, but it doesn't seem to work. How do I check for Excel Filters?Anonymous
March 15, 2012
I tried RTM, I still can only see word from Semantic Search not phrase. I think if a Semantic Search can't return phrase, it is useless.Anonymous
January 03, 2013
Looks great! How is the tag cloud realized / visualizied ? What is the technology behind the tag cloud ? Best regards!