Method and system for describing and exchanging data between heterogeneous database systems with data converted by the receiving database system

• US 5,278,978 A
• Filed: 03/26/1990
• Issued: 01/11/1994
• Est. Priority Date: 03/26/1990
• Status: Expired due to Term

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Lindsay, Bruce G., Reinsch, Roger A., Zimowski, Melvin R., Demers, Richard A.
• Primary Examiner(s): Anderson, Lawrence E.
• Assistant Examiner(s): Geckil, Mehmet
• Application Number:
  US07/499,114
• Time in Patent Office: 1,387 Days
• Field of Search: 395/600, 395/725, 395/200, 395/650
• US Class Current: 707/756
• 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/99952 Coherency, e.g. same view to multiple users

Abstract

The invention establishes the context in which data exchanged between dissimilar relational database management systems can be mutually understood and preserved. 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. For systems which match, data conversion is completely avoided. For systems which do not match, data conversion is minimized.

Claims

1. In a multi-database combination including a first database system and a second database system, each having different machine environments and data formats, a method for describing machine environments and format of data to be exchanged between the first and second database systems, the method including the sequential steps of:

establishing a communication link between the first and second database systems;

on the communication link, communicating from the first database system to a second database system a description of the machine environment of the first database system and communicating from the second database system to the first database system description of the machine environment of the second database system;

sending at least two database access requests from the first database system to the second database without resending the descriptions of machine environment;

in response to a first of the at least two database access requests, returning from the second database to the first database system user data in a data format native to the second database system and descriptions of the data format without sending the descriptions of the machine environment of the second database system; and

in response to each database access request following the first database access request, returning from the second database system to the first database system user data in the data format native to the second database system without sending descriptions of the machine environment or the data format; and

whereby, user data in the format native to the second database system is converted by the first database system into a format native to the first database system using the descriptions of the format and the descriptions of the machine environment of the second database system.

2. The method of claim 1 further including the step of converting the user data into a format native to the first database system at the first database system in response to the descriptions of the data format native to the second database system and the description of the machine environment of the second database system.