SYSTEM, METHOD, AND PROGRAM FOR INCREASING EFFICIENCY OF DATABASE QUERIES

摘要

[Problem] To provide a device, a method, and a program for speeding up a database process which are implementable at 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 storage device. In the 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 storage as far as possible. When necessary, an SQL execution plan is dynamically rewritten in accordance with a hardware configuration.