Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2005-01-25
2005-01-25
Mizrahi, Diane D (Department: 2171)
Data processing: database and file management or data structures
Database design
Data structure types
Reexamination Certificate
active
06847973
ABSTRACT:
A method of managing slowly changing dimensions in a dimensional database, such as a dimensional data mart, is disclosed. The method consists of providing a dimension template for each dimension undergoing slow changes, which template assigns a behavior to each column of the dimension table. When a row of dimensional data is to be delivered to the dimension table, the table is searched for a record having the key value of the row of data to be delivered. If such a record exists and if any attributes of the row to be delivered have their values changed compared with the existing record, the table is updated according to the behavior type assigned to these attributes in the dimension template, either by overwriting the existing record with the record to be delivered or by creating a new record or records.
REFERENCES:
patent: 6003024 (1999-12-01), Bair et al.
patent: 6549907 (2003-04-01), Fayyad et al.
patent: 6587547 (2003-07-01), Zirngibl et al.
patent: 1164511 (2001-12-01), None
Ralph Kimball, “The Data Warehouse Lifecycle Toolkit”, 1998, XP002243859, pp. 180-193.
Ralph Kimball, “The Data Warehouse Toolkit”, 1996, XP002243860, pp. 100-106.
Campbell Nigel Anthony
Griffin David Antony John
Griffiths Peter James Lawrence
Judges Stephen Hugh
Roberts Michael David
Cognos Incorporated
Mizrahi Diane D
Mofiz Apu M
Shumaker & Sieffert PA
LandOfFree
Method of managing slowly changing dimensions does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method of managing slowly changing dimensions, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method of managing slowly changing dimensions will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3366497