The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.

The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.

Patent No.:

US 11379267 B1

Date of Patent:

Jul. 05, 2022

Filed:

Mar. 25, 2021

Automatic resource allocation design for satisfying service level goals of mixed workload queries in a database system

Applicant:

Teradata Us, Inc, San Diego, CA (US);

Inventors:

Hoa Thu Tran, Escondido, CA (US);

Stephen A Brobst, Las Vegas, NV (US);

Douglas P Brown, Rancho Santa Fe, CA (US);

Frank Roderic Vandervort, Ramona, CA (US);

Assignee:

Teradata US, Inc., San Diego, CA (US);

Attorney:

Howard Speight

Primary Examiner:

Wing F Chan

Assistant Examiner:

Leon Y Tseng

Int. Cl.

CPC ...

G06F 9/50 (2006.01); G06F 16/25 (2019.01); G06F 9/48 (2006.01);

U.S. Cl.

CPC ...

G06F 9/5027 (2013.01); G06F 9/4881 (2013.01); G06F 16/25 (2019.01);

Abstract

A database system receives a query to be processed. The database system has resources. A user assigns the query to a tier of resource allocation priorities in a hierarchy of tiers. The tier has been designated as being automatically managed by the database system. The tier has a plurality of levels of priority for resource allocation (LPRAs). The database system decomposes the query into a first step and a set of subsequent steps. The first step has a beginning and each of the set of subsequent steps has a respective beginning. The database system assigns the first step to a first LPRA, wherein executing the query at the first LPRA is projected by the database system to satisfy a service level goal (SLG) within a on_schedule_range of the SLG. The database system determines during execution of the set of subsequent steps that the query is no longer projected to satisfy the SLG within the on_schedule_range of the SLG and, as a result, assigns one of the set of subsequent steps to a second LPRA different from the first LPRA, wherein executing the query at the second LPRA is projected by the database system to return execution of the query to within the on_schedule_range of the SLG.

Find Patent Forward Citations