知搜-全球专利检索

  1. 登录
  2. 注册

搜索结果

1 条记录 (耗时 0.024 秒)

    Optimization of SQL queries involving aggregate expressions using a plurality of local and global aggregation operations
    1.
    发明授权
    Optimization of SQL queries involving aggregate expressions using a plurality of local and global aggregation operations 失效
    使用多个本地和全局聚合操作优化涉及聚合表达式的SQL查询

    公开(公告)号：US5884299A

    公开(公告)日：1999-03-16

    申请号：US795114

    申请日：1997-02-06

    申请人： Bhashyam Ramesh ,  Timothy Brent Kraus ,  Todd Allan Walter

    发明人： Bhashyam Ramesh ,  Timothy Brent Kraus ,  Todd Allan Walter

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30445 ,  G06F17/30489 ,  Y10S707/99932 ,  Y10S707/99933

    摘要： A method, apparatus, and article of manufacture for optimizing SQL queries in a relational database management system involving aggregate and grouping functions. A local aggregation operation is performed on one or more processors of a massively parallel processor (MPP) computer system, wherein rows of the table that are local to each processor are locally aggregated to create one or more aggregate result rows. The aggregate result rows created by each of the local aggregation operations are then re-distributed to one or more processors and coalesced into a global aggregate result row by a global aggregation operation.

    摘要翻译： 一种在关系数据库管理系统中优化SQL查询的方法，装置和制品，涉及聚合和分组功能。 在大规模并行处理器（MPP）计算机系统的一个或多个处理器上执行本地聚合操作，其中本地对每个处理器进行本地表的行被本地聚合以创建一个或多个聚合结果行。 然后将由每个本地聚合操作创建的聚合结果行重新分配到一个或多个处理器，并通过全局聚合操作合并到全局聚合结果行。