Summary
We need a brief description of what this is. What are they looking at?
Time to Market: System configured, tuned and producing results in 5 days.
Interoperability –Successfully integrated the environment, including: Datastage 8.5 Fix pack
1 & Cognos 8.4.
Reliability – Netezza DB has been issue free during the entire POC.
Portability – Migration of existing DB2 schema and table definitions required
minimal changes. Minimal tuning, optimization required.
Performance – with minimal tuning, dramatic improvements in query speed were
seen over the existing DB2 warehouse. Queries directly against the database ran in 35-50x
faster.
-Unmodified Cognos 8.4 queries ran 12x faster. (Cognos 10 and above optimized for netezza)
Data Load & Unload from DB2 to Netezza
DB2 load Netezza Load Performance Improvement
1.2b Row Fact Table 21,600 sec. 133 sec. 162x Performance Improvement
DB2 Unload Netezza Unload
1.2b Row Fact Table 10,800 sec. 253 sec. 42x Performance Improvement
Netezza vz. DB2 Query results
DB2 Netezza Performance Improvement
Query 1 4,800 sec 201 sec 24x Performance Improvement
Query 2 4,800 sec 142 sec 34x Performance Improvement
Query 3 300 sec 7 sec 44x Performance Improvement
Query 4 9,000 sec 300 sec 30x Performance Improvement
Query 5 9,000 sec 44 sec 206x Performance Improvement
Query 6 10 sec 4 sec 2.5x Performance Improvement
Query 7 38 sec 2 sec 16x Performance Improvement
Query 8 1281 sec 10 sec 128x Performance Improvement
Conclusions
The 5 day POC operated without issue
– Supports existing ETL / BI toolset
– Performance / Simplicity
– Low TCO
– Trusted vendor
– Proven 4th generation technology
– POC demonstrated:
• Rapid time to value: Installed in 24hrs, loading data and delivering value in 48hrs
• Simplicity of deployment. No SQL Changes for Cognos query deployment.
• Ease of administration