A data warehousing and OLAP application for the Naval Reserve Force (CNRF) assessment process

• Main Author: Langley, Scott A.
• Other Authors: Dolk, Daniel R.
• Published: 2012
• Online Access: http://hdl.handle.net/10945/9742

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.