APPARATUS AND METHOD FOR PROCESSING QUERY IN DATABASE WITH HYBRID STORAGE

摘要

The present invention provides an apparatus and method for processing a query in a relational database system having a hybrid storage of a memory tablespace and a disk tablespace, with the configuration of the present invention, by extending a table partitioning technology in order for the relational database system to use the disk tablespace and memory tablespace in a hybrid manner, it is possible to implement data discrimination due to different data storages in one logical table and create scan plans in compliance with the difference in the storages, thereby establishing an optimal scan plan to the query intended to access the storages having different properties.

主权项

1. An apparatus for processing a query in a database system, the apparatus comprising:
a tablespace metadata that stores information as to whether tables are stored in which tablespace, wherein the tables are stored in the database system including a disk tablespace and a memory tablespace; a query compiling unit, upon receiving a query statement, configured to check whether a table needed for processing the query statement is stored in the disk tablespace or the memory tablespace by referencing the information about the tablespace and to create a scan plan of the table; and a query execution unit configured to read out the data of the table by accessing the disk tablespace or the memory tablespace in accordance with the scan plan that is created by the query compiling unit and to perform a processing of the query statement using the read-out data.