公开(公告)号：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.

摘要翻译： 公开了一种在数据库中刷新物化视图的技术。 细节表被分区，例如对存储的信息跟踪对详细表的更改。 在物化视图中仅对包括对细节表进行的修改的分区对应的部分被刷新，从而避免了完全刷新以克服平坦化的需要。

公开(公告)号：US07930297B2

公开(公告)日：2011-04-19

申请号：US11004145

申请日：2004-12-03

申请人： Tsae-Feng Yu ,  John Raitto ,  Bhujanga Panchapagesan ,  Shilpa Lawande ,  Randall G. Bello

发明人： Tsae-Feng Yu ,  John Raitto ,  Bhujanga Panchapagesan ,  Shilpa Lawande ,  Randall G. 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.

摘要翻译： 公开了一种在数据库中刷新物化视图的技术。 细节表被分区，例如对存储的信息跟踪对详细表的更改。 在物化视图中仅对包括对细节表进行的修改的分区对应的部分被刷新，从而避免了完全刷新以克服平坦化的需要。

公开(公告)号：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.

摘要翻译： 描述了与在一组物化视图上的动态范围相关联的系统，方法，媒体和其他实施例，以确定是否在执行时间将物化视图与查询相关联。 一个示例性系统可以包括物化视图创建时间逻辑，其被配置为识别物化视图，以创建包含表达，以及将该含有表达式与物化视图相关联。 示例系统还可以包括被配置为接收具有绑定变量的查询的执行时间逻辑。 执行时间逻辑可以动态地覆盖物化视图，以确定是否使用物化视图来处理具有绑定变量的查询。

公开(公告)号：US09063962B2

公开(公告)日：2015-06-23

申请号：US13842843

申请日：2013-03-15

申请人： John Raitto ,  Tirthankar Lahiri ,  Marie-Anne Neimat ,  Chih-Ping Wang

发明人： John Raitto ,  Tirthankar Lahiri ,  Marie-Anne Neimat ,  Chih-Ping Wang

IPC分类号： G06F17/30

摘要： A method, apparatus, and system for automatically determining an optimal database subsection is provided. A database subsection is selected to optimize certain benefits when the database subsection is translated, transferred, and cached on an alternative database system, which may utilize a different technology or database engine that provides certain performance benefits compared to the original database system. Algorithms such as multi-path greedy selection and/or dynamic programming may provide optimal or near-optimal results. A host for the alternative database server may be shared with or otherwise located in close physical proximity to improve latency for a database application or client layer. Once the database subsection analysis is completed, a report may be generated and presented to the user, and an implementation script may also be created to automatically configure a client host to function as a cache or replacement system according various cache size configurations described in the report.

公开(公告)号：US5991754A

公开(公告)日：1999-11-23

申请号：US222249

申请日：1998-12-28

申请人： John Raitto ,  Mohamed Ziauddin ,  James Finnerty

发明人： John Raitto ,  Mohamed Ziauddin ,  James Finnerty

IPC分类号： G06F17/30

CPC分类号： G06F17/30489 ,  G06F17/30457 ,  Y10S707/99932 ,  Y10S707/99934

摘要： A method and system are provided for processing queries, where the queries do not reference a particular materialized view. Specifically, techniques are provided for handling a query that specifies a first set of one or more aggregate functions, where the particular materialized view reflects a second set of one or more aggregate functions. Whether the query can be rewritten is determined based on the aggregate functions in the first and second sets, and the corresponding arguments. Techniques are also provided for processing a query that (1) does not reference a particular materialized view, (2) specifies a first set of one or more aggregate functions, where the particular materialized view reflects a second set of one or more aggregate functions. A technique is also provided for rewriting queries that specify an outer join that has a dimension table on the child-side of the outer join and a fact table on the parent-side of the outer join. The query is rewritten to produce a rewritten query by replacing references to the fact table in the query with references to a materialized view. The rewritten query specifies an outer join that has the dimension table on the child side and the materialized view on the parent side.

摘要翻译： 提供了一种用于处理查询的方法和系统，其中查询不引用特定的物化视图。 具体地，提供了用于处理指定一个或多个聚合函数的第一组的查询的技术，其中特定实例化视图反映第二组一个或多个聚合函数。 是否可以重写查询是基于第一组和第二组中的聚合函数以及相应的参数来确定的。 还提供了用于处理查询的技术，其中（1）不引用特定的实例化视图，（2）指定一个或多个聚合函数的第一组，其中特定实例化视图反映第二组一个或多个聚合函数。 还提供了一种技术，用于重写查询，该查询指定外部联接的外部连接，外部连接的子边上具有维度表，外部连接的父侧上的事实表。 重写该查询以通过替换引用到实例化视图的查询中的事实表的引用来替换引用的查询。 重写的查询指定了一个外连接，它具有子端的维度表和父端的实例化视图。

公开(公告)号：US20140280373A1

公开(公告)日：2014-09-18

申请号：US13842843

申请日：2013-03-15

申请人： John Raitto ,  Tirthankar Lahiri ,  Marie-Anne Neimat ,  Chih-Ping Wang

发明人： John Raitto ,  Tirthankar Lahiri ,  Marie-Anne Neimat ,  Chih-Ping Wang

IPC分类号： G06F17/30

CPC分类号： G06F17/30292 ,  G06F17/30442 ,  G06F17/30463 ,  G06F17/30575

摘要： A method, apparatus, and system for automatically determining an optimal database subsection is provided. A database subsection is selected to optimize certain benefits when the database subsection is translated, transferred, and cached on an alternative database system, which may utilize a different technology or database engine that provides certain performance benefits compared to the original database system. Algorithms such as multi-path greedy selection and/or dynamic programming may provide optimal or near-optimal results. A host for the alternative database server may be shared with or otherwise located in close physical proximity to improve latency for a database application or client layer. Once the database subsection analysis is completed, a report may be generated and presented to the user, and an implementation script may also be created to automatically configure a client host to function as a cache or replacement system according various cache size configurations described in the report.

摘要翻译： 提供了一种用于自动确定最佳数据库子部分的方法，装置和系统。 当数据库部分被翻译，传输和缓存在替代数据库系统上时，选择数据库子部分来优化某些优点，替代数据库系统可以利用与原始数据库系统相比提供某些性能优势的不同技术或数据库引擎。 诸如多路径贪心选择和/或动态规划的算法可以提供最佳或接近最佳的结果。 替代数据库服务器的主机可以与物理接近处于共享状态或以其他方式设置，以改善数据库应用程序或客户端层的延迟。 一旦完成了数据库子部分分析，就可以生成报告并呈现给用户，还可以创建实现脚本，以便根据报告中描述的各种缓存大小配置自动配置客户端主机作为缓存或替换系统。 。