Comparing SAP HANA to EMC Greenplum DCA,Agenda,Data Warehouse Characteristics What is HANA? What is DCA? Data Warehouse Selection Criteria,Data Warehouse Characteristics,Data Warehouses always GROW In size, number of users, importance, and usage Hard to predict growth patterns Data Warehouses Constantly Change As you add users, applications, more data Data Warehousing skills are critical to success Requires skilled people to work on the DBMS Myth that they are “just another database” Large data warehouse community is important for exchange of information and ideas between other customers Partnership with DBMS vendor is critical,Agenda,Data Warehouse Characteristics What is HANA? What is DCA? Data Warehouse Selection Criteria,HANAs Revolutionary Approach,Groundbreaking In-Memory Innovations,300 x FasterAnalytics,?,?,?,Real-Time Access to Transactional Data,SAP HANA In-Memory software + hardware(HP, IBM, Fujitsu, Cisco, Dell) Data Modeling and Data Management Real-time Data Replication SAP BusinessObjects Data Services for ETL capabilities from SAP Business Suite, SAP NetWeaver Business Warehouse (SAP NetWeaver BW), and 3rd Party Systems Capabilities Enabled Analyze information in real-time at unprecedented speeds on large volumes of non-aggregated data Create flexible analytic models based on real-time and historic business data Foundation for new category of applications (e.g., planning, simulation) to significantly outperform current applications in category Minimize data duplication,SAP In-Memory Appliance (SAP HANA),SAP HANA Proof Points,460B,Data records analyzed in less than a second,21%,Average increase in revenue,3600 x,Faster reporting speed,SAP HANA Customer Testimonials Highlighting Value and Benefits,SAP HANA Customer Testimonials Highlighting Value and Benefits,SAP HANA Customer Testimonials Highlighting Value and Benefits,”,HANA Revolutionized the Market,SAP HANA Customer Testimonials Highlighting Value and Benefits,SAP HANA: Architecture,SLT,SAP BusinesObjects Data Services 4.0,DB Triggers,Business Intelligence Clients and SAP HANA 1.0,ERP,SAP In-Memory Database,Real Time,DB,SAP BW,3rd Party,SAP BusinessObjects Data Services,SAP HANA (Appliance),SAP BusinessObjects BI 4.0,Semantic Layer,Crystal,WebI,Dashboards,Explorer,A Office,SQL(ODBC/JDBC),BICS,Microsoft Excel,MDX (ODBO),DBSQL,Crystal,SQL(ODBC/JDBC),Sybase Unwired,SQL(ODBC/JDBC),3rd Party BI Client,Custom Web Developed UI,3rd party application,Non-Certified,SAP HANA Sizing Disclaimer,Sizing recommendations apply for certified hardware only. These are included in SAPs Product Availability Matrix, but are changing constantly. Please contact hardware vendor for suitable hardware configuration. SAP HANA is constantly being optimized. This might impact sizing recommendations, which will not be reflected in this document. Therefore, work with your SAP account team for recommendations. The sizing guideline in this document refers to SAP HANA Platform only. Additional applications integrated with SAP HANA (e.g., Business Objects, Data Services) are not covered. Specific sizing guidelines for these are available elsewhere.,In-Memory usage scenario: Technology,SAP HANA,BI Clients,SQL,MDX,BICS,3rd Party,Customers use the In-Memory technology to realize their own use cases:,Non SAP Data Source,Computing Engine,Data Modeling,ETL,Agenda,Data Warehouse Characteristics What is ? What is DCA? Data Warehouse Selection Criteria,Greenplum,Greenplum comes in two configurations, each with three “sizes” Regular DCA and “high capacity DCA” The only difference is the high capacity model uses larger, slower disk drives Sizes Quarter rack, half rack, and full rack Greenplum also announced a “high performance” model using SSD rather than disk drives, but so far it has not materialized.,Greenplum DCA,40U Cabinet,Moving from half to full rack can only be done onsite by the EMC field team,Greenplum DCA High Capacity Model,Same 40U Cabinet,The only difference is capacity and scan speed. The simply replaced the drives in the DCA with larger capacity, slower drives!,What is the EMC Greenplum DCA,Applications access the database through the master host. If the master is down, the system is inaccessible since no automated connection failover,No “magic” here, the data needs to be moved from disk, to the CPUs for processing,Only one port for application connections, this limits throughput,What is the EMC Greenplum DCA,The standby is kept in synch with the primary using disk mirroring. If this is synchronous, that hurts performance, and if asynchronous then transactions can be lost in the event of a failover,Greenplum Claims These Advantages,HANA delivers far simpler administration, better compression, and faster performance than Greenplum,Being able to store 100TB, and access and return it quickly and efficiently, are two completely different things,The architecture is full of bottlenecks and inefficiencies in its design (discussed later),Greenplum DCA Comparison Summary,Agenda