Teradata
Teradata is a relational database management system ( RDBMS) that by the time of his independent company Teradata Ltd.. ( Founded in 1979 ) was developed. After the first years of successful work the NCR Teradata Corporation in 1991 and acquired the used hardware-based database system for its computer lines. Teradata has been split off as of October 1, 2007 by NCR Corporation and is now a separate, publicly traded company. In the Gartner Magic Quadrant for Data Warehouse Database Management Systems Teradata occupied for more than 8 years ago through the top position.
Teradata is a Massive Parallel Processing System, which uses a shared-nothing architecture. The most important aspect of the Teradata DBMS is that it is linear and predictable scalable, in all dimensions of database workloads (data volume, number of users, complexity of queries). This is also the reason why Teradata is used in many large-scale applications using a data warehouse.
Teradata has been running since the Version 2 Release 6 on 64bit Intel Linux platforms and on Microsoft Windows 2000 servers. Before release V2R6 was a 32- bit version under its own operating system, NCR UNIX SVR4 MP - RAS, a variant of System V UNIX, which was developed by AT & T and NCR available. The Teradata DBMS is accessed via standard interfaces such as ODBC or JDBC and programmed via SQL. Almost all ETL and BI tool vendors have collaborations and partnerships with Teradata and provide appropriate versions of their software.
Teradata offers its DBMS since the beginning as an appliance that contains optimally parked for the typical workload of a data warehouse hardware components. For about two years, Teradata has designed its services to several appliance variants and thus has the different workload scenarios, eg Active warehousing, bill. Likewise, Teradata provides so forth comparability with competitors, with the most turns out only one aspect of data warehousing and for a - how to resolve - usually reduced to costs.
Great users of this technology come from the area of trade, telecommunications and banking / insurance or the manufacturing industry with large numbers and complex products such as the automotive industry. Especially for large amounts of data that must be efficiently processed and made available, are high-performance databases in use. The main competitors are other high -end manufacturers such as IBM DB2 RDBMS with their HP with the HP Neoview Business Intelligence Appliance, Oracle, Netezza (IBM) and Exadata.