Managing database search modes - 7.0

Talend Data Fabric Installation Guide for Linux

EnrichVersion
7.0
EnrichProdName
Talend Data Fabric
task
Installation and Upgrade
EnrichPlatform
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend DQ Portal
Talend ESB
Talend Identity and Access Management
Talend Installer
Talend JobServer
Talend Log Server
Talend MDM Server
Talend MDM Web UI
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio

In Talend MDM, the master data records can be stored in a SQL database, and a second SQL storage also exists which serves as the Staging Area for the master database. For more information, see Working with a Staging Area.

Searches in the master database support both full text search and standard SQL search, while searches in the staging database only support standard SQL search.

Standard SQL search considers the search content as an integrate phrase to be matched, while full text search interprets the search content as a phrase which contains multiple words, and the records that match any of the words will be returned. For example, if the search content is test first name, full text search considers it as three independent words test, first, and name, while standard SQL search considers it as one phrase test first name.

By default, the full text search mode is used for searches in the master database.

If needed, you can change the default settings in the file <$INSTALLDIR>/conf/datasources.xml to optimize the master database searches.

Procedure

  1. Open the file <$INSTALLDIR>/conf/datasources.xml.
  2. Add the contains-optimization option with the value like following the fulltext-index-directory option.
    For example:
    <fulltext-index-directory>/home/user/Talend/Talend-MDMServer/data
    /indexes/H2-Default</fulltext-index-directory>
    <contains-optimization>like</contains-optimization>
    The value for the contains-optimization option can be:

    Value

    Description

    like

    This is the default value when no full-text indexes are set. In this case, the standard SQL search mode is used for searches in the master database.

    disabled

    With this value set, an exception will be thrown if MDM encounters a condition with a CONTAINS.

    fulltext

    This is the default value when full-text indexes are available. In this case, the full text search mode is used for searches in the master database.

    If the contains-optimization option is set to fulltext, the MDM server will perform case insensitive searches no matter what the value of case-sensitive-search is. For more information, see Managing the case-sensitivity in database searches.

  3. Save your changes.