Onsite Seminar
Managing Reference Data for the Enterprise
Reference data – also known as code tables and domain values – represents a strategic data asset for the enterprise, but is rarely managed as such. The perceived structural simplicity, low volumes, and slow rate of change of reference data tend give the impression that its management needs are relatively simple. However, this is not true. Reference data tables typically make up 20-50% of all the tables in any database. Across the enterprise they aggregate to a layer of data that has significant size, overall complexity, and which is always changing. Furthermore, reference data has added importance because it drives business rules, provides reporting dimensions, and categorizes data in ways that may extend beyond the boundaries of the enterprise. Reference data is also used for maintaining subtle data structures hidden with fully normalized database designs.
If reference data is not managed properly it can cause significant issues in data sharing and disrupt system processing. For many enterprises it poses a poorly understood barrier to implementing reliable decision support and integrating operational systems so that transactions can flow between them with low rejection rates.
This class is taught from the perspective of undertaking an enterprise-wide reference data management project. A significant component comes from real-life projects in which the instructor has participated. Both the strategic level and a detailed implementation needs are covered. Exercises and workshops are included.
Objective
What attendees will learn:
- Fundamental concepts that underlie reference data
- Practical real life steps and experiences to manage reference data
Duration
3 days
Course Format
Lecture, group discussion and exercises
Instructor
Malcolm Chisholm
To request a quote for this in-house seminar
Please call (973) 632-0138 or email info@debtechint.com
Return to Onsite Seminars Table of Contents
