Time model
    4.
    发明授权
    Time model 有权
    时间模型

    公开(公告)号:US07376682B2

    公开(公告)日:2008-05-20

    申请号:US10775513

    申请日:2004-02-09

    IPC分类号: G06F17/30

    摘要: Quantifying the impact of wasteful operations on a database system is provided. One or more operations that are determined to be wasteful are received. The impact of the wasteful operations on performance in a database may then be quantified. The database is monitored to determine when a wasteful operation is being performed. When a wasteful operation is detected, a time value is recorded of the time spent on processing the wasteful operation. The time value is stored and used to quantify an impact of a performance problem in a database. The time value may be stored and associated with other time values that are recorded for the same wasteful operation. Thus, the impact of wasteful operations that are performed and processed in a database may be determined.

    摘要翻译: 提供了浪费操作对数据库系统的影响。 接收到被确定为浪费的一个或多个操作。 然后可以量化浪费操作对数据库中的性能的影响。 监视数据库以确定何时执行浪费的操作。 当检测到浪费的操作时,记录处理浪费操作花费的时间的时间值。 时间值被存储并用于量化数据库中性能问题的影响。 时间值可以被存储并且与为相同的浪费操作记录的其他时间值相关联。 因此,可以确定在数据库中执行和处理的浪费操作的影响。

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

    公开(公告)号:US07774312B2

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

    申请号:US10934771

    申请日:2004-09-03

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

    Methods and systems for database statement execution plan optimization
    6.
    发明授权
    Methods and systems for database statement execution plan optimization 有权
    数据库语句执行计划优化的方法和系统

    公开(公告)号:US07092931B1

    公开(公告)日:2006-08-15

    申请号:US10144681

    申请日:2002-05-10

    IPC分类号: G06F7/00 G06F17/30

    摘要: The methods and systems for database statement execution plan optimization exploit bind variable data available on the network to build and optimize an execution plan for the statement. A system for database statement execution plan optimization comprises a bind variable analyzer, a frame allocator, and an optimizer, in addition to a parser for parsing and analyzing the statement, a type checker for type checking the statement, and a tree builder for building an expression tree.

    摘要翻译: 数据库语句执行计划优化的方法和系统利用网络上可用的绑定变量数据来构建和优化语句的执行计划。 用于数据库语句执行计划优化的系统除了用于解析和分析语句的解析器之外还包括绑定变量分析器,帧分配器和优化器,用于检查语句的类型检查器,以及用于构建语句的树构建器 表达式树。

    Methods and systems for database statement execution plan optimization
    7.
    发明授权
    Methods and systems for database statement execution plan optimization 有权
    数据库语句执行计划优化的方法和系统

    公开(公告)号:US07324985B2

    公开(公告)日:2008-01-29

    申请号:US11433842

    申请日:2006-05-12

    IPC分类号: G06F7/00 G06F17/30

    摘要: The methods and systems for database statement execution plan optimization exploit bind variable data available on the network to build and optimize an execution plan for the statement. A system for database statement execution plan optimization comprises a bind variable analyzer, a frame allocator, and an optimizer, in addition to a parser for parsing and analyzing the statement, a type checker for type checking the statement, and a tree builder for building an expression tree.

    摘要翻译: 数据库语句执行计划优化的方法和系统利用网络上可用的绑定变量数据来构建和优化语句的执行计划。 用于数据库语句执行计划优化的系统除了用于解析和分析语句的解析器之外还包括绑定变量分析器,帧分配器和优化器,用于检查语句的类型检查器,以及用于构建语句的树构建器 表达式树。