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!