Hitachi, Ltd.

Other

Hitachi Software Engineering Company, Ltd.

Norihiro Hara

Masashi Tsuchida

Yukio Nakano

Yoshito Kamegi

Nobuo Kawamura

Morihiro Iwata

Masato Asami

Katsushi Yako

Susumu Kobayashi

Shunichi Torii

Tsunehiko Baba

Tooru Kawashima

Masataka Kan

Yoichi Yamamoto

Masami Hikawa

Akira Shimizu

Tomohiro Hanai

Tetsuya Suzuki

Kiyomi Hirohata

Tomohiro Nakayama

Akira Ito

Masaki Kimura

Kazutomo Ushijima

Tadataka Matsubayashi

Kazuhito Kobayashi

Seisuke Tokuda

Toru Kawashima

Takahiro Yasui

Michiko Tanaka

Youichi Yamamoto

Shinsuke Hamada

Mitsuo Miyazaki

Yoshihide Sato

Masaaki Narita

Kohji Kimura

Shinji Hamada

Shota Kumagai

Noriko Nagae

Takuya Isozaki

Yasuhiro Tahara

Keisuke Matsubara

Ryuichi Hoshino

Sansei Ooshima

Shinichi Hoshino

Kenichi Kaku

Junichiro Soshiki

Kenji Kushi

A data processing system according to an embodiment of the present invention may manage one or more tables and a plurality of archive files including one or more records extracted from the table. Upon receiving a search request for the table, the data processing system may generate a query (first partial query) to search for a record from the table corresponding to a condition specified by the search request, and generate a query (second partial query) to identify the archive file including the record extracted from the table specified as a search target in the search request, and search the identified archive file for the record corresponding to the condition specified by the search request. A query for deriving a union of the output results of the first partial query and the second partial query may be generated, and processing related to the generated query may be executed in parallel.

Data processing system

This database system includes a first site that provides a database and a second site that stores a copy of said database. A first computer for the first site performs database processing and updates the data in the database. A first original storage for the first site transmits data to a second original storage for the second site asynchronously with respect to a database management unit, and a first duplicate storage for the first site transmits data to a second duplicate storage for the second site asynchronously with respect to the database management unit. A second computer for the second site compares the data in the second original storage with the data in the second duplicate with prescribed timing and restores the database if the data in the second original storage and the data in the second duplicate storage do not match.

Database system control method and database system

[Object] A monitoring item selection method, device and a storage medium capable of simplifying operation and management of a system that frequently undergoes configuration changes are proposed. [Solution] Operation information concerning resources in the monitoring target device and nodes that run on the monitoring target device and make use of the resources to execute processing are periodically or randomly acquired from a monitoring target device. A relation between the nodes and a relation between the nodes and the resources based on the acquired operation information are extracted. Monitoring items of the monitoring target device are selected based on the operation information, the extracted relation between the nodes and relation between the nodes and the resources, and a pre-defined condition.

Monitoring item selection method and device, and storage medium

A computer system, comprising: a computer for outputting a result in response to a request; and a storage system for storing data output based on the request, the computer including: a request reception module for receiving the request; a processing procedure generation module for generating a plurality of processing procedures including an order of access to the data stored in the plurality of storage devices; a data division module for dividing the data; an information obtaining module for obtaining load information indicating a load condition of the storage system; an allotment determination module for determining, based on the obtained load information, allotments for allocating the divided data to be processed by the generated plurality of processing procedures; and a processing execution module for executing, based on the determined allotments, the generated plurality of processing procedures in parallel.

Computer system, data retrieval method and database management computer

In a database management method, a first database management apparatus comprises a list which holds storage location information indicating a write destination in a second database for data which is added to a first database, the method comprising a first step whereby, when optional data is added to the first database, the first database management apparatus appends the storage location information from the first list to the data, a second step whereby the first database management apparatus transmits the data to which location information has been appended to second database management apparatus and issues a request to add the data to the second database management apparatus, and a third step whereby the second database management apparatus adds the data to the location in the second database indicated by location information appended to the data in response to the data addition request.

Database management method, database management system and database management program

An execution system executes an update batch according to an update batch execution request from a terminal device and gives a batch execution command to each standby system. Each system stores the content of updated data in its update buffer; and subject to termination of the update batch by each system, the post-update data content is reflected in a database. While the above processing is performed, the execution system and the standby systems accept a reference request from the terminal device; and in a case of 'batch not executed' or 'batch in execution', each system searches the database and then returns the pre-update data content to the terminal device; and in a case of &#x201c;update content being reflected&#x201d;, each system searches the database or the update buffer and then returns the post-update data content to the terminal device.

System for judging an execution status of batch processing, and based on judgement result to send post-update data to terminal device

A resource allocation method, a resource allocation program, and a resource allocation apparatus in which a request reception server subjects an inputted SQL to a syntax analysis. At least one SQL process is extracted from the input SQL, and a resource cost of a database required by a BES (Back End Server) to perform the SQL process for each of one or more process types contained in the SQL process is calculated. Further, an allocation ratio is determined for allocating the resource of a request executing server to a virtualized server in accordance with a resource cost ratio required by each of the BES to execute the SQL process. Additionally, requests are made for execution of the respective BES on the virtualized server to which the resource has been allocated so as to execute the SQL process.

Resource allocation method for a physical computer used by a back end server including calculating database resource cost based on SQL process type

A server to be changed is added to a destination unit in terms of configuration. The server to be changed is started to restore the database in the database storage region to which the server has access and to restore the transaction for the process that was executed when the server failed. The destination of the failed server (a system destination unit) when failure occurs is determined to stabilize the throughput of the entire system after the switchover of the system in the event of failure. The destination server is determined according to an instruction given in advance by the user. The database management system statistically determines the destination server in accordance with a policy designated by the user. Alternatively, the database management system dynamically determines the destination server according to the policy designated by the user when failure occurs.

Method and system for data processing with high availability

There is provided a method of adding a new computer as a standby computer to a computer system that includes an active computer for performing service processing and a standby computer for storing replica of data stored in the active computer. The replica of the data stored in the standby computer is updated when the data stored in the active computer is updated. The method comprising the steps of: selecting the standby computer from the computer system; transferring the replica of the data stored in the selected standby computer to the new computer; and transferring update information on data updated in the active computer after the transferring the replica of the data is started, to the new computer.

System and method for adding a standby computer into clustered computer system

In a database management apparatus for managing a database where an index is used in a search for data, the data is stored in a table that has attributes of the data as columns. The index is created in association with at least one column. The columns include an index key column for which the index is created without data being stored. Upon reception of a request to register the data in the table including the index key column, the data in columns other than the index key column is registered. An index of the index key column is updated using data corresponding to the index key column.

Method and apparatus for data processing with index search

Provided is a method of changing the configuration of a shared-nothing database system without shutting down the system. The configuration changing method for a shared-nothing database system includes plural database servers, a storage which provides data areas to the database servers, and a management server which has a database management system and divides a transaction to allocate pieces of the transaction to the database servers, and the configuration changing method allows no two of the database servers to access the same data area. The configuration changing method changes the configurations of the database servers by specifying which data area is to be reallocated, judging whether or not the specified data area can be reallocated, and reallocating the specified data area without shutting down the database management system when it is judged that the specified data area can be reallocated.

Method for changing configuration of servers in a shared-nothing database system

Provided is a data replication method capable of reducing the number of communication times when a processing result of an active system is replicated to a standby system. The data replication method, in which a first computer receives a first message containing a first processing request, and a plurality of second computers replicates the first message, includes the steps of: sending, by a third computer, the first message to the first computer and the second computers; sending, by each of the second computers, a message receive notification of the first message to the first computer; sending, by the first computer, after reception of the message receive notification from the second computers, the message receive notification of the first message to the third computer; and sending, by the first computer, a notification indicating that the first processing request becomes executable by the first computer to the second computers.

Data replication method

A database processing system including a plurality of partitioned databases. Data processing is performed with pieces of information processing apparatus associated with each of the partitioned databases respectively. In response to a query, a status table indicating availability of each information processing apparatus is read from the storage. Of the pieces of information processing apparatus for processing the received query, at least a serviceable one is determined as a process request destination. A process request corresponding to the query is transmitted to the information processing apparatus determined as the process request destination. The process request is received through a communication unit, and data on the database are consequently processed. A processing result is transmitted to a transmitting source through the communication unit.

Method and system for data processing with parallel database systems

In a system that switches multiple database servers to separate computers, a switching order of the database servers is variably changed and set. In the system that allows an executive system computer and a standby system computer having the database servers to share a database respectively, the system is switched from the database server of the executive system computer to the database server of the standby system computer. Information (order information) that indicates an order in which the system of the executive system database server is switched is registered in a storage device. The order information is changed by detection of the occurrence of an event in the executive system computer. The system switching processing is performed from the executive system database server to the standby system database server in accordance with the changed order information.

System and method for highly available data processing in cluster system

This invention provides a method of controlling switching of computers according to a cause of failure without preparing one standby node for each active node. For n active nodes (), m standby nodes () of different characteristics (in terms of CPU performance, I/O performance, communication performance, and the like) are prepared. The m standby nodes () are assigned in advance with priority levels to be failover targets for each cause of failure. When a failure occurs in one active node (), a standby node that can remove the cause of the failure is chosen out of the m standby nodes () to take over data processing.

Computer system management method, management server, computer system, and program

Growing community of inventors

Kawasaki, Japan

Norihiro Hara