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.

Document generated by Confluence on Feb 03, 2026 12:59