AUTOMATIC QUERY EXECUTION PLAN MANAGEMENT AND PERFORMANCE STABILIZATION FOR WORKLOADS
    11.
    发明申请
    AUTOMATIC QUERY EXECUTION PLAN MANAGEMENT AND PERFORMANCE STABILIZATION FOR WORKLOADS 有权
    自动查询执行计划管理和性能稳定工作

    公开(公告)号:US20100223253A1

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

    申请号:US12395836

    申请日:2009-03-02

    IPC分类号: G06F17/30 G06F7/00

    CPC分类号: G06F17/30306

    摘要: A method, apparatus, and computer program product are disclosed for managing query execution plans for a workload. In one embodiment, the method includes gathering an initial set of performance characteristics generated from a database management system (DBMS) executing a database workload according to one or more query execution plans (QEPs). The database workload includes one or more database statements. The method determines a QEP change for one or more QEPs of the database workload. In addition, the method gathers a subsequent set of performance characteristics generated from the DBMS executing the one or more QEPs of the database workload influenced by the QEP change. Furthermore, the method determines a performance difference created by the QEP change based on the initial set of performance characteristics and the subsequent set of performance characteristics and responds to the performance difference in accordance with a monitoring policy.

    摘要翻译: 公开了用于管理工作负载的查询执行计划的方法,装置和计算机程序产品。 在一个实施例中,该方法包括收集根据一个或多个查询执行计划(QEP)从执行数据库工作负荷的数据库管理系统(DBMS)生成的一组初始性能特征。 数据库工作负载包括一个或多个数据库语句。 该方法确定数据库工作负载的一个或多个QEP的QEP更改。 此外,该方法收集从DBMS生成的后续一组性能特征,这些特性执行受QEP更改影响的数据库工作负载的一个或多个QEP。 此外,该方法基于初始的性能特征集合和后续的一组性能特性来确定由QEP变化产生的性能差异,并且根据监视策略来响应性能差异。

    Rebalancing partitioned data
    13.
    发明授权
    Rebalancing partitioned data 失效
    重新平衡分区数据

    公开(公告)号:US06269375B1

    公开(公告)日:2001-07-31

    申请号:US09053356

    申请日:1998-04-01

    IPC分类号: G06F1130

    摘要: A method, apparatus, and article of manufacture for a computer implemented rebalancing system. Partitioned data is rebalanced in a database stored on a data storage device connected to a computer. Range values are redefined for each partition. Next, the data is reordered into the redefined ranges for the partitions.

    摘要翻译: 一种用于计算机实现的重新平衡系统的方法,装置和制品。 分割的数据在存储在连接到计算机的数据存储设备上的数据库中重新平衡。 为每个分区重新定义范围值。 接下来,将数据重新排序到分区的重新定义的范围内。

    High performance recover/build index system by unloading database files
in parallel
    15.
    发明授权
    High performance recover/build index system by unloading database files in parallel 失效
    高性能恢复/构建索引系统通过并行卸载数据库文件

    公开(公告)号:US5842208A

    公开(公告)日:1998-11-24

    申请号:US838647

    申请日:1997-04-09

    IPC分类号: G06F17/30 G06F7/00

    摘要: A method, apparatus, and article of manufacture for a computer implemented recover/build index system. The recover/build index system builds a database index for a database file by scanning partitions of the database file in parallel to retrieve key values and their associated record identifier (rid) values. The recover/build index system then sorts the scanned key/rid values for each partition in parallel. Next, the recover/build index system performs one or more merges on the sorted key/rid values from all of the partitions to generate a single key/rid value stream. Finally, the recover/build index system builds the index using the single key/rid value stream.

    摘要翻译: 计算机实现的恢复/构建索引系统的方法,装置和制品。 recover / build index系统通过并行扫描数据库文件的分区来检索数据库文件的数据库索引,以检索密钥值及其关联的记录标识符(删除)值。 然后,恢复/构建索引系统并行排列每个分区的扫描密钥/排除值。 接下来,恢复/构建索引系统对来自所有分区的排序的关键点/排除值执行一个或多个合并以生成单个关键点/排除值流。 最后,恢复/构建索引系统使用单个键/值返回值构建索引。