Database preprocessing device and method for non-traditional oil production plants

Abstract

To provide an apparatus and method for database preprocessing for unconventional oil production plants.SOLUTION: A database preprocessing method of a database preprocessing apparatus includes the steps of: inputting sensor data from a plurality of sensors installed in an unconventional oil production plant, for monitoring the unconventional oil production plant; temporarily storing the input sensor data; determining whether previous sensor data exists in the database; comparing, when the previous data exists in the database, the temporarily stored sensor data with the previous sensor data; determining that the temporarily stored sensor data is abnormal or not; adding, when the temporarily stored sensor data is determined to be abnormal, a key value indicating that the temporality stored sensor data is abnormal; and storing the sensor data with the key value added thereto in the database.SELECTED DRAWING: Figure 3

Description

[Technical Field]

[0001] The present invention relates to a database pre-processing system and method for non-traditional oil producing plants. [Background technology]

[0002] As international crude oil prices rise worldwide, competition to secure oil resources and develop alternative energy sources is intensifying. Canada is the world's 22nd largest oil producer, and in recent years, the profitability of its oil sands has improved, leading to more aggressive investment and development.

[0003] With the development of ICT technology, much research is being conducted in the resource development field aiming to introduce information and communication technology, including smart mines and digital oil fields. Advances in ICT technology have also led to the development of monitoring systems, and recently, engineers can monitor all on-site equipment from their offices, allowing them to manage and operate production plants without having to visit the site in person.

[0004] In particular, as technologies related to the Fourth Industrial Revolution, such as big data and artificial intelligence, have been gaining attention in recent years, active development of related applied technologies to improve the efficiency and safety of resource development is underway. Among these information and communication technologies, digital twins are considered one of the key technologies. Simply put, a digital twin is a replica of a real-world object in a virtual world. "Replication" here refers to acquiring real-time data of a real-world object, rather than simply data acquired through on-site surveys, and reflecting the variability of that data to realistically mimic the changes in the object. Digital twins thus realized can be used to quickly diagnose the current state of an object or predict future conditions by reflecting the characteristics and changes of complex real-world objects.

[0005] Unlike typical oil production plants, the number of sensors in oil sands production plants increases dramatically as the number of processing facilities increases. Therefore, in order to realize a real-time monitoring system for oil sands production plants, technology is needed to efficiently store large amounts of data in a database and transmit it to monitoring devices. [Prior art documents] [Patent documents]

[0006] [Patent Document 1] Korean Patent Registration No. 10-2594835 Summary of the Invention [Problem to be solved by the invention]

[0007] The present invention provides a database pre-processing device and method for a non-traditional oil production plant, which efficiently stores a large amount of sensor data acquired from a large number of sensors installed in each facility of the non-traditional oil production plant in a database and transmits the data to a monitoring device for monitoring the non-traditional oil production plant. [Means for solving the problem]

[0008] According to one aspect of the present invention, a database pre-processing method for a non-traditional oil production plant is disclosed, which is executed by a database pre-processing device.

[0009] A database pre-processing method for a non-traditional oil production plant according to an embodiment of the present invention includes the steps of inputting sensor data from a plurality of sensors installed in the non-traditional oil production plant for monitoring the non-traditional oil production plant, temporarily storing the input sensor 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, determining whether the temporarily stored sensor data is abnormal data, and 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 to the temporarily stored sensor data, and storing the sensor data with the added key value in the database.

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

[0011] The database preprocessing method further includes a step of determining whether the temporarily stored sensor data matches the previous sensor data when it is determined that the temporarily stored sensor data is not abnormal data; a step of deleting the temporarily stored sensor data to remove duplication when the temporarily stored sensor data matches the previous sensor data; and a step of storing data currently stored in the database as null data.

[0012] The database preprocessing method further includes a step of reading sensor data stored in the database in order to transmit the sensor data stored in the database to a monitoring device, a step of checking whether a key value exists in the read sensor data, a step of transmitting an alarm message to the monitoring device informing that the sensor data currently being transmitted is abnormal data if the key value exists in the read sensor data, and a step of transmitting the read sensor data to the monitoring device.

[0013] The database preprocessing method further includes a step of checking whether the read sensor data is null data if the key value does not exist in the read sensor data, a step of reading previous sensor data from the database if the read sensor data is null data, and a step of transmitting the read previous sensor data to the monitoring device as current sensor data.

[0014] According to another aspect of the present invention, a database pre-processing system for a non-traditional oil producing plant is disclosed.

[0015] A database pre-processing 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, and the instructions perform a database pre-processing method for monitoring the non-traditional oil production plant, including the steps of inputting sensor data from a plurality of sensors installed in the non-traditional oil production plant, temporarily storing the input sensor data, determining whether previous sensor data exists in a database, and 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, and 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 to the temporarily stored sensor data, and storing the sensor data with the added key value in the database. [Effects of the Invention]

[0016] A database pre-processing device and method for a non-traditional oil production plant according to an embodiment of the present invention efficiently stores a large amount of sensor data acquired from a large number of sensors installed in each piece of equipment of a non-traditional oil production plant in a database and transmits the data to a monitoring device for monitoring the non-traditional oil production plant, thereby enabling real-time monitoring of production plant equipment without being restricted by the user environment, and enabling equipment operators to quickly identify abnormal phenomena and operate the production plant stably. [Brief explanation of the drawings]

[0017] [Figure 1] FIG. 1 is a diagram illustrating a schematic configuration of a monitoring system for a non-traditional oil production plant according to an embodiment of the present invention. [Figure 2] FIG. 2 is a diagram showing an example of a screen output by the human-machine interface device. [Figure 3] FIG. 3 is a flow chart that schematically illustrates a database pre-processing method for a non-traditional oil production plant that is performed by a database pre-processing device according to an embodiment of the present invention. [Figure 4] FIG. 4 is a flow chart illustrating a database pre-processing method for a non-traditional oil production plant performed by a database pre-processing device according to another embodiment of the present invention. [Figure 5] FIG. 5 is a diagram illustrating a schematic configuration of a database pre-processing device for a non-traditional oil production plant according to an embodiment of the present invention. DETAILED DESCRIPTION OF THE INVENTION

[0018] As used herein, singular expressions include plural expressions unless the context clearly indicates otherwise. In this specification, terms such as "comprise" or "include" should not be interpreted as necessarily including all of the components or steps described in the specification, but should be interpreted as including some of the components or steps, or including additional components or steps. Furthermore, terms such as "unit" or "module" described in the specification refer to a unit that processes at least one function or operation, and may be realized by hardware or software, or a combination of hardware and software.

[0019] Various embodiments of the present invention will now be described in detail with reference to the accompanying drawings.

[0020] FIG. 1 is a diagram illustrating a schematic configuration of a monitoring system for a non-traditional oil production plant according to an embodiment of the present invention.

[0021] Referring to FIG. 1, a monitoring system for a non-traditional oil production plant according to an embodiment of the present invention may be configured to include a database pre-processing device (100), a plurality of sensors (200) installed in a non-traditional oil production plant facility (10), a monitoring device (300), and a human machine interface (HMI) device (400).

[0022] The database pre-processing device (100) performs the function of collecting a large amount of sensor data from a plurality of sensors (200) installed in each facility of the non-traditional oil production plant for monitoring the non-traditional oil production plant equipment (10), efficiently storing the data in a database, and transmitting the data to the monitoring device (300).

[0023] A plurality of sensors (200) senses the non-traditional oil production plant equipment (10) and generates a large amount of sensor data.

[0024] For example, unlike a typical oil production plant, in an oil sand production plant, the number of sensors increases rapidly as the number of processing facilities increases. Therefore, the database pre-processing device (100) according to an embodiment of the present invention can perform pre-processing of a large amount of sensor data acquired through a plurality of sensors (200) to support real-time monitoring of the monitoring device (300) for the non-traditional oil production plant facilities (10).

[0025] The monitoring device (300) performs real-time monitoring of the non-traditional oil production plant equipment (10) by receiving a large amount of preprocessed sensor data from the database preprocessing device (100) and performing monitoring.

[0026] The human-machine interface device (400) receives real-time monitoring results of the non-traditional oil production plant equipment (10) from the monitoring device (300), outputs the results, and provides various functions to the user.

[0027] For example, Figure 2 shows an example of a screen output by the human-machine interface device. As shown in Figure 2, the human-machine interface device (400) can provide one screen for viewing the entire production plant and three screens for viewing detailed data of selected equipment.

[0028] That is, the human-machine interface device (400) provides a diagram screen of the non-traditional oil production plant, a screen for monitoring real-time data within the facility, a screen for equipment specifications, a screen for visualizing data graphs, a user-to-user messaging function, and a real-time notification function regarding abnormal data.

[0029] Here, the diagram screen of the non-traditional oil production plant is a monitoring screen configured to enable the main data and production flow of the entire production plant to be checked at a glance.

[0030] The real-time data monitoring screen for the facility displays detailed data for the selected facility and also displays previously measured data along with currently measured data so that fluctuations in the data can be checked.

[0031] Furthermore, the equipment specification screen is a screen that displays the specifications of the equipment, as well as a 3D model of the equipment and an image of the on-site equipment.

[0032] The data graph visualization screen is a screen that visualizes and displays the time series data of each facility as a graph.

[0033] Furthermore, the user-to-user messaging function allows messages to be sent and received between various connected users, and provides a messaging function that enables instant communication, particularly between workers and engineers at production plant sites.

[0034] 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 understand the abnormal phenomenon of the equipment in question.

[0035] FIG. 3 is a flow chart that schematically illustrates a database pre-processing method for a non-traditional oil production plant that is performed by a database pre-processing device according to an embodiment of the present invention.

[0036] In step S310, the database pre-processing device (100) inputs sensor data from a plurality of sensors (200) installed in the non-traditional oil production plant equipment (10) for monitoring the non-traditional oil production plant equipment (10).

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

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

[0039] Here, the sensor data can be stored in the database in chronological order.

[0040] In step S340, if previous sensor data exists in the database, the database pre-processing device 100 compares the temporarily stored sensor data with the previous sensor data.

[0041] In step S350, the database preprocessing device 100 determines whether the temporarily stored sensor data is abnormal based on the comparison result.

[0042] That is, the database preprocessing device 100 can determine that 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.

[0043] In step S360, if 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 to the temporarily stored sensor data.

[0044] In step S370, the database preprocessing device 100 stores the sensor data with the added key value in the database.

[0045] In step S380, if 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 the previous sensor data.

[0046] In step S390, if the database preprocessing device 100 determines that the temporarily stored sensor data matches the previous sensor data, it deletes the temporarily stored sensor data to remove duplication.

[0047] Thereafter, the database preprocessing device 100 proceeds to step S370 and stores the data currently stored in the database as null data.

[0048] If the result of the determination in step S330 is that there is no previous sensor data in the database, the database preprocessing device 100 stores the temporarily stored sensor data in the database as is.

[0049] FIG. 4 is a flow chart illustrating a database pre-processing method for a non-traditional oil production plant performed by a database pre-processing device according to another embodiment of the present invention.

[0050] In step S410, the database pre-processing device 100 reads the sensor data stored in the database in order to transmit the sensor data stored in the database to the monitoring device 300.

[0051] For example, the database preprocessing device 100 can sequentially read out the sensor data stored in the database in chronological order from the initial point in time.

[0052] In step S420, the database preprocessing device 100 checks whether the read sensor data contains a key value indicating that the data is abnormal.

[0053] In step S430, if the key value exists in the read sensor data, the database preprocessing device 100 transmits an alarm message to the monitoring device 300 to notify that the currently transmitted sensor data is abnormal data.

[0054] In step S440, the database preprocessing device (100) transmits the read sensor data to the monitoring device (300).

[0055] Here, the monitoring device 300 can check the key value included in the received sensor data and recognize that the received sensor data is abnormal data.

[0056] 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 null data.

[0057] In step S460, if the read sensor data is null, the database preprocessing device 100 reads previous sensor data from the database.

[0058] Thereafter, the database pre-processing device 100 proceeds to step S440 and transmits the read previous sensor data to the monitoring device 300 as current sensor data.

[0059] If it is determined in step S450 that the read sensor data is not null, the database preprocessing device (100) transmits the read sensor data to the monitoring device (300) as is.

[0060] FIG. 5 is a diagram illustrating a schematic configuration of a database pre-processing device for a non-traditional oil production plant according to an embodiment of the present invention.

[0061] Referring to FIG. 5, a database pre-processing 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).

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

[0063] The memory 120 may include various types of volatile or non-volatile storage media, such as ROM and RAM.

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

[0065] The communication unit 130 is a means for transmitting and receiving data to and from other devices through a communication network.

[0066] The interface unit (140) can include a network interface for connecting to a network and a user interface.

[0067] On the other hand, the components of the above-described embodiments can be easily understood from the perspective of the process. That is, each component can be recognized as a process. Furthermore, the processes of the above-described embodiments can be easily understood from the perspective of the components of the device.

[0068] The technical contents described above may be realized in the form of program instructions executable by various computer means and recorded on a computer-readable medium. The computer-readable medium may include program instructions, data files, data structures, and the like, alone or in combination. The program instructions recorded on the medium may be specially designed and configured for the embodiments, or may be well known and usable by 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, magneto-optical media such as floptical disks, and hardware devices specially configured to store and execute program instructions, such as ROM, RAM, and flash memory. Examples of program instructions include machine language code generated by a compiler and high-level language code executable by a computer using an interpreter, for example. A hardware device may be configured to operate as one or more software modules to perform the operations of the embodiments, or vice versa.

[0069] 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, which modifications, changes, and additions are to be considered within the scope of the following claims. [Explanation of symbols]

[0070] 10: Non-traditional oil production plant equipment 100: Database preprocessor 110: Processor 120: Memory 130: Communications Department 140: Interface section 200: Multiple sensors 300: Monitoring equipment 400: Human Machine Interface (HMI) Device

Claims

1. A database pre-processing method for a non-traditional oil production plant, the method comprising: receiving sensor data input from a plurality of sensors installed at the non-traditional oil production plant for monitoring the non-traditional oil production plant; Temporarily storing the input sensor data; determining whether previous sensor data exists in the database; If 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; If the temporarily stored sensor data is determined to be abnormal data, adding a key value indicating that the temporarily stored sensor data is abnormal data to the temporarily stored sensor data; and storing the sensor data to which the key value has been added in a database; The database pre-processing method for a non-traditional oil production plant, wherein the non-traditional oil production plant is an oil sands production plant.

2. The step of determining whether the data is abnormal includes:

2. The database pre-processing method for a non-traditional oil production plant according to claim 1, wherein the temporarily stored sensor data is determined to be abnormal data if a difference between the temporarily stored sensor data and the previous sensor data exceeds a preset tolerance.

3. In claim 1, The above database preprocessing method is as follows: determining whether the temporarily stored sensor data is consistent with the previous sensor data when it is determined that the temporarily stored sensor data is not abnormal data; If the temporarily stored sensor data matches the previous sensor data, deleting the temporarily stored sensor data to remove duplication; and 2. The database pre-processing method for a non-traditional oil production plant according to claim 1, further comprising the step of: storing data currently stored in the database as null data.

4. The above database preprocessing method is as follows: reading the sensor data stored in the database to transmit the sensor data stored in the database to a monitoring device; determining whether the key value exists in the read sensor data; If the key value exists in the read sensor data, transmitting an alarm message to the monitoring device informing that the currently transmitted sensor data is abnormal data; and The database pre-processing method for a non-traditional oil production plant according to claim 1, further comprising the step of transmitting the read sensor data to the monitoring device.

5. The above database preprocessing method is as follows: If the key value does not exist in the read sensor data, checking whether the read sensor data is null data; If the retrieved sensor data is null, retrieving previous sensor data from the database; and The database pre-processing method for a non-traditional oil production plant according to claim 4, further comprising the step of transmitting the read previous sensor data to the monitoring device as current sensor data.

6. In a database pre-processing device for a non-traditional oil production plant, a memory for storing instructions; and a processor for executing the instructions; The above command is receiving sensor data from a plurality of sensors installed in the non-traditional oil production plant for monitoring the non-traditional oil production plant; Temporarily storing the input sensor 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; determining whether the temporarily stored sensor data is abnormal; If the temporarily stored sensor data is determined to be abnormal data, adding a key value indicating that the temporarily stored sensor data is abnormal data to the temporarily stored sensor data; and performing a database preprocessing method including a step of storing the sensor data to which the key value has been added in a database; The database pre-processing device for a non-traditional oil production plant is characterized in that the non-traditional oil production plant is an oil sand production plant.

Images