DATA - Data Architecture > Data and Database Design > Modeling Databases
Modeling Databases
 
Logical Formalism and Synchronization
Database
Creating Databases
Database Properties
Associating a Package with a Database
Importing a DBMS Version
Relational Schema Map and Relational Schemas
Relational Schema Map
Relational Schema
Relational Diagram
Creating the Relational Diagram
Database Components
Database Tables
Table Columns
Modifying Keys and Indexes
Creating a Key
Creating an Index
Adding a Column to a Key or Index
Primary and foreign keys
Specifying Primary Keys
Specifying Foreign Keys
Column Primary Key of Two Tables
Column Primary Key of Three Tables
Data Types and Column Datatypes
Attribute Datatypes
Determining Column Datatypes from Attribute Types
Mappings Between Pivot Types and Datatypes
Creating New Datatypes
Database Modeling Rules
A database is the physical object that enables storage and organization of logical data for use by programs corresponding to distinct applications, to facilitate the independent evolution of the data and the application programs.
HOPEX Data Governance and HOPEX Data Architecture integrate the logical and physical modeling levels and allow to switch from one model to another. You can therefore:
• Build a data diagram or a class diagram, See Defining Logical Data.
• From this diagram, create database tables and their columns, indexes, and keys, as well as the drawings for the corresponding relational diagrams. See Synchronizing logical and physical models.
• Optimize the resulting relational model and generate SQL commands to define the tables. HOPEX Data Governance and HOPEX Data Architecture in particular take account of changes in the conceptual model without losing optimizations made to the relational model. See Denormalizing logical and physical models.
• Reverse generate a database definition using the ODBC protocol to create the corresponding tables and columns in HOPEX Data Architecture, and obtain the corresponding data diagram or class diagram. See Reverse engineer tables.