Data Quality: The Accuracy Dimension
An informative resource for any data management staff, IT management staff, and CIOs of companies with data assets.
TABLE OF CONTENTS Data Quality: The Accuracy Dimension
Appendix B: Content of a Data Profiling Repository
This appendix lists information that can be included in a data profiling repository. This demonstrates the information that needs to be collected and maintained in order to record and demonstrate everything you need to know about a data source. This information is invaluable for use on application modifications or intended new uses. A specific organization may find additional information that can be added to this list to make it even more comprehensive.
Some of this information could be transferred to a formal metadata repository for permanent storage. However, be aware that formal repositories do not have constructs for all of the information listed in this appendix.
B.1 Schema Definition
-
Identification of the collection of data that is profiled together
-
Business description
-
Data steward
-
Business analysts with knowledge of objects
B.2 Business Objects
-
Name
-
Business description
-
Tables used to store object data
-
Data model of business object
B.3 Domains
-
Name
-
Description
-
Data type
-
Length boundaries
-
Numeric precision
-
Value properties
-
Discrete value list
-
Encoded value meanings
-
-
Range of values permitted
-
Skip-over rule
-
-
Character patterns required
-
Character set
-
Character exclusions
-
Text field restrictions
-
B.4 Data Source
-
Type IMS/VSAM/ORACLE/
-
Physical location
-
Application name
-
Application description
-
Database administrator name
-
Key dates
-
First deployment date
-
Major change dates
-
-
Extraction information
-
Data conversions needed
-
Overloaded field definitions
-
-
Tables that result from extraction
-
Extraction executions
-
Date of extraction
-
Type full or sample
-
B.5 Table Definitions
-
Name
-
Descriptive name
-
Business meaning
-
Columns
-
Name
-
Longer descriptive name
-
Business definition
-
Confidence indicators
-
Trusted
-
Susceptibility to decay
-
Enforcement processes
-
-
Domain names...
-
Copyright Elsevier Science (USA) 2003 under license agreement with Books24x7
