Teradata and It’s unique features

The Teradata database is a massively parallel processing system running a “shared nothing” architecture.

The origin of the name Teradata is ‘tera’ derived from Greek which means ‘trillion’.

It is the first commercial database to support a trillion bytes of data.

Unique features

–> Parallel architecture

The Teradata Database provides exceptional performance using parallelism to achieve a single answer faster than a non-parallel system. Parallelism uses multiple processors working together to accomplish a task quickly. makes Teradata Database faster than other relational systems.

–> Single datastore

The Teradata Database acts as a single data store, instead of replicating database for different purposes with the teradata database we can store the data once and use it for all applications. The Teradata database provides same connectivity for all systems.

• can be accessed by network-attached and channel-attached systems.
• supports the requirements of many diverse clients.–> Scalability

Scalability is nothing but we can add components to the system, the performance increase as linear. Scalability enables the system to grow to support more users/data/queries/complexity of queries without experiencing performance degradation.

–> capacity

includes:
• Scaling from Gigabytes to Terabytes of detailed data stored in billions of rows.
• Scaling to thousands of millions of instructions per second (MIPS) to process data.

–> fault tolerance
automatically detects and recovers from hardware failures.
–> data integrity
ensures that transactions either complete or rollback to a stable state if a fault occurs.

Leave a Reply

Your email address will not be published. Required fields are marked *