Diversity Collection - Cache DB
Sources from other modules
To provide details from other modules like DiversityTaxonNames,
DiversityAgents, DiversityScientificTerms etc. in the cached data, this
information is transferred into the cache
database together with the data from
DiversityCollection database. Use the 
add button to
add a source for the data you need. The data for the cache database are
provided via views that will be created for you. With the
find button you can list the sources used in the
projects to get a hint of what may be needed. The tables and view for
the sources are placed in the schema dbo in the
SQL-Server cache database and public in the
Postgres cache databases. In case a new
version for the source is available you get a notation like Needs recreation to version 2 . In this case you can either try to update the source with a click on the 
button or
remove the source with a click on the 
button and use the button to recreate the
source. For an introduction see a short tutorial
.
For the inclusion of sources from services like Catalogue of Life see
the chapter Sources from webservices.
Subsets
The sources of some module provide additional subsets to the main data.
To select the subsets that should be transferred to the cache database,
click on the 
button. In the upcoming dialog
(see the example for DiversityTaxonNames below) select those subsets you
want to transfer in addition to the basic list. By default all subsets
are selected.
Transfer
Single manual transfer
To transfer the data of a single source into the
cache
database use the
next button and the 
details button
to inspect the content.
To transfer the data into the Postgres
database, you have to connect with a
database first. Use the next button to transfer the
data from the cache
database into the
Postgres
database. The
button will transfer the data of all
sources in the list into the cache database (see below).
Scheduled transfer
To transfer the data of all sources into the
cache
database and all available
Postgres
databases, use the scheduledtransfer as background process. With this
transfer all available Postgres databases will be included in the data
transfer. These targets are indicated underneath the Postgres block (see
image below).
If the target is placed on the current server, the text will appear in
black as shown below.
Removal
With the button you can remove the sources
together with the views (see above).
Subsections of Sources
Cache Database
Taxonomy
Sources for the taxonomy
To provide the taxonomy with accepted names and synonyms for the
identifications in the cached data, this information is transferred into
the [cache database] together with
the data from the collection database. To add a source from a database
on the local or a a linked server, use the
button. In the appearing dialogs, select the database and the project of
the data. The data for the cache database are provided via views that
will be created. To inspect the data from the views, click on the
button. With the
button you can remove the views (see below). To restrict the data
subsets that are transferred to the cache database, click on the
button. In the upcoming dialog (see below)
select those subsets you want to transfer in addition to the basic name
list.
To transfer the data into the cache
database resp.
[Postgres
database] use the
buttons and the
buttons to inspect the content. To transfer resp. inspect data within
the Postgres database, you have to connect with a database first.
With the buttons you can transfer all
sources in the list from the original source into the
cache
database resp. into the
Postgres
database.
Cache Database
Terms
Sources for the scientific terms
To provide details from DiversityScientificTerms in the cached data,
this information is transferred into the [cache
database] together with the data from
the collection database. Use the button to add a
source for the data you need. The data for the cache database are
provided via views that will be created. To select a source for the
schedule based transfer resp. the transfer with
the buttons, use the
checkbox. To see the protocol of the
transfers, click on the 
button. To transfer all
sources that had been selected use the
button (Source database to cache database)
resp.
button (Cache database to Postgres
database). To inspect the data from the views, click on the
button. With the
button you can remove the views (see below). To transfer the data into
the cache
database resp.
Postgres
database use the
buttons and the
buttons to inspect the content. To transfer resp. inspect data within
the Postgres database, you have to connect with a database first.
Cache Database
Webservices
Sources from webservices
To provide details for datasets linked to webservices like Catalogue ofLife etc. in the cached data, this
information can be transferred into the cache
database together with the data from
the DiversityCollection database. Use the button
to add the webservice you need.
Transfer
To transfer the data of a webservice into the
cache
database use the
button. A window a shown below will open
where you must select all projects that should be checked for data
related to the webservice you selected. Only names found within these
projects will be transferred.
Use the buttons to inspect the
content. Names that are already present will not be transferred again.
So if you need these values to be updated you have to remove it (see
below) and add it again. Links that refer to lists of names instead of
single names will not be inserted. These links will be stored in the
Errorlog to enable their inspection.
To transfer the data into the Postgres
database, you have to connect with a
database first. Use the button to transfer the
data from the cache
database into the
Postgres
database and the
buttons to inspect the content.
Removal
With the button you can remove the sources.
Agents
Sources for the agents
To provide details for the agents in the cached data, this information
is transferred into the cache
database together with the data from
the collection database. Use the add button to add a
source. The data for the cache database are provided via views that will
be created. To inspect the data from the views, click on the
button. With the
button you can remove the views (see below). To restrict the data
subsets that are transferred to the cache database, click on the
button. In the upcoming dialog select those
subsets you want to transfer in addition to the basic name list. To
transfer the data into the cache resp.
Postgres
database use the
buttons and the
buttons to inspect the content. To transfer resp. inspect data within
the Postgres database, you have to connect with a database first.
