Patent application number | Description | Published |
20120071535 | ESTROGEN RECEPTOR MODULATORS AND USES THEREOF - Described herein are compounds that are estrogen receptor modulators. Also described are pharmaceutical compositions and medicaments that include the compounds described herein, as well as methods of using such estrogen receptor modulators, alone and in combination with other compounds, for treating diseases or conditions that are mediated or dependent upon estrogen receptors. | 03-22-2012 |
20130012561 | ESTROGEN RECEPTOR MODULATORS AND USES THEREOF - Described herein are compounds that are estrogen receptor modulators. Also described are pharmaceutical compositions and medicaments that include the compounds described herein, as well as methods of using such estrogen receptor modulators, alone and in combination with other compounds, for treating diseases or conditions that are mediated or dependent upon estrogen receptors. | 01-10-2013 |
20130116258 | ANDROGEN RECEPTOR MODULATORS AND USES THEREOF - Described herein are compounds that are androgen receptor modulators. Also described are pharmaceutical compositions and medicaments that include the compounds described herein, as well as methods of using such androgen receptor modulators, alone and in combination with other compounds, for treating diseases or conditions that are mediated or dependent upon androgen receptors. | 05-09-2013 |
20130231333 | ESTROGEN RECEPTOR MODULATORS AND USES THEREOF - Described herein are compounds that are estrogen receptor modulators. Also described are pharmaceutical compositions and medicaments that include the compounds described herein, as well methods of using such estrogen receptor modulators, alone and in combination with other compounds, for treating diseases or conditions that are mediated or dependent upon estrogen receptors. | 09-05-2013 |
20140364427 | ESTROGEN RECEPTOR MODULATORS AND USES THEREOF - Described herein are compounds that are estrogen receptor modulators. Also described are pharmaceutical compositions and medicaments that include the compounds described herein, as well as methods of using such estrogen receptor modulators, alone and in combination with other compounds, for treating diseases or conditions that are mediated or dependent upon estrogen receptors. | 12-11-2014 |
Patent application number | Description | Published |
20100125565 | Actively managing resource bottlenecks in a database system - A computer-implemented method, apparatus and article of manufacture for optimizing a database query. Resource usage of one or more resources of the computer system are monitored. A condition code representative of the monitored resource usage is stored. A cost model is modified using the stored condition code. A query execution plan is generated for the database query using the modified cost model. The query execution plan is then executed in order to retrieve data from a database stored on the computer system, wherein the retrieved data is presented to a user for subsequent use and analysis. | 05-20-2010 |
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 |
20100169302 | SYSTEM, METHOD, AND COMPUTER-READABLE MEDIUM FOR GROUPING DATABASE LEVEL OBJECT ACCESS COUNTS PER PROCESSING MODULE IN A PARALLEL PROCESSING SYSTEM - A system, method, and computer-readable medium for grouping of database object access counts per processing module in a parallel processing system are provided. Each processing module manages an intermediate cache allocated thereto that stores database object access counts local to the respective processing module. The processing modules are configured in a hierarchical configuration and processing modules at the lowest level of the configuration forward their respective intermediate cache to a processing module configured as a parent to the respective processing module. On receipt of intermediate cache(s) from lower level processing modules, a processing module merges the received intermediate caches with the intermediate cache allocated to the processing module. The process is iteratively repeated until a root processing module receives the intermediate caches from processing modules configured as child nodes thereto. The root processing module merges the received intermediate cache(s) with the root processing module's intermediate cache thereby generating a final cache. An objects access count data structure is then generated by the root processing module. The object access count data structure of the final cache includes data blocks of object access counts where each data block is associated with a particular access module processor (AMP). The data blocks may then be forwarded to the associated AMPs. | 07-01-2010 |
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 |
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 |
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 |
Patent application number | Description | Published |
20090327216 | Dynamic run-time optimization using automated system regulation for a parallel query optimizer - A computer-implemented apparatus, method, and article of manufacture for optimizing a database query. System conditions and operating environment events that occur during operation of the computer system are monitored. An n-dimensional optimizer matrix is used to identify at least one rule resulting from the monitored system conditions and operating environment events. An optimal query execution plan is selected from among a plurality of query execution plans generated for the query in response to the identified rule. | 12-31-2009 |
20090327242 | Parallel, in-line, query capture database for real-time logging, monitoring and opitmizer feedback - A computer-implemented method, apparatus and article of manufacture for optimizing a database query. A query execution plan is generated for the database query, which may be stored in an in-line query capture database. Execution of the query execution plan may be monitored in order to generate performance information, which also may be stored in the in-line query capture database. The data stored in in-line query capture database may be used during the initial generation of query execution plans, as well as for the re-optimization of a query execution plan, during the execution of the query execution plan. | 12-31-2009 |
20120059817 | METHOD FOR INCREASING THE EFFICIENCY OF SYNCHRONIZED SCANS THROUGH INTELLIGENT QUERY DISPATCHING - A computer-implemented method, apparatus and article of manufacture for optimizing execution of database queries in a computer system. In one embodiment, the steps and functions include: generating first and second query execution plans for first and second requests, wherein the first and second query execution plans are each comprised of one or more steps that scan a specified table in a database stored on the computer system in order to retrieve data from the table; and executing the first and second query execution plans, wherein intelligent query dispatching is performed on the steps of the first and second query execution plans to ensure that the steps share the data retrieved from the table and cached in memory. | 03-08-2012 |
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 |
20130212086 | ACTIVELY MANAGING RESOURCE BOTTLENECKS IN A DATABASE SYSTEM - A computer-implemented method, apparatus and article of manufacture for optimizing a database query. Resource usage of one or more resources of the computer system are monitored. A condition code representative of the monitored resource usage is stored. A cost model is modified using the stored condition code. A query execution plan is generated for the database query using the modified cost model. The query execution plan is then executed in order to retrieve data from a database stored on the computer system, wherein the retrieved data is presented to a user for subsequent use and analysis. | 08-15-2013 |