Research On Fixtures' Archives Management System Based On Network Database

With the development of computer and information, new theories and technologies are produced by manufacturing field's great changing. As the technologies of the CAD/CAM/CAPP are used and spread, the archive management digitalization and intelligentization of the mechanical manufacturing is imperative under the situation. It will improve the management ability of enterprises. And the most important thing is that realizing the CAD/CAM/CAPP is the base of managing all the files by using computers. As one of the important information resources, archives of fixtures are threatened by the global information waves also. The effective management and utilization are needed on the archives, but the old way cannot meet the need any more. How to change the old manual way to the digital one becomes the main point.The drawings designed by CAD can be input the system. So the designers can use the drawings saved in the system to edit. That would be a convenient way for them to design the fixtures, and can reduce the design period and the cost of the enterprises which produce it or use it.The structure of the system is designed by investigating the need of the client and fully using of the information technologies, which is included computer technology , communication technology, network technology and database technology. A universal fixtures' archives management system in the network is developed by using VB programming language and SQL Server data base. The system uses the topo of client/ server, and can run on multiple platforms. Therefore the system can be collocated in different server and the user can access it through the Intranet. The system achieves digitalization sign of files, report design, querying, management of pigeonhole, system and customs and so on. Friendly interface, quick reaction and strong practicality of the system make the users operating easily on it.After investigating on the original way of the fixtures' archives managing, the system is structurally developed that is including the topo design, function design and database design. Every Function modules in this system and working processes of the system are introduced in details in this paper. The system are presented including the muti-platform and software design pattern. The theories and methods of the software engineering are applied to control the process of design, development and test to improve the quality of the software and to cut the expenditure.