摘要:
A disaster recovery technology capable of achieving the high-speed FO and correctly reading the logs even if the unit of logs written in the main site is large is provided. In the disaster recovery system comprising a main site and a sub-site, when the writing in units of a log block consisting of a plurality of log records is performed in the main site and the logs are applied in the sub-site, the log blocks are read from the sub-storage to verify the consistency, and it is determined whether the reading process conflicts with the writing process through the remote copy operation when reading the logs. Then, only the log blocks in which the reading process does not conflict with the writing process as a result of the determination are applied to the database. Thereby, the logs are applied in the sub-site independently to recover the database.
摘要:
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.
摘要:
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.
摘要:
To reduce operational and management costs during normal operations while recovering a database without loss and maintaining on-line performance on a site. A first system includes a primary storage system (103) that stores a DB (107) and a main computer (100) that executes a primary DBMS (101), which provides a DB. A second system includes a secondary (113) that receives from the primary storage system (103) a copy of a log, which shows update differences of the DB (107), and stores a secondary DBMS (117), and a subset (500) that recovers the secondary DB (117) according to the log that is copied from the primary storage system (103). When a failure occurs in the first system, the first system is switched to the second system. A second computer (110) that executes a second DBMS (111) is added to the second system, and the secondary DB (117) that is recovered or is being recovered in the subset (500) is taken over to the second computer (110).
摘要:
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.
摘要:
A management device stores configuration history information indicating a history of system configuration changes, from this information, specifies a system configuration of a recovery time, which is a certain point in time in the past, specifies a system configuration of the current time, and compares the system configuration of the recovery time with the system configuration of the current time, and based on the results of this comparison, specifies whether or not there is a system configuration part in the system configuration of the current time for which, if data of the recovery time is recovered, a setting change is required in order to access this recovered data. When this system configuration part is specified, the management device constructs a system configuration for enabling a data utilization unit to access the recovered data by issuing an indication related to a required setting change to an element capable of carrying out the setting change for this system configuration part.
摘要:
Provided is a storage system in which a transaction of a database is quiesced, a pair of a first volume and a second volume is split so as to make settings to allow an access to be made only to the database in the first volume, the transaction is then released from the quiescent state, a sparse space is specified in the database stored in the second volume, only the specified sparse space in the second volume is partially reorganized, and the contents of the partially reorganized second volume are copied to the first volume such that the first volume and the second volume are resynchronized with each other to form the pair again.
摘要:
A database system for storing table data as divided in a plurality of storages has a processing request acceptance section and an execution section which, at the time of rebalancing already stored data in response to addition of a storage, can execute inquiry operations concurrently. The system determines data to be moved from existing storages to the additional storage. When search, update and delete processing requests are issued during execution of the rebalance operation of copying the data to the additional storage and deleting the original data, both the DBMS acceptance section and DBMS executor section execute the operation corresponding to the requests. When an insert processing request is issued, the system determines a data insert destination on the basis of contents of a step of dividing the data from the existing storages to the additional storage.
摘要:
A computer is used in a computer system including multiple physical storage areas for storing database data. The database includes component information having a reference item having plural value ranges. The database data is dividable according to value ranges of the reference item. The computer comprises an access frequency obtaining module and a data allocation module. The access frequency obtaining module obtains, for each value range of the reference item in the component information, an estimated access frequency for data of the component information. The data allocation module allocates, based on the obtained estimated access frequency, data of the component information divided according to the value ranges of the reference item to the physical storage areas to be stored.
摘要:
A pattern forming apparatus brings a masking panel having a pattern-like through hole into tight contact with the inside surface of a front panel, and positions the through hole to the inside of a recess of the front panel. In this state, liquid developer is supplied through a developing roller, and an electric field passing through a developing recess where the recess and through hole are continued. Therefore, charged developer particles are collected in the developing recess, and the recess of the front panel is developed.