Patent · US Active

Deferred maintenance of sparse join indexes

US8032503B2 · kind B2 · utility

15Cited by

16References

21Claims

0Family size

Assignee

Teradata US, Inc. · US

Inventors

Carlos Bouloy · San Diego, US
Grace Kwan-On Au · Rancho Palos Verdes, US
Hong Gui · Madison, US

Key dates

Filing date	Aug 5, 2008
Grant date	Oct 4, 2011
Priority date	—
Expiry date	Dec 18, 2029

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/2456
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

A system and method include defining a snapshot join index using a sparse condition in a join index definition. A new sparse condition of the snapshot join index is compared with an old sparse condition. Rows in a base table are identified as a function of the comparing, and the join index table is updated using the identified rows.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.