MDM Console Reference Guide
Basic Concepts
What is an MDM Repository?
The MDM Software Environment
Configuration Parameters
MDM Console Security
MDM Repository Structure
Table Types
Data Types
Maximum Text Width
Dimensions and Units
Taxonomies
Attributes
Qualified Tables and Qualifiers
Product Applications and Application-Based Search
Product Families
Product Masks
Data Groups
Validations and Validation Groups
Data Quality and MDM
MDM Console Overview
Starting and Exiting the MDM Console
Loading the MDM Console Settings File
MDM Console Main Window
Selection Methods
Mouse And Motion Key Selection
Typeahead Seek Selection
Tips for Working with Trees
Tips for Working with Grids
Saving and Restoring Records
MDM System Management
Working with the MDM Console
MDM Console at a Glance
Console Hierarchy Pane
Objects Pane
Object Detail Pane
MDM Server and Repository Management
MDM Server Security
Working with MDM Servers
Accessing an MDM Server
Mounting and Unmounting the MDM Server
Starting and Stopping the MDM Server
Working with MDM Repositories
DBMS Servers
Repository Port Numbers
Accessing an MDM Repository
Mounting and Unmounting an MDM Repository
Connecting to and Disconnecting from an MDM Repository
Loading and Unloading an MDM Repository
Repository Maintenance
Designing an MDM Repository
Planning the MDM Repository
Main Table
Flat and Hierarchy Lookup Tables
Taxonomy Lookup Tables
Qualified Lookup Tables
Multiple Prices and Cross References Part Numbers
Product Application and Application-Based Search
Valid Tables and Nested Lookups-Within-Lookups
Fields Versus Attributes - A Comparison
Object Tables
Lookup and Non-Lookup Subtables - A Comparison
Special Tables and System Tables
Code Property
Creating an MDM Repository
Repository Options
Repository Partitions
Subset and Schema-only Partition
Repository Structure Operations
Working with Tables
Adding and Modifying Tables
Display Fields
Unique Fields
Display Fields, Unique Fields, and Record Operations
Family Field
Alternative Display Fields
Deleting Tables
Working with Fields
Adding and Modifying Fields
Required Fields
To Normalize or Not to Normalize
To Sort Index or Not to Sort Index
Sort Types
To Keyword or Not to Keyword
To Cache or Not to Cache
Decimals, Fractions, and Floating Point Precision
Show Fractions
Calculation Fields
Create Stamp, Time Stamp and User Stamp Fields
Reordering Fields
Deleting Fields
Families Table
Image Variants Table
Configuring the Watermark
Relationship Table
Relationship Types
Sibling versus Parent/Child Relationships
Single- versus Multi-Table Relationships
Single- versus Multi-Level Relationships
Hybrid Relationships
Relationship Qualifiers
Workflows Table
MDM Repository Security
Console-Level Repository Security
Users Table
Roles Table
Functional Privileges
Table and Field Privileges
Record Constraints
Performing MDM Operations
Connections Table
Other System Tables
Change Tracking Table
Remote Systems Table
Key Generation
Ports Table
Links Table
URL Syntax
XML Schemas Table
Reports Table
Logs Table
Repository Properties
DBMS Settings
DBMS Initialization
MDM DBMS Server Account
Multiple DBMS Instances
Repository Administration
Repository Administration Operations
Appropriating an MDM Repository
Updating an MDM Repository
Verifying an MDM Repository
Duplicating an MDM Repository
Deleting an MDM Repository
Maintaining Master and Slave Repositories
Master/Slave Landscapes
Master/Slave Limitations
Moving Master and Slave Repositories
Synchronization Requires Identical MDM Server Versions
Identifying Master and Slave Repositories
Publication Slaves
Master/Slave-Related Operations
Creating Master and Slave Repositories
Synchronizing a Slave Repository
Broken Master/Slave Repositories
Normalizing a Master or Slave Repository
Backing Up and Restoring a Repository
MDM Repository Archive and Unarchive
Archiving an MDM Repository
Archive Options Dialog
Unarchiving an MDM Repository Over Another Repository
Creating a New MDM Repository from an MDM Archive
Archive Report
Managing Archive Files
Dealing with Outdated Archives
MDM Publication Model Archive and Unarchive
Exporting and Importing Schemas
Exporting an MDM Repository Schema
Importing an MDM Repository Schema
Import Schema Dialog at a Glance
Color Coding in the Import Schema Dialog
Importing the Schema
Manually Overriding Schema Reconciliation
Creating an MDM Repository from a Schema File
Multilingual Support
Introduction
Multi-Byte Unicode Implementation
Multi-Layered Data Model
Language-Centric Views
Multilingual Repository Metadata
Multilingual Repository Data
Multilingual Publishing
Multilingual GUI Software
Repository Languages and Language Names
Multilingual Data and Metadata Elements
Multilingual Basics
Language Layers
Language Inheritance
Inheritance Levels
Quick Reference
Multilingual Operations
Modifying the Repository Languages
Changing the Display Name of a Repository Language
Modifying Language-Specific Language Inheritance
Defining Multilingual Table Names
Defining Multilingual Field Names
Defining Multilingual Fields
Remote Systems and MDM
Introduction
What is a Remote System?
Key Mapping
Remote Systems Table
[Remote System] and [Remote Key] Fields
Remote System Semantics
What is a Port?
Port Benefits
Ports and the File System
Ports Table
Quick Reference
Remote System Operations
Managing Remote Systems
Specifying Key Mapping for a Table
Managing Ports
UI Language Selection
Starting the MDM Language Selector Utility
MDM UOM Manager
Introduction
Getting Started
Find Functionality
Working with Dimensions
Working with Units
CLIX Command Line Interface
Command Line Interface to MDM
CLIX Command Syntax
Command Names
Arguments
Option Flags
CLIX Commands
Command Detail
MDM Server Commands
MDS Activity Monitoring Command
Repository Control Commands
Master/Slave Commands
Activity Monitoring Commands
Repository Copying Commands
DBMS Commands
CLIX Errors
DBMS Settings
Appendices
Keyword Stemming Engine
LDAP Support
What is LDAP?
How LDAP Works
Basic MDM LDAP
MDM LDAP Fields
LDAP Access
MDM LDAP Algorithm (Basic)
MDM LDAP Algorithm (Alternative)
MDM LDAP Algorithm (Fallback)
MDM Architecture in LDAP
Restrictions and Limitations
LDAP Errors and MDM
Trusted Connections
How Trusted Connections Work
Command Line Arguments
Configuration Files
MDM Server Settings
DBMS Servers List
Subtables and Qualified Tables
Miscellaneous Notes
Connecting to a DBMS Server for the First Time
Installing Updates to the MDM Software
Backing Up Repositories Before Updating Software
Manual Deletion of Files
Manually Starting and Stopping the MDM Server
DBMS Versions for Optimized MDM Performance
MDM File Locations and File System Security
Controlling MDM from a Command Prompt
Photoshop and Photoshop Image Processing
Object Cache Size Registry Setting
DBMS Optimization Tips
Collation Settings and Character Sets
Reference
Menu Command Reference
File Menu
View Menu
MDM Servers Menu
Repositories Menu
Tables Menu
Fields Menu
Help Menu
Import Schema Dialog Context Menu
Other Context Menu Commands
Display and Format Conventions