Patent ID: 8370303

Claim:
A non-transitory computer-readable medium embodying a program executable in a computing device, the program comprising: code that identifies a portion of changed records in a first electronic commerce transaction table of a master transaction data store; code that identifies a portion of changed records in a second electronic commerce transaction table of the master transaction data store; code that creates a first snapshot working table which contains the portion of changed records from the first electronic commerce transaction table; code that creates a second snapshot working table which contains the portion of changed records from the second electronic commerce transaction table; code that determines a first plurality of identifiers present in the second snapshot working table but not present in the first snapshot working table and fetches from the second master table a row corresponding to each of the first plurality of identifiers, and stores in the first snapshot table the row from the second master table corresponding to the first plurality of identifiers; and code that determines a second plurality of identifiers present in the first snapshot working table but not present in the second snapshot working table and fetches from the first master table a row corresponding to each of the second plurality of identifiers, and stores in the second snapshot working table the row from the first master table corresponding to the second plurality of identifiers.