Physical Data Maps 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 physical data map is used to visualize the dependencies between relational schemas.
Physical Data Maps
A physical data map is an urbanization tool for physical information. It represents a set of relational schemas in a particular context.
Creating a physical data map
To create a physical data map 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. In the edit area, right-click the database and click New > Physical Data Map.
The map created appears.
To create the diagram of the physical data map:
1. Right-click the map and select New > Diagram.
2. Select Physical Data Map Diagram.
3. Click OK.
The diagram appears in the edit area.
Components of a physical data map
You can add internal and external components to a physical data 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.