Patent ID: 7668804
Filing Date: 2010-02-23
Classification: G06F,Y10S

Abstract:
1. A method for recommending statistical views comprising: identifying a workload to be handled by a database system, wherein said workload comprises at least one query that the database system is to handle; enumerating a set of at least one candidate statistical views (statviews) to be utilized when optimizing the workload; computing a benefit value of the each of the enumerated candidate statistical views relative to the entire workload; computing a cost value for each of the enumerated candidate statistical views, wherein the cost value reflects a cost of constructing and collecting statistics on the associated statistical view; for each of the enumerated candidate statistical views, when the computed cost value is greater than the computed benefit value, excluding that enumerated candidate statistical view from a determined set of candidate views; for each of the enumerated candidate statistical views, when the computed cost value is less than the computed benefit value, adding that enumerated candidate statistical view to the determined set of candidate views; and recommending the determined set of candidate views.