Hitachi, Ltd.

Hitachi Computer Consultant Ltd.

Shunichi Torii

Masashi Tsuchida

Nobuo Kawamura

Keiji Kojima

Shigeo Nagashima

Koichiro Omoda

Yukio Nakano

Kazuo Masai

Kazuyoshi Negishi

Yasuhiro Inagami

Norihiro Hara

Yoshito Kamegi

Yoshifumi Takamoto

Tsuguo Shimizu

Tsuguo Matsuura

Noriyasu Ido

Akiharu Sakata

Takeshi Maeda

Atsushi Hatakeyama

Yoshito Tsunoda

Hiromichi Fujisawa

Yoshihisa Kamo

Takayuki Nakagawa

Yasusi Kanada

Yoshikazu Tanaka

Masami Takahashi

Hiroshi Yasuoka

Masahiro Hashimoto

Yasushi Kawashimo

Zenji Tsutsumi

Tooru Shonai

Eiji Tatsukawa

A method and a system of database divisional management for use with a parallel database system comprising an FES (front end server), BES's (back end servers), an IOS (I/O server) and disk units. The numbers of processors assigned to the FES, BES's and IOS, the number of disk units, and the number of partitions of the disk units are determined in accordance with the load pattern in question. Illustratively, there may be established a configuration of one FES, four BES's, one IOS and eight disk units. The number of BES's is varied from one to four depending on the fluctuation in load, so that a scalable system configuration is implemented. When the number of BES's is increased or decreased, only the management information thereabout is transferred between nodes and not the data, whereby the desired degree of parallelism is obtained for high-speed query processing.

Method and system of database divisional management for parallel database system

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

A database management system for executing database operations in parallel by a plurality of nodes and a query processing method are described. The database management system contains a decision management node for deciding a distribution node for retrieving information so as to analyze a query received from an application program, generate a processing procedure for processing the query, and execute the process and a join node for sorting, merging, and joining the information retrieved by the distribution node. When the query process is executed, the distribution node decided by the decision management node retrieves the information to be processed and the join node decided by the decision management node also obtains the result for the query from the retrieved information. The query result is outputted from an output node and transferred to the application program.

System and method for implementing hash-based load-balancing query processing in a multiprocessor database system

A database management system for executing database operations in parallel by a plurality of nodes and a query processing method for it are described. The database management system contains a decision management node for deciding a distribution node for retrieving information so as to analyze a query received from an application program, generate a processing procedure for processing the query, and execute the process and a join node for sorting, merging, and joining the information retrieved by the distribution node. When the query process is executed, the distribution node decided by the decision management node retrieves the information to be processed and the join node decided by the decision management node also obtains the result for the query from the retrieved information. The query result is outputted from an output node and transferred to the application program.

Database management apparatus and query operation therefor, including processing plural database operation requests based on key range of hash code

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

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

A database management system for executing database operations in parallel by a plurality of nodes and a query processing method are described. The database management system contains a decision management node for deciding a distribution node for retrieving information so as to analyze a query received from an application program, generate a processing procedure for processing the query, and execute the process, and a join node for sorting, merging, and joining the information retrieved by the distribution node. When the query process is executed, the distribution node decided by the decision management node retrieves the information to be processed and the join node decided by the decision management node also obtains the result for the query from the retrieved information. The query result is outputted from an output node and transferred to the application program.

Database management system and query operation therefor, including processing plural database operation requests based on key range of hash code

A method and a system of database divisional management for use with a parallel database system comprising an FES (front end server), BES's (back end servers), an IOS (I/O server) and disk units. The numbers of processors assigned to the FES, BES's and IOS, the number of disk units, and the number of partitions of the disk units are determined in accordance with the load pattern in question. Illustratively, there may be established a configuration of one FES, four BES's, one IOS and eight disk units. The number of BEST's is varied from one to four depending on the fluctuation in load, so that a scalable system configuration is implemented. When the number of BES's is increased or decreased, only the management information thereabout is transferred between nodes and not the data, whereby the desired degree of parallelism is obtained for high-speed query processing.

Method of executing partition operations in a parallel database system

System and method for implementing parallel operations in a database

A text data registering and retrieving method capable of improving the transaction processing performance is provided. The document number of a document for which deletion or replacement has been newly requested is registered in an updated document number list. The text data of the document for which insertion or replacement has been newly requested is registered in an update text buffer. The text data stored temporarily in the update text buffer is registered in a plural-character occurrence file defining a text index in a character component file merge step. The data registered in the plural-character occurrence file is retrieved for query terms. The text data stored in the update text buffer is retrieved for the query terms. The document number of a document updated or deleted is deleted from the result of retrieval in the plural-character occurrence file. Also, the result or the document number obtained in the, update text buffer is added to the result of retrieval to provide a final retrieval result.

Text data registering and retrieving system including a database storing

Method and system of database divisional management for parallel

Database management system and method for query process for the same

A fast access high capacity data storage system and method are disclosed, the data storage system including a disk-based storage system employing a plurality of storage surfaces. Selected storage surfaces have a plurality of independently controlled data access heads in data communication therewith, and circuitry is provided for allowing concurrent data transfers through the plurality of data access heads. Performance is further improved by monitoring frequently accessed data records and transferring them to a copy recording surface or recording surfaces less frequently used, and by moving a data access head of the plurality of data access heads to other recording surfaces to decrease access bottlenecks. The storage system further includes circuitry for averaging at least one of record length data, transfer timing data, access timing data and address data.

High capacity data storage method and system using independently

Growing community of inventors

Musashino, Japan

Shunichi Torii