US 2021/0334264 A1Published application

System, method, and program for increasing efficiency of database queries

OwnerKohei KAIGAIinventor

Life of this patent

Estimating the term…

Loading patent…

Abstract

[Problem] To provide a device, a method, and a program for speeding up a database process which can be implemented at a low cost. [Solution] A plurality of I/O extension units including a GPU, an SSD and a PCIe switch are connected to a database server via a PCIe bus, and it is made possible to transfer data from the SSD to the GPU and perform processing in parallel without the intervention of a CPU and a main memory. In a preprocess of a database query, it is made possible to generate an instruction for the process of a large amount of data to be completed within one I/O extension unit and execute a database query without the intervention of the CPU and the main memory. When necessary, an SQL execution plan is dynamically rewritten in accordance with a hardware configuration.

Claims14

Dependent claims

A database processing apparatus comprising:

a database processing apparatus comprising:
a first external storage device;
a first parallel processing device;
a first I/O switch;
a second external storage device;
a second parallel processing device;
a second I/O switch;
a central processing device;
an I/O controller which is built in the central processing unit or directly connected to the central processing unit via an internal bus;
and
a main memory;
wherein the first external storage device, a first parallel processing device, and a first I/O switch are housed in a first enclosure;
the second external storage device, the second parallel processing device, and the second I/O switch are housed in a second enclosure;
the central processing unit and the I/O controller are housed in a third enclosure;
the first enclosure and the third enclosure are different;
the second enclosure and the third enclosure are different;
the central processing unit is configured to issue, to the first external storage device via the first I/O switch, an order for transferring data stored in the first external storage device to the first parallel processing device, without an intervention of the I/O controller or the main memory;
and
the central processing unit is configured to order, to the second external storage device via the second I/O switch, an instruction for transferring data stored in the second external storage device to the second parallel processing device, without an intervention of the I/O controller or the main memory.

16 more elements

a non-transitory computer readable medium that stores a computer-executable program for database processing,

the computer-executable program being executed on a database processing apparatus comprising:
a first external storage device;
a first parallel processing device;
a first I/O switch;
a second external storage device;
a second parallel processing device;
a second I/O switch;
a central processing unit;
an I/O controller which is built in the central processing unit or directly connected to the central processing unit via an internal bus;
and
a main memory;
wherein the first external storage device, a first parallel processing device, and a first I/O switch are housed in a first enclosure;
the second external storage device, the second parallel processing device and the second I/O switch are housed in a second enclosure;
the central processing unit and the I/O controller are housed in a third enclosure;
the first enclosure and the third enclosure are different;
the second enclosure and the third enclosure are different, and
the computer-executable program comprising instructions for:
ordering, to the first external storage device via the first I/O switch, to transfer data stored in the first external storage device to a first parallel processing device, without an intervention of the I/O controller or the main memory;
and
ordering to the second external storage device via the second I/O switch, to transfer data stored in the second external storage device to the second parallel processing device, without an intervention of the I/O controller or the main memory.

17 more elements

a computer-executable database processing method executed on a database processing system,

the database processing system comprising:
a first external storage device;
a first parallel processing device;
a first I/O switch;
a second external storage device;
a second parallel processing device;
a second I/O switch;
a central processing unit;
an I/O controller which is built in the central processing unit or directly connected to the central processing unit via an internal bus;
and
a main memory;
wherein the first external storage device, a first parallel processing device, and a first I/O switch are housed in a first enclosure;
the second external storage device, the second parallel processing device and the second I/O switch are housed in a second enclosure;
the central processing unit and the I/O controller are housed in a third enclosure;
the first enclosure and the third enclosure are different;
the second enclosure and the third enclosure are different,
the computer-executable database processing method comprising:
ordering, to the first external storage device via the first I/O switch, to transfer data stored in the first external storage device to the first parallel processing device, without an intervention of the I/O controller or the main memory;
and
ordering to the second external storage device via the second I/O switch, to transfer data stored in the second external storage device to the second parallel processing device, without an intervention of the I/O controller or the main memory.

17 more elements

Dependencies are inferred from the claim text.