| CPC G06F 16/284 (2019.01) [G06F 16/219 (2019.01); G06F 16/2282 (2019.01)] | 20 Claims |
|
1. A system, comprising:
at least one data processor; and
at least one memory storing instructions, which when executed by the at least one data processor, result in operations comprising:
retrieving a database table comprising a dataset including key fields and data fields;
extending the database table by adding a new key field to each row of the database table, wherein the new key field includes a version number and a data block identifier;
generating a view of the database table, wherein the view is a relation defined in terms of stored base tables;
initializing the view of the database table by setting a current version number to zero;
defining one or more triggering components for simulating a versioned database, wherein the one or more triggering components 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; and
simulating the versioned database using the one or more triggering components, including executing a first instead-of trigger for updating data in the dataset, via the view, by:
incrementing each version number in a dataset by one,
adding a new version number zero to the dataset, and
inserting new data to the database table.
|