Title:
A METHOD AND APPARATUS FOR TRANSFORMING DATA
Document Type and Number:
WIPO Patent Application WO2002047463
Kind Code:
A3
Abstract:
Embodiments of the invention comprise a method and apparatus for transforming data. Systems implementing the invention allow for loading the data from one or more source tables into one or more destination tables. The system allows for parsing source data fields, defining new source data fields, combining source fields to create source field combinations, and combining destination fields to create destination field combinations. The system allows for mapping source fields and values to destination fields and values, where either the source fields and values or destination fields and values may be field and value combinations, and allows for transforming field values based on destination field type. The tools provided in a system implementing the invention provide a user the ability to intervene at each step during the data transform task. A user may manually input a hierarchy definition, a specific mapping, define rules for combining data fields, or define rules for converting data values.
Inventors:
WEINBERG PAUL N
LO WENPHING
LIU ZHENG
HAZI ARIEL
LO WENPHING
LIU ZHENG
HAZI ARIEL
Application Number:
PCT/US2001/048573
Publication Date:
October 03, 2002
Filing Date:
December 12, 2001
Export Citation:
Assignee:
A2I INC (US)
International Classes:
G06F17/30; (IPC1-7): G06F13/14; G06F15/16; G06F15/17; H04L9/00
Foreign References:
| US5867712A | 1999-02-02 | |||
| US6141658A | 2000-10-31 | |||
| US5745758A | 1998-04-28 |
Download PDF: