I am considering various ways of storing deltas on objects for long periods of time (30 years would be a common case). One option is for one delta table to save changes for each object. Since the delta needs to be stored for such a long time, the delta table will grow very large, so I considered options for at least a couple of them, without saving each delta as a row.
The delta table will primarily store the primitives from .NET ( int , long , decimal , string , etc.). The delta table will look something like this:
| RowIdentifier | FieldIdentifier | NewValue | Timestamp |
Are protocol buffers (protobuf-net or some other protobuffs) suitable for such long-term storage?
source share