Method and apparatus for rationalizing different data formats in a data management system

• US 5,845,283 A
• Filed: 04/24/1996
• Issued: 12/01/1998
• Est. Priority Date: 04/24/1996
• Status: Expired due to Term

• Current Assignee: Linquateq Incorporated
• Original Assignee: Lingua TEQ Incorporated
• Inventors: Peterson, Michael E., Williams, Dale L.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): LEWIS, CHERYL RENEA
• Application Number:
  US08/639,073
• Time in Patent Office: 951 Days
• Field of Search: 370/420, 370/60.1, 395/500, 395/600, 395/2.79, 707/1, 707/2, 707/101, 707/102
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A data conversion device, including a preferably software implemented data conversion engine, which receives a formatted input data stream from an input device, converts the data into a different (universal) format in real time and transmits the converted data to an output device. Messages, i.e., data, from host devices can also be uplinked, via the data conversion device, to the data generating devices. By rapidly processing new and/or incompatible data record formats the invention minimizes the cost of maintaining data management systems and maximizes their usage. The conversion device input and output architecture is flexible and the conversion device can be used with multiple (networked or non-networked) data generating devices and single or multiple data storage devices using multiple data output formats.

Claims

1. An information retrieval and storage system comprising:

at least one data generating device for generating a stream of data having a predetermined form of information content, structure and format;

a data conversion device for receiving said data stream from said data generating device, converting said data stream into a universal, intermediate form of information content, structure and format, and from the universal intermediate form into a desired output form of information content, structure and format; and

for outputting an output data stream; and

a host device for receiving said output data stream.

2. The system according to claim 1 further comprising a plurality of data generating devices, each connected to said data conversion device, said data generating devices using diverse forms of information content, structure and format.

3. The system according to claim 2 wherein said plurality of data generating devices are networked and said data conversion device includes a network interface.

4. The system according to claim 2 wherein said data conversion device further comprises at least one data input port and at least one data output port and wherein at least one of data generating devices is hard wired to said input port;

and further comprising a host data processing device, said host data processing device being hardwired to said output port.

5. The system according to claim 2 wherein said conversion device comprises one or more discrete devices located remotely from said host device, each of said discrete devices being associated with at least one of said plurality of data generating devices.

6. The system according to claim 2 wherein said data conversion is centrally located in the vicinity of said host device.

7. The system according to claim 1 wherein said data conversion device comprises at least two input data interface devices, each for supporting a different predetermined input data form of information content, structure and format.

8. The system according to claim 7 wherein said input data interface devices convert said predetermined data forms into said intermediate, universal data form.

9. The system according to claim 8 wherein said data conversion device further comprises at least one output interface device, said output interface device being operable to convert data from said intermediate, universal data form into a predetermined output data form.

10. The system according to claim 1 wherein said data conversion device further comprises an input port connected to at least two input data interface devices, and wherein at least two of said plurality of data generating devices are configured as nodes on a network, each of said nodes having a unique address, and wherein said data conversion device receives input data from said networked devices via said inlet port and, based on said unique address, directs said input data to one of said input data interface devices.

11. The system according to claim 10 wherein said data conversion device further comprises at least two output data interface devices, each of said outlet data inface devices being connected to an output port and wherein said data conversion device includes means for directing converted data to an appropriate one of said output data interface devices, said system further comprising at least two host data processing devices, each hard wired to one of said outlet ports.

12. The system according to claim 1 wherein said data conversion device further comprises at least two output data interface devices, each of said outlet data inface devices being connected to an output port and wherein said data conversion device includes means for directing converted data to an appropriate one of said output data interface devices, said system further comprising at least two host data processing devices, each hard wired to one of said outlet ports.

13. The system according to claim 1 wherein said data conversion device further comprises at least one data input port hard wired to said data generating device, and at least two output data interfaces, each connected to an output port, and wherein said data conversion device includes means for directing formatted output data to an appropriate one of said output interface devices, said system further comprising at least two host data processing devices, each hard wired to one of said outlet ports.

14. The system according to claim 13 further comprising a plurality of networked data generating devices connected to said data input port.

15. The system according to claim 1 wherein said data conversion device comprises at least two data input ports and at least two data output ports, each of said input and output ports having an associated interface device and wherein said data conversion device includes means for converting said input data streams into one or more formatted output data streams and directing said formatted output data streams, via an interface device, to one or more of said respective output ports.

16. The system according to claim 1 wherein said data conversion device is located remotely from said host device in the vicinity of said data generating device.

17. A data conversion device for receiving data streams having different forms from a plurality of data generating devices, said conversion device comprising:

(a) at least one input side data interface for receiving an incoming data stream, said input interface supporting a predetermined input form of information content, structure and format;

(b) a data conversion engine for receiving input data from said input data interface having said predetermined form of information content, structure and format and converting said data into intermediate, universal form of information content, structure and format; and

(c) at least one output data interface for receiving data in said intermediate universal form of information content, structure and format and outputting said data in a predetermined output form of information content, structure and format.

18. The device according to claim 17 wherein said data conversion device comprises a real-time data conversion device.

19. The device according to claim 17 wherein said data conversion engine includes a record storage means for temporary storage of data streams during conversion and a library of conversion rules for converting input data streams from one or more input forms of information content, structure and format into said intermediate universal form of information content, structure and format and for converting data from said intermediate universal form into one or more output forms of information content, structure and format.

20. A method of processing one or more input data streams having diverse forms of information content, structure and format into one or more output data streams having diverse forms of information content structure and format using a data conversion device comprising the steps of:

receiving a data stream in a first form of information content, structure and format;

converting said data stream in a first interface device into an intermediate, universal form of information contents, structure and format;

converting said data stream in a second interface device from said universal form into a desired output form of information content, structure and format;

transmitting the data stream in said output form to be a data processing device.

21. The method according to claim 20 wherein said conversion steps are bi-directional.

22. An information contents storage and manipulation system including a data converter having a plurality of inputs for receiving data streams representing diverse forms of information content, structure and format and a plurality of outputs for outputting, based on said received data streams, converted data streams representing diverse forms of information content, structure and format, said converter comprising:

one or more input side interfaces for supporting the diverse forms of information content, structure and format received at said at least one input;

one or more output side interfaces for supporting the diverse forms of information content, structure and format to be output at said at least one output;

a conversion engine for performing conversions between each of the input side data streams and output side data streams, said conversion engine including an intermediate record storage for storing data records and a conversion library storage for storing conversion routines, said intermediate record storage holding data converted from one of said diverse forms of information content, structure and format to an intermediate, universal form based on a selected one of said conversion routines until said stored record is converted into a selected one of said diverse output forms of information content, structure and format.

23. The system according to claim 22 wherein said interfaces and said conversion engine are bi-directional.

24. The system according to claim 22 wherein said intermediate, universal form is specific to data for a particular industry.

25. The system according to claim 24 wherein the intermediate, universal data form defines all data fields maintained for said industry.

26. The system according to claim 22 wherein said converter is a real-time data converter.