search

NeotomaDB / DwC-Mapping

A document explaining how we will map Neotoma against the DarwinCore Schema
MIT License
0 stars 0 forks source link

Clarify in the document the triggers for export. #6

Open SimonGoring opened 8 years ago

SimonGoring commented 8 years ago

The trigger will be -

  1. Upload to Neotoma (after a 24h delay) - part of an existing stored procedure

Depending on how the data goes to GBIF, what do we do on data modification?

What happens then? Can we just completely clear out the old GBIF data & re-upload at the dataset level? (probably the best option, because of all the concatenated strings in the data tables)

  1. Set up triggers on the database itself to watch fields. What fields (or tables) do we watch?
    • Data (obviously, if data values change)
    • Taxa (if a taxon changes)
    • ???
  2. Add the change within other existing stored procedures (of Eric's)
SimonGoring commented 8 years ago

Thoughts @spatialit @IceAgeEcologist ?