CPC G06F 16/2282 (2019.01) [G06F 16/2358 (2019.01); G06F 16/24568 (2019.01)] | 12 Claims |
1. A method comprising:
providing a primary table storing a set of data in a plurality of partitions;
executing modifications to the primary table to delete a first partition of the plurality of partitions and to add a new partition representing a change to the first partition based on the modifications;
generating a system table storing delta information related to the modifications to the primary table in a different format than the primary table;
defining a retention boundary for the set of data stored in the primary table;
deleting data past the retention boundary in the primary table;
storing, in the system table, delta information related to modifications executed past the retention boundary; and
generating change data capture information including a virtual table with one or more pointers to the system table for delta information related to modifications past the retention boundary and one or more pointers to the primary table for data before the retention boundary.
|