公开(公告)号：US20050240637A1

公开(公告)日：2005-10-27

申请号：US10914095

申请日：2004-08-10

申请人： Nobuo Kawamura

发明人： Nobuo Kawamura

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

CPC分类号： G06F11/1461 ,  G06F11/1451 ,  Y10S707/99955

摘要： The invention relates to backup processing for performing backup of data used in an information processing device having a storage unit. When data has been updated, updated bit information indicating that the data has been updated is stored in an update bitmap management table stored in the storage unit. When the number of updated bit information in the update bitmap management table has reached a differential backup reference value for estimating differential backup time, the backup of data corresponding to the updated information is commanded. When the command for the backup is received, the updated bit information stored in the update bitmap management table in the storage unit is read out. Then, the backup of the data corresponding to the updated bit information is obtained.

摘要翻译： 本发明涉及用于执行在具有存储单元的信息处理设备中使用的数据的备份的备份处理。 当数据被更新时，指示数据被更新的更新位信息被存储在存储在存储单元中的更新位图管理表中。 当更新位图管理表中更新的位信息的数量已经达到用于估计差异备份时间的差异备份参考值时，命令对应于更新信息的数据的备份。 当接收到用于备份的命令时，读出存储在存储单元中的更新位图管理表中的更新的位信息。 然后，获得与更新的位信息相对应的数据的备份。

公开(公告)号：US20050210073A1

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

申请号：US10819191

申请日：2004-04-07

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

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

IPC分类号： G06F3/06 ,  G06F7/00 ,  G06F11/14 ,  G06F11/20 ,  G06F12/00 ,  G06F17/30

CPC分类号： G06F11/2074 ,  G06F11/1471 ,  G06F11/2038 ,  G06F11/2048 ,  G06F11/2064 ,  G06F2201/80

摘要： A disaster recovery system and a method therefor, having: a function for receiving write requests from a host computer to write log information indicating the contents of a database process executed for a database buffer on a main site, database data updated on the database buffer and status information indicating the position of log information used for disaster recovery; a function for transferring the received write request for log information to a recovery site by a synchronous remote copy process; and a function for transferring the received write request for database data to the recovery site by an asynchronous remote copy process. While remote copy can be executed at a long distance without data loss, the deterioration of the performance of a database process on a main site can be suppressed.

摘要翻译： 一种灾难恢复系统及其方法，具有：接收来自主计算机的写入请求的功能，用于写入表示在主站点上为数据库缓冲器执行的数据库处理的内容的日志信息，数据库缓冲器上更新的数据库数据， 指示用于灾难恢复的日志信息的位置的状态信息; 用于通过同步远程复制处理将接收到的日志信息写入请求传送到恢复站点的功能; 以及通过异步远程复制处理将接收的数据库数据写入请求传送到恢复站点的功能。 虽然远程复制可以在没有数据丢失的情况下长时间执行，但是可以抑制主站点上的数据库处理的性能的恶化。

公开(公告)号：US20050193034A1

公开(公告)日：2005-09-01

申请号：US10628516

申请日：2003-07-29

申请人： Masaru Kitsuregawa ,  Nobuo Kawamura ,  Kazuo Masai

发明人： Masaru Kitsuregawa ,  Nobuo Kawamura ,  Kazuo Masai

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

CPC分类号： G06F11/2092 ,  G06F11/1471 ,  G06F11/2048 ,  G06F11/2097 ,  Y10S707/99955

摘要： Judgement is made to determine whether or not an access request from a host computer is a write request and whether or not the contents of the write request are log information indicating contents of database processing executed in a buffer by the host computer. When the contents of the write request are the log information, position information indicated in the log information is converted into physical position information in a primary storage system using a conversion table indicating a correspondence between logical position information recognized by the host computer and physical position information in the primary storage system. According to the contents of the log information, data is updated in a database area of the primary storage system represented by the physical position information converted using the conversion table. The access request is sent to a secondary storage system.

摘要翻译： 进行判断以确定来自主计算机的访问请求是否为写入请求，以及写入请求的内容是否是指示由主计算机在缓冲器中执行的数据库处理的内容的日志信息。 当写请求的内容是日志信息时，在日志信息中指示的位置信息使用表示由主计算机识别的逻辑位置信息与物理位置信息之间的对应关系的转换表转换到主存储系统中的物理位置信息 在主存储系统中。 根据日志信息的内容，在由使用转换表转换的物理位置信息表示的主存储系统的数据库区域中更新数据。 访问请求被发送到辅助存储系统。

公开(公告)号：US09710515B2

公开(公告)日：2017-07-18

申请号：US14404525

申请日：2012-05-31

申请人： Hideomi Idei ,  Norifumi Nishikawa ,  Nobuo Kawamura ,  Kazuhiko Mogi ,  Masaru Kitsuregawa ,  Masashi Toyoda ,  Kazuo Goda

发明人： Hideomi Idei ,  Norifumi Nishikawa ,  Nobuo Kawamura ,  Kazuhiko Mogi ,  Masaru Kitsuregawa ,  Masashi Toyoda ,  Kazuo Goda

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

CPC分类号： G06F17/30445 ,  G06F17/30557

摘要： This analysis system analyzes the behavior of a DBMS in a computer system having a computer which executes tasks in parallel and reads data from a database (DB) when executing a query. This analysis system acquires the number of selected rows corresponding to a key value of an index key used in the query, and calculates a model-based predicted degree of processing parallelism of the processing corresponding to the query. The system acquires, from the storage device, event information on an input-output event with respect to the storage medium when the processing corresponding to the query is executed actually, calculates a measured degree of processing parallelism when the processing corresponding to the query is executed actually, based on the event information, and displays information based on the model-based predicted degree of processing parallelism and the measured degree of processing parallelism.

公开(公告)号：US20150169591A1

公开(公告)日：2015-06-18

申请号：US14402878

申请日：2012-05-24

申请人： Michiko Yoshida ,  Akira Shimizu ,  Seisuke Tokuda ,  Kazuhiko Mogi ,  Shinji Fujiwara ,  Nobuo Kawamura ,  Masaru Kitsuregawa ,  Kazuo Goda

发明人： Michiko Yoshida ,  Akira Shimizu ,  Seisuke Tokuda ,  Kazuhiko Mogi ,  Shinji Fujiwara ,  Nobuo Kawamura ,  Masaru Kitsuregawa ,  Kazuo Goda

IPC分类号： G06F17/30

CPC分类号： G06F16/252 ,  G06F16/24532 ,  G06F16/2455 ,  G06F16/24569

摘要： A database management system (DBMS) manages a database existing in a second storage device with an access speed lower than that of a first storage device. In an execution of a query, the DBMS dynamically generates tasks two or more executable tasks in parallel. The DBMS generates task start information which is information representing a content of the execution of the task, manages the task start information, and executes a content represented by the task start information by the task. The task start information includes a data address set existing in the second storage device. The DBMS controls movement of the data address sets between the first storage device and the second storage device based on a management state of the task start information. In addition, the DBMS selects the task start information based on whether or not the data address set exists in the first storage device.

摘要翻译： 数据库管理系统（DBMS）以比第一存储设备低的访问速度来管理第二存储设备中存在的数据库。 在执行查询时，DBMS并行动态生成任务两个或多个可执行任务。 DBMS生成作为任务执行内容的信息的任务开始信息，管理该任务开始信息，并执行任务开始信息所表示的内容。 任务开始信息包括存在于第二存储装置中的数据地址集。 DBMS基于任务开始信息的管理状态，控制第一存储装置与第二存储装置之间的数据地址集的移动。 另外，DBMS根据第一存储装置中是否存在数据地址组来选择任务开始信息。

公开(公告)号：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并且正确读取日志的灾难恢复技术，即使在主站点中写入的日志单元大。 在包括主站点和子站点的灾难恢复系统中，当在主站点执行由多个日志记录组成的日志块单元的写入，并且日志被应用于子站点时，日志 从子存储器读取块以验证一致性，并且在读取日志时确定读取过程是否通过远程复制操作与写入过程冲突。 然后，只有作为判定结果的读取过程与写入过程不冲突的日志块被应用于数据库。 因此，日志将独立应用于子站点以恢复数据库。

公开(公告)号：US20120151138A1

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

申请号：US13389893

申请日：2010-08-10

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

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

IPC分类号： G06F12/00

CPC分类号： G06F3/0665 ,  G06F3/061 ,  G06F3/064 ,  G06F3/0689

摘要： According to this invention, a data arrangement method, the computer connected to a storage system which provides a plurality of logical storage devices comprising a plurality of physical storage devices arranges data in a logical storage volume constructed by integrating the plurality of logical storage devices. The method includes: a step wherein the computer receives an instruction to build the logical storage volume using the plurality of logical storage devices or to rebuild the constructed logical storage volume; a step wherein the computer obtains information about the plurality of physical storage devices constituting each of the plurality of logical storage devices included in the received instruction; and a step wherein the arrangement position of data into the logical storage volume is determined on the basis of the obtained information about the plurality of physical storage devices.

摘要翻译： 根据本发明，一种数据配置方法，连接到存储系统的计算机，其提供包括多个物理存储装置的多个逻辑存储装置，将数据排列在通过集成多个逻辑存储装置构成的逻辑存储卷中。 该方法包括：一个步骤，其中计算机接收使用多个逻辑存储设备构建逻辑存储卷的指令或重建构造的逻辑存储卷; 计算机获取构成接收到的指令中包含的多个逻辑存储装置中的每一个的多个物理存储装置的信息的步骤; 以及基于获得的关于多个物理存储设备的信息来确定数据到逻辑存储卷中的布置位置的步骤。

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

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

公开(公告)号：US08041674B2

公开(公告)日：2011-10-18

申请号：US12510622

申请日：2009-07-28

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

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

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

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

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

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

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