Data stream converter

• US 9,721,037 B2
• Filed: 10/07/2016
• Issued: 08/01/2017
• Est. Priority Date: 09/15/2000
• Status: Expired due to Fees

• Current Assignee: Hartford Fire Insurance Company (The Hartford Financial Services Group, Inc.)
• Original Assignee: Hartford Fire Insurance Company (The Hartford Financial Services Group, Inc.)
• Inventors: Price, David K., Plante, David F., Duffy, Michael O.
• Primary Examiner(s): Fleurantin, Jean B
• Application Number:
  US15/330,555
• Publication Number:
  US 20170039294A1
• Time in Patent Office: 298 Days
• Field of Search: 707635, 707756, 707760, 707778, 707791, 707792, 707797, 707798, 707803, 715234, 715239, 715249
• CPC Class Codes: G06F 16/24568 Data stream processing; Continuous queries
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/282 Hierarchical databases, e.g. IMS, LDAP data stores or Lotus Notes
• CPC Class Codes: G06F 16/40 of multimedia data, e.g. slideshows comprising image and additional audio data retrieval of still image data G06F16/50; retrieval of audio data G06F16/60; retrieval of video data G06F16/70
• CPC Class Codes: G06F 16/84 Mapping; Conversion
• CPC Class Codes: G06F 16/986 Document structures and storage, e.g. HTML extensions
• CPC Class Codes: G06F 40/143 Markup, e.g. Standard Generalized Markup Language [SGML] or Document Type Definition [DTD]
• CPC Class Codes: G06F 40/154 Tree transformation for tree-structured or markup documents, e.g. XSLT, XSL-FO or stylesheets
• CPC Class Codes: G06Q 40/08 Insurance
• CPC Class Codes: H04L 65/75 Media network packet handling
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]

Abstract

A method and system for converting XML files to and from files in a data format based on hierarchies in real-time. A method for converting from XML to the data format based on hierarchies includes: applying a stylesheet to at least one XML file thereby generating at least one data record in an intermediate format and including information included in the at least one XML file; and, translating the at least one record in the intermediate format to the data format based on hierarchies. A method for converting from a data format based on hierarchies to XML includes: translating at least one record including information stored in the file format based on hierarchies to an intermediate format; and, applying a stylesheet to the at least one record in the intermediate format thereby generating at least one XML file being indicative of the information and suitable for transmission.

Claims

1. A computer-implemented method for converting a received data stream from XML (Extensible Markup Language) format to an electronic data interchange (EDI) format, the EDI format being based on hierarchies, the method being executed by one or more processors, comprising:

by a first computer system, receiving a data stream in XML format, the data stream including a transaction type identifier;

by the first computer system, accessing a first translation tool corresponding to the transaction type identifier, and, using the accessed first translation tool, translating the received data stream to an intermediate data format having a plurality of tags, the tags incorporating sequence data, including one or more tags incorporating group delimiters and one or more tags incorporating transaction group identifiers;

by the first computer system, accessing a second translation tool corresponding to the transaction type identifier, and translating the data stream in the intermediate data format to the EDI format based on hierarchies, employing the sequence data to format the data in the EDI format based on hierarchies, the formatting of the data stream in the EDI format based on hierarchies including arranging of alphanumeric data elements independent of font, and designation of delimiter data groups and transaction data groups arranged between the delimiter data groups using the one or more of the group delimiters and transaction group identifiers; and

by the first computer system, providing the data stream in the EDI format based on hierarchies for output to a computing device.

2. The computer-implemented method of claim 1, wherein the first translation tool is a stylesheet.

3. The computer-implemented method of claim 2, wherein the stylesheet is an XSL (Extensible Stylesheet Language) stylesheet.

4. The computer-implemented method of claim 1, wherein the converting to the EDI format based on hierarchies further comprises employing sequence index and length data of the sequence data to format the data in the EDI format based on hierarchies.

5. The computer-implemented method of claim 1, wherein at least one of the tags incorporating sequence data comprises length data.

6. The computer-implemented method of claim 1, wherein the EDI format based on hierarchies is an AL3 format.

7. The computer-implemented method of claim 1, wherein the translating to the EDI format based on hierarchies further comprises removing the tags.

8. A computer interface system for converting a data stream from XML (Extensible Markup Language) format to an EDI (Electronic Data Interchange) format based on hierarchies, comprising:

a first computer system connected to a computer network and configured for bi-directional communication of data over the computer network, the first computer system comprising one or more processors and configured to;

receive a data stream including a transaction type identifier in XML format;

access a first translation tool corresponding to the transaction type identifier, and, using the accessed first translation tool, translate the received data stream to an intermediate data format having a plurality of tags, the tags incorporating sequence data, including one or more tags incorporating group delimiters and one or more tags incorporating transaction group identifiers;

translate, using a second translation tool, the data stream from the intermediate data format to the EDI format based on hierarchies, employing the sequence data to format the data in the EDI format based on hierarchies, the formatting of the data in the EDI format based on hierarchies including arrangement of alphanumeric data elements independent of font and designation of delimiter data groups and transaction data groups arranged between the delimiter data groups using the one or more of the group delimiters and transaction group identifiers; and

provide the data in the EDI format for output to a further computing device.

9. The computer interface system of claim 8, wherein the first translation tool specifies a presentation of a class of XML documents.

10. The computer interface system of claim 9, wherein the first translation tool is a stylesheet.

11. The computer interface system of claim 8, wherein the EDI format based on hierarchies further comprises data elements, data groups being logical groupings of the data elements and hierarchies establishing logical relationships among the data groups.

12. The computer interface system of claim 8, wherein the translating to the EDI format based on hierarchies further comprises employing sequence index and length data of the sequence data to format the data in the EDI format based on hierarchies.

13. A computer-implemented method for converting data formatted based on hierarchies to XML (Extensible Markup Language) format data, the method being executed by one or more processors, comprising:

by a first computer system, receiving a data stream in an EDI (Electronic Data Interchange) format based on hierarchies, the data stream including a transaction type identifier, delimiter data groups and transaction data groups arranged between the delimiter data groups;

by the first computer system, accessing a translation tool, and using the accessed translation tool to translate the data stream to an intermediate data format having tags incorporating transaction type identifier data, sequence data and delimiter data group data, wherein the sequence data of at least one of the tags incorporating sequence data comprises data group name and length data;

by the first computer system, accessing a second translation tool, corresponding to the transaction type identifier, and, using the second translation tool, converting the received data in the intermediate data format having tags to XML format, employing the data group name and length data of the sequence data to format the data in XML format, the formatting of the data in XML format including tags and arrangements of alphanumeric data elements independent of font; and

providing, by the first computer system, the XML formatted data as an output.

14. The computer-implemented method of claim 13, wherein the second translation tool is a stylesheet.

15. The computer-implemented method of claim 14, wherein the stylesheet is an XSL (Extensible Stylesheet Language) stylesheet.

16. The computer-implemented method of claim 13, wherein the received data stream is in AL3 EDI format.

17. The computer-implemented method of claim 13, further comprising receiving the XML format data output at a web server, and furnishing the XML format data by the web server in response to an XML request transaction.

18. A computer system for converting a data stream in an EDI (Electronic Data Interchange) format based on hierarchies to XML (Extensible Markup Language) format data, comprising:

a first computer system connected to a computer network and configured for bi-directional communication of data over the computer network, the first computer system comprising one or more processors and configured to;

receive a data stream in EDI format including a transaction type identifier, delimiter data groups and transaction data groups arranged between the delimiter data groups;

access a first translation tool, and, using the first translation tool, translate the received data stream to an intermediate data format having tags incorporating the transaction type identifier, sequence data and delimiter data group data, wherein the sequence data of at least one of the tags incorporating sequence data comprises data group name and length data;

access a second translation tool corresponding to the transaction type identifier;

translate, using the second translation tool, the received data in the intermediate data format having tags to XML format, using the data group name and length data of the sequence data to format the data in XML format; and

provide the XML format data as an output to a device.

19. The computer system of claim 18, wherein the second translation tool specifies a presentation of a class of XML documents.

20. The computer system of claim 19, wherein the second translation tool is a stylesheet.