CN111639965A

CN111639965A - Integral updating method and device

Info

Publication number: CN111639965A
Application number: CN202010411740.XA
Authority: CN
Inventors: 刘伍
Original assignee: Zhejiang Koubei Network Technology Co Ltd
Current assignee: Zhejiang Koubei Network Technology Co Ltd
Priority date: 2020-05-15
Filing date: 2020-05-15
Publication date: 2020-09-08
Anticipated expiration: 2040-05-15
Also published as: CN111639965B

Abstract

The embodiment of the invention discloses an integral updating method and a device, wherein the method comprises the following steps: when the integral updating operation is detected, determining an integral operation result corresponding to the integral updating operation according to the updating type of the integral updating operation and the integral amount; recording an integral operation result in an integral main table, and generating a task record to be updated corresponding to the integral updating operation in an intermediate data table; inquiring integral attribute information of each integral data record stored in the integral detail table according to the task record to be updated stored in the intermediate data table; and asynchronously updating at least one integral data record matched with the integral updating operation in the integral list according to the query result. Therefore, the point attributes of each point in the point list in the embodiment of the invention are set independently, so that different point attributes can be flexibly set for each point acquired by a user.

Description

Integral updating method and device

Technical Field

The embodiment of the invention relates to the field of electronic information, in particular to an integral updating method and device.

Background

At present, a plurality of services have an integral function, and the use permission of a user for the service function can be flexibly configured through the integral. Since the service integral of each user dynamically changes with the service operation triggered by the user, the current service integral of each user needs to be dynamically recorded and maintained through a data table.

In the prior art, the service integration situation of each user is recorded through a data table. For ease of management, the exact same point attribute is typically set for each point taken by the user. For example, in the case of taking the score attribute as the score expiration time, the score expiration time is usually a natural year or a season. Accordingly, all points taken within the same natural year or season expire the last day of the natural year or season.

However, the inventor finds that the above mode in the prior art has at least the following defects in the process of implementing the invention: the point attributes of each point in the data table are completely the same, and different point attributes cannot be flexibly set for each point acquired by a user. For example, in some service scenarios, the expiration time of each point needs to be dynamically set according to the relative time point determined by the point acquisition time, and the single data table in the prior art obviously cannot meet the service requirement.

Disclosure of Invention

In view of the above, embodiments of the present invention are proposed to provide an integral update method and apparatus that overcome the above problems or at least partially solve the above problems.

According to an aspect of an embodiment of the present invention, there is provided a point updating method including:

when the integral updating operation is detected, determining an integral operation result corresponding to the integral updating operation according to the updating type of the integral updating operation and the integral amount;

recording the integral operation result in an integral main table, and generating a task record to be updated corresponding to the integral updating operation in an intermediate data table;

inquiring integral attribute information of each integral data record stored in an integral detail table according to the task record to be updated stored in the intermediate data table;

and asynchronously updating at least one integral data record matched with the integral updating operation in the integral list according to the query result.

Optionally, the generating a task record to be updated corresponding to the integral update operation in the intermediate data table includes:

and generating a task record to be updated corresponding to the point updating operation in an intermediate data table according to the updating type and the point amount of the point updating operation and a point operation result corresponding to the point updating operation.

Optionally, after the recording the integration operation result in the integration main table, the method further includes: sending an update success notification corresponding to the integral operation result;

inquiring integral attribute information of each integral data record stored in an integral detail table according to the task record to be updated stored in the intermediate data table; asynchronously updating at least one integral data record in the integral list matched with the integral updating operation according to the query result comprises:

and reading the task record to be updated stored in the intermediate data table through an asynchronous thread, and implementing asynchronous updating of the at least one integral data record according to the read task record to be updated.

Optionally, before the method is executed, the method further includes:

when an integral acquisition operation is detected, recording an integral operation result corresponding to the integral acquisition operation in an integral main table;

adding at least one integral data record corresponding to the integral acquisition operation in an integral list; wherein the integral attribute information of the integral data record comprises at least one of: point acquisition time, point expiration time, point type, point source, point priority, and operation identification of point acquisition operation.

Optionally, the integral update operation includes: an integral increase class update operation and an integral decrease class update operation;

wherein the point addition class update operation comprises: canceling deduction operation, canceling pre-deduction operation and canceling freezing operation; the integral reduction type update operation includes: an integral deduction operation, an integral pre-deduction operation, and an integral freezing operation.

Optionally, the point attribute information of each point data record stored in the point detail table is inquired according to the task record to be updated stored in the intermediate data table; asynchronously updating at least one integral data record in the integral list matched with the integral updating operation according to the query result comprises:

acquiring integral expiration time contained in integral attribute information of each integral data record stored in an integral detail table, and determining at least one integral data record matched with the integral updating operation according to the integral expiration time;

when the point updating operation is a point increasing type updating operation, determining the point data record with late point expiration time as at least one point data record matched with the point updating operation; when the point updating operation is a point reduction type updating operation, determining the point data record with the early point expiration time as at least one point data record matched with the point updating operation.

Optionally, the main integration table further includes: an account master table and a flow master table; the main account table is used for recording integral operation results corresponding to the current account balance, and the flow main table is used for recording integral operation results corresponding to the integral updating operation;

and, the integration schedule further comprises: an account statement and a flow statement;

when the integral acquisition operation is detected, respectively adding integral data records corresponding to the integral acquisition operation in the account detail table and the flow detail table;

executing, each time a point updating operation is detected, an updating process for a point data record corresponding to the point updating operation that has been stored in the account list; then, an update data record corresponding to the current point update operation is added to the point list.

Optionally, there is an association relationship between the update data record added in the point list and the point data record after performing the update processing in the account list;

the update data record in the point list includes a record identifier, an update result, and point attribute information of the point data record after the update process is performed in the account list.

Optionally, the method further comprises:

and clearing the expired integral data records according to the integral expiration time contained in the integral attribute information of each integral data record stored in the integral detail table.

Optionally, the main integration table further includes: a pre-deduction master table corresponding to an integral pre-deduction type update operation, and the integral detail table further comprises: and (5) pre-buckling a detailed list.

According to still another aspect of the embodiments of the present invention, there is provided an integration updating apparatus including:

the determining module is suitable for determining a point updating operation result corresponding to the point updating operation according to the updating type and the point amount of the point updating operation when the point updating operation is detected;

the main table updating module is suitable for recording the integral operation result in an integral main table;

the intermediate table updating module is suitable for generating a task record to be updated corresponding to the integral updating operation in an intermediate data table;

the query module is suitable for querying the integral attribute information of each integral data record stored in the integral detail table according to the task record to be updated stored in the intermediate data table;

and the list updating module is suitable for asynchronously updating at least one integral data record matched with the integral updating operation in the integral list according to the query result.

Optionally, the intermediate table updating module is specifically adapted to:

Optionally, the master table updating module is further adapted to: sending an update success notification corresponding to the integral operation result;

the schedule update module is specifically adapted to:

Optionally, the apparatus further comprises:

the integral acquisition module is suitable for recording an integral operation result corresponding to the integral acquisition operation in an integral main table when the integral acquisition operation is detected; adding at least one integral data record corresponding to the integral acquisition operation in an integral list; wherein the integral attribute information of the integral data record comprises at least one of: point acquisition time, point expiration time, point type, point source, point priority, and operation identification of point acquisition operation.

Optionally, the detail table updating module is specifically adapted to:

wherein each time a point acquisition operation is detected, the point acquisition module is further adapted to add point data records corresponding to the point acquisition operation in the account list and the flow list respectively;

whenever a point update operation is detected, the list update module is further adapted to perform an update process for the point data record corresponding to the point update operation already stored in the account list; then, an update data record corresponding to the current point update operation is added to the point list.

Optionally, the apparatus further comprises:

and the integral clearing module is suitable for clearing the expired integral data records according to the integral expiration time contained in the integral attribute information of each integral data record stored in the integral detail table.

According to still another aspect of the embodiments of the present invention, there is provided an electronic apparatus including: the system comprises a processor, a memory, a communication interface and a communication bus, wherein the processor, the memory and the communication interface complete mutual communication through the communication bus;

the memory is used for storing at least one executable instruction, and the executable instruction enables the processor to execute the operation corresponding to the integral updating method.

According to a further aspect of the embodiments of the present invention, there is provided a computer storage medium having at least one executable instruction stored therein, where the executable instruction causes a processor to perform operations corresponding to the above-mentioned integral update method.

In the method and the device for updating the integral, provided by the embodiment of the invention, an integral main table and an integral detail table are arranged, wherein the integral main table is used for quickly recording an integral operation result corresponding to the integral updating operation by taking one-time integral operation as a unit; the point list is used for recording point data records of all points involved in the point operation and point attribute information thereof by taking one point as a unit. Since a plurality of point data records may be involved in one point updating operation, the point attribute information of each point data record corresponding to the point updating operation is updated through the point list. Accordingly, the mode can separately record the integral attribute information of the integral by taking one integral as a unit through the integral detail table. Therefore, the point attributes of each point in the point list in the embodiment of the invention are set independently, so that different point attributes can be flexibly set for each point acquired by a user. In addition, asynchronous updating between the main integral table and the detailed integral table can be realized by means of the intermediate data table, so that on the premise of ensuring that the main integral table is updated quickly and an updating result is returned, the integral data records in the detailed integral table are updated one by one, and the problem that the response speed is influenced due to slow updating of the detailed integral table is solved.

The foregoing description is only an overview of the technical solutions of the present invention, and the embodiments of the present invention are described below in order to make the technical means of the present invention more clearly understood and to make the above and other objects, features, and advantages of the present invention more clearly understandable.

Drawings

Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:

fig. 1 is a flowchart illustrating a point updating method according to an embodiment of the present invention;

fig. 2 is a flowchart illustrating a point updating method according to a second embodiment of the present invention;

fig. 3 is a structural diagram illustrating an integration updating apparatus according to a third embodiment of the present invention;

fig. 4 shows a schematic structural diagram of an electronic device according to a fifth embodiment of the present invention.

Detailed Description

Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.

Example one

Fig. 1 shows a flowchart of a point updating method according to an embodiment of the present invention. As shown in fig. 1, the method includes:

step S110: when the point updating operation is detected, a point operation result corresponding to the point updating operation is determined according to the updating type of the point updating operation and the point amount.

The point updating operation generally refers to various operations that can change the service points, and specifically may be a point increasing type updating operation or a point decreasing type updating operation.

In general, the integral update operation refers to: the operation of updating the acquired integral is performed, for example, various operations such as deduction, freezing or deduction, and unfreezing are performed on the acquired integral. Accordingly, it is determined to perform an increase process or a decrease process for the acquired point according to the update type of the point update operation, and a specific number of increases or decreases is determined according to the amount of the point update operation, thereby obtaining a result of the point operation corresponding to the point update operation.

Step S120: and recording the result of the integral operation in the integral main table, and generating a task record to be updated corresponding to the integral updating operation in the intermediate data table.

Specifically, the main integration table is used for recording operation results corresponding to each operation from the operation dimension. The integral main table can be one or more, and particularly can be various types of main tables. For example, the main point table may be an account main table used for storing account balance information, and correspondingly, the point operation result refers to the current account balance after the point is updated. For another example, the main integral table may also be a flow chart for storing operation flow information, and correspondingly, the integral operation result refers to an operation flow record corresponding to the integral update operation.

In addition, a task record to be updated corresponding to the point updating operation is generated in the intermediate data table, and the task record to be updated is determined according to the updating type and the point amount of the point updating operation and the point operation result corresponding to the point updating operation.

Step S130: and inquiring the integral attribute information of each integral data record stored in the integral detail table according to the task record to be updated stored in the intermediate data table.

And acquiring the task record to be updated stored in the intermediate data table, determining the updating type and the credit amount of the corresponding credit updating operation, and inquiring the credit attribute information of each credit data record stored in the credit detail table.

Specifically, the score list is used for recording score data records corresponding to each score and score attribute information thereof from the score dimension. Wherein the integral attribute information includes: and the integration source, the integration flow direction, the integration expiration time and other information.

For one-time integral updating operation, the integral main table is recorded by taking the operation as a unit, so that only one data record corresponding to the one-time integral updating operation needs to be recorded in the integral main table. However, the score list is recorded in units of one score, and one score updating operation may involve a plurality of scores, and accordingly, the number of score data records in the score list to be updated may be a plurality of. It can be seen that, since one integration operation may involve multiple integrations, the contents in the integration list are more refined than in the main integration list.

Similar to the main integral table, the integral tables may be one or more, and may specifically be various types of tables. For example, the points list may be an account list for storing account balance change information. As another example, the integral schedule may also be a pipeline schedule for storing operational pipeline change information.

Step S140: and asynchronously updating at least one integral data record matched with the integral updating operation in the integral list according to the query result.

Specifically, attributes such as the point expiration time, the point source, the point number and the like of each point data record in the point list can be determined according to the query result, correspondingly, at least one point data record matched with the updating type and the point amount of the point updating operation recorded in the task record to be updated can be determined, and updating processing can be executed aiming at the at least one point data record, so that the individual updating operation aiming at each point is realized.

Therefore, in the integration updating method provided by the embodiment of the invention, an integration main table and an integration detail table are provided, wherein the integration main table is used for quickly recording an integration operation result corresponding to the current integration updating operation by taking one-time integration operation as a unit; the point list is used for recording point data records of all points involved in the point operation and point attribute information thereof by taking one point as a unit. Since a plurality of point data records may be involved in one point updating operation, the point attribute information of each point data record corresponding to the point updating operation is updated through the point list. Accordingly, the mode can separately record the integral attribute information of the integral by taking one integral as a unit through the integral detail table. Therefore, the point attributes of each point in the point list in the embodiment of the invention are set independently, so that different point attributes can be flexibly set for each point acquired by a user. In addition, asynchronous updating between the main integral table and the detailed integral table can be realized by means of the intermediate data table, so that on the premise of ensuring that the main integral table is updated quickly and an updating result is returned, the integral data records in the detailed integral table are updated one by one, and the problem that the response speed is influenced due to slow updating of the detailed integral table is solved.

Example II,

Fig. 2 shows a flowchart of an integration updating method according to a second embodiment of the present invention, and as shown in fig. 2, the method includes:

step S200: when the integral acquisition operation is detected, recording an integral operation result corresponding to the integral acquisition operation in an integral main table; and adding at least one integral data record corresponding to the integral acquisition operation in the integral list.

The point acquisition operation can be triggered through various entries such as a point acquisition entry and a point exchange entry. In summary, the point acquisition operation broadly refers to various types of operations for adding points to a user account.

Specifically, for one point obtaining operation, the obtained point is usually one point, and certainly, in some special service scenarios, two points may be obtained simultaneously through one point obtaining operation, which is not limited in the present invention.

Accordingly, when one integral obtaining operation is used to obtain one integral, an integral operation result corresponding to the integral obtaining operation is recorded in the integral main table, and the integral operation result may be a current balance result or an operation pipeline result, which is not limited in the present invention. The integral operation result in the integral main table is mainly used for realizing functions of integral inquiry and the like so as to show the content in the integral main table to a user. In addition, the point data record corresponding to one point acquired by the point acquisition operation is recorded in the point list. Because one integral acquisition operation is used for acquiring one integral, only one integral data record needs to be added into the integral detail table; if one integral obtaining operation is used for obtaining multiple integral points at the same time, multiple integral data records need to be correspondingly added in the integral detail table so as to record the integral attribute information of each integral point respectively.

The point attribute information of the point data record is used for recording various types of information related to the point, for example, the point attribute information includes at least one of the following items: the credit acquisition time, the credit expiration time, the credit type, the credit source, the credit flow direction, the credit priority, the operation identifier of the credit acquisition operation, and the like. Because the points are independent of each other, creating a point data record for each point is beneficial to flexibly configuring the point attribute of each point.

Step S210: when the point updating operation is detected, a point operation result corresponding to the point updating operation is determined according to the updating type of the point updating operation and the point amount.

In this embodiment, the integral update operation refers to: and updating the acquired points in the user account. Specifically, the integral update operation includes: an integral increase class update operation and an integral decrease class update operation; wherein, the point addition type updating operation comprises the following steps: canceling deduction operation, canceling pre-deduction operation and canceling freezing operation; the point reduction class update operation includes: an integral deduction operation, an integral pre-deduction operation, and an integral freezing operation. It follows that whatever type of point update operation is performed on points already acquired in the user account.

Accordingly, it is determined to perform an increase process or a decrease process for the acquired point according to the update type of the point update operation, and a specific number of increases or decreases is determined according to the amount of the point update operation, thereby obtaining a result of the point operation corresponding to the point update operation.

Step S220: and recording an integral operation result in the integral main table, and generating a task record to be updated corresponding to the integral updating operation and the integral operation result in the intermediate data table.

Specifically, the main integration table is used for recording operation results corresponding to each operation from the operation dimension. In this embodiment, the master table of integrals includes: an account master table and a flow master table. The account main table is used for storing account balance information, and correspondingly, the point operation result refers to the current account balance after the point is updated. The running water main table is used for storing operation running water information, and correspondingly, the integral operation result refers to an operation running water record corresponding to the integral updating operation.

Optionally, after the integration operation result is recorded in the integration main table, an update success notification corresponding to the integration operation result may be further sent. The receiver of the successful update notification can be an upper-layer service module for calling the score update interface to execute the score update operation, so that the upper-layer service module can return an update result to the user according to the successful update notification, thereby reducing the waiting time delay of the user and improving the response speed of the update operation of the user.

Step S230: and determining an updating type and a credit amount according to the task record to be updated stored in the intermediate data table, inquiring credit attribute information of each credit data record stored in the credit detail table, and asynchronously updating at least one credit data record matched with the credit updating operation in the credit detail table according to an inquiring result.

In particular, since one point updating operation may involve multiple points, it is necessary to perform the updating operation on multiple point data records in the point list, which results in a long time for the updating operation. Therefore, in the present embodiment, in order to avoid the user waiting time from being too long due to the time-consuming time for updating the point list, the asynchronous update process between the point list and the point main list is realized by the intermediate data list.

It can be seen that by this step, at least one point data record matching the point updating operation can be updated according to the task record to be updated stored in the intermediate data table. During specific implementation, the task record to be updated stored in the intermediate data table can be read through the asynchronous thread, and asynchronous updating of at least one integral data record is realized according to the task record to be updated.

For example, it is assumed that 100 point data records are recorded in the point list, each point data record is obtained by check-in, and the point amount included in each point data record is 10. It is necessary to deduct 80 points from the user account at a time by deduction-like point update operations. At this time, as for the main point table, since the 80 points are deducted once, only one operation result corresponding to the deduction operation needs to be recorded, that is: and recording the account balance before operation, the account balance after operation and other contents. However, for the point list, since each point data record in the point list only contains 10 points, the point amount in 8 point data records needs to be deducted according to the point expiration time contained in the point attribute information of each point data record in the order from early to late of the expiration time. Therefore, the updating data volume of the integral list is large, the integral list is not suitable for synchronous updating, and asynchronous updating of the integral list can be achieved by means of the intermediate data list, so that the response speed of a user side is not influenced.

In addition, it should be noted that the intermediate data table is optional, and in other embodiments of the present invention, if the requirement on the service real-time performance is not high, the intermediate data table may also be omitted.

In addition, in this embodiment, for each integral update operation, a corresponding task record to be updated may be generated in the intermediate data table, so as to implement asynchronous update of the integral detail table and the integral main table. Or, the number of the integral numbers to be updated can be determined comprehensively according to the total operation integral numbers of the integral updating operation, the integral numbers contained in the single integral data record in the integral detail table and other factors, so that whether the corresponding task record to be updated is generated in the intermediate data table or not is determined according to the number of the integral numbers to be updated. For example, when the total operation credit amount of the credit update operation is greater than a first preset threshold value, and/or the credit amount contained in a single credit data record in the credit detail table is less than a second preset threshold value, a corresponding task record to be updated may be generated in the intermediate data table. Correspondingly, if the total amount of the operation credit of the credit updating operation is smaller, or the credit amount contained in a single credit data record in the credit list is larger, the following steps are performed: when the number of the integral strokes involved in one updating operation is small, the integral detail table is directly updated in a synchronous updating mode, and therefore storage overhead of the intermediate data table is saved.

During specific implementation, the task record to be updated stored in the intermediate data table can be read every other preset time length through a preset asynchronous thread, so that asynchronous updating of the integral detail table is achieved. The preset duration can be flexibly set according to the real-time requirement of the specific service. Correspondingly, after the task record to be updated, the asynchronous thread deletes the task record to be updated in the intermediate data table.

Therefore, in the embodiment, the score attribute information of each score is recorded separately through the score detail table, so that the expiration time of each score can be flexibly set. Accordingly, in this embodiment, when the point deduction process is performed, points which are about to expire quickly can be deducted preferentially, and when the point refund process is performed, points which expire later are refunded preferentially, so that the priority of each point data record to be processed can be determined according to the point refund time. Correspondingly, when at least one integral data record matched with the integral updating operation in the integral list is updated according to the query result, the method is realized by the following steps: and acquiring the integral expiration time contained in the integral attribute information of each integral data record stored in the integral detail table, and determining at least one integral data record matched with the integral updating operation according to the integral expiration time. When the point updating operation is a point increasing type updating operation, determining the point data record with late point expiration time as at least one point data record matched with the point updating operation; when the point updating operation is the point reduction type updating operation, the point data record with the early point expiration time is determined as at least one point data record matched with the point updating operation.

In order to facilitate multi-dimensional query, the point list in this embodiment further includes an account list and a flow list, so that a user can query from an account balance dimension and an operation flow dimension respectively.

The following is a detailed description of the details of updating the account statement and the flow statement:

when the integral acquisition operation is detected, respectively adding integral data records corresponding to the integral acquisition operation in the account list and the flow list; executing update processing for the point data record corresponding to the point update operation, which has been stored in the account list, whenever the point update operation is detected; then, an update data record corresponding to the current point update operation is added to the point list. And the updated data records added in the point list and the point data records subjected to updating processing in the account list have an incidence relation. Specifically, the update data record in the point list includes the record identifier of the point data record after the update processing in the account list, the update result, the point attribute information, and the like. Therefore, the updated data records in the point list are closely associated with the account list by referring to the point data records after the updating processing is executed in the account list.

For ease of understanding, the above data tables are described in detail below by taking a specific example as an example:

assume that the application provides a check-in entry that obtains points by check-in. Accordingly, the user triggers the point acquisition operation in step S200 once a day through the check-in entry, which is triggered 100 times in succession. In the process, an account balance record corresponding to the user is continuously stored in the account main table, and the numerical value of the account balance record is dynamically updated along with each integral acquisition operation so that the user can inquire the account balance in real time; and sequentially storing 100 operation flow records corresponding to each integral acquisition operation in the flow master table so as to allow a user to inquire operation flow information.

In addition, in the above process, 100 score data records corresponding to each score obtaining operation are sequentially stored in the account list, and each score data record is used for recording the total score (i.e. 10 scores) obtained this time, the score obtaining time, the score expiration time, the score source (sign in), and the like. Since the point acquisition time and the point expiration time of the points acquired each day are different, it is necessary to separately store each point by 100 point data records. Similarly, 100 integral data records corresponding to each integral acquisition operation are sequentially stored in the flow list. In the point acquisition process, the recording mode of the flow list and the account list is approximately the same.

Next, a point reduction class update operation is detected, and accordingly, points need to be deducted 21 from the user account. When deduction is executed, firstly, the current account balance of the user is inquired from the account main table, and the account balance is judged to be larger than 21, so that the current account balance is directly reduced by 21, and an updated account balance record is obtained. In addition, a running water record corresponding to the integral deduction operation at this time is added to the running water main table and used for showing the integral operation result of the integral deduction operation at this time. Because the operation of deducting 21 points belongs to one-time operation, only one operation flow record is needed to be added in the flow chart, and the operation flow record is used for recording operation attribute information associated with the operation, such as the type of the points is deduction, the number of the points is 21, and the like. And next, returning a notification message of successful deduction to the user so as to facilitate the user to quickly inquire the account balance and operate the flow record. And synchronously recording the task record to be updated corresponding to the deduction operation in the intermediate data table.

Correspondingly, the task record to be updated in the intermediate data table is read through the asynchronous thread, so that the asynchronous updating of the account detail table and the flow detail table is realized. The specific updating process is as follows:

in the account list, update processing is performed for the stored point data record corresponding to the point deduction type update operation. In the present example, specifically, since 100 point data records corresponding to each point obtaining operation are stored in the account list, and the point amount of each point data record is 10, three point data records with earlier expiration times are selected from the point data records for updating. The three points with earlier expiration times are recorded as follows:

the first data record: recording the ID of 101, the expiration time of the credit of 3 months and 1 day, and the credit amount of 10;

and a second data record: recording ID as 102, point expiration time as 3 months and 2 days, and point amount as 10;

and recording third data: record ID 103, credit expiration time 3 months and 3 days, and credit amount 10.

Correspondingly, the credit amount of the first data record is updated to 0 from 10, the credit amount of the second data record is updated to 0 from 10, and the credit amount of the third data record is updated to 9 from 10 in sequence from morning to evening of the expiration time. Therefore, when the point updating process is executed, the number of the point data records contained in the account list is not changed, and only the updating operation is executed for the corresponding point data records so as to record the attributes of the remaining point amount, the point flow direction, the point expiration time and the like contained in the updated point data records.

In addition, in order to clearly record the operation flow information of each point in the flow list, it is necessary to add an update data record corresponding to the current point deduction type update operation to the point list. For example, for the above operation, the following three update data records need to be added to the score list:

first update record: the associated account record ID is 101, the credit expiration time is 3 months and 1 day, and the credit amount is updated to 0 from 10;

and a second data record: the associated account record ID is 102, the credit expiration time is 3 months and 2 days, and the credit amount is updated from 10 to 0;

and recording third data: the associated account record ID is 103, the credit expiration time is 3 months and 3 days, and the credit amount is updated from 10 to 9.

Therefore, each updating data record in the flow list comprises the record ID of the point data record which executes the updating operation in the corresponding account list, so that the mutual association between the point list and the account list is realized. Therefore, the flow list can clearly record the detailed information such as the accurate flow direction of each integral by respectively making each updating data record refer to the corresponding integral data record in the account list, so that each integral change record can accurately trace the source, and the attribute such as the expiration time of the integral is determined according to the source of the integral.

And the expiration time in each updating data record in the flow list is used for determining the processing priority so as to quickly execute the point return operation according to the expiration time in the updating data record. For example, assume that after deducting 21 points, a deduction cancellation operation needs to be performed, and the number of points for deduction is 3. Correspondingly, 3 points need to be refunded to the user account, and the operation result corresponding to the refunded operation is directly recorded in the account main table and the production main table. In the flow list, the credit data records to be returned are determined according to the information such as the expiration time or the processing priority contained in the latest updated data records. Correspondingly, the point data record corresponding to the updated data record is determined from the account detail table based on the record ID of the account detail table quoted in the updated data record of the flow detail table, and the point is returned to which record according to the expiration time of each point data record. When the credit is returned, the credit with a later expiration time should be returned preferentially, so that the returning operation needs to be performed on the third data record with the record ID of 103 first, so that the credit amount of the third data record is recovered from 9 to 10; then, a rollback operation is performed for the second data record with record ID 102 to restore the credit amount of the second data record from 0 to 2. Correspondingly, two update data records which respectively refer to the third data record with the record ID of 103 and the second data record with the record ID of 102 in the account list are added in the flow list so as to record the specific updating process of each data record. Therefore, the point data records to be updated in the returning operation can be quickly positioned through the updated data records in the flow list and the record IDs of the account list contained in the flow list, and therefore point returning processing is achieved.

Therefore, when the point updating operation is executed, the total amount of the point data records in the account list is not changed, and only the updating processing needs to be executed for the corresponding point data records. However, the update data records need to be correspondingly added in the flow list, and the newly added update data records implement accurate tracing of the update data records by referring to the record IDs of the changed point data records in the account list, so as to facilitate implementing complicated processing types such as point return. In the above manner, each data record carries an attribute of credit expiration time, and accordingly, the processing priority of each data record can be determined according to the credit expiration time, so that it is ensured that the credit which is expired soon is preferentially deducted when the credit is deducted, and the credit which is expired later is preferentially deducted when the credit is refunded.

Step S240: and clearing the expired integral data records according to the integral expiration time contained in the integral attribute information of each integral data record stored in the integral detail table.

Specifically, the accumulated point clearing thread may periodically scan the accumulated point expiration time included in the accumulated point attribute information of each accumulated point data record stored in the accumulated point list, so as to clear the expired accumulated point data record. Because the detail list is stored by taking one integral as a unit, the expiration time can be set independently for each integral and the monitoring and processing are convenient, and the flexibility of the service function is improved. For example, points that expire in the schedule may be processed by a point expiration task. And when the point specification is over, the point balance corresponding to the account main table is reduced.

As can be seen, in this embodiment, the main integration table further includes: an account master table and a flow master table; the main account table is used for recording integral operation results corresponding to the current account balance, and the main pipelining table is used for recording integral operation results corresponding to the integral updating operation; and, the integral list further includes: account statement and chronological statement. Through the arrangement, information such as the source and the flow direction of each operation and each corresponding point can be clearly recorded. Wherein, each integral flow direction is definite, the expiration time is independent, and when the order is returned, the processing can be carried out according to the integral principle of always consuming first and quickly expiring. Similarly, the processing logics of the processes of integral pre-deduction, cancellation and the like are similar, and are not described again here.

It can be seen that in the present embodiment, the intermediate data table (TODO table) serves as a bridge, so that the point account can respond to the result quickly and record detailed information each time the add/subtract operation is performed. In addition, the main point table may further include: the pre-deduction main table corresponding to the integral pre-deduction type updating operation, and the integral list table may further include: and the prebuckling list is used for conveniently and accurately recording the prebuckling operation.

In summary, the above-mentioned manner in the present embodiment can at least realize the following functions:

(1) the point expiration function: each acquired point can record independent expiration time through a list, and after the current time exceeds the expiration time, the point is equivalent to expiration and cannot be used for service implementation. Accordingly, the partial credit can be identified in the system as being out of date.

(2) Integrating the water flow function: the historical record of the point change is displayed for the user and the service provider, which is equivalent to the concept of a bill. Each flow contains information such as the number of integration changes, integration before change, integration after change, and cause of change.

(3) Integral pre-deduction function: part of the score is frozen, meaning that it will be used for deduction and can no longer be operated on by other requests, similar to the concept of lock inventory. After freezing, the freezing can be canceled or the integral can be converted into the actual deduction integral.

(4) Integral main table: the system comprises a main table of the point account, a main table of the point flow and a main table of the point pre-deduction. The master table is used for summarizing and recording the integral number and other relevant information of one process operation.

(5) List of integrals: the system comprises an integral account list, an integral flow list and an integral pre-deduction list. The main function of the detail list is to record the flow trend of specific points, because each point has the attribute of independent expiration time, etc., and one operation may involve multiple points, therefore, each operation needs to record the flow direction of several points. Typically, the main table is used for presentation and the detail table is used for making the underlying record, and the detail table information is not typically required to be presented to the user.

(6) TODO table: the intermediate data table is used for asynchronous service of data operation between the main table and the detail table.

Therefore, the method can ensure that the user always consumes the quickly expired points first. Because the expiration time of each acquired point may be different, when the account points are deducted, the points which are about to expire are deducted preferentially, and if a back-off (point back-off) operation occurs, the sequence is still maintained, namely, the points which are expired after the back-off to the account are given first. In addition, the mode can support the function of customizing the expiration time of the points by setting the detail table corresponding to the main table. And the processing process of the detail table and the main table can be decoupled through the intermediate data table, so that the quick response can be realized through the main table, the asynchronous updating of the detail table can be realized through the intermediate data table, the definite recording of the flow direction of each integral is realized, and the user-defined attribute information of each integral is supported conveniently. In the above mode, the operations between the main table and the detail table are asynchronous, and the main table plays a role in displaying the service summary data. In addition, in order to support the service requirement of the custom time, the expiration time of each integral needs to be recorded independently, so the detail table is designed, but the synchronous operation of the main table and the detail table has a performance bottleneck, and the operation of the main table and the detail table is decoupled to a certain extent by adding an intermediate data table: the main table is operated to return a result, and then the detail table data is asynchronously updated, so that the overall process is efficiently completed.

EXAMPLE III

Fig. 3 shows an integration updating apparatus provided in the third embodiment of the present invention, including:

a determining module 31 adapted to determine, when a point updating operation is detected, a point operation result corresponding to the point updating operation according to an updating type of the point updating operation and a point amount;

a main table updating module 32, adapted to record the integration operation result in an integration main table;

the intermediate table updating module 33 is adapted to generate a task record to be updated corresponding to the integral updating operation in an intermediate data table;

the query module 34 is adapted to query the integral attribute information of each integral data record stored in the integral detail table according to the task record to be updated stored in the intermediate data table;

and the detail table updating module 35 is adapted to asynchronously update at least one integral data record in the integral detail table, which is matched with the integral updating operation, according to the query result.

Optionally, the intermediate table updating module is specifically adapted to:

the schedule update module is specifically adapted to:

Optionally, the apparatus further comprises:

Optionally, the detail table updating module is specifically adapted to:

Optionally, the apparatus further comprises:

The specific structure and the working principle of each module may refer to the description of the corresponding part of the method embodiment, and are not described herein again.

Example four

An embodiment of the present application provides a non-volatile computer storage medium, where the computer storage medium stores at least one executable instruction, and the computer executable instruction may execute the point updating method in any method embodiment described above. The executable instructions may be specifically configured to cause a processor to perform respective operations corresponding to the above-described method embodiments.

EXAMPLE five

Fig. 4 is a schematic structural diagram of an electronic device according to a fifth embodiment of the present invention, and the specific embodiment of the present invention does not limit the specific implementation of the electronic device.

As shown in fig. 4, the electronic device may include: a processor (processor)402, a Communications Interface 406, a memory 404, and a Communications bus 408.

Wherein:

the processor 402, communication interface 406, and memory 404 communicate with each other via a communication bus 408.

A communication interface 406 for communicating with network elements of other devices, such as clients or other servers.

The processor 402 is configured to execute the program 410, and may specifically perform the relevant steps in the above embodiment of the integration updating method.

In particular, program 410 may include program code comprising computer operating instructions.

The processor 402 may be a central processing unit CPU, or an application specific Integrated circuit asic, or one or more Integrated circuits configured to implement an embodiment of the present invention. The electronic device comprises one or more processors, which can be the same type of processor, such as one or more CPUs; or may be different types of processors such as one or more CPUs and one or more ASICs.

And a memory 404 for storing a program 410. The memory 404 may comprise high-speed RAM memory, and may also include non-volatile memory (non-volatile memory), such as at least one disk memory.

The program 510 may be specifically configured to enable the processor 502 to execute the corresponding operations in the above method embodiments.

The algorithms and displays presented herein are not inherently related to any particular computer, virtual machine, or other apparatus. Various general purpose devices may be used with the teachings herein. The required structure for constructing such a device will be apparent from the description above. Moreover, the present invention is not directed to any particular programming language. It is appreciated that a variety of programming languages may be used to implement the teachings of the present invention as described herein, and any descriptions of specific languages are provided above to disclose the best mode of the invention.

In the description provided herein, numerous specific details are set forth. It is understood, however, that embodiments of the invention may be practiced without these specific details. In some instances, well-known methods, structures and techniques have not been shown in detail in order not to obscure an understanding of this description.

Similarly, it should be appreciated that in the foregoing description of exemplary embodiments of the invention, various features of the invention are sometimes grouped together in a single embodiment, figure, or description thereof for the purpose of streamlining the disclosure and aiding in the understanding of one or more of the various inventive aspects. However, the disclosed method should not be interpreted as reflecting an intention that: that the invention as claimed requires more features than are expressly recited in each claim. Rather, as the following claims reflect, inventive aspects lie in less than all features of a single foregoing disclosed embodiment. Thus, the claims following the detailed description are hereby expressly incorporated into this detailed description, with each claim standing on its own as a separate embodiment of this invention.

Those skilled in the art will appreciate that the modules in the device in an embodiment may be adaptively changed and disposed in one or more devices different from the embodiment. The modules or units or components of the embodiments may be combined into one module or unit or component, and furthermore they may be divided into a plurality of sub-modules or sub-units or sub-components. All of the features disclosed in this specification (including any accompanying claims, abstract and drawings), and all of the processes or elements of any method or apparatus so disclosed, may be combined in any combination, except combinations where at least some of such features and/or processes or elements are mutually exclusive. Each feature disclosed in this specification (including any accompanying claims, abstract and drawings) may be replaced by alternative features serving the same, equivalent or similar purpose, unless expressly stated otherwise.

Furthermore, those skilled in the art will appreciate that while some embodiments described herein include some features included in other embodiments, rather than other features, combinations of features of different embodiments are meant to be within the scope of the invention and form different embodiments. For example, in the following claims, any of the claimed embodiments may be used in any combination.

The various component embodiments of the invention may be implemented in hardware, or in software modules running on one or more processors, or in a combination thereof. Those skilled in the art will appreciate that a microprocessor or Digital Signal Processor (DSP) may be used in practice to implement some or all of the functionality of some or all of the components in an apparatus according to an embodiment of the invention. The present invention may also be embodied as apparatus or device programs (e.g., computer programs and computer program products) for performing a portion or all of the methods described herein. Such programs implementing the present invention may be stored on computer-readable media or may be in the form of one or more signals. Such a signal may be downloaded from an internet website or provided on a carrier signal or in any other form.

It should be noted that the above-mentioned embodiments illustrate rather than limit the invention, and that those skilled in the art will be able to design alternative embodiments without departing from the scope of the appended claims. In the claims, any reference signs placed between parentheses shall not be construed as limiting the claim. The word "comprising" does not exclude the presence of elements or steps not listed in a claim. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The invention may be implemented by means of hardware comprising several distinct elements, and by means of a suitably programmed computer. In the unit claims enumerating several means, several of these means may be embodied by one and the same item of hardware. The usage of the words first, second and third, etcetera do not indicate any ordering. These words may be interpreted as names.

Claims

1. An integration updating method comprising:

2. The method of claim 1, wherein the generating a task record to be updated in an intermediate data table corresponding to the point update operation comprises:

3. The method of claim 2, wherein after recording the integration operation result in an integration main table, further comprising: sending an update success notification corresponding to the integral operation result;

4. The method of any of claims 1-3, wherein prior to performing the method, further comprising:

5. The method of any of claims 1-4, wherein the integral update operation comprises: an integral increase class update operation and an integral decrease class update operation;

6. The method according to claim 5, wherein the score attribute information of each score data record stored in a score detail table is inquired according to the task record to be updated stored in the intermediate data table; asynchronously updating at least one integral data record in the integral list matched with the integral updating operation according to the query result comprises:

7. The method of any of claims 1-6, wherein the master table of integrals further comprises: an account master table and a flow master table; the main account table is used for recording integral operation results corresponding to the current account balance, and the flow main table is used for recording integral operation results corresponding to the integral updating operation;

8. An integration updating device, comprising:

9. A computing device, comprising: the system comprises a processor, a memory, a communication interface and a communication bus, wherein the processor, the memory and the communication interface complete mutual communication through the communication bus;

the memory is used for storing at least one executable instruction, and the executable instruction causes the processor to execute the operation corresponding to the integral updating method according to any one of claims 1-7.

10. A computer storage medium having stored therein at least one executable instruction for causing a processor to perform operations corresponding to the point update method of any one of claims 1-7.