1.

What are the newly developed features of Teradata?

Answer»

Teradata offers the following features:  

  • Unlimited Parallelism: Teradata is based on Massive Parallel Processing (MPP), which allows it to divide large tasks (related to data processing) into smaller tasks and run them in parallel.   
  • Shared Nothing Architecture: As this database is BUILT on a shared-nothing architecture, the disks, Teradata nodes, and AMPs (Access Module Processors) are all independent and do not share resources with others, resulting in an optimized performance for the given task. 
  • Linear Scalability: Teradata Systems are linearly scalable and can HANDLE large volumes of data in the most efficient manner.   
  • Connectivity: Teradata is best in terms of connectivity as it can CONNECT with channel-attached systems, such as mainframes or networks. 
  • Mature Optimizer: Teradata offers a mature optimizer (which provides the most efficient method for retrieving the data required by a SQL query) that can handle up to 64 joins (combining data from different tables in a database) per SQL query.  
  • SQL (Structured Query Language): This standard language is supported by Teradata as a means of interacting with data stored in tables. It also offers its own extensions.  
  • Robust Utilities: As part of Teradata's robust UTILITY suite, Teradata provides utilities for importing and exporting data from/to Teradata systems such as Fastload, Fastexport, Multiload, and TPT (Teradata Parallel Transporter), and many more.    
  • Load & Unload utilities: Teradata features load & unload utilities, which allow users to move data into and out of the Teradata system. 
  • Automatic DISTRIBUTION: Teradata automatically distributes data evenly among the disks, requiring no manual intervention.  
  • Low TCO (Total cost of ownership): Due to its ease of setup, administration, and maintenance, it has a low TCO.  


Discussion

No Comment Found