Invention Grant
- Patent Title: Replicating large statements with low latency
-
Application No.: US17674914Application Date: 2022-02-18
-
Publication No.: US12056153B2Publication Date: 2024-08-06
- Inventor: Serge Bourbonnais , Austin D'Costa , Roger Zheng , Christian Zentgraf , David Mooney
- Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Schmeiser, Olsen & Watts, LLP
- Agent Lily Neff
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/23 ; G06F16/2453 ; G06F16/2455 ; G06F16/27

Abstract:
A method, system and computer program product is provided. The method includes identifying a large statement, writing 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.
Public/Granted literature
- US20220171791A1 REPLICATING LARGE STATEMENTS WITH LOW LATENCY Public/Granted day:2022-06-02
Information query