in black and white
Main menu
Share a book About us Home
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics

Introduction to the Teradata® RDBMS for UNIX® Version 2 Release 2.1 - NCR

NCR Introduction to the Teradata® RDBMS for UNIX® Version 2 Release 2.1 - NCR, 1998. - 315 p.
Download (direct link): inntroduktionteradata1998.pdf
Previous << 1 .. 65 66 67 68 69 70 < 71 > 72 73 74 75 .. 76 >> Next

program A unit of software that performs a set of operations to satisfy the needs of users or other programs. A program consists of one or more modules.

protocol A set of rules that govern the communication between two or more entities, such as processors, programs, or systems, including the formats of messages that flow among the entities.

query A Teradata SQL statement, particularly a SELECT statement.

queue A list of requests to use system resources, such as processor time, memory, access to a peripheral device, or lock.

RAID Redundant Array of Inexpensive Disks. A technology using R specialized disk controllers and software to distribute data across a

set of multiple disk drives (arrays). The data is segmented across the different disks in the array, a method known as striping.

Introduction to the Teradata RDBMS for UNIX


RAID1 An implementation of RAID technology in which striped data is stored as identical (mirrored) copies on separate disk media, so the data is both striped and mirrored.

RAID5 An implementation of RAID technology in which data and parity segments are stored by means of striping across multiple disks. Failures in any one component can be compensated for by reconstructing the data from the parity information and the surviving data. RAID5 data is not mirrored and uses approximately 60 percent less disk storage than does RAID1 for the same amount of data.

RAM See random access memory.

random access memory A quality of a memory device that writes or reads data from the memory through direct locating, rather than locating through references to other data in the memory.

recovery See backout.

redundancy group A group of disks protected by the same parity scheme. The groups are tolerant of any single point disk failure.

relational A database management system in which complex data structures are represented as simple, two-dimensional tables consisting of columns and rows. Cf: hierarchical, inverted, network.

request In host software, a message sent from an application program to the Teradata RDBMS.

resource monitoring Performance monitoring features to help users gather performance data in real time that may help tune the system.

Resource Usage (ResUsage) data Resource usage and performance data that is stored in database tables for subsequent analysis, which may help to identify trends and help tune the system.

Resource Sampling Subsystem A PDE software component that provides the ability to gather resource statistics which may be presented to real-time resource monitoring or saved as ResUsage data or both.

response The result (success or failure) generated when the Teradata RDBMS processes a Teradata SQL statement.

restart The process by which online operation of the Teradata RDBMS resumes after a system error, such as a hardware failure, a software protocol failure, or loss and restoration of AC power.

restore A function provided by a host utility program that re-creates a database from archived dump tapes. Cf: dump.

result The information returned to the user to satisfy a request made of the Teradata RDBMS. Results may include a return code,


Introduction to the Teradata RDBMS for UNIX

activity count, error message, warning message, title information, and/or rows from a spool file.

ResUsage data See Resource Usage.

row In Teradata SQL, the fields, whether null or not, that represent one entry under each column in a table. The row is the smallest unit of information operated on by data manipulation statements. Cf: column, database, field, table.

SCSI See Small Computer Systems Interface.


secondary index In Teradata SQL, an index on a column or group of columns other than those used for the primary index. A secondary index stores of extra information ordered on the secondary index columns, which more rapidly locates information in the Teradata RDBMS.

separator A character or group of characters that separates words and special symbols in Teradata SQL. Blanks and comments are the most common separators.

session In client software, a logical connection between an application program on a host and the Teradata RDBMS that permits the application program to send one request to and receive one response from the Teradata RDBMS at a time.

Session Control A program that executes in a PE to manage user sessions with the Teradata RDBMS.

SLAN See System LAN.

Small Computer Systems Interface (SCSI) An input and output bus that provides a standard interface for peripheral devices.

spool file A file that holds the results of the processing of Teradata SQL statements until they can be examined by the user or application program.

SQLflagger The feature of the SQL parser that detects syntax legal for Teradata SQL but illegal for ANSI SQL and reports the discrepancy.

startup string One or more Teradata SQL statements that are executed automatically when a user performs a LOGON.
Previous << 1 .. 65 66 67 68 69 70 < 71 > 72 73 74 75 .. 76 >> Next