Download (direct link):
module A unit of software that typically performs one function or a set of closely related functions and is the smallest unit of software that can be replaced.
multitasking The ability to share the resources of a computer, operating system, or address space among several tasks, or “threads” of execution, where the state of each task is, in general, independent of the state of other tasks.
MVS See Multiple Virtual Storage.
Multiple Virtual Storage (MVS) One of the primary operating systems (or system control programs) for medium and large IBM computers. MVS offers multiprogramming for multiple users.
name In Teradata SQL, a word supplied by the user that refers to an object, such as a column, database, macro, table, user, or view.
network A method of organizing records in a Database Management System in which relationships between one record and another are represented by pointers. A pointer is a part of a record that gives the address, typically on disk, where the next related record resides. The database thus consists of a network of records and pointers. This organizational form is also known as a “plex” structure, a “navigational” database, or a CODASYL model database. Cf: hierarchical, inverted, relational.
Introduction to the Teradata RDBMS for UNIX
node A processor node consisting of one or more processors that share memory. Peripheral devices such as disk storage may be connected to a node. An interconnect between the nodes facilitates message communication between nodes. Network and channel connections provide for communication to clients and those between interconnected nodes.
null In Teradata SQL, the absence of a value for a field.
offline A state of a system or component in which it is logically O disconnected from its normal operating environment so that special
functions such as service, maintenance, and/or diagnostics can be performed on the component or system in isolation from the rest of the environment.
online Any state in which a system is available for users to enter ordinary requests, and in which all normal functions are provided.
operand Values, given by constants or variables, that an operator acts upon to produce a result.
operator In Teradata SQL, a symbol or keyword that specifies an operation performed on the values of the operands (if any).
owner In Teradata SQL, the user who has the ability to grant or revoke all access rights on a database to and from other users. By default, the creator of the database is the owner, but ownership can be transferred from one user to another by the GIVE statement.
packet In host software, the smallest unit of data sent on the channel P between the TDP and the channel connection software. A message
consists of one or more packets. A packet is a purely physical division of a message. Packets are distinct from parcels, which are logical subdivisions of a message.
Parallel Database Extensions (PDE) Message-based kernel service extensions to UNIX System V, Release 4, suitable for a parallel distributed-memory machine.The extensions include network services and message services, memory management services, and file system access services. These services provide parallelism and are available only to a TPA, that is, the Teradata RDBMS.
parallel processing Simultaneous or concurrent execution of two or more processes in a single functional unit.
parameter In Teradata SQL, a variable name in a macro for which an argument value is substituted when the macro is executed.
parcel In host software, a logical part of a message. A parcel contains the message information (Teradata SQL statements, result rows, failure codes, etc.).
Introduction to the Teradata RDBMS for UNIX
Parser A program executing in a PE that translates Teradata SQL statements entered by a user into the steps that accomplish the user’s intentions.
Parsing Engine (PE) An instance (virtual processor) of the database management Session Control, Parsing, and Dispatching processes and their data context (caches).
partition A logical connection of tasks and associated resources within a virtual processor that performs a related function.
PDE See Parallel Database Extensions.
PE See Parsing Engine.
PL/I Preprocessor A program that facilitates productive design, coding, and testing of user application programs written in PL/I that interact with the Teradata RDBMS.
Preprocessor See COBOL Preprocessor, C Preprocessor, PL/I Preprocessor.
primary index In Teradata SQL, an index that determines in which AMP (and the location in that AMP where) a row is stored. Access through the primary index is generally the most efficient means of locating a row.
primary key A unique identifier for a row.
privilege The right of a specified user to enter a specified RDBMS/SQL statement (such as CREATE, SELECT, GRANT, etc.) against a specified database, macro, table, user, or view.