Defining the Master Index Match String (Repository)

The match string defines the fields that are passed to the match engine for probabilistic weighting. By default, the fields defined for matching are the fields you specified for matching in the wizard or Configuration Editor. You can modify and delete fields in the match string if necessary. At least one field must be defined in the match string or no weights will be generated.

If you do modify the match string, you might need to make corresponding changes to the match engine configuration files as well. For more information about modifying these files, see the appropriate match engine implementation guideUnderstanding the Oracle Java CAPS Match Engine.

Perform either of the following tasks to configure the match string.

• Creating the Master Index Match String (Repository)

• Modifying the Master Index Match String (Repository)

Creating the Master Index Match String (Repository)

A default match string is predefined based on the match type information you specified in the wizard. If no match types were defined using the wizard, the structure of the match string is still defined but with no fields. You can use normalized or phonetically encoded fields for the match string.

To Create the Match String (Configuration Editor)

1. In the Projects window, right-click the master index application you want to modify, and then click Open.
2. If the Configuration Editor dialog box appears, click Edit to check out the listed files.

   The Configuration Editor appears.

3. Expand the object structure so all fields are visible.
4. To add a field to the match string, click on the field name and then select a value for the Match Type field on the Properties page.

   ---

   Note - The match types you can use are listed in the first column of matchConfigFile.cfg. For more information about Oracle Java CAPS Match Engine match types, see Understanding the Oracle Java CAPS Match Engine.

   ---

5. Perform the previous step for each field in the match string.
6. On the Configuration Editor toolbar, click Save.

To Create the Match String (XML Editor)

1. In the Projects window, expand the Configuration node in the project you want to modify, and then double-click the Match Field file.

   The file opens in the NetBeans XML editor.

2. In the MatchingConfig element, scroll to the match-columns element in the match-system-object element.
3. To add a field to the match string, do the following:
   1. In the match-columns element, create a new match-column element.
   2. In the new match-column element, create and define a column-name element.

      Enter the fully qualified field name of the field on which to match (for example, Enterprise.SystemSBR.Person.Address.City).

   3. Following the column-name element, create and define a match-type element.

      Enter an ID that identifies the field to the match engine. For the Oracle Java CAPS Match Engine, this value must correspond to a defined match type.

      For example:

      <match-system-object>
         <object-name>Address</object-name>
         <match-columns>
           <match-column>
             <column-name>Enterprise.SystemSBR.Person.Address.StreetName
             </column-name>
             <match-type>StreetName</match-type>
           </match-column>
         </match-columns>
      </match-system-object>

4. Repeat the previous step for each field to add to the match string.
5. Save and close the file.

Modifying the Master Index Match String (Repository)

Once you define a match string, you can modify or delete information about the fields in the match string as necessary. This should only be done prior to moving to production. Otherwise, unexpected matching results might occur. For more information about Oracle Java CAPS Match Engine match types and field IDs, see Understanding the Oracle Java CAPS Match Engine.

To Modify the Match String (Configuration Editor)

1. In the Projects window, right-click the master index application you want to modify, and then click Open.
2. If the Configuration Editor dialog box appears, click Edit to check out the listed files.

   The Configuration Editor appears.

3. Expand the object structure so all fields are visible.
4. To add a field to the match string, click the field name and then select a value for the Match Type field on the Properties page.

   The field is added to the match string.

5. To modify the match type specified for a field, click the name of the field defined for matching and then select a new value for the Match Type field on the Properties page.
6. To remove a field from the match string, click the name of the field defined for matching and then select None for the Match Type field on the Properties page.
7. On the Configuration Editor toolbar, click Save.

To Modify the Match String (XML Editor)

1. In the Projects window, expand the Configuration node in the project you want to modify, and then double-click the Match Field file.

   The file opens in the NetBeans XML editor.

2. Scroll to the MatchingConfig element, and then scroll to the match-system-object element.
3. To add a field to the match string, do the following:
   1. In the match-columns element, create a new match-column element.
   2. In the new match-column element, create and define a column-name element.

      Enter the fully qualified field name of the field on which to match (for example, Enterprise.SystemSBR.Person.Address.City).

   3. Following the column-name element, create and define a match-type element.

      Enter an ID that identifies the field to the match engine. For the Oracle Java CAPS Match Engine, this value must correspond to a defined match type.

      For example:

      <match-system-object>
         <object-name>Address</object-name>
         <match-columns>
           <match-column>
             <column-name>Enterprise.SystemSBR.Person.Address.StreetName
             </column-name>
             <match-type>StreetName</match-type>
           </match-column>
         </match-columns>
      </match-system-object>

4. To change a field used in the match string, change the value of the column-name element.

   Enter the fully qualified field name of the new field (for example, Enterprise.SystemSBR.Person.FirstName).

5. To change the type of matching to perform for a field, change the value of the match-type element.

   Enter an ID that identifies the field to the match engine. For the Oracle Java CAPS Match Engine, this value must correspond to a defined match type.

6. To delete a field from the match string, delete all text between and including the match-column element defining the field you want to delete.

   Using the example below, to delete the HouseNo field from the match string, delete the boldface text.

   <match-system-object>
     <object-name>Address</object-name>
     <match-columns>
        <match-column>
          <column-name>Enterprise.SystemSBR.Person.Address.StreetName
          </column-name>
          <match-type>StreetName</match-type>
        </match-column>
        <match-column>
          <column-name>Enterprise.SystemSBR.Person.Address.HouseNo
          </column-name>
          <match-type>HouseNumber</match-type>
        </match-column>

7. Save and close the file.