US 11,055,276 B2
Tracking change data in a database
Charles W. Caro, Apex, NC (US); Sriram Balasubramanian, San Jose, CA (US); and Stephen Peter Ball, Bagshot (GB)
Assigned to Embarcadero Technologies, Inc., Austin, TX (US)
Filed by Embarcadero Technologies, Inc., Austin, TX (US)
Filed on Aug. 21, 2019, as Appl. No. 16/547,441.
Application 16/547,441 is a continuation of application No. 14/823,884, filed on Aug. 11, 2015, granted, now 10,430,403.
Claims priority of provisional application 62/039,824, filed on Aug. 20, 2014.
Prior Publication US 2019/0377723 A1, Dec. 12, 2019
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/00 (2019.01); G06F 16/23 (2019.01); G06F 16/21 (2019.01)
CPC G06F 16/2365 (2019.01) [G06F 16/219 (2019.01)] 20 Claims
OG exemplary drawing
1. A method for tracking change data, said method comprising:
changing data in at least one field of a plurality of data in a database at a computer system, wherein said plurality of data is comprised within a base table of said database, said base table comprising an original state of said plurality of data, wherein said changing said data changes a record header for said at least one field within a change data table of said database, wherein said change data table comprises changes made to said base table, wherein said record header is collocated within said base table and said change data table;
creating a flag in said record header of said data signaling said change to said at least one field within said change data table; and
linking successive versions of said database together such that a subscriber accessing said database can automatically view a current version of said database with said change by accessing said record header of said data and identifying said flag within said record header of said data.