Method of managing slowly changing dimensions

Details Method of managing slowly changing dimensions Method of managing slowly changing dimensions

G - Physics

06

F

G06F 17/30 (2006.01)

Patent

CA 2311884

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 behaviour to each column of the dimension table. When a row of data is to be delivered to the dimension table, the table is searched for a record having the key value present in the row of data to be delivered. If such a record exists and any attributes of the row to be delivered have changed values compared with the existing record, the table is updated according to the behaviour type assigned to these attributes in the dimension template, either by updating the existing record or by creating a new record.

Affiliated with

Also associated with

Rating

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.

Rate now

Comments { 0 }

Profile ID: LFCA-PAI-O-1633298