Usually full-text catalogs along with the corresponding tables are created via Cinegy Database Wizard during the database creation procedure (this step is optional).

Database Tab

On this tab you can create a new full-text catalog if it hasn’t been previously created via Cinegy Database Wizard. The full-text catalog can also be dropped or re-created here, if needed.

12_DBM_fulltext

Enabling the Full-Text Option

The "Full-text enabled" option allows enabling/disabling the full-text search in the database. The "full-text service is started" option starts and stops the search service on the server.

Signature Verifying

The "Verify signature" option enables/disables signing of the external components (word breakers, filters, etc.) to improve the overall security and robustness of the current database.

Caution
It is recommended to keep this option enabled.
Important
Refer to the Microsoft SQL Server documentation to get more details about the signature verification tool.

Building a New Catalog

Cinegy products require one full-text catalog set in the Cinegy Archive database. For small databases creating only one full-text catalog for all tables is more efficient. For large databases you can create a separate full-text catalog for each table.

To create a new catalog set, you have to remove the old one. Even if you have just restored the Cinegy Archive database created on another machine from backup, it is better to remove the existing catalog set and to create a new one. This is because the catalogs in SQL Server are not entirely portable.

Follow the steps:

  1. Make sure the existing catalog is in the "idle" state. Use the "Refresh" button to get the current state of the catalog.

  2. Select the existing catalog and press the "Drop" button in order to delete it.

  3. Press the "Create" button in order to start populating a new catalog.

Note
The process of building the indices may take some time. The search function will not be available until the population finishes.

Searchable Descriptors

For more efficient search it is possible to limit the search fields to the specified descriptors set. It is necessary to select the desired descriptors for search. To do this, press the "Fields" button and the following dialog will appear:

12_DBM_fields_for_search

Here select the descriptor group or individual descriptor(s) that will be available for search.

Note
To search by object names, the "Clip name" descriptor (internal name is pd_clip_name) in the "Predefined" group should be marked as searchable.

Check the "Show only marked for Search" option to display only the descriptors already marked as searchable. "Show tooltips" option will enable showing the tooltips with extended descriptor information.

Important
The other way to make a descriptor searchable is to edit it in the "Descriptor groups, descriptors, presets" dialog. See the Descriptors, Presets article for more details.

Documents Tab

This tab allows you to create and configure SQL Server linked servers ("PHANTOM" and "FileSys") to enable search within the documents stored in the file system outside the Cinegy Archive database:

12_DBM_fulltext_documents
Caution
User must have administrator privileges to be able to manage the SQL Server linked servers.

To create a "PHANTOM" server, enter the desired SQL Server instance name and press the "Create" button. The data provider value (SQLOLEDB) will be generated automatically.

To create a "FileSys" server, press the "Create" button; the data provider value (MSIDXS) will be generated automatically.

drop_button

To delete a created server, use the corresponding "Drop" button.

It is an automatic way of creating and configuring SQL Server linked servers. Alternatively, this can be done manually via SQL Server Management Studio.

Important
Refer to the SQL Server Linked Servers Configuration paragraph in the Microsoft Indexing Service article to learn how to create and configure "PHANTOM" and "FileSys" servers manually.