Installation and Configuration Guide

Back Next

Database Objects

MDM Registry Edition

categorizes the database objects into the following logical groups:

Source Database: A source database contains the user data in the User Source Tables (UST).
MDM Registry Edition
can access the USTs by using a user ID that has select privilege on the USTs.; MDM Registry Edition
creates fuzzy indexes on the USTs. Use triggers to synchronize the indexes with the UST updates. The triggers store information about the UST rows that you updated, deleted, or added in a transaction table. The transaction table is part of the source database schema. The user ID must have the privilege to create triggers on the USTs.
Target Database: A target database contains Identity Tables (IDT) and Identity Indexes (IDX).
MDM Registry Edition
creates and updates the identity tables and identity indexes by using a user ID that has create privileges.

If you want the IDTs and IDXs to remain in synchronization with the USTs,
MDM Registry Edition
also creates a two-phase-commit table,
IDS_2PC
, in the target database schema.