LevSelector.com New York
home > Teradata

Teradata (page under construction - still you may find it very useful)
On This Page Other Pages

- intro
- data types
- data load utilities
- teradata api
- perl dbd teradata
- xx

- xx
- xx
- xx
- xx

Intro ------------------------------

- http://www.teradata.com - Teradata - database engine optimized for Datawarehousing (for reading, not for inserting). Used for huge data warehouses (Fortune 100 companies, for example, major arilines). Over 25 years of experience implementing over 1,900 data warehouses worldwide.

Examples of clients: PayPal (migrated to Teradata form Oracle), Verizon Wireless (~50 mln clients), Wachovia Bank, Delta Airlines (consolidated 27 data-marts into one data-warehouse), American Red Cross, CVS/ Pharmacy, United States Airforce.

90% of the Top Global Telecommunications Companies
50% of the Top Global Retailers
70% of the Top Global Airlines
60% of the Top Global Transportation Logistics Companies
40% of the Top Global Commercial and Savings Banks

Teradata was spun-off from NCR in 2007 (NCR = National Cash Register: http://www.ncr.com).

http://www.info.teradata.com/ - documentation.

Basically it is a SQL database specifically enginnered for building big datawarehouses. Uses parrallel processing for everything. It can scale in all dimensions almost infinitely. Can run on Unix and Windows servers.

Data Types:

Data Load Utilities


Teradata API

Teradata provides a number of standardized interfaces: http://www.teradata.com/t/page/44083/index/html

Access from Perl


use DBI;
$dbh = DBI->connect('dbi:Teradata:hostname', 'user', 'password');
... (standard DBI syntax)