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

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