Teradata Us, Inc.

David Doyle Gilbreath

Michael G Coutts

Douglas Paul Brown

A database system analyzes a query to determine the resources required to execute the query by identifying the department that issued the query (the 'source department') and identifying query-recited tables and determining the department by which each of the query-recited tables is controlled (the “accessed departments”). The database system determines that the resources required to execute the query are controlled by more than one department: the source department and one or more accessed departments. For each accessed department, a cost of a first strategy involving a SQL rewrite and a cost of a second strategy not involving a SQL rewrite are determined by preparing a query execution plan, determining the cost of the resources, and considering whether data controlled by the accessed department is not accessible except to the accessed department. The first strategy is chosen for at least one of the accessed departments because the first-strategy cost is lower.

Departmental allocation of query processing

A query is received. It is determined that the query does not fit a profile for a run-the-business set of queries, where the profile for the run-the-business set of queries excludes queries that are not routine parts of running a business and that do not require priority processing. The query is executed with a dynamically-created compute capacity that is not part of a compute capacity used to run the run-the-business set of queries.

Growing community of inventors

Escondido, CA, United States of America

David Doyle Gilbreath