CODEWITHSUNDEEP
sql-server
hidden
hidden

Reputation: 3236

Semantic Search without using filetable in sql server 2012

We have an file upload system and would like to use the new MSSQL2012 semantic search feature for sql server 2012. Is that possible without using filetables?

This is our schema:

enter image description here

Upvotes: 2

Views: 503

Answers (1)

Stoleg
Stoleg

Reputation: 9320

I think there are two questions here.

Can you use Semantic Search without using filetable?

Yes, you can. It can be used on any table with Full-Text indexing turned on. Here is the list of prerequisites: link.

Basically you can use it on the data, which is loaded into the database.

The second question is whether your schema benefit from Semantic Search an to what extent.

Looking at your scheema I understand, that your database hold only paths to the documents and their "descriptions". Therefore, you can enable Semantic Search on the columns in your database. It will allow to use Semantic Search on FileName and Description, but not on documents' contents.

In order to use Semantic Search on the contents of these documents you'll need to store these documnets in SQL database. FileTable structure helps this task, although you can choose another way of storing whole documnets in your database.

Upvotes: 3

Related Questions