-
1.发明授权DBMS backup without suspending updates and corresponding recovery using separately stored log and data files 有权DBMS备份而不会使用单独存储的日志和数据文件挂起更新和相应的恢复公开(公告)号：US07412460B2
公开(公告)日：2008-08-12
申请号：US10600221
申请日：2003-06-19
CPC分类号： G06F11/1466 , G06F11/1471 , G06F2201/80 , Y10S707/99945 , Y10S707/99948 , Y10S707/99953
摘要： A method for performing a system level backup of a log-ahead database management system (DBMS) without suspending updates by application programs is described. The DBMS comprises a database mainline system, a backup utility and a restore utility. The data and log records are stored on separate storage volumes. Log records are written to identify objects that require special handling during the point-in-time recovery. The database engine operates normally during a backup except for suspending actions that would alter the file system catalog or write updates across a storage volume boundary; and by freezing the REDO log point in its checkpoint information. The backup utility copies the data volumes first and optionally the log volumes second while updates are allowed. The resulting inconsistencies are resolved either during a DBMS restart or during a point-in-time (PIT) recovery performed by the restore utility.
摘要翻译： 描述了用于执行日志提前数据库管理系统（DBMS）的系统级备份而不中止应用程序的更新的方法。 DBMS包括数据库主线系统，备份实用程序和恢复实用程序。 数据和日志记录存储在不同的存储卷上。 日志记录被写入以识别在时间点恢复期间需要特殊处理的对象。 数据库引擎在备份期间正常运行，除了挂起将会更改文件系统目录或在存储卷边界上写入更新的操作; 并通过在其检查点信息中冻结REDO日志点。 备份实用程序首先复制数据卷，并可选地备份日志卷，同时允许更新。 在DBMS重新启动期间或在恢复实用程序执行的时间点（PIT）恢复期间，解决了所产生的不一致。
-
2.发明授权System and method for minimizing data outage time and data loss while handling errors detected during recovery 失效减少数据中断时间和数据丢失的系统和方法，同时处理在恢复期间检测到的错误公开(公告)号：US07552147B2
公开(公告)日：2009-06-23
申请号：US11219409
申请日：2005-09-02
申请人： Jeffrey William Josten , Laura Michiko Kunioka-Weis , Thomas Majithia , Haakon Philip Roberts , James Zu-Chia Teng
发明人： Jeffrey William Josten , Laura Michiko Kunioka-Weis , Thomas Majithia , Haakon Philip Roberts , James Zu-Chia Teng
IPC分类号： G06F17/30
CPC分类号： G06F17/30371 , Y10S707/99953
摘要： A system, method a computer usable storage medium tangibly embodying a program of instructions executable by the computer to perform a computer-based method for restoration of a database from a failed data recovery. For each failed data recovery the method generates a log error data set having log records of a faulty transaction unapplied to data due to inconsistency. Log error data set is directly useable by a log analysis tool to regenerate and redo the unapplied faulty transaction to recover the data and by a print log tool to diagnose the faulty transaction. Log records mimic format of records of an archive log data set and identify data objects, faulty transactions on the data objects and a range of the unapplied data objects' updates.
摘要翻译： 一种系统，方法一种计算机可用存储介质，其有形地体现由计算机执行的指令程序，以执行基于计算机的方法，用于从故障数据恢复恢复数据库。 对于每个失败的数据恢复，该方法生成一个日志错误数据集，其中由于不一致性而导致的错误事务的日志记录未应用于数据。 日志错误数据集可以由日志分析工具直接使用，以重新生成并重做未应用的故障事务以恢复数据，并通过打印日志工具来诊断故障事务。 日志记录模拟存档日志数据集记录的格式，并识别数据对象，数据对象上的故障事务和一系列未应用的数据对象的更新。
-
3.发明授权Method and apparatus for ensuring cache coherency for spawned dependent transactions in a multi-system environment with shared data storage devices 有权用于确保在具有共享数据存储设备的多系统环境中的产生的依赖事务的高速缓存一致性的方法和装置公开(公告)号：US06557082B1
公开(公告)日：2003-04-29
申请号：US09539664
申请日：2000-03-30
IPC分类号： G06F1300
CPC分类号： G06F12/0815 , G06F12/0866 , Y10S707/99952
摘要： A method, apparatus and article of manufacture for ensuring cache coherency in a database containing a data store on a central data storage device connected to a plurality of computers. When an immediate write option is set, the data in a local buffer pool changed by a first transaction on a first computer is immediately written to a group buffer pool at the central data storage device, prior to initiating a second transaction upon a second computer that relies upon the modified data. Local buffer pools are then invalidated thereby facilitating local buffer pool updates from the group buffer pool. The immediate write (IW) option may be a subsystem parameter set at a system level or a bind option set at a plan level. The immediate write option may be set so that data is written to the group buffer pool at or before a phase one commit.
摘要翻译： 一种用于确保数据库中的高速缓存一致性的方法，装置和制品，所述数据库包含连接到多个计算机的中央数据存储设备上的数据存储。 当设置立即写入选项时，在第一计算机上由第一事务改变的本地缓冲池中的数据被立即写入中央数据存储设备的组缓冲池，然后在第二计算机上发起第二事务之前， 依赖于修改后的数据。 然后本地缓冲池无效，从而有助于从组缓冲池更新本地缓冲池。 即时写入（IW）选项可以是在系统级别设置的子系统参数或在计划级别设置的绑定选项。 可以设置即时写入选项，以便在第一阶段提交之前或之前将数据写入组缓冲池。
-
4.发明授权Computer program product and program storage device for database access using a shared electronic store in a multi-system environment having shared disks 失效用于在具有共享磁盘的多系统环境中使用共享电子商店进行数据库访问的计算机程序产品和程序存储设备
公开(公告)号：US5761660A
公开(公告)日：1998-06-02
申请号：US691273
申请日：1996-08-01
申请人： Jeffrey William Josten , Tina Louise Masatani , Chandrasekaran Mohan , Inderpal S. Narang , James Zu-Chia Teng
发明人： Jeffrey William Josten , Tina Louise Masatani , Chandrasekaran Mohan , Inderpal S. Narang , James Zu-Chia Teng
CPC分类号： G06F17/30362 , G06F11/1471 , Y10S707/99938 , Y10S707/99952 , Y10S707/99953
摘要： A computer-implemented method for minimizing the amount of time to access current data in a database which may be stored wholly in a DASD-oriented external storage subsystem or partly in DASD and partly in a stored high-speed electronic store while maintaining coherency of the data with respect to multiple user systems.
摘要翻译： 一种计算机实现的方法，用于最小化访问数据库中当前数据的时间量，其可以完全存储在面向DASD的外部存储子系统中，或者部分地存储在DASD中，部分存储在存储的高速电子存储中，同时保持 相对于多个用户系统的数据。
-
公开(公告)号：US07650352B2
公开(公告)日：2010-01-19
申请号：US11277355
申请日：2006-03-23
CPC分类号： G06F17/30371 , G06F17/30336 , G06F17/30368
摘要： A partial index availability system places, in a restricted state, all pages in the index associated with a structure modification, when an error occurs in processing a log of the said structure modification. This maintains traversability of the rest of the index that is not in restricted state. The system locates and marks a left sentinel and a right sentinel associated with a non-leaf page that is in a restricted state preventing an undo of a transaction. The sentinels prevent a transaction from accessing an uncommitted change associated with the non-leaf page. After a recovery procedure is run the entire index is made available. During the period between the placement of the index pages in LPL or rebuild pending to the time of final removal of these pages from their restrictive states as a result of a recovery procedure being run, the users are given access to the non-restricted portion of the index.
摘要翻译： 当处理所述结构修改的日志时，部分索引可用性系统将处于受限状态的所有索引中的与结构修改相关联的所有页面放置。 这样可以保持索引的其余部分的遍历不受限制。 系统定位并标记与处于限制状态的非叶页面相关联的左前哨和右哨兵，以防止撤消交易。 哨兵防止事务访问与非叶页面相关联的未提交的更改。 运行恢复过程后，整个索引可用。 在LPL中的索引页面的放置期间或由于正在运行恢复过程而将这些页面从其限制性状态最终移除到最终删除的时间期间，用户被访问到非限制部分 指数。
-
6.发明授权Efficient sequence number generation in a multi-system data-sharing environment 失效在多系统数据共享环境中生成有效的序列号公开(公告)号：US06952707B1
公开(公告)日：2005-10-04
申请号：US09694185
申请日：2000-10-23
CPC分类号： G06F17/30348 , Y10S707/99938 , Y10S707/99945 , Y10S707/99953
摘要： A method, apparatus, article of manufacture, and data structure for use in efficiently generating sequence numbers in a multi-system data-sharing environment. Sequence number assignment logic, performed by a computer system, generates a recoverable, unique sequence number for assignment to an application, wherein the sequence number is contained in a control page stored in a database on a data storage device coupled to the computer system and shared with other computer systems, and updates to the control page are serialized across all of the computer systems.
摘要翻译： 一种用于在多系统数据共享环境中有效地生成序列号的方法，装置，制品和数据结构。 由计算机系统执行的序列号分配逻辑生成用于分配给应用的可恢复的唯一序列号，其中序列号包含在存储在与计算机系统耦合的数据存储设备上的数据库中的数据库中并且共享 与其他计算机系统，并且控制页面的更新在所有计算机系统上进行序列化。
-
7.发明授权Assigning recoverable unique sequence numbers in a transaction processing system 失效在事务处理系统中分配可恢复的唯一序列号公开(公告)号：US06874104B1
公开(公告)日：2005-03-29
申请号：US09330865
申请日：1999-06-11
CPC分类号： G06F17/30348 , Y10S707/99938 , Y10S707/99945 , Y10S707/99953
摘要： A method, apparatus, article of manufacture, and data structure for use in providing transaction control for a computer-implemented database management system. The database management system manages one or more databases. A transaction processing system provides transaction control for one or more of the databases managed by the database management system, wherein the transaction processing system assigns a recoverable, unique sequence number whenever a request is made by an application.
摘要翻译： 一种用于为计算机实现的数据库管理系统提供事务控制的方法，装置，制造和数据结构。 数据库管理系统管理一个或多个数据库。 事务处理系统为由数据库管理系统管理的数据库中的一个或多个数据库提供事务控制，其中事务处理系统每当应用程序作出请求时分配可恢复的唯一序列号。
-
8.发明授权公开(公告)号：US07743036B2
公开(公告)日：2010-06-22
申请号：US11764962
申请日：2007-06-19
IPC分类号： G06F17/30
CPC分类号： G06F17/30371 , Y10S707/99953
摘要： A shared memory device called the Coupling Facility (CF) is used to record the indoubt transaction entries for each member of the database cluster, avoiding the CPU cost and elapsed time impact of persisting this information to disk (either via a log write or a relational table I/O). The CF provides full read/write access and data coherency for concurrent access by all the members in the database cluster. At any given point in time, the CF will contain the full list of indoubt transactions for the entire database cluster. CF duplexing is used to guarantee the integrity of the CF structure used for the indoubt list. In the event of complete loss of both CF structures (which will not happen except in major disaster situations), data sharing group restart processing can reconstruct the CF structures from the individual member logs.
摘要翻译： 称为耦合设施（CF）的共享内存设备用于记录数据库集群中每个成员的不确定事务条目，从而避免将此信息持续存储在磁盘上的CPU成本和耗时时间（通过日志写入或关系 表I / O）。 CF为数据库集群中的所有成员提供完全读/写访问和数据一致性并发访问。 在任何给定的时间点，CF将包含整个数据库集群的不确定事务的完整列表。 CF双工用于确保用于不确定列表的CF结构的完整性。 在CF结构完全丢失的情况下（除主要灾害情况外不会发生），数据共享组重新启动处理可以从各个成员日志中重构CF结构。
-
9.发明授权公开(公告)号：US07260589B2
公开(公告)日：2007-08-21
申请号：US10726700
申请日：2003-12-04
IPC分类号： G06F17/30
CPC分类号： G06F17/30371 , Y10S707/99953
摘要： A shared memory device called the Coupling Facility (CF) is used to record the indoubt transaction entries for each member of the database cluster, avoiding the CPU cost and elapsed time impact of persisting this information to disk (either via a log write or a relational table I/O). The CF provides full read/write access and data coherency for concurrent access by all the members in the database cluster. At any given point in time, the CF will contain the full list of indoubt transactions for the entire database cluster. CF duplexing is used to guarantee the integrity of the CF structure used for the indoubt list. In the event of complete loss of both CF structures (which will not happen except in major disaster situations), data sharing group restart processing can reconstruct the CF structures from the individual member logs.
摘要翻译： 称为耦合设施（CF）的共享内存设备用于记录数据库集群中每个成员的不确定事务条目，从而避免将此信息持续存储在磁盘上的CPU成本和耗时时间（通过日志写入或关系 表I / O）。 CF为数据库集群中的所有成员提供完全读/写访问和数据一致性并发访问。 在任何给定的时间点，CF将包含整个数据库集群的不确定事务的完整列表。 CF双工用于确保用于不确定列表的CF结构的完整性。 在CF结构完全丢失的情况下（除主要灾害情况外不会发生），数据共享组重新启动处理可以从各个成员日志中重构CF结构。
-
公开(公告)号：US07120746B2
公开(公告)日：2006-10-10
申请号：US10238465
申请日：2002-09-09
申请人： John Joseph Campbell , David Arlen Elko , Jeffrey William Josten , Haakon Philip Roberts , David Harold Surman
发明人： John Joseph Campbell , David Arlen Elko , Jeffrey William Josten , Haakon Philip Roberts , David Harold Surman
IPC分类号： G06F12/00
CPC分类号： G06F12/0866 , G06F12/084 , G06F12/0891
摘要： Disclosed is a system, method, and program for transferring data. When a transaction commits, multiple data objects that have been changed by the transaction are identified. The multiple data objects are written from local storage to a cache structure using a batch write command. When changed data objects at a first system that are not cached in the shared external storage are written to disk, a batch cross invalidation command is used to invalidate the data objects at a second system. Additionally, multiple data objects are read from the cache structure into a processor storage using a batch castout command.
摘要翻译： 公开了一种用于传送数据的系统，方法和程序。 当事务提交时，会识别由事务更改的多个数据对象。 使用批量写入命令将多个数据对象从本地存储器写入高速缓存结构。 当未被缓存在共享外部存储器中的第一个系统上的更改数据对象被写入磁盘时，使用批次交叉无效命令使第二个系统上的数据对象无效。 另外，使用批量转换命令将多个数据对象从高速缓存结构读取到处理器存储器中。
-
-
-
-
-
-
-
-
-
搜索结果
11 条记录 (耗时 0.023 秒)
