Asset Oriented Modeling (AOM)

- Step by Step (4) -


We make sure that:

Partitioned Normal Form

An asset type is in Partitioned Normal Form (PNF) if the atomic properties of an asset constitute a key of the asset and all non-atomic properties are in Partitioned Normal Form themselves. 

The advantage of PNF-assets is that their structure can be transformed (for example during schema evolution) without loss of information. Especially, if we plan to store assets in relational databases, PNF is essential. Relational technology requires to fragment complex structures into flat relational tables. Keys that span complex structures are lost during such a transformation to First Normal Form (1NF).

Most asset types in our example are in PNF as most of them have an atomic property that acts as primary key.

The asset type "person", however, is not in PNF. It does not have an atomic property which could act as key. The only property is the complex property "name". To transform this asset into PNF, we have two options:

In some cases, however, PNF is too strict. Therefore, PNF is only a "should" and not a "must" for AOM normalization.



Home Definition Step-by-Step Examples Downloads

Contact: support 'at'