Teradata

From Free net encyclopedia

Image:Teradata NCR logo.jpg Teradata is a relational database management system initially created by the firm with the same name, founded in 1979. Teradata is part of the NCR Corporation which acquired the Teradata company on February 28, 1991. It is a massively parallel processing system running a shared nothing architecture. The main point with the Teradata DBMS is that it's linearly and predictably scalable in all dimensions of a database system workload (data volume, breadth, number of users, complexity of queries), explaining its popularity for enterprise data warehousing applications. Teradata is offered on Intel servers interconnected by the BYNET messaging fabric. Teradata systems are offered with either Engenio or EMC disk arrays for database storage.

Teradata offers a choice of several operating systems:

NCR UNIX SVR4 MP-RAS, a variant of System V UNIX from AT&T
Microsoft Windows 2000 and Windows Server 2003
SUSE Linux on 64-bit Intel servers has been pre-announced for 2006.

Teradata Enterprise Data Warehouses are often accessed via ODBC or JDBC by applications running on operating system such as Microsoft Windows or flavors of UNIX. The warehouse typically sources data from operational systems via a combination of batch and trickle loads.

The largest and most prominent customer of this DBMS is Wal-Mart, which runs its central inventory and other financial systems on Teradata. Wal-Mart's Teradata Data Warehouse is generally regarded by the DBS industry as being the largest data warehouse in the world. Other Teradata customers include companies like AT&T (formerly SBC), Dell, Continental Airlines, National Australia Bank, FedEx, Vodafone, Gap Inc, Safeway Inc and Kaiser Permanente.

Teradata's main competitors are other high-end solutions such as Oracle and IBM's DB2.

[edit]