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

1. 发明授权

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.
摘要翻译：公开了一种用于在处理系统内利用的关系数据库上有效提供维护活动的方法和系统。关系数据库包括一个线程池和多个资源。线程池接收来自多个客户端的请求并控制多个资源。所述方法和系统包括确定需要维护活动并且提供启动第一进程的第一命令，如果需要维护活动，则终止所述线程池中的所有线程。所述方法和系统还包括提供在维护活动完成之后启动第二进程的第二命令，其导致创建线程并启动请求的处理。基于确定需要维护活动的本发明的系统和方法使得关系数据库内的池线程终止并因此释放资源，而且允许来自客户端的连接持久化。一旦关系数据库资源被释放，则执行维护活动，然后恢复分布式关系数据库处理。

2. 发明授权

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

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. 发明授权

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

5. 发明授权

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

6. 发明授权

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

7. 发明授权

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执行。结合调用存储过程，可以指定存储过程的输入参数，包括所请求的函数，数据库应用程序的名称，数据库应用程序的源代码，预编译器选项，编译器选项，链接器选项，绑定选项和运行时选项。来自存储过程的输出可以包括可执行加载模块，数据库资源模块，指示每个步骤的成功或失败的输出参数串，以及包含每个步骤的输出的一个或多个结果集。

8. 发明授权

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

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. 发明授权

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

热门服务

关于我们

友情链接

联系方式