会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 5. 发明授权
    • Database query optimization
    • 数据库查询优化
    • US08122033B2
    • 2012-02-21
    • US11971525
    • 2008-01-09
    • Jian LeWenbin Ma
    • Jian LeWenbin Ma
    • G06F17/00
    • G06F17/30442
    • A method, system, and computer program product for optimizing database queries in a data processing system. A query optimization (QO) utility maximizes the query coverage of Materialized Query Tables (MQTs) in order to efficiently process various types of incoming queries to a database engine. In particular, the QO utility enables MQT technology for nullable foreign key columns in a number of table joins involving fact tables and dimension tables, in which the fact tables and dimension tables have column data which are not null. The QO utility also enables MQT query matching for a relational database engine for non-additive measures, and improves the performance of existing query-matching capabilities for a relational database engine for additive measures. The QO utility specifies a number of functionally dependent relationships between the columns of a table in order to enhance the query matching abilities of the database engine.
    • 一种用于在数据处理系统中优化数据库查询的方法,系统和计算机程序产品。 查询优化(QO)实用程序最大化物化查询表(MQT)的查询覆盖率,以便有效地处理数据库引擎的各种传入查询。 特别地,QO实用程序在涉及事实表和维度表的多个表连接中启用MQT技术用于可空的外键列,其中事实表和维度表的列数据不为空。 QO实用程序还为关联数据库引擎启用MQT查询匹配以用于非加性度量,并提高了关系数据库引擎的加法度量的现有查询匹配功能的性能。 QO实用程序指定表的列之间的多个功能依赖关系,以增强数据库引擎的查询匹配能力。
    • 6. 发明授权
    • System and method for transforming queries using window aggregation
    • 使用窗口聚合转换查询的系统和方法
    • US07275056B2
    • 2007-09-25
    • US10425343
    • 2003-04-29
    • Qi ChengLinqi LiuWenbin MaMir Hamid PiraheshCalisto P. Zuzarte
    • Qi ChengLinqi LiuWenbin MaMir Hamid PiraheshCalisto P. Zuzarte
    • G06F7/00G06F17/30
    • G06F17/30451Y10S707/99934Y10S707/99935
    • A system and method transform queries with subqueries, using window aggregation. An optimizer in a relational database management system transforms queries to optimize their efficiency and speed. The method transforms queries that have a subquery, replacing the subquery with a window aggregation function. In the case of a correlated subquery, the window aggregation function is partitioned by a correlated column of a correlated table. All data in the main select clause, or outer block, of the query that was obtained through references to the correlated table is instead obtained through the new window aggregation subquery. By using window aggregation, the aggregation is performed at the same time as the selection of relevant data from the correlated table, thereby compiling all needed data in a single pass through the table or view. Reducing the number of times that tables or views are accessed reduces the computational demands of a query.
    • 系统和方法使用子查询转换查询,使用窗口聚合。 关系数据库管理系统中的优化器可以转换查询以优化其效率和速度。 该方法转换具有子查询的查询,使用窗口聚合函数替换子查询。 在相关子查询的情况下,窗口聚合函数由相关表的相关列划分。 通过引用相关表获得的查询的main select子句或外部块中的所有数据都是通过新的窗口聚合子查询得到的。 通过使用窗口聚合,在从相关表中选择相关数据的同时进行聚合,从而在通过表或视图的单次传递中编译所有需要的数据。 降低访问表或视图的次数减少了查询的计算需求。
    • 10. 发明申请
    • Database Query Optimization
    • 数据库查询优化
    • US20090177621A1
    • 2009-07-09
    • US11971525
    • 2008-01-09
    • Jian LeWenbin Ma
    • Jian LeWenbin Ma
    • G06F17/30
    • G06F17/30442
    • A method, system, and computer program product for optimizing database queries in a data processing system. A query optimization (QO) utility maximizes the query coverage of Materialized Query Tables (MQTs) in order to efficiently process various types of incoming queries to a database engine. In particular, the QO utility enables MQT technology for nullable foreign key columns in a number of table joins involving fact tables and dimension tables, in which the fact tables and dimension tables have column data which are not null. The QO utility also enables MQT query matching for a relational database engine for non-additive measures, and improves the performance of existing query-matching capabilities for a relational database engine for additive measures. The QO utility specifies a number of functionally dependent relationships between the columns of a table in order to enhance the query matching abilities of the database engine.
    • 一种用于在数据处理系统中优化数据库查询的方法,系统和计算机程序产品。 查询优化(QO)实用程序最大化物化查询表(MQT)的查询覆盖率,以便有效地处理数据库引擎的各种传入查询。 特别地,QO实用程序在涉及事实表和维度表的多个表连接中启用MQT技术用于可空的外键列,其中事实表和维度表的列数据不为空。 QO实用程序还为关联数据库引擎启用MQT查询匹配以用于非加性度量,并提高了关系数据库引擎的加法度量的现有查询匹配功能的性能。 QO实用程序指定表的列之间的多个功能依赖关系,以增强数据库引擎的查询匹配能力。