Patent application number | Description | Published |
20080208923 | Method for verifying data consistency of backup system, program and storage medium - A technology for verifying backup data capable of synchronizing timings of checksum calculation and verifying data consistency regardless of the storing position of the data is provided. In a backup system using a data update log, a checksum of data of a backup source and a checksum of backup data are checked, thereby verifying data consistency. Data check log generation means and the like are provided so that the data update log and the data check log are transmitted in order to a secondary site. By this means, the timings of the checksum calculation are synchronized. Further, by providing data area extraction means and the like, the verification of data consistency can be performed regardless of the storing position of the data. | 08-28-2008 |
20080229140 | System and method of disaster recovery - In a DR system, from the viewpoint of device cost, when search is not carried out, a physical application where log recovery is available by inexpensive DB appliance server is adopted. Further, a local mirror operation at a secondary site is not carried out. Furthermore, from the viewpoint of operation, by a log apply function unit, the tendencies of a log application and operations are monitored, and a search process is accepted according to the progress conditions of the log application. When the log application does not catch up sufficiently, the search is not accepted. Moreover, when a consistency guarantee of a secondary DB is made, not transactions in process at the moment of search instruction are undone (rolled back), but only transactions in process at the moment of a search instruction are redone (rolled forward). | 09-18-2008 |
20080288497 | Exclusive control method for database and program - A technology capable of preventing a problem which occurs when log writing of a preceding transaction fails while reducing waiting time of a subsequent transaction is provided. A database control method for releasing locking of data held by a transaction upon reception of a transaction completion instruction from an operation terminal or the like by a database is provided. The database includes an exclusive control module, a log output module, and a log buffer. The log output module stores a transaction completion log in the log buffer upon reception of the transaction completion instruction from the operation terminal. The exclusive control module releases locking held by the transaction upon reception of storage of the transaction completion log in the log buffer. | 11-20-2008 |
20090024384 | Data processing method and system, program for realizing the method, and computer readable storage medium storing the program - A database access management unit manages accesses to databases managed by a plurality of data processing servers each provided for each data kind. A request analysis unit analyzes a request from an application containing a process request for each data kind. A process server selection unit selects the data processing server for executing a data process in accordance with the data kind. A data process request unit requests the data processing server to execute the data process. A process result edition unit edits the process result by the data processing server. | 01-22-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 |
20090125568 | DATABASE RECOVERY METHOD APPLYING UPDATE JOURNAL AND DATABASE LOG - A database recovery method including a computer and a storage system, in which: the storage system includes a disk drive for storing data; the disk drive includes a data volume, a snapshot volume, a database log for storing an update log, and an update journal for storing update information of the data volume; a recovery point for indicating an end point of a range to which the update journal is to be applied and a starting point of a range to which the database log is to be applied is recorded to recover the data volume; and when the database is to be recovered, the update journal is applied to the snapshot volume up to the recovery point, the snapshot volume after the update is switched to the data volume, and the database log after the recovery point is applied to the data volume that is set by switching. | 05-14-2009 |
20090248755 | SYSTEM AND METHOD FOR DATA BACKUP USING LOG RECORDS - To generate backup data based on a log while a power consumption of a standby system is reduced, provided is a method for data backup in which a first computer system transmits a data update record, a second storage system of a second computer system receives and then stores the data update record, and a second computer of the second computer system generates a copy of data contained in the first computer system based on the stored data update record, the method for data backup, including: monitoring the data update record transmitted by the first computer system, and stopping, when a predetermined first condition is satisfied, the second computer; and starting, when a predetermined second condition is satisfied, the second computer, thereby generating the copy of the data contained in the first computer system based on the stored data update record. | 10-01-2009 |
20090287749 | METHOD AND SYSTEM FOR DATA PROCESSING WITH DATA REPLICATION FOR THE SAME - To guarantee the contents of an update by a transaction in a parallel database management system, the database management system includes a replica database management unit that manages the replica database, records synchronous information at a timing at which one of the transaction generated is valid in every database management unit and other transactions are invalid in every database management unit, extracts update information and the synchronous information for creating the replica database from the update logs, and causes the replica database management unit to import the update information of each transaction that has become valid before the synchronous information was recorded. | 11-19-2009 |
20100036890 | DATABASE MANAGEMENT METHOD, DATABASE MANAGEMENT APPARATUS, AND DATABASE MANAGEMENT PROGRAM - In order to reduce a period of time required for a database operation and maintenance job, provided is a database management method in a database management apparatus that manages a database stored in a storage apparatus including: executing load processing of storing data which is read from the storage apparatus in a memory; executing job processing by reading and writing the data which is stored in the memory; executing unload processing of writing the data which is stored in the memory in the storage apparatus; and executing maintenance processing for the database using the data which is stored in the memory at timing for executing at least one of the load processing and the unload processing. | 02-11-2010 |
20100121824 | DISASTER RECOVERY PROCESSING METHOD AND APPARATUS AND STORAGE UNIT FOR THE SAME - A technique capable of constructing a disaster recovery system reduced in performance degradation of a primary system is provided. The technique includes a step of conducting synchronous writing of log information into a secondary storage subsystem in a secondary system when a write request received from a host computer is a write request of log information, a step of temporarily storing a write request and conducting asynchronous writing into the secondary storage subsystem when the received write request is a write request of database data or status information, a step of modifying log information, data in a database area, and status information in the secondary storage subsystem according to contents of a write request received from a primary storage subsystem, and a step of recovering the database area according to contents of log information in a location indicated by the status information. | 05-13-2010 |
20100211577 | DATABASE PROCESSING SYSTEM AND METHOD - Provided is a database system in which sorting of query results is sped up. The database system stores storage location information in which storage locations of the pieces of data are recorded in a given order. When there is no second task, which is executed based on data that is fetched in a first task, whether every piece of data requested in a third task, which is executed before the first task, has been fetched is determined. In the case where every piece of data requested in the third task has been fetched, data fetched in the first task is output. In the case where some of the data requested in the third task has not been fetched, data fetched in the first task is kept in a temporary buffer until every piece of data requested in the third task is fetched, and then output. | 08-19-2010 |
20100293156 | DATABASE PROCESSING METHOD AND DATABASE PROCESSING SYSTEM - Provided is a database processing system including: a computer for outputting data in response to a received query request; and a storage system including a storage device for storing the data, in which: the storage device stores a plurality of partial indices indicating a storage location of the data; the data stored in the storage device is grouped; and the computer is configured to: receive the query request for the data; acquire one of the plurality of partial indices; specify, based on the query request for the data and the acquired one of the plurality of partial indices, a location at which the requested data is stored; and send a request to acquire the data stored at the specified location to the storage system. Accordingly, in the database processing system, a time period necessary to input and output the data is shortened. | 11-18-2010 |
20120151138 | DATA ARRANGEMENT METHOD AND DATA MANAGEMENT SYSTEM - According to this invention, a data arrangement method, the computer connected to a storage system which provides a plurality of logical storage devices comprising a plurality of physical storage devices arranges data in a logical storage volume constructed by integrating the plurality of logical storage devices. The method includes: a step wherein the computer receives an instruction to build the logical storage volume using the plurality of logical storage devices or to rebuild the constructed logical storage volume; a step wherein the computer obtains information about the plurality of physical storage devices constituting each of the plurality of logical storage devices included in the received instruction; and a step wherein the arrangement position of data into the logical storage volume is determined on the basis of the obtained information about the plurality of physical storage devices. | 06-14-2012 |
20130144867 | DATABASE PROCESSING METHOD, DATABASE PROCESSING SYSTEM AND DATABASE SERVER - It is provided a database processing method including: a first step of receiving a query request instructing to output the requested data as query results in a designated order; a second step of generating a query execution plan including an order of accessing tables for storing the data based on the received query request; a third step of acquiring the data requested based on the query request from the database based on the generated query execution plan; a fourth step of generating intermediate results including the acquired data; a fifth step of sorting the generated intermediate results in the designated order; a sixth step of judging, for each of the intermediate results, whether an order of the sorted intermediate results has been determined; and a seventh step of outputting the intermediate results whose order has been determined as the query results in order from a head thereof. | 06-06-2013 |
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 |