Operational Measurement Management and its Database Support

摘要

Technical measurements are an integral part of research and development of new technical devices. Now they are also an integral part of production too, especially as a part of quality control systems. More new problems started with they applications up, like storing and following preservation of big data files. Many problems are also with processing of the measurement results, especially to be up to standards of ISO 9000 normative. It includes basic data about the measurement (structured data) and measurement outputs (huge data streams). Using database systems looks as good idea, because of structured measurement data and they processing. They were developed more concepts of database measurement system support during the research project MSM 272300012. It was decided to develop specialised measurement systems, on the base of experiments and experiences with they use in operating conditions. It proved to be wrong to develop general system, because of compound operating and long response of the system. And it is not possible to use these systems for mass production systems. The problem of data storing is not as easy to be answered, because of dependence on used technical devices. During realisation the measurement system for gearbox noise measurement are data stored to the database, because used analyser system PULSE (Bruel and Kjaer Co) is open structure and can cooperate with other software systems. Anyhow the data streams are not longer (after compression) than the Memo data type, in practical use increases the data file too fast (about hundreds MB daily). Therefore we must include a special supervisory system for administration and creating data files to the system. Nevertheless the used system MS-Access supports data files up to 1 GB, for practical application is better if the file size do not exceed the capacity of CD-ROM disc.