Method and combination for minimizing data conversions when data is transferred between a first database storing data in a first format and a second database storing data in a second format

• US 5,566,332 A
• Filed: 08/11/1994
• Issued: 10/15/1996
• Est. Priority Date: 03/27/1990
• Status: Expired due to Term

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Coyle, Daniel J. Jr., Adair, John G., Resch, Robert P., Lindsay, Bruce G., Reinsch, Roger A., Selinger, Patricia G., Zimowski, Melvin R., Grafe, Robert J.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Choules, Jack M.
• Application Number:
  US08/288,837
• Time in Patent Office: 796 Days
• Field of Search: 395/600, 395/500, 395/200.09, 395/200.12, 395/200.18
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: Y10S 707/922 Communications
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99954 Version management

Abstract

The invention establishes the context in which data exchanged between dissimilar relational database management systems can be mutually understood and preserved, and data conversions can be minimized. The invention accomplishes this by establishing layers of descriptive information which isolate machine characteristics, levels of support software, and user data descriptions. Optimized processing is achieved by processing the different descriptor levels at different times during the development and execution of the database management systems. Minimal descriptive information is exchanged between the cooperating database management systems. Any data conversions that may be necessary are done only by the receiver of the data, and only at the point where it is necessary to have the data represented in the receiver'"'"'s native format for processing. For sending and receiving systems which match, data conversion is completely avoided, even when the data may have been forwarded through intermediate DBMS systems which do not match. For sending and receiving systems which do not match, data conversion is minimized. The data conversion routines and tables in each system are also minimized by requiring conversion only INTO a system'"'"'s native format, never FROM its native format into some other format.

Claims

1. A combination for establishing a data conversion context at a first computer system which receives data from a second computer system, wherein the second computer system stores and processes data in a format different than the first computer system, the combination comprising:

(a) descriptors in the first computer system defining machine and language characteristics of a plurality of computer systems;

(b) means for obtaining from said descriptors, first and second descriptors which respectively define machine and language characteristics for said second computer system;

(c) means for receiving data from the second computer system; and

(d) means for combining the first and second descriptors with data descriptors in the received data which describe characteristics of data native to the second computer system to produce a context for converting the received data to data which is native to the first computer system.

2. A method for use by a user processor in making data requests to a server processor which stores and processes data in a format different than the user processor, comprising the user processor executed steps of:

storing a dictionary of processor descriptors;

creating a communication link to a server processor by;

communicating to the server processor an identifier denoting the user processor; and

receiving from the server processor an identifier denoting the server processor;

sending a request for data to the server processor in the user processor data format, the request including a descriptor of the user processor data format;

receiving from the server processor data responsive to the request for data, the data being in the server processor data format, and being accompanied by a descriptor of the server processor data format; and

using the identifier denoting the server processor and the descriptor of the server processor data format, converting the data to the user processor data format.

3. The method of claim 2, wherein the step of creating a communication link further includes validating the identifier denoting the server processor.

4. The method of claim 2, wherein the identifier denoting the server processor includes identification of a server processor machine descriptor.

5. The method of claim 4, wherein:

the storing step includes storing a plurality of server processor machine descriptors at the user processor;

and the step of converting includes;

obtaining a server processor machine descriptor from the dictionary in response to the identifier denoting the server processor; and

in response to the server processor machine descriptor, converting bit representations in the data received from the server processor to bit representations used by the user processor.

6. The method of claim 2, wherein the identifier denoting the server processor includes identification of a computer language descriptor.

7. The method of claim 6, wherein:

the storing step includes storing a plurality of computer language descriptors in the dictionary; and

the step of converting includes;

obtaining a computer language descriptor from the dictionary in response to the identifier denoting the server processor; and

in response to the computer language descriptor, converting control fields in the data received from the server processor to control fields of a computer language used by the user processor.

8. The method of claim 2, wherein the identifier denoting the server processor includes identification of a server processor code page.

9. The method of claim 8, wherein:

the storing step includes storing a plurality of server processor code page descriptors in the dictionary;

and, the step of converting includes;

obtaining a server processor code page descriptor from the dictionary in response to the identifier denoting the server processor; and

in response to the code page descriptor, converting character representations in the data received from the server processor to character representations used by the user processor.

10. The method of claim 8, wherein:

the storing step includes storing a plurality of server processor code page descriptors in the dictionary;

and, the step of converting includes;

obtaining a code page descriptor from the dictionary in response to the identifier denoting the server processor; and

in response to the code page descriptor, converting control function representations in the data received from the server processor to control function representations used by the user processor.

11. A combination for use by a user processor in making data requests to a server processor which stores and processes data in a format different than the user processor, the combination comprising, in the user processor:

means for creating a communication link to a server processor by;

communicating to the server processor an identifier denoting the user processor; and

receiving from the server processor an identifier denoting the server processor;

a dictionary of server processor descriptors;

means for sending a request for data to the server processor on the communication link in the user processor data format, the request including a descriptor of the user processor data format;

means for receiving from the server processor data responsive to the request for data, the data being in the server processor data format and being accompanied by a descriptor of the server processor data format; and

means for converting the data to the user processor data format in response to the identifier denoting the server processor and the descriptor of the server processor data format.

12. The combination of claim 11, wherein the means for creating a communication link is further for validating the identifier denoting the server processor.

13. The combination of claim 11, wherein the identifier denoting the server processor includes identification of a server processor machine descriptor.

14. The combination of claim 13, wherein:

the server processor descriptors include a plurality of server processor machine descriptors;

and, the means for converting includes;

means for obtaining a server processor machine descriptor from the dictionary in response to the identifier denoting the server processor; and

means for converting bit representations in the data received from the server processor to bit representations used by the user processor in response to the server processor machine descriptor.

15. The combination of claim 11, wherein the identifier denoting the server processor includes identification of a computer language descriptor.

16. The combination of claim 15, wherein:

the server processor descriptors include a plurality of computer language descriptors;

and, the means for converting includes;

means for obtaining a computer language descriptor from the dictionary in response to the identifier denoting the server processor; and

means for converting control fields in the data received from the server processor to control fields of a computer language used by the user processor.

17. The combination of claim 11, wherein the identifier denoting the server processor includes identification of a server processor code page.

18. The combination of claim 17, wherein:

the server processor descriptors include a plurality of server processor code page descriptors;

and, the means for converting includes;

means for obtaining a server processor code page descriptor from the dictionary in response to the identifier denoting the server processor; and

means for converting character representations in the data received from the server processor to character representations used by the user processor in response to the code page descriptor.

19. The combination of claim 17, wherein:

the server processor descriptors include a plurality of code page descriptors;

and, the means for converting includes;

means for obtaining a code page descriptor from the dictionary in response to the identifier denoting the server processor; and

means for converting control function representations in the data received from the server processor to control function representations used by the user processor in response to the code page descriptor.