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

1. 发明授权

US07668804B1 Recommending statistical views using cost/benefit metrics 有权
标题翻译：使用成本/效益指标推荐统计视图
公开(公告)号：US07668804B1
公开(公告)日：2010-02-23
申请号：US12264878
申请日：2008-11-04
申请人： Amr El-Helw , Ihab Ilyas , Calisto P. Zuzarte
发明人： Amr El-Helw , Ihab Ilyas , Calisto P. Zuzarte
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30306 , G06F17/30554 , Y10S707/99932
摘要： A workload to be handled by a database system can be identified. The workload can include at least one query that the database system is to handle. A set of at least one candidate statistical views (statviews) to be utilized when optimizing the workload can be enumerated. A benefit value and a cost value of the each of the enumerated candidate statistical views relative to the entire workload can be computed. The cost value can reflect a cost of constructing and collecting statistics on the associated statistical view. A set of the candidate views most beneficial for handling the workload can be determined based upon the computed benefit values and computed cost values. A generalization phase that augments the candidate view set with higher value candidate views for consideration during the recommendation phase. The optimum subset of views from the determined set of candidate views can be recommended, which can cause them to be constructed and utilized by a database optimizer.
摘要翻译：可以识别由数据库系统处理的工作负载。工作负载可以包括数据库系统要处理的至少一个查询。可以列举在优化工作负载时要使用的一组至少一个候选统计视图（statviews）。可以计算相对于整个工作负荷的每个枚举的候选统计视图的利益值和成本值。成本值可以反映相关统计视图构建和收集统计数据的成本。可以基于计算的利益值和计算的成本值来确定对处理工作负载最有利的一组候选视图。推广阶段，在推荐阶段考虑，增加候选人视图，并提供更高价值的候选人视图。可以推荐来自确定的候选视图集合的最佳视图子集，这可以导致它们被数据库优化器构造和利用。

2. 发明授权

US08812481B2 Management of interesting database statistics 有权
标题翻译：有趣的数据库统计管理
公开(公告)号：US08812481B2
公开(公告)日：2014-08-19
申请号：US11777255
申请日：2007-07-12
申请人： Calisto Paul Zuzarte , Volker Gerhard Markl , Wing Yan Lau , Ihab Ilyas , Amr El-Helw
发明人： Calisto Paul Zuzarte , Volker Gerhard Markl , Wing Yan Lau , Ihab Ilyas , Amr El-Helw
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30463 , G06F17/30433 , G06F17/30442
摘要： A method, system, and computer program product for managing database statistics are provided. The method, system, and computer program product provide for receiving a query for optimizing, collecting statistics specific to the query prior to generating any access plans for executing the query, and generating an access plan for executing the query based on the collected statistics.
摘要翻译：提供了一种用于管理数据库统计的方法，系统和计算机程序产品。方法，系统和计算机程序产品提供用于在生成用于执行查询的任何访问计划之前接收优化，收集特定于查询的统计信息的查询，以及基于收集的统计信息生成用于执行查询的访问计划。

3. 发明申请

US20090018992A1 MANAGEMENT OF INTERESTING DATABASE STATISTICS 有权
标题翻译：有趣的数据统计管理
公开(公告)号：US20090018992A1
公开(公告)日：2009-01-15
申请号：US11777255
申请日：2007-07-12
申请人： Calisto Paul ZUZARTE , Volker Gerhard MARKL , Wing Yan LAU , Ihab ILYAS , Amr EL-HELW
发明人： Calisto Paul ZUZARTE , Volker Gerhard MARKL , Wing Yan LAU , Ihab ILYAS , Amr EL-HELW
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , G06F17/30433 , G06F17/30442
摘要： A method, system, and computer program product for managing database statistics are provided. The method, system, and computer program product provide for receiving a query for optimizing, collecting statistics specific to the query prior to generating any access plans for executing the query, and generating an access plan for executing the query based on the collected statistics.
摘要翻译：提供了一种用于管理数据库统计的方法，系统和计算机程序产品。方法，系统和计算机程序产品提供用于在生成用于执行查询的任何访问计划之前接收优化，收集特定于查询的统计信息的查询，以及基于收集的统计信息生成用于执行查询的访问计划。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式