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

1. 发明申请

US20050235004A1 Using estimated cost to schedule an order for refreshing a set of materialized views (MVS) 有权
标题翻译：使用估计成本计划刷新一组物化视图（MVS）的顺序
公开(公告)号：US20050235004A1
公开(公告)日：2005-10-20
申请号：US11084331
申请日：2005-03-18
申请人： Nathaniel Folkert , Abhinav Gupta , Andrew Witkowski
发明人： Nathaniel Folkert , Abhinav Gupta , Andrew Witkowski
IPC分类号： G06F17/30
CPC分类号： G06F17/30383 , G06F17/30457
摘要： In an embodiment, estimated costs are used to pick the best refresh technique (e.g., method) for a given MV. In another embodiment, estimated costs are used to schedule the refresh of a set MVs in an order such that overall time to refresh is reduced, or in an order that uses the smallest overall time, for refreshing when compared to other alternative refresh schedules. In another embodiment, the estimated cost of refreshing each of a set of MVs is used to select the set of CPU resources to allocate to refreshing each MV. Based on the estimated costs, the allocation of CPU resources is chosen to be more optimal (e.g., use less CPU time) than other available sets of CPU resources. In an embodiment, when refreshing an MV, delayed index maintenance is chosen if a significant portion of the base table and/or the partitions of the table has changed.
摘要翻译：在一个实施例中，估计成本用于选择给定MV的最佳刷新技术（例如，方法）。在另一个实施例中，使用估计成本来按照这样的顺序调度设置的MV的刷新，使得当与其他备选刷新时间表相比时，总体刷新时间减少或以使用最小总体时间的顺序进行刷新。在另一个实施例中，使用一组MV中的每一个刷新的估计成本来选择要分配以刷新每个MV的CPU资源集合。基于估计的成本，CPU资源的分配被选择为比其他可用的CPU资源集合更优化（例如，使用更少的CPU时间）。在一个实施例中，当刷新MV时，如果基表的重要部分和/或表的分区已经改变，则选择延迟索引维护。

2. 发明申请

US20050234971A1 Using estimated cost to refresh a set of materialized views (MVS) 有权
标题翻译：使用估计成本刷新一组物化视图（MVS）
公开(公告)号：US20050234971A1
公开(公告)日：2005-10-20
申请号：US11084416
申请日：2005-03-18
申请人： Nathaniel Folkert , Abhinav Gupta , Andrew Witkowski
发明人： Nathaniel Folkert , Abhinav Gupta , Andrew Witkowski
IPC分类号： G06F17/30
CPC分类号： G06F17/30457 , G06F17/30383
摘要： In an embodiment, estimated costs are used to pick the best refresh technique (e.g., method) for a given MV. In another embodiment, estimated costs are used to schedule the refresh of a set MVs in an order such that overall time to refresh is reduced, or in an order that uses the smallest overall time, for refreshing when compared to other alternative refresh schedules. In another embodiment, the estimated cost of refreshing each of a set of MVs is used to select the set of CPU resources to allocate to refreshing each MV. Based on the estimated costs, the allocation of CPU resources is chosen to be more optimal (e.g., use less CPU time) than other available sets of CPU resources. In an embodiment, when refreshing an MV, delayed index maintenance is chosen if a significant portion of the base table and/or the partitions of the table has changed.
摘要翻译：在一个实施例中，估计成本用于选择给定MV的最佳刷新技术（例如，方法）。在另一个实施例中，使用估计成本来按照这样的顺序调度设置的MV的刷新，使得当与其他备选刷新时间表相比时，总体刷新时间减少或以使用最小总体时间的顺序进行刷新。在另一个实施例中，使用一组MV中的每一个刷新的估计成本来选择要分配以刷新每个MV的CPU资源集合。基于估计的成本，CPU资源的分配被选择为比其他可用的CPU资源集合更优化（例如，使用更少的CPU时间）。在一个实施例中，当刷新MV时，如果基表的重要部分和/或表的分区已经改变，则选择延迟索引维护。

3. 发明申请

US20050235003A1 Choosing whether to use a delayed index maintenance depending on the portion of the materialized view (MV) changed 有权
标题翻译：根据物化视图（MV）的部分更改是否使用延迟索引维护
公开(公告)号：US20050235003A1
公开(公告)日：2005-10-20
申请号：US11083804
申请日：2005-03-18
申请人： Nathaniel Folkert , Abhinav Gupta , Andrew Witkowski
发明人： Nathaniel Folkert , Abhinav Gupta , Andrew Witkowski
IPC分类号： G06F17/30
CPC分类号： G06F17/30336 , G06F17/30312
摘要： In an embodiment, estimated costs are used to pick the best refresh technique (e.g., method) for a given MV. In another embodiment, estimated costs are used to schedule the refresh of a set MVs in an order such that overall time to refresh is reduced, or in an order that uses the smallest overall time, for refreshing when compared to other alternative refresh schedules. In another embodiment, the estimated cost of refreshing each of a set of MVs is used to select the set of CPU resources to allocate to refreshing each MV. Based on the estimated costs, the allocation of CPU resources is chosen to be more optimal (e.g., use less CPU time) than other available sets of CPU resources. In an embodiment, when refreshing an MV, delayed index maintenance is chosen if a significant portion of the base table and/or the partitions of the table has changed.
摘要翻译：在一个实施例中，估计成本用于选择给定MV的最佳刷新技术（例如，方法）。在另一个实施例中，使用估计成本来按照这样的顺序调度设置的MV的刷新，使得当与其他备选刷新时间表相比时，总体刷新时间减少或以使用最小总体时间的顺序进行刷新。在另一个实施例中，使用一组MV中的每一个刷新的估计成本来选择要分配以刷新每个MV的CPU资源集合。基于估计的成本，CPU资源的分配被选择为比其他可用的CPU资源集合更优化（例如，使用更少的CPU时间）。在一个实施例中，当刷新MV时，如果基表的重要部分和/或表的分区已经改变，则选择延迟索引维护。

4. 发明申请

US20060047622A1 Using join dependencies for refresh 有权
公开(公告)号：US20060047622A1
公开(公告)日：2006-03-02
申请号：US11083830
申请日：2005-03-18
申请人： Nathaniel Folkert , Abhinav Gupta , Andrew Witkowski
发明人： Nathaniel Folkert , Abhinav Gupta , Andrew Witkowski
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30457 , G06F17/30451
摘要： In an embodiment, Partition Change Tracking (PCT) refresh is performed by using join dependencies on partitioning columns to derive and fill in identifiers of rows and/or partitions containing the rows in the refresh expressions. In an embodiment, the join dependencies that form the Materialized View's (MV's) query definition and the partitioning predicate of the table are used to automatically generate a statement which is run in order to derive and fill in identifiers of the rows and/or partitions that are being changed. The identifiers are then plugged into the refresh expression, and the refresh expression is run. Running the refresh expression causes the rows identified to be refreshed.

5. 发明申请

US20050234945A1 Allocating CPU resources for a particular refresh schedule 审中-公开
标题翻译：为特定的刷新计划分配CPU资源
公开(公告)号：US20050234945A1
公开(公告)日：2005-10-20
申请号：US11084174
申请日：2005-03-18
申请人： Nathaniel Folkert , Abhinav Gupta , Andrew Witkowski
发明人： Nathaniel Folkert , Abhinav Gupta , Andrew Witkowski
IPC分类号： G06F17/30
CPC分类号： G06F16/2393
摘要： In an embodiment, estimated costs are used to pick the best refresh technique (e.g., method) for a given MV. In another embodiment, estimated costs are used to schedule the refresh of a set MVs in an order such that overall time to refresh is reduced, or in an order that uses the smallest overall time, for refreshing when compared to other alternative refresh schedules. In another embodiment, the estimated cost of refreshing each of a set of MVs is used to select the set of CPU resources to allocate to refreshing each MV. Based on the estimated costs, the allocation of CPU resources is chosen to be more optimal (e.g., use less CPU time) than other available sets of CPU resources. In an embodiment, when refreshing an MV, delayed index maintenance is chosen if a significant portion of the base table and/or the partitions of the table has changed.
摘要翻译：在一个实施例中，估计成本用于选择给定MV的最佳刷新技术（例如，方法）。在另一个实施例中，使用估计成本来按照这样的顺序调度设置的MV的刷新，使得当与其他备选刷新时间表相比时，总体刷新时间减少或以使用最小总体时间的顺序进行刷新。在另一个实施例中，使用一组MV中的每一个刷新的估计成本来选择要分配以刷新每个MV的CPU资源集合。基于估计的成本，CPU资源的分配被选择为比其他可用的CPU资源集合更优化（例如，使用更少的CPU时间）。在一个实施例中，当刷新MV时，如果基表的重要部分和/或表的分区已经改变，则选择延迟索引维护。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式