On a Cloud: Data Storage Techniques

Data Audit History

There have been several times when I needed to ensure that we could understand the changes of data overtime. This is inline with the idea of never deleting data; however, in keeping a full audit history you can more deeply understand user behaviors. Or, if you need to have data retention for legal issues, this is also a pattern that could make sense.



Data Store Identifiers: GUID

Over ten years ago now, I moved from auto-increment integers to GUID’s; and I have never looked back. There are a number of reasons why I feel that it is much easier for computers systems and humans to use GUID’s to identify tuples; check it out!


Connect with me on GitHub; or ask me questions on Twitter.