CN118445352B

CN118445352B - Data processing method, device and data processing system

Info

Publication number: CN118445352B
Application number: CN202410537245.1A
Authority: CN
Inventors: 龙晓云; 赵伟军; 麦信林
Original assignee: Guangzhou Contact Intelligent Technology Co ltd
Current assignee: Guangzhou Contact Intelligent Technology Co ltd
Priority date: 2024-04-29
Filing date: 2024-04-29
Publication date: 2025-03-28
Anticipated expiration: 2044-04-29
Also published as: CN118445352A

Abstract

The embodiment of the application is suitable for the technical fields of industrial Internet and data processing, and provides a data processing method, a data processing device and a data processing system, wherein the method comprises the steps of storing metering data acquired through each metering terminal, wherein any metering data has acquisition time information; the method comprises the steps of receiving an input index calculation formula for counting target indexes, wherein the index calculation formula consists of a plurality of metering data and corresponding operators, acquiring the metering data contained in the index calculation formula according to the acquisition time information, calculating by adopting the index calculation formula to obtain the target indexes, configuring display content of the target indexes, and displaying the display content through a display terminal. By adopting the method, the calculation formula of the index can be configured in a self-defined way, the adjustment or expansion of the system function can be realized without modifying the system code, and the requirement of rapid change of the service is met.

Description

Data processing method, device and system

Technical Field

The embodiment of the application belongs to the technical field of data processing, and particularly relates to a data processing method, a data processing device and a data processing system.

Background

In the informatization management system in various fields of manufacturing industry and the like, various data such as enterprise production, energy consumption, equipment, technology, environmental protection and the like can be collected through networking, corresponding visual information is generated after processing, such as digital signboards, production reports and the like, and the data statistics, monitoring, analysis and excavation requirements of enterprises on the whole production process are realized.

In the prior art, the conventional informatization management system mainly uses a data platform embedded in the system to realize the functions. The report generation and data display functions of the data platform usually need to be customized one by a system provider according to the requirements of enterprises, the enterprises cannot independently adjust or optimize the functions realized by the system or the data platform in the use process, and even if smaller data changes, the providers need to be contacted to revise codes. Illustratively, the data platform may be used to count and present various types of data indicators in an enterprise's production process, which are typically implemented in a written code. However, as business changes, the data indicators that need to be counted and presented may change. When a new data index is required to be counted and displayed, the prior art can only achieve the purpose by recoding codes capable of realizing the counting and displaying functions of the new data index through suppliers, the whole process is low in efficiency and high in cost, and the stability of the system is reduced easily because the codes are repeatedly modified, so that the normal use of the system and a data platform is influenced.

Disclosure of Invention

In view of this, the embodiments of the present application provide a data processing method, apparatus, and data processing system, which are used to adjust or extend the functions implemented by the system in a self-defined manner by using a zero code modeling manner, so as to meet the requirement of rapid service change.

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

storing metering data acquired by each metering terminal, wherein any metering data has acquisition time information;

Receiving an input index calculation formula for counting target indexes, wherein the index calculation formula consists of a plurality of metering data and corresponding operators;

acquiring a plurality of metering data contained in the index calculation formula according to the acquisition time information, and calculating by adopting the index calculation formula to obtain the target index;

and configuring the display content of the target index and displaying the display content through a display terminal.

A second aspect of an embodiment of the present application provides a data processing apparatus, including:

The storage module is used for storing metering data acquired through each metering terminal, and any metering data has acquisition time information;

The receiving module is used for receiving an input index calculation formula for counting target indexes, wherein the index calculation formula consists of a plurality of metering data and corresponding operators;

the calculation module is used for acquiring a plurality of metering data contained in the index calculation formula according to the acquisition time information, and calculating by adopting the index calculation formula to obtain the target index;

and the display module is used for configuring the display content of the target index and displaying the display content through the display terminal.

A third aspect of an embodiment of the present application provides a data processing system, including a plurality of metering terminals, at least one display terminal, and a data processing terminal respectively connected to the plurality of metering terminals and the at least one display terminal, the data processing terminal including a memory, a processor, and a computer program stored in the memory and executable on the processor, the processor implementing the data processing method according to the first aspect when executing the computer program.

A fourth aspect of embodiments of the present application provides a computer-readable storage medium storing a computer program which, when executed by a processor, implements a data processing method as described in the first aspect above.

A fifth aspect of an embodiment of the present application provides a computer program product for, when run on a computer, causing the computer to perform the data processing method of the first aspect described above.

Compared with the prior art, the embodiment of the application has the following beneficial effects:

According to the embodiment of the application, the data processing system can receive the index calculation formula for counting the target index input by the user by storing the metering data acquired by each metering terminal. In this way, the data processing system can acquire a plurality of metering data contained in the index calculation formula according to the acquisition time information of the metering data, and calculate by adopting the index calculation formula to obtain the target index. After the display content of the target index is configured, the data processing system can display the display content through the display terminal. By applying the method provided by the embodiment of the application, a user can configure the calculation formula of each index in a self-defined way, the problem that the adjustment or expansion of the system function can be realized only by modifying the system code in the prior art is solved, and the requirement of rapid change of the service is met.

Drawings

In order to more clearly illustrate the technical solutions of the embodiments of the present application, the following will briefly introduce the drawings that are required to be used in the embodiments or the description of the prior art. It is evident that the drawings in the following description are only some embodiments of the present application and that other drawings may be obtained from these drawings without inventive effort for a person of ordinary skill in the art.

FIG. 1 is a schematic diagram of a data processing method according to an embodiment of the present application;

FIG. 2 is a schematic diagram of a possible implementation of S104 in a data processing method according to an embodiment of the present application;

FIG. 3 is a schematic diagram of a data processing apparatus according to an embodiment of the present application;

FIG. 4 is a schematic diagram of another data processing apparatus according to an embodiment of the present application;

FIG. 5 is a schematic diagram of a data processing system provided by an embodiment of the present application;

Fig. 6 is a schematic diagram of a data processing terminal according to an embodiment of the present application.

Detailed Description

In the following description, for purposes of explanation and not limitation, specific details are set forth such as the particular system architecture, techniques, etc., in order to provide a thorough understanding of the embodiments of the present application. It will be apparent, however, to one skilled in the art that the present application may be practiced in other embodiments that depart from these specific details. In other instances, detailed descriptions of well-known systems, devices, circuits, and methods are omitted so as not to obscure the description of the present application with unnecessary detail.

The technical scheme of the application is described below through specific examples.

Referring to fig. 1, a schematic diagram of a data processing method provided by an embodiment of the present application may specifically include the following steps:

S101, storing metering data acquired through each metering terminal, wherein any metering data has acquisition time information.

It should be noted that the method can be applied to data processing systems of various enterprises. The data processing system in the enterprise can be used for collecting, analyzing, processing and displaying the data generated by various links such as production, equipment operation, process flow and the like, so that the whole process of the various links of the enterprise operation is efficiently managed. The data processing system can be a system in a manufacturing industry such as a cement production enterprise, the system can collect data of various devices in the cement production process, such as electricity consumption, electricity generation and the like of a cement grinding system, obtain indexes such as unit product energy consumption and the like through analysis and processing, and display the indexes to related personnel through display terminals such as a data billboard and the like so as to monitor the cement production flow and ensure the smooth proceeding of the production process.

In the embodiment of the application, each metering terminal can be a device which is bound with a corresponding management unit and can be used for collecting certain data generated by the management unit. Such as a flowmeter, an ammeter, etc. The management unit may be a physical object within the enterprise, such as the cement mill system in the previous example, or the mill main motors under the cement mill system, etc. Taking the management unit as one of the main grinding motors as an example, the metering terminal corresponding to the management unit can be an ammeter, and the electricity consumption counted by the ammeter is metering data collected by the metering terminal, namely the electricity consumption consumed in the running or standby process of the main grinding motor. It should be noted that one management unit may be bound to a plurality of metering terminals, and different metering terminals may be used to collect metering data of different types of the bound management units.

In one possible implementation manner of the embodiment of the application, a plurality of data tables can be configured in the data processing system, and each data table can be associated with one metering terminal and used for storing metering data acquired by the associated metering terminal. The metering data stored in the data table may be raw data collected by the metering terminal. In this way, the original data collected by each metering terminal can be stored in the data processing system and then extracted and used according to actual requirements. According to the embodiment of the application, the data are stored according to the metering data acquired by one metering terminal respectively stored in each data table, so that the integrity of data storage can be ensured, the possible confusion of the data acquired by a plurality of metering terminals during storage can be avoided, the accuracy of the data is ensured, and the required data can be conveniently extracted during subsequent use.

In a specific implementation, for each metering terminal installed within an enterprise, the data processing system may determine identification information for 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 a data processing system. When the data processing system receives metering data collected by any metering terminal, the metering data and the collecting time information can be correspondingly stored into a data table with the same identification information as the metering terminal. The collection time information may be the time when the metering terminal collects the corresponding metering data. In one example, the acquisition time information may be a point in time, i.e. a point in time when the metering data is acquired. Or the acquisition time information may be used to indicate a time range, which may be a time period between the time of transmission of the present metering data and the time of transmission of the last metering data. By correspondingly storing the acquisition time information, the time consistency of the metering data of each type can be ensured when the metering data statistics index is used.

In the embodiment of the application, each metering terminal can collect metering data according to the 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 the electricity consumption, that is, the ammeter, may be half an hour, and the time granularity of the metering terminal corresponding to the metering data of the water consumption, that is, the watermeter, may be one hour. Thus, the electricity meter can count the electricity consumption of the bound management unit every half hour and transmit the electricity consumption to the data processing system, and the water meter can count the water consumption of the bound management unit every half hour and transmit the water consumption to the data processing system.

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 a corresponding data table. Thus, 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.

S102, receiving an input index calculation formula for counting target indexes, wherein the index calculation formula consists of a plurality of metering data and corresponding operators.

In the embodiment of the application, the index calculation formula for counting the target index can be input by a user in the operation interface of the data processing system, and the data processing system can realize adjustment or expansion of index statistics by receiving the index calculation formula customized by the user.

In one possible implementation manner of the embodiment of the present application, the data processing system may provide an operation interface, where the operation interface may include a formula editor, and a user may use the formula editor to input a calculation formula of the target index, so as to implement a custom adjustment or expansion of a system function.

In the embodiment of the application, in order to achieve the above purpose, the data processing system can firstly model each management unit and metering terminal in the enterprise, and lay a foundation for customizing an index calculation formula in a zero code modeling mode.

In a particular implementation, a plurality of management units within an enterprise may be determined, as well as a superior management unit or a inferior management unit associated with each management unit, each management unit corresponding to one entity object. In this way, a hierarchical model may be generated from each management unit and its associated superordinate or subordinate management units. The association relationship between the management units can be clarified through the hierarchical model. By way of example, a particular cement grinding system within an enterprise may be a management unit that may include one or more grinding main motors therein. In this example, the cement mill system belongs to an upper management unit of the mill main motor, and the mill main motor belongs to a lower management unit of the cement mill system. By incorporating each management unit in the enterprise into the hierarchical model, a model covering all management units and the association relationship between each management unit can be constructed.

Based on the above, the data processing system can further determine the metering terminal corresponding to each management unit in the hierarchical model, and by storing each metering terminal in association with each management unit in the hierarchical model, a visual index selection page containing objects such as each management unit, each metering terminal and the like and association relations among the objects can be formed. The visual index selection page can be convenient for a user to operate when the index calculation formula is configured later.

Thus, when the index calculation formula is configured, that is, when the index calculation formula of the target index input by the user is received, the data processing system can display the visual index selection page through the operation interface. By displaying the visual index selection page, a user can quickly and accurately determine metering data required by the statistics target index according to each management unit, each metering terminal and the association relation thereof. For metering data required for counting target indexes, a user can select in a visual index selection page. When the data processing system receives an instruction of selecting any metering terminal in the visual index selection page, metering data type information corresponding to the selected metering terminal can be input into the formula editor.

For example, when the index of "energy consumption of unit product of cement mill system" needs to be calculated, the user may select a metering terminal, i.e. an ammeter, corresponding to the management unit of "cement mill system" for counting the index of "electricity consumption" in the visual index selection page. The formula editor will automatically generate the metering data type information of "power consumption of the cement grinding system".

In an embodiment of the present application, the formula editor further includes a plurality of operators, each of which can be used to input into the formula editor when selected to connect with the latest input metering data type information. Therefore, after the metering data type information of the "cement mill system power consumption" is generated in the formula editor, the user can select the symbol "/" in the operator and select the metering terminal for counting the "yield" index corresponding to the "cement mill system" management unit again, so that the complete calculation formula of the "cement mill system power consumption/cement mill system yield" is displayed in the formula editor. The displayed content is the information input by the user in the formula editor, namely the index calculation formula of the self-defined target index.

By storing the information input in the formula editor, a complete calculation formula of the statistical target index can be obtained.

In the embodiment of the application, the user can directly select the required information in the page to be used for generating the calculation formula by displaying the visual index selection page.

In one possible implementation manner of the embodiment of the present application, before generating the index calculation formula, the data processing system may further verify that the information input into the formula editor is correct, that is, verify that the index calculation formula is correct. The verification may include verifying whether redundant operators are stored in the formula, whether various parameters constituting the formula are reasonable, and the like. For index calculation formulas passing verification, the data processing system can also store the index calculation formulas and display the index calculation formulas in a visual index selection page.

In yet another possible implementation of an embodiment of the present application, the stored metrics may be part of the new metrics. Therefore, when the user generates a calculation formula of the target index using the formula editor, the user can select a certain stored index from the visual index selection page. When the data processing system receives an instruction for selecting a certain index stored in the visual index selection page, the index calculation formula corresponding to the stored changed index can be used as a component part of the index calculation formula of the new target index to be counted and input into the formula editor. Then, the user can continue to select operators and metering data type information corresponding to other metering terminals on the basis. In this way, the data processing system may generate a new index calculation formula of the target index based on the index calculation formula corresponding to the selected stored index, the metering data type information corresponding to the other metering terminals, and the corresponding operators.

The generated index calculation formula is utilized to generate a new index calculation formula, so that the formula configuration difficulty can be reduced, and the formula configuration efficiency can be improved.

S103, acquiring a plurality of metering data contained in the index calculation formula according to the acquisition time information, and calculating by adopting the index calculation formula to obtain the target index.

The data processing system may utilize the corresponding index calculation formula to calculate the target index based on the formula.

In one possible implementation of the embodiment of the present application, in order to count the target index, the required data may be first extracted from the collected metering data. And then, calculating by combining a calculation formula and data, thereby obtaining the target index.

When acquiring the required metering data, the data processing system can extract the required data from the acquired metering data by taking the acquisition time information as a reference. In particular, the data processing system may determine a statistical time of the target indicator. For any one of the measurement data contained in the index calculation formula, the data processing system can acquire a data value of which the acquisition time information is matched with the statistical time. The matching of the collection time information with the statistical time may include that the time corresponding to the collection time information is the same as the statistical time, or that the time corresponding to the collection time information belongs to the same time range as the statistical time.

Thus, when the target index is obtained by calculation by adopting the index calculation formula, the data processing system can carry out mathematical calculation by adopting the data value of the matched metering data and the corresponding operator to obtain the target index.

S104, configuring the display content of the target index and displaying the display content through a display terminal.

After the target index is calculated, the data processing system can be configured based on the target index, and the configured content is the display content required to be displayed to the user. The display content can be displayed through the display terminal. Such as a data sign, a data center interface, etc.

In a possible implementation manner of the embodiment of the present application, as shown in fig. 2, 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 to S1044:

s1041, determining a display mode of the target index.

In the embodiment of the application, the display mode of the target index can comprise a table, a trend graph, a pie chart, a map, a scatter diagram, an index card and the like. The user can select a proper display mode according to the type of the target index and the actual requirement.

S1042, displaying the target index in a preview interface according to the display mode, wherein the preview interface is provided with a display component, the display component comprises a graphic component and a data component, and the graphic component and the data component can be added into the preview interface in a dragging mode.

In the embodiment of the application, a preview interface can be provided in an operation interface of the data processing system after a display mode is selected by a user, and the preview interface can be used for displaying target indexes according to the display mode selected by the user. In addition, various display components, such as graphical components, data components, and the like, may be provided in the preview interface. Wherein the graphical component may be used to adjust or modify the corresponding image of the target indicator displayed in the selected display mode. The graph used for marking each data point in the line graph can be modified from a circle to a diamond by a marking component in the graph component, or a line component can be included in the graph component, and the thickness of the line in the line graph can be adjusted by the modification of the line component. The data component can be used for comparing and displaying different data in the target index.

In the embodiment of the application, the graphic component and the data component can be added into the preview interface in a dragging mode for a user to view the display content finally configured in the preview interface.

S1043, combining the target index displayed according to the display mode with the added graphic component and/or the data component to generate the display content.

And S1044, sending the display content to a display terminal for display.

After the user adjusts the displayed target metrics with the graphical component and/or the data component, the data processing system may generate display content based on the final combined target metrics and the added graphical component and/or data component. After the display content is saved, the data processing system can send the display content to the display terminal for display.

In one possible implementation manner of the embodiment of the present application, the configuration of the display content may be only operated once, and as the metering terminal continuously collects new metering data, the data processing system may update the target index with the newly collected metering data. The updated target index can be displayed on the display terminal according to the configured display content.

In the embodiment of the application, the data processing system can receive the index calculation formula for counting the target index input by the user by storing the metering data acquired by each metering terminal. In this way, the data processing system can acquire a plurality of metering data contained in the index calculation formula according to the acquisition time information of the metering data, and calculate by adopting the index calculation formula to obtain the target index. After the display content of the target index is configured, the data processing system can display the display content through the display terminal. By applying the method provided by the embodiment of the application, a user can configure the calculation formula of each index in a self-defined way, the problem that the adjustment or expansion of the system function can be realized only by modifying the system code in the prior art is solved, and the requirement of rapid change of the service is met.

It should be noted that, the sequence number of each step in the above embodiment does not mean the sequence of execution sequence, and the execution sequence of each process should be determined by its function and internal logic, and should not limit the implementation process of the embodiment of the present application in any way.

For easy understanding, the data processing method provided by the embodiment of the present application is described below with reference to specific examples. The method can be applied to the data processing device shown in fig. 3, and the device can specifically comprise components or units such as management unit modeling, index system modeling, calculation model verification, an arithmetic unit, a processor, a memory, a configuration tool, a data display terminal and the like. The function of each component or unit and the role played in the implementation of the data processing method of the embodiment of the present application are described in detail below.

Example one:

And modeling an index system, wherein the index is a standard for measuring whether parameters of various projects of enterprise production reach standards, and establishing an index assessment system is quite important for enterprise production efficiency, product quality, cost accounting and performance assessment. The enterprise can establish the related indexes in the data processing system according to the self business requirement, and the method provided by the embodiment of the application can support multi-level indexes and flexible setting of a calculation mode, thereby being beneficial to the establishment of a perfect index assessment system for the enterprise.

Management unit modeling, the management unit is an object of enterprise data modeling, assessment and management, such as all production areas of a factory in the manufacturing industry, for example, departments, workshops, procedures, production lines, equipment and even the factory itself can be regarded as the management unit. For any enterprise, the required management units can be built first, after the establishment is completed, the father-child level model between the management units can be built by directly referring to other management units as father-child levels, and the rapid establishment of the association relation between all the management units and each unit is realized. The hierarchical model constructed as described above may be stored in a database. The management unit establishes association between the management unit and the index through a formula editor, forms calculation parameters, configures a required calculation model by combining various operators and business requirements of enterprises, and realizes automatic calculation of index data of the management unit by taking the original data as elements. The calculation model may include an index calculation formula.

In the embodiment of the application, all models can be quickly constructed through a visual interface. Taking the cement industry as an example, if the power consumption of a unit product of a certain cement grinding system and equipment of a main grinding motor of the system is to be checked, because the index calculation formula is ' power consumption/output ', two indexes of ' power consumption ' and ' output ' can be firstly built in an index system, secondly, a management unit of a ' cement grinding system ' and a management unit of a main grinding motor ' is built in a management unit modeling module, and an upper management unit of the main grinding motor is set as a ' cement grinding system ', namely, the building of a related management unit and the index system is completed, related data and upper-lower association relations can be automatically stored in a data table, and when the index system needs to be used, the associated data can be automatically displayed in a system interface, so that the user can use the index system conveniently.

And (3) model checking and operation, namely establishing a calculation model after completing configuration of the management unit, referencing required indexes in a visual interface, referencing data calculation points or other management units to carry out formula configuration, automatically verifying a calling checking module according to built-in checking rules after the system is confirmed, returning a result to the front end if the result does not meet the requirements, reminding an operator to revise the result in a popup window mode, and calling a memory to store the configured calculation model in a page.

The data processing system comprises an arithmetic unit, the arithmetic unit can automatically analyze the established calculation model according to the set value of the granularity of the operation time in the memory, and call the data source to calculate the final result, namely the target index, according to each parameter and operator in the calculation model.

For example, when the index of "energy consumption of unit product of cement mill system" needs to be calculated, the user can select the index of "management unit of cement mill system" and "power consumption" in the configuration interface, the formula editor will automatically generate the parameter of "power consumption of cement mill system", then select the "/" symbol in the operator, select the index of "management unit of cement mill system" and "yield" again, and the complete calculation model of "power consumption of cement mill system/yield of cement mill system" will be displayed in the formula editor. When the calculation model is stored, the system automatically checks whether the model is correct, whether redundant operators exist or not, whether parameter composition is reasonable, and the like. And if the model is correct, calling a storage module to store the model into a database after the model is finished. When the arithmetic unit detects that the current time is the same as the set time granularity, the corresponding module is automatically called to calculate the result and then stored.

And after the index calculation is completed, the configuration tool and the data display terminal can display related data in a display in various modes according to the service requirements of users when the users have the requirements. The data processing system in the embodiment of the application can provide a plurality of custom configuration tools, support enterprises to automatically complete the layout, editing, data extraction and other works of display contents according to own business requirements, realize flexible display of data without programming, and meet diversified requirements of clients. Illustratively, the configuration tool in FIG. 3 may be used for rights control, page layout, and parameter configuration.

In the embodiment of the application, the data display terminal can comprise a zero code large screen editing tool and a large screen display module.

The zero code large screen editing tool can be used for facing enterprise users, realizing self-service and zero code visual large screen configuration, providing chart components such as tables, trend graphs, pie charts, maps, scatter diagrams, index cards and the like required by large screen configuration, realizing free configuration of graphic element data through free combination of screening management units, indexes and time, and realizing quick and efficient configuration of the large screen by means of dragging by the graphic components and data components.

For example, three items of a month electricity consumption data label of an E2 workshop of a certain enterprise, a daily output trend graph of the month and a daily unit product electricity consumption histogram comparison graph of the month are displayed in a large screen. When a user selects to newly build a large screen file, the system firstly detects the role of the user, and establishes an association relation between the role and the built large screen through a data table. When other users access, the platform automatically performs matching, if the roles are different, the large screen cannot be accessed, and access permission control is realized. After the large screen file is established, the system can start to configure large screen display content, when a user increases a display control, the system can automatically generate a block, an editing page is called and popped up at the front end when the block is edited, and unique identification can be generated by recording parameters such as a title (E2 workshop power consumption), a model type, a data name (E2 workshop), an index (power consumption), a time type (month) and the like selected or input by the user, and the information can be stored in a database. Meanwhile, the background starts to analyze the stored data, matches the data name (namely the management unit), the index and the time type, automatically searches the corresponding numerical value from the data table, renders the front-end display control according to the model type, and displays the result in the picture. And if the model type is a data label, displaying numbers, if the model type is a trend graph, displaying daily yield trend lines, and if the model type is a histogram comparison graph, displaying a histogram of daily unit consumption in the month. The front-end component supports the user to adjust any position, size and shape of each block so as to meet the use requirement with more flexible layout and good experience.

And the large screen display module is used for the system to verify whether the user has the access right of the relevant large screen. If yes, analyzing parameters configured by all blocks in the large screen one by one, calling related data from a database and displaying the related data on a page according to the model type.

In addition, the data display terminal can also pass through a zero code report tool. The zero-code report tool can quickly generate a visual report required by a user in a chart combination mode based on the free combination of query conditions of various dimensions such as a management unit, an index, a team, a product, time and the like, various data presentation modes such as trend, structure, comparison and the like, and the user can store the frequently used reports in a classified manner according to the requirements of the use scene for quick query. The report tool builds a data analysis model based on the index model, can deeply encapsulate report generation logic, and enables a user to quickly customize a personalized report without any coding, thereby meeting the data statistics and analysis requirements.

The report tool in the embodiment of the application mainly comprises three parts of report inquiry, custom storage and quick inquiry.

Taking a power consumption report of a PVC production line as an example, matching the power consumption report with a management unit, a power consumption index, time and the like of the PVC production line in a data table according to query conditions input by a user at the front end, forming a title by the management unit, the index and the time in a text splicing mode, finding out a corresponding data table according to a time type, filling data in a report control in a page, calling a chart control to bind related data with the control, and displaying the data in the page in a form+graph mode to finish data display. When the user needs to save the display result for the future quick query, the system can correlate the currently selected various query parameters with the report names input by the user and form a complete report query condition record, and save the complete report query condition record into the data table to realize the saving function of the report. When a user inquires quickly, the background can search relevant parameters in the condition record from the database according to the report name by clicking the report name, and the user does not need to perform excessive operations to search relevant data directly through the parameters, and the relevant parameters are automatically bound and presented on the form control and the chart control of the page, so that the quick inquiry of the saved report data is realized.

The data processing device and the data processing method provided by the embodiment of the application can be applied to the fields of manufacturing industry, internet and the like, and can be used for quickly realizing big data modeling by using a zero code tool so as to construct an enterprise data visualization platform. In an informatization management system of various enterprises such as manufacturing industry, various data such as enterprise production, energy consumption, equipment, technology, environmental protection and the like are collected through networking, calculation model automatic statistical results established according to a user-defined index system through a modeling tool are transferred to a data table according to different time granularities, when a user sets corresponding display content through a visualization tool, the system can acquire related data from the data table according to the configured content, and the related data is displayed in a terminal interface through a quoted front-end control (such as a text label, a trend chart, a structure chart, a table and the like), so that the purposes of quickly generating various visualization platforms such as a digital billboard, a management cockpit, a production report and the like according to different service definitions are achieved, the demands of enterprises on statistics, monitoring, analysis and mining of the whole production process data are met, and the enterprises are achieved.

Example two:

In energy management application software and other management application software based on internet of things collection, enterprises realize the calculation of management indexes such as production, energy efficiency and the like by collecting data of metering terminal equipment such as ammeter, pulverized coal scale and material scale through the internet, and further realize the fine management of management units such as production equipment, working procedures, workshops and whole factories. According to the method and the device provided by the embodiment of the application, the modeling authority of the metering terminal and the management unit is opened to the business personnel of the enterprise through the visual software interface, and the dynamic, visual and rapid modeling of the management index is realized on the premise of not depending on the programming personnel.

The management index is a quantifiable index used for counting and analyzing the performance of related business of an enterprise in a system, and comprises a basic index and a KPI index, wherein the basic index is used for measuring the data condition of a certain single business unit of the enterprise, such as daily electricity consumption, raw coal consumption and diesel consumption of the enterprise, and can be collected through a single metering terminal, such as a smart meter and a coal powder scale, while the KPI index is a composite index capable of measuring the performance level of a certain business field of the enterprise, such as the KPI index of the energy efficiency of a certain cement enterprise, such as 'ton cement comprehensive energy consumption = clinker comprehensive coal consumption (clinker consumption/cement yield) +cement comprehensive electricity consumption 0.1229 +fuel conversion standard coal consumption consumed by a baked cement mixture', and the index synthesizes basic index data, such as comprehensive coal consumption, yield, comprehensive electricity consumption, fuel consumption and the like, and can be used for measuring the comprehensive energy efficiency level of a certain cement enterprise to produce a certain cement.

The management index can be decomposed into two levels of indexes such as electricity consumption, coal consumption, diesel consumption and the like according to business requirements, and the indexes such as production indexes, energy consumption indexes, sales indexes, financial indexes and the like can be classified according to business attribution.

The management index modeling is used for receiving enterprise management index models which are customized by a user through a visual interface, such as index types, numbers, names, superior indexes, index actions, statistical periods and the like, and the models are solidified through a memory, so that selection and basis are provided for subsequent metering terminal modeling and management unit modeling. If the electricity consumption and the comprehensive energy consumption of a certain process are counted, the electricity consumption and the comprehensive energy consumption are used as management indexes to be modeled through the step.

And modeling a metering terminal, wherein the metering terminal is terminal metering equipment capable of collecting basic index data in a system through networking, such as a smart meter, a raw material scale, a flowmeter, a sensor and the like, and the metering terminal is a basic index data carrier. The system realizes real-time online acquisition of the data of the metering terminal through the IOT internet of things component, calculates the difference value in the counting period of the metering point according to the hour, day, month and year time dimension, such as electricity consumption of an ammeter and the like, and provides a basic data source for index modeling of the management unit through online modeling of the metering terminal.

The system receives a metering terminal model customized by a user through metering terminal modeling, and the metering terminal model comprises information such as acquisition point position numbers, terminal names, acquisition indexes, installation positions, verification periods and the like, and transfers the metering terminal model to a memory for solidification. The user-defined model of a certain ammeter is [ point location number: CFK00_02A.04, terminal name: broken electric room ammeter, collection index: electricity consumption, installation position: broken electric room, check period: 30 days ]

Management unit definition and formula modeling the management unit system is used as an object of enterprise data modeling, analysis and assessment, such as a company, a workshop, a production line, a process or a device. By online definition of management unit entities, enterprises can realize visual modeling of management and control objects according to management needs.

The management unit modeling comprises a solid model and a statistical model:

the entity model is a user-defined modeling of the entity of the management unit and comprises a management unit name, a type, an upper management unit, a description and the like, for example, the model of a certain cement mill of a certain cement enterprise is shown as a management unit name 1# cement mill, a type 1# cement mill, a production host, an upper management unit and a cement procedure, and the description is shown as a process from a clinker bottom clinker discharging, conveying, cement grinding system to a cement conveying warehouse, and discharging, crushing and conveying of auxiliary materials including fly ash, gypsum and the like.

After receiving the determination of the entity model of the management unit, a user can define the statistical model of the management unit through a system visual interface, when the statistical model is configured, the system invokes the management index and the metering terminal model which are completely defined in the memory through the processor, the user selects the index model required by the current configuration management unit through the visual interface provided by the system, selects the corresponding metering terminal from the metering terminal models according to the actual calculation requirement, and the definition of the statistical model of the management unit can be completed by combining calculation logic.

If the electricity consumption calculation formula of A1 # cement mill in a certain cement factory is ' rolling machine room + grinding machine room + HR5AH mill + a105 fixed roll + a106 movable roll + laboratory [ office building ] + public lighting-material warehouse top induced draft fan-HR 9#10# bulk-screw air compressor + screw air compressor:. 0.5 ', when the electricity consumption statistical model of the management unit is configured, the 1# cement mill is a management unit entity needing to be configured, the electricity consumption is a management index model needing to be configured, and in the statistical model of the management unit, the rolling machine room ', ' mill room ', ' HR5AH mill ' and the like are metering terminal models for bearing collected data.

The management unit can perform hierarchical modeling according to the managed level, and if a certain factory 1# cement process comprises 1# and 2# cement mills, the 1# and 2# cement mills can be defined as sub-level management units of the 1# cement process. The system not only builds the statistical model of the management unit by calling the metering terminal, but also supports the statistical model of the sub-level management unit defined in the scheduling memory of the processor, and the rapid building of the statistical model of the management unit is realized. The power consumption index of the 1# cement process may be configured as 1# cement mill power consumption+2 # cement mill power consumption, and the yield index of the 1# cement process may be configured as 1# cement mill yield+2 # cement mill yield.

Through visual modeling and free combination of management indexes, metering terminals and management units, user-defined configuration of the complex statistical model can be completed through a visual interface. The energy efficiency index of a cement plant is that' ton cement comprehensive power consumption= ((in-plant limestone conveying section power consumption (collection)/limestone crushing limestone output or purchasing quantity is the raw material grinding limestone consumption quantity + raw material process power consumption quantity (collection)/raw material grinding raw material output or purchasing quantity is the rotary kiln raw material consumption quantity + clinker process power consumption quantity (collection))/rotary kiln clinker output or purchasing quantity is the cement grinding clinker consumption quantity + packaging process power consumption quantity (collection) +gypsum, mixed material in-plant section power consumption quantity (collection) +cement process power consumption quantity (collection))/(cement grinding P.O.5 output or purchasing quantity + cement grinding P.C.42.5 output or purchasing quantity + M.32.5 output or purchasing quantity + P.P.32.5 output or purchasing quantity + P.R.7.5 output or purchasing quantity) ". All the components participating in the operation in the formula are the combination of a metering terminal, a management unit, a management index model and an operator. A user can define, adjust and expand a statistical model at any time according to service requirements through a visual interface without changing the visual interface, so that visual modeling of the zero code is realized.

The system comprises a management unit model, an identification verification module, a processor and a memory storage model, wherein the management unit model is configured, the verification module is used for carrying out formula verification on the data statistics model of the management unit, a verification rule comprises that operators are needed to be contained between two metering terminal models, the two operators cannot be directly connected, if the rule verification fails, the system does not store the current statistics model and reminds a user to correct through a visual interface, and if the rule verification is successful, the processor is used for automatically converting the name of the metering terminal in the statistics model into a unique identification of the metering terminal and then delivering the unique identification to the memory storage model.

The processor can count the index data of the management unit according to the operation rule of the statistic model, and the final counted index data of the management unit is stored through the memory.

And the data display module is used for obtaining index data of the management unit through the processor scheduling memory after the management unit is modeled, so as to realize a statistical report and data analysis function.

Referring to fig. 4, a schematic diagram of another data processing apparatus provided by an embodiment of the present application may specifically include a storage module 401, a receiving module 402, a calculating module 403, and a display module 404, where:

The storage module 401 is configured to store metering data acquired by each metering terminal, where any metering data has acquisition time information;

A receiving module 402, configured to receive an input index calculation formula for counting target indexes, where the index calculation formula is composed of a plurality of metering data and corresponding operators;

The calculation module 403 is configured to obtain a plurality of measurement data included in the index calculation formula according to the acquisition time information, and calculate by using the index calculation formula to obtain the target index;

And the display module 404 is used for configuring the display content of the target index and displaying the display content through a display terminal.

In one possible implementation manner of the embodiment of the present application, the storage module 401 may specifically be used for:

The method comprises the steps of determining identification information of each metering terminal, establishing a data table for each metering terminal based on the identification information, and correspondingly storing metering data and acquisition time information into the data table with the same identification information as the metering terminals when receiving metering data acquired by any metering terminal, wherein the metering data are original data acquired by the metering terminals.

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

The method comprises the steps of determining a plurality of management units and an upper management unit or a lower management unit associated with each management unit, wherein any management unit corresponds to one entity object, generating a layering model according to each management unit and the upper management unit or the lower management unit associated with each management unit, determining metering terminals corresponding to each management unit in the layering model, and storing each metering terminal and each management unit in the layering model in an associated mode to form a visual index selection page.

In one possible implementation manner of the embodiment of the present application, the receiving module 402 may specifically be configured to:

When receiving an instruction of selecting any metering terminal in the visual index selection page, inputting metering data type information corresponding to the metering terminal into a formula editor, wherein the formula editor also comprises a plurality of operators, any operator is used for being input into the formula editor when being selected so as to be connected with the latest input metering data type information, and storing the information input in the formula editor, wherein the information is a customized index calculation formula of the target index.

In a possible implementation manner of the embodiment of the present application, the visual index selection page further includes a stored index, and the receiving module 402 is further configured to:

when an instruction for selecting the stored index in the visual index selection page is received, the stored index calculation formula corresponding to the index is used as a component part of an index calculation formula of a target index to be counted and is input into the formula editor, and the index calculation formula of the target index is generated based on the selected stored index calculation formula corresponding to the index, metering data type information corresponding to other metering terminals and corresponding operators.

In one possible implementation manner of the embodiment of the present application, the calculating module 403 may specifically be configured to:

The method comprises the steps of determining the statistical time of a target index, acquiring a data value of which acquisition time information is matched with the statistical time for any piece of metering data contained in an index calculation formula, wherein the matching of the acquisition time information with the statistical time comprises that the time corresponding to the acquisition time information is identical to the statistical time or the time range of the time corresponding to the acquisition time information is identical to the statistical time, and carrying out mathematical calculation by adopting the matched data value of the metering data and a corresponding operator to obtain the target index.

In one possible implementation manner of the embodiment of the present application, the display module 404 may specifically be used for:

The method comprises the steps of determining a display mode of target indexes, displaying the target indexes in a preview interface according to the display mode, wherein the preview interface is provided with a display component, the display component comprises a graphic component and a data component, the graphic component and the data component can be added into the preview interface in a dragging mode, combining the target indexes displayed according to the display mode with the added graphic component and/or the data component to generate display content, and sending the display content to a display terminal for display.

The data processing device provided by the embodiment of the application can realize the steps in the method embodiments.

For the device embodiments, since they are substantially similar to the method embodiments, the description is relatively simple, and reference should be made to the description of the method embodiments.

As shown in fig. 5, an embodiment of the present application provides a data processing system that may include a plurality of metering terminals, such as metering terminal 1, metering terminal 2, metering terminal n, etc., in fig. 5, as well as a data processing terminal and a display terminal. The data processing terminal may be used to implement the functions of each step in the foregoing method embodiments, that is, receive the measurement data collected by each measurement terminal and perform analysis processing in combination with a user-defined index calculation formula or model, and display the finally formed display content to the user through the display terminal. The relevant functions of the data processing system may be referred to the description of the foregoing embodiments, and will not be repeated here.

Referring to fig. 6, a schematic diagram of a data processing terminal according to an embodiment of the present application is shown. As shown in fig. 6, 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. The processor 610, when executing the computer program 621, implements the steps of the respective embodiments of the data processing method described above, such as steps S101 to S104 shown in fig. 1. Or the processor 610, when executing the computer program 621, performs the functions of the modules/units in the above-described device embodiments, such as the functions of the modules 401 to 404 shown in fig. 4.

Illustratively, the computer program 621 may be partitioned into one or more modules/units that are stored in the memory 620 and executed by the processor 610 to accomplish the present application. The one or more modules/units may be a series of computer program instruction segments capable of performing particular functions, which may be used to describe the execution 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 calculating module, and a display module, each of which specifically functions as follows:

The data processing terminal 600 may be a terminal and a device capable of implementing each of the foregoing method embodiments. By way of example, the data processing terminal 600 may be a desktop computer, cloud server, or the like. The data processing terminal 600 may include, but is not limited to, a processor 610, a memory 620. It will be appreciated by those skilled in the art that fig. 6 is only one example of a data processing terminal 600 and does not constitute a limitation of the data processing terminal 600, and may include more or less components than those illustrated, or may combine certain components, or different components, e.g., the data processing terminal 600 may also include input and output devices, network access devices, buses, etc.

The Processor 610 may be a central processing unit (Central Processing Unit, CPU), but may also be other general purpose processors, digital signal processors (DIGITAL SIGNAL Processor, DSP), application SPECIFIC INTEGRATED Circuit (ASIC), off-the-shelf Programmable gate array (Field-Programmable GATE ARRAY, FPGA) or other Programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or the like. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.

The memory 620 may be an internal storage unit of the data processing terminal 600, for example, a hard disk or a 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 memory card (SMART MEDIA CARD, SMC), a Secure Digital (SD) card, a flash memory card (FLASH CARD) or the like, which are provided on the data processing terminal 600. Further, the memory 620 may also include both an internal storage unit and an external storage device of the data processing terminal 600. The memory 620 is used to store the computer program 621 and other programs and data required for 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.

The embodiment of the application also discloses a data processing terminal which comprises a memory, a processor and a computer program stored in the memory and capable of running on the processor, wherein the processor realizes the data processing method in the previous embodiments when executing the computer program.

The embodiments of the present application also disclose a computer readable storage medium storing a computer program which, when executed by a processor, implements the data processing method described in the foregoing embodiments.

The embodiment of the application also discloses a computer program product which enables a computer to execute the data processing method described in the previous embodiments when the computer program product runs on the computer.

The above embodiments are only for illustrating the technical solution of the present application, and are not limited thereto. Although the present application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications and substitutions can be made to the technical solutions described in the foregoing embodiments or equivalent substitutions can be made to some technical features thereof, and these modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present application.

Claims

1. A method of data processing, comprising:

determining a plurality of management units and a superior management unit or a subordinate management unit associated with each management unit, wherein any management unit corresponds to one entity object;

Generating a layering model according to each management unit and the associated upper management unit or lower management unit thereof;

determining a metering terminal corresponding to each management unit in the hierarchical model;

storing each metering terminal and each management unit in the layered model in an associated manner to form a visual index selection page;

Determining identification information of each metering terminal, and respectively establishing a data table for each metering terminal based on the identification information;

When metering data acquired by any metering terminal is received, correspondingly storing the metering data and the acquisition time information into a data table with the same identification information as the metering terminal, wherein any metering data has the acquisition time information, and the metering data is original data acquired by the metering terminal;

Displaying the visual index selection page, wherein the visual index selection page also comprises stored indexes which can be used as components of new indexes;

When an instruction for selecting any metering terminal in the visual index selection page is received, metering data type information corresponding to the metering terminal is input into a formula editor, the formula editor further comprises a plurality of operators, and any operator is used for being input into the formula editor when being selected so as to connect with the latest input metering data type information;

storing the information input in the formula editor, wherein the information is an index calculation formula of a self-defined target index, and the index calculation formula consists of a plurality of metering data and corresponding operators;

2. The method of claim 1, wherein receiving the input index calculation formula for counting target indexes, further comprises:

When an instruction for selecting the stored index in the visual index selection page is received, the stored index calculation formula corresponding to the index is used as a component part of an index calculation formula of the target index to be counted and is input into the formula editor;

And generating an index calculation formula of the target index based on the selected stored index calculation formula corresponding to the index, metering data type information corresponding to other metering terminals and corresponding operators.

3. The method according to claim 1 or 2, wherein the acquiring a plurality of metering data included in the index calculation formula according to the acquisition time information includes:

determining the statistical time of the target index;

For any metering data contained in the index calculation formula, acquiring a data value of which the acquisition time information is matched with the statistical time, wherein the acquisition time information is matched with the statistical time, and the time corresponding to the acquisition time information is identical to the statistical time, or the time range to which the time corresponding to the acquisition time information belongs is identical to the statistical time;

Correspondingly, the calculating by adopting the index calculation formula to obtain the target index comprises the following steps:

And carrying out mathematical calculation by adopting the matched data value of the metering data and the corresponding operator to obtain the target index.

4. A method according to claim 3, wherein configuring the display content of the target indicator and displaying the display content through a display terminal comprises:

determining a display mode of the target index;

Displaying the target index in a preview interface according to the display mode, wherein the preview interface is provided with a display component, the display component comprises a graphic component and a data component, and the graphic component and the data component can be added into the preview interface in a dragging mode;

Combining the target index displayed according to the display mode with the added graphic component and/or the data component to generate the display content;

And sending the display content to a display terminal for display.

5. A data processing apparatus, comprising:

The display module is used for configuring the display content of the target index and displaying the display content through the display terminal;

the storage module is specifically configured to:

When receiving metering data collected by any metering terminal, correspondingly storing the metering data and the collecting time information into a data table with the same identification information as the metering terminal, wherein the metering data is original data collected by the metering terminal;

the device further comprises a configuration unit, wherein the configuration unit is specifically used for:

Determining a plurality of management units and an upper management unit or a lower management unit associated with each management unit, wherein any management unit corresponds to one entity object, generating a layering model according to each management unit and the upper management unit or the lower management unit associated with each management unit, determining metering terminals corresponding to each management unit in the layering model, and storing each metering terminal and each management unit in the layering model in an associated manner to form a visual index selection page;

the receiving module is specifically configured to:

When receiving an instruction of selecting any metering terminal in the visual index selection page, inputting metering data type information corresponding to the metering terminal into a formula editor, wherein the formula editor also comprises a plurality of operators, any operator is used for being input into the formula editor when being selected so as to be connected with the latest input metering data type information, the information input in the formula editor is saved, the information is a customized index calculation formula of the target index, the visual index selection page also comprises stored indexes, and the stored indexes can be used as components of new indexes.

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, the data processing terminal comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the processor implements the data processing method according to any one of claims 1-4 when executing the computer program.

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