Invention Grant
- Patent Title: Methods for tracking database changes and devices thereof
- Patent Title (中): 跟踪数据库更改的方法及其设备
-
Application No.: US13542792Application Date: 2012-07-06
-
Publication No.: US09128974B2Publication Date: 2015-09-08
- Inventor: Ananth Prasad Konagolli Suresh , Vikrant Raghu , Renji Kuruvilla Thomas
- Applicant: Ananth Prasad Konagolli Suresh , Vikrant Raghu , Renji Kuruvilla Thomas
- Applicant Address: IN Bangalore
- Assignee: Infosys Limited
- Current Assignee: Infosys Limited
- Current Assignee Address: IN Bangalore
- Agency: LeClairRyan, a Professional Corporation
- Priority: IN2450/CHE/2011 20110719
- Main IPC: G06F17/00
- IPC: G06F17/00 ; G06F7/00 ; G06F17/30

Abstract:
Methods, devices, and computer-readable storage media for tracking changes in a database including at least one database table include adding a first column to a schema of each database table. The first column includes a row update identifier for each row of the database table. A global update identifier is incremented in response to a row change and recorded as the row update identifier for the changed row. In response to a latest database synchronization event, a reference table including a synchronization update identifier is generated, and the global update identifier is incremented and recorded as the synchronization update identifier. An update to a row in a database table is tracked based at least upon determining that a row update identifier of the updated row in the database table is greater than the synchronization update identifier in the reference table.
Public/Granted literature
- US20130024422A1 METHODS FOR TRACKING DATABASE CHANGES AND DEVICES THEREOF Public/Granted day:2013-01-24
Information query