Patents by Inventor Serge Bourbonnais

Serge Bourbonnais has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Patent number: 10970266
    Abstract: A method includes reading, by a capture engine, log data. The log data can be synchronously hardware-replicated. The log data reflects that an update was started for a database of a first site. The capture engine corresponds to a capture engine of a second site. The method also includes identifying, by the capture engine, the update. The method also includes determining whether the update was committed to the database of the first site. The method also includes replicating, by an apply engine, the update to a database of the second site based on the determining. The update is replicated to the database of the second site based on a determination that the update was committed to the database of the first site. The committed update corresponds to a consistent replication of updates across two or more databases that reside in multiple database management systems.
    Type: Grant
    Filed: November 30, 2017
    Date of Patent: April 6, 2021
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Serge Bourbonnais, Paul Cadarette, David A. Clitherow, Michael G. Fitzpatrick, Pamela McLean, David Petersen, John G. Thompson, Gregory W. Vance
  • Publication number: 20210096959
    Abstract: Aspects of the invention include a continuous availability for workload and site switches with no data loss at unlimited distances in an active-active sites configuration. A non-limiting example computer-implemented method includes synchronously replicating commit records of changed workload data, by a processor, from an active site to a bunker site upon a workload data commit. The method asynchronously replicates committed transactions on changed workload data, by the processor, from the bunker site to a recovery site.
    Type: Application
    Filed: September 27, 2019
    Publication date: April 1, 2021
    Inventors: David PETERSEN, Paul M. CADARETTE, Serge BOURBONNAIS, Michael Gerard FITZPATRICK, John Simon TILLING, Pamela L. MCLEAN, Gregory Walter VANCE, Matthew J. WARD, Theresa Mary BROWN, Nicolas Marc CLAYTON, Wei LIU, Hua ZHU, Xing Jun ZHOU
  • Patent number: 10956403
    Abstract: A method for verifying data consistency between update-in-place data structures and append-only data structures containing change histories associated with the update-in-place data structures is provided. The method includes loading data from an update-in-place data structure to a first set of hash buckets in a processing platform, loading data from append-only data structures to a second set of hash buckets in the processing platform, performing a bucket-level comparison between the data in the first set of hash buckets and the data in the second set of has buckets, and generating a report based on the bucket-level comparison.
    Type: Grant
    Filed: November 15, 2018
    Date of Patent: March 23, 2021
    Assignee: International Business Machines Corporation
    Inventors: Serge Bourbonnais, Si Bin Fan, Xiao Li, Jonathan W. Wierenga, Mai Zeng
  • Patent number: 10902015
    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.
    Type: Grant
    Filed: January 19, 2017
    Date of Patent: January 26, 2021
    Assignee: International Business Machines Corporation
    Inventors: Serge Bourbonnais, Austin F. M. D'Costa, Xiao Li, Jonathan W. Wierenga, Xin Wu, Christian Zentgraf, Xiang W. Zhou
  • Publication number: 20200175034
    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.
    Type: Application
    Filed: December 3, 2018
    Publication date: June 4, 2020
    Inventors: Serge Bourbonnais, Austin D'costa, Roger Zheng, Christian Zentgraf, David Mooney
  • Publication number: 20200034210
    Abstract: A system for maintaining a two-site configuration for continuous availability over long distances may include a first computing site configured to execute a first instance associated with a priority workload, the first instance being designated as an active instance; a second computing site configured to execute a second instance of the priority workload, the second instance being designated as a standby instance; a software replication module configured to replicate a unit of work data associated with the priority workload from a first data object associated with the active instance to a second data object associated with the standby instance, and a hardware replication module configured to replicate an image from a first storage volume to a copy on a second storage volume, wherein the first storage volume is associated with the first computing site, and the second storage volume is associated with a third computing site.
    Type: Application
    Filed: October 3, 2019
    Publication date: January 30, 2020
    Inventors: Serge Bourbonnais, Paul M. Cadarette, Michael G. Fitzpatrick, David B. Petersen, Gregory W. Vance
  • Publication number: 20200026786
    Abstract: A method for resynchronizing at least one batch job is provided. The method may include detecting a type of region switch request. The method may further include stopping execution workloads on a primary system based on the switch request. The method may further include suspending software and hardware data replication from the primary system to the secondary system. The method may further utilizing proxy replication engine to determine a point-in-time (PIT) at which the execution is stopped and the suspension. The method may also include switching the replication of the software and hardware data to occur the secondary system to the primary system. The method may further include synchronizing the software and hardware data up to the determined point-in-time (PIT). The method may also include activating the execution of the plurality of workloads on the secondary system based on the determined point-in-time (PIT), switching, and synchronizing.
    Type: Application
    Filed: July 18, 2018
    Publication date: January 23, 2020
    Inventors: Paul M. Cadarette, David B. Petersen, Serge Bourbonnais, Michael G. Fitzpatrick, Pamela L. McLean, John G. Thompson, Gregory W. Vance, David A. Clitherow
  • Patent number: 10482104
    Abstract: A system for providing continuous availability comprises a second computing site that is geographically remote from a first computing site. The second computing site comprises a storage unit configured to store units of work data and data synchronously replicated from the first computing site. The second computing site further comprises a group of workloads configured to process the units of work data asynchronously replicated from the first computing site. The second computing site further comprises a software replication module configured not to replicate any data while the first computing site is available.
    Type: Grant
    Filed: September 10, 2015
    Date of Patent: November 19, 2019
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Serge Bourbonnais, Jing Cheng, You-Chin Fuh, David B. Petersen, James Z. Teng, Hong Jing Ying, Miao Zheng
  • Patent number: 10474694
    Abstract: A system for providing continuous availability comprises a second computing site that is geographically remote from a first computing site. The second computing site comprises a storage unit configured to store units of work data and data synchronously replicated from the first computing site. The second computing site further comprises a group of workloads configured to process the units of work data asynchronously replicated from the first computing site. The second computing site further comprises a software replication module configured not to replicate any data while the first computing site is available.
    Type: Grant
    Filed: February 25, 2015
    Date of Patent: November 12, 2019
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Serge Bourbonnais, Jing Cheng, You-Chin Fuh, David B. Petersen, James Z. Teng, Hong Jing Ying, Miao Zheng
  • Publication number: 20190163776
    Abstract: A method includes reading, by a capture engine, log data. The log data can be synchronously hardware-replicated. The log data reflects that an update was started for a database of a first site. The capture engine corresponds to a capture engine of a second site. The method also includes identifying, by the capture engine, the update. The method also includes determining whether the update was committed to the database of the first site. The method also includes replicating, by an apply engine, the update to a database of the second site based on the determining. The update is replicated to the database of the second site based on a determination that the update was committed to the database of the first site. The committed update corresponds to a consistent replication of updates across two or more databases that reside in multiple database management systems.
    Type: Application
    Filed: November 30, 2017
    Publication date: May 30, 2019
    Inventors: Serge Bourbonnais, Paul Cadarette, David A. Clitherow, Michael G. Fitzpatrick, Pamela McLean, David Petersen, John G. Thompson, Gregory W. Vance
  • Patent number: 10255343
    Abstract: Techniques for initializing a connection in a peer-to-peer replication environment. Responsive to a request to add a target node to a data replication group, embodiments receive a first message, at a target node, from an initiator node within the data replication group, indicating that the initiator node will begin replicating changes to the target node without waiting for any acknowledgements relating to the first message. The changes are applied to a first instance of a data entity on the initiator node. A second message is transmitted, from the target node, to at least one other member in the data replication group, announcing that the target node is joining the data replication group. Embodiments receive a plurality of replicated changes, at the target node, from the initiator node, and process each replicated change in the plurality of replicated changes against a second instance of the data entity at the target node.
    Type: Grant
    Filed: October 20, 2016
    Date of Patent: April 9, 2019
    Assignee: International Business Machines Corporation
    Inventors: Serge Bourbonnais, Somil Kulkarni, Yat O. Lau
  • Publication number: 20190087450
    Abstract: A method for verifying data consistency between update-in-place data structures and append-only data structures containing change histories associated with the update-in-place data structures is provided. The method includes loading data from an update-in-place data structure to a first set of hash buckets in a processing platform, loading data from append-only data structures to a second set of hash buckets in the processing platform, performing a bucket-level comparison between the data in the first set of hash buckets and the data in the second set of has buckets, and generating a report based on the bucket-level comparison.
    Type: Application
    Filed: November 15, 2018
    Publication date: March 21, 2019
    Inventors: Serge Bourbonnais, SI BIN FAN, Xiao Li, Jonathan W. Wierenga, Mai Zeng
  • Patent number: 10229152
    Abstract: A data replication method can begin with the detection of an inconsistency between records of a target table and corresponding records of a source table of a relational database management system (RDBMS) performing a parallel apply replication by an improved data replication manager. The target table can be a copy of the source table, both of which include multiple unique constraints and indexes. A timeframe that encompasses the records of the target table having the inconsistency can be determined. The timeframe can utilize a commit timestamp or a log sequence number. Consistency between the target table and the source table can be automatically restored for the determined timeframe through use of a reactive-apply process. Data suppression for updates is automatically restored once the copy is consistent. Transactions performed upon the target table by the reactive-apply process can be performed in parallel. Service at the source table and the target table can be uninterrupted.
    Type: Grant
    Filed: June 27, 2016
    Date of Patent: March 12, 2019
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Serge Bourbonnais, Austin F. D'Costa, Xiao Li, Jonathan Wierenga
  • Patent number: 10216584
    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.
    Type: Grant
    Filed: December 21, 2017
    Date of Patent: February 26, 2019
    Assignee: International Business Machines Corporation
    Inventors: Serge Bourbonnais, Austin F. M. D'Costa, Yat On Lau, Xiao Li, Hong Min, Gong Su, Jonathan W. Wierenga, Christian Zentgraf
  • Patent number: 10216582
    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.
    Type: Grant
    Filed: August 15, 2016
    Date of Patent: February 26, 2019
    Assignee: International Business Machines Corporation
    Inventors: Serge Bourbonnais, Austin F. M. D'Costa, Yat On Lau, Xiao Li, Hong Min, Gong Su, Jonathan W. Wierenga, Christian Zentgraf
  • Patent number: 10176216
    Abstract: A method for verifying data consistency between update-in-place data structures and append-only data structures containing change histories associated with the update-in-place data structures is provided. The method includes loading data from an update-in-place data structure to a first set of hash buckets in a processing platform, loading data from append-only data structures to a second set of hash buckets in the processing platform, performing a bucket-level comparison between the data in the first set of hash buckets and the data in the second set of has buckets, and generating a report based on the bucket-level comparison.
    Type: Grant
    Filed: February 1, 2016
    Date of Patent: January 8, 2019
    Assignee: International Business Machines Corporation
    Inventors: Serge Bourbonnais, Si Bin Fan, Xiao Li, Jonathan W. Wierenga, Mai Zeng
  • Patent number: 10169409
    Abstract: A system for transferring data from a Relational Database Management System (“RDBMS”) to a big data platform and methods for making and using the same. The system can acquire a partitioning execution scheme of a selected table from the RDBMS and submitting partitioned queries from the big data platform to each mapper of partitions. The partitioned queries are generated based on the partitioning execution scheme. The partitioning execution scheme can be acquired by submitting a query explain request to an optimizer of the RDBMS to generating a parallel query plan. The partitioning execution scheme can also be acquired by querying statistics from a statistics catalog of the RDBMS or by user inputs. The system can use RDBMS capabilities and statistics for parallel data fetching. Thereby, the system can increase efficiency of the fetching and can avoid straggling when target data is not evenly distributed and can avoid table query-in-serial.
    Type: Grant
    Filed: October 1, 2015
    Date of Patent: January 1, 2019
    Assignee: International Business Machines Corporation
    Inventors: Serge Bourbonnais, Hong Min, Xiao Li, Gong Su, Ke Wei Wei, Xi Long Zheng
  • Patent number: 10169429
    Abstract: An integrated data processing system with two-tier data caching system and techniques for use thereof in a hybrid RDBMS and BDS computing environment are provided. In one aspect, the system is RDBMS-centric and uses two caches, one on the RDBMS side (1st tier) and the other on the BDS side (2nd tier). In another aspect, a DRDA wrapper on the BDS side enables the RDBMS to communicate with the BDS as if the BDS is another RDBMS. This is advantageous because the RDBMS already supports the DRDA protocol standard. In yet another aspect, the DRDA wrapper performs the data transformation needed when transferring cached objects between the RDBMS cache and BDS cache because RDBMS and BDS save data objects in different formats. This is advantageous because it offloads the computation from RDBMS to BDS therefore reducing the performance impact on RDBMS for its normal query and transaction processing.
    Type: Grant
    Filed: November 11, 2015
    Date of Patent: January 1, 2019
    Assignee: International Business Machines Corporation
    Inventors: Serge Bourbonnais, Zhen Hua Dong, Nan Jiang, Xiao Li, Hong Min, Gong Su, En Zhong Wang, Ke Wei Wei, Xi Long Zheng
  • Patent number: 10084858
    Abstract: A system for providing reliable availability of a general workload and continuous availability of a priority workload over long distances may include a first computing site configured to execute a first instance associated with the priority workload, wherein the first instance is designated as an active instance, a second computing site configured to execute a second instance of the priority workload, wherein the second instance is designated as a standby instance, a third computing site configured to restart a third instance associated with the general workload, and a workload availability module configured to synchronize a portion of data associated with the third instance with a corresponding portion of data associated with the second instance.
    Type: Grant
    Filed: November 22, 2017
    Date of Patent: September 25, 2018
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Serge Bourbonnais, Paul M. Cadarette, Michael G. Fitzpatrick, David B. Petersen, Gregory W. Vance
  • Patent number: 10083202
    Abstract: A method for verifying data consistency between update-in-place data structures and append-only data structures containing change histories associated with the update-in-place data structures is provided. The method includes loading data from an update-in-place data structure to a first set of hash buckets in a processing platform, loading data from append-only data structures to a second set of hash buckets in the processing platform, performing a bucket-level comparison between the data in the first set of hash buckets and the data in the second set of has buckets, and generating a report based on the bucket-level comparison.
    Type: Grant
    Filed: December 6, 2016
    Date of Patent: September 25, 2018
    Assignee: International Business Machines Corporation
    Inventors: Serge Bourbonnais, Si Bin Fan, Xiao Li, Jonathan W. Wierenga, Mai Zeng