Difference between revisions of "Database structure"
From PhotoVoltaic Logger new generation
m (→pvlng_babelkit) |
m (→pvlng_tree) |
||
| Line 13: | Line 13: | ||
The channel tree is organized in a nested set structure. | The channel tree is organized in a nested set structure. | ||
| − | <blockquote>The nested set model is a particular technique for representing nested sets (also known as trees or hierarchies) in relational databases. | + | <blockquote>The nested set model is a particular technique for representing nested sets (also known as trees or hierarchies) in relational databases. |
| + | <cite>[[Wikipedia:Nested set model]]</cite></blockquote> | ||
[http://www.evanpetersen.com/item/nested-sets.html More theory] about nested sets. | [http://www.evanpetersen.com/item/nested-sets.html More theory] about nested sets. | ||
| + | |||
[[File:DBTableTree.png]] | [[File:DBTableTree.png]] | ||
Revision as of 18:23, 10 March 2014
Contents
Abstract
pvlng_type
pvlng_channel
pvlng_tree
The channel tree is organized in a nested set structure.
The nested set model is a particular technique for representing nested sets (also known as trees or hierarchies) in relational databases. Wikipedia:Nested set model
More theory about nested sets.
pvlng_reading_num / pvlng_reading_str
The difference between the reading tables is only the data format for reading values.
The timestamps are not stored as "normal" timestamp type, but as unsigned integer.
It was tested and have significant more performance for consolidated data readouts.
pvlng_babelkit
Here are stored all translations for the web frontend.
