公开(公告)号：US07991749B2

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

申请号：US12329143

申请日：2008-12-05

申请人： Norifumi Nishikawa ,  Takashi Oeda ,  Nobuo Kawamura ,  Kazuhiko Mogi

发明人： Norifumi Nishikawa ,  Takashi Oeda ,  Nobuo Kawamura ,  Kazuhiko Mogi

IPC分类号： G06F17/30

CPC分类号： G06F11/1471 ,  G06F2201/80 ,  G06F2201/84 ,  Y10S707/99945 ,  Y10S707/99953

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

摘要翻译： 一种包括计算机和存储系统的数据库恢复方法，其中：存储系统包括用于存储数据的磁盘驱动器; 磁盘驱动器包括数据卷，快照卷，用于存储更新日志的数据库日志和用于存储数据卷的更新信息的更新日志; 记录用于指示要应用更新日志的范围的终点的恢复点和要应用数据库日志的范围的起始点，以恢复数据量; 要恢复数据库时，将更新日志应用于直到恢复点的快照卷，将更新后的快照卷切换到数据卷，并将恢复点后的数据库日志应用于数据 通过切换设置的音量。

公开(公告)号：US20100293156A1

公开(公告)日：2010-11-18

申请号：US12712662

申请日：2010-02-25

申请人： Michiko Tanaka ,  Kazutomo Ushijima ,  Akira Shimizu ,  Seisuke Tokuda ,  Shinji Fujiwara ,  Nobuo Kawamura

发明人： Michiko Tanaka ,  Kazutomo Ushijima ,  Akira Shimizu ,  Seisuke Tokuda ,  Shinji Fujiwara ,  Nobuo Kawamura

IPC分类号： G06F17/30

CPC分类号： G06F17/30306

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

摘要翻译： 提供了一种数据库处理系统，包括：计算机，用于响应于接收的查询请求输出数据; 以及存储系统，包括用于存储数据的存储装置，其中：所述存储装置存储指示所述数据的存储位置的多个部分索引; 存储在存储设备中的数据被分组; 并且计算机被配置为：接收对数据的查询请求; 获取所述多个部分索引中的一个; 基于所述数据的查询请求和所述多个部分索引中获取的一个部分索引，指定存储所请求的数据的位置; 并发送请求以将存储在指定位置的数据存储到存储系统。 因此，在数据库处理系统中，输入和输出数据所需的时间段被缩短。

公开(公告)号：US20100121824A1

公开(公告)日：2010-05-13

申请号：US12651752

申请日：2010-01-04

申请人： Nobuo Kawamura ,  Kota Yamaguchi ,  Takashi Oeda

发明人： Nobuo Kawamura ,  Kota Yamaguchi ,  Takashi Oeda

IPC分类号： G06F17/00 ,  G06F7/00 ,  G06F12/16 ,  G06F12/00

CPC分类号： G06F11/2074 ,  G06F11/2076 ,  Y10S707/99953

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

摘要翻译： 提供了一种能够构建灾难恢复系统的技术，降低了主系统的性能下降。 该技术包括当从主计算机接收的写请求是日志信息的写请求时，将日志信息同步写入次系统中的次存储子系统的步骤，临时存储写请求并进行异步写入的步骤 当所接收到的写入请求是数据库数据或状态信息的写入请求时，进入辅助存储子系统，根据所接收到的写入请求的内容，修改日志信息，数据库区域中的数据和辅助存储子系统中的状态信息 以及根据状态信息指示的位置中的日志信息的内容来恢复数据库区域的步骤。

公开(公告)号：US07567989B2

公开(公告)日：2009-07-28

申请号：US11065361

申请日：2005-02-25

申请人： Eiji Yatabe ,  Nobuo Kawamura ,  Yasuhiro Takahashi ,  Hideaki Sunami

发明人： Eiji Yatabe ,  Nobuo Kawamura ,  Yasuhiro Takahashi ,  Hideaki Sunami

IPC分类号： G06F12/00 ,  G06F17/30

CPC分类号： G06F17/30581 ,  Y10S707/99953

摘要： To guarantee that contents of an update by a transaction in a parallel database management system. A 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.

摘要翻译： 通过并行数据库管理系统中的事务来保证更新的内容。 数据库管理系统包括管理副本数据库的副本数据库管理单元，在每个数据库管理单元中生成的交易中的一个有效的定时记录同步信息，在每个数据库管理单元中记录其他事务无效的提取更新信息 以及用于从更新日志创建副本数据库的同步信息，并且使副本数据库管理单元在记录同步信息之前导入已变为有效的每个事务的更新信息。

公开(公告)号：US20090024384A1

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

申请号：US12232336

申请日：2008-09-16

申请人： Susumu Kobayashi ,  Yukio Nakano ,  Nobuo Kawamura ,  Masashi Tsuchida ,  Shunichi Torii

发明人： Susumu Kobayashi ,  Yukio Nakano ,  Nobuo Kawamura ,  Masashi Tsuchida ,  Shunichi Torii

IPC分类号： G06F17/20

CPC分类号： G06F17/2863 ,  G06F17/275 ,  G06F17/289

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

摘要翻译： 数据库访问管理单元管理对由每种数据类型提供的多个数据处理服务器管理的数据库的访问。 请求分析单元分析来自包含每个数据类型的处理请求的应用的请求。 处理服务器选择单元根据数据类型选择用于执行数据处理的数据处理服务器。 数据处理请求单元请求数据处理服务器执行数据处理。 处理结果编辑单元通过数据处理服务器编辑处理结果。

公开(公告)号：US20080208923A1

公开(公告)日：2008-08-28

申请号：US11704290

申请日：2007-02-09

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

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

IPC分类号： G06F12/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.

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

公开(公告)号：US07353335B2

公开(公告)日：2008-04-01

申请号：US11396644

申请日：2006-04-04

申请人： Nobuo Kawamura

发明人： Nobuo Kawamura

IPC分类号： G06F17/30 ,  G06F3/06 ,  G06F12/00

CPC分类号： G06F11/2071 ,  G06F11/2074 ,  G06F11/2076 ,  G06F17/30312 ,  G06F17/30368 ,  Y10S707/99953

摘要： The present invention is constituted so as to enable the recovery of a database even when a log comprising a DB update history is not created. When executing a transaction in the logless mode, a logless-start log is created and written to a primary log VOL 55A at the start of this transaction, and this logless-start log is also written to a secondary log VOL 55B. Thereafter, batch processing is carried out for a DB of a primary DB VOL 51A, and while this transaction is being executed, the pair-split state of the DB VOL is cancelled either prior to the start or after the end of the batch processing, and if the difference between the DB VOLs is eliminated subsequent to the end of batch processing, a logless-end log is created and written to the primary log VOL 55A, and this log is also written to the secondary log VOL 55B.

摘要翻译： 本发明构成为即使在不创建包含DB更新历史的日志的情况下也能够恢复数据库。 在无日志模式下执行事务时，将在此事务开始时创建一个无日志启动日志并将其写入主日志VOL 55 A，并将此无启动日志写入辅助日志VOL 55 B.此后 对于主DB VOL 51A的DB执行批量处理，并且在执行该事务时，在批处理开始之前或之后取消DB VOL的成对拆分状态， 并且如果在批量处理结束之后消除DB VOL之间的差异，则创建无log-end日志并将其写入主日志VOL 55 A，并且该日志也被写入辅助日志VOL 55B。

公开(公告)号：US07321907B2

公开(公告)日：2008-01-22

申请号：US10929699

申请日：2004-08-30

申请人： Masashi Tsuchida ,  Nobuo Kawamura ,  Nobuyuki Yamashita

发明人： Masashi Tsuchida ,  Nobuo Kawamura ,  Nobuyuki Yamashita

IPC分类号： G06F17/30

CPC分类号： G06F11/2094 ,  G06F11/2097 ,  G06F17/30575 ,  G06F2201/80 ,  Y10S707/954 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99934 ,  Y10S707/99938 ,  Y10S707/99945 ,  Y10S707/99953 ,  Y10S707/99955

摘要： The system manages at least a database in multiple database storage units, and the database is duplicated for redundancy. The system maintains the database redundancy for security. The system enables the maintenance and reorganization of the database storage units without interrupting the on-going operations involving the access to the database storage units. The non-stop ongoing database access is available by allocating a pair of a main storage unit and an intermediate storage unit that maintains the substantially identical data. During certain predetermined operations, the main storage unit is being dedicating to the on-going transactions while the intermediate database storage unit is manipulated to contain data that corresponds to a specified time. For example, the content of the intermediate storage is subsequently copied or used to update another database. When the above duplication or incorporation is completed, the intermediate storage unit is updated for the transactions that have taken place during the above operations to be synchronized with the main storage unit.

摘要翻译： 该系统至少管理多个数据库存储单元中的数据库，并且重复数据库以进行冗余。 系统维护数据库冗余以实现安全。 该系统能够维护和重组数据库存储单元，而不会中断正在进行的涉及对数据库存储单元的访问的操作。 可以通过分配一对主存储单元和维持基本上相同的数据的中间存储单元来获得不间断的数据库访问。 在某些预定操作期间，主存储单元被专用于正在进行的事务，而中间数据库存储单元被操纵以包含对应于指定时间的数据。 例如，中间存储器的内容随后被复制或用于更新另一个数据库。 当上述复制或并入完成时，中间存储单元被更新为在上述操作期间发生的与主存储单元同步的事务。

公开(公告)号：US07263580B2

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

申请号：US10849022

申请日：2004-05-20

申请人： Hiroyasu Kiba ,  Nobuo Kawamura

发明人： Hiroyasu Kiba ,  Nobuo Kawamura

IPC分类号： G06F12/00

CPC分类号： G06F12/0804 ,  G06F12/0866

摘要： A data processing system is used which is provided with a computer for executing a program, and a storage unit having a cache memory for storing data transmitted as a result of execution of the program and a disk device for storing data stored in the cache memory. The storage unit responds to an input of a request for storing data transmitted from the program to store the transmitted data in the cache memory. Next, the storage unit responds to an input of a request for flashing transmitted from the program to store, in the disk device, the data stored in the cache memory.

摘要翻译： 使用具有用于执行程序的计算机的数据处理系统，以及具有用于存储作为执行程序的结果而发送的数据的高速缓冲存储器的存储单元和用于存储存储在高速缓冲存储器中的数据的盘装置。 存储单元响应于从程序发送的数据存储请求的输入，以将所发送的数据存储在高速缓冲存储器中。 接下来，存储单元响应于从程序发送的用于闪存的请求的输入，以在盘设备中存储存储在高速缓存存储器中的数据。

公开(公告)号：US07194486B2

公开(公告)日：2007-03-20

申请号：US10932100

申请日：2004-09-02

申请人： Taichi Ishikawa ,  Nobuo Kawamura

发明人： Taichi Ishikawa ,  Nobuo Kawamura

IPC分类号： G06F12/00 ,  G06F17/30

CPC分类号： G06F17/30575

摘要： A data processing apparatus includes a storage device having a replication generation function for replicating a data base to create a replication data base, and stores data and a plurality of log information in transaction processing that uses the data in the storage device, selects a transaction that is performing a data operation without meeting a predetermined condition after synchronization between the data base and the replication data base is released, and performs the data operation cancellation processing to the replication data base by the selected transaction. It also selects a transaction, which meets the predetermined condition and is not performing a data operation to the replication data base, to perform a data operation to the replication data base with the selected transaction. It then becomes possible to reduce the burden for the data processing apparatus during using the replication data base.

摘要翻译： 数据处理装置包括具有用于复制数据库以创建复制数据库的复制生成功能的存储装置，并且将数据和多个日志信息存储在使用存储装置中的数据的事务处理中， 在数据库和复制数据库之间的同步之后不执行预定条件执行数据操作，并且通过所选择的事务对复制数据库执行数据操作取消处理。 它还选择满足预定条件并且不对复制数据库执行数据操作的事务，以便利用所选择的事务对复制数据库执行数据操作。 因此，可以减少使用复制数据库期间的数据处理装置的负担。