Invention Grant
US08504513B2 Auto-generation of code for performing a transform in an extract, transform, and load process
有权
自动生成用于在提取，转换和加载过程中执行变换的代码
- Patent Title: Auto-generation of code for performing a transform in an extract, transform, and load process
- Patent Title (中): 自动生成用于在提取，转换和加载过程中执行变换的代码
-
Application No.: US12625573Application Date: 2009-11-25
-
Publication No.: US08504513B2Publication Date: 2013-08-06
- Inventor: Vijaykumar K Aski , Danny Chen
- Applicant: Vijaykumar K Aski , Danny Chen
- Applicant Address: US WA Redmond
- Assignee: Microsoft Corporation
- Current Assignee: Microsoft Corporation
- Current Assignee Address: US WA Redmond
- Agency: Hope Baldauff Hartman, LLC
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00
Abstract:
A mapping is received and stored that maps elements of a data warehouse to types of a type system implemented by a data source. Program code is generated that performs a transform of data retrieved from a data source based on the mapping. Generation of the program code may include generating program code for performing a dimension transform based on the mapping, generating program code for performing a fact transform based on the mapping, and generating program code for performing an outrigger transform based on the mapping. The generated program code may then be executed to transform the data retrieved from the data source prior to loading into the data warehouse.
Public/Granted literature
- US20110125705A1 AUTO-GENERATION OF CODE FOR PERFORMING A TRANSFORM IN AN EXTRACT, TRANSFORM, AND LOAD PROCESS Public/Granted day:2011-05-26
Information query
