Introduction to CES Database Manager

CES Database Manager is GUI tool and is used to create and administer a database. You can use CES Database manager to perform installation, administration, and performance turning on a CES database on all supported platforms. CES Database Manager allows you to:

  • Create and administer an Oracle database instance.

  • Load and upgrade CES core data model.

  • Install the Oracle Text Search option for querying the text properties in databases.

  • Tune and optimize a CES Database.

 

Using Keyword Search

Keyword Search searches the properties that are defined as context searchable in the default configuration. The algorithms used for searching are:

Fuzzy Search: performs search and gives results if words are misspelled.

Soundex/homonym Search: performs search and gives results when words have the same sound or spelling but a different meaning.

Synonyms: words that have nearly the same meaning.

Stem: Contain a common linguistic root

The order in which the above algorithms can be used for performing searches can be configured using CES Category, Smart Search Scenario (CSM_SS_SCENARIO)  >  Multi Word(CSM_MULTI_WORD), Smart Search Scenario  >  Single Word(CSM_SINGLE_WORD).

Oracle uses Context Indexing for searching. Context indexing provides powerful search, retrieval, and viewing capabilities. It also provides advanced linguistic processing.

DB2 uses Text extender for searching. With the text extender searching can be done by soundex, synonym, thesaurus, proximity, linguistic, and several other criteria.