Browse Prior Art Database

Approach For A Business User Consumable Data Mapper Application Disclosure Number: IPCOM000228647D
Publication Date: 2013-Jun-26

Publishing Venue

The Prior Art Database


Approach For A Business User Consumable Data Mapper Application

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 14% of the total text.

Page 01 of 18

Approach For A Business User Consumable Data Mapper Application

Known Solutions to Related Work:

The closest area of related work is Data Mapper Application available in Websphere Transformation Extender [7]. The data mapper interface available in WTX (Websphere Transformation Extender) is shown in Figure 1.

Figure 1: Data Mapper Interface for WebSphere Transformation Extender

Though the WTX data mapper is not targeted for the business users, their graphic user interface seem to have some similarities with the approach that we are proposing, so worth a comparison. Some points of differences between WTX, and what we do in our work.

1. WTX data mapper, allows the user to map between the source and target XML nodes without the need for drawing any connecting lines between them, instead they allow the users to enter a rule for each target XML node, which represents the source XML node that needs to be mapped. In our approach, the rules are automatically generated when the source node is dragged and dropped into the target XML node (which is a more convenient feature for a business user), and we also support mapping between nodes using rules.

2. In WTX data mapper, an already mapped node for a target node or a mapped node for a source node can only be identified by interpreting the rule specified in the rule column of the target node. This makes life difficult for the business users to interpret the already mapped node, especially when they want edit/modify the existing mapping. In our approach, we provide a feature of automatic highlighting of mapped node for a source/target node, which allows the business users to quickly navigate through the


Page 02 of 18

existing mapping and edit/modify them easily.

3. In WTX data mapper, the validation of mapping happens at the rule level, where the mapping rule is validated for its syntax, which verifies whether a valid source node is used for mapping. In our solution, we provide a context level validation for a node (which verifies whether such much will provide valid output), and provide appropriate alert/suggestion for the user that such mapping would result in invalid output.

4. Our approach includes a data column for the source and target, and we show results of the mapping on the fly by transforming the data from source node to target node based on the mapping specified by the user. WTX data mapper does not support any such feature.

5. WTX is purely a schema based data mapper, where as our approach is a hybrid model with supports both schema based mapping and instance based mapping.

In this section, we explain the design overview of the business data mapper and the user experience features with screenshots to demonstrate how we achieve business user consumability. Unique features of business data mapper are shown in the following sections as described below,

5.1 Hybrid Model for schema based mapping and instance based mapping

5.2 Generating Results on the Fly

5.3 Context Level Validatio...