文档介绍：数据仓库技术架构及方案
SPDB Project Training
黄予辉
2008年12月13日
Agenda
• Teradata简介
•架构设计原理
•整体架构说明
• ETL架构说明
Teradata 公司概况
• Teradata Corporation – 2007年10月1日纽交所上市
> 企业级数据仓库全球领导者
• EDW/ADW 数据库技术
•分析型解决方案
•咨询服务
> 自1999年开始,连续9年被Gartner评为数据仓库第一名
•美国前10大上市软件公司
> S&P 500 标准普尔500成员
> 纽交所上市代码: “TDC”
> NYSE Arca Tech 100
•世界级的客户遍布全球
> 超过 850 个世界级客户
> 超过2000个安装系统
•全球员工超过5,500名
Teradata 市场份额
Teradata Top 10
• Leading industries
90% of Top 10 > Banking/Financial Services
Global Telco Firms > Government
> Insurance & Healthcare
> Manufacturing
70% of Top 10 > Retail
Global Airlines > munications
> Transportation Logistics
60% of the Top 10 > Travel
Transportation
• World class customer list
Logistic Firms
> More than 850 customers
> More than 2,000
50% of Top 10 installations
Global Retailers
• Global presence
40% of Top 10 > Over 100 countries
mercial
& Savings Banks
FORTUNE Global Rankings, July 2006
Teradata 驱动世界级企业的可持续发展
munications Financial Travel
Retail
Insurance
Manufacturing
AoyamaShoji
Teradata 数据仓库技术的领导者
软件硬件
Gartner Magic Quadrant for Data Warehouse Gartner Magic Quadrant for Data Warehouse
DBMS, 2006 DBMS Servers, 2006
Feinberg & Beyer (9/2006) Feinberg, Hardcastle, Butler, Dawson (8/25/2006)
The Magic Quadrant is copyrighted 9/12/06 by Gartner, Inc. and is reused with permission. The Magic Quadrant is a graphical representation of a marketplace at and for a specific time
period. It depicts Gartner's analysis of how certain vendors measure against criteria for that marketplace, as defined by Gartner. Gartner does not endorse any vendor, product or service
depicted in the Magic Quadrant, and does not advise technology users to select only those vendors placed in the "Leaders" quadrant. The Magic Quadrant is intended solely as a research
tool, and is not meant to be a specific guide to action. Gartner disclaims all warranties, express or implied, with respect to