| With the domestic automobile generator manufacturers are increasing the popularity of information technology and product research efforts investment, which produced a large number of test data in new product development and process improvement. Therefore, test data management effectively is conducive to product development and reuse of test data. After building motor the NVH test data management and evaluation system, technicians can manage and evaluate test data, using test data management and evaluation system, You can quickly and accurately query to the required test data, and base on these test data evaluation NVH performance of the motor, improve the efficiency of electrical product development and improvement.This study is combined with practical engineering problems in the NVH test data management and evaluation from some motor manufacturer. Firstly, This article analysis the needs of motor NVH test data management and evaluation system, On the basis of the needs analysis, design and analysis of the system’s development program, including the system architecture, system running environment, system function analysis, system function module division, the operation of the system process and the system design process, etc.According to the characteristics of the motor NVH test data and analysis of the test report, Establish motor NVH test database conceptual data model, E-R model, the basis of the E-R model to establish and optimize relational schema, Using SQL Server2008database management system finally realize vehicle motor harshness (NVH) testing for the establishment of the database table.On the basis of the ADO.NET data access technology, Detailed design of the motor NVH test data management and evaluation system function module, System functional modules include test management, test information query, standard test data curve, data evaluation, reporting and system maintenance.Discuss and implement based on the calculation method of first-order digital differential speed curve. This method of calculating the initial rotational speed, the pulse sequence does not need complex high-order polynomial fit, only by adjacent three o’clock interpolation derivative can obtain satisfactory results, while the amount of calculation is also relatively small. Then, on the basis of the well-studied Gabor expansion theory, research expanded based on the "like orthogonal" Gabor order than tracking the time-frequency filtering to achieve a particular order of the noise vibration signal in motor lifting speed stage score amount extracted and reconstructed. Overcome the traditional order analysis method based on FFT Angle domain cannot be insufficient amount of failure to extract order in time domain. |