Patent · US Active

Aggregate join index utilization in query processing

US7912833B2 · kind B2 · utility

3Cited by

7References

18Claims

0Family size

Assignee

Teradata US, Inc. · US

Inventors

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

Key dates

Filing date	Aug 5, 2008
Grant date	Mar 22, 2011
Priority date	—
Expiry date	Sep 18, 2029

Classification

Technology area (CPC Y)Emerging Cross-Sectional Technologies
CPC primaryY10S707/957
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

A system and method include obtaining a query and identifying an aggregate join index (AJI) at a high level of aggregation. The dimension table may be rolled-up with the grouping key being the union of the grouping key in the AJI and the grouping key of the query. The identified AJI is joined with the rolled-up dimension table to obtain columns in the query that are not in the identified AJI. The joined AJI and rolled-up dimension table are then rolled up to answer the query.

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