Number source limit analysis method applied to reservation system in government affair field

By using the data analysis method of MQTT protocol and redis database in the government reservation system, the problem of inconsistency in online and offline source management is solved, and efficient utilization of government resources and user satisfaction is achieved.

CN120354974APending Publication Date: 2025-07-22INSPUR SOFTWARE CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202510423817.8
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2025-04-07
Publication Date
2025-07-22

AI Technical Summary

Technical Problem

The online and offline number source management in the government service reservation system is not coordinated, resulting in concentrated online number grabbing time periods, concentrated offline number picking time, accumulated personnel, serious waste of resources, and unable to achieve peak and valley allocation.

Method used

The ROCKETMQ server middleware that uses the MQTT protocol handles offline number pick-up notifications of the reservation system, and uses the redis database to record data, establish a data model for estimating the number quota, calculate the average daily demand through the formula, and adjust the number source number according to the real-time situation.

Benefits of technology

It has achieved efficient utilization of government resources, reduced the difficulty of staffing of government affairs centers, improved resource utilization and user satisfaction, and reduced queuing time.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN120354974A_ABST
    Figure CN120354974A_ABST
Patent Text Reader

Abstract

The invention discloses a number source limit analysis method applied to a reservation system in the government affair field, and relates to the technical field of data analysis. Comprising the following steps: step 1, processing an offline number taking notification of a reservation system by ROCKETMQ server middleware based on an MQTT protocol; 2, recording data generated in the number taking notification process in a redis database according to requirements; 3, establishing a data model, and carrying out the calculation of the number allocation amount of the reservation system; according to the invention, the number of required number sources is clearly calculated based on existing data, and adjustment is carried out according to real-time conditions, so that the resource utilization rate is improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention discloses a method for analyzing the number source quota of an appointment system applied to the government affairs field, which relates to the technical field of data analysis. Background Art

[0002] In general, the appointment system for government services fixes the number of appointment numbers released in each time period, and manages the number sources separately for online appointments and offline number pick-ups. In the actual use process, some problems will occur. For example, the online number grabbing time periods are concentrated, the offline number pick-up times are concentrated, and there are crowds of people, and still a large amount of waiting time is required; another example is that the number source allocation is too average, which cannot play the role of peak-valley regulation and is likely to cause waste of government affairs resources. Summary of the Invention

[0003] Aiming at the problems of the existing technology, the present invention provides a method for analyzing the number source quota of an appointment system applied to the government affairs field, which clearly calculates the required number of number sources based on the existing data and adjusts according to the real-time situation to improve the resource utilization rate.

[0004] The specific solution proposed by the present invention is as follows:

[0005] The present invention provides a method for analyzing the number source quota of an appointment system applied to the government affairs field, including:

[0006] Step 1: Process the offline number pick-up notice of the appointment system through the ROCKETMQ server middleware based on the MQTT protocol:

[0007] Register the queuing service as a producer on the ROCKETMQ server. When the number pick-up behavior occurs, the ROCKETMQ server sends a topic message to the message queue. When the consumer actively obtains the topic message, the topic message is sent to the specified appointment systems.

[0008] Step 2: Record the data generated during the number pick-up notice process in the redis database according to the requirements;

[0009] Step 3: Establish a data model to estimate the number of numbers released by the appointment system:

[0010] Estimate the daily average demand: Based on the redis database, estimate the daily average demand according to the daily average number of number pick-ups and the daily average number of appointments.

[0011] Estimate the current daily average handling volume: Estimate the current daily average handling volume according to the number of windows, the daily average handling volume, and the handling duration.

[0012] Based on the redis database, estimate the demand change according to the year-on-year and month-on-month data of future time, and give the increase or decrease amount of the quota and the increase or decrease amount of the number of windows. Obtain the change law of the business demand according to the time year-on-year data.

[0013] Further, in step 1 of the method for analyzing the source quota of a reservation system applied to the government affairs field, the message production / consumption mode of the ROCKETMQ server middleware is used to define the business behaviors in the same administrative region as the same message topic, and the messages of different topics are sent to different reservation systems when different consumption logics are executed.

[0014] Further, when the ROCKETMQ server middleware used in step 1 of the method for analyzing the source quota of a reservation system applied to the government affairs field loses topic messages, compensation is performed according to the business scenario. When selecting the middle of the day and the end of the day, the abnormal topic messages are screened out and resent.

[0015] Further, when estimating the daily average demand using the data model in step 3 of the method for analyzing the source quota of a reservation system applied to the government affairs field, the online daily average successful reservation volume and the online daily average failed reservation volume are obtained according to the daily average reservation volume, and the formula:

[0016] Online daily average successful reservation volume + online daily average failed reservation volume + offline daily average number of ticket pickups = daily average demand,

[0017] is used to estimate the daily average demand.

[0018] The present invention also provides a device for analyzing the source quota of a reservation system applied to the government affairs field, including a ticket pickup management module, a recording module, and an estimation module.

[0019] The ticket pickup management module processes the offline ticket pickup notification of the reservation system based on the ROCKETMQ server middleware of the MQTT protocol:

[0020] The queuing service is registered as a producer on the ROCKETMQ server, and when a ticket pickup behavior occurs, a topic message is sent to the message queue through the ROCKETMQ server. When the consumer actively obtains the topic message, the topic message is sent to the specified reservation systems.

[0021] The recording module records the data generated during the ticket pickup notification process in the redis database according to the requirements.

[0022] The estimation module establishes a data model to estimate the ticket release quota of the reservation system:

[0023] Estimate the daily average demand: Based on the redis database, the daily average demand is estimated according to the daily average number of ticket pickups and the daily average reservation volume.

[0024] Estimate the current daily average handling volume: The current daily average handling volume is estimated according to the number of windows, the daily average handling volume, and the handling duration.

[0025] Based on the Redis database, the demand changes are calculated according to the year-on-year and month-on-month data of future time, and the amount of increase or decrease in quota and the amount of increase or decrease in the number of windows are given. The business demand is obtained according to the time variation law of the year-on-year data.

[0026] Furthermore, the number management module of the number source quota analysis device applied to the appointment system in the government affairs field uses the message production / consumption mode of the ROCKETMQ server middleware to define the business behaviors in the same administrative region as the same message topic, and sends the messages of different topics to different appointment systems when executing different consumption logics.

[0027] Furthermore, when the number management module of the number source quota analysis device applied to the appointment system in the government affairs field loses topic messages using the ROCKETMQ server middleware, compensation is performed according to the business scenario. At the mid-day and end-of-day, the abnormal topic messages are screened out and resent.

[0028] Furthermore, when the calculation module of the number source quota analysis device applied to the appointment system in the government affairs field calculates the daily average demand using the data model, the online daily average successful reservation volume and the online daily average failed reservation volume are obtained according to the daily average reservation volume, and the formula is used:

[0029] Online daily average successful reservation volume + online daily average failed reservation volume + offline daily average number of ticket pick-ups = daily average demand,

[0030] to calculate the daily average demand.

[0031] The beneficial effects of the present invention are:

[0032] The network environment between the queuing system and the appointment system is shielded. There is no longer a need for communication between the queuing system and the appointment. It is only necessary to connect all government affairs products to the MQTT server and the application server to achieve number source sharing. Since the MQTT protocol messages have characteristics such as low bandwidth occupancy, light weight, and relatively high reliability, the transmission of messages occupies less resources. When there is no message trigger, there is no need to always connect to the application server to obtain the latest data, which can also reduce the pressure on the application server.

[0033] Reduce the difficulty of personnel allocation of number sources in the government affairs center and improve the resource utilization rate of the government affairs center. Optimal suggestions are put forward according to the actual demands of different businesses.

[0034] Improve the satisfaction rate of online appointments. The appropriate number of frequently handled business number sources helps to reduce queuing and improve user satisfaction. BRIEF DESCRIPTION OF THE DRAWINGS

[0035] Figure 1 It is a schematic diagram of the application framework of the method of the present invention.

[0036] Figure 2It is a schematic diagram of data recorded in the Redis database. Specific implementation manners

[0037] The present invention will be further described below in conjunction with the accompanying drawings and specific embodiments, so that those skilled in the art can better understand the present invention and be able to implement it, but the embodiments cited are not intended to limit the present invention.

[0038] Embodiment 1

[0039] The present invention provides a method for analyzing the number source quota of a reservation system applied to the government affairs field, including:

[0040] Step 1: The ROCKETMQ server middleware based on the MQTT protocol processes the offline number-taking notice of the reservation system:

[0041] Register the queuing service as a producer on the ROCKETMQ server. When a number-taking behavior occurs, the ROCKETMQ server sends a topic message to the message queue. When the consumer actively obtains the topic message, the topic message is sent to the designated reservation systems.

[0042] Among them, the message production / consumption mode of the ROCKETMQ server middleware defines the business behavior of the same administrative region as the same message topic, and different topic messages are sent to different reservation systems when different consumption logics are executed. When the ROCKETMQ server middleware loses topic messages, compensation is performed according to the business scenario. Select the time during the day and at the end of the day to screen out abnormal topic messages for resending.

[0043] Step 2: Record the data generated during the number-taking notice process in the Redis database according to requirements;

[0044] Step 3: Establish a data model to estimate the number of released numbers in the reservation system:

[0045] Estimate the daily average demand: Based on the Redis database, estimate the daily average demand according to the daily average number-taking volume and the daily average reservation volume. When using the data model to estimate the daily average demand, obtain the daily average successful reservation volume and the daily average failed reservation volume online according to the daily average reservation volume, and use the formula:

[0046] Daily average successful reservation volume online + daily average failed reservation volume online + daily average number-taking volume offline = daily average demand, and estimate the daily average demand.

[0047] Estimate the current daily average handling volume: Estimate the current daily average handling volume according to the number of windows, the daily average handling volume, and the handling duration.

[0048] Based on the Redis database, the demand change is calculated according to the year-on-year and month-on-month data of future time, and the amount of increase or decrease in quota and the amount of increase or decrease in the number of windows are given. The changing rule of the business demand is obtained according to the time year-on-year data.

[0049] Embodiment 2

[0050] The present invention also provides a number source quota analysis device applied to the appointment system in the government affairs field, including a number taking management module, a recording module and a calculation module.

[0051] The number taking management module processes the offline number taking notice of the appointment system based on the ROCKETMQ server middleware of the MQTT protocol:

[0052] Register the queuing service as a producer on the ROCKETMQ server, and send a topic message to the message queue through the ROCKETMQ server when the number taking behavior occurs. When the consumer actively obtains the topic message, send the topic message to the designated appointment systems.

[0053] The recording module records the data generated during the number taking notice process in the Redis database according to the requirements.

[0054] The calculation module establishes a data model to calculate the number of released numbers quota of the appointment system:

[0055] Calculate the daily average demand: Based on the Redis database, calculate the daily average demand according to the daily average number of number takings and the daily average number of appointments.

[0056] Calculate the current daily average handling volume: Calculate the current daily average handling volume according to the number of windows, the daily handling volume and the handling duration.

[0057] Based on the Redis database, the demand change is calculated according to the year-on-year and month-on-month data of future time, and the amount of increase or decrease in quota and the amount of increase or decrease in the number of windows are given. The changing rule of the business demand is obtained according to the time year-on-year data.

[0058] For the information interaction, execution process, etc. among the above-mentioned modules in the device, since they are based on the same concept as the method embodiment of the present invention, the specific content can be referred to the description in the method embodiment of the present invention, and will not be repeated here.

[0059] Similarly, the device of the present invention shields the network environment between the queuing system and the appointment system, and no longer requires communication between the queuing system and the appointment. It only needs to connect all government affairs products to the MQTT server and the application server to realize number source sharing. Because the MQTT protocol messages have the characteristics of low bandwidth occupation, light weight, high reliability, etc., the transmission of messages occupies less resources. When there is no message trigger, there is no need to keep connecting to the application server to obtain the latest data, which can also reduce the pressure on the application server.

[0060] Reduce the difficulty of personnel allocation number sources in the government affairs center and improve the resource utilization rate of the government affairs center. Put forward optimal suggestions according to the actual demands of different services.

[0061] Improve the satisfaction rate of online appointments. An appropriate number of frequently handled service number sources helps reduce queuing and improves user satisfaction.

[0062] It should be noted that not all steps and modules in the above-mentioned processes and device structures are necessary, and some steps or modules can be ignored according to actual needs. The execution order of each step is not fixed and can be adjusted as needed. The system structure described in the above-mentioned embodiments can be a physical structure or a logical structure. That is, some modules may be implemented by the same physical entity, or some modules may be implemented by multiple physical entities separately, or some components in multiple independent devices may be jointly implemented.

[0063] The above-mentioned embodiments are only preferred embodiments cited to fully illustrate the present invention, and the protection scope of the present invention is not limited thereto. Equivalent substitutions or transformations made by those skilled in the art on the basis of the present invention are within the protection scope of the present invention. The protection scope of the present invention shall be subject to the claims.

Claims

1. A method for analyzing the source quota of an appointment system applied to the government affairs field, characterized in that Including: Step 1: The ROCKETMQ server middleware based on the MQTT protocol processes the offline queuing number notification of the reservation system: Register the queuing service as a producer on the ROCKETMQ server. When a queuing number is taken, the ROCKETMQ server sends a topic message to the message queue. When the consumer actively obtains the topic message, the topic message is sent to the specified reservation systems. Step 2: Record the data generated during the queuing number notification process in the redis database according to requirements. Step 3: Establish a data model to calculate the quota of the number of available numbers in the reservation system: Calculate the daily average demand: Based on the redis database, calculate the daily average demand according to the daily average number of queuing numbers and the daily average number of reservations. Calculate the current daily average processing volume: Calculate the current daily average processing volume according to the number of windows, the daily average processing volume, and the processing duration. Based on the redis database, calculate the demand change according to the year-on-year and month-on-month data of future time, and give the increase or decrease amount of the quota and the increase or decrease amount of the number of windows. Obtain the change rule of the business demand according to the year-on-year data of time.

2. The number source quota analysis method applied to the appointment system in the government affairs field according to claim 1, characterized in that In Step 1, use the message production / consumption mode of the ROCKETMQ server middleware to define the business behavior of the same administrative region as the same message topic, and send different topic messages to different reservation systems when different consumption logics are executed.

3. The number source quota analysis method for a reservation system applied to the government affairs field according to claim 1, characterized in that When the ROCKETMQ server middleware in Step 1 loses topic messages, make compensations according to the business scenario. Select the midday and end-of-day times to filter out the abnormal topic messages and resend them.

4. The number source quota analysis method applied to the appointment system in the government affairs field according to claim 1, characterized in that When calculating the daily average demand using the data model in Step 3, obtain the daily average successful online reservation volume and the daily average failed online reservation volume according to the daily average number of reservations, and use the formula: Daily average successful online reservation volume + daily average failed online reservation volume + daily average offline queuing number = daily average demand Calculate the daily average demand.

5. A number source quota analysis device applied to the appointment system in the government affairs field, characterized in that Including a queuing number management module, a recording module, and a calculation module. The queuing number management module based on the ROCKETMQ server middleware of the MQTT protocol processes the offline queuing number notification of the reservation system: Register the queuing service as a producer on the ROCKETMQ server. When a queuing number is taken, the ROCKETMQ server sends a topic message to the message queue. When the consumer actively obtains the topic message, the topic message is sent to the specified reservation systems. The recording module records the data generated during the queuing number notification process in the redis database according to requirements. The calculation module establishes a data model to calculate the quota of the number of available numbers in the reservation system: Calculate the daily average demand: Based on the redis database, calculate the daily average demand according to the daily average number of queuing numbers and the daily average number of reservations. Calculate the current daily average processing volume: Calculate the current daily average processing volume according to the number of windows, the daily average processing volume, and the processing duration. Based on the redis database, calculate the demand change according to the year-on-year and month-on-month data of future time, and give the increase or decrease amount of the quota and the increase or decrease amount of the number of windows. Obtain the change rule of the business demand according to the year-on-year data of time.

6. The number source quota analysis device applied to the appointment system in the government affairs field according to claim 5, characterized in that it takes The number management module uses the message production / consumption mode of the ROCKETMQ server middleware to define the business behaviors of the same administrative region as the same message topic, and sends messages of different topics to different reservation systems when executing different consumption logics.

7. The number source quota analysis device applied to the appointment system in the government affairs field according to claim 5, characterized in that it takes When the number management module uses the ROCKETMQ server middleware and loses topic messages, compensation is performed according to the business scenario. At midday and the end of the day, abnormal topic messages are screened out and resent.

8. The number source quota analysis device applied to the appointment system in the government affairs field according to claim 5, characterized in that When the calculation module calculates the daily average demand using the data model, it obtains the online daily average successful reservation volume and the online daily average failed reservation volume based on the daily average reservation volume, and uses the formula: Online daily average successful reservation volume + Online daily average failed reservation volume + Offline daily average number of ticket pickups = Daily average demand, to calculate the daily average demand.