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

1. 发明授权

US08984170B2 Idempotence for database transactions 有权
标题翻译：数据库事务的幂等
公开(公告)号：US08984170B2
公开(公告)日：2015-03-17
申请号：US13448258
申请日：2012-04-16
申请人： Carol L. Colrain , Stefan Heinrich Roesch , Kevin S. Neel
发明人： Carol L. Colrain , Stefan Heinrich Roesch , Kevin S. Neel
IPC分类号： G06F15/16 , H04L29/08
CPC分类号： H04L67/142 , H04L67/146 , H04L67/148 , H04L67/42
摘要： A method, machine, and computer-readable medium is provided for managing transactional sets of commands sent from a client to a server for execution. A first server reports logical identifiers that identify transactional sets of commands to a client. The first server commits information about a set of commands to indicate that the set has committed. A second server receives, from the client, a request that identifies the set based on the logical identifier that the client had received. The second server determines whether the request identified the latest set received for execution in a corresponding session and whether any transactions in the set have not committed. If any transaction has not committed, the second server enforces uncommitted state of the identified set by blocking completion of the identified set issued in the first session. The identified set may then be executed in the second session without risk of duplication.
摘要翻译：提供了一种方法，机器和计算机可读介质，用于管理从客户机发送到服务器以执行的事务性命令集。第一个服务器报告向客户端标识事务性命令集的逻辑标识符。第一个服务器提交有关一组命令的信息，以指示该集合已提交。第二服务器从客户端接收基于客户端已经接收的逻辑标识符来标识集合的请求。第二个服务器确定请求是否识别出在相应会话中接收到的用于执行的最新集合，以及集合中的任何事务是否都未提交。如果任何交易尚未提交，则第二服务器通过阻止在第一个会话中发出的已识别集合的完成来强制识别集合的未提交状态。所识别的集合然后可以在第二会话中被执行，而不会有重复的风险。

2. 发明授权

US08626890B2 Connection pool use of runtime load balancing service performance advisories 有权
标题翻译：连接池使用运行时负载平衡服务性能咨询
公开(公告)号：US08626890B2
公开(公告)日：2014-01-07
申请号：US12938545
申请日：2010-11-03
申请人： Carol L. Colrain , Rajkumar A. Irudayaraj , Douglas N. Surber
发明人： Carol L. Colrain , Rajkumar A. Irudayaraj , Douglas N. Surber
IPC分类号： G06F15/173
CPC分类号： G06F9/5083 , G06F9/505 , G06F2209/508
摘要： Runtime connection load balancing of work across connections to a clustered computing system involves the routing of requests for a service, based on the current operational performance of each of the instances that offer the service. A connection is selected from an identified connection pool, to connect to an instance that provides the service for routing a work request. The operational performance of the instances may be represented by performance information that characterizes the response time and/or the throughput of the service that is provided by a particular instance on a respective node of the system, and is relative to other instances that offer the same service.
摘要翻译：基于提供服务的每个实例的当前操作性能，对群集计算系统的连接进行工作的运行时连接负载平衡包括对服务请求的路由。从标识的连接池中选择连接，以连接到提供服务以路由工作请求的实例。实例的操作性能可以由表征由系统的相应节点上的特定实例提供的服务的响应时间和/或吞吐量的性能信息来表示，并且相对于提供相同的其他实例服务。

3. 发明授权

US06892205B1 System and method for pre-compiling a source cursor into a target library cache 有权
标题翻译：将源光标预编译为目标库缓存的系统和方法
公开(公告)号：US06892205B1
公开(公告)日：2005-05-10
申请号：US10086842
申请日：2002-02-28
申请人： Carol L. Colrain , Namit Jain , Juan R. Loaiza
发明人： Carol L. Colrain , Namit Jain , Juan R. Loaiza
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/3048 , G06F17/30433 , Y10S707/99934 , Y10S707/99953
摘要： A system and method for enabling a second database instance to more quickly process a request to execute a database statement that has previously been executed by a first database instance is described. In one embodiment, the method involves sending the database statement from the first database instance to the second database instance, and generating by the second database instance one or more structures needed to prepare the statement for execution, such as a parse tree and an execution plan for the statement. If at some point in the future, the second database instance receives a request to execute the same statement, the above structures can be used for execution, thereby eliminating the need for one or more potentially time-consuming operations, such as generation of a parse tree or execution plan for the statement.
摘要翻译：描述了使得第二数据库实例能够更快速地处理执行先前由第一数据库实例执行的数据库语句的请求的系统和方法。在一个实施例中，该方法涉及将数据库语句从第一数据库实例发送到第二数据库实例，并且由第二数据库实例生成准备执行语句所需的一个或多个结构，诸如解析树和执行计划为声明。如果在将来的某个时刻，第二个数据库实例接收到执行相同语句的请求，上述结构可以用于执行，从而不需要一个或多个潜在的耗时的操作，比如生成解析树或执行计划。

4. 发明申请

US20130066948A1 IDEMPOTENCE FOR DATABASE TRANSACTIONS 有权
公开(公告)号：US20130066948A1
公开(公告)日：2013-03-14
申请号：US13448258
申请日：2012-04-16
申请人： Carol L. Colrain , Stefan Heinrich Roesch , Kevin S. Neel
发明人： Carol L. Colrain , Stefan Heinrich Roesch , Kevin S. Neel
IPC分类号： G06F15/16 , G06F17/30
CPC分类号： H04L67/142 , H04L67/146 , H04L67/148 , H04L67/42
摘要： A method, machine, and computer-readable medium is provided for managing transactional sets of commands sent from a client to a server for execution. A first server reports logical identifiers that identify transactional sets of commands to a client. The first server commits information about a set of commands to indicate that the set has committed. A second server receives, from the client, a request that identifies the set based on the logical identifier that the client had received. The second server determines whether the request identified the latest set received for execution in a corresponding session and whether any transactions in the set have not committed. If any transaction has not committed, the second server enforces uncommitted state of the identified set by blocking completion of the identified set issued in the first session. The identified set may then be executed in the second session without risk of duplication.

5. 发明申请

US20110055368A1 Connection Pool Use of Runtime Load Balancing Service Performance Advisories 有权
标题翻译：连接池使用运行时负载平衡服务性能咨询
公开(公告)号：US20110055368A1
公开(公告)日：2011-03-03
申请号：US12938545
申请日：2010-11-03
申请人： Carol L. Colrain , Rajkumar A. Irudayaraj , Douglas N. Surber
发明人： Carol L. Colrain , Rajkumar A. Irudayaraj , Douglas N. Surber
IPC分类号： G06F15/173
CPC分类号： G06F9/5083 , G06F9/505 , G06F2209/508
摘要： Runtime connection load balancing of work across connections to a clustered computing system involves the routing of requests for a service, based on the current operational performance of each of the instances that offer the service. A connection is selected from an identified connection pool, to connect to an instance that provides the service for routing a work request. The operational performance of the instances may be represented by performance information that characterizes the response time and/or the throughput of the service that is provided by a particular instance on a respective node of the system, and is relative to other instances that offer the same service.
摘要翻译：基于提供服务的每个实例的当前操作性能，对群集计算系统的连接进行工作的运行时连接负载平衡包括对服务请求的路由。从标识的连接池中选择连接，以连接到提供服务以路由工作请求的实例。实例的操作性能可以由表征由系统的相应节点上的特定实例提供的服务的响应时间和/或吞吐量的性能信息来表示，并且相对于提供相同的其他实例服务。

6. 发明授权

US09600371B2 Preserving server-client session context 有权
公开(公告)号：US09600371B2
公开(公告)日：2017-03-21
申请号：US13542278
申请日：2012-07-05
申请人： Carol L. Colrain , Hochak Hung , Kevin S. Neel
发明人： Carol L. Colrain , Hochak Hung , Kevin S. Neel
IPC分类号： G06F17/30 , G06F11/14
CPC分类号： G06F11/1438 , G06F2201/80
摘要： Methods, devices, and storage media are provided for preserving the context of a server-client session. A server generates an initial context and a context for each user command executed in a first session and sends context to a client with the return for each command. The context describes software, session state, returned data, and/or hardware characteristics of a server-side environment for the first session. The client receives and stores the context with each user command. Upon determining that the database session should be rebuilt in the second session, the client sends initial context. A server for the second session receives the initial context and determines whether commands should be replayed in the second session. If commands are replayed, the server validates that server environment and client-visible results for each command in the second session match that from execution in the first session using the context for that command.

7. 发明申请

US20130066955A1 MASKING DATABASE OUTAGES FROM CLIENTS AND APPLICATIONS 有权
标题翻译：从客户和应用程序中屏蔽数据库的时间
公开(公告)号：US20130066955A1
公开(公告)日：2013-03-14
申请号：US13563680
申请日：2012-07-31
申请人： Kevin S. Neel , Carol L. Colrain , Douglas N. Surber , Nancy R. Ikeda , Stefan Heinrich Roesch , Tong Zhou , Jean De Lavarene
发明人： Kevin S. Neel , Carol L. Colrain , Douglas N. Surber , Nancy R. Ikeda , Stefan Heinrich Roesch , Tong Zhou , Jean De Lavarene
IPC分类号： G06F15/16
CPC分类号： H04L67/42 , G06F11/1443 , G06F11/1474 , H04L67/142 , H04L67/146 , H04L67/148 , H04L67/327
摘要： Methods, devices, and computer-readable media are provided for restoring state that was built up on a first session between a first server instance and a client to a second session between a second server instance and the client. Non-transactional session state that existed for the first session is preserved by repeating non-transactional commands in the second session. Transactions are executed in the second session when the transactions did not complete in the first session. The first server instance sends, to the client in the first session, information to maintain for a possible replay of commands that were sent in a request to the first server instance for execution in the first session. If the first session becomes unavailable, the maintained information may be used by the second server instance to restore the database session, masking the outage from users, applications, and clients.
摘要翻译：提供了方法，设备和计算机可读介质，用于将在第一服务器实例和客户端之间的第一会话上建立的状态恢复到第二服务器实例和客户端之间的第二会话。存在于第一个会话的非事务会话状态通过在第二个会话中重复非事务性命令来保留。当第一个会话中没有完成事务时，在第二个会话中执行事务。第一个服务器实例向第一个会话中的客户端发送信息，以维护在第一个服务器实例的请求中发送的命令的可能重放，以便在第一个会话中执行。如果第一个会话不可用，则第二个服务器实例可以使用维护的信息来恢复数据库会话，从而掩盖用户，应用程序和客户端的中断。

8. 发明申请

US20130066952A1 PRESERVING SERVER-CLIENT SESSION CONTEXT 有权
标题翻译：保留服务器客户端会话语境
公开(公告)号：US20130066952A1
公开(公告)日：2013-03-14
申请号：US13542278
申请日：2012-07-05
申请人： Carol L. Colrain , Hochak Hung , Kevin S. Neel
发明人： Carol L. Colrain , Hochak Hung , Kevin S. Neel
IPC分类号： G06F15/16 , G06F17/30
CPC分类号： G06F11/1438 , G06F2201/80
摘要： Methods, devices, and storage media are provided for preserving the context of a server-client session. A server generates an initial context and a context for each user command executed in a first session and sends context to a client with the return for each command. The context describes software, session state, returned data, and/or hardware characteristics of a server-side environment for the first session. The client receives and stores the context with each user command. Upon determining that the database session should be rebuilt in the second session, the client sends initial context. A server for the second session receives the initial context and determines whether commands should be replayed in the second session. If commands are replayed, the server validates that server environment and client-visible results for each command in the second session match that from execution in the first session using the context for that command.
摘要翻译：提供了方法，设备和存储介质来保存服务器 - 客户端会话的上下文。服务器为第一个会话中执行的每个用户命令生成初始上下文和上下文，并向每个命令返回的客户端发送上下文。该上下文描述用于第一会话的服务器端环境的软件，会话状态，返回数据和/或硬件特性。客户端接收并存储每个用户命令的上下文。在确定数据库会话应在第二个会话中重建时，客户端发送初始上下文。用于第二会话的服务器接收初始上下文并确定是否应在第二会话中重播命令。如果重播命令，则服务器将使用该命令的上下文来验证服务器环境和第二个会话中每个命令的客户机可见结果是否与第一个会话中的执行相匹配。

9. 发明申请

US20130066837A1 RECOVERING STATEFUL READ-ONLY DATABASE SESSIONS 有权
标题翻译：恢复有效的只读数据库会话
公开(公告)号：US20130066837A1
公开(公告)日：2013-03-14
申请号：US13229641
申请日：2011-09-09
申请人： Carol L. Colrain , Kevin S. Neel , Tong Zhou , Douglas N. Surber , Stefan Heinrich Roesch , Nancy R. Ikeda
发明人： Carol L. Colrain , Kevin S. Neel , Tong Zhou , Douglas N. Surber , Stefan Heinrich Roesch , Nancy R. Ikeda
IPC分类号： G06F17/30
CPC分类号： G06F17/30289 , G06F17/30371
摘要： A process, apparatus, and computer-readable medium are provided for rebuilding a database session when a previous database session becomes unavailable and the commands previously sent for execution on the previous database session satisfy certain criteria. The process includes determining whether or not a set of commands sent by a client for execution on the previous database session is acceptable to replay based at least in part on whether or not the set of commands satisfies one or more criteria. The process further includes determining that the previous database session is unavailable. In response to determining that the previous database session is unavailable, if the set of commands is acceptable for replay, the set of commands is sent for execution on a new database session to rebuild the state on the new database session. The process masks the outage from the application.
摘要翻译：提供了一种过程，装置和计算机可读介质，用于在先前数据库会话变得不可用时重建数据库会话，并且先前发送用于执行先前数据库会话的命令满足特定标准。该过程包括确定至少部分地基于该组命令是否满足一个或多个标准来确定由客户端发送的用于在先前的数据库会话上执行的一组命令是否可接受重播。该过程还包括确定先前的数据库会话不可用。响应于确定先前的数据库会话不可用，如果该组命令对于重放是可接受的，则该组命令被发送用于在新的数据库会话上执行以重建新的数据库会话上的状态。该过程掩盖了应用程序中断。

10. 发明授权

US08200658B2 System and method for providing highly available database performance 有权
标题翻译：提供高可用数据库性能的系统和方法
公开(公告)号：US08200658B2
公开(公告)日：2012-06-12
申请号：US13158808
申请日：2011-06-13
申请人： Carol L. Colrain , Namit Jain , Juan R. Loaiza
发明人： Carol L. Colrain , Namit Jain , Juan R. Loaiza
IPC分类号： G06F17/30
CPC分类号： G06F17/3048 , G06F17/30433 , Y10S707/99934 , Y10S707/99953
摘要： A system and method for enabling a second database instance to more quickly process a request to execute a database statement that has previously been executed by a first database instance is described. In one embodiment, the method involves sending the database statement from the first database instance to the second database instance, and generating by the second database instance one or more structures needed to prepare the statement for execution, such as a parse tree and an execution plan for the statement. If at some point in the future, the second database instance receives a request to execute the same statement, the above structures can be used for execution, thereby eliminating the need for one or more potentially time-consuming operations, such as generation of a parse tree or execution plan for the statement.
摘要翻译：描述了使得第二数据库实例能够更快速地处理执行先前由第一数据库实例执行的数据库语句的请求的系统和方法。在一个实施例中，该方法涉及将数据库语句从第一数据库实例发送到第二数据库实例，并且由第二数据库实例生成准备执行语句所需的一个或多个结构，诸如解析树和执行计划为声明。如果在将来的某个时刻，第二个数据库实例接收到执行相同语句的请求，上述结构可以用于执行，从而不需要一个或多个潜在的耗时的操作，比如生成解析树或执行计划。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式