Other

Hitachi, Ltd.

Hitachi Software Engineering Company, Ltd.

Kiyomi Hirohata

Kota Yamaguchi

Kazuo Masai

Keisuke Toda

Hideaki Kasao

Nobuo Kawamura

Norihiro Hara

Tomohiro Nakayama

Norifumi Nishikawa

Shigetoshi Hayashi

Shigekazu Inohara

Tooru Kawashima

Koichi Shimazaki

Masaaki Narita

Hideyuki Kanuka

Ryuichi Hoshino

Takatoshi Ohara

Minoru Tomisaka

Misaki Mito

Kohsaku Yamahira

According to the invention, it is possible to efficiently construct an environment for implementing an IT system. Provided is an environment construction support device. The environment construction support device stores a tree structure model that is information representing an environment for implementing an IT system in a tree structure and can be updated as needed, a construction script structure that is information related to a construction script that is a series of codes for constructing the environment and can be updated as needed, and parameter correspondence information that is information indicating a correspondence between an element of the tree structure model and an element of the construction script, and updates the parameter correspondence information to correspond to latest contents of the tree structure model and the construction script structure by comparing at least one of the tree structure model and the construction script structure with the parameter correspondence information.

Environment construction support device and environment construction support method

Database processing including processing for a shared table is efficiently executed. Processing for a database including a shared table which can be referred to by a plurality of database processing devices is managed. Table information indicating database processing devices allocated according to an attribute of a table in a database and a processing type is referred to via a storage. According to whether or not a processing request for the database includes processing for a shared table, a database processing device to execute the processing request is selected. The database processing request is issued to the selected database processing. According to the database processing request, the database processing device accesses the database.

Method and system of database management with shared area

The present invention relates to an optimization method in a database management system having the function of accessing external databases. Conventionally, whether functions contained in a query can be executed in external databases depends on a database management system having the functions, and therefore there has been a problem in that a database utilization method cannot apply to query optimization and query execution performance is reduced. To solve the above problem, a database management system having the function of accessing external databases is provided with an optimization step comprising the steps of: obtaining specification about whether to execute functions in a query in external databases; determining whether data referred to in a query is confined to one database; and determining whether a user specifies that the functions in the query are executed in external databases.

Database management system, and query method and query execution program in the database management system

A parallel database management system with a database divided into a plurality of external memory units is disclosed. A control CPU, upon receipt of a request for access to the database, decides whether the access request is for storing or searching a record. For a record storage request, the control CPU determines an external memory unit to store the record using a hash function. In the case of a record search request, on the other hand, all the external memory units are searched in parallel without using the hash function thereby to obtain the desired record. The hash function is altered upon addition of an external memory unit.

Parallel database record distribution method and parallel database management system

A database processing system for analyzing a query issued to a database to generate a corresponding execution procedure for performing database processing in accordance therewith. A plurality of columns for storing data each constituted by a set of instances and conditions concerning the instances constituting the plurality of columns are entered. A query is inputted which contains a predicate for evaluating whether a set of instances which meet the designated conditions and which can be identified with the same subscript exists among the sets of instances stored in the plurality of columns. In response to the query, a decision is made as to whether or not an index has been generated for one or plural columns specified in the query predicate. When the index is generated, the index is accessed to acquire an identifier of table data which is &ldquo;true&rdquo; for a predicate. Unless the index is generated, a decision is then made as to whether or not column data acquired by accessing the database meet the conditions specified in the predicate contained in the query.

Database processing method, apparatus for carrying out the same and medium storing processing program

A parallel data base management system with a data base divided into a plurality of external memory units is disclosed. A control CPU, upon receipt of a request for access to the data base, decides whether the access request is for storing or searching a record. For a record storage request, the control CPU determines an external memory unit to store the record using a hash function. In the case of a record search request, on the other hand, all the external memory units are searched in parallel without using the hash function thereby to obtain the desired record. The hash function is altered upon addition of an external memory unit.

Parallel data base record distribution method and parallel data base management system

Parallel data base record distribution method and parallel data base

Growing community of inventors

Yokohama, Japan

Kiyomi Hirohata