Hitachi, Ltd.

Yoshito Kamegi

Masashi Tsuchida

Norihiro Hara

Yukio Nakano

Morihiro Iwata

Masato Asami

Susumu Kobayashi

Nobuo Kawamura

Shunichi Torii

Youichi Yamamoto

Yoichi Yamamoto

Kazuaki Tanaka

Shigeru Yoneda

Satoshi Wakayama

Mikihiko Tokunaga

Ichiro Yokoyama

Tomoto Shimizu

Takeshi Kamoshida

Eiji Kaneko

Makoto Urakawa

Kiyotaka Kiyasu

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.

Database processing method and system

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.

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

A request accepting server accepts a processing request of data of a predetermined type, analyzes the request, and allocates a process corresponding to the request to either one of the request accepting server and at least one database processing server. A handle is a control block to manage a storage area of data as a processing target and has a server in which the processing target data has been stored and information regarding its storing position. When the processing target data corresponding to the processing request is processed in accordance with the processing request, the request accepting server executes a process according to the processing request by using a handle regarding the processing target data. When an entity of the processing target data is necessary the entity of the processing target data is obtained on the basis of the handle and is processed.

Database processing method and apparatus using handle

In a database management system including a request reception server and a plurality of execution servers, each having a plug-in program module incorporated by a user, the request reception server analyzes a processing request from the user to determine whether or not the plurality of execution servers require currently unidentified input parameters when executing external functions in their plug-in modules, based on a definition information table created from descriptions of interface specifications for the plug-in program modules. When it is determined that the execution servers require such input parameters, an external function in the plug-in program module in the request reception server is executed to previously acquire the unidentified input parameters. The request reception server creates an execution processing procedure code, to be executed by the plurality of execution servers, assuming that the unidentified input parameters have already been inputted, and passes the execution processing procedure code together with the input parameters acquired by the request reception server to the plurality of execution servers.

Database processing method and apparatus for processing data by analyzing query input

A newly defined data type is added to a database management system. Information about a query component assisting in querying data belonging to the newly defined data type is registered along with data type information in a query component information. If the data type being queried is the newly added data type, the query component information is searched to find a query component for assisting queries to data belonging to the particular data type. The matching query component is activated and a screen is displayed to input information needed to the query data belonging to the data type. The information is input and a query statement is generated using the inputted information. The generated query statement is issued to the database management system and query results are obtained.

Method for querying a database in which a query statement is issued to a database management system for which data types can be defined

A method and a system for executing a general database processing independent of a specific user-defined function are provided. In an implementation method, 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 in response to a processing request for the database issued from an end user, that the user-defined function contained therein 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 from the module definition information, and a database processing is performed using the implementation module thus selected.

Database management method of invoking a function retrieving index type definition, cataloging particular index which has not yet been supported by a database system

An overloaded routines resolving method of analyzing an invocation for the group of overloaded routines to determine the routine to be called, the method including: the routine group sorting step of sorting the group of routines on the basis of the predetermined precedence; the reference utilization pruning step of determining the routine which has the highest precedence of a data type of an argument from among the routines which can be called for the types in the definition of the arguments of the invocation from the sorted routines and of deleting any of the routines each of which has the lower precedence than that of the routine thus determined from the candidates; and the sort order characteristic pruning step of comparing the data types of the arguments among the routines which still remain after having executed the reference utilization pruning step to delete any of the routines each of which has no possibility of being called from the candidates. From the foregoing, the necessary minimum candidate can be selected efficiently in the overloaded routines resolution which is carried out when analyzing the query for the database.

Method of resolving overloaded routines, system for implementing the same and medium for storing processing program therefor

A newly defined data type is added to a database management system. Information about a query component assisting in querying data belonging to the newly defined data type is registered along with data type information in a query component information. If the data type being queried is the newly added data type, the query component information is searched to find a query component for assisting queries to data belonging to the particular data type. The matching query component is activated and a screen is displayed to input information needed to query data belonging to the data type. The information is input and a query statement is generated using the inputted information. The generated query statement is issued to the database management system and query results are obtained.

A request accepting server accepts a processing request of data of a predetermined type, analyzes the request, and allocates a process corresponding to the request to either one of the request accepting server and at least one database processing server. A handle is a control block to manage a storage area of data as a processing target and has a server in which the processing target data has been stored and information regarding its storing position. When the processing target data corresponding to the processing request is processed in accordance with the processing request, the request accepting server executes a process according to the processing request by using a handle regarding the processing target data. When an entity of the processing target data is necessary, the entity of the processing target data is obtained on the basis of the handle and is processed.

In a parallel database system having an execution device on a front end side and a plurality of execution devices on a database operation side (hereinafter referred to as the &ldquo;divided data side&rdquo;), the front end side analyzes a definition statement of a routine such as a function or a procedure inputted from a user to create routine execution process instructions for executing the routine. Simultaneously, the front end side determines whether or not a database operation statement is contained in the routine, and creates check information indicative of the determination result. The front end side analyzes a query statement inputted from the user to create a first query execution process instruction to be executed on the front end side and a second query execution process instruction to be executed on the divided data side. When the divided data side executes the query in accordance with the second query execution process instruction, a routine containing no database operation statement in the second query statement process instruction is executed on the divided data side.

Routine executing method in database system

Method and system for database processing by invoking a function related to index type definition, generating an execution plan based on index type name

Parallel database management method and parallel database management system

In a parallel database system having an execution device on a front end side and a plurality of execution devices on a database operation side (hereinafter referred to as the 'divided data side'), the front end side analyzes a definition statement of a routine such as a function or a procedure inputted from a user to create routine execution process instructions for executing the routine. Simultaneously, the front end side determines whether or not a database operation statement is contained in the routine, and creates check information indicative of the determination result. The front end side analyzes a query statement inputted from the user to create a first query execution process instruction to be executed on the front end side and a second query execution process instruction to be executed on the divided data side. When the divided data side executes the query in accordance with the second query execution process instruction, a routine containing no database operation statement in the second query statement process instruction is executed on the divided data side.

Growing community of inventors

Yokohama, Japan

Yoshito Kamegi