500049 Video Annotation and Reference System : Dione
This page last changed on Mar 09, 2016 by brian.
About Dione
Dione is a Windows VM that hosts MS SQL 2008 and hosts the external VARS database.
 | Connecting via JDBC When using windows authentication to connect with the jtds JDBC driver don't forget to add 'useNTLMv2=true' in the connection string. See http://jtds.sourceforge.net/faq.html#windowsAuth |
Summary of Data Embargo
The data embargo info used for this iteration is described here. The table below more clearly summarizes what modifications on Dione are requested:
| Concept | Delete KB Branch | Delete KB Media and LinkRealizations | Delete Annotations |
|---|---|---|---|
| Xenoturbellida |  |
|
|
| Xenoturbellidae | |
|
|
| Xenoturbella | |
|
|
| Mystery Mollusc | |
|
|
| Ctenophora | |
||
| Cydippida | |
||
| Cydippida 2 | |
|
|
| Llyria | |
|
|
| Mertensia | |
|
|
| Mertensiidae sp. A | |
|
|
| Platyctenida | |
|
|
| Platyctenida sp. 1 | |
|
|
| Lyroctenidae | |
|
|
| Lyrocteis | |
|
|
| Tjalfiellidae | |
|
|
| Tjalfiella | |
|
|
| Tjalfiella tristoma | |
|
|
| Thalassocalycida | |
||
| Thalassocalycida sp. 1 | |
|
|
| Intacta | |
|
|
| Aegina sp. 1 | |
|
|
| Erenna sp. A | |
|
|
| Erenna sp. B | |
|
|
| Physonectae sp. 1 | |
|
|
| Tuscaroridae | |
|
|
| Tuscarantha | |
|
|
| Tuscarantha luciae | |
|
|
| Tuscarantha braueri | |
|
|
| Tuscaretta | |
|
|
| Tuscaretta globosa | |
|
|
| Tuscaridium | |
|
|
| Tuscaridium cygneum | |
|
|
| Tuscarilla | |
|
|
| Tuscarilla nationalis | |
|
|
| Tuscarilla similis | |
|
|
| Tuscarilla campanella | |
|
|
| Tuscarora | |
|
Additional Annotations to delete
- Bob Vrijenhoek or Clague's annotations of Xenophyophoroidea, Psamminidae, Psamminida
- Robison, Sherock, Raskoff, Zeidberg, Hopcroft, Hunt or Hamners's annotations with a cameradirection of transect, diel transect, startransect or endtransect.
Embargo SQL
The data in these databases are replicated monthly and the following scripts are applied after replication:
- Knowledgebase
- Annotation
The SQL has been updated on both the develop and videofile-jdk8 branshes
About VARS replication to DIONE
From Neil Conner:
Okay, Brian, it's all ready to go. This is a two-step process:
- I created permanent backup devices (fixed files) on a network share for the VARS and VARS_KB databases on both Equinox and Dione.
- On Equinox, I created a new maintenance plan called "VARS_Export Backups" which writes a full backup of VARS and VARS_KB to the respective backup device and scheduled it to run the first Monday of each month at 3:00am.
- On Dione, I created a SQL Agent job for the VARS database called "VARS_Export Restore from Equinox" and one for VARS_KB called "VARS_KB_Export Restore from Equinox". Both jobs run the first Monday of each month at 5:00am.
- The VARS job has the following four steps: 1) does a restore from whatever happens to be in the respective backup device, 2) deletes unnecessary user accounts, 3) runs the embargo script and 4) updates the URLs; the VARS_KB job has only the first two steps. Both jobs create a log file on Dione and send me an email on failure.
