利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

15 条记录 (耗时 0.052 秒)

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

    公开(公告)号：US07774312B2

    公开(公告)日：2010-08-10

    申请号：US10934771

    申请日：2004-09-03

    申请人： Gary Ngai ,  Michael Feng ,  Alex Tsukerman ,  Benoit Dageville ,  Mark Ramacher ,  Karl Dias ,  Graham S. Wood ,  Leng Leng Tan ,  Richard Sarwal ,  Sushil Kumar

    发明人： Gary Ngai ,  Michael Feng ,  Alex Tsukerman ,  Benoit Dageville ,  Mark Ramacher ,  Karl Dias ,  Graham S. Wood ,  Leng Leng Tan ,  Richard Sarwal ,  Sushil Kumar

    IPC分类号： G06F17/30

    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捕获的数据允许自动执行系统级别和用户级别分析，而不会不必要地影响系统性能，例如通过消除或减少重复工作负载以便诊断问题的要求。

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

    公开(公告)号：US20050086263A1

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

    申请号：US10934771

    申请日：2004-09-03

    申请人： Gary Ngai ,  Michael Feng ,  Alex Tsukerman ,  Benoit Dageville ,  Mark Ramacher ,  Karl Dias ,  Graham Wood ,  Leng Leng Tan ,  Richard Sarwal ,  Sushil Kumar

    发明人： Gary Ngai ,  Michael Feng ,  Alex Tsukerman ,  Benoit Dageville ,  Mark Ramacher ,  Karl Dias ,  Graham Wood ,  Leng Leng Tan ,  Richard Sarwal ,  Sushil Kumar

    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捕获的数据允许自动执行系统级别和用户级别分析，而不会不必要地影响系统性能，例如通过消除或减少重复工作负载以便诊断问题的要求。

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

    公开(公告)号：US07664798B2

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

    申请号：US10934345

    申请日：2004-09-03

    申请人： Graham Stephen Wood ,  Alex Tsukerman ,  Richard Sarwal ,  Gary Ngai ,  Mark Ramacher ,  Leng Leng Tan

    发明人： Graham Stephen Wood ,  Alex Tsukerman ,  Richard Sarwal ,  Gary Ngai ,  Mark Ramacher ,  Leng Leng Tan

    IPC分类号： G07F17/30

    CPC分类号： G06F17/30289 ,  Y10S707/99932 ,  Y10S707/99945

    摘要： 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.

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

    Database performance baselines
    7.
    发明申请
    Database performance baselines 有权
    数据库性能基准

    公开(公告)号：US20050086246A1

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

    申请号：US10934345

    申请日：2004-09-03

    申请人： Graham Wood ,  Alex Tsukerman ,  Richard Sarwal ,  Gary Ngai ,  Mark Ramacher ,  Leng Leng Tan

    发明人： Graham Wood ,  Alex Tsukerman ,  Richard Sarwal ,  Gary Ngai ,  Mark Ramacher ,  Leng Leng Tan

    IPC分类号： G06F7/00 ,  G06F17/00 ,  G06F17/30

    CPC分类号： G06F17/30289 ,  Y10S707/99932 ,  Y10S707/99945

    摘要： 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.

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

    Method and apparatus for improved transaction recovery
    10.
    发明授权
    Method and apparatus for improved transaction recovery 失效
    改进交易恢复的方法和装置

    公开(公告)号：US5850507A

    公开(公告)日：1998-12-15

    申请号：US618443

    申请日：1996-03-19

    申请人： Gary C. Ngai ,  Hasan Rizvi ,  Leng Leng Tan

    发明人： Gary C. Ngai ,  Hasan Rizvi ,  Leng Leng Tan

    IPC分类号： G06F11/14 ,  G06F11/00

    CPC分类号： G06F11/1474 ,  G06F2201/80 ,  Y10S707/99953

    摘要： A method and system for recovering after a crash of an instance in a database is disclosed. According to the method, transaction information corresponding to all the transactions that existed in the failed instance is inspected. These transactions that were active at the time the instance crashed are marked as "dead." The database is made available to users after updating the transaction information and before undoing all of the changes or updates performed by dead transactions. The changes made by the dead transactions may be undone by new transactions on a on-demand basis after the database is made available. Specifically, when a new transaction is waiting to obtain a lock on a resource held by another transaction, the new transaction determines whether the owner of the lock is one of the dead transactions. If so, the new transaction rolls back some or all of the changes made by the dead transaction.

    摘要翻译： 公开了在数据库中的实例崩溃之后恢复的方法和系统。 根据该方法，检查与失败实例中存在的所有事务相对应的事务信息。 在实例崩溃时活动的这些事务被标记为“死亡”。 数据库在更新事务信息之后以及在撤销由死锁事务执行的所有更改或更新之前可用于用户。 在数据库可用之后，死亡交易所做的更改可能会在需求的基础上被新的交易撤销。 具体来说，当新事务正在等待获取另一个事务所持有的资源的锁时，新的事务将确定该锁的所有者是否是其中一个死锁事务。 如果是这样，新的事务会回滚一些或所有由死的事务所做的更改。