Data Warehouse Architecture for Army Installations

摘要

U.S. Army installations are enterprises performing tasks such as management of funds, budgeting, estimating, managing facilities, maintaining facilities, providing training, complying with environmental and safety laws and regulations. Installations use many database management and operational systems to conduct these tasks. A data warehouse is a single store of information to answer complex queries from management using cross-functional data to perform advanced data analysis methods and to compare with historical data. In the data warehousing approach, the cleansed and transformed data from several operational systems is stored in a single integrated repository of information. This approach provides easy access to needed data, improves system response time, and enhances data integrity. If designed and developed properly, an Army installation data warehouse has the potential to improve efficiencies and produce a positive return-on-investment.