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 |
20130085984 | MANAGING EXCESS CAPACITY OF DATABASE SYSTEMS IN A CAPACITY CONTROLLED COMPUTING ENVIRONMENT - Excess capacity available to a database system in a capacity controlled environment can be effectively managed. In particular, excess capacity that is not made available for normal operations of a database system can be used to manage errors, especially situations that may hinder expected performance of the database system. In addition, excess capacity can be used to optimize or further optimize database queries, especially those that meet a criterion (e.g., not fully optimize, not optimized as expected). | 04-04-2013 |
20130085986 | SYSTEM MAINTENANCE AND TUNING OF DATABASES BY USING EXCESS CAPACITY IN CAPACITY CONTROLLED ENVIRONMENT - Excess capacity available to a database system in a capacity controlled environment can be effectively managed for maintenance and/or tuning activities. In this context, excess capacity can be used as needed and/or on a temporary basis. Furthermore, maintenance and/or tuning activities can be performed without requiring the use of the configured or allotted capacity. As a result, these operations can be performed without adversely affecting other operations which may be deemed more critical by the users of databases. System maintenance and tuning (or fine tuning) of a database environment can, for example, include operations associated with “Physical Tuning,” and “Index Tuning”. Some exemplary operations include collecting Statistics, analyzing a database workload, sampling, analyzing an execution plan, creating indexes. | 04-04-2013 |
20130086129 | REGULATING CAPACITY AND MANAGING SERVICES OF COMPUTING ENVIRONMENTS AND SYSTEMS THAT INCLUDE A DATABASE - Capacity of a database system and/or a computing system that includes a database can be effectively changed from a current computing capacity to another computing capacity. This can be achieved by causing usage capacity of at least one of resource to be changed when the database is active. By way of example, capacity of a database system can be regulated by delaying the execution of the database work based on a target capacity. As a result, database work can take relatively longer to complete when the capacity of a database is effectively regulated to be below its full capacity. In effect, a portion of available capacity (excess capacity) can be made inaccessible to the database. However, excess capacity can be used to manage various services of the database in accordance with one or more service criteria (e.g., Service Level Goals or Agreements). | 04-04-2013 |
20130110773 | LEARNING CAPACITY BY USING EXCESS CAPACITY IN A CAPACITY CONTROLLED ENVIRONMENT | 05-02-2013 |
20140195567 | DATA STORAGE MANAGEMENT BY USING EXCESS CAPACITY IN A CAPACITY CONTROLLED ENVIRONMENT - Excess capacity (or excess resources) can be used in a capacity controlled environment to effectively manage data storage of a database. In this context, excess capacity can, for example, be controlled used as needed, as configured and/or on a temporary basis. Management of data storage in a database can, for example, include operations associated with moving or relocating data of the database. Relocation of data can, for example, be performed to relocate data deemed to be “hot” data to a location that can provide a faster access time in order to improve the overall efficiency of the database system. | 07-10-2014 |