Teradata is a fully scalable relational database management system produced by Teradata Corp. It is widely used to manage 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 to form large parallel processing systems.
Teradata acts as a single data store that accepts a large number of concurrent request from multiple client applications. The major features of Teradata are:
- Parallelism along with load distribution shared among several users
- Execution of complex queries with a maximum of 256 joins
- Parallel efficiency
- Complete scalability
The components included in the Teradata database system to support data communication management are:
- Call level interface (CLI)
- WinCLI and open database connectivity (ODBC)
- Teradata Director Program (TDP)
- Micro TDP
The Teradata client software components include:
- Basic Teradata Query
- C
- CLI
- ODBC
- TDP
- Archive
- Query man
- FastLoad
- MultiLoad
- FastExport
- Open Teradata Backup
- Tpump
- Teradata Manager
- WinDDI
