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

1. 发明授权

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）服务器。服务器使用自己的恢复日志来满足日志需求。

2. 发明授权

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成员的连接。

3. 发明授权

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

4. 发明授权

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

5. 发明授权

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.

6. 发明授权

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地址执行重新同步过程。

7. 发明授权

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过程部署系统将包含过程逻辑组件和数据库请求组件的查询过程从源系统部署到目标系统。在生成查询过程时，系统生成查询过程源代码，符号表和封装的优化结果，以重新生成数据库请求组件的查询语句的运行时指令，并使查询语句具有部署的过程逻辑零件。在部署期间，系统维护程序逻辑组件和数据库请求组件之间的关联。系统将程序逻辑组件的内部表示复制到目标系统，而无需再生。系统重新生成数据库请求组件以在目标系统上重新创建查询过程，并在过程逻辑组件和数据库请求组件之间保持一致的接口。

8. 发明授权

US06542904B2 Method and system for efficiently providing maintenance activity on a relational database that is utilized within a processing system 有权
标题翻译：用于在处理系统内使用的关系数据库上有效提供维护活动的方法和系统
公开(公告)号：US06542904B2
公开(公告)日：2003-04-01
申请号：US09364645
申请日：1999-07-30
申请人： Richard A. Crus , Curt Lee Cotner , Harry Otto Radke , Brian Keith Howell
发明人： Richard A. Crus , Curt Lee Cotner , Harry Otto Radke , Brian Keith Howell
IPC分类号： G06F1730
CPC分类号： G06F17/30595 , Y10S707/99952 , Y10S707/99953
摘要： A method and system for efficiently providing maintenance activity on a relational database that is utilized within a processing system is disclosed. The relational database includes a pool of threads and a plurality of resources. The pool of threads receive requests from a plurality of clients and control the plurality of resources. The method and system comprise determining that a maintenance activity is required and providing a first command that initiates a first process which terminates all threads in the pool of threads if the maintenance activity is required. The method and system further include providing a second command which initiates a second process after the maintenance activity has completed which causes the threads to be created and initiates the processing of requests. A system and method in accordance with the present invention based upon the determination that a maintenance activity is required causes the pool threads within a relational database to terminate and thus free up resources but also allows the connections from the clients to persist. Once the relational database resources are freed, the maintenance activity is performed, and thereafter distributed relational database processing is resumed.
摘要翻译：公开了一种用于在处理系统内利用的关系数据库上有效提供维护活动的方法和系统。关系数据库包括一个线程池和多个资源。线程池接收来自多个客户端的请求并控制多个资源。所述方法和系统包括确定需要维护活动并且提供启动第一进程的第一命令，如果需要维护活动，则终止所述线程池中的所有线程。所述方法和系统还包括提供在维护活动完成之后启动第二进程的第二命令，其导致创建线程并启动请求的处理。基于确定需要维护活动的本发明的系统和方法使得关系数据库内的池线程终止并因此释放资源，而且允许来自客户端的连接持久化。一旦关系数据库资源被释放，则执行维护活动，然后恢复分布式关系数据库处理。

9. 发明授权

US07991796B2 System and program for implementing scrollable cursors in a distributed database system 失效
标题翻译：在分布式数据库系统中实现可滚动光标的系统和程序
公开(公告)号：US07991796B2
公开(公告)日：2011-08-02
申请号：US12348818
申请日：2009-01-05
申请人： Curt Lee Cotner , Margaret A. Dong
发明人： Curt Lee Cotner , Margaret A. Dong
IPC分类号： G06F17/30
CPC分类号： G06F17/30595 , Y10S707/99931
摘要： Provided are a system and program for accessing data in a distributed database environment. A client program receives multiple requests for data from a database object satisfying specified search predicates from an application program. Each request includes a request for at least one row from the table. The client program transfers a database command and a rowset parameter indicating a maximum number of rows to return to a server program over a network if the requested row is not maintained by the client program. A data block is generated with the server program including rows from the database object satisfying the search predicates in response to the database command. The rows included in the data block do not exceed the rowset parameter. The server program transfers the data block to the client program. In turn, the client program returns at least one requested row from the received data block in response to one request for the at least one row of data from the application program.
摘要翻译：提供了一种用于在分布式数据库环境中访问数据的系统和程序。客户程序从满足来自应用程序的指定搜索谓词的数据库对象接收对数据的多个请求。每个请求包括从表中至少一行的请求。如果客户端程序没有维护所请求的行，则客户机程序传送数据库命令和行集参数，指示最大行数返回到网络上的服务器程序。生成数据块，服务器程序包括响应数据库命令满足搜索谓词的数据库对象的行。包含在数据块中的行不超过行集参数。服务器程序将数据块传输到客户端程序。反过来，响应于来自应用程序的至少一行数据的一个请求，客户端程序从接收的数据块返回至少一个所请求的行。

10. 发明授权

US07603336B2 Peephole DBMS reorganization allowing concurrent data manipulation 失效
标题翻译： Peephole DBMS重组允许并发数据操作
公开(公告)号：US07603336B2
公开(公告)日：2009-10-13
申请号：US11313117
申请日：2005-12-19
申请人： Curt Lee Cotner , James Alan Ruddy
发明人： Curt Lee Cotner , James Alan Ruddy
IPC分类号： G06F7/00
CPC分类号： G06F17/30339 , Y10S707/99931 , Y10S707/99942
摘要： A method, apparatus and program storage device readable by a computer tangibly embodying a program of instructions executable by the computer is provided for reorganization of database data. The computer database reorganization method reorganizes one set of database data blocks at a time, allowing concurrent data manipulation. Method identifies a set of data blocks for reorganization in a sliding peephole mode, re-orders the set of data blocks and replaces the original set of data blocks with the re-ordered set of data blocks. The method include an overlapping peephole method, which chooses, for each set of data block to be reorganized, a next succeeding set of data blocks plus an overlap segment, wherein the overlap segment includes a set of empty pages other than intentionally specified free pages, and the overlap segment is a subset of the preceding set of data blocks.
摘要翻译：提供有形地体现由计算机可执行的指令程序的计算机可读的方法，装置和程序存储装置，用于重新组织数据库数据。计算机数据库重组方法一次重组一组数据库数据块，允许并发数据操作。方法识别用于在滑动窥视孔模式中进行重组的一组数据块，重新命令该组数据块，并用重新排列的数据块集替换原始数据块集合。该方法包括重叠窥视孔方法，其针对要重组的每组数据块选择下一个后续数据块集合加上重叠段，其中重叠段包括除有意指定的空闲页之外的一组空页，并且重叠段是前面的数据块集合的子集。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式