Trace Id is missing

Maximize the everyday with Microsoft 365

Get online protection, secure cloud storage, and innovative apps designed to fit your needs—all in one plan.
For 1 personFor up to 6 people
A young woman works on a Surface laptop while Microsoft 365 App icons whirl around her head.

Microsoft® SQL Server® 2014 SP2 Semantic Language Statistics

The Semantic Language Statistics Database is a required component for the Statistical Semantic Search feature in Microsoft SQL Server 2014 SP2 Semantic Language Statistics.

Important! Selecting a language below will dynamically change the complete page content to that language.

  • Version:

    12.0.5000.0

    Date Published:

    7/10/2016

    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 SP2. You can download this database from this page, attach it to your Microsoft SQL Server 2014 SP2 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 10, Windows 7, Windows 7 Service Pack 1, Windows 8.1, Windows Phone 8, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2

    1. The expanded database and log file require approximately 210 megabytes of disk space.
    2. The system should meet the requirements for SQL Server 2014 SP2.

  • 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.

  • For more information, see Semantic Search.

    Supported Languages
    http://go.microsoft.com/fwlink/?LinkID=241468

Follow Microsoft

Back To Top