| Patent application number | Description | Published |
|---|
| 20080275840 | SELECTIVE DATABASE STATISTICS RECOLLECTION - The subject mater herein relates to database management and, more particularly, to selective database statistics recollection. Various embodiments provide one or more of system, methods, and software that identify database column and index states when statistics become stale to a point where query execution plans against respective columns and indexes fail to be efficient. These and other embodiments provide a way to update column and index statistics only when the statistics are determined to be stale. As a result, adverse database performance as a result of needless updating of database statistics is mitigated. | 11-06-2008 |
| 20090063396 | TECHNIQUES FOR PARTITIONING INDEXES - Techniques for partitioning indexes are provided. A predefined data type associated with a column of a database table is acquired. Column value statistics for the column are acquired. The values are analyzed to produce multiple partitions for the values. Each partition includes each of the values and each partition includes multiple groupings of the values. Also, each grouping of a particular partition includes a subset or range of the values. Furthermore, each grouping of a partition includes a same distribution for the values as other groupings of that partition. Each partition represents a potential partitioning index for the column and its values. | 03-05-2009 |
| 20090083215 | SYSTEM, METHOD, AND COMPUTER-READABLE MEDIUM FOR AUTOMATED SELECTION OF SAMPLING USAGE IN A DATABASE SYSTEM - A system, method, and computer readable medium that automate the selection of sampling for statistics collection in a database system are provided. Various resource usage and savings evaluations may be made to determine if a column or index is a candidate for sampling during statistics recollections. If the column is successfully evaluated as a quality candidate for sampling using resource usage and savings evaluations, one or more statistics accuracy evaluations may be made to determine if inaccuracies introduced in the statistics by sampling are tolerable. If the column is successfully evaluated as a quality candidate for sampling using the statistics accuracy evaluations, the column may be designated for sampling during statistics recollections on the column. A column or index is thereby identified or eliminated for sampling and designated as such in an automated manner without manual designation or specification by a database management administrator. | 03-26-2009 |
| 20100145929 | ACCURATE AND TIMELY ENFORCEMENT OF SYSTEM RESOURCE ALLOCATION RULES - A computer-implemented method, apparatus and article of manufacture for optimizing a database query. A query execution plan for the database query is generated using estimated cost information; one or more steps of the query execution plan are executed to retrieve data from a database stored on the computer system. Actual cost information is generated for each of the executed steps, and the estimated cost information is re-calculated using the actual cost information. One or more resource allocation rules defined on one or more steps of the query execution plan are executed, based on the estimated cost information, wherein the resource allocation rules include one or more defined actions. The estimated cost information may be re-calculated using the actual cost information when confidence in the estimated cost information is low, but the estimated cost information may not be re-calculated when confidence in the estimated cost information is high. In addition, the estimated cost information may be re-calculated using the actual cost information, only when the step has one or more resource allocation rules defined thereon. | 06-10-2010 |
| 20100153431 | ALERT TRIGGERED STATISTICS COLLECTIONS - In an example embodiment, a method is illustrated as including defining a rule for executing a structured query language (SQL) statement, the rule including a resource threshold. A violation of the rule may be detected during an execution of the SQL statement. Further, SQL execution data is logged in a log table as a result of the rule being violated, the SQL execution data including a statistics collection recommendation. An estimated cost of gathering statistics indicated by the statistics collection recommendation is compared to an estimated resource savings and a data dictionary storing statistics on data objects associated with the SQL statement is updated as a function of the comparing. | 06-17-2010 |
| 20110010359 | SYSTEM, METHOD, AND COMPUTER-READABLE MEDIUM FOR ENHANCING QUERY EXECUTION BY AN OPTIMIZER IN A DATABASE SYSTEM - A system, method, and computer-readable medium that provide automatic and dynamic control of optimizer settings in a large complex system environment are provided. The optimizer may pursue more aggressive query execution plans and switch to a more conservative approach in cases of actual observed inaccuracies. | 01-13-2011 |
| 20110010361 | SYSTEM, METHOD, AND COMPUTER-READABLE MEDIUM FOR CONTROLLING OPTIMIZER ROBUSTNESS AND ACHIEVING SERVICE LEVEL GOALS IN A DATABASE SYSTEM - A system, method, and computer-readable medium for automatic and dynamic control of optimizer settings in a large complex system environment are provided. The described mechanisms significantly increase the potential of achieving Service Level Goals for classes of queries where optimizer aggression is needed. Confidence threshold parameters are automatically controlled to facilitate generation of query execution plans to conform with associated Service Level Goals. | 01-13-2011 |
| 20110055201 | SYSTEM, METHOD, AND COMPUTER-READABLE MEDIUM FOR AUTOMATIC INDEX CREATION TO IMPROVE THE PERFORMANCE OF FREQUENTLY EXECUTED QUERIES IN A DATABASE SYSTEM - A system, method, and computer-readable medium that facilitate the optimization of frequently executed queries via automated index creation are provided. Standard optimizer strategies for dynamic index creation are utilized with query frequency information taken from a system's request cache. The described mechanisms provide a process of determining what indexes would be beneficial to query performance based on decisions and information from the optimizer that is ultimately responsible for the choice of index usage. Further, the plan cache is utilized in a manner that provides reliable information about the historical and anticipated frequency of specific queries. | 03-03-2011 |
