System and procedure for concurrent database access by multiple user applications through shared connection processes
First Claim
1. In an object-oriented database processing system having storage means for storing a plurality of databases and a plurality of user applications (UAs) for processing database access requests including schema queries and requests to execute standard query language (SQL) units of work (UOWs), for storing a plurality of catalog server processes, each linked to a respective database, and a plurality of SQL server processes, each linked to a respective database, and for storing a plurality of objects including a plurality of database access (DBA) objects for passing messages between said UAs and said databases, a method for accessing data in a first said database responsive to one or more said database access requests from a first said UA, said method comprising the steps of:
- forming first logical paths between said plurality of catalog server processes and said plurality of DBA objects, and second logical paths between said plurality of SQL server processes and said plurality of DBA objects;
at least one of said first logical paths being shared among two or more DBA objects of the plurality of DBA objects;
followed by;
(a) sending said database access requests from said first UA to a first said DBA object for passing messages between said first UA and said first database, said first DBA object including first schema retrieval methods and first SQL execution methods;
(b) transferring schema query messages between said first schema retrieval methods of said first DBA object and said first database through a first said logical path; and
(c) transferring SQL UOW execution messages between said first SQL execution methods of said first DBA object and said first database through a second said logical path.
1 Assignment
0 Petitions
Accused Products
Abstract
A system for managing database connections between concurrent user applications and a plurality of databases in a database processing system. This method minimizes the number of connections made to a database by allowing such connections to be shared by multiple applications. The concept of a shared versus exclusive connection is introduced and, depending on the user application, a connection manager automatically routes a database access request through either an existing shared connection or an exclusive connection. A single database access object is introduced that includes two types of methods for connecting to a specified database in two different simultaneous paths. First, a shared connection through a catalog server process is made to process schema query requests for definition retrieval. Secondly, another connection is made to retrieve and manipulate data from the database responsive to SQL execution requests. Importantly, the SQL execution path itself may be either exclusive or shared with other associated database access objects requesting SQL execution in the same database.
-
Citations
33 Claims
-
1. In an object-oriented database processing system having storage means for storing a plurality of databases and a plurality of user applications (UAs) for processing database access requests including schema queries and requests to execute standard query language (SQL) units of work (UOWs), for storing a plurality of catalog server processes, each linked to a respective database, and a plurality of SQL server processes, each linked to a respective database, and for storing a plurality of objects including a plurality of database access (DBA) objects for passing messages between said UAs and said databases, a method for accessing data in a first said database responsive to one or more said database access requests from a first said UA, said method comprising the steps of:
-
forming first logical paths between said plurality of catalog server processes and said plurality of DBA objects, and second logical paths between said plurality of SQL server processes and said plurality of DBA objects; at least one of said first logical paths being shared among two or more DBA objects of the plurality of DBA objects; followed by; (a) sending said database access requests from said first UA to a first said DBA object for passing messages between said first UA and said first database, said first DBA object including first schema retrieval methods and first SQL execution methods; (b) transferring schema query messages between said first schema retrieval methods of said first DBA object and said first database through a first said logical path; and (c) transferring SQL UOW execution messages between said first SQL execution methods of said first DBA object and said first database through a second said logical path. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)
-
-
15. An object-oriented database processing system having a plurality of objects and a plurality of databases, said objects including a plurality of user applications (UAs) that make database access requests for processing schema queries and standard query language (SQL) unit of work (UOW) executions, said system comprising:
-
data storage means for storing said data and objects; a plurality of database access (DBA) objects in said data storage means, each for receiving said database access requests for one said database from one said UA and having methods for exchanging schema retrieval messages with said one database over a first logical path and methods for exchanging SQL UOW execution messages with said one database over a second logical path; a plurality of catalog server processes in said data storage means, each linked to a respective one of said databases, for processing said schema queries responsive to messages exchanged with said DBA objects; at least one said database being linked to one said catalog server process that is shared by two or more said DBA objects; a plurality of SQL server processes in said data storage means, each linked to a respective one of aid databases, for processing said SQL execution requests responsive to messages exchanged with said DBA objects; and connection manager means in said data storage means for selecting and linking said catalog server processes to said DBA objects to form said first logical paths and for selecting and linking said SQL server processes to said DBA objects to form said second logical paths. - View Dependent Claims (16, 17, 18, 19)
-
-
20. A computer program product for use in an object-oriented database processing system having a central processing unit and storage means for storing a plurality of databases and a plurality of user applications (UAs) for processing database access requests including schema queries and requests to execute standard query language (SQL) units of work (UOWs), for storing a plurality of catalog server processes, each linked to a respective database, and a plurality of SQL server processes, each linked to a respective database, and for storing a plurality of objects including a plurality of database access (DBA) objects for passing messages between said UAs and said databases, said computer program product comprising:
-
a recording medium; means recorded on said medium for forming first logical paths between said plurality of catalog server processes and said plurality of DBA objects, and second logical paths between said plurality of SQL server processes and said plurality of DBA objects, at least one of said first logical paths being shared among two or more DBA objects of the plurality of DBA objects; means recorded on said recording medium for directing said processing system to send database access requests from a first UA to a first said DBA object for passing messages between said first UA and a first database, said first DBA object including first schema retrieval methods and first SQL execution methods; means recorded on said recording medium for directing said processing system to transfer schema query messages between said first schema retrieval methods of said first DBA object and said first database through a first logical path; and means recorded on said recording medium for directing said processing system to transfer SQL UOW execution messages between said first SQL execution methods of said first DBA object and said first database through a second logical path. - View Dependent Claims (21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33)
-
Specification