Introduction to Teradata Database

Introduction to Teradata Database


The Teradata Database is a relational database management system (RDBMS) that drives a company’s data warehouse. The Teradata Database provides the foundation to give a company the power to grow, to compete in today’s dynamic marketplace, and to evolve the business by getting answers to a new generation of questions. The Teradata Database’s scalability allows the system to grow as the business grows, from gigabytes to terabytes and beyond. The Teradata Database’s unique technology has been proven at customer sites across industries and around the world.

The Teradata Database is an open system, compliant with industry ANSI standards. It runs on these industry standard operating systems, Microsoft Windows Enterprise Server, and Novell SUSE Linux. For this reason, Teradata is considered an open architecture.

Note: Some customers may still be running on MP-RAS UNIX but that operating system is no longer supported as of Teradata 13.10.

The Teradata Database is a large database server that accommodates multiple client applications making inquiries against it concurrently. Various client platforms access the database through a TCP-IP connection or across an IBM mainframe channel connection. The Teradata Database is accessed using SQL (Structured Query Language), the industry standard access language for communicating with an RDBMS. The ability to manage large amounts of data is accomplished using the concept of parallelism, wherein many individual processors perform smaller tasks concurrently to accomplish an operation against a large repository of data. To date, only parallel architectures can handle databases of this size.


A defined object that may contain other database objects, such as tables, views, macros, triggers and stored procedures.


A Relational Database Management System (RDBMS) is a system that supports a relational data structure, including commands to manipulate the data tables.


Ability to grow the system along multiple dimensions (data, users, number of concurrent queries, complexity of queries) without experiencing performance degradation.

Microsoft Windows Enterprise Server

Microsoft Windows Enterprise Server is one of the operating system platforms that the Teradata Database runs on.

Novel SuSE Linux

Novel SuSE Linux is one of the operating system platforms that the Teradata Database runs on.


UNIX MP-RAS is one of the operating system platforms that the Teradata Database runs on. It includes enhancements to the UNIX MP kernel to make it more Reliable, Available, and Serviceable (RAS).


client - architecture

client – architecture

Users can access data in the Teradata Database through an application on both channel-attached and network-attached clients. Clients are platforms, such as a personal computer, server or mainframe system. Additionally, the node itself can act as a client. Teradata client software is installed on each client (channel-attached, network-attached, or node) and communicates with RDBMS software on the node. You may hear either type of client referred to by the term “host,” though this term is not typically used in documentation or product literature.



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s