KR102685110B1 - Apparatus and method for database preprocessing for unconventional oil production plants - Google Patents

Abstract

A database preprocessing device and method for an unconventional oil production plant are disclosed. The database preprocessing method for unconventional oil production plants includes the steps of receiving sensor data from a plurality of sensors installed in the unconventional oil production plant, temporarily storing the input sensor data, and transferring it to the database for monitoring of the unconventional oil production plant. A step of determining whether sensor data exists, if previous sensor data exists in the database, a step of comparing the temporarily stored sensor data with the previous sensor data, a step of determining whether the temporarily stored sensor data is abnormal data, a step of determining whether the temporarily stored sensor data is abnormal data, When it is determined that the sensor data is abnormal data, the method includes adding a key value indicating abnormal data to the temporarily stored sensor data and storing the sensor data with the added key value in a database.

Description

Database preprocessing apparatus and method for unconventional oil production plants {Apparatus and method for database preprocessing for unconventional oil production plants}

The present invention relates to a database preprocessing device and method for an unconventional oil production plant.

Due to the increase in international oil prices around the world, competition to secure oil resources and develop alternative energy is active around the world. Canada is the world's 22nd largest oil producing country, and has recently been pursuing more active investment and development as the profitability of oil sands has increased.

As ICT technology develops, much research is being conducted in the field of resource development to introduce information and communication technologies, including smart mines and digital oil fields. As ICT technology has advanced, monitoring systems have evolved, and recently, engineers have been able to monitor all on-site facilities from their offices and manage and operate production plants without having to visit the site in person.

In particular, as technologies related to the Fourth Industrial Revolution, such as big data and artificial intelligence, have recently emerged, the development of related application technologies to improve the efficiency and stability of resource development is being actively conducted. Among these information and communication technologies, digital twin is evaluated as a core technology. To put it simply, a digital twin means an exact replica of an object in reality in the virtual world. Here, replication refers not to simple data acquired from field research, but to acquiring real-time data of a real object and reflecting the volatility of the data to closely replicate the change pattern of the object. Since the digital twin implemented in this way reflects the characteristics or changes of objects in complex reality, it is used to quickly diagnose the current state of the object or predict future situations.

Unlike general oil production plants, in the case of oil sand production plants, the number of sensors increases rapidly as the number of processing facilities increases. Therefore, in order to implement a real-time monitoring system for an oil sands production plant, technology is needed to efficiently store large amounts of data in a database and transmit it to a monitoring device.

Republic of Korea Patent Publication No. 10-2594835 (2023.10.24)

The present invention relates to a non-traditional oil production plant that efficiently stores a large amount of sensor data obtained from a number of sensors installed in each facility of the non-traditional oil production plant in a database and transmits it to a monitoring device for monitoring of the non-traditional oil production plant. It is intended to provide a database preprocessing device and method.

According to one aspect of the present invention, a database preprocessing method for a non-traditional oil production plant performed by a database preprocessing device is disclosed.

A database preprocessing method for an unconventional oil production plant according to an embodiment of the present invention includes receiving sensor data from a plurality of sensors installed in the unconventional oil production plant for monitoring the unconventional oil production plant, the input sensor temporarily storing data, determining whether previous sensor data exists in the database, comparing the temporarily stored sensor data with the previous sensor data if the previous sensor data exists in the database, the temporary determining whether the stored sensor data is abnormal data; if it is determined that the temporarily stored sensor data is abnormal data, adding a key value indicating that the temporarily stored sensor data is abnormal data; and the key value is It includes storing the added sensor data in a database.

In the step of determining whether the temporarily stored sensor data is abnormal data, if the difference between the temporarily stored sensor data and the previous sensor data exceeds a preset tolerance, the temporarily stored sensor data is determined to be abnormal data.

The database preprocessing method includes, when it is determined that the temporarily stored sensor data is not abnormal data, determining whether the temporarily stored sensor data matches the previous sensor data, and determining whether the temporarily stored sensor data matches the previous sensor data. If there is a match, the method further includes performing deduplication by removing the temporarily stored sensor data and storing the currently stored data as empty data in the database.

The database preprocessing method includes reading sensor data stored in the database in order to transmit the sensor data stored in the database to a monitoring device, checking whether the key value exists in the read sensor data, If a key value exists in the read sensor data, transmitting an alarm message indicating that the sensor data to be transmitted at the current time is abnormal data to the monitoring device and transmitting the read sensor data to the monitoring device. Includes more.

The database preprocessing method includes, when a key value does not exist in the read sensor data, checking whether the read sensor data is empty data, and if the read sensor data is empty data, transferring it from the database. It further includes reading sensor data and transmitting the read previous sensor data as current sensor data to the monitoring device.

According to another aspect of the present invention, a database preprocessing device for an unconventional oil production plant is disclosed.

A database preprocessing device for a non-traditional oil production plant according to an embodiment of the present invention includes a memory for storing instructions and a processor for executing the instructions, wherein the instructions are for monitoring the non-traditional oil production plant. Receiving sensor data from a plurality of sensors installed in the oil production plant, temporarily storing the input sensor data, determining whether previous sensor data exists in the database, and determining whether the previous sensor data exists in the database. In this case, comparing the temporarily stored sensor data with the previous sensor data, determining whether the temporarily stored sensor data is abnormal data, if it is determined that the temporarily stored sensor data is abnormal data, the temporarily stored sensor data A database preprocessing method is performed including adding a key value indicating abnormal data to the data and storing sensor data with the added key value in a database.

A database preprocessing device and method for a non-traditional oil production plant according to an embodiment of the present invention efficiently collects a large amount of sensor data obtained from a plurality of sensors installed in each facility of the non-traditional oil production plant for monitoring of the non-traditional oil production plant. By storing it in a database and transmitting it to a monitoring device, real-time monitoring of production plant facilities is possible without restrictions on the user environment, and facility operators can quickly check for abnormalities to enable stable production plant operation. .

1 is a diagram schematically illustrating the configuration of a monitoring system for an unconventional oil production plant according to an embodiment of the present invention.
Figure 2 is a diagram showing an example of a screen output by a human machine interface device.
Figure 3 is a flow chart schematically illustrating a database preprocessing method for a non-traditional oil production plant performed by a database preprocessing device according to an embodiment of the present invention.
Figure 4 is a flow chart schematically illustrating a database preprocessing method for a non-traditional oil production plant performed by a database preprocessing device according to another embodiment of the present invention.
Figure 5 is a diagram schematically illustrating the configuration of a database preprocessing device for an unconventional oil production plant according to an embodiment of the present invention.

As used herein, singular expressions include plural expressions unless the context clearly dictates otherwise. In this specification, terms such as “consists of” or “comprises” should not be construed as necessarily including all of the various components or steps described in the specification, and some of the components or steps may include It may not be included, or it should be interpreted as including additional components or steps. In addition, terms such as "... unit" and "module" used in the specification refer to a unit that processes at least one function or operation, which may be implemented as hardware or software, or as a combination of hardware and software. .

Hereinafter, various embodiments of the present invention will be described in detail with reference to the attached drawings.

Figure 1 is a diagram schematically illustrating the configuration of a monitoring system for an unconventional oil production plant according to an embodiment of the present invention.

Referring to FIG. 1, the monitoring system for an unconventional oil production plant according to an embodiment of the present invention includes a database preprocessing device 100, a plurality of sensors 200 installed in the unconventional oil production plant equipment 10, and a monitoring device 300. ) and a human machine interface (HMI: Human Machine Interface) device 400.

In order to monitor the unconventional oil production plant equipment 10, the database preprocessing device 100 collects a large amount of sensor data from a plurality of sensors 200 installed in each equipment of the non-traditional oil production plant and efficiently stores it in a database. It performs the function of transmitting this to the monitoring device 300.

A plurality of sensors 200 perform sensing on the non-traditional oil production plant equipment 10 and generate a large amount of sensor data.

For example, unlike a typical oil production plant, in the case of an oil sands production plant, the number of sensors increases rapidly as the number of processing facilities increases. Therefore, the database preprocessing device 100 according to an embodiment of the present invention provides mass data acquired through a plurality of sensors 200 in order to support real-time monitoring of the monitoring device 300 for the non-traditional oil production plant equipment 10. Preprocessing of sensor data can be performed.

The monitoring device 300 performs real-time monitoring of the non-traditional oil production plant equipment 10 by receiving and monitoring a large amount of sensor data pre-processed from the database pre-processing device 100.

The human machine interface device 400 receives and outputs real-time monitoring results for the non-traditional oil production plant equipment 10 from the monitoring device 300 and provides various functions to the user.

For example, Figure 2 is a diagram showing an example of a screen output by a human machine interface device. As shown in FIG. 2, the human machine interface device 400 can provide one screen to check the entire production plant and three screens to check detailed data of the selected facility.

That is, the human machine interface device 400 provides a non-traditional oil production plant diagram screen, a real-time data monitoring screen within the facility, a facility specifications screen, a data graph visualization screen, a messaging function between users, and a real-time notification function for abnormal data.

Here, the non-traditional oil production plant diagram screen is a monitoring screen configured for the entire production plant so that key data and production flow of the entire production plant can be checked at once.

In addition, the real-time data monitoring screen within the facility displays detailed data of the selected facility and displays previously measured data along with currently measured data so that changes in data can be confirmed.

Additionally, the equipment specifications screen is a screen that displays a 3D model of the equipment and an image of the field equipment, along with the equipment specifications.

And, the data graph visualization screen is a screen that visualizes and displays the time series data of each facility as a graph.

Additionally, the user-to-user messaging function is a function for sending and receiving messages with various connected users. In particular, it provides a messaging function that allows immediate communication between workers and engineers at the production plant site.

In addition, the real-time notification function for abnormal data is a function that outputs an error message on the monitoring screen when abnormal data occurs so that the user can quickly identify abnormalities in the equipment.

Figure 3 is a flowchart schematically illustrating a database preprocessing method for a non-traditional oil production plant performed by a database preprocessing device according to an embodiment of the present invention.

In step S310, the database preprocessing device 100 receives sensor data from a plurality of sensors 200 installed in the non-traditional oil production plant equipment 10 in order to monitor the non-traditional oil production plant equipment 10.

In step S320, the database preprocessing device 100 temporarily stores the input sensor data.

In step S330, the database preprocessing device 100 determines whether previous sensor data exists in the database.

Here, sensor data may be stored in time series in the database.

In step S340, if previous sensor data exists in the database, the database preprocessing device 100 compares the temporarily stored sensor data with the previous sensor data.

In step S350, the database preprocessing device 100 determines whether the temporarily stored sensor data is abnormal data as a result of the comparison.

That is, when the difference between the temporarily stored sensor data and the previous sensor data exceeds a preset tolerance, the database preprocessing device 100 may determine the temporarily stored sensor data to be abnormal data.

In step S360, when the database preprocessing device 100 determines that the temporarily stored sensor data is abnormal data, it adds a key value indicating that the temporarily stored sensor data is abnormal data.

In step S370, the database preprocessing device 100 stores sensor data to which a key value has been added in the database.

In step S380, when the database preprocessing device 100 determines that the temporarily stored sensor data is not abnormal data, it determines whether the temporarily stored sensor data matches previous sensor data.

In step S390, if the temporarily stored sensor data matches the previous sensor data as a result of the determination, the database preprocessing device 100 removes the temporarily stored sensor data to perform deduplication.

Afterwards, the database preprocessing apparatus 100 enters step S370 and stores the data currently stored in the database as empty data.

As a result of the determination in step S330, if there is no previous sensor data in the database, the database preprocessing device 100 immediately stores the temporarily stored sensor data in the database.

Figure 4 is a flowchart schematically illustrating a database preprocessing method for a non-traditional oil production plant performed by a database preprocessing device according to another embodiment of the present invention.

In step S410, the database preprocessing device 100 reads sensor data stored in the database in order to transmit the sensor data stored in the database to the monitoring device 300.

For example, the database preprocessing device 100 may sequentially read sensor data stored in time series in the database from the first time.

In step S420, the database preprocessing device 100 checks whether a key value indicating abnormal data exists in the read sensor data.

In step S430, if a key value exists in the read sensor data, the database preprocessing device 100 transmits an alarm message indicating that the sensor data to be transmitted at the current time is abnormal data to the monitoring device 300.

In step S440, the database preprocessing device 100 transmits the read sensor data to the monitoring device 300.

Here, the monitoring device 300 may recognize that the received sensor data is abnormal data by checking the keypad included in the received sensor data.

In step S450, if the key value does not exist in the read sensor data, the database preprocessing device 100 checks whether the read sensor data is empty data.

In step S460, the database preprocessing device 100 reads previous sensor data from the database when the read sensor data is empty data.

Thereafter, the database preprocessing device 100 enters step S440 and transmits the previously read sensor data as current sensor data to the monitoring device 300.

As a result of the determination in step S450, if the read sensor data is not empty data, the database preprocessing device 100 directly transmits the read sensor data to the monitoring device 300.

Figure 5 is a diagram schematically illustrating the configuration of a database preprocessing device for an unconventional oil production plant according to an embodiment of the present invention.

Referring to FIG. 5, the database preprocessing device 100 for a non-traditional oil production plant according to an embodiment of the present invention includes a processor 110, a memory 120, a communication unit 130, and an interface unit 140.

The processor 110 may be a CPU or a semiconductor device that executes processing instructions stored in the memory 120.

Memory 120 may include various types of volatile or non-volatile storage media. For example, memory 120 may include ROM, RAM, etc.

For example, the memory 120 may store instructions for performing a database preprocessing method for a non-traditional oil production plant according to an embodiment of the present invention.

The communication unit 130 is a means for transmitting and receiving data with other devices through a communication network.

The interface unit 140 may include a network interface and a user interface for accessing a network.

Meanwhile, the components of the above-described embodiment can be easily understood from a process perspective. In other words, each component can be understood as a separate process. Additionally, the processes of the above-described embodiments can be easily understood from the perspective of the components of the device.

Additionally, the technical contents described above may be implemented in the form of program instructions that can be executed through various computer means and recorded on a computer-readable medium. The computer-readable medium may include program instructions, data files, data structures, etc., singly or in combination. Program instructions recorded on the medium may be specially designed and configured for the embodiments or may be known and available to those skilled in the art of computer software. Examples of computer-readable recording media include magnetic media such as hard disks, floppy disks, and magnetic tapes, optical media such as CD-ROMs and DVDs, and magnetic media such as floptical disks. -Includes optical media (magneto-optical media) and hardware devices specifically configured to store and execute program instructions, such as ROM, RAM, flash memory, etc. Examples of program instructions include machine language code, such as that produced by a compiler, as well as high-level language code that can be executed by a computer using an interpreter, etc. A hardware device may be configured to operate as one or more software modules to perform the operations of the embodiments, and vice versa.

The above-described embodiments of the present invention have been disclosed for illustrative purposes, and those skilled in the art will be able to make various modifications, changes, and additions within the spirit and scope of the present invention, and such modifications, changes, and additions will be possible. should be regarded as falling within the scope of the patent claims below.

10: Non-traditional oil production plant equipment
100: database preprocessing unit
110: processor
120: memory
130: Department of Communications
140: Interface unit
200: plurality of sensors
300: monitoring device
400: Human Machine Interface (HMI) device

Claims (6)

In the database preprocessing method for a non-traditional oil production plant performed by a database preprocessing device,
In order to monitor the unconventional oil production plant, receiving sensor data from a plurality of sensors installed in the unconventional oil production plant;
Temporarily storing the input sensor data;
determining whether previous sensor data exists in the database;
If the previous sensor data exists in the database, comparing the temporarily stored sensor data with the previous sensor data;
determining whether the temporarily stored sensor data is abnormal data;
When it is determined that the temporarily stored sensor data is abnormal data, adding a key value indicating that the temporarily stored sensor data is abnormal data;
storing sensor data to which the key value is added in a database;
Reading sensor data stored in the database to transmit the sensor data stored in the database to a monitoring device;
checking whether the key value exists in the read sensor data;
If a key value exists in the read sensor data, transmitting an alarm message indicating that the sensor data to be transmitted at the current time is abnormal data to the monitoring device; and
A database preprocessing method for a non-traditional oil production plant comprising transmitting the read sensor data to the monitoring device.
According to paragraph 1,
The step of determining whether the data is abnormal is,
A database preprocessing method for a non-traditional oil production plant, characterized in that when the difference between the temporarily stored sensor data and the previous sensor data exceeds a preset tolerance, the temporarily stored sensor data is determined as abnormal data.
According to paragraph 1,
The database preprocessing method is,
If it is determined that the temporarily stored sensor data is not abnormal data, determining whether the temporarily stored sensor data matches the previous sensor data;
If the temporarily stored sensor data matches the previous sensor data, performing deduplication by removing the temporarily stored sensor data; and
A database preprocessing method for an unconventional oil production plant, further comprising the step of storing currently stored data as empty data in the database.
delete According to paragraph 1,
The database preprocessing method is,
When a key value does not exist in the read sensor data, checking whether the read sensor data is empty data;
If the read sensor data is empty data, reading previous sensor data from the database; and
A database preprocessing method for a non-traditional oil production plant, further comprising transmitting the read previous sensor data as current sensor data to the monitoring device.
In the database preprocessing device for an unconventional oil production plant,
Memory for storing instructions; and
Including a processor that executes the instructions,
The command is:
In order to monitor the unconventional oil production plant, receiving sensor data from a plurality of sensors installed in the unconventional oil production plant;
Temporarily storing the input sensor data;
determining whether previous sensor data exists in the database;
If the previous sensor data exists in the database, comparing the temporarily stored sensor data with the previous sensor data;
determining whether the temporarily stored sensor data is abnormal data;
When it is determined that the temporarily stored sensor data is abnormal data, adding a key value indicating that the temporarily stored sensor data is abnormal data;
Storing the sensor data to which the key value is added in a database;
Reading sensor data stored in the database to transmit the sensor data stored in the database to a monitoring device;
checking whether the key value exists in the read sensor data;
If a key value exists in the read sensor data, transmitting an alarm message indicating that the sensor data to be transmitted at the current time is abnormal data to the monitoring device; and
A database preprocessing device for a non-traditional oil production plant, characterized in that performing a database preprocessing method including transmitting the read sensor data to the monitoring device.

Images