专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

21. 发明申请

US20090064160A1 Transparent lazy maintenance of indexes and materialized views 审中-公开
标题翻译：透明懒惰维护索引和物化视图
公开(公告)号：US20090064160A1
公开(公告)日：2009-03-05
申请号：US11897770
申请日：2007-08-31
申请人： Per-Ake Larson , Jingren Zhou , Hicham G. Elmongui
发明人： Per-Ake Larson , Jingren Zhou , Hicham G. Elmongui
IPC分类号： G06F9/46
CPC分类号： G06F16/24539 , G06F16/2272 , G06F16/2393
摘要： Described herein is a materialized view or index maintenance system that includes a task generator component that receives an indication that an update transaction has committed against a base table in a database system. The task generator component, in response to the update transaction being received, generates a maintenance task for one or more of a materialized view or an index that is affected by the update transaction. A maintenance component transparently performs the maintenance task when a workload of a CPU in the database system is below a threshold or when an indication is received that a query that uses the one or more of the materialized view or the index has been received.
摘要翻译：这里描述的是物化视图或索引维护系统，其包括任务生成器组件，其接收更新事务针对数据库系统中的基表执行的指示。响应于正在接收的更新事务，任务生成器组件为受更新事务影响的物化视图或索引中的一个或多个生成维护任务。当数据库系统中的CPU的工作负载低于阈值或接收到指示使用了一个或多个物化视图或索引的查询已被接收时，维护组件透明地执行维护任务。

22. 发明授权

US07406468B2 View matching for materialized outer-join views 有权
标题翻译：查看物化外连接视图的匹配
公开(公告)号：US07406468B2
公开(公告)日：2008-07-29
申请号：US11152740
申请日：2005-06-14
申请人： Per-Ake Larson , Jingren Zhou
发明人： Per-Ake Larson , Jingren Zhou
IPC分类号： G06F7/00
CPC分类号： G06F17/30451 , G06F17/30439 , Y10S707/99934
摘要： A computer implemented system that facilitates view matching for outer join views comprises an interface component that receives at least one query that includes one or more outer join operators. A view matching-component converts the at least one query and outputs a substitute query expression. In accordance with one aspect of the subject invention, the view-matching component can comprise a normalization component that converts the at least one query and at least one materialized view into a normalized query expression and a normalized view expression. Furthermore, the view-matching component can include an analysis component that receives the normalized query expression and the normalized view expression, and a construction component that constructs the substitute query expression.
摘要翻译：促进外部连接视图的视图匹配的计算机实现的系统包括接收包括一个或多个外部连接运算符的至少一个查询的接口组件。视图匹配组件转换至少一个查询并输出替代查询表达式。根据本发明的一个方面，视图匹配组件可以包括将至少一个查询和至少一个物化视图转换成归一化查询表达式和归一化视图表达式的规范化组件。此外，视图匹配组件可以包括接收归一化查询表达式和归一化视图表达式的分析组件以及构造替代查询表达式的构造组件。

23. 发明申请

US20070250473A1 Use of materialized transient views in query optimization 有权
标题翻译：在查询优化中使用物化瞬态视图
公开(公告)号：US20070250473A1
公开(公告)日：2007-10-25
申请号：US11409341
申请日：2006-04-21
申请人： Per-Ake Larson , Jingren Zhou
发明人： Per-Ake Larson , Jingren Zhou
IPC分类号： G06F17/30
CPC分类号： G06F17/30457 , Y10S707/99932
摘要： Methods and systems for integrating use of materialized transient views into generation of an optimized query execution plan. Features and aspects hereof provide rapid identification of common expressions in a query as transient view candidates and then rapidly select among the transient view candidates for those transient views that most benefit the cost of execution of the query. The selected transient views are incorporated into a generated final, optimized query execution plan including operator to materialize the selected transient views for re-use in execution of the query.
摘要翻译：将物化瞬态视图集成到生成优化查询执行计划中的方法和系统。特征和方面可以将查询中的常见表达式快速识别为临时视图候选，然后在临时视图候选中快速选择最有利于查询执行成本的瞬态视图。所选择的瞬态视图被合并到生成的最终优化的查询执行计划中，包括运算符实现所选择的临时视图以便在查询的执行中重新使用。

24. 发明申请

US20060282424A1 View matching for materialized outer-join views 有权
标题翻译：查看物化外连接视图的匹配
公开(公告)号：US20060282424A1
公开(公告)日：2006-12-14
申请号：US11152740
申请日：2005-06-14
申请人： Per-Ake Larson , Jingren Zhou
发明人： Per-Ake Larson , Jingren Zhou
IPC分类号： G06F17/30
CPC分类号： G06F17/30451 , G06F17/30439 , Y10S707/99934
摘要： A computer implemented system that facilitates view matching for outer join views comprises an interface component that receives at least one query that includes one or more outer join operators. A view matching-component converts the at least one query and outputs a substitute query expression. In accordance with one aspect of the subject invention, the view-matching component can comprise a normalization component that converts the at least one query and at least one materialized view into a normalized query expression and a normalized view expression. Furthermore, the view-matching component can include an analysis component that receives the normalized query expression and the normalized view expression, and a construction component that constructs the substitute query expression.
摘要翻译：促进外部连接视图的视图匹配的计算机实现的系统包括接收包括一个或多个外部连接运算符的至少一个查询的接口组件。视图匹配组件转换至少一个查询并输出替代查询表达式。根据本发明的一个方面，视图匹配组件可以包括将至少一个查询和至少一个物化视图转换成归一化查询表达式和归一化视图表达式的规范化组件。此外，视图匹配组件可以包括接收归一化查询表达式和归一化视图表达式的分析组件以及构造替代查询表达式的构造组件。

25. 发明申请

US20060047696A1 Partially materialized views 审中-公开
标题翻译：部分物化视图
公开(公告)号：US20060047696A1
公开(公告)日：2006-03-02
申请号：US10971600
申请日：2004-10-21
申请人： Per-Ake Larson , Jingren Zhou , Jonathan Goldstein
发明人： Per-Ake Larson , Jingren Zhou , Jonathan Goldstein
IPC分类号： G06F17/00
CPC分类号： G06F16/24539 , G06F16/2393 , G06F16/24552
摘要： Partially materialized views in the field of database systems are described herein. A method of partially materializing a view computed from one or more source tables comprises generating a view definition including a query expression and at least one control predicate referencing at least one control table. The query expression specifies the maximal content of the view, that is, the complete set of records that could be materialized. One or more control predicates and the contents of one or more control tables restrict what records are actually materialized and stored in the view. This allows the content of the partially materialized view to be adjusted simply by updating one or more control tables.
摘要翻译：本文描述了数据库系统领域中的部分物化视图。部分实现从一个或多个源表计算出的视图的方法包括生成包括查询表达式和至少一个引用至少一个控制表的控制谓词的视图定义。查询表达式指定视图的最大内容，即可以实现的完整记录集。一个或多个控制谓词和一个或多个控制表的内容限制了实际实现并存储在视图中的记录。这允许通过更新一个或多个控制表来简单地调整部分实现视图的内容。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式