CN114239510A - Service information processing method and device, storage medium and electronic equipment - Google Patents
Service information processing method and device, storage medium and electronic equipment Download PDFInfo
- Publication number
- CN114239510A CN114239510A CN202111580656.1A CN202111580656A CN114239510A CN 114239510 A CN114239510 A CN 114239510A CN 202111580656 A CN202111580656 A CN 202111580656A CN 114239510 A CN114239510 A CN 114239510A
- Authority
- CN
- China
- Prior art keywords
- service
- business
- information
- service data
- state
- 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
Images
Classifications
-
- 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
- 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
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- 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/24—Querying
- G06F16/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Software Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The disclosure relates to a method, a device, a storage medium and an electronic device for processing service information, relating to the technical field of electronic information processing, wherein the method comprises the following steps: and according to a preset detection period, acquiring the business quantity of the business data corresponding to each object in the current detection period recorded in a business counting table, and synchronously updating the business counting table under the condition that the business data is newly added in a business data table. And updating the service accumulated quantity corresponding to each object in the service statistical table according to the service quantity corresponding to each object. And determining the business quantity state corresponding to the object according to the business accumulated quantity corresponding to each object in the business statistical table, and the early warning threshold value and the total quantity threshold value corresponding to the object. And determining the use authority corresponding to each object according to the service quantity state corresponding to each object, wherein the use authority is used for indicating whether the service data table receives the service data corresponding to the object. The method and the device can realize standardized management of the service data and improve the accuracy of quantity statistics.
Description
Technical Field
The present disclosure relates to the field of electronic information processing technologies, and in particular, to a method and an apparatus for processing service information, a storage medium, and an electronic device.
Background
With the rapid development of information technologies such as internet and cloud computing, the data volume brought correspondingly also shows explosive growth. Many forms, questionnaires, etc. of business data can be filled in and collected over the network. Different users have different demands on service data, so packages meeting the demands can be ordered through the cloud filing platform. In the process of collecting the service data uploaded by the user, the cloud filling platform counts the number of the service data to determine whether the service data meet the specification of the corresponding package. Since the user may modify or delete the service data, there may be a deviation in counting the amount of the service data.
Disclosure of Invention
The present disclosure is directed to a method, an apparatus, a storage medium, and an electronic device for processing service information, so as to solve the related problems in the prior art.
In order to achieve the above object, according to a first aspect of the embodiments of the present disclosure, there is provided a method for processing service information, the method including:
acquiring the service quantity of service data corresponding to each object in the current detection period recorded in a service counting table according to a preset detection period, wherein the service counting table is synchronously updated under the condition that service data are newly added in a service data table;
updating the business accumulated quantity corresponding to each object in a business statistical table according to the business quantity corresponding to each object;
determining the business quantity state corresponding to the object according to the business accumulated quantity corresponding to each object in the business statistical table, and the early warning threshold value and the total quantity threshold value corresponding to the object;
and determining the use authority corresponding to each object according to the service quantity state corresponding to each object, wherein the use authority is used for indicating whether the service data table receives the service data corresponding to the object.
According to a second aspect of the embodiments of the present disclosure, there is provided an apparatus for processing service information, the apparatus including:
the acquisition module is used for acquiring the business quantity of the business data corresponding to each object in the current detection period recorded in a business counting table according to the preset detection period, and the business counting table is synchronously updated under the condition that the business data are newly added in a business data table;
the first updating module is used for updating the business accumulated quantity corresponding to each object in the business statistical table according to the business quantity corresponding to each object;
the state determining module is used for determining the business quantity state corresponding to the object according to the business accumulated quantity corresponding to each object in the business statistical table, and the early warning threshold value and the total quantity threshold value corresponding to the object;
and the permission determining module is used for determining the use permission corresponding to each object according to the service quantity state corresponding to each object, and the use permission is used for indicating whether the service data table receives the service data corresponding to the object.
According to a third aspect of embodiments of the present disclosure, there is provided a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of the method of the first aspect of embodiments of the present disclosure.
According to a fourth aspect of the embodiments of the present disclosure, there is provided an electronic apparatus including:
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 of the first aspect of an embodiment of the disclosure.
According to the technical scheme, firstly, the service quantity of the service data corresponding to each object in the current detection period recorded in the service counting table is obtained according to the preset detection period, wherein the service counting table can be synchronously updated under the condition that the service data is newly added in the service data table. And then updating the business accumulated quantity corresponding to the object in the business statistical table according to the business quantity corresponding to each object. And further determining the business quantity state corresponding to the object according to the business accumulated quantity corresponding to each object in the business statistical table, and the early warning threshold value and the total quantity threshold value corresponding to the object. And finally, determining the service quantity state corresponding to each object, wherein the service quantity state corresponds to the object and is used for indicating whether the service data table receives the service data usage right corresponding to the object. According to the method and the device, the service counting table is used for recording the service quantity of the service data in each detection period, and the corresponding service accumulated quantity in the service counting table is updated, so that the use permission corresponding to the user is determined, the standardized management of the service data can be realized, and the accuracy of quantity counting is improved.
Additional features and advantages of the disclosure will be set forth in the detailed description which follows.
Drawings
The accompanying drawings, which are included to provide a further understanding of the disclosure and are incorporated in and constitute a part of this specification, illustrate embodiments of the disclosure and together with the description serve to explain the disclosure without limiting the disclosure. In the drawings:
fig. 1 is a flow chart illustrating a method of processing traffic information according to an example embodiment;
fig. 2 is a flow chart illustrating another method of processing traffic information according to an example embodiment;
fig. 3 is a flow chart illustrating another method of processing traffic information according to an example embodiment;
FIG. 4 is a flow chart illustrating another method of processing traffic information in accordance with an exemplary embodiment;
fig. 5 is a flowchart illustrating another method of processing traffic information according to an example embodiment;
fig. 6 is a flowchart illustrating another method of processing traffic information according to an example embodiment;
fig. 7 is a flowchart illustrating another method of processing traffic information according to an example embodiment;
FIG. 8 is a block diagram illustrating an apparatus for processing traffic information in accordance with an exemplary embodiment;
fig. 9 is a block diagram illustrating another apparatus for processing traffic information according to an example embodiment;
fig. 10 is a block diagram illustrating another apparatus for processing traffic information according to an example embodiment;
fig. 11 is a block diagram illustrating another apparatus for processing traffic information according to an example embodiment;
fig. 12 is a block diagram illustrating another apparatus for processing traffic information according to an example embodiment;
FIG. 13 is a block diagram illustrating an electronic device in accordance with an exemplary embodiment;
FIG. 14 is a block diagram illustrating an electronic device in accordance with an example embodiment.
Detailed Description
Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, like numbers in different drawings represent the same or similar elements unless otherwise indicated. The implementations described in the exemplary embodiments below are not intended to represent all implementations consistent with the present disclosure. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the present disclosure, as detailed in the appended claims.
Before introducing the service information processing method, the service information processing device, the service information storage medium and the electronic device, an application scenario related to each embodiment of the present disclosure is introduced, where the application scenario may be a cloud filling platform, the cloud filling platform may provide multiple package services, and each object may order the package service meeting requirements through the cloud filling platform. The object may be understood as a user renting the cloud filing platform, and may be a personal user or an enterprise user, which is not specifically limited by the present disclosure. The package service is used for limiting the number of business data which can be filled by the corresponding object and can be supported by the cloud filling platform. The personal user, the enterprise user or the technical personnel can access the cloud filling platform through terminal equipment, and can also access the cloud filling platform through a browser and the like. The terminal device can 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.
Fig. 1 is a flowchart illustrating a method for processing service information according to an exemplary embodiment, where the method includes the following steps, as shown in fig. 1:
For example, the cloud filing platform may maintain a service data table, each object may generate service data through the cloud filing platform, and then the cloud filing platform may store the service data into the service data table. The business data table stores a large number of business data records, each business data record comprises a piece of business data, an object ID corresponding to the business data, generation time and other information, and the object ID can uniquely identify an object. For example, a service data record may be structured as: { object ID, traffic data, production time }. The service data may be classified into various types, for example: the object can submit questionnaire data through the cloud filling platform, the object can also send short message data through the cloud filling platform, and the object can also upload file data (which can comprise text files, image files, audio files and the like) through the cloud filling platform.
Furthermore, the cloud filing platform can also maintain a business counting table, and the business counting table records the business quantity of the business data corresponding to each object in the current detection period according to the preset detection period. The detection period is set to one day. And the business counting table is used for recording the business quantity of the business data corresponding to each object in each day. The service counting table may include a counting record corresponding to each object, and the structure of the counting record may be { object ID, service type, service number, user ID, service ID }. When a new piece of service data is added in the service data table, the service quantity in the service counting table is synchronously updated. The number of services may be understood as the number of pieces of service data, and may also be understood as the size of the service data. For example, the service data may be divided into questionnaire data, short message data, and file data, and then the service quantity may include: the number of pieces of questionnaire data, the number of pieces of short message data, and the size of file data (the unit may be KB or MB, for example), and the structure of the corresponding count record may be divided into three count records of { object ID, questionnaire data type, number of pieces of questionnaire data, user ID, service ID }, { object ID, short message data type, number of pieces of short message data, user ID, service ID }, { object ID, file data type, size of file data, user ID, service ID }, and the like, which are stored separately.
The cloud filling platform can acquire the service quantity of the service data corresponding to each object in the current detection period recorded in the service counting table according to the detection period. Taking the detection period as one day for example, the cloud filing platform may set a timing task, and the timing task reads the business quantity of the business data corresponding to each object in the business count table at 2 o' clock of each day in the day.
And 102, updating the business accumulated quantity corresponding to each object in the business statistical table according to the business quantity corresponding to each object.
For example, the cloud filing platform may further maintain a service statistical table, and the service statistical table records the service cumulative number corresponding to each object. The service statistics table may include a cumulative record corresponding to each object, and the structure of the cumulative record may be { object ID, service cumulative number }. After the service quantity of the service data corresponding to each object in the current detection period recorded in the service count table is obtained, the service cumulative quantity corresponding to the object in the service statistical table can be updated accordingly. For example, the service quantity corresponding to the object may be added to the service cumulative quantity corresponding to the object in the service statistics table as the updated service cumulative quantity corresponding to the object in the service statistics table. The accumulated amount of the business can be understood as the total amount of the business data generated by the object through the cloud filling platform from the time when the object subscribes to the corresponding package service to the time when the current detection period is finished. For example, in the business count table, 55 pieces of questionnaire data are submitted by the object a through the cloud filing platform in the previous day, that is, the number of businesses corresponding to the object a is 55. If the accumulated number of the traffic corresponding to the a object in the traffic statistics table is 171, the accumulated number of the traffic corresponding to the a object in the traffic statistics table may be updated to 171+55 — 226.
Because a large number of service data records are stored in the service data table, if a service statistical table firstly inquires how much service data is generated in a detection period from the service data table, and then updates the corresponding service accumulated quantity, a large amount of data needs to be processed, and the updating efficiency is low. Meanwhile, since the service data stored in the service data table may be modified or deleted, if the service statistical table updates the corresponding service cumulative number according to the service data table, a deviation may occur. And through the service statistical table which can be updated synchronously with the service data table, the service data generated by each object through the cloud filling platform can be accurately recorded, so that the corresponding service accumulated quantity is updated according to the service statistical table, and the updating efficiency and accuracy can be improved.
And 103, determining the business quantity state corresponding to the object according to the business accumulated quantity corresponding to each object in the business statistical table, and the early warning threshold value and the total quantity threshold value corresponding to the object.
And 104, determining the use authority corresponding to each object according to the service quantity state corresponding to each object, wherein the use authority is used for indicating whether the service data table receives the service data corresponding to the object.
For example, the service statistical table further records an early warning threshold and a total threshold of service data ordered by each object through the cloud filling platform, where the total threshold is used to indicate a maximum value of the service data that the object can generate through the cloud filling platform, and the early warning threshold is used to indicate that the number of the service data currently generated by the object through the cloud filling platform is close to the total threshold, for example, the early warning threshold may be 80% of the total threshold. And the total amount threshold value is consistent with the total amount threshold value recorded in the package table maintained by the cloud filing platform. The package table may include package service records of package services ordered by each object on the cloud filing platform, the package service records include package service identifiers, total amount thresholds, package service valid flag bits (used for indicating whether the package services are valid), and the like corresponding to the object, and the package service records may have a structure: { object ID, package service identifier, total amount threshold, package service valid flag }. After the business accumulated quantity corresponding to the object in the business statistics table is updated in step 102, the business accumulated quantity corresponding to each object in the business statistics table may be respectively compared with the early warning threshold value and the total threshold value corresponding to the object to determine the business quantity state corresponding to the object. The traffic volume status may also be stored in a traffic statistics table. Further, the usage right corresponding to the object may be determined according to the service quantity state corresponding to the object.
The traffic volume status may include three types: the cloud reporting platform comprises a normal state, an early warning state and an excess state, wherein the normal state indicates that the number of the business data generated by the object through the cloud reporting platform is within the range of a total threshold value, and early warning is not needed. The early warning state indicates that the number of the business data generated by the object through the cloud filling platform is within the range of the total amount threshold value and is close to the total amount threshold value, and early warning needs to be carried out. The excess state indicates that the amount of the business data generated by the object through the cloud filling platform exceeds a total amount threshold value. Accordingly, the usage rights can be divided into two types: and opening and closing, wherein the opening indicates that the business data table can receive the business data corresponding to the object, namely the object can generate the business data through the cloud filling platform, and the closing indicates that the business data table refuses to receive the business data corresponding to the object, namely the object cannot generate the business data through the cloud filling platform. When the service quantity state is a normal state or an early warning state, the use permission can be determined to be open, and when the service quantity state is an excess state, the use permission can be determined to be closed.
Under the condition of comprising various service data, the service statistical table can record the early warning threshold value and the total threshold value of each service data corresponding to each object. For example, the service data is divided into questionnaire data, short message data, and file data, and then the service statistics table may record a questionnaire warning threshold, a questionnaire total amount threshold, a short message warning threshold, a short message total amount threshold, a file warning threshold, and a file total amount threshold corresponding to each object. Correspondingly, the service quantity status may also include a service quantity status corresponding to each service data, and may include, for example: questionnaire service quantity state, short message service quantity state and file service quantity state. Further, the usage right may also include a usage right corresponding to each service data, and for example, may include: questionnaire use authority, short message use authority and file use authority. Correspondingly, the structure of the cumulative record may be { object ID, questionnaire warning threshold, questionnaire total amount threshold, short message warning threshold, short message total amount threshold, file warning threshold, file total amount threshold, questionnaire service cumulative amount, short message service cumulative amount, file service cumulative amount, questionnaire service amount status, short message service amount status, file service amount status }.
The service statistical table and the service data table can be updated synchronously, so that the corresponding service accumulated quantity can be determined quickly and accurately, the service quantity state and the use permission corresponding to each object can be accurately judged, the standardized management of service data can be realized, and the service efficiency and the accuracy of the cloud filling platform are improved.
In summary, firstly, 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 is obtained, wherein the service count table can be synchronously updated under the condition that the service data is newly added in the service data table. And then updating the business accumulated quantity corresponding to the object in the business statistical table according to the business quantity corresponding to each object. And further determining the business quantity state corresponding to the object according to the business accumulated quantity corresponding to each object in the business statistical table, and the early warning threshold value and the total quantity threshold value corresponding to the object. And finally, determining the service quantity state corresponding to each object, wherein the service quantity state corresponds to the object and is used for indicating whether the service data table receives the service data usage right corresponding to the object. According to the method and the device, the service counting table is used for recording the service quantity of the service data in each detection period, and the corresponding service accumulated quantity in the service counting table is updated, so that the use permission corresponding to the user is determined, the standardized management of the service data can be realized, and the accuracy of quantity counting is improved.
Fig. 2 is a flowchart illustrating another service information processing method according to an exemplary embodiment, and as shown in fig. 2, the implementation manner of step 103 may include:
and step 1031, for each object, if the accumulated number of the services corresponding to the object in the service statistical table is less than or equal to the early warning threshold, determining that the state of the number of the services corresponding to the object is a normal state.
For example, the accumulated number of services corresponding to each object in the service statistics table may be compared with an early warning threshold, and if the accumulated number of services corresponding to each object is less than or equal to the early warning threshold, the state of the number of services corresponding to the object may be determined to be a normal state. If the total quantity is greater than the early warning threshold, the accumulated quantity of the business corresponding to the object can be further compared with the total quantity threshold, and if the total quantity is greater than the early warning threshold and less than or equal to the total quantity threshold, the state of the business quantity corresponding to the object can be determined to be the early warning state. If the total amount is larger than the total amount threshold value, the service quantity state corresponding to the object can be determined to be an excess state. Further, if the service quantity state corresponding to the object is determined to be the early warning state, early warning information can be sent to the object so as to early warn that the quantity of the service data generated by the object through the cloud filling platform is close to the total quantity threshold value. For example, the method may send the pre-warning information in the form of a short message, an email, or the like to the terminal device specified by the object, or send the pre-warning information in the form of a popup, an in-station message, or the like to the account registered by the object.
Accordingly, the implementation of step 104 may include:
and if the service quantity state corresponding to the object is an excess state, determining that the use permission corresponding to the object is closed so as to indicate a service data table to refuse to receive the service data corresponding to the object. And if the service quantity state corresponding to the object is a normal state or an early warning state, determining that the use permission corresponding to the object is open so as to indicate that the service data table can receive the service data corresponding to the object.
For example, when the service quantity state is a normal state or an early warning state, it may be determined that the usage right is open, that is, the object may generate service data through the cloud filing platform. When the service quantity state is the excess state, the use authority can be determined to be closed, namely the object cannot generate service data through the cloud filing platform.
In the case of including a plurality of kinds of service data, the usage right corresponding to each object may include a usage right of each kind of service data. For example, the service data is divided into questionnaire data, short message data, and file data, and then the usage right corresponding to each object may include: questionnaire use authority, short message use authority and file use authority. The questionnaire use permission is closed, the object cannot submit questionnaire data through the cloud filling platform (and cannot be manually opened), the short message use permission is closed, the object cannot send short message data through the cloud filling platform, and the file use permission is closed, the object cannot upload file data through the cloud filling platform.
Fig. 3 is a flowchart illustrating another method for processing service information according to an exemplary embodiment, where as shown in fig. 3, after step 103, the method may further include:
and 105, for each object, if the service quantity state corresponding to the object is the early warning state, determining a sending tag corresponding to the object in the service statistical table, wherein the sending tag is used for indicating whether early warning information is sent for the object.
And 106, under the condition that the sending tag corresponding to the object is not sent, sending early warning information to the object, and updating the sending tag corresponding to the object to be sent.
For example, for each object, the cloud filling platform may send the warning information for the object only when it is determined that the traffic volume state corresponding to the object is the warning state for the first time, and then no longer send the warning information for the object when it is determined that the traffic volume state corresponding to the object is the warning state again. Specifically, a sending tag may be added to the cumulative record corresponding to each object in the service statistics table, so as to identify whether the warning information has been sent to the object, where for example, the sending tag is 0, which indicates that the warning information has not been sent, and the sending tag is 1, which indicates that the warning information has been sent. In step 103, when it is determined that the service quantity state corresponding to a certain object is the early warning state, the sending tag corresponding to the object may be queried from the service statistics table, and if the sending tag corresponding to the object is sent, it indicates that the cloud filling platform has sent the early warning information for the object, and no processing may be performed, so as to avoid waste of transmission resources due to repeated sending of the early warning information for the object. If the sending tag corresponding to the object is not sent, the early warning information is not sent to the object by the cloud filling platform, the early warning information can be sent to the object, and meanwhile, the sending tag corresponding to the object in the business statistical table is updated to be sent.
Fig. 4 is a flowchart illustrating another method for processing service information according to an exemplary embodiment, where as shown in fig. 4, after step 101, the method may further include:
And step 108, emptying the business count table.
For example, the cloud filing platform may further maintain an object information table, where object information and quantity information of each object are stored in the object information table, where the object information is used to characterize the object, and may include, for example, an object ID of the object, and may also include a usage right corresponding to the object. The quantity information is used to characterize the quantity of the corresponding service data of the object in a plurality of time ranges, which may include, for example: the current detection period and before the current detection period. Taking the detection period as 1 day for example, the quantity information may include: the amount of business data generated by the object through the cloud filling platform on the current day (may be denoted as today _ sub) and the amount of business data generated by the object through the cloud filling platform before the current day (may be denoted as before _ sub). After the service quantity of the service data corresponding to each object in the current detection period recorded in the service count table is obtained, the quantity information corresponding to the object in the object information table can be updated according to the service quantity corresponding to each object. Therefore, if the personal user, the enterprise user or the technical personnel have the corresponding quantity information on the current day or before, the personal user, the enterprise user or the technical personnel can directly inquire the quantity information from the object information table, the data quantity in the object information table is small, and the inquiring speed can be greatly improved.
After steps 102, 107, the timing task may clear the traffic count table, so that the traffic count table may continue to record the traffic amount of the traffic data corresponding to each object in the next detection week. Further, the timing task can also back up the service statistical table, so that a subsequent technician can check the service accumulated quantity, the service quantity state and the like.
Fig. 5 is a flowchart illustrating another method for processing service information according to an exemplary embodiment, where as shown in fig. 5, the method may further include:
And 110, inquiring the inquiry result which corresponds to the target object and meets the inquiry condition in a pre-established inquiry wide table, and displaying the inquiry result, wherein the inquiry wide table comprises an object information table and a service data table.
For example, the cloud filing platform may further provide query services, and an individual user, an enterprise user, or a technician may send a query instruction to the cloud filing platform through a terminal device, or may send a query instruction to the cloud filing platform through a browser or the like. The query instruction may include object information of the target object and a query condition. The object information may be, for example, any one or more object instance fields of the target object, and the query condition may include a query time range, and/or a query business data type. For example, the query conditions include a query time range from 7/month 1 in 2021 to 7/month 3 in 2021, and the query service data types are: questionnaire data and short message data.
After receiving the query instruction, the cloud filing platform can query the query result meeting the query condition corresponding to the target object in the pre-established query broad table as a response to the query instruction, and display the query result on the display interface. The query wide table includes an object information table, a service data table, and a package table. The query broad table is formed by associating the object information table and the service data table in advance according to a preset association relation, so that the cloud filing platform can directly query the query broad table without associating the object information table with the service data table when executing a query instruction. Because a large number of service data records are stored in the service data table, if the query instruction is executed each time, the object information table and the service data table are associated, a large number of processing resources are consumed, the query efficiency is low, and even the problem of query timeout is caused, so that the query is directly performed in the query wide table, and the query efficiency can be effectively improved.
Furthermore, if the query time range in the query condition is matched with the time range represented by the quantity information in the object information table, the query can be directly performed in the object information table. If the query time range in the query condition does not match the time range represented by the quantity information in the object information table, the query can be performed in the service data table.
For example, if the query condition is to query the amount of service data generated by the target object through the cloud filing platform on the current day, the today _ subscription corresponding to the target object can be directly obtained in the object information table, and the today _ subscription is used as a query result and displayed. For another example, if the query condition is to query the amount of business data generated by the target object through the cloud filing platform within 7/month 1 in 2021 to 7/month 5 in 2021, then the business data table may be queried, the generation time is within 7/month 1 in 2021 to 7/month 5 in 2021, and the business data records with the object ID matched with the target object are obtained and displayed.
Fig. 6 is a flowchart illustrating another method for processing service information according to an exemplary embodiment, where as shown in fig. 6, the method may further include:
and step 111, associating the object information table with the service data table according to the association relation indicated by the object information to obtain a query width table comprising the object information table and the service data table.
Accordingly, the implementation manner of step 110 may be:
and acquiring a query result by calling a retrieval engine to execute the query instruction.
For example, a plurality of service data records are stored in the service data table, each service data record includes a corresponding object ID, and an object ID of each object is also stored in the object information table, that is, the service data table and the object information table both store the object ID, so that the service data table and the object information table have an association relationship. The object information table and the service data table may be associated 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, and the association process may be understood as flattening the object information table and the service data table. The object information table, the package table and the service data table can be associated according to the association relation indicated by the object information to obtain a query wide table consisting of the object information table, the package table and the service data table. And then, synchronizing the query broad table to the retrieval engine, and correspondingly, the cloud filing platform can execute the query instruction by calling the retrieval engine to obtain a query result fed back by the retrieval engine. Wherein the Search engine may be, for example, an ES (english: Elastic Search) engine. By executing the query instruction by the retrieval engine, the query efficiency can be further improved. Furthermore, when the service data table and/or the service data table changes, the query wide table can be updated correspondingly, and the query wide table is synchronized to the retrieval engine.
Fig. 7 is a flowchart illustrating another processing method of service information according to an exemplary embodiment, where as shown in fig. 7, the quantity information includes: a first quantity corresponding to the first time range and a second quantity corresponding to the second time range, wherein 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 range with a high frequency of occurrence is usually the current day and before the current day, the first time range may be set as the current day, and the second time range may be set as the time before the current day. Correspondingly, the first quantity is the quantity of the business data generated by the object through the cloud filling platform on the current day, and is represented as today _ sub. The second quantity is the quantity of the business data generated by the object through the cloud filling platform before the current day, and is represented as before _ sub.
Accordingly, the implementation of step 107 may include:
For example, when the quantity information corresponding to each object in the object information table is updated, the second quantity corresponding to the object may be updated to be the sum of the second quantity corresponding to the object and the first quantity corresponding to the object, that is, before _ notification ═ before _ notification + today _ notification. Then, the first quantity corresponding to the object is updated to the service quantity corresponding to the object, that is, today _ subscription is the service quantity of the service data corresponding to the object in the current detection period. Therefore, the quantity information corresponding to the 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 the query instruction, the first quantity and the second quantity can be directly queried in the object information table, and the query efficiency can be further improved.
In summary, firstly, 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 is obtained, wherein the service count table can be synchronously updated under the condition that the service data is newly added in the service data table. And then updating the business accumulated quantity corresponding to the object in the business statistical table according to the business quantity corresponding to each object. And further determining the business quantity state corresponding to the object according to the business accumulated quantity corresponding to each object in the business statistical table, and the early warning threshold value and the total quantity threshold value corresponding to the object. And finally, determining the service quantity state corresponding to each object, wherein the service quantity state corresponds to the object and is used for indicating whether the service data table receives the service data usage right corresponding to the object. According to the method and the device, the service counting table is used for recording the service quantity of the service data in each detection period, and the corresponding service accumulated quantity in the service counting table is updated, so that the use permission corresponding to the user is determined, the standardized management of the service data can be realized, and the accuracy of quantity counting is improved.
Fig. 8 is a block diagram illustrating a service information processing apparatus according to an exemplary embodiment, and as shown in fig. 8, the apparatus 200 includes:
an obtaining module 201, configured to obtain, according to a preset detection period, a service quantity of service data corresponding to each object in a current detection period recorded in a service count table, where the service count table is updated synchronously under the condition that service data is newly added in a service data table.
The first updating module 202 is configured to update the service cumulative quantity corresponding to each object in the service statistical table according to the service quantity corresponding to each object.
And the state determining module 203 is configured to determine a service quantity state corresponding to each object according to the service cumulative quantity corresponding to each object in the service statistical table, and the early warning threshold and the total quantity threshold corresponding to the object.
And the permission determining module 204 is configured to determine, according to the service quantity state corresponding to each object, a usage permission corresponding to the object, where the usage permission is used to indicate whether the service data table receives the service data corresponding to the object.
In one implementation, the state determination module 203 may be configured to perform the following steps:
step 1) aiming at each object, if the accumulated quantity of the services corresponding to the object in the service statistical table is less than or equal to an early warning threshold value, determining that the state of the quantity of the services corresponding to the object is a normal state.
And 2) if the accumulated quantity of the services corresponding to the object in the service statistical table is greater than the early warning threshold value and less than or equal to the total quantity threshold value, determining that the state of the quantity of the services corresponding to the object is an early warning state.
And 3) if the accumulated quantity of the services corresponding to the object in the service statistical table is greater than the total threshold value, determining that the service quantity state corresponding to the object is an excess state.
Accordingly, the privilege determination module 204 may be configured to perform the following steps:
and 4) if the service quantity state corresponding to the object is an excess state, determining that the use permission corresponding to the object is closed so as to indicate a service data table to refuse to receive the service data corresponding to the object.
And 5) if the service quantity state corresponding to the object is a normal state or an early warning state, determining that the use permission corresponding to the object is open so as to indicate that the service data table can receive the service data corresponding to the object.
Fig. 9 is a block diagram illustrating another apparatus for processing service information according to an exemplary embodiment, and as shown in fig. 9, the apparatus 200 may further include:
a tag determining module 205, configured to determine, for each object, a sending tag corresponding to each object in the service statistics table if the service quantity state corresponding to the object is an early warning state after determining the service quantity state corresponding to the object according to the service cumulative quantity corresponding to each object in the service statistics table, and the early warning threshold and the total quantity threshold corresponding to the object, where the sending tag is used to indicate whether early warning information has been sent for the object.
The warning module 206 is configured to send warning information for the object and update the sending tag corresponding to the object as sent when the sending tag corresponding to the object is not sent.
Fig. 10 is a block diagram illustrating another apparatus for processing service information according to an exemplary embodiment, and as shown in fig. 10, the apparatus 200 may further include:
a second updating module 207, configured to update quantity information corresponding to each object in the object information table according to the number of services corresponding to each object after obtaining the number of services of the service data corresponding to each object in the current detection period recorded in the service count table according to the preset detection period, where the object information table includes object information corresponding to each object, and the quantity information is used to represent the number of service data corresponding to the object in multiple time ranges.
And an emptying module 208 for emptying the traffic count table.
Fig. 11 is a block diagram illustrating another apparatus for processing service information according to an exemplary embodiment, and as shown in fig. 11, the apparatus 200 may further include:
the receiving module 209 is configured to receive a query instruction, where the query instruction includes object information of the target object and a query condition.
The query module 210 is configured to query a query result that meets the query condition and corresponds to the target object in a pre-established query wide table, and display the query result, where the query wide table includes an object information table and a service data table.
Fig. 12 is a block diagram illustrating another apparatus for processing service information according to an exemplary embodiment, and as shown in fig. 12, the apparatus 200 may further include:
the association module 211 is configured to associate the object information table with the service data table according to the association relationship indicated by the object information to obtain a query width table including the object information table and the service data table.
A synchronization module 212 for synchronizing the query wide table to the search engine.
Accordingly, the query module 210 may be configured to:
and acquiring a query result by calling a retrieval engine to execute the query instruction.
In another implementation, the quantity information includes: a first quantity corresponding to the first time range and a second quantity corresponding to the second time range, wherein 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.
Accordingly, the second update module 207 may be configured to perform the following steps:
step 6) updating the second number corresponding to the object to be the sum of the second number corresponding to the object and the first number corresponding to the object.
And 7) updating the first quantity corresponding to the object to the business quantity corresponding to the object.
With regard to the apparatus in the above-described embodiment, the specific manner in which each module performs the operation has been described in detail in the embodiment related to the method, and will not be elaborated here.
In summary, firstly, 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 is obtained, wherein the service count table can be synchronously updated under the condition that the service data is newly added in the service data table. And then updating the business accumulated quantity corresponding to the object in the business statistical table according to the business quantity corresponding to each object. And further determining the business quantity state corresponding to the object according to the business accumulated quantity corresponding to each object in the business statistical table, and the early warning threshold value and the total quantity threshold value corresponding to the object. And finally, determining the service quantity state corresponding to each object, wherein the service quantity state corresponds to the object and is used for indicating whether the service data table receives the service data usage right corresponding to the object. According to the method and the device, the service counting table is used for recording the service quantity of the service data in each detection period, and the corresponding service accumulated quantity in the service counting table is updated, so that the use permission corresponding to the user is determined, the standardized management of the service data can be realized, and the accuracy of quantity counting is improved.
Fig. 13 is a block diagram illustrating an electronic device 300 in accordance with an example embodiment. As shown in fig. 13, the electronic device 300 may include: a processor 301 and a memory 302. The electronic device 300 may also include one or more of a multimedia component 303, an input/output (I/O) interface 304, and a communication component 305.
The processor 301 is configured to control the overall operation of the electronic device 300, so as to complete all or part of the steps in the method for processing the service information. The memory 302 is used to store various types of data to support operation at the electronic device 300, such as instructions for any application or method operating on the electronic device 300 and application-related data, such as contact data, transmitted and received messages, pictures, audio, video, and the like. The Memory 302 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 (EEPROM), Erasable Programmable Read-Only Memory (EPROM), Programmable Read-Only Memory (PROM), Read-Only Memory (ROM), magnetic Memory, flash Memory, magnetic disk or optical disk. The multimedia components 303 may include a screen and an audio component. Wherein the screen may be, for example, a touch screen and the audio component is used for outputting and/or inputting audio signals. For example, the audio component may include a microphone for receiving external audio signals. The received audio signal may further be stored in the memory 302 or transmitted through the communication component 305. The audio assembly 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, such as a keyboard, 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, which is not limited herein. The corresponding communication component 305 may therefore include: Wi-Fi module, Bluetooth module, NFC module, etc.
In an exemplary embodiment, the electronic Device 300 may 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 for executing the above-mentioned method for Processing service information.
In another exemplary embodiment, there is also provided a computer readable storage medium including program instructions, which when executed by a processor, implement the steps of the above-described service information processing method. For example, the computer readable storage medium may be the memory 302 including the program instructions, which are executable by the processor 301 of the electronic device 300 to perform the service information processing method described above.
Fig. 14 is a block diagram illustrating an electronic device 400 according to an example embodiment. For example, the electronic device 400 may be provided as a server. Referring to fig. 14, the electronic device 400 includes a processor 422, which may be one or more in number, and a memory 432 for storing computer programs executable by the processor 422. The computer program stored in memory 432 may include one or more modules that each correspond to a set of instructions. Further, the processor 422 may be configured to execute the computer program to perform the above-described processing method of the service information.
Additionally, electronic device 400 may also include a power component 426 and a communication component 450, the power component 426 may be configured to perform power management of the electronic device 400, and the communication component 450 may be configured to enable communication, e.g., wired or wireless communication, of the electronic device 400. The electronic device 400 may also include input/output (I/O) interfaces 458. The electronic device 400 may operate based on an operating system, such as Windows Server, stored in the memory 432TM，Mac OS XTM，UnixTM，LinuxTMAnd so on.
In another exemplary embodiment, there is also provided a computer readable storage medium including program instructions, which when executed by a processor, implement the steps of the above-described service information processing method. For example, the non-transitory computer readable storage medium may be the memory 432 including the program instructions, which are executable by the processor 422 of the electronic device 400 to perform the above-mentioned service information processing method.
In another exemplary embodiment, a computer program product is also provided, which contains a computer program executable by a programmable apparatus, the computer program having code portions for performing the above-mentioned service information processing method when executed by the programmable apparatus.
The preferred embodiments of the present disclosure are described in detail with reference to the accompanying drawings, however, the present disclosure is not limited to the specific details of the above embodiments, and various simple modifications may be made to the technical solution of the present disclosure within the technical idea of the present disclosure, and these simple modifications all belong to the protection scope of the present disclosure.
It should be noted that, in the foregoing embodiments, various features described in the above embodiments may be combined in any suitable manner, and in order to avoid unnecessary repetition, various combinations that are possible in the present disclosure are not described again.
In addition, any combination of various embodiments of the present disclosure may be made, and the same should be considered as the disclosure of the present disclosure, as long as it does not depart from the spirit of the present disclosure.
Claims (10)
1. A method for processing service information, the method comprising:
acquiring the service quantity of service data corresponding to each object in the current detection period recorded in a service counting table according to a preset detection period, wherein the service counting table is synchronously updated under the condition that service data are newly added in a service data table;
updating the business accumulated quantity corresponding to each object in a business statistical table according to the business quantity corresponding to each object;
determining the business quantity state corresponding to the object according to the business accumulated quantity corresponding to each object in the business statistical table, and the early warning threshold value and the total quantity threshold value corresponding to the object;
and determining the use authority corresponding to each object according to the service quantity state corresponding to each object, wherein the use authority is used for indicating whether the service data table receives the service data corresponding to the object.
2. The method according to claim 1, wherein determining the traffic volume status corresponding to the object according to the traffic cumulative volume corresponding to each object in the traffic statistics table, and the early warning threshold and the total volume threshold corresponding to the object comprises:
for each object, if the accumulated number of the services corresponding to the object in the service statistical table is less than or equal to the early warning threshold, determining that the state of the number of the services corresponding to the object is a normal state;
if the accumulated number of the services corresponding to the object in the service statistical table is larger than the early warning threshold value and smaller than or equal to the total threshold value, determining that the state of the number of the services corresponding to the object is an early warning state;
if the accumulated number of the services corresponding to the object in the service statistical table is larger than the total threshold value, determining that the service number state corresponding to the object is an excess state;
the determining the usage right corresponding to each object according to the service quantity state corresponding to the object includes:
if the service quantity state corresponding to the object is an excess state, determining that the use permission corresponding to the object is closed so as to indicate the service data table to refuse to receive the service data corresponding to the object;
and if the service quantity state corresponding to the object is a normal state or an early warning state, determining that the use permission corresponding to the object is open so as 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 traffic volume status corresponding to the object according to the traffic cumulative volume corresponding to each object in the traffic statistics table, and the early warning threshold and the total volume threshold corresponding to the object, the method further comprises:
for each object, if the service quantity state corresponding to the object is an early warning state, determining a sending tag corresponding to the object in the service statistical table, wherein the sending tag is used for indicating whether early warning information is sent for the object;
and under the condition that the sending label corresponding to the object is not sent, sending the early warning information to the object, and updating the sending label corresponding to the object to be sent.
4. The method according to claim 1, wherein after obtaining the service quantity of the service data corresponding to each object in the current detection period recorded in the service count table according to the preset detection period, the method further comprises:
updating quantity information corresponding to each object in an object information table according to the business quantity corresponding to each object, wherein the object information table comprises object information corresponding to each object, and the quantity information is used for representing the quantity of business data corresponding to each object in a plurality of time ranges;
and emptying the business counting table.
5. The method of claim 4, further comprising:
receiving a query instruction, wherein the query instruction comprises object information of a target object and a query condition;
and inquiring an inquiry result which corresponds to the target object and meets the inquiry condition in a pre-established inquiry wide table, and displaying the inquiry result, wherein the inquiry wide table comprises the object information table and the service data table.
6. The method of claim 5, further comprising:
associating the object information table with the service data table according to an association relation indicated by object information to obtain the query broad table comprising the object information table and the service data table;
synchronizing the query wide table to a search engine;
the querying, in a pre-established query broad table, a query result that corresponds to the target object and satisfies the query condition includes:
and acquiring the query result by calling the retrieval engine to execute the query instruction.
7. The method of claim 4, wherein the quantity information comprises: a first quantity corresponding to a first time range and a second quantity corresponding to a second time range, wherein the first time range corresponds to the current detection period, and the second time range corresponds to a time range before the current detection period;
the updating the quantity information corresponding to the object in the object information table according to the service quantity corresponding to each object includes:
updating the second quantity corresponding to the object to be the sum of the second quantity corresponding to the object and the first quantity corresponding to the object;
and updating the first quantity corresponding to the object to the business quantity corresponding to the object.
8. An apparatus for processing service information, the apparatus comprising:
the acquisition module is used for acquiring the business quantity of the business data corresponding to each object in the current detection period recorded in a business counting table according to the preset detection period, and the business counting table is synchronously updated under the condition that the business data are newly added in a business data table;
the first updating module is used for updating the business accumulated quantity corresponding to each object in the business statistical table according to the business quantity corresponding to each object;
the state determining module is used for determining the business quantity state corresponding to the object according to the business accumulated quantity corresponding to each object in the business statistical table, and the early warning threshold value and the total quantity threshold value corresponding to the object;
and the permission determining module is used for determining the use permission corresponding to each object according to the service quantity state corresponding to each object, and the use permission is used for indicating whether the service data table receives the service data corresponding to the object.
9. A non-transitory computer readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method according to any one of claims 1 to 7.
10. An electronic device, comprising:
a memory having a computer program stored thereon;
a processor for executing the computer program in the memory to carry out the steps of the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111580656.1A CN114239510A (en) | 2021-12-22 | 2021-12-22 | Service information processing method and device, storage medium and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111580656.1A CN114239510A (en) | 2021-12-22 | 2021-12-22 | Service information processing method and device, storage medium and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114239510A true CN114239510A (en) | 2022-03-25 |
Family
ID=80761285
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111580656.1A Pending CN114239510A (en) | 2021-12-22 | 2021-12-22 | Service information processing method and device, storage medium and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114239510A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114698015A (en) * | 2022-04-12 | 2022-07-01 | 中国联合网络通信集团有限公司 | Service monitoring method, device, system and storage medium |
-
2021
- 2021-12-22 CN CN202111580656.1A patent/CN114239510A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114698015A (en) * | 2022-04-12 | 2022-07-01 | 中国联合网络通信集团有限公司 | Service monitoring method, device, system and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| USRE48194E1 (en) | Systems and methods for monitoring and applying data related to shareable links associated with content items stored in an online content management service | |
| AU2017202007B2 (en) | Notification feed across multiple client devices | |
| US10614197B2 (en) | Monitored shareable links to content items stored in an online content management service | |
| CN102567091B (en) | Electronic communications triage | |
| US20160127210A1 (en) | Facilitating Collection and Display of Information Related to Data Usage by a Plurality of Mobile Devices | |
| CN107733968B (en) | Application information pushing method and device, computer equipment and storage medium | |
| CN113365106B (en) | Multimedia resource generation method and device, electronic equipment and storage medium | |
| CN104737161A (en) | Person-based information aggregation | |
| CN107844530B (en) | Data processing method and device, server and computer readable storage medium | |
| CN107729483B (en) | Classification display method, classification display device, terminal and computer-readable storage medium | |
| CN114239510A (en) | Service information processing method and device, storage medium and electronic equipment | |
| CN112631879A (en) | Data acquisition method and device, computer readable medium and electronic equipment | |
| US20210132855A1 (en) | Method and device for detecting slow node and computer-readable storage medium | |
| CN110300222B (en) | Short message display method, system, terminal equipment and computer readable storage medium | |
| CN109213955B (en) | Data processing method and related equipment | |
| CN113515541A (en) | Data query method, device and system of database | |
| CN111159207A (en) | Information processing method and device | |
| CN109391537B (en) | Information processing method and device and computer storage medium | |
| CN115827763A (en) | Data processing method, device and equipment | |
| CN112364267A (en) | Front-end data acquisition method and device | |
| CN105897569B (en) | A kind of method of reseptance and device of the network information | |
| CN114257598B (en) | Resource downloading method and device, storage medium and electronic equipment | |
| US20230100936A1 (en) | Method, device, and computer program product for transmitting data for object storage | |
| CN110019358B (en) | Data processing method, device and equipment and storage medium | |
| KR101804797B1 (en) | Method for Providing Call Related Information for Point of Interest |
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 |