Browse Prior Art Database

Sample-based ESQL Transformation Generation

IP.com Disclosure Number: IPCOM000014393D
Original Publication Date: 2000-Dec-01
Included in the Prior Art Database: 2003-Jun-19
Document File: 4 page(s) / 58K

Publishing Venue

IBM

Abstract

A large amount of application development today has the requirement of mapping data in one form to another. However, other than fairly simple transformations, it is often difficult to describe the transformation. Most solutions to describing the transformation require a programmer to write a "program" or script in a language such as XSL or ESQL. This invention provides a mechanism to generate this program or script that implements this transformation. It uses an example of the source input and an example of the target format that the user provides and finds patterns in it. From the patterns that it finds, it generates the "program" or script to create the target from the source. This invention takes a sample source and a target source that the user enters in a graphical user interface. The user interface then find the transformation script by applying certain rules to find the right transformation script. Figure 1 shows the process that the user goes through. transformation definition script

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 53% of the total text.

Page 1 of 4

Sample-based ESQL Transformation Generation

A large amount of application development today has the requirement of mapping data in one form to another. However, other than fairly simple transformations, it is often difficult to describe the transformation. Most solutions to describing the transformation require a programmer to write a "program" or script in a language such as XSL or ESQL.

This invention provides a mechanism to generate this program or script that implements this transformation. It uses an example of the source input and an example of the target format that the user provides and finds patterns in it. From the patterns that it finds, it generates the "program" or script to create the target from the source.

This invention takes a sample source and a target source that the user enters in a graphical user interface. The user interface then find the transformation script by applying certain rules to find the right transformation script. Figure 1 shows the process that the user goes through.

transformation definition script

sample source expected target

user provides at development time:

generated:

at runtime:

transformation generator

deploy

Figure 1. Process of taking a source message and a target message to create transformation definition script.

The user specifies a sample source and the expected ouput. The transfomation generator then generates a script or program that describes this transformation in general terms. This script or program is installed into the runtime and used to transform data in a form similar to the sample source into the appropriate form that resembles the expected target.

1

[This page contains 4 pictures or other non-text objects]

Page 2 of 4

As an example, let's assume that we want to take the source message and produce the target message. In this case there is logic that looks for patterns that: transform a compound message segment from "row-major" to "column-major" order. Often the message is to have "outside" tags moved inside and "inside" tags moved outside. For example a message may be of the form:

  <employee><name...