Patent application number | Description | Published |
20080301161 | Method and system for data processing with high availability - 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. | 12-04-2008 |
20090013325 | RESOURCE ALLOCATION METHOD, RESOURCE ALLOCATION PROGRAM AND RESOURCE ALLOCATION APPARATUS - 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, extracts at least one SQL process from the SQL, calculates a resource cost of a database required by the BES to perform the SQL process for each of process types contained in the SQL process, decides an allocation ratio 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, and requests for execution of the respective BES on the virtualized server to which the resource has been allocated so as to execute the SQL process. | 01-08-2009 |
20090037381 | Data registration and retrieval method, data registration and retrieval program and database system - A database system registers data unreflected in an index into a registration text buffer. When the database system retrieves a registration text buffer, the database system prepares a registration buffer index using retrieval character indicated by a retrieval request. Thereafter, when a retrieval request is received, an index in a database is retrieved. When there is no pertinent data in the index, the registration buffer index is retrieved. An index indicated by the registration buffer index is used to retrieve the registration text buffer. The database system reflects the registration buffer index in the index at predetermined timing. Thus, even if the number of data registered in the registration text buffer is increased, the retrieval time is not increased. | 02-05-2009 |
20090055444 | Method and System for High-Availability Database - The present invention provides a system switching function for database management systems which requires no standby resources idling during normal operation. One aspect of the invention is directed to a method for processing databases in a system which includes a plurality of storage areas each storing a database and a plurality of computers each having a database management program running thereon which manages one of the plurality of storage areas. Each storage area is associated with only the computer managing the storage area. The method comprises, when a failure has occurred in one of the plurality of computers as a failed computer, obtaining preset substitution information indicating that the storage area managed by the database management program running on the failed computer is to be managed by the database management program running on another one of the plurality of computers as a substitute computer; and, based on the substitution information, changing association of the storage area with the failed computer to the substitute computer. The storage area is to be managed by the database management program running on the substitute computer. | 02-26-2009 |
20090172142 | System and method for adding a standby computer into clustered computer system - 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. | 07-02-2009 |
20090187545 | METHOD AND APPARATUS FOR DATA PROCESSING WITH INDEX SEARCH - 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. | 07-23-2009 |
20090240974 | Data replication method - 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. | 09-24-2009 |
20090307186 | Method and Apparatus for Database Management and Program - A database management apparatus including an auxiliary storage unit for storing structured data and a database management part for managing the structured data, which extracts all paths showing a storage position of the structured data to be processed from an SQL statement for processing the structured data; when a plurality of the paths are extracted, the database management apparatus compares the extracted paths with each other, and extracts as a common path a common part of both the paths; and processes using the SQL statement the structured data of nodes of the storage position or lower shown by the extracted common path. | 12-10-2009 |
20100036894 | DATA SYNCHRONIZATION METHOD, DATA SYNCHRONIZATION PROGRAM, DATABASE SERVER AND DATABASE SYSTEM - A data synchronization method is provided to enhance reliability and performance of the database. The data reflection method selection unit of the active server weights collected values in the resource utilization table by multiplying the collected values by assessment coefficients assigned to the individual collected values in an assessment coefficient table and sums up the weighted values to calculate an assessment value for each data reflection method, and determines the data reflection method whose assessment value is minimum. The log data transmission unit, according to the determined data reflection method, sends log data that is reflected on the active database to the standby server, which forms one of the duplicated servers making up the redundant configuration. The data reflection method identifies the content to be transmitted. | 02-11-2010 |
20100138391 | MANAGEMENT METHOD, MANAGEMENT PROGRAM AND MANAGEMENT APPARATUS OF DATABASE - A database management system includes a backup processing portion and a DB access processing portion. The backup processing portion operates to write data at a given time of a database stored in a storage unit out of the database after the given time as backup data. When an update request for data not written out as the backup data occurs in a data access request after the given time, the DB access processing portion writes the data at the given time out of the database as the backup data and updates the data written out of the database according to the update request. The backup processing portion and the DB access processing portion execute their processes in parallel. | 06-03-2010 |
20100274758 | DATA PROCESSING METHOD, COMPUTER, AND DATA PROCESSING PROGRAM - Provided is a computer system including: an active system; and a standby system. The active system generates, when an update request is received, an after-update log, and sends the after-update log to the standby system at a predetermined timing. The standby system generates a before-update log based on the after-update log sent from the active system and the stored data, updates, after the before-update log is generated, the stored data based on the after-update log, and rolls, when a rollback request is received, the data back to the data before update based on the generated before-update log. Accordingly, it becomes possible to suppress an increase in period of time to reflect the data updated in the active system on the standby system, and to suppress an increase in period of time for rollback of the data performed in the standby system. | 10-28-2010 |
20110035748 | DATA PROCESSING METHOD, DATA PROCESSING PROGRAM, AND DATA PROCESSING SYSTEM - 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. | 02-10-2011 |
20120209891 | DATABASE MANAGEMENT METHOD, DATABASE MANAGEMENT SYSTEM AND DATABASE MANAGEMENT PROGRAM - 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. | 08-16-2012 |
20130159303 | COMPUTER SYSTEM, DATA RETRIEVAL METHOD AND DATABASE MANAGEMENT COMPUTER - 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. | 06-20-2013 |