Relational Schema Map and Relational Schemas
A database can be split into a set of relational schemas.
A relational schema is used to define a physical data structure.
A relational schema map is used to visualize the dependencies between relational schemas.
Relational Schema Map
A relational schema map is an urbanization tool for physical information. It represents a set of relational schemas in a particular context.
Creating a relational schema map
To create a relational schema map in HOPEX Data Governance:
1. Click the Architecture > Databases navigation menu.
In HOPEX Data Architecture, click the Databases navigation menu.2. In the edit area, right-click the database and click New > Relational Schema Map.
The map created appears.
To create the diagram of the relational schema map:
1. Move the mouse over the map and click the Create a Diagram button.
2. Select Relational Map Diagram.
3. Click OK.
The diagram appears in the edit area.
Components of a relational schema map
You can add internal and external components to a relational schema map.
The internal components are relational schemas that are part of the map scope (whether they belong to the same owner element or not).
The external components are those used in the map but that are not part of the scope analyzed.
To add a relational schema to the map:
1. In the diagram insert toolbar, click the Relational Schema button then click in the map.
2. Indicate the name of the relational schema and click OK.