Register now or log in to join your professional community.
Scalable - Highly parallel (AMP architecture) MPP system. Fault Tolerant with no single point of failure (HSN).
Super Workload management - (TASM) high concurrency (active user count). Very Secure ( Access model)
Maximum performance when data is distributed evenly across AMPs
•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 capable of supporting many concurrent users from various client platforms.•Teradata is compatible with industry standards (ANSI compliant).•Teradata is completely built on a parallel architecture.
Features:
Teradata supports more larger warehouse data than all competitors combined.
The Teradata Database is a relational database management system (RDBMS) that drives a company's data warehouse. TheTeradata Database is accessed using SQL (Structured Query Language), the industry standard access language for communicating with an RDBMS. The ability to manage largeamounts of data is accomplished using the concept of parallelism, wherein many individual processors perform smaller tasks concurrently to accomplish an operation against a largerepository of data. To date, only parallel architectures can handle databases of this size.
Teradata is basically a database used to drive OLAP,OLTP, Datawarehouse etc.It has a a built in parallel system. TPT(Teradata Parallel Trasnsport), MLOAD are some interactive utilities offered by Teradata which eases the loading of records into tables. In new version of Teradata (15.0), the JSON data also can be stored.
Some of the newly developed features of Teradata are:
Teradata is basically an RDMS which is used to drive the Datamart, Datawarehouse, OLAP, OLTP, as well as DSS Appliances of the company. Some of the primary characteristics of Teradata are given below.