会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 12. 发明申请
    • 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实用程序指定表的列之间的多个功能依赖关系,以增强数据库引擎的查询匹配能力。