Research on Application System of Spatial Coordinate Measuring Machine Based on Network Database Technology

An application system of space coordinate measuring machine based on network database technology is proposed. The structure and function of space coordinate measuring machine application system based on network database technology are analyzed. An object-oriented model of the system is proposed. The analysis and discussion were carried out, and the technical concept and key technology of the space coordinate measuring machine application system based on the network database technology were verified with an experimental contact space CMM application system.
Keywords: network database, coordinate measuring machine, object-oriented model


1 Introduction In the information age, industry and science and technology mainly obtain information through measurement [1]. The symbol of the information age is the development of high-speed and large-capacity computers, and the key is the production technology of large-scale integrated circuits. Modern engineering technology is increasingly used for testing. The use of advanced testing technology and tools is one of the important signs of high economic development and technological modernization.
1.1 Development profile and trend of space coordinate measuring machine Modern space coordinate measuring machine is a large-scale precision intelligent instrument integrating optics, machinery and electronic technology, which can measure the space size of any complex shape [2]. Intermediate measurement can be controlled during the manufacturing process, online measurement of CNC machine tools or flexible production lines, especially CAD / CAM technology can be applied to the online system of space coordinate measuring machines and machining centers, making space coordinate measuring machines-computer workstations-CNC machine tools The online system has been further promoted to ensure product quality and promote the development of new products. The space coordinate measuring machine has become an indispensable large-scale universal measuring instrument for modern industrial inspection and quality control.
1.2 The application system of space coordinate measuring machine With the development of microcomputer technology, space coordinate measuring machine, network technology and database technology, the application system of space coordinate measuring machine has also been further developed, basically forming a shaped structure. It consists of five major parts: space coordinate measuring machine subsystem, data processing subsystem, data basic output input (I / O) subsystem, data communication subsystem and data conversion subsystem [3]. The structure of the entire system is shown in Figure 1.

1.3 Network database technology Database technology is one of the key technologies in the space coordinate measuring machine application system based on network database technology, which supports the operation of the entire application system. The new generation of Web-DB (Web-Data base) uses the B / S (Browser / Server) model to further decompose the server side of the C / S (Client / Server) model into an application server (Web server) and one or more A database server, thus becoming a three-tier C / S model [4], as shown in Figure 2. There are four methods for database access to the Web: public gateway mode, ODBC (Open DatabaseConnecTIvity) mode, JDBC (Java DatabaseConnecTIvity) mode and CORBA (Common ObjectRequest Broker Architecture) mode.
1.4 Spatial coordinate measuring machine application system based on network database Based on the above analysis, the author designed a spatial coordinate measuring machine application system framework based on network database technology as the core and integrating spatial coordinate measurement and CAD technology [5], allowing users By processing the database to process data remotely, that is to say to use the network database technology to transform the original space coordinate measuring machine application system, forming a space coordinate measuring machine application system based on the network database technology, or based on the network database technology Application system of space coordinate measuring machine. The technical concept of the space coordinate measuring machine application system based on network database technology is shown in Figure 3.

As for the feasibility of the system, the author believes that first, the space coordinate measuring machine has achieved considerable development after decades of development [6], and has been widely used in various mechanical manufacturing and testing. Second, the technical integration of this system is very good, and the computer graphics technology, database technology, computer network and communication technology it depends on are all very mature technologies. Our job is just to make full use of these technologies for integration and optimization to realize our application system. Therefore, the feasibility of the system is high.
2 Analysis and design of application system of space coordinate measuring machine based on network database technology J. Rangbough's OMT method (Object ModelingTechnique), which is based on the entity-relational model, extends class, inheritance and behavior. It uses object model, dynamic model and functional model to describe a system, which is a relatively well-developed method. [7] [8]. The author uses this method to analyze and design this system.
2.1 Analysis of the application system of space coordinate measuring machine based on network database technology
2.1.1 Functional analysis Specifically, the goal of the space coordinate measuring machine application system based on the network database technology is to establish a universal space coordinate measuring machine application system, which allows the user to select the type and model of the space coordinate measuring machine constructing the system Use the entire system as a Web server in the B / S structure, select the data processing method, storage format, and storage method inside and outside the system, set data measurement control strategies, and transmit measurement data and processed data to other systems .
For different purposes of use of the space coordinate measuring machine, there must be different operating procedures and data processing methods. The user selects the corresponding measurement strategy, data format, and data processing method for the specific application through software settings. The spatial coordinate measuring machine application system based on the network database technology is compatible with various types of spatial coordinate measuring machines. At the same time, error coordinate software compensation should be provided for spatial coordinate measuring machines with relatively large errors.
2.1.2 Structural analysis (1) Spatial coordinate measuring machine application system hardware structure based on network database technology The system structure serves its functions. In order to meet the above functional requirements, various types of spatial coordinate measuring machines should be allowed on the system hardware Access and expansion. For each application, the number and type of spatial coordinate measuring machines are different. This system uses software selection solutions to solve the problem. As for the flexibility of the system ’s measurement strategy and data processing, it can be found in the software. In the above solution, the communication problem between the systems is completed by the computer network, so the hardware structure of this system is shown in Figure 4.

(2) The software structure of the space coordinate measuring machine application system based on network database technology is analyzed as before. A space coordinate measuring machine application system must have data measurement, measurement control, data processing, result display, data storage, and communication with other equipment systems. Function; as a spatial coordinate measuring machine application system based on network database technology, it must realize the definition of measurement strategies, the definition of data processing algorithms, the definition of database storage formats, the choice of display methods, and the dynamic exchange of data, At the same time, the above definition can also be saved as a measurement item for later recall. Generally speaking, the system functions correspond to the software modules, and there are modules corresponding to the functions.
The software structure of the system is shown in Figure 5.

2.1.3 The system workflow should complete the above functions and ensure the flexibility and scalability of the system. The system uses the workflow shown in Figure 6.
The workflow is divided into three parts.
First, design the measurement plan. The user selects the type and driver of the space coordinate measuring machine, designs the measurement path and plan of the space coordinate measuring machine, sets the display space coordinate system, and then designs the data processing algorithm. Determine the display mode of the results, define the database format for storing the measurement data, and save these series of parameters as the measurement plan.
The measurement plan is executed, the user starts the system, opens a measurement plan, and starts the measurement.
Measurement process, operating space coordinate measuring machine, external signal enters data processing through I / O, the result of data processing will affect the measurement control according to the measurement strategy, and the results of data processing will be sent to the display of the results. If the user needs to write the record file, write For signal file operations, if you want to write a database, add a record to a defined database table. If you want to send data to the network, you need to send a file. If you need to convert the data format, you need to perform the data conversion operation.
2.2 Object-oriented model of space coordinate measuring machine application system based on network database technology The object-oriented model of space coordinate measuring machine application system based on network database technology is composed of object model, dynamic model and functional model. According to Yourdon's object-oriented analysis principles, system objects can be: signal measurement, signal display, signal file recorder, signal database, data Web server, data format converter, and system framework.
An abstract subject box is used to describe each class, and an arrow symbol is used to indicate the message passing between each class. The system's object model is shown in Figure 7.

The dynamic model of this system has four states. The dynamic model of the system consists of four sub-state diagrams. There are three sub-state diagrams on the site of the space coordinate measuring machine. The third is the measurement sub-state diagram. On the upper computer side, there is a receiving sub-state diagram. The functional model of this system is shown in Figure 8.
3 Spatial coordinate measuring machine application system based on network database technology The author uses these technologies and theories to reconstruct an original spatial coordinate measuring machine, and on this basis establishes an experimental contact type three coordinate measurement based on network database technology The machine application system has the following functions: allows the user to define the measurement path and data processing algorithm, allows the user to set the display mode of the display, etc., the system has network communication capabilities, etc.
The realized hardware platform adopts contact space coordinate measuring machine, IBM compatible PC, CPU for Celeron 300, RAM for 128M, network card for 10M, Windows98 LAN; software platform uses Windows95 / 98, Access, VC ++, etc. [11] .
3.1 The interface diagram of the system interface and command field measurement system is omitted, the interface diagram of the superior monitoring system is omitted.
3.2 Measurement example Two computers are connected to the local area network, both installed TCP / IP communication protocol, the network speed is 10Mbase, one is used as the measurement computer, and the PS2308I / O board is used as the contact space coordinate measuring machine and installed with field measurement The measurement computer of the program is connected; the other computer acts as a monitoring computer and installs the superior monitoring application program. Sketch of the experiment site.
3.3 Experimental results Use this system to measure a tablet, the measured data (part) is shown in Figure 9, and then converted, sent to the Autocad system for processing, the resulting figure is shown in Figure 10, the physical The picture is shown in Figure 11.


4 Conclusion The spatial coordinate measuring machine application system based on the network database technology connects the spatial coordinate measuring machine to the network through the network database technology and serves as a layer of the multi-layer application system, allowing the system's measurement scheme and data processing method to be changed. Dynamically update data between databases to achieve online measurement and offline analysis of application systems. Moreover, through the Internet or Intranet interconnection, data transmission and measurement path and analysis method updates can be performed. It is of great significance to remote measurement and FMS manufacturing systems.
The object-oriented model of the space coordinate measuring machine application system based on network database technology proposed in this paper correctly reflects the structure, nature and function of the system. Tests have proved that the system developed with this model is safe, easy to operate and widely adaptable, and can be used for remote measurement and monitoring of the network.
Several key technologies proposed in this paper have considerable guiding significance for the application of network databases: open database interconnection (ODBC) technology, dynamic setting of ODBC parameter technology, data storage and dynamic exchange technology, and the connection technology between real-time database and large database Advanced nature.

references

1 Li Li. New technology and development trend of coordinate measurement. Journal of Xi'an Institute of Technology, 1998 (4): 322 ~ 326
2 Zhang Fuxue. Robot technology and its application. Beijing: Electronic Industry Press, 2000
3 Meng Mingchen, etc. Research on the integration of mechanical CAD / CAM using STEP. Journal of Tsinghua University, 1998, 38 (10)
4 Lin YJ, Mahabaleshwarkar R, Massina E. CAD-BasedCMM Dimensional InspecTIon Path Planning-a Generic Algorithm, RoboTIca, 2001, 19 (4-5): 137-148
5 FranceschiniF, Galetto M, SettineriL. On-line DiagnosticTools for CMM Performance. INT JADV MANUFTECH, 2002, 19 (2): 125 ~ 130
6 Jiang BC, Chiu SD. Form Tolerance-Based MeasurementPoints Determination with CMM. JINTELL MANUF, 2002, 13 (2): 101 ~ 108
7 Wan Weimin. C ++ language and object-oriented programming. Beijing: Tsinghua University Press, 1998
8 Ronald JN. Object-oriented Systems Analysis and Design-ed. USA Prentice Hall, 1998
9 Chen Jinchang, Zhao Mingxiu. C language computer drawing tutorial. Guangzhou: South China University of Technology Press, 1998
10 Yao Zhifeng, wait. High-speed data based on Windows95. Measurement and Control Technology, 1999 (4): 20-24
11 William F, William T. Data Structureswith C ++. Beijing: Tsinghua University Press, 1997

Led UFO High Bay Light

UFO Led High Bay Light,UFO High Bay Led,UFO High Bay Light,Led UFO High Bay Light

Jilin Province Wanhe light Co.,Ltd , https://www.wanhelight.com