Automated versioning of configuration tables with rollback

Abstract

Arrangements for automated versioning of configuration tables with the ability of automated rollback are provided. A database table having key fields and data fields may be retrieved. The table may be extended by adding a new key field to each row of the database table. The new key field may include a version number and a data block identifier. A view of the table may be generated and initialized by setting a current version number to zero. One or more triggering components for simulating a versioned database may be defined. The one or more triggering components may include one or more instead-of triggers used to insert, update, or delete from the database table upon an insert, update, or delete operation on the view. The versioned database may be simulated using the one or more triggering components, including an instead-of-insert trigger, an instead-of-update trigger, and/or an instead-of-delete trigger.