Patent · US Active

Dynamically building and populating data marts with data stored in repositories

US7970728B2 · kind B2 · utility

10Cited by

13References

25Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Benjamin Honzal · Isny im Allgäu, DE
Holger Kache · Munich, DE
Mary Ann Roth · San Jose, US
Guenter A. Sauter · Ridgefield, US

Key dates

Filing date	Oct 23, 2008
Grant date	Jun 28, 2011
Priority date	—
Expiry date	Dec 15, 2029

Classification

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

Abstract

Methods, systems, and articles of manufacture for constructing and populating data marts with dimensional data models from a set of data repositories that contain factual and association information about a set of related assets are disclosed. An intermediate data warehouse is generated to process the facts and associations for each asset. Using the intermediate warehouse, one or more data marts are generated with fact tables, dimensions, and hierarchies to fully model the information available for each asset.

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