Method of integrating remote databases by automated client scoping of update requests prior to download via a communications network

摘要

A system and method enable the selection of a time range, or other record selection criteria, of database records for upload from a local database source and for transfer to a remote database. A specifically bounded time period is selected to limit the number of data records selected for upload in a particular action to those records that are individually associated with date time stamp values falling within the specified time period. This limitation of records selected for inclusion in an upload process to data records having associations with date time stamps falling within a limited time range, or other criteria, reduces a likelihood of overload in transferring data and thereby reduces the incidence of time-outs in the communication of a local database, any intermediary server or software action, and the remote database in an updating of the recipient database to reflect a current state of the local database. A plurality of asynchronous threads may be employed to contemporaneously upload records associated with date time stamps having values within a requested time range whereby data records may be uploaded in parallel.

主权项

1. A computer implemented method comprising:
a. A DBMS selecting a plurality of records for upload to a second DBMS; b. Writing a key of each selected record into a key array; c. Determining a maximum array key count Kmax; d. Calculating the count of keys of the ordered array Kcount; e. Determining if the Kmax>Kcount; and f. If the Kmax>Kcount, uploading the selected records in a single sequential upload to the second DBMS.