System and Method for Re-Synchronizing a Portion of or an Entire Source Database and a Target Database

A database management system, comprising:

• a processor comprising hardware;
• and
• a transient persistent memory storing a database management system software adapted to update a first database with information received via an electronic communications network and
• the memory further storing executable instructions that, when executed by the processor, perform operations comprising:
• a. Storing a source database in a computer system, wherein a plurality of source records of the source database each include a date time stamp of a most recent revision and a unique record identifier, wherein each record identifier is a unique signifier within the source database and a record creation event is a type of record revision;
• b. Storing a target database in a computer memory, wherein the target database receives copies of revisions of the plurality of source records;
• c. Selecting within the target database of a plurality of records to update;
• d. Generating a nonpersistent source work file comprising source compound keys extracted from each current source record of the plurality of source records, and each source compound key extracted from a same source record and including a source information and a most recent source date time stamp of the same source record;
• d. Sorting the source compound keys of the nonpersistent source work file into a nonpersistent source ordered list according to a value sequence of individual source record identifiers of the source records;
• e. Generating a nonpersistent target work file comprising target compound keys extracted from each current target record of the plurality of target records, and each target compound key extracted from a same target record and including a target information and a most recent target date time stamp of the same target record;
• f. Sorting the target compound keys of the nonpersistent target work file into a nonpersistent target ordered list according to the value sequence of individual record identifiers of the target records as applied to order the source ordered list of the source work file;
• g. Comparing the nonpersistent source work file and the nonpersistent target work file to generate a nonpersistent retrieval work file that lists source compound keys not found to be matched in the nonpersistent target work file by a target compound key having a same target record identifier and target date time stamp;
• and
• h. Writing all source records having corresponding source compound keys listed in the nonpersistent retrieval work file into the target database.

A database management system, the database management system bi-directionally communicatively coupled with a computer system that stores a source database, wherein a plurality of source records of the source database each include a date time stamp of a most recent revision and a unique record identifier, and each record identifier is a unique signifier within the source database, the database management system comprising:

• a processor comprising hardware;
• and
• a memory storing a database management system software adapted to update a first database with information received via an electronic communications network and the memory
• further storing executable instructions that, when executed by the processor, perform operations comprising:
• a. Storing a target database in a computer memory, wherein the target database receives copies of revisions of the plurality of source record and stores the revisions of the plurality of source records as target records, and a record creation event is processed as a type of record revision;
• b. Generating a new or truncated nonpersistent temporary table from a prior comparison operation;
• c. Writing at least one key and at least one archive value for each record in the source database into the nonpersistent temporary table;
• d. Comparing all of the keys of active records of the nonpersistent temporary table with a SQL statement to determine which records referenced by the nonpersistent temporary table are missing or marked as archived in the target database table;
• e. Generating a nonpersistent refresh list of the record identifiers of each target database record determined to require an update;
• f. Downloading all records associated with a record identifier of the nonpersistent refresh list from the source database and adding each downloaded record to the target database;
• and
• g. Comparing records in the nonpersistent temporary table and the target database table to determine which records that are marked archived in the nonpersistent temporary table are showing as active in the target database table by checking all active records in the target database table against the list of active records in the nonpersistent temporary table.

A computer-implemented method comprising:

• a. Storing a source database in a computer system, wherein a plurality of source records of the source database each include a source update indicator of a most recent update and a unique record identifier, wherein each record identifier is a unique signifier within the source database and a record creation event is a type of record revision;
• b Storing a target database in a transient, persistent memory, wherein the target database receives copies of revisions of the plurality of source records;
• c. Selecting within the target database of a plurality of records to update;
• d. Generating a nonpersistent source work file comprising source compound keys extracted from each current source record of the plurality of source records, and each source compound key extracted or derived from a same source record and including the source record identifier and the source update indicator of the most recent update of the same source record;
• e. Sorting the source compound keys of the nonpersistent source work file into a nonpersistent source ordered list according to a value sequence of individual source record identifiers of the records from which the compound keys are generated;
• f. Generating a nonpersistent target work file comprising target compound keys extracted from each current target record of the plurality of target records, and each target compound key is extracted from an individual target record and including a target record identifier and a target update indicator of a most recent update of a same target record;
• g. Sorting the target compound keys of the nonpersistent target work file into a nonpersistent target ordered list according to the value sequence of the record identifiers of the target compound keys as applied to order the nonpersistent source ordered list of the nonpersistent source work file;
• h. Comparing the nonpersistent source work file and the nonpersistent target work file to generate a nonpersistent retrieval work file that lists source compound keys not found to be matched in the target work file by a target compound key having a same target record identifier and target update indicator;
• and
• i. Writing all source records having corresponding source compound keys listed in the retrieval work file into the target database.