Teradata

Why Trust Techopedia

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.

Advertisements

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
Advertisements

Related Terms

Margaret Rouse
Technology Expert
Margaret Rouse
Technology Expert

Margaret is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages.