Design And Implementation Of Database Management Platform For College Of Mechanical And Electrical Engineering Of Beijing University Of Chemical Technology

The information is large and complex in the grassroots administrative post,meanwhile, the data and files are miscellaneous. In this job, there are usually manytemporary jobs, needing to contact with other departments and individuals. So it isnecessary to adjust the work scientifically, otherwise, it will reduce the workefficiency; even delay some very important works. This paper aims at building aplatform for information service and management with database kernel to resolve theworking poor efficiency problem.The job of the electromechanical engineering institute in BEIJING University ofChemical Technology was treated as subject investigated in this paper. In the face ofthe works and procedures characteristics, the data exchange, the data association listand the data sharing with science orderly and the software of MS OFFICE and VBA(Visual Basic for Application) were used in this paper. A large number of data or fileswere distributed in the database with proper and normal mode. A platform aboutinstitute information was developed, which was provided with flexible functions.Eight sub-databases were developed with thousands of data or files contained.For poly-type Word, Excel, PPT and image files, the inducing and educing workswere resolved with multi-method. Multi-mode inquiry was established. Also, somesubsidiary functions such as log with memorandum was set up. Data integration andclassification were carried out in this paper. The integration and classificationintegrally order arrayed the data.The compact and practical platform is ultimately fit for the administrative works,which could improve efficiency of by a long way. It is exoteric and continuable forthe congeneric jobs, and can be transplanted and expanded.