|
|
| Line 1: |
Line 1: |
| | | | |
| − | Rule 1: Follow the rules
| + | == Data documentation == |
| | + | |
| | + | All data included into the databases has be documented! |
| | + | |
| | + | == Naming of data == |
| | + | |
| | + | '''Database Name''' |
| | + | |
| | + | The name of the database is *oedb* |
| | + | |
| | + | '''Database Schema''' |
| | + | |
| | + | The structure of the database is realised via the naming of the schema! |
| | + | |
| | + | *always lower case; no points; no spaces; no dates -> use underscores; ...<br/># name starts with type of schema (*orig* for original data; *calc* for calculations; ???) |
| | + | |
| | + | <br/>'''Database Table''' |
| | + | |
| | + | *always lower case; no points; no spaces; no dates -> use underscores; ...<br/># name starts with the source (e.g. _zensus_)<br/># main value (e.g. _population_)<br/># if separated by [attribute] (e.g. _by_gender_)<br/># with resolution [tupel] (e.g. _per_mun_) |
| | + | |
| | + | -> *_zensus_population_by_gender_per_mun_* |
| | + | |
| | + | *All abreviations have to be documentated (in the Glossary or Wiki)! |
Revision as of 13:50, 20 May 2016
Data documentation
All data included into the databases has be documented!
Naming of data
Database Name
The name of the database is *oedb*
Database Schema
The structure of the database is realised via the naming of the schema!
- always lower case; no points; no spaces; no dates -> use underscores; ...
# name starts with type of schema (*orig* for original data; *calc* for calculations; ???)
Database Table
- always lower case; no points; no spaces; no dates -> use underscores; ...
# name starts with the source (e.g. _zensus_)
# main value (e.g. _population_)
# if separated by [attribute] (e.g. _by_gender_)
# with resolution [tupel] (e.g. _per_mun_)
-> *_zensus_population_by_gender_per_mun_*
- All abreviations have to be documentated (in the Glossary or Wiki)!
