Requirement | Current Only | Functional History | Row-Level Audit | Column-Level Audit | Ledger |
Application only wishes to see current active values for all functional tasks against data store. | X | ||||
Normal application tasks will require access to data valid at specific and varying points-in-time. | X | ||||
Application only wishes to see current values, but auditors need to be able to see every change. | X | X | |||
Application only wishes to see current values, but users want to browse through changes made to specific columns. | X | X | |||
Critical data is numeric and must always be able to know about every change impacting figures. | X | ||||
Normal application tasks will require access to data valid at specific and varying points-in-time for a subset of data. Auditors will need to be able to see every change made. | X | X | |||
Normal application tasks will require access to data valid at specific and varying points-in-time for a subset of data. Users want to browse through changes made to specific columns. Auditors will need to be able to see every change made. | X | X | X |
Table 1: Considerations in choosing a structure.