Difference between revisions of "Entity Data Model"
(→Transition) |
|||
| Line 1: | Line 1: | ||
| − | =Introduction= | + | ==Introduction== |
| − | ==Objectives== | + | ===Objectives=== |
In an industrial environment we quite often need to | In an industrial environment we quite often need to | ||
* describe an industrial plant consisting of a bunch of different parts, each having a certain purpose and set of properties, and which are related in various ways | * describe an industrial plant consisting of a bunch of different parts, each having a certain purpose and set of properties, and which are related in various ways | ||
| Line 15: | Line 15: | ||
{{ToDo}} Think about the functions and features of blocks. | {{ToDo}} Think about the functions and features of blocks. | ||
| − | ==Plant picture== | + | ===Plant picture=== |
[[File:UDOM_PlantParts.png|thumb|220px|alt=Parts of a plant|Example plant and parts]] | [[File:UDOM_PlantParts.png|thumb|220px|alt=Parts of a plant|Example plant and parts]] | ||
Lets start with a simple picture and assume that our plant consists of a pump and an armature. Both equipments exhibit certain technical or other properties, which our datamodel must contain in some form. Additionally the datamodel has to provide mechanism to indicate the circumstances that both equipments are parts of the plant and maybe even be related to each other. | Lets start with a simple picture and assume that our plant consists of a pump and an armature. Both equipments exhibit certain technical or other properties, which our datamodel must contain in some form. Additionally the datamodel has to provide mechanism to indicate the circumstances that both equipments are parts of the plant and maybe even be related to each other. | ||
| Line 42: | Line 42: | ||
</strong> | </strong> | ||
| − | =From the plant picture to {{UBIK}}= | + | ==From the plant picture to {{UBIK}}== |
| − | ==Transition== | + | ===Transition=== |
[[File:UDOM_TransitionMetaModel.png|thumb|220px|alt=Transition plant picture|Transition from plant picture into data model]] | [[File:UDOM_TransitionMetaModel.png|thumb|220px|alt=Transition plant picture|Transition from plant picture into data model]] | ||
The transition from the plant picture into an object- / data - model logically happens via an intermediate layer and finally leads to our first definition | The transition from the plant picture into an object- / data - model logically happens via an intermediate layer and finally leads to our first definition | ||
| Line 170: | Line 170: | ||
{{UMM|Data model built and described by MetaClasses and MetaProperties related to each other, either by <b>1 : n</b> or <b>n : n</b> cardinality.}} | {{UMM|Data model built and described by MetaClasses and MetaProperties related to each other, either by <b>1 : n</b> or <b>n : n</b> cardinality.}} | ||
| − | ==Entity Relationship Model (ER model)== | + | ===Entity Relationship Model (ER model)=== |
[[File:UDOM_Relating4.png|thumb|220 px|alt=ER-model|Entitiy-Relationship-Model]] | [[File:UDOM_Relating4.png|thumb|220 px|alt=ER-model|Entitiy-Relationship-Model]] | ||
In software engineering, such an abstract descriptive model is called Entity–Relationship model (ER model) and describes the entities (={{UBIK}} MetaClasses) and relationships between them. Usually this information is depicted in an entity-relationship-diagram (ERD), which draws the corresponding data objects and relations as rectangles and lines between them, respectively. The MetaClass ''„CONTROL“'' can be drawn as diamond, signalling the additional block between these two MetaClasses, which is always needed for each relation of cardinality n : n. | In software engineering, such an abstract descriptive model is called Entity–Relationship model (ER model) and describes the entities (={{UBIK}} MetaClasses) and relationships between them. Usually this information is depicted in an entity-relationship-diagram (ERD), which draws the corresponding data objects and relations as rectangles and lines between them, respectively. The MetaClass ''„CONTROL“'' can be drawn as diamond, signalling the additional block between these two MetaClasses, which is always needed for each relation of cardinality n : n. | ||
| Line 179: | Line 179: | ||
| − | ==About References and Relations== | + | ===About References and Relations=== |
[[File:UDOM_Relating5_RefRel.png|thumb|220 px|alt=References and Relations|{{UBIK}} References and Relations]] | [[File:UDOM_Relating5_RefRel.png|thumb|220 px|alt=References and Relations|{{UBIK}} References and Relations]] | ||
Concluding and summarizing the above discussion we finally depict the two possible types of relation in the {{UBIK}} MetaModel. | Concluding and summarizing the above discussion we finally depict the two possible types of relation in the {{UBIK}} MetaModel. | ||
| Line 192: | Line 192: | ||
{{Checked}} <b>Relationships between blocks (MetaClasses)</b> | {{Checked}} <b>Relationships between blocks (MetaClasses)</b> | ||
| + | |||
| + | ==Conclusion== | ||
Revision as of 15:07, 22 January 2013
Contents
Introduction
Objectives
In an industrial environment we quite often need to
- describe an industrial plant consisting of a bunch of different parts, each having a certain purpose and set of properties, and which are related in various ways
- manage process or maintenance data of the plant and its features
- do a high-performance cost-benefit analysis and create key performance indicators
Therefore we need to
„Dissemble“ the system into theoretical blocks representing the real as well as intangible parts of the system.
Identify the necessary properties of the blocks.
Think about how blocks are possibly related to each other.
Think about the functions and features of blocks.
Plant picture
Lets start with a simple picture and assume that our plant consists of a pump and an armature. Both equipments exhibit certain technical or other properties, which our datamodel must contain in some form. Additionally the datamodel has to provide mechanism to indicate the circumstances that both equipments are parts of the plant and maybe even be related to each other.
In this first exemplary plant, we take account of a pump and armature and find definitions as shown in the picture on the right. Looking closer at the PUMP block reveals its properties and property values, this information is explicitely depicted as
Of course, a real plant consists of multiple pumps, each described with the same set of properties (TAG, vendor, power, maintenance data). The real pumps in the plant are distinguished by different property values as given in the table.
| Pump | TAG | Vendor | Power | Maintenance |
|---|---|---|---|---|
| #1 | P0815 | Andritz | 2 kW | Yearly |
| #2 | P0816 | Andritz | 5 kW | Monthly |
| #3 | P0817 | Sulzer | 4 kW | Yearly |
We can redefine or extend our objectives by
- Design a descriptive model including all required blocks and properties of the system
- An object in this model specifies possible properties for a certain part of the real system
From the plant picture to UBIK®
Transition
The transition from the plant picture into an object- / data - model logically happens via an intermediate layer and finally leads to our first definition
- UBIK® MetaModel
- A descriptive model, where objects provide information about the aspects of the data, is also called “Metamodel”.
So far we have identified
Checked Theoretical blocks representing the parts of the system
Checked Necessary properties of these blocks
An important aspect of the datamodel has not been discussed yet, namely how are the blocks (=MetaClasses) related to each other?
Relating objects
Assuming that all three pumps are clearly parts of the plant „UBIK1“, the descriptive model has to be extended in order to include this information as well. In our "table" view we account for this by adding a property to the „Pump“ block refering to the plant. This additional property represents the link information between the pumps #1 - #3 and the plant „UBIK1“.
 |
20 px |
|
- UBIK® MetaModel
- Add a metaproperty „Plant“ to the MetaClass „Pump“, where the values of the MetaProperty refer to the plant „UBIK1“.
Now we introduce two armatures with the properties from the descriptive model above. Assume that, due to the piping, pumps #1 and #2 are controlled by both armatures, whereas A200 regulates pump #3 only. This situation is depicted below already indicating, that the implementation of the relation requires a more complex structure. We find three pumps on the left side and two armatures on the right side of the relation, respectively. Managing this control relation in the MetaModel requires to introduce a relation block „CONTROL“ with two MetaProperties „Armature#“ and „Pump#“
 |
20 px |
|
20 px |  |
- UBIK® MetaModel
- Managing the control relation in the MetaModel requires to introduce a relation block „CONTROL“ with two MetaProperties „Armature#“ and „Pump#“.
Lets have a closer look at the characteristics of the two methods relating objects:
|
|
||||||||||||||||||||||||||||||||||||
| 40 px | 40 px | ||||||||||||||||||||||||||||||||||||
| each pump refers exactely to the one plant | two pumps are controlled by two armatures one pump is controlled by one armature |
||||||||||||||||||||||||||||||||||||
| 40 px | 40 px | ||||||||||||||||||||||||||||||||||||
| Cardinality 1 : n | Cardinality n : n |
- UBIK® MetaModel
- Data model built and described by MetaClasses and MetaProperties related to each other, either by 1 : n or n : n cardinality.
Entity Relationship Model (ER model)
In software engineering, such an abstract descriptive model is called Entity–Relationship model (ER model) and describes the entities (=UBIK® MetaClasses) and relationships between them. Usually this information is depicted in an entity-relationship-diagram (ERD), which draws the corresponding data objects and relations as rectangles and lines between them, respectively. The MetaClass „CONTROL“ can be drawn as diamond, signalling the additional block between these two MetaClasses, which is always needed for each relation of cardinality n : n.
About References and Relations
Concluding and summarizing the above discussion we finally depict the two possible types of relation in the UBIK® MetaModel.
- UBIK® MetaModel
- 1 : n relationships are called “References” (one pump refers to exactly one plant)
- n : n relationships are called “Relations” (two pumps are controlled by two armatures, one pump is controlled by one armature)
Congratulations, we integrated another important issue in our data- and object model:
Checked Relationships between blocks (MetaClasses)
