Database
 
Creating Databases
Database Properties
Associating a Package with a Database
Importing a DBMS Version
On a database, and depending on the target DBMS, control parameters of the various data processing tools (synchronization, generation, reverse generation etc.) will be defined.
Creating Databases
Une base de données permet de spécifier la structure de stockage physique des données.
To create a database:
1. Click the Databases navigation menu.
2. Right-click the databases folder and click New > Database.
3. Enter the name of the database.
4. Click OK.
The database created appears in the list of databases.
*When a database is created, the ANSI/ISO 9075:1992 SQL DBMS is associated with it by default.
Database Properties
To access the properties of a database:
*Select the database and click Properties .
Properties pages are used to:
• access the components of the database (tables, physical views, data groups, etc.).
• modify the Characteristics of the database (name, target DBMS, etc.).
• define Responsibilities.
• define the Options linked to:
• the generation of tables. See Configuring Database Generation.
• synchronization. See Configuring Synchronization.
Associating a Package with a Database
You can create a data package from the database or connect an existing package to it. The package enables representation of the structure of the database, the classes it contains and their parts.
The database package is the default owner of the objects represented in the class diagram. However it is possible to use objects held in other packages.
*In the same way, you can connect a data model to a database after having selected the corresponding formalism.
To create a package from a database:
1. Open the properties of a database.
2. In the Characteristics page, expand the Data packages section.
3. Create a package.
Importing a DBMS Version
When you create a new repository, you are provided with different DBMS and versions by default, except for the latest versions, such as "Oracle 18c" and "Oracle 19c. You can download these versions and their datatypes from the Hopex Store.
When a database is created, the ANSI/ISO 9075:1992 SQL DBMS is associated with it by default. You can choose another target DBMS in its properties.
DBMS datatypes are not supplied by default. To view the datatypes of a DBMS in the Hopex repository, you need to import the corresponding module, whose name takes the form "Database Design XXX" with the DBMS name. Modules are available in the Hopex Store.