Transcription
IBM Smarter AnalyticsInfrastructure for zEnterpriseTransforming your business to be Information DrivenCaryn MeyersIBM System z Business Intelligence Marketing Manager 2013 IBM Corporation
Drowning in a sea of data .with no informationInformation is exploding44x202035 zettabytes1021digital data growththrough 20202009800,000 petabytes 101521 in 2Business leaders say theydon’t have access to theinformation they need to dotheir jobs1 in 3Organization leadersfrequently make decisionsbased on information theydon’t trust, or don’t have220%Organizations competingon analytics substantiallyoutperform their peers33%Sources: The Guardian, May 2010 IBM IBV/MIT Sloan Management Review Study 2011. Copyright Massachusetts Institute of Technology 2011Revenue growth and 12X moreprofit growth for organizationsthat apply advanced analytics 2013 IBM Corporation
Analytics Shifts to Pervasive Operational Workload Enterprises are modernizing and extending functionally Better decisions from the right information Informed decisions at the point of contact Consistency of information across organizations Which is driving operational characteristics requirements Cost of downtime is escalating The impact of unauthorized intrusion of private information isoverwhelming Stringent Service Level Agreements Newer applications - demanding lower latency of data Businesses want the most up-to-date information they can get Yesterday’s information was good yesterday While focusing on reducing costs and consolidating Lower costs through reduced complexity Simplified environment with easier administration Lower SW costs, elimination of redundant servers andresources33 2013 IBM Corporation
System z: The INFORMATION HUB of the EnterpriseEasy to manageDataDashboards / ReportingAdministrationInfrastructureand Data ProtectionIBM Smart Analytics System 9700Guardium HostBased ProbesGuardiumCollectorsIBM CognosSoftware / QMFISV: SAS/IBIIBM Optim andGuardium SoftwareMaster Data, Data Warehouseand Data IntegrationIBM InfoSphere Software44Data Mining and StatisticsQuery AcceleratorIBM DB2 AnalyticsAcceleratorIBM SPSS PredictiveAnalytics Software 2013 IBM Corporation
The IBM zEnterprise Smarter Analytics Foundation is designed to enable a datacentric approach towards business analytics by easing the integration of all aspectsof decision management into operational systemsAnalytics software. These are thetools that deliver actionableinsights from data.Predictive ViewData warehouses, marts, etc. These sourcessupport reporting and predictive model creation.Historical ViewThe operational systems that house the book of record.These sources are critical to day-to-day business processes.Real-Time View5 2013 IBM Corporation
A Closer Look:Elements of the IBM zEnterprise Smarter Analytics FoundationIBM zEnterprise Analytics System 9700 / 9710 A highly competitive solution specifically designed to support a complete business analytics anddata warehouse environment on System z A customizable and integrated solution of hardware, software and services that enables rapidintegration of Decision Management into operational systems Combines the availability and security of System z with the characteristics of an appliance thatenables mixed workload analytics to drive business optimization with information-led actionabledecisionsIBM DB2 Analytics Accelerator A workload optimized appliance that enables the integration of business insights into operationalprocesses Unprecedented response times enable 'train of thought' analyses frequently blocked by poor queryperformance Deep integration with DB2 z/OS provides transparency to all applications Queries are automatically executed in the most efficient location Appliance hands-free operations, eliminating most database tuning tasks Included in the IBM zEnterprise Smart Analytics System 9700 (optional element of the 9710)IBM zEnterprise BladeCenter Extension6 Extends System z qualities of service to distributed applications accessing data or applicationshosted on System z, facilitating lower overall cost and an improved user experience Preserves existing application architecture: no modifications required for operating systems orapplications An integrated solution: infrastructure is built and tested at the factory Improves the connectivity between distributed applications and IBM System z through isolated,secure, redundant and automatically configured high-speed network connection 2013 IBM Corporation
IBM zEnterprise Analytics System 9700Mixed Workloads for Next Generation Business AnalyticsAn integrated solution designed and tested tosupport rapid deployment of business analytics across the enterprise Integrated offering of hardware, software,and optional services Secure, Available Business Analytics Simplified administration Optimized software stack OS, DB2, Utilities, InfoWarehouse, Cognos, SPSSAnalytics Infrastructurein-a-box7 Plus OPTIONAL PACKS – To create end-to-end solution 2013 IBM Corporation
IBM zEnterprise Analytics System 9700Flexibility in Critical Data Decision SystemsOrganized for simplicityand functionalitySystem z z196 / EC12z/OS Operating System alyticsAcceleratorOrz/OSDB2 for z/OSOperational Source Systems88 2013 IBM Corporation
IBM zEnterprise Analytics System 9710Cost Effective Critical Data Decision SystemsOrganized for simplicityand functionalitySystem z/114ETL/ELTz/OS Operating System StackOperational Source SystemsDataWarehouseDataMartODSDB2 for z/OSDS887099DB2 AnalyticsAccelerator 2013 IBM Corporation
Data Analytics PackDelivering information when, where, and how each user needs it Delivers information where,when and how it is needed Self-service reporting and analysisIndividualized by userAutomated delivery of information in contextAuthor once, consume anywhere Full range of BI capabilities Query, reporting, analysis,dashboarding, realtime monitoring1010 2013 IBM Corporation
Data Integration PackDelivers data integration capabilities, and includes a common metadata server tosupport reuse and enhanced governance, as well as capabilities to support creatingmanaging project blueprints, to help improve project visibility and decrease projectrisk. Information Server for Data Integration: Discovery Metadata Workbench DataStage BluePrint Director Data Architect InfoServices Director FastTrack Change Data Capture11 2013 IBM Corporation
DB2 Analytics Accelerator V3Further extending the featuresMore insight from your data Unprecedented response times for“right-time” analysis Complex queries in seconds ratherthan hours Transparent to the application Inherits all System z DB2 attributesBlending System z and Netezzatechnologies to deliver unparalleled,mixed workload performance forcomplex analytic business needs.1212 No need to create or maintain indices Eliminate query tuning Fast deployment and time-to-value 2013 IBM Corporation
DB2 for z/OS : Mixed Architecture – Hybrid ComputingHybrid Parallel Processing (HPP)Symmetric Multiprocessing (SMP)Massively Parallel Processing (MPP)Tuned to perform one task veryTuned to perform manyTunedtasks for mixed workloadsquicklysimultaneousSimpler, transparent to applicationMore complex, Hard to programSimpler, Easy to programScales according to needScales horizontallyScales verticallyAll processors optimized for useSome processors not fully utilizedProcessors equally utilizedMost data warehouses have a mixture of queries that requirethe unique capabilities of both SMP and MPP.1313 2013 IBM Corporation
Did you know: DB2 for z/OS delivers a single, workload-optimizedsystem for both operations AND warehousing?DB2 for z/OS andIBM DB2 Analytics Accelerator Simplification High fidelity dataOLTP Transactions Competitiveprice/performanceOperational analytics Dynamic routing for mostefficient fit for purposeexecution architectureReal time data ingestionDB2 NativeProcessingHigh concurrencyAdvanced analytics*Standard reportsOLAPComplex queries14* Advanced analytics is supported by Netezza but not currently exploited by IDAA Combines the strengths ofboth System z and Netezzatechnology Merges operational anddata warehouse into asingle optimizedenvironment Single environment forsecurity, logging, back-up,and recovery 2013 IBM Corporation
Combining the Best transaction system with the best analytics ySMP HostQuery execution run-time forqueries that cannot be or shouldnot be off-loaded to IDAAIDAA DRDA rySPUCPUFPGAMemoryDB2 for z/OSDB2 Analytics AcceleratorQueries executed without DB2 Analytics AcceleratorQueries executed with DB2 Analytics Accelerator1515 2013 IBM Corporation
DB2 Analytics Accelerator V3What’s New? High Performance Storage SaverLowering the costs oftrusted analytics Store a DB2 table or partition of datasolely on the Accelerator. Incremental Update Enables continual updates to Acceleratordata. zEnterprise EC12 Support Supports zEnterprise EC12, z196, z114 Query Prioritization Brings System z workload managementprioritization down to the individual query High Capacity Support has been extended to include theentire Netezza 1000 line (1.28 PB) UNLOAD Lite Reduces z/OS MIPS consumption, bymoving the preparation off System z.1616 2013 IBM Corporation
High Performance Storage SaverReducing the cost of high speed storage Time-partitioned tables where: only the recent partitions are used in a transactional context(frequent data changes, short running queries) the entire table is used for analytics (data intensive, complexqueries). DB2 partitions are deleted after the High Performance StorageSaver are created on the acceleratorDB2#1Query fromApplicationNo longer present on DB2 #6#7 2013 IBM Corporation
Storage options to match data needsOptimized in both price and performance for differing workloadsHigh PerformanceStorage SaverDatabase ResidentPartitionsSingle Disk StoreDual Disk Store Only stored on Acceleratorstorage (Less Cost) Stored on both DB2 andAccelerator storage Optimized performance fordeep analytics, multifaceted,reporting and complex queries Mixed query workload withtransactions, single record queriesand record updates with deepanalytics, multifaceted, reportingand complex queries. Only full table update or fullpartition update from backup Same high speed query accesstransparently through DB2Cost1818 Full table, full partition update,Incremental update from DB2 data Same high speed query accesstransparently through DB2The right mix of cost and functionalityFunctionality 2013 IBM Corporation
N1001 Systems and SizesPureData System for Analytics /41/211 810241280Predictable, Linear Scalability throughout entire familyCapacity User Data spaceEffective Capacity User Data Space with compression19*: 4X compression assumed 2013 IBM Corporation
End-to-end Business Analytics - Fraud DetectionLinux on ZCognosReportingSelect IBM BladesSystem z Hostwith Unified Resource ManagerSystem z Hardware Management Console (HMC)Operational database Data WarehouseDB2 for z/OSDB2 for z/OSDB2 Utilitiesz/VMDB2z/OSIWHouseLinuxonSystem zz/OSCOGNOSAIX onPOWER7AIX on onAIXAIX onPOWER7POWER7POWER7AIX onPOWER7AIX onPOWER7AIX onPOWER7System z PR/SM Blade HW Resourcesz HW ResourceszBXSupport ElementPrivate data network (IEDN)20SASFraudDetectionISAS-9700Power BladesSAS-Fraud DetectionAIX-Grid 2013 IBM Corporation
System z HostLinuxonSystem zLinux onSystem x orWindowsAIX onPOWER7 z/VMBlade VirtualizationBlade VirtualizationIBM DB2 Analytics Acceleratorz/OSz/TPF Linux onSystem zz/VSE Select IBM BladesDataPower XI50zwith Unified Resource ManagerSystem z Hardware Management Console (HMC)zEnterprise contains all processing required for decisionmanagement within a single system imageSystem z PR/SM System z HW ResourcesBlade HW ResourceszBXSupport ElementPrivate data network (IEDN)Unified ResourceManagerCustomer Network21Private Management Network INMNPrivate Management Network (information only)Private High Speed Data Network IEDNCustomer Network 2013 IBM Corporation
IBM Analytics Tools:xMaking complexbusiness information understandableCognosQMFSPSSILOG CPLEXTranslate data from various corporate systems into: Deliver information where, when and how it is needed Self-service reporting and analysis Individualized by user visually rich presentations gauges, maps, charts, and other graphical elements Integrated results from multiple sources, combined in a more meaningful wayWhile delivering integrated offerings designed to optimize performance Delivered 2222into the hands of business users 2013 IBM Corporation
Answering the questions – “Why?” Analysis Reporting full breadth of report types Access via email, portal, MSOffice, search and mobiledevices etc. Easy Integration of info fromexternal sources Push data and formats toother tools such as Excel Dashboards“How are we doing?” Advanced Analytics at-a-glance - highly visualand intuitive high impact views of complexinfo operational, tactical, strategic Designed to help monitor,measure, and managecorporate performance2323– guided exploration– Easy click-through todetails– Extreme queryperformance with the IBMIDAA– Statistical analysis andtrending– Forecasting and keymeasurements– In DBMS scoring andtemporal data with DB2for z/OS– Integration with SPSS 2013 IBM Corporation
BI Mobility – QMF/CognosMaking information.accessible! Advances Leverage mobile technology to accelerate delivery ofinteractive analytics to executives and frontline workers Address challenges of compressed decision cycles withreal-time analytics Integrate analytics in everyday work and in workflow toinform business processesMobile, real-time,and portable. Key features Mobile interaction on iPhone and iPad Interactive, disconnected reports Real-time monitoring of in-flight information Mashups Business-driven workflow24 2013 IBM Corporation
Taking Predictive Analytics to the Next LevelPredict the Behavior of the Next Case by modelingA Universe of DataA Predictive ModelAttributes: Married Lives in the City of Chicago VP R&D, SPSS / IBM Owns a Corvette and a Plane 47 years old Drinks Martinis, extra dryPredicted Attributes Likes Rush Likes Chopin Works long hours Travels overseasPredicted Behavior Wants to Buy aviation headsets Buys Car Washes! Buys Champagne Vacations to N. California to golf25 2013 IBM Corporation
IBM SPSS –Making information.predictive High-performance data mining and textanalytics workbench Set of mining algorithms that provideinsight and prediction Identify patterns and trends in data thatcan be used to optimize businessdecisions Cognos integration of SPSS models Benefits Maximize Analyst Output Create Practical Solutions Faster Open & Efficient Architecture Data mining within standarddatabases Data/Text Mining natural language processing heuristic rules statistical techniques . to reveal meaning in text Collaboration & Deployment Services Flexible enterprise foundation for managingand deploying analytics throughout theorganization Benefits Automates analytical processes Securely share and reuse analytic models Streamlines delivery of analyticalinformation on a scheduled or real-timebasisWEB-DEMO of MODELER at: spss/demos/modeler/2626 2013 IBM Corporation
The Impact on Real-time ScoringMultiple infrastructuresrequiredWeb services callCustomerinteractionBusinessApplication/ OLTPHistoricalData StoreETLScoringApplicationCopyR-T, min,hr, wk, mthDelivers adynamic scoreApplicationDBWeb services callHigh NetworkingTraffic27Difficult to committo SLA’s 2013 IBM Corporation
IBM Smarter Analytics – Anti-Fraud, Waste and Abuse SolutionAnti-fraud, Waste and Abuse SolutionFor Healthcare – For InsuranceDetect suspicious transactions prior to payment, minimize lossfrom overpayments, and recommend method of interventionSolution overviewProvide prepayment fraud detection with adaptive systemthat learns from the latest data Detect suspicious transactions using predictive modelsand smarter business rules Harness analytics to recommend best method ofinteraction for each transactionSolution benefits Dramatically reduce costs from fraud and abuse Pay valid transactions faster and with greater certainty More efficient use of investigative resources reducescosts and increases rate of return28Business Outcomes State governmentstopped fraud prior topayment and saved onaverage 220 millionannually Healthcare providersignificantly reduced falsepositive rate from 79percent to 29 percent Organizations applyingpredictive analytics are 2.2more likely to outperformtheir peers1. 2013 IBM Corporation
Workload AssessmentReportReport forfor aa firstfirst assessment:assessment: AccelerationAcceleration potentialpotential forfor QueriesQueries EstimatedEstimated timetime CPcostCP cost Customer Collects information from dynamicstatement cache, supported bystep-by-step instruction and REXXscript (small effort for customer) Upload compressed file (up tosome MB) to IBM FTP server IBM Import data into local database Quick analysis based on knownDB2 Analytics AcceleratorcapabilitiesKey contact: Data Warehouse System stomerandREXXandREXX procedureprocedureDatabaseDatabase29292DataData packagepackage(mainly(mainly unloadunloaddatadata sets)sets)Pre-processPre-process andandloadload3IBMIBM stTest ToolToolReportAssessment 2013 IBM Corporation
Client Value Engagement:5-Year: Analytics Accelerator Solution BenefitsTheThe followingfollowing benefitsbenefits werewere determineddetermined throughthrough thethe CVECVE processprocess basedbased onon on-siteon-site interviews,interviews, conferenceconference callscalls andandquestionnaires.questionnaires. AllAll ofof thethe benefitsbenefits cancan bebe achievedachieved throughthrough properproper implementationimplementation asas determineddetermined byby thethe ableblueprint within this CVE final deliverableSystem Z CPUsCumulative Financial Benefits 7.00 7.00 MilMilIDAA Financial Benefits SummaryIT AdministratorProductivitySpeed BI DevelopmentProjects .292.5 .292.5 MilMil .562.5 .562.5 MilMil 11,428,000 12,000,000 9,842,400 10,000,000 8,256,800 8,000,000 6,671,200 6,000,000 5,085,600 4,000,000BI Analysis ProductivityEnhancements 1.638 1.638 MilMil 2,000,000 0Year 1Remove IT Infrastructure30Year 2Year 3Year 4Year 5 1.935 1.935 MilMil 2013 IBM Corporation
Would you like to know more about how zEnterprise business intelligence and analytic offeringswill enable your enterprise to become information-driven?www.ibm.com/systems/zbiTo find the latest whitepapers from –consultants, analysts, solution architects3131Contact local IBM zEnterprise Sales contactto arrange a follow-on sessionWW contact: joys@us.ibm.com 2013 IBM Corporation
Thank You!328IBM Confidential 2011 IBM Corporation 2013 IBM Corporation
The IBM zEnterprise Smarter Analytics Foundation is designed to enable a data- centric approach towards business analytics by easing the integration of all aspects of decision management into operational systems
