Research On Database Design Of Regional Manufacturing Resource Optimization System

Based on information technology, the manufacturing resources belonging to various enterprises distributed in the region can be integrated together effectively, so that the enterprises who need the specific resources can locate them accurately and rapidly; and the resources can be collocated together by the most effective mode to service for all enterprises in the region ,and the high usage of resource gotten. Both the above process and results are called Regional Manufacturing Resource Optimization(RMRO).The Regional Manufacturing Resource Optimization System(RMROS) is a kind of application software which aids enterprises in the specific region performing the RMRO. Based on network and database technology, RMROS is composed of many modules, each of them performing certain functions corresponding to the optimization of variant resources.Based on analyzing and abstracting entities and their relationships of RMRO, E-R graph illustrating the main contents of RMRO is proposed. Like other businesses, actions of RMRO include three phases, which are searching, negotiating and fulfilling. The (S,N,F) three-phase mode of RMRO, which stands for Search, Negotiate and Fulfill respectively, is proposed and analyzed. After the information according to the each phase of optimization and normal running of the system are discussed respectively, the information demands are concluded and analyzed in detail. Especially meta-information method is used in products and equipments information management. The trait of users and information contents of user management are also analyzed. The conceptual model of database is illustrated with E-R graph. After that, logical design and physical design of database are partly accomplished, and some designing principles of them are analyzed, such as external schema, cluster and index design and data type choosing. The Relational Database is poor semantic, so manufacturing resource database management system based on relational database management system isproposed for manufacturing resource database management. The functions and design of manufacturing resource database management is discussed and Human-Computer Interface of equipments information management is designed and implemented.Finally, the research contents and conclusions of this paper have been summarized and its further studies forecasted.