Download (direct link):
Introduction to the Teradata RDBMS for UNIX A-17
How the Teradata RDBMS for UNIX Differs from the Teradata RDBMS for TOS
How the Teradata RDBMS for UNIX Differs from the Teradata DBS for TOS
Introduction to the Teradata RDBMS for UNIX
This glossary defines terms specific to the Teradata RDBMS for UNIX. It also defines some general-use computer terms critical to an understanding of the Teradata RDBMS, as well as some general-use terms whose definition has been enhanced for the Teradata RDBMS.
Words that are italicized in the explanations are themselves defined in the glossary. For your convenience, frequently misunderstood terms are flagged with “cf” (compare) citations to alert you to similar terms for comparison; parenthetical notes to similar or contrasting terms. All command or statement keywords, modifiers, and other reserved words are fully capitalized.
In alphabetizing entries in this glossary, a blank character sorts before any letter, and a dash character sorts after any letter.
ABORT In Teradata SQL, a statement that aborts a transaction in progress and backs out changes to the database only if the conditional expression associated with the abort statement is true.
Access Module Process (AMP) An instance (virtual processor) of database management data (tables, rows, indices) with their associated data manipulation processes and their data context (Transaction In Progress table, lock information, disk access information).
administrator A special user responsible for allocating resources to a community of users.
Administration Workstation The system console of an NCR System 5100M.
AMP See Access Module Process.
application program A host program that performs a particular function or set of functions that the user desires to perform.
AWS See Administration Workstation
backout The process by which database changes are reversed after an aborted transaction so that the database is restored the state prior to the transaction. Cf: ABORT, transaction.
batch Host application programs that run in a background mode where their execution is not under the direct moment-to-moment control of a user are said to run in batch. Batch programs or jobs are often run for an extensive period of time and may be part of a data
Introduction to the Teradata RDBMS for UNIX Glossary-1
processing operation that is routinely run every day, week, month, or year.
Basic Teradata Query (BTEQ) A host-resident application program that enables a user to execute a series of Teradata SQL requests in either batch or interactive mode. BTEQ can read from or write to host data sets and use more than one Teradata session.
block A collection of records, rows, or packets that is manipulated as a unit, typically for efficiency of execution.
BTEQ See Basic Teradata Query.
buffer A software area in main memory used for constructing and processing messages.
BYNET The dual interconnection network that allows high-speed communications between the nodes of an NCR System 5100M. Provides greater bandwidth than the Ynet, and point-to-point as well broadcast communications.
byte In Teradata SQL, a data type in which information is stored as a string of zero or more 8-bit elements without translation. Also, one such 8-bit element.
C Preprocessor A program that facilitates productive design, coding, and testing of user application programs written in C that interact with the Teradata RDBMS.
cache A high-speed buffer storage area that contains frequently accessed instructions and data. It is used to reduce access time.
Call-Level Interface (CLI) A set of entry points provided by Teradata to facilitate low-level communication between programs running on the host and the Teradata RDBMS. CLI is used by Teradata programs such as BTEQ, the COBOL Preprocessor (runtime environment), FastLoad, and host utility programs. CLI is available to customer-written application programs coded in any language that supports a call statement and separate compilation of source modules.
channel The hardware means by which a central processor is attached to peripheral units. The path by which data is transferred between a mainframe host and the Teradata RDBMS.
channel connection software A program on the server that provides a pathway for applications running on a channel-connected mainframe (host) to access the Teradata RDBMS. Cf: Gateway.
CICS The Customer Information Control System, an IBM program product that acts as a supervisory or “monitor” program for application programs that are optimized for real-time interaction with users to perform relatively constrained information processing
Introduction to the Teradata RDBMS for UNIX
tasks. CICS runs under control of the MVS operating system (there is also a DOS version of CICS) and communicates with a network of terminals. Application programs written for CICS must use only CICS system services and must obey a number of other constraints imposed by the CICS environment.