@@ -152,7 +152,7 @@ The following procedures are implemented to ascertain data quality in the databa
...
@@ -152,7 +152,7 @@ The following procedures are implemented to ascertain data quality in the databa
- Controlled vocabulary: Those are a special version of foreign keys, here used for qualitative attributes: Whenever a qualitative attribute is recorded, controlled vocabularies (a list of allowed values for that column) are used. These assure, that the same thing is always called the same (and without typos) and no further data cleaning is necessary before data evaluation. Controlled vocabularies are stored in separate tables. These tables can not be changed by the ordinary user, but only by admins. Deletion in controlled vocabularies are not recorded in the database itself (no soft delete mechanism), here the admin is responsible to keep a backup. In the \__column_definition\_ view those columns are marked in the \__controlled_vocabulary\_ and. Possible entries for those columns can be seen in the \__controlled_vocabularies\_ view.
- Controlled vocabulary: Those are a special version of foreign keys, here used for qualitative attributes: Whenever a qualitative attribute is recorded, controlled vocabularies (a list of allowed values for that column) are used. These assure, that the same thing is always called the same (and without typos) and no further data cleaning is necessary before data evaluation. Controlled vocabularies are stored in separate tables. These tables can not be changed by the ordinary user, but only by admins. Deletion in controlled vocabularies are not recorded in the database itself (no soft delete mechanism), here the admin is responsible to keep a backup. In the \__column_definition\_ view those columns are marked in the \__controlled_vocabulary\_ and. Possible entries for those columns can be seen in the \__controlled_vocabularies\_ view.
<details>
<details>
<summary>Example</summary></details>
<summary>Example</summary>
The Accreditation status of measurements are managed by a boolean column with controlled vocabulary used according to the following schema:
The Accreditation status of measurements are managed by a boolean column with controlled vocabulary used according to the following schema:
...
@@ -161,7 +161,7 @@ The Accreditation status of measurements are managed by a boolean column with co
...
@@ -161,7 +161,7 @@ The Accreditation status of measurements are managed by a boolean column with co
-**no, but the values are of high reliability**: false
-**no, but the values are of high reliability**: false
-**no**: Exclude such data from data base
-**no**: Exclude such data from data base
-**unknown**: NULL
-**unknown**: NULL
</details>
- Quality assessment workflow: As described below.
- Quality assessment workflow: As described below.
