Research Of SQL Server 2000 Data Warehouse And Data Mining Technology In The Military Informational Management Application

Personnel development is the focus of the military information technology. We should strive to achieve talent management tools of information technology. Within the armed forces, there is many of the cadre management information system. They will be widely using the traditional database development platform to develop. They are regarded as the core of an independent database. Use it to handle all types of clerical work. Due to database is lack the functions of data analysis and decision support. However, the data warehouse management system can solve such problems, because it has been developed by advanced data warehouse and data mining technology.Data warehouse is a new data storage and management techniques. As database technology is mature and user demand for data on the analytical, data warehouse technology has begun to rise. We can consider the data warehouse is a new database, which consolidation of target data with differentiation theme and advanced process technology. It is the data processing of a new research direction, is mainly used to obtain and organize data from various types of discrete business processing systems. And used to provide users with a variety ways for obtain the required information, for it has a good data anglicizing and processing capabilities.Data Mining induction unknown valuable information from complex data sources,is a knowledge discovery process. Its main analysis is classification, prediction, assemble, describe visualization, valuation and association rules. Data Mining is a cross-discipline in the information age, its appearance changed the ways and means of human cognition of the world. In the paper we want to discuss mining techniques are oriented domain-specific with a specific premise. Data mining technology is able to understand by the user and description by natural language. Throughout the entire process of data mining, involves a large number of preparatory work and planning process. In fact, many experts believe that the preliminary stages of data-processing operations are usually occupying 80% of the time and effort in the entire data mining process. These include the data format conversion, data cleansing, table links and other important work. In the modern battlefield, data mining technology can find important information, or to judge the conclusions, from the small differences in mass data obtained from various means of reconnaissance. That is the two functions about description of the enemy situation and prediction of enemy actions, making the command decision-makers foresight. Therefore, we can say that data mining technology combined with advanced technologies such as precision-guided, communication, detection, can be translated the information advantage into operational advantages, is a combat force multiplier.Microsoft SQL Server 2000 is complete software of database development, application and analysis. Be able to provide users with a powerful database technology platform in some respects, such as large amounts of data warehousing, online analytical processing and e-commerce applications. And a comprehensive support network function database construction-use management program. In its 7.0 version later, the software has been providing the service components with data mining capabilities and OLAP capacity; they can found the available information from OLAP datasets and common relational database.The data management system is withholding military equipment-oriented system of cadre selection and training as the main theme, in its development process, database as an important source of data for data mining, the quality of its pros and cons related to the success or failure of the construction of the entire mining system. In this paper, we put the military information building as a background, make the cadre management database of a group the size of unit as a research object. Use it for develop information-based data management system. The paper describes the basic flow in detail about us to use the data warehouse and data mining technology provide by Microsoft SQL Server 2000, to establish the system working environment and historical data analysis. Completion of the example-development and thematic database-design. Established a multi-dimensional datasets. Multi-dimensional analysis the data after processing in the system. Gives the results of the analysis data, Achieves the wish about machine-aided decision-making in the field of cadres relevant and training. We are fully tapped the capacity and potential of SQL Server, but not to be pursuit of large-scale comprehensive system blindly. Used advanced data warehouse theory as a guide, gradually organize and standardize the data institutions and models of Units. Then with practice, we use of the results at this stage to carry out design research. It is a beneficial exploration of unit about scientific decision-making and information technology.