Technology assets in the Guided Stewardship model

The following Technology assets are considered part of the Guided Stewardship operating system:

• System, which is part of the semantic layer.
• Database, which is part of the physical layer.

Database asset type

Database assets represent the physical databases in your data environment. They are the highest level of physical data organization in a data environment. Database assets should have specific names, and implement specific technologies, such as PostgreSQL. Although the Database asset type is a Technology asset, it is considered part of the physical layer.

Database assets are:

Related to...	Via the relation type...	Description
System assets	System groups / is grouped by Database	One-to-many relation, whereby: A System asset can group many Database assets. A Database asset can be grouped by only one System asset.
Schema assets	Database has / belongs to Schema	One-to-many relation, whereby: A Database asset can have many Schema assets. A Schema asset can belong to only one Database asset.

System asset type

System assets represent executable software that an organization uses to automate business functions that help run the business smoothly and efficiently. Systems can be any commercially available or privately developed software. Although the System asset type is a Technology Asset, it is considered part of the semantic layer.

Example CRM, ERP, and EDW software

System assets are:

Related to...	Via the relation type...	Description
Data Model assets	System implements / is implemented in Data Model	One-to-one relation, whereby: A System asset can implement only one Data Model asset. A Data Model asset can be implemented by only one System asset.
Database assets	System groups / is grouped by Database	One-to-many relation, whereby: A System asset can group many Database assets. A Database asset can be grouped by only one System asset.

Related topics

About the semantic layer
About the semantic layer
About the Guided Stewardship model