Engineering data management and sharing system for oil and gas pipeline SCADA systems

Abstract

The application discloses an oil and gas pipeline SCADA system engineering data management and sharing system, which comprises an engineering data management unit for acquiring PCS engineering data from a PCS and classifying and managing the PCS engineering data, and for transmitting the PCS engineering data into the PCS; and an engineering data management platform in communication connection with the engineering data unit, the engineering data management platform converts the PCS engineering data received from the engineering data management unit into SCADA engineering standard data for storage, and according to an HTTP request of the engineering data management unit, extracts the SCADA engineering standard data to convert into PCS engineering data, and returns the management data through a JSON string. The oil and gas pipeline SCADA system engineering data management and sharing system can realize classified management and automatic extraction of the PCS engineering data, realize static version management and dynamic baseline management functions of the engineering data, so that the engineering configuration process is traceable and can be rolled back, and important nodes of the engineering can be recorded.

Description

Technical Field

[0001] This invention relates to the field of oil and gas pipeline data management technology, and in particular to an engineering data management and sharing system for oil and gas pipeline SCADA systems. Background Technology

[0002] In traditional pipeline SCADA system construction, engineering data and the completed SCADA system are tied together. Engineering data cannot be shared between the various stages of design, construction and operation and maintenance. Moreover, different SCADA systems use their own engineering data storage formats, which are incompatible with each other, and the results of engineering construction cannot be reused between different SCADA systems.

[0003] During the construction and modification of a project, as well as changes or upgrades to the operating system, database, or unit version, incompatibility with the original project may occur. The debugging of the project relies entirely on manual labor, making it difficult to guarantee the standardization and correctness of the operation, resulting in a large workload and low efficiency.

[0004] The PCS (Pipeline Control System) is a domestically developed SCADA system for oil and gas pipelines by China National Petroleum Corporation (CNPC). The aforementioned problems encountered during the implementation of the project are mainly due to the closed data storage structure of the SCADA system, the lack of project management and version management in the PCS, and the difficulty in upgrading and maintaining the project. At the same time, the lack of automation tools leads to a large workload for project migration and conversion.

[0005] The information disclosed in this background section is intended only to enhance the understanding of the overall background of the invention and should not be construed as an admission or in any way implying that the information constitutes prior art known to those skilled in the art. Summary of the Invention

[0006] One of the objectives of this invention is to provide an engineering data management and sharing system for SCADA systems in oil and gas pipelines, thereby improving the problems of difficult engineering upgrades and maintenance, large workload and low efficiency in engineering migration and conversion of existing SCADA systems.

[0007] To achieve the above objectives, the present invention provides an engineering data management and sharing system for SCADA systems in oil and gas pipelines, comprising: an engineering data management unit, which is used to acquire PCS engineering data from the PCS and classify and manage it, and also to transmit the PCS engineering data into the PCS; and an engineering data management platform, which is communicatively connected to the engineering data unit. The engineering data management platform converts the PCS engineering data received from the engineering data management unit into SCADA engineering standard data for storage. Based on the HTTP request from the engineering data management unit, the engineering data management platform extracts the SCADA engineering standard data, converts it into PCS engineering data, and returns the management data via a JSON string.

[0008] Furthermore, in the above technical solution, the PCS engineering data includes the screen, pixels, acquisition points, SCADA points, calculation points, basic engineering configuration information, and engineering files.

[0009] Furthermore, in the above technical solution, the basic engineering configuration information includes basic information about the model, basic information about the panel, basic configuration of alarms, and basic configuration of historical storage.

[0010] Furthermore, in the above technical solution, the engineering documents include engineering-related design documents.

[0011] Furthermore, in the above technical solution, the engineering data management unit includes: an engineering information management module, which manages the basic configuration information of the PCS engineering data; an engineering point table data management module, which manages the collection points, calculation points, and SCADA points of the PCS engineering data; an engineering file management module, which manages the engineering files of the PCS engineering data; and an engineering screen management module, which manages the screens and pixels of the PCS engineering data.

[0012] Furthermore, in the above technical solution, the engineering information management module, engineering point table data management module, engineering file management module, and engineering screen management module of the engineering data management unit automatically extract the corresponding PCS engineering data, convert the corresponding PCS engineering data into SCADA engineering standard data, centrally store it on the engineering data management platform, and establish a PCS engineering dataset.

[0013] Furthermore, in the above technical solution, the engineering data management unit also includes: a version management module, which manages the versions of engineering-related data and documents during their evolution; a baseline management module, which creates a baseline for all documents of PCS engineering data when a preset milestone is reached, and performs baseline revision and / or maintenance, or version rollback and recovery, based on the needs of the PCS project or changes in the implementation process; and an engineering migration module, which is used for migrating PCS engineering data across platforms, across databases, or between different version units.

[0014] Furthermore, in the above technical solution, the version management module includes: an archive management module, which centrally stores archives on the server, allowing users to access files on the server via import and export after authorization by the system administrator; unauthorized users cannot access files on the server; a data file upgrade management module, which generates a new version on the server each time a file is imported, with each version of the file having detectable and editable attributes; a locking module, which protects files during updates to prevent conflicts when different users modify the same file; and a comparison module, which compares different versions of the file.

[0015] Furthermore, in the above technical solution, the baseline management module includes: a baseline configuration distribution module, which is used to perform baseline configuration for officially launched engineering projects; a baseline configuration checking module, which is used to check the matching degree between the baseline configuration and the engineering information; and a baseline configuration revision module, which is used to revise and / or maintain the baseline configuration according to the needs of the officially launched engineering projects or changes in the implementation process.

[0016] Furthermore, in the above technical solution, the migration includes mutual engineering conversion between PostgreSQL database and Oracle database, as well as engineering upgrades between different versions of PCS.

[0017] Furthermore, in the above technical solution, the engineering data management unit also includes: a system permission management module, which is used to manage users, roles, permissions, and login verification according to the system's preset security rules; and a log management module, which is used to record system operation events.

[0018] Furthermore, in the above technical solution, the engineering data management unit obtains PCS engineering data from PCS through File Access and JDBC provided by PCS.

[0019] Furthermore, in the above technical solution, the engineering data management unit transmits PCS engineering data to PCS through File Access and JDBC provided by PCS.

[0020] Furthermore, in the above technical solution, PCS engineering data is transmitted between the engineering data management unit and the engineering data management platform via FTP.

[0021] Compared with the prior art, the present invention has the following beneficial effects:

[0022] 1. This invention can address the needs of PCS project data management by enabling the classification management and automatic extraction of PCS project data.

[0023] 2. This invention enables static version management and dynamic baseline management of engineering data, making the engineering configuration process traceable and reversible, and allowing important engineering nodes to be recorded.

[0024] 3. This invention also enables cross-platform, cross-database, and compatible migration of PCS project datasets across different versions.

[0025] The above description is merely an overview of the technical solution of the present invention. In order to better understand the technical means of the present invention and to implement it according to the contents of the specification, and to make the above and other objects, technical features and advantages of the present invention easier to understand, one or more preferred embodiments are listed below and described in detail with reference to the accompanying drawings. Attached Figure Description

[0026] Figure 1 This is a data transmission diagram of an oil and gas pipeline SCADA system engineering data management and sharing system according to an embodiment of the present invention.

[0027] Figure 2 This is a structural block diagram of an engineering data management unit according to an embodiment of the present invention.

[0028] Figure 3 This is a schematic diagram of PCS engineering data relationships according to an embodiment of the present invention. Detailed Implementation

[0029] The specific embodiments of the present invention will now be described in detail with reference to the accompanying drawings, but it should be understood that the scope of protection of the present invention is not limited to the specific embodiments.

[0030] Unless otherwise expressly stated, throughout the specification and claims, the term "comprising" or its variations such as "including" or "comprises" shall be understood to include the stated elements or components without excluding other elements or other components.

[0031] In this document, for ease of description, spatial relative terms such as “below,” “under,” “down,” “above,” “above,” “up,” etc., are used to describe the relationship of one element or feature to another element or feature in the accompanying drawings. It should be understood that spatial relative terms are intended to encompass different orientations of an object in use or operation, in addition to those depicted in the figures. For example, if an object in the figure is flipped, an element described as “below” or “under” another element or feature would be oriented “above” that element or feature. Thus, the exemplary term “below” can encompass both the downward and upward orientations. An object may also have other orientations (rotated 90 degrees or other orientations), and the spatial relative terms used herein should be interpreted accordingly.

[0032] In this document, the terms "first," "second," etc., are used to distinguish two different elements or parts, and are not used to define specific positions or relative relationships. In other words, in some embodiments, the terms "first," "second," etc., can also be used interchangeably.

[0033] like Figure 1 As shown, the oil and gas pipeline SCADA system engineering data management and sharing system according to a specific embodiment of the present invention includes: an engineering data management unit, which is used to obtain PCS engineering data from the PCS and perform classification management, and is also used to transmit PCS engineering data into the PCS; and an engineering data management platform, which is communicatively connected to the engineering data unit. The engineering data management platform converts the PCS engineering data received from the engineering data management unit into SCADA engineering standard data for storage. According to the HTTP request of the engineering data management unit, the engineering data management platform extracts the SCADA engineering standard data, converts it into PCS engineering data, and returns the management data through a JSON string.

[0034] Furthermore, in one or more exemplary embodiments of the present invention, the engineering data management unit obtains PCS engineering data from the PCS via File Access and JDBC provided by the PCS, and then transmits it to the engineering data management platform via FTP. Furthermore, in one or more exemplary embodiments of the present invention, the engineering data management platform converts SCADA engineering standard data into PCS engineering data, and then transmits it to the engineering data management unit via FTP. The engineering data management unit then imports the PCS engineering data into the PCS via File Access and JDBC provided by the PCS. The engineering data management platform is responsible for the storage and management of SCADA standard engineering data, providing service interfaces for storage, management, and data conversion. The service interfaces are provided in HTTP format, and the interface data content is expressed in JSON format.

[0035] Furthermore, in one or more exemplary embodiments of the present invention, PCS engineering data includes different categories of engineering data such as point table data, engineering files, basic engineering configuration information, and screen data. Point table data includes acquisition points, SCADA points, and calculation points, while screen data includes images and pixels.

[0036] Furthermore, in one or more exemplary embodiments of the present invention, the basic engineering configuration information includes basic information about the model, basic information about the panel, basic configuration of alarms, and basic configuration of historical storage. Furthermore, in one or more exemplary embodiments of the present invention, the engineering files include engineering-related design documents.

[0037] Combination Figure 2As shown, in one or more embodiments of the present invention, the engineering data management unit includes: an engineering information management module for managing the basic engineering configuration information of the PCS engineering data; an engineering point table data management module for managing the acquisition points, calculation points, and SCADA points of the PCS engineering data; an engineering file management module for managing the engineering files of the PCS engineering data; and an engineering screen management module for managing the screens and pixels of the PCS engineering data.

[0038] Furthermore, in one or more exemplary embodiments of the present invention, the engineering information management module, engineering point table data management module, engineering file management module, and engineering screen management module of the engineering data management unit automatically extract the corresponding PCS engineering data from the PCS and convert the corresponding engineering data into SCADA engineering standard data, which is then centrally stored on the engineering data management platform to establish a PCS engineering dataset. Exemplarily, when the engineering data management unit automatically extracts the corresponding PCS engineering data, it reads the data according to different storage methods and storage locations for various types of data, such as pixels, screens, acquisition points, SCADA points, calculation points, engineering basic configuration information, and engineering files. Exemplarily, the engineering data is stored in file form (SCADA engineering standard data format); version information, change record information, and other relational description information are stored in the database. The standardized PCS engineering dataset is centrally stored and shared on the engineering data management platform, enabling engineering data entry and recovery in different PCS systems, achieving the sharing of engineering construction results. Simultaneously, since the standardized stored engineering data is independent of the platform and database, cross-platform, cross-database, and compatible migration and export of PCS engineering datasets with different software versions can be achieved.

[0039] Furthermore, in one or more exemplary embodiments of the present invention, the engineering data management unit further includes: a version management module, which manages the versions of engineering-related data and files during their evolution; a baseline management module, which creates a baseline for all PCS engineering data documents when a preset milestone is reached, to record the results of this stage as a whole, achieve overall backup, revise and / or maintain the baseline according to the needs of the PCS project or changes in the implementation process, or perform version rollback recovery; and an engineering migration module, which is used for migrating PCS engineering data across platforms, databases, or different version units. Exemplarily, as the engineering construction work progresses, PCS engineering data may change; basic engineering configuration information may be modified; engineering files may be added and modified; pixels, images, acquisition points, SCADA points, and calculation points may all be modified or added. Milestones are important stages divided according to the progress of the project. PCS project requirements include, for example, a project stipulation to upload backups weekly. Changes in the implementation process include, for example, modifications made due to changes in requirements causing changes in data such as images and acquisition points. Engineering migration includes, for example, version upgrades, server replacements, operating system or database system replacements, etc.

[0040] Furthermore, in one or more exemplary embodiments of the present invention, the version management module includes: an archive management module, which is used to centrally store archives on a server, and authorize various users to access files on the server through import and export methods after authorization by the system administrator; unauthorized users cannot access files on the server; a data file upgrade management module, which is used to generate a new version on the server each time a file is imported, and each version of the file has checkable and editable attributes, and any version can be checked out and edited at any time; a locking module, which is used to protect files when they are updated to avoid conflicts when different users modify the same file; and a comparison module, which is used to compare different versions of files. Here, "archives" is a general term for the centrally stored PCS project data, and "files" is the storage format of the centrally stored PCS project data.

[0041] Furthermore, in one or more exemplary embodiments of the present invention, the baseline management module includes: a baseline configuration distribution module, used for baseline configuration of officially launched engineering projects; a baseline configuration checking module, used for verifying the matching degree between the baseline configuration and engineering information; and a baseline configuration revision module, used for revising and / or maintaining the baseline configuration according to the needs of the officially launched engineering project or changes in the implementation process. "Engineering information" is included in "engineering basic configuration information," such as information about which pipelines and which stations. "Officially launched engineering projects" refers to projects that have completed construction and are officially put into operation, i.e., have moved from the construction phase to the operation phase.

[0042] Furthermore, in one or more exemplary embodiments of the present invention, migration includes mutual engineering conversion between PostgreSQL databases and Oracle databases, as well as engineering upgrades between different versions of PCS.

[0043] Furthermore, in one or more exemplary embodiments of the present invention, the engineering data management unit further includes: a system permission management module, which is used to perform user management, role management, permission management and login verification according to the system's preset security rules; and a log management module, which is used to record system operation events.

[0044] Furthermore, in one or more exemplary embodiments of the present invention, user management includes creating, modifying, and deleting users; role management includes creating, modifying, and deleting roles; permission management includes defining role permissions and allocating permissions; login verification includes password verification and permission verification.

[0045] Furthermore, in one or more exemplary embodiments of the present invention, the logs include event logs and message logs. The log management module plays a crucial role in processing historical data, diagnosing and tracking problems, and understanding system activity, including log recording, log viewing, and log filtering.

[0046] Furthermore, in one or more exemplary embodiments of the present invention, the engineering data management unit must be deployed in the production network together with the engineering data management platform. The engineering data management unit can be installed in a Windows environment or a Linux environment; it can be integrated into the PCS as a plug-in or installed and deployed independently; and some functions can be operated through a browser.

[0047] Combination Figure 2 As shown, in one or more embodiments of the present invention, the oil and gas pipeline SCADA system engineering data management and sharing system extracts PCS engineering data from the PCS project for storage and management. PCS engineering data mainly includes point table data, screen data, basic engineering configuration information, and engineering documents. During the management of PCS engineering data, the oil and gas pipeline SCADA system engineering data management and sharing system generates version information of the PCS engineering data evolution process. When the project reaches a certain milestone, a baseline is created for each data version of the PCS engineering data, generating milestone baseline information for the PCS engineering data. When the PCS software is upgraded, the PCS engineering data can be migrated to the PCS software to generate a PCS project.

[0048] The foregoing description of specific exemplary embodiments of the present invention is for illustrative and explanatory purposes. These descriptions are not intended to limit the invention to the precise forms disclosed, and it will be apparent that many changes and variations can be made in accordance with the foregoing teachings. The exemplary embodiments were chosen and described in order to explain the specific principles of the invention and its practical application, thereby enabling those skilled in the art to implement and utilize various different exemplary embodiments of the invention, as well as various different choices and variations. Any simple modifications, equivalent changes, and alterations made to the foregoing exemplary embodiments should fall within the scope of protection of the present invention.

Claims

1. A data management and sharing system for an oil and gas pipeline SCADA system, characterized in that, include: The engineering data management unit is used to acquire and classify PCS engineering data from the PCS, and also to transfer PCS engineering data into the PCS. The PCS engineering data includes images, pixels, acquisition points, SCADA points, calculation points, basic engineering configuration information, and engineering files; and An engineering data management platform is communicatively connected to the engineering data unit. The engineering data management platform converts the PCS engineering data received from the engineering data management unit into SCADA engineering standard data for storage. The engineering data management platform extracts SCADA engineering standard data and converts it into PCS engineering data according to the HTTP request of the engineering data management unit, and returns the management data through a JSON string. The engineering information management module, engineering point table data management module, engineering file management module, and engineering screen management module of the engineering data management unit automatically extract the corresponding PCS engineering data, convert the corresponding engineering data into SCADA engineering standard data, and centrally store it on the engineering data management platform to establish a PCS engineering dataset. The baseline management module of the engineering data management unit is used to create a baseline for all documents of PCS engineering data when a preset milestone is reached. Based on the needs of the PCS project or changes in the implementation process, the baseline is revised and / or maintained, or version rollback is performed.

2. The oil and gas pipeline SCADA system engineering data management and sharing system according to claim 1, characterized in that, The basic configuration information of the project includes basic information about the model, basic information about the panel, basic configuration of alarms, and basic configuration of historical storage.

3. The oil and gas pipeline SCADA system engineering data management and sharing system according to claim 1, characterized in that, The project documents include project-related design documents.

4. The oil and gas pipeline SCADA system engineering data management and sharing system according to claim 1, characterized in that, The engineering information management module is used to manage the basic configuration information of PCS engineering data; The engineering point table data management module is used to manage the collection points, calculation points, and SCADA points of PCS engineering data; The project file management module is used to manage project files for PCS project data; and The engineering screen management module is used to manage the screen and pixels of PCS engineering data.

5. The oil and gas pipeline SCADA system engineering data management and sharing system according to claim 4, characterized in that, The engineering data management unit also includes: The version management module is used to manage the version evolution of project-related data and files; and The project migration module is used for migrating PCS project data across platforms, databases, or different version units.

6. The oil and gas pipeline SCADA system engineering data management and sharing system according to claim 5, characterized in that, The version management module includes: The file management module is used to centrally store files on the server. The system administrator authorizes each user to access the files on the server through import and export. Unauthorized users cannot access the files on the server. The data file upgrade management module is used to generate a new version on the server each time a file is imported. Each version of the file has detectable and editable attributes. A locking module is used to protect files during updates, preventing conflicts when different users modify the same file; and The comparison module is used to compare different versions of a file.

7. The oil and gas pipeline SCADA system engineering data management and sharing system according to claim 1, characterized in that, The baseline management module includes: Distribute the baseline configuration module, which is used to configure the baseline for the officially launched engineering project; The baseline configuration check module is used to verify the matching degree between the baseline configuration and the project information; and The baseline configuration revision module is used to revise and / or maintain the baseline configuration based on the needs of the officially launched project or changes during the implementation process.

8. The oil and gas pipeline SCADA system engineering data management and sharing system according to claim 5, characterized in that, The migration includes mutual engineering conversion between PostgreSQL and Oracle databases, as well as engineering upgrades between different versions of PCS.

9. The oil and gas pipeline SCADA system engineering data management and sharing system according to claim 1, characterized in that, The engineering data management unit also includes: The system access control module is used for user management, role management, access control, and login verification based on preset system security rules; and The log management module is used to record system operation events.

10. The SCADA system for oil and gas pipelines as described in claim 1, characterized in that, The engineering data management unit obtains PCS engineering data from PCS through File Access and JDBC provided by PCS.

11. The oil and gas pipeline SCADA system engineering data management and sharing system according to claim 1, characterized in that, The engineering data management unit transmits PCS engineering data to PCS via File Access and JDBC provided by PCS.

12. The oil and gas pipeline SCADA system engineering data management and sharing system according to claim 1, characterized in that, The PCS project data is transferred between the project data management unit and the project data management platform via FTP.

Images