Design And Implement Of Supply Chain Management System Based On Database

Using database technology to realize supply chain management is an important subject of modern enterprise management. It is an important means to make rational use of enterprise resources to make effective decisions and to enhance the competitiveness of enterprises. Based on the analysis of the current situation of supply chain management, this paper studies the related concepts of supply chain and supply chain management, and introduces the classification of supply chain and supply chain management. At the same time, the database modeling theory and related technologies are described, and the database modeling language UML, and the main modeling tools of UML are also introduced.It is provided effective methods for the follow-up study. According to the application requirements of the system, the system function and system performance are analyzed, and the main components of the system function are described in detail. In this paper, we also determine the system structure, select the appropriate tool for the development of the project. Based on B/S mode architecture, the system are researched and designed, determined to data sharing, independence, minimum redundancy, safety and integrity of system data for the principle of design, to ensure the effectiveness and improvement of the information system. According to the function of the main modules of the system, the contents of the database tables are determined. In order to ensure the security of the system, the security mechanism is established based on B/S. This paper also compares the existing mainstream development language JSP, ASP, PHP, analysis of its advantages and disadvantages with others, select one of the following system development. In the current database access technology based on JSP, combined with database tables design, system function of main module(user information management module, the basic information module, storage management module and other functional module) code to achieve, and maintain the stable operation of the system. Finally, the article summarizes the existing work on the basis of the analysis of the future direction of improvement.