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

11. 发明授权

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.

12. 发明授权

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.
摘要翻译：提供了调整工作的技术。响应于识别工作的触发，调用自动调整。触发器指示工作的性能目标已经错过。分析工作。基于调谐历史为工作选择调谐操作。所选择的调谐操作是为工作实现的。

13. 发明授权

US08090735B2 Statement generation using statement patterns 有权
标题翻译：使用语句模式生成语句
公开(公告)号：US08090735B2
公开(公告)日：2012-01-03
申请号：US11767454
申请日：2007-06-22
申请人： William Robert Bireley , Delmar Eugene Blevins , Stephen Andrew Brodsky , Curt Lee Cotner , Anshul Dawra , Swaminathan Gounder , Daya Vivek , Maryela Evelin Weihrauch
发明人： William Robert Bireley , Delmar Eugene Blevins , Stephen Andrew Brodsky , Curt Lee Cotner , Anshul Dawra , Swaminathan Gounder , Daya Vivek , Maryela Evelin Weihrauch
IPC分类号： G06F17/30
CPC分类号： G06F17/30424 , G06F17/30442
摘要： Provided are techniques for generating a result set. A statement that includes at least one statement pattern is received, wherein each statement pattern is a template that indicates how a statement is to be modified for execution against a data store and wherein each statement pattern modifies program logic and control flow. Each statement pattern is expanded to generate one or more new statements, wherein each statement pattern is capable of being expanded to zero or more statement patterns. The one or more new statements are executed against a data store to obtain a result set. It is determined whether to modify the result set based on the at least one statement pattern. In response to determining that the result set is to be modified, modifying the result set.
摘要翻译：提供了用于生成结果集的技术。收到包含至少一个语句模式的语句，其中每个语句模式是指示语句如何被修改以针对数据存储进行执行的模板，并且其中每个语句模式修改程序逻辑和控制流程。扩展每个语句模式以生成一个或多个新语句，其中每个语句模式能够被扩展为零个或多个语句模式。对数据存储执行一个或多个新语句以获得结果集。确定是否基于至少一个语句模式修改结果集。响应于确定结果集被修改，修改结果集。

14. 发明授权

US07827212B2 System and method for improved clearing of JAVA object's variables 有权
标题翻译：用于改进JAVA对象变量清除的系统和方法
公开(公告)号：US07827212B2
公开(公告)日：2010-11-02
申请号：US10444676
申请日：2003-05-22
申请人： Curt Lee Cotner
发明人： Curt Lee Cotner
IPC分类号： G06F12/00
CPC分类号： G06F9/4493
摘要： An apparatus and a method of clearing a runtime data area where software objects store variables and each software object has a finalize method where the invention drives the finalize method of a software object when the finalize method of the software object has not performed an operation for a predetermined time period.
摘要翻译：一种清除软件对象存储变量的运行时间数据区域的装置和方法，并且每个软件对象具有最终的方法，其中当软件对象的最终确定方法尚未执行对软件对象的操作时，本发明驱动软件对象的最终方法预定时间段。

15. 发明授权

US07647626B2 Method for establishing a trusted relationship between a data server and a middleware server 失效
标题翻译：在数据服务器和中间件服务器之间建立信任关系的方法
公开(公告)号：US07647626B2
公开(公告)日：2010-01-12
申请号：US11008507
申请日：2004-12-08
申请人： Paul Miller Bird , Curt Lee Cotner , Walid Rjaibi , Timothy Jon Vincent
发明人： Paul Miller Bird , Curt Lee Cotner , Walid Rjaibi , Timothy Jon Vincent
IPC分类号： G06F7/04 , G06F15/16 , G06F17/30 , H04L29/06
CPC分类号： H04L63/083 , G06F17/30286
摘要： A data server of a data processing system is operably coupled to a database and in communication with a middleware server. A connection between the data server and the middleware server is established and managed. A set of attributes identifying trusted middleware servers is instituted with the data server. The middleware server transmits a connection request to the data server. The connection request has request attributes including identifying the connection request as being for a new connection or reuse of an existing connection with different connection request attributes. A connection with the middleware server is established by the data server based on the connection request. A connection status message is received by the middleware server from the data server indicating a status of the connection request. A trust indicator for the connection is established at the data server according to a trust status identified by the set of attributes for the middleware server.
摘要翻译：数据处理系统的数据服务器可操作地耦合到数据库并与中间件服务器通信。建立和管理数据服务器与中间件服务器之间的连接。数据服务器建立了识别可信中间件服务器的一组属性。中间件服务器向数据服务器发送连接请求。连接请求具有请求属性，包括将连接请求标识为用于新连接或重新使用具有不同连接请求属性的现有连接。数据服务器根据连接请求建立与中间件服务器的连接。连接状态消息由中间件服务器从数据服务器接收到，指示连接请求的状态。根据由中间件服务器的属性集识别的信任状态，在数据服务器处建立用于连接的信任指示符。

16. 发明授权

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

17. 发明授权

US5881238A System for assignment of work requests by identifying servers in a multisystem complex having a minimum predefined capacity utilization at lowest importance level 失效
标题翻译：通过在具有最低重要性级别的最小预定容量利用率的多系统复合体中识别服务器来分配工作请求的系统
公开(公告)号：US5881238A
公开(公告)日：1999-03-09
申请号：US797899
申请日：1997-02-10
申请人： Jeffrey David Aman , Curt Lee Cotner , Donna Ngar Ting Dillenberger , David Bruce Emmes
发明人： Jeffrey David Aman , Curt Lee Cotner , Donna Ngar Ting Dillenberger , David Bruce Emmes
IPC分类号： G06F9/50 , G06F13/00
CPC分类号： G06F9/505 , G06F9/5083 , G06F2209/5022
摘要： Apparatus and accompanying methods for use preferably in a multi-system shared data (sysplex) environment (100), wherein each system (110) provides one or more servers (115), for dynamically and adaptively assigning and balancing new work and for new session requests, among the servers in the sysplex, in view of attendant user-defined business importance of these requests and available sysplex resource capacity so as to meet overall business goals. Specifically, systems and servers are categorized into two classes: eligible, i.e., goal-oriented servers running under a policy and for which capacity information is currently available, and candidate, i.e., servers which lack capacity information. Work requests for a client application are assigned first to various eligible systems and eligible servers thereon based on their current capacity to accept new work and in a manner that meets business goals inherent in a sysplex policy; followed, if additional servers are requested by that application, to candidate systems and candidate servers thereon. As to session placement, first those system(s) are selected that have lowest utilization, at a target importance level, but with sufficient available capacity at that level. Competing servers on the selected system(s) are then evaluated based on their corresponding session count data to yield a single resulting server. Thereafter, identification of multiple servers and their corresponding weights are returned to, e.g., a client application, for eventual routing of work requests to those servers, or the identification of a single server is returned to that application for establishing a new session therewith.
摘要翻译：用于优选在多系统共享数据（系统综合）环境（100）中使用的设备和相关方法，其中每个系统（110）提供一个或多个服务器（115），用于动态地和适应性地分配和平衡新的工作和新的会话考虑到这些请求的用户定义的业务重要性和可用的系统资源容量，以满足整体业务目标，在sysplex的服务器之中请求。具体来说，系统和服务器分为两类：符合条件，即在策略下运行的目标导向服务器，目前可用的容量信息，以及候选者，即缺少容量信息的服务器。基于他们目前接受新工作的能力，并以满足系统复合策略中固有的业务目标的方式，首先将针对客户端应用程序的工作请求分配给各种符合资格的系统及其合格的服务器; 接下来，如果该应用程序请求其他服务器，则在候选系统和候选服务器上。对于会话布置，首先选择具有最低利用率的系统，在目标重要性水平，但在该级别具有足够的可用容量。然后根据其对应的会话计数数据对所选系统上的竞争服务器进行评估，以产生单个结果服务器。此后，将多个服务器及其对应的权重的识别返回给例如客户端应用程序，以便最终将工作请求路由到这些服务器，或者将单个服务器的标识返回到该应用以与其建立新的会话。

18. 发明授权

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

19. 发明授权

US07668805B2 System and method for managing query access to information 有权
标题翻译：用于管理信息查询访问的系统和方法
公开(公告)号：US07668805B2
公开(公告)日：2010-02-23
申请号：US10931535
申请日：2004-09-01
申请人： Paul Miller Bird , Curt Lee Cotner , Patrick Dantressangle
发明人： Paul Miller Bird , Curt Lee Cotner , Patrick Dantressangle
IPC分类号： G06F17/30
CPC分类号： G06F21/6209 , G06F2221/2105 , G06F2221/2141 , Y10S707/99933
摘要： A system, computer usable medium and computer-based method for supporting named memory variables in an information retrieval system including a relational database. PUBLIC and PRIVATE named memory variables can be created, referenced, modified or deleted using SQL statements. The information retrieval system allocates a memory area as a named variable storage space for storing named memory variables. System catalogs may be used for storing information about PUBLIC, SECURE PUBLIC, PRIVATE, SECURE PRIVATE and pre-defined named memory variables. PUBLIC and PRIVATE named memory variables can be used for transferring information between SQL statements of one or more sessions or for retrieving system information from the relational database. Both PUBLIC and PRIVATE types can be defined as SECURE named memory variables requiring specific authorization privileges to read or write to the variable.
摘要翻译：一种用于在包括关系数据库的信息检索系统中支持命名存储器变量的系统，计算机可用介质和基于计算机的方法。可以使用SQL语句创建，引用，修改或删除PUBLIC和PRIVATE命名的内存变量。信息检索系统将存储区域分配为用于存储命名的存储器变量的命名变量存储空间。系统目录可用于存储有关PUBLIC，SECURE PUBLIC，PRIVATE，SECURE PRIVATE和预定义的命名内存变量的信息。 PUBLIC和PRIVATE命名的内存变量可用于在一个或多个会话的SQL语句之间传输信息，或用于从关系数据库检索系统信息。 PUBLIC和PRIVATE类型都可以定义为SECURE命名的内存变量，需要特定的授权权限来读取或写入变量。

20. 发明授权

US07580958B2 Supporting multiple versions of a routine 有权
标题翻译：支持多个版本的例程
公开(公告)号：US07580958B2
公开(公告)日：2009-08-25
申请号：US11156509
申请日：2005-06-17
申请人： Yao-Ching Stephen Chen , Curt Lee Cotner , Baoqiu Cui , Tammie Dang , Joe Cheng-yu Huang , Claire Willey McFeely , Robert Thomas Miller , Manogari Nogi Simanjuntak , Yumi Kimura Tsuji , Xiaoyu Yang , Jay A. Yothers , Margaret Alice Zagelow
发明人： Yao-Ching Stephen Chen , Curt Lee Cotner , Baoqiu Cui , Tammie Dang , Joe Cheng-yu Huang , Claire Willey McFeely , Robert Thomas Miller , Manogari Nogi Simanjuntak , Yumi Kimura Tsuji , Xiaoyu Yang , Jay A. Yothers , Margaret Alice Zagelow
IPC分类号： G06F12/00 , G06F17/30
CPC分类号： G06F17/30595 , Y10S707/99952 , Y10S707/99953
摘要： Techniques are provided for supporting versions of a routine. A first version of the routine is created. A second version of the routine is generated in response to receiving an alter statement including an add version clause. The second version of the routine is activated in response to receiving an alter statement including an activate version clause.
摘要翻译：提供了用于支持例程的版本的技术。创建例程的第一个版本。响应于接收到包含add version子句的alter语句，生成该例程的第二个版本。响应于接收到包含activate version子句的alter语句，该例程的第二个版本被激活。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式