Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Installing MDM Registry Edition
  4. Post-Installation Tasks
  5. Troubleshooting
  6. Upgrading MDM Registry Edition
  7. Uninstalling MDM Registry Edition

Installation and Configuration Guide

Installation and Configuration Guide

Database Objects

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.

0 COMMENTS

We’d like to hear from you!