Teradata

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