Can Fit Criteria
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.

Back to Article