MES system report rapid generation method based on third-party report tool
Through the MES system processing module and third-party report tools, we extract and compare report requirements feature values and data model feature values, and generate or select target data models, which solves the complex report generation in the integration of MES system and third-party report tools. The problem has achieved the convenience of rapid generation and display of reports and the efficient utilization of resources.
Patent Information
- Application Number
- CN202411004744.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-07-25
- Publication Date
- 2024-12-03
AI Technical Summary
The integration of existing MES systems and third-party reporting tools is insufficient in flexibility, resulting in complex report generation and waste of resources, and the inability to effectively utilize third-party reporting tools, resulting in inconvenience in report display and data management.
The main data table and business data table are extracted and synchronized to the data storage module through the processing module of the MES system. The third-party report tool generates a report request and sends it to the processing module. The processing module extracts the feature value of the report requirements and compares the feature value of the data model. Right, generate or select the target data model, and the third-party report tool locates the data model and generates the final presentation report.
It realizes the convenience of rapid report generation and display, reduces duplicate development work, improves resource utilization, and enhances the flexibility and efficiency of report generation.
Smart Images

Figure CN119066064A_ABST
Abstract
Description
Technical Field
[0001] The present invention belongs to the technical field of MES system data processing, and in particular relates to a method for quickly generating MES system reports based on a third-party reporting tool. Background Art
[0002] The MES system assists enterprises in optimizing and managing the production process, improving production efficiency and product quality through comprehensive monitoring and control of the production process. The management data, business data, and process data generated during the production process are very huge, and the user's reporting requirements are diverse. Users in different positions need to pay attention to very different data. In order to represent data at different levels of fields, MES data storage is scattered in multiple tables, and multiple tables are associated, which makes the direct data acquisition process more complicated.
[0003] Usually, the MES system and the third-party reporting system are deployed separately and independently. The MES system data is scattered, the process is complex, and generally a series of changes will be made to the system to adapt to on-site needs. Given the real-time and business-oriented characteristics of the MES system, if the MES system database is directly used as the data source for the third-party reporting tool, a large amount of business data and temporary data will affect the extraction and display of the data, and there is still a big gap from condensing the management data for actual display.
[0004] Both the MES report display and the proprietary reporting tools based on MES lack flexibility. The report tool styles are not beautiful and reports cannot be formed by dragging and dropping, resulting in many functions requiring on-site development. At the same time, the deployed third-party reporting tools are not well utilized, resulting in a waste of resources. The original docking method between the MES system and the third-party reporting tools is still the bottleneck of the integration of the two. Summary of the invention
[0005] In order to solve at least one of the above technical problems existing in the prior art, the present invention provides a method for quickly generating MES system reports based on a third-party reporting tool.
[0006] The present invention is implemented by the following technical solution: a method for quickly generating MES system reports based on a third-party reporting tool, comprising the following steps:
[0007] S1: The processing module of the MES system extracts the master data table and business data table of the MES system database and synchronizes them to the data storage module;
[0008] S2: The third-party reporting tool generates report requests and sends them to the processing module of the MES system;
[0009] S3: The processing module extracts the report requirement feature value based on the report request information; and obtains the feature index data in the data storage module to extract the feature value of the existing data model;
[0010] S4: Iterate the characteristic values of the existing data model and compare them with the characteristic values required by the report; return the index number of the target data model that matches the characteristic value required by the report to the third-party reporting tool;
[0011] S5: The third-party reporting tool locates the target data model according to the returned data model index number, uses it as the data source, writes SQL code to extract the model data to the third-party reporting tool engine, and generates the final display report.
[0012] Preferably, in step S4, the step of comparing the characteristic value of the existing data model with the characteristic value required by the report is as follows:
[0013] S41: If the two match, the existing data model is used as the target model;
[0014] S42: If there is no existing data model that matches the report requirement characteristic value, the processing module generates a new data model according to the report requirement characteristic value and stores the data model in the data storage module, and stores the characteristic value of the new data model in the characteristic index; at this time, the new data model serves as the target model.
[0015] Preferably, the master data tables and business data tables of the MES system database include master data tables such as MES material data tables, resource data tables, process data tables, shop floor operation control data tables, and equipment business data tables, production quality data tables, logistics information data tables, and configuration information data tables.
[0016] Preferably, the third-party reporting tool, the processing module and the data storage module implement data exchange via a web interface.
[0017] Preferably, the processing module of the MES system has a built-in data extraction and synchronization module, a feature value extraction module, a model analysis and comparison module, a model generation module and a feature storage module;
[0018] The data extraction and synchronization module is used to extract and synchronize the master data table and business data table of the MES system database to the data storage module;
[0019] The feature value extraction module is used to extract feature values from third-party reporting tools and data storage modules;
[0020] The model analysis and comparison module is used to compare the characteristic values of the existing data model with the characteristic values required by the report;
[0021] The model generation module is used to generate a new data model by processing the data table data according to the characteristic values required by the report;
[0022] The feature storage module is used to temporarily store new data models and their corresponding index numbers.
[0023] Preferably, the data storage module has a built-in feature index module and a data model module;
[0024] The feature index module is used to store the feature values of existing and new data models and provide index numbers;
[0025] The data model module is used to store existing and new data models.
[0026] Compared with the prior art, the present invention has the following beneficial effects:
[0027] The present invention provides a method for quickly generating MES system reports based on a third-party reporting tool. By constructing report requirement characteristic values and data model characteristic values, the requirement characteristic values are compared and analyzed with the data model characteristic values to determine whether the data model is reusable. If not, a new data model is generated and the new characteristic value is stored in the characteristic index for subsequent analysis and utilization. With the accumulation of data models, the number of reusable models will increase, and report generation and display will be faster and more convenient. BRIEF DESCRIPTION OF THE DRAWINGS
[0028] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.
[0029] Figure 1 It is a schematic diagram of the overall process of the present invention. DETAILED DESCRIPTION
[0030] In conjunction with the drawings in the embodiments of the present invention, the technical solutions in the embodiments of the present invention are clearly and completely described. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other implementation methods obtained by ordinary technicians in this field without making creative work are within the scope of protection of the present invention.
[0031] It should be noted that the structures, proportions, sizes, etc. illustrated in the drawings of this specification are only used to match the contents disclosed in the specification for people familiar with this technology to understand and read, and are not used to limit the conditions under which the present invention can be implemented. Therefore, they have no substantive technical significance. Any structural modification, change in proportional relationship or adjustment of size should fall within the scope of the technical contents disclosed in the present invention without affecting the effects and purposes that can be achieved by the present invention. It should be noted that in this specification, relational terms such as first and second are only used to distinguish one entity from other entities, and do not necessarily require or imply any actual relationship or order between these entities.
[0032] The present invention provides an embodiment:
[0033] like Figure 1 As shown, a method for quickly generating MES system reports based on a third-party reporting tool includes the following steps:
[0034] S1: The processing module of the MES system extracts the master data table and business data table of the MES system database and synchronizes them to the data storage module;
[0035] S2: The third-party reporting tool generates report requests and sends them to the processing module of the MES system;
[0036] S3: The processing module extracts the report requirement feature value based on the report request information; and obtains the feature index data in the data storage module to extract the feature value of the existing data model;
[0037] S4: Iterate the characteristic values of the existing data model and compare them with the characteristic values required by the report; return the index number of the target data model that matches the characteristic value required by the report to the third-party reporting tool;
[0038] In step S4, the steps of comparing the characteristic values of the existing data model with the characteristic values required by the report are as follows:
[0039] S41: If the two match, the existing data model is used as the target model;
[0040] S42: If there is no existing data model that matches the report requirement characteristic value, the processing module generates a new data model according to the report requirement characteristic value and stores the data model in the data storage module, and stores the characteristic value of the new data model in the characteristic index; at this time, the new data model serves as the target model.
[0041] S5: The third-party reporting tool locates the target data model according to the returned data model index number, uses it as the data source, writes SQL code to extract the model data to the third-party reporting tool engine, and generates the final display report.
[0042] In this embodiment, the master data table and business data table of the MES system database include master data tables such as MES material data table, resource data table, process data table, workshop operation control data table, and equipment business data table, production quality data table, logistics information data table, and configuration information data table. The third-party reporting tool and the processing module and the data storage module realize data exchange through the web interface.
[0043] The processing module of the MES system has built-in data extraction and synchronization module, feature value extraction module, model analysis and comparison module, model generation module and feature storage module; the data extraction and synchronization module is used to extract and synchronize the master data table and business data table of the MES system database to the data storage module; the feature value extraction module is used to extract feature values from third-party reporting tools and data storage modules; the model analysis and comparison module is used to compare the feature values of the existing data model with the feature values required by the report;
[0044] The model generation module is used to generate a new data model based on the characteristic values required by the report and process the data table data involved; the characteristic storage module is used to temporarily store the new data model and its corresponding index number.
[0045] The data storage module has built-in feature index module and data model module; the feature index module is used to store feature values of existing and new data models and provide index numbers; the data model module is used to store existing and new data models.
[0046] In the current MES application scenario of smart factories, any report requires developers to develop data acquisition functions and display interfaces. Similar report requirements cause a lot of repetitive work. This patent mainly constructs report requirement characteristic values and data model characteristic values, calculates and analyzes characteristic values to achieve the reuse of data models. With the accumulation of data models, the number of reusable models will increase, and report generation and display will be faster and more efficient, while reducing a lot of repetitive development work.
[0047] The above is only a preferred specific embodiment of the present invention, but the protection scope of the present invention is not limited thereto. Any changes or substitutions that can be easily thought of by a person skilled in the art within the technical scope disclosed by the present invention should be included in the protection scope of the present invention. Therefore, the protection scope of the present invention shall be based on the protection scope of the claims.
Claims
1. A method for quickly generating MES system reports based on a third-party reporting tool, characterized in that: The following steps are involved: S1: The processing module of the MES system extracts the master data table and business data table of the MES system database and synchronizes them to the data storage module; S2: The third-party reporting tool generates report requests and sends them to the processing module of the MES system; S3: The processing module extracts the report requirement feature value based on the report request information; and obtains the feature index data in the data storage module to extract the feature value of the existing data model; S4: Iterate the characteristic values of the existing data model and compare them with the characteristic values required by the report; return the index number of the target data model that matches the characteristic value required by the report to the third-party reporting tool; S5: The third-party reporting tool locates the target data model according to the returned data model index number, uses it as the data source, writes SQL code to extract the model data to the third-party reporting tool engine, and generates the final display report.
2. According to claim 1, a method for quickly generating MES system reports based on a third-party reporting tool is characterized in that: In step S4, the steps of comparing the characteristic values of the existing data model with the characteristic values required by the report are as follows: S41: If the two match, the existing data model is used as the target model; S42: If there is no existing data model that matches the report requirement characteristic value, the processing module generates a new data model according to the report requirement characteristic value and stores the data model in the data storage module, and stores the characteristic value of the new data model in the characteristic index; at this time, the new data model serves as the target model.
3. The method for quickly generating MES system reports based on a third-party reporting tool according to claim 1, characterized in that: The master data tables and business data tables of the MES system database include master data tables such as MES material data tables, resource data tables, process data tables, workshop operation control data tables, and equipment business data tables, production quality data tables, logistics information data tables, and configuration information data tables.
4. The method for quickly generating MES system reports based on a third-party reporting tool according to claim 1, characterized in that: The third-party reporting tool exchanges data with the processing module and the data storage module through the web interface.
5. The method for quickly generating MES system reports based on a third-party reporting tool according to claim 1, characterized in that: The processing module of the MES system has built-in data extraction and synchronization module, feature value extraction module, model analysis and comparison module, model generation module and feature storage module; The data extraction and synchronization module is used to extract and synchronize the master data table and business data table of the MES system database to the data storage module; The feature value extraction module is used to extract feature values from third-party reporting tools and data storage modules; The model analysis and comparison module is used to compare the characteristic values of the existing data model with the characteristic values required by the report; The model generation module is used to generate a new data model by processing the data table data according to the characteristic values required by the report; The feature storage module is used to temporarily store new data models and their corresponding index numbers.
6. The method for quickly generating MES system reports based on a third-party reporting tool according to claim 1, characterized in that: The data storage module has built-in feature index module and data model module; The feature index module is used to store the feature values of existing and new data models and provide index numbers; The data model module is used to store existing and new data models.
