Patent · US Active

Using multidimensional access as surrogate for run-time hash table

US8001112B2 · kind B2 · utility

23Cited by

28References

19Claims

0Family size

Assignee

Oracle International Corporation · US

Inventors

Matthew Dombroski · Lancaster, US
Ekrem Soylemez · Arlington, US
Andrew Witkowski · Foster City, US

Key dates

Filing date	Jul 23, 2004
Grant date	Aug 16, 2011
Priority date	—
Expiry date	Jun 13, 2027

Classification

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

Abstract

Approaches are disclosed for using a multidimensional database as a surrogate for a run-time hash table in the context of processing a relational query. In an embodiment, an analytic workspace is used to store data, wherein the data is to be evaluated using a by a function in the processing of a MODEL clause. The approaches eliminate the need to use a hash table to store the data that is to be evaluated. The data may initially reside in the analytic workspace, or it may be loaded into the analytic workspace.

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