DDL and DML support for hybrid columnar compressed tables
US8583692B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Aug 30, 2010 |
| Grant date | Nov 12, 2013 |
| Priority date | — |
| Expiry date | Aug 30, 2030 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/284
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Techniques for storing and manipulating tabular data are provided. According to one embodiment, a user may control whether tabular data is stored in row-level or column-major format. Furthermore, the user may control the level of data compression to achieve an optimal balance between query performance and compression ratios. Tabular data from within the same table may be stored in both column-major and row-major format and compressed at different levels. In addition, tabular data can migrate between column-major format and row-major format in response to various events. For example, in response to a request to update or lock a row stored in column-major format, the row may be migrated and subsequently stored into row-major format. In one embodiment, table partitions are used to enhance data compression techniques. For example, compression tests are performed on a representative table partition, and a compression map is generated and applied to other table partitions.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.