Database processing method, apparatus for implementing same, and medium containing processing program therefor

• US 6,728,710 B2
• Filed: 09/13/2002
• Issued: 04/27/2004
• Est. Priority Date: 12/01/1998
• Status: Expired due to Fees

• Current Assignee: Hitachi, Ltd.
• Original Assignee: Hitachi, Ltd.
• Inventors: Kobayashi, Susumu, Tsuchida, Masashi, Nakano, Yukio, Iwata, Morihiro
• Primary Examiner(s): Mizrahi, Diane D.
• Assistant Examiner(s): Mofiz, Apu M
• Application Number:
  US10/242,441
• Publication Number:
  US 20030014431A1
• Time in Patent Office: 592 Days
• Field of Search: 707/3, 707/8, 707/10, 707/103.R, 379/211.02, 379/221.01, 379/220.02
• US Class Current: 1/1
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: Y10S 707/99938 Concurrency, e.g. lock management in shared database
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A database processing method for defining and operating data of file reference type which references a file. A column data insert request for specifying position information indicative of a storage location of a file and watch information for watching the file is received from a database client. A request for watching a file indicated by the position information is issued in accordance with the watch information. The position information and the watch information are stored in a database. The foregoing operations permit data in an external file placed outside a database to be treated as data equivalent to ordinary column data stored in the database to improve the integrity of the database.

Claims

1. A database processing method for performing database operations by referencing an external file, comprising the steps of:

receiving from a database client, a table select request for specifying a table name, a select item, a select condition, and a processing type indicative of which of column data and contents of an external file are to be processed; and

transmitting to the database client column data which meets said select condition, or the contents of an external file indicated by position information in said column data in accordance with the contents of said processing type, and watch information for watching access to said external file.

2. A database processing method for performing database operations by referencing an external file, comprising the steps of:

receiving an update notice for a-an external file referenced by column data of file reference type and watch information for watching access to said external file;

when said update notice indicates a delete of the external file, deleting a row corresponding to the column data indicative of the deleted file based on said watch information; and

executing maintenance processing on an index in accordance with an update or a delete of the external file file.

3. A database processing apparatus for performing database operations by referencing an external file, comprising:

a processing request acceptance processing unit for receiving from a database client, a table select request for specifying a table name, a select item, a select condition, and a processing type indicative of which of column data and contents of an external file are to be processed; and

a select processing unit for transmitting to the database client, column data which meets said select condition, or the contents of an external file indicated by position information in said column data in accordance with the contents of said processing type, and watch information for watching access to said external file.

4. A database processing apparatus for performing database operations by referencing an external file, comprising:

an update notice acceptance processing unit for receiving an update notice for an external file referenced by column data of file reference type and a watch information for watching access to said external file, and for deleting a row corresponding to the column data indicative of a deleted file when said update notice indicates a delete of the file based on said watch information; and

an index maintenance processing unit for executing maintenance processing on an index in accordance with an update or a delete of the external file.

5. A medium having recorded thereon a program for causing a computer to function as a database processing apparatus for performing database operations by referencing an external file, said program comprising:

a program code causing a computer to function as a processing request acceptance processing unit for receiving from a database client, a table select request for specifying a table name, a select item, a select condition, and a processing type indicative of which of column data and contents of an external file are to be processed; and

a program code causing a computer to function as a select processing unit for transmitting to the database client, column data which meets said select condition, or the contents of an external file indicated by position information in said column data in accordance with the contents of said processing type, and a watch information for watching access to said external file.

6. A medium having recorded thereon a program for causing a computer to function as a database processing apparatus for performing database operations by referencing an external file, said program comprising:

a program code causing a computer to function as an update notice acceptance processing unit for receiving an update notice for an external file referenced by column data of file reference type and a watch information for watching access to said external file, and for deleting a row corresponding to the column data indicative of a deleted file when said update notice indicates a delete of the file based on said watch information; and

a program code causing a computer to function as an index maintenance processing unit for executing maintenance processing on an index in accordance with an update or a delete of the external file.