GoldSystem
GoldSystem for Lookups and TaxonWizards Base List
To allow a maximum of quality all lookup data are equipped with a special flag named gold.
If this flag is set to true, it means that an entry has been marked as correct by the data administrator.
This is especially important for taxa that enter the system through a data ingest. It can no longer happen that data
gets into the system unnoticed.
More about this in the TaxonWizard section.
On the additional percentage displays, the ratio of records marked with gold to those not marked with
gold is
visualized.
It is also possible to display, check and mark as gold only the records that have not yet reached gold
status, if the
quality is positively checked.
Lookup equality
The definition of equality in lookups needs to be explained again briefly.
A lookup entry always consists of two parts:
The key can be a name (e.g. for person the abbreviation name: mmustermann
) and the
attributes describe a lookup entry more precisely (e.g.
full_name: Max Mustermann
).
The key is always uniq for all entries in a Lookup table.
Now, three scenarios can arise during a lookup import into the database:
- Lookup with equal key is in Db and all attributes are equal
- Lookup with equal key is in Db and not all attributes are equal
- Lookup Lookup with equal key is not in Db
In the first case, nothing would have to be done.
In the second case, the entry in the database could be updated.
In the last case, the new entry would be created in the database.
Furthermore, the import of lookup files regarding the gold status is interesting.
There are three possibilities to granulate the import.
Import mode from EXCEL file (only gold, only not gold, all)
Which data sets from the import file should be used. Data sets that are marked as gold in the file (only gold),
only those that do not have gold status (only not gold) or all of them (all).
Write mode in database (only create new, only update existing, create and update existing)
Furthermore, the mode in which the imported data should be processed in the database can be specified.
It can be selected whether only data can be created in the database, which do not yet exist there (only createnew).
Or only already existing data can be renewed or adapted (only update existing), or both (create and update existing).
Update mode in database (only matching not gold, only matching gold, all matching)
The update mode of records already found in the database can also be set.
The following rule applies: Only gold marked records from the Excel table may change gold marked records in
the database.
Basically: gold may change everything, not gold only not gold.
Here we restrict this fact a little bit.
On the one hand only already existing records in the database may be changed, which do not have gold status
(only
matching not gold).
On the other hand only already existing records, which have gold status (only matching gold) or
all existing data
(all matching).
Always remember the rule: gold may be changed always only from gold.
So in the following example all lookup entries would be imported (all).
New database entries would be made and existing entries would be modified (create and update existing).
But only corresponding existing entries in the database will be changed, which do not have gold status (only matching
not gold).
This means that the entries already marked as gold in the database would be protected from changes by the ingest.