HOPEX Information Architecture > IA Physical Layer
IA Physical Layer
 
HOPEX Information Architecture - Physical Layer
Data Modeling Options
Database and Physical Modeling
Database
Relational Diagram
Physical Modeling
Specifying Primary and Foreign Keys
Database Modeling Rules
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
Attribute and Column Types
Attribute Datatypes
Determining Column Datatypes from Attribute Types
Mappings Between Pivot Types and Datatypes
Creating New Datatypes
Generating SQL scripts
Running SQL Generation
Incremental Generation
Configuring SQL generation
Supported Syntax
Advanced SQL Options
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
Extracting the Description of a Database
Customizing ODBC Extraction
Select Clause Formats
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
DB2 Version 10.5: Syntax supported by HOPEX
Detail of Concepts Managed by DB2 V10.5
Creating Datatype Packages
Physical Parameters
PostgreSql 9.3: Syntax supported by HOPEX
Detail of Concepts Managed by PostgreSQL
Creating Datatype Packages
Physical Parameters