the ibm netezza datawarehouse appliance
DESCRIPTION
Dai Clegg, Director of Product Marketing i Netezza - The IBM Netezza datawarehouse appliance. Se mere på: http://www.smarterbusiness.dkTRANSCRIPT
![Page 1: The IBM Netezza datawarehouse appliance](https://reader033.vdocuments.us/reader033/viewer/2022061113/545c96e5b1af9f320a8b4800/html5/thumbnails/1.jpg)
Turn Information into InsightsThe IBM Netezza datawarehouse appliance
- simplicity with maximum performance.
dai clegg
![Page 2: The IBM Netezza datawarehouse appliance](https://reader033.vdocuments.us/reader033/viewer/2022061113/545c96e5b1af9f320a8b4800/html5/thumbnails/2.jpg)
The IBM Netezza Appliance: Revolutionizing Analytics
Purpose-built analytics engine Integrated database, server & storage Standard interfaces Low total cost of ownership
Speed: 10-100x faster than traditional systems Simplicity: Minimal administration Scalability: Peta-scale user data capacity Smart: High-performance advanced analytics
![Page 3: The IBM Netezza datawarehouse appliance](https://reader033.vdocuments.us/reader033/viewer/2022061113/545c96e5b1af9f320a8b4800/html5/thumbnails/3.jpg)
Data Integration
Data In
The Netezza Appliance – Loading
IBM Information Server
Ab Initio
Business Objects/SAP
Composite Software
Expressor Software
GoldenGate Software (Oracle)
Informatica
Sunopsis (Oracle)
WisdomForce
SQ
L
OD
BC
JD
BC
O
LE-D
B
![Page 4: The IBM Netezza datawarehouse appliance](https://reader033.vdocuments.us/reader033/viewer/2022061113/545c96e5b1af9f320a8b4800/html5/thumbnails/4.jpg)
The Netezza Appliance – Querying
Reporting & AnalysisCognos (IBM)SPSS (IBM)Unica (IBM)ActuateBusiness Objects/SAPInformation BuildersKalidoKXENMicroStrategyOracle OBIEEQlikTechQuest SoftwareSAS
SQ
L
OD
BC
JD
BC
O
LE-D
B
Data Out
![Page 5: The IBM Netezza datawarehouse appliance](https://reader033.vdocuments.us/reader033/viewer/2022061113/545c96e5b1af9f320a8b4800/html5/thumbnails/5.jpg)
Page 5
Digital Media
Financial Services
Government
Health & Life Sciences
Retail / Consumer Products
Telecom
Other
![Page 6: The IBM Netezza datawarehouse appliance](https://reader033.vdocuments.us/reader033/viewer/2022061113/545c96e5b1af9f320a8b4800/html5/thumbnails/6.jpg)
“…when something took 24 hours I could only do so much with it, but when something takes 10 seconds, I may be able to completely rethink the business process…”
- SVP Application Development, Nielsen
15,000 users running 800,000+ queries per day 50X faster than before
Source: http://www.youtube.com/watch?v=yOwnX14nLrE&feature=player_embedded
Speed
![Page 7: The IBM Netezza datawarehouse appliance](https://reader033.vdocuments.us/reader033/viewer/2022061113/545c96e5b1af9f320a8b4800/html5/thumbnails/7.jpg)
DAYS
WEEKS
MONTHS
“Allowing the business users access to the Netezza box was what sold it.”
Steve Taff, Executive Dir. of IT Services
200X faster than Oracle systemROI in less than 3 months
Up and running 6 months before having any training
Simplicity
![Page 8: The IBM Netezza datawarehouse appliance](https://reader033.vdocuments.us/reader033/viewer/2022061113/545c96e5b1af9f320a8b4800/html5/thumbnails/8.jpg)
“NYSE … has replaced an Oracle 10 relational database with a data warehousing appliance from Netezza, allowing it to conduct rapid searches of 650 terabytes of data.”
ComputerWeekly.com
Source: http://www.computerweekly.com/Articles/2008/04/14/230265/NYSE-improves-data-management-with-datawarehousing.htm
1 PB on Netezza7 years of historical data100-200% annual data growth
Scalability
![Page 9: The IBM Netezza datawarehouse appliance](https://reader033.vdocuments.us/reader033/viewer/2022061113/545c96e5b1af9f320a8b4800/html5/thumbnails/9.jpg)
“Because of (Netezza’s) in-database technology, we believe we'll be able to do 600 predictive models per year (10X as many as before) with the same staff."
Eric Williams,
CIO and executive VP
Coupon redemption rates as high as 25%
Predicts what shoppers are likely to buy in future visits
Smart
![Page 10: The IBM Netezza datawarehouse appliance](https://reader033.vdocuments.us/reader033/viewer/2022061113/545c96e5b1af9f320a8b4800/html5/thumbnails/10.jpg)
IBM Netezza True Appliance Massively Parallel Processing™
High-PerformanceDatabase EngineStreaming joins,
aggregations, sorts
S-Blade
Processor &
streaming DB logic
S-Blade
Processor &
streaming DB logic
S-Blade
Processor &
streaming DB logic
S-Blade
Processor &
streaming DB logic
Massively Parallel Intelligent Storage
1
2
3
960
ŸŸŸ
Network FabricSMP Host
DBOSFront End
High-Speed Loader/Unloader
SQL Compiler
Query Plan
Optimize
Admin
SQL
Snippets
SQL
Source Systems
Client
High Performance
Loader
3rd PartyApps
DBA CLI
ETL Server
SOLARIS
LINUX
HP-UX
AIX
WINDOWS
TRU64
Execution Engine
![Page 11: The IBM Netezza datawarehouse appliance](https://reader033.vdocuments.us/reader033/viewer/2022061113/545c96e5b1af9f320a8b4800/html5/thumbnails/11.jpg)
Our Secret Sauce
FPGA Core CPU Core
Uncompress Project Restrict,Visibility
Complex ∑Joins, Aggs, etc.
select DISTRICT,
PRODUCTGRP,
sum(NRX)
from MTHLY_RX_TERR_DATA
where MONTH = '20091201'
and MARKET = 509123
and SPECIALTY = 'GASTRO'
Slice of table
MTHLY_RX_TERR_DATA
(compressed)
Slice of table
MTHLY_RX_TERR_DATA
(compressed)where MONTH = '20091201'
and MARKET = 509123
and SPECIALTY = 'GASTRO'
where MONTH = '20091201'
and MARKET = 509123
and SPECIALTY = 'GASTRO'
sum(NRX)sum(NRX)select DISTRICT,
PRODUCTGRP,
sum(NRX)
select DISTRICT,
PRODUCTGRP,
sum(NRX)
![Page 12: The IBM Netezza datawarehouse appliance](https://reader033.vdocuments.us/reader033/viewer/2022061113/545c96e5b1af9f320a8b4800/html5/thumbnails/12.jpg)
IBM Netezza True Appliance Massively Parallel Processing™
High-PerformanceDatabase EngineStreaming joins,
aggregations, sorts
S-Blade
Processor &
streaming DB logic
S-Blade
Processor &
streaming DB logic
S-Blade
Processor &
streaming DB logic
S-Blade
Processor &
streaming DB logic
Massively Parallel Intelligent Storage
1
2
3
960
ŸŸŸ
Network FabricSMP Host
DBOSFront End
High-Speed Loader/Unloader
SQL Compiler
Query Plan
Optimize
Admin
Consolidate
Source Systems
Client
High Performance
Loader
3rd PartyApps
DBA CLI
ETL Server
SOLARIS
LINUX
HP-UX
AIX
WINDOWS
TRU64
Execution Engine
![Page 13: The IBM Netezza datawarehouse appliance](https://reader033.vdocuments.us/reader033/viewer/2022061113/545c96e5b1af9f320a8b4800/html5/thumbnails/13.jpg)
The IBM Netezza Appliance: Revolutionizing Analytics
Speed: 10-100x faster than traditional systems Simplicity: Minimal administration Scalability: Peta-scale user data capacity Smart: High-performance advanced analytics
Page 13
Digital Media
Financial Services
Government
Health & Life Sciences
Retail / Consumer Products
Telecom
Other