Data Integration of Heterogeneous Data Source in Multi-parameter Test Processing

摘要

A variety of specific instruments are used to test the corresponding parameters in the process of multi-parameter test. Function of traditional instrument is simple and it can only test a single type of parameter, therefore we require a variety of instruments. Basic data of different digital instruments bought by companies at different times has large differences in the standards of their structures and amount. Decentralized data storage management, data over redundancy and lack of networks result in worse isolation of information. But the multi parameter test result data of tests analysis and report form need to be integrated, this article uses Lab VIEW tool bag LabSQL to realize the visit to Heterogeneous Database and data format transformation of different standards. Then order, event, for circulation and condition structure are used to generate the data preliminary conformity, finally proposed that LabVIEW and the Excel hybrid programming combined to generate the report form printing function. It satisfies requests of integration, uniformity and visit security on the data conformity.