An other strategy for historisation is to have an external process create a "snapshot" of your tables' content regularly. For instance, table T would be copied every night to T_archives, with the same structure plus a timestamp field.

This is usually easier to work with, as the archives contain everything needed, but can be inefficient on large tables that rarely change.