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
Posted by:

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
Tweat cdn.techopedia.com
Techopedia on Twitter


'@Techopedia'
Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join 138,000+ IT pros on our weekly newsletter

Resources
Free Whitepaper – Bridging the IT Operations Application Owner Gap
Free Whitepaper – Bridging the IT Operations Application Owner Gap:
Conflicting organizational needs all too often create tension between functional silos. Application owners demand more and more resources.
Free 30 Day Trial – VMTurbo Operations Manager
Free 30 Day Trial – VMTurbo Operations Manager:
VMTurbo's flagship product, Operations Manager maintains your virtual and cloud environments in a healthy state. It manages homogeneous and...