Teradata

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
Share this:

Tech moves fast! Stay ahead of the curve with Techopedia!

Join nearly 200,000 subscribers who receive actionable tech insights from Techopedia.