发明申请
- 专利标题: METHOD AND APPARATUS FOR TRANSPORTING DATA FOR DATA WAREHOUSING APPLICATIONS THAT INCORPORATES ANALYTIC DATA INTERFACE
- 专利标题(中): 运输分析数据接口的数据仓库应用数据的方法和装置
-
申请号: US09877370申请日: 2001-06-07
-
公开(公告)号: US20060242160A1公开(公告)日: 2006-10-26
- 发明人: Firoz Kanchwalla , David Lyle , Sujit Bais , Srinivasan Maadapusi , Amol Dongre , Premkumar Somakumar
- 申请人: Firoz Kanchwalla , David Lyle , Sujit Bais , Srinivasan Maadapusi , Amol Dongre , Premkumar Somakumar
- 主分类号: G06F17/00
- IPC分类号: G06F17/00
摘要:
A method and apparatus for transporting data for a data warehousing application. Data is extracted from one or more source containing data having a standard data structure and is translated into data that contains meaningful business terms. The translated data is then stored. In the present embodiment, an analytic business component is operable for extracting data from the source, translating the extracted data and for storing the translated data into a staging area. The translated data is then processed to obtain data having a common structure. In the present embodiment, a source adapter processes the translated data to obtain data having a common structure. The data having a common structure is then transformed into a format suitable for loading into a data mart. In the present embodiment, an analytic data interface receives the data having a common structure and transforms the data for loading into a data warehouse. The data is then stored in a data warehouse.
公开/授权文献
信息查询