Introductions Semantic Search

Text mining is also becoming more and more popular. Everybody would like to understand data from blogs, Web sites, and social media. Microsoft SQL Server in versions 2012 and 2014 enhances full-text search support that was substantially available in previous editions. Semantic Search, a new component in Full-Text Search, can help you understand the meaning of documents.

The Semantic Language Statistics Database is a required component for the Statistical Semantic Search feature in Microsoft SQL Server 2014. Statistical Semantic Search provides deep insight into unstructured documents stored in SQL Server databases by extracting and indexing statistically relevant key phrases. Then it also uses these key phrases to identify and index documents that are similar or related.

For example, users can query the index of key phrases to build the taxonomy for an organization, or for a corpus of technical documents. Or for example in an HR scenario, a recruiter can query the document similarity index to identify resumes that match a job description. Semantic Search follows all of the Fulltext index population models to work seamlessly in the existing Fulltext scenarios.

Semantic Search Functions on SQL 2014 Hosting

Here are some search function on semantic that we have to use to our program because it’s can make maximized sql 2014 features.

  •  semantickeyphrasetable (Transact-SQL)

Returns a table with zero, one, or more rows for those key phrases associated with columns in the specified table.

  •  semanticsimilaritydetailstable (Transact-SQL)

Returns a table of zero, one, or more rows of key phrases common across two documents (a source document and a matched document) whose content is semantically similar.

  •  semanticsimilaritytable (Transact-SQL)

Returns a table of zero, one, or more rows for those columns whose content is \semantically similar to a specified document.

How to install Semantic Search Functions on SQL 2014 Hosting

There are some steps that you must completely implemented before using semantic search

1. Install the semantic language statistics database.

Download the appropriate version of the Windows installer package named SemanticLanguageDatabase.msi. This file contains a compressed database file and log file.

Run the SemanticLanguageDatabase.msi Windows installer package to extract the database and log file. You should change the default destination directory to a location where SQL Server has necessary file permissions for attaching a database (SQL Server data folder for example). Optionally, you can move the extracted database file and log file to the preferred location in the file system.

2. Attach the semantic language statistics database.

Attach the database to the instance of SQL Server by using Management Studio or by calling CREATE DATABASE with the FOR ATTACH syntax. By default, the name of the database is semanticsdb. You can optionally give the database a different name when you attach it. You have to provide this name when you register the database in the following step:

ON (FILENAME = 'C:\Microsoft Semantic Language Database\semanticsdb.mdf')


When the semantic language statistics database is extracted, restricted permissions are assigned to the database file and log file in the file system. As a result, the user may not have permission to attach the database. If an error is raised when you try to attach the database, check and fix file system permissions as appropriate.

3. Register the semantic language statistics database.

Call the stored procedure sp_fulltext_semantic_register_language_statistics_db and provide the name that you gave to the database when you attached it:

EXEC sp_fulltext_semantic_register_language_statistics_db @dbname = N'semanticsdb';

Our Special SQL Server 2014 Hosting Complete Features
What we think makes so compelling is how deeply integrated all the pieces are. We integrate and centralize everything--from the systems to the control panel software to the process of buying a domain name. For us, that means we can innovate literally everywhere. We've put the guys who develop the software and the admins who watch over the server right next to the 24-hour Fanatical Support team, so we all learn from each other.