ALERT

[LAST CHANCE] Data Layer: Modern Business, Defined

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

Techopedia Deals

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 thousands of others with our weekly newsletter

Resources
The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.