| Patent application number | Description | Published |
|---|
| 20090132536 | Dynamic control and regulation of critical database resources using a virtual memory table interface - A computer-implemented apparatus, method, and article of manufacture provide the ability to manage a plurality of database systems. A domain contains the database systems, and a database in one of the systems has segmented global memory partitions. A virtual monitor partition provides logon access to the segmented global memory partitions in a form of a virtual database. Open application programming interfaces (API) enable logon access to the virtual monitor partition to access data in the virtual database. A multi-system regulator manages the domain and utilizes the open APIs to access data in the virtual data base. | 05-21-2009 |
| 20090132602 | Virtual data maintenance - A computer-implemented apparatus, method, and article of manufacture manage a plurality of database systems and perform data maintenance tasks in a data warehouse system. A domain includes a plurality of database systems. A virtual regulator manages the domain, detects a request to invoke a data maintenance task on a first system in the domain, routes the data maintenance task, for execution, to a second system in the domain, and applies results from the data maintenance task (executed by the second system) to the first system. | 05-21-2009 |
| 20090132611 | Closed-loop system management method and process capable of managing workloads in a multi-system database environment - A computer-implemented apparatus, method, and article of manufacture provide the ability to manage a plurality of database systems. A domain contains a plurality of database systems. A system event monitor, on each of the database systems, monitors the database systems' system conditions and operating environment events within the domain. A multi-system regulator manages the domain, communicates with the system event monitor, and creates a dynamic event on one of the database systems based on the system conditions and operating environment events. The dynamic event causes an adjustment to a state of the database system. | 05-21-2009 |
| 20100115205 | SYSTEM, METHOD, AND COMPUTER-READABLE MEDIUM FOR SPOOL CACHE MANAGEMENT - A system, method, and computer-readable medium that facilitate efficient use of cache memory in a massively parallel processing system are provided. A residency time of a data block to be stored in cache memory or a disk drive is estimated. A metric is calculated for the data block as a function of the residency time. The metric may further be calculated as a function of the data block size. One or more data blocks stored in cache memory are evaluated by comparing a respective metric of the one or more data blocks with the metric of the data block to be stored. A determination is then made to either store the data block on the disk drive or flush the one or more data blocks from the cache memory and store the data block in the cache memory. In this manner, the cache memory may be more efficiently utilized by storing smaller data blocks with lesser residency times by flushing larger data blocks with significant residency times from the cache memory. The disclosed cache management mechanisms are effective for many workloads and are adaptable to various database usage scenarios without requiring detailed studies of the particular data demographics and workload. | 05-06-2010 |
| 20100153958 | SYSTEM, METHOD, AND COMPUTER-READABLE MEDIUM FOR APPLYING CONDITIONAL RESOURCE THROTTLES TO FACILITATE WORKLOAD MANAGEMENT IN A DATABASE SYSTEM - A system, method, and computer-readable medium that facilitate workload management in a computer system are provided. A workload's system resource consumption is adjusted against a target consumption level thereby facilitating maintenance of the consumption to the target consumption within an averaging interval by dynamically controlling workload concurrency levels. System resource consumption is compensated during periods of over or under-consumption by adjusting workload consumption to a larger averaging interval. Further, mechanisms for limiting, or banding, dynamic concurrency adjustments to disallow workload starvation or unconstrained usage at any time are provided. Disclosed mechanisms provide for category of work prioritization goals and subject-area resource division management goals, allow for unclaimed resources due to a lack of demand from one workload to be used by active workloads to yield full system utilization at all times, and provide for monitoring success in light of the potential relative effects of workload under-demand, and under/over-consumption management. | 06-17-2010 |
| 20100162251 | SYSTEM, METHOD, AND COMPUTER-READABLE MEDIUM FOR CLASSIFYING PROBLEM QUERIES TO REDUCE EXCEPTION PROCESSING - A system, method, and computer-readable medium that facilitate classification of database requests as problematic based on estimated processing characteristics of the request are provided. Estimated processing characteristics may include estimated skew including central processing unit skew and input/output operation skew, central processing unit duration per input/output operation, and estimated memory usage. The estimated processing characteristics are made on a request step basis. The request is classified as problematic responsive to determining one or more of the estimated characteristics of a request step exceed a corresponding threshold. In this manner, mechanisms for predicting bad query behavior are provided. Workload management of those requests may then be more successfully provided through workload throttles, filters, or even a more confident exception detection that correlates with the estimated bad behavior. | 06-24-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 |
| 20110055168 | SYSTEM, METHOD, AND COMPUTER-READABLE MEDIUM TO FACILITATE APPLICATION OF ARRIVAL RATE QUALIFICATIONS TO MISSED THROUGHPUT SERVER LEVEL GOALS - A system, method, and computer-readable medium that provide mechanisms for tracking the number of queries received for processing for a workload to facilitate arrival rate qualifications to Throughput Service Level Goals are provided. A number of queries counter associated with a particular workload is incremented each time a query assigned to the particular workload is received thereby tracking the arrival rate of workload queries. When a system performance condition comprising a non-compliant system performance level with respect to a Throughput Service Level Goal is identified, the number of queries counter is compared with the Throughput Service Level Goal. If the arrival rate of queries for the workload is greater than the Throughput Service Level Goal of the workload, actions associated with non-compliance of the Throughput Service Level Goal may then be performed. If the number of queries counter is less than or equal to the Throughput Service Level Goal, the preliminary identification of the missed Service Level Goal as a system performance condition event is dismissed or otherwise ignored. | 03-03-2011 |
