Data migration method and system of data acquisition and monitoring system of oil and gas pipeline

Abstract

The application discloses a data migration method and system of a data acquisition and monitoring system of an oil and gas pipeline, and belongs to the technical field of oil and gas pipeline data acquisition and monitoring control system engineering. The method comprises the following steps: first, uniformly converting data into data in a standard format; and then, based on a preset conversion database, converting the data in the standard format into data in a target format, so that the conversion and migration processes of the standardized data are realized, the data in different formats of various software is conveniently converted into the data in the target format, the efficiency is relatively high, the problem of low data conversion and migration efficiency in the related art is solved, and the engineering data migration efficiency of the data acquisition and monitoring system of the oil and gas pipeline is improved.

Description

TECHNICAL FIELD

[0001] The present application relates to the field of oil and gas pipeline data acquisition and monitoring control system engineering, in particular to a data migration method and system of an oil and gas pipeline data acquisition and monitoring system. BACKGROUND

[0002] At present, with the continuous upgrading of enterprise informatization, the development of different database technologies and the adoption of diversified new technologies, in the domestic oil and gas pipeline data acquisition and monitoring control system (English: Supervisory Control And Data Acquisition; Abbreviation: SCADA), the PCS pipeline control system (English: Pipeline Control System; Abbreviation: PCS) is the core software of the oil and gas pipeline regulation business of China Petroleum. There are still some other software being used in some oil and gas pipeline regulation businesses in the system. In order to avoid the problem of repeated development of oil and gas pipeline data acquisition and monitoring control system and waste of resources, the PCS pipeline control system software can extract data on the server of some existing other software, and convert and migrate the extracted data to the server of the PCS pipeline control system software, so as to make full use of the resources of some other related software.

[0003] A data migration method of an oil and gas pipeline data acquisition and monitoring system sets different engineering data conversion modes for different software, that is, for the first software, the data of the first software can be converted into the data of the target software by a certain mode and migrated to the server of the target software, and for the second software, the data of the second software can be converted into the data of the target software by another mode and migrated to the server of the target software.

[0004] However, the above-mentioned data migration method of the oil and gas pipeline data acquisition and monitoring system has a large workload, resulting in a long time for data conversion and migration of the oil and gas pipeline data acquisition and monitoring system and low efficiency. SUMMARY

[0005] The embodiments of the present application provide a data migration method and system of an oil and gas pipeline data acquisition and monitoring system, and the technical solution is as follows:

[0006] According to the first aspect of the present application, a data migration method of an oil and gas pipeline data acquisition and monitoring system is provided, which is used in a data acquisition and monitoring system, the data acquisition and monitoring system includes a terminal of an oil and gas pipeline station, a first server of a first software, a second server of a target software and a storage, and the method includes:

[0007] The first server acquires first engineering data of a data acquisition and monitoring system of an oil and gas pipeline;

[0008] The first server sends the first engineering data to the storage;

[0009] The storage transmits the first engineering data to the terminal;

[0010] The terminal processes the first engineering data to obtain second engineering data in a standard format;

[0011] The terminal checks the second engineering data based on the first engineering data to determine whether the data content of the first engineering data and the data content of the second engineering data are the same;

[0012] When the data content of the first engineering data and the data content of the second engineering data are the same, the terminal converts the second engineering data into third engineering data based on a preset conversion database, and the preset conversion database includes a corresponding relationship between the data in the standard format and the data in a target format matched by target software;

[0013] The terminal transmits the third engineering data to the second server.

[0014] Optionally, the first engineering data includes first picture data and first point table data;

[0015] The terminal processes the first engineering data to obtain second engineering data in a standard format, including:

[0016] The terminal processes the first picture data to obtain second picture data in the standard format;

[0017] The terminal processes the first point table data to obtain point table data in the standard format.

[0018] Optionally, before the terminal converts the second engineering data into third engineering data in a target format matched by target software based on a preset conversion database when the data content of the first engineering data and the data content of the second engineering data are the same, the method includes:

[0019] Obtaining a first corresponding relationship library of picture data in the standard format and picture data in the target format;

[0020] Obtaining a second corresponding relationship library of picture data in the standard format and picture data in the target format;

[0021] Based on the first corresponding relationship library and the second corresponding relationship library, the preset conversion database is established.

[0022] Optionally, the terminal converts the second engineering data into third engineering data in a target format matched with the target software based on a preset conversion database, including:

[0023] The terminal converts the second picture data into third picture data in the target format based on a preset conversion database.

[0024] The terminal converts the second point table data into third point table data in the target format based on a preset conversion database.

[0025] Optionally, the area corresponding to the oil and gas pipeline station includes a pipeline network and a plurality of devices on the pipeline network, and the plurality of devices are connected with the first server through a network,

[0026] The first picture data includes a process flow diagram of the pipeline network of the area corresponding to the oil and gas pipeline station and a preset graphic of the plurality of devices.

[0027] The first point table data includes state data of the plurality of devices and address information of the plurality of devices in the network.

[0028] Optionally, the device has a monitoring component for acquiring state data of the device, and the monitoring component is connected with the first server through the network.

[0029] Optionally, the data acquisition and monitoring system includes a third server, and the method further includes:

[0030] The third server acquires fourth point table data of the data acquisition and monitoring system of the oil and gas pipeline;

[0031] The third server sends the fourth point table data to the storage;

[0032] The storage transmits the fourth point table data to the terminal;

[0033] The terminal processes the fourth point table data and converts the fourth point table data into fifth point table data in the target format matched with the target software.

[0034] Optionally, the terminal transmits the third engineering data to the second server, including:

[0035] The terminal checks the format of the third engineering data to determine whether the third engineering data is in the target format.

[0036] When the third engineering data is in the target format, the terminal transmits the third engineering data to the second server.

[0037] Optionally, the terminal comprises a display, and after the terminal checks the format of the third engineering data to determine whether the third engineering data is in the target format, the method further comprises

[0038] when the third engineering data is in the target format, displaying the third engineering data on the display.

[0039] According to another aspect of the present application, a data acquisition and monitoring system is provided, comprising a terminal of an oil and gas pipeline station, a first server, a second server and a memory;

[0040] The first server is configured to acquire first engineering data of a data acquisition and monitoring system of an oil and gas pipeline.

[0041] The first server is configured to send the first engineering data to the memory.

[0042] The memory is configured to transmit the first engineering data to the terminal.

[0043] The terminal is configured to process the first engineering data to obtain second engineering data in a standard format.

[0044] The terminal is configured to check the second engineering data based on the first engineering data to determine whether the data content of the first engineering data and the data content of the second engineering data are the same.

[0045] The terminal is configured to, when the data content of the first engineering data and the data content of the second engineering data are the same, convert the second engineering data into third engineering data in a target format matching a target software based on a preset conversion database, the preset conversion database comprising a correspondence between data in the standard format and data in the target format.

[0046] The terminal is configured to transmit the third engineering data to the second server.

[0047] The technical scheme provided by the embodiments of the present application has at least the following beneficial effects:

[0048] Provided is a data migration method of a data acquisition and monitoring system of an oil and gas pipeline, for a data acquisition and monitoring system of an oil and gas pipeline, which first converts engineering data of the data acquisition and monitoring system of the oil and gas pipeline in a first server into second engineering data in a standard format, then converts the second engineering data into third engineering data in a target format based on a preset conversion database, and migrates the third engineering data to a second server. The method first converts data into data in a standard format, and then converts the data in the standard format into data in a target format based on a preset conversion database, thereby realizing the conversion and migration process of standardized data, facilitating the conversion of data in various formats of various software into data in a target format, improving the efficiency of the conversion and migration of engineering data of the data acquisition and monitoring system of the oil and gas pipeline, and solving the problem of low efficiency of data conversion and migration in related technologies. BRIEF DESCRIPTION OF DRAWINGS

[0049] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings needed in the embodiment description will be briefly introduced. Obviously, the drawings in the following description are only some embodiments of the present application, and other drawings can be obtained by those skilled in the art without creative effort.

[0050] Figure 1 is a structural schematic diagram of a data acquisition and monitoring system provided by the embodiments of the present application;

[0051] Figure 2 is a flowchart of a data migration method of a data acquisition and monitoring system of an oil and gas pipeline shown by the embodiments of the present application;

[0052] Figure 3 is a flowchart of another data migration method of a data acquisition and monitoring system of an oil and gas pipeline shown by the embodiments of the present application;

[0053] Figure 4 is Figure 3 is a flowchart of the method shown in the embodiments of the present application to obtain second engineering data in a standard format;

[0054] Figure 5 is Figure 3 is a flowchart of the method shown in the embodiments of the present application to establish a preset conversion database;

[0055] Figure 6 is Figure 3 is a flowchart of the method shown in the embodiments of the present application to convert second engineering data into third engineering data;

[0056] Figure 7 is a flowchart of another data migration method of a data acquisition and monitoring system of an oil and gas pipeline shown by the embodiments of the present application.

[0057] The specific embodiments of the present application have been shown and described in the above drawings, and will be described in more detail hereinafter. The drawings and the written description are not intended to restrict the scope of the present application in any way, but to explain the present application to those skilled in the art by referring to a particular embodiment. DETAILED DESCRIPTION

[0058] In order to make the purposes, technical solutions and advantages of the present application clearer, the embodiments of the present application will be further described in detail below with reference to the drawings.

[0059] The data acquisition and monitoring system of the oil and gas pipeline refers to a distributed control system for realizing remote monitoring and automatic data acquisition of the pipeline by using computer technology. With the continuous upgrading of enterprise informatization, the development of different database technologies and the adoption of diversified new technologies, the PCS pipeline control system software in the data acquisition and monitoring control system of the domestic oil and gas pipeline is the core software of the oil and gas pipeline regulation and control business of China Petroleum. At present, some other software is still used for the oil and gas pipeline regulation and control business in the data acquisition and monitoring control system of the oil and gas pipeline.

[0060] At present, in the data acquisition and monitoring control system of the oil and gas pipeline, different software exists different graphics and databases, so that the PCS pipeline control system software cannot utilize the resources of some other related software, and further leads to the problems of repeated development of the data acquisition and monitoring control system of the oil and gas pipeline and waste of resources. Some other related software can include software ViewStar and OASyS.

[0061] An oil and gas pipeline data acquisition and monitoring system data migration method in the related art needs to set different engineering data conversion processes for different software, that is, the original engineering data is modified for different types of software, and then data migration is performed.

[0062] However, the above oil and gas pipeline data acquisition and monitoring system data migration method has a large workload, and leads to a long time and low efficiency of data conversion and migration of the oil and gas pipeline data acquisition and monitoring system.

[0063] The embodiments of the present application provide an oil and gas pipeline data acquisition and monitoring system data migration method, which can solve the problems in the above related art.

[0064] As shown in Figure 1 , the data migration method comprises the following steps. Figure 1is a structural schematic diagram of an oil and gas pipeline data acquisition and monitoring system provided by an embodiment of the present application. The oil and gas pipeline data acquisition and monitoring system can include a terminal 11 of an oil and gas pipeline station, a first server 12 of first software, a second server 13 of target software, a third server 14 of second software, and a storage 15. The storage 15 can be wiredly connected with the first server 12 of the first software, the third server 14 of the second software, and the terminal 11 of the oil and gas pipeline station. The terminal 11 can be wiredly or wirelessly connected with the second server 13 of the target software.

[0065] Figure 2 is a flowchart of a data migration method of an oil and gas pipeline data acquisition and monitoring system according to an embodiment of the present application. The method is described by taking the oil and gas pipeline data acquisition and monitoring system shown in Figure 1 as an example. The method can include the following steps.

[0066] Step 201: The first server acquires first engineering data of the oil and gas pipeline data acquisition and monitoring system.

[0067] Step 202: The first server sends the first engineering data to the storage.

[0068] Step 203: The storage transmits the first engineering data to the terminal.

[0069] Step 204: The terminal processes the first engineering data to obtain second engineering data in a standard format.

[0070] Step 205: The terminal checks the second engineering data based on the first engineering data to determine whether the data content of the first engineering data and the data content of the second engineering data are the same.

[0071] Step 206: When the data content of the first engineering data and the data content of the second engineering data are the same, the terminal converts the second engineering data into third engineering data based on a preset conversion database. The preset conversion database includes a corresponding relationship between data in the standard format and data in a target format matched by the target software.

[0072] Step 207: The terminal transmits the third engineering data to the second server.

[0073] The oil and gas pipeline data acquisition and monitoring system can include a PCS pipeline control system software and some other data acquisition and monitoring system software. The PCS pipeline control system software is the target software and can run on the second server. The some other data acquisition and monitoring system software can run on the first server.

[0074] In summary, this application provides a data migration method for an oil and gas pipeline data acquisition and monitoring system. The method first converts the engineering data of the oil and gas pipeline data acquisition and monitoring system in a first server into a standard format second engineering data. Then, based on a preset conversion database, the second engineering data is converted into a target format third engineering data, and the third engineering data is migrated to a second server. This method first uniformly converts the data into a standard format, and then converts the standard format data into the target format based on a preset conversion database. This achieves a standardized data conversion and migration process, facilitating the conversion of data from various software formats into the target format. It is highly efficient, solves the problem of low efficiency in data conversion and migration in related technologies, and improves the efficiency of engineering data migration in oil and gas pipeline data acquisition and monitoring systems.

[0075] Figure 3 This is a flowchart illustrating another data migration method for a data acquisition and monitoring system for oil and gas pipelines, as shown in an embodiment of this application. This embodiment applies this method. Figure 1 Taking the data acquisition and monitoring system of the shown oil and gas pipeline as an example, this method can include the following steps:

[0076] Step 301: The first server acquires the first engineering data of the oil and gas pipeline data acquisition and monitoring system.

[0077] The area corresponding to an oil and gas pipeline station includes the pipeline network and multiple devices on the pipeline network. These devices are connected to the primary service provider via a network, and the pipeline network may include multiple oil and gas pipelines.

[0078] The area corresponding to an oil and gas pipeline station can include the station itself and the area where the pipelines managed by that station are located.

[0079] The device has a monitoring component for acquiring device status data, and the monitoring component is connected to a first server via a network.

[0080] The equipment in the area corresponding to the aforementioned oil and gas pipeline station site may include one or more of the following: pumps, valves, air coolers, analyzers, compressors, heat exchangers, heaters, flow meters, filters, pigging devices, and oil mixing treatment devices. The first server can obtain the first engineering data from the first site's oil and gas pipeline data acquisition and monitoring system from the monitoring components.

[0081] The analyzer may include equipment for natural gas quality analysis, and the compressor may include an air compressor for compressing and pressurizing natural gas.

[0082] Step 302: The first server sends the first engineering data to the memory.

[0083] The first server can extract the first engineering data on a current oil and gas pipeline data acquisition and monitoring system, and send the extracted first engineering data to a storage, which can be a mobile hard disk used for saving the first engineering data.

[0084] In step 303, the storage transmits the first engineering data to a terminal.

[0085] In step 302, the storage uploads the first engineering data to the terminal through a transmission interface provided by the terminal, which can include various terminals such as desktop computers and notebook computers, and can be connected to the second server in a wired or wireless manner.

[0086] In step 304, the terminal processes the first engineering data to obtain second engineering data in a standard format.

[0087] The first engineering data includes first picture data and first point table data.

[0088] The first picture data includes a process flow diagram of a pipe network of an area corresponding to an oil and gas pipeline station and graphics of a plurality of preset devices. For example, the graphics of the plurality of preset devices can include graphics of preset valves and graphics of preset pumps.

[0089] The first point table data includes state data of the plurality of devices and address information of the plurality of devices in a network. For example, the first point table data can include a communication protocol, a network IP and a port, a collection period, a variable type, and a register address.

[0090] The collection period can include a period of collecting device data of software in the oil and gas pipeline data acquisition and monitoring system. For example, the collection period is 3 seconds.

[0091] The variable type can include a data type of data collected from a pipeline field device in real time. For example, the data type is an integer type or a floating point type.

[0092] As shown in FIG. 4, step 304 can include the following two sub-steps: Figure 4 In sub-step 3041, the terminal processes the first picture data to obtain second picture data in a standard format.

[0093]

[0094] ​After the terminal parses the first picture data, the terminal can first extract the basic drawing elements and the combined elements in the picture data, and then combine and draw the extracted basic drawing elements and the combined elements according to the format specified in the Enterprise Standard of China Petroleum Natural Gas Co., Ltd., PCS Software Engineering Data Organization, Storage and Exchange Specification (Q / SY BD 110-2020) and SCADA System Engineering Data Exchange Specification (Q / SY BD 111-2020) to obtain the second picture data in the standard format.

[0095] The combined elements can include the position, rotation angle and scaling factor of the basic drawing elements, and can be used to describe the combination of the basic drawing elements. The basic drawing elements can include straight lines, rectangles, circles, ellipses, polylines and polygons, and can be used to describe the process flow diagram of the pipe network and the graphics of the plurality of preset devices.

[0096] The sub-step 3042 is processing the first point table data by the terminal to obtain the second point table data in the standard format.

[0097] After the terminal parses the first point table data, the terminal can first extract the data in the point table data, and then insert the extracted data into the second point table in the standard format according to the format specified in the Enterprise Standard of China Petroleum Natural Gas Co., Ltd., PCS Software Engineering Data Organization, Storage and Exchange Specification (Q / SY BD 110-2020) and SCADA System Engineering Data Exchange Specification (Q / SY BD 111-2020) to obtain the second point table data in the standard format.

[0098] Further, the second engineering data including the second picture data and the second point table data can be obtained.

[0099] Step 305, the terminal checks the second engineering data based on the first engineering data to determine whether the data content of the first engineering data and the data content of the second engineering data are the same.

[0100] The terminal checks the second picture data and the second point table data based on the first picture data and the first point table data, that is, the terminal compares the data content of the first picture data and the second picture data, and compares the data content of the first point table data and the second point table data. If the data content of the first picture data and the second picture data is the same, and the data content of the first point table data and the second point table data is the same, step 306 is executed, and if the above data content is not the same, step 301 is executed.

[0101] Step 306, establishing a preset conversion database.

[0102] The preset conversion database includes a corresponding relationship between data in a standard format and data in a target format matched by the target software. According to the preset conversion database, the data in the standard format can be converted into the data in the target format matched by the target software. Since the engineering data can include picture data and point table data, the preset conversion database can be established by combining a corresponding relationship library of the picture data and a corresponding relationship library of the point table data.

[0103] As shown in FIG. 3, step 306 can include the following three sub-steps: Figure 5

[0104] Sub-step 3061, obtaining a first corresponding relationship library of the picture data in the standard format and the picture data in the target format.

[0105] The first corresponding relationship library can include a one-to-one corresponding relationship between a process flow diagram of a pipe network of a region corresponding to the oil and gas pipeline station and a preset plurality of device graphics in the picture data in the standard format and the picture data in the target format. The first corresponding relationship library can be established by a staff.

[0106] Sub-step 3062, obtaining a second corresponding relationship library of the point table data in the standard format and the point table data in the target format.

[0107] The second corresponding relationship library can include a one-to-one corresponding relationship between state data of a plurality of devices and address information of the plurality of devices in a network in the point table data in the standard format and the point table data in the target format. The second corresponding relationship library can be established by a staff.

[0108] Sub-step 3063, establishing a preset conversion database based on the first corresponding relationship library and the second corresponding relationship library.

[0109] According to the corresponding relationship library of the picture data and the corresponding relationship library of the point table data obtained respectively, the preset conversion database of the engineering data is established.

[0110] Step 307, when the data content of the first engineering data and the data content of the second engineering data are the same, the terminal converts the second engineering data into third engineering data based on the preset conversion database.

[0111] The terminal can convert the second picture data and the second point table data in the second engineering into third picture data and third point table data respectively based on the preset conversion database, where the third picture data can be third picture data in a target format, and the third point table data can be third point table data in the target format, i.e., the third engineering data can be engineering data in the target format.

[0112] ​The terminal analyzes the second picture data in the standard format, screens the graphic information of the device in the second picture data in the standard format, extracts the graphic information in the second picture data according to the target format of the target software, performs picture data drawing, and obtains third picture data in the target format.

[0113] The terminal can perform data auditing on the second point table data in the standard format according to the point table of the target software, compare the field name and type of the point table of the target software with the field name and type described by the extensible markup language of the second point table, and check the condition constraint of the database of the target software, extract the data in the second point table data according to the target format of the target software, and insert the data into the point table in the target format, to obtain third point table data in the target format.

[0114] The field name can include a device name, an IP address, and a data identifier (English: Long ID); and the type can refer to a data type.

[0115] The constraint condition in the database can define a rule of the data, that is, can guarantee the integrity of the data.

[0116] As shown in FIG. 7, step 307 can include the following two sub-steps: Figure 6

[0117] Sub-step 3071, the terminal converts the second picture data into third picture data in the target format based on the preset conversion database.

[0118] The terminal can convert the second picture data in the standard format into third picture data in the target format based on a first corresponding relationship library of the picture data in the standard format and the picture data in the target format in the preset conversion database.

[0119] Sub-step 3072, the terminal converts the second point table data into third point table data in the target format based on the preset conversion database.

[0120] The terminal can convert the second point table data in the standard format into third point table data in the target format based on a second corresponding relationship library of the point table data in the standard format and the point table data in the target format in the preset conversion database.

[0121] Step 308, the terminal checks the format of the third engineering data to determine whether the third engineering data is in the target format.

[0122] The terminal can determine whether the format of the third engineering data is correct according to the target format matched by the target software. If the format of the third engineering data is correct, step 309 is performed, and if the format of the third engineering data is incorrect, step 307 is performed.

[0123] ​Step 309, when the third engineering data is in the target format, the third engineering data is displayed through the display, and the terminal transmits the third engineering data to the second server.

[0124] The terminal can include a display for displaying a preview of the third engineering data generated by the terminal, so that the staff can check the completeness of the third engineering data and compare the converted third engineering data with the second engineering data in real time.

[0125] The terminal can transmit the third engineering data to the second server to realize the migration of the engineering data between the first server and the second server. For example, the third engineering data can be transmitted to the second server through the FileAccess provided by the second server.

[0126] Steps 3041 and 3042 can be performed simultaneously, and steps 3071 and 3072 can also be performed simultaneously, so as to improve the migration efficiency of the engineering data.

[0127] In summary, the embodiment of the present application provides a data migration method of an oil and gas pipeline data acquisition and monitoring system. The method is used for the oil and gas pipeline data acquisition and monitoring system. The method first converts the engineering data of the oil and gas pipeline data acquisition and monitoring system in the first server into second engineering data in a standard format, then converts the second engineering data into third engineering data in a target format based on a preset conversion database, and migrates the third engineering data to the second server. The method first converts the data into standard format data, and then converts the standard format data into target format data based on the preset conversion database, realizes the conversion and migration process of the standardized data, facilitates the conversion of data in various formats of various software into data in the target format, has high efficiency, solves the problem of low efficiency of data conversion and migration in related technologies, and improves the efficiency of the engineering data migration of the oil and gas pipeline data acquisition and monitoring system.

[0128] Figure 7 is another flowchart of a data migration method of an oil and gas pipeline data acquisition and monitoring system according to an embodiment of the present application. The method can include the following steps:

[0129] Step 401, the third server acquires fourth point table data of the oil and gas pipeline data acquisition and monitoring system.

[0130] The step 401 can refer to the step 301 in the above-mentioned Figure 3 embodiment, and the present application will not be described here.

[0131] Step 402, the third server sends the fourth point table data to the storage.

[0132] The step 402 can refer to the step 302 in the above embodiment, and details are not described herein again. Figure 3 The step 302 in the above embodiment, and details are not described herein again.

[0133] The step 403, the memory transmits the fourth point table data to the terminal.

[0134] The step 403 can refer to the step 303 in the above embodiment, and details are not described herein again. Figure 3 The step 303 in the above embodiment, and details are not described herein again.

[0135] The step 404, the terminal processes the fourth point table data, and converts the fourth point table data into fifth point table data in a target format matched with the target software.

[0136] The terminal can parse the fourth point table data, extract data in the fourth point table data, and output the extracted data in the target format matched with the target software, so as to obtain the fifth point table data.

[0137] The step 405, the terminal checks the format of the fifth point table data, to determine whether the fifth point table data is in the target format.

[0138] The terminal can determine whether the format of the fifth engineering data is correct according to the target format matched with the target software. If the format of the fifth engineering data is correct, the step 406 is executed, and if the format of the fifth engineering data is incorrect, the step 404 is executed.

[0139] The step 406, when the fifth point table data is in the target format, the terminal transmits the fifth point table data to the second server.

[0140] The terminal can transmit the fifth engineering data to the second server, to realize migration of engineering data between the third server and the second server.

[0141] In summary, the embodiment of the present application provides a data migration method of an oil and gas pipeline data acquisition and monitoring system, which is used for the oil and gas pipeline data acquisition and monitoring system. The method converts engineering data of the oil and gas pipeline data acquisition and monitoring system in the first server into second engineering data in a standard format, converts the second engineering data into third engineering data in a target format based on a preset conversion database, and migrates the third engineering data to the second server. The method converts data into standard format data first, and then converts the standard format data into target format data based on the preset conversion database, realizes conversion and migration process of standardized data, facilitates conversion of data in different formats of various software into data in the target format, has high efficiency, solves the problem of low efficiency of data conversion and migration in related technologies, and improves the efficiency of engineering data migration of the oil and gas pipeline data acquisition and monitoring system.

[0142] According to another aspect of the present application, a data acquisition and monitoring system is provided, as shown in the accompanying drawings, comprising a terminal 11 of an oil and gas pipeline station, a first server 12, a second server 13 and a storage 15. Figure 1

[0143] The first server 12 is configured to acquire first engineering data of the data acquisition and monitoring system of the oil and gas pipeline.

[0144] The first server 12 is configured to send the first engineering data to the storage 15.

[0145] The storage 15 is configured to transmit the first engineering data to the terminal 11.

[0146] The terminal 11 is configured to process the first engineering data to obtain second engineering data in a standard format.

[0147] The terminal 11 is configured to verify the second engineering data based on the first engineering data to determine whether the data content of the first engineering data and the data content of the second engineering data are the same.

[0148] The terminal 11 is configured to, when the data content of the first engineering data and the data content of the second engineering data are the same, convert the second engineering data into third engineering data in a target format matched with target software based on a preset conversion database, the preset conversion database comprising a corresponding relationship between data in the standard format and data in the target format.

[0149] The terminal 11 is configured to transmit the third engineering data to the second server 12.

[0150] The data acquisition and monitoring system can be installed in a Windows environment or a Linux environment, and can be integrated into the second server as a plug-in or independently installed and deployed.

[0151] ​In summary, the embodiment of the present application provides a data acquisition and monitoring system, which comprises a terminal of an oil and gas pipeline station, a first server, a second server and a memory. The terminal can convert engineering data of the data acquisition and monitoring system of the oil and gas pipeline in the first server into second engineering data in a standard format, convert the second engineering data into third engineering data in a target format based on a preset conversion database, and migrate the third engineering data to the second server. The method converts data into data in a standard format first, and then converts the data in the standard format into data in a target format based on a preset conversion database, so as to realize the conversion and migration process of standardized data, facilitate the conversion of data in various formats of various software into data in a target format, and improve the efficiency of the migration of engineering data of the data acquisition and monitoring system of the oil and gas pipeline.

[0152] In the present application, the terms "first", "second", "third", "fourth" and "fifth" are only used for descriptive purposes, and cannot be understood as indicating or implying relative importance. The term "a plurality of" refers to two or more, unless otherwise explicitly limited.

[0153] The above only describes optional embodiments of the present application and is not intended to limit the present application. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application shall be included in the protection scope of the present application.

Claims

1. A data migration method for an oil and gas pipeline data acquisition and monitoring system, characterized in that, A data acquisition and monitoring system is used, the data acquisition and monitoring system comprising: a terminal at an oil and gas pipeline station, a first server for first software, a second server for target software, and a storage device; the method comprises: The first server acquires the first engineering data of the oil and gas pipeline data acquisition and monitoring system; the first engineering data includes first screen data and first point table data; the first screen data includes a process flow diagram of the pipeline network in the area corresponding to the oil and gas pipeline station and graphics of multiple preset devices; the graphics of the multiple devices include preset valve graphics and preset pump graphics; the first point table data includes the status data of the multiple devices and the address information of the multiple devices in the network; the first point table data includes communication protocol, network IP and port, acquisition period, variable type and register address; The first server sends the first project data to the memory; The memory transmits the first engineering data to the terminal; The terminal processes the first engineering data to obtain second engineering data in a standard format. This processing includes: parsing the first screen data, extracting basic drawing elements and combined elements from the first screen data, and combining and drawing the extracted basic drawing elements and combined elements according to a specified format to obtain second screen data in a standard format. The combined elements include the position, rotation angle, and scaling factor of the basic drawing elements, and are used to describe the combination of the basic drawing elements. The basic drawing elements include straight lines, rectangles, circles, ellipses, polylines, and polygons, and are used to describe the process flow diagram of the pipeline network and the graphics of multiple preset devices. The terminal also parses the first point table data, extracts data from the first point table data, and inserts the extracted data into the second point table in a standard format according to a specified format to obtain second point table data in a standard format. The terminal verifies the second engineering data based on the first engineering data to determine whether the data content of the first engineering data and the data content of the second engineering data are the same. When the data content of the first engineering data and the data content of the second engineering data are the same, the terminal converts the second engineering data into third engineering data based on a preset conversion database. The preset conversion database includes the correspondence between the standard format data and the target format data matched by the target software. The terminal transmits the third engineering data to the second server.

2. The method according to claim 1, characterized in that, When the data content of the first engineering data and the data content of the second engineering data are the same, before the terminal converts the second engineering data into third engineering data in a target format that matches the target software based on a preset conversion database, the method includes: Obtain a first correspondence database between the standard format image data and the target format image data; Obtain a second correspondence database between the standard format point table data and the target format point table data; Based on the first correspondence database and the second correspondence database, the preset conversion database is established.

3. The method according to claim 1, characterized in that, The terminal, based on a preset conversion database, converts the second engineering data into third engineering data in a target format that matches the target software, including: The terminal converts the second screen data into the third screen data in the target format based on a preset conversion database; The terminal converts the second point table data into the third point table data in the target format based on a preset conversion database.

4. The method according to claim 1, characterized in that, The area corresponding to the oil and gas pipeline station site includes the pipeline network and multiple devices on the pipeline network, which are connected to the first service via a network.

5. The method according to claim 4, characterized in that, The device has a monitoring component for acquiring the device's status data, and the monitoring component is connected to the first server via the network.

6. The method according to claim 1, characterized in that, The data acquisition and monitoring system includes a third server, and the method further includes: The third server acquires the fourth point table data from the data acquisition and monitoring system of the oil and gas pipeline. The third server sends the fourth point table data to the memory; The memory transmits the fourth point table data to the terminal; The terminal processes the fourth point table data and converts it into a fifth point table data in the target format that matches the target software.

7. The method according to any one of claims 1-6, characterized in that, The terminal transmits the third engineering data to the second server, including: The terminal verifies the format of the third engineering data to determine whether the third engineering data is the target format. When the third engineering data is in the target format, the terminal transmits the third engineering data to the second server.

8. The method according to claim 7, characterized in that, The terminal includes a display. After the terminal verifies the format of the third engineering data to determine whether the third engineering data is in the target format, the method further includes: When the third engineering data is in the target format, the third engineering data is displayed on the monitor.

9. A data acquisition and monitoring system, characterized in that, include: The terminal, first server, second server, and storage device of the oil and gas pipeline station; The first server is used to acquire the first engineering data of the oil and gas pipeline data acquisition and monitoring system; the first engineering data includes first screen data and first point table data; the first screen data includes the process flow diagram of the pipeline network in the area corresponding to the oil and gas pipeline station and the graphics of multiple preset devices; the graphics of the multiple devices include the graphics of preset valves and preset pumps. The first point table data includes the status data of the multiple devices and the address information of the multiple devices in the network; the first point table data includes communication protocol, network IP and port, collection period, variable type and register address; The first server is used to send the first engineering data to the memory; The memory is used to transmit the first engineering data to the terminal; The terminal is used to process the first engineering data to obtain second engineering data in a standard format; The terminal is used to parse the first screen data, extract basic drawing elements and combined elements from the first screen data, and combine and draw the extracted basic drawing elements and combined elements according to a prescribed format to obtain standard format second screen data. The combined elements include the position, rotation angle, and scaling factor of the basic drawing elements, and are used to describe the combination of the basic drawing elements. The basic drawing elements include straight lines, rectangles, circles, ellipses, polylines, and polygons, and are used to describe the process flow diagram of the pipeline network and the graphics of multiple preset devices. After parsing the first point table data, the terminal extracts data from the first point table data and inserts the extracted data into the standard format second point table according to a prescribed format to obtain standard format second point table data. The terminal is used to verify the second engineering data based on the first engineering data to determine whether the data content of the first engineering data and the data content of the second engineering data are the same. The terminal is configured to, when the data content of the first engineering data and the data content of the second engineering data are the same, convert the second engineering data into third engineering data in a target format that matches the target software, based on a preset conversion database. The preset conversion database includes the correspondence between the standard format data and the target format data. The terminal is used to transmit the third engineering data to the second server.

Images