TERADATA

What Does Teradata Mean?

Teradata is a fully scalable relational database management system produced by Teradata Corp. It is widely used to manage large data warehousing operations.The Teradata database system is based on off-the-shelf symmetric multiprocessing technology combined with communication networking, connecting symmetric multiprocessing systems to form large parallel processing systems.

Techopedia Explains Teradata

Teradata acts as a single data store that accepts a large number of concurrent request from multiple client applications. The major features of Teradata are:

• Parallelism along with load distribution shared among several users
• Execution of complex queries with a maximum of 256 joins
• Parallel efficiency
• Complete scalability

The components included in the Teradata database system to support data communication management are:

• Call level interface (CLI)
• WinCLI and open database connectivity (ODBC)
• Teradata Director Program (TDP)
• Micro TDP

The Teradata client software components include:

• Basic Teradata Query
• C
• CLI
• ODBC
• TDP
• Archive
• Query man
• FastLoad
• MultiLoad
• FastExport
• Open Teradata Backup
• Tpump
• Teradata Manager
• WinDDI

Teradata is a broadly used relational database management system (RDBMS), that can be identified for its special capabilities on being consistent data and transactions, extensive security features, outstanding in parallelism, upright in performance, strong and robust structure, higher convenience for scalability, ability to support SQL querying, etc. The major components are Storage Architecture, AMPs or Access Module Processors, Parsing Engine and a corresponding Message Parsing layer.

Features

• Unlimited Parallelism:?Teradata is based on MPP architecture (Massively Parallel Processing) which divides the workload evenly across the entire system. It splits the task among its processes and runs them parallelly and this reduces the pressure and task is completed real quick.
• Connectivity:?Teradata can connect to mainframe or network attached systems. It?supports SQL to interact?with data stored in the tables. Also, It provides its own extension.
• Mature Optimizer:?Teradata optimizer is very matured and works parallelly since the start.
• Linear Scalability:?Teradata systems are extremely scalable. They are scalable up to 2048 nodes. One can easily triple the capacity of the system by tripling the number of AMPs.
• Robust Utilities:?Teradata supports robust utilities to import/export data Eg: Fast Load, Multi-load, etc..
• Shared Nothing Architecture:?Teradata nodes, AMPs work independently without sharing. They work independently.
• Useful for any type of user:?It can be customized for any type of users like business users or application users. The SQL of Teradata can be customized for business needs and provides great features for business requirements.

#HUQUO #TERADATA