CN117851409A - Progress data statistics method, device, equipment, storage medium and program product - Google Patents
Progress data statistics method, device, equipment, storage medium and program product Download PDFInfo
- Publication number
- CN117851409A CN117851409A CN202410052648.7A CN202410052648A CN117851409A CN 117851409 A CN117851409 A CN 117851409A CN 202410052648 A CN202410052648 A CN 202410052648A CN 117851409 A CN117851409 A CN 117851409A
- Authority
- CN
- China
- Prior art keywords
- index
- target
- progress
- value
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 78
- 238000004364 calculation method Methods 0.000 claims abstract description 14
- 238000012545 processing Methods 0.000 claims description 76
- 238000004422 calculation algorithm Methods 0.000 claims description 20
- 238000004590 computer program Methods 0.000 claims description 13
- 230000008030 elimination Effects 0.000 claims description 3
- 238000003379 elimination reaction Methods 0.000 claims description 3
- 238000011161 development Methods 0.000 abstract description 8
- 230000007246 mechanism Effects 0.000 description 18
- 230000008569 process Effects 0.000 description 10
- 230000006870 function Effects 0.000 description 9
- 238000010586 diagram Methods 0.000 description 5
- 238000012423 maintenance Methods 0.000 description 5
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000003247 decreasing effect Effects 0.000 description 3
- 238000013461 design Methods 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- 230000003190 augmentative effect Effects 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000012937 correction Methods 0.000 description 2
- 238000007405 data analysis Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 239000013589 supplement Substances 0.000 description 2
- 230000001502 supplementing effect Effects 0.000 description 2
- 230000005856 abnormality Effects 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 230000001419 dependent effect Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000000802 evaporation-induced self-assembly Methods 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000007619 statistical method Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000001356 surgical procedure Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/08—Insurance
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- General Engineering & Computer Science (AREA)
- General Business, Economics & Management (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Technology Law (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Development Economics (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The application provides a progress data statistics method, a device, equipment, a storage medium and a program product, wherein the method comprises the following steps: acquiring a target table and an index table of various service indexes; aiming at each service index, carrying out de-duplication and merging treatment on the data in the target table and the index table corresponding to the service index based on the index main body to obtain a summary table; each index body in the summary table corresponds to a target value, a target initial value and a current index value; calculating a first difference value between the current value of the index and the target initial value and a second difference value between the target value and the target initial value; and determining the index progress in the preset time based on the first difference value and the second difference value, so as to count the index progress corresponding to the various business indexes, and obtaining a progress statistics table. Therefore, by the method, index progress statistics of various service indexes can be realized, development workload and system resource expenditure are reduced, and the application range of index progress calculation is increased.
Description
Technical Field
The present disclosure relates to the field of data analysis technologies, and in particular, to a progress data statistics method, apparatus, device, storage medium, and program product.
Background
The insurance industry refers to the industry that will collect funds in contractual form to compensate for the economic benefit of the insured. There are many needs in the insurance industry for some metrics to be statistically progress, such as the completion of premium goals.
In the prior art, a special progress statistics program is required to be developed aiming at different business indexes, and then the progress of different indexes is counted by the progress statistics program.
However, when the index progress is counted, a plurality of special counting programs are needed, and consistency among each counting program is lacked, so that the workload of operation maintenance, development and adjustment is large, and the system resource overhead is increased.
Disclosure of Invention
The application provides a progress data statistics method, device, equipment, storage medium and program product, which are used for solving the problems that when index progress statistics is carried out in the prior art, a plurality of special statistics programs are needed, consistency is lacking among each statistics program, so that the workload of operation maintenance and development adjustment is large, and the system resource overhead is increased.
In a first aspect, the present application provides a method for counting progress data, the method comprising:
acquiring a target table and an index table of various service indexes; the target table is used for storing target values and target initial values corresponding to different index main bodies in preset time; the index table is used for storing the current values of indexes corresponding to different index main bodies in preset time;
aiming at each service index, carrying out de-duplication and merging processing on the data in a target table and an index table corresponding to the service index based on the index main body to obtain a summary table; each index body in the summary table corresponds to a target value, a target initial value and a current index value;
calculating a first difference between the current value of the index and the target initial value, and a second difference between the target value and the target initial value;
and determining the index progress in preset time based on the first difference value and the second difference value, so as to count the index progress corresponding to the multiple business indexes, and obtaining a progress statistics table.
Optionally, performing duplication removal and merging processing on the data in the target table and the index table corresponding to the service index based on the index main body to obtain a summary table, where the summary table includes:
Judging whether missing data exists in the target table and the data in the index table corresponding to the service index;
if yes, compensating the missing data in the target table and/or the index table based on a predefined numerical value, and performing duplication removal and merging processing on the compensated data in the target table and the index table based on an index main body to obtain a summary table;
if not, carrying out duplication elimination processing on the target table and the data in the index table based on the index main body, and carrying out combination processing on the duplicated data in the target table and the duplicated data in the index table to obtain a summary table.
Optionally, compensating the missing data in the target table and/or the index table based on a predefined value includes:
when determining that missing data exists in the target table, acquiring a predefined value based on an index main body in the index table, and performing compensation processing on the missing data in the target table based on the predefined value;
and/or when determining that the missing data exists in the index table, acquiring a predefined value based on the index body in the target table, and performing compensation processing on the missing data in the index table based on the predefined value.
Optionally, determining the indicator progress within the preset time based on the first difference value and the second difference value includes:
and calculating the index progress in the preset time based on the first difference value and the second difference value by using a predefined algorithm.
Optionally, calculating, by using a predefined algorithm, an indicator progress within a preset time based on the first difference value and the second difference value, including:
and calculating the ratio of the first difference value to the second difference value to obtain the index progress in the preset time.
Optionally, the method for obtaining the target table and the index table of the multiple service indexes includes:
and obtaining a target table and an index table of various service indexes by utilizing a parallel processing mode so as to determine the index progress of each service index in preset time.
Optionally, the method further comprises:
visually displaying the progress statistics table, and acquiring the progress of manually calculating indexes to be compared of the multiple service indexes;
comparing the to-be-compared index progress with the index progress in the progress statistics table to verify whether the index progress is consistent with the to-be-compared index progress or not;
and when the index progress is determined to be inconsistent with the index progress to be compared, correcting the index progress in the progress statistics table based on the index progress to be compared.
In a second aspect, the present application further provides a progress data statistics apparatus, the apparatus comprising:
the acquisition module is used for acquiring a target table and an index table of various service indexes; the target table is used for storing target values and target initial values corresponding to different index main bodies in preset time; the index table is used for storing the current values of indexes corresponding to different index main bodies in preset time;
the processing module is used for carrying out de-duplication and merging processing on the target table corresponding to the service index and the data in the index table according to each service index based on the index main body to obtain a summary table; each index body in the summary table corresponds to a target value, a target initial value and a current index value;
the calculation module is used for calculating a first difference value between the current index value and the target initial value and a second difference value between the target value and the target initial value;
and the statistics module is used for determining the index progress in the preset time based on the first difference value and the second difference value so as to count the index progress corresponding to the multiple business indexes and obtain a progress statistics table.
In a third aspect, the present application further provides an electronic device, including: a processor, and a memory communicatively coupled to the processor;
The memory stores computer-executable instructions;
the processor executes computer-executable instructions stored by the memory to implement the method of any one of the first aspects.
In a fourth aspect, the present application also provides a computer-readable storage medium storing computer-executable instructions for implementing the method according to any one of the first aspects when executed by a processor.
In a fifth aspect, the present application also provides a computer program product comprising a computer program which, when executed by a processor, implements the method according to any of the first aspects.
In summary, the present application provides a method, an apparatus, a device, a storage medium, and a program product for counting progress data, where a target value, a target starting value, and a target current value corresponding to the target body of different service indexes can be obtained by combining the target table and the target body in the target table, and combining the target value and the target value, further, a first difference value between the target current value and the target starting value, and a second difference value between the target value and the target starting value are calculated, and further, the progress of the target is calculated based on the first difference value and the second difference value, so that regardless of whether the target value is a positive number, 0, or a negative number, the progress of the target is calculated from low to high, and regardless of whether the process of achieving the target by the service indexes is from high to low, the progress of the target is calculated by using the first difference value and the second difference value. Therefore, the method can be generally used for the progress statistics of all business indexes, is easy to operate and maintain, can realize the index progress statistics of various business indexes only by the method, reduces the development workload and the system resource expenditure, and increases the application range of index progress calculation.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the application and together with the description, serve to explain the principles of the application.
Fig. 1 is a schematic view of an application scenario provided in an embodiment of the present application;
fig. 2 is a flow chart of a progress data statistics method according to an embodiment of the present application;
FIG. 3 is a flowchart of an alternative method for statistics of progress data according to an embodiment of the present application;
fig. 4 is a schematic structural diagram of a progress data statistics device according to an embodiment of the present application;
fig. 5 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Specific embodiments thereof have been shown by way of example in the drawings and will herein be described in more detail. These drawings and the written description are not intended to limit the scope of the inventive concepts in any way, but to illustrate the concepts of the present application to those skilled in the art by reference to specific embodiments.
Detailed Description
In order to clearly describe the technical solutions of the embodiments of the present application, in the embodiments of the present application, the words "first", "second", etc. are used to distinguish the same item or similar items having substantially the same function and effect. For example, the first device and the second device are merely for distinguishing between different devices, and are not limited in their order of precedence. It will be appreciated by those of skill in the art that the words "first," "second," and the like do not limit the amount and order of execution, and that the words "first," "second," and the like do not necessarily differ.
In this application, the terms "exemplary" or "such as" are used to mean serving as an example, instance, or illustration. Any embodiment or design described herein as "exemplary" or "for example" should not be construed as preferred or advantageous over other embodiments or designs. Rather, the use of words such as "exemplary" or "such as" is intended to present related concepts in a concrete fashion.
In the present application, "at least one" means one or more, and "a plurality" means two or more. "and/or", describes an association relationship of an association object, and indicates that there may be three relationships, for example, a and/or B, and may indicate: a alone, a and B together, and B alone, wherein a, B may be singular or plural. The character "/" generally indicates that the context-dependent object is an "or" relationship. "at least one of" or the like means any combination of these items, including any combination of single item(s) or plural items(s). For example, at least one (one) of a, b, or c may represent: a, b, c, a-b, a-c, b-c, or a-b-c, wherein a, b, c may be single or plural.
In the technical scheme of the application, the processing of collecting, storing, using, processing, transmitting, providing, disclosing and the like of the related information such as financial data or user data accords with the regulations of related laws and regulations and does not violate the popular regulations.
In data analysis work, it is often necessary to count the progress of certain business indexes, i.e., the ratio of the current value of the index to the target value, for example, the rate of completion of the premium target.
In one possible implementation manner, a special progress statistics program is required to be developed aiming at different business indexes, and then the progress of the different business indexes is counted by the progress statistics program; the formula for calculating the progress is as follows: progress = indicator current value/target value.
However, when the index progress is counted, a plurality of special counting programs are needed, and consistency among each counting program is lacked, so that the workload of operation maintenance, development and adjustment is large, and the system resource overhead is increased.
For example, a plurality of special statistics programs commonly developed are difficult to be commonly used for all business indexes, and optionally, the special statistics programs can be used for statistics of indexes with target values of positive numbers, such as 1000 ten thousand yuan for premium targets, but cannot be used for statistics of indexes with target values of 0 or negative numbers, such as during the period that personal consumption loans guarantee insurance stops new business, only historical business is subjected to batch reduction and batch withdrawal, and the indexes are 100 ten thousand yuan for premium targets.
Moreover, the process of requiring the business index to achieve the goal is a process of increasing from 0 to the goal value, such as a process of increasing the premium from 0 to the goal 1000 ten thousand yuan, and cannot be a process of decreasing from above the goal value to the goal value, such as a process of decreasing the rate to be collected from 20% to the goal 5%, and decreasing the odds from 80% to the goal 60%.
When the progress statistics of a plurality of business indexes is performed on the massive data, different progress statistics programs need to be executed multiple times, so that the system resource overhead is increased.
Since the progress refers to the proportion of the distance travelled to the whole distance, the formula based on the calculated progress is: a progress = distance travelled/distance travelled = (current point-start)/(end-start) the progress calculation formula for the index can be derived, which is: index progress= (index current value-target start value)/(target value-target start value).
Aiming at the problems and the considerations, the application provides a progress data statistics method, which can obtain target values, target initial values and target current values corresponding to indexes of different service indexes by combining target tables, index main bodies in the target tables and combining target values and index values, further, calculate a first difference value between the target current values and the target initial values and a second difference value between the target values and the target initial values, and further calculate the progress of the indexes based on the first difference value and the second difference value, so that the progress of the indexes is calculated according to whether the target values are positive numbers, 0 numbers or negative numbers, and whether the progress of the indexes reaches the targets is from low to high or from high to low, and the progress of the indexes calculated by using the first difference value and the second difference value is the correct value, so that reasonable progress of the indexes can be calculated. Therefore, the method can be generally used for the progress statistics of all business indexes, is easy to operate and maintain, can realize the index progress statistics of various business indexes only by the method, reduces the development workload and the system resource expenditure, and increases the application range of index progress calculation.
Embodiments of the present application are described below with reference to the accompanying drawings. Fig. 1 is a schematic view of an application scenario provided in an embodiment of the present application, and the method for statistics of progress data provided in the present application may be applied to the application scenario shown in fig. 1. Taking the application in the security industry as an example, the application scenario comprises: a first insurance mechanism 101, a second insurance mechanism 102, a data processing system 103 and a user's terminal device 104; wherein the first safety mechanism 101 and the second safety mechanism 102 are distributed in different markets.
Taking a business index as an example of a vehicle insurance premium, if it is desired to count the vehicle insurance premium for a certain year, the data processing system 103 may obtain the target vehicle insurance premium to be achieved for the year, the initial vehicle insurance premium for the year, and the current vehicle insurance premium to be achieved up to the present.
Further, for each insurance mechanism, the progress of the insurance premium of each insurance mechanism may be calculated, or the progress of the insurance premium collected by all mechanisms may be counted, for example, the progress of the insurance premium of the first insurance mechanism 101 in the year may be calculated, by calculating a first difference value between the current insurance premium and the initial insurance premium, and a second difference value between the target insurance premium and the initial insurance premium, and calculating the progress of the year by using the first difference value and the second difference value.
Alternatively, the formula may be: the schedule = first difference/second difference, the schedule of the year is calculated, or the schedule of the year may be calculated based on the first difference and the second difference by other algorithms, which are not specifically limited in the embodiment of the present application.
It will be appreciated that if the schedule of the insurance premium of the second insurance organization 102 in the year is calculated, the processing is similar to that described above, and will not be repeated here. If the progress of the insurance policy after the total insurance policy of all institutions is calculated, the local municipalities are used as index main bodies, the target insurance policy, the initial insurance policy and the current insurance policy which are realized at present and are achieved by the insurance institution of each local municipality in the business index of the insurance policy are combined, and the progress of the year is calculated by using the similar processing procedures, so that the progress of the insurance institution of each local municipality is counted.
Optionally, if the same insurance mechanism corresponds to different service indexes, the progress of the insurance mechanism in the same city or the total progress of the insurance mechanisms in different cities corresponding to each service index may be calculated by using the similar method for each service index.
It should be noted that, the vehicle insurance premium is an index whose target value is positive or 0, and the method of the present application may also be applied to a scenario in which the target value is negative, and the business index reaches the target from low to high or from high to low, for example, the business index is a personal loan guarantee premium, and the personal loan guarantee premium may be negative, for example, the target value of the personal loan guarantee premium is-500000 yuan; the above case may also apply to the method of the present application for calculating progress.
It should be noted that, in the embodiment of the present application, the number and the distribution area of the insurance mechanisms for performing progress statistics are not specifically limited, and the above is merely an example.
Optionally, after the progress of the insurance mechanism is obtained, the progress may be sent to the terminal device 104 of the user for visual display, or may be directly displayed on the display device of the data processing system 103, which is not specifically limited in the embodiment of the present application.
The Terminal device may be various electronic devices having a display screen and supporting web browsing, and may also be referred to as a Terminal (Terminal), a User Equipment (UE), a Mobile Station (MS), a Mobile Terminal (MT), and the like. The terminal device may be a mobile phone, a smart television, a wearable device, a smart speaker, a smart security device, a smart gateway, a tablet computer (Pad), a computer with wireless transceiving function, a Virtual Reality (VR) terminal device, an augmented Reality (Augmented Reality, AR) terminal device, a wireless terminal in industrial control (industrial control), a wireless terminal in self-driving (self-driving), a wireless terminal in teleoperation (remote medical surgery), a wireless terminal in smart grid (smart grid), a wireless terminal in transportation security (transportation safety), a wireless terminal in smart city (smart city), a wireless terminal in smart home (smart home), etc. Such terminal devices include, but are not limited to, smartphones, tablet computers, laptop portable computers, desktop computers, and the like.
It should be noted that, the progress data statistics method provided in the present application may be applied to application scenarios related to progress statistics, such as finance, medical treatment, endowment, resource, and the like, besides the application scenarios described above, and the specific application scenario applicable to the present application embodiment is not limited.
The following describes the technical solution of the present application and how the technical solution of the present application solves the above technical problems in detail with specific embodiments. The following embodiments may be combined with each other, and the same or similar concepts or processes may not be described in detail in some embodiments. Embodiments of the present application will be described below with reference to the accompanying drawings.
Based on the application scenario shown in fig. 1, the embodiment of the application provides a progress data statistics method. Fig. 2 is a flow chart of a progress data statistics method according to an embodiment of the present application. As shown in fig. 2, the method includes:
s201, acquiring a target table and an index table of various service indexes; the target table is used for storing target values and target initial values corresponding to different index main bodies in preset time; the index table is used for storing the current values of indexes corresponding to different index main bodies in preset time.
In this embodiment of the present application, the target table is configured to store target values corresponding to different index main bodies, where the index main bodies are used to indicate identification information of different index owners, and taking insurance industry as an example, the index main bodies may be identification information for identifying different index owners, where the identification information is used to identify a regional name, a mechanism name, a risk name, a regional code, a mechanism code, a risk code, and the like.
Table 1 is an example of a target table stored in a database, as shown in table 1:
TABLE 1
The index table is used for storing current values corresponding to different index main bodies, and table 2 is an example of an index table stored in the database, as shown in table 2:
TABLE 2
The data type is used for indicating the numerical types of the target numerical value, the target initial numerical value and the current numerical value of the index, and not null indicates that the target numerical value, the target initial numerical value and the current numerical value cannot be null, such as decomal (14, 2), indicates that the numerical value digit is 14 digits at the maximum, and can reserve two digits after the decimal point. The data type is defined for facilitating the writing of the computer program, i.e. the method of the present application may be performed by writing into the computer program.
It should be noted that, in the database, the target values, the target initial values and the current values of the indexes corresponding to different index bodies are stored in the form of a table, so that the data statistics and the calculation are convenient to call.
Alternatively, the target value, the target start value, and the current index value may be stored based on other storage forms, which are not limited in this embodiment of the present application, and may be stored in the form of key value pairs or distributed files.
Optionally, in this step, the data processing system may also directly obtain the target values, the target starting values, and the current values of the indexes corresponding to the different index bodies in the preset time for the subsequent calculation processing, which is not specifically limited in the embodiment of the present application.
It should be noted that, the target values, the target initial values and the current values of the indexes corresponding to the main bodies of different indexes in the preset time are all counted in advance to store data, and the statistical method and the statistical main body are not particularly limited in the embodiment of the present application, for example, the target values, the target initial values and the current values of the indexes in the preset time of the statistical mechanism can be manually based, and stored in the database of the mechanism, and when the statistical mechanism is used, corresponding data can be directly called from the database.
S202, aiming at each service index, carrying out de-duplication and merging processing on the data in a target table and an index table corresponding to the service index based on the index main body to obtain a summary table; each index body in the summary table corresponds to a target value, a target starting value and a current index value.
In the embodiment of the present application, the service index is used to indicate different kinds of indexes, which may be insurance premium, insurance rate to be charged, odds ratio, and the like, or may be service indexes of different application scenarios such as financial service, insurance service, and fund service, which is not particularly limited in the embodiment of the present application.
In this step, the data processing system may call a unit method, combine the target table and the index main body of the index table, perform compensation and/or deduplication processing, generate an index main body table, and further, for the data to be added in the index main body table, perform compensation and/or combination processing on the target value, the target starting value and the current value of the index based on the left join (left join) of the index main body table and the index table, to generate a summary table.
When the value corresponding to a certain index body in the index body table is null, a predefined value can be called for compensation in a compensation processing mode, and the predefined value is not particularly limited, and is a value defined in advance.
Optionally, if the target initial value of a certain index body in the index body table is null, the compensation value may be 0, if the target value is null, the compensation value may be 0, and if the current value of the index is null, the compensation value may be 0.
It should be noted that, the repetition removing and merging processing may be performed by the unit method in the target table and the index table, and the method for performing the repetition removing and merging processing in the embodiment of the present application is not specifically limited, and may be other algorithms corresponding to the repetition removing and merging functions.
For example, taking an example that the target table has target values and target initial values of 16 places and the index table has index current values of 16 places, the target table and the index main body in the index table may be subjected to de-duplication processing based on area names or area codes of the 16 places, so as to obtain an index main body table, and further, based on the index main body, the target values, the target initial values and the index current values of the 16 places are subjected to merging processing, so as to obtain a summary table.
S203, calculating a first difference value between the current value of the index and the target initial value, and a second difference value between the target value and the target initial value.
In some embodiments, taking the current index value as 5000000 of the current income of the insurance premium, the initial target value as 0 of the initial income of the insurance premium, and the target value as 10000000 of the target income of the insurance premium as an example, the first difference value=5000000 of the current income of the insurance premium-0 of the initial income of the insurance premium=5000000 of the insurance premium, and the second difference value=10000000 of the target income of the insurance premium-0 of the initial income of the insurance premium=10000000 of the insurance premium.
In other embodiments, taking the current index value as the current income of the personal loan guarantee insurance premium as a factor of 750000, the initial target value as the initial income of the personal loan guarantee insurance premium as a factor of 1000000, the target value as the target income of the personal loan guarantee insurance premium as a factor of 500000, the first difference = personal loan guarantee premium current revenue-750000-personal loan guarantee premium start revenue-1000000-personal loan guarantee premium 250000-the second difference = personal loan guarantee premium target revenue-500000-personal loan guarantee premium start revenue-1000000-personal loan guarantee premium 500000-the first difference = personal loan guarantee premium start revenue.
In still other embodiments, taking the current value of the indicator as 10% of the current charge rate, the initial value of the target as 20% of the initial charge rate, and the target as 5% of the target charge rate as an example, the first difference value=10% of the current charge rate to 20% of the initial charge rate=10% of the charge rate, and the second difference value=5% of the target charge rate to 20% of the initial charge rate=15% of the charge rate.
In still other embodiments, taking the current value of the index as the current odds 70%, the initial value as the initial odds 80%, and the target value as the target odds 60% as examples, the first difference value=the current odds 70% -the initial odds 80% =odds-10%, and the second difference value=the target odds 60% -the initial odds 80% =odds-20%.
S204, determining the index progress in preset time based on the first difference value and the second difference value, and counting the index progress corresponding to the multiple business indexes to obtain a progress statistics table.
Optionally, the formula based on the calculation of the index progress is: index progress= (index current value-target initial value)/(target value-target initial value), calculating index progress, and further counting index progress corresponding to various business indexes to obtain a progress statistics table.
Optionally, the index progress is calculated based on a weighting algorithm, and the formula is: index progress = first difference a/second difference b, or index progress = (index current value c-target start value d)/(target value e-target start value d), where a, b, c, d, e are weights or scale values; the index progress can be calculated by giving weight or proportion values to the numerical values based on the importance degree, priority or constraint conditions of different scenes of the numerical values.
It should be noted that, in the embodiment of the present application, the method for determining the indicator progress within the preset time based on the first difference and the second difference is not particularly limited, and may be determined based on the user requirement/application scenario.
Optionally, after the schedule statistics are obtained, the schedule statistics may also be visually displayed for the user to view.
Therefore, according to the progress data statistics method provided by the embodiment of the application, by calculating the first difference value between the current value and the target initial value of the index and the second difference value between the target value and the target initial value, the index progress calculated by using the first difference value and the second difference value is the correct value, no matter what application scene, the reasonable index progress can be calculated by using the method of the application, and meanwhile, the data structure and the corresponding multiple computer programs of the method of the application have universality and expandability, so that the operation and maintenance cost and the development and adjustment cost can be effectively reduced.
Fig. 3 is a schematic flow chart of an alternative progress data statistics method according to an embodiment of the present application, as shown in fig. 3, where the progress data statistics method includes: and merging the target table and the index main body in the index table to generate an index main body table, merging the target value and the index value to generate a summary table, further reading data in the summary table, calculating the index progress, and generating a progress statistics table.
The target table and the index table are in a table form and comprise target values, target initial values and target current values corresponding to different index main bodies, and can also be in other forms, such as a file form, but the data in the target table and the index table correspond to the target values, the target initial values and the target current values corresponding to different index main bodies.
It should be noted that, the method for calculating the indicator progress may be (indicator current value-target start value)/(target value-target start value).
Therefore, no matter the target value is positive, 0 or negative, the calculation and statistics of the index progress of various service indexes can be realized, so that the calculation rate is improved, and the development workload and the system resource cost are reduced.
Optionally, performing duplication removal and merging processing on the data in the target table and the index table corresponding to the service index based on the index main body to obtain a summary table, where the summary table includes:
judging whether missing data exists in the target table and the data in the index table corresponding to the service index;
if yes, compensating the missing data in the target table and/or the index table based on a predefined numerical value, and performing duplication removal and merging processing on the compensated data in the target table and the index table based on an index main body to obtain a summary table;
If not, carrying out duplication elimination processing on the target table and the data in the index table based on the index main body, and carrying out combination processing on the duplicated data in the target table and the duplicated data in the index table to obtain a summary table.
In this embodiment of the present application, the predefined value is a value defined in advance for performing compensation processing on different index bodies, where the predefined value may be directly called from a database, or may be modified manually, and this embodiment of the present application is not specifically limited, and is determined based on a user requirement and/or an application scenario, and for example, the predefined value may be set to be a value 0.
In this step, in addition to the case where there is no missing data in both the target table and the index table, there may be the following cases: the target table has no missing data, but the index table has missing data; missing data exists in the target table, but the index table has no missing data; however, the index bodies corresponding to the missing data of the two are different.
Since the index body which is required to appear in either the target table or the index table needs to appear in the result, the missing data in the target table and/or the index table can be compensated, and then the data in the target table and the index table can be combined, for example, the target table and the index table can be combined by using a unit method.
Illustratively, taking the example of a target table having target values and target starting values for 15 municipalities and a target table having target current values for 15 municipalities, wherein the target table includes target values and target starting values for municipalities 1-14 and 16 and the target table includes target current values for municipalities 1-12 and 14-16.
Further, the data processing system may obtain a predefined value corresponding to the city 15 in the target table, supplement the target value and the target initial value of the city 15, and correspondingly, obtain a predefined value corresponding to the city 13 in the index table, and supplement the current value of the index of the city 13.
Optionally, when the missing data does not exist in the data in the target table and the index table, the data processing system may perform deduplication processing on the index main body with duplication in the target table and the index table, and further, combine the data in the target table and the index table of the index main body after deduplication to obtain the summary table.
Therefore, the embodiment of the application can perform data compensation processing on the target table and/or the index table with missing data, so that index main bodies related to the business index can appear in the summary table, data omission is reduced, comprehensiveness of progress statistics is improved, furthermore, the application can perform deduplication processing on the target table and the index main bodies in the index table, so that the combined summary table has no data of redundant index main bodies, system resource occupation is saved, and operation and maintenance are easy.
Optionally, compensating the missing data in the target table and/or the index table based on a predefined value includes:
when determining that missing data exists in the target table, acquiring a predefined value based on an index main body in the index table, and performing compensation processing on the missing data in the target table based on the predefined value;
and/or when determining that the missing data exists in the index table, acquiring a predefined value based on the index body in the target table, and performing compensation processing on the missing data in the index table based on the predefined value.
Illustratively, taking the example that the target table includes the target values and the target initial values of the ground cities 1-14 and the ground cities 16, and the index table includes the index current values of the ground cities 1-12 and the ground cities 14-16, determining that missing data exists in the target table and the index table based on judgment of the target table and the index table, further, determining that the target value and the target initial value of the ground city 15 are absent in the target table and the index current value of the ground city 13 is absent in the index table based on the index main body ground city.
Further, based on the index main body city 15, the current index value of the city 15 is obtained from the index table, and the target value and the target initial value of the city 15 are supplemented based on the predefined value, such as the supplementing value 0, correspondingly, based on the index main body city 13, the target value and the target initial value of the city 13 are obtained from the target table, and the current index value of the city 13 is supplemented based on the predefined value, such as the supplementing value 0, and then the complete summary table is obtained.
It should be noted that, when the target table lacks the target value and the target initial value of the city 15, the index table lacks data, or the index table lacks the current value of the city 13, the target table lacks data, and the compensation process of the missing data is performed by using the similar method, which is not described herein in detail.
Optionally, when there is partial missing data in the target table, a predefined value is obtained based on the index body in the index table, and compensation processing is performed on the partial missing data in the target table based on the predefined value, for example, the partial missing data is the target value or the target starting value of the absent ground 15 in the target table.
Therefore, the method and the device can determine the predefined value based on the index main body in the missing data in the target table and/or the index table, further compensate the target table and/or the index table based on the predefined value, ensure the integrity of the data, and further improve the comprehensiveness of progress statistics.
Optionally, determining the indicator progress within the preset time based on the first difference value and the second difference value includes:
and calculating the index progress in the preset time based on the first difference value and the second difference value by using a predefined algorithm.
In the embodiment of the application, the predefined algorithm may refer to an algorithm defined in advance for calculating an index progress within a preset time, and a reasonable index progress may be calculated by using the predefined algorithm; the preset time may refer to a time period in which the progress is completed, and the preset time=index statistics termination time-index statistics start time, in this embodiment of the present application, the predefined algorithm and the preset time are not specifically limited, for example, the preset time may be 1 year, and the predefined algorithm may be division.
Optionally, a weighting algorithm is used to calculate the indicator progress in the preset time based on the first difference and the second difference, where the formula corresponding to the weighting algorithm is indicator progress=first difference a/second difference b.
Optionally, a division is used, based on the first difference value and the second difference value, an index progress within a preset time is calculated, and a formula corresponding to the division is index progress=first difference value/second difference value.
Optionally, by using other redefined algorithms, based on the first difference value and the second difference value, an index progress within a preset time is calculated, and the index progress calculated by the redefined algorithm is required to be in line with an actual scene.
Therefore, according to the embodiment of the application, different algorithms can be utilized, the index progress in the preset time is calculated based on the first difference value and the second difference value, and the flexibility of calculating the index progress is improved.
Optionally, calculating, by using a predefined algorithm, an indicator progress within a preset time based on the first difference value and the second difference value, including:
and calculating the ratio of the first difference value to the second difference value to obtain the index progress in the preset time.
In some embodiments, taking the example of the first difference value=5000000 of current income of the insurance premium-0 of initial income of the insurance premium=5000000 of insurance premium of the insurance premium in the preset time, the second difference value=10000000 of target income of the insurance premium-0 of initial income of the insurance premium=10000000 of insurance premium, and the index progress=5000000 of insurance premium/10000000 of insurance premium=50%.
In other embodiments, taking the example of the first difference value=the current income of the personal loan guarantee insurance premium for a preset time-750000 yuan-the initial income of the personal loan guarantee insurance premium for a preset time-1000000 yuan=the 250000 yuan of the personal loan guarantee insurance premium, the second difference value=the target income of the personal loan guarantee insurance premium for a preset time-500000 yuan-the initial income of the personal loan guarantee insurance premium-1000000 yuan=500000 yuan of the personal loan guarantee insurance premium, the index progress=250000 yuan of the personal loan guarantee insurance premium/500000 yuan of the personal loan guarantee insurance premium=50%.
In still other embodiments, taking the first difference value=10% of the current charge rate to be charged to the initial charge rate to be charged to 20% =10% of the charge rate to be charged for a preset period of time, the second difference value=5% of the target charge rate to be charged to 20% =15% of the charge rate to be charged to the target charge rate, and the index progress=10% of the charge rate to be charged/15% =2/3.
In still other embodiments, taking the first difference value=70% of the current odds to 80% of the initial odds=80% of the odds-10% of the odds within the preset time, the second difference value=60% of the target odds to 80% of the initial odds=80% of the odds-20% of the odds, and the index progress=10% of the odds/20% of the odds-20% =50%.
Note that, in the embodiment of the present application, the numerical expression form of the indicator progress is not particularly limited, and may be a fraction, a decimal, a percentage, or the like.
Therefore, the embodiment of the application can calculate by using the mode of index progress = first difference value/second difference value, simplify the calculation process, improve the calculation speed, and the calculation method can be generally used for the progress statistics of all business indexes, and improve the applicability of the index progress.
Optionally, the target table and the index table for acquiring various service indexes (such as premium, chargeable rate and pay rate) include:
And obtaining a target table and an index table of various service indexes by utilizing a parallel processing mode so as to determine the index progress of each service index in preset time.
In the embodiment of the present application, since different traffic indexes correspond to different target tables and index tables, and a large amount of index data is stored in each target table and index table, the present application may execute S201-S204 in a parallel processing manner.
It should be noted that, the data structure for implementing all the functions of the method of the present application may be based on a computer program, i.e. the method of the present application may be written into a progress statistics program to perform statistics of the progress data.
In the step, the parallel processing performance of the distributed database can be fully utilized, the mass data can be efficiently calculated, and the data structure of each function is realized, namely, the target table and the index table for processing multiple service indexes in parallel are subjected to duplicate removal and combination processing, the index progress in the preset time is determined, and the index progress corresponding to the multiple service indexes is further counted to obtain a progress statistics table.
Therefore, the processing performance of progress data statistics can be greatly improved, and the processing time is saved.
Optionally, the method further comprises:
Visually displaying the progress statistics table, and acquiring the progress of manually calculating indexes to be compared of the multiple service indexes;
comparing the to-be-compared index progress with the index progress in the progress statistics table to verify whether the index progress is consistent with the to-be-compared index progress or not;
and when the index progress is determined to be inconsistent with the index progress to be compared, correcting the index progress in the progress statistics table based on the index progress to be compared.
In this step, after the schedule statistics are obtained, the schedule statistics may be visually displayed, for example, in the application scenario shown in fig. 1, and may be visually displayed at the terminal device 104 of the user for the user to view and use for subsequent analysis.
Further, if the accuracy of the index progress in the progress statistics table is to be judged, the progress of the index to be compared of the plurality of service indexes calculated by manual input can be obtained, and for each service index, the progress of the index is compared with the progress of the index to be compared, namely, whether the progress of the index is consistent with the progress of the index to be compared is judged, if so, the determined progress of the index is correct, if not, the determined progress of the index is wrong, and then the progress of the index in the progress statistics table is corrected based on the progress of the index to be compared.
Optionally, when the index progress is inconsistent with the index progress to be compared, a prompt message may be generated to remind the user to correct the index progress, or to check whether an abnormality occurs in the execution process of S201-S204.
Therefore, the embodiment of the application can verify the index progress to determine the accuracy of the index progress, and when a problem exists, the index progress can be corrected, so that the accuracy of determining the index progress is improved.
In the foregoing embodiments, the progress data statistics method provided in the embodiments of the present application is described, and in order to implement each function in the method provided in the embodiments of the present application, an electronic device as an execution body may include a hardware structure and/or a software module, and each function may be implemented in the form of a hardware structure, a software module, or a hardware structure plus a software module. Some of the functions described above are performed in a hardware configuration, a software module, or a combination of hardware and software modules, depending on the specific application of the solution and design constraints.
For example, fig. 4 is a schematic structural diagram of a device for statistics of progress data according to an embodiment of the present application, as shown in fig. 4, where the device includes: an obtaining module 401, configured to obtain a target table and an index table of multiple service indexes; the target table is used for storing target values and target initial values corresponding to different index main bodies in preset time; the index table is used for storing the current values of indexes corresponding to different index main bodies in preset time;
A processing module 402, configured to, for each service indicator, perform deduplication and merging processing on the target table and the data in the indicator table corresponding to the service indicator based on the indicator main body, to obtain a summary table; each index body in the summary table corresponds to a target value, a target initial value and a current index value;
a calculating module 403, configured to calculate a first difference between the current value of the indicator and the target start value, and a second difference between the target value and the target start value;
and a statistics module 404, configured to determine an indicator progress within a preset time based on the first difference and the second difference, so as to perform statistics on indicator progress corresponding to the multiple service indicators, and obtain a progress statistics table.
Optionally, the processing module 402 includes a judging unit, a first processing unit, and a second processing unit;
specifically, the judging unit is configured to judge whether missing data exists in the target table and the data in the index table corresponding to the service index;
the first processing unit is used for carrying out compensation processing on the target table and/or the missing data in the index table based on a predefined numerical value when the missing data exists in the data in the target table and the index table, carrying out de-duplication and merging processing on the compensated data in the target table and the index table based on an index main body, and obtaining a summary table;
And the second processing unit is used for carrying out de-duplication processing on the data in the target table and the index table based on the index main body when the data in the target table and the index table do not have missing data, and carrying out merging processing on the data in the target table and the index table after de-duplication to obtain a summary table.
Optionally, the first processing unit is specifically configured to:
when determining that missing data exists in the target table, acquiring a predefined value based on an index main body in the index table, and performing compensation processing on the missing data in the target table based on the predefined value;
and/or when determining that the missing data exists in the index table, acquiring a predefined value based on the index body in the target table, and performing compensation processing on the missing data in the index table based on the predefined value.
Optionally, the statistics module 404 is specifically configured to:
and calculating the index progress in the preset time based on the first difference value and the second difference value by using a predefined algorithm.
Optionally, the statistics module 404 is specifically configured to:
and calculating the ratio of the first difference value to the second difference value to obtain the index progress in the preset time.
Optionally, the obtaining module 401 is specifically configured to:
and obtaining a target table and an index table of various service indexes by utilizing a parallel processing mode so as to determine the index progress of each service index in preset time.
Optionally, the apparatus further includes a correction module, where the correction module is configured to:
visually displaying the progress statistics table, and acquiring the progress of manually calculating indexes to be compared of the multiple service indexes;
comparing the to-be-compared index progress with the index progress in the progress statistics table to verify whether the index progress is consistent with the to-be-compared index progress or not;
and when the index progress is determined to be inconsistent with the index progress to be compared, correcting the index progress in the progress statistics table based on the index progress to be compared.
The specific implementation principle and effect of the progress data statistics device provided in the embodiment of the present application may refer to the relevant description and effect corresponding to the foregoing embodiment, and will not be repeated herein.
Exemplary, the embodiment of the present application further provides a schematic structural diagram of an electronic device, and fig. 5 is a schematic structural diagram of an electronic device provided in the embodiment of the present application, as shown in fig. 5, where the electronic device may include: a processor 501 and a memory 502 communicatively coupled to the processor; the memory 502 stores a computer program; the processor 501 executes the computer program stored in the memory 502, so that the processor 501 performs the method described in any one of the embodiments above.
Wherein the memory 502 and the processor 501 may be connected by a bus 503.
Embodiments of the present application also provide a computer-readable storage medium storing computer program execution instructions that, when executed by a processor, are configured to implement a method as described in any of the foregoing embodiments of the present application.
The embodiment of the application also provides a chip for executing instructions, wherein the chip is used for executing the method in any of the previous embodiments executed by the electronic equipment in any of the previous embodiments of the application.
Embodiments of the present application also provide a computer program product comprising a computer program which, when executed by a processor, performs a method as described in any of the preceding embodiments of the present application, as performed by an electronic device.
In the several embodiments provided in this application, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative, e.g., the division of modules is merely a logical function division, and there may be additional divisions of actual implementation, e.g., multiple modules or components may be combined or integrated into another system, or some features may be omitted, or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices or modules, which may be in electrical, mechanical, or other forms.
The modules illustrated as separate components may or may not be physically separate, and components shown as modules may or may not be physical units, may be located in one place, or may be distributed over multiple network units. Some or all of the modules may be selected according to actual needs to implement the solution of this embodiment.
In addition, each functional module in each embodiment of the present application may be integrated in one processing unit, or each module may exist alone physically, or two or more modules may be integrated in one unit. The units formed by the modules can be realized in a form of hardware or a form of hardware and software functional units.
The integrated modules, which are implemented in the form of software functional modules, may be stored in a computer readable storage medium. The software functional modules described above are stored in a storage medium and include instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) or processor to perform some of the steps of the methods described in various embodiments of the present application.
It should be appreciated that the processor may be a central processing unit (Central Processing Unit, CPU for short), other general purpose processors, digital signal processor (Digital Signal Processor, DSP for short), application specific integrated circuit (Application Specific Integrated Circuit, ASIC for short), etc. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. The steps of a method disclosed in connection with the present application may be embodied directly in a hardware processor for execution, or in a combination of hardware and software modules in a processor for execution.
The Memory may include a high-speed random access Memory (Random Access Memory, abbreviated as RAM), and may further include a Non-volatile Memory (NVM), such as at least one magnetic disk Memory, and may also be a U-disk, a removable hard disk, a read-only Memory, a magnetic disk, or an optical disk.
The bus may be an industry standard architecture (Industry Standard Architecture, ISA) bus, an external device interconnect (Peripheral Component Interconnect, PCI) bus, or an extended industry standard architecture (Extended Industry Standard Architecture, EISA) bus, among others. The buses may be divided into address buses, data buses, control buses, etc. For ease of illustration, the buses in the drawings of the present application are not limited to only one bus or one type of bus.
The storage medium may be implemented by any type of volatile or non-volatile Memory device or combination thereof, such as Static Random-Access Memory (SRAM), electrically erasable programmable Read-Only Memory (Electrically Erasable Programmable Read Only Memory, EEPROM), erasable programmable Read-Only Memory (Erasable Programmable Read-Only Memory, EPROM), programmable Read-Only Memory (Programmable Read-Only Memory, PROM), read-Only Memory (ROM), magnetic Memory, flash Memory, magnetic disk, or optical disk. A storage media may be any available media that can be accessed by a general purpose or special purpose computer.
An exemplary storage medium is coupled to the processor such the processor can read information from, and write information to, the storage medium. In the alternative, the storage medium may be integral to the processor. The processor and the storage medium may reside in an application specific integrated circuit (Application Specific Integrated Circuits, ASIC for short). It is also possible that the processor and the storage medium reside as discrete components in an electronic device or a master device.
The foregoing is merely a specific implementation of the embodiments of the present application, but the protection scope of the embodiments of the present application is not limited thereto, and any changes or substitutions within the technical scope disclosed in the embodiments of the present application should be covered by the protection scope of the embodiments of the present application. Therefore, the protection scope of the embodiments of the present application shall be subject to the protection scope of the claims.
Claims (11)
1. A method of progress data statistics, the method comprising:
acquiring a target table and an index table of various service indexes; the target table is used for storing target values and target initial values corresponding to different index main bodies in preset time; the index table is used for storing the current values of indexes corresponding to different index main bodies in preset time;
Aiming at each service index, carrying out de-duplication and merging processing on the data in a target table and an index table corresponding to the service index based on the index main body to obtain a summary table; each index body in the summary table corresponds to a target value, a target initial value and a current index value;
calculating a first difference between the current value of the index and the target initial value, and a second difference between the target value and the target initial value;
and determining the index progress in preset time based on the first difference value and the second difference value, so as to count the index progress corresponding to the multiple business indexes, and obtaining a progress statistics table.
2. The method according to claim 1, wherein performing deduplication and merging processing on the data in the target table and the index table corresponding to the service index based on the index body to obtain a summary table includes:
judging whether missing data exists in the target table and the data in the index table corresponding to the service index;
if yes, compensating the missing data in the target table and/or the index table based on a predefined numerical value, and performing duplication removal and merging processing on the compensated data in the target table and the index table based on an index main body to obtain a summary table;
If not, carrying out duplication elimination processing on the target table and the data in the index table based on the index main body, and carrying out combination processing on the duplicated data in the target table and the duplicated data in the index table to obtain a summary table.
3. Method according to claim 2, characterized in that the compensation of missing data in the target table and/or the index table based on predefined values comprises:
when determining that missing data exists in the target table, acquiring a predefined value based on an index main body in the index table, and performing compensation processing on the missing data in the target table based on the predefined value;
and/or when determining that the missing data exists in the index table, acquiring a predefined value based on the index body in the target table, and performing compensation processing on the missing data in the index table based on the predefined value.
4. The method of claim 1, wherein determining an indicator schedule for a preset time based on the first difference and the second difference comprises:
and calculating the index progress in the preset time based on the first difference value and the second difference value by using a predefined algorithm.
5. The method of claim 4, wherein calculating, using a predefined algorithm, an indicator schedule for a preset time based on the first difference and the second difference, comprises:
and calculating the ratio of the first difference value to the second difference value to obtain the index progress in the preset time.
6. The method of claim 1, wherein obtaining the target table and the index table for the plurality of business indexes comprises:
and obtaining a target table and an index table of various service indexes by utilizing a parallel processing mode so as to determine the index progress of each service index in preset time.
7. The method according to any one of claims 1-6, further comprising:
visually displaying the progress statistics table, and acquiring the progress of manually calculating indexes to be compared of the multiple service indexes;
comparing the to-be-compared index progress with the index progress in the progress statistics table to verify whether the index progress is consistent with the to-be-compared index progress or not;
and when the index progress is determined to be inconsistent with the index progress to be compared, correcting the index progress in the progress statistics table based on the index progress to be compared.
8. A schedule data statistics apparatus, the apparatus comprising:
the acquisition module is used for acquiring a target table and an index table of various service indexes; the target table is used for storing target values and target initial values corresponding to different index main bodies in preset time; the index table is used for storing the current values of indexes corresponding to different index main bodies in preset time;
the processing module is used for carrying out de-duplication and merging processing on the target table corresponding to the service index and the data in the index table according to each service index based on the index main body to obtain a summary table; each index body in the summary table corresponds to a target value, a target initial value and a current index value;
the calculation module is used for calculating a first difference value between the current index value and the target initial value and a second difference value between the target value and the target initial value;
and the statistics module is used for determining the index progress in the preset time based on the first difference value and the second difference value so as to count the index progress corresponding to the multiple business indexes and obtain a progress statistics table.
9. An electronic device, comprising: a processor, and a memory communicatively coupled to the processor;
The memory stores computer-executable instructions;
the processor executes computer-executable instructions stored in the memory to implement the method of any one of claims 1-7.
10. A computer readable storage medium storing computer executable instructions which when executed by a processor are adapted to carry out the method of any one of claims 1 to 7.
11. A computer program product comprising a computer program which, when executed by a processor, implements the method according to any of claims 1-7.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202410052648.7A CN117851409A (en) | 2024-01-12 | 2024-01-12 | Progress data statistics method, device, equipment, storage medium and program product |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202410052648.7A CN117851409A (en) | 2024-01-12 | 2024-01-12 | Progress data statistics method, device, equipment, storage medium and program product |
Publications (1)
Publication Number | Publication Date |
---|---|
CN117851409A true CN117851409A (en) | 2024-04-09 |
Family
ID=90543875
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202410052648.7A Pending CN117851409A (en) | 2024-01-12 | 2024-01-12 | Progress data statistics method, device, equipment, storage medium and program product |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN117851409A (en) |
-
2024
- 2024-01-12 CN CN202410052648.7A patent/CN117851409A/en active Pending
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109242261B (en) | Method for evaluating security risk based on big data and terminal equipment | |
CN107798592B (en) | Method and apparatus for calculating commission | |
CN107656955B (en) | Repayment data batch reporting method and device | |
CN106910129B (en) | Asset data processing method, client and server | |
CN108269182B (en) | Balance calculation method and calculation equipment based on fund collection | |
CN112232936A (en) | Project fee adding and deducting method and device, electronic equipment and readable storage medium | |
CN109377207B (en) | Abnormal hospitalization behavior judging method and related products | |
CN111091471A (en) | Insurance claim settlement method, device, equipment and storage medium | |
CN107688959B (en) | Breakpoint list processing method, storage medium and server | |
CN111242779B (en) | Financial data characteristic selection and prediction method, device, equipment and storage medium | |
CN110276692B (en) | Method and device for processing transaction data | |
CN117851409A (en) | Progress data statistics method, device, equipment, storage medium and program product | |
CN108133325A (en) | A kind of partner's management method and device | |
CN111199799A (en) | Health prompt information processing method and device and terminal equipment | |
CN111223000A (en) | Bill processing method and device, computer equipment and storage medium | |
CN115062079A (en) | Transaction flow processing method, device, equipment and storage medium | |
CN114169451A (en) | Behavior data classification processing method, device, equipment and storage medium | |
CN114116797A (en) | Method and device for settling taxi renting data | |
CN111105154A (en) | Stock market operation risk assessment method and device, electronic equipment and storage medium | |
CN111311396A (en) | Re-posting accounting method, device, equipment and storage medium | |
CN111784512A (en) | Bank-enterprise reconciliation flow processing method and device and electronic equipment | |
CN111524020A (en) | Data processing method, device, equipment and storage medium | |
CN113344630B (en) | Resource allocation method, device, electronic equipment and storage medium | |
CN117331983A (en) | Method, device, equipment and medium for searching overdue loan data | |
CN111144810B (en) | Data processing method and device and related equipment |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination |