The following objects are created on the MDM-RE Database (target database) to provide control information:

Object	Object Type
IDS_FDT_META	Table
IDS_FDT_META_DBID_I	Index
IDS_FDT_META_ID_I	Index
IDS_FDT_META_NAME_I	Index
IDS_FDT_META_NMIDDB_I	Index
IDS_FDT_RECID	Table
IDS_FDT_RECID_NO_I	Index
IDS_RB_GROUPS	Table
IDS_RB_GROUPS_I	Index
IDS_2PC	Table
IDS_UPD_SYNC_NSA	Table
IDS_UPD_SYNC_NSA_I	Index

The following objects are created in the

MDM Registry Edition

database when an Identity Table is loaded. The object names include a prefix,

IDS

, and a two-digit system qualifier,

nn

. System qualifier is the numeral value in a database connection string. For example, if the database connection string is

odb:1:userid/password@service

, the system qualifier is 1.

Object	Object Type	Description
IDS_nn_IDTName	Table	ID Table
IDS_nn_IDLName	Table	Link Table
IDS_nn_IDTName_I[1..n]	Index	ID Table Indexes. _I is the RecId index. _I{1..n} are the PK / join indexes.
IDSX_nn_IDXName	Table	IDX Table
IDSX_nn_IDXName_I	Index	IDX Index

where

nn

indicates the system qualifier.

IDTName

is the value of the

NAME=

parameter from the IDT-Definition.

IDLName

is the value of the

IDL-NAME=

parameter from the

Multi-Search-Definition

.

IDXName

is the value of the

ID=

parameter from the

IDX-Definition

.

Object	Object Type
IDS_nn_INUSE	Table - Rulebase Lock
IDS_nn_SSARBN	Table - Data
IDS_nn_RECOVERY	Table - Restart/Recovery
IDSX_nn_SSARBN	Index

where

nn

indicates the rulebase qualifier, which is the numeral value in a rulebase connection string. For example, if the rulebase connection string is

odb:0:userid/password@service

, the rulebase qualifier is 0.

The Update Synchronizer is supported by various objects which are created by the SQL scripts

updsyncu.sql

and

updsynci.sql

. These objects are created in the source database (containing User Source Tables).

The System Loader will create triggers on the USTs if the

SYNC

option was specified. All triggers use the following naming convention: