Integrated visual and language-based method for reusable data transformations

Abstract

A method deploys a set of coupled data transformation modules describing a data transformation, the data transformation for transforming a data structure from a first format to a second format. The method includes receiving an instruction for selecting the set of transformation modules from a memory; converting each of the set of transformation modules to a common model format, the set of modules having at least one transformation module being of a module type of a type set including language constructed modules and visually constructed modules; and generating an executable version of the converted transformation modules suitable for execution by a data transformation engine. The executable version, when executed, transforms the data structure from the first format to the second format.

Description

FIELD OF THE INVENTION[0001]The present invention relates to deployment environments for supporting the coexistence of a visual transformation and a language transformation architecture.BACKGROUND OF THE INVENTION[0002]Development of transformation applications involves multiple players and roles. On one hand, high level transformation scenarios are typically designed by business analysts. On the other hand, application implementation, with technical requirements such as performance, is typically handled by highly specialized application programmers or developers. These two types of players have diverse backgrounds, different perspectives of the problem domain, and often times very different programming skills. Their responsibilities are different, but they also must communicate with each other and work together to produce an efficient, scalable and maintainable transformation system.[0003]An environment based exclusively on visual transformation methods can provide all benefits ass...

AI Technical Summary

Benefits of technology

The present invention provides a programming and development environment that supports both visual and language-based methods of transforming data structures. This allows for seamless reuse of the transformation modules created by both methods. The invention also includes a method for deploying a set of coupled data transformation modules, a system for doing so, and a computer program product for implementing the method. The technical effect of this invention is improved flexibility and efficiency in data transformation, making it easier to develop and reuse data transformation modules.

Problems solved by technology

However, language based artifacts cannot take advantage of the visually developed artifacts.

There is no round trip since visual tools produce proprietary formatted artifacts that are not accessible to programming languages in the public domain.

When a transformation system is developed using visual tools, it is usually easier to prototype, but it is not optimal when the transformation load increases due to the inherent properties of visual programming.

However, it is harder to maintain as the complexity of the tool increases, and even experienced developers will need more time to ensure system integrity, since the effects of the change are harder to predict.

However, some complex scenarios are difficult or not possible to achieve using these visual tools alone.

Therefore, some of the optimizations that are possible using language based transformation modules are not feasible when using a graphical engine to generate the transformation modules used to perform the transformations of the data structures.

Images