会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 3. 发明授权
    • Self-managing performance statistics repository for databases
    • 数据库的自我管理性能统计信息库
    • US07774312B2
    • 2010-08-10
    • US10934771
    • 2004-09-03
    • Gary NgaiMichael FengAlex TsukermanBenoit DagevilleMark RamacherKarl DiasGraham S. WoodLeng Leng TanRichard SarwalSushil Kumar
    • Gary NgaiMichael FengAlex TsukermanBenoit DagevilleMark RamacherKarl DiasGraham S. WoodLeng Leng TanRichard SarwalSushil Kumar
    • G06F17/30
    • 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捕获的数据允许自动执行系统级别和用户级别分析,而不会不必要地影响系统性能,例如通过消除或减少重复工作负载以便诊断问题的要求。
    • 4. 发明申请
    • Self-managing performance statistics repository for databases
    • 数据库的自我管理性能统计信息库
    • US20050086263A1
    • 2005-04-21
    • US10934771
    • 2004-09-03
    • Gary NgaiMichael FengAlex TsukermanBenoit DagevilleMark RamacherKarl DiasGraham WoodLeng Leng TanRichard SarwalSushil Kumar
    • Gary NgaiMichael FengAlex TsukermanBenoit DagevilleMark RamacherKarl DiasGraham WoodLeng Leng TanRichard SarwalSushil Kumar
    • G06F7/00
    • 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捕获的数据允许自动执行系统级别和用户级别分析,而不会不必要地影响系统性能,例如通过消除或减少重复工作负载以便诊断问题的要求。
    • 6. 发明申请
    • METHODS, SYSTEMS AND SOFTWARE FOR IDENTIFYING AND MANAGING DATABASE WORK
    • 用于识别和管理数据库工作的方法,系统和软件
    • US20070255757A1
    • 2007-11-01
    • US11739277
    • 2007-04-24
    • Alex TsukermanCarol ColrainGraham WoodJane ChenLuxi ChidambaranBenoit DagevilleGary NgaiMark Ramacher
    • Alex TsukermanCarol ColrainGraham WoodJane ChenLuxi ChidambaranBenoit DagevilleGary NgaiMark Ramacher
    • G06F17/30
    • 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.
    • 本发明的各种实施例提供了解决方案,以允许数据库与其客户端之间的关系(其可以是最终用户,业务应用等)的更为复杂的管理。 仅仅作为示例,一些实施例可以促进对数据库中的工作请求的管理以及数据库系统中的服务质量的管理。 在一些实施例中,可以将识别句柄分配给数据库工作请求。 数据库管理应用程序可以使用识别句柄来识别工作请求,也可以是任何相关的工作请求。 识别句柄还可以识别数据库(和/或其实例)和/或集群数据库节点,并且识别句柄可以被发送到中间层应用,例如,以通知中间层关于处理 工作请求,服务质量的变化,服务器可用性等。
    • 9. 发明申请
    • Automatic Workload Repository Performance Baselines
    • 自动工作负载存储库性能基准
    • US20090106756A1
    • 2009-04-23
    • US12111011
    • 2008-04-28
    • Mike FengMark RamacherGary NgaiGraham WoodJohn Beresniewicz
    • Mike FengMark RamacherGary NgaiGraham WoodJohn Beresniewicz
    • G06F9/46
    • G06F11/3495G06F11/3409G06F11/3428G06F11/3616
    • Techniques that improve manageability of systems. Techniques are provided for creating different types of baselines that are more flexible and dynamic in nature. A future-based baseline may be created defining a period of time, wherein at least a portion of the period of time is in the future. A baseline may be created that is a composite of multiple baselines. In general, baselines may be specified having one or more periods of time that are either contiguous or non-contiguous. A template for creating a set of baselines based on a set of time periods may also be created, where the template can be used to create a baseline for each of the set of time periods. A moving window baseline may be created having an associated time window that changes with passage of time, where accordingly the data associated with the baseline may also dynamically change with passage of time.
    • 提高系统可管理性的技术。 提供了技术来创建不同类型的基础,这些基准在本质上更加灵活和动态。 可以创建定义一段时间的基于未来的基线,其中至少一部分时间段在将来。 可以创建一个基准,该基准是多个基线的组合。 通常,可以指定具有连续或不连续的一个或多个时间段的基线。 还可以创建用于基于一组时间段来创建一组基线的模板,其中可以使用该模板为每组时间段创建基准。 可以创建具有随时间变化而变化的相关联的时间窗口的移动窗口基线,其中因此与基线相关联的数据也随着时间的推移而动态地改变。