Teradata (page under construction - still you may find it very useful)
|On This Page||Other Pages|
- 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 Load Utilities
Teradata provides a number of standardized interfaces: http://www.teradata.com/t/page/44083/index/html
Access from Perl
$dbh = DBI->connect('dbi:Teradata:hostname', 'user', 'password');
... (standard DBI syntax)