Teradata is one of the popular Relational Database Management System. It is mainly suitable for building large scale data warehousing applications.When we have a large-scale data warehousing application Teradata is perfect selection. Teradata is Relational Database Management System (RDBMS). It is an open system. And it is also perfect for parallelism concept. Teradata can run on Windows, Linux and Unix server platform. Teradata have the feature to support multiple data warehouse operations at the same time to different clients.
Teradata is developed by American IT firm whose name is Teradata corporation. It deal with analytic data platforms, applications, and other related services. Below are the characteristics of Teradata:-
(a)Teradata is a single
(b)Teradata is built on parallelism
(c)Teradata is open system.
(d)Teradata has multi node running capabilities
(e)Teradata acts as same as server does.
(f)Teradata is compatible with the ANSI(American National Standards Institute)
Teradata achieves this by the concept of parallelism. It is developed by the company called Teradata.
Below are few features of Teradata :
- SQL − Teradata supports industry standard SQL to interact with the data stored in tables. In addition to this, it provides its own extension.
- Robust Utilities − Teradata provides robust utilities to import/export data from/to Teradata system such as FastLoad, MultiLoad, FastExport and TPT.
- 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.
- 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.
- Mature Optimizer − Teradata optimizer is one of the matured optimizer in the market. It has been designed to be parallel since its beginning. It has been refined for each release.
- Automatic Distribution − Teradata automatically distributes the data evenly to the disks without any manual intervention.
