| The military electronic parts are important technical bases and strategic resources of weapon systems and military electronics equipments. The management of military electronic parts is a difficult problem due to various classes of military electronic parts and related parties, i.e., end users, developers, manufacturers, industrial administrative departments and other organizations. Currently, most management systems are OLTP systems which provide over detailed information in scattered sub systems rather than comprehensive, analytical and supportive for decision-makers. With the development of technology, the mature data warehouse and data analysis technologies established bases of data warehouse based electronic parts decision supporting system. For full scale, efficient and scientific project management and decision, it is extremely necessary to build OLAP cored comprehensive management and decision making systems of military electronic parts.This paper describes basic principles and methods of data warehouse, data analysis and decision supporting system, as well as main products of data warehouse. This paper also analyzes the current status and needing of military electronic parts. On the basis of analysis, the author built a data warehouse based electronic parts decision supporting system on platform of SQL Server 2005, implemented ETL, and analyzed the information of tuebs which are typical in industry. The key technology introduced in this paper are methods of building structure and management system of data warehouse, and methods of data transformation, analysis and data mining, got rules and forecast of trend. |
