Design And Research Of Oilfield Basic Data Acquisition System With Dual Mode And Dual Database

With the rapid development of information technology, all walks of life are gradually a lot of introduction and application of information management system. A lot of unit of the oil industry are used in all kinds of information management software. Compared with these units, the basic data of oil field in the information management is relatively backward, and these basic sectors also need processing based on a huge amount of information, to ensure data accuracy, but also to ensure the timeliness of data. Oil field as a special industry, many in remote areas, the stability of network status is difficult to obtain, to instability in the network conditions to ensure the normal use of the system becomes a key problem.In view of this situation, the development of the dual mode dual database field based data acquisition system. Dual mode dual database field based data acquisition system is a typical data acquisition system, this system adopts the offline mode under the framework of C/S based, supplemented by double database online mode, parallel mode. Dual mode is offline mode and online mode, and double data refers to the system using two sets of database, namely the local PC using access database, and the database of the server for Oracle9i. The dual mode dual database can ensure that oil as a special industry in basic data entry, summary, delete, save, in the process of updating the system efficient and stable operation. System uses PowerBuilder as the database application system development tools. PowerBuilder is a good C/S development tool, it provides visual, object-oriented rapid application development environment, has a powerful, cost is relatively small, short development cycle, high quality. The choice of database, Oracle9i database has strong function, the commonly used Access database, prepare two for the development of Oilfield Information integration. System by connecting two database, realize the offline mode, online pattern, so as to ensure the normal use of the database system, the data transfer between update and ensure data accuracy.Based on the research and development of the implementation of this system in basic data collection and management of information, the weakening of the oil field as a special industry in the information management process on the stability of the network over reliance on, the implementation of basic input statistics, management and query functions of output data entry and audit function and all levels of management report.