Data Warehouse to Support Condition Based Maintenance (CBM)

摘要

The United States Army's legacy maintenance strategy for its helicopter fleet is centered on replacing and repairing components based on aircraft hours flown. This strategy overlooks how variations in environmental conditions, component stresses, and other exogenous factors effect the lifetime of specific components across the entire fleet of Army Aviation Aircraft. This report describes the design and implementation of a data warehouse that subsumes many disparate databases currently housing information about these factors. This data warehouse supports a common synchronized 'maintenance picture' that includes state, health, usage, and logistics data for any component on any helicopter in the fleet. This view enables researchers and planners to individually manage component maintenance according to a 'condition based' policy. This report discusses a systems engineering approach to creating a data warehouse including logical and physical designs, data management strategies, and an implementation plan. Discussion is also included detailing how the warehouse might be adopted for condition-based maintenance of all Army systems.