Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: [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.

Abstract: A management method and apparatus, and a storage medium, are capable of preventing the deterioration in the response performance of the overall system caused by the imbalance of the load between server apparatuses in a computer system equipped with a distributed shared file system. The management apparatus for managing a computer system is equipped with a distributed shared file system, and in cases where the load of a server containing a certain file is high upon updating that file, it selects another server with a low load as the temporary storage destination of the update data of that file, notifies the selected server as the write destination of the update data to the client, and, at the stage where the load of the server containing the file decreases, instructs the server retaining the update data to transfer the update data to the server containing the file.

Abstract: A performance prediction method, performance prediction system and program for predicting a performance of a monitoring target system including processing devices. A plurality of types of measurement values are acquired from the monitoring target system at regular intervals. A value at a future time of a reference index which is a portion of the measurement values is predicted, and the probability, based on a probability model, that a target event will be generated is calculated, the target event being an event in which a specific measurement value, which is different from the reference index at the future time, lies within the specific range, with the value of the reference index regarded as a prerequisite. An operation results value of the monitoring target system is included in the measurement values and an operation plan value of the monitoring target system is included in the reference index, which is time-series predicted.

Abstract: 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.

Abstract: 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.

Abstract: [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.

Abstract: 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.

Abstract: 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 “update content being reflected”, each system searches the database or the update buffer and then returns the post-update data content to the terminal device.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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 “update content being reflected”, each system searches the database or the update buffer and then returns the post-update data content to the terminal device.

Abstract: 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.