A data warehousing and OLAP application for the Naval Reserve Force (CNRF) assessment process
Langley, Scott A.
Dolk, Daniel R.
MetadataShow full item record
The Naval Reserve Force has identified a need to pool the data from its many legacy database systems into a single, useable data warehouse. The current system uses separate legacy databases and formatted reports to provide a manual decision process. Under the leadership of Rear Admiral John Totushek, the Naval Reserve Force is driving many technological revolutions via the Leading Change initiative. One of the key goals of the Leading Change initiative is a strategic decision support tool. To support this goal, Naval Reserve Force Assessment Division elected to fund a project to provide a prototype data warehouse and Online Analytical Processing (OLAP) solution to the problem. The Naval Reserve Strategic Decision Support Tool (NaRSDAT) is the result. The NaRSDAT development of this thesis provides an in depth evaluation of the existing databases. It then provides an object oriented development approach to a relational data warehouse and a star schema development for data mining. NaRSDAT employs Microsoft Visual Basic, Microsoft Access, and Cognos PowerPlay to provide a complete data warehouse and OLAP solution. The NaRSDAT prototype will serve as the basis for a comprehensive knowledge management solution for the Naval Reserve Force.
Showing items related by title, author, creator and subject.
Digges, Edward D. (Monterey, California. Naval Postgraduate School, 1996-06);Many Defense Distribution Depots are configured with some warehouses closer to the input/output activity than others. By designating a closer warehouse as the forward warehouse and the more distant warehouses as reserve ...
Dausman, Andrew D. (Monterey, California: Naval Postgraduate School, 2016-03);This thesis develops a retention model for the Selected Marine Corps Reserve (SMCR). Data for this model were pulled from the Marine Corps’ Total Force Data Warehouse for the fiscal years: 2009 through 2015. The model ...
Koch, Douglas J. (Monterey, California. Naval Postgraduate School, 2009-09);Currently, the Navy stores and retains data in multiple data warehouses, in various formats, in numerous legacy systems. The Navy's Bureau of Personnel is responsible for four distinct data stores that house unique data ...