This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
architecture [2011/11/15 22:07] jap |
architecture [2011/11/21 10:29] jap |
||
---|---|---|---|
Line 19: | Line 19: | ||
{{:db_structure.png|}}\\ | {{:db_structure.png|}}\\ | ||
//Database structure// | //Database structure// | ||
+ | <del> | ||
''MemDB'' is the primary data exchange database. It contains two tables: ''Variable'' and ''Value''. Each physical parameter, like sensor reading, actuator target value, etc. has one row in ''Variable'' table defining properties of the variable. Each variable may have several values, separated with timestamp. Current value is the one with latest timestamp. | ''MemDB'' is the primary data exchange database. It contains two tables: ''Variable'' and ''Value''. Each physical parameter, like sensor reading, actuator target value, etc. has one row in ''Variable'' table defining properties of the variable. Each variable may have several values, separated with timestamp. Current value is the one with latest timestamp. | ||
Line 32: | Line 32: | ||
Example:\\ | Example:\\ | ||
- | Sensor //Outdoor Air Temperature// of ventilation unit may simultaneously belong to both ventilation measurements group and outdoor weather measurements group. | + | Sensor //Outdoor Air Temperature// of ventilation unit may simultaneously belong to both ventilation measurements group and outdoor weather measurements group.</del> |
=== Initialization === | === Initialization === |