发明名称 HISTORICAL DATA WAREHOUSING SYSTEM
摘要 A method comprises obtaining data from a source system. Further, the obtained data is pre-processed by a stepwise operation to generate pre-processed data. The last operated upon data is recorded. In addition, the pre-processed data is transformed into subject-oriented data by utilizing reusable primary keys and Relational Database Management System dates in the source system to link related pre-processed data. Additionally, the subject-oriented data is stored in a data warehouse. The Relational Database Management System dates are utilized for distinctly characterizing the subject-oriented data when a plurality of tables containing data with duplicate primary keys are combined in the data warehouse.
申请公布号 US2007136330(A1) 申请公布日期 2007.06.14
申请号 US20060548652 申请日期 2006.10.11
申请人 发明人 LECHELER-MOORE RUTH;SERIO TOM;DUNHAM KIRVEN;RIGGS LARRY T.
分类号 G06F7/00;G06Q30/00 主分类号 G06F7/00
代理机构 代理人
主权项
地址