Database server processing system, method, program and program storage device

• US 6,754,658 B1
• Filed: 08/25/2000
• Issued: 06/22/2004
• Est. Priority Date: 02/16/2000
• Status: Expired due to Fees

• Current Assignee: Hitachi, Ltd.
• Original Assignee: Hitachi, Ltd.
• Inventors: Matsuno, Hideki
• Primary Examiner(s): Robinson, Greta
• Assistant Examiner(s): Le, Miranda
• Application Number:
  US09/645,407
• Time in Patent Office: 1,397 Days
• Field of Search: 707/9-10, 707/100-104, 707/8, 707/200-203, 707/223
• US Class Current: 1/1
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: Y10S 707/99938 Concurrency, e.g. lock management in shared database
• CPC Class Codes: Y10S 707/99939 Privileged access
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A database processing apparatus includes a user connection information recording unit for storing connection requests from users in response to database connection processing requests by at least one user requiring for database processing, and database resource allocation unit for making a user occupy a database resource of a database system, in response to a transaction execution request from the user, with a minimum transaction unit ensured with an equivalency to a database processing, and execute a transaction stored in the database resource, thereby carrying out utilization of the system by a number of users.

Claims

1. A database processing method, comprising the steps of:

storing connection requests from users in response to database connection processing requests by at least one user requiring database processing;

making the user occupy a database resource of a database system, in response to a transaction execution request from the user, with a minimum transaction unit ensured with an equivalency to a database processing;

executing a transaction stored in the database resource;

assigning, for each user, authentic information in response to an access right for each user for each of the databases;

replacing a plurality of logical authentic information with a physical authentic information for access to a database, the logical authentic information of each of users requesting a database processing request and having a database access right with same levels as other users; and

executing a transaction without carrying out both database disconnection processing and database reconnection processing for the database, when a database resource is being connected with a database with the physical authentic information used and the physical authentic information is identical with an authentic information associated with the transaction to be executed.

2. A computer readable recording medium recording a database processing program, including:

a program of storing connection requests from users in response to database connection processing requests by the users requesting at least one database processing;

a program for making the users occupy a database resource of a database system with a minimum transaction unit ensured with an equivalency to the database processing in accordance with transaction execution requests from the users;

a program of replacing a plurality of logical authentic information with a physical authentic information for access to a database, the logical authentic information of each of users requesting a database processing request and having a database access right with same levels as other users; and

a program of executing a transaction without carrying out both database disconnection processing and database reconnection processing for the database, when a database resource is being connected with a database with the physical authentic information used and the physical authentic information is identical with an authentic information associated with the transaction to be executed.

3. A computer program for executing a database processing method, including:

a step of storing connection requests from users in response to database connection processing requests by the users requesting at least one database processing;

a step of making the users occupy a database resource of a database system with a minimum transaction unit ensured with an equivalency to the database processing in accordance with transaction execution requests from the users;

a step of executing a transaction stored in the database resource;

a step of replacing a plurality of logical authentic information with a physical authentic information for access to a database, the logical authentic information of each of users requesting a database processing request and having a database access right with same levels as other users; and

a step of executing a transaction without carrying out both database disconnection processing and database reconnection processing for the database, when a database resource is being connected with a database with the physical authentic information used and the physical authentic information is identical with an authentic information associated with the transaction to be executed.

4. A database processing apparatus, comprising:

a user connection information recording unit for storing connection requests from users in response to database connection processing requests by at least one user requiring database processing; and

a database resource allocation unit for making the user occupy a database resource of a database system, in response to a transaction execution request from the user, with a minimum transaction unit ensured with an equivalency to a database processing, and execute a transaction stored in the database resource,

wherein a plurality of logical authentic information are replaced with a physical authentic information for access to a database, the logical authentic information of each of users requesting a database processing request and having a database access right with same levels as other users; and

wherein a transaction is executed without carrying out both database disconnection processing and database reconnection processing for the database, when a database resource is being connected with a database with the physical authentic information used and the physical authentic information is identical with an authentic information associated with the transaction to be executed.