System for reducing communications overhead in distributed database transactions by serializing in order related requests into single transmission message and receiving transmission response

• US 5,179,660 A
• Filed: 05/15/1989
• Issued: 01/12/1993
• Est. Priority Date: 05/15/1989
• Status: Expired due to Term

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Incorporated (International Business Machines Corporation)
• Inventors: Garrison, Jane R., Devany, Estel P., Jacobs, Dwayne C., Jordan, Lloyd E. II
• Primary Examiner(s): Lee, Thomas C.
• Assistant Examiner(s): KIM, KENNETH S
• Application Number:
  US07/352,082
• Time in Patent Office: 1,338 Days
• Field of Search: 364/200 MS File, 364/900 MS File, 395/200, 395/600
• US Class Current: 709/219
• CPC Class Codes: G06F 16/256 in federated or virtual databases

Abstract

A system suitable for use on a computer network provides a user interface on a local node and an application to be run on a remote node. An application for accepting input from the user and translating it to appropriate commands for the remote application is divided, and located partially on the local node and partially on the remote node. That portion located on the local node gathers any information required from the user and transmits it to the portion located on the remote node in an efficient manner. The remote location portion uses the transmitted information to interface with the remote application and obtain results. The results are collected and transmitted to the local portion, from which they are returned to the user.

Claims

1. In a distributed data processing system including a local network node having a user interface facility and a remote node having a database manager for a remote database accessible through the remote node, a method for executing a transaction between the local network node and the remote database, comprising the steps executed by the distributed data processing system of:

prompting, through the user interface facility, user selection of a transaction type;

responsive to user selection of the transaction type, prompting user specification of values for a set of parameters associated with the transaction type needed for a series of requests defining the transaction;

transmitting from the local network node over a network communications link to the remote node, as a single message, the parameter values specified by the user;

responsive to receipt of the single message at the remote node, making a series of individual database request through the database manager using the transmitted parameter values to generate a transaction result; and

returning the transaction result to the local network node as a second single message over a communications link.

2. The method of claim 1, wherein the step of making a series of individual database requests includes:

applying the set of parameter values to a remote application;

the series of database requests from the remote application using the set of parameter values.

3. The method of claim 2, wherein the set of parameter values and the transaction result are formatted in a preselected manner prior to transmission over the network communications link, and wherein the set of parameter values information and transaction result are stored upon receipt at the remote node and the local node, respectively.

4. The method of claim 1, wherein each of the individual database requests comprises an SQL request.

5. A distributed data processing system for executing transactions with a database, comprising:

a user node;

a remote node;

a network connecting the user node and the remote node;

interface facility means located on the user node for gathering information from a user, for constructing a series of related requests to the database and for displaying a result obtained from the database responsive to the series of related requests;

a database manager located on the remote node;

means for establishing a communications link between the user node and the remote node and for transmitting the series of requests in a single message;

server means located on the remote node responsive to receipt of the series of requests over the communications link for applying the related requests to the database and obtaining the result therefrom; and

the establishing means further providing for establishing a communication link between the user node and the remote node for transmitting the result to the user node in a single message.

6. The system of claim 5, wherein said database manager is an SQL database manager, and each of the related requests is an SQL database request.

7. The system of claim 5, wherein the series of related requests define a transaction.

8. The system of claim 5, wherein said establishing means comprises:

remote and local network interfaces connected to the network and to the remote node and user node, respectively;

means for formatting the series of selected requests for transmission over the network and for recreating formatted results received from the remote node; and

means for recreating formatted series of related requests received from the local node, and for formatting the result for transmission over the network.

9. The system of claim 8, further comprising:

a second database manager located on the local node; and

means located on the local node for making the series of related requests to the second database manager;

wherein said local data services procedure communicates the series of related requests directly to said local node making means if the second database manager is requested by a user, and directs formatted series of related requests to the remote node if the remote node database manager is requested by the user.