Good evening,

I am working on a project where the requirement is to trace all versions of a given table row. Hmm...There are some documents at eurocontrol.int and an xml schema that defines the data exchange model. Every table has meta data recording the data of creation, last edit, date start, and date end for data validity. Has anyone done such modelling? Are there any open source implementations of such a model?

Sincerely,

Donaghy

If you are looking for a trace you will only be performing inserts, no updates, even if you have an update date column it will be recording the insert date of a new row.