Learn to Store, Analyze Documents on Windows File System With SQL Server

Learn to Store, Analyze Documents on Windows File System With SQL Server

This article overviews the power of Semantic Search in SQL Server that allows performing comparative analysis against the unstructured data.. The focus of the article is on comparing documents that can be stored on Windows File System in one respect and in the other respect their comparative analysis that can be performed with Semantic Search in SQL Server.

The focus of the article is on comparing documents that can be stored on Windows File System in one respect and in the other respect their comparative analysis that can be performed with Semantic Search in SQL Server.

Additionally, the readers will learn how to store unstructured data by exploring File Table and creating MS Word documents on the fly (instantly) to be consumed by Semantic Search.

This part of the article is related to the use of Semantic Search on unstructured data for the extraction of basic level business-crucial information provided standard naming is in place.

Prerequisites

The readers need to go through *Learn to Store and Analyse Documents on Windows File System with SQL Server Semantic Search Part 1 *to proceed further with it.

This article assumes the readers are familiar with most (if not all) of the following:

This article also assumes that following steps have already been completed.

  • FILESTREAM Enabled Database EmployeesFilestreamSample has been set up.
  • File Table has been set up.
  • MS Word document *Asif Permanent Employee *and *Peter Permanent Employee *has been stored in a windows folder managed through File Table.
  • Querying the database File Table shows the information about the stored documents.

Please refer to the article Learn to Store and Analyse Documents on Windows File System with SQL Server Semantic Search Part 1 to complete any of the above missing steps, which are mandatory to cover the walkthrough completely.

Performing Name-Based Documents Comparative Analysis

As we are preparing to perform documents comparative analysis based on their standard naming, at this point it is worth doing a quick check by querying the FILESTREAM Enabled database we set up in the first part of the article.

Run the following script against EmployeesFilestreamSample database:

-- View stored documents managed by File Table to check
SELECT stream_id
      ,[name]
      ,file_type
      ,creation_time
FROM EmployeesFilestreamSample.dbo.EmployeesDocumentStore

sql server full-text search semantic search sql server sql server 2016

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Laravel 7 Full Text Search MySQL

Larave full text search app. Here, you'll learn how to implement full text search in laravel app. This tutorial also work with laravel 5, 5.5, 6, 7 version

Introduction to Structured Query Language SQL pdf

SQL stands for Structured Query Language. SQL is a scripting language expected to store, control, and inquiry information put away in social databases. The main manifestation of SQL showed up in 1974, when a gathering in IBM built up the principal model of a social database. The primary business social database was discharged by Relational Software later turning out to be Oracle.

How to Use Semantic Search in SQL Server

This article helps to fully explore the Semantic Search feature in SQL Server and learn the subtleties of its installation and use. Starting from scratch and finishing with a ready-to-use feature.

SCHEMAS in SQL Server -MS SQL Server – Zero to Hero Query Master

This is part 3 of “MS SQL Server- Zero to Hero” and in this article, we will be discussing about the SCHEMAS in SQL SERVER. Before getting into this article, please consider to visit previous articles in this series from below.

Text Analysis Within a Full-Text Search Engine

In this article, take a look at text analysis within a full-text search engine.