Tech moves fast! Stay ahead of the curve with Techopedia!
Join nearly 200,000 subscribers who receive actionable tech insights from Techopedia.
Teradata
Last Updated: August 18, 2011
Definition - What does Teradata mean?
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.
Techopedia explains Teradata
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
