US 10,853,349 B2 · Event based analytics database synchronization

Abstract

Event based analytics database synchronization is described. In one example, an event tracking engine can sequence through batches of records in a transactional database that is being synchronized to an analytics database. The event tracking engine can determine a last version attribute associated with the batch, and query the transactional database to identify any records for the batch having a more recent version attribute than the last version attribute. When any records in the transactional database having a more recent version attribute are identified, the event tracking engine finds the data values in the record are different than those in the analytics database. The data values can be normalized, for example, before being forwarded to an analytics system for incorporation into the a analytics database. Over time, changes in the transactional database are identified and populated or mirrored in the analytics database.

Claims20

Dependent claims

A method for event based synchronization of data between databases, comprising:

enrolling a plurality of devices with a management service, the management service remotely configuring operating systems of the client devices to register and configure the client devices for device management;
sequencing, with reference to a tracking table, to a batch of records in a transactional database, the batch of records comprising a plurality of records corresponding to the plurality of devices;
determining, with reference to the tracking table, a last version attribute associated with data synchronization for the batch;
querying the transactional database to identify at least one record of the batch having a more recent version attribute than the last version attribute;
comparing data in an analytics database to data in the at least one record to find at least one value to synchronize from the transactional database to the analytics database;
and
forwarding the at least one value to an analytics computing system for incorporation into an analytics database.

4 more elements

A non-transitory computer-readable medium embodying program code executable in at least one computing device for event based synchronization of data between databases that, when executed by the at least one computing device, directs the at least one computing device to at least:

enroll a plurality of devices with a management service, the management service remotely configuring operating systems of the client devices to register and configure the client devices for device management;
sequence to a batch of records in a transactional database, the batch of records comprising a plurality of records corresponding to the plurality of devices;
determine a last version attribute associated with data synchronization for the batch;
query the transactional database to identify at least one record of the batch having a more recent version attribute than the last version attribute;
compare data in an analytics database to data in the at least one record to find at least one value to synchronize from the transactional database to the analytics database;
and
forward the at least one value for incorporation into an analytics database.

4 more elements

A system for event based synchronization of data between databases, comprising:

a memory device configured to store computer-readable instructions thereon;
and
at least one processing device configured, through execution of the computer-readable instructions, to at least:
enroll a plurality of devices with a management service, the management service remotely configuring operating systems of the client devices to register and configure the client devices for device management;
sequence to a batch of records in a transactional database, the batch of records comprising a plurality of records corresponding to the plurality of devices;
determine a last version attribute associated with data synchronization for the batch;
query the transactional database to identify at least one record for the batch having a more recent version attribute than the last version attribute;
compare data in an analytics database to data in the at least one record to find at least one value to synchronize from the transactional database to the analytics database;
and
forward the at least one value for incorporation into an analytics database.

7 more elements

Dependencies are inferred from the claim text.

Event based analytics database synchronization

Life of this patent

Event based analytics database synchronization

Life of this patent

Abstract

Claims20