公开(公告)号：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的一致性保证被做出时，不是在搜索指令的时刻处理的事务被撤销（回滚），而是仅仅在搜索指令的时刻重新进行正在进行的事务。

公开(公告)号：US20090248755A1

公开(公告)日：2009-10-01

申请号：US12193978

申请日：2008-08-19

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

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

IPC分类号： G06F17/30

CPC分类号： G06F11/2097 ,  G06F1/3209 ,  G06F11/2038 ,  G06F11/2048

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

摘要翻译： 为了在备用系统的功耗降低的同时基于日志生成备份数据，提供了一种用于数据备份的方法，其中第一计算机系统发送数据更新记录，第二计算机系统的第二存储系统接收然后 存储数据更新记录，并且第二计算机系统的第二计算机基于存储的数据更新记录生成包含在第一计算机系统中的数据的副本，数据备份方法，包括：监视由数据更新记录发送的数据更新记录 第一计算机系统，并且当满足预定的第一条件时停止所述第二计算机; 并且当满足预定的第二条件时，启动第二计算机，从而基于所存储的数据更新记录生成包含在第一计算机系统中的数据的副本。

公开(公告)号：US07587430B2

公开(公告)日：2009-09-08

申请号：US11405464

申请日：2006-04-18

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

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

IPC分类号： G06F17/30

CPC分类号： G06F11/2048 ,  G06F11/2097 ,  G06F2201/80 ,  Y10S707/99952 ,  Y10S707/99953

摘要： Database synchronization processing is completed within a reasonable time, using narrow-band network that connects a primary site to a secondary site, to reduce the running cost of a system. A primary DBMS has a transaction executing unit for reading a primary DB of a primary storage system to update data as requested in an update request, and a write unit for writing the updated data in the primary storage system. The primary storage system includes an unnecessary information removing unit for overwriting an unused area in the written data successively with one of a preset character and a preset value. The primary storage system is connected, via a network, to a second storage system which stores a copy of the primary DB. The primary storage system is connected to the network via a network device which has a data compression unit for compressing a succession of the same value.

摘要翻译： 数据库同步处理在合理的时间内完成，使用将主站点连接到辅助站点的窄带网络，以降低系统的运行成本。 主DBMS具有交易执行单元，用于读取主存储系统的主DB以根据更新请求中的请求更新数据;以及写单元，用于在主存储系统中写入更新的数据。 主存储系统包括不必要的信息删除单元，用于以预设字符和预设值中的一个连续地写入写入数据中的未使用区域。 主存储系统经由网络连接到存储主DB的副本的第二存储系统。 主存储系统经由具有用于压缩相同值的连续数据的数据压缩单元的网络装置连接到网络。

公开(公告)号：US20070203958A1

公开(公告)日：2007-08-30

申请号：US11405464

申请日：2006-04-18

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

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

IPC分类号： G06F17/30

CPC分类号： G06F11/2048 ,  G06F11/2097 ,  G06F2201/80 ,  Y10S707/99952 ,  Y10S707/99953

摘要： Database synchronization processing is completed within a reasonable length of time while employing a narrow-band network as a network that connects a primary site to a secondary site, to thereby reduce the running cost of a system. A primary DBMS (101) has a transaction executing unit (104) for reading a primary DB (119) of a primary storage system (110) to update data as requested in an update request, and a write unit (106) for writing the updated data in the primary storage system (110). The primary storage system (110) includes an unnecessary information removing unit (1400) for overwriting an unused area in the written data successively with one of a preset character and a preset value. The primary storage system (110) is connected, via a network (320), to a second storage system (120) which stores a copy of the primary DB (119). The primary storage system (110) is connected to the network (320) via a network device (140) which has a data compression unit for compressing a succession of the same value.

摘要翻译： 数据库同步处理在合理的时间长度内完成，同时采用窄带网络作为将主站点连接到辅助站点的网络，从而降低系统的运行成本。 主DBMS（101）具有交易执行单元（104），用于读取主存储系统（110）的主DB（119）以更新请求中的请求更新数据;以及写单元（106），用于写入 主存储系统（110）中的更新数据。 主存储系统（110）包括不必要的信息删除单元（1400），用于以预设字符和预设值中的一个连续地重写所写入的数据中的未使用区域。 主存储系统（110）经由网络（320）连接到存储主DB（119）的副本的第二存储系统（120）。 主存储系统（110）经由网络设备（140）连接到网络（320），网络设备（140）具有用于压缩相同值的一系列的数据压缩单元。

公开(公告)号：US20060242370A1

公开(公告)日：2006-10-26

申请号：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分类号： G06F12/16

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.

公开(公告)号：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） ）。

公开(公告)号：US07890467B2

公开(公告)日：2011-02-15

申请号：US11704290

申请日：2007-02-09

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

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

IPC分类号： G06F7/00

CPC分类号： G06F11/2097 ,  G06F11/1004 ,  G06F11/2038

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

摘要翻译： 提供了一种用于验证备份数据的技术，该备份数据能够同步校验和计算的定时和验证数据一致性，而不管数据的存储位置如何。 在使用数据更新日志的备份系统中，检查备份源的数据和备份数据的校验和的校验和，从而验证数据一致性。 提供数据检查日志生成装置等，以便数据更新日志和数据检查日志被发送到次要站点。 通过这种方式，校验和计算的定时是同步的。 此外，通过提供数据区域提取装置等，可以执行数据一致性的验证，而不管数据的存储位置如何。

公开(公告)号：US20060026452A1

公开(公告)日：2006-02-02

申请号：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.