Research And Application On SpringMVC In Oil Production Management System

With the development of digital and information construction in oil field, oil industry can auto collect and identify the real-time data in the process of oil production by various types of sensing equipment, above the data acquisition system,oil companies need to develop an accurate, intuitive display application system, to store and collect the production data of oil field, and monitor the production situation, provide a lots of charts for oil field workers to analysis and judge the trend of production parameters. Therefore, how to store, process and transmit real-time data at the production level and which system architecture can realize the information management of the oilfield production process, have become the two key problems in the oil production management system.(1)This paper researched the method of using ETL tool to store the oil well data and indicator diagram data in the aggregate relational database of the oil group headquarters, and introduced the architecture design scheme of the relational database for the oil production management system.We will collect real-time data and alarms information automatically from oil well equipment by SCADA system,then transmit them by fiber channel using SAN storage technology. The ETL tools are used to extract, convert and load relational data into historical database and relational database in oilfield company.(2)This paper studied the SpringMVC design pattern which reduce the degree of system coupling in the development of oil production management system application architecture, and analyzed My Batis persistence layer framework in the database operation, therefore, we proposal the development scheme which integrate SpringMVC and My Baits in the oil production management system. SpringMVC will eventually match the user’s request to the business logic control layer, and based onMy Batis, we write the data access operation(DAO) layer using two types of templates which provided by Spring, then invoke the concern tool class or function to complete the data operation. For each system module, we had make a detailed performance test in different scenes, therefore we had the test result which indicates the improvement direction, and consequently we had optimized the prediction functionality of the product parameters, promoted the comparison performance of the indicate diagrams, and improved the expansibility of the system.