Teradata
| Teradata
|
|
|---|---|
|
|
| Basic data
|
|
| developer | Teradata |
| Publishing year | 1979 |
| Current version | 16.20 |
| operating system | Linux , Unix , Windows |
| category | Database management system |
| License | proprietary |
| German speaking | Yes |
| www.teradata.com | |
Teradata is both the name for a relational database management system ( RDBMS ) and the name of the company Teradata Ltd. developing this product. (Founded in 1979). Teradata has consistently held the top position in the Gartner Magic Quadrant for Data Warehouse Database Management Systems for more than eight years.
Database management system
Teradata is an ANSI SQL compliant database. The Teradata DBMS is addressed via standard interfaces such as ODBC or JDBC and programmed via SQL.
Technically, Teradata is designed as a massive parallel processing system that uses a shared nothing architecture . Since data, CPU and memory are in a fixed relationship to one another, it is linearly and predictably scalable . The scalability in all dimensions of the database workload , e.g. B. Data volume, number of users, complexity of queries, enables Teradata to be used as a data warehouse in many large-scale applications .
Teradata has been running on 64-bit Intel Linux platforms and Windows 2000 servers since Version 2 Release 6 . Before version V2R6, a 32-bit variant was available under its own operating system , NCR UNIX SVR4 MP-RAS, a variant of System V Unix that was developed by AT&T and NCR .
Almost all ETL and BI tool providers have cooperations and partnerships with Teradata and offer corresponding versions of their software.
company
The company was originally founded in 1979 as a result of a cooperation between Citibank and the California Institute of Technology. In 1991, NCR Corporation took over Teradata and used the hardware- based database system for its computer lines. Teradata spun off from NCR Corporation on October 1, 2007 and is now an independent, publicly traded company.
Teradata has been offering its DBMS as an appliance since the beginning, which contains hardware components that are optimally matched to one another for the typical workload of a data warehouse. For about two years now, Teradata has designed its offering to include several appliance variants and thus supports the various workload scenarios, e.g. B. in active warehousing, invoice. Teradata also enables a comparison to be made with the competition, which predominantly only highlights a partial aspect of data warehousing and offers a solution for this - mostly at reduced costs.
Large users of this technology come from the retail, telecommunications and banking / insurance sectors as well as from the manufacturing industry with large quantities and complex products (e.g. the automotive industry). High-performance databases are used in particular for large amounts of data that have to be efficiently processed and made available. The main competitors are other high-end manufacturers such as IBM with the RDBMS DB2 , Oracle with the RDBMS of the same name and the EXAdata appliance, and Exasol with the product of the same name.
As of December 31, 2016, the company had 10,093 employees worldwide and sales of $ 2.3 billion.
Web links
- Official website (English)
- Official website (German)
Individual evidence
- ↑ https://www.teradata.at/About-Us/Our-History
- ↑ sunysb.edu: The Teradata Scalability Story ( Memento of the original dated December 2, 2012 in the Internet Archive ) Info: The archive link was inserted automatically and has not yet been checked. Please check the original and archive link according to the instructions and then remove this notice.
- ↑ For 10-K: Annual Report for the Fiscal Year Ending December 31, 2016 of February 27, 2017 (en).
