Software, method and system for data connectivity and integration having transformation and exchange infrastructure

• US 20040019693A1
• Filed: 06/09/2003
• Published: 01/29/2004
• Est. Priority Date: 06/07/2002
• Status: Active Grant

• Current Assignee: Vorro, Inc.
• Original Assignee: Object Innovation, Inc. (The Cigna Group)
• Inventors: Beck, Paul Robert Jr., Sirdevan, Scott Michael, Ludke, Edward Reed, Sisco, Paul Allan, Grow, John Darwin, Caleraro, Matthew Aloysius
• Granted Patent: US 7,325,027 B2
• Time in Patent Office: Days
• US Class Current: 709/232
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: H04L 67/563 Data redirection of data network streams
• CPC Class Codes: H04L 67/565 Conversion or adaptation of application format or content adding application control or application functional data H04L67/561
• CPC Class Codes: H04L 67/62 Establishing a time schedule for servicing the requests
• CPC Class Codes: H04L 67/75 Indicating network or usage conditions on the user display
• CPC Class Codes: H04L 69/08 Protocols for interworking; Protocol conversion

Abstract

Software, methods, and system for data connectivity and integration having a transformation and exchange gateway are provided. The transformation and exchange gateway software is stored in a memory and has a mapper to map connection data path instructions, a plurality of inbound templates each to provide inbound data processing instructions for an inbound data set having an inbound data interchange protocol, at least one outbound template to provide outbound data processing instructions for an outbound data set having an outbound data interchange protocol different from the inbound data interchange protocol, and a data transformation and exchange engine in communication with the mapper to locate a data path and determine a select one of the plurality of inbound templates to use for inbound data processing instructions, in communication with the select one of the plurality of inbound templates to process the inbound data set responsive to the inbound data processing instructions of the select one of the plurality of inbound templates and thereby transform the inbound data set to the outbound data set, and in communication with the at least one outbound template to send the outbound data set with the outbound data interchange protocol responsive to the outbound data processing instructions of the at least one outbound template.

Claims

1. A system for data connectivity and integration, the system comprising:

a first computer defining a first server, the first server having a first memory, a first data set stored therein, and a first data interchange protocol;

a first area network in communication with the server;

a plurality of remote data terminals in communication with the first server through the first area network by the first data interchange protocol, at least one remote data terminal of the plurality of remote data terminals having data terminal memory associated therewith;

a second area network in communication with the first server and the at least one remote data terminals;

a second computer remote from the first server, in communication with the second area network, and defining a second server, the second server having a second memory, a second data set stored therein, and a second data interchange protocol;

a third computer remote from the first server, in communication with the second area network, and defining a third server, the third server having memory, a third data set stored therein and a third data interchange protocol; and

transformation and exchange gateway software stored in data terminal memory of one of the plurality of remote data terminals, having an output in communication with the first server through the first area network by the first data interchange protocol and having an input in communication with the second server through the second area network by the second data interchange protocol and in communication with the third server through the second area network by the third data interchange protocol to transform each of the second and third data interchange protocols to the first data interchange protocol so that the respective second and third data sets can be effectively communicated to the first server through the transformation and exchange gateway software and be in the first data interchange protocol for effective use by the plurality of remote terminals and to transform the first data interchange protocol to the respective second and third data interchange protocols so that first data set can be communicated from the first server to the second and third servers so that the second and third servers for effective use thereby.

2. A system as defined in claim 1, wherein the transformation and exchange gateway software further has a plurality of inbound templates defining the input positioned in communication with the second and third servers to selectively define the respective second and third data interchange protocols prior to receiving inbound data and at least one outbound template defining the output positioned in communication with the plurality of remote terminals to selectively define the first data interchange protocol prior to sending outbound data.

3. A system as defined in claim 2, wherein the transformation and exchange gateway software further includes a mapper to map connection data path instructions to the second and third servers.

4. A system as defined in claim 3, wherein the transformation and exchange gateway software includes a data transforming and exchanging engine in communication with the mapper to locate a data path and determine a select one of the plurality of inbound templates to use for inbound data processing instructions, in communication with the select one of the plurality of inbound templates to process the inbound data set responsive to the inbound data processing instructions of the select one of the plurality of inbound templates and thereby transform the inbound data set to the outbound data set, and in communication with the at least one outbound template to send the outbound data set with the outbound data interchange protocol responsive to the outbound data processing instructions of the at least one outbound template.

5. A system as defined in claim 4, wherein the transformation and exchange gateway software further comprises a scheduler in communication with the mapper to schedule timing for making a connection to the second and third servers having the inbound data set and connection instructions to connect to the second and third servers having the inbound data set.

6. A system as defined in claim 4, wherein the transformation and exchange gateway software further comprises a set of graphical user interface (GUI) tools in communication with the data transformation and exchange engine to interface with a user, the GUI tools including an inbound template GUI to select the inbound data processing instructions and thereby define parameters for the inbound data set and an outbound template GUI to select the outbound data processing instructions and thereby define parameters for the outbound data set.

7. Transformation and exchange gateway software stored in a first memory, the software comprising:

a mapper to map connection data path instructions;

a plurality of inbound templates each to provide inbound data processing instructions for an inbound data set having an inbound data interchange protocol;

at least one outbound template to provide outbound data processing instructions for an outbound data set having an outbound data interchange protocol different from the inbound data interchange protocol; and

a data transformation and exchange engine in communication with the mapper to locate a data path and determine a select one of the plurality of inbound templates to use for inbound data processing instructions, in communication with the select one of the plurality of inbound templates to process the inbound data set responsive to the inbound data processing instructions of the select one of the plurality of inbound templates and thereby transform the inbound data set to the outbound data set, and in communication with the at least one outbound template to send the outbound data set with the outbound data interchange protocol responsive to the outbound data processing instructions of the at least one outbound template.

8. Software as defined in claim 7, further comprising a scheduler in communication with the mapper to schedule timing for making a connection to an entity having the inbound data set and connection instructions to connect to the entity having the inbound data set.

9. Software as defined in claim 7, further comprising a set of graphical user interface (GUI) tools in communication with the data transformation and exchange engine to interface with a user, the GUI tools including an inbound template GUI to select the inbound data processing instructions and thereby define parameters for the inbound data set and an outbound template GUI to select the outbound data processing instructions and thereby define parameters for the outbound data set.

10. A method of data interchanges, the method comprising:

receiving an inbound data set having a first data interchange protocol;

processing the inbound data set responsive to inbound data processing instructions to thereby transform the inbound data set into an outbound data set having a second data interchange protocol different from the first data interchange protocol; and

sending the outbound data set having the second data interchange protocol.