Apparatus and method for processing query in database with hybrid storage
US9904708B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Feb 19, 2015 |
| Grant date | Feb 27, 2018 |
| Priority date | — |
| Expiry date | Mar 13, 2036 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24542
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.