 Method and apparatus for implementing a shared message queue using a list structure |
| In general, the present invention contemplates a method and apparatus for implementing a shared ... |
|
| Method and apparatus for erasing data after tampering |
| According to one aspect of the invention, a method is provided for storing data on a storage unit ... |
|
| Method, system, program, and data structure for cleaning a database table |
| OF THE PREFERRED EMBODIMENTS In the following description, reference is made to the accompanying ... |
|
| Hosting a network service on a cluster of servers using a single-address image |
| The present invention provides methods and apparatus for hosting a network service on a cluster of ... |
|
| Computer system for creating semantic object models from existing relational database schemas |
| The present invention is a computer system programmed to automatically create a semantic object ... |
|
| Integrated customer interface for web based data management |
| The present invention is directed to a Web-based, integrated customer interface system for data ... |
|
| Graphical user interface for relational database |
| Referring now to FIG. 1, there is illustrated a block diagram describing an exemplary computer ... |
|
|
Method and apparatus for transforming data
| Details |
Inventors: Weinberg, Paul N.; Lo, Wenphing; Liu, Zheng; Hazi, Ariel;
Assignee: SAP Aktiengesellschaft (Waldorf, DE)
Primary Examiner: Rimell; Sam
Assistant Examiner: Chojnacki; Mellissa M.
Attorney, Agent or Firm: Dalina Law Group P.C.
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. |
|
DETAILED DESCRIPTION Systems implementing the invention provide users with a set of tools for transforming data from databases.
When transforming data from a data source into a destination, the challenge resides in converting data attributes or values, and properly placing the data into the destination locations, while keeping data integrity.
Several challenges face a user while transforming data.
Among the challenges are data mapping.
The data to be transformed may reside in one more tables, the layout of which may differ from the data source to the receiving database.
The user may also have to solve a problem that arises when all source data values represented by the source data do not exist in distinct source data fields.
In this case the user may have to parse one or more source data values embedded within text description fields to extract the data.
The source tables and the destination tables, even having the same names, may not have a direct, one-to-one correspondence between source and destination fields.
In this case, it is not possible to map individual source and destination fields directly when the mapping relationship exists between the combination of two or more source fields and/or the combination of two or more destination fields and/or attributes; fields are be combined for mapping of field combinations rather than individual fields.
Embodiments implementing the invention provide solutions that facilitate transforming data from one or more data sources into one or more data destinations.
The method can also be used by a computer programer to enhance data exchange computer software.
The tools built using the invention allow users transforming the data to manipulate the data during the transform process using one or more of the following steps.
The steps comprise joining two or more tables from a source database, parsing data fields, mapping data fields from source tables into destination tables, defining new (or temporary) data fields, partitioning tables into sets according to data field values, merging data fields, transforming and matching both fields and field values
|
| Related patents |
|
|
Providing access to user interface elements of legacy application programs
An architecture is provided that enables an accessibility aid to directly access and manipulate user interface elements of an application program programmatically. M...
|
|
|
Translation of object queries involving inheritence
Join expressions, expressed in terms of objects, are translated into a relational database join statement by generating a parse tree based on the join expression. The ...
|
|
|
Method for accessing a memory unit in which sequences of notes are stored, corresponding memory unit and corresponding program
According to an aspect of the present invention, there is provided a simple method for accessing a memory unit in which a sequence of notes is stored, which method makes ...
|
|
|
Development system with application browser user interface
The present invention is embodied in a component-based, rapid application development (RAD) Java environment. The system's user interface is structured to increase one's ...
|
|
|
Multi-processor JAVA subsystem
OF THE INVENTION Reference will now be made in detail to the preferred embodiments of the invention, examples of which are illustrated in the accompanying drawings. W...
|
|
|
Context programming in object-oriented environments
The present invention is directed to control of time structured or other context related data by adding a context in object-oriented programming environments. In ...
|
|
|
Method, system, and program for mapping standard application program interfaces (APIs) to user interface APIs
OF THE PREFERRED EMBODIMENTS In the following description, reference is made to the accompanying drawings which form a part hereof, and which illustrate several ...
|
|
|
Method and apparatus for centralized management of a storage virtualization engine and data services
In accordance with the principles of the invention, an SVE control system uses management software at a central service processor to control data services and a storage ...
|
|
|
Prime implicates and query optimization in relational databases
The improved normalization methodology of the present invention is based on Socher's minimization methodology (see Socher, R., above). Socher's minimization method uses ...
|
|
|
Method for transmitting and displaying an interchannel interval image in a cable system
A system and method is provided for displaying an image in a cable system including a cable headend having a plurality of cable channels and a subscriber unit with a ...
|
|
|
Databases 
