MDM and Data Governance
MDM and Data Governance
MDM and Data Governance
SoberIT
Software Business and Engineering Institute
Lecture Contents
Master Data Management, lecture (40 min)
SOA Characteristics and MDM, group work (60 min)
Break (5 min)
Data Governance, lecture (40 min)
Review of Data Governance article (30 min)
SoberIT
Software Business and Engineering Institute
MASTER DATA
MANAGEMENT
HELSINKI UNIVERSITY OF TECHNOLOGY
SoberIT
Software Business and Engineering Institute
Master Data
Master data can be defined as the data that has
been cleansed, rationalized, and integrated into
an enterprise-wide system of record for core
business activities.
Berson & Dubov (2007)
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
MDM System
Provides mechanisms for consistent use of
master data across the organization
Provides a consistent understanding and trust of
master data entities
Is designed to accommodate and manage
change
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
Methods of Use
Collaborative Authoring
MDM System coordinates a group of users and systems
in order to reach agreement on a set of master data.
Operational
MDM System participates in the operational
transactions and business processes of the enterprise,
interacting with other application systems and people.
Analytical
MDM System is a source of authoritative information
for downstream analytical systems, and sometimes is a
source of insight itself.
HELSINKI UNIVERSITY OF TECHNOLOGY
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
Convergent
Two-phase commit
transactions
Costly in terms of
performance, complexity
and availability
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
A trusted source to
downstream systems for
reporting and analytics, or as a
system of reference to other
operational applications
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
Registry
What
Maintain thin
system of record
with links to more
complete data
spread across
systems; useful for
realtime reference
Benefits
Complete view is
assembled as
needed; fast to
build
Read-mostly; may
be more complex
to manage
Methods of Analytical
use
Operational
System of
Reference
Reference
Coexistence
Transactional
Hub
Manage single view Manage single view
of master data,
of master data,
synchronizing
providing access
changes with other via services
systems
Assumes existing
systems
unchanged, yet
provides read-write
management
Not always
consistent with
other systems
Collaborative,
Operational,
Analytical
Reference
Collaborative,
Operational,
Analytical
Record
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
Registry Hub
Coexistence Hub
Transaction Hub
Purpose
Central reference
Harmonization
Transactional access
System Type
System of reference
System of reference
System of record
Method of Use
(Analytical,
collaborative),
operational
Analytical, collaborative,
operational
Analytical, collaborative,
operational
Master Data
Stored in legacy
systems, but can be
consistently viewed and
derived through linkage
to master data in these
legacy systems
Type of
Access/Transactions
SoberIT
Software Business and Engineering Institute
Registry Hub
Coexistence Hub
Transaction Hub
Correctness
Completeness
Consistency
No consistency: Master
data remains
inconsistent in legacy
systems
Converging to absolute
consistency: Transactions
are invoked only through
MDM services of MDM
System and propagated
to consuming
applications
(asynchronously or
synchronously)
Converging consistency:
Multiple legacy and MDM
System are updated;
conflicts require
resolution
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
Service-Oriented Architecture
SoberIT
Software Business and Engineering Institute
Service reuse
Service granularity
Service composability
SoberIT
Software Business and Engineering Institute
DATA GOVERNANCE
SoberIT
Software Business and Engineering Institute
Governance
Scope
People &
Roles
Monitoring
Governance
Responsibilities
Policies &
Procedures
SoberIT
Software Business and Engineering Institute
Governance in IT
Mature IT organizations have a set of processes, policies, and
procedures related to IT architecture, including:
Defining architectural components, behaviors, interfaces,
and integration
Getting approval of the architecture
Ensuring that the IT infrastructure and applications align
with architecture standards
Requesting changes to the components to accommodate
new application requirements or emerging technologies
Granting variances to application architects and owners
for all or part of the architectural requirements
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
CobiT Example:
DS11 Manage Data Process Description
Control over the IT process of
Manage data
that satisfies the business requirement for IT of
optimising the use of information and ensuring that information is available as required
by focusing on
maintaining the completeness, accuracy, availability and protection of data
is achieved by
Number of incidents where sensitive data were retrieved after media were
disposed
SoberIT
Software Business and Engineering Institute
Verify that all data expected for processing are received and processed completely, accurately and in a
timely manner, and all output is delivered in accordance with business requirements. Support restart and
reprocessing needs.
Define and implement procedures for effective and efficient data storage, retention and archiving to meet
business objectives, the organisations security policy and regulatory requirements.
Define and implement procedures to maintain an inventory of stored and archived media to ensure their
usability and integrity.
DS11.4 Disposal
Define and implement procedures to ensure that business requirements for protection of sensitive data
and software are met when data and hardware are disposed or transferred.
Define and implement procedures for backup and restoration of systems, applications, data and
documentation in line with business requirements and the continuity plan.
Define and implement policies and procedures to identify and apply security requirements applicable to
the receipt, processing, storage and output of data to meet business objectives, the organisations
security policy and regulatory requirements.
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
Data Governance
Touches Both
Business and IT
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
1 Develop a
value statement
2 Prepare
a roadmap
3 Plan and
fund
4 Design
the
program
5 Deploy
the
program
6 Govern
the data
7 Monitor,
measure,
report
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
Data-Related Rules
Policies
Standards
Guidelines
Requirements
Golden Copy
designations
Guiding Principles
System of Record
designations
Business Rules
etc.
SoberIT
Software Business and Engineering Institute
Ha ha!
SoberIT
Software Business and Engineering Institute
Considerations
Current State
Future Vision
SoberIT
Software Business and Engineering Institute
Post-Compliance Paradigm
For efforts with a compliance requirement, the
work is not finished until we
1. Do the work
2. Control it
3. Document it, and then
4. Prove compliance.
Source: http://www.tdan.com/view-special-features/5356
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
Source: Deloitte
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
7.
Resolving Issues
8.
9.
5. Managing Change
6. Defining Data
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
Ha ha!
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
SoberIT
Software Business and Engineering Institute
Description
Organizational Structures
and Awareness
Describes the level of mutual responsibility between business and IT for data
governance, and recognition of the fiduciary responsibility to govern data at different
levels of management.
Stewardship
Policy
Value Creation
The methods used to measure, improve, and certify the quality and integrity of
product, test, and archival data.
The methods and tools used to create common semantic definitions for business and
IT terms, data models, types, and repositories. Metadata is information that bridges
human and computer understanding.
Information Lifecycle
A systematic, policy-based approach to information collection, use, retention, and
Management
deletion.
Audit,HELSINKI
Logging, UNIVERSITY
and
TheTECHNOLOGY
organizational processes for monitoring the data value, risks, and efficacy of
OF
Reporting
governance.
Source: the IBM Data Governance Council
SoberIT
Software Business and Engineering Institute
Homework Questions
Please read Kristin Wendes paper A Model for Data Governance
Organising Accountabilities for Data Quality Management and answer
to the following questions:
1.
2.
3.
How would you map the data quality roles to the three DQM layers
Strategy, Organisation and Information Systems?
4.
SoberIT
Software Business and Engineering Institute
2.
3.
5.
8.
7
8
Down
EclipseCrossword.com
1.
4.
Information as a service
6.
7.
SoberIT
Software Business and Engineering Institute
References
SoberIT
Software Business and Engineering Institute
Online References
http://www.deloitte.com/dtt/cda/doc/content/us_consulting_im_dmrev_0606.pdf
http://www.cio.com/article/114750/Six_Steps_to_Data_Governance_Success
http://www.datagovernance.com/dgi_framework.pdf
http://www.datagovernance.com/wp_how_to_use_the_dgi_data_governance_framework.pdf