Real-time index calculation method and device based on low code configuration, equipment and medium

Through the real-time indicator calculation method of low-code configuration, the calculation engine platform is used to analyze indicator formulas and metadata configuration tables, which solves the problem of over-reliance on code in indicator calculation, realizes rapid configuration and debugging of indicators, improves work efficiency and clear logic sex.

CN119045870APending Publication Date: 2024-11-29TOGEEK
View PDF 0 Cites 1 Cited by

Patent Information

Application Number
CN202411269603.1
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-09-11
Publication Date
2024-11-29

AI Technical Summary

Technical Problem

The existing technology over-reliance on code in indicator calculations leads to unclear processing logic and difficulty in operation and debugging, and the rapid configuration and hot addition and deletion of large batches of indicators are not possible. The calculation logic is hidden in the code and is difficult to view intuitively.

Method used

Using a real-time indicator calculation method based on low-code configuration, the metadata configuration table is read through the computing engine platform, and the target indicator is judged as the original data or calculation data, and targeted analysis and processing are carried out through the metadata configuration table and the computing engine platform to realize online Real-time editing and modification, reducing dependence on code, and improving operation and debugging ease.

Benefits of technology

It realizes rapid configuration and debugging of indicator calculations, reduces operational difficulty, improves work efficiency, and has clear logic. Non-program developers can also quickly locate problems and shorten the troubleshooting time.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119045870A_ABST
    Figure CN119045870A_ABST
Patent Text Reader

Abstract

The invention provides a real-time index calculation method and device based on low code configuration, equipment and a medium, and relates to the field of data analysis, and the method comprises the steps: obtaining a plurality of to-be-calculated target indexes, and determining the time dimensions of the target indexes; reading the metadata configuration table through a calculation engine platform, and judging whether the target index is original data or calculation data; under the condition that the target index is original data, reading corresponding data from an original database; under the condition that the target index is calculation data, analyzing an index formula through a calculation engine platform, and determining reference index information; and calling data from the data input port through the calculation engine platform, and performing index calculation to generate an index calculation result corresponding to the target index. By setting the metadata configuration table and the calculation engine platform, online real-time editing and modification can be realized, only the reliability and stability of the calculation engine need to be concerned, the dependence degree on codes is low, the processing logic is clear, and the operation and debugging are simple and convenient.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present application relates to the field of data analysis technology, and specifically to a real-time indicator calculation method, device, equipment and medium based on low-code configuration. Background Art

[0002] In the information systems of production enterprises, such as indicator calculation and statistical reports, a large amount of indicator calculation and statistical work will be involved. The indicator data sources include the working parameters uploaded by the production equipment sensors, the data generated by other business systems, the data entered and imported by users, etc. The calculation logic will include basic arithmetic calculations, judgment selection and statistical summary, etc.

[0003] In the related technology, in the process of indicator calculation, it is necessary to first confirm the business calculation logic of each indicator, and then directly use code to implement it once in a fixed way in the calculation program; the calculation logic code is written for each indicator separately, and the runtime is divided into the steps of reading the original data, calculation process, generating calculation code, and saving results.

[0004] The current technical solution has the following disadvantages: (1) It is impossible to quickly configure a large number of indicators. When the amount of indicator data is large, each indicator needs to be written in the code to implement the calculation logic, which is a large workload and cannot achieve batch and rapid indicator addition and configuration; it is impossible to achieve hot addition, deletion and hot configuration of indicators, and the code must be redeployed; it has high requirements for operators. (2) It is difficult to debug indicators. When the value of an indicator is wrong, it is necessary to debug the code line by line and check the calculation results of each step, which makes debugging difficult. (3) The calculation logic is hidden in the code, which is not intuitive to view. Summary of the invention

[0005] In response to the shortcomings of the prior art, the present application provides a real-time indicator calculation method, device, equipment and medium based on low-code configuration, which solves the problems existing in the current indicator analysis, such as excessive reliance on code, unclear processing logic, and difficult operation and debugging.

[0006] To achieve the above objectives, this application is implemented through the following technical solutions:

[0007] In a first aspect, an embodiment of the present application provides a real-time indicator calculation method based on low-code configuration, the method comprising: obtaining multiple target indicators to be calculated, determining the time dimension of the target indicator, the time dimension being used to characterize the calculation period of the target indicator; reading a constructed metadata configuration table through a preset computing engine platform, classifying the target indicator, and determining whether the target indicator is original data or calculated data; wherein the computing engine platform is capable of sending instructions to a preset data input port to call data from an original database through the data input port; when the target indicator is original data, based on the time period preconfigured in the metadata configuration table, reading data at a corresponding time point from the original database and storing it in a result dictionary table to output from a preset data output port; when the target indicator is calculated data, parsing the indicator formula corresponding to the target indicator through the computing engine platform, determining the reference indicator information corresponding to the target indicator, wherein the reference indicator information includes at least one reference indicator of at least one level; based on the reference indicator information, calling data from the data input port through the computing engine platform, performing indicator calculation to generate an indicator calculation result corresponding to the target indicator, and storing it in the result dictionary table.

[0008] According to the first aspect of the embodiment of the present application, the aforementioned determination whether the target indicator is original data or calculated data may include the following steps: based on the metadata configuration table, querying the indicator formula corresponding to the target indicator; when the indicator formula corresponding to the target indicator is empty, determining that the target indicator is original data; when the indicator formula corresponding to the target indicator is not empty, determining that the target indicator is calculated data.

[0009] According to the first aspect of the embodiment of the present application, the aforementioned analysis of the indicator formula corresponding to the target indicator by the computing engine platform to determine the reference indicator information corresponding to the target indicator may include the following steps: based on the configuration information in the metadata configuration table, the indicator formula corresponding to the target indicator is analyzed by the computing engine platform to obtain the first-level sub-data corresponding to the target indicator; data interaction is performed with the original database through the computing engine platform and the data input port to determine whether there is first-level sub-data in the original database; in the case that the original database does not have first-level sub-data, the first-level sub-data is analyzed by the computing engine platform to determine the subordinate target data corresponding to the first-level sub-data; iteratively executes the parsing query job to determine whether there is subordinate target data corresponding to the first-level sub-data in the original database, until the numerical value corresponding to each subordinate target data is obtained; wherein the first-level sub-data and the subordinate target data are reference indicators.

[0010] According to the first aspect of the embodiment of the present application, the aforementioned method of calling data from the data input port through the computing engine platform based on the reference indicator information, performing indicator calculation to generate an indicator calculation result corresponding to the target indicator, and storing it in the result dictionary table, may include the following steps: based on the time period pre-configured in the metadata configuration table, calling the data in the original database from the data input port through the computing engine platform to obtain the first-level sub-data involved in the calculation; in the case where there is no corresponding subordinate target data for the first-level sub-data, performing indicator calculation based on the first-level sub-data to obtain the indicator calculation result; in the case where there is corresponding subordinate target data for the first-level sub-data, recursively parsing the first-level sub-data through the computing engine platform until all the subordinate target data are obtained from the original database; integrating the first-level sub-data and the subordinate target data and aligning the time axis, performing indicator calculation through the computing engine platform to obtain the indicator calculation result.

[0011] According to the first aspect of the embodiment of the present application, after the aforementioned calling of data from the data input port through the computing engine platform based on the reference indicator information, performing indicator calculation to generate indicator calculation results corresponding to the target indicator, and storing them in the result dictionary table, the real-time indicator calculation method based on low-code configuration may also include the following steps: based on the storage address in the metadata configuration table, determining the mapping relationship between the indicator calculation results and the preset multiple result databases; based on the mapping relationship, sending the indicator calculation results from the result dictionary table to the corresponding result database through the data output port.

[0012] According to the first aspect of the embodiment of the present application, the configuration information of the metadata configuration table includes an indicator code, an indicator description, an indicator dimension, an indicator formula, a time dimension and a storage address; wherein the indicator formula is used to characterize the calculation logic of the indicator.

[0013] According to the first aspect of the embodiment of the present application, the computing engine platform is used to parse indicator formulas, and the formula types corresponding to the indicator formulas include basic arithmetic operations, statistical summaries and custom functions; custom functions support judgment, jumps and loops; the computing engine platform is provided with a configuration unit for indicator creation and custom configuration of indicator formulas.

[0014] In a second aspect, an embodiment of the present application provides a real-time indicator calculation device based on low-code configuration, the device comprising an acquisition module, a judgment module, a reading module, a parsing module and a calculation module; the acquisition module is used to acquire multiple target indicators to be calculated and determine the time dimension of the target indicator, the time dimension being used to characterize the calculation period of the target indicator; the judgment module is used to read the constructed metadata configuration table through a preset computing engine platform, classify the target indicator, and determine whether the target indicator is original data or calculated data; wherein the computing engine platform is capable of sending instructions to a preset data input port to call data from an original database through the data input port; the reading module is used to read the data at the corresponding time point from the original database based on the time period pre-configured in the metadata configuration table when the target indicator is original data and store it in a result dictionary table to output it from a preset data output port; the parsing module is used to parse the indicator formula corresponding to the target indicator through the computing engine platform when the target indicator is calculated data, and determine the reference indicator information corresponding to the target indicator, wherein the reference indicator information includes at least one reference indicator of at least one level; the calculation module is used to call data from the data input port through the computing engine platform based on the reference indicator information, perform indicator calculation to generate an indicator calculation result corresponding to the target indicator, and store it in the result dictionary table.

[0015] In a third aspect, an embodiment of the present application provides an electronic device comprising: a processor, a memory, and a program stored in the memory and executable on the processor, wherein when the program is executed by the processor, the real-time indicator calculation method based on low-code configuration in the aforementioned first aspect is implemented.

[0016] In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium, which stores a program or instruction. When the program or instruction is executed by a processor, the real-time indicator calculation method based on low-code configuration in the aforementioned first aspect is implemented.

[0017] This application provides a real-time indicator calculation method, device, equipment and medium based on low-code configuration. Compared with the prior art, it has the following beneficial effects:

[0018] In the process of real-time indicator calculation, the present application reads the metadata configuration table for the target indicator to be calculated through the computing engine platform, first determines whether the target indicator is original data or calculated data, and then conducts targeted analysis and processing; in the case where the target indicator is original data, the corresponding data is directly called from the original database through the data input port and stored in the result dictionary table; in the case where the target indicator is calculated data, the corresponding indicator formula is parsed through the computing engine platform to determine the reference indicator information required to calculate the target indicator, and the reference indicator information can be determined from the original database through parsing and querying. By setting up the metadata configuration table and the computing engine platform, the present application can realize online real-time editing and modification, and only needs to pay attention to the reliability and stability of the computing engine, with low dependence on the code, clear processing logic, and simple operation and debugging. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0020] Figure 1 It is a schematic diagram of indicator calculation in the prior art;

[0021] Figure 2 This is a schematic diagram of an indicator calculation provided in an embodiment of the present application;

[0022] Figure 3 It is a flowchart of a real-time indicator calculation method based on low-code configuration provided in an embodiment of the present application;

[0023] Figure 4 yes Figure 3 An exemplary flow chart of S120;

[0024] Figure 5 yes Figure 3 An exemplary flow chart of S140;

[0025] Figure 6 yes Figure 3 An exemplary flow chart of S150;

[0026] Figure 7 It is a structural diagram of a real-time indicator calculation device based on low-code configuration provided in an embodiment of the present application;

[0027] Figure 8 It is a structural schematic diagram of another real-time indicator calculation device based on low-code configuration provided in an embodiment of the present application;

[0028] Fig. 9 It is a structural schematic diagram of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0029] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention are clearly and completely described. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0030] It should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the existence of other identical elements in the process, method, article or device including the elements.

[0031] The embodiments of the present application solve the problems of over-reliance on code, unclear processing logic, and difficult operation and debugging in current indicator analysis by providing a real-time indicator calculation method, device, equipment and medium based on low-code configuration.

[0032] The technical solution in the embodiment of the present application is to solve the above technical problems, and the overall idea is as follows:

[0033] In the information systems of production enterprises, such as indicator calculation and statistical reports, a large amount of indicator calculation and statistical work will be involved. The indicator data sources include the working parameters uploaded by the production equipment sensors, the data generated by other business systems, the data entered and imported by users, etc. The calculation logic will include basic arithmetic calculations, judgment selection and statistical summary, etc.

[0034] Please refer to Figure 1 , Figure 1The indicator calculation method in the prior art is shown. In the prior art, in the process of calculating the indicator, it is necessary to first confirm the business calculation logic of each indicator, and then directly use the code to implement it once in a fixed manner in the calculation program; the calculation logic code is written separately for each indicator, and the operation is divided into steps such as reading original data, calculation process, generating calculation code, and saving results; it is impossible to quickly configure a large number of indicators. When the amount of indicator data is large, each indicator needs to be written in the code to implement the calculation logic, which is a large workload and cannot achieve batch and rapid indicator addition and configuration; it is impossible to achieve hot addition and deletion and hot configuration of indicators, and the code must be redeployed; the requirements for operators are high. Indicator debugging is difficult. When the value of an indicator is wrong, it is necessary to debug the code line by line and check the calculation results of each step, which is difficult to debug; and the calculation logic is hidden in the code, which is not intuitive to view.

[0035] In order to better understand the above technical solution, the above technical solution will be described in detail below in conjunction with the accompanying drawings and specific implementation methods.

[0036] The following first introduces a real-time indicator calculation method based on low-code configuration provided in an embodiment of the present application.

[0037] Please refer to the flowchart of a real-time indicator calculation method based on low-code configuration provided in this application embodiment. Figure 2 and Figure 3 , the real-time indicator calculation method based on low-code configuration may include the following steps S110-S150.

[0038] S110: Acquire multiple target indicators to be calculated, and determine the time dimension of the target indicator, where the time dimension is used to characterize the calculation period of the target indicator.

[0039] S120. Read the constructed metadata configuration table through a preset computing engine platform, classify the target indicators, and determine whether the target indicators are original data or calculated data; wherein the computing engine platform can send instructions to a preset data input port to call data from the original database through the data input port.

[0040] S130: When the target indicator is original data, based on the time period preconfigured in the metadata configuration table, read the data at the corresponding time point from the original database and store it in the result dictionary table to be output from the preset data output port.

[0041] S140. When the target indicator is calculation data, the indicator formula corresponding to the target indicator is parsed by the calculation engine platform to determine the reference indicator information corresponding to the target indicator, wherein the reference indicator information includes at least one reference indicator of at least one level.

[0042] S150. Based on the reference indicator information, call data from the data input port through the calculation engine platform, perform indicator calculation to generate an indicator calculation result corresponding to the target indicator, and store it in the result dictionary table.

[0043] In the embodiment of the present application, it is understandable that the indicator formula is used to characterize the calculation logic of the target indicator, and the calculation logic includes the relationship between the reference indicator and the target indicator. The result dictionary table is used to store the results of each calculation process. For indicators within a calculation cycle, it only needs to be calculated once, without multiple calculations. The data input port provides raw data to the calculation engine platform, which mainly reads the data involved in the calculation from each original database according to the time period configured by the metadata, and integrates the data in multiple original databases, aligns the time axis, and then sends it to the calculation engine platform for calculation. The calculation engine platform can read and scan the metadata configuration table, and according to different time periods, regularly issue instructions to the data input port to prepare the raw data, and then parse each indicator formula and generate the calculation results.

[0044] The above is a specific implementation method of a real-time indicator calculation method based on low-code configuration provided in an embodiment of the present application. For the target indicator to be calculated, the present application reads the preset metadata configuration table through the computing engine platform, and first determines whether the target indicator is original data or calculated data, so as to perform targeted analysis and processing.

[0045] Specifically, when the target indicator is original data, the corresponding data is directly called from the original database through the data input port and stored in the result dictionary table. When the target indicator is calculated data, the corresponding indicator formula is parsed through the calculation engine platform to determine the reference indicator information required to calculate the target indicator. The reference indicator information can be determined from the original database through parsing and query.

[0046] It should be noted that this application can realize online real-time editing and modification by setting the indicator formula and period in the metadata configuration table, which takes effect immediately without adjusting the code; program developers only need to focus on the reliability and stability of the calculation engine, without paying attention to the specific business logic; indicator formula configuration personnel only need to focus on business logic, without paying attention to the internal process of the software, thus achieving efficient cooperation and reasonable division of labor among various personnel and improving work efficiency; the dependence on the code is low, the processing logic is clear, and the operation and debugging are simple.

[0047] It should also be noted that since the calculation logic corresponding to the target indicators can be viewed intuitively in the metadata configuration table, it is simpler than the query code and the indicator reference relationship is clearer. It can greatly reduce the difficulty in troubleshooting and indicator debugging. Non-program developers can also quickly locate the root cause of the problem, shortening the troubleshooting time.

[0048] In some embodiments, the configuration information of the metadata configuration table includes an indicator code, an indicator description, an indicator dimension, an indicator formula, a time dimension, and a storage address; wherein the indicator formula is used to characterize the calculation logic of the indicator.

[0049] In the embodiment of the present application, the metadata configuration table configures the basic information of the indicator. It can be understood that the indicator formula is the calculation logic of the indicator, such as indicator A=B+C*10, where B and C are the reference indicators corresponding to A. The formula is intuitive and easy to understand. The time dimension is the calculation period of the indicator, such as "minutes" means that the indicator is calculated once every minute.

[0050] In some embodiments, the computing engine platform is used to parse indicator formulas. The formula types corresponding to indicator formulas include basic arithmetic operations, statistical summaries, and custom functions; custom functions support judgment, jumps, and loops; the computing engine platform is equipped with a configuration unit to perform custom configuration of indicator creation and indicator formulas. The computing engine platform has the characteristics of low code, easy expansion, rich support for calculation logic, and convenient debugging. Basic arithmetic operations include: addition, subtraction, multiplication, division, and power operations; statistical summaries include: sum, average, maximum, and minimum.

[0051] In the embodiments of the present application, it can be understood that by setting the configuration unit, the present application can conveniently expand indicators, the configuration unit supports batch configuration of indicators, users can freely add indicators in the metadata configuration table, and can configure indicators in batches, and the configuration process has a low degree of dependence on the code.

[0052] In one example, if Figure 4 As shown, the aforementioned determination target indicator is raw data or calculated data, that is, the aforementioned S120 may specifically include the following steps:

[0053] S210. Based on the metadata configuration table, query the indicator formula corresponding to the target indicator.

[0054] S220: When the indicator formula corresponding to the target indicator is empty, determine that the target indicator is original data.

[0055] S230: When the indicator formula corresponding to the target indicator is not empty, determine the target indicator as calculation data.

[0056] In the embodiments of the present application, it can be understood that the original data can be directly obtained from the original database, and the value of the corresponding time point can be directly obtained from the original database according to the address configured in the metadata configuration table; the calculation index needs to be further analyzed and processed by the calculation engine platform according to the index formula set in the metadata configuration table.

[0057] In some embodiments, Figure 5As shown, the aforementioned calculation engine platform analyzes the indicator formula corresponding to the target indicator to determine the reference indicator information corresponding to the target indicator, that is, the aforementioned S140 may specifically include the following steps:

[0058] S310. Based on the configuration information in the metadata configuration table, the indicator formula corresponding to the target indicator is parsed through the calculation engine platform to obtain the first-level sub-data corresponding to the target indicator.

[0059] S320, interacting with the original database through the computing engine platform and the data input port to determine whether the original database has first-level sub-data.

[0060] S330: When the first-level sub-data does not exist in the original database, the first-level sub-data is parsed through the computing engine platform to determine the lower-level target data corresponding to the first-level sub-data.

[0061] S340, iteratively execute the parsing query operation to determine whether there is subordinate target data corresponding to the first-level sub-data in the original database, until the value corresponding to each subordinate target data is obtained; wherein the first-level sub-data and the subordinate target data are reference indicators.

[0062] In the embodiment of the present application, it can be understood that the computing engine platform can scan the metadata configuration table starting from the first indicator. When the target indicator is a calculation point, its indicator formula is disassembled to determine which associated reference indicators are in the formula; for example: A=B+C; A is the target indicator to be calculated, then when the computing engine platform scans A, it can determine that the formula corresponding to A is B+C, B and C are the first-level sub-data corresponding to A, and are also the reference indicators corresponding to A; for example, B=E+F, C=G+H; wherein E and F are the lower-level target data corresponding to the first-level sub-data B, and G and H are the lower-level target data corresponding to the first-level sub-data C; the computing engine platform can iteratively disassemble the indicator formula and interact with multiple original databases through the data input port to query, and finally determine all the reference indicators required to calculate the target indicator.

[0063] It should be emphasized that the result dictionary table can store the results of each calculation process. If the first-level sub-data B has been numerically calculated before, the value corresponding to the first-level sub-data B will be stored in the result dictionary table for easy call. When calculating A=B+C, since the first-level sub-data C has not been calculated before, the value of the first-level sub-data C needs to be calculated based on G and H; since the value of the first-level sub-data B is stored in the result dictionary table, the system can directly call the value of the first-level sub-data B from the result dictionary table without having to calculate it again.

[0064] In some embodiments, Figure 6As shown, the aforementioned S150 may specifically include the following steps: based on the reference indicator information, the calculation engine platform calls data from the data input port, performs indicator calculation to generate an indicator calculation result corresponding to the target indicator, and stores it in the result dictionary table.

[0065] S410. Based on the time period preconfigured in the metadata configuration table, the data in the original database is called from the data input port through the computing engine platform to obtain the primary sub-data involved in the computing.

[0066] S420. When there is no corresponding lower-level target data for the first-level sub-data, an indicator calculation is performed based on the first-level sub-data to obtain an indicator calculation result.

[0067] S430: When the first-level sub-data has corresponding lower-level target data, the first-level sub-data is recursively parsed through the computing engine platform until all the lower-level target data are obtained from the original database.

[0068] S440, integrating the first-level sub-data and the lower-level target data and aligning the time axis, performing indicator calculation through the calculation engine platform, and obtaining the indicator calculation result.

[0069] In the embodiment of the present application, it can be understood that the first-level sub-data and the lower-level target data are reference indicators corresponding to the target indicator. In the indicator calculation process, after determining the reference indicator corresponding to the target indicator, the calculation engine platform can arbitrarily determine the calculation order in a recursive manner based on multiple reference indicators and indicator formulas. The calculation result of each time can be stored in the result dictionary table for direct call next time.

[0070] It should be noted that this application supports multiple calculation dimensions and can automatically perform calculations according to the time dimension of the indicator configuration. The calculation method is rich, flexible and convenient, and can meet the indicator calculation requirements in most scenarios, such as minutes, hours, days, weeks, months and years; among them, long periods can be generated by statistics of short periods, such as hourly values ​​can be generated by averaging and summing minute values; they can also be calculated and generated by indicators of the same period, such as a monthly indicator can also be calculated from other monthly indicators.

[0071] In some embodiments, after the aforementioned step of calling data from the data input port through the computing engine platform based on the referenced indicator information, performing indicator calculation to generate an indicator calculation result corresponding to the target indicator, and storing it in the result dictionary table, that is, after the aforementioned S150, the real-time indicator calculation method based on the low-code configuration may further include the following steps:

[0072] S161. Based on the storage address in the metadata configuration table, determine the mapping relationship between the indicator calculation result and the preset multiple result databases.

[0073] S162. Based on the mapping relationship, the indicator calculation results are sent from the result dictionary table to the corresponding result database through the data output port.

[0074] In the embodiment of the present application, it can be understood that by sending the indicator calculation results from the result dictionary table to the corresponding result database for storage, the result obtained by calculating the target indicator once can be used in multiple result databases, thereby achieving one calculation and use in multiple locations.

[0075] In some embodiments, Figure 7 As shown, the present application provides a real-time indicator calculation device 500 based on low-code configuration, and the real-time indicator calculation device 500 may specifically include the following modules:

[0076] An acquisition module 510 is used to acquire a plurality of target indicators to be calculated and determine a time dimension of the target indicator, where the time dimension is used to characterize a calculation period of the target indicator;

[0077] The judgment module 520 is used to read the constructed metadata configuration table through a preset computing engine platform, classify the target indicator, and judge whether the target indicator is original data or calculated data; wherein the computing engine platform can send instructions to a preset data input port to call data from the original database through the data input port;

[0078] The reading module 530 is used to read the data of the corresponding time point from the original database based on the time period preconfigured in the metadata configuration table when the target indicator is the original data and store it in the result dictionary table so as to output it from the preset data output port;

[0079] The parsing module 540 is used to parse the indicator formula corresponding to the target indicator through the calculation engine platform when the target indicator is calculation data, and determine the reference indicator information corresponding to the target indicator, wherein the reference indicator information includes at least one reference indicator of at least one level;

[0080] The calculation module 550 is used to call data from the data input port through the calculation engine platform based on the reference indicator information, perform indicator calculation to generate an indicator calculation result corresponding to the target indicator, and store it in the result dictionary table.

[0081] According to an embodiment of the present application, any multiple modules among the acquisition module 510, the judgment module 520, the reading module 530, the parsing module 540 and the calculation module 550 can be combined into one module for implementation, or any one of the modules can be split into multiple modules. Alternatively, at least part of the functions of one or more of these modules can be combined with at least part of the functions of other modules and implemented in one module.

[0082] It should be noted that before performing formal indicator calculation, the operator can perform a calculation test based on the real-time indicator calculation device 500, and when the test result does not exceed the preset threshold range, perform formal indicator calculation.

[0083] In some embodiments, the aforementioned determination module 520 may be specifically used to:

[0084] Based on the metadata configuration table, query the indicator formula corresponding to the target indicator;

[0085] When the indicator formula corresponding to the target indicator is empty, the target indicator is determined to be the original data;

[0086] When the indicator formula corresponding to the target indicator is not empty, the target indicator is determined to be calculated data.

[0087] In some embodiments, the aforementioned parsing module 540 may be specifically used to:

[0088] Based on the configuration information in the metadata configuration table, the indicator formula corresponding to the target indicator is parsed through the calculation engine platform to obtain the first-level sub-data corresponding to the target indicator;

[0089] Interact with the original database through the computing engine platform and data input port to determine whether the original database has primary sub-data;

[0090] When the original database does not contain first-level sub-data, the first-level sub-data is parsed through the computing engine platform to determine the lower-level target data corresponding to the first-level sub-data;

[0091] Iteratively execute the parsing query job to determine whether there is subordinate target data corresponding to the first-level sub-data in the original database, until the value corresponding to each subordinate target data is obtained; wherein the first-level sub-data and the subordinate target data are reference indicators.

[0092] In some embodiments, the aforementioned calculation module 550 may be specifically used for:

[0093] Based on the time period pre-configured in the metadata configuration table, the data in the original database is called from the data input port through the computing engine platform to obtain the first-level sub-data involved in the calculation;

[0094] When there is no corresponding lower-level target data in the first-level sub-data, the indicator calculation is performed based on the first-level sub-data to obtain the indicator calculation result;

[0095] When the first-level sub-data has corresponding lower-level target data, the first-level sub-data is recursively parsed through the computing engine platform until all the lower-level target data are obtained from the original database;

[0096] The first-level sub-data and lower-level target data are integrated and aligned with the time axis, and the indicator calculation is performed through the calculation engine platform to obtain the indicator calculation results.

[0097] In some embodiments, Figure 8 As shown, the real-time index calculation device 500 may further include an output module 560, and the output module 560 may specifically include the following units:

[0098] The relationship determination unit 561 is used to determine the mapping relationship between the indicator calculation result and the preset multiple result databases based on the storage address in the metadata configuration table.

[0099] The result output unit 562 is used to send the indicator calculation result from the result dictionary table to the corresponding result database through the data output port based on the mapping relationship.

[0100] Figure 7 and Figure 8 Each module in the device shown has the function of implementing each step in the aforementioned real-time indicator calculation method based on low-code configuration, and can achieve its corresponding technical effect. For the sake of concise description, it will not be repeated here.

[0101] In some embodiments, the present application provides an electronic device, the structure diagram of the electronic device is as follows Fig. 9 shown.

[0102] The electronic device may include a processor 610 and a memory 620 storing computer program instructions.

[0103] Specifically, the processor 610 may include a central processing unit (CPU), or an application specific integrated circuit (ASIC), or may be configured to implement one or more integrated circuits of the embodiments of the present application.

[0104] The memory 620 may include a large capacity memory for data or instructions. By way of example and not limitation, the memory 620 may include a hard disk drive (HDD), a floppy disk drive, a flash memory, an optical disk, a magneto-optical disk, a magnetic tape, or a universal serial bus (USB) drive or a combination of two or more of these. In appropriate cases, the memory 620 may include a removable or non-removable (or fixed) medium. In appropriate cases, the memory 620 may be inside or outside the integrated gateway disaster recovery device. In a specific embodiment, the memory 620 is a non-volatile solid-state memory.

[0105] The memory 620 may include a read-only memory (ROM), a random access memory (RAM), a disk storage medium device, an optical storage medium device, a flash memory device, an electrical, optical or other physical / tangible memory storage device. Therefore, typically, the memory 620 includes one or more tangible (non-transitory) computer-readable storage media (e.g., a memory device) encoded with software including computer-executable instructions, and when the software is executed (e.g., by one or more processors), it can perform the operations described in any of the real-time indicator calculation methods based on low-code configuration in the above-mentioned embodiments.

[0106] The processor 610 reads and executes computer program instructions stored in the memory 620 to implement any one of the real-time indicator calculation methods based on low-code configuration in the above embodiments.

[0107] In one example, the electronic device may further include a communication interface 630 and a bus 600. Fig. 9 As shown, the processor 610, the memory 620, and the communication interface 630 are connected via a bus 600 and communicate with each other.

[0108] The communication interface 630 is mainly used to implement communication between various modules, devices, units and / or equipment in the embodiments of the present application.

[0109] Bus 600 includes hardware, software or both, and the parts of online data flow billing equipment are coupled to each other. For example, but not limitation, bus may include accelerated graphics port (AGP) or other graphics bus, enhanced industrial standard architecture (EISA) bus, front-end bus (FSB), hypertransport (HT) interconnection, industrial standard architecture (ISA) bus, infinite bandwidth interconnection, low pin count (LPC) bus, memory bus, micro channel architecture (MCA) bus, peripheral component interconnection (PCI) bus, PCI-Express (PCI-X) bus, serial advanced technology attachment (SATA) bus, video electronics standard association local (VLB) bus or other suitable bus or two or more of these combinations. In appropriate cases, bus 600 may include one or more buses. Although the present application embodiment describes and shows a specific bus, the present application considers any suitable bus or interconnection.

[0110] In addition, in combination with the real-time indicator calculation method based on low-code configuration in the above embodiment, the embodiment of the present application can provide a computer storage medium for implementation. The computer storage medium stores computer program instructions; when the computer program instructions are executed by the processor, any one of the real-time indicator calculation methods based on low-code configuration in the above embodiment is implemented.

[0111] It should be clear that the present application is not limited to the specific configuration and processing described above and shown in the figures. For the sake of simplicity, a detailed description of the known method is omitted here. In the above embodiments, several specific steps are described and shown as examples. However, the method process of the present application is not limited to the specific steps described and shown, and those skilled in the art can make various changes, modifications and additions, or change the order between the steps after understanding the spirit of the present application.

[0112] The functional blocks shown in the above block diagram can be implemented as hardware, software, firmware or a combination thereof. When implemented in hardware, it can be, for example, an electronic circuit, an application specific integrated circuit (ASIC), appropriate firmware, a plug-in, a function card, etc. When implemented in software, the elements of the present application are programs or code segments that are used to perform the required tasks. The program or code segment can be stored in a machine-readable medium, or transmitted on a transmission medium or a communication link by a data signal carried in a carrier wave. "Machine-readable medium" can include any medium capable of storing or transmitting information. Examples of machine-readable media include electronic circuits, semiconductor memory devices, ROM, flash memory, erasable ROM (EROM), floppy disks, CD-ROMs, optical disks, hard disks, optical fiber media, radio frequency (RF) links, etc. The code segment can be downloaded via a computer network such as the Internet, an intranet, etc.

[0113] It should also be noted that the exemplary embodiments mentioned in this application describe some methods or systems based on a series of steps or devices. However, this application is not limited to the order of the above steps, that is, the steps can be performed in the order mentioned in the embodiment, or in a different order from the embodiment, or several steps can be performed simultaneously.

[0114] Aspects of the present disclosure are described above with reference to the flowchart and / or block diagram of the method, device (system) and computer program product according to the embodiment of the present disclosure. It should be understood that each box in the flowchart and / or block diagram and the combination of each box in the flowchart and / or block diagram can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device to produce a machine so that these instructions executed by the processor of the computer or other programmable data processing device enable the implementation of the function / action specified in one or more boxes of the flowchart and / or block diagram. Such a processor can be, but is not limited to, a general-purpose processor, a special-purpose processor, a special application processor, or a field programmable logic circuit. It can also be understood that each box in the block diagram and / or flowchart and the combination of boxes in the block diagram and / or flowchart can also be implemented by dedicated hardware that performs a specified function or action, or can be implemented by a combination of dedicated hardware and computer instructions.

[0115] In summary, compared with the prior art, this application has the following beneficial effects:

[0116] 1. The computing engine platform established by this application is responsible for parsing the indicator formulas and statistical logic for calculating each indicator; the computing engine platform is equipped with a configuration unit for creating indicators and customizing indicator formulas. The computing engine platform has the characteristics of low code, easy expansion, rich support for calculation logic, and convenient debugging. By setting up the configuration unit, indicators can be easily expanded. The configuration unit supports batch configuration of indicators. Users can freely add indicators to the metadata configuration table and configure indicators in batches. The configuration process has a low degree of dependence on code.

[0117] 2. This application can realize online real-time editing and modification by configuring the calculation formula and cycle in the metadata configuration table, which takes effect immediately without adjusting the code; program developers only need to pay attention to the reliability and stability of the calculation engine, without paying attention to the specific business logic; indicator formula configuration personnel only need to pay attention to the business logic, without paying attention to the internal process of the software. It realizes efficient cooperation and reasonable division of labor among various personnel and improves work efficiency.

[0118] 3. This application targets the target indicators to be calculated. Since the calculation logic can be intuitively viewed in the metadata configuration table, it is simpler and clearer than the query code, and the indicator reference relationship is also clear and simple. It can greatly reduce the difficulty in troubleshooting and indicator debugging. Non-program developers can also quickly locate the root cause of the problem, shortening the troubleshooting time. The processing logic is clear, and the operation and debugging are simple.

[0119] The above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit the same. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some of the technical features may be replaced by equivalents. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A real-time indicator calculation method based on low-code configuration, characterized in that: include: Acquire multiple target indicators to be calculated, and determine a time dimension of the target indicator, where the time dimension is used to characterize a calculation period of the target indicator; The constructed metadata configuration table is read through a preset computing engine platform, the target indicator is classified, and the target indicator is determined to be original data or calculated data; wherein the computing engine platform can send instructions to a preset data input port to call data from the original database through the data input port; In the case where the target indicator is the original data, based on the time period preconfigured in the metadata configuration table, the data at the corresponding time point is read from the original database and stored in the result dictionary table, so as to be output from a preset data output port; In the case where the target indicator is the calculation data, the indicator formula corresponding to the target indicator is parsed by the calculation engine platform to determine the reference indicator information corresponding to the target indicator, wherein the reference indicator information includes at least one reference indicator of at least one level; Based on the reference indicator information, data is called from the data input port through the calculation engine platform, indicator calculation is performed to generate an indicator calculation result corresponding to the target indicator, and the result is stored in the result dictionary table.

2. The real-time indicator calculation method based on low-code configuration according to claim 1 is characterized in that: The determining whether the target indicator is original data or calculated data includes: Based on the metadata configuration table, query the indicator formula corresponding to the target indicator; When the indicator formula corresponding to the target indicator is empty, determining that the target indicator is original data; When the indicator formula corresponding to the target indicator is not empty, the target indicator is determined to be calculated data.

3. The real-time indicator calculation method based on low-code configuration according to claim 1 is characterized in that: The step of parsing the indicator formula corresponding to the target indicator by the computing engine platform to determine the reference indicator information corresponding to the target indicator includes: Based on the configuration information in the metadata configuration table, the indicator formula corresponding to the target indicator is parsed by the computing engine platform to obtain the primary sub-data corresponding to the target indicator; Performing data interaction with the original database through the computing engine platform and the data input port to determine whether the first-level sub-data exists in the original database; In the case that the primary sub-data does not exist in the original database, the primary sub-data is parsed by the computing engine platform to determine the lower-level target data corresponding to the primary sub-data; Iteratively execute the parsing query operation to determine whether the original database has subordinate target data corresponding to the first-level sub-data, until a value corresponding to each of the subordinate target data is obtained; wherein the first-level sub-data and the subordinate target data are the reference indicators.

4. The real-time indicator calculation method based on low-code configuration according to claim 3 is characterized in that: Based on the reference indicator information, calling data from the data input port through the calculation engine platform, performing indicator calculation to generate an indicator calculation result corresponding to the target indicator, and storing it in the result dictionary table, includes: Based on the time period preconfigured in the metadata configuration table, the data in the original database is called from the data input port through the computing engine platform to obtain the primary sub-data involved in the calculation; In the case that the first-level sub-data does not have the corresponding lower-level target data, performing an indicator calculation based on the first-level sub-data to obtain an indicator calculation result; In the case that the first-level sub-data has the corresponding lower-level target data, recursively parsing the first-level sub-data through the computing engine platform until all the lower-level target data are obtained from the original database; The first-level sub-data and the lower-level target data are integrated and aligned with the time axis, and the indicator calculation is performed through the calculation engine platform to obtain the indicator calculation result.

5. The real-time indicator calculation method based on low-code configuration according to any one of claims 1 to 4, characterized in that: After the referenced indicator information is used to call data from the data input port through the computing engine platform, the indicator calculation is performed to generate the indicator calculation result corresponding to the target indicator, and the result is stored in the result dictionary table, the real-time indicator calculation method based on low-code configuration also includes: Based on the storage address in the metadata configuration table, determining the mapping relationship between the indicator calculation result and the preset multiple result databases; Based on the mapping relationship, the indicator calculation result is sent from the result dictionary table to the corresponding result database through the data output port.

6. The real-time indicator calculation method based on low-code configuration according to claim 1 is characterized in that: The configuration information of the metadata configuration table includes an indicator code, an indicator description, an indicator dimension, an indicator formula, a time dimension and a storage address; wherein the indicator formula is used to characterize the calculation logic of the indicator.

7. The real-time indicator calculation method based on low-code configuration according to claim 6 is characterized in that: The computing engine platform is used to parse the indicator formula, and the formula types corresponding to the indicator formula include basic arithmetic operations, statistical summaries and custom functions; the custom functions support judgment, jumps and loops; the computing engine platform is provided with a configuration unit to perform indicator creation and custom configuration of the indicator formula.

8. A real-time indicator calculation device based on low-code configuration, characterized in that: include: An acquisition module, used to acquire a plurality of target indicators to be calculated, and determine a time dimension of the target indicator, wherein the time dimension is used to characterize a calculation period of the target indicator; A judgment module, used to read the constructed metadata configuration table through a preset computing engine platform, classify the target indicator, and judge whether the target indicator is original data or calculated data; wherein the computing engine platform can send instructions to a preset data input port to call data from the original database through the data input port; A reading module, for reading data at a corresponding time point from the original database based on a time period preconfigured in the metadata configuration table when the target indicator is the original data, and storing the data in a result dictionary table so as to output the data from a preset data output port; A parsing module, configured to parse an indicator formula corresponding to the target indicator through the computing engine platform to determine reference indicator information corresponding to the target indicator when the target indicator is the calculation data, wherein the reference indicator information includes at least one reference indicator of at least one level; The calculation module is used to call data from the data input port through the calculation engine platform based on the reference indicator information, perform indicator calculation to generate an indicator calculation result corresponding to the target indicator, and store it in the result dictionary table.

9. An electronic device, characterized in that: include: A processor, a memory, and a program stored in the memory and executable on the processor, wherein when the program is executed by the processor, the real-time indicator calculation method based on low-code configuration as described in any one of claims 1 to 7 is implemented.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores programs or instructions, and when the programs or instructions are executed by the processor, the real-time indicator calculation method based on low-code configuration as described in any one of claims 1 to 7 is implemented.

Citation Information

Cited By

  • Index calculation method and system considering period offset and terminal equipment

    CN120561160A