Self-archiving database

A computer-implemented method for a self-archiving database, in a database system, wherein a storage memory stores the transaction database, comprising:

• providing, in the storage memory, archive table data that specifies, for a transaction database, archive parameters which indicate a pre-defined archive time period based on which a periodic archive procedure is performed and purge parameters which indicate a pre-defined purge time period based on which a periodic purge procedure is performed;
• based on the archive parameters indicating that a next time period for archive is reached, by the database system:
• creating, in the transaction database, by the database system using a database partition feature, a new partition which is used as a live partition into which the database stores transaction records which are new;
• performing, by the database system, a partition move, using the database partition feature, to the archive database, a transaction database partition which determined to be expired, wherein the transaction records in the expired transaction database partition become members of a newest archive database partition of the archive database;
• and
• based on the purge parameters indicating that a next time period for purging is reached, by the database system:
• removing, by the database system, using the database partition feature, from the archive database, an archive database partition which is determined to be expired, wherein data is deleted as a whole from the archive database based on the archive database partition being removed.