US 5,632,015 A · Computer program product to efficiently process diverse result sets returned by a stored procedure

Abstract

A system for processing diverse and non-diverse result sets is described. The system includes a client process in a client computer system that constructs a client process execution request identifying a stored procedure and specifying constraints on the quantity of response data that the client process is capable of handling. The client process execution request is transferred from the client process in the client computer system to a server process in a server computer system. The server process invokes the stored procedure identified by the client process execution request. Execution of the stored procedure results in the generation of answer set data for a plurality of diverse query result sets. Result set generators obtain answer set data for X of the query result sets, where X is defined by the constraints. The server process then generates an initial response containing, for each of the X query result sets, an amount of the obtained answer set data consistent with the constraints. The initial response is transferred from the server computer system to the client process in the client computer system. The client application is then able to access and process answer set data for the diverse result sets in any order.

Claims18

Dependent claims

A computer program product comprising a computer readable medium having computer program logic recorded thereon for enabling a processor in a server computer system to process diverse result sets, said computer program logic comprising:

client process execution request receiving means for enabling said processor to receive from a client process in a client computer system a client process execution request identifying a stored procedure and specifying constraints on the quantity of response data that said client process is capable of handling;
stored procedure invoking means for enabling said processor to invoke said stored procedure identified by said client process execution request, execution of said stored procedure resulting in the generation of answer set data for a plurality of query result sets;
answer set data obtaining means for enabling said processor to asynchronously obtain answer set data for X of said query result sets, where X is defined by said constraints;
initial response generating means for enabling said processor to generate an initial response containing, for each of said X query result sets, an amount of said obtained answer set data consistent with said constraints;
and
initial response transferring means for enabling said processor to transfer said initial response from said server computer system to said client process in said client computer system.

3 more elements

A program storage device readable by a machine, tangibly embodying a program of instructions executable by the machine to perform method steps for processing diverse result sets, said method steps comprising:

(1) constructing by a client process in a client computer system a client process execution request identifying a stored procedure and specifying constraints on the quantity of response data that said client process is capable of handling;
(2) transmitting said client process execution request from said client process in said client computer system to a server process in a server computer system;
(3) invoking in said server computer system said stored procedure identified by said client process execution request, execution of said stored procedure resulting in the generation of answer set data for a plurality of query result sets;
(4) asynchronously obtaining answer set data for X of said query result sets in said server computer system, where X is defined by said constraints;
(5) generating in said server computer system an initial response containing, for each of said X query result sets, an amount of said obtained answer set data consistent with said constraints;
(6) transferring said initial response from said server computer system to said client process in said client computer system;
and
(7) enabling a client application in said client computer system to access and process answer set data transferred from said server computer system to said client process in said client computer system.

5 more elements

A computer program product comprising a computer readable medium having computer program logic recorded thereon for controlling a processor in a client computer system, said computer program logic comprising:

client process execution request constructing means for enabling said processor to construct a client process execution request identifying a stored procedure and specifying constraints on the quantity of response data that can be handled;
client process execution request transmitting means for enabling said processor to transmit said client process execution request to a server process in a server computer system, wherein said server process invokes said stored procedure in said server computer system, execution of said stored procedure resulting in the generation of answer set data for a plurality of query result sets, said server process generating an initial response containing, for each of X query result sets, an amount of said obtained answer set data consistent with said constraints, where X is defined by said constraints, said initial response being transmitted to said client computer system;
and
enabling means for enabling said processor to enable a client application in said client computer system to access and process answer set data transferred from said server computer system to said client computer system.

1 more element

Dependencies are inferred from the claim text.

Computer program product to efficiently process diverse result sets returned by a stored procedure

Life of this patent

Computer program product to efficiently process diverse result sets returned by a stored procedure

Life of this patent

Abstract

Claims18