Teradata Us, Inc.

Teradota Us, Inc.

Teradat Us, Inc.

Anita Richards

Douglas Paul Brown

Bhashyam Ramesh

John Mark Morris

Louis Martin Burger

Todd A Walter

Thomas Patrick Julien

Stephen Andrew Brobst

Caroline Ballinger

Donald Raymond Pederson

Hoa Thu Tran

Jeffrey S Shelton

Bruce Wayne Britton

Debra Galeazzi

Richard Glick

Choung Kim

Thomas Greene

Arthur Clark

James Peter Colby, Jr

In a database system, at least one metric associated with resources in a database system used by multiple classes of requests is monitored, where a first of the multiple classes is associated with a lower priority than a second of the multiple classes. A throttle limit is calculated for requests of the first class, based on the monitored metric. The calculated throttle limit is used to determine scheduling of the request of the first class for execution.

Calculating a throttle limit for requests in a database system

A test system receives environment information of a target database system, where the environment information includes information relating to hardware and software components of the target database system, and one or more of: definitions of workloads in the target database system, and settings of a scheduler in the target database system. The test system emulates an environment of the target database system using the received environment information, and database software is executed in the emulated environment in the test system.

Emulating an environment of a target database system

A data store system may include a storage array comprising a plurality of storage devices configured to store data. The data store may further include a processor array comprising a plurality of processors. The processor array may be in communication with the storage array. The processor array may receive workloads to be performed on the data. The processor may further process the workloads at a processing resource usage level of processing resources that is less than maximum available processing resources. The processing resource usage level may be associated with completion of at least a predetermined number of received workloads in accordance with the level of performance that is less than a total number of received workloads. The processor may further process the workloads at the processing resource level in response to presence of predetermined operating conditions. A method and computer-readable medium may also be implemented.

Performance continuity management

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).

Regulating capacity and managing services of computing environments and systems that include a database

The claimed invention provides a method for managing response time in a database system. The method includes monitoring a plurality of events that impact on the operation of the database system, identifying at least one event that impacts on at least one of the performance and availability of the database, and initiating an action in response to the identified event.

Managing events in a computing environment

A system and method for managing one or more database systems, wherein the database systems perform database queries to retrieve data stored by the database systems. One or more regulators are used for managing the database systems, wherein the regulators monitor workload priority influenced data temperature in order to allocate resources for the systems. The data temperature is a measure of physical accesses to logical data, and the workload priority is used to further define data temperature, in order to optimize data storage placement and data access decisions.

Workload priority influenced data temperature

An optimization technique is provided that optimizes data access by mapping each table, or row and/or column in a table, to a particular query, depending on whether the data in said table, row or column is 'hot' or 'cold' data. In one aspect, the invention features a method for optimizing the access time of an SQL query to a database including data. The method includes receiving, for each query type, a data frequency access measure and associating each query type with a processing rule set, according to the received data frequency access measure.

Managing access to data in a multi-temperature database

A database system receives information relating to a job requested by a requestor, where the job includes a plurality of requests. Execution of the requests of the job is managed using the received information, where managing the requests includes adjusting one or more of priority settings and resource estimates for the requests.

Managing execution of multiple requests in a job using overall deadline for the job

A computer-implemented method, apparatus and article of manufacture for performing an automatic error recovery in a database system. Automatic error recovery is performed for a query execution plan, following errors, problems or failures that occur during execution, by automatically or manually deactivating and/or activating components, features or code paths, and then re-submitting the query execution plan for execution in the computer system.

Query execution plan revision for error recovery

Requests to be executed in the database system are received, where a plurality of the requests are provided in a queue for later execution. Priority indicators are calculated for assignment to corresponding ones of the plurality of requests in the queue, where the priority indicators are calculated based on delay times and predefined priority levels of the requests. The requests in the queue are executed in order according to the calculated priority indicators.

Calculating priority indicators for requests in a queue

A database system includes an optimizer to generate resource estimates regarding execution of a request in the database system, and a regulator to monitor execution of a request and to adjust a priority level of the request based on the monitored execution and based on the resource estimates provided by the optimizer. The regulator is executable to further feed back statistics regarding execution of the request to the optimizer to improve accuracy of resource estimates provided by the optimizer.

Database system having a regulator to provide feedback statistics to an optimizer

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.

Parallel, in-line, query capture database for real-time logging, monitoring and optimizer feedback

A filter receives a request to perform an operation in a database system, and the filter receives a resource estimate relating to the request from an optimizer. The filter determines whether the resource estimate exceeds an available resource of the database system, and if so, the filter rejects the request prior to execution of the request.

Rejecting a request in a database system

A method, computer program and database system are disclosed for guiding the development of workload group definition (WD) classifications for a database system having resources. WD classification information is provided where a workload group is a set of system requests having characteristics defined by a WD and a WD classification identifies one or more WDs with similar performance requirements. If WD classification is not acceptable, one or more of the following functions is performed until WD classification is acceptable: (a) splitting one or more WDs; and (b) merging two or more WDs.

Guiding the development of workload group definition classifications

A computer running a database system receives a query. The database system services a plurality of collections. Each collection includes a plurality of workload groups. Each collection is assigned a percentage of a resource for its use. A donor collection, C, is not using its assigned percentage of the resource during a time slice tJ. The length in time of time slice tJ is less than a time in which the query is expected to execute. The query is assigned to a workload group. The assignment is determined by the computer applying a workload classification and an exception criteria to parameters of the query. The workload group is part of a donee collection, C, different from the donor collection. The donor collection donates, through the computer, use of a boost percentage of the resource to the donee collection during the time slice tJ. The boost percentage is proportional to the percentage of the resource assigned to the donee collection, the percentage of the resource assigned to the donor collection, and a Greediness Value related to the amount of the donor collection's allocated percentage of the resource available to be donated. The query is executed by the computer during time slice tJ, with the donee collection using its allocated percentage of the resource plus the boost percentage of the resource to execute the query.

Growing community of inventors

San Juan Capistrano, CA, United States of America

Anita Richards