DATA TRANSFORMATION AND EXCHANGE

• US 20090119416A1
• Filed: 08/06/2008
• Published: 05/07/2009
• Est. Priority Date: 08/07/2007
• Status: Active Grant

• Current Assignee: Vorro, Inc.
• Original Assignee: Bridgegate Internationa LLC
• Inventors: Carlson, William, Barber, Charles, Slater, David, King, Ronnie E. II, Beck, Paul Robert JR., SIRDEVAN, Scott Michael, Sirdevan, Terry Lee, Workman, Jason, Schott, Zane, Sisco, Paul Allan, Grow, John Darwin, Calderaro, Matthew Aloysius
• Granted Patent: US 8,296,461 B2
• Time in Patent Office: Days
• US Class Current: 709/246
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: H04L 67/62 Establishing a time schedule for servicing the requests
• CPC Class Codes: H04L 69/08 Protocols for interworking; Protocol conversion

Abstract

A data transformation and exchange server receives an input data stream from one or more application servers and/or computing devices. The data stream includes a plurality of input records and each input record can be in a different input protocol and/or character encoding. The transformation and exchange server determines each input record in the input data stream based on one or more boundary points and determines a template from a plurality of templates based on the input record. The transformation and exchange server transforms the input record into an output record based on the template and communicates the output record via an output data stream.

Claims

1. A method for data transformation and exchange, comprising:

determining an input record based on one or more boundary points in an input data stream;

determining a template from a plurality of templates based on the input record;

transforming the input record to an output record based on the template; and

communicating the output record via an output data stream.

2. The method of claim 1, further comprising designating one or more boundary points in the input data stream based on data type information, a data validation rule, a data inbound template, a data outbound template, or any combination thereof.

3. The method of claim 1, further comprising:

receiving the input data stream; and

communicating the output data stream in or substantially in real-time as the input data stream is received.

4. The method of claim 1, further comprising communicating the output data stream based on a predetermined schedule.

5. The method of claim 1, further comprising:

receiving a communication failure notification associated with the output data stream; and

communicating the output data stream based on quality of service information and the communication failure notification.

6. The method of claim 1, further comprising communicating the output data stream based on dynamically generated information associated with the output data stream.

7. The method of claim 1, further comprising:

determining one or more data validation rules based on the input record and one or more data validation templates; and

determining data type information based on the input record and one or more data type templates.

8. The method of claim 7, further comprising the transforming the input record to the output record further based on the one or more data validation rules, the data type information, the template, or any combination thereof.

9. The method of claim 7, wherein the one or more data validation rules and the data type information are determined independently.

10. The method of claim 1, further comprising:

iterating through at least one data field in the input record based on the template;

selecting data from the at least one data field in the input record based on the template; and

storing the data in a searchable format based on the template.

11. The method of claim 1, further comprising:

selecting at least one data field in the input record, the output record, or both based on a business activity monitor rule;

comparing the selected one or more data fields to at least one threshold value; and

transmitting a notification communication based on the comparison of the selected one or more data fields, the notification communication generated based on the comparison.

12. The method of claim 1, further comprising:

generating an accessible log of actions applied to the input record, output record, or both; and

providing an in-process report of the actions applied to the input record, output record, or both.

13. The method of claim 1, further comprising:

aggregating data from selected fields of one or more input records associated with a plurality of transactions to obtain an aggregated value;

comparing the aggregated value to a threshold value; and

transmitting a notification communication based on the comparison of the aggregated value to the threshold value, the notification communication generated based on the comparison.

14. The method of claim 1, further comprising:

aggregating data from selected fields of one or more input records associated with a plurality of transactions to obtain an aggregated value; and

displaying the aggregated value on a computing device.

15. The method as defined in claim 1, further comprising determining for each of a plurality of fields within the input record a first character encoding for decoding data associated with the field.

16. The method as defined in claim 15, further comprising determining a second character encoding for decoding data associated with a second field within the input record.

17. The method of claim 1, wherein the input record utilizes a first protocol and the output record utilizes a second protocol.

18. The method of claim 1, wherein the input record and the output record utilize a same protocol, the input record comprises a first set of data fields, the output record comprises a second set of data fields, and the first set of data fields is different from the second set of data fields.

19. The method of claim 1, wherein the template comprises a plurality of references to a server and further comprising automatically modifying the plurality of references to the server via a single configuration modification.

20. The method of claim 1, further comprising:

providing a user interface to modify one or more templates from the plurality of templates; and

modifying the one or more templates from the plurality of templates based on information received via the user interface and associated with a protocol.

21. A computer readable medium embodying computer program product for performing data processing, the computer program product, when executed by a computer, causing the computer to perform the steps of:

determining an input record based on one or more boundary points in an input data stream;

determining a template from a plurality of templates based on the input record;

transforming the input record to an output record based on the template; and

communicating the output record via an output data stream.

22. A data transformation and exchange system, comprising:

a data boundary module for determining an input record based on one or more boundary points in an input data stream;

a template selection module for determining a template from a plurality of templates based on the input record; and

a transformation module for transforming the input record to an output record based on the template and communicating the output record via an output data stream.

23. The system of claim 22, further comprising:

a data validation module for determining one or more data validation rules based on the input record and one or more data validation templates; and

a data type module for determining data type information based on the input record and one or more data type templates.

24. The system of claim 22, further comprising:

a storage analysis module for iterating through at least one data field in the input record based on the template and selecting data from the at least one data field in the input record based on the template; and

a storage module for storing the data in a searchable format based on the template.

25. The system of claim 22, further comprising:

a business activity monitor module for;

selecting at least one data field in the input record, the output record, or both based on a business activity monitor rule;

comparing the selected one or more data fields to at least one threshold value; and

transmitting a notification communication based on the comparison of the selected one or more data fields, the notification communication generated based on the comparison.

26. The system of claim 22, further comprising:

a compare module for aggregating data from selected fields of one or more input records associated with a plurality of transactions to obtain an aggregated value and comparing the aggregated value to a threshold value; and

a notification module for transmitting a notification communication based on the comparison of the aggregated value to the threshold value, the notification communication generated based on the comparison.

27. The system of claim 22, further comprising:

a compare module for aggregating data from selected fields of one or more input records associated with a plurality of transactions to obtain an aggregated value; and

a notification module for displaying the aggregated value on a computing device.