System and method for efficient data handling across multiple systems

• US 9,465,883 B2
• Filed: 08/03/2015
• Issued: 10/11/2016
• 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:
  US14/756,118
• Publication Number:
  US 20150370913A1
• Time in Patent Office: 435 Days
• Field of Search: 707/635, 707/756, 707/760, 707/778, 707/791, 707/792, 707/797, 707/798, 707/803, 715/234, 715/239, 715/249
• US Class Current: 1/1
• 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 data indicative of a transaction from XML (Extensible Markup Language) format to a second data format, the second data format being based on hierarchies, the method being executed by one or more processors, comprising:

by a first computer system, retrieving data indicative of a transaction in XML format;

by the first computer system, converting the retrieved transaction data to an intermediate data format having tags incorporating sequence data, including one or more tags incorporating one or more of delimiter group name data and transaction group name data;

by the first computer system, converting the data in the intermediate data format to the second data format based on hierarchies, employing the sequence data to format the data in the second data format based on hierarchies, the formatting of the data in the second data 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 delimiter group name data and transaction group name data, and

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

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

3. The computer-implemented method of claim 1, wherein the converting the retrieved data to the intermediate data format comprises using a stylesheet.

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

5. The computer-implemented method of claim 1, wherein the second data format based on hierarchies is an AL3 format.

6. The computer-implemented method of claim 5, wherein the AL3 format is ACORD AL3 format.

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

8. A computer interface system for converting data indicative of a transaction from XML (Extensible Markup Language) format to a second data format, comprising:

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

receive data indicative of a transaction in XML format;

convert the received transaction data to an intermediate data format having tags incorporating sequence data, including one or more tags incorporating one or more of delimiter group name data and transaction group name data;

convert the received data in the intermediate data format to the second data format based on hierarchies, employing the sequence data to format the data in the second data format based on hierarchies, the formatting of the data in the second data 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 delimiter group name data and transaction group name data; and

provide the data in the second data format based on hierarchies in accordance with said tags incorporating sequence data.

9. The computer interface system of claim 8, wherein the second data 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.

10. The computer interface system of claim 8, wherein the second data format based on hierarchies is an AL3 format.

11. The computer interface system of claim 10, wherein the second data format is ACORD AL3.

12. The computer interface system of claim 8, wherein the converting to the second data format based on hierarchies further comprises employing sequence index and length data of said sequence data to format the data in the second data 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 data formatted based on hierarchies, including delimiter data groups and transaction data groups arranged between the delimiter data groups;

by the first computer system, converting the received data to an intermediate data format having tags incorporating 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, 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 received data is in AL3 format.

15. The computer-implemented method of claim 13, wherein the converting the data in the intermediate data format comprises applying an XSL stylesheet to the data in the intermediate data format.

16. 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.

17. A computer system for converting data formatted 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, said first computer system comprising one or more processors and configured to;

receive data indicative of a transaction formatted based on hierarchies including delimiter data groups and transaction data groups arranged between the delimiter data groups;

convert the received data to an intermediate data format having tags incorporating 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;

convert the received data in the intermediate data format having tags to XML format; and

provide the XML format data as an output; and

wherein the first computer system is further configured to convert the received data from

the intermediate data format to XML format employing the data group name and length data of the sequence data to format the data in XML format.

18. The computer system of claim 17, wherein the received data formatted based on hierarchies comprises an AL3 format file.

19. The computer system of claim 17, wherein the converting the data in the intermediate data format comprises applying an XSL stylesheet to the data in the intermediate data format.