|
|
| Line 2: |
Line 2: |
| | == Data documentation == | | == Data documentation == |
| | | | |
| − | All data included into the databases has be documented! | + | All data included in the databases has be documented! |
| | | | |
| | == Naming of data == | | == Naming of data == |
| Line 8: |
Line 8: |
| | '''Database Name''' | | '''Database Name''' |
| | | | |
| − | The name of the database is *oedb* | + | The name of the database is '''oedb''' |
| | | | |
| | '''Database Schema''' | | '''Database Schema''' |
| Line 14: |
Line 14: |
| | The structure of the database is realised via the naming of the 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; ???) | + | *always lower case |
| | + | *no points, no commas |
| | + | *no spaces |
| | + | *no dates |
| | + | *use underscores |
| | + | |
| | + | |
| | + | |
| | + | #name starts with type of schema |
| | + | #*'''orig''' for original data |
| | + | #*'''calc''' for processed data |
| | + | |
| | + | #name includes distinct subject area or source |
| | + | |
| | + | Example: ''orig_vg250'' |
| | | | |
| | <br/>'''Database Table''' | | <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_) | + | *always lower case<br/> |
| | + | *no points, no commas<br/> |
| | + | *no spaces<br/> |
| | + | *no dates<br/> |
| | + | *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) |
| | + | |
| | + | Example: ''zensus_population_by_gender_per_mun'' |
| | | | |
| − | -> *_zensus_population_by_gender_per_mun_*
| |
| | | | |
| − | *All abreviations have to be documentated (in the Glossary or Wiki)!
| + | All abreviations have to be documentated (in the [[Category:Glossary|Glossary]])! |
Revision as of 09:52, 25 May 2016
Data documentation
All data included in 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 commas
- no spaces
- no dates
- use underscores
- name starts with type of schema
- orig for original data
- calc for processed data
- name includes distinct subject area or source
Example: orig_vg250
Database Table
- always lower case
- no points, no commas
- 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)
Example: zensus_population_by_gender_per_mun
All abreviations have to be documentated (in the)!
