Query workload statistics collection in a database management system
    2.
    发明申请
    Query workload statistics collection in a database management system 有权
    在数据库管理系统中查询工作负载统计信息

    公开(公告)号:US20050234900A1

    公开(公告)日:2005-10-20

    申请号:US10824856

    申请日:2004-04-14

    IPC分类号: G06F17/30

    摘要: In various embodiments, a method, apparatus, and article of manufacture collect statistics in a database management system. A workload comprising a plurality of database queries is received. Query statistics for the database queries are identified. The query statistics for the database queries are consolidated to provide consolidated statistics. One or more statistics collection requests are generated based on the consolidated statistics.

    摘要翻译: 在各种实施例中,方法,装置和制品在数据库管理系统中收集统计数据。 接收包括多个数据库查询的工作负载。 识别数据库查询的查询统计信息。 合并数据库查询的查询统计信息以提供统一统计信息。 基于统一统计信息生成一个或多个统计信息收集请求。

    STATISTICS MANAGEMENT
    4.
    发明申请
    STATISTICS MANAGEMENT 失效
    统计管理

    公开(公告)号:US20090030875A1

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

    申请号:US12140994

    申请日:2008-06-17

    IPC分类号: G06F17/30

    摘要: Disclosed is a technique for maintaining statistics. A query is received. Column group generation is performed to form one or more column groups. Column group refinement is performed based on statistics data generated for a previously received query. A statistics check is automatically performed. A statistics collection command is generated to obtain statistics.

    摘要翻译: 公开了一种维护统计的技术。 接收到查询。 执行列组生成以形成一个或多个列组。 基于针对先前接收到的查询生成的统计数据执行列组细化。 统计检查自动执行。 生成统计信息收集命令,获取统计信息。

    Statistics management
    6.
    发明授权
    Statistics management 失效
    统计管理

    公开(公告)号:US07984024B2

    公开(公告)日:2011-07-19

    申请号:US12140994

    申请日:2008-06-17

    IPC分类号: G06F7/00 G06F17/00

    摘要: Disclosed is a technique for maintaining statistics. A query is received. Column group generation is performed to form one or more column groups. Column group refinement is performed based on statistics data generated for a previously received query. A statistics check is automatically performed. A statistics collection command is generated to obtain statistics.

    摘要翻译: 公开了一种维护统计的技术。 接收到查询。 执行列组生成以形成一个或多个列组。 基于针对先前接收到的查询生成的统计数据执行列组细化。 统计检查自动执行。 生成统计信息收集命令,获取统计信息。

    Method, system, and program for statistics management
    8.
    发明申请
    Method, system, and program for statistics management 有权
    统计管理的方法,系统和程序

    公开(公告)号:US20050149505A1

    公开(公告)日:2005-07-07

    申请号:US10752915

    申请日:2004-01-07

    IPC分类号: G06F17/30

    摘要: Disclosed is a technique for maintaining statistics. A query is received. Column group generation is performed to form one or more column groups. Column group refinement is performed based on statistics data generated for a previously received query. A statistics check is automatically performed. A statistics collection command is generated to obtain statistics.

    摘要翻译: 公开了一种维护统计的技术。 接收到查询。 执行列组生成以形成一个或多个列组。 基于针对先前接收到的查询生成的统计数据执行列组细化。 统计检查自动执行。 生成统计信息收集命令,获取统计信息。

    TOOL AND A METHOD FOR CUSTOMIZING HINT
    9.
    发明申请
    TOOL AND A METHOD FOR CUSTOMIZING HINT 审中-公开
    工具和定制提示的方法

    公开(公告)号:US20080091647A1

    公开(公告)日:2008-04-17

    申请号:US11766759

    申请日:2007-06-21

    IPC分类号: G06F7/00

    CPC分类号: G06F16/2453

    摘要: The application relates to a tool and a method for customizing hint. According to the invention, provided is at least one hint service adapter configured to collect relevant information of different database platforms, validate customized hint on real database platforms and provide feedback, and deploy the customized hint on database platform. Also provided is hint defining means configured to customize hint independently of database platforms, and providing customized hint to the at least one hint service adapter.

    摘要翻译: 该应用涉及一种用于自定义提示的工具和方法。 根据本发明,提供了至少一个提示服务适配器,其被配置为收集不同数据库平台的相关信息,验证真实数据库平台上的定制提示并提供反馈,并在数据库平台上部署定制提示。 还提供了提示定义装置,被配置为独立于数据库平台定制提示,并且向至少一个提示服务适配器提供定制提示。