2.8.4.7 Creating Thesaurus for Graph

This section describes how to create Thesaurus for Graph and it is required to execute the Graph batches.

Note:

• This section is applicable when MATCHING_MECHANISM is set to OT.
• There is no additional configuration required for OpenSearch.
• For a fresh installation, there is no thesaurus available in the database.

To create a thesaurus in the Graph schema:

1. Navigate to the <COMPLIANCE_STUDIO_INSTALLATION_PATH>/deployed/ficdb/graphmetadata/ bin directory.
2. Execute the following command:
   ./CreateDBThesaurus.sh -h
   The script has two options:

   1. Create: This option helps to generate the pre-seeded thesaurus in the database.
   2. Reset: This option helps the user to update the pre-existing thesaurus. If there is any change in the data, the user can run the script with a reset flag, and the thesaurus will be updated.

   If it is CREATE mode, refer to the example below:

   /CreateDBThesaurus.sh -c -gd <GRAPH_DATASOURCE_NAME>.

   If it is RESET mode, refer to the example below:

   ./CreateDBThesaurus.sh -r -gd <GRAPH_DATASOURCE_NAME>

   Note:

   • If you want to verify whether thesaurus is created or not, then execute the command:

     select * from ctx_user_thesauri;

   • If thesaurus is created, you can see it in the <COMPLIANCE_STUDIO_INSTALLATION_PATH>/workspace/ dbThesaurus directory.
   • To DELETE thesaurus, execute the following command in the data schema:

     BEGIN
     CTX_THES.DROP_THESAURUS('THESAURUS_NAME');
     END

   • Users need to delete/drop the thesaurus from the database manually. You can find all the thesaurus details, including thesaurus owner and name, inside the ctx_thesauri table in the data schema. Only the owner of that thesaurus can drop/delete it.
   • Only one thesaurus can be created in one Database server with the specified thesaurus name.