Abstract
The purpose of this study is to improve the efficiency of on-line monitoring of pollutants on oil platform and the economic benefits of oil exploration and development companies. In this study, firstly, several technologies used in the development of this system are introduced, namely, Common Gateway Interface (CGI), Active Server Page (ASP), Document Object Model (DOM) and Internet Information Server (IIS). Secondly, the overall structure of oil anti-fouling statistics system is divided into three functional modules: news module, anti-fouling data processing module and user management module. Finally, the overall workflow of the system, user workflow, system security and database are designed. The results show that the system can realize the rapid and automatic exchange and information sharing of system information, and provide information service for related departments. In addition, it can also improve the comprehensive information query ability, and provide leaders and competent departments with the latest information at any time, so as to provide information support for planning and decision-making. Therefore, through this research, it is possible to speed up the collection and processing of information, improve the comprehensive utilization of information resources, and provide a reliable basis for scientific decision-making.
Introduction
Oil pollution refers to the pollution caused by oil leakage and emission in the process of exploitation, transportation, loading and unloading, processing and use of oil, which mainly occurs in the ocean [1, 2]. Floating on the surface of sea, oil spreads rapidly to form oil film, which can be transported and transformed through diffusion, evaporation, dissolution, emulsification, photodegradation, biodegradation and absorption. The impact of oil pollution on the environment can be divided into two aspects: first, oil and gas pollute the atmospheric environment [3]. Physical and chemical reactions occur between oil volatiles and other harmful gases after being irradiated by the ultraviolet rays, generating photochemical smog, carcinogens and greenhouse effect, and destroying the ozone layer, etc. [4, 5]. Second, corrosion and leakage of underground oil tank and oil pipeline pollute soil and underground water source. It causes soil salinization and poisoning, leading to soil damage and waste, and its toxic substances can enter the food chain system through crops, especially groundwater, and ultimately directly harm human beings. Therefore, the detection of petroleum pollutants is urgent.
Nowadays, with the rapid development of Internet, adopting computer network for data transmission and management is an important content to improve data transmission accuracy and work efficiency [6, 7]. Statistical informatization is mainly aimed at the informatization of statistical design, data processing, information management and service [8, 9]. After years of statistical informatization construction, branches at all levels have made great progress in network construction, data processing and office automation construction [10, 11, 12]. With the deepening of statistical informatization construction, the construction of statistical system has gradually become the focus of statistical informatization construction [13].
In order to transmit and report environmental protection information in the process of oil exploration and development in a more timely and accurate manner and reduce the cost of information transmission and report, the powerful function of computer network is fully utilized to realize the resource sharing of environmental protection information of oil exploration and development, and a set of Web-based oil pollution prevention statistics system is designed and developed.
Methodology
CGI
CGI is a specification for external programs that run on the WWW server. According to the program, it can expand the function of the server and complete the work that the server itself can’t do. An external document can be executed to generate an HTML document and return the document to the server [14, 15]. CGI applications can interact with the browser and communicate with external data sources such as the database server through the API of the database. A CGI program, for example, can take data from a database server, format it as an HTML document, and send it to a browser, or it can put data from a browser into a database. Almost all the server software used supports CGI, and developers can use any of the built-in languages of WEB server to write CGI, including popular C, C++, VB, Delphi and Java.
Process of an ASP file.
Based on Distributed Component Object Model (DCOK) architecture, ASP enables application components to be executed in a distributed manner locally or on the network, thus improving the application efficiency based on client/server architecture. Since HITP browser itself has the advantage of cross-platform, it is a good client platform [16, 17, 1]. ASP provides some kernel features as follows. Server-side scripting: multiple language statements can be embedded in a page to run on the server; flexible WEB database connection: with ActiveX Data Objects (ADO) and server-side scripting, it is easy to build rich database functions on the site; state management: built-in objects can track and manage the state of an application on a per-user, per-application, and per-server basis. Built-in objects can overcome the limitations of stateless HTTP; active server components: programming components can be used. These components can be created with tools such as VC++, VB, VJ++, Delphi, and PowerBuilder to integrate the web application with an existing client-server system.
An ASP process is as follows. When the user applies for an asp file through the browser, the processing of the file begins. This file is read and processed by the WEB server, and any server-side script commands are processed by the Active Server Framework (ASF) script engine. While HTML and client-side scripts are returned to the browser, server-side scripts are not returned to the browser. Figure 1 illustrates the process of an ASP file.
DOM
The basic idea of DOM is to treat the WEB browser window and its contents as objects. According to the idea of object-oriented, each object has specific properties and methods. By methods of calling objects, WEB developers can perform corresponding document operations [16, 17, 18]. In addition, according to the concept of “event-driven” in object-oriented programming, DOM defines some events, including mouse event, keyboard event and system event. In this way, WEB programmers can use these events in their programs to respond to user actions.
IIS
IIS is a web server built into Server. It is the easiest way to build web applications and publish information. IIS is designed to meet a wide range of user needs. It is an ISP hosting site that receives millions of hits per day from a company’s workgroup or department. IIS can use a feature called “process isolation” to protect components from bad actions or network application errors by running different processes in different memory spaces. It can also quickly upgrade web applications by handling multiple concurrent user events with the built-in step-by-step application service. Users can build new components and applications in ASP, which is a script environment without compiling. What’s more, users can also use the integrated JAVA virtual machine technology to provide a reliable and high-performance environment for running JAVA components through ASP.
IIS also has powerful site management features. It helps users to manage tasks conveniently, such as creating a new site or virtual directory. It can also provide a rich and integrated tool management network applications, establish a number of sites in the machine with only one IP address, provide powerful configuration management functions, so that administrators can operate easily and independently. In addition, it can analyze log files to determine how to use them and analyze the content of WEB sites with analysis tools to visualize the site structure.
Results and discussion
Functional module design
The overall structure of oil anti-fouling statistics system is divided into three functional modules: news module, anti-fouling data processing module and user management module. Each of the three modules has a different number of sub-modules. And the content of these modules can be dynamically updated by adding, modifying, deleting and summarizing in the management center. The overall framework of system module is shown in Fig. 2. Specifically, the frameworks of each functional module are shown in Figs 3–5.
The overall framework of the system module.
The framework of news module.
The framework of anti-fouling data processing module.
The framework of user management module.
System overall workflow design: for a multi-user management system, the workflow of each type of user is different. The workflow of a multi-user system starts with the user login module and authenticates the user’s identity. Identity authentication can be divided into the following two processes: confirm whether the user is a valid system user and determine the role type of the user. The first process determines whether the user is allowed to enter the system. The second process determines the user’s operation permissions based on the type of user, thus determining the user’s work interface.
User workflow design: after entering the system, different types of users can perform different operations. These operations can be roughly divided into user management module and user operation module. And the user operation module can be divided into two parts: news management module and anti-pollution data processing module.
System security design: in this system, the user accesses the application through the WEB server, and accesses the data in the database through the execution of the application. To prevent information from being stolen, when the application is executed, the logged-on users are divided into administrator and ordinary users. The administrator has all operation rights on all data tables and data in the database. While ordinary users only have the right to query and a small number of specific modifications, which are shown in the application interface. Some application options are automatically shielded by the system, and some buttons such as “Add”, “Delete” and “Modify” are also disabled, so that users can’t conduct these data operations, as shown in Fig. 6.
Database design
As shown in Table 1, the data objects involved in the system are designed and stored in the following database tables.
Table and function description in the database
Table and function description in the database
System workflow.
With the rapid development of the Internet in the past decade, the use of computer networks for data transmission and management is an important part to improve data transmission accuracy and work efficiency. In this study, based on ASP technology, ADO technology and SQL technology, a WEB-based petroleum anti-fouling statistical system is developed. Through the research on the design and implementation of the system and related theoretical knowledge, it is found that because the system adopts B/S architecture, it overcomes the geographical limitation of information transmission, reduces the configuration requirements of the client, reduces the maintenance work of the client, facilitates the operation of the staff, and reduces the training cost. In addition, the organization and storage of information through this system will ultimately provide decision support for enterprise management. However, the system has not been verified in practice, at present, only a series of modules have been designed theoretically. Therefore, in the following research, it should carry out practical verification of this system, so as to continuously optimize the system function and improve the detection efficiency of pollutants in the oil industry.