Index statistical method and device, equipment and storage medium

Abstract

The invention discloses an index statistical method, device and equipment and a storage medium, and relates to the technical field of artificial intelligence, and the method comprises the steps: determining parameters required for performing statistical analysis on indexes according to obtained parameter information, and determining a combination relationship among the parameters according to obtained combination information; determining statistical rules of the indexes according to the parameters and the combination relationship among the parameters; and converting the statistical rule into a query code, and executing the query code on the to-be-counted data to determine an index statistical result corresponding to the to-be-counted data. According to the technical scheme, the statistical rule of the index is determined according to the fact that the user clicks and drags the control in the front-end page, flexible configuration of the statistical rule of the index is achieved, the flexibility of index statistics is improved, index statistics of the to-be-counted data is achieved by executing the query code corresponding to the statistical rule on the to-be-counted data, and the user experience is improved. According to the method and the device, the index statistics period is shortened, and the index statistics cost is reduced.

Description

Technical Field

[0001] Embodiments of the present invention relate to the field of artificial intelligence technology, and in particular, to an indicator statistics method, device, equipment and storage medium. Background Art

[0002] With the rapid development of Internet financial services, banking and financial business scenarios have become diversified. In order to comprehensively monitor the business, it is necessary to collect indicator statistics for business data.

[0003] In the existing technology, it is first necessary to formulate indicator rules corresponding to the business indicators, and then submit the indicator rules to the data center. The data center processes the business data based on the indicator rules to obtain business indicators.

[0004] However, this indicator statistical method is customized and fine-tuning of indicators requires the data center to update the production version, which has poor flexibility and high cost. Summary of the invention

[0005] The present invention provides an indicator statistics method, device, equipment and storage medium to improve the flexibility of indicator statistics and reduce the cost of indicator statistics.

[0006] In a first aspect, an embodiment of the present invention provides an indicator statistics method, including:

[0007] Determine the parameters required for the statistics of the indicators according to the acquired parameter information, and determine the combination relationship between the parameters according to the acquired combination information;

[0008] Determine the statistical rules of the indicator according to the parameters and the combination relationship between the parameters;

[0009] The statistical rules are converted into query codes, and the query codes are executed on the statistical data to be counted to determine the indicator statistical results corresponding to the statistical data to be counted.

[0010] The technical solution of the embodiment of the present invention provides an indicator statistics method, including: determining the parameters required for the indicator statistics according to the acquired parameter information, determining the combination relationship between the parameters according to the acquired combination information; determining the statistical rules of the indicator according to the parameters and the combination relationship between the parameters; converting the statistical rules into query codes, and executing the query codes on the statistical data to be counted to determine the indicator statistical results corresponding to the statistical data to be counted. The above technical solution can first determine the parameters required for the indicator statistics and the combination relationship between the parameters according to the parameter information and combination information determined by the user clicking and dragging the statistical condition control, the statistical dimension control, the statistical target control and the statistical method control in the front-end page, so as to configure the parameters and the combination relationship between the parameters; secondly, the parameters can be combined and configured according to the combination relationship between the parameters to obtain the statistical rules of the indicators, so as to realize the flexible configuration of the statistical rules of the indicators and improve the flexibility of the indicator statistics; and then the statistical rules can be converted into query codes, and the statistical rules corresponding to the statistical data to be counted can be realized by executing the query codes corresponding to the statistical rules on the statistical data to be counted, so as to obtain the indicator statistical results corresponding to the statistical data to be counted, and reduce the cycle and cost of the indicator statistics.

[0011] Furthermore, the parameter information is determined according to the control clicked by the user on the front-end page, and the combination information is determined according to the dragging operation of the user on the clicked control on the front-end page.

[0012] Furthermore, the parameters include at least statistical conditions, statistical dimensions, statistical targets and statistical methods.

[0013] Furthermore, the statistical rules of the indicators are determined according to the parameters and the combination relationship between the parameters, including:

[0014] The parameters are combined according to the combination relationship between the parameters to obtain the statistical rule of the indicator.

[0015] Furthermore, it also includes:

[0016] Synchronizes the pending statistical data to the analysis database based on pre-configured data synchronization rules.

[0017] Further, converting the statistical rules into query codes, and executing the query codes on the data to be counted to determine the statistical results of the indicators corresponding to the data to be counted, includes:

[0018] Converting the statistical rules into query statements supported by the analysis database;

[0019] The query statement is executed based on the analysis database to obtain the indicator statistical results corresponding to the statistical data to be counted.

[0020] In a second aspect, an embodiment of the present invention further provides an indicator statistics device, including:

[0021] A first determination module is used to determine the parameters required for performing statistics on the indicator according to the acquired parameter information, and to determine the combination relationship between the parameters according to the acquired combination information;

[0022] A second determination module is used to determine the statistical rules of the indicator according to the parameters and the combination relationship between the parameters;

[0023] The execution module is used to convert the statistical rules into query codes and execute the query codes on the statistical data to be counted to determine the indicator statistical results corresponding to the statistical data to be counted.

[0024] In a third aspect, an embodiment of the present invention further provides an electronic device, the electronic device comprising:

[0025] at least one processor; and a memory communicatively coupled to the at least one processor;

[0026] The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the indicator statistics method as described in any one of the first aspects.

[0027] In a fourth aspect, an embodiment of the present invention further provides a storage medium comprising computer executable instructions, wherein the computer executable instructions, when executed by a computer processor, are used to execute the indicator statistics method as described in any one of the first aspects.

[0028] In a fifth aspect, the present application provides a computer program product, which includes computer instructions. When the computer instructions are executed on a computer, the computer executes the indicator statistics method provided in the first aspect.

[0029] It should be noted that the above computer instructions may be stored in whole or in part on a computer-readable storage medium. The computer-readable storage medium may be packaged together with the processor of the indicator statistics device, or may be packaged separately from the processor of the indicator statistics device, and this application does not limit this.

[0030] The description of the second, third, fourth and fifth aspects in this application can refer to the detailed description of the first aspect; and the beneficial effects of the description of the second, third, fourth and fifth aspects can refer to the beneficial effect analysis of the first aspect, which will not be repeated here.

[0031] In this application, the name of the above-mentioned indicator statistics device does not limit the device or functional module itself. In actual implementation, these devices or functional modules may appear with other names. As long as the functions of each device or functional module are similar to those of this application, they fall within the scope of the claims of this application and their equivalent technologies.

[0032] These and other aspects of the present application will become more apparent from the following description. BRIEF DESCRIPTION OF THE DRAWINGS

[0033] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. 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 creative work.

[0034] Figure 1 A flowchart of an indicator statistics method provided by an embodiment of the present invention;

[0035] Figure 2 A flowchart of another indicator statistics method provided by an embodiment of the present invention;

[0036] Figure 3 A schematic diagram of the structure of an indicator statistics device provided by an embodiment of the present invention;

[0037] Figure 4 A schematic diagram of the structure of an electronic device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0038] The present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It is to be understood that the specific embodiments described herein are only used to explain the present invention, rather than to limit the present invention. It should also be noted that, for ease of description, only parts related to the present invention, rather than all structures, are shown in the accompanying drawings.

[0039] The term "and / or" in this article is merely a description of the association relationship of associated objects, indicating that three relationships may exist. For example, A and / or B can mean: A exists alone, A and B exist at the same time, and B exists alone.

[0040] The terms "first" and "second" and the like in the specification and drawings of this application are used to distinguish different objects, or to distinguish different processing of the same object, rather than to describe a specific order of objects.

[0041] In addition, the terms "including" and "having" and any variations thereof mentioned in the description of the present application are intended to cover non-exclusive inclusions. For example, a process, method, system, product or device that includes a series of steps or units is not limited to the listed steps or units, but may optionally include other steps or units that are not listed, or may optionally include other steps or units that are inherent to these processes, methods, products or devices.

[0042] It should be mentioned before discussing exemplary embodiments in more detail that some exemplary embodiments are described as processes or methods depicted as flow charts. Although the flow charts describe various operations (or steps) as sequential processes, many operations therein can be implemented in parallel, concurrently or simultaneously. In addition, the order of various operations can be rearranged. The process can be terminated when its operation is completed, but can also have additional steps not included in the accompanying drawings. The process can correspond to methods, functions, procedures, subroutines, subprograms, etc. In addition, the embodiments in the present invention and the features in the embodiments can be combined with each other without conflict.

[0043] It should be noted that, in the embodiments of the present application, words such as "exemplary" or "for example" are used to indicate examples, illustrations or descriptions. Any embodiment or design described as "exemplary" or "for example" in the embodiments of the present application should not be interpreted as being more preferred or more advantageous than other embodiments or designs. Specifically, the use of words such as "exemplary" or "for example" is intended to present related concepts in a specific way.

[0044] In the description of the present application, unless otherwise specified, “plurality” means two or more.

[0045] The existing technology has a long period from determining the indicator rules of business indicators to actually realizing indicator statistics. Moreover, when processing multiple indicators on the same data table, the cost required to be invested increases accordingly, resulting in further cost increases.

[0046] Therefore, there is an urgent need for an indicator statistics method to realize the configuration-based generation of indicator rules, improve the flexibility of indicator statistics and reduce the cost of indicator statistics.

[0047] The indicator statistics method provided in this application will be described in detail below with reference to diagrams and examples.

[0048] Figure 1 A flowchart of an indicator statistics method provided by an embodiment of the present invention. This embodiment is applicable to situations where it is necessary to improve the flexibility of indicator statistics while reducing the cost of indicator statistics. The method can be executed by an indicator statistics device, such as Figure 1 As shown, the specific steps include:

[0049] Step 110: Determine the parameters required for performing statistics on the indicators according to the acquired parameter information, and determine the combination relationship between the parameters according to the acquired combination information.

[0050] This solution provides a front-end page that can be dragged by a user. The front-end page includes parameter controls. When the parameters include statistical conditions, statistical dimensions, statistical targets, and statistical methods, the parameter controls include statistical condition controls, statistical dimension controls, statistical target controls, and statistical method controls. In response to the user clicking on the statistical condition controls, statistical dimension controls, statistical target controls, and statistical method controls, the front-end page can determine parameter information. In response to the user dragging the statistical condition controls, statistical dimension controls, statistical target controls, and statistical method controls, the front-end page can determine combination information. Of course, after determining the parameter information and combination information, the front-end page can send the parameter information and combination information to the server.

[0051] Specifically, after receiving the parameter information sent by the front-end page, the statistical conditions, statistical dimensions, statistical targets and statistical methods can be determined according to the operations of the statistical condition controls, statistical dimension controls, statistical target controls and statistical method controls clicked by the user contained in the parameter information, so as to determine the parameters required for the statistics of the indicators. After receiving the combination information sent by the front-end page, the combination relationship between the statistical conditions, statistical dimensions, statistical targets and statistical methods can be determined according to the operations of the statistical condition controls, statistical dimension controls, statistical target controls and statistical method controls dragged by the user contained in the combination information, so as to determine the combination relationship between the parameters required for the statistics of the indicators.

[0052] In the embodiment of the present invention, the parameters required for the statistics of the indicators and the combination relationship between the parameters are determined, the parameters and the combination relationship between the parameters are configured, and the flexibility of the indicator statistics is improved.

[0053] Step 120: Determine the statistical rule of the indicator according to the parameters and the combination relationship between the parameters.

[0054] Specifically, by combining and configuring the parameters based on the combination relationship between the parameters, the statistical logic of the indicator can be determined, that is, the statistical rule of the indicator can be obtained.

[0055] In an embodiment of the present invention, after determining the parameters required for statistics of the indicators and the combination relationship between the parameters, the parameters are combined and configured according to the combination relationship between the parameters to obtain the statistical rules of the indicators, thereby realizing the automatic configuration of the statistical rules of the indicators.

[0056] Step 130: convert the statistical rules into query codes, and execute the query codes on the data to be counted to determine the statistical results of the indicators corresponding to the data to be counted.

[0057] The query code may be determined according to the storage method of the statistical data to be counted. For example, the statistical data to be counted is stored based on a database, and the query code is a code for performing indicator statistics on the statistical data based on the database.

[0058] Specifically, after determining the statistical rules of the indicators, the statistical rules can be input into the rule engine, and the rule engine can convert the statistical rules into codes according to the storage method of the statistical data to be counted, and obtain the query code that can be used to perform indicator statistics on the statistical data to be counted.

[0059] Furthermore, query code can be executed on the data to be counted. It can be understood that query code can be executed on the database storing the data to be counted to perform indicator statistics on the data to be counted, obtain indicator statistical results corresponding to the data to be counted, and realize indicator statistics based on the data to be counted.

[0060] In the embodiment of the present invention, by executing the query code corresponding to the statistical rule on the statistical data to be counted, the indicator statistics of the statistical data to be counted are realized, and the indicator statistical results corresponding to the statistical data to be counted are obtained.

[0061] The indicator statistics method provided by the embodiment of the present invention includes: determining the parameters required for the indicator statistics according to the acquired parameter information, determining the combination relationship between the parameters according to the acquired combination information; determining the statistical rules of the indicator according to the parameters and the combination relationship between the parameters; converting the statistical rules into query codes, and executing the query codes on the statistical data to be counted to determine the indicator statistical results corresponding to the statistical data to be counted. The above technical scheme can first determine the parameters required for the indicator statistics and the combination relationship between the parameters according to the parameter information and combination information determined by the user clicking and dragging the statistical condition control, the statistical dimension control, the statistical target control and the statistical method control in the front-end page, so as to configure the parameters and the combination relationship between the parameters; secondly, the parameters can be combined and configured according to the combination relationship between the parameters to obtain the statistical rules of the indicators, so as to realize the flexible configuration of the statistical rules of the indicators and improve the flexibility of the indicator statistics; and then the statistical rules can be converted into query codes, and the query codes corresponding to the statistical rules can be executed on the statistical data to realize the indicator statistics of the statistical data to be counted, and the indicator statistical results corresponding to the statistical data to be counted can be obtained, so as to reduce the cycle and cost of the indicator statistics.

[0062] Figure 2 This is a flow chart of another indicator statistics method provided by an embodiment of the present invention. This embodiment is specific based on the above embodiment. Figure 2 As shown, in this embodiment, the method may further include:

[0063] Step 210: Synchronize the data to be counted to the analysis database based on pre-configured data synchronization rules.

[0064] The analysis database may be ClickHouse.

[0065] The data synchronization rules may include a table of data to be counted, fields to be counted in the table of data to be counted, and a target database. The data synchronization rules may determine the data to be counted and the storage method of the data to be counted. For example, if the data synchronization rule is to synchronize the data to be counted to an analysis database, it may be determined that the storage method of the data to be counted is based on the analysis database.

[0066] Specifically, the data to be counted can be first determined according to the pre-configured data synchronization rules. Specifically, the data table to be counted and the fields to be counted in the data table to be counted can be determined to determine the data to be counted. Of course, the target database can also be determined. For example, the target database can be determined to be an analysis database.

[0067] Furthermore, the data to be counted can be synchronized to the analysis database.

[0068] In actual applications, you can also configure a scheduled task to automatically synchronize the fields to be counted in the table to be counted to the analysis database at preset intervals. For a data table, after synchronizing the data table to the analysis database, you can determine at least one indicator statistical result corresponding to the data table. Of course, as the data table is updated, the statistical results of each indicator will also be updated.

[0069] In the embodiment of the present invention, the data to be counted are synchronized to the analysis database based on pre-configured data synchronization rules, thereby achieving standardized storage of the data to be counted.

[0070] Step 220: Determine the parameters required for performing statistics on the indicators according to the acquired parameter information, and determine the combination relationship between the parameters according to the acquired combination information.

[0071] The parameter information is determined according to the control clicked by the user on the front-end page, and the combination information is determined according to the dragging operation of the clicked control by the user on the front-end page.

[0072] Parameters include statistical conditions, statistical dimensions, statistical targets and statistical methods. Statistical conditions can be channels, transaction types, etc. Statistical dimensions can be regions, channels, payment methods, customer types, etc. Statistical targets can be amounts, number of transactions, etc. Statistical methods can be summation, average, maximum / minimum, number of transactions, etc. In actual applications, parameters also support on-demand input, making parameter configuration more dynamic and flexible.

[0073] The parameter controls on the front-end page include statistical condition controls, statistical dimension controls, statistical target controls, and statistical method controls. Users can select statistical conditions by clicking on the statistical condition controls, select statistical dimensions by clicking on the statistical dimension controls, select statistical targets by clicking on the statistical target controls, and select statistical methods by clicking on the statistical method controls. The statistical conditions, statistical dimensions, statistical targets, and statistical methods selected by users can constitute parameter information, and the parameter information can be determined by users clicking on the controls on the front-end page.

[0074] Users can drag controls to determine the association between controls, and then determine the combination relationship between statistical conditions, statistical dimensions, statistical targets and statistical methods. Users can determine the combination information by dragging controls on the front-end page.

[0075] After determining the parameter information and the combination information, the front-end page can send the parameter information and the combination information to the server. After receiving the parameter information sent by the front-end page, the server can determine the statistical conditions, statistical dimensions, statistical targets and statistical methods according to the statistical conditions, statistical dimensions, statistical targets and statistical methods contained in the parameter information, so as to determine the parameters required for statistical analysis of the indicators. After receiving the combination information sent by the front-end page, the combination relationship between the statistical conditions, statistical dimensions, statistical targets and statistical methods can be determined according to the correlation relationship between the statistical conditions, statistical dimensions, statistical targets and statistical methods contained in the combination information, so as to determine the combination relationship between the parameters required for statistical analysis of the indicators.

[0076] In the embodiment of the present invention, the parameters required for the statistics of the indicators and the combination relationship between the parameters are determined, the parameters and the combination relationship between the parameters are configured, and the flexibility of the indicator statistics is improved.

[0077] Step 230: Determine the statistical rule of the indicator according to the parameters and the combination relationship between the parameters.

[0078] In one implementation, step 230 may specifically include:

[0079] The parameters are combined according to the combination relationship between the parameters to obtain the statistical rule of the indicator.

[0080] Specifically, by combining and configuring the parameters based on the combination relationship between the parameters, the statistical logic of the indicator can be determined, that is, the statistical rule of the indicator can be obtained.

[0081] For example, the statistical data to be collected is a consumption details table, and the indicator is the total transaction amount that occurs through the mobile phone channel every day, and the distribution in each region is analyzed. Therefore, the transaction amount can be configured as the statistical target, the daily summation can be configured as the statistical method, the region can be configured as the statistical dimension, and the mobile phone channel can be configured as the statistical condition. By combining the configured statistical conditions, statistical dimensions, statistical targets, and statistical methods, the indicator rule for the indicator statistics of the consumption details table can be determined as follows: sum up the transaction amount of the mobile phone channel in each region in the consumption details table every day.

[0082] In an embodiment of the present invention, after determining the parameters required for statistics of the indicators and the combination relationship between the parameters, the parameters are combined and configured according to the combination relationship between the parameters to obtain the statistical rules of the indicators, thereby realizing the automatic configuration of the statistical rules of the indicators.

[0083] Step 240: convert the statistical rules into query codes, and execute the query codes on the data to be counted to determine the statistical results of the indicators corresponding to the data to be counted.

[0084] When the analysis database is ClickHouse, the query code can be SQL supported by ClickHouse.

[0085] In one implementation, step 240 may specifically include:

[0086] The statistical rules are converted into query statements supported by the analysis database; the query statements are executed based on the analysis database to obtain the indicator statistical results corresponding to the statistical data to be counted.

[0087] Specifically, after determining the statistical rules of the indicators, the statistical rules can be input into the rule engine, and the rule engine can automatically convert the statistical rules into templated SQL supported by ClickHouse. For example, it can be determined that the corresponding SQL for summing up the transaction amount of mobile phone channels in each region every day in the consumption details table is: select sum (transaction amount) from transaction details table where transaction channel = mobile phone and transaction date = {tradedate}, select region, or, sum (transaction amount) from transaction details table where transaction channel = mobile phone and transaction date = {tradedate} group by region. Among them, {tradedate} is a template parameter. After each preset time period, the template parameter will be automatically updated to the latest data log after the statistical data is updated.

[0088] Of course, the query code corresponding to the indicator rule can be solidified into a reusable SQL, and the SQL can be recorded in the database for archiving.

[0089] In addition, a server with a built-in ClickHouse online analysis engine can execute the aforementioned SQL in ClickHouse to obtain the indicator statistical results corresponding to the data to be counted, that is, the total transaction amount of mobile phone channels in each region per day corresponding to the consumption details table can be obtained. The indicator statistical results corresponding to the data to be counted determined by executing SQL can be stored in the local database for subsequent indicator analysis.

[0090] In the embodiment of the present invention, by executing the query code corresponding to the statistical rule on the statistical data to be counted, the indicator statistics of the statistical data to be counted are realized, and the indicator statistical results corresponding to the statistical data to be counted are obtained.

[0091] The indicator statistics method provided by an embodiment of the present invention includes: synchronizing the data to be counted to an analysis database based on pre-configured data synchronization rules; determining the parameters required for statistics of the indicators based on the acquired parameter information, and determining the combination relationship between each of the parameters based on the acquired combination information; determining the statistical rules of the indicators based on each of the parameters and the combination relationship between each of the parameters; converting the statistical rules into query codes, and executing the query codes on the data to be counted to determine the indicator statistical results corresponding to the data to be counted. The above technical scheme can first determine the data to be counted based on the pre-configured data synchronization rules and synchronize the data to the analysis database to realize the standardized storage of the statistical data. Secondly, it can determine the parameters required for statistics of the indicators and the combination relationship between the parameters according to the parameter information and combination information determined by the user clicking and dragging the statistical condition controls, statistical dimension controls, statistical target controls and statistical method controls in the front-end page, so as to realize the configuration of the parameters and the combination relationship between the parameters. Then, the parameters can be combined and configured according to the combination relationship between the parameters to obtain the statistical rules of the indicators, realize the flexible configuration of the statistical rules of the indicators, and improve the flexibility of indicator statistics. Then, the statistical rules can be converted into query codes. By executing the query codes corresponding to the statistical rules on the analysis database storing the data to be counted, the indicator statistics of the statistical data can be realized, and the indicator statistical results corresponding to the data to be counted can be obtained, thereby reducing the cycle and cost of indicator statistics.

[0092] In addition, the configuration of the statistical rules of the indicators can be adjusted as needed, further improving the flexibility of indicator statistics. Moreover, the configuration adjustment of the statistical rules of the indicators does not require the production of a new version, and is immediately visible and available, reducing the configuration adjustment cost of the statistical rules of the indicators. In addition, this solution supports the processing of multiple indicators on the same data table, and the cost is almost unchanged.

[0093] Figure 3This is a schematic diagram of the structure of an indicator statistics device provided by an embodiment of the present invention, which can be used to improve the flexibility of indicator statistics while reducing the cost of indicator statistics. The device can be implemented by software and / or hardware and is generally integrated in an electronic device, such as a computer device.

[0094] like Figure 3 As shown, the device comprises:

[0095] A first determination module 310 is used to determine the parameters required for performing statistics on the indicator according to the acquired parameter information, and to determine the combination relationship between the parameters according to the acquired combination information;

[0096] A second determination module 320, configured to determine a statistical rule of the indicator according to the parameters and a combination relationship between the parameters;

[0097] The execution module 330 is used to convert the statistical rules into query codes, and execute the query codes on the data to be counted to determine the indicator statistical results corresponding to the data to be counted.

[0098] The indicator statistics device provided in this embodiment determines the parameters required for the indicator statistics according to the acquired parameter information, determines the combination relationship between the parameters according to the acquired combination information; determines the statistical rules of the indicator according to the parameters and the combination relationship between the parameters; converts the statistical rules into query codes, and executes the query codes on the statistical data to be counted to determine the indicator statistical results corresponding to the statistical data to be counted. The above technical scheme can first determine the parameters required for the indicator statistics and the combination relationship between the parameters according to the parameter information and combination information determined by the user clicking and dragging the statistical condition control, statistical dimension control, statistical target control and statistical method control in the front-end page, and realize the configuration of the parameters and the combination relationship between the parameters; secondly, the parameters can be combined and configured according to the combination relationship between the parameters to obtain the statistical rules of the indicator, realize the flexible configuration of the statistical rules of the indicator, and improve the flexibility of indicator statistics, and then the statistical rules can be converted into query codes, and the query codes corresponding to the statistical rules are executed on the statistical data to realize the indicator statistics of the statistical data to be counted, and the indicator statistical results corresponding to the statistical data to be counted are obtained, thereby reducing the cycle and cost of indicator statistics.

[0099] In one implementation, the parameter information is determined based on a control clicked by a user on a front-end page, and the combination information is determined based on a dragging operation performed by the user on the clicked control on the front-end page.

[0100] In one implementation, the parameters include at least statistical conditions, statistical dimensions, statistical targets and statistical methods.

[0101] Based on the above embodiment, the second determining module 320 is specifically configured to:

[0102] The parameters are combined according to the combination relationship between the parameters to obtain the statistical rule of the indicator.

[0103] Based on the above embodiment, the device further includes:

[0104] The synchronization module is used to synchronize the data to be counted to the analysis database based on pre-configured data synchronization rules.

[0105] Based on the above embodiment, the execution module 330 is specifically used for:

[0106] The statistical rules are converted into query statements supported by the analysis database; the query statements are executed based on the analysis database to obtain the indicator statistical results corresponding to the statistical data to be counted.

[0107] The indicator statistics device provided in the embodiment of the present invention can execute the indicator statistics method provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of executing the indicator statistics method.

[0108] It is worth noting that in the embodiment of the above-mentioned indicator statistics device, the various units and modules included are only divided according to functional logic, but are not limited to the above-mentioned division, as long as the corresponding functions can be achieved; in addition, the specific names of the functional units are only for the convenience of distinguishing each other, and are not used to limit the scope of protection of the present invention.

[0109] Figure 4 A schematic diagram of the structure of an electronic device provided by an embodiment of the present invention. Figure 4 A block diagram of an exemplary electronic device 4 suitable for implementing embodiments of the present invention is shown. Figure 4 The electronic device 4 shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.

[0110] like Figure 4 As shown, the electronic device 4 is in the form of a general purpose computing electronic device. The components of the electronic device 4 may include, but are not limited to: one or more processors or processing units 16, a system memory 28, and a bus 18 connecting different system components (including the system memory 28 and the processing unit 16).

[0111] Bus 18 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, a processor or a local bus using any of a variety of bus architectures. By way of example, these architectures include, but are not limited to, an Industry Standard Architecture (ISA) bus, a Micro Channel Architecture (MAC) bus, an Enhanced ISA bus, a Video Electronics Standards Association (VESA) local bus, and a Peripheral Component Interconnect (PCI) bus.

[0112] The electronic device 4 typically includes a variety of computer system readable media. These media can be any available media that can be accessed by the electronic device 4, including volatile and non-volatile media, removable and non-removable media.

[0113] The system memory 28 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 30 and / or cache memory 32. The electronic device 4 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, the storage system 34 may be used to read and write non-removable, non-volatile magnetic media ( Figure 4 not shown, usually called a "hard drive"). Although Figure 4 Not shown in the figure, a disk drive for reading and writing to a removable non-volatile disk (e.g., a "floppy disk"), and an optical disk drive for reading and writing to a removable non-volatile optical disk (e.g., a CD-ROM, a DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to the bus 18 via one or more data medium interfaces. The system memory 28 may include at least one program product having a set (e.g., at least one) of program modules that are configured to perform the functions of the various embodiments of the present invention.

[0114] A program / utility 40 having a set (at least one) of program modules 42 may be stored, for example, in system memory 28, such program modules 42 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which or some combination may include an implementation of a network environment. Program modules 42 generally perform the functions and / or methods of the embodiments described herein.

[0115] The electronic device 4 may also communicate with one or more external devices 14 (e.g., keyboards, pointing devices, displays 24, etc.), one or more devices that enable a user to interact with the electronic device 4, and / or any device that enables the electronic device 4 to communicate with one or more other computing devices (e.g., network cards, modems, etc.). Such communication may be performed via an input / output (I / O) interface 22. Furthermore, the electronic device 4 may also communicate with one or more networks (e.g., a local area network (LAN), a wide area network (WAN), and / or a public network, such as the Internet) via a network adapter 20. Figure 4 As shown, the network adapter 20 communicates with other modules of the electronic device 4 via the bus 18. It should be understood that although Figure 4 Not shown, other hardware and / or software modules may be used in conjunction with the electronic device 4, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.

[0116] The processing unit 16 executes various functional applications and page displays by running the programs stored in the system memory 28, for example, implementing the indicator statistics method provided in the embodiment of the present invention, which includes:

[0117] Determine the parameters required for the statistics of the indicators according to the acquired parameter information, and determine the combination relationship between the parameters according to the acquired combination information;

[0118] Determine the statistical rules of the indicator according to the parameters and the combination relationship between the parameters;

[0119] The statistical rules are converted into query codes, and the query codes are executed on the statistical data to be counted to determine the indicator statistical results corresponding to the statistical data to be counted.

[0120] Of course, those skilled in the art can understand that the processor can also implement the technical solution of the indicator statistics method provided by any embodiment of the present invention.

[0121] An embodiment of the present invention provides a computer-readable storage medium on which a computer program is stored. When the program is executed by a processor, for example, an indicator statistics method provided by an embodiment of the present invention is implemented. The method includes:

[0122] Determine the parameters required for the statistics of the indicators according to the acquired parameter information, and determine the combination relationship between the parameters according to the acquired combination information;

[0123] Determine the statistical rules of the indicator according to the parameters and the combination relationship between the parameters;

[0124] The statistical rules are converted into query codes, and the query codes are executed on the statistical data to be counted to determine the indicator statistical results corresponding to the statistical data to be counted.

[0125] The computer storage medium of the embodiment of the present invention can adopt any combination of one or more computer-readable media. The computer-readable medium can be a computer-readable signal medium or a computer-readable storage medium. The computer-readable storage medium can be, for example, but not limited to: an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples (non-exhaustive list) of computer-readable storage media include: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In this document, a computer-readable storage medium can be any tangible medium containing or storing a program, which can be used by an instruction execution system, device or device or used in combination with it.

[0126] Computer-readable signal media may include data signals propagated in baseband or as part of a carrier wave, which carry computer-readable program code. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. Computer-readable signal media may also be any computer-readable medium other than a computer-readable storage medium, which may send, propagate, or transmit a program for use by or in conjunction with an instruction execution system, apparatus, or device.

[0127] The program code embodied on the computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

[0128] Computer program code for performing the operations of the present invention may be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, C++, and conventional procedural programming languages ​​such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0129] It should be understood by those skilled in the art that the modules or steps of the present invention described above can be implemented by a general-purpose computing device, they can be concentrated on a single computing device, or distributed on a network composed of multiple computing devices, optionally, they can be implemented by a program code executable by a computer device, so that they can be stored in a storage device and executed by the computing device, or they can be made into individual integrated circuit modules, or multiple modules or steps therein can be made into a single integrated circuit module for implementation. Thus, the present invention is not limited to any specific combination of hardware and software.

[0130] In addition, the acquisition, storage, use, and processing of data in the technical solution of the present invention are in compliance with the relevant provisions of national laws and regulations.

[0131] Note that the above are only preferred embodiments of the present invention and the technical principles used. Those skilled in the art will understand that the present invention is not limited to the specific embodiments herein, and that various obvious changes, readjustments and substitutions can be made by those skilled in the art without departing from the scope of protection of the present invention. Therefore, although the present invention has been described in more detail through the above embodiments, the present invention is not limited to the above embodiments, and may include more other equivalent embodiments without departing from the concept of the present invention, and the scope of the present invention is determined by the scope of the appended claims.

Claims

1. An indicator statistical method, characterized in that: include: Determine the parameters required for the statistics of the indicators according to the acquired parameter information, and determine the combination relationship between the parameters according to the acquired combination information; Determine the statistical rules of the indicator according to the parameters and the combination relationship between the parameters; The statistical rules are converted into query codes, and the query codes are executed on the statistical data to be counted to determine the indicator statistical results corresponding to the statistical data to be counted.

2. The index statistical method according to claim 1, characterized in that: The parameter information is determined according to the control clicked by the user on the front-end page, and the combination information is determined according to the dragging operation of the user on the clicked control on the front-end page.

3. The index statistical method according to claim 1, characterized in that: The parameters include at least statistical conditions, statistical dimensions, statistical targets and statistical methods.

4. The index statistical method according to claim 1, characterized in that: The statistical rules of the indicators are determined according to the parameters and the combination relationship between the parameters, including: The parameters are combined according to the combination relationship between the parameters to obtain the statistical rule of the indicator.

5. The index statistical method according to claim 1, characterized in that: Also includes: Synchronize the pending statistical data to the analysis database based on pre-configured data synchronization rules.

6. The index statistical method according to claim 5, characterized in that: Converting the statistical rules into query codes, and executing the query codes on the data to be counted to determine the statistical results of the indicators corresponding to the data to be counted, including: Converting the statistical rules into query statements supported by the analysis database; The query statement is executed based on the analysis database to obtain the indicator statistical results corresponding to the statistical data to be counted.

7. An indicator statistics device, characterized in that: include: A first determination module is used to determine the parameters required for performing statistics on the indicator according to the acquired parameter information, and to determine the combination relationship between the parameters according to the acquired combination information; A second determination module is used to determine the statistical rules of the indicator according to the parameters and the combination relationship between the parameters; The execution module is used to convert the statistical rules into query codes and execute the query codes on the statistical data to be counted to determine the indicator statistical results corresponding to the statistical data to be counted.

8. An electronic device, characterized in that: The electronic device comprises: at least one processor; and a memory communicatively coupled to the at least one processor; The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the indicator statistics method as described in any one of claims 1 to 6.

9. A storage medium containing computer executable instructions, characterized in that: The computer executable instructions are used to execute the indicator statistics method as described in any one of claims 1 to 6 when executed by a computer processor.

10. A computer program product, characterized in that The computer program product comprises a computer program, and when the computer program is executed by a processor, the computer program implements the indicator statistics method according to any one of claims 1 to 6.

Images