Operational Data Store Towards Event Managed Enterprise
Moving Towards Event Driven Enterprise
Data-Driven Batch Reporting
People-Driven
Production Reporting
Ad Hoc Reporting
OLAP/ DSS
Point in Time
Event-Driven Alerts/ Rules
Business Activity Monitoring Real Time
The Power of Real-Time
Data Integration ODS Integrates: Customer data Service data Channel data Inventory data
Real-time/Non Real-time from: ADC Clarify PhoneGen SAP Commverse
and Provides: Single View of Customer Pervasive Enterprise Information
T I B C O
Business User
ODS
Integrated Single View of Customer
Data Synchronization Check & Report DeSynchronization Revenue Assurance regains Synchronization ODS Monitors De-synchronization ODS Standardize backend data load/change Processes Standardize Data Exchange Processes
Regain Sync
Desync Report
Regain Sync
RA Team
Business Activity Monitoring Monitor Key Metrics Real-Time Observe and Manage Enterprise Performance at event level Align Execution to Strategy Native systems not burdened
Daily Payment Collection Target Tracking Overdue Report Customers
CIOU Manager
Soft Collections
DAKC Operations Line Manager
CIOU Team
Delhi
Mumbai
T I B C O
Chennai
Kolkata
Payment Collection
Dashboards
ODS Payment Collection Tracking at 2 p.m.
Business Rules & Actionable Triggers Monitor Events in Real Time Apply Business Rules Trigger Alert in case of Exception based on business rule Alert responsible person for action ODS provides information to analyze Customer details for Trigger Action
T I B C O
Business Rules Engine ODS
Actionable Triggers
Adjustment Rules and Alerts Adjustments tracking Adjustment for 7 day old customer
First 30 days of customer
T I B C O
Based on Value Based on User ID and IP address Frequency of Adjustments
ODS Adjustment>2000
Business Rules Engine
ID 101 Five Adjustments totaling 5000 in 1 day Adjustment Desk
De-duping & House-Holding Identify & Report Multiple Instances of one Customer Make ODS users aware of Customer Multiplicity Build Household information Treat Customer intelligently Manage Campaigns & Promotions better
D E D U P L I C A T I O N
H O U S E H O L D I N G
Intelligent Reinserts Perform Data Analysis and Mining in ODS. Generate intelligence for Operations, Sales and Service Desk Insert data in native systems Service Customers better by knowing the current state of customer Identify Up-Selling and Cross-Selling Opportunity
T I B Reinsert C O
Analysis Rules Engine ODS
Reinsert
Execution Plan Functional Design Integration Design/Data Modeling (ERD) HP HW/SW Procurement and Commissioning Extract Transform and Load (ETL) Design and Development Enterprise Application Integration (EAI) Process Design and Development Reports & Dashboard Design and Development Business Rules and Triggers Engine Design and Development Intelligent Reinserts Design and Development Testing Deployment in Production
HP NonStop Platform ™
Rules
RTE Docked Applications
EAI Event ETL Publish Message Transform Capture MiningSubscribe Queuing ™
NonStop CORBA ™ Tuxedo NonStop
Application Server/TP Monitor
Soap XML BEA WLS
NonStop SQL Cluster Aware DBMS and ReplicationNonStop RDF ™
NonStop Kernel SSI Clustered Operating System ™
™
Uncommon Advantage
Common Standards
RTE Applications/Services
™
Ag n gre En g gi ati ne o
™
Sc RT En or gi ing ne
R In ea fo l D rm Tim ir ec ati e to on r
Blaze
™
st M om gr e r
NonStop DTE ™
RT Info Director NonStop DataLoader TIBCO SS NonStop SOAP NonStop Inserter Informatica, Savant NonStop SQL NonStop XML BEA JMS Assential, Genus MF MQSeries ™
Cu
EAI partnerships
HP NonStop Server
RTE Data Store Queue
Keys
RT Aggregation
RT Scoring
Auditing
Security Policies
Upsert, Delete, Query
Business Rules
Request Handler
Data Cleansing
Assembly - Disassembly
Bus. Activity Monitor
App.
RTID
Subscription
Other
Adapter
SAP
Integration Server
App
Document Metadata
NonStop Server Fundamentals
Other
Standards based • J2EE (BEA WLS) • ANSI SQL • XML • JMS, HTTP
ODS DSS Comparison ODS
DSS
Enterprise Application Integration Current Valued
1-way Integrated Snap-Shot Valued
Volatile (updated)
Static/Stable (appended)
Zero Latency
Extended Latency
Medium History (events)
Long Term History
Transactional Focus
Large Scale Query Focused
3rd Normal/Dimensional
Dimensional Design
Access: OLTP Tools and EAI
Access: OLAP Tools
Availability: 24x7x365
Availability: Taken Offline