Invention Grant
US07676478B2 Data warehousing systems and methods having reusable user transforms
有权
数据仓库系统和方法具有可重用的用户转换
- Patent Title: Data warehousing systems and methods having reusable user transforms
- Patent Title (中): 数据仓库系统和方法具有可重用的用户转换
-
Application No.: US11497782Application Date: 2006-08-02
-
Publication No.: US07676478B2Publication Date: 2010-03-09
- Inventor: Nancy A. Rausch
- Applicant: Nancy A. Rausch
- Applicant Address: US NC Cary
- Assignee: SAS Institute Inc.
- Current Assignee: SAS Institute Inc.
- Current Assignee Address: US NC Cary
- Agency: Jones Day
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00

Abstract:
Data warehousing systems and methods are described herein. In one example methodology, a plurality of transformation templates are stored in a transformation library, each transformation template including software objects that describe how to transform extracted data prior to loading the data into the data warehouse. A unique identifier may be associated with each of the plurality of transformation templates. Using this unique identifier, an instance of at least one of the plurality of transformation templates may be instantiated into a data transformation process by mapping the software objects of the transformation template into the instance of the transform using code segments. The code segments of the data transformation process are then executed to transform and load the extracted data into the data warehouse.
Public/Granted literature
- US20070174308A1 Data warehousing systems and methods having reusable user transforms Public/Granted day:2007-07-26
Information query