Data warehousing and data quality for a Spatial Decision Support System.
Dill, Robert W.
Thomas, George W.
Dolk, Daniel R.
MetadataShow full item record
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
Approved for Public release; distribution is unlimited
Showing items related by title, author, creator and subject.
Mortlock, Robert (Monterey, California. Naval Postgraduate School, 2017-07); NPS-AM-17-211This Enhanced Combat Helmet (ECH) case study encourages critical analysis of a U.S. Defense Department project at two key decision points: project start and production. The case centers on the development, testing, and ...
Corley, M.S.; Santiago, F.; T. Martinez; Agrawal, B.N. (2011);The Navy is interested in horizontal laser propagation studies in a maritime environment, near the ocean surface, for applications including imaging and high-energy laser propagation. The Naval Postgraduate School (NPS) ...
Brickey, Jonalan (2001-06);The Housing Welcome Center (HWC) in Monterey, CA manages more than 2, 200 military family houses and provides services to approximately 4,500 service members. The current housing information system consists of a proprietary ...