公开(公告)号：GB2597201B

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

申请号：GB202116491

申请日：2020-04-06

Applicant: IBM

Inventor： REINHOLD GIESELHART ,  KNUT STOLZE ,  FELIX BEIER ,  LIZARDO LUIS OLIVEIRA

IPC: G06F16/21 ,  G06F9/445

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.

公开(公告)号：GB2500532B

公开(公告)日：2018-02-21

申请号：GB201311399

申请日：2011-11-03

Applicant: IBM

Inventor： KNUT STOLZE ,  FELIX BEIER ,  OLIVER DRAESE

IPC: H03M7/40 ,  H03M7/46

公开(公告)号：GB2534373A

公开(公告)日：2016-07-27

申请号：GB201500934

申请日：2015-01-20

Applicant: IBM

Inventor： OLIVER BENKE ,  OLIVER DRAESE ,  ROLAND SEIFFERT ,  KNUT STOLZE ,  PETER BENDEL ,  NAMIK HRLE ,  MARYELA WEIHRAUCH ,  RUIPING LI

IPC: G06F17/30

Abstract: A computer-implemented method for processing data (118) in a distributed system (112) comprising a first DBMS (110) and an accelerator system (120). The method comprises: maintaining (302), by the first DBMS, a catalogue (116), the catalogue comprising first metadata (MD1) descriptive of first data containers (124.1) in the first DBMS and second metadata (MD2) descriptive of second data containers (124.2, 128) in the accelerator system; providing (304) a single interface (138) of the distributed system for receiving a database query (140); evaluating (306), by the single interface, the received database query (140); if the received database query comprises a DDL statement related to the creation or modification of a first data container, providing (310) said DDL statement to the first DBMS and processing (322) said DDL statement by the first DBMS; if the database query comprises a DDL statement related to the creation or modification of a second data container, providing (312) said DDL statement to the first DBMS and processing (324) said DDL statement by the first DBMS, thereby creating a trigger signal; if the received database query comprises a DML statement, determining (3 14), by the single interface, if said DML statement shall be processed by the first DBMS or shall be dispatched to the accelerator system for being processed; in response to the generation of the trigger signal, creating, deleting or updating (318), by the accelerator system, the second data container to which the DDL statement relates in the accelerator system; and updating, by the accelerator system, the second metadata (MD2) in the catalogue (116) accordingly; if the DML statement is dispatched to the accelerator system, processing (320), by the accelerator system, the dispatched DML statement on data (118.2) contained in the second data containers.

公开(公告)号：GB2631493A

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

申请号：GB202310122

申请日：2023-07-03

Applicant: IBM

Inventor： KNUT STOLZE ,  FELIX BEIER ,  LUIS EDUARDO OLIVEIRA LIZARDO ,  REINHOLD GEISELHART

IPC: G06F16/27 ,  G06F16/23

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

IPC: G06F16/21 ,  G06F16/22

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.

公开(公告)号：GB2628343A

公开(公告)日：2024-09-25

申请号：GB202304003

申请日：2023-03-20

Applicant: IBM

Inventor： PHILIPP GOTTLICH ,  KNUT STOLZE ,  MAX FABIAN GILBERT

IPC: G06F9/448 ,  G06F9/50 ,  G06F9/54 ,  G06F12/02

Abstract: An application comprises a number of components 105, a number of buffers 101 and a buffer manager 103. Each buffer has a state that indicates what output has been written to the buffer. Each component requests a buffer with a given state from the buffer manager. If a buffer with that state exists, then the buffer manager gives that buffer to the component. The component reads data from the buffer, processes the data and writes new data to the buffer. The component then updates the state to indicate the data it has written to the buffer. The buffer may then be given to another component that requires the data output by the first component. Is there is no buffer with the state required by a component, the component waits until a buffer becomes available. If there are multiple buffers with the same state, the buffer manager may prioritise the buffer that has been in that state the longest. Buffers may be initialised to indicate that they are empty.

公开(公告)号：GB2604758A

公开(公告)日：2022-09-14

申请号：GB202205338

申请日：2020-08-21

Applicant: IBM

Inventor： PETER BENDEL ,  OLIVER HARM ,  KNUT STOLZE ,  BJÖRN BROLL

IPC: G06F12/02 ,  G06F16/21

Abstract: The present disclosure relates to a method for executing concurrent database operations in a database system during a time window. The database operations are configured to use storage units of a storage space of the database system. The method comprises determining a first usage speed of free storage units to be used by at least one first database operation and a second usage speed of free storage units to be used by a second database operation. The first and second usage speeds may be used for determining a maximum number of free storage units to be used by the second database operation during the time window. The second database operation may be executed during the time window in accordance with the maximum number. The first database operation may be executed, wherein the execution of the first database operation during the time window being limited to the storage units of the storage space.

公开(公告)号：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.

公开(公告)号：GB2534374A

公开(公告)日：2016-07-27

申请号：GB201500937

申请日：2015-01-20

Applicant: IBM

Inventor： OLIVER BENKE ,  OLIVER DRAESE ,  ROLAND SEIFFERT ,  KNUT STOLZE ,  PETER BENDEL

IPC: G06F17/30

Abstract: A distributed system (112) comprises a first DBMS (110) and an accelerator system (120). The first DBMS (110) comprises data (118.1) and a catalogue (116). The catalogue comprises first (MD1) and second (IVED2) metadata. The first metadata is descriptive of the structure of first data containers (e.g. tables or views) (122, 124.1) stored in the first database management system. The second metadata is descriptive of the structure of second data containers (124.2, 128) stored in the accelerator system. The accelerator system comprises a copy (118.2) of at least some parts of the data (118.1). The distributed system (112) further comprises a single interface (138) for receiving a database query (140). At least the accelerator system is configured for solely processing database queries received by the distributed system (112) via the single interface, the single interface being configured for accessing the catalogue. The first DBMS is configured for: detecting a trigger event for calculating a computational task; creating incomplete second metadata for a second data container which is absent from the accelerator system at the moment of the detection, the incomplete second metadata comprising a name or a namespace for the absent second data container and lacking structural information of said second data container; causing the accelerator system to execute program logic of the accelerator system, the execution of the program logic, said execution comprising: dynamically identifying (414) information being indicative of structural features the absent second data container shall comply to; transmitting (416) the dynamically identified information to the first database management system; creating the second data container in accordance with said structural features; storing the created second data container in the accelerator system and filling said second data container with data; supplementing the incomplete second metadata with the transmitted information, thereby creating complete second metadata being descriptive of the name and structure of the created second data container.