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

1. 发明授权

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结构。

2. 发明授权

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结构。

3. 发明授权

US06031978A System, method and program for enabling a client to reconnect to a same server in a network of computer systems after the server has moved to a different network address 失效
标题翻译：系统，方法和程序，用于在服务器移动到不同的网络地址后，使客户端能够重新连接到计算机系统网络中的同一服务器
公开(公告)号：US06031978A
公开(公告)日：2000-02-29
申请号：US674239
申请日：1996-06-28
申请人： Curt Lee Cotner , James Willis Pickel
发明人： Curt Lee Cotner , James Willis Pickel
IPC分类号： G06F17/30 , H04L29/06 , H04L29/12 , G06F13/00
CPC分类号： G06F17/30575 , H04L29/06 , H04L29/12009 , H04L61/00 , H04L67/42 , Y10S707/99953
摘要： The system, method and program of this invention provides a technique that enables a client, connected by a network, such as TCP/IP, to a multi-server system, such as a parallel database management system, to locate a server product that may have moved to a different network address within the multi-server system. More specifically, the client is able to perform two-phase commit and automatic resynchronization with a same DBMS server that may have moved to a new network address before a transaction with the client was committed. In order to complete the two-phase resynchronization process for uncompleted units of work, the client system has to reestablish connection to the previously connected DBMS member.
摘要翻译：本发明的系统，方法和程序提供了一种使诸如TCP / IP之类的网络连接的客户机能够等待诸如并行数据库管理系统的多服务器系统来定位可能已经移动到多服务器系统中的不同网络地址。更具体地说，客户端能够在与客户端的交易提交之前，与可能移动到新的网络地址的同一个DBMS服务器执行两阶段提交和自动重新同步。为了完成未完成工作单元的两相重新同步过程，客户端系统必须重新建立与先前连接的DBMS成员的连接。

4. 发明授权

US06247055B1 System, method and program for enabling a client to reconnect to a same server in a network of computer systems after the server has moved to a different network address 失效
标题翻译：系统，方法和程序，用于在服务器移动到不同的网络地址后，使客户端能够重新连接到计算机系统网络中的同一服务器
公开(公告)号：US06247055B1
公开(公告)日：2001-06-12
申请号：US09109528
申请日：1998-07-02
申请人： Curt Lee Cotner , James Willis Pickel
发明人： Curt Lee Cotner , James Willis Pickel
IPC分类号： G06F1516
CPC分类号： G06F17/30575 , H04L29/06 , H04L29/12009 , H04L61/00 , H04L67/42 , Y10S707/99953
摘要： A client connected to a multi-server system, (e.g., a parallel database management system) can locate a server product that may have moved to a different network address within the multi-server system. For example, a client is able to perform two-phase commit and automatic resynchronization with a same DBMS server that may have moved to a new network address before a transaction was committed. A unique resync port number is assigned to each server member when the server member is started up. The server's physical IP address and resync number are stored in a list in a global area accessible by each server member. When a client establishes a connection to a server member, the client will receive the server member's resync number or the global list. The client records the server's unique resync number in the client's dataset. If the client experiences a communication failure with that server, the client will send a message to a Domain Name Server requesting an IP address of any active server in the network. Upon receipt of an address, the client will send a connect message to that address. Upon receipt of the connection request message, that server can either send to the client a copy of the global list as part of the initial handshaking or scan the list and send to the client the IP address corresponding to the resync number of the desired server member. The client performs a resynchronization process via the IP address associated with that resync port number.
摘要翻译：连接到多服务器系统（例如，并行数据库管理系统）的客户机可以定位可能移动到多服务器系统内的不同网络地址的服务器产品。例如，客户端能够在事务提交之前与同一DBMS服务器执行两阶段提交和自动重新同步，该服务器可能已经移动到新的网络地址。当服务器成员启动时，将为每个服务器成员分配唯一的重新同步端口号。服务器的物理IP地址和重新同步号码存储在每个服务器成员可访问的全局区域的列表中。当客户端建立与服务器成员的连接时，客户端将收到服务器成员的重新同步号码或全局列表。客户端在客户端数据集中记录服务器的唯一重新同步号码。如果客户端与该服务器发生通信故障，客户端将向域名服务器发送一条消息，请求网络中任何活动服务器的IP地址。收到地址后，客户端将向该地址发送连接消息。在接收到连接请求消息时，该服务器可以向客户端发送全局列表的副本作为初始握手的一部分或扫描列表，并向客户端发送与所需服务器成员的重新同步号码相对应的IP地址。客户端通过与该重新同步端口号相关联的IP地址执行重新同步过程。

5. 发明授权

US5884327A System, method and program for performing two-phase commit with a coordinator that performs no logging 失效
标题翻译：使用不执行日志记录的协调器执行两阶段提交的系统，方法和程序
公开(公告)号：US5884327A
公开(公告)日：1999-03-16
申请号：US719523
申请日：1996-09-25
申请人： Curt Lee Cotner , Richard Anthony Crus , Brian Keith Howell , James Willis Pickel , David Joseph Wisneski
发明人： Curt Lee Cotner , Richard Anthony Crus , Brian Keith Howell , James Willis Pickel , David Joseph Wisneski
IPC分类号： G06F11/14 , G06F17/30 , G06F17/00
CPC分类号： G06F17/30377 , Y10S707/99938 , Y10S707/99952 , Y10S707/99953
摘要： The system, method, and program of this invention allows a two-phase commit protocol to work properly, even when the client acting as the coordinator does not have a log to record two-phase state information. In a preferred embodiment, the client in a client/server distributed transaction processing system is a personal computer. The client, without a recovery log, acts as a coordinator of a commit process. The coordinator migrates, i.e., passes, responsibility for resynchronization, and any associated logging requirement, to a server, e.g., to any of the connected relational database management system (RDBMS) servers, which is a participant in the transaction. The server uses its own recovery log for use in satisfying the logging requirement.
摘要翻译：本发明的系统，方法和程序允许两阶段提交协议正常工作，即使当作为协调器的客户端没有记录来记录两相状态信息时。在优选实施例中，客户端/服务器分布式事务处理系统中的客户端是个人计算机。没有恢复日志的客户端充当提交进程的协调器。协调者迁移，即将重新同步的责任和任何关联的记录要求传递给服务器，例如，作为交易参与者的任何连接的关系数据库管理系统（RDBMS）服务器。服务器使用自己的恢复日志来满足日志需求。

6. 发明授权

US07711746B2 System and method for deploying an SQL procedure 有权
标题翻译：用于部署SQL过程的系统和方法
公开(公告)号：US07711746B2
公开(公告)日：2010-05-04
申请号：US11311810
申请日：2005-12-17
申请人： Margaret Ann Bernal , Yao-Ching Stephen Chen , Ding-Wei Chieh , Curt Lee Cotner , Baoqiu Cui , Tammie Dang , Marion B. Farber , Georgia Carroll Fuller , Joe Cheng-yu Huang , Hui-An Lee , Claire Willey McFeely , Chunfeng Pei , James Willis Pickel , Yumi Kimura Tsuji , Jay A. Yothers , Margaret Alice Zagelow , Liyan Zhou
发明人： Margaret Ann Bernal , Yao-Ching Stephen Chen , Ding-Wei Chieh , Curt Lee Cotner , Baoqiu Cui , Tammie Dang , Marion B. Farber , Georgia Carroll Fuller , Joe Cheng-yu Huang , Hui-An Lee , Claire Willey McFeely , Chunfeng Pei , James Willis Pickel , Yumi Kimura Tsuji , Jay A. Yothers , Margaret Alice Zagelow , Liyan Zhou
IPC分类号： G06F7/00
CPC分类号： G06F17/30587
摘要： An SQL procedure deployment system deploys a query procedure comprising a procedural logic component and a database request component from a source system to a target system. At generation of the query procedure, the system generates a query procedure source code, a symbol table, and an encapsulated optimization results to regenerate run-time instructions for query statements of the database request component and make the query statements function with a deployed procedural logic component. The system maintains an association between the procedural logic component and the database request component during deployment. The system copies an internal representation of the procedural logic component to the target system without regeneration. The system regenerates the database request component to recreate the query procedure on the target system and to maintain a consistent interface between the procedural logic component and database request component.
摘要翻译： SQL过程部署系统将包含过程逻辑组件和数据库请求组件的查询过程从源系统部署到目标系统。在生成查询过程时，系统生成查询过程源代码，符号表和封装的优化结果，以重新生成数据库请求组件的查询语句的运行时指令，并使查询语句具有部署的过程逻辑零件。在部署期间，系统维护程序逻辑组件和数据库请求组件之间的关联。系统将程序逻辑组件的内部表示复制到目标系统，而无需再生。系统重新生成数据库请求组件以在目标系统上重新创建查询过程，并在过程逻辑组件和数据库请求组件之间保持一致的接口。

7. 发明授权

US07136847B2 Method and system for dynamically changing cursor attributes in an embedded SQL application 有权
公开(公告)号：US07136847B2
公开(公告)日：2006-11-14
申请号：US09944939
申请日：2001-08-31
申请人： Tammie Dang , William Robert Bireley , Curt Lee Cotner , Claire Willey McFeely , James Willis Pickel , Koichi Yamaguchi
发明人： Tammie Dang , William Robert Bireley , Curt Lee Cotner , Claire Willey McFeely , James Willis Pickel , Koichi Yamaguchi
IPC分类号： G06F17/30
CPC分类号： G06F17/30386 , Y10S707/99933 , Y10S707/99934
摘要： Aspects for dynamically changing attributes in an embedded-SQL application are described. In these aspects, an option is provided within a standard SQL statement for specifying one or more attributes of at least a declared cursor. The standard SQL statement is then processed to include the specified one or more attributes in at least the declared cursor. The provision occurs with an ATTRIBUTES option and within a PREPARE SQL statement.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式