Invention Grant
- Patent Title: System and method for processing and analyzing dimension data
- Patent Title (中): 用于处理和分析尺寸数据的系统和方法
-
Application No.: US12766071Application Date: 2010-04-23
-
Publication No.: US08626790B2Publication Date: 2014-01-07
- Inventor: Asha Kiran Potdar , Harikrishna Raghumandala , John Vernale
- Applicant: Asha Kiran Potdar , Harikrishna Raghumandala , John Vernale
- Applicant Address: US CT Hartford
- Assignee: Hartford Fire Insurance Company
- Current Assignee: Hartford Fire Insurance Company
- Current Assignee Address: US CT Hartford
- Agency: Howard IP Law Group, PC
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A processor is operated to combine a first row of a dimension table in a data warehouse with a second row in the dimension table. The result is a combined row that includes a row identification key for the first row and a row identification key for the second row. The row identification key for the first row joins the combined row to fact data from a prior time period. The second row corresponds to a current time period that is later than the prior time period. The processor is also operated to join at least a portion of the combined row to at least a portion of the corresponding row in a fact table associated with the dimension table. The fact data from the prior time period is included in the corresponding row in the fact table.
Public/Granted literature
- US20110264618A1 SYSTEM AND METHOD FOR PROCESSING AND ANALYZING DIMENSION DATA Public/Granted day:2011-10-27
Information query