Method of communicating data between computers having different record formats

• US 7,120,636 B2
• Filed: 07/25/2001
• Issued: 10/10/2006
• Est. Priority Date: 07/25/2001
• Status: Active Grant

• Current Assignee: Somfy Sas (Somfy SA)
• Original Assignee: Somfy Sas (Somfy SA)
• Inventors: Pendleton, William W.
• Primary Examiner(s): Robinson, Greta
• Assistant Examiner(s): Veillard, Jacques
• Application Number:
  US10/333,897
• Publication Number:
  US 20040139076A1
• Time in Patent Office: 1,903 Days
• Field of Search: 707/3, 707/9, 707/10, 707100-102, 707/104.1, 707/200, 707/203, 709/201, 709/202, 709/217, 709/224, 709/232, 709/236, 709/203, 709/223, 709/237, 705 2- 4, 705/34
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation

Abstract

A method of communicating data between databases having different formats includes providing a first computer (4), a second computer (14), and a server (22) in a distributed computer network (2) where the server (22) is configured to send, receive, and process data packets including records having different formats to and from the first computer (4) an the second computer (14). The server (22) converts a first record in a first format (26a) into the first record in the second format (26b) and converts a second record in the second format (26b) into the first format (26a). The second computer is configured to receive data packets having the first record in the second format (26b), and to send data packets having the second record in the second format (26b).

Claims

1. A method of communicating data between databases having different formats, the method comprising the steps of:

providing a first computer, a second computer, and a server in a distributed computer network, the server configured to send and receive data packets including records having different formats between the first computer and the second computer, the server configured to convert a record format of a record received from the first computer into a record format of a record of the second computer, and vice versa, wherein the server includes;

a packet sniffer configured to separate from a first data packet a first record in a first format and a first transmitter-receiver layer, the packet sniffer also configured to separate from a second data packet a second record in a second format and a second transmitter-receiver layer;

a transmitter-receiver conversion matrix configured to scan the first transmitter-receiver layer and the second transmitter-receiver layer; and

a convert function configured to use at least one conversion routine for converting the first record in the first format into a first record in a second format and/or for converting the second record in the second format into the second record in the first format, with each layer and/or the second conversion based on the scanning of the first transmitter-receiver transmitter-receiver layer, respectively.

2. The method of claim 1 wherein the transmitter-receiver conversion matrix includes a first conversion routine configured to convert the first record in the first format into the first record in the second format.

3. The method of claim 1 wherein the transmitter-receiver conversion matrix selects the first conversion routine based upon the first transmitter-receiver layer.

4. The method of claim 1 wherein the transmitter-receiver conversion matrix includes a second conversion routine configured to convert the second record in the first format into the second record in the second format.

5. The method of claim 1 wherein the transmitter-receiver conversion matrix selects the second conversion routine based upon the second transmitter-receiver layer.

6. The method of claim 1 wherein the convert function applies the first conversion routine to the first record in the first format to convert the first record in the first format to the first record in the second format.

7. The method of claim 1 wherein the convert function applies the second conversion routine to the second record in the second format to convert the second record in the second format to the second record in the first format.

8. The method of claim 1 wherein the server is configured to send a first data packet to the second computer and a second data packet to the first computer.

9. The method of claim 1 wherein the first data packet includes the first record in the second format, a first transmitter-receiver layer, and a first IP header.

10. The method of claim 1 wherein the second data packet includes the second record in the second format, a second transmitter-receiver layer, and a second IP header.