The Study Of The Supplies Procurement Information System Based On The Data Warehouse

Procurement of materials related to the enterprise has always been an important part of the survival and development, but also by the Shengli Oil Field business concern and attention. In 2004, Shengli Oilfield in the three-tier mode, the Institute for Supply Management's purchasing system construction materials, in 2005 ERP system in the Shengli oil field production enterprise wide application of information system has accumulated a great deal of material procurement data. However, these existing systems used by the main database or the traditional database, the only transaction processing, databases difficult to combine, not for the procurement of goods and materials enterprises to provide analysis and decision-making. Data storage technology to meet the analysis, decision-making needs.In this paper, at home and abroad for the procurement of materials and research data warehouse and data warehouse development process and OLAP technology, an analysis of existing materials procurement management system of the structure, function and so on, in the Shengli oil field exploration well within the data warehouse construction Mode method.Shengli Oilfield in the procurement of materials for example, based on data warehousing systems material procurement, research to build a data warehouse of the whole process. According to the data warehouse design, procurement of materials to the existing system, the overall program, the redesign of hardware and software platform to further establish a data warehouse based on the material procurement system. In foundation relevant fact table and maintain table building the material procurement analysis and supporter choice more dimension cube of Data, suffice more dimension of necessary. Finally, the Shengli Oil Field for the enterprise data management features of the metadata, ETL achieve, to update the maintenance of several key aspects of technology elaborate.As a result, the data storage technology and supply chain environment, in close connection with the procurement of goods and materials so that it can help companies achieve the policy-making material procurement, so as to optimize resources, for the "digital oil field" in the idea of carrying out the field for reference.