Quantity analysis method, device, equipment and storage medium for reservation service
By cleaning and splitting the historical data of online appointment services, calculating the fulfillment rate and income weight, building a decision model, solving the problem of difficult to determine the number of online appointment services, and achieving intelligent decision-making and maximum returns with the optimal number of appointments change.
Patent Information
- Application Number
- CN202111148141.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-09-29
- Publication Date
- 2024-12-03
- Estimated Expiration
- 2041-09-29
AI Technical Summary
In online reservation services, due to uncertainty in user time, overselling or insufficient problems, it is difficult to determine the optimal number of reservation services, resulting in tight manpower and material resources or underutilization of resources.
By collecting historical data of online reservation services, performing data cleaning and time dimension splitting, calculating fulfillment rate and income weights, building a decision model for the number of reservation services, and intelligently making the optimal number of reservations.
It improves the accuracy of determining the number of appointment services, reduces losses caused by user uncertainties, and ensures the maximum benefits of online appointment services.
Smart Images

Figure CN113807553B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of artificial intelligence, and in particular to a method, device, electronic device and computer-readable storage medium for analyzing the quantity of reservation services. Background Art
[0002] Overbooking refers to a service delivery model in which the number of sales (number of accepted reservations) can be greater than the number of services that can be provided. It can be applied to online reservation services in industries such as medical beauty, dental care, genetic testing, traditional Chinese medicine care and physical examinations. At present, the number of online reservation services is usually determined based on the acceptable number of different institutions or enterprises. However, in actual business scenarios, due to the uncertainty of user time, it is easy for users to make online reservations but fail to fulfill their offline contracts. Therefore, online reservation services can achieve full utilization of manpower and material resources through overbooking. However, the number of overbookings is not easy to control. Too much overbooking will cause a shortage of manpower and material resources, while a small number of overbookings will not achieve the effect of full utilization of manpower and material resources. Therefore, how to determine the optimal number of reservation services becomes increasingly important. Summary of the invention
[0003] The present invention provides a method, device, electronic device and computer-readable storage medium for analyzing the quantity of reservation services, the main purpose of which is to intelligently decide the optimal reservation quantity for reservation services.
[0004] To achieve the above object, the present invention provides a method for analyzing the quantity of reservation services, comprising:
[0005] Collect historical data of online reservation services, and clean the historical data to obtain target data;
[0006] Splitting the target data according to the time dimension to obtain target data for multiple time periods;
[0007] Calculating the historical fulfillment rate of the online reservation service in each time period according to the number of reservation users and the number of visiting users in the target data of each time period in the multiple time periods;
[0008] Calculate the historical revenue weight of the online reservation service in each time period;
[0009] Obtain the historical number of available reservation services for the online reservation service in each time period, and construct a reservation service quantity decision model according to the historical available reservation number, the historical fulfillment rate, and the historical revenue weight;
[0010] According to the current available number of reservation services for the online reservation service, the current number of reservation services for the online reservation service is analyzed using the reservation service number decision model.
[0011] Optionally, splitting the target data according to a time dimension to obtain target data of multiple time periods includes:
[0012] Acquire the total data volume of the target data and the collection time of each data in the target data;
[0013] Generate a timestamp for each data in the target data according to the total data volume and the acquisition time;
[0014] According to the timestamp of each data, target data of multiple time periods are generated.
[0015] Optionally, generating a timestamp for each data in the target data according to the total data volume and the acquisition time includes:
[0016] Obtain the sub-data volume of the target data within each of the acquisition times, and calculate the data proportion of each of the sub-data volume in the total data volume;
[0017] According to the data proportion, the timestamp of each of the divided data volumes is updated to obtain the timestamp of each data in the target data.
[0018] Optionally, the calculating the historical revenue weight of the online reservation service in each time period includes:
[0019] Query the service revenue and service loss of the online reservation service in each time period;
[0020] Calculate the marginal revenue of the online reservation service in each time period according to the service revenue;
[0021] Calculate the marginal loss and additional cost of the online reservation service in each time period according to the service loss;
[0022] The marginal revenue, the marginal loss and the additional cost are aggregated to serve as the historical revenue weight of the online reservation service in each time period.
[0023] Optionally, the reservation service quantity decision model includes:
[0024]
[0025] Among them, S represents the optimal number of reservations for the online reservation service, N represents the historical number of reservable services, ω represents the marginal benefit in the historical benefit weight, ρ represents the marginal loss in the historical benefit weight, φ represents the additional cost in the historical benefit weight, and σ represents the historical fulfillment rate.
[0026] Optionally, the performing data cleaning on the historical data to obtain target data includes:
[0027] Performing a deduplication operation on the historical data, and detecting whether the deduplicated historical data has any missing data values;
[0028] If there is no missing data value, the historical data after deduplication is used as the target data;
[0029] If there are missing data values, the missing data values are filled to obtain target data.
[0030] Optionally, the performing a deduplication operation on the historical data includes:
[0031] Calculate the similarity between any two pieces of historical data;
[0032] If the similarity is not greater than the preset similarity, retaining the two historical data at the same time;
[0033] If the similarity is greater than a preset similarity, any one of the two data is deleted.
[0034] In order to solve the above problem, the present invention also provides a device for analyzing the number of reservation services, the device comprising:
[0035] A data cleaning module is used to collect historical data of online reservation services and clean the historical data to obtain target data;
[0036] A time dimension splitting module is used to split the target data according to the time dimension to obtain target data for multiple time periods;
[0037] A fulfillment rate calculation module, used to calculate the historical fulfillment rate of the online reservation service in each time period according to the number of reserved users and the number of visiting users in the target data of each time period in the multiple time periods;
[0038] A revenue weight calculation module, used to calculate the historical revenue weight of the online reservation service in each time period;
[0039] A decision model building module, used to obtain the historical number of available reservation services for the online reservation service in each time period, and to build a reservation service quantity decision model according to the historical available reservation number, the historical fulfillment rate and the historical revenue weight;
[0040] The service quantity decision module is used to analyze the current reservation service quantity of the online reservation service according to the current reservation service quantity of the online reservation service and using the reservation service quantity decision model.
[0041] In order to solve the above problem, the present invention further provides an electronic device, the electronic device comprising:
[0042] at least one processor; and,
[0043] a memory communicatively connected to the at least one processor; wherein,
[0044] The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor to implement the above-mentioned method for analyzing the quantity of reservation services.
[0045] In order to solve the above problem, the present invention also provides a computer-readable storage medium, in which at least one computer program is stored. The at least one computer program is executed by a processor in an electronic device to implement the above-mentioned method for analyzing the quantity of reservation services.
[0046] It can be seen that the present invention first collects historical data of online reservation services, cleans the historical data and splits the historical data in time dimensions to obtain target data for multiple time periods, which can reduce the amount of historical data, improve the processing speed of subsequent data, and further split the historical data according to time, so that the user behavior of the online reservation service in different time periods can be understood in more detail, thereby improving the accuracy of the subsequent determination of the optimal number of reservation services; secondly, the embodiment of the present invention calculates the historical fulfillment rate and historical revenue weight of the online reservation service in each time period, and obtains the historical number of available reservation services for the online reservation service in each time period to construct a reservation service quantity decision model, which can intelligently determine the optimal number of current reservation services for the online reservation service, reduce the losses caused by the cancellation of online reservation services due to user uncertainties, and ensure the maximization of the benefits of online reservation services. Therefore, the method, device, electronic device and computer-readable storage medium for analyzing the number of reservation services proposed in the embodiment of the present invention can intelligently decide the optimal number of reservations for reservation services. BRIEF DESCRIPTION OF THE DRAWINGS
[0047] Figure 1 A schematic diagram of a flow chart of a method for analyzing the quantity of reservation services provided by an embodiment of the present invention;
[0048] Figure 2 A schematic diagram of a module of a device for analyzing the number of reservation services provided by an embodiment of the present invention;
[0049] Figure 3 A schematic diagram of the internal structure of an electronic device for implementing a method for analyzing the quantity of reservation services provided by an embodiment of the present invention;
[0050] The realization of the purpose, functional features and advantages of the present invention will be further explained in conjunction with embodiments and with reference to the accompanying drawings. DETAILED DESCRIPTION
[0051] It should be understood that the specific embodiments described herein are only used to explain the present invention, and are not used to limit the present invention.
[0052] The embodiment of the present application provides a method for analyzing the quantity of an appointment service. The execution subject of the method for analyzing the quantity of the appointment service includes but is not limited to at least one of the electronic devices such as a server, a terminal, etc. that can be configured to execute the method provided by the embodiment of the present application. In other words, the method for analyzing the quantity of the appointment service can be executed by software or hardware installed on a terminal device or a server device, and the software can be a blockchain platform. The server includes but is not limited to: a single server, a server cluster, a cloud server or a cloud server cluster, etc. The server can be an independent server, or it can be a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, content delivery networks (Content Delivery Network, CDN), and big data and artificial intelligence platforms.
[0053] Reference Figure 1 FIG. 1 is a flow chart of a method for analyzing the number of reservation services provided in an embodiment of the present invention. In an embodiment of the present invention, the method for analyzing the number of reservation services includes:
[0054] S1. Collect historical data of online reservation services, and clean the historical data to obtain target data.
[0055] In an embodiment of the present invention, the online reservation service refers to a service for advance consultation and reservation through a network platform, such as a hotel reservation service, a traditional Chinese medicine therapy reservation service, and a medical reservation service, etc. The historical data includes service basic data and user data. The service basic data refers to the product data of the online reservation service, such as service price, service time, service items, and service objects, etc. The user data refers to data of the online reservation service that has been consulted, such as user name, user reservation time, user visit data, and user consumption data, etc.
[0056] Furthermore, it should be understood that the historical data may contain a lot of useless data and / or duplicate data. Therefore, the embodiment of the present invention cleans the historical data to reduce the amount of the historical data and improve the processing speed of subsequent data.
[0057] As an embodiment of the present invention, the data cleaning of the historical data to obtain the target data includes: deduplicating the historical data, and detecting whether there are missing data values in the deduplicated historical data; if there are no missing data values, using the deduplicated historical data as the target data; if there are missing data values, filling the missing data values to obtain the target data.
[0058] Further, as one of the embodiments of the present invention, the deduplication operation on the historical data includes: calculating the similarity between any two data in the historical data, if the similarity is not greater than a preset similarity, retaining the two historical data at the same time, if the similarity is greater than a preset similarity, deleting any one of the two data. The preset similarity can be set to 0.9, or can be set according to actual business scenarios.
[0059] It should be noted that, before calculating the similarity of the historical data, the embodiment of the present invention further includes: using a hash algorithm to convert the historical data into a corresponding hash value to achieve subsequent calculation of the similarity of the historical data.
[0060] In an optional embodiment, the similarity between any two data in the historical data is calculated using the following method:
[0061]
[0062] Among them, d represents the similarity between any two data, w 1j and w 2j Represents the hash value corresponding to any two data.
[0063] Furthermore, as one of the embodiments of the present invention, the detection of missing data values can be implemented by a detection function in a currently known missing data value detection tool, such as the missmapfunction detection function in the Amelia package tool.
[0064] S2. Split the target data according to the time dimension to obtain target data of multiple time periods.
[0065] The embodiment of the present invention obtains data of the online reservation service in different time periods by splitting the target data according to the time dimension. For example, if the target data is historical data within the past year, it can be split into target data of four dimensions according to quarters.
[0066] As an embodiment of the present invention, splitting the target data according to the time dimension to obtain target data for multiple time periods includes: obtaining the total data volume of the target data and the collection time of each data in the target data, generating a timestamp for each data in the target data according to the total data volume and the collection time, and generating target data for multiple time periods according to the timestamp of each data.
[0067] Among them, generating the timestamp of each data in the target data according to the total data volume and the collection time includes: obtaining the sub-data volume of the target data within each of the collection time, calculating the data proportion of each of the sub-data volume in the total data volume, and updating the timestamp of each of the sub-data volume according to the data proportion to obtain the timestamp of each data in the target data.
[0068] Based on the division of the time dimension, the target data can be further split according to time, so that the user behavior of the online reservation service in different time periods can be understood in more detail, thereby improving the accuracy of subsequent determination of the optimal number of reservation services.
[0069] S3. Calculate the historical fulfillment rate of the online reservation service in each time period according to the number of reservation users and the number of visiting users in the target data of each time period in the multiple time periods.
[0070] It should be understood that in actual business scenarios, due to the uncertainty of user time or the instability of reservation services, there may be a phenomenon where users make reservations for services but do not actually consume the services. Therefore, the embodiment of the present invention calculates the historical fulfillment rate of the online reservation service in each time period based on the number of reserved users and the number of visiting users in the target data of each time period in the multiple time periods, and uses this as a decision factor for the subsequent construction of a decision model to ensure the decision accuracy of the decision model, wherein the decision model is used to determine the optimal number of reservations for the online reservation service to ensure the maximum rate of return on the service product.
[0071] In the embodiment of the present invention, the number of reservation users refers to the number of users who submit reservation orders after consulting the online reservation service through the network platform, and the number of visiting users refers to the number of users who have consumed the online reservation service offline. It should be noted that, before calculating the historical fulfillment rate of the online reservation service in each time period according to the number of reservation users and the number of visiting users in the target data of each time period in the multiple time periods, the embodiment of the present invention also includes: querying the historical fulfillment information of the user corresponding to the number of reservation users and the number of visiting users, judging whether the user is a blacklist user according to the historical fulfillment information, if the user is a blacklist user, then deleting the user's reservation and / or the number of visits, if the user is not a blacklist user, then retaining the user's reservation and / or the number of visits. Among them, the historical fulfillment information can be obtained by querying the browsing record of the user in the background database of the online reservation service, and the judgment of the blacklist user can be set based on the historical fulfillment number of the user. If the historical fulfillment number of the user reaches ten times, the user is judged to be a blacklist user, which can also be set according to the actual business scenario.
[0072] Furthermore, in an optional embodiment of the present invention, the historical fulfillment rate of the online reservation service in each time period is calculated using the following formula:
[0073]
[0074] Among them, P represents the historical fulfillment rate, M represents the number of users who have made reservations, and N represents the number of visiting users.
[0075] It should be noted that the number of reserved users and the number of visiting users can be queried through a query statement, and the query statement can be an SQL statement.
[0076] S4. Calculate the historical revenue weight of the online reservation service in each time period.
[0077] It should be understood that when the number of visiting users is lower than the amount of reservation user data, that is, when the historical fulfillment rate is not equal to 1, the online reservation service will be in an idle state, which will bring certain service costs. Therefore, the present invention calculates the historical revenue weight of the online reservation service in each time period to determine the decision factors of the subsequent decision model to ensure the decision accuracy of the decision model.
[0078] As an embodiment of the present invention, the calculation of the historical revenue weight of the online reservation service in each time period includes: querying the service revenue and service loss of the online reservation service in each time period, calculating the marginal revenue of the online reservation service in each time period based on the service revenue, calculating the marginal loss and additional cost of the online reservation service in each time period based on the service loss, and summarizing the marginal revenue, marginal loss and additional cost as the historical revenue weight of the online reservation service in each time period.
[0079] The service revenue and service loss are determined based on the service items and service prices of different online reservation services. For example, if the online reservation service is a hotel reservation service and its service item is the reservation of hotel rooms, the service revenue and service loss can be determined based on the number of people who have reserved the hotel rooms and the number of people who have stayed in the hotel rooms. The marginal revenue refers to the revenue converted by the new users who make reservations for the online reservation service for consumption, the marginal loss refers to the loss converted by the users who make reservations for the online reservation service but do not make consumption, and the marginal loss refers to the equipment loss caused by the non-consumption of the reservations for the online reservation service.
[0080] Furthermore, in order to ensure the privacy and security of the historical income weight, the historical income weight can also be stored in a blockchain node.
[0081] S5. Obtain the historical number of available reservation services for the online reservation service in each time period, and construct a reservation service quantity decision model according to the historical available reservation number, the historical fulfillment rate, and the historical revenue weight.
[0082] It should be understood that in actual business scenarios, the number of online reservation services should not be greater than the actual number of reservations available. For example, for hotel room reservation services, the number of hotel rooms that can be reserved online should not be greater than the actual number of hotel rooms available. Therefore, the embodiment of the present invention obtains the historical number of reservable services for the online reservation service in each time period to determine the maximum number of reservable services for the online reservation service in each time period. Optionally, the historical number of reservable services can also be obtained through the above query statement.
[0083] It should be further understood that since the reservation service is an online transaction on a network platform, in actual business scenarios, the reservation service can also be traded offline. If the available number of reservations for the online reservation service is directly opened up, it is likely that there will be no available service offline, which will cause certain losses. Therefore, the embodiment of the present invention constructs a reservation service quantity decision model through the historical available number of reservations, the historical fulfillment rate and the historical profit weight, so as to intelligently decide the optimal number of reservations for the subsequent online reservation service and ensure the maximum rate of return of the online reservation service.
[0084] Furthermore, in an optional embodiment of the present invention, the following formula is used to construct a reservation service quantity decision model:
[0085]
[0086] Among them, S represents the optimal number of reservations for the online reservation service, N represents the historical number of reservable services, ω represents the marginal benefit in the historical benefit weight, ρ represents the marginal loss in the historical benefit weight, φ represents the additional cost in the historical benefit weight, and σ represents the historical fulfillment rate.
[0087] S6. Analyze the current number of reservation services for the online reservation service using the reservation service quantity decision model according to the current number of reservation services for the online reservation service.
[0088] In an embodiment of the present invention, the current number of reservable services refers to the remaining number of idle services of the online reservation service, which is generated based on different business scenarios. The current number of reservable services of the online reservation service is input into the reservation service quantity decision model, that is, the historical number of reservable services in the reservation service quantity decision model is replaced with the current number of reservable services to output the current number of reservation services of the online reservation service. The optimal number of current reservation services of the online reservation service can be determined to ensure the current maximum rate of return of the online reservation service.
[0089] It can be seen that the present invention first collects the historical data of the online reservation service, cleans the historical data and splits the historical data in the time dimension to obtain target data for multiple time periods, which can reduce the amount of the historical data, improve the processing speed of subsequent data, and further split the historical data according to time, so that the user behavior of the online reservation service in different time periods can be understood in more detail, and the accuracy of the subsequent determination of the optimal number of reservation services can be improved; secondly, the embodiment of the present invention calculates the historical fulfillment rate and historical revenue weight of the online reservation service in each time period, and obtains the historical number of available reservation services for the online reservation service in each time period to construct a reservation service quantity decision model, which can intelligently determine the optimal number of current reservation services for the online reservation service, reduce the losses caused by the cancellation of online reservation services due to user uncertainties, and ensure the maximization of the benefits of online reservation services. Therefore, a reservation service quantity analysis method proposed in the embodiment of the present invention can intelligently decide the optimal number of reservations for reservation services.
[0090] like Figure 2 FIG. 1 is a functional module diagram of the quantity analysis device for reservation services of the present invention.
[0091] The quantity analysis device 100 for reservation services of the present invention can be installed in an electronic device. According to the functions to be implemented, the quantity analysis device for reservation services can include a data cleaning module 101, a time dimension splitting module 102, a fulfillment rate calculation module 103, a revenue weight calculation module 104, a decision model construction module 105, and a service quantity decision module 106. The module of the present invention can also be called a unit, which refers to a series of computer program segments that can be executed by a processor of an electronic device and can complete fixed functions, which are stored in the memory of the electronic device.
[0092] In this embodiment, the functions of each module / unit are as follows:
[0093] The data cleaning module 101 is used to collect historical data of the online reservation service and clean the historical data to obtain target data;
[0094] The time dimension splitting module 102 is used to split the target data according to the time dimension to obtain target data of multiple time periods;
[0095] The fulfillment rate calculation module 103 is used to calculate the historical fulfillment rate of the online reservation service in each time period according to the number of reserved users and the number of visiting users in the target data of each time period in the multiple time periods;
[0096] The revenue weight calculation module 104 is used to calculate the historical revenue weight of the online reservation service in each time period;
[0097] The decision model building module 105 is used to obtain the historical number of available reservation services for the online reservation service in each time period, and to build a reservation service quantity decision model according to the historical available reservation number, the historical fulfillment rate and the historical revenue weight;
[0098] The service quantity decision module 106 is used to analyze the current number of scheduled services of the online reservation service according to the current number of scheduled services of the online reservation service and using the reservation service quantity decision model.
[0099] In detail, each module in the reservation service quantity analysis device 100 in the embodiment of the present invention adopts the same method as above when in use. Figure 1 The technical means are the same as the quantitative analysis method of the reservation service described in, and can produce the same technical effects, so I will not go into details here.
[0100] like Figure 3 FIG. 1 is a schematic diagram of the structure of an electronic device 1 for implementing the method for analyzing the quantity of reservation services according to the present invention.
[0101] The electronic device 1 may include a processor 10, a memory 11, a communication bus 12, and a communication interface 13, and may also include a computer program stored in the memory 11 and executable on the processor 10, such as a quantity analysis program for reservation services.
[0102] The processor 10 may be composed of an integrated circuit in some embodiments, for example, a single packaged integrated circuit, or a plurality of packaged integrated circuits with the same or different functions, including one or more central processing units (CPUs), microprocessors, digital processing chips, graphics processors, and combinations of various control chips, etc. The processor 10 is the control core (ControlUnit) of the electronic device 1, and uses various interfaces and lines to connect various components of the entire electronic device 1, and executes or executes programs or modules stored in the memory 11 (for example, a number analysis program for executing reservation services, etc.), and calls data stored in the memory 11 to execute various functions of the electronic device 1 and process data.
[0103] The memory 11 includes at least one type of readable storage medium, and the readable storage medium includes a flash memory, a mobile hard disk, a multimedia card, a card-type memory (for example, an SD or DX memory, etc.), a magnetic memory, a disk, an optical disk, etc. In some embodiments, the memory 11 may be an internal storage unit of the electronic device 1, such as a mobile hard disk of the electronic device 1. In other embodiments, the memory 11 may also be an external storage device of the electronic device 1, such as a plug-in mobile hard disk, a smart memory card (Smart Media Card, SMC), a secure digital (SecureDigital, SD) card, a flash card (Flash Card), etc. equipped on the electronic device 1. Further, the memory 11 may also include both an internal storage unit of the electronic device 1 and an external storage device. The memory 11 may not only be used to store application software and various types of data installed in the electronic device 1, such as the code of the quantity analysis program of the reservation service, but also be used to temporarily store data that has been output or is to be output.
[0104] The communication bus 12 may be a peripheral component interconnect (PCI) bus or an extended industry standard architecture (EISA) bus, etc. The bus may be divided into an address bus, a data bus, a control bus, etc. The bus is configured to realize connection and communication between the memory 11 and at least one processor 10, etc.
[0105] The communication interface 13 is used for communication between the above-mentioned electronic device 1 and other devices, including a network interface and an employee interface. Optionally, the network interface may include a wired interface and / or a wireless interface (such as a WI-FI interface, a Bluetooth interface, etc.), which is generally used to establish a communication connection between the electronic device 1 and other electronic devices 1. The employee interface may be a display (Display), an input unit (such as a keyboard (Keyboard)), and optionally, the employee interface may also be a standard wired interface, a wireless interface. Optionally, in some embodiments, the display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, and an OLED (Organic Light-Emitting Diode) touch device, etc. Among them, the display may also be appropriately referred to as a display screen or a display unit, which is used to display information processed in the electronic device 1 and to display a visual employee interface.
[0106] Figure 3 Only the electronic device 1 having components is shown, and those skilled in the art can understand that Figure 3The structure shown does not constitute a limitation on the electronic device 1, and may include fewer or more components than shown in the figure, or combine certain components, or arrange the components differently.
[0107] For example, although not shown, the electronic device 1 may also include a power source (such as a battery) for supplying power to each component. Preferably, the power source may be logically connected to the at least one processor 10 through a power management device, so that the power management device can realize functions such as charging management, discharging management, and power consumption management. The power source may also include any components such as one or more DC or AC power sources, recharging devices, power failure detection circuits, power converters or inverters, power status indicators, etc. The electronic device 1 may also include a variety of sensors, Bluetooth modules, Wi-Fi modules, etc., which will not be repeated here.
[0108] It should be understood that the embodiment is for illustration only and the scope of the patent application is not limited to this structure.
[0109] The number analysis program for reservation services stored in the memory 11 of the electronic device 1 is a combination of multiple computer programs. When running in the processor 10, it can achieve:
[0110] Collect historical data of online reservation services, and clean the historical data to obtain target data;
[0111] Splitting the target data according to the time dimension to obtain target data for multiple time periods;
[0112] Calculating the historical fulfillment rate of the online reservation service in each time period according to the number of reservation users and the number of visiting users in the target data of each time period in the multiple time periods;
[0113] Calculate the historical revenue weight of the online reservation service in each time period;
[0114] Obtain the historical number of available reservation services for the online reservation service in each time period, and construct a reservation service quantity decision model according to the historical available reservation number, the historical fulfillment rate, and the historical revenue weight;
[0115] According to the current available number of reservation services for the online reservation service, the current number of reservation services for the online reservation service is analyzed using the reservation service number decision model.
[0116] Specifically, the specific implementation method of the processor 10 for the above computer program can refer to Figure 1 The description of the relevant steps in the corresponding embodiments will not be repeated here.
[0117] Furthermore, if the module / unit integrated in the electronic device 1 is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a non-volatile computer-readable storage medium. The computer-readable storage medium can be volatile or non-volatile. For example, the computer-readable medium can include: any entity or device capable of carrying the computer program code, a recording medium, a USB flash drive, a mobile hard disk, a magnetic disk, an optical disk, a computer memory, and a read-only memory (ROM).
[0118] The present invention further provides a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor of the electronic device 1, the computer program can implement:
[0119] Collect historical data of online reservation services, and clean the historical data to obtain target data;
[0120] Splitting the target data according to the time dimension to obtain target data for multiple time periods;
[0121] Calculating the historical fulfillment rate of the online reservation service in each time period according to the number of reservation users and the number of visiting users in the target data of each time period in the multiple time periods;
[0122] Calculate the historical revenue weight of the online reservation service in each time period;
[0123] Obtain the historical number of available reservation services for the online reservation service in each time period, and construct a reservation service quantity decision model according to the historical available reservation number, the historical fulfillment rate, and the historical revenue weight;
[0124] According to the current available number of reservation services for the online reservation service, the current number of reservation services for the online reservation service is analyzed using the reservation service number decision model.
[0125] In the several embodiments provided by the present invention, it should be understood that the disclosed devices, apparatuses and methods can be implemented in other ways. For example, the device embodiments described above are only schematic, for example, the division of the modules is only a logical function division, and there may be other division methods in actual implementation.
[0126] The modules described as separate components may or may not be physically separated, and the components shown as modules may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
[0127] In addition, each functional module in each embodiment of the present invention may be integrated into one processing unit, each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of hardware plus software functional modules.
[0128] It is obvious to those skilled in the art that the present invention is not limited to the details of the above exemplary embodiments, and that the present invention can be implemented in other specific forms without departing from the spirit or essential characteristics of the present invention.
[0129] Therefore, no matter from which point of view, the embodiments should be regarded as illustrative and non-restrictive, and the scope of the present invention is limited by the appended claims rather than the above description, so it is intended that all changes falling within the meaning and scope of the equivalent elements of the claims are included in the present invention. Any attached figure mark in the claims should not be regarded as limiting the claims involved.
[0130] The blockchain referred to in this invention is a new application mode of computer technologies such as distributed data storage, peer-to-peer transmission, consensus mechanism, encryption algorithm, etc. Blockchain is essentially a decentralized database, a string of data blocks generated by cryptographic methods. Each data block contains a batch of network transaction information, which is used to verify the validity of its information (anti-counterfeiting) and generate the next block. Blockchain can include the underlying blockchain platform, platform product service layer, and application service layer.
[0131] The embodiments of the present application can acquire and process relevant data based on artificial intelligence technology. Among them, artificial intelligence (AI) is the theory, method, technology and application system that uses digital computers or machines controlled by digital computers to simulate, extend and expand human intelligence, perceive the environment, acquire knowledge and use knowledge to obtain the best results.
[0132] In addition, it is clear that the word "comprising" does not exclude other units or steps, and the singular does not exclude the plural. Multiple units or devices stated in the system claim can also be implemented by one unit or device through software or hardware. The second and other words are used to indicate names, but not to indicate any particular order.
[0133] Finally, it should be noted that the above embodiments are only used to illustrate the technical solution of the present invention rather than to limit it. Although the present invention has been described in detail with reference to the preferred embodiments, those skilled in the art should understand that the technical solution of the present invention can be modified or replaced by equivalents without departing from the spirit and scope of the technical solution of the present invention.
Claims
1. A method for quantitative analysis of reservation services, characterized in that: The method comprises: Collect historical data of online reservation services, and clean the historical data to obtain target data; Splitting the target data according to the time dimension to obtain target data for multiple time periods; Calculating the historical fulfillment rate of the online reservation service in each time period according to the number of reservation users and the number of visiting users in the target data of each time period in the multiple time periods; Query the service revenue and service loss of the online reservation service in each time period, calculate the marginal revenue of the online reservation service in each time period according to the service revenue, calculate the marginal loss and additional cost of the online reservation service in each time period according to the service loss, and summarize the marginal revenue, the marginal loss and the additional cost as the historical revenue weight of the online reservation service in each time period, wherein the marginal revenue is the revenue converted by the new users who make a reservation for the online reservation service for consumption, and the marginal loss is the loss converted by the users who make a reservation for the online reservation service but do not consume; Obtain the historical number of available reservation services for the online reservation service in each time period, and construct a reservation service quantity decision model according to the historical available reservation number, the historical fulfillment rate, and the historical revenue weight; According to the current available number of reservation services for the online reservation service, the current number of reservation services for the online reservation service is analyzed using the reservation service number decision model.
2. The method for quantitative analysis of reservation services according to claim 1, characterized in that: The target data is split according to the time dimension to obtain target data for multiple time periods, including: Acquire the total data volume of the target data and the collection time of each data in the target data; Generate a timestamp for each data in the target data according to the total data volume and the acquisition time; According to the timestamp of each data, target data of multiple time periods are generated.
3. The method for analyzing the quantity of reservation services according to claim 2, characterized in that: The step of generating a timestamp for each data in the target data according to the total data volume and the acquisition time includes: Obtain the sub-data volume of the target data within each of the acquisition times, and calculate the data proportion of each of the sub-data volume in the total data volume; According to the data proportion, the timestamp of each of the divided data volumes is updated to obtain the timestamp of each data in the target data.
4. The method for analyzing the quantity of reservation services according to claim 1, characterized in that: The reservation service quantity decision model includes: Among them, S represents the optimal number of reservations for the online reservation service, N represents the historical number of available reservation services, ω represents the marginal benefit in the historical benefit weight, ρ represents the marginal loss in the historical benefit weight, φ represents the additional cost in the historical benefit weight, and σ represents the historical fulfillment rate.
5. The method for quantitative analysis of reservation services according to claim 1, characterized in that: The data cleaning of the historical data to obtain the target data includes: Performing a deduplication operation on the historical data, and detecting whether the deduplicated historical data has any missing data values; If there is no missing data value, the historical data after deduplication is used as the target data; If there are missing data values, the missing data values are filled to obtain target data.
6. The method for analyzing the quantity of reservation services according to claim 5, characterized in that: The deduplication operation on the historical data includes: Calculate the similarity between any two pieces of historical data; If the similarity is not greater than the preset similarity, retaining the two historical data at the same time; If the similarity is greater than a preset similarity, any one of the two data is deleted.
7. A quantitative analysis device for reservation services, characterized in that: The device comprises: A data cleaning module is used to collect historical data of online reservation services and clean the historical data to obtain target data; A time dimension splitting module is used to split the target data according to the time dimension to obtain target data for multiple time periods; A fulfillment rate calculation module, used to calculate the historical fulfillment rate of the online reservation service in each time period according to the number of reserved users and the number of visiting users in the target data of each time period in the multiple time periods; A revenue weight calculation module is used to query the service revenue and service loss of the online reservation service in each time period, calculate the marginal revenue of the online reservation service in each time period according to the service revenue, calculate the marginal loss and additional cost of the online reservation service in each time period according to the service loss, and summarize the marginal revenue, the marginal loss and the additional cost as the historical revenue weight of the online reservation service in each time period, wherein the marginal revenue is the revenue converted by the new users who make a reservation for the online reservation service for consumption, and the marginal loss is the loss converted by the users who make a reservation for the online reservation service but do not consume; A decision model building module, used to obtain the historical number of available reservation services for the online reservation service in each time period, and to build a reservation service quantity decision model according to the historical available reservation number, the historical fulfillment rate and the historical revenue weight; The service quantity decision module is used to analyze the current reservation service quantity of the online reservation service according to the current reservation service quantity of the online reservation service and using the reservation service quantity decision model.
8. An electronic device, characterized in that: The electronic device comprises: at least one processor; and, a memory communicatively connected to the at least one processor; wherein, The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the method for analyzing the quantity of reservation services as described in any one of claims 1 to 6.
9. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the method for analyzing the quantity of reservation services according to any one of claims 1 to 6 is implemented.
Citation Information
Patent Citations
Lesson booking method and device, storage medium and server
CN110363312A
Intelligent recommendation method and device for reservation time, storage medium and terminal
CN112668743A
