-
1.发明授权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
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.发明授权公开(公告)号：US07743036B2
公开(公告)日：2010-06-22
申请号：US11764962
申请日：2007-06-19
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.发明授权公开(公告)号：US07260589B2
公开(公告)日：2007-08-21
申请号：US10726700
申请日：2003-12-04
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.发明授权公开(公告)号：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.
-
5.发明授权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
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地址执行重新同步过程。
-
6.发明授权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
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）服务器。 服务器使用自己的恢复日志来满足日志需求。
-
公开(公告)号：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.发明授权公开(公告)号：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.
-
9.发明授权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
公开(公告)日：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.
摘要翻译： 提供有形地体现由计算机可执行的指令程序的计算机可读的方法，装置和程序存储装置，用于重新组织数据库数据。 计算机数据库重组方法一次重组一组数据库数据块，允许并发数据操作。 方法识别用于在滑动窥视孔模式中进行重组的一组数据块，重新命令该组数据块，并用重新排列的数据块集替换原始数据块集合。 该方法包括重叠窥视孔方法，其针对要重组的每组数据块选择下一个后续数据块集合加上重叠段，其中重叠段包括除有意指定的空闲页之外的一组空页， 并且重叠段是前面的数据块集合的子集。
-
-
-
-
-
-
-
-
-
搜索结果
25 条记录 (耗时 0.02 秒)
