How are data for a Production Record Data Model stored

To be able to store Production Event Records, users have to create a data model first. As described by the chapter Core Concept behind recording production record data via data model, the model represents a hierarchy structure with a lot of variability.

Every data model, which in EAV terms equals an entity, is defined by a unique name called a NodeName inside Litmus Production Record Database, which will get its own distinct ID assigned.

In the example below, the NodeName is Line X.

All further definitions for this hierarchy such as the sub-levels (Station A and Station B) as well as all items (purple boxes) are in EAV terms attributes.

The relation between an entity and an attribute is created by forming a relation between the respective ID of the entity and the ID's of an attribute.

Data are later recorded just with the reference to their respective attribute.

In most use cases for an EAV data model like:

data are stored directly against an entity itself.

As events recorded by Litmus Production Record Database are not observed only one time but on a reoccurring basis, it is necessary to create basically an index of each event.

Litmus Production Record Database does solve this through the concept of a Production Record ID or ProRecID for short.

A ProRecID is a unique index for a specific event recorded for a specific data model.

This does allow users to retrieve the data recorded for a specific data model for a specific event.

As this does require to know the ProRecID and users typically do not know a specific ProRecID, Litmus Production Record Database makes use of Identifiers.

Identifiers are up to five attributes, which in their unique combination describe a specific ProRecID.

These Identifiers should be chosen based on how an organization refers to these events on a day to day basis, as it then allows their natural understanding to retrieve the data.

Below are some possible examples for what Identifiers could be.

For more examples, please go to the chapter Litmus Production Record Database Use Cases.

Users are therefore able to retrieve event data by searching for the event id which correlates with the value recorded for the identifiers for the desired data model.

Example is shown by the chapters: