Utility Data Model For Big Data Analytics - Oracle
Utility Data Model For Big Data Analytics - Oracle
Utility Data Model For Big Data Analytics - Oracle
Oracle Corporation
SCALE
$36.9B in revenue on a trailing twelvemonth basis*
INNOVATION
34,000 developers and engineers
#1 in 50 product/industry categories
$4.5B $4.5B
$3.3B
$1.3B $1.5B
$2.7B $2.8B
$1.9B $2.2B
MORE THAN
$24B IN R&D
SINCE 2004
About
The
Speaker
Samuel Harrell
Industry Director, Utilities NA
Industry Business Unit
Agenda
Utilities
Data
Management
& Advanced
Analytics
Big
Data
Mobile
In-memory
Analytics
Cloud
2000s
Adhoc Query/Analysis
BI/DW platforms
1990s
Reporting/Dashboards
Web-based BI/DM
1980s
Database
Reporting Tools
Telemetry
800TB
PCTs Come
On-line
Events
600TB
Messages
Databases
Files
OMS Upgrade
400TB
200TB
AMI Deployment
RTU Upgrade
Mobile Data Goes Live
Distribution Management
Rollout
GIS Upgrade
Substation Automation System
Time
Source: Electric Power Research Institute
Produce
Data
%
12
Executives who feel they
understand the impact data
will have on their
organizations
Use
Data
Static Business
Processes
Skill Set
Gaps
BIG DATA
CLOUD
Collaborative Analytics
Approach
10
Operational Integration
of Analytics
Actionable
Insights
MOBILE
Standardize
Optimize
One off
tools/solutions
Enterprise standard
tools/solutions
Agile, flexible
architecture
Bottom-up
Information as
a Platform
All stage 3
capabilities
delivered as a
platform
(service/cloud)
Access of tools and
data among broad
subscriber group
Value
Reports
KPI Dashboards
Ad-hoc Queries
Optimizing
Real-Time
Operations
Prescriptive
Diagnostic
Predictive
Descriptive
Automated
Standardized
Flexible
Past (Reactive)
Field Workers
t=0
Managers
Future (Proactive)
Executives
Time
Customers
Business Value of Enterprise Analytics: Connect, Empower Users and Transform the Business
12
13
Utilities
Data
Management
& Advanced
Analytics
Apache
Flume
HDFS
Oracle NoSQL
Database
Hadoop
(MapReduce)
Big Data
Connectors
Real-Time
Data
Enterprise
Applications
Data
Integration
STREAM
ACQUIRE
ORGANIZE
14
Data
Warehouse
Industry
Data
Models
In-Database
Analytics
Event
Processing
ANALYZE
Analytic
Applications
Visualization
DECIDE
Proprietary & Confidential
Social
Work Mgmt
Asset Mgmt
Meter/Device
Network
Utilities GBU
Applications
CIS/CRM
Data Connectors
(ODI)
Data Sources
Derived Tables
ERP
Foundation
ETRM
Layer
Analytic
Layer
Presentation
Layer
OBIEE
OLAP
OBIEE
OLAP
ODM
ODM
Weather
Oracle
SQL
Modeler
GIS/Spatial
Other
CIM, MultiSpeak, etc.
15
Accurate
Reliable
Credible
Timely
Complete
Appropriate
16
Integration &
Process Excellence
Real-time
Event-driven
Centralized
Action Oriented
Reusable
Flexible
Advanced Analytics
& Decision Support
Operational Decision
Orientation
Sophisticated
Proactive
Cross Functional
Oracle Industry
Data Model
Analytics
Development
(DB EE Option)
Productized or
Custom Connectors
to Non-Oracle
Applications
Information
Cleansing and
Staging
Master Data
Management
Foundation Layer
Extensions
Development of
Productized
Connectors to
Oracle Applications
Sample Star
Schemas
Analytical Layer
Extensions
Developemnt of
Productized Star,
OLAP, Mining
Models
Intra-ETLs
Use of Productized
Sample OBIEE Content
Connectors
Foundation Layer
(3NF)
Oracle Offerings
Use of Productized
Reports,
Dashboards
Guided Analytics
Partner Solutions
Focus on Data Management & Data Integration
18
Partner Solutions
Focus on Advanced Analytics
19
Closing Remarks
20
Utilities
Data
Management
& Advanced
Analytics
1. SIMPLIFY
2. STANDARDIZE
Business processes,
procedures, accelerate user
adoption, improve quality and
accuracy of data
3. CENTRALIZE
Data, processes, systems
and decisions, common data
definition across business
for cross domain analytics
21
BLOG
SMART
METER
4. AUTOMATE
DEVICES
Big Data
Opportunities in
the Connected Car
Reduce claims-to-premiums
ratio leveraging real time
information from the vehicles
can help measure its exposure
to risks such as when, where
and how long it was driven.
Location-sensitive playlists
by mashing podcasts, music or
news. Develop personalized
ad campaigns and alerts
based on vehicle location.
Questions
23
24
25
THE COMPLETE
ANALYTICS SOLUTION
26