Query and exadata support for hybrid columnar compressed data
US8832142B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Aug 30, 2010 |
| Grant date | Sep 9, 2014 |
| Priority date | — |
| Expiry date | Oct 13, 2030 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2457
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and apparatus is provided for optimizing queries received by a database system that relies on an intelligent data storage server to manage storage for the database system. Storing compression units in hybrid columnar format, the storage manager evaluates simple predicates and only returns data blocks containing rows that satisfy those predicates. The returned data blocks are not necessarily stored persistently on disk. That is, the storage manager is not limited to returning disc block images. The hybrid columnar format enables optimizations that provide better performance when processing typical database workloads including both fetching rows by identifier and performing table scans.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.