netezzatwinfin
Post on 20-Jan-2016
38 Views
Preview:
DESCRIPTION
TRANSCRIPT
Keith Bodell, Account Executive - Federal
Matt Campbell, Systems Engineer - Federal
NetezzaTwinFin
2009 | Confidential
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
2009 | Confidential
“Classical” Data Warehouse Creation Tasks
Requirements Definition
Logical Data Model Design
Physical Database DesignAccess paths/IndicesPhysical data placementCache strategiesLatency requirementsAggregationsReporting vs. Analytics
Installation and ConfigurationEnsure OS, DBMS, Clustering, and Disk Management compatibilityDatabase definition (SQL DDL)Load
Tuning
2009 | Confidential
“Classical” Data Warehouse – New ApplicationDefine requirements
Re-consider:Access paths/IndicesPhysical data placementCache strategiesLatency requirementsAggregationsReporting vs. Analytics
Examine cost, effort, and performance impact on existing applications
Accept or reject, If accepted:
Evaluate current environment – any upgrades required?
Installation/ConfigurationOperating systems, DB, Clustering, Disk management compatibilityDatabase definition (SQL DDL)Load
Tuning
2009 | Confidential
Netezza Data Warehouse Creation TasksRequirements Definition
Logical Data Model Design
Physical Database Design – Make decisions regarding:Access paths/IndicesPhysical data placementCache strategiesLatency requirementsAggregationsReporting vs. Analytics
Installation/ConfigurationEnsure Operating system, DB, Clustering, Disk management compatibilityDatabase definition (SQL DDL)Load
Tuning
2009 | Confidential
Netezza Data Warehouse – New ApplicationDefine requirements
Confirm Logical Data Model
Re-considerAccess paths/IndicesPhysical data placementCache strategiesLatency requirementsAggregationsReporting vs. Analytics
Examine cost, effort, and performance impact on existing applications
Accept or reject, If accepted:
Evaluate current environment – any upgrades required?
Installation/ConfigurationOperating systems, DB, Clustering, Disk management compatibilityDatabase definition (SQL DDL)Load
Tuning
2009 | Confidential
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
2009 | Confidential
Netezza Data Warehouse – Performance
2009 | Confidential
The Netezza TwinFin™ Appliance
Page 9
High-performance databaseengine streaming joins,
aggregations, sorts, etc.
SQL CompilerQuery PlanOptimizeAdmin
Processor &streaming DB logic
Slice of User DataSwap and Mirror partitionsHigh speed data streaming
SMP Hosts
Snippet Blades™
(S-Blades™)
Disk Enclosures
2009 | Confidential
The Netezza AMPP™ Architecture
Page 10
Advanced Analytics
Advanced Analytics
LoaderLoader
ETLETL
BIBI
Applications
FPGA
Memory
CPU
FPGA
Memory
CPU
FPGA
Memory
CPU
HostsHost
Disk Enclosures S-Blades™
NetworkFabric
Netezza Appliance
2009 | Confidential
CPAG Architecture
Page 11
NSF/DHS
Netezza
GWA EDW
OTHER AGENCIES
SUB-CONTRACTORS
DATASOURCES
USERS
2009 | Confidential
Data Stream Processing
Page 12
FPGA Core CPU Core
Uncompress ProjectRestrictVisibility
Complex ∑Joins, Aggs, etc.
2009 | Confidential
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
Thank you
top related