Utility Data Model For Big Data Analytics

Transcription

Utility Data Model forBig Data Analytics1Copyright 2014, Oracle and/or its affiliates. All rights reserved.Proprietary & Confidential

Oracle CorporationSCALE 36.9B in revenue on a trailing twelvemonth basis*INNOVATION 34,000 developers and engineers #1 in 50 product/industry categories 18,000 customer support specialists,speaking 29 languages 24B in R&D since 2004 18,000 implementation consultants 50B on more than 80 acquisitions 15 million developers in Oracle onlinecommunities 390,000 customers in 145 countries 25,000 partners 115,000 employees 2 million students supported annually 900 independent Oracle user groupswith 500,000 members* GAAP revenue reported in USD as of August 31, 20122Copyright 2014, Oracle and/or its affiliates. All rights reserved.Proprietary & Confidential

Investment in Innovation and Integration 4.5B 4.5B 3.3B 1.3B 1.5B 2.7B 2.8B 1.9B 2.2BMORE THAN 24B IN R&DSINCE 2004FY04 FY05 FY06 FY07 FY08 FY09 FY10 FY11 FY12Figures in GAAP3Copyright 2014, Oracle and/or its affiliates. All rights reserved.Proprietary & Confidential

AboutTheSpeaker Samuel Harrell– Industry Director, Utilities NA– Industry Business Unit4Copyright 2014, Oracle and/or its affiliates. All rights reserved.Proprietary & Confidential

Agenda Industry & Business Challenges Big Data Platform Strategy– Oracle Utilities Data Model (OUDM)Implementation and DeploymentBenefits Close & Open Discussion5Copyright 2014, Oracle and/or its affiliates. All rights reserved.Proprietary & Confidential

Industry & BusinessChallenges6Copyright 2014, Oracle and/or its affiliates. All rights reserved.UtilitiesDataManagement& AdvancedAnalyticsProprietary & Confidential

Pace of Change Has Rapidly 0sAdhoc Query/AnalysisBI/DW platforms1990sReporting/DashboardsWeb-based BI/DM1980sDatabaseReporting Tools7Copyright 2014, Oracle and/or its affiliates. All rights reserved.Proprietary & Confidential

New Technologies Create Avalanche of New InformationCreating New Opportunities to Improve Business PerformanceEnd-User DataRequirementsExpected Data Volume Growth of a Tier 1 IOUWaveformNew Devices in the Homeenabled by smart meteringTelemetry800TBPCT’s ComeOn-lineEvents600TBMessagesDatabasesFilesOMS Upgrade400TB200TBAMI DeploymentRTU UpgradeMobile Data Goes LiveDistribution ManagementRolloutGIS UpgradeSubstation Automation SystemAdvanced Distribution AutomationMobile Workforce ProjectTimeSource: Electric Power Research Institute8Copyright 2014, Oracle and/or its affiliates. All rights reserved.RTU: remote terminal unitPCT - Programmable Communicating ThermostatProprietary & Confidential

The Problem With Big DataProduceData%12Executives who feel theyunderstand the impact datawill have on theirorganizationsUseDataSource: Oracle Utilities Research Report, 20139Copyright 2014, Oracle and/or its affiliates. All rights reserved.Proprietary & Confidential

Big Data – Are You Ready?Utilities Face Key Challenges in Realizing ValueInformationSilosStatic BusinessProcessesSkill SetGapsBIG DATACLOUDCollaborative AnalyticsApproach10Operational Integrationof AnalyticsCopyright 2014, Oracle and/or its affiliates. All rights reserved.ActionableInsightsMOBILEProprietary & Confidential

Unified Information Architecture Maturity PhasesSilosStandardizeOptimize One offtools/solutions Enterprise standardtools/solutions Agile, flexiblearchitecture Bottom-up Data warehouse anddependent datamarts Analyze “just in time”structured &unstructured datatogether Local business unitdriven Many versions oftruth Independent datamarts IT & LOB partnership Secure, consistentaccess to all data Advanced analytics &real-timerecommendationsInformation asa Platform All stage 3capabilitiesdelivered as aplatform(service/cloud) Access of tools anddata among broadsubscriber groupMaturity & Capability11Copyright 2014, Oracle and/or its affiliates. All rights reserved.Proprietary & Confidential

ValueWhy Should Utilities Care? Preventative Action What-If Scenarios Forecasting Reports KPI Dashboards Ad-hoc Queries ePast (Reactive)Field Workerst 0ManagersFuture (Proactive)ExecutivesTimeCustomersBusiness Value of Enterprise Analytics: Connect, Empower Users and Transform the Business12Copyright 2014, Oracle and/or its affiliates. All rights reserved.Proprietary & Confidential

Big Data Platform Strategy13Copyright 2014, Oracle and/or its affiliates. All rights reserved.UtilitiesDataManagement& AdvancedAnalyticsProprietary & Confidential

Solution Stack for Big DataTechnology PerspectiveApacheFlumeHDFSOracle NoSQLDatabaseHadoop(MapReduce)Big ataIntegrationSTREAMACQUIREORGANIZE14Copyright 2014, Oracle and/or its affiliates. All rights nsVisualizationDECIDEProprietary & Confidential

Oracle Utilities Data ModelTechnical ArchitectureOracle Utilities Data Model (OUDM)SocialWork MgmtAsset MgmtMeter/DeviceNetworkUtilities GBUApplicationsCIS/CRMData Connectors(ODI)Data SourcesDerived delerGIS/SpatialOtherCIM, MultiSpeak, etc.Exadata, Exalytics, Big Data Connectors15Copyright 2014, Oracle and/or its affiliates. All rights reserved.OUDM Key Components: Pre-built, CIM-based designed and optimizedfor Oracle DB and hardware Use in any applications environment and iseasily extensible and customizable Foundation for BI and analytics infrastructure 3rd Normal Form (3NF) CIM-based Foundation Layer with reference & basetransactions Analytical Layer with Aggregates, OLAP Cubes,Pre-built Mining Models Intra ETL Exchange, Extensive BI Metadata Over 670 tables with over 4,800 columns;and 1,300 industry measures and 80 KPIs Presentation Dashboards & Sample ReportsPartner Value-Add (Xtensible Solutions): Data integration services Pre-built application connectors Additional analytical reports, models, etc.Proprietary & Confidential

CIM and Enterprise TransformationDriving Value From Big DataEnterprise DataManagement Accurate Reliable Credible Timely Complete Appropriate16Copyright 2014, Oracle and/or its affiliates. All rights reserved.Integration &Process Excellence Real-time Event-driven Centralized Action Oriented Reusable FlexibleAdvanced Analytics& Decision Support Operational DecisionOrientation Sophisticated Proactive Cross FunctionalProprietary & Confidential

Oracle Utilities Data ModelImplementation Flexibility – Enterprise ScaleApplicationIntegrationOracle IndustryData ModelAnalyticsDevelopment(DB EE Option)Productized orCustom Connectorsto Non-OracleApplicationsInformationCleansing andStagingMaster DataManagementFoundation LayerExtensionsDevelopment ofProductizedConnectors toOracle ApplicationsSample StarSchemasCopyright 2014, Oracle and/or its affiliates. All rights reserved.Analytical LayerExtensionsDevelopemnt ofProductized Star,OLAP, MiningModelsCustom Star, OLAP,Mining ModelsCustomDashboards & ReportsRole DefinitionIntra-ETLsUse of ProductizedSample OBIEE ContentConnectorsCustomer, SI, DevPartner Offerings17Foundation Layer(3NF)Oracle OfferingsUse of ProductizedReports,DashboardsGuided AnalyticsCustomer, SI, DevPartner OfferingsProprietary & Confidential

Partner SolutionsFocus on Data Management & Data Integration18Copyright 2014, Oracle and/or its affiliates. All rights reserved.Proprietary & Confidential

Partner SolutionsFocus on Advanced Analytics19Copyright 2014, Oracle and/or its affiliates. All rights reserved.Proprietary & Confidential

Closing Remarks20Copyright 2014, Oracle and/or its affiliates. All rights reserved.UtilitiesDataManagement& AdvancedAnalyticsProprietary & Confidential

Roadmap For Innovation & Transformation1. SIMPLIFY2. STANDARDIZESystems and processesto reduce cost, increasecontrol, and provideplatform for better decisionsBusiness processes,procedures, accelerate useradoption, improve quality andaccuracy of data3. CENTRALIZEData, processes, systemsand decisions, common datadefinition across businessfor cross domain analytics21Copyright 2014, Oracle and/or its affiliates. All rights reserved.BLOGSMARTMETER4. AUTOMATEDEVICESWhenever possible withintegrated event drivenbusiness processes,collaborative best practicesProprietary & Confidential

Real time monitoring andremote diagnostics on ongoingbasis will have direct costavoidance/savings potential inwarranty claimsBig DataOpportunities inthe Connected CarUtilize vehicle sensor data forearly fault detection, servicealerts, monitor emissions &driver behavior monitoring(teenage drivers)Reduce claims-to-premiumsratio leveraging real timeinformation from the vehiclescan help measure its exposureto risks such as when, whereand how long it was driven.Location-sensitive playlistsby mashing podcasts, music ornews. Develop personalizedad campaigns and alertsbased on vehicle location.

Questions23Copyright 2014, Oracle and/or its affiliates. All rights reserved.Proprietary & Confidential

Presenter Contact InformationSamuel Harrell Industry Director, Utilities NAPhone: 1 281-904-0488Email: sam.harrell@oracle.comOracle Industry Business Unit24Copyright 2014, Oracle and/or its affiliates. All rights reserved.Proprietary & Confidential

The preceding is intended to outline our generalproduct direction. It is intended for informationpurposes only, and may not be incorporated into anycontract. It is not a commitment to deliver anymaterial, code, or functionality, and should not berelied upon in making purchasing decisions.The development, release, and timing of anyfeatures or functionality described for Oracle’sproducts remains at the sole discretion of Oracle.25Copyright 2014, Oracle and/or its affiliates. All rights reserved.Proprietary & Confidential

THE COMPLETEANALYTICS SOLUTION26Copyright 2014, Oracle and/or its affiliates. All rights reserved.Proprietary & Confidential

Guided Analytics Oracle Offerings Customer, SI, Dev Partner Offerings Customer, SI, Dev Partner Offerings Oracle Utilities Data Model Implementation Flexibility – Enter