HOPEX Information Architecture > Data Architecture > Modeling Databases > Database
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
A database enables specification of data physical storage structure.
To create a database in HOPEX Data Governance:
1. Click the navigation menu then Architecture > Hierarchy View.
*In HOPEX Information Architecture, click the navigation menu then Data Architecture> Physical Data Assets.
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.
Database Properties
To access the properties of a database:
1. Select the database and click the Properties button.
The properties window of the database appears.
2. Click on the drop-down list to access the different properties pages.
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 Risks associated, the Standards used, the Objectives and Requirements.
• To 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, if the corresponding formalism has been selected. See Formalisms.
To create a package from a database:
*Click the database icon and select New > Package. This command creates a new package as well as its associated class diagram. See The Class Diagram.
To connect an package to a database:
1. Click the database icon and select Connect > Data Package.
The query dialog box appears.
2. Click Find.
3. Select the desired package and click Connect.
You can see the name of the packages associated with a database in the database properties, in the Characteristics page.
Importing a DBMS Version
At creation of a new repository, only the SQL ANSI/ISO 9075:1992 DBMS version is installed. If you choose another target DBMS for a database, you must import the module for SQL datatypes that is compressed in the DBMS SQL Type.exe file.
The DBMS SQL Type.exe file is available in the Utilities of your HOPEX installation directory.
Once the module is imported in , you can select the appropriate DBMS in the database properties windows.