Selective data synchronization and transfer to remote distributed database servers
A method for resolving the synchronization of identity data from a central database server to distributed database servers is provided. The method involves synchronizing identity data to central and distributed database servers based on identity data types associated with a factory. The method first includes assigning by a configuration manager identity data types to factories which manufacture devices that will need identity data. Next an Identity Data (ID) Loader receives a file containing the identity data, and the ID Loader loads the identity data to a central database server and creates a file history record indicating a record of the file loaded. Next, a Factory Synchronizer Loader (FSL) is triggered to create and execute jobs to load identity data, configuration data or other data. Finally, the identity data is synchronized between the central data base with the remote database servers in a location of the factory. In some embodiments, the FSL corrects identity data and resynchronizes, or determines when synchronization fails and repeats synchronization processes when the failure occurs.
1. A method for resolving the synchronization of identity data from a central database server to distributed database servers comprising:
assigning by a configuration manager identity data types to factories which manufacture devices that will need identity data for secure identification;
receiving by an Identity Data (ID) Loader a file containing the identity data, the ID Loader loading the identity data to the central database server and creating in the central database server a file history record indicating a record of the file loaded, wherein the central database server is located at a data distribution center separate from factories where the remote distributed database servers are located and is more stable to maintain the identify data than the remote distributed database servers, wherein further access to the file containing the identity data outside the central database server to obtain identity data is no longer required;
triggering a Factory Synchronizer Loader (FSL) to create at least one identity data loading job based on an event table, wherein the identity data loading job comprises:
(a) determining the record associated with an ID of the file;
(b) determining an identify data type associated with the record; and
(c) determining a factory location associated with the data type from the configuration table;
(d) based on the information from (a)-(c) creating the load data job;
executing by the FSL the pending load data job by loading the identity data only to a selected one of a plurality of primary remote ones of the distributed database servers located in one of the factories so that the selected remote one of the distributed database servers has identity data different than remaining ones of the plurality of primary remote ones of the distributed database servers; and
synchronizing the identity data in the central data base server individually with the selected remote one of the distributed database servers in the location of one of the factories.
2. The method of claim 1 , further comprising synchronizing configuration data in the central database server with the remote database server.
3. The method of claim 1 , further comprising:
identifying that the identity data provided to the selected remote database server is incorrect;
correcting the incorrect identify data in the central database server; and
synchronizing changes in the corrected identity data individually with the selected remote database server.
4. The method of claim 1 , further comprising synching the identity data of a device to a factory where the device is built.
5. The method of claim 1 , wherein in the step of executing by the FSL the pending load data job, if the jobs fails, the FSL will continue on to a next job and retry the failed job later.
6. The method of claim 1 , wherein in the step of executing by the FSL the pending load data job, once the FSL executes the load data job, updating a job status to completed.