|
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.
|