EPrints Technical Mailing List Archive

Message: #05307

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

[EP-tech] Traceability of record changes

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@id.uzh.ch
phone: +41 44 63 56705
fax: +41 44 63 54505
http://www.zi.uzh.ch