I am looking for a database solution which do not delete the previous entry when updating a value. I want to be able to mark some tables as permanent so they keep all changes and such that i can query it for data later and get the audit trail.
As far as I know HBase does this, no items are deleted when you mark it as deleted, http://hadoop-hbase.blogspot.no/2011/12/deletion-in-hbase.html
Any recommendations for NoSql/database system which does this?