End-2-End Data Models for Asset Management
Back to the Home Page

Step 8 - Define the KPI Tables

Step 7 - Define the Data Mart Model
This is typically used to store KPI Data.

Step 6 - Define POC Tables
Our Asset Management Service is primarily planned for Utilities including 
Electricity, Gas, Water and Transport, such as Airport, and Rail.

Step 5 - Generate the Asset Register Physical Data Model

Physical Data Model for Asset Management
Step 4 - Asset Register Logical Data Model
Corresponding Tables

Getting Started Conceptual Data Model for Asset Management
Step 3 - Define the Asset Register Conceptual Business Data Model

Getting Started Conceptual Data Model for Asset Management
Step 2 - Define Sample Data
A. Asset Hierarchy :-
1. Category, eg Domestic
2. Supertype, eg Cutlery
3. Type, eg Spoon

B. Lifecycle Phases :- 
These can be common to all types of Assets and typically include :-
1. Acquire
2. Use
3. Maintain
4. Dispose

C. Status :-
1. Needs Maintenance 
2. OK
3. Ready for Disposal
Step 1 - Start with our Canonical Data Model


Canonical Data Model


Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
May 15th. 2017


© Database Answers Ltd. 2017