[EP-tech] Traceability of record changes

martin.braendle at id.uzh.ch martin.braendle at id.uzh.ch
Mon Jan 11 11:26:05 GMT 2016



Hi,

and a happy and successful 2016!

If one wants to find all eprints for which a given field X has changed its
value from A to B, this seems to be quite cumbersome, because the history
table only stores the name of the fields that have been modified, but not
their content, which is saved in the revisions XML files in the documents
directory.

- Is there already a method or script that enables one to do so?
- Why has this been designed this way, and not the way that all changes
(which field and which content) are tracked in the SQL database? Whether
disk space is used up by the database or in the filesystem should not
matter. Having the changes only in the database would facilitate searching
a lot; in addition, rollbacks to a given point would be possible.

Best regards,

Martin

--
Dr. Martin Brändle
Zentrale Informatik
Universität Zürich
Stampfenbachstr. 73
CH-8006 Zürich

mail: martin.braendle at id.uzh.ch
phone: +41 44 63 56705
fax: +41 44 63 54505
http://www.zi.uzh.ch
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20160111/ef6d95cb/attachment.html 


More information about the Eprints-tech mailing list