会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 77. 发明授权
    • Mean time to recover (MTTR) advisory
    • 平均恢复时间(MTTR)咨询
    • US07020599B1
    • 2006-03-28
    • US10017337
    • 2001-12-13
    • Qiang CaoSushil KumarTirthankar LahiriYunrui LiGianfranco Putzolu
    • Qiang CaoSushil KumarTirthankar LahiriYunrui LiGianfranco Putzolu
    • G06F9/45
    • G06F11/3457G06F17/30306G06F2201/86Y10S707/99943Y10S707/99953
    • A method for simulating different MTTR settings includes determining a simulated MTTR setting and providing a simulated checkpoint queue. The simulated checkpoint queue is associated with the simulated MTTR setting and is an ordered list of one or more elements. Each element represents a buffer, and the ordered list has a head and a tail. The method also includes providing a simulated write counter associated with the simulated MTTR setting. The method further includes, in response to detecting a change to a first buffer, checking if the first buffer is represented in the simulated checkpoint queue. If the first buffer is not represented in the simulated checkpoint queue, an element that represents the first buffer is linked to the tail of the simulated checkpoint queue. An MTTR advisory system includes a memory, one or more processors coupled to the memory, a simulated MTTR setting, a simulated checkpoint queue, and a simulated write counter. The simulated MTTR setting is maintained in the memory. The simulated checkpoint queue is maintained in the memory and associated with the simulated MTTR setting. The simulated write counter is also maintained in the memory, and is associated with the simulated MTTR setting. The simulated write counter provides a count of the number of times an element is removed from the simulated checkpoint queue, wherein the element is removed from the simulated checkpoint queue in response to a write out of a buffer from volatile memory and storing in nonvolatile memory.
    • 用于模拟不同MTTR设置的方法包括确定模拟MTTR设置并提供模拟检查点队列。 模拟的检查点队列与模拟的MTTR设置相关联,并且是一个或多个元素的有序列表。 每个元素表示一个缓冲区,有序列表有一个头和尾。 该方法还包括提供与模拟的MTTR设置相关联的模拟写入计数器。 该方法还包括响应于检测到对第一缓冲器的改变,检查在模拟检查点队列中是否表示第一缓冲器。 如果模拟检查点队列中没有表示第一个缓冲区,则表示第一个缓冲区的元素链接到模拟检查点队列的尾部。 MTTR咨询系统包括存储器,耦合到存储器的一个或多个处理器,模拟MTTR设置,模拟检查点队列和模拟写入计数器。 模拟的MTTR设置保留在内存中。 模拟检查点队列保存在存储器中并与模拟的MTTR设置相关联。 模拟写计数器也保存在存储器中,并与模拟的MTTR设置相关联。 仿真写入计数器提供从模拟检查点队列中删除元素的次数的计数,其中响应于从易失性存储器写入缓冲器并存储在非易失性存储器中,将元件从模拟检查点队列中移除。
    • 80. 发明申请
    • 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捕获的数据允许自动执行系统级别和用户级别分析,而不会不必要地影响系统性能,例如通过消除或减少重复工作负载以便诊断问题的要求。