Study On Supply Resource Management System

The thesis take the advanced supply chain theory as the instruction, the system analyze SINOPEC enterprise goods and material handling existence question, unified its commodity and supplies the chain the characteristic, proposed the SINOPEC enterprise provisioning chain system design principle, realizes Chinese SINOPEC Engineering construction Company (to hereafter refer to as SEI) to purchase the service the informationization management, and with the Marian system, the China Petroleum and Chemical Corporation supplier management system management system, the China Petroleum and Chemical Corporation EC system carries on the effective integration, the realization purchase process verification and the surveillance, provides the policy-making support for the leadership, enhances the purchase process the scientific nature and the standards, the realization highly effective, the integrated service work platform. The thesis research and apply SRM theory in material management of petrochemical enterprises, it can illumine flow manufacture corporation industry and direct petrochemical enterprises. The thesis mainly introduces the solution from two aspects:Software design: The system uses J2EE structure, this system structure based on XML, the Java technology, uses the present technology mature and general Web application service development technology, to satisfy the user that need the high usability, the redundant reliability as well as may the extended demand. And used had high is expandable, the support enterprise Java standard and CORBA also has the main engine mutually operational enterprise to apply server WebLogic Enterprise. The system completes the main function including demand management, the purchase management, the inquiry management, the technical appraisal management, the quoted price management, the commercial appraisal management, the synthesis appraisal management, the order form management, the purchase payment management, the project information management, the synthesis statistics and the achievements analysis and the commodity code management and so on.Database design: Has used the Oracle database, it has the consummation business processing, reliable, secure and the integrated data warehouse function. According to company's service investigation and study analysis foundation in, the full consideration satisfies various levels user the data demand and the database design principle, purchase order, purchase plan, inquiry book, quoted price book, order form, payment, supplier entity design database and so on revolves the project, to invite. Massive has utilized database optimization operation and so on the view, memory process, index in this process, enhanced the data to carry out the efficiency.This article finally aims at the question which in the performance history bumps into, proposed some systems wait for further consummate and the research.