公开(公告)号：IL295463B1

公开(公告)日：2025-03-01

申请号：IL29546322

申请日：2022-08-08

Applicant: IBM ,  DENNIS BUTTERSTEIN ,  OLIVER BENKE ,  TOBIAS ULRICH BERGMANN ,  FELIX BEIER ,  TERENCE P PURCELL

Inventor： DENNIS BUTTERSTEIN ,  OLIVER BENKE ,  TOBIAS ULRICH BERGMANN ,  FELIX BEIER ,  TERENCE P PURCELL

IPC: G06F16/23 ,  G06F16/2453 ,  G06F16/2458

Abstract: Methods and systems for generating database statistics. Table statistics in a metadata catalog of a source database system are observed, statistics generation costs utilizing a target database system are estimated, and source statistics generation costs utilizing a source database system are estimated. The statistics generation costs are compared and statistics generation queries by the target database system are triggered in response to the statistics generation costs utilizing the target database system having a predefined relationship with the source statistics generation costs utilizing the source database system. The statistics generation queries are performed by the target database system in response to the triggering by the source database system. The generated statistics are sent from the target database system to the source database system, the table statistics in a metadata catalog are updated based on the generated statistics, and the updated table statistics are used to optimize a query plan.

公开(公告)号：GB2602544A8

公开(公告)日：2022-07-20

申请号：GB202115084

申请日：2021-10-21

Applicant: IBM

Inventor： FELIX BEIER ,  DENNIS BUTTERSTEIN ,  SABINE PERATHONER-TSCHAFFLER ,  EINER LUECK

IPC: G06F16/27

Abstract: A computer implemented method comprises receiving at least one log record 130 describing a type of operation performed in a source database system 101. Based on the type of operation, an update strategy is selected from a set of pre-defined update strategies. The update strategy specifies a sequence of replication operations to be performed in order to apply changes described in the at least one log record to a target database system 103. The change described in the log record may then be applied using the chosen update strategy in order to synchronize data across multiple databases. If the update of the target database fails, an alternative update strategy may be used instead. The method may be useful in a system in which both older and newer versions of the incremental update software are available, and a choice must be made about which to use.

公开(公告)号：IL295463A

公开(公告)日：2022-10-01

申请号：IL29546322

申请日：2022-08-08

Applicant: IBM ,  DENNIS BUTTERSTEIN ,  OLIVER BENKE ,  TOBIAS ULRICH BERGMANN ,  FELIX BEIER ,  TERENCE P PURCELL

Inventor： DENNIS BUTTERSTEIN ,  OLIVER BENKE ,  TOBIAS ULRICH BERGMANN ,  FELIX BEIER ,  TERENCE P PURCELL

IPC: G06F16/2453

Abstract: Methods and systems for generating database statistics. Table statistics in a metadata catalog of a source database system are observed, statistics generation costs utilizing a target database system are estimated, and source statistics generation costs utilizing a source database system are estimated. The statistics generation costs are compared and statistics generation queries by the target database system are triggered in response to the statistics generation costs utilizing the target database system having a predefined relationship with the source statistics generation costs utilizing the source database system. The statistics generation queries are performed by the target database system in response to the triggering by the source database system. The generated statistics are sent from the target database system to the source database system, the table statistics in a metadata catalog are updated based on the generated statistics, and the updated table statistics are used to optimize a query plan.

公开(公告)号：GB2602544A

公开(公告)日：2022-07-06

申请号：GB202115084

申请日：2021-10-21

Applicant: IBM

Inventor： FELIX BEIER ,  DENNIS BUTTERSTEIN ,  SABINE PERATHONER-TSCHAFFLER ,  EINAR LUECK

IPC: G06F16/27

Abstract: A computer implemented method comprises receiving at least one log record 130 describing a type of operation performed in a source database system 101. Based on the type of operation, an update strategy is selected from a set of pre-defined update strategies. The update strategy specifies a sequence of replication operations to be performed in order to apply changes described in the at least one log record to a target database system 103. The change described in the log record may then be applied using the chosen update strategy in order to synchronize data across multiple databases. If the update of the target database fails, an alternative update strategy may be used instead. The method may be useful in a system in which both older and newer versions of the incremental update software are available, and a choice must be made about which to use.