Towards Reengineering the United States Navy Enlister Manpower and Personnel Systems – A Data Warehouse Approach
Conde, Douglas J.
Crownover, Cassandra A.
Dolk, Daniel R.
MetadataShow full item record
Historically, stove piped information systems have been developed to meet the needs of individual departments or users. Over time, attempts to increase the usefulness of these systems often involved adding layers of additional programming and data structures, resulting in complex and difficult to maintain legacy-based systems. The United States Navy enlisted personnel and manpower database system epitomizes this problem. The current system consists of several mainframe systems and a multitude of front-end systems that often require personnel managers to perform manual data extraction to execute routine activities. To illustrate the problem; we focus on Navy Enlisted Classification (NEC) reutilization, a critical aspect of the personnel assignment process. First, we present a series of contemporary database topics that form the basis for solving the problems associated with file-based legacy databases. Second, we provide details of the make-up and problems associated with the current system. Third, we develop a prototype relational data mart to prove the value of a data warehouse/data mart driven relational system. Fourth, using the prototype relational data mart as a source system, we use a contemporary OLAP application to prove the effectiveness of using a multidimensional data tool to analyze NEC reutilization. Finally, we discuss issues involving data quality and their impact on a data warehouse solution to integrating legacy systems
Approved for public release; distribution is unlimited
Showing items related by title, author, creator and subject.
Bak, Gwang U.; Kim, Chong-hun (Monterey, California. Naval Postgraduate School, 1982-12);A personnel information systems is designed for the management of Korean military officer personnel. The objective of this thesis is to apply the computer-based personnel information system in the area of military officer ...
A Rationale and Framework for Establishing a Systems Engineering Community within the Department of the Army Clayton, Alan; Wiborg, Anders; Riva, Amie (2011-03-08); NPS-SE-11-002Army acquisition programs are faced with increasing technical complexity and interdependence as most program products must integrate into a system of systems. The low quantity of systems engineers and the poor quality of ...
Clayton, Alan; Riva, Amie; Wiborg, Angers (Monterey, California. Naval Postgraduate School, 2011-03);Army acquisition programs are faced with increasing technical complexity and interdependence as most program products must integrate into a system of systems. Low quantity of systems engineers and poor quality systems ...