Research And Implementation Of Database Unified Interface System For Wisdom Oilfield Applications

Along with lots of large-scale applications and the rapid development of information technology in the oil industry, especially in the context of the oil industry vigorously promoting the construction of wisdom oil, oil-related data is growing explosively. For the various systems used in the oil industry production, living and management, how to manage a variety of databases effectively about releasing the direct dependent on backend database, improving system security, reducing development and maintenance costs of the system and improving the deployment and promotion’s efficiency, is an important issue for a wisdom oilfield applications, which needs to be solved eagerly. It’s also a valuable research topic and good application prospect in future. Research and implementation of this project commenced around this focus.First, this paper introduced the background and current development-related fields of wisdom oil, then described the current situation of database and related database technology, which compared and analyzed different types of relational databases. According to the current wisdom oilfield system and common application views of database, It was determined the design and implementation strategy of this project, which focused on MySQL and Oracle databases, then supplemented by other database.Second, based on research and analysis of the popular research database connections for different development platforms, this paper proposed one abstract model and the overall design of the interface system, which including related seven main modules. In the design and implement phase, firstly, introduced the main function of each module and determined their design principles and related technologies. Second, in the design and implementation phase of the specific module sections explained the specific implementation of each module. It included the completion of the common SQL statements abstraction and encapsulation for different interface for front-end module, which reduced the degree of coupling between modules. The achievement of a database query pool and result sets buffer pool reduced the database and improved the load capacity and stability of the system. Moreover, the module of the automatic database backup and restore functions ensured the security of the data. In addition, a separate database connection pool was designed to improve the efficiency of database connections and systems, to achieve the system compatibility and to maintain seamless switching of different databases as well as the transparency for the upper module.Finally, to ensure the correctness of the system, serials of testing under the development environment, the test environment in multiple scenarios were done, which proved the optimization of this interface system for the entire system on load and performance. Meanwhile, after deploying in a real system of wisdom oilfield applications in one companay, it is verified the correctness, security, efficiency and convenience of this interface system. So as a conclusion, this paper solved the problem to be solved, completed the issue of this topic’s purpose.