Modeling Databases
 
Logical Formalism and Synchronization
Logical Formalism and Synchronization
Database
Creating Databases
Database Properties
Associating a Package with a Database
Importing a DBMS Version
Relational Domain Map and Relational Domains
Relational Domain Map
Relational Domain
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 Architecture integrates the logical and physical modeling levels and is used to switch from one model to another. You can therefore:
• Build a data diagram or a class diagram, See Modeling Data dictionaries.
• 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 Architecture in particular takes 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.