Method of processing a synchronization point in a database management
system to assure a database version using update logs from accumulated
transactions
    61.
    发明授权
    Method of processing a synchronization point in a database management system to assure a database version using update logs from accumulated transactions 失效
    在数据库管理系统中处理同步点的方法,以确保使用来自累积事务的更新日志的数据库版本

    公开(公告)号:US5778388A

    公开(公告)日:1998-07-07

    申请号:US529176

    申请日:1995-09-15

    IPC分类号: G06F11/14 G06F12/00 G06F17/30

    摘要: In a database management method and a database management system in which transactions need not be stopped at a synchronization point (syncpoint) acquired at a fixed interval of time, when a point to acquire a syncpoint is reached in a database control procedure, a syncpoint acquisition start log is output and then a syncpoint acquisition flag is set ON in a page control table of each updated page existing in a buffer pool. In the operation, a list of update page control tables is also created to write in the database the pages which are indicated in the list thus prepared. However, for a transaction accessing the pertinent updated page prior to the write operation thereof in the database, the data write operation is performed before the page is referenced, thereby enabling the access to be performed to the database without interrupting the transaction.

    摘要翻译: 在数据库管理方法和数据库管理系统中,其中事务不需要在以固定时间间隔获取的同步点(syncpoint)停止,当在数据库控制过程中达到获取同步点的点时,同步点获取 输出开始日志,然后在存储在缓冲池中的每个更新页面的页面控制表中将同步点获取标志设置为ON。 在操作中,还创建了更新页面控制表的列表,以便在数据库中写入由此准备的列表中指示的页面。 然而,对于在其在数据库中的写入操作之前访问相关更新页面的事务,在引用页面之前执行数据写入操作,从而使得能够对数据库执行访问而不中断事务。

    System and method for data backup using log records
    62.
    发明授权
    System and method for data backup using log records 有权
    使用日志记录进行数据备份的系统和方法

    公开(公告)号:US08190580B2

    公开(公告)日:2012-05-29

    申请号:US12193978

    申请日:2008-08-19

    IPC分类号: G06F17/30

    摘要: To generate backup data based on a log while a power consumption of a standby system is reduced, method for data backup is provided 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 includes 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.

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

    Database recovery method applying update journal and database log
    63.
    发明授权
    Database recovery method applying update journal and database log 有权
    应用更新日志和数据库日志的数据库恢复方法

    公开(公告)号:US07991749B2

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

    申请号:US12329143

    申请日:2008-12-05

    IPC分类号: G06F17/30

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

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

    DISASTER RECOVERY PROCESSING METHOD AND APPARATUS AND STORAGE UNIT FOR THE SAME
    64.
    发明申请
    DISASTER RECOVERY PROCESSING METHOD AND APPARATUS AND STORAGE UNIT FOR THE SAME 审中-公开
    灾难恢复处理方法及其设备和存储单元

    公开(公告)号:US20100121824A1

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

    申请号:US12651752

    申请日:2010-01-04

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

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

    Method and system for data processing with data replication for the same
    65.
    发明授权
    Method and system for data processing with data replication for the same 有权
    用于数据复制的数据处理方法和系统相同

    公开(公告)号:US07567989B2

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

    申请号:US11065361

    申请日:2005-02-25

    IPC分类号: G06F12/00 G06F17/30

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

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

    Data processing method and system, program for realizing the method, and computer readable storage medium storing the program
    66.
    发明申请
    Data processing method and system, program for realizing the method, and computer readable storage medium storing the program 审中-公开
    数据处理方法和系统,用于实现该方法的程序,以及存储程序的计算机可读存储介质

    公开(公告)号:US20090024384A1

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

    申请号:US12232336

    申请日:2008-09-16

    IPC分类号: G06F17/20

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

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

    Method for verifying data consistency of backup system, program and storage medium
    67.
    发明申请
    Method for verifying data consistency of backup system, program and storage medium 有权
    验证备份系统,程序和存储介质的数据一致性的方法

    公开(公告)号:US20080208923A1

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

    申请号:US11704290

    申请日:2007-02-09

    IPC分类号: G06F12/00

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

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

    Storage control method for database recovery in logless mode
    68.
    发明授权
    Storage control method for database recovery in logless mode 有权
    数据恢复存储控制方法

    公开(公告)号:US07353335B2

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

    申请号:US11396644

    申请日:2006-04-04

    申请人: Nobuo Kawamura

    发明人: Nobuo Kawamura

    IPC分类号: G06F17/30 G06F3/06 G06F12/00

    摘要: 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。

    Method and system for managing multiple database storage units
    69.
    发明授权
    Method and system for managing multiple database storage units 失效
    用于管理多个数据库存储单元的方法和系统

    公开(公告)号:US07321907B2

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

    申请号:US10929699

    申请日:2004-08-30

    IPC分类号: G06F17/30

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

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

    Cache flush based on checkpoint timer
    70.
    发明授权
    Cache flush based on checkpoint timer 有权
    基于检查点计时器的缓存刷新

    公开(公告)号:US07263580B2

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

    申请号:US10849022

    申请日:2004-05-20

    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.

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