DISTRIBUTED SYSTEM WITH ACCELERATOR AND CATALOG

摘要

A distributed database system (or federated database system) where a catalogue is used to store metadata descriptive of data containers for the constituent database system(s) and/or accelerator system(s) of the federated database. In response to the generation of the trigger signal corresponding to a database definition language (DDL) statement, the accelerator system updates metadata in the catalogue.

主权项

1. A computer-implemented method for use with a federated database system including an accelerator system, a database management system (DBMS) structured and programmed to manage a first constituent database, with the DBMS including a single interface structured and programmed to receive database queries, the method comprising:
maintaining, by the DBMS, a catalogue comprising first metadata and second metadata, the first metadata being descriptive of a structure of data containers of a first data container type stored in the first constituent database, the second metadata being descriptive of a structure of data containers of a second data container type stored in the accelerator system; evaluating, by the single interface, a first received database query to determine whether the first database query includes a data definition language statement related to the creation or modification of a first data container in the DBMS and/or a data definition language statement related to the creation or modification of a first data container in the DBMS; on condition that the evaluation determines that the first database query includes a data definition language statement related to the creation or modification of the first data container type:
providing, by the single interface, the data definition language statement to the database management system, andchanging, by the DBMS, the first data container type according to the data definition language statement; and on condition that the evaluation determines that the first database query includes a data definition language statement related to the creation or modification of the first data container type:
providing, by the single interface, the data definition language statement to the database management system, andcreating, by the DBMS, a trigger signal that causes the accelerator system to change the second data container type and update the second metadata in the catalogue such that the updated second metadata is descriptive of the changed second data container type.