HOPEX Information Architecture > Data Architecture > Database and Physical Data
Database and Physical Data
 
Logical Formalism and Synchronization
Database
Creating Databases
Database Properties
Associating a Package with a Database
Importing a DBMS Version
Relational Diagram
Creating the Relational Diagram
Defining the components of a database
Database Tables
Table Columns
Modifying Keys and Indexes
Creating a Key
Creating an Index
Adding a Column to a Key or Index
Specifying Primary and Foreign Keys
Specifying Primary Keys
Specifying Foreign Keys
Column Primary Key of Two Tables
Column Primary Key of Three Tables
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 Information 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 Defining a Data Dictionary.
• 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 Information 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 Information Architecture, and obtain the corresponding data diagram or class diagram. See Reverse engineer tables.