Method for integrated linking and visualization of manufacturing database by using digital twin

Abstract

Provided is a method for integrated linking and visualization of a manufacturing database by using a digital twin. A method for integrated linking of a manufacturing database according to an embodiment of the present invention comprises: on the basis of an information model for integrated linking of multiple time series databases distributed in a manufacturing site, generating a digital twin for integrated linking of the time series databases; linking the time series databases to the digital twin; and collecting time series data from the time series databases linked to the digital twin. Accordingly, it is possible to reduce time and cost consumption by simplifying repeatedly performed data linking and visualization tasks, and to perform the corresponding tasks without external expertise in a manufacturing site in which IT-based knowledge is insufficient.

Description

Manufacturing Database Integration and Visualization Method Using Digital Twins

[0001] The present invention relates to the utilization of time series data in a smart factory, and more specifically, to a method for integrating, linking, managing, and visualizing time series data generated in real time in a smart factory and stored in a distributed database.

[0002] Recently, Fourth Industrial Revolution technologies (cloud computing, AI, IoT, connected robotics, etc.) are interconnecting the vast amount of data generated in industrial settings. Continuously managing the extensive time-series data generated throughout the entire business lifecycle—from product planning and design to production, distribution, and sales—is key to predictive maintenance of equipment, creating business value, and maintaining product quality.

[0003] Time series data is a collection of sequentially determined data sets collected over a period of time. Sequential data lacks any meaning if viewed solely as a single value. However, if properly collected, stored, and visualized, it can be utilized in a variety of ways, such as detecting outliers, predicting future trends, or monitoring target achievement, depending on specific field needs.

[0004] In reality, time-series data generated in manufacturing plants is distributed and stored in various databases, each with its own unique format, depending on the equipment manufacturer or product. Consequently, visualizing this data on a single screen requires inputting and linking individual configuration information (access addresses, user authentication, tokens, etc.) for each database, and implementing individual visualization screens based on the characteristics of the target data, which can be unnecessarily repetitive.

[0005] The present invention has been devised to solve the above problems, and the purpose of the present invention is to simplify data linkage and visualization work that has been performed repeatedly, thereby reducing time and cost consumption, and to provide a method for managing and visualizing time series data generated in real time in a smart factory and stored in a distributed database by integrating and linking them, using an asset management shell, as a means for performing the work without external expertise in a manufacturing site lacking IT-based knowledge.

[0006] In order to achieve the above object, a manufacturing database integration and linkage method according to one embodiment of the present invention comprises the steps of: creating a digital twin for integrating and linking time series databases based on an information model for integrating and linking multiple time series databases distributed across a manufacturing site; connecting time series databases with the digital twin; and collecting time series data from time series databases connected with the digital twin.

[0007] The manufacturing database integration and linkage method according to the present invention further includes a step of generating an information model for integrating and linking time series databases; and the digital twin generation step may be to acquire information of time series databases based on the information model generated in the information model generation step and integrate and link the time series databases.

[0008] The information model could be an asset management shell.

[0009] In the asset management shell, time series databases to be integrated can be created as sub-models.

[0010] Each sub-model may contain query statements containing time series data to be integrated and managed among the time series data in the time series database.

[0011] The collection step may be to collect time series data according to a query statement.

[0012] The manufacturing database integration linkage method according to the present invention further includes a step of creating a linkage setting file for linkage with time series databases; and the linking step may be connecting with time series databases based on the created linkage setting file.

[0013] The linkage settings file can contain the addresses of time series databases, tokens, IDs / passwords, and column names of the time series data to be linked.

[0014] The manufacturing database integration linkage method according to the present invention may further include a step of visualizing collected time series data.

[0015] According to another aspect of the present invention, a manufacturing database integration and linkage system is provided, characterized by including: a linkage unit that creates a digital twin for integrating and linking time series databases based on an information model for integrating and linking a plurality of time series databases distributed across a manufacturing site, connects the time series databases with the digital twin, and collects time series data from the time series databases connected with the digital twin; and a visualization unit that visualizes the collected time series data.

[0016] According to another aspect of the present invention, a manufacturing database integration and linkage method is provided, comprising: a step of creating an information model for integrating and linking time series databases; a step of creating a digital twin for integrating and linking time series databases based on the created information model; a step of connecting time series databases with the digital twin; and a step of collecting time series data from time series databases connected with the digital twin.

[0017] According to another aspect of the present invention, a manufacturing database integration and linkage system is provided, comprising: a user input unit that generates an information model for integrating and linking time series databases according to a user's input; and a linkage unit that generates a digital twin for integrating and linking time series databases based on the generated information model, connects the time series databases with the digital twin, and collects time series data from the time series databases connected with the digital twin.

[0018] As described above, according to embodiments of the present invention, by using an asset management shell to manage and visualize time series data generated in real time in a smart factory and stored in a distributed database, the data linking and visualization work that was performed repeatedly is simplified, thereby reducing time and cost consumption, and the work can be performed without external expertise in manufacturing sites that lack IT-based knowledge.

[0019] Figure 1 is a manufacturing database integration / visualization system utilizing a digital twin according to one embodiment of the present invention.

[0020] Figure 2 is an example of a model structure for a single database that conforms to the TimeseriesData Submodel Template.

[0021] Figure 3 is an example of a TSDB Config file.

[0022] Figure 4 shows the results of visualizing time series data.

[0023] Figure 5 is a flowchart of a manufacturing database integration / visualization method utilizing a digital twin according to another embodiment of the present invention.

[0024] Hereinafter, the present invention will be described in more detail with reference to the drawings.

[0025] Currently, Industry 4.0 has officially announced the TimeSeriesData Submodel Template within the Asset Management Shell (AASet Administration Shell) metamodel. This includes metadata (names, characteristics, text descriptions, etc.) for connecting and integrating time-series data (a series of data recorded in chronological order) generated from equipment, robots, and sensors with digital twin services. Through this submodel, users can create a metamodel that complies with industry standards by configuring information from external databases as sub-models. However, this is only a sample model that inputs external database information, and does not consider methods for integrating and linking distributed databases for visualization.

[0026] To verify specific time-series data, administrators must enter information in a database and link it to each digital twin, viewing tens or even tens of thousands of data sets in text format. They must also manually search and analyze each value for a specific time period or surrounding time periods. This is highly inefficient for decision-making during the production process, as it hinders the ability to quickly find desired or relevant data. Furthermore, it risks errors in the administrator's data analysis.

[0027] Accordingly, in the embodiment of the present invention, unnecessary repetitive work is reduced by creating a single integrated model based on distributed time series database information, and the created model is linked and managed through a central digital twin server to automatically visualize real-time time series data as a graph to quickly identify patterns and trends in the process, thereby suggesting a method for more efficiently managing the production process and responding quickly when problems occur.

[0028] For integrated data management, it is possible to integrate and express database information by creating a single standard asset management shell information model without building a new system or modifying the existing system, and it is a technology that increases data consistency by providing an interface that allows access to multiple database information that are currently being visualized from an external system and receives data, and it is possible to continuously reflect changing user needs such as adding desired time series data and time cycles, so that time series data can be visualized quickly and easily.

[0029] FIG. 1 is a diagram illustrating the configuration of a manufacturing database integration / visualization system utilizing digital twins according to one embodiment of the present invention. The manufacturing database integration / visualization system according to an embodiment of the present invention is a method for converting time series data distributed across multiple databases in a manufacturing site into a single integrated time series data information model based on an asset management shell, thereby visualizing the data in real time in the form of a graph by linking with a central digital twin server.

[0030] The manufacturing database integration / visualization system according to the embodiment of the present invention that performs such a function is configured to include a user input unit (110), a central digital twin server linkage unit (120), and a data visualization unit (130).

[0031] The central digital twin server linkage (120) can collect data by comprehensively connecting the actual distributed time series database based on the user's desired query and data information and the standard information model of the distributed database that is integrated into one, and visualizes the data in the form of an HTTP-based real-time graph through the external access information, Endpoint.

[0032] To this end, the digital twin server requires integrated data modeling (TSDB Aggregation AAS) and TSDB configuration information (TSDB Config) of distributed databases, and runs the digital twin server based on the files to centrally manage them in an integrated manner and link data in real time to express them in the form of graph visualization.

[0033] Below, each component of the manufacturing database integration / visualization system according to an embodiment of the present invention is described in detail one by one.

[0034]

[0035] 1. User input section (110)

[0036] The user input section (110) is configured to create a TSDB integrated AAS, which is an AAS-based information model for integrating and linking multiple time series databases distributed across a manufacturing site.

[0037] With integrated modeling data from distributed databases, users can input information from multiple databases and data sets for integrated visualization. At this time, different databases can be modeled to the same specifications through the Asset Management Shell's TimeseriesData Submodel. Within the Asset Management Shell, submodels are created for each time series database to be integrated. Each submodel contains the name of the time series database to be integrated, connection information, and a query, allowing users to enter further details. The query contains the time series data to be integrated and managed from among the time series databases.

[0038] Figure 2 is an example of a model structure for a single database that complies with the TimeseriesData Submodel Template. Figure 2 is an example of an integrated model structure based on the TimeseriesData Submodel Template configured to verify time series data on the robot x-axis, y-axis, and z-axis of InfluxDB, a time series database.

[0039] In addition, the user input unit (110) creates TSDB Configs, which are configuration files for linking with time series databases distributed across manufacturing sites. Fig. 3 is an example of a TSDB Config file. As illustrated, each TSDB Config includes the addresses of the time series databases to be linked, tokens, IDs / passwords, and column names of the time series data to be linked.

[0040]

[0041] 2. Central digital twin server linkage (120)

[0042] The core of the central digital twin server linkage unit (120) acquires static information of time series databases based on the asset management shell model created by user settings / input through the user input unit (110) and creates a digital twin that integrates and links the time series databases.

[0043] And the connector of the central digital twin server linkage unit (120) actually connects the time series databases with the digital twin based on the linkage setting file created by the user setting / input through the user input unit (110), and when successfully connected, collects the time series data specified in the query statement, which is dynamic data, from the time series databases connected to the digital twin.

[0044] The endpoint of the central digital twin server linkage (120) provides HTTP-based access information so that users or external systems can easily access the integrated time series data management digital twin to collect data.

[0045] Based on this, the digital twin server contains both static and dynamic information about multiple distributed time series databases, and can collect and manage time series data in real time according to user requirements.

[0046]

[0047] 3. Data visualization section (130)

[0048] The data visualization unit (130) visualizes time series data collected by the central digital twin server linkage unit (120).

[0049] To this end, the TimeseriesData UI of the data visualization unit (130) accesses the Endpoint provided by the digital twin server to receive time series data collected in real time through the integrated time series data management digital twin. All collected time series data is automatically mapped to a consistent data structure (data name-value, time-value) and displayed as a graph.

[0050] Due to the nature of time-series data, trends and patterns can be identified, demonstrating how data values ​​change over time. Therefore, the X-axis of a line graph can be automatically mapped to time, and the Y-axis to data values, allowing for visualization. Figure 4 shows the results of real-time, distributed time-series data received through a digital twin server, mapped, and visualized.

[0051] FIG. 5 is a diagram illustrating a flow of a manufacturing database integration / visualization method utilizing a digital twin according to another embodiment of the present invention.

[0052] For integrated linkage / visualization of a manufacturing database, first, the user input unit (110) creates a TSDB integrated model, which is an asset management shell model for integrated linkage of multiple time series databases distributed across a manufacturing site, through user settings / input (S210), and creates a linkage settings file for linkage with time series databases (S220).

[0053] Then, the central digital twin server linkage unit (120) acquires information from time series databases based on the asset management shell model created in step S210 and creates a digital twin that integrates and links the time series databases (S230).

[0054] And the central digital twin server linkage unit (120) connects time series databases with digital twins based on the linkage setting file created in step S220 (S240), and collects time series data corresponding to the query from the time series databases connected to the digital twins (S250).

[0055] Afterwards, the data visualization unit (130) visualizes the time series data collected in step S250 by mapping them into a data format for graph visualization (S260).

[0056] So far, we have described in detail a preferred embodiment of a manufacturing database integration, linkage, and visualization method utilizing digital twins.

[0057] The smartization of manufacturing plants is generating a significant amount of data in modern factories. The establishment of interoperable data exchange standards for smart factories and the advancement of big data and cloud technologies have made data collection relatively straightforward. However, manufacturing sites face challenges in utilizing this collected data.

[0058] Accordingly, in the above embodiment, a method is presented to visualize time series data distributed across multiple databases in a manufacturing site in real time in the form of a graph by converting and creating a single integrated time series data information model based on an asset management shell and linking it with a central digital twin server.

[0059] Visual confirmation of distributed manufacturing data will enable immediate heuristic analysis and prediction, as well as anomaly detection through monitoring. Furthermore, in manufacturing sites, this will reduce the number of individual visualization screens and repetitive linking tasks required to visualize time-series data, contributing to improved work efficiency and productivity.

[0060] Meanwhile, it goes without saying that the technical idea of ​​the present invention can also be applied to a computer-readable recording medium containing a computer program that performs the functions of the device and method according to the present embodiment. In addition, the technical idea according to various embodiments of the present invention can be implemented in the form of computer-readable code recorded on a computer-readable recording medium. The computer-readable recording medium can be any data storage device that can be read by a computer and store data. For example, the computer-readable recording medium can be a ROM, a RAM, a CD-ROM, a magnetic tape, a floppy disk, an optical disk, a hard disk drive, etc. In addition, the computer-readable code or program stored on the computer-readable recording medium can be transmitted through a network connected between computers.

[0061] In addition, although the preferred embodiments of the present invention have been illustrated and described above, the present invention is not limited to the specific embodiments described above, and various modifications can be made by a person having ordinary skill in the art to which the present invention pertains without departing from the gist of the present invention as claimed in the claims, and such modifications should not be understood individually from the technical idea or prospect of the present invention.

Claims

1. A step of creating a digital twin that integrates and links time series databases based on an information model for integrating and linking multiple time series databases distributed across manufacturing sites; Steps to connect time series databases with digital twins; A manufacturing database integration linkage method, characterized by including a step of collecting time series data from time series databases connected to a digital twin.

2. In claim 1, A step of creating an information model for integrating and linking time series databases is further included; The digital twin creation steps are: A manufacturing database integration and linking method characterized by acquiring information of time series databases based on an information model created in an information model creation step and integrating and linking time series databases.

3. In claim 1, The information model is, A manufacturing database integration linkage method characterized by being an asset management shell.

4. In claim 3, In the asset management shell, A manufacturing database integration and linkage method characterized in that the time series databases to be integrated and linked are each created as sub-models.

5. In claim 4, Each sub-model has A manufacturing database integration linkage method characterized in that time series data to be integrated and managed among time series data of a time series database are included as query statements.

6. In claim 5, The collection phase is, A manufacturing database integration linkage method characterized by collecting time series data according to a query statement.

7. In claim 1, Further comprising a step of creating a linkage configuration file for linking with time series databases; The connection steps are: A manufacturing database integration linkage method characterized by connecting to time series databases based on a generated linkage settings file.

8. In claim 7, In the linkage settings file, A manufacturing database integration linkage method characterized by including addresses of time series databases, tokens, IDs / passwords, and column names of time series data to be linked.

9. In claim 1, A manufacturing database integration linkage method, characterized in that it further includes a step of visualizing collected time series data.

10. A linkage unit that creates a digital twin that integrates and links time series databases based on an information model for integrating and linking multiple time series databases distributed across manufacturing sites, connects the time series databases with the digital twin, and collects time series data from the time series databases connected with the digital twin; and A manufacturing database integration linkage system characterized by including a visualization section for visualizing collected time series data.

11. Step of creating an information model for integrating time series databases; A step of creating a digital twin that integrates and links time series databases based on the generated information model; Steps to connect time series databases with digital twins; A manufacturing database integration linkage method, characterized by including a step of collecting time series data from time series databases connected to a digital twin.

12. A user input section that creates an information model for integrating and linking time series databases based on user input; and A manufacturing database integration linkage system characterized by including a linkage unit that creates a digital twin that integrates and links time series databases based on the generated information model, links the time series databases with the digital twin, and collects time series data from the time series databases connected with the digital twin.

Images