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

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