Patent ID: 9128974
Filing Date: 2015-09-08
Classification: G06F

Abstract:
1. A method for tracking database changes, the method comprising: adding, by a database change tracking computing device, to a schema of at least one table of a database, a first column comprising a row update identifier for at least one row of the database table, wherein a global update identifier is incremented in response to a change to the row and the incremented value of the global update identifier is recorded as the row update identifier for the row in response to the change; generating, by the database change tracking computing device, in response to a latest database synchronization event, a reference table comprising a synchronization update identifier, wherein the global update identifier is incremented in response to the latest database synchronization event and the incremented value of the global update identifier is recorded as the synchronization update identifier in response to the latest database synchronization event; tracking, by the database change tracking computing device, an update to the row, based at least upon determining that the row update identifier is greater than the synchronization update identifier in the reference table; and providing, by the database change tracking computing device, at least a portion of the database subsequent to the update.