US 12,306,820 B1
System and method for duplicating structured data in database
Peter Gassner, Pleasanton, CA (US); Jonathan Stone, Olympia, WA (US); Andrew Han, Needham, MA (US); and Brian Keith Caufield, Livermore, CA (US)
Assigned to Veeva Systems Inc., Pleasanton, CA (US)
Filed by Veeva Systems Inc., Pleasanton, CA (US)
Filed on Jul. 25, 2023, as Appl. No. 18/358,546.
Claims priority of provisional application 63/429,979, filed on Dec. 2, 2022.
Int. Cl. G06F 16/00 (2019.01); G06F 16/23 (2019.01)
CPC G06F 16/235 (2019.01) [G06F 16/2358 (2019.01)] 22 Claims
OG exemplary drawing
 
1. A computer-implemented method for duplicating data including a first data object and a second data object from a data management system, wherein the data management system comprises a first repository, a second repository and a data duplication controller, the method comprising:
writing data changes to a log table for collecting the data changes in the data management system;
extracting data changes by a data extractor in the data duplication controller;
running a data flattener in the data duplication controller to generate flattened data for the extracted data changes, and creating a first flat file and a second flat file for the flattened data for the extracted data changes, wherein the first flat file is for a first extract of the first data object in the document management system, wherein the first flat file includes data of the first data object but not the second data object, wherein the second flat file is for a second extract of the second data object in the document management system, and wherein the second flat file includes data of the second data object but not the first data object;
receiving the first and second flat files from the data flattener at a first predetermined time interval, and creating a first data change file to package the first flat file and the second flat file for the flattened data for the extracted data changes by a packaging controller in the data duplication controller; and
presenting the first data change file with a listing application programming interface (API) in the data duplication controller to enable access to the data change file.