EDUCATIONAL SERVICES
MANAGING DATA INTEGRITY WORKSHOP

ABSTRACT
This seminar is intended to provide Business and Information Systems professionals an understanding of what Information and Data Integrity is, HOW to manage Data Integrity across the Enterprise, how to build the Knowledge Repository, how to use Information Directory to deliver Metadata to corporate business and IT users and how this initiative impacts an organization. Also taught are the implementation strategy alternatives.

AUDIENCE
Business and IT managers involved in approving and justifying or planning a managed data integrity across the Enterprise. Anyone involved in the design, development, implementation data management functions, including project managers. Quality Assurance specialists, System and Business architects, data modelers, DBAs, Application and System Support managers.

IT Mission

Implement Quality Information Systems That Support The Enterprise

Zachman's Information System Architecture Framework

• Data, Function, Communication, Users, Cycles
• What is Information Integrity?
• Managing Information Integrity - What It Takes

Information Integrity Issues

• No Common Definitions
• Missing And Invalid Data Values
• Inconsistent Values For Common Data Elements
• Inconsistent Formats Of Data
• Inconsistent Naming
• Lack Of Security To Safeguard Integrity Of Data

Strategy of Implementing Information Integrity

• Identify Scope
• Understand And Document Business Rules
• Collect Common Data Elements
• Prepare Elements For Business Rule Analysis And Violations
• Track Violations Of Business Rules
• Manage Business Rules Via FORUM
• Communicate Violations To Business Owner And IT
• Issue Correctional Transaction Or Data Transfer
• Build Knowledge Repository
• Track/Measure Progress

What is Metadata?

• Business Metadata
• System Metadata
• Corporate Information Services Metadata

The Role of Information Directory Tools Required to Manage Information Integrity

• Repository/CASE
• Technology Maps
• Acquisition, Transformation
• Cleansing
• Scheduling
• Validation
• Information Delivery
• Middleware
• DBMS

Skills Required

• Business Skills
• IT Skills

Measuring Integrity Progress

• Ten Measures used to track information integrity progress

Implementation Methodology

• Time Boxes
• Evolutionary
• Critical Success Factors

Real Time Demonstration of Tools and Industry

• Applications
• Reporting Visualization And Ad-hoc Tools
• Data Acquisition Tools
• OLAP, ROLAP Tools
• Data Mining Tools
• Geographic Information Systems (GIS)
• Detect And Alert Tools
• Information Directory/Catalogs
• CASE/Data Modeling Tools