Database processing method and system

• US 7,324,992 B2
• Filed: 03/01/2004
• Issued: 01/29/2008
• Est. Priority Date: 02/26/1997
• Status: Expired due to Fees

• Current Assignee: Hitachi, Ltd.
• Original Assignee: Hitachi, Ltd.
• Inventors: Kamegi, Yoshito, Hara, Norihiro, Kawamura, Nobuo, Torii, Shunichi
• Primary Examiner(s): Mahmoudi; Tony
• Application Number:
  US10/788,276
• Publication Number:
  US 20040167917A1
• Time in Patent Office: 1,429 Days
• Field of Search: 707/1, 707/2, 707/3, 707/100, 707/102
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2291 User-Defined Types; Storage management thereof
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access
• CPC Class Codes: Y10S 707/99936 Pattern matching access
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

In an implementation method for executing a general database processing, index definition information for setting a specific user-defined function in correspondence to a specific index which is used to carry out an index access to data in a database region is created, and module definition information for setting the specific index which is used to carry out the index access to the data in the database region in correspondence to an implementation module for subjecting the data in the database region to a specific processing is created. When it is determined that the user-defined function contained in a processing request is set in correspondence to the specific index on the basis of the index definition information, a specific implementation module for carrying out an access using the specific index is selected, and a database processing is performed using the implementation module.

Claims

1. A database management method of performing a processing of a database by invoking a function registered in the database in response to a request of processing, comprising the steps of:

relating with each other and cataloging as index definition information, an index name, an index type name of the index type in an index corresponding to said index name, data configured to invoke an index-accessing routine which accesses an index of said index type, a transformation function name identifying an input key-generating function which generates an input key configured to maintain said index from values of indexed columns, and a first function name identifying an index-accessing function which accesses said index;

upon reception of said processing request including a second function name, referring to said index definition information to acquire a relevant one of said cataloged index type name corresponding to said second function name, and said data configured to invoke an index-accessing routine which accesses an index of the index type corresponding to said cataloged index type name corresponding to said second function name, and when said second function name matches said cataloged first function name, generating an execution plan based on said acquired index-accessing routine-invoking data; and

in executing said execution plan, invoking a revelant routine based on the index-accessing routine-invoking data to access the index corresponding to said acquired index type name.

2. A database management method of performing a processing of a database by invoking a function registered in the database in response to a request of processing, comprising the steps of:

relating with each other and cataloging as index definition information, an index name, an index type name of the index type in an index corresponding to said index name, data configured to invoke an index-accessing routine which accesses an index of said index type, a transformation name of the function, which takes a data type as an input and provides as an output a data type configured to maintain an index of said index type, and a first function name identifying an index-accessing function which accesses said index;

upon reception of said processing request including a second function name, referring to said index definition information to acquire a relevant one of said cataloged index type name corresponding to said second function name, and said data configured to invoke an index-accessing routine which accesses an index of the index type corresponding to said cataloged index type name corresponding to said second function name, and when said second function name matches said cataloged first function name, generating an execution plan based on said acquired index-accessing routine-invoking data; and

in executing said execution plan, invoking a relevant routine based on the acquired index-accessing routine-invoking data to access the index corresponding to said acquired index type name.

3. A database management method of performing a processing of a database by invoking a function registered in the database in response to a request of processing, comprising the steps of:

relating with each other and cataloging as index definition information, an index name, an index type name of the index type in an index corresponding to said index name, data configured to invoke an index-accessing routine which accesses an index of said index type, a transformation function name identifying an input key-generating function which generates an input key configured to maintain said index from values of indexed columns, and a first function name identifying an index-accessing function which accesses said index;

upon reception of said processing request including a second function name, referring to said index definition information to acquire a relevant one of said cataloged index type name corresponding to said second function name, and said data configured to invoke an index-accessing routine which accesses an index of the index type corresponding to said cataloged index type name corresponding to said second function name, and when said second function name matches said cataloged first function name, generating an execution plan based on said acquired relevant index type name; and

in executing said execution plan, referring to said index definition information to acquire data configured to invoke an index-accessing routine which accesses the index of said acquired index type name, and invoking a relevant routine based on the acquired index-accessing routine-invoking data to access the index corresponding to said acquired index type name.