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

公开(公告)号：GB2533116A

公开(公告)日：2016-06-15

申请号：GB201421916

申请日：2014-12-10

Applicant: IBM

Inventor： MATTHIAS TSCHAFFLER ,  DANIEL MARTIN ,  ANDREAS LOHRER ,  NAMIK HRLE

IPC: G06F17/30

Abstract: A source database is configured for efficiently processing database queries of a first query type (e.g. OLAP) and a target database is configured for efficiently processing database queries of a second query type (e.g. OLTP). A request (302) is received for performing a database statement particularly as regards a query. A latency time (304) and a velocity (306) of replicating data changes is determined and is used for predicting if an execution of the database statement will be finished earlier in the source or target databases (308). The statement request is dispatched to the source or target databases according to which is predicted to finish the request earlier.

公开(公告)号：GB2531537A

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

申请号：GB201418665

申请日：2014-10-21

Applicant: IBM

Inventor： DANIEL MARTIN ,  NAMIK HRLE ,  CHANDRASEKARAN MOHAN ,  JAMES SPYKER ,  YONGFENG YAO

IPC: G06F17/30

Abstract: A database management system (DBMS) comprising a source database, e.g. a OLTP database, and a target database, e.g. an OLAP database. The DBMS is configured for: asynchronously replicating data changes of the source database to the target database; receiving a request (308) to perform a database statement (T4S4); identifying a most recently committed one (T2) of a plurality of transactions (T1, T2, T3) which committed in the source database before receiving (LSNO the request (308); repeatedly determining if the identified most recently committed one transaction was replicated to the target database; delaying execution of the requested statement (T4S4) in the target database until the evaluation returns that the first transaction (T2) has also been replicated to and has committed in the target database; after the delaying, executing the requested statement (T4S4) in the target database.