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

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

The final part goes into every detail and exemplifies storing and analyzing documents on Windows file system with SQL Server Semantic Search. Being the final part of the article, it is going to take you to the next level of analyzing word documents stored in Windows folders, managed by File Table, and consumed by Semantic Search.

Being the final part of the article, it is going to take you to the next level of analyzing word documents stored in Windows folders, managed by File Table, and consumed by Semantic Search.

Additionally, the readers are going to gain more understanding of Semantic Search and how to make it work with MS Word documents for analysis.

This article provides a name-based analysis of the documents with equal attention to both theory and practice.

Prerequisites

This article assumes the following:

  1. The readers are familiar with the following concepts:
  2. File Table(s).
  3. Semantic Search.
  4. Full-Text Search.
  5. All the prerequisites and *FILESTREAM Enabled EmployeesFilestreamSample *database have been set up.
  6. *EmployeesDocumentStore File Table *has been set up
  7. The following documents have been added to the File Table:
  8. Asif Permanent Employee – Experienced Project Manager.
  9. Mike Permanent Employee – Fresh Programmer.
  10. Peter Permanent Employee – Fresh Project Manager.
  11. Sadaf Contract Employee – Experienced Business Analyst.
  12. The readers can perform some simple Semantic Search operations against the stored documents.

I suggest that you go through the following articles to fill any gaps in your understanding of the above prerequisites and to implement the walkthrough(s) in the final part of the article:

  1. Learn to Store and Analyse Documents on Windows File System with SQL Server Semantic Search Part 1.
  2. Learn to Store and Analyse Documents on Windows File System with SQL Server Semantic Search Part 2.

Part 1 Review

In the first part of the series we learned about the following things:

  1. Setting up a FILESTREAM database.
  2. Setting up a File Table.
  3. Creating MS Word Documents in Windows Folder.
  4. Saving MS Word Documents in a File Table.
  5. Viewing MS Word Document by running a T-SQL script.

Part 2 Review

In the second part of the article we implemented the following things:

  1. Enabling Semantic Search by defining a Full-Text index, a Catalog, and a unique index.
  2. Running Full-Text queries against the stored documents.
  3. Adding more MS Word Documents.
  4. Counting of Documents.
  5. Comparing Permanent vs Contract-based employees.
  6. Adding more details to the names of the documents.
  7. Finding fresh employees’ documents using the name (column) based Semantic Search.
  8. Finding experienced employees’ documents using the name (column) based Semantic Search.
  9. Finding all Project Manager’s documents using the name (column) based Semantic Search.

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.

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.

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.