Incremental run-time session balancing in a multi-node system
    2.
    发明授权
    Incremental run-time session balancing in a multi-node system 有权
    多节点系统中的增量运行时会话平衡

    公开(公告)号:US07930344B2

    公开(公告)日:2011-04-19

    申请号:US12338651

    申请日:2008-12-18

    IPC分类号: G06F15/16 G06F12/00

    CPC分类号: G06F9/5088

    摘要: An approach migrates database sessions from a database server on which performance and resource availability requirements are not being met to another database server. Because workload is removed from the database server not meeting these requirements, improved performance there is promoted. Furthermore, the approach switches the users in a way that attempts to keep performance and resource availability levels at the database server receiving the database sessions within goals for performance and resource availability.

    摘要翻译: 一种方法将数据库会话从数据库服务器迁移到哪个性能和资源可用性要求未被满足到另一个数据库服务器。 因为从不符合这些要求的数据库服务器中删除工作负载,因此提升了性能。 此外,该方法以一种尝试在数据库服务器上保持性能和资源可用性级别的方式切换用户,以在性能和资源可用性的目标内接收数据库会话。

    Incremental Run-Time Session Balancing In A Multi-Node System
    4.
    发明申请
    Incremental Run-Time Session Balancing In A Multi-Node System 有权
    多节点系统中的增量运行时会话平衡

    公开(公告)号:US20090100180A1

    公开(公告)日:2009-04-16

    申请号:US12338651

    申请日:2008-12-18

    IPC分类号: G06F15/173

    CPC分类号: G06F9/5088

    摘要: An approach migrates database sessions from a database server on which performance and resource availability requirements are not being met to another database server. Because workload is removed from the database server not meeting these requirements, improved performance there is promoted. Furthermore, the approach switches the users in a way that attempts to keep performance and resource availability levels at the database server receiving the database sessions within goals for performance and resource availability.

    摘要翻译: 一种方法将数据库会话从数据库服务器迁移到哪个性能和资源可用性要求未被满足到另一个数据库服务器。 因为从不符合这些要求的数据库服务器中删除工作负载,因此提升了性能。 此外,该方法以一种尝试在数据库服务器上保持性能和资源可用性级别的方式切换用户,以在性能和资源可用性的目标内接收数据库会话。

    Incremental run-time session balancing in a multi-node system
    5.
    发明授权
    Incremental run-time session balancing in a multi-node system 有权
    多节点系统中的增量运行时会话平衡

    公开(公告)号:US07552171B2

    公开(公告)日:2009-06-23

    申请号:US10918055

    申请日:2004-08-12

    IPC分类号: G06F15/16 G06F12/00

    CPC分类号: G06F9/5088

    摘要: An approach migrates database sessions from a database server on which performance and resource availability requirements are not being met to another database server. Because workload is removed from the database server not meeting these requirements, improved performance there is promoted. Furthermore, the approach switches the users in a way that attempts to keep performance and resource availability levels at the database server receiving the database sessions within goals for performance and resource availability.

    摘要翻译: 一种方法将数据库会话从数据库服务器迁移到哪个性能和资源可用性要求未被满足到另一个数据库服务器。 因为从不符合这些要求的数据库服务器中删除工作负载,因此提升了性能。 此外,该方法以一种尝试在数据库服务器上保持性能和资源可用性级别的方式切换用户,以在性能和资源可用性的目标内接收数据库会话。

    Calculation of service performance grades in a multi-node environment that hosts the services
    6.
    发明授权
    Calculation of service performance grades in a multi-node environment that hosts the services 有权
    在承载服务的多节点环境中计算服务性能等级

    公开(公告)号:US07437459B2

    公开(公告)日:2008-10-14

    申请号:US10917661

    申请日:2004-08-12

    IPC分类号: G06F15/173 G06F12/00

    CPC分类号: H04L67/1008 H04L67/1031

    摘要: An approach generates performance grades. A performance grade is a value or set of values that indicates the relative work performance offered by a resource, such as a server in a multi-node system, relative to other resources. Performance grades are used to dynamically allocate work within a multi-node computer system. For example, performance grades are used for connection-time balancing, and to direct a database connection request to a multi-node database instance that a performance grade indicates provides better performance. Performance grade deltas are generated that reflect the incremental change in performance grade for additional sessions or work. Performance deltas are used to direct incoming sessions, to more optimally balance workload, and to deal with logon storms where a large number of connect requests arrive in a very short time period.

    摘要翻译: 一种方法产生绩效等级。 性能等级是指示资源(如多节点系统中的服务器)相对于其他资源提供的相对工作性能的值或值集合。 性能等级用于在多节点计算机系统内动态分配工作。 例如,性能等级用于连接时间平衡,并将数据库连接请求引导到性能等级指示提供更好性能的多节点数据库实例。 产生性能等级三角形,反映其他会话或工作的性能等级的增量变化。 性能增量用于引导传入的会话,更好地平衡工作负载,并处理大量连接请求在很短时间内到达的登录风暴。

    Mapping source logical clock into destination logical clock in a distributed system
    7.
    发明授权
    Mapping source logical clock into destination logical clock in a distributed system 有权
    将源逻辑时钟映射到分布式系统中的目标逻辑时钟

    公开(公告)号:US07523143B2

    公开(公告)日:2009-04-21

    申请号:US10909985

    申请日:2004-08-02

    IPC分类号: G07F17/30 G06F15/16

    摘要: A source database system sends information to a destination database system, and each database system generates a separate set of sequence information. A mapping is maintained between the two sets of sequence information. Using the mapping, the destination database system may be used to restore changes lost at the source database system without reinstating the source database. Additionally, queries associated with a particular point in a sequence associated with the sequence information of the source database may be redirected to the destination database, and the destination database system may serve as a logical standby for the source database system. A variety of methods of maintaining and/or extracting the mapping information are disclosed.

    摘要翻译: 源数据库系统向目标数据库系统发送信息,每个数据库系统生成一组单独的序列信息。 在两组序列信息之间保持映射。 使用映射,目标数据库系统可用于恢复源数据库系统丢失的更改,而不会恢复源数据库。 此外,与源数据库的序列信息相关联的序列中的特定点相关联的查询可以被重定向到目的地数据库,并且目的地数据库系统可以用作源数据库系统的逻辑备用。 公开了维护和/或提取映射信息的各种方法。

    Commit-time ordered message queue supporting arbitrary read and dequeue patterns from multiple subscribers
    8.
    发明授权
    Commit-time ordered message queue supporting arbitrary read and dequeue patterns from multiple subscribers 有权
    提交时间有序消息队列支持来自多个订户的任意读取和出列模式

    公开(公告)号:US07680793B2

    公开(公告)日:2010-03-16

    申请号:US11245863

    申请日:2005-10-07

    IPC分类号: G06F17/30

    摘要: Data consistency in the context of information sharing requires maintenance of dependencies among information being shared. Transactional dependency ordering is implemented in a database system message queue, by associating a unique system commit time with each transactional message group. Read consistency is implemented in such a queue by allowing only messages with a fully determined order to be visible. A fully determined order is implemented through use of a high watermark, which guarantees that future transactions, for which messages are entering the queue, have commit times that are greater than the current high watermark. Therefore, only messages below the current high watermark are visible and can be dequeued, with no chance of other new messages enqueuing below the current high watermark.

    摘要翻译: 信息共享上下文中的数据一致性需要维护正在共享的信息之间的依赖关系。 通过将唯一的系统提交时间与每个事务消息组相关联,在数据库系统消息队列中实现事务依赖性排序。 通过仅允许具有完全确定的顺序的消息可见,在这样的队列中实现读取一致性。 通过使用高水印实现完全确定的顺序,这保证了消息进入队列的未来事务具有大于当前高水印的提交时间。 因此,只有低于当前高水印的消息才可见,并且可以出队,没有其他新消息排入低于当前高水印的机会。

    DATABASE SYSTEM AND EVENTING INFRASTRUCTURE
    9.
    发明申请
    DATABASE SYSTEM AND EVENTING INFRASTRUCTURE 审中-公开
    数据库系统和不良基础设施

    公开(公告)号:US20090158298A1

    公开(公告)日:2009-06-18

    申请号:US11954739

    申请日:2007-12-12

    IPC分类号: G06F9/44

    摘要: A system for managing event monitors within a database is provided. The system can adjust the amount of notifications generated by those event monitors, so as to achieve an effective balance between probability of notification loss and available notification bandwidth, as well as provide a better quality of service to database users.

    摘要翻译: 提供了一种用于管理数据库内的事件监视器的系统。 该系统可以调整这些事件监视器产生的通知量,以便在通知丢失的概率和可用的通知带宽之间实现有效平衡,并为数据库用户提供更好的服务质量。

    High availability for distributed non-persistent event propagation
    10.
    发明授权
    High availability for distributed non-persistent event propagation 有权
    分布式非持久性事件传播的高可用性

    公开(公告)号:US07856461B2

    公开(公告)日:2010-12-21

    申请号:US11224770

    申请日:2005-09-12

    IPC分类号: G06F17/00

    摘要: Techniques are provided for maintaining high propagation availability for non-persistent messages. Destination-to-instance mapping information is provided to a listener process for a cluster database. The destination-to-instance mapping indicates the current owner instance of each single-instance destination within the cluster database. To establish a connection to a single-instance destination, a sending process sends a connection request to the global listener. The connection request identifies the desired destination queue, but not the owner instance of the queue. The global listener for the cluster database uses the destination-to-instance mapping to determine which instance is the current owner of the specified queue, and establishes a connection between the sending process and the appropriate owner instance.

    摘要翻译: 提供了为非持久性消息保持高传播可用性的技术。 将目标到实例的映射信息提供给集群数据库的侦听器进程。 目标对实例映射指示集群数据库中每个单实例目标的当前所有者实例。 要建立与单实例目标的连接,发送进程会向全局侦听器发送连接请求。 连接请求标识所需的目标队列,但不标识队列的所有者实例。 集群数据库的全局侦听器使用目标到实例映射来确定哪个实例是指定队列的当前所有者,并在发送进程和适当的所有者实例之间建立连接。