Accession Number:

ADA336886

Title:

Data Warehousing and Data Quality for a Spatial Decision Support System

Descriptive Note:

Master's thesis

Corporate Author:

NAVAL POSTGRADUATE SCHOOL MONTEREY CA

Personal Author(s):

Report Date:

1997-09-01

Pagination or Media Count:

226.0

Abstract:

This research investigates the problems inherent in Decision Support Systems DSS that depend on the quality and accuracy of legacy information as the basis for decision making. A Spatial Decision Support System SDSS was developed at Naval Postgraduate School to analyze the comparative desirability of Army Reserve Unit locations. The Army Reserve Installation Evaluation System ARIES integrates a GIS mapping engine and a decision model solver in a flexible environment that leverages operational legacy database information for decision-making. Data quality problems from legacy sources motivated the development of a data migration plan to transform the source data into an architecture optimized for the ARIES SDSS application. This research developed a prototype Data Migration Tool DMT to extract the relevant source data into a centralized repository for the SDSS with an acceptable degree of data quality to support SDSS outcomes. Six data quality attributes were identified accuracy, completeness, consistency, timeliness, uniqueness, and validity. The ARIES DMT focused on data validity and developed techniques for measuring and enforcing data validity. The DMT also specified individual responsibilities for data administration, development of data retrieval routines, and data quality assessment. Significant system performance enhancements resulted from implementation of the DMT by leveraging the spatial aspects of the underlying repository through geographic queries that efficiently localized subsets of the data files. Additional performance enhancements were obtained through the use of data warehousing techniques.

Subject Categories:

  • Computer Systems

Distribution Statement:

APPROVED FOR PUBLIC RELEASE