Christian Zentgraf

US Patent:

20200175034, Jun 4, 2020

Filed:

Dec 3, 2018

Appl. No.:

16/208538

Inventors:

- Armonk NY, US
Austin D'costa - Beaverton OR, US
Roger Zheng - Richmond Hill, CA
Christian Zentgraf - Columbus OH, US
David Mooney - Toronto, CA

International Classification:

G06F 16/27
G06F 16/2453
G06F 16/2455
G06F 16/23

Abstract:

A method, system and computer program product is provided. The method includes identifying a large statement, writing the rows that are changed by the large statement into a set of files outside a database management system recovery log, and writing log records for the set of files to the database management system recovery log, such that the log records provide ordering of row changes made by the large statement. The log records include a log sequence number corresponding to a first row changed and a format and encoding used for the row changes. The method further includes streaming, by the one or more processors of the computer system, the set of files out-of-band by a replication capture process to a target database management system.

US Patent:

20180203913, Jul 19, 2018

Filed:

Jan 19, 2017

Appl. No.:

15/410276

Inventors:

- Armonk NY, US
Austin F. M. D'Costa - Beaverton OR, US
Xiao Li - San Jose CA, US
Jonathan W. Wierenga - Petone, NZ
Xin Wu - Beijing, CN
Christian Zentgraf - Columbus OH, US
Xiang W. Zhou - Shanghai, CN

International Classification:

G06F 17/30

Abstract:

Several replication subscriptions are defined for a table in a database management system. The table is divided into partitions. Each replication subscription replicates transactions to a range of partitions. Subscriptions are assignable to different consistency groups. Transaction consistency is preserved at the consistency group level. A persistent delay table is created for each of several apply functions. Each apply function processes replication subscriptions for one consistency group, to replicate the table to a target table in parallel. Transactions for a given range of a partition are executed in parallel. When an apply function upon a row of the target table results in an error, the row is stored in the delay table. Application of each row in the delay table is repeatedly retried, and if successful, the row is removed from the delay table.

US Patent:

20180113766, Apr 26, 2018

Filed:

Dec 21, 2017

Appl. No.:

15/851336

Inventors:

- Armonk NY, US
Austin F.M. D'Costa - Beaverton OR, US
Yat On Lau - San Jose CA, US
Xiao Li - San Jose CA, US
Hong Min - Poughkeepsie NY, US
Gong Su - New York NY, US
Jonathan W. Wierenga - Lower Hutt, NZ
Christian Zentgraf - Columbus OH, US

International Classification:

G06F 11/14
G06F 17/30

Abstract:

Provided are techniques for replicating relational transactional log data to a big data platform. Change records contained in change data tables are fetched. A relational change history with transaction snapshot consistency is rebuilt to generate consistent change records by joining the change data tables and a unit of work table based on a commit sequence identifier. The consistent change records are stored on the big data platform, and queries are answered on the big data platform using the consistent change records.

US Patent:

20180113771, Apr 26, 2018

Filed:

Dec 21, 2017

Appl. No.:

15/850454

Inventors:

- Armonk NY, US
Austin F.M. D'Costa - Beaverton OR, US
Yat On Lau - San Jose CA, US
Xiao Li - San Jose CA, US
Hong Min - Poughkeepsie NY, US
Gong Su - New York NY, US
Jonathan W. Wierenga - Lower Hutt, NZ
Christian Zentgraf - Columbus OH, US
Kan Zhang - Palo Alto CA, US

International Classification:

G06F 11/14
G06F 17/30

Abstract:

Provided are techniques for transaction consistency query support for replicated data from recovery log to external data stores. An external data store is populated with records using entries of a change data table. The change data table has entries for each transaction that has committed and is to be replicated, and each of the entries stores information for each log entry in a recovery log from a database management system. Each log entry identifies a transactional change of data and a transaction completion indicator of one of commit and abort. In response to receiving a query about a transaction of the transactions, a set of records are retrieved from the external data store for the transaction. From the set of records, records whose sequence identifier values are larger than a maximum transaction commit sequence identifier are removed. From the set of records, remaining records having transaction consistency are returned.

US Patent:

20180046551, Feb 15, 2018

Filed:

Aug 15, 2016

Appl. No.:

15/237407

Inventors:

- Armonk NY, US
Austin F.M. D'Costa - Beaverton OR, US
Yat On Lau - San Jose CA, US
Xiao Li - San Jose CA, US
Hong Min - Poughkeepsie NY, US
Gong Su - New York NY, US
Jonathan W. Wierenga - Lower Hutt, NZ
Christian Zentgraf - Columbus OH, US

International Classification:

G06F 11/14
G06F 17/30

Abstract:

Provided are techniques for replicating relational transactional log data to a big data platform. Change records contained in change data tables are fetched. A relational change history with transaction snapshot consistency is rebuilt to generate consistent change records by joining the change data tables and a unit of work table based on a commit sequence identifier. The consistent change records are stored on the big data platform, and queries are answered on the big data platform using the consistent change records.

US Patent:

20170351585, Dec 7, 2017

Filed:

Jun 3, 2016

Appl. No.:

15/173502

Inventors:

- Armonk NY, US
Austin F.M. D'Costa - Beaverton OR, US
Yat On Lau - San Jose CA, US
Xiao Li - San Jose CA, US
Hong Min - Poughkeepsie NY, US
Gong Su - New York NY, US
Jonathan W. Wierenga - Lower Hutt, NZ
Christian Zentgraf - Columbus OH, US
Kan Zhang - Palo Alto CA, US

International Classification:

G06F 11/14
G06F 17/30

Abstract:

Provided are techniques for transaction consistency query support for replicated data from recovery log to external data stores. An external data store is populated with records using entries of a change data table. The change data table has entries for each transaction that has committed and is to be replicated, and each of the entries stores information for each log entry in a recovery log from a database management system. Each log entry identifies a transactional change of data and a transaction completion indicator of one of commit and abort. In response to receiving a query about a transaction of the transactions, a set of records are retrieved from the external data store for the transaction. From the set of records, records whose sequence identifier values are larger than a maximum transaction commit sequence identifier are removed. From the set of records, remaining records having transaction consistency are returned.