Patent Number: 8,793,268

Title: Smart key access and utilization to optimize data warehouse performance

Abstract: In a data warehouse, a master table includes surrogate identifiers. Each surrogate identifier (SID) uniquely identifies a master table domain within the master table. A dimension table uses the surrogate identifiers to link to the master table domains. A SID generator uses first data supplied in a user query to generate a first SID indicating location of a particular master table domain in the master table. The SID generator generates the first SID without accessing the master table.

Inventors: Gonsalves; Allan Michael (San Jose, CA)

Assignee:

International Classification: G06F 17/30 (20060101)

Expiration Date: 7/29/12018