IEM Database (in) consistency

(imported topic written by JesperLarsen)


I was wondering… BigFIX has as a design decision decided to not implement any foreign keys in the IEM database to optimize for speed. This is a valid decision, but it opens up for issues with data integrity, as data integrity then has to be managed explicitly. Furthermore, in debugging / error situations, it is pretty hard to determine if data in the DB is actually in an inconsistent state or not.

So, I am wondering if a tool or schema or something is available for doing actual database integrity verification?