Dynamically building and populating data marts with data...

Details Dynamically building and populating data marts with data... Dynamically building and populating data marts with data...

2011-06-28

2011-06-28

Lewis, Cheryl (Department: 2167)

Data processing: database and file management or data structures

Data warehouse, data mart, online analytical processing ,...

C707S695000, C707S806000

Reexamination Certificate

active

07970728

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.

REFERENCES:
patent: 6167405 (2000-12-01), Rosensteel et al.
patent: 6212524 (2001-04-01), Weissman et al.
patent: 6385604 (2002-05-01), Bakalash et al.
patent: 6651062 (2003-11-01), Ghannam et al.
patent: 6721749 (2004-04-01), Najm et al.
patent: 7117215 (2006-10-01), Kanchwalla et al.
patent: 7313561 (2007-12-01), Lo et al.
patent: 7315849 (2008-01-01), Bakalash et al.
patent: 7319996 (2008-01-01), Chen et al.
patent: 7333982 (2008-02-01), Bakalash et al.
patent: 7392248 (2008-06-01), Bakalash et al.
patent: 7680828 (2010-03-01), Gorelik
patent: 7730057 (2010-06-01), Bell et al.
patent: 2004/0181440 (2004-09-01), Yeh et al.
patent: 2006/0031250 (2006-02-01), Henigman et al.
patent: 2006/0117057 (2006-06-01), Legault et al.
patent: 2006/0259507 (2006-11-01), Higuchi
patent: 2006/0271568 (2006-11-01), Balkir et al.
patent: 2007/0185867 (2007-08-01), Maga et al.
patent: 2007/0250524 (2007-10-01), Le
patent: 2007/0294208 (2007-12-01), Chowdhary et al.
patent: 2008/0021893 (2008-01-01), Bakalash et al.
patent: 2008/0021915 (2008-01-01), Bakalash et al.
patent: 2008/0027970 (2008-01-01), Zhuge et al.
patent: 2008/0104089 (2008-05-01), Pragada et al.
patent: 2009/0012816 (2009-01-01), Cookson et al.
L. Schlesinger, A. Bauer, W. Lehner, G. Ediberidze, & M. Gutzmann, “Efficiently Synchronizing Multidimensional Schema Data”, Proceedings of the 4th ACM International Workshop, pp. 1-8, Nov. 2001.
Karayannidis, et al., “Processing Star Queries on Hierarchically-Clustered Fact Tables” pp. 1-12, 2002.
Veerman, Erik, “Designing a Dimensional Model,” pp. 1-21.

Affiliated with

Also associated with

Rating

Dynamically building and populating data marts with data... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Dynamically building and populating data marts with data..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Dynamically building and populating data marts with data... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2619309