A computer program comprising instructions which, when executed by a computer, cause the computer to perform operations comprising: Performing a transaction on a first table, the first table including database data, wherein performing the transaction includes creating a second table corresponding to a new version of the first table, the second table being a separate table from the first table; after the transaction is completed, based at least in part on the second table created as the separate table, generating a change tracking entry, the change tracking entry including an indication of at least one modification made to the first table by executing the transaction; Advancing a change tracking stream at least in part by entering the generated change tracking entry into the change tracking stream, wherein advancing the change tracking stream comprises advancing a stream offset and a retention limit in the change tracking stream, the stream offset corresponding to a first position in the change tracking stream and the retention limit corresponding to a second position im Change tracking stream, the change tracking stream containing a series of committed transactions; and in response to a trigger event including advancing the change tracking stream, automatically performing a predefined task on the second table and generating a task history entry indicating that the task was successfully completed.
展开▼
