Browse Prior Art Database

How to map an extra middle layer of data mediation in a two ontology graphical Mapping Tool

IP.com Disclosure Number: IPCOM000217965D
Publication Date: 2012-May-14
Document File: 5 page(s) / 123K

Publishing Venue

The IP.com Prior Art Database

Abstract

Disclosed is a solution to call an intermediate process, as a middle layer of data mediation in between the source and the target, such as calling a user-defined Relational Database Stored Procedure. The intermediate process, like a stored procedure, is neither a source nor a target, and it takes input data in input parameters, and returns output data in output parameters, return value, and result sets. The input data can be data from the incoming message, and the data returned from the stored procedure is passed to the outgoing message in the target.

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

Page 01 of 5

How to map an extra middle layer of data mediation in a two ontology graphical Mapping Tool

This invention provides a solution to map incoming message as input data to one or more Relational Database Stored Procedures for data transformation. In addition, the returned data from Stored Procedures can be mapped to outgoing messages during the Message Transformation process in an existing mapping paradigm.

The difficulty in providing a feature to call a Stored Procedure from the mapper comes in developing a method to present this function in a user-familiar mapping paradigm. Most graphical Data Mapping or Data Transformation Tools that can transform data from an incoming format to an outgoing format usually have only two ontologies, a source ontology, and a target ontology. There are two panes in the graphical editor to represent these two ontologies, one pane for the source message and the other pane for the target message. A user can simply drag and drop elements from the source message in the source pane to the target message in the target pane to create an element mapping. A connection line links the two elements in the source and the target to represent the mapping relationship.

Figure 1: Message Mapping Tool in an enterprise management messaging toolkit


1. Source Pane: displays source message


2. Target Pane: displays target message


3. Edit Pane: displays the expression to be used to derived the target element value

1


Page 02 of 5

4. Map Script Pane: displays a summary of the mappings for each target field and its value

Such a graphical tool is usually designed for two ontologies only, the source and the target. There is no third ontology in between the source and the target.

Figure: Two ontologies mapping model

This invention provides a solution to call an intermediate process, as a middle layer of data mediation in between the source and the target, such as calling a user-defined Relational Database Stored Procedure. The intermediate process, like a stored procedure, is neither a source nor a target, and it takes input data in input parameters, and returns output data in output parameters, return value, and result sets. The input data can be data from the incoming message, and the data returned from the stored procedure is passed to the outgoing message in the target.

Current systems with the ability to call a stored procedure have limitations. The stored procedure can only have input parameters. If the stored procedure returns any output parameters, return value, or result sets, they are all being ignored. The returned data cannot be retrieved and passed to the outgoing message in the target. This as a major limitation, because most stored procedures return some data, and this data needs to be mapped to the outgoing message; without such a capability, it is almost useless.

The disclosed invention does not have this limitation. It provides a solution to the existing mapping paradigm with which users are familiar.

This inventi...