State Farm Mutual Automobile Insurance Company

Dhivya Kannan

Taha Kadado

This disclosure describes systems, devices, and techniques for tracking changes to a base record, such as a database. An example method includes identifying a change associated with a first entry in the base record and identifying a time of the change. A corresponding change entry, indicating the first entry and the time of the change in the base record, can be stored in a change record. The change record can be a database that can be queried by external systems to retrieve updated data about changes to the base record. One or more external systems can update derived records by retrieving, from the change record, the latest updated data associated with the source base record within a specified time frame or based on a last retrieved change entry ID. Likewise, one or more external auditing systems can retrieve, from the change record, all applied changes to the source base record.

Growing community of inventors

Frisco, TX, United States of America

Dhivya Kannan