Data index statistical method, system and electronic equipment based on database configuration

Abstract

The application provides a kind of based on database configuration data index statistics method, system and electronic equipment, it is related to computer technology field, the method includes: first, according to the index predefinition of business requirement and configure index basic information, generate index basic information table;Index basic information table is used to store the index basic information of at least one index;Index basic information includes: statistical dimension, statistical method and statistical caliber;Index development script is written based on development process specification;Index development script is used to obtain the statistical value of index according to the detail data of business, and the statistical value is stored in index statistical result table;Based on the index parameter to be viewed and index basic information received in advance, the statistical result is obtained from index statistical result table using data interface, the technical problem of the prior art, such as separate development requirement, insufficient expansion, low development efficiency, is solved by the method, and the technical effect of improving development efficiency is achieved.

Description

Technical Field

[0001] This invention relates to the field of computer technology, and in particular to a data indicator statistical method, system, and electronic device based on database configuration. Background Technology

[0002] Against the backdrop of digital transformation, the volume of data generated by various business systems across different organizations is growing exponentially with the digitalization of their operations. To effectively optimize departmental operations, what's often needed is not just this massive amount of data itself, but more importantly, the business insights it reflects. For example, analyzing the case-handling data from officers' mobile devices can yield more indicators, such as the distribution of case numbers by department, time, and region, and the distribution of case numbers by case type. Further analysis of these indicators can identify areas requiring focused attention, enabling targeted monitoring and promoting more efficient work among officers. Currently, the main approach is to store data on different themes in different tables, with technical developers creating customized reports based on business needs. This approach suffers from the drawbacks of requiring separate development for each data indicator, resulting in insufficient scalability and low development efficiency. Summary of the Invention

[0003] The purpose of this invention is to provide a data indicator statistics method, system, and electronic device based on database configuration, so as to alleviate the technical problems of insufficient scalability of data indicator requirements and low development efficiency in the prior art.

[0004] In a first aspect, embodiments of the present invention provide a data indicator statistics method based on database configuration, the method comprising:

[0005] Based on business needs, indicators are predefined and basic indicator information is configured to generate an indicator basic information table. The indicator basic information table is used to store the basic information of at least one indicator. The indicator basic information includes: statistical dimension, statistical method, and statistical scope.

[0006] The indicator development scripts are written based on the development process specifications. The above indicator development scripts are used to obtain the statistical values ​​of the indicators based on the detailed data of the business and store the above statistical values ​​in the indicator statistical results table.

[0007] Based on the pre-received parameters of the indicators to be viewed and the basic information of the aforementioned indicators, statistical results are obtained from the statistical results table of the aforementioned indicators using the data interface.

[0008] In some possible implementations, the steps of predefining indicators and configuring basic indicator information according to business needs to generate an indicator basic information table include: defining indicators in a standardized manner according to business needs and determining indicator types; the indicator types include atomic indicators and composite indicators; the composite indicators are obtained from the atomic indicators through four arithmetic operations; configuring statistical dimensions, statistical methods and statistical scope according to the indicator types to generate an indicator basic information table; the statistical methods include statistical cumulative values ​​or current updated values.

[0009] In some possible implementations, the above-mentioned indicator statistical result table is used to store atomic indicators; the above-mentioned atomic indicators are used to combine the above-mentioned indicator basic information to realize the configuration and query of composite indicators; the above-mentioned indicator statistical result table includes: indicator code, indicator name, indicator value and at least one statistical dimension.

[0010] In some possible implementations, before the step of obtaining statistical results from the statistical result table of the above-mentioned indicators using a data interface based on the pre-received indicator parameters to be viewed and the above-mentioned indicator basic information, the method further includes: inputting the indicator parameters to be viewed according to the above-mentioned business requirements; the indicator parameters to be viewed include: the indicator to be viewed, the statistical dimension, and the time interval; and receiving the indicator parameters to be viewed using a data interface.

[0011] In some possible implementations, based on the pre-received parameters of the indicators to be viewed and the aforementioned basic information about the indicators, statistical results are obtained from the aforementioned indicator statistical result table using a data interface. This includes: validating the aforementioned indicators to be viewed input to the data interface, removing invalid indicators and invalid dimension values ​​according to the validation rules; splitting the validated indicators into multiple groups according to the aforementioned statistical method, and concatenating each group using structured query language according to the aforementioned statistical method and the corresponding arithmetic operation requirements; obtaining statistical results from the aforementioned indicator statistical result table based on the concatenation results of the aforementioned structured query language for each group, and merging the statistical results of multiple groups using different statistical methods into a unified format return result.

[0012] In some possible implementations, the above verification rules include: the above-mentioned indicator to be viewed is configured in the above-mentioned indicator basic information table and has been developed; the above-mentioned indicator to be viewed supports a predetermined statistical dimension; and the above-mentioned statistical dimension supported by the above-mentioned indicator to be viewed conforms to the corresponding parameter range.

[0013] In some possible implementations, the above method further includes: generating a chart based on the returned results and displaying the chart in a visual form on the front-end page.

[0014] Secondly, embodiments of the present invention provide a data indicator statistics system based on database configuration, the system comprising:

[0015] The configuration module is used to predefine indicators and configure basic indicator information according to business needs, and generate an indicator basic information table. The indicator basic information table is used to store the basic information of at least one indicator. The indicator basic information includes: statistical dimension, statistical method and statistical scope.

[0016] The script writing module is used to write indicator development scripts based on the development process specifications. The aforementioned indicator development scripts are used to obtain the statistical values ​​of the indicators based on the detailed data of the business and store the statistical values ​​in the indicator statistical results table.

[0017] The statistical results generation module is used to obtain statistical results from the statistical results table of the above indicators based on the pre-received parameters of the indicators to be viewed and the basic information of the above indicators, using the data interface.

[0018] Thirdly, embodiments of the present invention provide an electronic device, including a memory and a processor, wherein the memory stores a computer program that can run on the processor, and the processor executes the computer program to implement the steps of the method described in any of the first aspects above.

[0019] Fourthly, embodiments of the present invention provide a computer-readable storage medium storing machine-executable instructions, which, when invoked and executed by a processor, cause the processor to perform the method described in any of the first aspects above.

[0020] This invention provides a data indicator statistics method, system, and electronic device based on database configuration. The method includes: firstly, predefining indicators and configuring basic indicator information according to business requirements to generate an indicator basic information table; the indicator basic information table stores the basic information of at least one indicator; the indicator basic information includes: statistical dimension, statistical method, and statistical caliber; writing indicator development scripts based on development process specifications; the indicator development scripts are used to obtain the statistical values ​​of the indicators based on detailed business data and store the statistical values ​​in an indicator statistical result table; and based on pre-received indicator parameters and indicator basic information, obtaining statistical results from the indicator statistical result table using a data interface. This method alleviates the technical problems of insufficient scalability of data indicator requirements and low development efficiency in existing technologies, achieving the technical effect of improving development efficiency. Attached Figure Description

[0021] To more clearly illustrate the specific embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the specific embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present invention. For those skilled in the art, other drawings can be obtained from these drawings without creative effort.

[0022] Figure 1 A flowchart illustrating a data indicator statistics method based on database configuration provided in an embodiment of the present invention;

[0023] Figure 2 A flowchart illustrating another data indicator statistics method based on database configuration provided in an embodiment of the present invention;

[0024] Figure 3 A schematic diagram of a data indicator statistics device based on database configuration provided in an embodiment of the present invention;

[0025] Figure 4 This is a schematic diagram of the structure of an electronic device provided in an embodiment of the present invention. Detailed Implementation

[0026] To make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. The components of the embodiments of the present invention described and shown in the accompanying drawings can generally be arranged and designed in various different configurations.

[0027] Therefore, the following detailed description of the embodiments of the invention provided in the accompanying drawings is not intended to limit the scope of the claimed invention, but merely to illustrate selected embodiments of the invention. All other embodiments obtained by those skilled in the art based on the embodiments of the invention without inventive effort are within the scope of protection of the invention.

[0028] It should be noted that similar reference numerals and letters in the following figures indicate similar items; therefore, once an item is defined in one figure, it does not need to be further defined and explained in subsequent figures. Some embodiments of the present invention will now be described in detail with reference to the accompanying drawings. Unless otherwise specified, the following embodiments and features can be combined with each other.

[0029] Against the backdrop of digital transformation, the volume of data generated by various business systems across different organizations is growing exponentially with the digitalization of their operations. To effectively optimize departmental operations, what's often needed is not just this massive amount of data itself, but more importantly, the business insights it reflects. For example, analyzing the case-handling data from officers' mobile devices can yield more indicators, such as the distribution of case numbers by department, time, and region, and the distribution of case numbers by case type. Further analysis of these indicators can identify areas requiring focused attention, enabling targeted monitoring and promoting more efficient work among officers. Currently, the main approach is to store data on different themes in different tables, with technical developers creating customized reports based on business needs. However, existing solutions have the following problems:

[0030] 1. Data development lacks unified process control, resulting in excessively long deployment cycles;

[0031] 2. Each requirement needs to be developed separately, resulting in insufficient scalability;

[0032] 3. Inconsistent statistical standards for data metrics result in inconsistent data values ​​for metrics with the same name on different pages, leading to a poor user experience.

[0033] 4. It takes developers a long time to troubleshoot data issues.

[0034] Based on this, embodiments of the present invention provide a data indicator statistics method, system, and electronic device based on database configuration to alleviate the aforementioned problems existing in the prior art.

[0035] To facilitate understanding of this embodiment, a data indicator statistics method based on database configuration disclosed in this embodiment of the invention will first be described in detail. See [link to relevant documentation]. Figure 1 The diagram shows a flowchart of a data indicator statistical method based on database configuration. This method can be executed by an electronic device and mainly includes the following steps S110 to S130:

[0036] S110: Predefine indicators and configure basic indicator information according to business needs, and generate an indicator basic information table; the indicator basic information table is used to store the basic information of at least one indicator; the indicator basic information includes: statistical dimension, statistical method and statistical scope;

[0037] S120: Write indicator development scripts based on development process specifications; indicator development scripts are used to obtain statistical values ​​of indicators based on detailed business data and store the statistical values ​​in the indicator statistical results table;

[0038] S130: Based on the pre-received parameters of the indicators to be viewed and the basic information of the indicators, obtain the statistical results from the indicator statistical results table using the data interface.

[0039] In one embodiment, the steps of predefining indicators and configuring basic indicator information according to business needs to generate an indicator basic information table include: defining indicators in a standardized manner according to business needs and determining indicator types; indicator types include atomic indicators and composite indicators; composite indicators are obtained from atomic indicators through four arithmetic operations; configuring statistical dimensions, statistical methods and statistical scope according to indicator types to generate an indicator basic information table; statistical methods include statistical cumulative values ​​or current updated values.

[0040] In one embodiment, the indicator statistics result table is used to store atomic indicators; atomic indicators are used to combine with indicator basic information to configure and query composite indicators; the indicator statistics result table includes: indicator code, indicator name, indicator value and at least one statistical dimension.

[0041] In one embodiment, before the step of obtaining statistical results from the indicator statistical result table using a data interface based on the pre-received indicator parameters to be viewed and the indicator basic information, the method further includes: inputting the indicator parameters to be viewed according to business needs; the indicator parameters to be viewed include: the indicator to be viewed, the statistical dimension, and the time interval; and receiving the indicator parameters to be viewed using a data interface.

[0042] In one embodiment, based on pre-received indicator parameters and basic indicator information, statistical results are obtained from the indicator statistical results table using a data interface, including:

[0043] (01) Validate the metrics to be viewed in the input data interface and remove invalid metrics and invalid dimension values ​​according to the validation rules;

[0044] In one embodiment, the verification rules include: the indicator to be viewed is configured in the indicator basic information table and development is completed; the indicator to be viewed supports a pre-determined statistical dimension; and the statistical dimension supported by the indicator to be viewed conforms to the corresponding parameter range.

[0045] As a specific example, the verification rules can include the following three aspects: (1) It is not supported to view indicators that are not configured in the indicator basic information table or have not been developed (i.e., the indicator to be viewed must be configured in the indicator basic information table and be developed); (2) The statistical dimension of a single indicator is predetermined. For example, some indicators do not support statistics by department dimension, but only support statistics by time or city dimension. After selecting the indicator, the unsupported statistical dimension can be verified, and the indicator can be filtered and prompted to see if a certain statistical dimension is supported; (3) The statistical dimension of the indicator also has a certain range. Invalid time parameters (such as future time or non-standard time parameter format) will be verified.

[0046] (02) Based on the statistical method, the verified indicators are divided into multiple groups, and each group is assembled using structured query language according to the statistical method and the corresponding arithmetic operation requirements.

[0047] In this embodiment, there are two statistical methods for the indicators: cumulative value and latest value. After grouping, the cumulative value group can obtain the sum of the selected time interval range as the statistical result by concatenating the structured query language. The latest value is directly concatenated to obtain the statistical value whose time is equal to the end time as the result.

[0048] (03) Based on the concatenation results of the structured query language for each group, obtain the statistical results from the indicator statistical results table respectively, and merge the statistical results of multiple groups with different statistical methods into a return result with a unified format.

[0049] It should be noted that composite indicators can be flexibly and dynamically combined: the indicator statistics result table stores atomic indicators, such as the numerator or denominator of an indicator. By configuring the basic information of indicators in the indicator base table, composite indicators can be configured and queried. For example, the statistics table only stores indicators A, B, and C, while the indicator base information table contains six indicators A, B, C, D, E, and F. The definition of indicator D is A / B, the definition of indicator E is A+B, and the definition of indicator F is (A+C) / B. Although indicators D, E, and F cannot be directly obtained from the indicator statistics table, the statistical values ​​of indicators D, E, and F can be obtained by dynamically combining indicators A, B, and C with the four arithmetic calculation symbols after obtaining the configuration information of the indicators.

[0050] If the numerator and denominator of the above indicator D are calculated in different ways (e.g., the numerator is the number of cases handled by law enforcement officers, the denominator is the number of law enforcement officers, and D means the average number of cases handled by law enforcement officers), the statistical results can be obtained directly by flexibly and dynamically concatenating the conditions of the structured query language without additional grouping of the statistical methods by obtaining the basic configuration information of indicator D.

[0051] The above method only requires the storage of atomic indicators, saving storage space in the statistical table; by configuration, the query requirements of composite indicators can be realized, reducing the workload of data developers. Only three indicators need to be developed to realize the query of more than 6 indicators.

[0052] In one embodiment, the method further includes: generating a chart based on the returned results, and displaying the chart in a visual form on the front-end page.

[0053] In other words, this invention provides a data indicator statistics method based on database configuration. This method is based on the basic logic of a unified standard, constructs a unified indicator framework, maintains indicator definitions in a unified indicator definition table, stores the results of indicator data development and output related data structures in a statistics table, and allows indicators of different statistical methods to be uniformly and visually displayed on the page.

[0054] As a concrete example, see Figure 2 As shown, the data metric statistics method based on database configuration provided in this embodiment includes the following steps:

[0055] S210: Basic information on configuration indicators;

[0056] Business personnel can define and configure statistical dimensions and methods (cumulative values ​​or latest values, etc.) for indicators according to business needs. For derived composite indicators, dynamic SQL can be directly configured using atomic indicators obtained through simple arithmetic calculations, without requiring data development to rewrite new scripts. The basic information configuration table structure for indicators is shown in Table 1 below:

[0057] Table 1 - Basic Information Configuration Table for Indicators

[0058]

[0059]

[0060] S220: Write indicator development scripts;

[0061] For the new metrics, data developers write scripts according to a unified development process specification, obtain the statistical values ​​of the metrics based on detailed business data, and store them uniformly in the statistical results table of the metric center. The structure of the statistical results table is shown in Table 2 below:

[0062] Table 2 - Statistical Results

[0063]

[0064]

[0065] S230: User input;

[0066] Business personnel can input the metrics, statistical dimensions, and time intervals they need to view, based on their business requirements.

[0067] S240: A single interface processes and returns standardized statistical results uniformly;

[0068] After receiving the input, the interface first validates the input, removing invalid metrics and dimension values. Then, based on the different statistical logics in the metric configuration information, the metrics are split into multiple groups. Each group is dynamically SQL-concatenated according to its own statistical logic and arithmetic calculation requirements, and statistical results are obtained from the statistical table. Next, the statistical results of the multiple groups with different statistical logics are merged into a unified format return result, and basic operations such as sorting are performed.

[0069] S250: Visualization on the front-end page. The statistical results returned in step S240 can be displayed on the front-end page in a visual format such as a table, bar chart, or line chart.

[0070] The above method maintains data metric definitions and standards uniformly in the metric configuration table, enabling metric reuse under different demand states, increasing metric documentation capabilities, improving development efficiency, and reducing subsequent communication costs. All metric values ​​are stored using a unified data model. Adding new metrics only requires writing statistical scripts based on the metric configuration information and unified data development specifications; the data structure and page display do not need to be modified, improving the stability and scalability of the data statistical model. Unified metric output allows different business units to directly use interface data through a unified data output interface, achieving consistency of the same data metric across different business units. Derived composite metrics can be obtained directly through configuration without developing new scripts. For example, the metrics of the number of connected and unconnected systems can be derived through arithmetic operations to obtain the system connection rate, the number of all systems requiring connection, and the rate of unconnected systems.

[0071] Furthermore, embodiments of the present invention also provide a data indicator statistics system based on database configuration, see [link to documentation]. Figure 3 The system includes:

[0072] Configuration module 310 is used to predefine indicators and configure basic indicator information according to business needs, and generate an indicator basic information table; the indicator basic information table is used to store the indicator basic information of at least one indicator; the indicator basic information includes: statistical dimension, statistical method and statistical scope;

[0073] The script writing module 320 is used to write indicator development scripts based on the development process specifications. The indicator development scripts are used to obtain the statistical values ​​of the indicators based on the detailed data of the business and store the statistical values ​​in the indicator statistical results table.

[0074] The statistical result generation module 330 is used to obtain statistical results from the indicator statistical result table using a data interface based on the pre-received indicator parameters and basic indicator information.

[0075] The database-configured data indicator statistics system provided in this application embodiment can be specific hardware on a device or software or firmware installed on the device. The device provided in this application embodiment has the same implementation principle and technical effects as the aforementioned method embodiments. For the sake of brevity, any parts not mentioned in the device embodiment can be referred to the corresponding content in the aforementioned method embodiments. Those skilled in the art will clearly understand that, for the sake of convenience and brevity, the specific working processes of the systems, devices, and units described above can all be referred to the corresponding processes in the aforementioned method embodiments, and will not be repeated here. The database-configured data indicator statistics system provided in this application embodiment has the same technical features as the database-configured data indicator statistics method provided in the aforementioned embodiments, and therefore can solve the same technical problems and achieve the same technical effects.

[0076] This application also provides an electronic device, specifically, the electronic device includes a processor and a storage device; the storage device stores a computer program, and the computer program, when run by the processor, executes the method described in any of the above embodiments.

[0077] Figure 4 This is a schematic diagram of the structure of an electronic device provided in an embodiment of this application. The electronic device 400 includes: a processor 40, a memory 41, a bus 42, and a communication interface 43. The processor 40, the communication interface 43, and the memory 41 are connected through the bus 42. The processor 40 is used to execute executable modules, such as computer programs, stored in the memory 41.

[0078] The memory 41 may include high-speed random access memory (RAM) or non-volatile memory, such as at least one disk storage device. Communication between this system network element and at least one other network element is achieved through at least one communication interface 43 (which can be wired or wireless), such as the Internet, wide area network, local area network, metropolitan area network, etc.

[0079] Bus 42 can be an ISA bus, PCI bus, or EISA bus, etc. The bus can be divided into address bus, data bus, control bus, etc. For ease of representation, Figure 4 The symbol is represented by a single double-headed arrow, but this does not mean that there is only one bus or one type of bus.

[0080] The memory 41 is used to store programs. After receiving an execution instruction, the processor 40 executes the program. The method executed by the device for defining the flow process disclosed in any of the foregoing embodiments of the present invention can be applied to the processor 40 or implemented by the processor 40.

[0081] Processor 40 may be an integrated circuit chip with signal processing capabilities. In implementation, each step of the above method can be completed by the integrated logic circuitry in the hardware of processor 40 or by instructions in software form. Processor 40 can be a general-purpose processor, including a Central Processing Unit (CPU), a Network Processor (NP), etc.; it can also be a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field-Programmable Gate Array (FPGA), or other programmable logic devices, discrete gate or transistor logic devices, or discrete hardware components. It can implement or execute the methods, steps, and logic block diagrams disclosed in the embodiments of this invention. The general-purpose processor can be a microprocessor or any conventional processor. The steps of the methods disclosed in the embodiments of this invention can be directly embodied in the execution of a hardware decoding processor, or executed by a combination of hardware and software modules in the decoding processor. The software modules can reside in random access memory, flash memory, read-only memory, programmable read-only memory, electrically erasable programmable memory, registers, or other mature storage media in the art. The storage medium is located in memory 41. The processor 40 reads the information in memory 41 and, in conjunction with its hardware, completes the steps of the above method.

[0082] Corresponding to the above method, this application embodiment also provides a computer-readable storage medium storing machine-executable instructions. When the machine-executable instructions are called and run by a processor, the machine-executable instructions cause the processor to perform the steps of the above method.

[0083] In the embodiments provided in this application, it should be understood that the disclosed apparatus and methods can be implemented in other ways. The apparatus embodiments described above are merely illustrative. For example, the division of units is only a logical functional division, and in actual implementation, there may be other division methods. Furthermore, multiple units or components may be combined or integrated into another system, or some features may be ignored or not executed. Additionally, the displayed or discussed mutual couplings, direct couplings, or communication connections may be through some communication interfaces; indirect couplings or communication connections between devices or units may be electrical, mechanical, or other forms.

[0084] The units described as separate components may or may not be physically separate. The components shown as units may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the units can be selected to achieve the purpose of this embodiment according to actual needs.

[0085] In addition, the functional units in the embodiments provided in this application can be integrated into one processing unit, or each unit can exist physically separately, or two or more units can be integrated into one unit.

[0086] If the aforementioned functions are implemented as software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of this invention, essentially, or the part that contributes to the prior art, or a portion of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause a computer device (which may be a personal computer, electronic device, or network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of this invention. The aforementioned storage medium includes various media capable of storing program code, such as USB flash drives, portable hard drives, read-only memory (ROM), random access memory (RAM), magnetic disks, or optical disks.

[0087] It should be noted that similar reference numerals and letters in the accompanying drawings indicate similar items. Therefore, once an item is defined in one accompanying drawing, it does not need to be further defined and explained in subsequent accompanying drawings. In addition, the terms "first," "second," "third," etc. are used only to distinguish descriptions and should not be construed as indicating or implying relative importance.

[0088] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, and not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some or all of the technical features; and these modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present invention.

Claims

1. A data indicator statistical method based on database configuration, characterized in that, include: Predefine indicators and configure basic indicator information according to business needs, and generate an indicator basic information table; The indicator basic information table is used to store the indicator basic information of at least one indicator; The basic information of the indicators includes: statistical dimensions, statistical methods, and statistical definitions; The indicator development script is written based on the development process specifications; the indicator development script is used to obtain the statistical value of the indicator based on the detailed data of the business, and store the statistical value in the indicator statistical result table; Based on the pre-received parameters of the indicators to be viewed and the basic information of the indicators, statistical results are obtained from the indicator statistical result table using a data interface. This includes: validating the indicators to be viewed input to the data interface, removing invalid indicators and invalid dimension values ​​according to the validation rules; splitting the validated indicators into multiple groups according to the statistical method, and concatenating each group using structured query language according to the statistical method and the corresponding arithmetic operation requirements; obtaining statistical results from the indicator statistical result table based on the concatenation results of the structured query language for each group, and merging the statistical results of multiple groups with different statistical methods into a unified format return result; wherein, for queries of composite indicators, statistical values ​​are obtained by dynamically concatenating the corresponding atomic indicators and combining them with arithmetic operation symbols by obtaining the indicator configuration information.

2. The data indicator statistical method based on database configuration according to claim 1, characterized in that, The steps for predefining and configuring basic indicator information based on business needs, and generating an indicator basic information table, include: The indicators are defined in a standardized manner according to business needs, and the indicator types are determined; the indicator types include atomic indicators and composite indicators. Configure the statistical dimensions, statistical methods, and statistical scope according to the indicator type to generate a basic information table for the indicator; the statistical methods include cumulative statistical values ​​or current updated values.

3. The data indicator statistical method based on database configuration according to claim 2, characterized in that, The statistical results table of the indicators is used to store atomic indicators; The atomic indicators are used to configure and query the composite indicators by combining the basic information of the indicators; The statistical results table for the indicators includes: indicator code, indicator name, indicator value, and at least one statistical dimension.

4. The data indicator statistical method based on database configuration according to claim 1, characterized in that, Before the step of obtaining statistical results from the indicator statistical results table using a data interface based on the pre-received indicator parameters to be viewed and the indicator's basic information, the method further includes: Based on the business requirements, input the parameters of the indicator to be viewed; the parameters of the indicator to be viewed include: the indicator to be viewed, the statistical dimension, and the time interval; The data interface is used to receive the parameter of the indicator to be viewed.

5. The data indicator statistical method based on database configuration according to claim 1, characterized in that, The verification rules include: The indicator to be viewed is configured in the indicator basic information table and has been developed; The metrics to be viewed support pre-defined statistical dimensions; The statistical dimensions supported by the indicator to be viewed conform to the corresponding parameter range.

6. The data indicator statistical method based on database configuration according to claim 1, characterized in that, The method further includes: A chart is generated based on the returned results, and the chart is displayed in a visual form on the front-end page.

7. A data indicator statistical system based on database configuration, characterized in that, The system includes: The configuration module is used to predefine indicators and configure basic indicator information according to business needs, and generate an indicator basic information table; the indicator basic information table is used to store the indicator basic information of at least one indicator; the indicator basic information includes: statistical dimension, statistical method and statistical scope; The script writing module is used to write indicator development scripts based on the development process specifications; the indicator development scripts are used to obtain the statistical values ​​of the indicators based on the detailed data of the business and store the statistical values ​​in the indicator statistical results table; The statistical result generation module is used to obtain statistical results from the indicator statistical result table using a data interface based on pre-received indicator parameters and basic indicator information. This includes: validating the indicators to be viewed from the input data interface, removing invalid indicators and invalid dimension values ​​according to validation rules; splitting the validated indicators into multiple groups according to the statistical method, and concatenating each group using a structured query language according to the statistical method and the corresponding arithmetic operations; obtaining statistical results from the indicator statistical result table based on the concatenation results of each group's structured query language, and merging the statistical results from multiple groups using different statistical methods into a unified format return result; wherein, for queries of composite indicators, statistical values ​​are obtained by dynamically concatenating the corresponding atomic indicators and combining them with arithmetic operation symbols by obtaining the indicator's configuration information.

8. An electronic device comprising a memory and a processor, wherein the memory stores a computer program executable on the processor, characterized in that, When the processor executes the computer program, it implements the steps of the method described in any one of claims 1 to 6.

9. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores machine-executable instructions that, when invoked and executed by a processor, cause the processor to perform the method according to any one of claims 1 to 6.

Images