by admin

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.

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:

  1. Parallelism along with load distribution shared among several users
  2. Execution of complex queries with a maximum of 256 joins
  3. Parallel efficiency
  4. Complete scalability

The components included in the Teradata database system to support data communication management are:

  1. Call level interface (CLI)
  2. WinCLI and open database connectivity (ODBC)
  3. Teradata Director Program (TDP)
  4. Micro TDP

The Teradata client software components include:

  1. Basic Teradata Query
  2. C
  3. CLI
  4. ODBC
  5. TDP
  6. Archive
  7. Query man
  8. FastLoad
  9. MultiLoad
  10. FastExport
  11. Open Teradata Backup
  12. Tpump
  13. Teradata Manager
  14. WinDDI