HOPEX Information Architecture > Data Architecture - Tools
Data Architecture - Tools
 
Synchronizing logical and physical models
Synchronization Display Options
"Logical to Physical" Synchronization Rules
From the Logical Model to the Physical Model
Reduced Synchronization (Logical to physical mode)
Running Synchronization After Modifications
From the Physical Model to the Logical Model
Configuring Synchronization
Diagram Synchronization
Model Mapping
The Database Editor
Mapping Details
Denormalizing logical and physical models
Denormalization Principles
Logical Denormalization
Physical Denormalization
Generating SQL scripts
Running SQL Generation
Incremental Generation
Configuring SQL generation
Supported Syntax
Defining Database Views
Defining Triggers for a Database
Using Stored Procedures
Adding Physical Properties to Database Objects
Reverse engineer tables
Running Reverse Engineering
Physical Properties Reverse Engineering
ODBC Extraction Utility
Pivot Types and Datatypes Correspondence Tables
The following tables show correspondence between pivot types and the different supported DBMSs and their versions.DB2 OS/390 Version 5
DB2 OS/390 Version 7
DB2 for z/OS Version 8
DB2 Universal Database Version 5
DB2 Universal Database Version 7
DB2 Universal Database Version 8
DB2 Universal Database Version 9
DB2 Version 9 For OS
Informix Dynamic Server 7.3
Ingres II 2.0
MySQL 4.1
MySQL 5.0
Oracle 10
Oracle 11
Oracle 8
Oracle 9i
PostgreSQL9.3
SQL ANSI/ISO 9075:1992
SQL Server 2000
SQL Server 2005
SQL Server 2008
SQL Server 7
Sybase Adaptive Server 11
Sybase Adaptive Server 12.5
Teradata Database