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

1. 发明授权

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

2. 发明授权

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.
摘要翻译：提供了一种用于在分布式数据库环境中访问数据的系统和程序。客户程序从满足来自应用程序的指定搜索谓词的数据库对象接收对数据的多个请求。每个请求包括从表中至少一行的请求。如果客户端程序没有维护所请求的行，则客户机程序传送数据库命令和行集参数，指示最大行数返回到网络上的服务器程序。生成数据块，服务器程序包括响应数据库命令满足搜索谓词的数据库对象的行。包含在数据块中的行不超过行集参数。服务器程序将数据块传输到客户端程序。反过来，响应于来自应用程序的至少一行数据的一个请求，客户端程序从接收的数据块返回至少一个所请求的行。

3. 发明授权

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.
摘要翻译：提供有形地体现由计算机可执行的指令程序的计算机可读的方法，装置和程序存储装置，用于重新组织数据库数据。计算机数据库重组方法一次重组一组数据库数据块，允许并发数据操作。方法识别用于在滑动窥视孔模式中进行重组的一组数据块，重新命令该组数据块，并用重新排列的数据块集替换原始数据块集合。该方法包括重叠窥视孔方法，其针对要重组的每组数据块选择下一个后续数据块集合加上重叠段，其中重叠段包括除有意指定的空闲页之外的一组空页，并且重叠段是前面的数据块集合的子集。

4. 发明授权

US07487159B2 Method implementing scrollable cursors in a distributed database system 有权
标题翻译：在分布式数据库系统中实现可滚动游标的方法
公开(公告)号：US07487159B2
公开(公告)日：2009-02-03
申请号：US11146516
申请日：2005-06-06
申请人： Curt Lee Cotner , Margaret A. Dong
发明人： Curt Lee Cotner , Margaret A. Dong
IPC分类号： G06F17/30
CPC分类号： G06F17/30595 , Y10S707/99931
摘要： Provided is a method 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.
摘要翻译：提供了一种在分布式数据库环境中访问数据的方法。客户程序从满足来自应用程序的指定搜索谓词的数据库对象接收对数据的多个请求。每个请求包括从表中至少一行的请求。如果客户端程序没有维护所请求的行，则客户机程序传送数据库命令和行集参数，指示最大行数返回到网络上的服务器程序。生成数据块，服务器程序包括响应数据库命令满足搜索谓词的数据库对象的行。包含在数据块中的行不超过行集参数。服务器程序将数据块传输到客户端程序。反过来，响应于来自应用程序的至少一行数据的一个请求，客户端程序从接收的数据块返回至少一个所请求的行。

5. 发明授权

US06978261B2 Using database management system's infrastructure to invoke a stored procedure for creating and preparing a database application 失效
标题翻译：使用数据库管理系统的基础设施来调用存储过程来创建和准备数据库应用程序
公开(公告)号：US06978261B2
公开(公告)日：2005-12-20
申请号：US09363780
申请日：1999-07-29
申请人： Curt Lee Cotner , Thomas Eng , Susan Malaika
发明人： Curt Lee Cotner , Thomas Eng , Susan Malaika
IPC分类号： G06F17/30
CPC分类号： G06F17/30415 , Y10S707/99931 , Y10S707/99932
摘要： Using a database management system's own infrastructure to invoke a stored procedure for creating and preparing a database application. The stored procedure automates the pre-compile, compile, linker, and binder steps performed in creating and preparing the database application. The stored procedure is invoked to perform these steps in order to render the database application executable by the RDBMS. In conjunction with the invocation of the stored procedure, input parameters for the stored procedure may be specified including the requested function, the name of the database application, the source code for the database application, pre-compiler options, compiler options, linker options, binder options, and runtime options. The outputs from the stored procedure may include an executable load module, a database resource module, an output parameter string indicating the success or failure of each step, and one or more result sets containing the outputs of each step.
摘要翻译：使用数据库管理系统自己的基础设施来调用存储过程来创建和准备数据库应用程序。存储过程自动化在创建和准备数据库应用程序时执行的预编译，编译，链接器和绑定器步骤。调用存储过程来执行这些步骤，以使数据库应用程序可以由RDBMS执行。结合调用存储过程，可以指定存储过程的输入参数，包括所请求的函数，数据库应用程序的名称，数据库应用程序的源代码，预编译器选项，编译器选项，链接器选项，绑定选项和运行时选项。来自存储过程的输出可以包括可执行加载模块，数据库资源模块，指示每个步骤的成功或失败的输出参数串，以及包含每个步骤的输出的一个或多个结果集。

6. 发明授权

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

7. 发明授权

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

8. 发明授权

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.

9. 发明授权

US06990477B2 Method, system, and program for implementing scrollable cursors in a distributed database system 失效
公开(公告)号：US06990477B2
公开(公告)日：2006-01-24
申请号：US09819476
申请日：2001-03-28
申请人： Curt Lee Cotner , Margaret A. Dong
发明人： Curt Lee Cotner , Margaret A. Dong
IPC分类号： G06F17/30
CPC分类号： G06F17/30595 , Y10S707/99931
摘要： Provided is a method, 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. 发明授权

US08782641B2 Tuning of work to meet performance goal 失效
标题翻译：调整工作以达到业绩目标
公开(公告)号：US08782641B2
公开(公告)日：2014-07-15
申请号：US11339002
申请日：2006-01-24
申请人： Curt Lee Cotner , You-Chin Fuh , Holger Karn , James R. Porell , Bryan Frederick Smith
发明人： Curt Lee Cotner , You-Chin Fuh , Holger Karn , James R. Porell , Bryan Frederick Smith
IPC分类号： G06F9/46
CPC分类号： G06F11/3466 , G06F11/3409 , G06F11/3433
摘要： Techniques are provided for tuning work. In response to identifying a trigger for a work, automatic tuning is invoked. The trigger indicates that a performance goal for the work has been missed. The work is analyzed. A tuning operation is selected for the work based on a tuning history. The selected tuning operation is implemented for the work.
摘要翻译：提供了调整工作的技术。响应于识别工作的触发，调用自动调整。触发器指示工作的性能目标已经错过。分析工作。基于调谐历史为工作选择调谐操作。所选择的调谐操作是为工作实现的。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式