GENERATING STATISTICAL VIEWS IN A DATABASE SYSTEM
1 Assignment
0 Petitions
Accused Products
Abstract
Techniques are disclosed for generating statistical views in a database system. In one embodiment, a request is received to execute a database workload. One or more constraints pertaining to executing the database workload is retrieved. The database workload is evaluated to generate multiple statistical view candidates. The statistical view candidates are refined based on the one or more constraints. One or more statistical views are then generated based on the refined statistical view candidates.
68 Citations
20 Claims
-
1-7. -7. (canceled)
-
8. A computer program product, comprising:
a computer-readable storage medium having computer-readable program code embodied therewith, the computer-readable program code comprising; computer-readable program code configured to receive a request to execute a database workload; computer-readable program code configured to retrieve one or more constraints pertaining to executing the database workload; computer-readable program code configured to evaluate the database workload to generate a plurality of statistical view candidates; computer-readable program code configured to refine, by operation of one or more computer processors when executing the computer-readable program code, the statistical view candidates based on the retrieved one or more constraints, wherein refining comprises at least one of adding, deleting and updating at least one statistical view candidate; and computer-readable program code configured to generate one or more statistical views based on the refined statistical view candidates. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
15. A system, comprising:
-
one or more computer processors; a memory containing a program, which when executed by the one or more computer processors is configured to perform an operation comprising; receiving a request to execute a database workload; retrieving one or more constraints pertaining to executing the database workload; evaluating the database workload to generate a plurality of statistical view candidates; refining the statistical view candidates based on the retrieved one or more constraints, wherein refining comprises at least one of adding, deleting and updating at least one statistical view candidate; and generating one or more statistical views based on the refined statistical view candidates. - View Dependent Claims (16, 17, 18, 19, 20)
-
Specification