Online Analytical Mining for Web Access Patterns - Advanced Topics in Database Research - page 312

To be updated fact table update δR (data to be updated to R FACT )

Target Page Date CPB CFP FP Count(CPB) Count(CFP) Count(FP) Duration
T2 Date2 Path 4 Path 5 Path 6 C4 C5 C6 D2

Target Page Month CPB CFP FP Count(CPB) Count(CFP) Count(FP) Duration
T2 Month2 Path 4 Path 5 Path 6 C4 C5 C6 D2

Target Page Year CPB CFP FP Count(CPB) Count(CFP) Count(FP) Duration
T2 Year2 Path 4 Path 5 Path 6 C4 C5 C6 D2

If T1 = T2, Date If If T1 = T2, Date 1 = Date2, Path 1 = Path 4, Path 2 = Path 5, and Path 3 = Path 6, then R FACT become:

Updated fact FACT (R FACT after updated) (Date)
Target Page Date CPB CFP FP Count(CPB) Count(CFP) Count(FP) Duration
T1

Updated fact table R' Updated fact table R'

Date1 Path 1 Path 2 Path 3 C1 + C4 C2 + C5 C3 + C6 D1 + D2

If they are not equal, it can be simply inserted the new records in the fact table directly.
Target Page Date CPB CFP FP Count(CPB) Count(CFP) Count(FP) Duration
T1

Date1 Path 1 Path 2 Path 3 C1 C2 C3 D1

T2 Date2 Path 4 Path 5 Path 6 C4 C5 C6 D2

If T1 = T2, If Month1 = Month2, Path 1 = Path 4, Path 2 = Path 5, and Path 3 = Path 6, then R FACT become:

Updated fact FACT (R FACT after updated) (Month)
Target Page Month CPB CFP FP Count(CPB) Count(CFP) Count(FP) Duration
T1

Updated fact table R' Updated fact table R'

Month1 Path 1 Path 2 Path 3 C1 + C4 C2 + C5 C3 + C6 D1 + D2

If they are not equal, it can be simply inserted the new records in the fact table directly.
Target Page Month CPB CFP FP Count(CPB) Count(CFP) Count(FP) Duration
T1

Month1 Path 1 Path 2 Path 3 C1 C2 C3 D1

T2 Month2 Path 4 Path 5 Path 6 C4 C5 C6 D2

If T1 = T2, If Year Y ea Y 1 = Year2, Path 1 = Path 4, Path 2 = Path 5, and Path 3 = Path 6, then R FACT become:

Updated fact FACT (R FACT after updated) (Year)
Target Page Year CPB CFP FP Count(CPB) Count(CFP) Count(FP) Duration
T1

Updated fact table R' Updated fact table R'

Year1 Path 1 Path 2 Path 3 C1 + C4 C2 + C5 C3 + C6 D1 + D2

If they are not equal, it can be simply inserted the new records in the fact table directly.
Target Page Year CPB CFP FP Count(CPB) Count(CFP) Count(FP) Duration
T1 Year Y ea Y 1 Path 1 Path 2 Path 3 C1 C2 C3 D1

T2 Year2 Path 4 Path 5 Path 6 C4 C5 C6 D2