Data modeling‎ > ‎


The purpose of a data model is to transform data into valuable information that the company can use to make clever decisions. In many companies, the data modeling discipline is not very well understood and often completely neglected. Data modeling requires deep insights in the business domain, and the standards and regulations that govern the business domain. Learning a standard is like learning a new language. Starting an ERP-implementation project without a common language is like building the tower of Babylon - I'm afraid it's a rule rather than an exception in many companies. There are many standards to pick from and they all have their strengths and weaknesses. The most important standards that can be used to model the backbone are listed below:
  • ISO/IEC 81346
    • VGB-Standard-S-823-T32
  • ISO 15926
  • ISO 14224
  • IEC 61355
The main drivers in the wind energy sector has agreed upon the "VGB-Standard-S-823-T32" standard which is a dialect of ISO/IEC 81346.

Most standards have their origin in the old paper based world where "structures" were always hierarchical. It's obvious for most data modelers that this puts some constrains on what you can model. Using standards must never prevent you from being smart, evil tongues say that "standards" are the lowest common denominator - there is some truth in that.

ISO/IEC 81346
The title of the standard is: "Industrial systems, installations and equipment and industrial products – Structuring principles and reference designations". The wind energy sector has managed to agree on common standard called VGB which is a dialect of ISO/IEC 81346. Here are some words for your new vocabularium: object, aspect, system, structuring, function, location, products, components, types, occurrencesindividuals etc. Each of these words has a well-defined meaning that all on the data modeling team should understand in order to be able to have meaningful discussion. 

Put some graphics here....

ISO 15926
The title of the standard is: "hkhkjhkjhkjhkj". It is a huge standard and complex standard. I only use it as a guidance for classification of products (hence ISO/IEC 81346) and characteristics. The classification tree is very deep, and maybe you do not need to go down to lowest classification level. The classified products are attached to the aspect nodes described in the ISO/IEC 81346 standard.  

Example - Classification of PUMP
  • PUMP

ISO 14224
The title of the standard is: "jhkahdkjahsdkadjhkjh". 

IEC 61355