Glossary - Query Scheduler

Teradata Query Scheduler User Guide

Product
Query Scheduler
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2512
lifecycle
previous
Product Category
Teradata Tools and Utilities

A

account

The distinct account name portion of the system account strings, excluding the performance group designation. Accounts can be employed wherever a user object can be specified.

ANSI

American National Standards Institute. The private, non-profit organization responsible for approving US standards in many areas, including computers and communications.

API

Application Program Interface. An interface (calling conventions) by which an application program accesses an operating system and other services. An API is defined at source code level and provides a level of abstraction between the application and the kernel (or other privileged utilities) to ensure the portability of the code. A language and message format used by an application program to communicate with the operating system or some other control program such as a database management system (DBMS) or communications protocol.

An API can also provide an interface between a high level language and lower level utilities and services written without consideration for the calling conventions supported by compiled languages. In this case, the API may translate the parameter lists from one format to another and the interpret call-by-value and call-by-reference arguments in one or both directions.

ASCII

American Standard Code for Information Interchange. The basis of character sets used in almost all present-day computers.

C

CLIv2

Call-Level Interface version 2. The application used by Teradata DWM to connect to the Teradata Database.

CPU

Central Processing Unit. The part of a computer which controls all the other parts.

D

DBA

Database Administrator. Generally, a person responsible for the design and management of one or more databases and for the evaluation, selection and implementation of database management systems.

DDL

Data Definition Language. SQL statements used to define, revise, and remove database objects. They are used to manage and control access to schema objects in a database. See SQL Data Definition Language (B035‑1144) to learn more.

E

execution time frame

A period of time when Teradata DWM can execute scheduled requests that are waiting to run.

I

ID

Identifier or Identification.

inner join

In Teradata SQL, a join operation on two or more tables, according to a join condition, that returns the qualifying rows from each table.

J

join

In Teradata SQL, a join is a SELECT operation that allows columns and rows to be combined from two or more tables to produce a result. Join types restricted by DWM are inner join, outer join, merge join, product join, and all joins. For more information, see all joins, exclusion join, inner join, merge join, nested join, and RowId join.

M

merge join

In Teradata SQL, the type of join that occurs when the WHERE conditional of a SELECT statement causes the system first to sort the rows of two tables based on a join field (specified in the statement), then traverse the result while performing a merge/match process.

N

nested join

In Teradata SQL, this join occurs when the user specifies a field that is a unique primary index on one table and which is in itself an index (unique/non-unique primary or secondary) to the second table.

O

ODBC

Open Database Connectivity. An application that may be used by Teradata Tools and Utilities to establish a connection with a Teradata Database.

outer join

In Teradata SQL, an extension of an inner join operation. In addition to returning qualifying rows from tables joined according to a join condition (the inner join), an outer join returns non-matching rows from one or both of its tables. Multiple tables are joined two at a time.

P

product join

In Teradata SQL, the type of join that occurs when the WHERE conditional of a SELECT statement causes the Teradata Database system to compare all qualifying rows from one table to all qualifying rows from the other table. Because each row of one table is compared to each row of another table, this join can be costly in terms of system performance.

Note: Product joins without an overall WHERE constraint are considered unconstrained (Cartesian). If the tables to be joined are small, the effect of an unconstrained join on performance may be negligible, but if they are large, there may be a severe negative effect on system performance.

profiles

A profile is a set of parameters assigned to a user, group of users, or an account that determines what scheduling capabilities are available and how your Teradata Query Scheduler scheduled requests server handles their scheduled requests.

Q

query management

The primary function of Teradata DWM is to manage logons and queries. This feature examines logon and query requests before they are dispatched for execution within the Teradata Database, and may reject logons, and may reject or delay queries. It does this by comparing the objects referenced in the requests to the types of DBA-defined rules.

R

request

A message sent from an application program, such as Teradata DWM, to the Teradata Database. In the Teradata Query Scheduler schedule request environment, a request is the definition of the parameters and text associated with a schedule request.

results table/file

In the Schedule Request environment, a results table or file is a database table or a Windows file into which result data for a schedule request that is not self-contained are stored.

results file storage

A symbolic name to a root directory where scheduled requests results are stored. A file storage location is mapped to a Windows root directory where results are stored.

RowID join

In Teradata SQL, this join occurs when one of the join tables has a non-unique primary index constant, and another column of that table matches weakly with a non-unique secondary index column of the second table.

rule

Rules are the name given to the method used by Teradata DWM to define what requests are prohibited from being immediately executed on the Teradata Database. That is, the rules enforced by Teradata DWM provide the query management capabilities.

S

scheduled requests

The capability to store scripts of SQL requests and execute them at a scheduled later time.

SQL

Structured Query Language. An industry-standard language for creating, updating and, querying relational database management systems. SQL was developed by IBM in the 1970s. It is the de facto standard as well as being an ISO and ANSI standard. It is often embedded in general purpose programming languages. Programming language used to communicate with the Teradata Database.

T

TDWM

The database shared by Teradata Dynamic Workload Manager and Teradata Query Scheduler. Previously called the dbqrymgr database.

Teradata DWM

Teradata Dynamic Workload Manager. A Teradata tool used to create and manage rules that manage access to a Teradata Database for Release 13.0 and earlier.

Teradata GSS

Teradata Generic Security Services. An application level interface (API) to system security services. It provides a generic interface to services which may be provided by a variety of different security mechanisms. Vanilla GSS-API supports security contexts between two entities (known as “principals”).

Teradata QS

Teradata Query Scheduler. A Teradata tool used to schedule SQL requests.

Teradata Tools and Utilities

See TTU.

TTU

Teradata Tools and Utilities. A group of products designed to work with the Teradata Database.

U

UTF

Universal Transformation Format. A method for converting 16-bit Unicode® characters into 7- or 8-bit characters. UTF-7 converts to 7-bit ASCII for transmission over 7-bit mail systems, while UTF-8 converts Unicode® to 8-bit bytes.

W

workgroups

Workgroups represent collections of related scheduled request work for users, user groups, or accounts. Each workgroup is assigned a maximum number of requests that can be executing from that workgroup simultaneously thereby ensuring that requests for all workgroups get a fair share of their scheduled work done within the execution time frames.