Teradata is a fully scalable relational database management system produced by Teradata Corp. It manages large data warehousing operations. The Teradata database system is based on off-the-shelf symmetric multiprocessing technology combined with communication networking, connecting symmetric multiprocessing systems. This helps to form large parallel processing systems. Additionally, its hybrid multi-cloud architecture gives you the flexibility to deploy anywhere, including public clouds (AWS, Azure, Google Cloud) and on-premises
- Teradata database system is based on Massively Parallel Processing (MPP) Architecture. MPP architecture divides the workload evenly across the entire system.
- Its architecture is called as Shared Nothing Architecture. Teradata Nodes, its Access Module Processors (AMPs) and the disks associated with AMPs work independently. Also, they are not shared with others.
- Its systems are highly scalable. They can scale up to 2048 Nodes. As Teradata is linearly scalable, we can expand the database capacity by just adding more nodes to the existing database. If the data volume grows, we can add more hardware and expand the database capacity.
- Supports industry standard SQL to interact with the data stored in tables.
- Automatically distributes the data evenly to the disks without any manual intervention.
- Supports many important features which enhance the security of an enterprise data warehouse. These security features include User-level security controls, increased user authentication options, support for security roles, enterprise directory integration, network trafﬁc encryption and auditing and monitoring controls.