Method and system for managing database having a capability of passing data, and medium relevant thereto

• US 7,089,249 B2
• Filed: 06/10/2004
• Issued: 08/08/2006
• Est. Priority Date: 05/28/1998
• Status: Expired due to Fees

• Current Assignee: Hitachi, Ltd.
• Original Assignee: Hitachi, Ltd.
• Inventors: Yamamoto, Youichi, Kobayashi, Susumu, Kamegi, Yoshito
• Primary Examiner(s): Le, Debbie M.
• Application Number:
  US10/864,637
• Publication Number:
  US 20040267757A1
• Time in Patent Office: 789 Days
• Field of Search: 707 1- 10, 709/203
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2219 Large Object storage; Management thereof
• CPC Class Codes: Y10S 707/99931 Database or file accessing

Abstract

In a database system of a client-server arrangement, a database server operating in a server outputs data to a storage device. Here, the data stores in a database that is requested by a user application operating in a client. The user application refers to the storage device to which the data is outputted, to obtain the data. Thereby, the data managed by the database server is passed to an application at high speed in the database system.

Claims

1. A database processing method used in a database system arranged in a client-server manner, comprising the steps of:

performing a first process, responsive to a request of a program being executed at a client, of enabling a database server operating at a server to transfer Large Object (LOB) data, which has been processed on a database, from said database to a common storage device which is shared between said client and said server, said common storage device being separated from said client and said server through a network, and being other than a storage device to which said database is stored, and enabling said database server operating at said server to respond to said request by transmitting identifying information, which identifies a particular storage area of said common storage device to which said LOB data is stored, to said program; and

performing a second process enabling said program being executed at said client to refer to said particular storage area of said common storage device for said LOB data, based on said identifying information including a processed result of said LOB data, to retrieve the transferred LOB data from said storage area of said common storage device into said program,

wherein said common storage device stores said LOB data transferred to said common storage device by said database server for subsequent retrieval by said program and outputs said LOB data in response to a retrieval request from said program.

2. A database processing method as claimed in claim 1, further comprising:

a third process of enabling said program to request an execution of a function defined in said database;

a fourth process of enabling said database server to execute said function according to said execution request from said program;

a fifth process of enabling said function to create a storage area identifying information of said common storage device to which, said data is output;

a sixth process of enabling said function to transfer said data to said storage area; and

a seventh process of enabling said function to notify said database server of said storage area identifying information.

3. A database processing method as claimed in claim 1, further comprising:

an eighth process of enabling plural processes,

wherein said eighth process has a parallel database arrangement, and executes database processes in parallel and outputs processed LOB data to said common storage device in parallel.

4. A database processing method as claimed in claim 1, further comprising:

a ninth process of enabling said program to refer to said common storage device to which processed LOB data is output by said database server as the same node as a node where said database server is in operation to retrieve said LOB data.

5. A database processing system used in a database system arranged in a client-server manner, comprising:

first means, responsive to a request of a program being executed at a client, for enabling a database server operating at a server to transfer Large Object (LOB) data, which has been processed on a database, from said database to a common storage device which is shared between said client and said server, said common storage device being separated from said client and said server through a network and being other than a storage device to which said database is stored, and enabling said database server operating at said server to respond to said request by transmitting identifying information, which identifies a particular storage area of said common storage device to which said LOB data is stored, to said program; and

second means for enabling said program being executed at said client to refer to said particular storage area of said common storage device for said LOB data, based on said identifying information including a result of processing said LOB data, to retrieve the transferred LOB data from said storage area of said common storage device into said program,

wherein said common storage device stores said LOB data transferred to said common storage device by said database server for subsequent retrieval by said program and outputs said LOB data in response to a retrieval request from said program.

6. A database processing system as claimed in claim 5, further comprising:

third means for enabling said program to request an execution of a function defined in said database;

fourth means for enabling said database server to execute said function according to said execution request from said program;

fifth means for enabling said function to create a storage area identifying information of said common storage device to which said data is output;

sixth means for enabling said function to output said data to said storage area; and

seventh means for enabling said function to notify said database server of said storage area identifying information.

7. A database processing system as claimed in claim 5, further comprising:

eighth means for enabling plural processes,

wherein said eighth process has a parallel database arrangement, and executes database processes in parallel and outputs processed LOB data to said common storage device in parallel.

8. A database processing system as claimed in claim 7, further comprising:

ninth means for enabling said program to refer to said common storage device to which processed LOB data is output by said database server as the same node as a node where said database server is in operation to retrieve said LOB data.

9. A computer readable storage medium having stored therein an executable program which is executed in a database processing system used in a database system arranged in a client-server manner, comprising:

first code means, responsive to a request of a program being executed at a client, of enabling a database server operating at a server to transfer Large Object (LOB) data, which has been processed on a database, from said database to a common storage device which is shared between said client and said server, said common storage device being separated from said client and said server through a network, and being other than a storage device to which said database is stored, and enabling said database server operating at said server to respond to said request by transmitting identifying information, which identifies a particular storage area of said common storage device to which said LOB data, to said program; and

second code means of enabling said program being executed at said client to refer to said particular storage area of said common storage device for said LOB data, based on said identifying information including a result of processing said LOB data, to retrieve the transferred LOB data from said storage area of said common storage device into said program,

wherein said common storage device stores said LOB data transferred to said common storage device by said database server for subsequent retrieval by said program and outputs said LOB data in response to a retrieval request from said program.

10. A computer readable storage medium as claimed in claim 9, further comprising:

third code means of enabling said program to request an execution of a function defined in said database;

fourth code means of enabling said database server to execute said function according to said execution request from said program;

fifth code means of enabling said function to create a storage area identifying information of said common storage device to which said data is output;

sixth code means of enabling said function to output said data to said storage area; and

seventh code means of enabling said function to notify said database server of said storage area identifying information.

11. A computer readable storage medium as claimed in claim 9, further comprising:

eighth code means of enabling plural processes,

wherein said eighth process has a parallel database arrangement, and executes database processes in parallel and outputs processed LOB data to said common storage device in parallel.

12. A computer readable storage medium as claimed in claim 9, further comprising:

ninth code means of enabling said program to refer to said common storage device to which processed LOB data is output by said database server as the same node as a node where said database server is in operation to obtain said data.