NetezzaTwinFin

1. NetezzaTwinFin Keith Bodell, Account Executive - Federal Matt Campbell, Systems Engineer - Federal

2. Data Warehouse - Why Twin Fin? • Simplicity and Cost-Effectiveness • Develop requirements • Design logical data model • Load data • GO • Performance and Scalability • AMPP architecture • Advanced analytics platform • Petabyte+ capacity • Linear scalability

3. “Classical” Data Warehouse Creation Tasks Requirements Definition Logical Data Model Design Physical Database Design Access paths/Indices Physical data placement Cache strategies Latency requirements Aggregations Reporting vs. Analytics Installation and Configuration Ensure OS, DBMS, Clustering, and Disk Management compatibility Database definition (SQL DDL) Load Tuning

4. “Classical” Data Warehouse – New Application Define requirements Re-consider: Access paths/Indices Physical data placement Cache strategies Latency requirements Aggregations Reporting vs. Analytics Examine cost, effort, and performance impact on existing applications Accept or reject, If accepted: Evaluate current environment – any upgrades required? Installation/Configuration Operating systems, DB, Clustering, Disk management compatibility Database definition (SQL DDL) Load Tuning

5. Netezza Data Warehouse Creation Tasks Requirements Definition Logical Data Model Design Physical Database Design – Make decisions regarding: Access paths/Indices Physical data placement Cache strategies Latency requirements Aggregations Reporting vs. Analytics Installation/Configuration Ensure Operating system, DB, Clustering, Disk management compatibility Database definition (SQL DDL) Load Tuning

6. Netezza Data Warehouse – New Application Define requirements Confirm Logical Data Model Re-consider Access paths/Indices Physical data placement Cache strategies Latency requirements Aggregations Reporting vs. Analytics Examine cost, effort, and performance impact on existing applications Accept or reject, If accepted: Evaluate current environment – any upgrades required? Installation/Configuration Operating systems, DB, Clustering, Disk management compatibility Database definition (SQL DDL) Load Tuning

7. Netezza Data Warehouse – Simplicity • “Netezza’s performance and ease of use allow us to provide our business users with a comprehensive view of the business when they need it, while allowing us to realize substantial cost savings.” • Executive Vice President of Sales, Marketing, Service &IT, BlueCross BlueShield of Massachusetts • “The [Netezza] system was also two-thirds the cost of our previous customer data warehouse, including ongoing support and maintenance.” • Director, Data Management and Data Warehousing Services, Ahold

8. Netezza Data Warehouse – Performance

9. The Netezza TwinFin™ Appliance Slice of User Data Swap and Mirror partitions High speed data streaming Disk Enclosures SQL Compiler Query Plan Optimize Admin SMP Hosts Snippet Blades™ (S-Blades™) Processor & streaming DB logic High-performance database engine streaming joins, aggregations, sorts, etc.

10. The Netezza AMPP™ Architecture Advanced Analytics FPGA CPU Memory Host Hosts BI FPGA CPU Memory ETL FPGA CPU Loader Memory Disk Enclosures Network Fabric Applications S-Blades™ Netezza Appliance

11. CPAG Architecture USERS GWA EDW DATA SOURCES NSF/DHS Netezza OTHER AGENCIES SUB-CONTRACTORS

12. Data Stream Processing FPGA Core CPU Core Restrict Visibility Complex ∑ Joins, Aggs, etc. Uncompress Project

13. Netezza Data Warehouse – Performance • “Gleaning valuable information from a two billion-row database…formerly took hours; with the Netezza system, the process takes just minutes.” • Vice President of Information Technology, Premier, Inc. • “Senior management teams used to make decisions based upon data that was eight weeks old…now they have the same report daily.” • Manager of Data Control, Orange • “The Netezza architecture is the simplest parallel computer we have ever used…Certainly, the achieved speedup is significant, and enables computations that were not previously possible.” • Sandia National Laboratories

14. Thank you