Compressing data stored in an intermediate or result table of a database
US7383270B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Feb 3, 2004 |
| Grant date | Jun 3, 2008 |
| Priority date | — |
| Expiry date | May 6, 2025 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99943
- WIPO fieldBasic communication processes
- WIPO sectorElectrical engineering
Abstract
A database system receives a transaction specifying one or more conditions to apply to a first table, and inserts data selected in the transaction into a second. The database system further generates a value list used for compressing a column of the second table, where generating the value list comprises one of inheriting entries of the value list from another value list associated with the first table, and deriving the value list based on the one or more conditions to apply on the first table.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.