Multi-data source query method and device, electronic equipment and storage medium

Abstract

The embodiment of the invention discloses a multi-data source query method and device, electronic equipment and a storage medium. The method comprises the following steps: receiving a query request containing a keyword; an instance of registered master data is determined based on the keyword, at least one attribute in an attribute list of the instance is matched with the keyword, and the registered master data comprises an entity and / or a workflow associated with a production unit; determining a target data source from a plurality of registered data sources based on the attribute list of the instance and / or the registered master data, the registered data sources being associated with the production unit; and querying data from the target data source based on the keyword. According to the embodiment of the invention, the data retrieval difficulty and cost are reduced, and the data retrieval efficiency is also improved.

Description

Technical Field

[0001] The present invention relates to the field of data processing technology, and in particular to a multi-data source query method, device, electronic device and storage medium. Background Art

[0002] Digitalization plays an important role in many industrial fields such as manufacturing. In recent years, factories and other production units have invested a lot of money and energy to gradually realize partial digitalization. Managers can make decisions based on data, and engineers can use data to improve work efficiency.

[0003] Since digitalization is a long process, it is normal for different suppliers of production units to provide their own software systems. Currently, in order to query data, users need to search for data from each software system separately and integrate the data manually. However, not only is the implementation cost high, but it is also easy to miss important information and it is difficult to ensure data retrieval efficiency. Summary of the invention

[0004] The embodiments of the present invention provide a multi-data source query method, device, electronic device and storage medium.

[0005] A multi-data source query method, comprising:

[0006] Receiving a query request containing a keyword;

[0007] determining an instance of registered master data based on the keyword, wherein at least one attribute in the attribute list of the instance matches the keyword, the registered master data comprising an entity and / or a workflow associated with a production unit;

[0008] determining a target data source from a plurality of registered data sources based on the attribute list of the instance and / or the registered master data, wherein the registered data sources are associated with the production unit;

[0009] Based on the keyword, data is queried from the target data source.

[0010] It can be seen that through the pre-registered master data and its instances, the target data source can be accurately determined from multiple registered data sources (the number of target data sources can be one or more), thereby improving data retrieval efficiency. Moreover, by implementing data search through a general search engine, there is no need to integrate multiple data sources, thus reducing implementation costs. In addition, the diversity of data sources also improves the diversity of data.

[0011] In one embodiment, the entity includes at least one of the following: an operator of the production unit; equipment of the production unit; a production order of the production unit; materials of the production unit;

[0012] The method comprises at least one of the following:

[0013] Register at least one of the name, number and email address of the operator to generate an instance of the operator;

[0014] Register at least one of the name, number and workgroup of the device to generate an instance of the device;

[0015] registering the production order with a first regular expression including a number of the production order;

[0016] The material is registered with a second regular expression containing the number of the material.

[0017] Therefore, various types of master data are registered in various ways, improving applicability.

[0018] In one embodiment, the data source includes at least one of the following: a digital software platform of the production unit; a communication software platform of the production unit; a file system of the production unit;

[0019] The method comprises at least one of the following:

[0020] Registering the uniform resource locator of the application program interface of the digital software platform and the description information of the digital software platform;

[0021] Registering the database address of the digital software platform and the description information of the digital software platform;

[0022] Registering the uniform resource locator of the application program interface of the communication software platform and the description information of the communication software platform;

[0023] Register the database address of the communication software platform and the description information of the communication software platform;

[0024] The address of the file system and the description information of the file system are registered.

[0025] Therefore, various types of data sources are registered in various ways to improve applicability.

[0026] In one embodiment, it includes:

[0027] Registering a format conversion template of the digital software platform;

[0028] Based on the format conversion template, format conversion is performed on data queried from an application of the digital software platform or a database of the digital software platform.

[0029] Therefore, by performing format conversion on the data, it is easier for users to understand the data.

[0030] In one embodiment, it includes:

[0031] Registering a format conversion template of the communication software platform;

[0032] Based on the format conversion template, format conversion is performed on the data queried from the application of the communication software platform or the database of the communication software platform.

[0033] Therefore, by performing format conversion on the data, it is easier for users to understand the data.

[0034] In one embodiment, it includes:

[0035] Parsing a file in the file system to obtain entries in the file;

[0036] Creating a corresponding table including the terms and the positions of the terms in the file;

[0037] The corresponding table is saved in the elastic search database.

[0038] Therefore, through elastic search, it is easy to retrieve files in the file system.

[0039] In one embodiment, determining a target data source from a plurality of registered data sources based on the registered master data and / or the attribute list of the instance comprises:

[0040] Determining, from a plurality of registered data sources, a target data source whose description information includes the registered master data; and / or

[0041] A target data source whose description information includes at least one attribute in the attribute list is determined from a plurality of registered data sources.

[0042] Therefore, based on the multiple matching processes of description information and attributes, multiple target data sources can be determined, which not only improves the data retrieval efficiency but also ensures that the respective attribute relationships can be associated and retrieved.

[0043] A device for querying multiple data sources, comprising:

[0044] A receiving module, used for receiving a query request containing a keyword;

[0045] a first determination module, configured to determine an instance of registered master data based on the keyword, wherein at least one attribute in an attribute list of the instance matches the keyword, the registered master data comprising an entity and / or a workflow associated with a production unit;

[0046] a second determination module, configured to determine a target data source from a plurality of registered data sources based on the attribute list of the instance and / or the registered master data, wherein the registered data source is associated with the production unit;

[0047] A query module is used to query data from the target data source based on the keyword.

[0048] It can be seen that through the pre-registered master data and its instances, the target data source can be accurately determined from multiple registered data sources (the number of target data sources can be one or more), thereby improving data retrieval efficiency. Moreover, by implementing data search through a general search engine, there is no need to integrate multiple data sources, thus reducing implementation costs. In addition, the diversity of data sources also improves the diversity of data.

[0049] In one embodiment, the entity includes at least one of the following: an operator of the production unit; equipment of the production unit; a production order of the production unit; materials of the production unit;

[0050] The apparatus includes a registration module configured to perform at least one of the following:

[0051] Register at least one of the name, number and email address of the operator to generate an instance of the operator;

[0052] Register at least one of the name, number and workgroup of the device to generate an instance of the device;

[0053] registering the production order with a first regular expression including a number of the production order;

[0054] The material is registered with a second regular expression containing the number of the material.

[0055] Therefore, various types of master data are registered in various ways, improving applicability.

[0056] In one embodiment, the data source includes at least one of the following: a digital software platform of the production unit; a communication software platform of the production unit; a file system of the production unit;

[0057] The apparatus includes a registration module configured to perform at least one of the following:

[0058] Registering the uniform resource locator of the application program interface of the digital software platform and the description information of the digital software platform;

[0059] Registering the database address of the digital software platform and the description information of the digital software platform;

[0060] Registering the uniform resource locator of the application program interface of the communication software platform and the description information of the communication software platform;

[0061] Register the database address of the communication software platform and the description information of the communication software platform;

[0062] The address of the file system and the description information of the file system are registered.

[0063] Therefore, various types of data sources are registered in various ways to improve applicability.

[0064] In one embodiment, the second determination module is used to determine, from multiple registered data sources, a target data source whose description information includes the registered master data; and / or, to determine, from multiple registered data sources, a target data source whose description information includes at least one attribute in the attribute list.

[0065] Therefore, based on the multiple matching processes of description information and attributes, multiple target data sources can be determined, which not only improves the data retrieval efficiency but also ensures that the respective attribute relationships can be associated and retrieved.

[0066] An electronic device, comprising:

[0067] processor;

[0068] A memory, configured to store executable instructions of the processor;

[0069] The processor is configured to read the executable instructions from the memory, and execute the executable instructions to implement any of the above multi-data source query methods.

[0070] A computer-readable storage medium stores computer instructions, wherein the computer instructions, when executed by a processor, implement the multi-data source query method as described above.

[0071] A computer program product comprises a computer program, wherein when the computer program is executed by a processor, the multi-data source query method as described above is implemented. BRIEF DESCRIPTION OF THE DRAWINGS

[0072] The preferred embodiments of the present invention will be described in detail below with reference to the accompanying drawings so that the above and other features and advantages of the present invention will be more apparent to those skilled in the art. In the accompanying drawings:

[0073] Figure 1 is a flowchart of a multi-data source query method according to an embodiment of the present invention.

[0074] Figure 2is an exemplary schematic diagram of registering master data according to an embodiment of the present invention.

[0075] Figure 3 4 is a first exemplary schematic diagram of a multi-data source query process according to an embodiment of the present invention.

[0076] Figure 4 4 is a second exemplary schematic diagram of a multi-data source query process according to an embodiment of the present invention.

[0077] Figure 5 It is a schematic diagram of query results according to an embodiment of the present invention.

[0078] Figure 6 4 is a structural diagram of a multi-data source query device according to an embodiment of the present invention.

[0079] Figure 7 is a structural diagram of an electronic device according to an embodiment of the present invention.

[0080] The reference numerals are as follows:

[0081]

[0082]

[0083]

[0084] DETAILED DESCRIPTION

[0085] In order to make the purpose, technical solutions and advantages of the present invention more clear, the present invention is further described in detail with reference to the following embodiments.

[0086] For the sake of brevity and intuitiveness in description, the scheme of the present invention is explained below by describing several representative implementations. A large number of details in the implementations are only used to help understand the scheme of the present invention. However, it is obvious that the technical scheme of the present invention may not be limited to these details when implemented. In order to avoid unnecessarily obscuring the scheme of the present invention, some implementations are not described in detail, but only a framework is given. Hereinafter, "including" means "including but not limited to", and "according to..." means "at least according to..., but not limited to only according to...". Due to the language habits of Chinese, when the number of a component is not specifically specified below, it means that the component can be one or more, or can be understood as at least one.

[0087] The inventors found that in the current digitalization process of production units, some problems have yet to be solved, including but not limited to:

[0088] (1) It is difficult to search for data from multiple independent software systems. Digitalization is a long process, and it is normal for some software systems to be provided by different suppliers. In order to query data, users need to open multiple software systems of production units separately, search for data from each of these software systems, and manually integrate the data.

[0089] (2) It is costly to integrate multiple isolated software systems into a new software system. Some software systems may have been developed several years ago, and the system structure information may have been forgotten or lost. In addition, collaboration between different suppliers is a high-cost project.

[0090] (3) It is easy to forget the data generated in the communication software system, such as email and team. For example, discussions with external suppliers are usually conducted through email, while many internal discussions are conducted through team. Since there is no unified search portal, users can easily forget to search for valid information from this communication software.

[0091] (4) Data stored only in the file system is difficult to search. For example, in factories, it is common to use shared folders to store and share important data, and many data (such as contracts) are also archived in files.

[0092] (5) Data is distributed across different departments and maintained by different colleagues. In order to figure out what happened in an event, colleagues need to be gathered together for discussion, which is inefficient.

[0093] Therefore, in the process of digitizing the production unit, a universal search engine is needed to retrieve all data scattered in different data sources. The embodiment of the present invention proposes a universal search engine that can use existing application program interfaces (APIs) and databases to obtain data from the respective third-party software systems of the production unit without adding additional costs to these software systems. In the embodiment of the present invention, based on the pre-configured master data and description information, multiple types of related data can be accurately searched from multiple data sources.

[0094] Figure 1 1 is a flowchart of a multi-data source query method according to an embodiment of the present invention. The method may be executed by a search engine adapted to query multi-data sources. Figure 1 As shown, the method includes:

[0095] Step 101: Receive a query request containing keywords.

[0096] For example, a query request containing a keyword may be received through a user interface (UI). For example, the keyword may be an operator's name, an email address, a production order number, a material number, and the like.

[0097] Step 102: Determine an instance of registered master data based on the keyword, wherein at least one attribute in an attribute list of the instance matches the keyword, and the registered master data contains entities and / or workflows associated with the production unit.

[0098] Here, production units are units engaged in production and business activities, including industry, mining, commerce, trade, etc. For example, production units can be implemented as group companies, subsidiaries, factories, production workshops, workshop assembly lines, etc.

[0099] The entities associated with the production unit may include the participating entities in the production process of the production unit, such as personnel, equipment, materials or information (such as orders). Specifically, the entities include at least one of the following: operating personnel of the production unit; equipment of the production unit; production orders of the production unit; materials of the production unit, etc. The workflow associated with the production unit may be the production preparation process, production process and post-production processing process in the production process of the production unit, etc.

[0100] The master data may contain entities and / or workflows associated with a production unit. The master data and its instances may be pre-registered in the search engine. The pre-configured master data and its instances help the search engine understand the user query.

[0101] For example, the entities of a production unit may include:

[0102] (a) Operators. The attribute list of operators may include user name, employee number, email, etc. Therefore, based on the master data implemented as operators, operator-related information appearing in other systems can be extracted and identified.

[0103] (b) Equipment. The attribute list of the operation may include the equipment name, equipment number, manufacturer, operator of the equipment, etc.

[0104] (c) Production order. The number of a production order follows a predetermined rule, such as starting with "PO800" and having a length of 10. In this way, a regular expression containing "PO800" can be used to represent a production order without configuring all instances of production orders.

[0105] (d) Materials. Like production orders, material numbers also follow predetermined rules, such as starting with "A7E" and having a length of 10. A regular expression containing "A7E" can also be used to represent all materials without the need to configure instances of all materials.

[0106] In one embodiment, the entity includes at least one of the following: an operator of a production unit; equipment of a production unit; a production order of a production unit; and materials of a production unit. The method includes at least one of the following: registering at least one of the operator's name, number, and email address to generate an instance of the operator; registering at least one of the equipment's name, number, and workgroup to generate an instance of the equipment; registering the production order with a first regular expression containing the number of the production order; and registering the material with a second regular expression containing the number of the material.

[0107] Therefore, various types of master data are registered in various ways, improving applicability.

[0108] Figure 2 FIG. 1 is an exemplary schematic diagram of registering master data according to an embodiment of the present invention. Figure 2 As shown:

[0109] In the operator registration area 11, operators and their instances can be registered. For example, an operator as an entity is registered, and its identifier is (user). In addition, one instance of the operator user1 is registered. The attribute list of user1 includes the user name (username) of user1, the employee number (employee number) of user1, and the email address (email) of user1.

[0110] In the equipment registration area 12, equipment and its instances can be registered. For example, a device as an entity is registered, and its identifier is (equipment). In addition, one instance of the device, equipment 1, has been registered. The attribute list of equipment 1 includes the specific equipment name (equipment name) of equipment 1, the specific equipment number (equipment number) of equipment 1, and the workgroup (workshop) to which the equipment belongs.

[0111] In the production order registration area 13, production orders can be registered. For example, a production order as an entity is registered, and its identifier is (production order). Moreover, all production orders starting with "PO800" and having a length of 10 are expressed by a regular expression, so there is no need to register an instance for each production order with a specific number. In other words, the regular expression is equivalent to registering each production order with a specific number.

[0112] In the material registration area 14, materials can be registered. For example, a production order as a material is registered, and its identifier is (material). In addition, all materials starting with "A7E" and having a length of 10 are expressed as a regular expression, so that there is no need to register an instance for each material.

[0113] Similarly, the master data of the workflow implemented as a production unit can also be registered. For example, the registered workflow is identified as (workflow), and the attribute list can include: the operator of the workflow, the equipment associated with the workflow, the production order associated with the workflow, and the material associated with the workflow, etc.

[0114] Step 103: Determine a target data source from a plurality of registered data sources based on the attribute list of the instance and / or the registered master data, wherein the registered data sources are associated with the production unit.

[0115] You can pre-register data sources in the search engine. Pre-configured data sources and their descriptions help the search engine quickly locate the target data source.

[0116] In one embodiment, the data source includes at least one of the following: a digital software platform of a production unit; a communication software platform of a production unit; a file system of a production unit; Figure 1 The method includes at least one of the following:

[0117] (1) The uniform resource locator (URL) of the application programming interface (API) of the registered digital software platform and the description of the digital software platform;

[0118] (2) The database address of the registered digital software platform and the description of the digital software platform;

[0119] (3) The URL of the API for registering the communication software platform and the description of the communication software platform;

[0120] (4) The database address of the registered communication software platform and the description of the communication software platform;

[0121] (5) Register the address of the file system and the description information of the file system.

[0122] For example, the digital software platform can be implemented as: Manufacturing Execution System (MES), Enterprise Management Solutions (SAP), Warehouse Management System (WMS), Enterprise Asset Management System (EAM) or Andon system, etc. The communication software platform can be implemented as various instant messaging software or various email systems, such as Outlook, conference software, etc.

[0123] The description information of the digital software platform can be used to describe the specific functions of the digital software platform. For example, the description information of the digital software platform can include a list of keywords that describe the functions of the digital software platform. For example, the keywords in the description information of MES can include: manufacturing, execution, operator, equipment, production order, etc. The description information of the communication software platform can include a list of keywords that describe the functions of the digital software platform and associated accounts. For example, the keywords in the description information of Outlook can include: email; workgroup of the email account; equipment operated by the operator corresponding to the email account; production orders processed by the operator corresponding to the email account, etc. In addition, the keywords in the description information of Outlook can also include the email addresses of each operator.

[0124] The description information of the file system may include a list of keywords that describe specific functions of the file system, such as file, contract, delivery note, and production order, etc.

[0125] Therefore, various types of data sources are registered in various ways to improve applicability.

[0126] In one embodiment, based on the attribute list of the registered master data and / or instance, determining the target data source from the plurality of registered data sources comprises at least one of the following:

[0127] (1) Determine the registered data source whose description information contains the registered master data.

[0128] For example, assume that the keyword in the query request is "Zhang San". Based on the keyword "Zhang San", the registered master data "operator" is hit, where the operator's user name instance "Zhang San" is specifically hit. Accordingly, the data sources whose description information contains "operator" are determined to include: MES and WMS. Therefore, it is determined that the target data sources include MES and WMS.

[0129] (2) Determine a registered data source whose description information contains at least one attribute in the attribute list.

[0130] For example, assume that the keyword in the query request is "Zhang San". Based on the keyword "Zhang San", the registered master data is determined to be "operator", and the instance of the operator "Zhang San" is specifically hit. The attribute list of the instance "Zhang San" includes "email" and "employee number". It is determined that the data sources whose description information includes "email" include: Outlook email system and conference software; it is determined that the data sources whose description information includes "employee number" include: personnel management folder. Therefore, it is determined that the target data sources include Outlook email system, conference software and personnel management folder.

[0131] The number of the determined target data sources may be one or more.

[0132] Step 104: Based on the keywords, query data from the target data source.

[0133] When the number of target data sources determined in step 103 is one, data is queried from the single target data source. When the number of target data sources determined in step 103 is multiple, data is queried from the multiple target data sources respectively.

[0134] In one embodiment, step 104 includes: determining, from the target data source, data containing the keyword or data associated with the keyword.

[0135] For example, assuming that the keyword is the number of a production order, and the destination data source is an MES system whose description information includes registered master data (i.e., a production order) and an email system whose description information includes registered master data (i.e., a production order), then the production order number is used to perform an exact match or a fuzzy match in the query from the MES system and the email system to determine the manufacturing process data related to the number and the associated emails.

[0136] For example, assume that the keyword in the query request is "Zhang San". Based on the keyword "Zhang San", the registered master data is determined to be "operator", and the instance of the operator "Zhang San" is specifically hit. The attribute list of the instance "Zhang San" includes "email". The destination data source is the MES system whose description information contains the registered master data (i.e. "operator") and the email system whose description information contains "email". Then, the production order number is used to perform an exact match or a fuzzy match in the query from the MES system and the email system to determine the manufacturing process data related to the number and the associated email.

[0137] For example, assuming that the keyword is the number of a production order, and the destination data source is a WMS system whose description information contains registered master data (i.e., a production order), then an exact match or fuzzy match is performed using the number of the production order from the WMS system to determine the warehouse data related to the number.

[0138] In one embodiment, it is further determined whether the attribute of the data associated with the keyword belongs to an instance of the registered master data. If so, the instance of the master data can be further displayed based on a user trigger operation.

[0139] For example, assume that the keyword in the query request is "PO80000217". Based on the keyword "PO80000217", it is determined that the registered master data is "production order", and the corresponding destination data source is determined to be: order management system. Then, "PO80000217" is used to perform a query in the order management system to query the order data corresponding to "PO80000217". The attributes of the order data include "operator": Zhang San, who is the initiator of the order. Among them, "operator": Zhang San belongs to the instance of the master data "operator". Therefore, the specific attributes of Zhang San's employee number and email included in the attribute list of the master data "operator" are further displayed. Alternatively, the data source whose description information contains "operator", "employee number" or "email" is further determined, and then from these further determined data sources, "PO80000217" is used to perform an exact match or fuzzy match search to search for more related information.

[0140] In one embodiment, it includes: registering a format conversion template of a digital software platform; and performing format conversion on data queried from an application of the digital software platform or a database of the digital software platform based on the format conversion template.

[0141] Typically, the query data returned from the destination data source may be in JSON format, containing paired fields, which is difficult for users to understand. Therefore, a format conversion template may be further registered during the data source registration process, and the conversion rules contained in the format conversion template may be used to combine the predetermined fields in the query data into text that the user can understand, for example, into natural language text.

[0142] In one embodiment, the method includes: registering a format conversion template of a communication software platform; and performing format conversion on data queried from an application program of the communication software platform or a database of the communication software platform based on the format conversion template.

[0143] In one embodiment, the method includes: parsing a file in a file system to obtain entries in the file; creating a corresponding table including the entries and the positions of the entries in the file; and saving the corresponding table in an elastic search database.

[0144] Figure 3 FIG. 1 is a first exemplary schematic diagram of a multi-data source query process according to an embodiment of the present invention. Figure 3As shown, the multi-data source search engine 200 is connected to the digital software platform 21, the communication software platform 22 and the file system 23 respectively. The digital software platform 21 includes MES24, SAP25, WMS26, EAM27 and Andon28, etc. The communication software platform 22 includes conference (teams) software 29, instant messaging (IM) software 30 and email software 31, etc. The file system 23 includes shipping notices 32, contracts 33 and purchase orders 34, etc. The user 10 enters a query request containing keywords in the multi-data source search engine 200. The multi-data source search engine 200 determines an instance of registered master data based on the keywords, wherein at least one attribute in the attribute list of the instance matches the keyword, and the registered master data includes entities and / or workflows associated with a production unit; determines a target data source from a plurality of registered data sources based on the registered master data and / or the attribute list of the instance, wherein the registered data source is associated with a production unit; and queries data from the target data source based on the keywords.

[0145] Figure 4 4 is a second exemplary schematic diagram of a multi-data source query process according to an embodiment of the present invention.

[0146] exist Figure 4 In the embodiment, the multi-data source query engine 88 includes master data processing 76, query parsing processing 77, data retrieval and integration processing 79, API management 80, database management 81 and file management 82. In the master data processing 76, the master data registration data 86 is received to perform registration for the operator 41, the equipment 42, the material 43 and the workflow 44. In the API management 80, the API registration data 53, the API description information 54 and the format conversion template 55 are obtained from the data source registration data 87. In the database management 81, the database registration data 56, the database description information 57 and the format conversion template 58 are obtained from the data source registration data 87. In the file management 82, the folder registration data 59 and the folder description information 60 are obtained from the data source registration data 87. The file management 82 obtains the file from the file system 72. The file parsing 73 and the file tokenization 74 are performed on the file, and the file is stored in the elastic search database 75.

[0147] The digital software platform 83 with API includes MES 64, SAP 65 and WMS 66. The digital software platform 84 with database includes Mysql database 67 and Postgresql database 68. The communication software platform 85 includes email software 69, instant messaging software 70 and conference software 71.

[0148] When the multi-data source query engine 88 receives the query request 77, it performs tokenization 45, keyword extraction 46, entity mapping 47 and query embedding 47 on the content of the query request 77, and determines an instance of the registered master data based on the keyword, wherein at least one attribute in the attribute list of the instance matches the keyword, and the registered master data contains entities and / or workflows associated with the production unit; based on the attribute list of the registered master data and / or the instance, determines the target data source from multiple registered data sources, wherein the registered data source is associated with the production unit; based on the keyword, queries data from the target data source.

[0149] Figure 5 is a schematic diagram of a query result according to an embodiment of the present invention. Figure 5 In the query input box 90, enter "PO80000217" and trigger the query control 91. Based on the registered production order master data, the multi-data source query engine 88 can know that "PO80000217" is a production order. Therefore, it is determined that the identification of the production order is production order, and the target data source (such as MES, WMS, email software, etc.) whose description information contains production order is determined from multiple registered data sources. Then, the data with exact match or fuzzy match of "PO80000217" is obtained from MES, WMS, and email software respectively. For example, the query result items may include: discussion emails 93 about "PO80000217" in email software; storage data 94 about materials retrieved about "PO80000217" in WMS; production process data 95 about "PO80000217" retrieved in MES; contract documents 96 about "PO80000217" retrieved in a shared folder, etc. The above information may be sorted based on the order of the time attribute.

[0150] Figure 6 is a structural diagram of a multi-data source query device according to an embodiment of the present invention. Figure 6 As shown, the device 600 for querying multiple data sources includes:

[0151] The receiving module 601 is used to receive a query request containing a keyword;

[0152] A first determination module 602 is configured to determine an instance of registered master data based on the keyword, wherein at least one attribute in the attribute list of the instance matches the keyword, and the registered master data includes an entity and / or a workflow associated with a production unit;

[0153] A second determination module 603 is used to determine a target data source from a plurality of registered data sources based on the attribute list of the instance and / or the registered master data, wherein the registered data source is associated with the production unit;

[0154] The query module 604 is used to query data from registered data sources based on keywords.

[0155] In one embodiment, the entity includes at least one of the following: an operator of a production unit; equipment of a production unit; a production order of a production unit; materials of a production unit;

[0156] The device includes a registration module 605, which is used to perform at least one of the following: registering at least one of the name, number and email of the operator to generate an instance of the operator; registering at least one of the name, number and workgroup of the equipment to generate an instance of the equipment; registering the number of the production order with a first regular expression; registering the number of the material with a second regular expression.

[0157] In one embodiment, the data source includes at least one of the following: a digital software platform of a production unit; a communication software platform of a production unit; a file system of a production unit;

[0158] The device includes a registration module 605, which is used to perform at least one of the following: registering the uniform resource locator of the application program interface of the digital software platform and the description information of the digital software platform; registering the database address of the digital software platform and the description information of the digital software platform; registering the uniform resource locator of the application program interface of the communication software platform and the description information of the communication software platform; registering the database address of the communication software platform and the description information of the communication software platform; registering the address of the file system and the description information of the file system.

[0159] In one embodiment, the second determination module 603 is used to determine a registered data source whose description information includes registered master data; and / or determine a registered data source whose description information includes at least one attribute in the attribute list.

[0160] In summary, the embodiments of the present invention provide a universal production unit (preferably a factory) search engine, which can perform data search from historical chat data, shared folders and digital software systems without additional improvements to existing digital software systems. Moreover, the data can be displayed to the user in a natural language format.

[0161] The embodiment of the present invention further provides an electronic device having a processor-memory architecture. Figure 7 is a structural diagram of an electronic device according to an embodiment of the present invention. Figure 7As shown, the electronic device 700 includes a processor 701, a memory 702, and a computer program stored in the memory 702 and executable on the processor 701. When the computer program is executed by the processor 701, any of the above multi-data source query methods is implemented. Among them, the memory 702 can be specifically implemented as a variety of storage media such as an electrically erasable programmable read-only memory (EEPROM), a flash memory (Flash memory), and a programmable program read-only memory (PROM). The processor 701 can be implemented as including one or more central processing units or one or more field programmable gate arrays, wherein the field programmable gate array integrates one or more central processing unit cores. Specifically, the central processing unit or the central processing unit core can be implemented as a CPU, an MCU, or a DSP, and the like.

[0162] It should be noted that not all steps and modules in the above processes and structure diagrams are necessary, and some steps or modules can be ignored according to actual needs. The execution order of each step is not fixed and can be adjusted as needed. The division of each module is only for the convenience of describing the functional division adopted. In actual implementation, a module can be implemented by multiple modules, and the functions of multiple modules can also be implemented by the same module. These modules can be located in the same device or in different devices.

[0163] The hardware modules in each embodiment can be implemented mechanically or electronically. For example, a hardware module may include a specially designed permanent circuit or logic device (such as a dedicated processor, such as an FPGA or ASIC) for performing a specific operation. The hardware module may also include a programmable logic device or circuit (such as a general-purpose processor or other programmable processor) temporarily configured by software to perform a specific operation. As for whether to implement the hardware module mechanically, or using a dedicated permanent circuit, or using a temporarily configured circuit (such as configured by software), it can be decided based on cost and time considerations.

[0164] The above are only preferred embodiments of the present invention and are not intended to limit the protection scope of the present invention. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.

[0165] Nouns and pronouns relating to persons in this patent application are not limited to a specific gender.

Claims

1. A multi-data source query method, characterized in that: include: Receiving (101) a query request containing a keyword; determining (102) an instance of registered master data based on the keyword, wherein at least one attribute in an attribute list of the instance matches the keyword, the registered master data comprising an entity and / or a workflow associated with a production unit; determining (103) a target data source from a plurality of registered data sources based on the attribute list of the instance and / or the registered master data, wherein the registered data source is associated with the production unit; Based on the keyword, data is queried (104) from the target data source.

2. The method according to claim 1, characterized in that The entity includes at least one of the following: an operator of the production unit; equipment of the production unit; a production order of the production unit; materials of the production unit; The method comprises at least one of the following: Register at least one of the name, number and email address of the operator to generate an instance of the operator; Register at least one of the name, number and workgroup of the device to generate an instance of the device; registering the production order with a first regular expression including a number of the production order; The material is registered with a second regular expression containing the number of the material.

3. The method according to claim 1, characterized in that The data source includes at least one of the following: a digital software platform of the production unit; a communication software platform of the production unit; a file system of the production unit; The method comprises at least one of the following: Registering the uniform resource locator of the application program interface of the digital software platform and the description information of the digital software platform; Registering the database address of the digital software platform and the description information of the digital software platform; Registering the uniform resource locator of the application program interface of the communication software platform and the description information of the communication software platform; Register the database address of the communication software platform and the description information of the communication software platform; The address of the file system and the description information of the file system are registered.

4. The method according to claim 3, characterized in that include: Registering a format conversion template of the digital software platform; Based on the format conversion template, format conversion is performed on data queried from an application of the digital software platform or a database of the digital software platform.

5. The method according to claim 3, characterized in that: include: Registering a format conversion template of the communication software platform; Based on the format conversion template, format conversion is performed on the data queried from the application of the communication software platform or the database of the communication software platform.

6. The method according to claim 3, characterized in that include: Parsing a file in the file system to obtain entries in the file; Creating a corresponding table including the terms and the positions of the terms in the file; The corresponding table is saved in the elastic search database.

7. The method according to claim 3, characterized in that The determining of a target data source from a plurality of registered data sources based on the instance-based attribute list and / or the registered master data comprises: Determining, from a plurality of registered data sources, a target data source whose description information includes the registered master data; and / or A target data source whose description information includes at least one attribute in the attribute list is determined from a plurality of registered data sources.

8. A device for querying multiple data sources, characterized in that: include: A receiving module (601), configured to receive a query request containing a keyword; A first determination module (602) is configured to determine an instance of registered master data based on the keyword, wherein at least one attribute in an attribute list of the instance matches the keyword, the registered master data comprising an entity and / or a workflow associated with a production unit; a second determination module (603) for determining a target data source from a plurality of registered data sources based on the attribute list of the instance and / or the registered master data, wherein the registered data source is associated with the production unit; The query module (604) is used to query data from the target data source based on the keyword.

9. The device according to claim 8, characterized in that The entity includes at least one of the following: an operator of the production unit; equipment of the production unit; a production order of the production unit; materials of the production unit; The apparatus comprises a registration module (605) for performing at least one of the following: Register at least one of the name, number and email address of the operator to generate an instance of the operator; Register at least one of the name, number and workgroup of the device to generate an instance of the device; registering the production order with a first regular expression including a number of the production order; The material is registered with a second regular expression containing the number of the material.

10. The device according to claim 8, characterized in that The data source includes at least one of the following: a digital software platform of the production unit; a communication software platform of the production unit; a file system of the production unit; The apparatus comprises a registration module (605) for performing at least one of the following: Registering the uniform resource locator of the application program interface of the digital software platform and the description information of the digital software platform; Registering the database address of the digital software platform and the description information of the digital software platform; Registering the uniform resource locator of the application program interface of the communication software platform and the description information of the communication software platform; Register the database address of the communication software platform and the description information of the communication software platform; The address of the file system and the description information of the file system are registered.

11. The device according to claim 10, characterized in that The second determination module (603) is used to determine, from a plurality of registered data sources, a target data source whose description information includes the registered master data; and / or, to determine, from a plurality of registered data sources, a target data source whose description information includes at least one attribute in the attribute list.

12. An electronic device, characterized in that: include: Processor (701); A memory (702), configured to store executable instructions of the processor (701); The processor (701) is configured to read the executable instructions from the memory (702) and execute the executable instructions to implement the multi-data source query method according to any one of claims 1 to 7.

13. A computer-readable storage medium having computer instructions stored thereon, characterized in that: When the computer instructions are executed by a processor, the multi-data source query method according to any one of claims 1 to 7 is implemented.

14. A computer program product, characterized in that The method comprises a computer program, which, when executed by a processor, implements the multi-data source query method according to any one of claims 1 to 7.

Images