US 11,704,302 B2
Method, system and apparatus for processing database updates
Christina S. Lee, Toronto (CA); Robert Cotran, Montreal (CA); Robert Shek, Toronto (CA); and Thomas Andrew Currier, Toronto (CA)
Assigned to PERRY + CURRIER INC., Toronto (CA)
Appl. No. 16/637,338
Filed by PERRY + CURRIER INC., Toronto (CA)
PCT Filed Aug. 8, 2018, PCT No. PCT/IB2018/055981
§ 371(c)(1), (2) Date Feb. 7, 2020,
PCT Pub. No. WO2019/030698, PCT Pub. Date Feb. 14, 2019.
Claims priority of provisional application 62/542,465, filed on Aug. 8, 2017.
Prior Publication US 2021/0133179 A1, May 6, 2021
Int. Cl. G06F 7/00 (2006.01); G06F 17/00 (2019.01); G06F 16/23 (2019.01); G06F 16/21 (2019.01); G06F 16/245 (2019.01); G06F 9/48 (2006.01)
CPC G06F 16/2379 (2019.01) [G06F 9/4881 (2013.01); G06F 16/21 (2019.01); G06F 16/245 (2019.01)] 12 Claims
OG exemplary drawing
 
1. A method comprising:
storing, at a job processing server, (i) a job queue including a plurality of job records previously created by the job processing server, each job record having corresponding job parameters, and (ii) a plurality of job initiation criteria and corresponding job parameter definitions;
detecting job initiation data comprising a database update to a primary database hosted by a second server and distinct from the job queue, the database update matching at least one of the job initiation criteria;
responsive to detecting the job initiation data, retrieving new job parameters at the job processing server from the primary database based on the job parameter definitions corresponding to the at least one job initiation criterion;
creating, at the job processing server, a new job record including the new job parameters, and storing the new job record in the job queue; and
responsive to detecting expiry of a predefined trigger time, processing the plurality of job records and the new job record in the job queue, by:
for each job record in the job queue, generating and sending instructions, based on the corresponding job parameters, for execution by the second server to perform an update to the primary database;
receiving a status indicator from the second server, the status indicator indicating a status of the update;
responsive to receiving the status indicator, removing the job record from the job queue.