Patent · US Expired

Compressing data stored in an intermediate or result table of a database

US7383270B1 · kind B1 · utility

8Cited by
7References
19Claims
0Family size

Assignee

Inventors

Key dates

Filing dateFeb 3, 2004
Grant dateJun 3, 2008
Priority date
Expiry dateMay 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.