Data collection system and remote control system

Abstract

To provide a data collection system capable of collecting semi-structured data and storing the collected semi-structured data in a database.SOLUTION: A data collection system according to an embodiment includes: means for receiving semi-structured data including first data of a first layer and multiple pieces of second data of a second layer which are included in the first data and each of which is set with second identification information; a database; information storage means for storing storage position information indicating storage positions of the multiple pieces of second identification information in the database; and registration means for writing the multiple pieces of second data to the database based on the storage position information.SELECTED DRAWING: Figure 5

Description

[Technical Field]

[0001] FIELD OF THE INVENTION Embodiments of the present invention relate to data collection systems and remote control systems. [Background technology]

[0002] There are remote control systems that remotely control facilities and equipment in factories and plants. The remote control system includes a data collection system that collects data on the facilities and equipment to be controlled. The data collection system includes a database that stores the collected data. The remote control system controls the controlled object based on the data stored in the database of the data collection system. For example, the data collection system collects data on the operating status of the controlled object. If the remote control system detects that the operating status of the controlled object is abnormal, it remotely controls the controlled object.

[0003] The equipment and devices in factories and plants may include items manufactured by different manufacturers. Equipment and devices manufactured by different manufacturers may output data in different formats. There are proposals to standardize the format of data output from controlled objects so that data collection systems can collect data in different formats output from controlled objects from different manufacturers. One example of such a proposal is Asset Administration Shell (AAS) data, which is being standardized under Industrie 4.0. AAS data is semi-structured data.

[0004] The database of a data collection system is often proprietary to the company, and as a result, the names of the data element fields in the semi-structured AAS data do not match the names of the fields in the database, making it impossible for the data collection system to store the semi-structured data in the database. [Prior art documents] [Patent documents]

[0005] [Patent Document 1] Patent No. 6162821 [Patent Document 2] Patent No. 6577546 [Patent Document 3] Japanese Patent Application Publication No. 2020-57089 [Non-patent literature]

[0006] [Non-Patent Document 1] SPECIFICATION Details of the Asset Administration Shell, Part 1, Federal Ministry for Economic Affairs and Energy (BMWi), November 2020 Summary of the Invention [Problem to be solved by the invention]

[0007] An object of the present invention is to provide a data collection system and a remote control system that can collect semi-structured data and store the collected semi-structured data in a database. [Means for solving the problem]

[0008] A data collection system according to an embodiment includes a receiving means, a database, an information storage means, and a registration means. The receiving means receives semi-structured data including first data at a first level and multiple second data at a second level included in the first data. Multiple second identification information is set for each of the multiple second data. The information storage means stores storage location information indicating storage locations of the multiple second identification information in the database. The registration means writes the multiple second data to the database based on the storage location information. The semi-structured data includes first semi-structured data related to a sensor and second semi-structured data related to a state change detected by the sensor. The second data of the first semi-structured data includes a measurement value of the sensor, sensor identification information, and a measurement time. The second data of the second semi-structured data includes identification information of the state change, the time of the state change, and a type of the state change. The database includes a first time series database that stores time series data of the measurement value for each of the sensor identification information, and a second time series database that stores time series data consisting of the time of the state change and the type of the state change for each of the state change identification information. [Brief explanation of the drawings]

[0009] [Figure 1] FIG. 1 is a block diagram showing an example of a remote control system according to a first embodiment. [Figure 2] FIG. 10 is a diagram showing an example of AAS data. [Figure 3] FIG. 1 shows a specific example of AAS data. [Figure 4] FIG. 10 is a diagram showing another example of AAS data. [Figure 5] 10 is a flowchart showing an example of processing by a mapping processing unit. [Figure 6] FIG. 10 is a diagram showing an example of AAS object extraction. [Figure 7] FIG. 4 is a diagram showing an example of a parent-child relationship dictionary. [Figure 8] FIG. 10 is a diagram showing an example of a registration buffer. [Figure 9] FIG. 10 is a diagram showing an example of obtaining AASID. [Figure 10] FIG. 10 is a diagram showing an example of sub-model mapping. [Figure 11] FIG. 10 is a diagram showing another example of sub-model mapping. [Figure 12] FIG. 10 is a diagram showing yet another example of sub-model mapping. [Figure 13] FIG. 2 is a diagram showing an example of data registration in an asset database. [Figure 14] FIG. 10 is a diagram showing another example of data registration in the asset database. [Figure 15] FIG. 10 is a diagram showing an example of updating a parent-child relationship dictionary. [Figure 16] FIG. 10 is a block diagram showing an example of a remote control system according to a second embodiment. [Figure 17] FIG. 10 is a diagram showing an example of a registration buffer. [Figure 18] FIG. 10 is a diagram showing an example of sub-model mapping. [Figure 19] FIG. 10 is a diagram showing another example of sub-model mapping. DETAILED DESCRIPTION OF THE INVENTION

[0010] Hereinafter, embodiments will be described with reference to the drawings. The following description exemplifies devices and methods for embodying the technical concepts of the embodiments. The technical concepts of the embodiments are not limited to the structures, shapes, arrangements, materials, etc. of the components described below. Modifications that can be easily conceived by those skilled in the art are naturally included within the scope of the disclosure. For clarity of explanation, the drawings may show schematic representations of the size, thickness, planar dimensions, or shape of each element, modified from the actual embodiment. Elements in multiple drawings may have different dimensional relationships or ratios. Corresponding elements in multiple drawings may be designated by the same reference numerals, and redundant description may be omitted. Some elements may be designated by multiple names, but these names are merely examples and do not necessarily mean that these elements may be designated by other names. Furthermore, elements that do not have multiple names may also be designated by other names. In the following description, "connected" means not only a direct connection but also a connection via another element.

[0011] Hereinafter, the present embodiment will be described in detail with reference to the drawings.

[0012] [First embodiment] FIG. 1 shows an example of a remote control system to which the data collection system according to the first embodiment is applied. The data collection system collects various data related to a monitored object. The remote control system controls the monitored object or transmits some kind of instruction to an operator of the monitored object based on the data collected by the data collection system. The data collection system is the remote control system from which the parts related to controlling the monitored object have been removed. The remote control system includes a cloud server 10, an edge 12, asset management shell servers (AAS servers) 14, 18, assets 16, 20, a semantic ID database (semantic ID DB) 22, a monitored object 36, and an IoT (Internet of Things) server 38.

[0013] Assets 16 and 20 are defined in Industrie 4.0 and are physical or logical objects owned or managed by an organization, company, or industry. Assets 16 and 20 are also monitored by a remote control system. An object is a "thing" that has value to an organization, company, or industry. "Things" include physical things such as machines and non-physical things such as documents. Examples of assets include at least one of equipment, devices, products, materials, jigs, tools, software, systems, employees, factories, plants, production plan information, maintenance plan information, maintenance response information, specification information, and order information.

[0014] The AAS servers 14, 18 generate AAS data that comprehensively manages all data related to the assets 16, 20 being monitored.

[0015] Figure 2 shows an example of a data representation of AAS data generated by the AAS servers 14 and 18. The data representation in Figure 2 shows an example of data representation according to the OPC UA (OLE for Process Control Unified Architecture) communication interface. AAS data includes a header and a body. AAS data is a digital representation of an asset. AAS data is a communication interface that connects assets to the digital world connected via the Internet.

[0016] The header contains the AAS ID (AASID) and asset ID. The AASID can be an IRI (Internationalized Resource Identifier) ​​or a URL (Uniform Resource Identifier). The asset ID can be an IRI. The header has an interface for connecting to an external network that exchanges information with other AAS data.

[0017] The body contains multiple data items (called submodels) at the first level. Multiple submodels allow AAS data to describe various aspects of an asset (e.g., security, safety, energy efficiency, assembly capabilities). Information about a single aspect is summarized in a single submodel. Submodels include standardized, common base submodels and free submodels created and circulated by specific industries or companies. Each submodel contains multiple data items (called submodel elements) at the second level. Examples of submodel elements are properties (Prop) and submodel element collections (SMC). Properties include all information about an asset, such as product characteristics, process variables, external links, asset capabilities, and attribute collections. Properties define characteristics suitable for describing or distinguishing a product or part. SMCs contain properties. That is, properties include both those directly included in the submodel and those included in the SMCs included in the submodel. Properties directly included in the submodel are second-level data items, while properties included in the SMCs are third-level data items.

[0018] In addition to an ID, a submodel is assigned a semantic ID, which is an ID in an external standardized dictionary that corresponds to the meaning of the content expressed by the submodel, and can be an IRDI (International Registration Data Identifier), IRI, or URI.

[0019] Submodel elements (properties) also have semantic IDs set in addition to idShort. idShort is the identifier of the property, and the property identifier is called idShort to distinguish it from the ID of the submodel. The semantic ID of a submodel element also indicates the meaning of the content expressed by the submodel element. The semantic ID of a submodel element is linked to the ID of the ConceptDescription. IRDI, IRI, or URI can also be used for the semantic ID of a submodel element.

[0020] The AAS servers 14, 18 set semantic IDs to data items in the AAS data by referring to the semantic ID DB 22 (details will be described later). The semantic ID DB 22 stores information indicating the correspondence between data items and semantic IDs.

[0021] For simplicity of explanation, the number of AAS servers 14, 18 and assets 16, 20 is two, but these numbers are not limited to two. The data collection system may include multiple AAS servers and multiple assets. Also, one asset is connected to one AAS server, but multiple assets may be connected to one AAS server. For example, if data indicating the operating status of an asset is to be included in the AAS data, the assets 16, 20 include sensors.

[0022] This section explains a use case for AAS data. This section explains AAS data in a production system. Multiple AAS data sets are generated at each stage of a production system. During the design stage, the AAS server generates AAS data, including product specifications and drawing manuals, generated by the manufacturer's design department when designing the equipment. During the procurement stage, the AAS server generates AAS data, including parts information and contract information, generated by suppliers when they provide the necessary parts. During the manufacturing stage, the AAS server generates AAS data, including product configuration and quality information, generated by the manufacturer's manufacturing department when manufacturing the equipment. During the installation stage, the AAS server generates AAS data, including system specifications, installation information, and configuration information, generated by integrators when installing and operating the production line. AAS data includes data related to the attributes and configuration of equipment and facilities. The attribute and configuration data does not include time attributes. AAS data also includes operational status data. Operational status data represents events detected based on instantaneous values ​​and changes in instantaneous values ​​of asset measurements measured by sensors. Operational status data is time-series data, whose values ​​change over time and include time attributes. Data related to the attributes and configuration of devices and equipment is static data, while time-series data is dynamic data. During the maintenance phase, the AAS server generates AAS data including inspection and maintenance information generated by manufacturers and maintenance companies when performing system maintenance.

[0023] By using AAS data, the remote control system can comprehensively connect all information related to various facilities, equipment, and people from different manufacturers in a single method, allowing multiple applications that manage the production system to be linked together.

[0024] Returning to the explanation of FIG. 1 , the AAS clients 32 and 44 periodically send data acquisition requests to the AAS servers 14 and 18, respectively. Upon receiving a data acquisition request from the AAS clients 32 and 44, the AAS servers 14 and 18 periodically send AAS data related to the attributes and configuration of the assets, which represents a snapshot of the data representation in FIG. 2 in a predetermined data format, to the AAS clients 32 and 44. Even if there is no data acquisition request from the AAS clients 32 and 44, the AAS servers 14 and 18 may send AAS data to the AAS clients 32 and 44, respectively, if the value of the AAS data changes due to a change in the attributes or configuration of the assets 16 and 20. Examples of data formats include JSON (Java Script Object Notification), XML, and RDF (Resource Description Framework). The AAS client 32 sends the acquired AAS data to the edge data communication processing unit 34.

[0025] The AAS server 14 transmits the AAS data to the AAS client 32 according to an OPC UA (OLE for Process Control Unified Architecture) communication interface. The edge 12 includes the AAS client 32 and an edge data communication processing unit 34.

[0026] The AAS server 18 transmits AAS data relating to the attributes and configuration of the asset 20 to the AAS client 44 according to the OPC UA communication interface.

[0027] The monitoring target 36 is a remotely controlled monitoring target other than an asset, and includes a sensor 36a. The IoT server 38 acquires various data related to the monitoring target 36 and transmits the acquired data to the edge data communication processing unit 34.

[0028] The various data include sensing data (referred to as IoT data) from the sensor 36a and event history data. The IoT data is data indicating the operating status (temperature, voltage, etc.) of the monitored object 36 detected by the sensor 36a and the time of detection. The event history data is data indicating a record of what, when, and what state occurred for the monitored object 36. The remote control system monitors whether the monitored object 36 is operating normally. When the monitored object 36 is operating normally, the IoT data output from the sensor 36a is within an acceptable range. When the monitored object 36 is operating abnormally, the IoT data output from the sensor 36a exceeds the acceptable range. The IoT server 38 determines whether the monitored object 36 is operating normally based on whether the IoT data is within the acceptable range, detects the occurrence of an event in which the IoT data exceeds the acceptable range, and generates event history data.

[0029] The edge data communication processing unit 34 periodically transmits a data acquisition request to the IoT server 38. The IoT server 38 periodically transmits IoT data to the edge data communication processing unit 34 in response to the data acquisition request from the edge data communication processing unit 34. The IoT server 38 may transmit IoT data to the edge data communication processing unit 34 when the value of the IoT data changes, even if there is no data acquisition request from the edge data communication processing unit 34. The IoT server 38 transmits event history data generated when an event is detected to the edge data communication processing unit 34, regardless of the data acquisition request from the edge data communication processing unit 34.

[0030] The edge data communication processor 34 transmits the edge data to the cloud server 10 according to an AMQP (Advanced Message Queuing Protocol) or MQTT (Message Queuing Telemetry Transport) communication interface. The edge data includes AAS data related to the attributes and configuration of the asset 16 acquired by the AAS client 32 from the AAS server 14, and IoT data and event history data of the monitored object 36 acquired by the edge data communication processor 34 from the IoT server 38.

[0031] The AAS data regarding the attributes and configuration of assets received by the cloud server 10 includes data sent from the AAS server 18 to the AAS client 44 and data sent from the AAS server 14 to the edge data communication processing unit 42 via the edge 12.

[0032] The cloud server 10 includes an edge data communication processing unit 42, an AAS client 44, a collection unit 46, an accumulation unit 48, a storage unit 50, an API (Application Program Interface) unit 52, a user interface (UI) unit 54, and an authentication and authorization unit 56.

[0033] The edge data communication processing unit 42 receives edge data transmitted from the edge 12 according to the AMQP communication interface. The AAS client 44 receives data transmitted from the AAS server 18 according to the OPC UA communication interface. The edge data communication processing unit 42 transmits the received edge data to the collection unit 46. The collection unit 46 includes an IoT data queue 62, an event history data queue 64, and an AAS data queue 66. The edge data communication processing unit 42 transmits IoT data in the edge data to the IoT data queue 62, transmits event history data in the edge data to the event history data queue 64, and transmits AAS data in the edge data to the AAS data queue 66. The AAS client 44 transmits the received AAS data to the AAS data queue 66.

[0034] The accumulation unit 48 includes an IoT data accumulation processing unit 72, an event history data accumulation processing unit 74, and a mapping processing unit 76. The storage unit 50 includes an IoT data storage 82, an event history data storage 84, an asset database (asset DB) 86, and a mapping dictionary 88.

[0035] The IoT data accumulation processing unit 72 reads IoT data from the IoT data queue 62 and writes the read IoT data to the IoT data storage 82. The event history data accumulation processing unit 74 reads event history data from the event history data queue 64 and writes the read event history data to the event history data storage 84. IoT data and event history data are data that have attribute information related to time. The IoT data storage 82 and the event history data storage 84 are configured to store time-series data. The IoT data accumulation processing unit 72 writes the IoT data as time-series data to the IoT data storage 82. The event history data accumulation processing unit 74 writes the event history data as time-series data to the event history data storage 84.

[0036] The mapping processing unit 76 reads AAS data from the AAS data queue 66 and writes the read AAS data to the asset DB 86 in accordance with the mapping information read from the mapping dictionary 88. The mapping processing unit 76 includes a registration buffer 78. The registration buffer 78 is created in a memory built into the mapping processing unit 76.

[0037] The asset DB 86 is a relational database consisting of multiple tables. A relational database is also called a structured database. Each table contains multiple rows (records) and multiple columns. If two tables contain the same column, the fields of the same column in the two tables are related by a foreign key.

[0038] The mapping dictionary 88 stores mapping information indicating which table and column of the asset DB 86 each data item of the AAS data should be written to. Since a unique semantic ID is assigned to each data item of the AAS data, the mapping dictionary 88 stores mapping information indicating which table and column of the asset DB 86 each data item should be written to for each semantic ID. The mapping information includes mapping information for each property, group mapping information for each submodel or SMC, and mapping information for each entity that indicates the parent-child relationship of AASs. An entity is data that indicates a reference to another AAS or asset.

[0039] The API unit 52 stores APIs that realize various functions related to data collection and remote control. A user operates the UI unit 54 to execute one of the APIs stored in the API unit 52. For example, if the API detects that an asset is behaving abnormally based on event history information, it can send an inquiry email to the asset or an email to a maintenance and inspection company requesting the dispatch of a maintenance technician.

[0040] Figure 3 shows an example of the data structure of AAS data. Figure 3 represents a unified data structure common to AAS data in various semi-structured data formats such as JSON and XML. The left side of Figure 3 shows that the AAS data "ABCD_Compact System" includes four submodels: the submodel "Nameplate", the submodel "Document", the submodel "Service", and the submodel "Identification".

[0041] Each submodel contains multiple submodel elements. The submodel "Nameplate" contains the submodel element "Prop" and the submodel element "SMC". The submodel "Document" contains the submodel element "SMC". The submodel element "SMC" contains the submodel element "Prop". The submodel "Document" manages data for PDF documents such as operation manuals. The submodel "Service" contains the submodel element "SMC". The submodel "Identification" contains the submodel element "Prop".

[0042] The right side of Figure 3 shows an example of the data structure of the submodel element "Prop" (ManufacturerName) 102 of the submodel "Nameplate" currently selected in the mapping process. The submodel element "Prop" includes a semantic ID 104. The value of the semantic ID 104 is "0173-1#02-AAO677#002".

[0043] Figure 4 shows another example of the data structure of AAS data. AAS data includes one or more submodels SM. A submodel SM may include one or more properties (Prop) and one or more submodel element collections (SMC), may include only one or more properties (Prop) without any submodel element collections (SMC), or may include properties (Prop) and one or more submodel element collections (SMC). A submodel element collection (SMC) may include one or more properties (Prop) and one or more submodel element collections (SMC). A property (Prop) may include one or more properties (Prop) and one or more submodel element collections (SMC). In this way, a submodel SM may include multiple levels of submodel element collections (SMC) / properties (Prop).

[0044] FIG. 5 is a flowchart showing an example of processing by the mapping processing unit 76.

[0045] AAS data can contain data for multiple AASs, and data for one AAS is called an AAS object.

[0046] When the mapping processing unit 76 acquires the AAS data from the AAS data queue 66, in S402, it extracts an AAS object from the AAS data.

[0047] Figure 6 shows an example of input AAS data and extracted AAS objects (data in JSON format). The AAS data includes objects related to the AAS of AASID(=XXX) and objects related to the AAS of AASID(=YYY). The objects related to the AAS of AASID(=XXX) include data related to the AAS of AASID(=XXX), data related to assets of AASID(=XXX), submodel 1 of AASID(=XXX), submodel 2 of AASID(=XXX), ..., submodel N of AASID(=XXX). The objects related to the AAS of AASID(=YYY) include data related to the AAS of AASID(=YYY), data related to assets of AASID(=YYY), submodel 1 of AASID(=YYY), submodel 2 of AASID(=YYY), ..., submodel N of AASID(=YYY).

[0048] In S404, the mapping processing unit 76 creates a parent-child relationship dictionary. The parent-child relationship dictionary is a dictionary for looking up a parent device ID from a child AASID. Fig. 7 shows an example of the parent-child relationship dictionary.

[0049] In S408, the mapping processing unit 76 creates a registration buffer 78 corresponding to the table to which the data acquired from the currently acquired AAS object is mapped in accordance with the mapping information.

[0050] FIG. 8 shows an example of the registration buffer 78.

[0051] 8(a) shows a device table "Device_Info" that stores information about devices (assets) as the registration buffer 78. The device table "Device_Info" includes columns such as a device ID, a company CD (also called a company ID), a device name, an asset ID, an AASID, a product serial ID, and a parent device ID.

[0052] 8(b) shows the enterprise master table "Enterprise_mst" as the registration buffer 78. The enterprise master table "Enterprise_mst" includes columns such as enterprise CD, enterprise country, and enterprise name.

[0053] 8(c) shows the document table "Documents" as the registration buffer 78. The document table "Documents" includes columns such as name (document name), type (document type), title, and author.

[0054] FIG. 8( d ) shows the child AASID list as a registration buffer 78 .

[0055] Returning to the explanation of FIG. 5, in S410, the mapping processing unit 76 acquires an AASID from the currently acquired AAS object and sets the AASID in the device table "Device_Info" in the registration buffer 78. The mapping processing unit 76 also generates a device ID from the AASID according to a predetermined method and sets the device ID in the device table "Device_Info" in the registration buffer 78. The predetermined method, for example, uses the hash value of the AASID as the device ID. FIG. 9 shows an example of the AASID acquisition process (S410). The left side of FIG. 9 shows that the AAS data "ABCD_Compact System" 106 includes five submodels: a "Nameplate" submodel, a "Document" submodel, a "Service" submodel, an "Identification" submodel, and a "Technical Specification" submodel. While FIG. 3 shows the submodel elements of each submodel, FIG. 9 omits the illustration of the submodel elements of each submodel.

[0056] The right side of Figure 9 shows an example of the data structure of the currently selected AAS data "ABCD_Compact System" 106. The AAS data "ABCD_Compact System" includes an AASID 108. The type of the AASID 108 is IRDI, and the ID value is a URL (http: / / abcd.com / shells / ...). The mapping processing unit 76 writes the AASID 108 into the AASID column of the device table "Device_Info". The mapping processing unit 76 also takes a hash value of the AASID 108 and writes it as a device ID into the device ID column of the device table "Device_Info".

[0057] In S412, the mapping processing unit 76 determines whether the acquired AASID value exists in the child AASID column of the parent-child relationship dictionary (FIG. 7).

[0058] If it exists, in S414, the mapping processing unit 76 obtains the parent device ID from the parent-child relationship dictionary and writes the obtained parent device ID into the parent device ID column of the device table “Device_Info” (Figure 8(a)) in the registration buffer 78.

[0059] If not present, or after the processing of S414, in S418, the mapping processing unit 76 writes data of each submodel element of the submodel into the registration buffer 78 according to the definition of the mapping dictionary 88 (submodel mapping). Details of the submodel mapping (S418) will be described later with reference to FIGS. 10 to 12.

[0060] The mapping processing unit 76 repeats the sub-model mapping (S418) for the number of sub-models included in the AAS object.

[0061] Submodel mapping is the process of writing AAS data (semi-structured data) into a column of the registration buffer 78 that corresponds to the semantic ID assigned to the submodel or submodel element.

[0062] Submodel mapping includes examples of mapping in units of properties, examples of mapping a plurality of properties in units of submodels or SMCs, and examples of mapping in units of entities that indicate parent-child relationships of AASs.

[0063] Figure 10 shows an example of mapping by property. As in Figure 3, the left side of Figure 10 shows that the AAS data "ABCD_Compact System" includes four submodels: the submodel "Nameplate," the submodel "Document," the submodel "Service," and the submodel "Identification." However, while Figure 3 shows only the names of the submodel elements and omits their values, Figure 10 also shows the value "ABCD" for some submodel elements, such as "Prop" (ManufacturerName) 102a.

[0064] The right side of Figure 10 shows an example of the data structure of the selected sub-model element "Prop" (ManufacturerName). The sub-model element "Prop" (ManufacturerName) includes a semantic ID 104. The type of the semantic ID 104 is IRDI, and the value of the semantic ID 104 is "0173-1#02-AAO677#002".

[0065] The mapping dictionary 88 stores mapping information indicating that the value "0173-1#02-AAO677#002" of the semantic ID 104 indicates that the sub-model element "Prop" (ManufacturerName) means "company name." Therefore, the mapping processing unit 76 writes the value "ABCD" of the sub-model element "Prop" (ManufacturerName) 102a of the sub-model "Nameplate" of the AAS data "ABCD_Compact System" into the "company name" column of the enterprise master table "Enterprise_mst" (FIG. 8(b)).

[0066] Figure 11 shows an example of mapping multiple properties together in units of submodels or SMCs. The left side of Figure 11 shows that the AAS data "ABCD_Compact System" includes two submodels, namely the submodel "Nameplate" and the submodel "Document" 110. The submodel "Document" 110 includes a submodel element collection SMC. The submodel element collection SMC includes multiple submodel elements "Prop".

[0067] 11 shows an example of the data structure of the submodel "Document" 110. The submodel "Document" includes a semantic ID 112. The value of the semantic ID 112 is the URL "https:www.hsu-hh.de / ...".

[0068] The mapping dictionary 88 stores mapping pattern information indicating that the URL "https:www.hsu-hh.de / ...2," which is the value of the semantic ID 112, indicates that the submodel element "Prop" (VDI2770_OrganisationName) 114a of the submodel "Document" means "author," that the submodel element "Prop" (VDI2770_Title) 114b means "title," and that the submodel element "Prop" (VDI2770_FileFormat) 114c means "type." The mapping pattern information collectively indicates the meanings of multiple submodel elements.

[0069] Therefore, the mapping processing unit 76 writes the value "abcd" of the sub-model element "Prop" (VDI2770_OrganisationName) 114a of the sub-model "Document" into the author column of the document table "Document" (Figure 8(c)), writes the value "****" of the sub-model element "Prop" (VDI2770_Title) 114b into the "title" column of the document table "Document", and writes the value "application / pdf" of the sub-model element "Prop" (VDI2770_FileFormat) 114c into the "type" column of the document table "Document".

[0070] FIG. 12 shows an example of entity mapping indicating a parent-child relationship of AAS. The submodel "BillofMaterial" includes the property "Entity" 116. Entity is data indicating a reference to another AAS or asset. An example of the semantic ID and value of the selected entity 116 is a URL. The mapping dictionary 88 stores mapping information indicating that the semantic 116a "https: / / xxx / BillofMaterial" means parent-child relationship information. Therefore, the mapping processing unit 76 adds the value "http: / / AAA / BBB" of the entity 116b indicating the parent-child relationship to the child AASID list.

[0071] Returning to the explanation of Figure 5, when mapping of data items contained in all submodels contained in the AAS object is completed, in S422, the mapping processing unit 76 writes the data in the registration buffer 78 to the record of the corresponding table in the asset DB 86 (data registration).

[0072] 13 is a diagram showing an example of data registration in the asset DB 86. When registering data in the company master table "Enterprise_mst" of the registration buffer 78, the mapping processing unit 76 checks whether a record with the same company name (e.g., AaAa) exists in the company master table "Enterprise_mst" of the asset DB 86. If no such record exists, the mapping processing unit 76 determines a new company CD (e.g., 100), creates a new record in the company master table "Enterprise_mst" of the asset DB 86, and sets the company CD (100) in the company CD column of the new record and in the company CD column of the device table "Device_Info." If the record exists, the mapping processing unit 76 sets the company CD of a record with the same company name in the company master table "Enterprise_mst" in the company CD column of the new record and in the company CD column of the device table "Device_Info."

[0073] Fig. 14 is a diagram showing another example of data registration in the asset DB 86. Fig. 14 shows a case where the company name of an AAS object is changed from AaAa to BbBb. As shown in Fig. 13, in the company master table "Enterprise_mst" of the asset DB 86, the company name is assumed to be AaAa and the company CD is assumed to be 100. In this state, it is assumed that the company name of the same AAS object is changed to BbBb. Therefore, a record with a company name of BbBb and a company CD of 200 is added to the company master table "Enterprise_mst" of the asset DB 86.

[0074] When the data registration is completed, the mapping processing unit 76 updates the parent-child relationship dictionary in S424. Fig. 15 shows an example of updating the parent-child relationship dictionary.

[0075] As a result, the data items of the sub-model elements of the AAS data, which is semi-structured data, are written to the columns of the corresponding tables of the asset DB 86, which is a structured database.

[0076] The document table "Documents" is not connected to other tables by a foreign key, so it may be a database separate from the asset DB 86.

[0077] The API unit 52 analyzes data stored in the IoT data storage 82, the event history data storage 84, and the asset DB 86, and upon detecting abnormal operation of the assets 16, 20, or the monitored object 36, sends a control API to the edge data communication processing unit 42 or the AAS client 44. The edge data communication processing unit 42 can control the operation of the monitored object 36 via the edge data communication processing unit 34 and the IoT server 38, or can control the operation of the asset 16 via the AAS client 32 and the AAS server 14. The AAS client 44 can control the operation of the asset 20 via the AAS server 18.

[0078] This allows the operation of the asset 16, 20 or monitored object 36 that is operating abnormally to return to normal. Alternatively, the edge data communications processing unit 42 can send a notification of abnormal operation to the monitored object 36 via the edge data communications processing unit 34 and the IoT server 38, or can send a notification of abnormal operation to the asset 16 via the AAS client 32 and the AAS server 14. The AAS client 44 can send a notification of abnormal operation to the asset 20 via the AAS server 18. These notifications may be displayed on the display of the control panel of the asset 16, 20 or monitored object 36, or may be sent to a smartphone or the like carried by the operator of the asset 16, 20 or monitored object 36.

[0079] The data collection system according to the embodiment collects AAS data and writes each data item of the AAS data to a corresponding column in a table in the asset database 86, where the meaning is represented by the semantic ID. Without using AAS data, comprehensive collection of data on controlled objects, such as a wide variety of devices and equipment from various manufacturers, would require individual collection based on each manufacturer's specifications, or the management information for the controlled objects would have to be individually configured, which was time-consuming. However, a remote control system incorporating this data collection system can comprehensively collect the operating status of controlled objects, such as equipment and equipment from various manufacturers installed in factories and plants. This allows the remote control system to capture the operating status of controlled objects in real time and achieve optimal operation and maintenance efficiency according to the operating status.

[0080] [Second embodiment] 16 shows an example of a remote control system to which the data collection system according to the second embodiment is applied. In the second embodiment, the same components as those in the first embodiment are given the same reference numerals and detailed descriptions thereof will be omitted.

[0081] The asset 20 includes sensors 20a and 20b. The sensors 20a and 20b measure various data related to the asset 20, similar to the sensor 36a of the monitored object 36. The AAS server 18 stores the IoT data measured by the sensors 20a and 20b, along with AAS data related to the attributes and configuration of the asset 20.

[0082] The AAS client 44 periodically transmits a data acquisition request to the AAS server 18. Upon receiving a data acquisition request from the AAS client 44, the AAS server 18 periodically transmits to the AAS client 44 first AAS data related to the attributes and configuration of the asset 20 and second AAS data including IoT data measured by the sensors 20a and 20b. The AAS server 18 may transmit the first AAS data or the second AAS data to the AAS client 32 if the value of the first AAS data or the second AAS data has changed, even if there is no data acquisition request from the AAS client 44. The AAS server 18 determines whether the IoT data is within an acceptable range, and if the IoT data exceeds the acceptable range, detects the occurrence of an event and transmits to the AAS client 44 third AAS data including event history data indicating the time of the event occurrence and the type of event.

[0083] In this way, the AAS data received by the AAS client 44 includes IoT data and event history data in addition to data related to attributes and configuration.

[0084] The AAS client 44 transmits the AAS data to the AAS data queue 66. The mapping processing unit 76 writes the AAS data stored in the AAS data queue 66 to the storage unit 50. The mapping processing unit 76 is connected to an asset DB 86, an IoT data storage 82, and an event history data storage 84. Based on the mapping information stored in a mapping dictionary 88, the mapping processing unit 76 writes first AAS data related to the attributes and configuration of the asset to the asset DB 86, writes second AAS data including IoT data to the IoT data storage 82, and writes third AAS data including event history data to the event history storage 84. In this way, the mapping destination of the mapping processing unit 76 is not limited to the asset DB 86, but also includes the IoT data storage 82 and the event history data storage 84.

[0085] The registration buffer 78 includes the registration buffer shown in Fig. 17 in addition to the registration buffer of the first embodiment (Fig. 8). Fig. 17(a) shows an example of an IoT data registration buffer for second AAS data including IoT data. Fig. 17(b) shows an example of an event history data registration buffer for third AAS data including event history data.

[0086] The IoT data registration buffer (FIG. 17(a)) includes a device ID, a sensor ID, a measurement time, and a measurement value, and records the measurement time and the measurement value for each pair of a device ID and a sensor ID.

[0087] The device ID is identification information for the monitored object 36 or the asset 16, 20. The sensor ID is identification information for multiple sensors in the monitored object 36 or the asset 16, 20. In this embodiment, the sensor ID is unique for each device ID. Therefore, a combination of the device ID and the sensor ID identifies one sensor in the system. For example, if a device with device ID=XXX has a sensor with sensor ID=sensor0, a device with device ID=YYY may also have a sensor with sensor ID=sensor0. If a single sensor is installed in the monitored object 36 or the asset 16, 20, the sensor ID and the device ID may be the same.

[0088] The type of identifier used to identify a sensor depends on the system design. In this embodiment, sensors are considered to be attached to devices, and are identified by a device ID and a sensor ID. In this case, the device ID is unique across the entire system, but the sensor ID only needs to be unique for the device ID of the device to which the corresponding sensor is attached. Therefore, as described above, when a device with device ID=XXX has a sensor with sensor ID=sensor0, a device with device ID=YYY may also have a sensor with sensor ID=sensor0. In addition to this embodiment, a system is also possible in which sensors registered in a sensor master (described later) are identified by being assigned a sensor ID that is unique across the entire system for each sensor.

[0089] The measurement time is expressed in a format that follows the ISO8601 extension method. The ISO8601 extension method is expressed as year = YYYY (Gregorian calendar), month = MM, day = DD, hour = hh, minute = mm, second = ss. If there is a time difference from Coordinated Universal Time (UTC), the time difference is added to the end. The IoT data in Figure 17(a) shows that it was acquired every minute.

[0090] The sensor ID written to the IoT data registration buffer and the associated definition (such as the unit of the sensor measurement value) are stored in the asset DB 86 as a sensor master.

[0091] The event history data registration buffer (Figure 17(b)) includes a device ID, an event ID, the time the event occurred, the event type, and detailed information. The device ID is identification information for the monitored object 36 or the asset 16, 20. The event ID is identification information for the event. The time the event occurred is also written in a format that conforms to the ISO8601 extension method.

[0092] The event IDs written in the event history data registration buffer and their associated definitions (the meaning of the event corresponding to the event ID and the type of event that occurs) are stored in the asset DB 86 as event masters.

[0093] The mapping processing unit 76 is connected to an IoT data storage 82 , an event history data storage 84 , and an asset DB 86 .

[0094] Other configurations of the second embodiment are the same as those of the first embodiment.

[0095] The operation of the mapping processing unit 76 according to the second embodiment differs from the operation of the mapping processing unit 76 according to the first embodiment shown in FIG. 5 in two respects: sub-model mapping (S418) and data registration (S422).

[0096] An example of the asset 20 is a transportation system driven by a motor. An example of the sensor 20a is an ammeter that measures the current flowing through the motor. Assume that the asset 20 includes only the sensor 20a and does not include the sensor 20b. Assume that the device name of the asset 20 is "ABCD_CompactSystem" and the ID of the ammeter is "Sensor1".

[0097] In the sub-model mapping (S418) of the mapping process of Figure 5, the mapping processing unit 76 writes the data of each sub-model element of the sub-model of the AAS data to the registration buffer of the first embodiment shown in Figure 8, the IoT data registration buffer shown in Figure 17(a), or the event history data registration buffer shown in Figure 17(b) in accordance with the definition of the mapping dictionary 88.

[0098] FIG. 18 shows an example of second AAS data including IoT data from the sensor 20a acquired by the AAS client 44. The submodel SM “OperationalData” of the second AAS data “ABCD_CompactSystem” includes a submodel element SMC “Sensor1” (sensor ID of the sensor 20a), a submodel element Prop “MeasurementTime” (measurement time of the sensor 20a = 00:00:00 on September 24, 2021), a submodel element Prop “MeasurementValue” (measurement value = 100), and a submodel element Prop “unit” (unit = amperes). From the data of the submodel SM, submodel element SMC, and submodel element Prop of the second AAS data, the sensor ID, measurement time, and measurement value are extracted according to the definitions in the mapping dictionary 88 and stored in the IoT data registration buffer shown in FIG. 17(a). Furthermore, the device ID stored in the registration buffer shown in FIG. 8(a) is copied to the IoT data registration buffer shown in FIG. 17(a) by the process of obtaining the AASID and setting the device ID (S410).

[0099] 18 shows an example of the data structure of the selected sub-model element Prop "MeasurementValue". The sub-model element Prop "MeasurementValue" includes a semantic ID 204. The type of the semantic ID 204 is URI, and the value of the semantic ID 204 is the URI "http: / / abcd.com / aas / sid / operationaldata / sensor / measurementvalue".

[0100] The mapping dictionary 88 indicates that the value of the sub-model element Prop “MeasurementValue” having the semantic ID 204 is the measurement value of the sensor 20a identified by the sensor ID (Sensor1). Therefore, the mapping processing unit 76 writes the value (=100) of the sub-model element Prop “MeasurementValue” of the AAS data “ABCD_CompactSystem” into the measurement value field specified by the pair of device ID and sensor ID in the IoT data registration buffer.

[0101] Similarly, the mapping processing unit 76 writes the value of the sub-model element Prop “MeasurementTime” of the AAS data “ABCD_CompactSystem” (= September 24, 2021, 00:00:00) into the measurement time field specified by the pair of device ID and sensor ID in the IoT data registration buffer.

[0102] FIG. 19 shows an example of third AAS data including event history data acquired by the AAS client 44. The submodel SM “OperationalData” of the third AAS data “ABCD_CompactSystem” includes a submodel element SMC “Event1” (event ID), a submodel element Prop “OccurrenceTime” (event occurrence time = September 24, 2021, 00:00:00), a submodel element Prop “EventType” (event type = H), and a submodel element Prop “Description” (detailed information = upper limit exceeded). From the data of the submodel SM, submodel element SMC, and submodel element Prop of the third AAS data, the event ID, event occurrence time, event type, and detailed information are extracted according to the definitions in the mapping dictionary 88 and stored in the event history data registration buffer shown in FIG. 17(b). Furthermore, the device ID stored in the registration buffer shown in FIG. 8(a) is copied to the event history data registration buffer shown in FIG. 17(b) by the AASID acquisition (S410) process.

[0103] 19 shows an example of the data structure of the selected sub-model element Prop "EventType". The sub-model element Prop "EventType" includes a semantic ID 206. The type of the semantic ID 206 is URI, and the value of the semantic ID 206 is the URI "http: / / abcd.com / aas / sid / operationaldata / event / eventtype".

[0104] The mapping dictionary 88 indicates that the value of the sub-model element Prop “EventType” having the semantic ID 206 is the type of event identified by the event ID (Event1). Therefore, the mapping processing unit 76 writes the value (=H) of the sub-model element Prop “EventType” of the AAS data “ABCD_CompactSystem” into the field of the event type specified by the pair of device ID and sensor ID in the event history data registration buffer.

[0105] Similarly, the mapping processing unit 76 writes the value of the sub-model element Prop “OccurrenceTime” of the AAS data “ABCD_CompactSystem” (= 00:00:00 on September 24, 2021) into the event occurrence time field specified by the device ID and sensor ID pair in the event history data registration buffer, and writes the text of the sub-model element Prop “Description” (= upper limit exceeded) into the detailed information field specified by the device ID and sensor ID pair in the event history data registration buffer.

[0106] In the data collection system according to the second embodiment, an asset 20 includes sensors 20a and 20b, and an AAS server 18 transmits to an AAS client 44 first AAS data related to the attributes and configuration of the asset, second AAS data including IoT data collected by the sensors 20a and 20b, and third AAS data including event history data. A semantic ID is assigned to each data item of the first, second, and third AAS data. A mapping dictionary 86 stores mapping information that sets the mapping destination of the data item for each semantic ID to the IoT data storage 82, the event history data storage 84, or the asset DB 86. A mapping processing unit 76 that receives the AAS data from the AAS client 44 can write each data item of the AAS data to the IoT data storage 82, the event history data storage 84, or the asset DB 86 according to the mapping information of the semantic ID.

[0107] The present invention is not limited to the above-described embodiments, and the components can be modified and embodied in practice without departing from the spirit of the invention. Furthermore, various inventions can be created by appropriately combining multiple components disclosed in the above-described embodiments. For example, some components may be omitted from all the components shown in the embodiments. Furthermore, components from different embodiments may be appropriately combined. [Explanation of symbols]

[0108] 10...Cloud server, 12...Edge, 14,18...AAS server, 16,20...Asset, 66...AAS data queue, 76...Mapping processing unit, 78...Registration buffer, 86...Asset DB, 88...Mapping dictionary

Claims

1. receiving means for receiving semi-structured data including first data of a first layer and a plurality of second data of a second layer included in the first data, wherein a plurality of second identification information is set for each of the plurality of second data; A database, an information storage means for storing storage location information indicating storage locations of the plurality of second identification information in the database; a registration means for writing the plurality of second data into the database based on the storage location information, the semi-structured data includes first semi-structured data related to a sensor and second semi-structured data related to a state change detected by the sensor; the second data of the first semi-structured data includes a measurement value of the sensor, sensor identification information, and a measurement time; the second data of the second semi-structured data includes identification information of the state change, a time of the state change, and a type of the state change; The database includes a first time series database that stores time series data of the measurement values ​​for each of the sensor identification information, and a second time series database that stores time series data consisting of the time of the state change and the type of the state change for each of the state change identification information.

2. The data collection system of claim 1 , wherein the state change is an event in which a measurement value of the sensor exceeds an acceptable range.

3. The data collection system according to claim 1 , wherein the storage location information indicates a correspondence relationship between the plurality of second identification information pieces of the second semi-structured data and storage locations of the plurality of second identification information pieces in the second time-series database.

4. the database includes a plurality of tables; First identification information is set in the first data, the storage location information includes first information indicating a correspondence relationship between the first identification information and columns of at least two first tables among the plurality of tables, and second information indicating a correspondence relationship between any of the plurality of second identification information and columns of a second table among the plurality of tables, 2. The data collection system of claim 1, wherein the registration means writes at least two pieces of data among the plurality of second data included in the first data into columns of the at least two first tables based on the first information, and writes the second data into columns of the second table based on the second information.

5. the second data includes data regarding an asset; The assets include at least one of facilities, devices, products, materials, jigs, tools, software, systems, employees, workers, factories, plants, production plan information, maintenance plan information, maintenance response information, specification information, and order information; the first data includes a set of second data relating to aspects of the asset; The data collection system of claim 4 , wherein the second data includes a product characteristic, a process variable, an external link, a capability of the asset, an attribute of the asset, or an operating status of the asset.

6. the receiving means receives an asset management shell; The asset management shell includes a header and a body; the header includes an asset identifier and an asset management shell identifier; The data collection system of claim 5 , wherein the body includes the first data.

7. The data collection system according to claim 1 , wherein the storage location information indicates a correspondence between the plurality of second identification information pieces of the first semi-structured data and storage locations of the plurality of second identification information pieces in the first time-series database.

8. receiving means for receiving semi-structured data including first data in a first layer related to a plurality of control objects and a plurality of second data in a second layer related to the plurality of control objects, wherein a plurality of second identification information is set in each of the plurality of second data; A database, an information storage means for storing the plurality of pieces of second identification information and storage location information indicating storage locations in the database; a registration means for writing the second data into the database based on the storage location information; a notification means for outputting information relating to any one of the plurality of control targets based on the second data stored in the database, the semi-structured data includes first semi-structured data related to a sensor and second semi-structured data related to a state change detected by the sensor; the second data of the first semi-structured data includes a measurement value of the sensor, sensor identification information, and a measurement time; the second data of the second semi-structured data includes identification information of the state change, a time of the state change, and a type of the state change; The database includes a first time series database that stores time series data of the measurement values ​​for each of the sensor identification information, and a second time series database that stores time series data consisting of the time of the state change and the type of the state change for each of the state change identification information.

Images