Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Microsoft SQL Server 2008 R2 Master Data Services
  • Table Of Contents Toc
Microsoft SQL Server 2008 R2 Master Data Services

Microsoft SQL Server 2008 R2 Master Data Services

4.3 (4)
close
close
Microsoft SQL Server 2008 R2 Master Data Services

Microsoft SQL Server 2008 R2 Master Data Services

4.3 (4)

Overview of this book

Table of Contents (18 chapters)
close
close
Microsoft SQL Server 2008 R2 Master Data Services
Credits
Foreword
About the Authors
About the Reviewers
www.PacktPub.com
Preface
1
Index

Data governance


As we've seen, an MDM solution can incorporate some sophisticated automated functions to assist in delivering master data to the business. However, technology alone cannot ensure the success of an MDM program. Processes must be followed in order to ensure that the MDM solution doesn't fall into the same trap that required its creation in the first place. Data Governance is the method for ensuring this—a framework that defines how master data can be used within the organization.

The idea behind using data governance for MDM is to ensure that the use of master data follows specific rules, policies, and procedures that tie in with the organization's overall strategic objectives. The rules that are set in place typically cover the following areas of the MDM program:

  • Data ownership—Defines who has overall responsibility for a given master data entity.

  • Change management—Defines the approval process for changes to the use of master data, or changes to the MDM technology solution itself.

  • Data access—Who can access the master data? This will include procedures for adding new users to the MDM solution.

  • Data modification—A set of rules that govern how inserts, updates and deletes can happen for master data. This may also dictate what is to happen in the event of an update conflict.

  • Data quality standards—Defines and monitors the overall data quality standards for the MDM program.

  • Disaster recovery—A set of procedures for defining how the master data repository is made available in the event of a disaster. As the MDM program gains traction in the organization, this is a key area to address, as the MDM solution itself becomes a key operational system.

  • Data privacy and retention—States how confidential and sensitive data is managed and how long data is retained.

The physical deliverable for data governance in MDM is a set of documents that clearly define the above rules and standards. These documents should be made available to the relevant people in the organization, according to the organization's standard document management policy, for example, SharePoint.

MDM policies and procedures are set up and enforced by a group within the organization known as the Data Governance Board. The Data Governance Board is working group within the organization that will meet on a regular basis to make decisions according to the policy. For example, the organization may be developing a new in-house Marketing system that will assist with campaign management. The stakeholders of this system wish to take a feed of Customer data from the MDM database, which must be approved via the Data Governance program.

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Microsoft SQL Server 2008 R2 Master Data Services
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon