Use and design of an active data dictionary for local validation of input data.

Abstract

This thesis addresses the problem of small user groups being forced to use input data collected and processel by sources outside their span of control. Specifically, the use of an active data dictionary to locally validate such input data is examined. The thesis proceeds from a general review of data validation techniques and criteria, through an examination of data dictionaries, to an illustration cf how an active data dictionary can be configured to act as a "data filter" for input data. Key initial planning and design steps are set forth, including requirements analysis, data definition, and initial logical design. A checklist of questions to answer during each of these activities is included. The concepts discussed in the paper are then applied to a specific case (DCSPLANS Branch, a.S. Army Military Personnel Center, Alexandria, VA) resulting in a "data filter" structure diagram that is tailored to the DCSPLANS' environment and their unique validation needs.