What is the Teradata Database?
Teradata is a relational database management system (RDBMS) that is:
Teradata is an open system, running on a UNIX MP-RAS or Windows server platform.
Teradata is completely built on a parallel architecture..
There have plenty of reasons why customers like to choose Teradata .
Teradata supports more larger warehouse data than all competitors combined.
Teradata Database can scale from 100 gigabytes to over 100+ petabytes of data on a single system without losing any performance .This is called Scalability.
Provides a parallel-aware Optimizer that makes query tuning unnecessary to get a query to run.
Automatic and even data distribution eliminates complex indexing schemes or time-consuming reorganizations .
Teradata Database can handle the most concurrent users, who are often running multiple, complex queries.
Designed and built with parallelism.
Supports ad-hoc queries using SQL
Single point of control for the DBA (Teradata Manager).
Unconditional parallelism (parallel architecture)
Teradata provides the lowest total cost (TCO) of ownership
High availability of data because there is no single point of failure – fault tolerance is built.
Features of Teradata
Following are some of the features of Teradata −
Unlimited Parallelism − Teradata database system is based on Massively Parallel Processing (MPP) Architecture. MPP architecture divides the workload evenly across the entire system. Teradata system splits the task among its processes and runs them in parallel to ensure that the task is completed quickly.
Shared Nothing Architecture − Teradata’s architecture is called as Shared Nothing Architecture. Teradata Nodes, its Access Module Processors (AMPs) and the disks associated with AMPs work independently. They are not shared with others.
Linear Scalability − Teradata systems are highly scalable. They can scale up to 2048 Nodes. For example, you can double the capacity of the system by doubling the number of AMPs.
Connectivity − Teradata can connect to Channel-attached systems such as Mainframe or Network-attached systems.
<a href=”https://mindmajix.com/teradata-training”>TeraData Training online course</a> makes you an expert in using Teradata and learn all that is required to Control Database Space, Teradata DBC Dictionary Tables and DBSize.
Know More Info Click Here:: https://mindmajix.com/teradata-training