Method, system, device and medium for querying product history

Patent metadata

Field	Value
Publication number	US-2022129447-A1
Application number	US-202117410723-A
Country	US
Kind code	A1
Filing date	Aug 24, 2021
Priority date	Oct 28, 2020
Publication date	Apr 28, 2022
Grant date	—

Abstract

A method for querying a product history is disclosed. The method includes receiving a product query request including at least one product query parameter for a target product to a product graph database that stores a relational map constructed based on a manufacturing process of the target product and describing entities including product entities and manufacturing entities and entity relations therebetween involved in the manufacturing process, querying the product graph database according to the product query parameter to obtain product history data of the target product by searching for a product entity corresponding to the target product as a target product entity in the relational map according to the parameter, searching for associated manufacturing entities of the target product entity according to the entity relations, obtaining the product history data based on the associated manufacturing entities, and sending a notification message to notify obtained product history data.

First claim

1 . A method for querying a product history, comprising:
receiving a product query request to a product graph database from a query device, the product query request including at least one product query parameter for a target product, the product graph database storing a relational map constructed based on a manufacturing process of the target product, the relational map describing entities including product entities and manufacturing entities and entity relations between the entities involved in the manufacturing process; querying the product graph database according to the product query parameter to obtain product history data of the target product, the querying comprising:
searching for a product entity corresponding to the target product as a target product entity in the relational map according to the product query parameter;
searching for one or more associated manufacturing entities of the target product entity according to the entity relations described by the relational map;
obtaining the product history data based on the associated manufacturing entities; and
sending a notification message to the query device to notify the query device of the obtained product history data.

2 . The method according to claim 1 , wherein the searching for the product entity corresponding to the target product as the target product entity comprises:
searching for a product entity of which property information matches with the product query parameter as the target product entity according to the entities described by the relational map, wherein the associated manufacturing entities are manufacturing entities having entity relations with the target product entity in the relational map.

3 . The method according to claim 2 , wherein the product query parameter comprises at least one of a product identifier, a time range or a product arrival rate of the target product.

4 . The method according to claim 1 , wherein the searching for a product entity corresponding to the target product as the target product entity comprises:
searching for a product entity of which related property information matches with the product query parameter as a first product entity according to the entities or entity relations described by the relational map, and searching for a second product entity related to the first product entity according to the product entity relations between product entities described by the relational map, and determining the second product entity as the target product entity, wherein the product entity relation between the second product entity and the first product entity is correlating relation, and a product corresponding to the first product entity is made from a product corresponding to the second product entity.

5 . The method according to claim 4 ,
wherein the product query parameter comprises a product arrival rate, the product arrival rate being a ratio of the number of first product entities that arrive at a specific station to the total number of first product entities, the first product entities being obtained from one same second product entity, and wherein the searching for the product entity corresponding to the target product as the target product entity comprises:
searching for a first relation between product entities in the relational map according to the product arrival rate to obtain a first product entity that meets a requirement of the product arrival rate, the first relation indicating that the first product entity is obtained from the second product entity; and
searching for a second relation between product entities in the relational map according to the first product entity to obtain a second product entity having the second relation with the first product entity as the target product entity, the second relation indicating that a defective result of the first product entity is related to the second product entity.

6 . The method according to claim 1 , wherein prior to receiving the query request, the method further comprises creating the product graph database by performing operations comprising:
obtaining original product history data from a manufacturing execution system (MES) executing the manufacturing process; processing the original product history data to obtain the product entities and the manufacturing entities, and constructing the entity relations according to transfer relations in the original product history data; and constructing the relational map according to the product entities, the manufacturing entities and the entity relations so as to create the product graph database.

7 . The method according to claim 6 ,
wherein the product graph database supports a property graph model, and the property graph model comprises a metadata layer and a data layer, wherein the metadata layer is arranged for constructing the manufacturing entities and the entity relations between manufacturing entities, and wherein the data layer is arranged for constructing the product entities, the entity relations between product entities and the entity relations between product entities and manufacturing entities.

8 . The method according to claim 6 , further comprising updating the product graph database by performing operations comprising:
in response to at least one of the obtained entities and the constructed entity relations being changed with respect to the relational map stored in the product graph database, updating the relational map according to the changed entities and/or entity relations; and storing the updated relational map in the product graph database.

9 . The method according to claim 6 , further comprising updating the product graph database by performing operations comprising:
in response to a query to the product graph database comprising a multi-hop query across a plurality of entities in the relational map and an occurrence frequency of the multi-hop query being greater than a predetermined threshold, modifying the relational map to establish a directly connected entity relation between a start query entity and an end query entity corresponding to a start and an end of the multi-hop query; and storing the modified relational map in the product graph database.

10 . The method according to claim 1 , wherein prior to querying the product graph database according to the product query parameter, the method further comprises:
parsing the product query request to obtain the product query parameter; and invoking a corresponding query statement template according to the product query parameter to create a query statement for querying the product graph database, wherein querying the product graph database according to the product query parameter comprises querying the product graph database according to the query statement to obtain the product history data of the target product.

11 . The method according to claim 1 , further comprising:
generating an index of interest for the target product according to the product history data; and including the generated index of interest in the notification message.

12 . The method according to claim 11 , wherein the generating the index of interest for the target product according to the product history data comprises:
obtaining a corresponding index of interest calculation template according to the product history data; and calculating the index of interest for the target product using the product history data according to the index of interest calculation template.

13 . The method according to claim 1 , wherein the generating the product history data according to the associated manufacturing entities comprises:
combining the associated manufacturin

Assignees

• Beijing Zhongxiangying Tech Co Ltd
• Boe Technology Group Co Ltd

Inventors

• Wang Chuan
• Zeng Lijun
• Zeng Jianfeng
• Wang Haijin
• Wu Jianmin
• Liu Nan
• Wang Hong
• Chai Dong
• Deng Minyang

Classifications

• G06Q50/04

  Manufacturing · CPC title

• G06Q10/06395

  Quality analysis or management · CPC title

• Y02P90/30

  Computing systems specially adapted for manufacturing · CPC title

• G06F16/24

  Querying · CPC title

• G06F16/284 Primary

  Relational databases · CPC title