Data processing method, device and data processing system

Abstract

The embodiments of the present application are applicable to the fields of industrial Internet and data processing technology, and provide a data processing method, device and data processing system, the method comprising: storing metering data collected through various metering terminals, any of the metering data having collection time information; receiving an input indicator calculation formula for statistical target indicators, the indicator calculation formula consisting of multiple metering data and corresponding operators; obtaining multiple metering data contained in the indicator calculation formula according to the collection time information; and using the indicator calculation formula to calculate the target indicator; configuring the display content of the target indicator and displaying the display content through a display terminal. Using the above method, the calculation formula of the indicator can be customized, and the adjustment or expansion of the system function can be achieved without modifying the system code to meet the needs of rapidly changing business.

Description

Technical Field

[0001] The embodiments of the present application belong to the field of data processing technology, and in particular, relate to a data processing method, device and data processing system. Background Art

[0002] In the information management systems of various fields such as manufacturing, various data on enterprise production, energy consumption, equipment, technology, environmental protection, etc. can be collected through networking, and the corresponding visual information can be generated after processing, such as digital dashboards, production reports, etc., to realize the enterprise's data statistics, monitoring, analysis and mining needs for the entire production process.

[0003] In the prior art, the traditional information management system mainly realizes the above functions by the data platform embedded in the system. The report generation and data display functions of the data platform usually require the system supplier to customize them one by one according to the requirements of the enterprise. The enterprise cannot independently adjust or optimize the functions realized by the system or data platform during use. Even minor data changes require contacting the supplier to re-modify the code. For example, the data platform can be used to count and display various data indicators in the production process of the enterprise. The statistics and display of these data indicators are usually achieved by writing code. However, with the changes in the business of the enterprise, the data indicators that need to be counted and displayed may change. When a new data indicator needs to be counted and displayed, the prior art can only achieve the purpose by the supplier re-encoding the code that can realize the statistics and display functions of the new data indicator. The whole process is not only inefficient and costly, but also easy to cause the system stability to decrease due to repeated modifications to the code, affecting the normal use of the system and data platform. Summary of the invention

[0004] In view of this, the embodiments of the present application provide a data processing method, device and data processing system, which are used to customize the functions implemented by the system through zero-code modeling to meet the rapidly changing business needs.

[0005] A first aspect of an embodiment of the present application provides a data processing method, including:

[0006] Storing metering data collected by various metering terminals, any of the metering data has collection time information;

[0007] Receive an input indicator calculation formula for statistical target indicators, the indicator calculation formula consisting of multiple measurement data and corresponding operators;

[0008] According to the collection time information, a plurality of measurement data included in the indicator calculation formula is obtained; and the indicator calculation formula is used to calculate and obtain the target indicator;

[0009] The display content of the target indicator is configured and displayed through a display terminal.

[0010] A second aspect of an embodiment of the present application provides a data processing device, including:

[0011] A storage module, used to store metering data collected by various metering terminals, any of the metering data having collection time information;

[0012] A receiving module, used for receiving an input indicator calculation formula for statistical target indicators, wherein the indicator calculation formula is composed of a plurality of measurement data and corresponding operators;

[0013] A calculation module, used to obtain a plurality of measurement data included in the indicator calculation formula according to the collection time information; and use the indicator calculation formula to calculate and obtain the target indicator;

[0014] A display module is used to configure the display content of the target indicator and display the display content through a display terminal.

[0015] A third aspect of an embodiment of the present application provides a data processing system, comprising multiple metering terminals, at least one display terminal, and a data processing terminal respectively connected to the multiple metering terminals and the at least one display terminal, the data processing terminal comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, and when the processor executes the computer program, the data processing method as described in the first aspect is implemented.

[0016] A fourth aspect of an embodiment of the present application provides a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the data processing method as described in the first aspect above is implemented.

[0017] A fifth aspect of the embodiments of the present application provides a computer program product. When the computer program product is run on a computer, the computer is enabled to execute the data processing method described in the first aspect.

[0018] Compared with the prior art, the embodiments of the present application have the following beneficial effects:

[0019] In the embodiment of the present application, by storing the metering data collected by each metering terminal, the data processing system can receive the indicator calculation formula for statistical target indicators input by the user. In this way, the data processing system can obtain multiple metering data contained in the above indicator calculation formula according to the collection time information of the metering data, and use the indicator calculation formula to calculate the target indicator. After configuring the display content of the target indicator, the data processing system can display the display content through the display terminal. Using the method provided in the embodiment of the present application, the user can customize the calculation formula of each indicator, which solves the problem that the adjustment or expansion of the system function can only be achieved by modifying the system code in the prior art, and meets the needs of rapid business changes. BRIEF DESCRIPTION OF THE DRAWINGS

[0020] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the following briefly introduces the drawings required for use in the embodiments or prior art descriptions. Obviously, the drawings described below are only some embodiments of the present application, and for ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0021] Figure 1 is a schematic diagram of a data processing method provided in an embodiment of the present application;

[0022] Figure 2 is a schematic diagram of a possible implementation of S104 in a data processing method provided in an embodiment of the present application;

[0023] Figure 3 is a schematic diagram of a data processing device provided in an embodiment of the present application;

[0024] Figure 4 is a schematic diagram of another data processing device provided in an embodiment of the present application;

[0025] Figure 5 is a schematic diagram of a data processing system provided in an embodiment of the present application;

[0026] Figure 6 It is a schematic diagram of a data processing terminal provided in an embodiment of the present application. DETAILED DESCRIPTION

[0027] In the following description, specific details such as specific system structures, technologies, etc. are proposed for the purpose of illustration rather than limitation, so as to provide a thorough understanding of the embodiments of the present application. However, it should be clear to those skilled in the art that the present application can also be implemented in other embodiments without these specific details. In other cases, detailed descriptions of well-known systems, devices, circuits, and methods are omitted to prevent unnecessary details from hindering the description of the present application.

[0028] The technical solution of the present application is described below through specific embodiments.

[0029] Reference Figure 1 , shows a schematic diagram of a data processing method provided in an embodiment of the present application, which may specifically include the following steps:

[0030] S101. Storing metering data collected by various metering terminals, wherein any metering data has collection time information.

[0031] It should be noted that this method can be applied to the data processing systems of various enterprises. The data processing system in the enterprise can be used to collect, analyze, process and display the data generated in various links such as production, equipment operation, and process flow, so as to achieve efficient management of the entire process of all links of enterprise operation. Exemplarily, the data processing system can be a system in a manufacturing industry such as a cement production enterprise. The system can collect data from various equipment in the cement production process, such as the power consumption and power generation of the cement mill system, obtain indicators such as unit product energy consumption through analysis and processing, and display them to relevant personnel through display terminals such as data dashboards, so as to monitor the cement production process and ensure the smooth progress of the production process.

[0032] In an embodiment of the present application, each metering terminal may be a device bound to a corresponding management unit and may be used to collect a certain data generated by the management unit. For example, a flow meter, an electric meter, and the like. The above-mentioned management unit may be an entity object within an enterprise, such as the cement mill system in the aforementioned example, or each mill main motor under the cement mill system, and the like. Taking the management unit as one of the mill main motors as an example, the metering terminal corresponding to the management unit may be an electric meter, and the power consumption counted by the electric meter is the metering data collected by the metering terminal, that is, the power consumed by the mill main motor during operation or standby. It should be noted that a management unit may be bound to multiple metering terminals, and different metering terminals may be used to collect different types of metering data of the bound management unit.

[0033] In a possible implementation of an embodiment of the present application, a plurality of data tables may be configured in a data processing system, and each data table may be associated with a metering terminal and used to store metering data collected by the associated metering terminal. The metering data stored in the data table may be the original data collected by the metering terminal. In this way, the original data collected by each metering terminal may be stored in the data processing system, and subsequently extracted and used according to actual needs. The embodiment of the present application stores data by storing metering data collected by a metering terminal in each data table, which not only ensures the integrity of data storage, but also avoids possible confusion when storing data collected by multiple metering terminals, ensures the accuracy of the data, and helps to conveniently extract the required data in subsequent use.

[0034] In a specific implementation, for each metering terminal installed in the enterprise, the data processing system can determine the identification information of each metering terminal, and establish a data table for each metering terminal based on the identification information. The data collected by each metering terminal can be transmitted to the data processing system. When the data processing system receives the metering data collected by any metering terminal, the metering data and the collection time information can be stored in a data table with the same identification information as the metering terminal. The above-mentioned collection time information may be the time when the metering terminal collects the corresponding metering data. In one example, the collection time information may be a certain time point, that is, a certain moment when the metering data is collected. Alternatively, the collection time information may also be used to indicate a certain time range, which may be the time period between the transmission moment of this metering data and the transmission moment of the last metering data. By correspondingly storing the collection time information, the temporal consistency of various types of metering data can be ensured when using metering data statistical indicators.

[0035] In an embodiment of the present application, each metering terminal can collect metering data according to a set time granularity. The time granularity of different types of metering terminals may be different. For example, the time granularity of the metering terminal corresponding to the metering data of electricity consumption, that is, the electric meter, may be half an hour, and the time granularity of the metering terminal corresponding to the metering data of water consumption, that is, the water meter, may be one hour. In this way, the electric meter can count the electricity consumption of the bound management unit every half an hour and transmit it to the data processing system, while the water meter can count the water consumption of the bound management unit every hour and transmit it to the data processing system.

[0036] After each metering terminal collects metering data according to the set time granularity and transmits the metering data to the data processing system, the data processing system can store the received metering data in the corresponding data table. In this way, as the metering terminal continuously collects data, a large amount of metering data can be stored in each data table of the data processing system.

[0037] S102: receiving an input indicator calculation formula for statistical target indicators, wherein the indicator calculation formula is composed of a plurality of measurement data and corresponding operators.

[0038] In an embodiment of the present application, the indicator calculation formula used to calculate the target indicator can be input by the user in the operation interface of the data processing system. The data processing system can adjust or expand the indicator statistics by receiving the user-defined indicator calculation formula.

[0039] In a possible implementation of an embodiment of the present application, a data processing system may provide an operation interface, which may include a formula editor. A user may use the formula editor to input a calculation formula for a target indicator, thereby achieving customized adjustment or expansion of system functions.

[0040] In an embodiment of the present application, in order to achieve the above-mentioned purpose, the data processing system may first model each management unit and metering terminal within the enterprise, laying the foundation for customizing the indicator calculation formula in a zero-code modeling manner.

[0041] In a specific implementation, multiple management units within an enterprise and the upper-level management units or lower-level management units associated with each management unit can be determined, and each management unit corresponds to an entity object. In this way, a hierarchical model can be generated based on each management unit and its associated upper-level management unit or lower-level management unit. The association relationship between each management unit can be clarified through the hierarchical model. Exemplarily, a cement mill system within an enterprise can be a management unit, and the cement mill system can include one or more main grinding motors. In this example, the cement mill system belongs to the upper-level management unit of the main grinding motor, and the main grinding motor belongs to the lower-level management unit of the cement mill system. By incorporating each management unit within the enterprise into the hierarchical model, a model covering all management units and the association relationship between each management unit can be constructed.

[0042] On this basis, the data processing system can further determine the metering terminal corresponding to each management unit in the hierarchical model, and by associating and storing each metering terminal with each management unit in the hierarchical model, a visual indicator selection page including objects such as each management unit, each metering terminal, and the relationship between each object can be formed. The above-mentioned visual indicator selection page can facilitate the user's operation when configuring the indicator calculation formula later.

[0043] In this way, when configuring the indicator calculation formula, that is, when receiving the indicator calculation formula of the target indicator input by the user, the data processing system can display the above-mentioned visual indicator selection page through the operation interface. By displaying the visual indicator selection page, the user can quickly and accurately determine the metering data required for the statistical target indicator according to each management unit, each metering terminal and their association. For the metering data required for the statistical target indicator, the user can select it in the visual indicator selection page. When the data processing system receives an instruction to select any metering terminal in the visual indicator selection page, the metering data type information corresponding to the selected metering terminal can be input into the formula editor.

[0044] For example, when the indicator "energy consumption per unit product of cement mill system" needs to be calculated, the user can select the metering terminal, i.e., the electric meter, corresponding to the "cement mill system" management unit for counting the "electricity consumption" indicator in the visualization indicator selection page. The formula editor will automatically generate the metering data type information of "electricity consumption of cement mill system".

[0045] In an embodiment of the present application, the formula editor also includes a plurality of operators, each of which can be used to be input into the formula editor when selected to connect the latest input metering data type information. Therefore, after generating the metering data type information of "cement mill system power consumption" in the formula editor, the user can enter the " / " symbol in the operator and select the metering terminal for counting the "output" indicator corresponding to the "cement mill system" management unit again. In this way, the complete calculation formula of "cement mill system power consumption / cement mill system output" will be displayed in the formula editor. The above-mentioned content displayed is the information that the user has entered in the formula editor, that is, the indicator calculation formula of the customized target indicator.

[0046] By saving the information entered in the formula editor, you can obtain the complete calculation formula for the statistical target indicator.

[0047] In the embodiment of the present application, by displaying the visualization indicator selection page, the user can directly select the required information in the page for generating a calculation formula.

[0048] In a possible implementation of the embodiment of the present application, before generating the indicator calculation formula, the data processing system can also verify the information input into the formula editor, that is, verify whether the indicator calculation formula is correct. The above verification can include whether there are redundant operators stored in the verification formula, whether the various parameters constituting the formula are reasonable, etc. For the indicator calculation formula that passes the verification, the data processing system can also store it and display it in the visualization indicator selection page.

[0049] In another possible implementation of the embodiment of the present application, the stored indicators can be used as components of the new indicators. Therefore, when the user uses the formula editor to generate the calculation formula of the target indicator, the user can also select a stored indicator from the visualization indicator selection page. When the data processing system receives an instruction to select a certain indicator stored in the visualization indicator selection page, the indicator calculation formula corresponding to the stored indicator can be input into the formula editor as a component of the indicator calculation formula of the new target indicator to be counted. Then, the user can continue to select operators and metering data type information corresponding to other metering terminals on this basis. In this way, the data processing system can generate the indicator calculation formula of the new target indicator based on the indicator calculation formula corresponding to the selected stored indicator and the metering data type information corresponding to other metering terminals and the corresponding operators.

[0050] Using the generated indicator calculation formula to generate a new indicator calculation formula can reduce the difficulty of formula configuration and improve the efficiency of formula configuration.

[0051] S103: acquiring a plurality of measurement data included in the indicator calculation formula according to the collection time information; and using the indicator calculation formula to calculate and obtain the target indicator.

[0052] Based on the corresponding indicator calculation formula that has been configured, the data processing system can use the formula to calculate the target indicator.

[0053] In a possible implementation of the embodiment of the present application, in order to calculate the target index, the required data can be first extracted from the collected measurement data, and then the calculation formula and the data are combined to perform calculations to obtain the target index.

[0054] When acquiring the required metering data, the data processing system can extract the required data from the metering data that has been collected based on the collection time information. Specifically, the data processing system can determine the statistical time of the target indicator. For any metering data included in the indicator calculation formula, the data processing system can obtain the data value of the matching of the collection time information and the statistical time. The matching of the above-mentioned collection time information and the statistical time can include that the time corresponding to the collection time information is the same as the statistical time, or that the time range to which the time corresponding to the collection time information belongs is the same as the statistical time.

[0055] In this way, when the indicator calculation formula is used to calculate the target indicator, the data processing system can use the data value of the matching measurement data and the corresponding operator to perform mathematical calculations to obtain the target indicator.

[0056] S104: Configure display content of the target indicator and display the display content through a display terminal.

[0057] After the target indicator is calculated, the data processing system can be configured based on the target indicator, and the configured content is the display content that needs to be displayed to the user. The above display content can be displayed through a display terminal. For example, a data dashboard, a data central control interface, etc.

[0058] In a possible implementation of the embodiment of the present application, as Figure 2 As shown, configuring the display content of the target indicator in S104 and displaying the display content through the display terminal may include the following steps S1041-S1044:

[0059] S1041. Determine a display method for the target indicator.

[0060] In the embodiment of the present application, the display mode of the target indicator may include a table, a trend chart, a pie chart, a map, a scatter plot, an indicator card, etc. The user can select a suitable display mode according to the type of the target indicator and actual needs.

[0061] S1042: Display the target indicator in a preview interface according to the display mode. The preview interface is provided with a display component, and the display component includes a graphic component and a data component. The graphic component and the data component can be added to the preview interface by dragging and dropping.

[0062] In an embodiment of the present application, a preview interface can be provided in the operation interface of the data processing system after the user selects the display mode, and the preview interface can be used to display the target indicator according to the display mode selected by the user. In addition, a variety of display components can be provided in the preview interface, such as graphic components, data components, etc. Among them, the graphic component can be used to adjust or modify the corresponding image of the target indicator displayed in the selected display mode. Exemplarily, the graphic used to mark each data point in the line chart can be modified from a circle to a diamond through the marking component in the graphic component; or alternatively, the graphic component can include a line component, and the thickness of the line in the line chart can be adjusted by modifying the line component. The data component can be used to compare and display different data in the target indicator.

[0063] In an embodiment of the present application, the above-mentioned graphic components and data components can be added to the preview interface by dragging and dropping, so that the user can view the display content obtained by the final configuration in the preview interface.

[0064] S1043: Combine the target indicator displayed in the display mode with the added graphic component and / or the data component to generate the display content.

[0065] S1044: Send the display content to a display terminal for display.

[0066] When the user adjusts the displayed target index using the graphic component and / or the data component, the data processing system can generate display content based on the final combined target index and the added graphic component and / or the data component. After saving the display content, the data processing system can send the display content to the display terminal for display.

[0067] In a possible implementation of the embodiment of the present application, the configuration of the above display content can be operated only once, and as the metering terminal continuously collects new metering data, the data processing system can update the target indicator using the newly collected metering data. The updated target indicator can be displayed on the display terminal according to the configured display content.

[0068] In an embodiment of the present application, by storing the metering data collected by each metering terminal, the data processing system can receive the indicator calculation formula for statistical target indicators input by the user. In this way, the data processing system can obtain multiple metering data contained in the above indicator calculation formula according to the collection time information of the metering data, and use the indicator calculation formula to calculate the target indicator. After configuring the display content of the target indicator, the data processing system can display the display content through the display terminal. Using the method provided in the embodiment of the present application, the user can customize the calculation formula of each indicator, which solves the problem that the adjustment or expansion of the system function can only be achieved by modifying the system code in the prior art, and meets the needs of rapid business changes.

[0069] It should be noted that the size of the serial numbers of the steps in the above embodiments does not mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present application.

[0070] For ease of understanding, the data processing method provided by the embodiment of the present application is introduced below with reference to specific examples. The method can be applied to Figure 3 In the data processing device shown, the device may specifically include components or units such as management unit modeling, indicator system modeling, calculation model verification, arithmetic unit, processor, memory, configuration tool, data display terminal, etc. The function of each component or unit and the role it plays in the process of implementing the data processing method of the embodiment of the present application are specifically introduced below.

[0071] Example 1:

[0072] Index system modeling: Indicators are standards for measuring whether the parameters of each project of an enterprise's production meet the standards. Establishing an index assessment system is very important for the production efficiency, product quality, cost accounting, and performance assessment of the enterprise. Enterprises can establish relevant indicators in the data processing system according to their own business requirements. The method provided in the embodiment of this application can support multi-level indicators and support flexible setting of calculation methods, which helps enterprises to establish a complete index assessment system.

[0073] Management unit modeling: Management units are the objects of enterprise data modeling, assessment and management. For example, all production areas of a factory in the manufacturing industry, such as departments, workshops, processes, production lines, equipment and even the factory itself, can be regarded as management units. For any enterprise, the required management units can be established first. After the establishment is completed, by directly referencing other management units as parents, a parent-child hierarchical model between the two can be established to achieve the rapid construction of the relationship between all management units and each unit. The hierarchical model constructed above can be stored in the database. The management unit associates the management unit with the indicator through the formula editor and forms the calculation parameters. It combines various operators and configures the required calculation model according to the business requirements of the enterprise, and uses the original data as the element to realize the automatic calculation of the management unit indicator data. The above calculation model may include the indicator calculation formula.

[0074] In the embodiment of the present application, all models can be quickly constructed through a visual interface. Taking the cement industry as an example, if you want to assess the unit product power consumption of a cement mill system and the main motor of the system, since the indicator calculation formula is "power consumption / output", you can first establish the two indicators of "power consumption" and "output" in the indicator system; secondly, establish the management units of "cement mill system" and "main motor of the mill" in the management unit modeling module, and set the upper management unit of the main motor of the mill to "cement mill system", that is, complete the establishment of relevant management units and indicator systems, and relevant data and upper and lower association relationships can be automatically stored in the data table. When reference is needed, the associated data will be automatically displayed in the system interface for user convenience.

[0075] Model verification and calculation: After completing the configuration of the management unit, the calculation model is established, the required indicators are referenced in the visual interface, and the data calculation points or other management units are referenced for formula configuration. When the system confirms that it is complete, the verification module will be called to automatically verify according to the built-in verification rules. If it does not meet the requirements, the result will be returned to the front end, and the operator will be reminded to modify it again in the form of a pop-up window; after passing, the storage device will be called to store the configured calculation model in the page.

[0076] Data calculation: The data processing system includes an operator, which can automatically parse the established calculation model according to the job time granularity setting value built into the memory, call the data source to calculate the final result, which is the target indicator, based on the parameters and operators in the calculation model.

[0077] For example, when the indicator "energy consumption per unit product of cement mill system" needs to be calculated, the user can select the "cement mill system" management unit and the "power consumption" indicator in the configuration interface, and the formula editor will automatically generate the "cement mill system power consumption" parameter, then select the " / " symbol in the operator, select the "cement mill system" management unit and the "output" indicator again, and the complete calculation model of "cement mill system power consumption / cement mill system output" will be displayed in the formula editor. When saving the calculation model, the system will automatically check whether the model is correct, such as whether there are redundant operators, whether the parameter composition is reasonable, etc. If the model is correct, call the storage module to store the model in the database after completion. When the operator detects that the current time is the same as the set time granularity, it automatically calls the corresponding module to calculate the result and save it.

[0078] Configuration tools and data display terminal: After the indicator calculation is completed, when the user needs it, the relevant data can be displayed in a variety of ways according to their business needs. The data processing system in the embodiment of the present application can provide a variety of custom configuration tools to support enterprises to complete the layout, editing, data extraction and other tasks of the display content according to their own business needs, and can realize flexible display of data without programming to meet the diverse requirements of customers. For example, Figure 3 The configuration tools in can be used for permission control, page layout and parameter configuration.

[0079] In an embodiment of the present application, the data display terminal may include two parts: a zero-code large-screen editing tool and a large-screen display module.

[0080] Zero-code large-screen editing tool: The zero-code large-screen editing tool can be used for enterprise users to realize self-service, zero-code visual large-screen configuration. The editing tool provides the chart components required to configure the large screen, such as tables, trend charts, pie charts, maps, scatter plots, indicator cards, etc., and realizes the free configuration of graphic metadata through the free combination of screening management units, indicators, and time. Users can use graphic components and data components to drag and drop to realize fast and efficient configuration of the large screen.

[0081] For example, the large screen displays the monthly power consumption data label of a company's E2 workshop, the daily production trend chart of this month, and the columnar comparison of unit product power consumption per day of this month. Figure 3Item content. When the user chooses to create a new large-screen file, the system will first detect the user's role and establish an association between the role and the established large-screen through the data table. When other users access it, the platform automatically matches it. If the role is different, the large screen cannot be accessed to achieve access control. After the large-screen file is established, the system can start to configure the large-screen display content. When the user adds a display control, the system can automatically generate a block. When editing the block, it will be called and the editing page will pop up on the front end. By recording the title (E2 workshop power consumption), model type, data name (E2 workshop), indicator (power consumption), time type (monthly) and other parameters selected or entered by the user, a unique identifier can be generated, and this information will be stored in the database. At the same time, the background will begin to parse the saved data, match the data name (i.e. management unit), indicator and time type, automatically find the corresponding value from the data table, render the front-end display control according to the model type, and display the result on the screen. If the model type is a data label, it will display numbers, if the type is a trend chart, it will display the daily production trend line, and if the type is a bar comparison chart, it will display the bar chart of the unit consumption per day of the month. The front-end component supports users to adjust the position, size and shape of each block to meet usage requirements with more flexible layout and good experience.

[0082] Large screen display module: for the system to verify whether the user has the access rights to the relevant large screen. If so, the system will analyze the parameters configured in each block of the large screen one by one, call the relevant data from the database and display it on the page according to the model type.

[0083] In addition, the data display terminal can also use the zero-code reporting tool. The zero-code reporting tool can quickly generate the visual reports required by users by combining charts based on multiple dimensions such as management units, indicators, teams, products, time, and multiple data presentation methods such as trends, structures, and comparisons. Users can save frequently used reports in different categories according to the needs of the usage scenario for quick query. The reporting tool builds a data analysis model based on the indicator model, which can deeply encapsulate the report generation logic, allowing users to quickly customize personalized reports without any coding to meet data statistics and analysis needs.

[0084] The report tool in the embodiment of the present application mainly includes three parts: report query, custom save and quick query.

[0085] Taking the electricity consumption report of the PVC production line as an example, the system background matches the query conditions entered by the user on the front end with the management unit, electricity consumption index, time, etc. of the PVC production line in the data table, and forms a title by splicing the management unit, index and time in a textual manner. The corresponding data table is found according to the time type, and the report control on the page is filled with data. At the same time, the chart control is called to bind the relevant data to the control, and the data is displayed on the page in the form of a table + chart to complete the data display. When the user needs to save the display results for future quick query, the system can associate the currently selected query parameters with the report name entered by the user and form a complete report query condition record, which is saved in the data table to realize the report saving function. When the user makes a quick query, he only needs to click on the report name, and the background can find the relevant parameters in the condition record from the database according to the report name. The user does not need to perform too much operation, and directly finds the relevant data through the parameters, and automatically binds and presents it in the table control and chart control on the page, realizing the quick query of the saved report data.

[0086] The data processing device and data processing method provided by the embodiment of the present application can be applied to the fields of manufacturing, industry and the Internet. By using zero-code tools to quickly realize big data modeling, an enterprise data visualization platform can be constructed. In the information management system of various enterprises such as manufacturing, various data such as enterprise production, energy consumption, equipment, process, environmental protection, etc. are collected through networking, and the calculation model established by the modeling tool according to the user-defined indicator system automatically counts the results, and is transferred to the data table according to different time granularities. When the user sets the corresponding display content through the visualization tool, the system can obtain relevant data from the data table according to the configured content, and display it in the terminal interface through the referenced front-end controls (such as text labels, trend charts, structure diagrams, tables, etc.), so as to achieve the purpose of quickly generating various visualization platforms such as digital kanban boards, management cockpits, and production reports according to different business customizations, meet the needs of enterprises for data statistics, monitoring, analysis, and mining of the entire production process, and realize the efficient management of the entire production process by enterprises.

[0087] Example 2:

[0088] In energy management application software and other management application software based on IoT collection, enterprises collect data from metering terminal devices such as electric meters, coal powder scales, and material scales through networking to realize the calculation of management indicators such as production and energy efficiency, thereby realizing the refined management of management units such as production equipment, processes, workshops, and the entire factory. In the process of calculating management indicators, the calculation of indicators is the metering relationship between the associated statistical objects and the metering terminals. By configuring the calculation formula of the metering terminal, the data collected by the metering terminal is calculated through the formula to realize the statistics of the indicator data. The method and device provided in the embodiment of the present application realize the dynamic, visual, and rapid modeling of management indicators by opening the modeling rights of metering terminals and management units to enterprise business personnel through a visual software interface without relying on programmers.

[0089] Management indicators are quantifiable indicators used in the system to count and analyze the performance of relevant business of an enterprise, including basic indicators and KPI indicators. Basic indicators are used to measure the data of a single business unit of an enterprise, such as the daily electricity consumption, raw coal consumption, and diesel consumption of the enterprise, which can be collected through a single metering terminal such as a smart meter, coal powder scale, etc.; KPI indicators are composite indicators that can measure the performance level of a certain business field of an enterprise, such as the energy efficiency KPI indicator of a cement company "comprehensive energy consumption per ton of cement = comprehensive coal consumption of clinker * (clinker consumption / cement output) + comprehensive electricity consumption of cement * 0.1229 + standard coal consumption of fuel consumed for drying cement admixtures". This indicator integrates basic indicator data such as comprehensive coal consumption, consumption, output, comprehensive electricity consumption, and fuel consumption, and can be used to measure the comprehensive energy efficiency level of a cement company in producing one ton of cement.

[0090] Management indicators can be decomposed hierarchically according to business needs. For example, comprehensive energy consumption can be decomposed into secondary indicators such as electricity consumption, coal consumption, and diesel consumption. Indicators can be classified according to business affiliation, such as production indicators, energy consumption indicators, sales indicators, financial indicators, etc.

[0091] Management indicator modeling is used to receive enterprise management indicator models customized by users through a visual interface, such as indicator category, number, name, superior indicator, indicator function, statistical period, etc. The model will be solidified through the memory to provide selection and basis for subsequent metering terminal modeling and management unit modeling. If you want to count the power consumption and comprehensive energy consumption of a certain process, "power consumption" and "comprehensive energy consumption" will be modeled as management indicators through this step.

[0092] Metering terminal modeling: The metering terminal is a terminal metering device in the system that can collect basic indicator data through networking, such as smart meters, material scales, flow meters, sensors, etc. The metering terminal is the carrier of basic indicator data. The system realizes real-time online collection of metering terminal data through IOT components, and calculates the difference in the statistical period of metering points according to time dimensions such as hours, days, months, and years, such as meter power consumption, etc. Through online modeling of metering terminals, it provides a basic data source for indicator modeling of management units.

[0093] The system receives the user-defined metering terminal model through metering terminal modeling, including information such as collection point number, terminal name, collection index, installation location, and verification cycle, and transfers the metering terminal model to the storage device for solidification. For example, the user-defined model of a meter is: [Point number: CFK00_02A.04, terminal name: Broken electrical room meter, collection index: electricity consumption, installation location: Broken electrical room; verification cycle: 30 days]

[0094] Management unit definition and formula modeling: The management unit system is the object of enterprise data modeling, analysis and assessment, such as a company, a workshop, a production line, a process or a piece of equipment. Through the online definition of management unit entities, enterprises can realize visual modeling of control objects according to management needs.

[0095] Management unit modeling includes two parts: entity model and statistical model:

[0096] The entity model is a user-defined modeling of the management unit entity, including the management unit name, type, parent management unit, description, etc. For example, the model of a cement mill in a cement enterprise: [Management unit name: 1# cement mill, type: production host, parent management unit: cement process, description: from clinker unloading, transportation, cement grinding system to cement transportation into the warehouse, including auxiliary materials such as fly ash and gypsum out of the warehouse, crushing and transportation].

[0097] After receiving the definition of the management unit entity model, the user can define the statistical model of the management unit through the system visualization interface: when configuring the statistical model, the system calls the defined management indicators and metering terminal models in the memory through the processor. The user selects the indicator model required for the current configuration management unit through the visualization interface provided by the system, and selects the corresponding metering terminal from the metering terminal model according to the actual calculation requirements. Combined with the calculation logic, the definition of the management unit statistical model can be completed.

[0098] For example, the power consumption calculation formula of the 1# cement mill in a cement plant is "roller press room + mill room + HR5AH mill + A105 fixed roller + A106 moving roller + laboratory [office building] + public lighting - raw material warehouse top induced draft fan - HR9#10# bulk - screw air compressor + screw air compressor * 0.5". When configuring the power consumption statistical model of the management unit, "1# cement mill" is the management unit entity that needs to be configured, and "power consumption" is the management indicator model that needs to be configured. In the statistical model of the management unit, "roller press room", "mill room", "HR5AH mill", etc. are all metering terminal models that carry collected data.

[0099] Management units can be hierarchically modeled according to the management level. For example, if the 1# cement process of a factory includes two cement mills, 1# and 2#, then the 1# and 2# cement mills can be defined as sub-management units of the 1# cement process. In addition to building the management unit statistical model by calling the metering terminal, the system also supports the statistical model of the sub-management unit defined in the memory through the processor scheduling, and has realized the rapid construction of the management unit's own statistical model. For example, the power consumption index of the 1# cement process can be configured as the power consumption of the 1# cement mill + the power consumption of the 2# cement mill; the output index of the 1# cement process can be configured as the output of the 1# cement mill + the output of the 2# cement mill.

[0100] Through the visualization modeling and free combination of management indicators, metering terminals, and management units, user-defined configuration of complex statistical models can be completed through the visualization interface. For example, the energy efficiency indicator of a cement plant: "Comprehensive power consumption per ton of cement = ((power consumption of limestone transportation section within the plant (collected) / limestone crushing limestone production or purchase volume * raw material mill limestone consumption + raw material process power consumption (collected) / raw material mill raw material production or purchase volume * rotary kiln raw material consumption + clinker process power consumption (collected)) / rotary kiln clinker production or purchase volume * cement mill clinker consumption + packaging process power consumption (collected) + gypsum, mixed material entry section power consumption (collected) + cement process power consumption (collected)) / (cement mill P·O_42.5 production or purchase volume + cement mill P·C_42.5 production or purchase volume + M_32.5 production or purchase volume + P·P_32.5 production or purchase volume + P·R_7.5 production or purchase volume)". All the components involved in the calculation in this formula are the combination of metering terminals, management units, management indicator models and operators. Users can define, adjust and expand statistical models at any time according to business needs through the visual interface without programming, realizing zero-code visual modeling.

[0101] Identification verification module: After completing the configuration of the management unit model, the verification module performs formula verification on the data statistical model of the management unit. The verification rules include that the two metering terminal models must contain operators and the two operators cannot be directly connected. If the rule verification fails, the system will not save the current statistical model and remind the user to correct it through the visual interface; if the rule verification is successful, the processor will automatically convert the metering terminal name in the statistical model into a unique identifier of the metering terminal and then hand it over to the memory to save the model.

[0102] Indicator operator: The processor also includes a formula operator. The processor will perform statistics on the indicator data of the management unit according to the statistical cycle requirements of the indicators in the management unit model and the timing scheduling operator according to the operation rules of the statistical model, and save the final statistical management unit indicator data through the memory.

[0103] Data display module: After completing the management unit modeling, the data display module in the system obtains the management unit indicator data through the processor scheduling memory to realize statistical reporting and data analysis functions.

[0104] Reference Figure 4 , shows a schematic diagram of another data processing device provided in an embodiment of the present application, which may specifically include a storage module 401, a receiving module 402, a computing module 403 and a display module 404, wherein:

[0105] Storage module 401, used to store metering data collected by various metering terminals, any of the metering data has collection time information;

[0106] A receiving module 402 is used to receive an input indicator calculation formula for statistical target indicators, wherein the indicator calculation formula is composed of multiple measurement data and corresponding operators;

[0107] The calculation module 403 is used to obtain a plurality of measurement data included in the indicator calculation formula according to the collection time information; and calculate the target indicator using the indicator calculation formula;

[0108] The display module 404 is used to configure the display content of the target indicator and display the display content through a display terminal.

[0109] In a possible implementation of the embodiment of the present application, the storage module 401 may be specifically used for:

[0110] Determine the identification information of each of the metering terminals; establish a data table for each of the metering terminals based on the identification information; when metering data collected by any of the metering terminals is received, store the metering data and collection time information in a data table having the same identification information as the metering terminal, wherein the metering data is the original data collected by the metering terminal.

[0111] In a possible implementation manner of the embodiment of the present application, the apparatus may further include a configuration unit, and the configuration unit may be specifically configured to:

[0112] Determine multiple management units and the upper management unit or lower management unit associated with each of the management units, any of the management units corresponds to an entity object; generate a hierarchical model according to each of the management units and its associated upper management unit or lower management unit; determine the metering terminal corresponding to each of the management units in the hierarchical model; associate each of the metering terminals with each of the management units in the hierarchical model and store them to form a visual indicator selection page.

[0113] In a possible implementation of the embodiment of the present application, the receiving module 402 may be specifically used for:

[0114] The visualization indicator selection page is displayed; when an instruction to select any metering terminal in the visualization indicator selection page is received, the metering data type information corresponding to the metering terminal is input into the formula editor, wherein the formula editor also includes a plurality of operators, and any operator is used to be input into the formula editor when selected to connect the latest input metering data type information; the information input in the formula editor is saved, and the information is a customized indicator calculation formula for the target indicator.

[0115] In a possible implementation of the embodiment of the present application, the visualization indicator selection page also includes stored indicators, and the receiving module 402 can also be used to:

[0116] When an instruction to select an indicator stored in the visualization indicator selection page is received, the indicator calculation formula corresponding to the stored indicator is input into the formula editor as a component of the indicator calculation formula of the target indicator to be counted; based on the indicator calculation formula corresponding to the selected stored indicator and the metering data type information and corresponding operators corresponding to other metering terminals, the indicator calculation formula of the target indicator is generated.

[0117] In a possible implementation of the embodiment of the present application, the calculation module 403 may be specifically used to:

[0118] Determine the statistical time of the target indicator; for any measurement data included in the indicator calculation formula, obtain the data value whose collection time information matches the statistical time, wherein the collection time information matches the statistical time including that the time corresponding to the collection time information is the same as the statistical time, or that the time range to which the time corresponding to the collection time information belongs is the same as the statistical time; perform mathematical calculations using the matched data value of the measurement data and corresponding operators to obtain the target indicator.

[0119] In a possible implementation of the embodiment of the present application, the display module 404 may be specifically used for:

[0120] Determine a display mode of the target indicator; display the target indicator in a preview interface according to the display mode, the preview interface is provided with a display component, the display component includes a graphic component and a data component, the graphic component and the data component can be added to the preview interface by dragging and dropping; combine the target indicator displayed according to the display mode with the added graphic component and / or the data component to generate the display content; send the display content to a display terminal for display.

[0121] An embodiment of the present application provides a data processing device, and by using the device, each step in the aforementioned method embodiments can be implemented.

[0122] As for the device embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the description of the method embodiment part.

[0123] like Figure 5 As shown, the embodiment of the present application provides a data processing system, which may include multiple metering terminals, such as Figure 5 The metering terminal 1, metering terminal 2, ... metering terminal n, etc., as well as the data processing terminal and the display terminal. The data processing terminal can be used to implement the functions of each step in the aforementioned method embodiments, that is, to receive the metering data collected by each metering terminal and analyze and process it in combination with the user-defined indicator calculation formula or model, and display the final display content to the user through the display terminal. The relevant functions of the data processing system can be found in the introduction of the aforementioned embodiment, which will not be repeated here.

[0124] Reference Figure 6 , shows a schematic diagram of a data processing terminal provided by an embodiment of the present application. Figure 6As shown, the data processing terminal 600 in the embodiment of the present application includes: a processor 610, a memory 620, and a computer program 621 stored in the memory 620 and executable on the processor 610. When the processor 610 executes the computer program 621, the steps in each embodiment of the above-mentioned data processing method are implemented, for example Figure 1 Alternatively, when the processor 610 executes the computer program 621, the functions of each module / unit in the above-mentioned device embodiments are realized, for example Figure 4 Functions of modules 401 to 404 are shown.

[0125] Exemplarily, the computer program 621 may be divided into one or more modules / units, which are stored in the memory 620 and executed by the processor 610 to complete the present application. The one or more modules / units may be a series of computer program instruction segments capable of completing specific functions, which may be used to describe the execution process of the computer program 621 in the data processing terminal 600. For example, the computer program 621 may be divided into a storage module, a receiving module, a computing module, and a display module, and the specific functions of each module are as follows:

[0126] A storage module, used to store metering data collected by various metering terminals, any of the metering data having collection time information;

[0127] A receiving module, used for receiving an input indicator calculation formula for statistical target indicators, wherein the indicator calculation formula is composed of a plurality of measurement data and corresponding operators;

[0128] A calculation module, used to obtain a plurality of measurement data included in the indicator calculation formula according to the collection time information; and use the indicator calculation formula to calculate and obtain the target indicator;

[0129] A display module is used to configure the display content of the target indicator and display the display content through a display terminal.

[0130] The data processing terminal 600 may be a terminal or device capable of implementing each of the above-mentioned method embodiments. For example, the data processing terminal 600 may be a computing device such as a desktop computer or a cloud server. The data processing terminal 600 may include, but is not limited to, a processor 610 and a memory 620. Those skilled in the art will appreciate that Figure 6It is only an example of the data processing terminal 600 and does not constitute a limitation of the data processing terminal 600. It may include more or fewer components than shown in the figure, or a combination of certain components, or different components. For example, the data processing terminal 600 may also include input and output devices, network access devices, buses, etc.

[0131] The processor 610 may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. A general-purpose processor may be a microprocessor or any conventional processor, etc.

[0132] The memory 620 may be an internal storage unit of the data processing terminal 600, such as a hard disk or memory of the data processing terminal 600. The memory 620 may also be an external storage device of the data processing terminal 600, such as a plug-in hard disk, a smart media card (SMC), a secure digital (SD) card, a flash card, etc. equipped on the data processing terminal 600. Further, the memory 620 may also include both an internal storage unit of the data processing terminal 600 and an external storage device. The memory 620 is used to store the computer program 621 and other programs and data required by the data processing terminal 600. The memory 620 may also be used to temporarily store data that has been output or is to be output.

[0133] An embodiment of the present application also discloses a data processing terminal, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the data processing method described in the above-mentioned embodiments when executing the computer program.

[0134] The embodiments of the present application further disclose a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the data processing method described in the above embodiments is implemented.

[0135] The embodiments of the present application further disclose a computer program product. When the computer program product is run on a computer, the computer is enabled to execute the data processing methods described in the above embodiments.

[0136] The above-described embodiments are only used to illustrate the technical solutions of the present application, rather than to limit them. Although the present application is described in detail with reference to the above-mentioned embodiments, a person skilled in the art should understand that the technical solutions described in the above-mentioned embodiments can still be modified, or some of the technical features can be replaced by equivalents; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present application, and should be included in the protection scope of the present application.

Claims

1. A data processing method, characterized in that: include: Determine a plurality of management units and an upper-level management unit or a lower-level management unit associated with each of the management units, wherein any of the management units corresponds to an entity object; Generate a hierarchical model according to each of the management units and its associated upper-level management unit or lower-level management unit; Determine a metering terminal corresponding to each of the management units in the hierarchical model; Associating and storing each of the metering terminals with each of the management units in the hierarchical model to form a visual indicator selection page; Determine identification information of each metering terminal, and establish a data table for each metering terminal based on the identification information; When metering data collected by any metering terminal is received, the metering data and the collection time information are stored in a data table having the same identification information as the metering terminal, any metering data having the collection time information, and the metering data being the original data collected by the metering terminal; Displaying the visualization indicator selection page, wherein the visualization indicator selection page also includes stored indicators, and the stored indicators can be used as components of the new indicator; When receiving an instruction to select any metering terminal in the visualization indicator selection page, inputting metering data type information corresponding to the metering terminal into a formula editor, wherein the formula editor further includes a plurality of operators, and any operator is used to be input into the formula editor when selected to connect the metering data type information input most recently; Saving the information entered in the formula editor, wherein the information is an indicator calculation formula of a custom target indicator, and the indicator calculation formula is composed of multiple measurement data and corresponding operators; According to the collection time information, a plurality of measurement data included in the indicator calculation formula is obtained; And using the indicator calculation formula to calculate and obtain the target indicator; The display content of the target indicator is configured and displayed through a display terminal.

2. The method according to claim 1, characterized in that The indicator calculation formula for receiving input for statistical target indicators also includes: When receiving an instruction to select an indicator stored in the visualization indicator selection page, inputting the indicator calculation formula corresponding to the stored indicator into the formula editor as a component of the indicator calculation formula of the target indicator to be counted; Based on the selected stored indicator calculation formula corresponding to the indicator and the metering data type information and corresponding operators corresponding to other metering terminals, the indicator calculation formula of the target indicator is generated.

3. The method according to claim 1 or 2, characterized in that: The acquiring, according to the collection time information, a plurality of measurement data included in the indicator calculation formula comprises: Determine the statistical time of the target indicator; For any measurement data included in the indicator calculation formula, obtaining a data value whose collection time information matches the statistical time, wherein the collection time information matches the statistical time, including that the time corresponding to the collection time information is the same as the statistical time, or that the time range to which the time corresponding to the collection time information belongs is the same as the statistical time; Accordingly, the target indicator is calculated by using the indicator calculation formula, including: The target indicator is obtained by performing mathematical calculations using the matched data values ​​of the measurement data and corresponding operators.

4. The method according to claim 3, characterized in that: The configuring the display content of the target indicator and displaying the display content through a display terminal includes: Determining how the target indicator is to be displayed; Displaying the target indicator in a preview interface according to the display mode, wherein the preview interface is provided with a display component, wherein the display component includes a graphic component and a data component, and the graphic component and the data component can be added to the preview interface by dragging and dropping; Combining the target indicator displayed in the display mode with the added graphic component and / or the data component to generate the display content; The display content is sent to a display terminal for display.

5. A data processing device, characterized in that: include: A storage module, used to store metering data collected by various metering terminals, any of the metering data having collection time information; A receiving module, used for receiving an input indicator calculation formula for statistical target indicators, wherein the indicator calculation formula is composed of a plurality of measurement data and corresponding operators; A calculation module, used to obtain a plurality of measurement data included in the indicator calculation formula according to the collection time information; And using the indicator calculation formula to calculate and obtain the target indicator; A display module, used to configure the display content of the target indicator and display the display content through a display terminal; Wherein, the storage module is specifically used for: Determine identification information of each metering terminal; establish a data table for each metering terminal based on the identification information; when metering data collected by any metering terminal is received, store the metering data and collection time information in a data table having the same identification information as the metering terminal, wherein the metering data is the original data collected by the metering terminal; The device further comprises a configuration unit, wherein the configuration unit is specifically configured to: Determine multiple management units and upper-level management units or lower-level management units associated with each management unit, any management unit corresponds to an entity object; generate a hierarchical model according to each management unit and its associated upper-level management unit or lower-level management unit; determine the metering terminal corresponding to each management unit in the hierarchical model; associate each metering terminal with each management unit in the hierarchical model and store them to form a visual indicator selection page; The receiving module is specifically used for: The visualization indicator selection page is displayed; when an instruction to select any metering terminal in the visualization indicator selection page is received, the metering data type information corresponding to the metering terminal is input into the formula editor, wherein the formula editor also includes a plurality of operators, and any operator is used to be input into the formula editor when selected to connect the latest input metering data type information; the information input in the formula editor is saved, and the information is a customized indicator calculation formula for the target indicator. The visualization indicator selection page also includes stored indicators, and the stored indicators can be used as components of new indicators.

6. A data processing system, comprising a plurality of metering terminals, at least one display terminal, and a data processing terminal connected to the plurality of metering terminals and the at least one display terminal, respectively, wherein the data processing terminal comprises a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the data processing method according to any one of claims 1 to 4 is implemented.

7. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the data processing method according to any one of claims 1 to 4 is implemented.

Images