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

1. 发明授权

US07930297B2 Materialized view maintenance and change tracking 有权
标题翻译：物化视图维护和更改跟踪
公开(公告)号：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.
摘要翻译：公开了一种在数据库中刷新物化视图的技术。细节表被分区，例如对存储的信息跟踪对详细表的更改。在物化视图中仅对包括对细节表进行的修改的分区对应的部分被刷新，从而避免了完全刷新以克服平坦化的需要。

2. 发明申请

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

3. 发明授权

US07440963B1 Rewriting a query to use a set of materialized views and database objects 有权
标题翻译：重写查询以使用一组物化视图和数据库对象
公开(公告)号：US07440963B1
公开(公告)日：2008-10-21
申请号：US10337714
申请日：2003-01-07
申请人： Randall G. Bello , Bhujanga Panchapagesan , Tsae-Feng Yu , John D. Raitto
发明人： Randall G. Bello , Bhujanga Panchapagesan , Tsae-Feng Yu , John D. Raitto
IPC分类号： G06F17/30
CPC分类号： G06F17/30457 , Y10S707/99933
摘要： An approach for processing a query in a database system is disclosed. An original query is determined to be partially satisfied by a materialized view. The original query is transformed using a set operation (i.e., union and intersection) on the materialized view and either another materialized view or a base table.
摘要翻译：公开了一种在数据库系统中处理查询的方法。原始查询被确定为通过物化视图部分满足。原始查询使用物化视图和另一物化视图或基表上的设置操作（即联合和交集）进行转换。

4. 发明申请

US20060224564A1 Materialized view tuning and usability enhancement 审中-公开
标题翻译：物化视图调整和可用性增强
公开(公告)号：US20060224564A1
公开(公告)日：2006-10-05
申请号：US11124480
申请日：2005-05-06
申请人： Tsae-Feng Yu , Jack Raitto , Thomas Tong , Min Xiao
发明人： Tsae-Feng Yu , Jack Raitto , Thomas Tong , Min Xiao
IPC分类号： G06F17/30
CPC分类号： G06F16/22
摘要： A method and system for enhancing a materialized view. In one embodiment the method includes analyzing a defined query of the materialized view, checking the requirements of the materialized view log, generating execution scripts that automatically create and enhance the materialized view logs and tuning the materialized view.
摘要翻译：一种用于增强物化视图的方法和系统。在一个实施例中，该方法包括分析物化视图的定义查询，检查物化视图日志的需求，生成自动创建和增强物化视图日志并调整物化视图的执行脚本。

5. 发明授权

US07895186B2 Method and mechanism of materialized view mix incremental refresh 有权
标题翻译：物化视图混合增量刷新的方法和机制
公开(公告)号：US07895186B2
公开(公告)日：2011-02-22
申请号：US11123922
申请日：2005-05-06
申请人： Tsae-Feng Yu
发明人： Tsae-Feng Yu
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30457 , Y10S707/99942
摘要： A method and system for updating both partition change track tables and non-partition track tables in a materialized view. A log-based incremental refresh is performed on the materialized view and a partition change tracking based refresh is performed on the materialized view. The dependency of the materialized view log for the partition change track base table is removed.
摘要翻译：一种用于在物化视图中更新分区更改跟踪表和非分区轨道表的方法和系统。在物化视图上执行基于日志的增量刷新，并在物化视图上执行基于分区更改跟踪的刷新。删除分区更改轨道基表的实例化视图日志的依赖关系。

6. 发明申请

US20060253483A1 Method and mechanism of materialized view mix incremental refresh 有权
标题翻译：物化视图混合增量刷新的方法和机制
公开(公告)号：US20060253483A1
公开(公告)日：2006-11-09
申请号：US11123922
申请日：2005-05-06
申请人： Tsae-Feng Yu
发明人： Tsae-Feng Yu
IPC分类号： G06F7/00
CPC分类号： G06F17/30457 , Y10S707/99942
摘要： A method and system for updating both partition change track tables and non-partition track tables in a materialized view. A log-based incremental refresh is performed on the materialized view and a partition change tracking based refresh is performed on the materialized view. The dependency of the materialized view log for the partition change track base table is removed.
摘要翻译：一种用于在物化视图中更新分区更改跟踪表和非分区轨道表的方法和系统。在物化视图上执行基于日志的增量刷新，并在物化视图上执行基于分区更改跟踪的刷新。删除分区更改轨道基表的实例化视图日志的依赖关系。

7. 发明授权

US06694310B1 Data flow plan optimizer 有权
标题翻译：数据流计划优化器
公开(公告)号：US06694310B1
公开(公告)日：2004-02-17
申请号：US09489403
申请日：2000-01-21
申请人： Tsae-Feng Yu , Anil D'silva , Jay W. Davison
发明人： Tsae-Feng Yu , Anil D'silva , Jay W. Davison
IPC分类号： G06F1730
CPC分类号： G06F17/30569 , G06F17/30463 , Y10S707/954 , Y10S707/99932 , Y10S707/99934 , Y10S707/99942 , Y10S707/99943 , Y10S707/99944
摘要： An optimizer for a data transformation system. The optimizer optimizes data flow plans that describe how data is to be transformed from the form it has in a data source to the form required in a data destination. A data flow plan is made up of a sequence of transforms, and the optimized data flow plan is equivalent to the original data flow plan but has fewer transforms. One kind of optimization is read/write optimization, in which the data flow plan is modified so that operations of the original data flow plan are performed in the data source or destination. Another is merge optimization, in which a single merge transform specifies the operations specified in a plurality of the transforms of the original data flow plan. The operations specified in the merge transform can further be performed in parallel. The optimizer additionally reorders the transforms in the original data flow plan to increase the amount of optimization. Operation of the optimizer is transparent to the user of the data transformation system.
摘要翻译：数据转换系统的优化器。优化器优化数据流程图，描述如何将数据从数据源中的形式转换为数据目标中所需的形式。数据流程图由一系列变换组成，优化后的数据流程图等同于原始数据流程图，但转换次数较少。一种优化是读/写优化，其中数据流计划被修改，以便在数据源或目的地中执行原始数据流计划的操作。另一个是合并优化，其中单个合并变换指定在原始数据流计划的多个变换中指定的操作。合并变换中指定的操作可以进一步并行执行。优化器还对原始数据流计划中的变换进行重新排序，以增加优化的数量。优化器的操作对数据转换系统的用户是透明的。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式