Skip to Main Content
Information Quality Applied: Best Practices for Improving Business Information, Processes and Systems
book

Information Quality Applied: Best Practices for Improving Business Information, Processes and Systems

by Larry P. English
October 2009
Beginner to intermediate content levelBeginner to intermediate
839 pages
29h 16m
English
Wiley
Content preview from Information Quality Applied: Best Practices for Improving Business Information, Processes and Systems
Chapter 8 n Data Correction and Controlling Data Redundancy 347
PARTICIPANT IQ ACTIVITY ROLE
Business
Information Steward
Ensures the Completeness, Correctness, and Clarity of the Data
Definition, Valid Value Sets, and Business Rule Specification.
Information
Architect
Develops the Information Model and attributes to support
the standardized data parsed from overloaded attributes.
Techniques and Tools for Step P5.4
Information Standards:
■n
Used to guide the standardization process. Often
these will be updated with the various data correction initiatives as over-
loaded data elements are discovered.
Modeling Software with Matrix Facility:
■n
Used to document the nonstan-
dard data to standardized data that is correctly named and defined
Business Rule Discovery Software:
■n
Used to find patterns in the data that
lead to standardization and atomic data values
Data Transformation and Data Correction Software:
■n
Used to electroni-
cally parse the data into atomic-level facts
Facilitated Data Definition Workshop:
■n
Used to ensure that data is identified,
named, and defined in a standard way, that is correct, complete and clear
Step P5.4: Process Steps and Guidelines
1. Identify the data elements that require parsing. These will include data ele-
ments that have been overloaded like Person Name, Address, and Product
Code such as Catalog Code or VIN (vehicle Identification Number).
This enables better ma
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Improving Data Warehouse and Business Information Quality: Methods for Reducing Costs and Increasing Profits

Improving Data Warehouse and Business Information Quality: Methods for Reducing Costs and Increasing Profits

Larry P. English
Information Quality

Information Quality

Ron S. Kenett, Galit Shmueli
Business Metadata: Capturing Enterprise Knowledge

Business Metadata: Capturing Enterprise Knowledge

W.H. Inmon, Bonnie O'Neil, Lowell Fryman

Publisher Resources

ISBN: 9780470134474Purchase book