WO2002047463A3 - A method and apparatus for transforming data - Google Patents

A method and apparatus for transforming data Download PDF

Info

Publication number
WO2002047463A3
WO2002047463A3 PCT/US2001/048573 US0148573W WO0247463A3 WO 2002047463 A3 WO2002047463 A3 WO 2002047463A3 US 0148573 W US0148573 W US 0148573W WO 0247463 A3 WO0247463 A3 WO 0247463A3
Authority
WO
Grant status
Application
Patent type
Prior art keywords
fields
source
data
values
destination
Prior art date
Application number
PCT/US2001/048573
Other languages
French (fr)
Other versions
WO2002047463A2 (en )
Inventor
Ariel Hazi
Zheng Liu
Wenphing Lo
Paul N Weinberg
Original Assignee
A2I Inc
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/30Information retrieval; Database structures therefor ; File system structures therefor
    • G06F17/30286Information retrieval; Database structures therefor ; File system structures therefor in structured data stores
    • G06F17/30557Details of integrating or interfacing systems involving at least one database management system
    • G06F17/30569Details of data format conversion from or to a database

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.
PCT/US2001/048573 2000-09-20 2001-12-12 A method and apparatus for transforming data WO2002047463A3 (en)

Priority Applications (6)

Application Number Priority Date Filing Date Title
US25556000 true 2000-12-12 2000-12-12
US60/255,560 2000-12-12
US09960902 US6910044B2 (en) 2000-09-20 2001-09-20 Method and apparatus for structuring, maintaining, and using families of data
US09960541 US7143339B2 (en) 2000-09-20 2001-09-20 Method and apparatus for dynamically formatting and displaying tabular data in real time
US09/960,902 2001-09-20
US09/960,541 2001-09-20

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
AU4163502A AU4163502A (en) 2000-12-12 2001-12-12 A method and apparatus for transforming data

Publications (2)

Publication Number Publication Date
WO2002047463A2 true WO2002047463A2 (en) 2002-06-20
WO2002047463A3 true true WO2002047463A3 (en) 2002-10-03

Family

ID=27400870

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2001/048573 WO2002047463A3 (en) 2000-09-20 2001-12-12 A method and apparatus for transforming data

Country Status (1)

Country Link
WO (1) WO2002047463A3 (en)

Families Citing this family (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7133878B2 (en) 2002-03-21 2006-11-07 Sap Aktiengesellschaft External evaluation processes
US7031787B2 (en) 2002-03-21 2006-04-18 Sap Aktiengesellschaft Change management
US7509326B2 (en) 2002-09-03 2009-03-24 Sap Ag Central master data management
US8438238B2 (en) 2002-10-16 2013-05-07 Sap Ag Master data access
US7236973B2 (en) 2002-11-27 2007-06-26 Sap Aktiengesellschaft Collaborative master data management system for identifying similar objects including identical and non-identical attributes
US7152072B2 (en) * 2003-01-08 2006-12-19 Fisher-Rosemount Systems Inc. Methods and apparatus for importing device data into a database system used in a process plant
US9691053B1 (en) 2003-02-13 2017-06-27 Sap Se System and method of master data management
US7930149B2 (en) 2003-12-19 2011-04-19 Sap Aktiengesellschaft Versioning of elements in a configuration model
US7272776B2 (en) 2003-12-30 2007-09-18 Sap Aktiengesellschaft Master data quality
US9928283B2 (en) 2013-04-15 2018-03-27 Validus Solutions, Inc. Tracing data through a transformation process using tracer codes

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5745758A (en) * 1991-09-20 1998-04-28 Shaw; Venson M. System for regulating multicomputer data transfer by allocating time slot to designated processing task according to communication bandwidth capabilities and modifying time slots when bandwidth change
US5867712A (en) * 1993-04-05 1999-02-02 Shaw; Venson M. Single chip integrated circuit system architecture for document instruction set computing
US6141658A (en) * 1997-09-10 2000-10-31 Clear With Computers, Inc. Computer system and method for managing sales information

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5745758A (en) * 1991-09-20 1998-04-28 Shaw; Venson M. System for regulating multicomputer data transfer by allocating time slot to designated processing task according to communication bandwidth capabilities and modifying time slots when bandwidth change
US5867712A (en) * 1993-04-05 1999-02-02 Shaw; Venson M. Single chip integrated circuit system architecture for document instruction set computing
US6141658A (en) * 1997-09-10 2000-10-31 Clear With Computers, Inc. Computer system and method for managing sales information

Also Published As

Publication number Publication date Type
WO2002047463A2 (en) 2002-06-20 application

Similar Documents

Publication Publication Date Title
EP0817025A3 (en) Data structures and method for implementing subcontracts in a distributed object oriented system
USD368283S (en) Set of front faces for tarot cards
WO2002021662A2 (en) Battery monitoring network
Roe Critical theory, sustainable development and populism
Lou Deformations of the Riccati equation by using Miura-type transformations
GB2419711B (en) System and method for information handling system image network communication
WO2001058178A3 (en) Set of equipment for the supplementation and forwarding of text messages
WO2003001697A3 (en) Reducing the peak-to-average power ratio of a communication sign al
WO2002011344A3 (en) Parameterized graphs with conditional components
JPH04119386A (en) Enciphered code conversion system
CA2446539A1 (en) System and method for electronic presentations
JPH04373060A (en) Batch job input number limiting system
WO2005065182A3 (en) Optical retarders and related devices and systems
Grimm et al. REGULAR VARIATION AND SOLUTIONS OF SECOND ORDER DD'FERENTIAL EQUATIONS
Evans et al. UK experiences in implementing concurrent engineering
Davis Knowledge is power
WO2005027800A3 (en) Revisable prosthetic device
Grosek et al. Graphs connected with block ciphers.
CA2669479A1 (en) Generating end-user presentations from structured data
JPH04239224A (en) Quantizer
Omar The Malay Lost World

Legal Events

Date Code Title Description
AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): GH GM KE LS MW MZ SD SL SZ TZ UG ZM ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE TR BF BJ CF CG CI CM GA GN GQ GW ML MR NE SN TD TG

AK Designated states

Kind code of ref document: A2

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG UZ VN YU ZA ZW

AL Designated countries for regional patents

Kind code of ref document: A3

Designated state(s): GH GM KE LS MW MZ SD SL SZ TZ UG ZM ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE TR BF BJ CF CG CI CM GA GN GQ GW ML MR NE SN TD TG

AK Designated states

Kind code of ref document: A3

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG UZ VN YU ZA ZW

121 Ep: the epo has been informed by wipo that ep was designated in this application
DFPE Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101)
REG Reference to national code

Ref country code: DE

Ref legal event code: 8642

122 Ep: pct application non-entry in european phase
NENP Non-entry into the national phase in:

Ref country code: JP

WWW Wipo information: withdrawn in national office

Country of ref document: JP