《SAPHANAvsEMCGreenplum9475.pptx》由会员分享，可在线阅读，更多相关《SAPHANAvsEMCGreenplum9475.pptx（36页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、15 May 2023Comparing SAP HANA to EMC Greenplum DCA 2011 SAP Corporation2AgendaData Warehouse CharacteristicsWhat is HANA?What is DCA?Data Warehouse Selection Criteria 2011 SAP Corporation3Data Warehouse CharacteristicsData Warehouses always GROWIn size,number of users,importance,and usageHard to pre
2、dict growth patternsData Warehouses Constantly ChangeAs you add users,applications,more dataData Warehousing skills are critical to successRequires skilled people to work on the DBMSMyth that they are“just another database”Large data warehouse community is important for exchange of information and i
3、deas between other customers Partnership with DBMS vendor is critical 2011 SAP Corporation4AgendaData Warehouse CharacteristicsWhat is HANA?What is DCA?Data Warehouse Selection Criteria 2011 SAP Corporation5HANAs Revolutionary ApproachGroundbreaking In-Memory Innovations300 x FasterAnalytics?Real-Ti
4、me Access to Transactional DataScaleSpeedFlexibilitySAP HANA 2011 SAP Corporation6SAP HANAIn-Memory software+hardware(HP,IBM,Fujitsu,Cisco,Dell)Data Modeling and Data ManagementReal-time Data ReplicationSAP BusinessObjects Data Services for ETL capabilities from SAP Business Suite,SAP NetWeaver Busi
5、ness Warehouse(SAP NetWeaver BW),and 3rd Party SystemsCapabilities EnabledAnalyze information in real-time at unprecedented speeds on large volumes of non-aggregated dataCreate flexible analytic models based on real-time and historic business dataFoundation for new category of applications(e.g.,plan
6、ning,simulation)to significantly outperform current applications in categoryMinimize data duplicationSAP In-Memory Appliance(SAP HANA)SAP HANA StudioReal-Time Data ReplicationSAP HANASAP HANASAP ApplicationsNon SAP Data sourcesSAP HANA DatabaseCalculation EngineRow&Column In-MemorySAP BusinessObject
7、s Data IntegratorSAP Information ComposerSAP BusinessObjects BI SolutionsOther Applications 2011 SAP Corporation7SAP HANA Proof Points460BData records analyzed in less than a second21%Average increase in revenue3600 xFaster reporting speed 2011 SAP Corporation8CustomerLinkCustomer StorySolutions Ado
8、beClick HereAdobe is using SAP HANA to analyze a large volume of complex data to gain business insights into software piracy,and to develop preventive strategies and explore significant revenue recovery opportunities.SAP HANASAP Business Objects BIInfosysClick HereInfosys utilizes SAP HANA to unders
9、tand profitability by project,conduct“what-if”analysis on the fly with granular revenue and cost data.The company was able to explore and interact with key variables that affected a projects profitability at all levels within the company.SAP HANABASFClick HereBASF,a German-based chemical company,use
10、s SAP HANA to speed response times from minutes to seconds,and improve data reliability to optimize their businessSAP HANASAP BWABosch SiemensClick HereBSH is using SAP HANA to better adapt to customer needs.BSH,with SAP In-Memory Computing,can now perform simulations and create business forecasts i
11、n seconds rather than days.SAP HANACentrica Click HereCentrica supplies gas and electricity to millions of homes and businesses and offers a wide range of energy services.Centrica uses SAP HANA to process and analyze vast amounts of data generated by its smart meter technology.SAP HANASAP HANA Custo
12、mer TestimonialsHighlighting Value and Benefits 2011 SAP Corporation9CustomerLinkCustomer StorySolutions CISCOClick HereSAP and Cisco are working together give customers the ability to make better decisions faster.With in-memory technology,and specifically SAP HANA,users have the ability to simplify
13、 the effective delivery of high-value information to business decision makersSAP HANASAP Business Objects BISAP BWAColgateClick HereColgate uses SAP HANA in their Mexico branch to manage their sales profitability and analysis reporting,where now sales reps can run reports with real-time results up t
14、o 100-300 times faster driving immediate business impact.SAP HANADeloitteClick HereDeloitte is gaining clear and immediate insight into its current liquidity and cash flow information using SAP HANA.SAP HANAHiltiClick HereHILTI is leveraging SAP HANA,to provide better flexibility and performance for
15、 reporting and analysis across multiple areas of the business based on millions of rows of data.SAP HANAP&GClick HereP&G,the worlds largest consumer product company,will use SAP HANA to build the next generation of financial planning and reporting applications,with speed that completely transforms w
16、hat is possible today.SAP HANASAP HANA Customer TestimonialsHighlighting Value and Benefits 2011 SAP Corporation10CustomerLinkCustomer StorySolutions INTELClick HereSAP and Intels co-innovation efforts with In-Memory Computing on Intel processors,is a game changing technology.SAP HANA reduces databa
17、se query time from 77 minutes to 13 seconds,a 355x improvement in performance,when run on the Intel Xeon processor 7500.SAP HANALenovoClick HereLenovo uses SAP CRM today and plans to use SAP HANA to process 1.8 million contract records with multiple attributes in less than a second,simplifying IT an
18、d reducing TCO.SAP HANASAP Business Objects BIMedidataClick HereSAP HANA helps Medidata improve the way their clients manage clinical trials process to have real-time analytics available immediately,bringing value to every level within the clinical trial management process.SAP HANANomura Research In
19、stitute(NRI)Click HereNRI,a research and consulting services provider,is able to use SAP HANA to analyze traffic information in Tokyo,and gained the ability to search through 360 million data records approximately 1 secondSAP HANAT-MobileClick HereT-Mobile plans to use Strategic Workforce Planning a
20、pplication on the HANA platform to make real-time decisions very quickly66 million calculations and returned the results in seconds to allow for immediate business decisions.SAP HANASAP Strategic Workforce PlanningSAP HANA Customer TestimonialsHighlighting Value and Benefits 2011 SAP Corporation11”H
21、ANA Revolutionized the MarketCustomerLinkCustomer StorySolutions AdobeClick HereAdobe is using SAP HANA to analyze a large volume of complex data to gain business insights into software piracy,and to develop preventive strategies and explore significant revenue recovery opportunities.SAP HANASAP Bus
22、iness Objects BIInfosysClick HereInfosys utilizes SAP HANA to understand profitability by project,conduct“what-if”analysis on the fly with granular revenue and cost data.The company was able to explore and interact with key variables that affected a projects profitability at all levels within the co
23、mpany.SAP HANABASFClick HereBASF,a German-based chemical company,uses SAP HANA to speed response times from minutes to seconds,and improve data reliability to optimize their businessSAP HANASAP BWABosch SiemensClick HereBSH is using SAP HANA to better adapt to customer needs.BSH,with SAP In-Memory C
24、omputing,can now perform simulations and create business forecasts in seconds rather than days.SAP HANACentrica Click HereCentrica supplies gas and electricity to millions of homes and businesses and offers a wide range of energy services.Centrica uses SAP HANA to process and analyze vast amounts of
25、 data generated by its smart meter technology.SAP HANASAP HANA Customer TestimonialsHighlighting Value and Benefits 2011 SAP Corporation12SAP HANA:ArchitecturenOraclenDB2nSybase&IQnSQL ServernInformixnTeradatanMySQLnNetezzanHP NeoviewnODBCnOracle AppsnPeopleSoftnSiebelnJD EdwardsnSnSAP BWnSAP ERPnTe
26、xt delimitednText fixed widthnEBCDICnXMLnCobolnExcelnHTTPnJMSnSOAPDatabasesApplicationsFiles/TransportSLTSAP BusinesObjects Data Services 4.0DB Triggers 2011 SAP Corporation13Business Intelligence Clients and SAP HANA 1.0ERPSAP In-Memory DatabaseReal TimeDBSAP BW3rd PartySAP BusinessObjects Data Ser
27、vicesSAP HANA(Appliance)SAP BusinessObjects BI 4.0Semantic LayerCrystalWebIDashboardsExplorerA OfficeSQL(ODBC/JDBC)BICSMicrosoft ExcelMDX(ODBO)DBSQLCrystalSQL(ODBC/JDBC)Sybase UnwiredSQL(ODBC/JDBC)3rd Party BI ClientCustom Web Developed UI3rd party applicationNon-Certified 2011 SAP Corporation14SAP
28、HANA Sizing Disclaimer 1.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.2.SAP HANA is constantly being optimized.This might impact sizing re
29、commendations,which will not be reflected in this document.Therefore,work with your SAP account team for recommendations.3.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.Speci
30、fic sizing guidelines for these are available elsewhere.2011 SAP Corporation15In-Memory usage scenario:TechnologySAP HANABI ClientsSQLMDXBICS3rd PartyTechnologyCustomers use the In-Memory technology to realize their own use cases:Non SAPData SourceComputing EngineData ModelingETL 2011 SAP Corporatio
31、n16AgendaData Warehouse CharacteristicsWhat is?What is DCA?Data Warehouse Selection Criteria 2011 SAP Corporation17GreenplumGreenplum 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 drivesSizes
32、Quarter rack,half rack,and full rackGreenplum also announced a“high performance”model using SSD rather than disk drives,but so far it has not materialized.2011 SAP Corporation18Greenplum DCA40U Cabinet Moving from half to full rack can only be done onsite by the EMC field team 2011 SAP Corporation19
33、Greenplum DCA High Capacity ModelSame 40U Cabinet The only difference is capacity and scan speed.The simply replaced the drives in the DCA with larger capacity,slower drives!2011 SAP Corporation20What is the EMC Greenplum DCAApplications access the database through the master host.If the master is d
34、own,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 2011 SAP Corporation21What is the EMC Greenplum DCAThe standby is kept in synch with th
35、e 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 2011 SAP Corporation22Greenplum Claims These AdvantagesHANA delivers far simpler administration,better compression,and faster performance than Gre
36、enplumBeing 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)2011 SAP Corporation23Greenplum DCA Comparison SummaryConsiderationsGreenplum DCASAP HANA Appl
37、ianceSupports gradual incremental growthNoYesOperates at stream speedNoYesIn-memory database analyticsNoYesBroad data type supportNoYesOptimized high speed loaderNoYesRun optimally with no tuning/maintenanceNoYes 2011 SAP Corporation24AgendaData Warehouse CharacteristicsWhat is?What is DCA?Data Ware
38、house Selection Criteria 2011 SAP Corporation25Data Warehouse Selection CriteriaTime to ValueScalabilityPerformanceHigh AvailabilityWorkload ManagementProven in ProductionTCOAnalytics Strategy 2011 SAP Corporation26Time to Value An AnalogyRequires constant tuning and maintenanceTurn the key and goGr
39、eenplumHANA 2011 SAP Corporation27Data Loading with GreenplumThe ETL process must serially write to files on each segment individually,then the data can be loaded into Greenplum.This means massive rewrite of the ETL process.And then the load processes fight for resources on the same filesystem(s)Gre
40、enplum claims load rates of 510 TB/hr(depending on model),but this is only AFTER the data has been split and written to each individual segmentHANA can load data at over?TB/hr with no pre-processing required 2011 SAP Corporation28Greenplum AvailabilityMirroring puts extra load on all servers and req
41、uires extra nodesWhat happen when the master fails?50%performance reduction in the event of a failureIf segments 1 and 2 both fail the entire system is down!2011 SAP Corporation29HANAs Preemptive Workload Management 2011 SAP Corporation30Workload Management in GreenplumQueues are based on roles only
42、,not application,query cost,etc.Number of active statements based on arbitrary number How can I stop problem queries from running at all?How can I handle users differently for different applications?My query took 10 seconds yesterday,but it has been running for 30 minutes already.What is wrong?Custo
43、mersBusiness AnalystDomain UserExecutive 2011 SAP Corporation31GreenplumGreenplum requires indexes,partitioning keys,etc.to performAll of which the DBA needs to determine and define manuallyIndex creation is very complicated and time consumingSame with PKs,FKs,constraints,etc.You need to VACUUM your
44、 Greenplum database regularly“A VACUUM FULL will reclaim all dead row space due to old row versions,but is a very expensive operation and may take too long to finish on large tables.”From the Greenplum Performance Tuning Guide 2011 SAP Corporation32HANA Compression Helps Lower TCO 2011 SAP Corporati
45、on33Analytic Ecosystem Elements33External EcosystemStructured SourcesExternal FeedsUnstructured SourcesEnterprise ApplicationsDataIntegrationMaster Data StreamProcessingContent AnalyticsOperationalAnalyticsBig DataAnalytics Big DataBig DataBI&Ad HocAnalyticsQueryableArchive 2011 SAP Corporation34Ana
46、lyzeIntegrateTransactional&Collaborative ApplicationsManageBusiness Analytics ApplicationsExternal Information SourcesData Cubes&MiningStreams Big DataMaster DataContentDatastreamingInformationGovernQualitySecurity&PrivacyLifecycleData WarehousesStandardsContent Where Does the Data Warehouse Fit 201
47、1 SAP Corporation35SAP HANA:Value PropositionAddressing Key Business Drivers Make Decisions in Real-timeFast and easy creation of ad-hoc views on businessAccess to real time analysisAccelerate Business Performance Increase speed of transactional information flow in areas such as planning,forecasting
48、,pricing,offersUnlock New Insights Remove constraints for analyzing large data volumes,trends,data mining,predictive analyticsStructured and unstructured dataIncrease Business ProductivityBusiness designed and owned analytical models reduce reliance on ITUse data from anywhereImprove IT EfficiencyMa
49、nage growing data volume and complexityLower landscape costs SpeedScaleFlexibilitySAP HANA 2011 SAP Corporation365/15/2023ConclusionThe business will continue to push the boundaries of time to value and your DW architecture needs to stay ahead of the curveCompanies will need to find a balance between consolidated and federated efforts while maintaining overall coordination.The challenge lies in maintaining governance while controlling costs and responding to the speed of the businessSimplify delivery while adding sophistication to your analytical capabilities