公开(公告)号：US07640276B2

公开(公告)日：2009-12-29

申请号：US11132175

申请日：2005-05-19

申请人： Satoru Watanabe ,  Yoshio Suzuki ,  Shinji Fujiwara

发明人： Satoru Watanabe ,  Yoshio Suzuki ,  Shinji Fujiwara

IPC分类号： G06F17/30

CPC分类号： G06F11/2097 ,  Y10S707/99953

摘要： Provided is a backup method including a step (S1) of reading a log which is a data update difference, and identifying a data storage area (page) of backup data, a step (S2) of determining high/low reusability of the identified data storage area, a step (S3) of storing a log corresponding to a data storage area determined to be low in reusability in a log storage area preset on a memory, and a step (S4) of applying a log corresponding to a data storage area determined to be high in reusability to the identified data storage area in a cache area set on the memory, and updating the data storage area. Thus, by further reducing the number of I/O times in an external storage system of a standby system which backs up data by log transfer, it is possible to reduce introduction costs of a backup system and its normal-time operation's costs at normal times.

摘要翻译： 提供了一种备份方法，包括：读取作为数据更新差异的日志的步骤（S1），以及识别备份数据的数据存储区域（页面）;确定所识别的数据的高/低可重用性的步骤（S2） 存储与预定在存储器上的日志存储区域中存储对应于确定为可重用性低的数据存储区域的日志的步骤（S3）;以及步骤（S4），对应于数据存储区域 被确定为对存储器中设置的高速缓存区域中的识别数据存储区域的可重用性高，并且更新数据存储区域。 因此，通过进一步减少通过日志传送备份数据的备用系统的外部存储系统中的I / O次数，可以降低备用系统的引入成本和正常时间操作的成本 。

公开(公告)号：US07529964B2

公开(公告)日：2009-05-05

申请号：US10930832

申请日：2004-09-01

申请人： Yoshio Suzuki ,  Nobuo Kawamura ,  Kota Yamaguchi ,  Satoru Watanabe ,  Shinji Fujiwara

发明人： Yoshio Suzuki ,  Nobuo Kawamura ,  Kota Yamaguchi ,  Satoru Watanabe ,  Shinji Fujiwara

IPC分类号： G06F11/00

CPC分类号： G06F11/2097 ,  G06F11/1471

摘要： A recovery of a secondary DB is executed by a log including a update difference of a primary DB, and a command is executed by adding the command to the log and analyzing the log by a secondary site. An operation command execution in the secondary site is applied to the DB having the consistency in the transaction at the same timing as a primary site or an intended timing, by transferring and executing the operation command via the log. In the case that the command is constituted by a snap shot generating instruction, a plurality of volumes of a mirror set forming a secondary storage apparatus are set to a pair state and the secondary DB is written in each of the volumes and synchronized, and the mirror set is set to a split state after the synchronization is finished, whereby a secondary DB is stored.

摘要翻译： 辅助DB的恢复由包括主DB的更新差异的日志执行，并且通过将命令添加到日志并通过辅助站点分析日志来执行命令。 通过经由日志传送和执行操作命令，在辅助站点中的操作命令执行以与主站点相同的定时或预期定时被应用于事务中具有一致性的DB。 在命令由快照生成指令构成的情况下，形成副存储装置的多个镜像组的集合被设置为成对状态，并且辅助DB被写入每个卷并同步，并且 镜像集在同步完成后设置为分割状态，从而存储辅助数据块。

公开(公告)号：US20080288497A1

公开(公告)日：2008-11-20

申请号：US11819310

申请日：2007-06-26

申请人： Satoru Watanabe ,  Yoshio Suzuki ,  Shinji Fujiwara ,  Nobuo Kawamura

发明人： Satoru Watanabe ,  Yoshio Suzuki ,  Shinji Fujiwara ,  Nobuo Kawamura

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  G06F17/30362 ,  G06F17/30368

摘要： 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.

摘要翻译： 提供一种能够防止在前一事务的日志写入失败同时减少后续事务的等待时间时发生的问题的技术。 提供一种数据库控制方法，用于在从数据库的操作终端等接收到交易完成指令时释放由交易持有的数据的锁定。 该数据库包括独占控制模块，日志输出模块和日志缓冲区。 日志输出模块在从操作终端接收到交易完成指令时将事务完成日志存储在日志缓冲器中。 独占控制模块在接收到日志缓冲区中的事务完成日志的存储时释放由事务保持的锁定。

公开(公告)号：US20080229140A1

公开(公告)日：2008-09-18

申请号：US11802186

申请日：2007-05-21

申请人： Yoshio Suzuki ,  Nobuo Kawamura ,  Shinji Fujiwara ,  Satoru Watanabe ,  Kazuhiko Mizuno

发明人： Yoshio Suzuki ,  Nobuo Kawamura ,  Shinji Fujiwara ,  Satoru Watanabe ,  Kazuhiko Mizuno

IPC分类号： G06F11/00

CPC分类号： G06F11/2082 ,  G06F11/2074 ,  G06F17/30368 ,  G06F2201/855

摘要： 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).

摘要翻译： 在DR系统中，从设备成本的观点来看，当不进行搜索时，采用廉价DB设备服务器可以进行日志恢复的物理应用。 此外，不执行次要站点处的本地镜像操作。 此外，从操作的观点来看，通过日志应用功能单元，监视日志应用和操作的倾向，并且根据日志应用的进度条件接受搜索处理。 当日志应用程序没有足够的赶上时，搜索不被接受。 此外，当辅助DB的一致性保证被做出时，不是在搜索指令的时刻处理的事务被撤销（回滚），而是仅仅在搜索指令的时刻重新进行正在进行的事务。

公开(公告)号：US20050283504A1

公开(公告)日：2005-12-22

申请号：US10989398

申请日：2004-11-17

申请人： Yoshio Suzuki ,  Nobuo Kawamura ,  Kota Yamaguchi ,  Shinji Fujiwara ,  Satoru Watanabe ,  Masaru Kitsuregawa

发明人： Yoshio Suzuki ,  Nobuo Kawamura ,  Kota Yamaguchi ,  Shinji Fujiwara ,  Satoru Watanabe ,  Masaru Kitsuregawa

IPC分类号： G06F12/00

CPC分类号： G06F11/2028 ,  G06F11/2025 ,  G06F11/2097

摘要： 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).

摘要翻译： 在正常运行期间降低运营和管理成本，同时在不丢失数据库的情况下恢复数据库并维护站点上的在线性能。 第一系统包括存储DB（107）的主存储系统（103）和执行提供DB的主DBMS（101）的主计算机（100）。 第二系统包括次级（113），其从主存储系统（103）接收日志的副本，其显示DB（107）的更新差异，并存储辅助DBMS（117）和子集（500） ），其根据从主存储系统（103）复制的日志恢复辅助DB（117）。 当第一系统发生故障时，第一个系统切换到第二个系统。 执行第二DBMS（111）的第二计算机（110）被添加到第二系统，并且在子集（500）中恢复或正在恢复的辅助DB（117）被接管到第二计算机（110） ）。

公开(公告)号：US07860824B2

公开(公告)日：2010-12-28

申请号：US11802186

申请日：2007-05-21

申请人： Yoshio Suzuki ,  Nobuo Kawamura ,  Shinji Fujiwara ,  Satoru Watanabe ,  Kazuhiko Mizuno

发明人： Yoshio Suzuki ,  Nobuo Kawamura ,  Shinji Fujiwara ,  Satoru Watanabe ,  Kazuhiko Mizuno

IPC分类号： G06F7/00

CPC分类号： G06F11/2082 ,  G06F11/2074 ,  G06F17/30368 ,  G06F2201/855

摘要： 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).

摘要翻译： 在DR系统中，从设备成本的观点来看，当不进行搜索时，采用廉价DB设备服务器可以进行日志恢复的物理应用。 此外，不执行次要站点处的本地镜像操作。 此外，从操作的观点来看，通过日志应用功能单元，监视日志应用和操作的倾向，并且根据日志应用的进度条件接受搜索处理。 当日志应用程序没有足够的赶上时，搜索不被接受。 此外，当辅助DB的一致性保证被做出时，不是在搜索指令的时刻处理的事务被撤销（回滚），而是仅仅在搜索指令的时刻重新进行正在进行的事务。

公开(公告)号：US20060085672A1

公开(公告)日：2006-04-20

申请号：US11012102

申请日：2004-12-16

申请人： Satoru Watanabe ,  Shinji Fujiwara ,  Yoshio Suzuki

发明人： Satoru Watanabe ,  Shinji Fujiwara ,  Yoshio Suzuki

IPC分类号： G06F11/00

CPC分类号： G06F11/1451 ,  G06F11/1471 ,  G06F11/2097

摘要： The invention provides an application technique of a backup data in which a backup data can be utilized by creating a backup data including no indeterminate data in a backup system. In a backup system including a primary system and a backup system, the method of creating the backup data includes: a data update record rerun step for rerunning a data update record to a backup data; and a backup data creation step for starting a read to a backup data B, stopping a read to a backup data A, copying the backup data to the backup data A, starting the read to the backup data A, stopping the read to the backup data B, and copying the backup data A to the backup data B.

摘要翻译： 本发明提供备份数据的应用技术，其中可以通过在备份系统中创建不包括不确定数据的备份数据来利用备份数据。 在包括主系统和备份系统的备份系统中，创建备份数据的方法包括：数据更新记录重新运行步骤，用于将数据更新记录重新运行到备份数据; 以及备份数据创建步骤，用于开始读取备份数据B，停止对备份数据A的读取，将备份数据复制到备份数据A，开始读取备份数据A，停止对备份的读取 数据B，并将备份数据A复制到备份数据B.

公开(公告)号：US08554733B2

公开(公告)日：2013-10-08

申请号：US11152199

申请日：2005-06-15

申请人： Yoshio Suzuki ,  Nobuo Kawamura ,  Kota Yamaguchi ,  Shinji Fujiwara ,  Satoru Watanabe

发明人： Yoshio Suzuki ,  Nobuo Kawamura ,  Kota Yamaguchi ,  Shinji Fujiwara ,  Satoru Watanabe

IPC分类号： G06F17/30

CPC分类号： G06F11/1402 ,  G06F11/2097

摘要： 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.

摘要翻译： 提供了能够实现高速FO并且正确读取日志的灾难恢复技术，即使在主站点中写入的日志单元大。 在包括主站点和子站点的灾难恢复系统中，当在主站点执行由多个日志记录组成的日志块单元的写入，并且日志被应用于子站点时，日志 从子存储器读取块以验证一致性，并且在读取日志时确定读取过程是否通过远程复制操作与写入过程冲突。 然后，只有作为判定结果的读取过程与写入过程不冲突的日志块被应用于数据库。 因此，日志将独立应用于子站点以恢复数据库。

公开(公告)号：US08131679B2

公开(公告)日：2012-03-06

申请号：US11819310

申请日：2007-06-26

申请人： Satoru Watanabe ,  Yoshio Suzuki ,  Shinji Fujiwara ,  Nobuo Kawamura

发明人： Satoru Watanabe ,  Yoshio Suzuki ,  Shinji Fujiwara ,  Nobuo Kawamura

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  G06F17/30362 ,  G06F17/30368

摘要： 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.

摘要翻译： 提供一种能够防止在前一事务的日志写入失败同时减少后续事务的等待时间时发生的问题的技术。 提供了一种数据库控制方法，用于在从数据库的操作终端等接收到交易完成指令时释放由交易持有的数据的锁定。 该数据库包括独占控制模块，日志输出模块和日志缓冲区。 日志输出模块在从操作终端接收到交易完成指令时将事务完成日志存储在日志缓冲器中。 独占控制模块在接收到日志缓冲区中的事务完成日志的存储时释放由事务保持的锁定。

公开(公告)号：US07925633B2

公开(公告)日：2011-04-12

申请号：US10989398

申请日：2004-11-17

申请人： Yoshio Suzuki ,  Nobuo Kawamura ,  Kota Yamaguchi ,  Shinji Fujiwara ,  Satoru Watanabe ,  Masaru Kitsuregawa

发明人： Yoshio Suzuki ,  Nobuo Kawamura ,  Kota Yamaguchi ,  Shinji Fujiwara ,  Satoru Watanabe ,  Masaru Kitsuregawa

IPC分类号： G06F7/00

CPC分类号： G06F11/2028 ,  G06F11/2025 ,  G06F11/2097

摘要： 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).

摘要翻译： 在正常运行期间降低运营和管理成本，同时在不丢失数据库的情况下恢复数据库并维护站点上的在线性能。 第一系统包括存储DB（107）的主存储系统（103）和执行提供DB的主DBMS（101）的主计算机（100）。 第二系统包括从主存储系统（103）接收日志的副本的次要（113），其显示DB（107）的更新差异，并存储辅助DBMS（117）和子集（500） ），其根据从主存储系统（103）复制的日志恢复辅助DB（117）。 当在第一系统中发生故障时，第一系统被切换到第二系统。 执行第二DBMS（111）的第二计算机（110）被添加到第二系统，并且在子集（500）中恢复或正在恢复的辅助DB（117）被接管到第二计算机（110） ）。