-
公开(公告)号: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.
-
公开(公告)号:GB2604421A
公开(公告)日:2022-09-07
申请号:GB202115857
申请日:2021-11-04
Applicant: IBM
Inventor: STEFAN RENNER , CHRISTIAN WILHELM PAUL HOERST , JOHANNES SEVERIN KERN , FELIX BEIER
Abstract: The present disclosure relates to a problem management method for a user system. A method may include detecting an error in the user system. A signed package may be provided in accordance with the detected error, wherein the package comprises at least a script. The user system may verify the authenticity of the package using a signature of the package, and may execute the script if the package is authentic.
-
公开(公告)号: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.
-
公开(公告)号:GB2500532B
公开(公告)日:2018-02-21
申请号:GB201311399
申请日:2011-11-03
Applicant: IBM
Inventor: KNUT STOLZE , FELIX BEIER , OLIVER DRAESE
-
公开(公告)号:GB2631493A
公开(公告)日:2025-01-08
申请号:GB202310122
申请日:2023-07-03
Applicant: IBM
Inventor: KNUT STOLZE , FELIX BEIER , LUIS EDUARDO OLIVEIRA LIZARDO , REINHOLD GEISELHART
Abstract: Disclosed herein is a computer implemented method of using a logical view of a base database table of a database system for mirroring or replication of changes in the logical view. The method comprises: receiving a change request for the logical view; generating a log record for the change request in a transaction log; performing a replication operation to replicate the change request for the logical view in a target database table by inputting the transaction log into a replication tool configured for modifying the target database table using the transaction log. The replication tool may be configured for performing a replication operation that replicates changes in the logical view to a different database table using the transaction log. the target database table may be a different database table or the base database table. Generating a log record for the change request in a transaction log may comprise logging the change to the logical view as a change to the base database table.
-
公开(公告)号:GB2630960A
公开(公告)日:2024-12-18
申请号:GB202308929
申请日:2023-06-15
Applicant: IBM
Inventor: REINHOLD GEISELHART , MAX FABIAN GILBERT , FELIX BEIER , KNUT STOLZE
Abstract: The present disclosure relates to a method for storing data in a table of a database system. The table comprises at least one first column and at least one second column. The first column is configured for comprising first type data, such as an integer or Char type. The second column is configured for comprising second type data such as a BLOB type, wherein the second type data has a maximum size higher than a maximum size of the first type data. The method comprises: receiving a query to store a record in the table. It may be determined whether the record comprises a value of the second column. In case the record comprises the value of the second column, the value may be stored in a version control system and a reference token representing the value may be stored in the second column of the table. In case the record does not comprise the value for the second column, the record may be stored in the table.
-
公开(公告)号:GB2604562A
公开(公告)日:2022-09-07
申请号:GB202209149
申请日:2020-11-18
Applicant: IBM
Inventor: REINHOLD GEISELHART , FELIX BEIER , DOMINIK SCHNELL
IPC: G08G1/0965
Abstract: A method for vehicle traffic behavior monitoring and feedback that includes collecting vehicle sensor data from a set of vehicles operating in a traffic environment, where each vehicle transmits vehicle sensor data via a communications network to a processor, and forming a consensus block of aggregate data, where the aggregate data is made of individual vehicle sensor data from each vehicle in the set of vehicles, and where the processor discards duplicate data and repetitive data from the consensus block. The method also includes detecting, in the consensus block, a vehicle motion pattern, where the vehicle motion pattern deviates from a threshold by greater than a tolerance, mapping the vehicle motion pattern to a particular vehicle in the set of vehicles, and generating a feedback response based on the mapping.
-
公开(公告)号:GB2597201A
公开(公告)日:2022-01-19
申请号:GB202116491
申请日:2020-04-06
Applicant: IBM
Inventor: REINHOLD GIESELHART , KNUT STOLZE , FELIX BEIER , LIZARDO LUIS OLIVEIRA
IPC: G06F16/21
Abstract: The invention relates to a computer-implemented method for managing multiple services (108-114; 208-214) in a DBMS (102, 202). The services respectively are configured to process data that is stored in or is received for being stored in a database (116-122; 216-222) managed by the DBMS. The method comprises providing (302) a service manager (106) operatively coupled to the DBMS; registering (304) the multiple services automatically and dynamically at runtime of the DBMS at the service manager; and automatically managing (306), by the service manager, dependencies between different ones of the multiple registered services.
-
公开(公告)号: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.
-
公开(公告)号:GB2597201B
公开(公告)日:2022-07-20
申请号:GB202116491
申请日:2020-04-06
Applicant: IBM
Inventor: REINHOLD GIESELHART , KNUT STOLZE , FELIX BEIER , LIZARDO LUIS OLIVEIRA
Abstract: The invention relates to a computer-implemented method for managing multiple services in a DBMS. The services respectively are configured to process data that is stored in or is received for being stored in a database managed by the DBMS. The method comprises providing a service manager operatively coupled to the DBMS; registering the multiple services automatically and dynamically at runtime of the DBMS at the service manager; and automatically managing, by the service manager, dependencies between different ones of the multiple registered services.
-
-
-
-
-
-
-
-
-