Patent · US Active

Determining materialized view coverage for join transactions

US8359325B1 · kind B1 · utility

15Cited by

3References

25Claims

0Family size

Assignee

Teradata US, Inc. · US

Inventors

Hong Gui · Madison, US
Grace Kwan-On Au · Rancho Palos Verdes, US
Curt J. Ellmann · Madison, US

Key dates

Filing date	Feb 25, 2004
Grant date	Jan 22, 2013
Priority date	—
Expiry date	Jul 28, 2030

Classification

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

Abstract

A database system includes database software to receive a query specifying a join of plural base tables, and to determine whether a foreign key and primary key relationship exists between join columns specified by the query and a materialized view definition. Based on the existence of the foreign key and the primary key relationship between join columns specified by the query and the materialized view definition, the database software determines that a result for the received query is to be computed from the materialized view.

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