Research And Application On Automobile Statistics Analysis Software Based On Data Warehouse

Quality statistic analysis is an important component of the company quality control, product quality is the necessary premise of management conditions. Car manufacturing factory attention is the failure rate and components failure rate two respects, auto manufacturing process outsourcing parts accounted for about 70% of the company's products, quality, cost, delivery date influence. Good control of the quality of the parts, and to reduce vehicle failure rates and has been the car manufacturers and users pursuit of the goal, spare parts quality evaluation generally USES the following quality index (1) the market 3 packets of failure rate; (2) a inspection qualified rate; (3) rate, five outlets will levy group in the three before quality index of the statistical work take manual operation, low efficiency, quality data due to huge multifarious, quality the statistics personnel and very limited, making the existing statistical way can't meet the quality management development demand. Other suppliers and manufacturers just E-mail between communication, also can't timely, clearly understand the level of product quality. How to five drafts and internal downstream supplementary company quality information integration, so as to realize the whole car industry chain of internal information unblocked, is to enhance the competitiveness of products for the five car key.This paper for the improvement of the five group face statistical analysis of the efficiency of the quality problem, based on data warehouse construction car trouble statistic analysis software in actual production, and realize the software, so as to realize the market information management and in manufacturing company, suppliers, dealers between accurate and efficient data exchange, ascension for five of the group of after-sales service level and quality management level.It firstly introduces the current domestic and foreign data warehouse, OLAP technology, auto fault statistics analysis software of the situation, and then the data warehouse and the article summarized OLAP technology, in view of the five group car factory for internal problems in the management of quality information software and suppliers of specific demand, based on data warehouse to build a car trouble statistic analysis software solutions. First auto fault statistics analysis software for the software framework of the overall design of the car, and then the failure data analysis, to determine the source of the auto fault data warehouse concept model, according to the boundaries of the software for automotive fault data warehouse, identify research topics in the clear auto fault data warehouse involves inquires the analysis, and then began to design theme auto fault data warehouse, and then to the logical model of car trouble to the analysis of the data in the data warehouse, clean, conversion and loading, and use some in the.net environment in the related development of technology, complete car trouble of statistic analysis software interface development. The paper introduces the fault statistics analysis software in for the application of the five group, and points out that the car trouble statistical analysis of the problems existing in the software and the next research direction of improvement.