DATA - Data Architecture > Data and Database Design
Data and Database Design
 
Modeling Data dictionaries
Logical Data Modeling Options
Overview of Logical Data
Data Dictionary
Data Domain Map
Data Domains and Logical Data Domains
Logical Data View
Class Diagram
Datatypes
Data Model
IDEF1X Notation
I.E. Notation
The Merise Notation
Modeling Databases
Logical Formalism and Synchronization
Database
Relational Schema Map and Relational Schemas
Relational Diagram
Database Components
Primary and foreign keys
Data Types and Column Datatypes
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
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
Recognizing Datatypes by ODBC
Physical Properties Reverse Engineering
Extracting Database Schema Description from Data Sources
Pivot Types and Datatypes Correspondence Tables
DB2 Version 9 For OS
MySQL 5.0
Oracle 11
PostgreSQL9.3
SQL ANSI/ISO 9075:1992
SQL Server 2008
Teradata Database