Database Answers Asset Lifecycle
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Asset Management   

An Access Database is available.

We might also design a Data Mart which is very useful for providing data for Reports and Business Intelligence.

We would be glad to have your comments.

If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.

The Requirements Have been derived from a review of the Wikipedia entry for Asset Management

Step - Create the Top-Level Model

When we think about our final draft, we realise that all the Entities are Hierarchies.
For example, the Services are grouped on Categories, Staff are in Organisation Hierarchies 
(where people usually report one-level up), and so on.

We show this in our Model as self-referencing Relationships for each Entity, which we call
Recursive or Reflexive Relationships, or 'Rabbits-Ears'.

In this Model, the Life Cycle of an Asset is shown as Services that cover the 
typical Phases of :-
  • Acquisition
  • Usage
  • Maintenance
  • Finally the Disposal of an Asset. We have also created separate Subject Area Models :-
  • Assets
  • Clients
  • Equipment
  • Events
  • Maintenance
  • Overhaul
  • Parties, Roles and Customers
  • Repair
  • Services
  • Data Model for Asset Management
    Step - Create the 'Business-friendly' Semantic Model
    This is specifically designed to be the 'Business-friendly' and to provide a vehicle for 
    communication with business users and Subject Matter Experts.
    We have not shown the 'Rabbits-Ears' to keep the diagram simple and easier to understand.
    Final Semantic Data Model for Asset Management

    Barry Williams
    Principal Consultant
    Database Answers Ltd.
    London, England
    February 24th. 2013

    © DataBase Answers Ltd. 2013
    About Us Contact Us