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

1. 发明申请

US20060122964A1 Materialized view maintenance and change tracking 有权
标题翻译：物化视图维护和更改跟踪
公开(公告)号：US20060122964A1
公开(公告)日：2006-06-08
申请号：US11004145
申请日：2004-12-03
申请人： Tsae-Feng Yu , John Raitto , Bhujanga Panchapagesan , Shilpa Lawande , Randall Bello
发明人： Tsae-Feng Yu , John Raitto , Bhujanga Panchapagesan , Shilpa Lawande , Randall Bello
IPC分类号： G06F17/30
CPC分类号： G06F17/30383
摘要： A technique for refreshing materialized views in a database is disclosed. The detail table is partitioned, and changes made to the detail table are tracked with information stored, for example. Only sections in the materialized view which correspond to the partitions which include modifications made to the detail table are refreshed, thus avoiding the need of a complete refresh to overcome staleness.
摘要翻译：公开了一种在数据库中刷新物化视图的技术。细节表被分区，例如对存储的信息跟踪对详细表的更改。在物化视图中仅对包括对细节表进行的修改的分区对应的部分被刷新，从而避免了完全刷新以克服平坦化的需要。

2. 发明申请

US20070214107A1 Dynamic materialized view ranging 有权
标题翻译：动态物化视图范围
公开(公告)号：US20070214107A1
公开(公告)日：2007-09-13
申请号：US11374593
申请日：2006-03-13
申请人： Randall Bello , John Raitto
发明人： Randall Bello , John Raitto
IPC分类号： G06F17/30
CPC分类号： G06F17/30457
摘要： Systems, methods, media, and other embodiments associated with dynamically ranging over a set of materialized views to determine whether to associate a materialized view with a query at execution time are described. One example system may include a materialized view creation time logic that is configured to identify a materialized view, to create a containment expression, and to relate the containment expression to the materialized view. The example system may also include an execution time logic that is configured to receive a query having a bind variable. The execution time logic may dynamically range over materialized views to determine whether to use a materialized view(s) to process the query having the bind variable.
摘要翻译：描述了与在一组物化视图上的动态范围相关联的系统，方法，媒体和其他实施例，以确定是否在执行时间将物化视图与查询相关联。一个示例性系统可以包括物化视图创建时间逻辑，其被配置为识别物化视图，以创建包含表达，以及将该含有表达式与物化视图相关联。示例系统还可以包括被配置为接收具有绑定变量的查询的执行时间逻辑。执行时间逻辑可以动态地覆盖物化视图，以确定是否使用物化视图来处理具有绑定变量的查询。

3. 发明授权

US06345272B1 Rewriting queries to access materialized views that group along an ordered dimension 有权
标题翻译：重写查询以访问沿有序维度分组的物化视图
公开(公告)号：US06345272B1
公开(公告)日：2002-02-05
申请号：US09361688
申请日：1999-07-27
申请人： Andrew Witkowski , Randall Bello , Mohamed Ziauddin
发明人： Andrew Witkowski , Randall Bello , Mohamed Ziauddin
IPC分类号： G06F1730
CPC分类号： G06F17/30592 , G06F17/30457 , G06F17/30489 , Y10S707/99932 , Y10S707/99934 , Y10S707/99936 , Y10S707/99943 , Y10S707/99944
摘要： A method and apparatus are provided for rewriting aggregate queries to access a materialized view when (1) the queries place a restriction on an ordered dimension, (2) the materialized view aggregates the information referenced in the query and groups by the same dimension, and (3) the materialized view groups the information at a coarser level of granularity than the granularity associated with the restriction contained in the aggregate queries.
摘要翻译：提供了一种方法和装置，用于当（1）查询对有序维度进行限制时，重写聚合查询以访问物化视图，（2）物化视图将查询中引用的信息和组以相同的维度进行聚合，以及（3）物化视图将粒度信息与比较集合查询中包含的限制相关联的粒度进行分组。

4. 发明授权

US06496819B1 Rewriting a query in terms of a summary based on functional dependencies and join backs, and based on join derivability 有权
标题翻译：基于功能依赖关系和连接回覆，并基于连接派生性重写一个摘要方面的查询
公开(公告)号：US06496819B1
公开(公告)日：2002-12-17
申请号：US09221641
申请日：1998-12-28
申请人： Randall Bello , James Finnerty , Mohamed Ziauddin , Andrew Witkowski
发明人： Randall Bello , James Finnerty , Mohamed Ziauddin , Andrew Witkowski
IPC分类号： G06F1700
CPC分类号： G06F17/30457 , G06F17/30454 , Y10S707/99933 , Y10S707/99934
摘要： A method and system is provided for processing queries. Specifically, techniques are provided for handling a query that does not reference a particular materialized view, where the query requires access to values from a particular column not contained in the materialized view. A technique is also provided for processing a query that does not reference a particular materialized aggregate view, where the materialized aggregate view specifies an outer join between a child table and a parent table and the query specifies a particular type of join between the child table and the parent table, where the particular type of join is one of an inner join, an anti-join and a semi-join. The query is rewritten to produce a rewritten query that accesses the materialized aggregate view to produce data required by the query. A technique is also provided for processing a query that does not reference a particular materialized view and that specifies that results are to be grouped by a first set of one or more columns, where the materialized view reflects data that is grouped by a second set of one or more columns. If each column in the first set of columns either exactly matches a column in the second set of columns, is functionally dependent on another column in the first set of columns, or is functionally dependent on a column in the second set of columns, then the query is rewritten to produce a rewritten query that references the materialized view.
摘要翻译：提供了一种用于处理查询的方法和系统。具体来说，提供了用于处理不引用特定物化视图的查询的技术，其中查询需要访问不包含在实例化视图中的特定列的值。还提供了一种用于处理不引用特定物化聚合视图的查询的技术，其中物化聚合视图指定子表和父表之间的外连接，并且查询指定子表和子表之间的特定类型的连接父表，其中特定类型的连接是内连接，反连接和半连接之一。该查询被重写以产生重写的查询，该查询访问物化聚合视图以产生查询所需的数据。还提供了一种用于处理不引用特定物化视图并且指定结果由第一组一个或多个列分组的查询的技术，其中物化视图反映了由第二组一个或多个列。如果第一组列中的每列与第二组列中的列精确匹配，则在功能上依赖于第一组列中的另一列，或者在功能上依赖于第二组列中的列，则查询被重写以产生引用物化视图的重写查询。

5. 发明授权

US06477525B1 Rewriting a query in terms of a summary based on one-to-one and one-to-many losslessness of joins 有权
标题翻译：根据一对一和一对多无连接的无损性重写一个摘要的查询
公开(公告)号：US06477525B1
公开(公告)日：2002-11-05
申请号：US09221363
申请日：1998-12-28
申请人： Randall Bello , James Finnerty , Mohamed Ziauddin , Andrew Witkowski
发明人： Randall Bello , James Finnerty , Mohamed Ziauddin , Andrew Witkowski
IPC分类号： G06F1700
CPC分类号： G06F17/30457 , G06F17/30489 , Y10S707/99933 , Y10S707/99934
摘要： A method and system are provided for processing queries. According to one aspect of the invention, a query that does not reference a particular materialized view is rewritten to reference the materialized view. In particular, upon receiving the query, it is determined whether the particular materialized view satisfies each condition in a set of conditions, where the set of conditions at least includes a condition that the materialized view reflects all rows that exist in a common section. The common section is a section of the query that is common to both the materialized view and the query. If the materialized view satisfies each condition in the set of conditions, then the query is rewritten to produce a rewritten query that references the materialized view. The materialized view may be a summary table that includes a summary column. The summary column contains values generated by aggregating values contained in rows produced by a one-to-many lossless join. The one-to-many lossless join is not in the common section. The query includes a cumulative aggregate function. Under these conditions, the method includes generating results of the cumulative aggregate function in the query by dividing values from the summary column by scaling factors.
摘要翻译：提供了一种用于处理查询的方法和系统。根据本发明的一个方面，重写未参考特定实例化视图的查询以引用实例化视图。具体地，在接收到查询后，确定特定实体化视图是否满足条件集合中的每个条件，其中条件集至少包括物化视图反映存在于公共部分中的所有行的条件。公共部分是查询的一部分，它与物化视图和查询都是共同的。如果物化视图满足条件集中的每个条件，则重写查询以产生引用物化视图的重写查询。实例化视图可以是包含摘要列的摘要表。摘要列包含通过聚合由一对多无损连接生成的行中包含的值生成的值。一对多无损连接不在共同的部分。该查询包括累积聚合函数。在这些条件下，该方法包括通过将摘要列中的值除以缩放因子来生成查询中的累积聚合函数的结果。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式