User incentive resource unfreezing processing method and device, terminal and medium

Abstract

The invention discloses a user incentive resource unfreezing processing method and device, a terminal and a medium. According to the scheme provided by the invention, before an unfreezing main process is triggered, condition query is executed on a main database in advance through a timed task independent of the unfreezing main process, and the remaining freezing duration of each record is calculated; according to the method, target data conforming to a preset time window are screened out, and the data are transferred to a preset temporary storage medium, so that the unfreezing service does not need to access an original database in an execution stage, and traversal processing is directly performed on pre-stored data. Through the processing of the scheme, the calculation pressure can be dispersed to the pre-reading stage, and only a small amount of pre-screened data sets need to be processed in the unfreezing stage, so that the calculation complexity of real-time tasks is reduced, the performance bottleneck caused by high-frequency access to a main database is avoided, a system can quickly respond to an expiration event, and the efficiency of the system is improved. A user can accurately obtain available resources at a specified time point, and meanwhile, the resource occupation peak value of the server is reduced.

Description

Technical Field

[0001] This application relates to the field of internet e-commerce technology, and in particular to a method, apparatus, terminal and medium for unfreezing user incentive resources. Background Technology

[0002] With the popularization of e-commerce, major e-commerce platforms generally offer incentives such as rebates and points to users after they make purchases or participate in specific platform activities in order to attract more active users and increase user stickiness.

[0003] In current e-commerce and cashback platforms, incentive resources typically have a freeze period. After the incentive resources expire, the system needs to unfreeze them to make them available to users. The mainstream unfreezing method is to use a scheduled task to batch scan all incentive resource log tables in the database at a fixed time each day or at fixed intervals to find and unfreeze expired incentive resources. However, with the surge in the number of users and the volume of incentive resource transactions, the log table data becomes extremely large. This leads to significant computational costs and excessive time consumption for traditional scheduled tasks during full table scans, easily causing unfreezing delays and resulting in a poor user experience. Summary of the Invention

[0004] This application provides a method, apparatus, terminal, and medium for unfreezing user incentive resources, which addresses the technical problem of low efficiency in the automatic unfreezing of incentive resources on existing e-commerce platforms.

[0005] To address the aforementioned technical problems, the first aspect of this application provides a method for unfreezing user incentive resources, comprising:

[0006] When the preset timed prefetch task is triggered, the user incentive resource record is read from the user database;

[0007] Based on the user incentive resource records, determine the time interval between the freeze expiration time of each user incentive resource record and the current real-time time, so as to filter out the target user incentive resource records that are about to expire based on the time interval;

[0008] The target user incentive resource record is written to a preset temporary storage medium so that when the resource unfreezing timer task is triggered, the unfreezing server will unfreeze the target user incentive resource record stored in the temporary storage medium.

[0009] Preferably, after the unfreezing server unfreezes the target user incentive resource record stored in the temporary storage medium, the process further includes:

[0010] Based on the received incentive resource unfreezing feedback information, and based on the unfrozen resource records in the incentive resource unfreezing feedback information, update the record status of the user incentive resource record corresponding to the unfrozen resource record in the user database, and remove the target user incentive resource record of the unfrozen resource record from the temporary storage medium.

[0011] Preferably, filtering out target user incentive resource records that are about to expire based on the time interval includes:

[0012] Based on the time interval and a preset time interval threshold, target user incentive resource records with time intervals shorter than the time interval threshold are selected from the user incentive resource records.

[0013] Preferably, after reading the user incentive resource records from the user database, the process further includes:

[0014] The user incentive resource records are initially screened.

[0015] Preferably, the initial screening of the user incentive resource records includes:

[0016] Based on the resource amount value and record status contained in the user incentive resource record, user incentive resource records with a record status of pending processing and a resource amount value of non-zero are selected.

[0017] Preferably, the initial screening of the user incentive resource records includes:

[0018] Based on the order of the freeze expiration times in the user incentive resource records, and combined with a time window of preset step size, user incentive resource records within the time window are filtered out starting from the starting record, wherein the starting record is the record with the earliest freeze expiration time in the user incentive resource records.

[0019] Preferably, the temporary storage medium includes: Redis cache, in-memory database, or lightweight temporary table.

[0020] Meanwhile, a second aspect of this application also provides a user incentive resource unfreezing processing device, comprising:

[0021] The record prefetching unit is used to read user incentive resource records from the user database when a preset timed prefetching task is triggered.

[0022] The record filtering unit is used to determine the time interval between the freeze expiration time of each user incentive resource record and the current real-time time based on the user incentive resource record, so as to filter out the target user incentive resource records that are about to expire based on the time interval.

[0023] The record writing unit is used to write the target user incentive resource record to a preset temporary storage medium so that when the resource unfreezing timer task is triggered, the unfreezing server will unfreeze the target user incentive resource record stored in the temporary storage medium.

[0024] A third aspect of this application also provides a user incentive resource unfreezing processing terminal, comprising: a memory and a processor;

[0025] The memory is used to store program code, which corresponds to the user incentive resource unfreezing processing method provided in the first aspect of this application;

[0026] The processor is used to read and execute the program code to implement the user incentive resource unfreezing process.

[0027] The fourth aspect of this application provides a computer-readable storage medium storing program code, which is read and executed by a processor to implement the user incentive resource unfreezing processing method provided in the first aspect of this application.

[0028] As can be seen from the above technical solutions, this application has the following advantages:

[0029] The solution provided in this application pre-queries the main database using a scheduled task independent of the main unfreezing process before triggering the main unfreezing process. By calculating the remaining freeze time for each record, it filters out target data that meets the preset time window and transfers this data to a preset temporary storage medium. This allows the unfreezing service to directly process the pre-stored data without accessing the original database during the execution phase. By pre-isolating and storing the target data, this solution distributes the computational burden to the pre-reading phase. The unfreezing phase only needs to process a small amount of pre-filtered data, reducing the computational complexity of real-time tasks, avoiding performance bottlenecks caused by frequent access to the main database, enabling the system to respond quickly to expiration events, ensuring that users accurately obtain available resources at the specified time, and reducing peak server resource usage. Attached Figure Description

[0030] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0031] Figure 1 This is a flowchart illustrating an embodiment of a user incentive resource unfreezing method provided in this application.

[0032] Figure 2 This is a schematic diagram of the architecture of an embodiment of a user incentive resource unfreezing processing device provided in this application.

[0033] Figure 3 This is a schematic diagram of the architecture of a user incentive resource unfreezing processing terminal embodiment provided in this application. Detailed Implementation

[0034] In existing technologies, e-commerce platforms commonly use scheduled tasks to batch scan incentive resource log tables to handle resource unfreezing. As the user base expands, the amount of data in the log tables grows exponentially, and full table scans consume significant computing resources, leading to decreased task execution efficiency. Especially during promotional periods, the surge in newly frozen records exacerbates system processing delays, potentially preventing some users from using their rebates after their resources expire, thus impacting the platform's service experience.

[0035] To address the aforementioned issues, researchers discovered two key bottlenecks in the traditional unfreezing process: firstly, frequent full scans of the main database lead to a surge in I / O pressure; secondly, the unfreezing task requires repeated calculations of time differences. Data analysis revealed that only records nearing their unfreezing time point need processing, and existing solutions lack pre-screening of the target data. Therefore, this application provides a method, apparatus, terminal, and medium for unfreezing user incentive resources. This solution optimizes the data processing path of the unfreezing process by establishing a pre-reading mechanism and separating the data to be processed from the main database through pre-screening, thus solving the technical problem of low efficiency in the automatic unfreezing of incentive resources on existing e-commerce platforms.

[0036] To make the inventive objectives, features, and advantages of this application more apparent and understandable, the technical solutions in the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the embodiments described below are only some embodiments of this application, and not all embodiments. Based on the embodiments in this application, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this application.

[0037] First, a detailed description of an embodiment of a user incentive resource unfreezing method provided in this application is as follows:

[0038] Please see Figure 1 The user incentive resource unfreezing method embodiment provided in this application includes the following steps:

[0039] Step 101: When the preset timed pre-read task is triggered, read the user incentive resource record from the user database;

[0040] Step 102: Based on the user incentive resource records, determine the time interval between the freeze expiration time of each user incentive resource record and the current real-time time, so as to filter out the target user incentive resource records that are about to expire based on the time interval.

[0041] Step 103: Write the target user incentive resource record to a preset temporary storage medium so that when the resource unfreezing timer task is triggered, the unfreezing server will unfreeze the target user incentive resource record stored in the temporary storage medium.

[0042] The scheduled pre-fetch task refers to a periodically executed data preprocessing operation, which can be implemented using a distributed task scheduling framework. For example, a pre-fetch task can be scheduled to run every morning to identify records expiring within the next 24 hours. User incentive resource records are structured data containing fields such as frozen status, resource quota, and expiration time. This data can be obtained through database queries, such as filtering records with a "frozen" status and a non-empty expiration time field in SQL. Time interval filtering involves filtering data by calculating the difference between the frozen expiration time and the system time. This can be implemented using a timestamp difference calculation function, such as converting the expiration time field of the database record to a Unix timestamp and then subtracting it from the current timestamp. Temporary storage medium refers to a non-persistent storage medium with high-speed read and write capabilities. This can be implemented using a key-value database, such as storing the filtered record IDs and expiration times in a hash table format on this storage medium.

[0043] Specifically, during the pre-reading phase, the system performs conditional queries on the main database in advance through a scheduled task independent of the main unfreezing process. By calculating the remaining freeze time for each record, target data that meets the preset time window is selected. After this data is transferred to a preset temporary storage medium, the unfreezing service does not need to access the original database during the execution phase; it directly iterates through and processes the pre-stored data. For example, if a time threshold of 6 hours is set in the pre-reading task, all records with a remaining freeze time of less than 6 hours will be marked as data to be unfrozen and stored in batches in the cache queue.

[0044] This solution employs a pre-fetch mechanism to isolate and store target data in advance, distributing the computational burden to the pre-fetch phase. The unfreezing phase only needs to process the pre-selected dataset, reducing the computational complexity of real-time tasks. Through this technical solution, this application effectively avoids performance bottlenecks caused by frequent access to the main database and shortens the execution cycle of the unfreezing task. Because the unfreezing phase directly processes pre-stored high-priority data, the system can quickly respond to expiration events, ensuring users accurately obtain available resources at the specified time, while simultaneously reducing peak server resource usage.

[0045] Based on the above basic embodiments, this application further proposes that after the unfreezing server unfreezes the target user incentive resource records stored in the temporary storage medium, it also includes: according to the received incentive resource unfreezing feedback information, according to the unfrozen resource records in the incentive resource unfreezing feedback information, updating the record status of the user incentive resource record corresponding to the unfrozen resource record in the user database, and removing the target user incentive resource record of the unfrozen resource record from the temporary storage medium.

[0046] The incentive resource unfreezing feedback information refers to the status confirmation data generated after the unfreezing server completes the resource unfreezing operation. Specifically, it can be implemented using a JSON format message containing an unfreezing record identifier and an operation timestamp to transmit the execution result of the unfreezing operation. Unfrozen resource records refer to incentive resource data entries that have completed the unfreezing operation and whose status has changed. Specifically, they can be located by parsing the unique identifier field of the record in the feedback information. Record status update refers to changing the frozen status of the corresponding record in the user database to the unfrozen status. Specifically, it can be implemented by executing an UPDATE statement using a database transaction mechanism to ensure the atomicity of main data storage and unfreezing operation. Removing the target user incentive resource record refers to deleting the processed record from the temporary storage medium. Specifically, it can be implemented using the Redis DEL command or the pointer release operation of the memory data structure to avoid duplicate processing of unfrozen data.

[0047] Specifically, after the unfreezing server completes the batch unfreezing operation on the target records in the temporary storage medium, the system will automatically receive status feedback information containing the operation results. By parsing the record identifier field in the feedback information, the system can accurately match the corresponding original incentive resource record in the user database and update its status field to "unfrozen" based on the transaction mechanism. Simultaneously, a data deletion command synchronized with the database operation is executed in the temporary storage medium to ensure that the unfrozen records no longer occupy temporary storage space. This forms a closed-loop processing flow, ensuring that the data status of the main database and the temporary storage medium remains consistent at all times.

[0048] This solution achieves real-time synchronization of unfreezing results between the main storage and temporary storage media by forcibly associating unfreezing operations with data status updates, effectively eliminating the risk of data residue caused by asynchronous operations. Through the above technical solution, this application solves the problem of data status asynchrony between the main database and temporary storage media during the unfreezing of incentive resources, avoiding storage space waste caused by failure to clean up temporary data in a timely manner. At the same time, the transaction mechanism ensures the integrity of data operations and prevents loss of unfreezing status or repeated unfreezing errors caused by system anomalies.

[0049] In some embodiments, regarding the step 102 of filtering out target user incentive resource records that are about to expire based on time intervals, the specific implementation method is as follows: based on time intervals and combined with a preset time interval threshold, target user incentive resource records with time intervals less than the time interval threshold are filtered out from the user incentive resource records.

[0050] The time interval refers to the difference between the freeze expiration time and the current real-time time. This can be calculated using timestamp differences, for example, by obtaining the Unix timestamp corresponding to the freeze expiration time and subtracting it from the current system timestamp to obtain the interval value in seconds. The time interval threshold is a pre-set critical value used to determine whether the incentive resource is about to expire. This can be implemented using a fixed value or a dynamically adjusted value, such as setting it to 24 hours or dynamically adjusting it to a value between 12 and 36 hours based on system load. This threshold is used to filter out records closest to their unfreezing time.

[0051] Specifically, after the scheduled pre-read task is triggered, the system iterates through all incentive resource records marked as pending preprocessing in the user database. For each record, it calculates the difference between the freeze expiration time and the current time, and compares this difference with a preset time interval threshold. For example, if the time interval threshold is set to 24 hours, all records with a difference less than or equal to 24 hours will be identified as target records about to expire. These target records are then transferred in batches to temporary storage media, such as a Redis cache. This allows the system to process only a small amount of data in the temporary storage media during subsequent unfreezing tasks. More specifically, the temporary storage media can be a Redis cache, an in-memory database, or a lightweight temporary table. By selecting a storage media with fast access characteristics, the unfreezing server can directly access the target records pre-transferred to the temporary media without performing a full table scan in the main log table. This reduces the time complexity of data retrieval, effectively shortening the response time of data retrieval when the unfreezing task is triggered. It also avoids processing delays caused by excessive data volume in the main log table, while simultaneously matching the characteristics of the temporary storage media.

[0052] This solution introduces a time interval threshold filtering mechanism, which can filter out records that are about to expire during the pre-reading phase, avoiding redundant data in subsequent unfreezing operations. For example, when there are millions of records in the user database, threshold filtering can reduce the actual number of records to be processed to several thousand, significantly reducing the data scanning scope.

[0053] In some embodiments, this application further proposes that after reading user incentive resource records from the user database, the process may include: performing an initial screening of the user incentive resource records.

[0054] The initial screening refers to the preliminary filtering of raw records in the user database during the pre-reading stage. This can be achieved by setting a status identifier field and a numerical threshold, such as filtering records with a status of "pending processing" and a resource quota value greater than zero. The resource quota value refers to the amount of incentive resources frozen in the user account, which can be determined using a floating-point number stored in the database field. The record status refers to the processing status of the incentive resources during the freeze period, which can be marked using an enumerated field as pending, unfrozen, or expired.

[0055] Specifically, after acquiring user incentive resource records during the pre-reading phase, the original dataset is first pre-filtered based on preset selection criteria. For example, by using the WHERE clause in the database query, only valid records with a pending status and a resource quota value greater than zero are retained. This step significantly reduces the amount of data that needs to be processed when calculating the freeze expiration time interval, avoiding the waste of computational resources caused by traversing the entire dataset.

[0056] For example, after a scheduled pre-read task is triggered, when the system reads user incentive resource records in batches from the user database, it first checks the record status field of each record, retaining only those marked as pending processing. Simultaneously, it validates the resource quota value field, filtering out records with a value of zero. This combined filtering quickly eliminates records that do not require processing, such as unfrozen but not cleared historical data, and zero-quota records resulting from user operation cancellations. The set of records after this initial filtering will serve as input data for subsequent calculations of the freeze expiration time, thereby reducing the number of records requiring time interval calculations.

[0057] This embodiment adds an initial screening step, completing preliminary filtering during the data reading stage. This effectively reduces the data processing volume in the subsequent freeze time calculation stage and decreases the system's resource consumption in time interval calculation and temporary storage medium writing. Through this processing method, this application can significantly reduce the number of records that need to participate in the freeze expiration time calculation, avoiding redundant operations on invalid or already processed records. This directly reduces the computational resource occupation of the pre-reading task, shortens the overall time from database reading to filtering output, and reduces the amount of unnecessary data stored in the temporary storage medium, providing more accurate data input for the subsequent unfreezing process.

[0058] Alternatively, during the initial screening process, all user incentive resource records are first sorted in ascending order of their freeze expiration dates, and the earliest expiring record is determined as the starting point. Then, based on a preset time window step size, for example, starting from the freeze time corresponding to the starting record, a fixed range of records for subsequent periods is selected as the first batch of screening targets. After completing the first batch, the starting point of the time window is updated to the starting record of the next batch, and the above screening logic is repeated. By processing in batches, the computational resource pressure caused by a single full scan is avoided, while ensuring that the screening process covers all records that are about to expire.

[0059] This embodiment significantly reduces the amount of data processed per batch by using time windows for batch filtering. For example, when user incentive resource records reach millions, existing technologies require loading all data at once, while this application can split the data into multiple time window batches, processing only a few thousand records each time, thereby reducing memory usage and computational latency. This processing method effectively solves the problem of excessive resource consumption in the initial screening stage under large-scale data scenarios. Through the batch processing mechanism, the system can reduce the computational load of a single task while ensuring the integrity of the filtering, avoiding processing delays caused by insufficient memory or CPU overload, and improving the overall execution efficiency of the unfreezing task.

[0060] The above is a detailed description of an embodiment of a user incentive resource unfreezing processing method provided in this application. The following is a detailed description of related embodiments of a user incentive resource unfreezing processing device, terminal, and storage medium provided in this application.

[0061] Please see Figure 2 This application provides an embodiment of a user incentive resource unfreezing processing device, the architecture of which includes:

[0062] The pre-reading unit 201 is used to read user incentive resource records from the user database when a preset timed pre-reading task is triggered.

[0063] The record filtering unit 202 is used to determine the time interval between the freeze expiration time of each user incentive resource record and the current real-time time based on the user incentive resource record, so as to filter out the target user incentive resource records that are about to expire based on the time interval.

[0064] The record writing unit 203 is used to write the target user incentive resource record to a preset temporary storage medium so that when the resource unfreezing timer task is triggered, the unfreezing server will unfreeze the target user incentive resource record stored in the temporary storage medium.

[0065] Specifically, when a scheduled pre-fetch task is triggered, the record pre-fetch unit retrieves frozen incentive resource records in batches from the user database. The record filtering unit calculates the difference between the freeze expiration time of each record and the current time, and filters out records that will be unfrozen within a specific future time period by combining this with a preset threshold. The filtered target records are then transferred in batches to temporary storage medium by the record writing unit, forming a dedicated dataset for the unfreezing task. When the unfreezing scheduled task starts, the unfreezing server directly accesses the dataset in the temporary storage medium for batch processing, avoiding a full scan of the main database. This solution decouples data filtering from the unfreezing operation through phased processing, allowing the unfreezing phase to process only the pre-processed, simplified dataset.

[0066] Furthermore, this application also proposes an embodiment of a user incentive resource unfreezing processing terminal, such as... Figure 3 As shown, the terminal in this embodiment mainly comprises a memory 33 and a processor 31, which are connected via a communication bus 34. The memory 33 stores program code corresponding to the user incentive resource unfreezing processing method. The processor 31 reads and executes the program code to implement the user incentive resource unfreezing processing method. The memory refers to the physical device used to store program code, which can be implemented using computer memory, a solid-state drive, or a hard disk drive. Its function is to provide the processor with a set of executable instructions. The processor is a computing unit capable of executing program code, which can be implemented using a central processing unit or a microprocessor chip. Its function is to control the terminal to perform pre-reading, filtering, and unfreezing operations by reading the program code from the memory.

[0067] Specifically, when a pre-set scheduled pre-fetch task is triggered, the processor executes program code to read user incentive resource records from the user database, calculates the interval between the freeze expiration time of each record and the current time, and filters out target records with an interval less than a preset threshold. These target records are then written in batches to temporary storage media, such as a Redis cache or in-memory database, so that when the resource unfreezing scheduled task is triggered, the data can be directly read from the temporary storage media to complete the unfreezing process. During this process, the memory continuously saves the running state of the program code, and the processor achieves efficient data processing through multi-threaded or distributed computing.

[0068] Furthermore, this application also proposes an embodiment of a computer-readable storage medium, in which program code is stored, which is read and executed by a processor to implement a user incentive resource unfreezing processing method.

[0069] Computer-readable storage media refers to physical carriers capable of persistently storing program code, specifically solid-state drives, hard disk drives, or flash drives. Their function is to provide a reliable storage foundation for the execution of the unfreezing process. Program code refers to computer programs containing executable instructions, specifically written in languages ​​such as Java, Python, or C++. Its function is to execute the code logic through the processor, implementing the pre-fetching, filtering, and batch processing functions for unfreezing incentive resources.

[0070] Specifically, when the program code is executed by the processor, it first reads user incentive resource records from the user database after the preset timed pre-fetch task is triggered. Then, it calculates the interval between the freeze expiration time of each record and the current time, filters out target records with intervals less than a preset threshold, and writes these records in batches to temporary storage media. When the resource unfreezing timed task is triggered, the unfreezing server directly reads the target records from the temporary storage media to perform the unfreezing operation, avoiding a full scan of the main log table. For example, Redis caching can be used as the temporary storage medium, as its memory read / write characteristics can significantly improve data access speed.

[0071] Those skilled in the art will clearly understand that, for the sake of convenience and brevity, the specific working processes of the terminals, devices, and units described above can be referred to the corresponding processes in the foregoing method embodiments, and will not be repeated here.

[0072] In the several embodiments provided in this application, it should be understood that the disclosed terminals, devices, and methods can be implemented in other ways. For example, the device embodiments described above are merely illustrative; for instance, the division of units is only a logical functional division, and in actual implementation, there may be other division methods. For example, multiple units or components may be combined or integrated into another system, or some features may be ignored or not executed. Furthermore, the coupling or direct coupling or communication connection shown or discussed may be through some interfaces, or indirect coupling or communication connection between devices or units, and may be electrical, mechanical, or other forms.

[0073] The terms “first,” “second,” “third,” “fourth,” etc. (if present) in the specification and accompanying drawings of this application are used to distinguish similar objects and are not necessarily used to describe a particular order or sequence. It should be understood that such data can be interchanged where appropriate so that embodiments of the application described herein can be implemented, for example, in orders other than those illustrated or described herein. Furthermore, the terms “comprising” and “having,” and any variations thereof, are intended to cover a non-exclusive inclusion; for example, a process, method, system, product, or apparatus that comprises a series of steps or units is not necessarily limited to those steps or units explicitly listed, but may include other steps or units not explicitly listed or inherent to such processes, methods, products, or apparatus.

[0074] It should be understood that in this application, "at least one (item)" means one or more, and "more than" means two or more. "And / or" is used to describe the relationship between related objects, indicating that three relationships can exist. For example, "A and / or B" can represent three cases: only A exists, only B exists, and both A and B exist simultaneously, where A and B can be singular or plural. The character " / " generally indicates that the preceding and following related objects are in an "or" relationship. "At least one (item) of the following" or similar expressions refer to any combination of these items, including any combination of single or plural items. For example, at least one (item) of a, b, or c can represent: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", where a, b, and c can be single or multiple.

[0075] The units described as separate components may or may not be physically separate. The components shown as units may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the units can be selected to achieve the purpose of this embodiment according to actual needs.

[0076] Furthermore, the functional units in the various embodiments of the present invention can be integrated into one processing unit, or each unit can exist physically separately, or two or more units can be integrated into one unit. The integrated unit can be implemented in hardware or as a software functional unit.

[0077] If the integrated unit is implemented as a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, or all or part of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of the present invention. The aforementioned storage medium includes various media capable of storing program code, such as USB flash drives, portable hard drives, read-only memory (ROM), random access memory (RAM), magnetic disks, or optical disks.

[0078] The above-described embodiments are only used to illustrate the technical solutions of this application, and are not intended to limit them. Although this application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features. Such modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of this application.

Claims

1. A method for unfreezing user incentive resources, characterized in that, include: When the preset timed prefetch task is triggered, the user incentive resource record is read from the user database; Based on the user incentive resource records, determine the time interval between the freeze expiration time of each user incentive resource record and the current real-time time, so as to filter out the target user incentive resource records that are about to expire based on the time interval; The target user incentive resource record is written to a preset temporary storage medium so that when the resource unfreezing timer task is triggered, the unfreezing server will unfreeze the target user incentive resource record stored in the temporary storage medium.

2. The method for unfreezing user incentive resources according to claim 1, characterized in that, After the unfreezing server unfreezes the target user incentive resource records stored in the temporary storage medium, it also includes: Based on the received incentive resource unfreezing feedback information, and based on the unfrozen resource records in the incentive resource unfreezing feedback information, update the record status of the user incentive resource record corresponding to the unfrozen resource record in the user database, and remove the target user incentive resource record of the unfrozen resource record from the temporary storage medium.

3. The method for unfreezing user incentive resources according to claim 1, characterized in that, Based on the aforementioned time interval, the target user incentive resource records that are about to expire include: Based on the time interval and a preset time interval threshold, target user incentive resource records with time intervals shorter than the time interval threshold are selected from the user incentive resource records.

4. The method for unfreezing user incentive resources according to claim 1, characterized in that, After retrieving user incentive resource records from the user database, the following also includes: The user incentive resource records are initially screened.

5. The method for unfreezing user incentive resources according to claim 4, characterized in that, The initial screening of the user incentive resource records includes: Based on the resource amount value and record status contained in the user incentive resource record, user incentive resource records with a record status of pending processing and a resource amount value of non-zero are selected.

6. The method for unfreezing user incentive resources according to claim 4, characterized in that, The initial screening of the user incentive resource records includes: Based on the order of the freeze expiration times in the user incentive resource records, and combined with a time window of preset step size, user incentive resource records within the time window are filtered out starting from the starting record, wherein the starting record is the record with the earliest freeze expiration time in the user incentive resource records.

7. The method for unfreezing user incentive resources according to claim 1, characterized in that, The temporary storage medium includes: Redis cache, in-memory database, or lightweight temporary table.

8. A user incentive resource unfreezing processing device, characterized in that, include: The record prefetching unit is used to read user incentive resource records from the user database when a preset timed prefetching task is triggered. The record filtering unit is used to determine the time interval between the freeze expiration time of each user incentive resource record and the current real-time time based on the user incentive resource record, so as to filter out the target user incentive resource records that are about to expire based on the time interval. The record writing unit is used to write the target user incentive resource record to a preset temporary storage medium so that when the resource unfreezing timer task is triggered, the unfreezing server will unfreeze the target user incentive resource record stored in the temporary storage medium.

9. A user incentive resource unfreezing processing terminal, characterized in that, include: Memory and processor; The memory is used to store program code, which corresponds to the user incentive resource unfreezing processing method as described in any one of claims 1 to 7; The processor is used to read and execute the program code to implement the user incentive resource unfreezing process.

10. A computer-readable storage medium, characterized in that, The computer-readable storage medium contains program code that is read and executed by a processor to implement the user incentive resource unfreezing processing method as described in any one of claims 1 to 7.

Images