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!
Techwise Webinar Series
The Cloud Imperative - What, Why, When, And How
The Cloud Imperative - What, Why, When, And How:
Join veteran analysts Dr. Robin Bloor of The Bloor Group, and Mark Madsen of Third Nature, as they explain how today’s cutting edge Cloud solutions can deliver enterprise caliber software like never before.

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...