Maximize the everyday with Microsoft 365
Get online protection, secure cloud storage, and innovative apps designed to fit your needs—all in one plan.
Microsoft® SQL Server® 2014 Semantic Language Statistics
The Semantic Language Statistics Database is a required component for the Statistical Semantic Search feature in Microsoft SQL Server 2014 Semantic Language Statistics.
Important! Selecting a language below will dynamically change the complete page content to that language.
Version:
12.0.2000.8
Date Published:
3/31/2014
File Name:
ENU\x64\SemanticLanguageDatabase.msi
ENU\x86\SemanticLanguageDatabase.msi
File Size:
177.4 MB
177.2 MB
The Semantic Language Statistics Database is a required component for the Statistical Semantic Search feature in Microsoft SQL Server 2014. You can download this database from this page, attach it to your Microsoft SQL Server 2014 instance, and register it to use the Semantic Search features.
Statistical Semantic Search provides deep insight into unstructured documents stored in SQL Server databases by extracting and indexing statistically relevant key phrases and similar documents based on this keyphrases. Semantic Search builds upon the existing Full-Text Search feature in SQL Server, and enables new scenarios that extend beyond keyword searches into 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, 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.
Developers can easily enable Semantic Search using familiar Fulltext search syntax. They can then access Semantic Search results using the Semantic Rowset functions (similar to CONTAINSTABLE and FREETEXTTABLE). Semantic Search follows all of the Fulltext index population models to work seamlessly in the existing Fulltext scenarios.Supported Operating Systems
Windows 7, Windows 7 Service Pack 1, Windows 8, Windows 8.1, Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2
- The expanded database and log file require approximately 210 megabytes of disk space.
- The system should meet the requirements for SQL Server 2014.
- 1. Install the semantic language statistics database.
- Download the appropriate version of the Windows installer package named SemanticLanguageDatabase.msi from this page. 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. For more information, see Detaching and Attaching Databases. 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:
CREATE DATABASE semanticsdb
ON (FILENAME = 'C:\Microsoft Semantic Language Database\semanticsdb.mdf')
FOR ATTACH;
Important
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';
GO
- For more information, see Semantic Search.
Supported Languages
http://go.microsoft.com/fwlink/?LinkID=241468
Follow Microsoft