UNIT OF WORK BASED INCREMENTAL DATA PROCESSING

摘要

Systems, methods, and other embodiments associated with a unit of work for incremental data processing are described. In one embodiment, a method includes selecting a unit of work key for a program that processes records in a source table. The unit of work key is selected such that modifications to a record having a certain unit of work key value will not affect the program's processing of records having a different unit of work key value. The selected unit of work key is associated with the program. When a record in the source table is created, modified, or deleted, a unit of work key value is identified for the record and a selected set of records having the identified unit of work key value is provided to the program. Thus, records in the data source that do not have the identified unit of work key values are not provided to the program.

主权项

1. A non-transitory computer storage medium storing computer-executable instructions comprising instructions for:
identifying a unit of work key that is predefined for a program, where the program processes data from a data source; determining a unique set of unit of work key values for records in the data source that have been created, modified, or deleted since a last time the program was executed; selecting a set of records from the data source that have the unit of work key values; and providing the selected set of records to the program such that records in the data source that do not have the identified unit of work key values are not provided to the program.