Fault isolation using code paths
    2.
    发明授权
    Fault isolation using code paths 有权
    使用代码路径进行故障隔离

    公开(公告)号:US08458511B2

    公开(公告)日:2013-06-04

    申请号:US12885323

    申请日:2010-09-17

    IPC分类号: G06F11/00

    CPC分类号: G06F11/3688

    摘要: Techniques are provided for isolating faults in a software program by providing at least two code paths that are capable of performing the same operation. When a fault occurs while the one of the code paths is being used to perform an operation, data that indicates the circumstances under which the fault occurred is stored. For example, a fault-recording mechanism may store data that indicates the entities that were involved in the failed operation. Because they were involved in an operation that experienced a fault, one or more of those entities may be “quarantined”. When subsequent requests arrive to perform the operation, a check may be performed to determine whether the requested operation involves any of the quarantined entities. If the requested operation involves a quarantined entity, a different code path is used to perform the operation, rather than the code path from which the entity is quarantined.

    摘要翻译: 提供了通过提供能够执行相同操作的至少两个代码路径来分离软件程序中的故障的技术。 当代码路径中的一个正在用于执行操作时发生故障时,存储指示发生故障的情况的数据。 例如,故障记录机制可以存储指示涉及故障操作的实体的数据。 因为他们参与了一个经历过错的行动,所以这些实体中的一个或多个可能被“隔离”。 当后续请求到达以执行操作时,可以执行检查以确定所请求的操作是否涉及任何被隔离的实体。 如果请求的操作涉及隔离实体,则使用不同的代码路径来执行操作,而不是实体被隔离的代码路径。

    Advisor framework, systems, methods and software for implementing the same
    3.
    发明授权
    Advisor framework, systems, methods and software for implementing the same 有权
    顾问框架,系统,方法和软件实现相同

    公开(公告)号:US07873606B2

    公开(公告)日:2011-01-18

    申请号:US10925831

    申请日:2004-08-24

    IPC分类号: G06F7/00 G06F17/00

    CPC分类号: G06F17/30306 G06F17/3056

    摘要: Various embodiments of the invention provide solutions that can offer a consistent framework for tools that assist in the configuration, tuning, and/or troubleshooting of a database and/or an RDBMS. Merely by way of example, one set of embodiments provides a software framework for an advisor component of a database and/or RDBMS. In accordance with some embodiments, the framework might specify a common data model for such advisor components. The data model can include, merely by way of example, a set of one or more findings (which might, in some cases, describe the result of an analysis of a circumstance in the database, RDBMS, and/or a mid-tier application used with the database) and/or a set of one or more recommendations (which might provide suggestions for addressing the circumstance). In particular embodiments. In particular embodiments, the data model might include a set of on or more rationales, which can explain the recommendations. In some cases, the software framework might include a task associated with the advisor component and/or one or more interfaces, which can include, inter alia, user interfaces and/or APIs. Other sets of embodiments can provide methods, systems and/or software programs for implementing an advisor framework.

    摘要翻译: 本发明的各种实施例提供可以为协助数据库和/或RDBMS的配置,调整和/或故障排除的工具提供一致的框架的解决方案。 仅仅作为示例,一组实施例为数据库和/或RDBMS的顾问组件提供了软件框架。 根据一些实施例,框架可以为这种顾问组件指定公共数据模型。 数据模型可以仅包括一个或多个发现(在某些情况下可能描述数据库中的情境分析的结果,RDBMS和/或中间层应用程序) 与数据库一起使用)和/或一组一个或多个建议(可能提供解决情况的建议)。 在特定实施例中,数据模型可以包括一组或多个理由,其可以解释建议。 在一些情况下,软件框架可以包括与顾问组件和/或一个或多个接口相关联的任务,其特别可以包括用户界面和/或API。 其他实施例集合可以提供用于实现顾问框架的方法,系统和/或软件程序。

    NODE DEATH DETECTION BY QUERYING
    5.
    发明申请
    NODE DEATH DETECTION BY QUERYING 有权
    通过查询进行死亡检测

    公开(公告)号:US20130262937A1

    公开(公告)日:2013-10-03

    申请号:US13431196

    申请日:2012-03-27

    IPC分类号: G06F11/00 H04L12/26

    摘要: Systems, methods, and other embodiments associated with detecting a node death in a clustered distributed system are described. In one embodiment, a method includes transmitting a ping message to a peer node in the network. If a reply to the ping message is not received from the peer node, a query is sent to table of port identifiers that lists ports in the cluster. In one embodiment, the query includes a port identifier associated with the peer node. The peer node is declared as inactive/dead when the query fails to locate a match in the table for the port identifier. When the query locates a match in the table for the port identifier, another ping message is periodically transmitted to the peer node.

    摘要翻译: 描述了与群集分布式系统中的节点死亡检测相关联的系统,方法和其他实施例。 在一个实施例中,一种方法包括将ping消息发送到网络中的对等节点。 如果没有从对等节点接收到ping消息的回复,则会将查询发送到列出集群端口的端口标识符表。 在一个实施例中,查询包括与对等节点相关联的端口标识符。 当查询无法在端口标识符的表中找到匹配时,对等节点被声明为非活动/已停止。 当查询查找端口标识符的表中的匹配时,会将另一个ping消息周期性地发送到对等节点。

    Database performance baselines
    6.
    发明授权
    Database performance baselines 有权
    数据库性能基准

    公开(公告)号:US07664798B2

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

    申请号:US10934345

    申请日:2004-09-03

    IPC分类号: G07F17/30

    摘要: Systems and methods to define and store performance baselines. A baseline may be defined as a pair of snapshots, each snapshot containing the same set of statistics and having a timestamp value associated therewith. The present invention allows for the designation, automatically or manually, of statistics collected over a certain period of time to be stored and used for comparison. Baselines may be used, for example, to manually or automatically compare with current system performance, compare difference-difference values and set thresholds to monitor current system performance.

    摘要翻译: 定义和存储性能基线的系统和方法。 基线可以被定义为一对快照,每个快照包含相同的一组统计信息并具有与之相关联的时间戳值。 本发明允许自动或手动地指定在一段时间内收集的统计数据,并将其用于比较。 可以使用基线来手动或自动与当前系统性能进行比较,比较差异差值和设置阈值以监视当前系统性能。

    METHODS, SYSTEMS AND SOFTWARE FOR IDENTIFYING AND MANAGING DATABASE WORK
    8.
    发明申请
    METHODS, SYSTEMS AND SOFTWARE FOR IDENTIFYING AND MANAGING DATABASE WORK 有权
    用于识别和管理数据库工作的方法,系统和软件

    公开(公告)号:US20070255757A1

    公开(公告)日:2007-11-01

    申请号:US11739277

    申请日:2007-04-24

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30575

    摘要: Various embodiments of the invention provide solutions to allow more sophisticated management of the relationship between a database and its clients (which can be, inter alia, end users, business applications, etc.). Merely by way of example, some embodiments can facilitate the management of work requests in a database, as well as the management of the quality-of-service in a database system. In some embodiments, an identification handle may be assigned to a database work request. A database management application can use the identification handle to identify the work request, as well, perhaps, as any related work requests. The identification handle may also identify the database (and/or an instance thereof) and/or a clustered database node, and the identification handle may be transmitted to a mid-tier application, e.g., to notify the mid-tier about the processing of the work request, changes in quality-of service, server availability, etc.

    摘要翻译: 本发明的各种实施例提供了解决方案,以允许数据库与其客户端之间的关系(其可以是最终用户,业务应用等)的更为复杂的管理。 仅仅作为示例,一些实施例可以促进对数据库中的工作请求的管理以及数据库系统中的服务质量的管理。 在一些实施例中,可以将识别句柄分配给数据库工作请求。 数据库管理应用程序可以使用识别句柄来识别工作请求,也可以是任何相关的工作请求。 识别句柄还可以识别数据库(和/或其实例)和/或集群数据库节点,并且识别句柄可以被发送到中间层应用,例如,以通知中间层关于处理 工作请求,服务质量的变化,服务器可用性等。

    Self-managing performance statistics repository for databases
    9.
    发明申请
    Self-managing performance statistics repository for databases 有权
    数据库的自我管理性能统计信息库

    公开(公告)号:US20050086263A1

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

    申请号:US10934771

    申请日:2004-09-03

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30306

    摘要: A self-managing workload repository (AWR) infrastructure useful for a database server to collect and manage selected sets of important system performance statistics. Based on a schedule, the AWR runs automatically to collect data about the operation of the database system, and stores the data that it captures into the database. The AWR is advantageously designed to be lightweight and to self manage its use of storage space so as to avoid ending up with a repository of performance data that is larger than the database that it is capturing data about. The AWR is configured to automatically capture snapshots of statistics data on a periodic basis as well as purge stale data on a periodic basis. Both the frequency of the statistics data capture and length of time for which data is kept is adjustable. Manual snapshots and purging may also be performed. The AWR captured data allows for both system level and user level analysis to be automatically performed without unduly impacting system performance, e.g., by eliminating or reducing the requirement to repeat the workload in order to diagnose problems.

    摘要翻译: 自管理工作负载存储库(AWR)基础架构可用于数据库服务器收集和管理所选的重要系统性能统计信息。 根据计划,AWR自动运行以收集有关数据库系统操作的数据,并将其捕获的数据存储到数据库中。 AWR有利地被设计为轻量级并且自我管理其对存储空间的使用,以避免最终获得比它正在捕获数据的数据库更大的性能数据库。 AWR配置为定期自动捕获统计数据的快照,并定期清除过期数据。 统计数据捕获的频率和保存数据的时间长短都是可调的。 也可以执行手动快照和清除。 AWR捕获的数据允许自动执行系统级别和用户级别分析,而不会不必要地影响系统性能,例如通过消除或减少重复工作负载以便诊断问题的要求。