Distributed system with accelerator and catalog

    公开(公告)号:GB2534373A

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

    申请号:GB201500934

    申请日:2015-01-20

    Applicant: IBM

    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.

Patent Agency Ranking