Rule-based data reporting device and method implemented using no-code platform

Abstract

A rule-based data reporting device implemented using a no-code platform according to an embodiment of the present invention may comprise a processor that: provides a first user interface implemented to select at least one piece of data from among multiple pieces of data of at least one target device and configure at least one operation, which is to be performed on each of the selected at least one piece of data, and an operation condition; provides a second user interface implemented to configure a generation condition for report generation; and generates a report on the basis of user inputs received via the first user interface and the second user interface.

Description

Rule-based data reporting device and method implemented through a no-code platform

[0001] The present invention relates to a rule-based data reporting device and method implemented through a no-code platform.

[0002] With the recent advancements in related technologies like the Internet of Things (IoT) and Artificial Intelligence (AI), smart factories are becoming a hot topic. A smart factory is a manufacturing system that operates by applying Information and Communications Technology (ICT) combined with digital automation solutions throughout the production process, from design and development to manufacturing.

[0003] To build facility automation in a smart factory, automation devices such as PLCs (Programmable Logic Controllers), HMIs (Human Machine Interfaces), and drives are essential.

[0004] At this time, separate software is required to manage data on automated devices, and the automated devices themselves cannot provide a data management method. Therefore, users must develop their own software to manage data on automated devices, purchase software from external vendors, or commission an external vendor to develop a data management program of their choice.

[0005] In this case, field workers or general users face difficulties managing automated device data if they are unfamiliar with programming or the software they purchased or commissioned to be developed. Furthermore, field workers and general users can only manage data according to the rules provided by the data management software. Therefore, creating data management rules tailored to each user's work environment incurs the burden of ongoing revisions.

[0006] As the types of software vary depending on the purpose of data management, users face difficulties in familiarizing themselves with each software. Users can only view reported data, and subsequent tasks are not automated. Therefore, the operation of data-driven automated devices must be controlled manually.

[0007] The purpose of the present invention is to provide a rule-based data reporting device and method implemented through a no-code platform that can perform data management and data reporting more easily.

[0008] In a rule-based data reporting device implemented through a no-code platform according to one embodiment of the present invention, a processor may be provided that selects at least one data among a plurality of data of at least one target device, provides a first user interface implemented to set at least one operation and operation condition to be performed for each of the at least one selected data, provides a second user interface implemented to set a generation condition for report generation, and generates a report based on user input received through the first user interface and the second user interface.

[0009] The above processor can generate a data logic list by storing a first user rule corresponding to a user input received through the first user interface.

[0010] The above processor can generate a report logic list by storing a second user rule corresponding to a user input received through the second user interface.

[0011] The processor may provide a third user interface implemented to select two or more data to be compared from among a plurality of data of the at least one target device, and set at least one operation and operation condition to be performed on the two or more selected data, and may generate a report based on user input received through the second user interface and the third user interface.

[0012] The above processor can store a third user rule corresponding to a user input received through the third user interface to generate a data comparison / analysis logic list.

[0013] The processor may provide a fourth user interface implemented to select a first user rule from the data logic list and a second user rule from the report logic list.

[0014] The fourth user interface may be implemented to further select at least one third user rule from the data comparison / analysis logic list.

[0015] A rule-based data reporting method implemented through a no-code platform according to one embodiment of the present invention may include: providing a first user interface implemented to select at least one data among a plurality of data of at least one target device and set at least one operation and operation condition to be performed for each of the at least one selected data; providing a second user interface implemented to set a generation condition for report generation; and generating a report based on user input received through the first user interface and the second user interface.

[0016] The step of providing the first user interface may include a step of generating a data logic list by storing a first user rule corresponding to a user input received through the first user interface.

[0017] The step of providing the second user interface may include a step of generating a report logic list by storing a second user rule corresponding to a user input received through the second user interface.

[0018] The reporting method may further include a step of providing a third user interface implemented to select two or more data to be compared from among a plurality of data of at least one target device and to set at least one operation and operation condition to be performed on the two or more selected data; and a step of generating a report based on user input received through the second user interface and the third user interface.

[0019] The step of providing the third user interface may include a step of generating a data comparison / analysis logic list by storing a third user rule corresponding to a user input received through the third user interface.

[0020] The above reporting method may further include a step of providing a fourth user interface implemented to select a first user rule from the data logic list and a second user rule from the report logic list.

[0021] According to one embodiment of the present invention, a user can easily set rules for desired data management and rules for desired types of reports.

[0022] According to one embodiment of the present invention, a user can easily obtain and manage data he or she desires, and also generate reports using the data in the form he or she desires.

[0023] FIG. 1 is a schematic diagram illustrating a data reporting system according to one embodiment of the present invention.

[0024] FIG. 2 is a block diagram illustrating the configuration of a data reporting device according to one embodiment of the present invention.

[0025] FIG. 3 is a diagram illustrating an operation flow chart of a data reporting device according to one embodiment of the present invention.

[0026] FIG. 4 is a drawing illustrating a first user interface according to one embodiment of the present invention.

[0027] FIG. 5 is a diagram illustrating a second user interface according to one embodiment of the present invention.

[0028] FIG. 6 is a diagram illustrating a third user interface according to one embodiment of the present invention.

[0029] FIG. 7 is a diagram illustrating a fourth user interface according to one embodiment of the present invention.

[0030] FIG. 8 is a diagram illustrating the operation of a data reporting device according to one embodiment of the present invention.

[0031] - Explanation of symbols -

[0032] 1: Data Reporting System

[0033] 100: Data Reporting Device

[0034] 110: Input section

[0035] 120: Communications Department

[0036] 130: Display

[0037] 140: Storage

[0038] 150: Processor

[0039] 200: Server

[0040] 300: Process line

[0041] 310: Power Management Unit

[0042] 320: Equipment control device

[0043] 330: Equipment Module

[0044]

[0045] Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the accompanying drawings. The detailed description set forth below, together with the accompanying drawings, is intended to explain exemplary embodiments of the present invention and is not intended to represent the only embodiments in which the present invention may be practiced. In the drawings, portions irrelevant to the description may be omitted for clarity in describing the present invention, and the same reference numerals may be used throughout the specification for identical or similar components.

[0046] FIG. 1 is a schematic diagram illustrating a data reporting system according to one embodiment of the present invention.

[0047] Referring to FIG. 1, a data reporting system (1) (hereinafter also referred to as system (1)) may include a data reporting device (100) (hereinafter also referred to as reporting device (100)), a server (200), a power management device (310) for each process line (300), an equipment control device (320), and an equipment module (330).

[0048] A reporting device (100) according to one embodiment of the present invention is a device that processes and analyzes data received from a process line (300), and may be implemented as a computer, a PLC (Programmable Logic Controller), a server, a smart phone, a tablet PC, a smart pad, a laptop, etc. The reporting device (100) may have a built-in manufacturing execution system (MES) to monitor data generated during the process of the process line (300).

[0049] A server (200) according to one embodiment of the present invention is a device that communicates with a reporting device (100), a device on a process line (300), etc., collects and provides data, and may have an employee assistance program (EAP) and a recipe parameter management system (RPMS) built in.

[0050] At this time, the reporting device (100) and the server (200) may be implemented as separate devices as shown in FIG. 1, but are not limited thereto and may be implemented in various ways, such as the reporting device (100) being implemented as one component within the server (200).

[0051] A process line (300) (process line #1, process line #2, etc.) according to one embodiment of the present invention may include a plurality of equipment modules (330) configured to operate sequentially according to the process order, and at least one process line (300) may be installed depending on the field situation.

[0052] A plurality of equipment modules (330) (equipment module #1, equipment module #2, equipment module #3, ...) may be connected to an equipment control device (320) (equipment control device #1, equipment control device #2, equipment control device #3, ...) that controls the operation of each equipment module. In addition, the process line (300) may separately be equipped with a power management device (310) that manages power, etc. of the plurality of equipment control devices (320).

[0053] At this time, the power management device (310) and the equipment control device (320) (hereinafter also referred to as a target device or an automation device) may be implemented as a PLC (Programmable Logic Controller), HMI (Human Machine Interface), drive, or computer, but is not limited thereto, and may be implemented as a tablet PC, smart pad, laptop, etc.

[0054] In order to manage data according to the operation of a process line (300), the present invention proposes a data reporting device (100) that allows a user who is not familiar with the operation of various tools or programming to obtain and manage desired data and to generate a report in a desired format from the data.

[0055] In addition, in cases where the process needs to be immediately modified according to data that changes in real time due to the nature of data in an automated device, or the operation of an automated device needs to be controlled, a data reporting device (100) capable of controlling the operation of an automated device is proposed.

[0056] Hereinafter, the configuration and operation of a system (1) according to one embodiment of the present invention will be specifically described with reference to the drawings.

[0057] FIG. 2 is a block diagram illustrating the configuration of a data reporting device according to one embodiment of the present invention.

[0058] A reporting device (100) according to one embodiment of the present invention may include an input unit (110), a communication unit (120), a display unit (130), a storage unit (140), and a processor (150).

[0059] The input unit (110) generates input data in response to user input of the reporting device (100). For example, the user input may be a user input for selecting data to be reported, a user input for setting at least one operation and operation condition to be performed on the data, a user input for setting a generation condition for report generation, a user input for creating a data logic list, a user input for creating a report logic list, a user input for creating a data comparison / analysis logic list, a user input for setting items of the first to fourth user interfaces, etc. In addition, if it is a user input required for report generation and automation device control, it can be applied without limitation.

[0060] The input unit (110) includes at least one input means. The input unit (110) may include a keyboard, a key pad, a dome switch, a touch panel, a touch key, a mouse, a menu button, etc.

[0061] The communication unit (120) can perform communication with external devices such as a reporting device (100), a power management device (310), a facility control device (320), and a facility module (330) to transmit and receive a plurality of data received from at least one target device, information on operations and operation conditions set for data monitoring, information on report generation conditions, information on operations and operation conditions set for data comparison, etc.

[0062] To this end, the communication unit (120) can perform wireless communication such as 5G (5th generation communication), LTE-A (long term evolution-advanced), LTE (long term evolution), Wi-Fi (wireless fidelity), Bluetooth, or wired communication such as LAN (local area network), WAN (Wide Area Network), and power line communication.

[0063] The display unit (130) displays display data according to the operation of the reporting device (100). The display unit (130) includes a liquid crystal display (LCD), a light emitting diode (LED) display, an organic light emitting diode (OLED) display, a micro electro mechanical systems (MEMS) display, and an electronic paper display. The display unit (130) may be implemented as a touch screen by being combined with the input unit (110).

[0064] The storage unit (140) stores the operation programs of the reporting device (100). The storage unit (140) includes non-volatile storage that can preserve data (information) regardless of whether power is supplied, and volatile memory that cannot preserve data when power is not supplied and into which data to be processed by the processor (150) is loaded. The storage includes flash memory, hard-disc drive (HDD), solid-state drive (SSD), read-only memory (ROM), etc., and the memory includes buffer, random access memory (RAM), etc.

[0065] The storage unit (140) may store a plurality of data received from at least one target device, information regarding operations and operation conditions set for data monitoring, information regarding report generation conditions, information regarding operations and operation conditions set for data comparison, etc. The storage unit (140) may store operation programs required in the process of creating and providing a user interface, creating a report, etc.

[0066] The processor (150) can control at least one other component (e.g., hardware or software component) of the reporting device (100) by executing software such as a program, and can perform various data processing or operations.

[0067] A processor (150) according to one embodiment of the present invention provides a first user interface implemented to select at least one data among a plurality of data of at least one target device, and set at least one operation and operation condition to be performed for each of the at least one selected data, and provides a second user interface implemented to set a generation condition for report generation, and can generate a report based on user input received through the first user interface and the second user interface.

[0068] Meanwhile, the processor (150) may perform at least a portion of the data analysis, processing, and result information generation for performing the above operations using at least one of a machine learning, neural network, or deep learning algorithm as a rule-based or artificial intelligence (AI) algorithm. Examples of the neural network may include models such as a CNN (Convolutional Neural Network), a DNN (Deep Neural Network), and an RNN (Recurrent Neural Network).

[0069] FIG. 3 is a diagram illustrating an operation flow chart of a data reporting device according to one embodiment of the present invention.

[0070] According to one embodiment of the present invention, the processor (150) may provide a first user interface implemented to select at least one data among a plurality of data of at least one target device and set at least one operation and operation condition to be performed for each of the at least one selected data (S10).

[0071] The target device may be a power management device (310) or a facility control device (320), and in addition, any device that generates data to be monitored according to the operation of the process line (300) may suffice.

[0072] The first user interface is a user interface implemented to select data to be reported and set data processing conditions, and a specific example is illustrated in Fig. 4.

[0073] The actions to be performed on each of the selected at least one data may be data retrieval, data modification, data optimization, etc., and may also be actions that can control the target device, such as stopping or starting the target device.

[0074] The operation condition may include various conditions for performing the operation, such as maximum (Max), minimum (Min), =, >, <, ≤, ≥, etc., and may include condition values ​​corresponding to each condition, input values ​​in the case of data modification, etc.

[0075] According to one embodiment of the present invention, the processor (150) can create a user interface that allows anyone to set rules for data reporting through a no-code platform. Specifically, the processor (150) can create a user interface by generating a script language according to the rules set through the no-code platform.

[0076] According to one embodiment of the present invention, the processor (150) may provide a second user interface implemented to set generation conditions for report generation (S20).

[0077] The second user interface is a user interface implemented to set generation conditions such as report format, report data format, and report generation cycle, and a specific example is illustrated in Fig. 5.

[0078] According to one embodiment of the present invention, the processor (150) can generate a report based on user input received through the first user interface and the second user interface (S30).

[0079] According to one embodiment of the present invention, a user can easily set rules for desired data management and rules for desired types of reports.

[0080] Through this, users can easily obtain and manage the data they want, and also create reports using that data in the format they want.

[0081] FIG. 4 is a drawing illustrating a first user interface (400) according to one embodiment of the present invention.

[0082] The first user interface (400) is a user interface implemented to select data to be reported and set data processing conditions.

[0083] The processor (150) can generate a data logic list by storing a first user rule corresponding to a user input received through the first user interface (400).

[0084] User rules set the selected data and the actions and action conditions to be performed using that data.

[0085] The first user interface (400) may include an area (410) for setting a name of a user rule, an area (420) for selecting at least one data among a plurality of data of at least one target device, an area (430) for setting at least one operation and operation condition to be performed for each of the at least one selected data, and an area (440) for displaying a data logic list.

[0086] Looking at the data selection area (420), data A, data B, data C, data D, data E, the entire project, description, function A, etc. are listed, and the processor (150) can receive user input to select or deselect any one of them. In Fig. 4, it can be seen that data B, data C, data E, function A, description, and data F are selected.

[0087] Looking at the action and action condition setting area (430), the processor (150) can receive user input that sets an action to be performed for each selected data and a condition for performing the action.

[0088] For example, for data B, logic is set to retrieve data when the condition value is equal to 10. For data C, logic is set to modify all data to the input value 25 when the condition value is less than 30.

[0089] For data E, logic is set to halt the operation of the target device when the condition value is greater than 100. For the description, logic is set to retrieve data unconditionally. For data F, logic is set to optimize data for scan time.

[0090] Looking at the area (440) displaying the data logic list, the processor (150) can generate a data logic list by storing a first user rule corresponding to user input received through the first user interface. At this time, one user rule can include at least one data logic, and of course, it can include two or more data logics. By storing frequently used data logic, report generation can be performed more quickly.

[0091] FIG. 5 is a diagram illustrating a second user interface according to one embodiment of the present invention.

[0092] The second user interface is a user interface implemented to set the generation conditions for report generation.

[0093] The second user interface (500) may include an area (510) for setting the name of a user rule, an area (520) for setting the creation conditions for report creation, and an area (530) for displaying a report logic list.

[0094] Looking at the area (520) that sets the generation conditions for report generation, the processor (150) can receive user input that sets the report format, report data format, user rules for the report target, report generation conditions, and report generation cycle.

[0095] Specifically, the report format is a reporting tool that is the target of OLE (Object Linking and Embedding) automation, such as MS Office Excel or Word. The report data format can be a format in which data is displayed, such as a table, diagram, or text.

[0096] The user rule subject to the report refers to the user rule set through the first user interface (400) above, and may also refer to the user rule set through the third user interface described later. The processor (150) may receive user input for selecting the user rule subject to the report through a data logic list or a data comparison / analysis logic list.

[0097] The report generation conditions can be selected from among data conditions (manual), pre-saved user rules (report conditions), and period cycles set through the first user interface (400) or the third user interface.

[0098] The report generation cycle is the cycle for generating reports based on the report generation conditions, and various cycles can be set, such as daily, hourly, or monthly.

[0099] Looking at the area (530) displaying the report logic list, the processor (150) can generate a report logic list by storing second user rules corresponding to user input received through the second user interface. By storing frequently used report logic, report generation can be performed more quickly.

[0100] FIG. 6 is a diagram illustrating a third user interface according to one embodiment of the present invention.

[0101] The third user interface (600) is a user interface implemented to select two or more data to be compared among a plurality of data of at least one target device, and to set at least one operation and operation condition to be performed on the two or more selected data.

[0102] The third user interface (600) may include an area (610) for setting the name of a user rule, an area (620) for selecting two or more data to be compared among multiple data of at least one target device, an area (630) for setting at least one operation and operation condition to be performed on the two or more selected data, and an area (640) for displaying a data comparison / analysis logic list.

[0103] Looking at the area (620) for selecting two or more pieces of data to be compared, one piece of data can be selected and mapped from each of the target device data and local data. In this case, the local data is considered to be target device data previously stored in the reporting device (100).

[0104] Since the data of the target device changes in real time, it is necessary to compare it with previous data at regular intervals.

[0105] Looking at the action and action condition setting area (630), the processor (150) can receive a user input that sets at least one action and action condition to be performed on two or more selected data.

[0106] For example, you can set up logic to compare data B of the target device with local data B to see if they are the same. If data C of the target device is greater than local data C, you can set up logic to modify the data to the input value 100. If data E of the target device is less than or equal to local data E, you can set up logic to stop the target device. If function A of the target device is different from local function A, you can set up logic to stop the target device.

[0107] Looking at the area (630) that displays the data comparison / analysis logic list, the processor (150) can create a data comparison / analysis logic list by storing a third user rule corresponding to a user input received through the third user interface (600).

[0108] The processor (150) can generate a report based on user input received through the second user interface (500) and the third user interface (600).

[0109] FIG. 7 is a diagram illustrating a fourth user interface according to one embodiment of the present invention.

[0110] The processor (150) may provide a fourth user interface (700) implemented to select a first user rule from a data logic list and a second user rule from a report logic list.

[0111] At this time, the fourth user interface (700) can be implemented to select at least one third user rule from the data comparison / analysis logic list.

[0112] FIG. 8 is a diagram illustrating the operation of a data reporting device according to one embodiment of the present invention.

[0113] The processor (150) creates a script language using a no-code platform provided by engineering software and creates user rules based on user input.

[0114] It provides a no-code platform for users who are not familiar with programming or related software, allowing them to create user rules to manage data in the form they want.

[0115] The processor (150) can execute a user-created script language to verify user rules and retrieve target device data using the OLE automation function of the engineering software using user rules for data retrieval. If the user has set a specific action for the target device, the processor (150) can execute the action.

[0116] The processor (150) can extract final data through the OLE automation function of the engineering software by using user rules for data comparison / analysis of the acquired target device data and local data. If the user sets a specific action for the target device, the processor (150) can execute the action.

[0117] The processor (150) can generate a report using a report tool (MS Office) using the OLE automation function of engineering software, utilizing user rules for report generation on final data. Reports can be generated manually, or automatically at specific intervals and under specific conditions, depending on the settings of user rules.

[0118] It can increase efficiency in data management and report generation, and also provide significant help in maintenance and productivity enhancement.

[0119] The present invention is intended to facilitate data management and data reporting by utilizing natural laws, and has industrial applicability.

Claims

1. In a rule-based data reporting device implemented through a no-code platform, Provides a first user interface (User Interface) implemented to select at least one data among a plurality of data of at least one target device and set at least one operation and operation condition to be performed for each of the at least one selected data, Provides a second user interface implemented to set the generation conditions for report generation, A data reporting device comprising a processor that generates a report based on user input received through the first user interface and the second user interface.

2. In paragraph 1, The above processor, A data reporting device that generates a data logic list by storing a first user rule corresponding to a user input received through the first user interface.

3. In paragraph 2, The above processor, A data reporting device that generates a report logic list by storing a second user rule corresponding to a user input received through the second user interface.

4. In paragraph 3, The above processor, Provide a third user interface implemented to select two or more data to be compared from among a plurality of data of at least one target device, and set at least one operation and operation condition to be performed on the two or more selected data, A data reporting device that generates a report based on user input received through the second user interface and the third user interface.

5. In paragraph 4, The above processor, A data reporting device that stores third-party user rules corresponding to user input received through the third-party user interface and generates a data comparison / analysis logic list.

6. In paragraph 5, The above processor, A data reporting device providing a fourth user interface implemented to select a first user rule from the above data logic list and a second user rule from the above report logic list.

7. In paragraph 6, The above fourth user interface is, A data reporting device implemented to further select at least one third-party user rule from the above data comparison / analysis logic list.

8. In the rule-based data reporting method implemented through the no-code platform, A step of providing a first user interface (User Interface) implemented to select at least one data among a plurality of data of at least one target device and to set at least one operation and operation condition to be performed for each of the at least one selected data; A step of providing a second user interface implemented to set generation conditions for report generation; A data reporting method comprising a step of generating a report based on user input received through the first user interface and the second user interface.

9. In paragraph 8, The step of providing the first user interface is as follows: A data reporting method comprising a step of generating a data logic list by storing a first user rule corresponding to a user input received through the first user interface.

10. In paragraph 9, The step of providing the second user interface is as follows: A data reporting method comprising a step of generating a report logic list by storing a second user rule corresponding to a user input received through the second user interface.

11. In paragraph 10, A step of providing a third user interface implemented to select two or more data to be compared from among a plurality of data of at least one target device, and to set at least one operation and operation condition to be performed on the two or more selected data; A data reporting method further comprising the step of generating a report based on user input received through the second user interface and the third user interface.

12. In paragraph 11, The step of providing the third user interface is as follows: A data reporting method comprising a step of generating a data comparison / analysis logic list by storing a third user rule corresponding to a user input received through the third user interface.

13. In paragraph 12, A data reporting method further comprising the step of providing a fourth user interface implemented to select a first user rule from the data logic list and a second user rule from the report logic list.

14. In paragraph 13, The above fourth user interface is, A data reporting method characterized in that it is implemented to further select at least one third user rule from the above data comparison / analysis logic list.

Images