尊敬的 微信汇率:1円 ≈ 0.046239 元 支付宝汇率:1円 ≈ 0.04633元 [退出登录]
SlideShare a Scribd company logo
Enterprise Data Management
By Bhaven Chavan
bhaven2001@yahoo.com
6/23/2016
Confidential | 2016
DISCLAIMER
Note: It is understood that the material in this presentation is intended for general information only and should
not be used in relation to any specific application without independent examination and verification of its
applicability and suitability by professionally qualified personnel. Those making use thereof or relying thereon
assume all risk and liability arising from such use or reliance.
6/23/2016
Definition
Enterprise Data Management is:
 Removing organizational data issues and conflicts by defining accurate, consistent and transparent content
 Ability to create , integrate, disseminate and manage data for all enterprise applications
 Requiring timely and accurate data delivery
 Defining structured data delivered strategy- from data producer to data consumer
 It goes hand-in-hand with IT Workable Data Governance practices and collaboratively helps in establishing
governance across the enterprise.
 It acts like framework for leadership, organizational structure, business process, standards, practices etc.
6/23/2016
Confidential | 2016
Current State & Why Now is the right time to address the
challenge
3
• Accurate, Consistent and Transparent content
• Ability to create , integrate, disseminate and manage
data for all enterprise applications
• Timely and Accurate data delivery
• A structured data delivered strategy- from data producer
to data consumer
Today’s Design is not addressing
the foundational needs of
enterprise data
But we are creating a new
reference architecture for
applications which should take
these needs into consideration
PL/SQL and Trigger base
integration
LOG, PQRY &
PRIMEUNIV
MINDRPT
GO
CRO
Export/Import
AIM
PQRY
PRIMEUNIV
CRO
Warehouse
DI
RDS
Affiliate
DI
RDS
Asset
DI
Salesforce
CRM
DI
DI
GOQRY
Oracle
Export/Im
port
DI
Report External Data
DI
CDB
DI
DI
CP
Data Marts
MVs
Report
Report Presentation
Data Layer
Report
Report
Report
Report
6/23/2016
Confidential | 2016
6/23/2016
Important Enterprise Data Management Use Cases
1 Produce True Insights from
True Data
•Accuracy in search and match
•Reduce risk of errors
•Operational
•Analytical
•Single view of trusted data
•Reveal hidden relationships
and patterns
•360-degree enterprise view
of customer/consumer
•Gaines consumer viewership
opportunity
2 Leverage enterprise data
analytics more fully and reliably
•Performance and Scalability
•Real-time delivery of insights
•Consumer behavior
•Predictability
•Trends
•Competitiveness
•Over time scalability
•Minimize downtime
•Improved user experience
•Lower IT costs and expansion
efforts
3 Enable wider use of
enterprise data and analytics
for speed and innovation
•Pre-built Services and Data
Model
•Unify disparate sources of
data
•Extensibility
•Accelerate implementation
•Rapid MDM integration with
an increasing number of data
repositories
4 Evolve business overtime
•Deployment Flexibility
•Support strategic initiatives
•Move across implementation
styles with a single solution
•Accelerate implementation
time
•Increase time to value
Architecture Data Principles
• Accurate, Consistent and Transparent content
• Ability to create , integrate, disseminate and manage data for all enterprise applications
• Timely and Accurate data delivery
• A structured data delivered strategy- from data producer to data consumer
6/23/2016
Confidential | 2016
6/23/2016
 Appropriately define and understand the enterprise data categories within organization
 Understand the current state of data architecture
 Define a future state enterprise data architecture based on founding data management principles
which begins with the “Enterprise Master Data Lineage Architecture”
 Review current application design and understand how the “enterprise data needs” will be addressed
and produce a gap analysis as needed
 Meet Architecture team to provide feedback and seek out methods to address enterprise data
concerns
The Approach
6/23/2016
Confidential | 2016
6/23/2016
Enterprise Data Categories
 Reference Data:
 Is data that defines the set of permissible values to used by other critical business objects or entities. E.g.
Country, Language, Asset Type, Customer type, Customer role etc.
 Master/Critical Data:
 The critical data of a business, such as Asset, Customer, Address etc. that drives other data.
 Data that are shared and used by several of the applications that make up the system/application.
 It fall generally into four groupings:
• People: there are customer, employee, and salesperson.
• Things: there are product, part, store, and asset.
• Concepts: there are things like contract, warrantee, and licenses.
• Places: there are office locations and geographic divisions.
 Less volatile than transactional data.
 It holds key principle of reusability across the enterprise.
6/23/2016
Confidential | 2016
6/23/2016
Enterprise Data Categories Continue….
 Transactional Data:
 A organization’s operations are supported by applications that automate key business process.
 It trends to be more volatile than master data.
 Analytical Data:
 It describes an enterprise’s performance.
 It supports company’s decision making process.
6/23/2016
Confidential | 2016
6/23/2016
Producer
Trusted
Master
Data
Govern
Share
Cleanse
Consolidation
Consumer
High Level Enterprise Master Data Lineage Architecture
Click For Conceptual View
6/23/2016
Confidential | 2016
6/23/2016
OLTP 2
OLTP DB
MDM
Asset
Data Acquisition
Layer
Customer Users Address
MDM Data Layer
Time Asset Customer Address
MDM Dimension Data Layer
Country Language
Reference Data Layer
Master Data Push
Reference Data Push
Master Data Pull/Post
Reference Data Pull
Reference Master
Data Pull
Reference Master
Data Push
• MDM represents the business objects that are shared across more than one transactional
application.
• It represents the business objects around which the transactions are executed.
• It represents the key dimensions around which analytics are done.
• Master data creates a single version of the truth about these objects across the
operational and analytical IT landscape.
Conceptual View of Enterprise MasterData Lineage Architecture
I
n
f
o
r
m
a
t
i
o
n
E
x
c
h
a
n
g
e
H
u
b
OLTP 1
Click For Logical View
Time
Zone
Other
References
6/23/2016
Confidential | 2016
6/23/2016
Logical View of Enterprise Master Data Lineage Architecture
OLTP Asset DB
MDM
Asset
Data Acquisition
Layer
Customer Users Address
MDM Data Layer
Time Asset Customer Address
MDM Dimension Data Layer
Country Language Time
Zone
Reference Data Layer
Other
References
OLTP 1
Information Exchange Hub (a)
Reference
Data pull
OLTP 2
OLTP Asset Extension
DB
Data Acquisition
Layer
Master Data
Push for
MDM
Master
Data Pull
Ref. Data
Push
Master Data
Push For
Downstream
OLTP 3
OLTP Operational DB
Data Acquisition
Layer
Data Lake
UDL DB
Analytical
Data layer
UDL DB
Operational
Data
Dimensional
Data Push For
Analytics
O
p
e
r
a
t
i
o
n
a
l
D
a
t
a
H
u
b
6/23/2016
Confidential | 2016
6/23/2016
Logical View of Enterprise Master Data Lineage Architecture
ForReferenceData…..
OLTP Asset DB
Data Acquisition
Layer
OLTP 1
Reference Data Exchange Hub (a)
Country, Language,..etc.Reference
Data pull
LOTP 2
OLTP Asset Extension
DB
Data Acquisition
Layer
Ref. Data
Push
OLTP 3
OLTP Operational DB
Data Acquisition
Layer
Data Lake
UDL DB
Analytical
Data layer
UDL DB
Operational
Data
O
p
e
r
a
t
i
o
n
a
l
D
a
t
a
H
u
b
MDM
Asset Customer Users Address
MDM Data Layer
Time Asset Customer Address
MDM Dimension Data Layer
Country Language Time
Zone
Reference Data Layer
Other
References
6/23/2016
Confidential | 2016
6/23/2016
Logical View of Enterprise Master Data Lineage Architecture
ForMasterData…..
OLTP Asset DB
RDS
Affiliate
Data Acquisition
Layer
Asset Party Rights
MDM Data Layer
Time
Broadcast
Asset Party Rights
MDM Dimension Data Layer
Country Language DMO
Reference Data Layer
Party
Role
PAM
Information Exchange Hub (a)
PUMA
OLTP Asset Extension
DB
Data Acquisition
Layer
Master Data
Push for
MDM
Master
Data Pull
Master Data
Push For
Downstream
MIND
OLTP Operational DB
Data Acquisition
Layer
Data Lake
UDL DB
Analytical
Data layer
I
n
f
o
r
m
a
t
i
o
n
H
u
b
UDL DB
Operational
Data
OLTP Asset DB
Data Acquisition
Layer
OLTP 1
Master Data Exchange Hub (a)
Asset,Customer,..etc.
OLTP 2
OLTP Asset Extension
DB
Data Acquisition
Layer
Master Data
Push for DM
Master
Data Pull
Master Data
Push For
Downstream
OLTP 3
OLTP Operational DB
Data Acquisition
Layer
Data Lake
UDL DB
Analytical
Data layer
O
p
e
r
a
t
i
o
n
a
l
D
a
t
a
H
u
b
UDL DB
Operational
Data
Dimensional
Data Push For
Analytics
MDM
Asset Customer Users Address
MDM Data Layer
Time Asset Customer Address
MDM Dimension Data Layer
Country Language Time
Zone
Reference Data Layer
Other
References
6/23/2016
Confidential | 2016
Intermission
Q&A
13
Thank You!
bhaven2001@yahoo.com
6/23/2016
Confidential | 2016

More Related Content

What's hot

Choosing technologies for a big data solution in the cloud
Choosing technologies for a big data solution in the cloudChoosing technologies for a big data solution in the cloud
Choosing technologies for a big data solution in the cloud
James Serra
 
Data Architecture Strategies
Data Architecture StrategiesData Architecture Strategies
Data Architecture Strategies
DATAVERSITY
 
Data Quality & Data Governance
Data Quality & Data GovernanceData Quality & Data Governance
Data Quality & Data Governance
Tuba Yaman Him
 
Rethinking Trust in Data
Rethinking Trust in Data Rethinking Trust in Data
Rethinking Trust in Data
DATAVERSITY
 
Enterprise Architecture vs. Data Architecture
Enterprise Architecture vs. Data ArchitectureEnterprise Architecture vs. Data Architecture
Enterprise Architecture vs. Data Architecture
DATAVERSITY
 
Data Governance and Metadata Management
Data Governance and Metadata ManagementData Governance and Metadata Management
Data Governance and Metadata Management
DATAVERSITY
 
Building a Data Strategy Your C-Suite Will Support
Building a Data Strategy Your C-Suite Will SupportBuilding a Data Strategy Your C-Suite Will Support
Building a Data Strategy Your C-Suite Will Support
Reid Colson
 
Building a Data Strategy – Practical Steps for Aligning with Business Goals
Building a Data Strategy – Practical Steps for Aligning with Business GoalsBuilding a Data Strategy – Practical Steps for Aligning with Business Goals
Building a Data Strategy – Practical Steps for Aligning with Business Goals
DATAVERSITY
 
How to Build & Sustain a Data Governance Operating Model
How to Build & Sustain a Data Governance Operating Model How to Build & Sustain a Data Governance Operating Model
How to Build & Sustain a Data Governance Operating Model
DATUM LLC
 
Data Architecture Strategies: Building an Enterprise Data Strategy – Where to...
Data Architecture Strategies: Building an Enterprise Data Strategy – Where to...Data Architecture Strategies: Building an Enterprise Data Strategy – Where to...
Data Architecture Strategies: Building an Enterprise Data Strategy – Where to...
DATAVERSITY
 
Data Architecture - The Foundation for Enterprise Architecture and Governance
Data Architecture - The Foundation for Enterprise Architecture and GovernanceData Architecture - The Foundation for Enterprise Architecture and Governance
Data Architecture - The Foundation for Enterprise Architecture and Governance
DATAVERSITY
 
Becoming a Data-Driven Organization - Aligning Business & Data Strategy
Becoming a Data-Driven Organization - Aligning Business & Data StrategyBecoming a Data-Driven Organization - Aligning Business & Data Strategy
Becoming a Data-Driven Organization - Aligning Business & Data Strategy
DATAVERSITY
 
RWDG Slides: What is a Data Steward to do?
RWDG Slides: What is a Data Steward to do?RWDG Slides: What is a Data Steward to do?
RWDG Slides: What is a Data Steward to do?
DATAVERSITY
 
Master Data Management – Aligning Data, Process, and Governance
Master Data Management – Aligning Data, Process, and GovernanceMaster Data Management – Aligning Data, Process, and Governance
Master Data Management – Aligning Data, Process, and Governance
DATAVERSITY
 
Data Quality
Data QualityData Quality
Data Quality
Vijaya K
 
Activate Data Governance Using the Data Catalog
Activate Data Governance Using the Data CatalogActivate Data Governance Using the Data Catalog
Activate Data Governance Using the Data Catalog
DATAVERSITY
 
Data strategy in a Big Data world
Data strategy in a Big Data worldData strategy in a Big Data world
Data strategy in a Big Data world
Craig Milroy
 
DI&A Slides: Data Lake vs. Data Warehouse
DI&A Slides: Data Lake vs. Data WarehouseDI&A Slides: Data Lake vs. Data Warehouse
DI&A Slides: Data Lake vs. Data Warehouse
DATAVERSITY
 
Data Governance
Data GovernanceData Governance
Data Governance
Rob Lux
 
Data Governance Takes a Village (So Why is Everyone Hiding?)
Data Governance Takes a Village (So Why is Everyone Hiding?)Data Governance Takes a Village (So Why is Everyone Hiding?)
Data Governance Takes a Village (So Why is Everyone Hiding?)
DATAVERSITY
 

What's hot (20)

Choosing technologies for a big data solution in the cloud
Choosing technologies for a big data solution in the cloudChoosing technologies for a big data solution in the cloud
Choosing technologies for a big data solution in the cloud
 
Data Architecture Strategies
Data Architecture StrategiesData Architecture Strategies
Data Architecture Strategies
 
Data Quality & Data Governance
Data Quality & Data GovernanceData Quality & Data Governance
Data Quality & Data Governance
 
Rethinking Trust in Data
Rethinking Trust in Data Rethinking Trust in Data
Rethinking Trust in Data
 
Enterprise Architecture vs. Data Architecture
Enterprise Architecture vs. Data ArchitectureEnterprise Architecture vs. Data Architecture
Enterprise Architecture vs. Data Architecture
 
Data Governance and Metadata Management
Data Governance and Metadata ManagementData Governance and Metadata Management
Data Governance and Metadata Management
 
Building a Data Strategy Your C-Suite Will Support
Building a Data Strategy Your C-Suite Will SupportBuilding a Data Strategy Your C-Suite Will Support
Building a Data Strategy Your C-Suite Will Support
 
Building a Data Strategy – Practical Steps for Aligning with Business Goals
Building a Data Strategy – Practical Steps for Aligning with Business GoalsBuilding a Data Strategy – Practical Steps for Aligning with Business Goals
Building a Data Strategy – Practical Steps for Aligning with Business Goals
 
How to Build & Sustain a Data Governance Operating Model
How to Build & Sustain a Data Governance Operating Model How to Build & Sustain a Data Governance Operating Model
How to Build & Sustain a Data Governance Operating Model
 
Data Architecture Strategies: Building an Enterprise Data Strategy – Where to...
Data Architecture Strategies: Building an Enterprise Data Strategy – Where to...Data Architecture Strategies: Building an Enterprise Data Strategy – Where to...
Data Architecture Strategies: Building an Enterprise Data Strategy – Where to...
 
Data Architecture - The Foundation for Enterprise Architecture and Governance
Data Architecture - The Foundation for Enterprise Architecture and GovernanceData Architecture - The Foundation for Enterprise Architecture and Governance
Data Architecture - The Foundation for Enterprise Architecture and Governance
 
Becoming a Data-Driven Organization - Aligning Business & Data Strategy
Becoming a Data-Driven Organization - Aligning Business & Data StrategyBecoming a Data-Driven Organization - Aligning Business & Data Strategy
Becoming a Data-Driven Organization - Aligning Business & Data Strategy
 
RWDG Slides: What is a Data Steward to do?
RWDG Slides: What is a Data Steward to do?RWDG Slides: What is a Data Steward to do?
RWDG Slides: What is a Data Steward to do?
 
Master Data Management – Aligning Data, Process, and Governance
Master Data Management – Aligning Data, Process, and GovernanceMaster Data Management – Aligning Data, Process, and Governance
Master Data Management – Aligning Data, Process, and Governance
 
Data Quality
Data QualityData Quality
Data Quality
 
Activate Data Governance Using the Data Catalog
Activate Data Governance Using the Data CatalogActivate Data Governance Using the Data Catalog
Activate Data Governance Using the Data Catalog
 
Data strategy in a Big Data world
Data strategy in a Big Data worldData strategy in a Big Data world
Data strategy in a Big Data world
 
DI&A Slides: Data Lake vs. Data Warehouse
DI&A Slides: Data Lake vs. Data WarehouseDI&A Slides: Data Lake vs. Data Warehouse
DI&A Slides: Data Lake vs. Data Warehouse
 
Data Governance
Data GovernanceData Governance
Data Governance
 
Data Governance Takes a Village (So Why is Everyone Hiding?)
Data Governance Takes a Village (So Why is Everyone Hiding?)Data Governance Takes a Village (So Why is Everyone Hiding?)
Data Governance Takes a Village (So Why is Everyone Hiding?)
 

Viewers also liked

Data management principles
Data management principlesData management principles
Data management principles
Fiddy Prasetiya
 
Tic
TicTic
Introducción a la multimedia
Introducción a la multimediaIntroducción a la multimedia
Introducción a la multimedia
lucho moreta
 
TargetStateFutureArchitect - DV
TargetStateFutureArchitect - DVTargetStateFutureArchitect - DV
TargetStateFutureArchitect - DV
Bhavendra Chavan
 
Como hacer compresibles los datos-LUIS MORETA 8C
Como hacer compresibles los datos-LUIS MORETA 8CComo hacer compresibles los datos-LUIS MORETA 8C
Como hacer compresibles los datos-LUIS MORETA 8C
lucho moreta
 
RainFest-Brochure-FINAL-klein kopie
RainFest-Brochure-FINAL-klein kopieRainFest-Brochure-FINAL-klein kopie
RainFest-Brochure-FINAL-klein kopie
Daphne Gerritse
 
Generate Business Leads
Generate Business LeadsGenerate Business Leads
Generate Business Leads
Ritika Jain
 
PIOGG_Chapter_two_s
PIOGG_Chapter_two_sPIOGG_Chapter_two_s
PIOGG_Chapter_two_s
Daphne Gerritse
 
Desarrollo sustentable de uruguay
Desarrollo sustentable de uruguayDesarrollo sustentable de uruguay
Desarrollo sustentable de uruguay
karina tula
 
Put Your Desktop in the Cloud In Support of the Open Government Directive and...
Put Your Desktop in the Cloud In Support of the Open Government Directive and...Put Your Desktop in the Cloud In Support of the Open Government Directive and...
Put Your Desktop in the Cloud In Support of the Open Government Directive and...
guest8c518a8
 
Tridant's Advanced Analytics : Real World Insights
Tridant's Advanced Analytics : Real World InsightsTridant's Advanced Analytics : Real World Insights
Tridant's Advanced Analytics : Real World Insights
Tridant Pty Ltd
 
Workable Enteprise Data Governance
Workable Enteprise Data GovernanceWorkable Enteprise Data Governance
Workable Enteprise Data Governance
Bhavendra Chavan
 
5 Principles of Data Management
5 Principles of Data Management5 Principles of Data Management
5 Principles of Data Management
Paul Bradshaw
 
Main project
Main projectMain project
Main project
Balogun Ibrahim
 
25 Data Principles To Abide By
25 Data Principles To Abide By25 Data Principles To Abide By
25 Data Principles To Abide By
Pravin Nadkarni
 
Understanding SOAP and REST basics and differences
Understanding SOAP and REST basics and differencesUnderstanding SOAP and REST basics and differences
Understanding SOAP and REST basics and differences
Bhavendra Chavan
 
Enterprise architecture framework business case
Enterprise architecture framework business caseEnterprise architecture framework business case
Enterprise architecture framework business case
Alex Antonatos
 
Botanica aplicada 1
Botanica aplicada 1Botanica aplicada 1
Botanica aplicada 1
Yadira Avalos
 
Data Architecture for Data Governance
Data Architecture for Data GovernanceData Architecture for Data Governance
Data Architecture for Data Governance
DATAVERSITY
 
How to Realize Benefits from Data Management Maturity Models
How to Realize Benefits from Data Management Maturity ModelsHow to Realize Benefits from Data Management Maturity Models
How to Realize Benefits from Data Management Maturity Models
Kingland
 

Viewers also liked (20)

Data management principles
Data management principlesData management principles
Data management principles
 
Tic
TicTic
Tic
 
Introducción a la multimedia
Introducción a la multimediaIntroducción a la multimedia
Introducción a la multimedia
 
TargetStateFutureArchitect - DV
TargetStateFutureArchitect - DVTargetStateFutureArchitect - DV
TargetStateFutureArchitect - DV
 
Como hacer compresibles los datos-LUIS MORETA 8C
Como hacer compresibles los datos-LUIS MORETA 8CComo hacer compresibles los datos-LUIS MORETA 8C
Como hacer compresibles los datos-LUIS MORETA 8C
 
RainFest-Brochure-FINAL-klein kopie
RainFest-Brochure-FINAL-klein kopieRainFest-Brochure-FINAL-klein kopie
RainFest-Brochure-FINAL-klein kopie
 
Generate Business Leads
Generate Business LeadsGenerate Business Leads
Generate Business Leads
 
PIOGG_Chapter_two_s
PIOGG_Chapter_two_sPIOGG_Chapter_two_s
PIOGG_Chapter_two_s
 
Desarrollo sustentable de uruguay
Desarrollo sustentable de uruguayDesarrollo sustentable de uruguay
Desarrollo sustentable de uruguay
 
Put Your Desktop in the Cloud In Support of the Open Government Directive and...
Put Your Desktop in the Cloud In Support of the Open Government Directive and...Put Your Desktop in the Cloud In Support of the Open Government Directive and...
Put Your Desktop in the Cloud In Support of the Open Government Directive and...
 
Tridant's Advanced Analytics : Real World Insights
Tridant's Advanced Analytics : Real World InsightsTridant's Advanced Analytics : Real World Insights
Tridant's Advanced Analytics : Real World Insights
 
Workable Enteprise Data Governance
Workable Enteprise Data GovernanceWorkable Enteprise Data Governance
Workable Enteprise Data Governance
 
5 Principles of Data Management
5 Principles of Data Management5 Principles of Data Management
5 Principles of Data Management
 
Main project
Main projectMain project
Main project
 
25 Data Principles To Abide By
25 Data Principles To Abide By25 Data Principles To Abide By
25 Data Principles To Abide By
 
Understanding SOAP and REST basics and differences
Understanding SOAP and REST basics and differencesUnderstanding SOAP and REST basics and differences
Understanding SOAP and REST basics and differences
 
Enterprise architecture framework business case
Enterprise architecture framework business caseEnterprise architecture framework business case
Enterprise architecture framework business case
 
Botanica aplicada 1
Botanica aplicada 1Botanica aplicada 1
Botanica aplicada 1
 
Data Architecture for Data Governance
Data Architecture for Data GovernanceData Architecture for Data Governance
Data Architecture for Data Governance
 
How to Realize Benefits from Data Management Maturity Models
How to Realize Benefits from Data Management Maturity ModelsHow to Realize Benefits from Data Management Maturity Models
How to Realize Benefits from Data Management Maturity Models
 

Similar to Enterprise Data Management

Big Data Evolution
Big Data EvolutionBig Data Evolution
Big Data Evolution
itnewsafrica
 
Data Mesh in Azure using Cloud Scale Analytics (WAF)
Data Mesh in Azure using Cloud Scale Analytics (WAF)Data Mesh in Azure using Cloud Scale Analytics (WAF)
Data Mesh in Azure using Cloud Scale Analytics (WAF)
Nathan Bijnens
 
Sgcp14dunlea
Sgcp14dunleaSgcp14dunlea
Sgcp14dunlea
Justin Hayward
 
Implementar una estrategia eficiente de gobierno y seguridad del dato con la ...
Implementar una estrategia eficiente de gobierno y seguridad del dato con la ...Implementar una estrategia eficiente de gobierno y seguridad del dato con la ...
Implementar una estrategia eficiente de gobierno y seguridad del dato con la ...
Denodo
 
How a Logical Data Fabric Enhances the Customer 360 View
How a Logical Data Fabric Enhances the Customer 360 ViewHow a Logical Data Fabric Enhances the Customer 360 View
How a Logical Data Fabric Enhances the Customer 360 View
Denodo
 
Data Profiling: The First Step to Big Data Quality
Data Profiling: The First Step to Big Data QualityData Profiling: The First Step to Big Data Quality
Data Profiling: The First Step to Big Data Quality
Precisely
 
Financial Services - New Approach to Data Management in the Digital Era
Financial Services - New Approach to Data Management in the Digital EraFinancial Services - New Approach to Data Management in the Digital Era
Financial Services - New Approach to Data Management in the Digital Era
accenture
 
Fuel your Data-Driven Ambitions with Data Governance
Fuel your Data-Driven Ambitions with Data GovernanceFuel your Data-Driven Ambitions with Data Governance
Fuel your Data-Driven Ambitions with Data Governance
Pedro Martins
 
Credit Suisse: Multi-Domain Enterprise Reference Data
Credit Suisse: Multi-Domain Enterprise Reference DataCredit Suisse: Multi-Domain Enterprise Reference Data
Credit Suisse: Multi-Domain Enterprise Reference Data
Orchestra Networks
 
Big Data Analytics Architecture Powerpoint Presentation Slides
Big Data Analytics Architecture Powerpoint Presentation SlidesBig Data Analytics Architecture Powerpoint Presentation Slides
Big Data Analytics Architecture Powerpoint Presentation Slides
SlideTeam
 
Modern Data Challenges require Modern Graph Technology
Modern Data Challenges require Modern Graph TechnologyModern Data Challenges require Modern Graph Technology
Modern Data Challenges require Modern Graph Technology
Neo4j
 
¿En qué se parece el Gobierno del Dato a un parque de atracciones?
¿En qué se parece el Gobierno del Dato a un parque de atracciones?¿En qué se parece el Gobierno del Dato a un parque de atracciones?
¿En qué se parece el Gobierno del Dato a un parque de atracciones?
Denodo
 
Big Data Analytics Architecture PowerPoint Presentation Slides
Big Data Analytics Architecture PowerPoint Presentation SlidesBig Data Analytics Architecture PowerPoint Presentation Slides
Big Data Analytics Architecture PowerPoint Presentation Slides
SlideTeam
 
Denodo’s Data Catalog: Bridging the Gap between Data and Business (APAC)
Denodo’s Data Catalog: Bridging the Gap between Data and Business (APAC)Denodo’s Data Catalog: Bridging the Gap between Data and Business (APAC)
Denodo’s Data Catalog: Bridging the Gap between Data and Business (APAC)
Denodo
 
DataSpryng Overview
DataSpryng OverviewDataSpryng Overview
DataSpryng Overview
jkvr
 
Achieving a Single View of Business – Critical Data with Master Data Management
Achieving a Single View of Business – Critical Data with Master Data ManagementAchieving a Single View of Business – Critical Data with Master Data Management
Achieving a Single View of Business – Critical Data with Master Data Management
DATAVERSITY
 
How Can You Calculate the Cost of Your Data?
How Can You Calculate the Cost of Your Data?How Can You Calculate the Cost of Your Data?
How Can You Calculate the Cost of Your Data?
DATAVERSITY
 
Increasing Agility Through Data Virtualization
Increasing Agility Through Data VirtualizationIncreasing Agility Through Data Virtualization
Increasing Agility Through Data Virtualization
Denodo
 
Buyer's guide to strategic analytics
Buyer's guide to strategic analyticsBuyer's guide to strategic analytics
Buyer's guide to strategic analytics
The Marketing Distillery
 
02 a holistic approach to big data
02 a holistic approach to big data02 a holistic approach to big data
02 a holistic approach to big data
Raul Chong
 

Similar to Enterprise Data Management (20)

Big Data Evolution
Big Data EvolutionBig Data Evolution
Big Data Evolution
 
Data Mesh in Azure using Cloud Scale Analytics (WAF)
Data Mesh in Azure using Cloud Scale Analytics (WAF)Data Mesh in Azure using Cloud Scale Analytics (WAF)
Data Mesh in Azure using Cloud Scale Analytics (WAF)
 
Sgcp14dunlea
Sgcp14dunleaSgcp14dunlea
Sgcp14dunlea
 
Implementar una estrategia eficiente de gobierno y seguridad del dato con la ...
Implementar una estrategia eficiente de gobierno y seguridad del dato con la ...Implementar una estrategia eficiente de gobierno y seguridad del dato con la ...
Implementar una estrategia eficiente de gobierno y seguridad del dato con la ...
 
How a Logical Data Fabric Enhances the Customer 360 View
How a Logical Data Fabric Enhances the Customer 360 ViewHow a Logical Data Fabric Enhances the Customer 360 View
How a Logical Data Fabric Enhances the Customer 360 View
 
Data Profiling: The First Step to Big Data Quality
Data Profiling: The First Step to Big Data QualityData Profiling: The First Step to Big Data Quality
Data Profiling: The First Step to Big Data Quality
 
Financial Services - New Approach to Data Management in the Digital Era
Financial Services - New Approach to Data Management in the Digital EraFinancial Services - New Approach to Data Management in the Digital Era
Financial Services - New Approach to Data Management in the Digital Era
 
Fuel your Data-Driven Ambitions with Data Governance
Fuel your Data-Driven Ambitions with Data GovernanceFuel your Data-Driven Ambitions with Data Governance
Fuel your Data-Driven Ambitions with Data Governance
 
Credit Suisse: Multi-Domain Enterprise Reference Data
Credit Suisse: Multi-Domain Enterprise Reference DataCredit Suisse: Multi-Domain Enterprise Reference Data
Credit Suisse: Multi-Domain Enterprise Reference Data
 
Big Data Analytics Architecture Powerpoint Presentation Slides
Big Data Analytics Architecture Powerpoint Presentation SlidesBig Data Analytics Architecture Powerpoint Presentation Slides
Big Data Analytics Architecture Powerpoint Presentation Slides
 
Modern Data Challenges require Modern Graph Technology
Modern Data Challenges require Modern Graph TechnologyModern Data Challenges require Modern Graph Technology
Modern Data Challenges require Modern Graph Technology
 
¿En qué se parece el Gobierno del Dato a un parque de atracciones?
¿En qué se parece el Gobierno del Dato a un parque de atracciones?¿En qué se parece el Gobierno del Dato a un parque de atracciones?
¿En qué se parece el Gobierno del Dato a un parque de atracciones?
 
Big Data Analytics Architecture PowerPoint Presentation Slides
Big Data Analytics Architecture PowerPoint Presentation SlidesBig Data Analytics Architecture PowerPoint Presentation Slides
Big Data Analytics Architecture PowerPoint Presentation Slides
 
Denodo’s Data Catalog: Bridging the Gap between Data and Business (APAC)
Denodo’s Data Catalog: Bridging the Gap between Data and Business (APAC)Denodo’s Data Catalog: Bridging the Gap between Data and Business (APAC)
Denodo’s Data Catalog: Bridging the Gap between Data and Business (APAC)
 
DataSpryng Overview
DataSpryng OverviewDataSpryng Overview
DataSpryng Overview
 
Achieving a Single View of Business – Critical Data with Master Data Management
Achieving a Single View of Business – Critical Data with Master Data ManagementAchieving a Single View of Business – Critical Data with Master Data Management
Achieving a Single View of Business – Critical Data with Master Data Management
 
How Can You Calculate the Cost of Your Data?
How Can You Calculate the Cost of Your Data?How Can You Calculate the Cost of Your Data?
How Can You Calculate the Cost of Your Data?
 
Increasing Agility Through Data Virtualization
Increasing Agility Through Data VirtualizationIncreasing Agility Through Data Virtualization
Increasing Agility Through Data Virtualization
 
Buyer's guide to strategic analytics
Buyer's guide to strategic analyticsBuyer's guide to strategic analytics
Buyer's guide to strategic analytics
 
02 a holistic approach to big data
02 a holistic approach to big data02 a holistic approach to big data
02 a holistic approach to big data
 

Enterprise Data Management

  • 1. Enterprise Data Management By Bhaven Chavan bhaven2001@yahoo.com 6/23/2016 Confidential | 2016 DISCLAIMER Note: It is understood that the material in this presentation is intended for general information only and should not be used in relation to any specific application without independent examination and verification of its applicability and suitability by professionally qualified personnel. Those making use thereof or relying thereon assume all risk and liability arising from such use or reliance.
  • 2. 6/23/2016 Definition Enterprise Data Management is:  Removing organizational data issues and conflicts by defining accurate, consistent and transparent content  Ability to create , integrate, disseminate and manage data for all enterprise applications  Requiring timely and accurate data delivery  Defining structured data delivered strategy- from data producer to data consumer  It goes hand-in-hand with IT Workable Data Governance practices and collaboratively helps in establishing governance across the enterprise.  It acts like framework for leadership, organizational structure, business process, standards, practices etc. 6/23/2016 Confidential | 2016
  • 3. Current State & Why Now is the right time to address the challenge 3 • Accurate, Consistent and Transparent content • Ability to create , integrate, disseminate and manage data for all enterprise applications • Timely and Accurate data delivery • A structured data delivered strategy- from data producer to data consumer Today’s Design is not addressing the foundational needs of enterprise data But we are creating a new reference architecture for applications which should take these needs into consideration PL/SQL and Trigger base integration LOG, PQRY & PRIMEUNIV MINDRPT GO CRO Export/Import AIM PQRY PRIMEUNIV CRO Warehouse DI RDS Affiliate DI RDS Asset DI Salesforce CRM DI DI GOQRY Oracle Export/Im port DI Report External Data DI CDB DI DI CP Data Marts MVs Report Report Presentation Data Layer Report Report Report Report 6/23/2016 Confidential | 2016
  • 4. 6/23/2016 Important Enterprise Data Management Use Cases 1 Produce True Insights from True Data •Accuracy in search and match •Reduce risk of errors •Operational •Analytical •Single view of trusted data •Reveal hidden relationships and patterns •360-degree enterprise view of customer/consumer •Gaines consumer viewership opportunity 2 Leverage enterprise data analytics more fully and reliably •Performance and Scalability •Real-time delivery of insights •Consumer behavior •Predictability •Trends •Competitiveness •Over time scalability •Minimize downtime •Improved user experience •Lower IT costs and expansion efforts 3 Enable wider use of enterprise data and analytics for speed and innovation •Pre-built Services and Data Model •Unify disparate sources of data •Extensibility •Accelerate implementation •Rapid MDM integration with an increasing number of data repositories 4 Evolve business overtime •Deployment Flexibility •Support strategic initiatives •Move across implementation styles with a single solution •Accelerate implementation time •Increase time to value Architecture Data Principles • Accurate, Consistent and Transparent content • Ability to create , integrate, disseminate and manage data for all enterprise applications • Timely and Accurate data delivery • A structured data delivered strategy- from data producer to data consumer 6/23/2016 Confidential | 2016
  • 5. 6/23/2016  Appropriately define and understand the enterprise data categories within organization  Understand the current state of data architecture  Define a future state enterprise data architecture based on founding data management principles which begins with the “Enterprise Master Data Lineage Architecture”  Review current application design and understand how the “enterprise data needs” will be addressed and produce a gap analysis as needed  Meet Architecture team to provide feedback and seek out methods to address enterprise data concerns The Approach 6/23/2016 Confidential | 2016
  • 6. 6/23/2016 Enterprise Data Categories  Reference Data:  Is data that defines the set of permissible values to used by other critical business objects or entities. E.g. Country, Language, Asset Type, Customer type, Customer role etc.  Master/Critical Data:  The critical data of a business, such as Asset, Customer, Address etc. that drives other data.  Data that are shared and used by several of the applications that make up the system/application.  It fall generally into four groupings: • People: there are customer, employee, and salesperson. • Things: there are product, part, store, and asset. • Concepts: there are things like contract, warrantee, and licenses. • Places: there are office locations and geographic divisions.  Less volatile than transactional data.  It holds key principle of reusability across the enterprise. 6/23/2016 Confidential | 2016
  • 7. 6/23/2016 Enterprise Data Categories Continue….  Transactional Data:  A organization’s operations are supported by applications that automate key business process.  It trends to be more volatile than master data.  Analytical Data:  It describes an enterprise’s performance.  It supports company’s decision making process. 6/23/2016 Confidential | 2016
  • 8. 6/23/2016 Producer Trusted Master Data Govern Share Cleanse Consolidation Consumer High Level Enterprise Master Data Lineage Architecture Click For Conceptual View 6/23/2016 Confidential | 2016
  • 9. 6/23/2016 OLTP 2 OLTP DB MDM Asset Data Acquisition Layer Customer Users Address MDM Data Layer Time Asset Customer Address MDM Dimension Data Layer Country Language Reference Data Layer Master Data Push Reference Data Push Master Data Pull/Post Reference Data Pull Reference Master Data Pull Reference Master Data Push • MDM represents the business objects that are shared across more than one transactional application. • It represents the business objects around which the transactions are executed. • It represents the key dimensions around which analytics are done. • Master data creates a single version of the truth about these objects across the operational and analytical IT landscape. Conceptual View of Enterprise MasterData Lineage Architecture I n f o r m a t i o n E x c h a n g e H u b OLTP 1 Click For Logical View Time Zone Other References 6/23/2016 Confidential | 2016
  • 10. 6/23/2016 Logical View of Enterprise Master Data Lineage Architecture OLTP Asset DB MDM Asset Data Acquisition Layer Customer Users Address MDM Data Layer Time Asset Customer Address MDM Dimension Data Layer Country Language Time Zone Reference Data Layer Other References OLTP 1 Information Exchange Hub (a) Reference Data pull OLTP 2 OLTP Asset Extension DB Data Acquisition Layer Master Data Push for MDM Master Data Pull Ref. Data Push Master Data Push For Downstream OLTP 3 OLTP Operational DB Data Acquisition Layer Data Lake UDL DB Analytical Data layer UDL DB Operational Data Dimensional Data Push For Analytics O p e r a t i o n a l D a t a H u b 6/23/2016 Confidential | 2016
  • 11. 6/23/2016 Logical View of Enterprise Master Data Lineage Architecture ForReferenceData….. OLTP Asset DB Data Acquisition Layer OLTP 1 Reference Data Exchange Hub (a) Country, Language,..etc.Reference Data pull LOTP 2 OLTP Asset Extension DB Data Acquisition Layer Ref. Data Push OLTP 3 OLTP Operational DB Data Acquisition Layer Data Lake UDL DB Analytical Data layer UDL DB Operational Data O p e r a t i o n a l D a t a H u b MDM Asset Customer Users Address MDM Data Layer Time Asset Customer Address MDM Dimension Data Layer Country Language Time Zone Reference Data Layer Other References 6/23/2016 Confidential | 2016
  • 12. 6/23/2016 Logical View of Enterprise Master Data Lineage Architecture ForMasterData….. OLTP Asset DB RDS Affiliate Data Acquisition Layer Asset Party Rights MDM Data Layer Time Broadcast Asset Party Rights MDM Dimension Data Layer Country Language DMO Reference Data Layer Party Role PAM Information Exchange Hub (a) PUMA OLTP Asset Extension DB Data Acquisition Layer Master Data Push for MDM Master Data Pull Master Data Push For Downstream MIND OLTP Operational DB Data Acquisition Layer Data Lake UDL DB Analytical Data layer I n f o r m a t i o n H u b UDL DB Operational Data OLTP Asset DB Data Acquisition Layer OLTP 1 Master Data Exchange Hub (a) Asset,Customer,..etc. OLTP 2 OLTP Asset Extension DB Data Acquisition Layer Master Data Push for DM Master Data Pull Master Data Push For Downstream OLTP 3 OLTP Operational DB Data Acquisition Layer Data Lake UDL DB Analytical Data layer O p e r a t i o n a l D a t a H u b UDL DB Operational Data Dimensional Data Push For Analytics MDM Asset Customer Users Address MDM Data Layer Time Asset Customer Address MDM Dimension Data Layer Country Language Time Zone Reference Data Layer Other References 6/23/2016 Confidential | 2016
  翻译: