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

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 (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP1523716A2 (en) 2002-03-21 2005-04-20 SAP Aktiengesellschaft Synchronizing users on shared data with locks
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
Miller Exponentiation is hard to avoid
CA2252021A1 (en) Method and apparatus for input of data
O'Neill et al. On the existence of discrete Wigner distributions
WO2001065359A3 (en) Method and apparatus for building a memory image
Wagon A bound on the chromatic number of graphs without certain induced subgraphs
Bellen Preservation of superconvergence in the numerical integration of delay differential equations with proportional delay
Bogomolny et al. Distribution of eigenvalues of certain matrix ensembles
JPS5617461A (en) Picture data coding system
Schechter Integration over a polyhedron: an application of the Fourier-Motzkin elimination method
USD473586S1 (en) Type font
DE20009411U1 (en) Milling tool, in particular for use in the cosmetic or medical field
WO2004003696A3 (en) Aircraft communication distribution system
DE3134328A1 (en) Method for operating a PCM system and for operating a memory storing PCM signals
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
Scott et al. Duality of a nonconvex sum of ratios
DE20109184U1 (en) Storage furniture, especially office equipment, fitting for this purpose, and hereby built furniture system
JPS58125172A (en) Specification editing device
Ylinen The structure of bounded bilinear forms on products of 𝐶*-algebras
WO2003001697A3 (en) Reducing the peak-to-average power ratio of a communication sign al
KR970071695A (en) An audio coding method and an audio encoder using the same bit rate is adjustable
DE20120493U1 (en) Device for in vitro generation of abrasion particles on implant surfaces
JPH04214143A (en) Air-conditioning system
WO2002011344A3 (en) Parameterized graphs with conditional components
USD474803S1 (en) Type font

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