information extracted from Operational Data Stores (ODS).
• Based on enterprise-wide model • Can begin small but may grow large rapidly • Populated by extraction/loading data from operational systems • Responds to end-user “what if” queries • Can store detailed as well as summary data
2006 2007
2008
– Teradata Corp founded in Los Angeles, California – Development begins on a massively parallel computer – YNET technology is patented – Teradata markets the first database computer DBC/1012 – First system purchased by Wells Fargo Bank of California – First public offering of stock – Teradata and NCR partner on next generation of DBC. – NCR Corporation is acquired by AT&T; Teradata revenues at $280 million. – Teradata is merged into NCR. – AT&T spins off NCR Corp. with Teradata; Teradata Version 2 is released. – The Teradata Database becomes the industry leader in data warehousing. – The first 100+ Terabyte system is put into production. – Teradata V2R5 released 12/2002; major release including features such as PPI, roles and
业界的领导企业 (Gartner Magic Quadrant for Data Warehouse
Database Management Systems)
challengers
leaders
ability to execute
Teradata
Oracle IBM
Microsoft Sybase
Netezza
▪ 数据仓库行业的领导企业
– 全球40多个国家设有分支机构 – 客户覆盖全球各个行业的领导企业 – 2006年营业收入16亿
▪ 高性能处理技术
– 并行环境 – 速度和可扩展能力
Teradata – A Brief History
1979
1982 1984
1987 1989 1991 1992 1996 1997 2000 2002
quarter. – Teradata's first full year as new corporation; 2500/5550 systems are introduced.
Teradata在全球各个行业的成功案例
全球前10大 电信公司中的90%
全球前10大 航空公司中的70%
全球前10大 运输行业公司中的60%
Greenplum
MySQL
DATAllegro
Kognitio Sand Technology
niche players
visionaries
completeness of vision
As of September 2007
经典数据仓库体系架构
什么是数据仓库
▪ “A Data Warehouse is a subject-oriented, integrated, time-variant, nonvolatile collection of data in support of management’s decision making process”
▪ 年收入$60+亿 ▪ 全球员工33,000人 ▪ 美国财富500强厂商，纽约证券交易所上市公司
Teradata 公司介绍
▪ Teradata 公司 –2007年10月1日正式从NCR分拆
– 全球企业级数据仓库的领导企业
• 企业级数据仓库领导企业 • 数据分析解决方案 • 咨询服务
– 1999年来一直被Gartner定位在数据仓库领导者象限
profiles, multi-value compression, and more. – Teradata V2R6.2 is released; BYNET V3 is available with NCR 5450/5500 systems. – NCR and Teradata become two separate corporations. Teradata 12.0 is released in 4th
--W.H.Inmon, 1992, Building The Data Warehouse
▪ 四点特征
– 面向主题 – 集成的（一致性） – 时变性 – 不易失性（稳定性）
What is a Data Warehouse?
A Data Warehouse is a central, enterprise-wide database that contains
Teradata数据仓库
Dr. Zhang Jian Senior Technical Consultant TD China, Apr., 2009
公司介绍
NCR公司介绍
▪ 创建于1884年，120年历史 ▪ 包括三大部门
– 数据仓库事业部 / Teradata – 金融服务 / ATM – 零售服务 / POS
全球前10大 零售商中的50%
全球前10大 商业银行中的50%
▪ 领先行业
– 银行及财务公司 – 政府 – 保险行业 – 制造业 – 零售业 级的客户名单
– 接近900个客户 – 超过2000个系统安装
FORTUNE Global Rankings, July 2007