专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US06874104B1 Assigning recoverable unique sequence numbers in a transaction processing system 失效
标题翻译：在事务处理系统中分配可恢复的唯一序列号
公开(公告)号：US06874104B1
公开(公告)日：2005-03-29
申请号：US09330865
申请日：1999-06-11
申请人： Jeffrey William Josten , Chandrasekaran Mohan , Inderpal Singh Narang
发明人： Jeffrey William Josten , Chandrasekaran Mohan , Inderpal Singh Narang
IPC分类号： G06F11/00 , G06F17/30
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.
摘要翻译：一种用于为计算机实现的数据库管理系统提供事务控制的方法，装置，制造和数据结构。数据库管理系统管理一个或多个数据库。事务处理系统为由数据库管理系统管理的数据库中的一个或多个数据库提供事务控制，其中事务处理系统每当应用程序作出请求时分配可恢复的唯一序列号。

2. 发明授权

US5761660A 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
IPC分类号： G06F12/00 , G06F11/14 , G06F17/30
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中，部分存储在存储的高速电子存储中，同时保持相对于多个用户系统的数据。

3. 发明授权

US07552147B2 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.
摘要翻译：一种系统，方法一种计算机可用存储介质，其有形地体现由计算机执行的指令程序，以执行基于计算机的方法，用于从故障数据恢复恢复数据库。对于每个失败的数据恢复，该方法生成一个日志错误数据集，其中由于不一致性而导致的错误事务的日志记录未应用于数据。日志错误数据集可以由日志分析工具直接使用，以重新生成并重做未应用的故障事务以恢复数据，并通过打印日志工具来诊断故障事务。日志记录模拟存档日志数据集记录的格式，并识别数据对象，数据对象上的故障事务和一系列未应用的数据对象的更新。

4. 发明授权

US06557082B1 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
申请人： Jeffrey William Josten , James Zu-Chia Teng
发明人： Jeffrey William Josten , James Zu-Chia Teng
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）选项可以是在系统级别设置的子系统参数或在计划级别设置的绑定选项。可以设置即时写入选项，以便在第一阶段提交之前或之前将数据写入组缓冲池。

5. 发明授权

US06952707B1 Efficient sequence number generation in a multi-system data-sharing environment 失效
标题翻译：在多系统数据共享环境中生成有效的序列号
公开(公告)号：US06952707B1
公开(公告)日：2005-10-04
申请号：US09694185
申请日：2000-10-23
申请人： Jeffrey William Josten
发明人： Jeffrey William Josten
IPC分类号： G06F11/00 , G06F17/30
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.
摘要翻译：一种用于在多系统数据共享环境中有效地生成序列号的方法，装置，制品和数据结构。由计算机系统执行的序列号分配逻辑生成用于分配给应用的可恢复的唯一序列号，其中序列号包含在存储在与计算机系统耦合的数据存储设备上的数据库中的数据库中并且共享与其他计算机系统，并且控制页面的更新在所有计算机系统上进行序列化。

6. 发明授权

US07412460B2 DBMS backup without suspending updates and corresponding recovery using separately stored log and data files 有权
标题翻译： DBMS备份而不会使用单独存储的日志和数据文件挂起更新和相应的恢复
公开(公告)号：US07412460B2
公开(公告)日：2008-08-12
申请号：US10600221
申请日：2003-06-19
申请人： Namik Hrle , Jeffrey William Josten , Thomas Majithia , James Zu-chia Teng
发明人： Namik Hrle , Jeffrey William Josten , Thomas Majithia , James Zu-chia Teng
IPC分类号： G06F7/00 , G06F17/00
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）恢复期间，解决了所产生的不一致。

7. 发明授权

US07743036B2 High performance support for XA protocols in a clustered shared database 有权
标题翻译：在群集共享数据库中对XA协议的高性能支持
公开(公告)号：US07743036B2
公开(公告)日：2010-06-22
申请号：US11764962
申请日：2007-06-19
申请人： Curt Lee Cotner , Brian K. Howell , Jeffrey William Josten , James Willis Pickel
发明人： Curt Lee Cotner , Brian K. Howell , Jeffrey William Josten , James Willis Pickel
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结构。

8. 发明授权

US07650352B2 System and method for increasing availability of an index 有权
标题翻译：提高索引可用性的系统和方法
公开(公告)号：US07650352B2
公开(公告)日：2010-01-19
申请号：US11277355
申请日：2006-03-23
申请人： You-Chin Fuh , Sauraj Goswami , Jeffrey William Josten , James Zu-Chia Teng
发明人： You-Chin Fuh , Sauraj Goswami , Jeffrey William Josten , James Zu-Chia Teng
IPC分类号： G06F7/00 , G06F17/30
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中的索引页面的放置期间或由于正在运行恢复过程而将这些页面从其限制性状态最终移除到最终删除的时间期间，用户被访问到非限制部分指数。

9. 发明授权

US07260589B2 High performance support for XA protocols in a clustered shared database 有权
标题翻译：在群集共享数据库中对XA协议的高性能支持
公开(公告)号：US07260589B2
公开(公告)日：2007-08-21
申请号：US10726700
申请日：2003-12-04
申请人： Curt Lee Cotner , Brian K. Howell , Jeffrey William Josten , James Willis Pickel
发明人： Curt Lee Cotner , Brian K. Howell , Jeffrey William Josten , James Willis Pickel
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结构。

10. 发明授权

US07120746B2 Technique for data transfer 有权
标题翻译：数据传输技术
公开(公告)号：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.
摘要翻译：公开了一种用于传送数据的系统，方法和程序。当事务提交时，会识别由事务更改的多个数据对象。使用批量写入命令将多个数据对象从本地存储器写入高速缓存结构。当未被缓存在共享外部存储器中的第一个系统上的更改数据对象被写入磁盘时，使用批次交叉无效命令使第二个系统上的数据对象无效。另外，使用批量转换命令将多个数据对象从高速缓存结构读取到处理器存储器中。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式