Automated versioning of configuration tables with rollback

US12141170B1 · kind B1 · utility

Assignee

• SAP SE · DE

Inventors

• Wulf Kruempelmann · Altlußheim, DE
• Susanne Schott · Mannheim, DE

Key dates

• Filing date: Sep 19, 2023
• Grant date: Nov 12, 2024
• Expiry date: Sep 19, 2043

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F16/2282
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

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.