Method, apparatus, storage medium, and electronic device for processing service information

By introducing business count tables and statistical tables into the cloud reporting platform, combining early warning thresholds and total amount thresholds, the statistical deviation problems caused by users' modification or deletion of data are solved, accurate and efficient management of business data is achieved, and the data management capabilities of the cloud reporting platform are improved.

CN114239510BActive Publication Date: 2025-08-01NEUSOFT CORP
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202111580656.1
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-12-22
Publication Date
2025-08-01
Estimated Expiration
2041-12-22

AI Technical Summary

Technical Problem

When the existing cloud reporting platform counts the number of business data, users can modify or delete data, resulting in deviations in statistical results, which affects the accuracy and efficiency of data management.

Method used

By introducing a business count table and a business statistics table into the cloud reporting platform, the number of business data is updated simultaneously according to the preset detection cycle, combined with the warning threshold and the total amount threshold, the use permissions of the object are determined to control data reception, and standardized management of business data is realized.

Benefits of technology

It improves the accuracy and efficiency of business data statistics, ensures the standardization of data management, reduces data deviations, and improves the service quality of the cloud reporting platform.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN114239510B_ABST
    Figure CN114239510B_ABST
Patent Text Reader

Abstract

The present disclosure relates to a method, an apparatus, a storage medium, and an electronic device for processing service information, and relates to the technical field of electronic information processing. The method includes: obtaining, according to a preset detection period, the service quantity of the service data corresponding to each object within the current detection period recorded in the service count table, and the service count table is synchronously updated when new service data is added to the service data table. Updating the service cumulative quantity corresponding to the object in the service statistics table according to the service quantity corresponding to each object. Determining the service quantity status corresponding to the object according to the service cumulative quantity corresponding to each object in the service statistics table, the warning threshold value corresponding to the object, and the total quantity threshold value. Determining the usage permission corresponding to the object according to the service quantity status corresponding to each object, and the usage permission is used to indicate whether the service data table receives the service data corresponding to the object. The present disclosure can achieve the standardized management of service data and improve the accuracy of quantity statistics.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present disclosure relates to the technical field of electronic information processing, and in particular, to a method, apparatus, storage medium, and electronic device for processing service information. Background Art

[0002] With the rapid development of information technologies such as the Internet and cloud computing, the corresponding data volume has also shown an explosive growth. Many business data such as forms and questionnaires can be filled in and collected through the network. Different users have different demands for business data, so packages that meet the requirements can be ordered through a cloud filling platform. When the cloud filling platform collects the service data uploaded by users, it will count the quantity of the service data to determine whether it meets the specifications of the corresponding package. Since users can modify or delete the service data, there may be a deviation when counting the quantity of the service data. Summary of the Invention

[0003] The purpose of the present disclosure is to provide a method, apparatus, storage medium, and electronic device for processing service information to solve the related problems existing in the prior art.

[0004] To achieve the above object, according to the first aspect of the embodiments of the present disclosure, a method for processing service information is provided, the method comprising:

[0005] Obtaining, according to a preset detection period, the service quantity of the service data corresponding to each object in the current detection period recorded in the service count table, where the service count table is synchronously updated when new service data is added to the service data table;

[0006] Updating the service cumulative quantity corresponding to the object in the service statistics table according to the service quantity corresponding to each object;

[0007] Determining the service quantity status corresponding to the object according to the service cumulative quantity corresponding to each object in the service statistics table, the warning threshold corresponding to the object, and the total quantity threshold;

[0008] Determining the usage permission corresponding to the object according to the service quantity status corresponding to each object, where the usage permission is used to indicate whether the service data table receives the service data corresponding to the object.

[0009] According to the second aspect of the embodiments of the present disclosure, a device for processing service information is provided, the device comprising:

[0010] An obtaining module, configured to obtain, according to a preset detection period, the service quantity of the service data corresponding to each object in the current detection period recorded in the service count table, where the service count table is synchronously updated when new service data is added to the service data table;

[0011] A first update module, configured to update the cumulative service quantity corresponding to each object in the service statistics table according to the service quantity corresponding to each object.

[0012] A status determination module, configured to determine the service quantity status corresponding to each object according to the cumulative service quantity corresponding to each object in the service statistics table, the warning threshold corresponding to the object, and the total threshold.

[0013] A permission determination module, configured to determine the usage permission corresponding to each object according to the service quantity status corresponding to each object, where the usage permission is used to indicate whether the service data table receives the service data corresponding to the object.

[0014] According to a third aspect of the embodiments of the present disclosure, there is provided a computer-readable storage medium, on which a computer program is stored, and when the program is executed by a processor, the steps of the method according to the first aspect of the embodiments of the present disclosure are implemented.

[0015] According to a fourth aspect of the embodiments of the present disclosure, there is provided an electronic device, including:

[0016] A memory, on which a computer program is stored;

[0017] A processor, configured to execute the computer program in the memory to implement the steps of the method according to the first aspect of the embodiments of the present disclosure.

[0018] Through the above technical solutions, first, according to a preset detection period, the service quantity of the service data corresponding to each object in the service count table recorded in the current detection period is obtained, where the service count table can be synchronously updated when new service data is added to the service data table. Then, according to the service quantity corresponding to each object, the cumulative service quantity corresponding to the object in the service statistics table is updated. Further, according to the cumulative service quantity corresponding to each object in the service statistics table, the warning threshold corresponding to the object, and the total threshold, the service quantity status corresponding to the object is determined. Finally, according to the service quantity status corresponding to each object, the usage permission corresponding to the object, which is used to indicate whether the service data table receives the service data corresponding to the object, is determined. The present disclosure records the service quantity of the service data in each detection period through the service count table and updates the corresponding cumulative service quantity in the service statistics table, so as to determine the usage permission corresponding to the user, and can realize the standardized management of service data and improve the accuracy of quantity statistics.

[0019] Other features and advantages of the present disclosure will be described in detail in the subsequent specific implementation part. Description of the Drawings

[0020] The accompanying drawings are used to provide a further understanding of the present disclosure and constitute a part of the specification. Together with the following detailed description, they are used to explain the present disclosure, but do not limit the present disclosure. In the accompanying drawings:

[0021] Figure 1 is a flowchart of a method for processing service information shown according to an exemplary embodiment;

[0022] Figure 2 is a flowchart of another method for processing service information shown according to an exemplary embodiment;

[0023] Figure 3 is a flowchart of another method for processing service information shown according to an exemplary embodiment;

[0024] Figure 4 is a flowchart of another method for processing service information shown according to an exemplary embodiment;

[0025] Figure 5 is a flowchart of another method for processing service information shown according to an exemplary embodiment;

[0026] Figure 6 is a flowchart of another method for processing service information shown according to an exemplary embodiment;

[0027] Figure 7 is a flowchart of another method for processing service information shown according to an exemplary embodiment;

[0028] Figure 8 is a block diagram of a device for processing service information shown according to an exemplary embodiment;

[0029] Figure 9 is a block diagram of another device for processing service information shown according to an exemplary embodiment;

[0030] Figure 10 is a block diagram of another device for processing service information shown according to an exemplary embodiment;

[0031] Figure 11 is a block diagram of another device for processing service information shown according to an exemplary embodiment;

[0032] Figure 12 is a block diagram of another device for processing service information shown according to an exemplary embodiment;

[0033] Figure 13 is a block diagram of an electronic device shown according to an exemplary embodiment;

[0034] Figure 14It is a block diagram of an electronic device shown according to an exemplary embodiment. Detailed implementation manners

[0035] Here, the exemplary embodiments will be described in detail, and the examples are shown in the drawings. When the following description refers to the drawings, unless otherwise indicated, the same numbers in different drawings represent the same or similar elements. The implementation manners described in the following exemplary embodiments do not represent all implementation manners consistent with the present disclosure. On the contrary, they are merely examples of devices and methods consistent with some aspects of the present disclosure as detailed in the appended claims.

[0036] Before introducing the method, device, storage medium, and electronic device for processing service information provided by the present disclosure, first, the application scenarios involved in each embodiment of the present disclosure are introduced. The application scenario may be a cloud filling platform, and the cloud filling platform may provide multiple package services. Each object can order the package service that meets the requirements through the cloud filling platform. Among them, the object can be understood as a user renting the cloud filling platform, which can be an individual user or an enterprise user, and the present disclosure does not make specific limitations thereon. The package service is used to limit how many business data can be filled by the corresponding object supported by the cloud filling platform. Individual users, enterprise users, or technicians can access the cloud filling platform by accessing it on a terminal device or through a browser or the like. Among them, the terminal device may be a mobile terminal with a display interface such as a smart phone, a tablet computer, a portable computer, or a fixed terminal such as a desktop computer.

[0037] Figure 1 It is a flowchart of a method for processing service information shown according to an exemplary embodiment. As Figure 1 shown, the method includes the following steps:

[0038] Step 101, according to a preset detection period, obtain the business quantity of the business data corresponding to each object in the current detection period recorded in the business count table, and the business count table is synchronously updated when new business data is added to the business data table.

[0039] For example, the cloud filling platform can maintain a business data table. Each object can generate business data through the cloud filling platform, and then the cloud filling platform can store the business data in the business data table. A large number of business data records are stored in the business data table. Each business data record includes a piece of business data, as well as information such as the object ID corresponding to the business data and the generation time. The object ID can uniquely identify the object. For example, the structure of a business data record can be: {object ID, business data, generation time}. Business data can be divided into multiple types. For example, an object can submit questionnaire data through the cloud filling platform, an object can also send SMS data through the cloud filling platform, and an object can also upload file data (which can include text files, image files, audio files, etc.) through the cloud filling platform.

[0040] Furthermore, the cloud filling platform can also maintain a business count table. The business count table records the business quantity of the business data corresponding to each object within the current detection period according to a preset detection period. The detection period is set to one day. At this time, the business count table is used to record the business quantity of the business data corresponding to each object within each day. The business count table can include count records corresponding to each object. The structure of the count record can be {object ID, business type, business quantity, user ID, business ID}. When a new business data is added to the business data table, the business quantity in the business count table will be updated synchronously. Among them, the business quantity can be understood as the number of business data records, or it can also be understood as the size of the business data. For example, if the business data is divided into questionnaire data, SMS data, and file data, then the business quantity can include: the number of questionnaire data records, the number of SMS data records, and the size of the file data (the unit can be, for example, KB or MB). The corresponding count record structures can be divided into three count records: {object ID, questionnaire data type, number of questionnaire data records, user ID, business ID}, {object ID, SMS data type, number of SMS data records, user ID, business ID}, {object ID, file data type, size of file data, user ID, business ID} for separate storage. The present disclosure does not make specific limitations on this.

[0041] The cloud filling platform can obtain the business quantity of the business data corresponding to each object within the current detection period recorded in the business count table according to the detection period. Taking the detection period of one day as an example, the cloud filling platform can set a scheduled task. This scheduled task reads the business quantity of the business data corresponding to each object within the day recorded in the business count table at 2 o'clock every day.

[0042] Step 102, update the cumulative business quantity corresponding to the object in the business statistics table according to the business quantity corresponding to each object.

[0043] For example, the cloud reporting platform can also maintain a business statistics table that records the cumulative business quantity corresponding to each object. The business statistics table may include cumulative records corresponding to each object, and the structure of the cumulative record can be {object ID, cumulative business quantity}. After obtaining the business quantity of the business data corresponding to each object in the current detection period recorded in the business count table, the cumulative business quantity corresponding to the object in the business statistics table can be updated accordingly. For example, the business quantity corresponding to the object can be added to the cumulative business quantity corresponding to the object in the business statistics table as the updated cumulative business quantity corresponding to the object in the business statistics table. The cumulative business quantity can be understood as the total quantity of business data generated by the object through the cloud reporting platform within the time range from the start of subscribing to the corresponding package service by the object to the end of the current detection period. For example, the business count table records that within the previous day, object A submitted 55 questionnaire data through the cloud reporting platform, that is, the business quantity corresponding to object A is 55. If the cumulative business quantity corresponding to object A in the business statistics table is 171, then the cumulative business quantity corresponding to object A in the business statistics table can be updated to 171 + 55 = 226.

[0044] Since there are a large number of business data records stored in the business data table, if the business statistics table first queries how much business data has been generated within a detection period from the business data table and then updates the corresponding cumulative business quantity, it needs to process a large amount of data and the update efficiency is low. At the same time, since the business data stored in the business data table may be modified or deleted, if the business statistics table updates the corresponding cumulative business quantity according to the business data table, there may be deviations. However, through a business statistics table that can be updated synchronously with the business data table, it can accurately record the business data generated by each object through the cloud reporting platform. Therefore, updating the corresponding cumulative business quantity according to the business statistics table can improve the update efficiency and accuracy.

[0045] Step 103: Determine the business quantity status corresponding to each object according to the cumulative business quantity corresponding to each object in the business statistics table, the warning threshold corresponding to the object, and the total quantity threshold.

[0046] Step 104: Determine the usage permission corresponding to each object according to the business quantity status corresponding to each object. The usage permission is used to indicate whether the business data table accepts the business data corresponding to the object.

[0047] Exemplarily, the business statistics table also records the warning threshold and the total threshold of the business data ordered by each object through the cloud filling platform. The total threshold is used to indicate the maximum value of the business data that the object can generate through the cloud filling platform, and the warning threshold is used to indicate that the quantity of the business data currently generated by the object through the cloud filling platform is close to the total threshold. For example, the warning threshold can be 80% of the total threshold. Among them, the total threshold is consistent with the total threshold recorded in the package table maintained by the cloud filling platform. The package table may include package service records of the package services ordered by each object on the cloud filling platform. The package service records include the package service identifier corresponding to the object, the total threshold, the package service valid flag (used to indicate whether the package service is valid), etc. The structure of the package service record can be: {object ID, package service identifier, total threshold, package service valid flag}. After updating the business cumulative quantity corresponding to the object in the business statistics table in step 102, the business cumulative quantity corresponding to each object in the business statistics table can be compared with the warning threshold and the total threshold corresponding to the object respectively to determine the business quantity status corresponding to the object. The business quantity status can also be stored in the business statistics table. Further, the usage permission corresponding to the object can be determined according to the business quantity status corresponding to the object.

[0048] The business quantity status can include three types: normal status, warning status, and over-limit status. Among them, the normal status means that the quantity of the business data generated by the object through the cloud filling platform is within the range of the total threshold and no warning is required. The warning status means that the quantity of the business data generated by the object through the cloud filling platform is within the range of the total threshold and is close to the total threshold, and a warning is required. The over-limit status means that the quantity of the business data generated by the object through the cloud filling platform exceeds the total threshold. Correspondingly, the usage permission can be divided into two types: open and closed. Open means that the business data table can receive the business data corresponding to the object, that is, the object can generate business data through the cloud filling platform. Closed means that the business data table refuses to receive the business data corresponding to the object, that is, the object cannot generate business data through the cloud filling platform. When the business quantity status is in the normal status or the warning status, the usage permission can be determined to be open. When the business quantity status is in the over-limit status, the usage permission can be determined to be closed.

[0049] In the case of including multiple types of business data, the business statistics table can record the warning thresholds and total quantity thresholds for each object corresponding to each type of business data. For example, if the business data is divided into questionnaire data, SMS data, and file data, then the business statistics table can record the questionnaire warning threshold, questionnaire total quantity threshold, SMS warning threshold, SMS total quantity threshold, file warning threshold, and file total quantity threshold corresponding to each object. Correspondingly, the business quantity status can also include the business quantity status corresponding to each type of business data. For example, it can include: questionnaire business quantity status, SMS business quantity status, and file business quantity status. Further, the usage permissions can also include the usage permissions corresponding to each type of business data. For example, it can include: questionnaire usage permission, SMS usage permission, and file usage permission. Correspondingly, the structure of the cumulative record can be {object ID, questionnaire warning threshold, questionnaire total quantity threshold, SMS warning threshold, SMS total quantity threshold, file warning threshold, file total quantity threshold, cumulative questionnaire business quantity, cumulative SMS business quantity, cumulative file business quantity, questionnaire business quantity status, SMS business quantity status, file business quantity status}.

[0050] Since the business statistics table can be synchronously updated with the business data table, it can quickly and accurately determine the corresponding cumulative business quantity, thereby accurately judging the business quantity status and usage permissions corresponding to each object, and can realize the standardized management of business data, improving the service efficiency and accuracy of the cloud filling platform.

[0051] In summary, first, according to the preset detection period, obtain the business quantity of the business data corresponding to each object recorded in the business count table during the current detection period, where the business count table can be synchronously updated when new business data is added to the business data table. Then, according to the business quantity corresponding to each object, update the cumulative business quantity corresponding to the object in the business statistics table. Further, according to the cumulative business quantity corresponding to each object in the business statistics table, and the warning threshold and total quantity threshold corresponding to the object, determine the business quantity status corresponding to the object. Finally, according to the business quantity status corresponding to each object, determine the usage permission corresponding to the object, which is used to indicate whether the business data table accepts the business data corresponding to the object. The present disclosure records the business quantity of business data in each detection period through the business count table and updates the corresponding cumulative business quantity in the business statistics table, thereby determining the usage permission corresponding to the user, and can realize the standardized management of business data and improve the accuracy of quantity statistics.

[0052] Figure 2 is a flowchart of another method for processing business information shown according to an exemplary embodiment, as Figure 2 shown, the implementation manner of step 103 can include:

[0053] Step 1031: For each object, if the cumulative business quantity corresponding to the object in the business statistics table is less than or equal to the warning threshold, determine that the business quantity status corresponding to the object is the normal status.

[0054] Step 1032: If the cumulative business quantity corresponding to the object in the business statistics table is greater than the warning threshold and less than or equal to the total quantity threshold, determine that the business quantity status corresponding to the object is the warning status.

[0055] Step 1033: If the cumulative business quantity corresponding to the object in the business statistics table is greater than the total quantity threshold, determine that the business quantity status corresponding to the object is the over - quantity status.

[0056] Exemplarily, the cumulative business quantity corresponding to each object in the business statistics table can be compared with the warning threshold first. If it is less than or equal to the warning threshold, then it can be determined that the business quantity status corresponding to the object is the normal status. If it is greater than the warning threshold, the cumulative business quantity corresponding to the object can be further compared with the total quantity threshold. If it is greater than the warning threshold and less than or equal to the total quantity threshold, then it can be determined that the business quantity status corresponding to the object is the warning status. If it is greater than the total quantity threshold, then it can be determined that the business quantity status corresponding to the object is the over - quantity status. Further, if it is determined that the business quantity status corresponding to the object is the warning status, a warning message can be sent for the object to give a warning that the quantity of the business data currently generated by the object through the cloud filling platform is close to the total quantity threshold. For example, warning messages in the form of text messages, emails, etc. can be sent to the specified terminal device of the object, or warning messages in the form of pop - ups, in - site messages, etc. can be sent to the account registered by the object.

[0057] Correspondingly, the implementation method of Step 104 can include:

[0058] If the business quantity status corresponding to the object is the over - quantity status, determine that the usage permission corresponding to the object is closed to instruct the business data table to reject the business data corresponding to the object. If the business quantity status corresponding to the object is the normal status or the warning status, determine that the usage permission corresponding to the object is open to instruct the business data table to be able to receive the business data corresponding to the object.

[0059] Exemplarily, in the case where the business quantity status is the normal status or the warning status, it can be determined that the usage permission is open, that is, the object can generate business data through the cloud filling platform. When the business quantity status is the over - quantity status, it can be determined that the usage permission is closed, that is, the object cannot generate business data through the cloud filling platform.

[0060] In the case of including multiple types of business data, the usage permissions corresponding to each object may include the usage permissions for each type of business data. Taking the business data being divided into questionnaire data, SMS data, and file data as an example, then the usage permissions corresponding to each object may include: questionnaire usage permissions, SMS usage permissions, and file usage permissions. The questionnaire usage permissions being closed indicates that the object cannot submit questionnaire data through the cloud filling platform (and cannot be manually enabled), the SMS usage permissions being closed indicates that the object cannot send SMS data through the cloud filling platform, and the file usage permissions being closed indicates that the object cannot upload file data through the cloud filling platform.

[0061] Figure 3 is a flowchart of another method for processing business information shown according to an exemplary embodiment, as Figure 3 shown, after step 103, the method may further include:

[0062] Step 105, for each object, if the business quantity status corresponding to the object is in a warning state, determine the sending label corresponding to the object in the business statistics table, where the sending label is used to indicate whether a warning message has been sent to the object.

[0063] Step 106, in the case where the sending label corresponding to the object is not sent, send a warning message to the object and update the sending label corresponding to the object to sent.

[0064] For example, for each object, the cloud filling platform may send a warning message to the object only when it is first determined that the business quantity status corresponding to the object is in a warning state, and when it is determined again that the business quantity status corresponding to the object is in a warning state later, no warning message will be sent to the object again. Specifically, a sending label may be added to the cumulative record corresponding to each object in the business statistics table, which is used to identify whether a warning message has been sent to the object. For example, the sending label being 0 indicates not sent, and the sending label being 1 indicates sent. In the case where it is determined in step 103 that the business quantity status corresponding to a certain object is in a warning state, the sending label corresponding to the object can be queried from the business statistics table. If the sending label corresponding to the object is sent, it means that the cloud filling platform has already sent a warning message to the object, and no action needs to be taken to avoid wasting transmission resources by repeatedly sending warning messages to the object. If the sending label corresponding to the object is not sent, it means that the cloud filling platform has not sent a warning message to the object yet, a warning message can be sent to the object, and at the same time, the sending label corresponding to the object in the business statistics table is updated to sent.

[0065] Figure 4 is a flowchart of another method for processing business information shown according to an exemplary embodiment, as Figure 4As shown, after step 101, the method may further include:

[0066] Step 107, update the quantity information corresponding to the object in the object information table according to the service quantity corresponding to each object. The object information table includes the object information corresponding to each object, and the quantity information is used to represent the quantity of service data corresponding to the object within multiple time ranges.

[0067] Step 108, clear the service count table.

[0068] For example, the cloud filling platform may also maintain an object information table, which stores the object information and quantity information of each object. Among them, the object information is used to represent the object. For example, it may include the object ID of the object, and may also include the usage permissions corresponding to the object. The quantity information is used to represent the quantity of service data corresponding to the object within multiple time ranges. The multiple time ranges may include, for example: the current detection period and before the current detection period. Taking the detection period of 1 day as an example, the quantity information may include: the quantity of service data generated by the object through the cloud filling platform on the current day (which can be expressed as today_submission), and the quantity of service data generated by the object through the cloud filling platform before the current day (which can be expressed as before_submission). After obtaining the service quantity of the service data corresponding to each object in the current detection period recorded in the service count table, the quantity information corresponding to the object in the object information table can be updated according to the service quantity corresponding to each object. In this way, if individual users, enterprise users or technicians query the corresponding quantity information on the current day or before, they can directly query from the object information table. The amount of data in the object information table is very small, which can greatly improve the query speed.

[0069] After steps 102 and 107, the scheduled task can clear the service count table so that the service count table can continue to record the service quantity of the service data corresponding to each object in the next detection week. Further, the scheduled task can also back up the service statistics table for subsequent technicians to verify the cumulative service quantity, service quantity status, etc.

[0070] Figure 5 is a flowchart of another method for processing service information shown according to an exemplary embodiment. As Figure 5 shown, the method may further include:

[0071] Step 109, receive a query instruction, where the query instruction includes the object information of the target object and the query condition.

[0072] Step 110: Query the query results that meet the query conditions corresponding to the target object in the pre-established query wide table, and display the query results. The query wide table includes an object information table and a business data table.

[0073] Exemplarily, the cloud filling platform can also provide query services. Individual users, enterprise users, or technical personnel can send query instructions to the cloud filling platform on a terminal device, or can also send query instructions to the cloud filling platform through a browser or other means. The query instructions can include the object information of the target object and the query conditions. The object information can be, for example, any one or more object instance fields of the target object. The query conditions can include a query time range and / or a query business data type. For example, the query time range included in the query conditions is from July 1, 2021 to July 3, 2021, and the query business data types are: questionnaire data and SMS data.

[0074] After receiving the query instructions, as a response to the query instructions, the cloud filling platform can query the query results that meet the query conditions corresponding to the target object in the pre-established query wide table, and display the query results on the display interface. Among them, the query wide table includes an object information table and a business data table, and can also include a package table. It can be understood that the object information table and the business data table are pre-associated according to a preset association relationship to form a query wide table. In this way, when the cloud filling platform executes the query instructions, it does not need to associate the object information table and the business data table again, and can directly query in the query wide table. Since a large number of business data records are stored in the business data table, if the object information table and the business data table are associated every time the query instructions are executed, it will consume a large amount of processing resources, the query efficiency is very low, and even the problem of query timeout may occur. Therefore, directly querying in the query wide table can effectively improve the query efficiency.

[0075] Furthermore, if the query time range in the query conditions matches the time range characterized by the quantity information in the object information table, then the query can be directly performed in the object information table. If the query time range in the query conditions does not match the time range characterized by the quantity information in the object information table, then the query can be performed in the business data table.

[0076] For example, if the query condition is to query the number of business data generated by the target object through the cloud filling platform on the current day, then the corresponding today_submission of the target object can be directly obtained from the object information table, and used as the query result for display. Another example, if the query condition is to query the number of business data generated by the target object through the cloud filling platform from July 1, 2021 to July 5, 2021, then it can be queried in the business data table for business data records where the generation time is within the period from July 1, 2021 to July 5, 2021 and the object ID matches the target object, so as to obtain the query result for display.

[0077] Figure 6 is a flowchart of another method for processing business information shown according to an exemplary embodiment, as Figure 6 shown, the method may further include:

[0078] Step 111, associate the object information table and the business data table according to the association relationship indicated by the object information, so as to obtain a query wide table including the object information table and the business data table.

[0079] Step 112, synchronize the query wide table to the retrieval engine.

[0080] Correspondingly, the implementation manner of step 110 may be:

[0081] By calling the retrieval engine to execute the query instruction, obtain the query result.

[0082] For example, there are multiple business data records stored in the business data table, and each business data record includes a corresponding object ID. Each object's object ID is also stored in the object information table. That is to say, the object ID is stored in both the business data table and the object information table. Therefore, there is an association relationship between the business data table and the object information table. The object information table and the business data table can be associated according to the association relationship indicated by the object information to obtain a query wide table composed of the object information table and the business data table. The association process can be understood as flattening the object information table and the business data table. The object information table, the package table, and the business data table can also be associated according to the association relationship indicated by the object information to obtain a query wide table composed of the object information table, the package table, and the business data table. After that, the query wide table can be synchronized to the retrieval engine. Correspondingly, the cloud filling platform can call the retrieval engine to execute the query instruction to obtain the query result feedback by the retrieval engine. The retrieval engine can be, for example, an ES (English: Elastic Search) engine. By executing the query instruction through the retrieval engine, the query efficiency can be further improved. Further, when the business data table, and / or the business data table changes, the query wide table can be updated accordingly and the query wide table can be synchronized to the retrieval engine.

[0083] Figure 7 is a flowchart of another method for processing service information shown according to an exemplary embodiment, as Figure 7 shown. The quantity information includes: a first quantity corresponding to a first time range and a second quantity corresponding to a second time range. The first time range corresponds to the current detection period, and the second time range corresponds to the time range before the current detection period. Taking the detection period as 1 day as an example, since the query time ranges with higher frequencies are usually the current day and the day before, the first time range can be set as the current day, and the second time range can be set as the time before the current day. Correspondingly, the first quantity is the quantity of business data generated by this object through the cloud filling platform on the current day, denoted as today_submission. The second quantity is the quantity of business data generated by this object through the cloud filling platform before the current day, denoted as before_submission.

[0084] Correspondingly, the implementation of step 107 may include:

[0085] Step 1071, update the second quantity corresponding to this object to the sum of the second quantity corresponding to this object and the first quantity corresponding to this object.

[0086] Step 1072, update the first quantity corresponding to this object to the business quantity corresponding to this object.

[0087] Exemplarily, when updating the quantity information corresponding to each object in the object information table, the second quantity corresponding to this object can be first updated to the sum of the second quantity corresponding to this object and the first quantity corresponding to this object, that is, before_submission = before_submission + today_submission. Then, the first quantity corresponding to this object is updated to the business quantity corresponding to this object, that is, today_submission = the business quantity of the business data corresponding to this object within the current detection period. In this way, the quantity information corresponding to this object in the object information table can be updated according to the business quantity corresponding to each object. Correspondingly, when the cloud filling platform receives a query instruction, the first quantity and the second quantity can be directly queried in the object information table, which can further improve the query efficiency.

[0088] In summary, first, according to the preset detection period, obtain the business quantity of the business data corresponding to each object in the current detection period recorded in the business count table, where the business count table can be synchronously updated when new business data is added to the business data table. Then, according to the business quantity corresponding to each object, update the business cumulative quantity corresponding to the object in the business statistics table. Further, according to the business cumulative quantity corresponding to each object in the business statistics table, and the warning threshold and total threshold corresponding to the object, determine the business quantity status corresponding to the object. Finally, according to the business quantity status corresponding to each object, determine the usage permission corresponding to the object, which is used to indicate whether the business data table receives the business data corresponding to the object. The present disclosure records the business quantity of business data in each detection period through the business count table, and updates the corresponding business cumulative quantity in the business statistics table, so as to determine the usage permission corresponding to the user, which can realize the standardized management of business data and improve the accuracy of quantity statistics.

[0089] Figure 8 is a block diagram of a processing device for business information shown according to an exemplary embodiment, as Figure 8 shown, the device 200 includes:

[0090] An acquisition module 201, configured to obtain, according to the preset detection period, the business quantity of the business data corresponding to each object in the current detection period recorded in the business count table, and the business count table is synchronously updated when new business data is added to the business data table.

[0091] A first update module 202, configured to update the business cumulative quantity corresponding to the object in the business statistics table according to the business quantity corresponding to each object.

[0092] A status determination module 203, configured to determine the business quantity status corresponding to the object according to the business cumulative quantity corresponding to each object in the business statistics table, and the warning threshold and total threshold corresponding to the object.

[0093] A permission determination module 204, configured to determine the usage permission corresponding to the object according to the business quantity status corresponding to each object, and the usage permission is used to indicate whether the business data table receives the business data corresponding to the object.

[0094] In one implementation, the status determination module 203 may be configured to perform the following steps:

[0095] Step 1) For each object, if the business cumulative quantity corresponding to the object in the business statistics table is less than or equal to the warning threshold, determine that the business quantity status corresponding to the object is the normal status.

[0096] Step 2) If the cumulative business quantity corresponding to the object in the business statistics table is greater than the warning threshold and less than or equal to the total threshold, determine that the business quantity status corresponding to the object is the warning status.

[0097] Step 3) If the cumulative business quantity corresponding to the object in the business statistics table is greater than the total threshold, determine that the business quantity status corresponding to the object is the over - quantity status.

[0098] Correspondingly, the permission determination module 204 can be used to execute the following steps:

[0099] Step 4) If the business quantity status corresponding to the object is the over - quantity status, determine that the usage permission corresponding to the object is closed, to indicate that the business data table rejects receiving the business data corresponding to the object.

[0100] Step 5) If the business quantity status corresponding to the object is the normal status or the warning status, determine that the usage permission corresponding to the object is open, to indicate that the business data table can receive the business data corresponding to the object.

[0101] Figure 9 is a block diagram of another business information processing device shown according to an exemplary embodiment, as Figure 9 shown, the device 200 may further include:

[0102] The label determination module 205 is configured to, after determining the business quantity status corresponding to each object according to the cumulative business quantity corresponding to each object in the business statistics table, the warning threshold corresponding to the object, and the total threshold, for each object, if the business quantity status corresponding to the object is the warning status, determine the sending label corresponding to the object in the business statistics table, and the sending label is used to indicate whether a warning message has been sent for the object.

[0103] The warning module 206 is configured to, when the sending label corresponding to the object is not sent, send a warning message for the object and update the sending label corresponding to the object to sent.

[0104] Figure 10 is a block diagram of another business information processing device shown according to an exemplary embodiment, as Figure 10 shown, the device 200 may further include:

[0105] The second update module 207 is configured to, after obtaining the business quantity of the business data corresponding to each object in the current detection period recorded in the business count table according to a preset detection period, update the quantity information corresponding to the object in the object information table according to the business quantity corresponding to each object. The object information table includes the object information corresponding to each object, and the quantity information is used to characterize the quantity of the business data corresponding to the object in multiple time ranges.

[0106] The clearing module 208 is used to clear the service count table.

[0107] Figure 11 It is a block diagram of another service information processing device shown according to an exemplary embodiment. As Figure 11 shown, the device 200 may further include:

[0108] The receiving module 209 is used to receive a query instruction, and the query instruction includes the object information of the target object and the query condition.

[0109] The query module 210 is used to query the query result corresponding to the target object that meets the query condition in the pre-established query wide table and display the query result. The query wide table includes the object information table and the service data table.

[0110] Figure 12 It is a block diagram of another service information processing device shown according to an exemplary embodiment. As Figure 12 shown, the device 200 may further include:

[0111] The association module 211 is used to associate the object information table and the service data table according to the association relationship indicated by the object information to obtain a query wide table including the object information table and the service data table.

[0112] The synchronization module 212 is used to synchronize the query wide table to the retrieval engine.

[0113] Correspondingly, the query module 210 can be used to:

[0114] Execute the query instruction by calling the retrieval engine to obtain the query result.

[0115] In another implementation, the quantity information includes: the first quantity corresponding to the first time range and the second quantity corresponding to the second time range. The first time range corresponds to the current detection period, and the second time range corresponds to the time range before the current detection period.

[0116] Correspondingly, the second update module 207 can be used to perform the following steps:

[0117] Step 6) Update the second quantity corresponding to the object to the sum of the second quantity corresponding to the object and the first quantity corresponding to the object.

[0118] Step 7) Update the first quantity corresponding to the object to the service quantity corresponding to the object.

[0119] Regarding the device in the above embodiments, the specific manners in which each module performs operations have been described in detail in the embodiments related to the method, and will not be elaborated herein.

[0120] In summary, first, according to a preset detection period, obtain the business quantity of the business data corresponding to each object in the current detection period recorded in the business count table, where the business count table can be synchronously updated when new business data is added to the business data table. Then, according to the business quantity corresponding to each object, update the business cumulative quantity corresponding to the object in the business statistics table. Further, according to the business cumulative quantity corresponding to each object in the business statistics table, the warning threshold and the total quantity threshold corresponding to the object, determine the business quantity status corresponding to the object. Finally, according to the business quantity status corresponding to each object, determine the usage permission corresponding to the object, which is used to indicate whether the business data table receives the business data corresponding to the object. The present disclosure records the business quantity of business data in each detection period through the business count table and updates the corresponding business cumulative quantity in the business statistics table, thereby determining the usage permission corresponding to the user, and can realize the standardized management of business data and improve the accuracy of quantity statistics.

[0121] Figure 13 is a block diagram of an electronic device 300 shown according to an exemplary embodiment. As Figure 13 shown, the electronic device 300 may include: a processor 301, a memory 302. The electronic device 300 may further include one or more of a multimedia component 303, an input / output (I / O) interface 304, and a communication component 305.

[0122] Among them, the processor 301 is used to control the overall operation of the electronic device 300 to complete all or part of the steps in the above-mentioned method for processing service information. The memory 302 is used to store various types of data to support the operation of the electronic device 300. These data may include, for example, instructions for any application or method operating on the electronic device 300, as well as application-related data, such as contact data, received and sent messages, pictures, audio, video, and so on. The memory 302 can be implemented by any type of volatile or non-volatile storage device or a combination thereof, such as Static Random Access Memory (SRAM), Electrically Erasable Programmable Read-Only Memory (EEPROM), Erasable Programmable Read-Only Memory (EPROM), Programmable Read-Only Memory (PROM), Read-Only Memory (ROM), magnetic memory, flash memory, a magnetic disk, or an optical disc. The multimedia component 303 may include a screen and an audio component. The screen may be, for example, a touch screen, and the audio component is used to output and / or input audio signals. For example, the audio component may include a microphone for receiving external audio signals. The received audio signal may be further stored in the memory 302 or sent through the communication component 305. The audio component also includes at least one speaker for outputting audio signals. The I / O interface 304 provides an interface between the processor 301 and other interface modules, and the above-mentioned other interface modules may be a keyboard, a mouse, buttons, etc. These buttons may be virtual buttons or physical buttons. The communication component 305 is used for wired or wireless communication between the electronic device 300 and other devices. Wireless communication, such as Wi-Fi, Bluetooth, Near Field Communication (NFC), 2G, 3G, 4G, NB-IoT, eMTC, or other 5G, etc., or a combination of one or more of them, is not limited herein. Therefore, the corresponding communication component 305 may include: a Wi-Fi module, a Bluetooth module, an NFC module, and so on.

[0123] In an exemplary embodiment, the electronic device 300 can be implemented by one or more application specific integrated circuits (ASICs), digital signal processors (DSPs), digital signal processing devices (DSPDs), programmable logic devices (PLDs), field programmable gate arrays (FPGAs), controllers, microcontrollers, microprocessors, or other electronic components, and is used to execute the above-mentioned method for processing service information.

[0124] In another exemplary embodiment, a computer-readable storage medium including program instructions is also provided. When the program instructions are executed by a processor, the steps of the above-mentioned method for processing service information are implemented. For example, the computer-readable storage medium can be the above-mentioned memory 302 including program instructions, and the above-mentioned program instructions can be executed by the processor 301 of the electronic device 300 to complete the above-mentioned method for processing service information.

[0125] Figure 14 FIG. is a block diagram of an electronic device 400 shown according to an exemplary embodiment. For example, the electronic device 400 can be provided as a server. Referring to Figure 14 , the electronic device 400 includes a processor 422, the number of which can be one or more, and a memory 432 for storing computer programs executable by the processor 422. The computer programs stored in the memory 432 can include one or more modules each corresponding to a set of instructions. In addition, the processor 422 can be configured to execute the computer program to execute the above-mentioned method for processing service information.

[0126] In addition, the electronic device 400 can further include a power supply component 426 and a communication component 450. The power supply component 426 can be configured to perform power management of the electronic device 400, and the communication component 450 can be configured to implement communication of the electronic device 400, for example, wired or wireless communication. In addition, the electronic device 400 can further include an input / output (I / O) interface 458. The electronic device 400 can operate based on an operating system stored in the memory 432, such as Windows Server TM , Mac OSX TM , Unix TM , Linux TM and so on.

[0127] In another exemplary embodiment, a computer-readable storage medium including program instructions is further provided. When the program instructions are executed by a processor, the steps of the above-described method for processing service information are implemented. For example, the non-transitory computer-readable storage medium may be the above-described memory 432 including program instructions, and the above program instructions may be executed by the processor 422 of the electronic device 400 to complete the above-described method for processing service information.

[0128] In another exemplary embodiment, a computer program product is further provided. The computer program product includes a computer program that can be executed by a programmable device, and the computer program has a code portion for executing the above-described method for processing service information when executed by the programmable device.

[0129] The preferred embodiments of the present disclosure have been described in detail above with reference to the accompanying drawings. However, the present disclosure is not limited to the specific details in the above embodiments. Within the scope of the technical concept of the present disclosure, various simple modifications can be made to the technical solutions of the present disclosure, and these simple modifications all fall within the protection scope of the present disclosure.

[0130] In addition, it should be noted that, in the above specific embodiments, the various specific technical features described can be combined in any suitable manner without contradiction. To avoid unnecessary repetition, the present disclosure does not separately describe various possible combination manners.

[0131] Furthermore, any combination can be made between various different embodiments of the present disclosure as long as it does not violate the idea of the present disclosure, and it should also be regarded as the content disclosed by the present disclosure.

Claims

1. A method for processing service information, characterized in that, The method includes: According to a preset detection period, obtaining the service quantity of the service data corresponding to each object within the current detection period recorded in the service count table, where the service count table is synchronously updated when new service data is added to the service data table; Updating the cumulative service quantity corresponding to each object in the service statistics table according to the service quantity corresponding to each object; Determining the service quantity status corresponding to each object according to the cumulative service quantity corresponding to each object in the service statistics table, the warning threshold corresponding to the object, and the total threshold; Determining the usage permission corresponding to each object according to the service quantity status corresponding to each object, where the usage permission is used to indicate whether the service data table receives the service data corresponding to the object; The determining the service quantity status corresponding to each object according to the cumulative service quantity corresponding to each object in the service statistics table, the warning threshold corresponding to the object, and the total threshold includes: For each object, if the cumulative service quantity corresponding to the object in the service statistics table is less than or equal to the warning threshold, determining that the service quantity status corresponding to the object is the normal status; If the cumulative service quantity corresponding to the object in the service statistics table is greater than the warning threshold and less than or equal to the total threshold, determining that the service quantity status corresponding to the object is the warning status; If the cumulative service quantity corresponding to the object in the service statistics table is greater than the total threshold, determining that the service quantity status corresponding to the object is the over-quantity status.

2. The method according to claim 1, wherein The determining the usage permission corresponding to each object according to the service quantity status corresponding to each object includes: If the service quantity status corresponding to the object is the over-quantity status, determining that the usage permission corresponding to the object is closed to indicate that the service data table rejects the service data corresponding to the object; If the service quantity status corresponding to the object is the normal status or the warning status, determining that the usage permission corresponding to the object is open to indicate that the service data table can receive the service data corresponding to the object.

3. The method according to claim 2, wherein After determining the service quantity status corresponding to each object according to the cumulative service quantity corresponding to each object in the service statistics table, the warning threshold corresponding to the object, and the total threshold, the method further includes: For each object, if the service quantity status corresponding to the object is the warning status, determining the sending label corresponding to the object in the service statistics table, where the sending label is used to indicate whether a warning message has been sent for the object; In the case where the sending label corresponding to the object is not sent, sending the warning message for the object and updating the sending label corresponding to the object to sent.

4. The method according to claim 1, characterized in that, After obtaining the service quantity of the service data corresponding to each object within the current detection period recorded in the service count table according to the preset detection period, the method further includes: Update the quantity information corresponding to each object in the object information table according to the number of services corresponding to each object. The object information table includes the object information corresponding to each object, and the quantity information is used to represent the quantity of service data corresponding to the object within multiple time ranges; Empty the service count table.

5. The method according to claim 4, wherein The method further includes: Receive a query instruction, where the query instruction includes the object information of the target object and a query condition; Query the query result corresponding to the target object that meets the query condition in a pre-established query wide table, and display the query result. The query wide table includes the object information table and the service data table.

6. The method according to claim 5, wherein The method further includes: Associate the object information table and the service data table according to the association relationship indicated by the object information to obtain the query wide table including the object information table and the service data table; Synchronize the query wide table to the retrieval engine; The querying of the query result corresponding to the target object that meets the query condition in the pre-established query wide table includes: Obtain the query result by calling the retrieval engine to execute the query instruction.

7. The method according to claim 4, characterized in that, The quantity information includes: a first quantity corresponding to a first time range and a second quantity corresponding to a second time range. The first time range corresponds to the current detection period, and the second time range corresponds to the time range before the current detection period; The updating of the quantity information corresponding to each object in the object information table according to the number of services corresponding to each object includes: Update the second quantity corresponding to the object to the sum of the second quantity corresponding to the object and the first quantity corresponding to the object; Update the first quantity corresponding to the object to the number of services corresponding to the object.

8. A processing device for service information, characterized in that The device includes: An acquisition module, configured to acquire the number of services of the service data corresponding to each object within the current detection period recorded in the service count table according to a preset detection period. The service count table is synchronously updated when new service data is added to the service data table; A first update module, configured to update the service cumulative quantity corresponding to each object in the service statistics table according to the number of services corresponding to each object; A status determination module, configured to determine the service quantity status corresponding to each object according to the service cumulative quantity corresponding to each object in the service statistics table, the warning threshold corresponding to the object, and the total threshold; A permission determination module, configured to determine the usage permission corresponding to each object according to the service quantity status corresponding to each object. The usage permission is used to indicate whether the service data table receives the service data corresponding to the object; The state determination module is configured to, for each of the objects, if the cumulative business quantity corresponding to the object in the business statistics table is less than or equal to the warning threshold, determine that the business quantity state corresponding to the object is a normal state; if the cumulative business quantity corresponding to the object in the business statistics table is greater than the warning threshold and less than or equal to the total threshold, determine that the business quantity state corresponding to the object is a warning state; if the cumulative business quantity corresponding to the object in the business statistics table is greater than the total threshold, determine that the business quantity state corresponding to the object is an over-quantity state.

9. A non-transitory computer-readable storage medium having a computer program stored thereon, characterized in that, When executed by a processor, the program implements the steps of the method according to any one of claims 1-7.

10. An electronic device, characterized in that, Comprising: A memory having a computer program stored thereon; A processor for executing the computer program in the memory to implement the steps of the method according to any one of claims 1-7.

Citation Information

Patent Citations

  • Method and system for warning service triggering

    CN101997730A

  • Data management method, device and system, big data platform and readable storage medium

    CN111552719A