search

marcardar / transcriptstudio-isha

Automatically exported from code.google.com/p/transcriptstudio4isha
0 stars 0 forks source link

Database content validation #134

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
It would be good to periodically run some validation over all the data in
the database. For example:

1. ids are unique (within its domain)
2. id refs are non-blank and point to valid ids:
  a) event/@type
  b) session/@eventId
  c) markup category id refs
  d) device/@id (first, we need to create a section in reference.xml for this)
3. reference.xml validation
  a) check consistency of concept hierarchy (no cycles)
  b) check synonyms consistent with hierarchy (a subtype should probably
not also be a synonym of the same concept)
* Sessions with no parent event (i.e. no eventId or eventId does not point
to a valid event)

probably a lot more...

Original issue reported on code.google.com by mjc1...@gmail.com on 14 Apr 2009 at 7:13