To make the Cinegy Archive database searchable, you will have to build the full-text catalog:

  • the catalog must be built for the relevant database tables;

  • the re-indexing must be enabled.

The "Full-text catalog manager" feature of Cinegy Enterprise Manager fulfills the tasks automatically for you.

Database Tab

On this tab searching properties for the Cinegy Archive database are configured.

If there are already indices in the database, you will be warned and asked to confirm the re-creation of the indices.

12_DBM_fulltext
Important
Refer to the Microsoft SQL Server documentation to get more details about the signature verification tool.

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.

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.