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

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