US 12,443,617 B1
Systems and methods for recording and updating data in a database
Agust K. Gudmundsson, Castle Rock, CO (US); Sheikbharith Liakathali, Frisco, TX (US); and John Nield Hankins, Philadelphia, PA (US)
Assigned to Verizon Patent and Licensing Inc., Basking Ridge, NJ (US)
Filed by VERIZON PATENT AND LICENSING INC., Basking Ridge, NJ (US)
Filed on May 30, 2024, as Appl. No. 18/677,980.
Int. Cl. G06F 7/00 (2006.01); G06F 16/25 (2019.01)
CPC G06F 16/254 (2019.01) 20 Claims
OG exemplary drawing
 
1. A method comprising:
initiating a job via a state machine, the job being a data structure that comprises job information related to a source of data, a job identifier (ID), a batch ID and destination location;
extracting, from a data source corresponding to the source of the data, data related to the job, the job data corresponding to the job ID and the batch ID;
inserting, based on the extraction of the job data, records from the data source into a records table, the records table further comprising the batch ID;
transforming the records within the records table into a format associated with a data store corresponding to the destination location; and
loading the transformed records into the data store of the destination location.