CN112541780A - Integral data recording system, recording method, storage medium and terminal - Google Patents
Integral data recording system, recording method, storage medium and terminal Download PDFInfo
- Publication number
- CN112541780A CN112541780A CN202011367369.8A CN202011367369A CN112541780A CN 112541780 A CN112541780 A CN 112541780A CN 202011367369 A CN202011367369 A CN 202011367369A CN 112541780 A CN112541780 A CN 112541780A
- Authority
- CN
- China
- Prior art keywords
- integral
- information
- consumption
- recording
- user
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 44
- 238000004891 communication Methods 0.000 claims abstract description 18
- 238000004590 computer program Methods 0.000 claims description 10
- 230000009286 beneficial effect Effects 0.000 description 9
- 238000007726 management method Methods 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000013523 data management Methods 0.000 description 2
- 230000010354 integration Effects 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000012163 sequencing technique Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0207—Discounts or incentives, e.g. coupons or rebates
- G06Q30/0226—Incentive systems for frequent usage, e.g. frequent flyer miles programs or point systems
- G06Q30/0227—Frequent usage incentive value reconciliation between diverse systems
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Strategic Management (AREA)
- Finance (AREA)
- Game Theory and Decision Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Marketing (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a point data recording system, a recording method, a storage medium and a terminal, wherein the system comprises: the integral recording module records the integral information of each time of the user in a storage mode of a database table and generates an integral recording table; the consumption recording module is used for recording the consumption information of the user; the integral updating module is in communication connection with the integral recording module and is used for updating integral information of the user; the judgment processing module is respectively in communication connection with the integral consumption recording module and the integral recording module and is used for outputting an updating control signal according to the consumption information and the integral information of the user; the system comprises a judgment processing module, an integral updating module and an integral recording module, wherein the judgment processing module is in communication connection with the integral updating module, and the integral updating module updates and modifies the integral information in the integral recording module according to an updating control signal.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a point data recording system, a point data recording method, a storage medium, and a terminal.
Background
In the point system, the increase and consumption of points increase the interest of the product and the activity of the user. Currently, most of the operations are to remove credits from the last year within a specific date of the year, for example, 12 months and 31 days at the end of the year, and this is a very delicate way for users and is not friendly.
If the system is started normally, under the condition of large user quantity, a large amount of data to be processed is continuously updated and deleted, so that the probability of concurrence and error is increased, and the burden of a database server is increased; when the points are consumed, because the point consumption of each time is the longest record, the strategy of repeatedly searching and traversing and then replacing the points makes the counting work of the points become complicated; if the deduction of the integral fails, the operation end recovers the existing integral and is difficult to realize.
Therefore, it is necessary to provide a novel point data recording system, a recording method, a storage medium, and a terminal to solve the above-mentioned problems in the prior art.
Disclosure of Invention
The invention aims to provide an integral data recording system, a recording method, a storage medium and a terminal, which can realize quick storage and update of the integral and effectively reduce the workload of integral processing.
To achieve the above object, the integration data recording system of the present invention includes:
the integral recording module records the integral information of each time of the user in a storage mode of a database table and generates an integral recording table;
the consumption recording module is used for recording the consumption information of the user;
the point updating module is in communication connection with the point recording module and used for updating point information of the user;
the judgment processing module is respectively in communication connection with the integral consumption recording module and the integral recording module and is used for outputting an updating control signal according to the consumption information and the integral information of the user;
the judgment processing module is in communication connection with the integral updating module, and the integral updating module updates and modifies the integral information in the integral recording module according to the updating control signal.
The invention has the beneficial effects that: the integral recording module is used for recording each time of integral information of a user and generating an integral recording table, when the user consumes the integral, the judging and processing module generates a control signal according to the consumption information and the integral recording table, so that the integral recording table recorded in the integral recording module is updated and modified through the integral updating module, management is facilitated, data query is facilitated, the integral information is stored in a storage mode of a database table, the workload of data processing is reduced, and the management efficiency of the integral is improved.
Further, the point recording module includes an ID unit, an expiration time unit, a total point unit, a point state unit, and an available point unit, where the ID unit is configured to record name information of the user, the expiration time unit is configured to record point expiration time information of the user, the total point unit is configured to record a total point currently owned by the user, the point state unit is configured to record state information of the point information, and the available point unit is configured to record an available point of the user. The beneficial effects are that: the ID unit, the expiration time unit, the total point unit, the point state unit and the available point unit are used for respectively recording name information, point expiration time information, total points, state information and available points of a user, so that the point information of each point recording table is accurate and convenient to search.
Furthermore, the score recording module further includes at least one of a recording sequence number unit, a score source recording unit and a score update time recording unit, where the recording sequence number unit is configured to record sequence number information of each piece of score information of the user, the score source recording unit is configured to record source information of each piece of score information of the user, and the score update time recording unit is configured to record update time information of each piece of score information of the user. The beneficial effects are that: the recording sequence number unit is convenient for sequencing the integral data, and the integral source recording unit and the integral updating time recording unit are beneficial to improving the accuracy of integral information recording.
Furthermore, the judgment processing module comprises an integral information calling unit and a control unit, the integral information calling unit is in communication connection with the integral recording module to call the integral information, the control unit is in communication connection with the integral information calling unit and the consumption recording module respectively, and the control unit generates a control signal according to the integral information and the consumption information and transmits the control signal to the integral updating module so as to update and modify the integral information in the integral recording module through the integral updating module.
Furthermore, the consumption recording module comprises a consumption user unit, a consumption point unit and a consumption time unit, wherein the consumption user unit is used for recording consumption user information of the consumption points, the consumption point unit is used for recording the consumption points, and the consumption time unit is used for recording consumption time information when the consumption points are consumed. The beneficial effects are that: when the user consumes the points, the accuracy of recording the user consumption points can be effectively improved through consuming the user information, the consumption points and the consumption time information.
Furthermore, the integral recording module records and stores the integral information in a database table mode. The beneficial effects are that:
the invention also discloses an integral data recording method, which comprises the following steps:
s1, recording the point information of the user through the point recording module, and recording the consumption information through the consumption recording module;
and S2, the judgment processing module generates a control signal according to the integral information and the consumption information and transmits the control signal to the integral updating module, and the integral updating module updates and modifies the integral information in the integral recording module according to the control signal.
The method has the beneficial effects that: when the user consumes the points, the point information and the consumption information of the user are compared through the judgment processing module, and then the point information in the point recording module is updated and modified through the point updating module.
Further, the point information includes name information of the user, point expiration time information, total points, status information, and available points.
Further, the point information further includes at least one of sequence number information, source information, and update time information.
Further, the consumption information includes consumption user information, consumption time information, and consumption points.
Further, the process of step S2 includes:
s21, the control unit acquires the consumption user information, calls the integral information and judges whether the consumption user information is consistent with the user information in the integral information;
s22, when the information of the consuming user is judged to be consistent with the information of the user, the control unit judges the numerical values of the consuming integral and the available integral, and when the consuming integral is larger than the available integral, the control unit outputs a control signal to the integral updating module to prompt the user that the consuming fails;
when the consumption integral is smaller than or equal to the available integral, the control unit outputs a control signal to the integral updating module, and the integral updating module performs differential updating in the integral recording module to increase a consumption record. The beneficial effects are that: the process modifies the point record of the user according to the numerical value of the consumption point, processes the points in the point record table through the difference updating process, updates a large amount of data, reduces the burden of a database server and improves the data processing efficiency.
Further, the differential updating process in step S23 includes the following steps:
a1, the control unit searches each integral information in the integral record table and finds the first integral record when the available integral is larger than or equal to the consumption integral for the first time in the integral record table;
a2, if the available points in the first point record are equal to the consumption points, modifying the available points in the first point record and all the previous point records to be 0, and adding a consumption record in the point record module;
and if the available integral in the initial integral record is larger than the consumption integral, modifying the available integral in all integral records before the initial integral record to be 0, and simultaneously modifying the available integral in the initial integral record to be differential integral, wherein the differential integral is the difference value obtained by subtracting the consumption integral from the sum of the available integral in the initial consumption record and all integral records before the initial consumption record, and a consumption record is added into the integral record module. The beneficial effects are that: the integral is updated and modified through the integral updating mode, and the efficiency of the data processing process is effectively improved.
The present invention provides a storage medium having stored thereon a computer program which, when executed by a processor, implements the recording method described above.
The invention further provides a terminal, which comprises a processor and a memory;
the memory is used for storing a computer program;
the processor is configured to execute the computer program stored in the memory to enable the terminal to implement the recording method described above.
Drawings
Fig. 1 is a block diagram of a recording system according to an embodiment of the present invention;
FIG. 2 is a flow chart of a recording method according to an embodiment of the present invention;
FIG. 3 is a flowchart illustrating step S2 of the recording method according to the embodiment of the invention;
fig. 4 is a flowchart illustrating step S23 of the recording method according to the embodiment of the invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings of the present invention, and it is obvious that the described embodiments are some, but not all embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention. Unless defined otherwise, technical or scientific terms used herein shall have the ordinary meaning as understood by one of ordinary skill in the art to which this invention belongs. As used herein, the word "comprising" and similar words are intended to mean that the element or item listed before the word covers the element or item listed after the word and its equivalents, but does not exclude other elements or items.
To solve the problems in the prior art, an embodiment of the present invention provides an integration data recording system, as shown in fig. 1, including:
the integral recording module 1 records the integral information of each time of the user in a storage mode of a database table and generates an integral recording table;
the consumption recording module 2 is used for recording the consumption information of the user;
the point updating module 3 is in communication connection with the point recording module 1 and is used for updating the point information of the user;
the judgment processing module 4 is in communication connection with the integral consumption recording module 2 and the integral recording module 1 respectively, and is used for outputting an updating control signal according to the consumption information and the integral information of the user;
the judgment processing module 4 is in communication connection with the integral updating module 3, and the integral updating module 3 updates and modifies the integral information in the integral recording module 1 according to the update control signal.
In the system, after a user acquires the integral, the integral recording module 1 records the integral information of the user through the integral recording table, and when the user consumes the integral, the consumption recording module 2 records the consumption information, and then the judgment processing module 4 outputs a control signal to the integral updating module 3 according to the recorded integral information of the user and the consumption information of the user in the integral recording table, and updates and modifies the integral information of the user in the integral recording module 1 through the integral updating module 3, thereby realizing the rapid processing of the integral data.
In the processing process, the point recording module 1 stores the point information of each time of the user in a storage mode of a database table and generates the point recording table, when the subsequent point information is updated and modified, only corresponding data in the point recording table needs to be directly modified, a large amount of data can be updated simultaneously, the burden of a database server is reduced, meanwhile, a more convenient management mode is provided for point data management, and compared with a point data management mode in the prior art, the point recording module is more flexible to use.
In some embodiments, the point recording module 1 includes an ID unit 11, an expiration time unit 12, a total point unit 13, a point status unit 14, and an available point unit 15, where the ID unit 11 is configured to record name information of the user, the expiration time unit 12 is configured to record point expiration time information of the user, the total point unit 13 is configured to record total points currently owned by the user, the point status unit 14 is configured to record status information of the point information, and the available point unit 15 is configured to record available points of the user.
When the point recording module 1 records the point information of each time of the user, the name information of the user is recorded through the ID unit 11, the expiration time information of each time of the point of the user is recorded through the expiration time unit 12, the total point unit 13 records the total point in the point information of each time of the user, the available point in the total point is recorded through the available point unit 15, and the point state unit 14 records the state of the point of the user, including available state and unavailable state, for further distinction, the available state of the point is represented as 0, and the unavailable state is represented as 1, so as to complete the recording process of the user state.
| User id | Available integral | Residual integral | Current state | Expiration time | Update time |
| 1111 | 4000 | 4000 | 0 | 11 month and 30 |
11 months and 13 days |
| 1111 | 2000 | 2000 | 0 | 12 month and 30 |
11 months and 13 days |
It should be noted that, in the above recording system, since the name information of the user, the expiration time of the point information, and the available point are always recorded when the point information and the consumption information of the user are recorded, when querying the point information in the stored point recording table, only the name information and the expiration time information of the user are needed to be used as key values, the available point information of the user in the point recording table can be rapidly queried, and the querying efficiency of the data is effectively improved.
In some embodiments, the score recording module 1 further includes at least one of a recording sequence number unit 16, a score source recording unit 17, and a score update time recording unit 18, where the recording sequence number unit 16 is configured to record sequence number information of each piece of score information of the user, the score source recording unit 17 is configured to record source information of each piece of score information of the user, and the score update time recording unit 18 is configured to record update time information of each piece of score information of the user.
The recording sequence number unit 16 marks a sequence number for each score record in the score record table to facilitate searching, the score source recording unit 17 records source information of each score generated by a user, and the score update time recording unit is used for recording the generation time of the score to facilitate searching by corresponding the generation time and the expiration time of the score.
In some embodiments, the judgment processing module 4 includes a score information calling unit 41 and a control unit 42, the score information calling unit 41 is in communication connection with the score recording module 1 to call the score recording table, the control unit 42 is in communication connection with the score information calling unit 41 and the consumption recording module 2, respectively, and the control unit 42 generates a control signal to the score updating module 3 according to the score recording table and the consumption information, so as to update and modify the score information in the score recording module 1 through the score updating module 3.
When a user generates consumption, the consumption recording module 2 records consumption information of the user, the control unit 42 in the judgment processing module 4 calls point information in a point recording table recorded in the point recording unit 1 through the point information calling unit 41, the control unit 42 obtains the consumption information in the consumption recording module 2, the control module 42 compares the consumption information with the point information according to the point information, so as to compare the consumption information with the point information, and process the point consumption information of the user conveniently, in the processing process, when the point consumed by the user is not larger than available point owned by the user, the control unit 42 outputs a control signal to the point updating module 3 to indicate that the current consumption can be carried out, the point updating module 3 updates and modifies the point information of the user according to the control information, so as to complete the processing process of the point data of the user, the operation is convenient.
In the process that the control unit 42 processes according to the consumption information and the integral information to output the control signal, when the integral consumed by the user is greater than the available integral of the user, the control unit 42 directly outputs the control signal to indicate that the current consumption integral of the user is too much and the consumption is failed; when the point consumed by the user is the same as the available point of the user, the control unit 42 outputs a control signal to the point updating module 3, the point updating module 3 controls the point recording module 1 to modify the point information of the user, the available point number of the user is modified to 0, and the point state is modified to be unavailable at the same time, so that the modification processing process of the point can be completed; when the point consumed by the user is smaller than the available point of the user, the control unit 42 searches the point information in the point record table of the user, finds each piece of point information of the record, and finds the position of the point information when the sum of the available points of the user is greater than or equal to the consumption point for the first time, the position of the point information is marked as N, if the sum of the available points of the N position and the previous point information is just equal to the consumption point, the state of the available points of the N position and the previous point information is modified to 1, which indicates that the position N and the previous point have been consumed, and when the sum of the available points of the N position and the previous point information is greater than the consumption point, the state of the available points of the N position and the previous point information is modified to 1, and the consumption point is subtracted by the sum of the available points of the N position and the previous point information to obtain the remaining consumption point, meanwhile, the difference integral can be obtained by subtracting the residual consumption integral from the available integral at the N position, so that the processing process during the consumption of the user integral can be completed, only the specific integral record needs to be modified and updated, the data in the whole data record table does not need to be calculated and modified, the calculation workload of the database is greatly reduced, and the data processing efficiency is improved.
Furthermore, after the point processing is completed, for the points consumed by the user, a consumption record is added in the point record table through the point record module 1, so as to facilitate the later query and tracing.
In some embodiments, the consumption recording module 2 includes a consumption user unit 21, a consumption point unit 22, and a consumption time unit 23, where the consumption user unit 21 is configured to record consumption user information of consumption points, the consumption point unit 22 is configured to record consumption points, and the consumption time unit 23 is configured to record consumption time information of consumption points, record consumption user information of consumption records through the consumption user unit 21, and facilitate comparison with point information of a user by combining consumption point data recorded by the consumption point unit 22 and consumption time information recorded by the consumption time unit 23.
The invention further provides an integral data recording method, as shown in fig. 2, comprising the following steps:
s1, recording the point information of the user through the point recording module, and recording the consumption information through the consumption recording module;
and S2, the judgment processing module generates a control signal according to the integral information and the consumption information and transmits the control signal to the integral updating module, and the integral updating module updates and modifies the integral information in the integral recording module according to the control signal.
The point data of the user is recorded and counted through the method, when the user consumes the points, the point information of the user is compared with the consumption points through the judgment processing module 4, so that the point updating module 3 is controlled to update and modify the point recording module 1, the consumed point information is obtained, and the point is quickly processed.
In some embodiments, the point information recorded in the point record table includes name information of a user, point expiration time information, total points, status information, and available points; the point information further includes at least one of sequence number information, source information, and update time information.
In still other embodiments, the consumption information includes consumption user information, consumption time information, and consumption credits.
In some embodiments, as shown in fig. 3, the process of step S2 includes:
s21, the control unit acquires the consumption user information, calls the integral information and judges whether the consumption user information is consistent with the user information in the integral information;
s22, when the information of the consuming user is judged to be consistent with the information of the user, the control unit judges the numerical values of the consuming integral and the available integral, and when the consuming integral is larger than the available integral, the control unit outputs a control signal to the integral updating module to prompt the user that the consuming fails;
when the consumption integral is smaller than or equal to the available integral, the control unit outputs a control signal to the integral updating module, and differential updating is carried out in the integral recording module through the integral updating module and a consumption record is added.
In some embodiments, as shown in fig. 4, the differential updating process in step S23 includes the following steps:
a1, the control unit searches each integral information in the integral record table and finds the first integral record when the available integral is larger than or equal to the consumption integral for the first time in the integral record table;
a2, if the available points in the first point record are equal to the consumption points, modifying the available points in the first point record and all the previous point records to be 0, and adding a consumption record in the point record module;
and if the available integral in the initial integral record is larger than the consumption integral, modifying the available integral in all integral records before the initial integral record to be 0, and simultaneously modifying the available integral in the initial integral record to be differential integral, wherein the differential integral is the difference value obtained by subtracting the consumption integral from the sum of the available integral in the initial consumption record and all integral records before the initial consumption record, and a consumption record is added into the integral record module.
Specifically, when the point consumed by the user is 6000, point information in a user point record table is searched, point information with the name information of the user in the point record table being the same as the consumption user information of the consumption points is found, available points of the user are summed, a position where the sum of the available points for the first time is greater than or equal to 6000 is selected, the position is a primary point record, the position is N, when the sum of the available points for the first time is equal to 6000, the number of the available points of the point information of the N position and the previous position is modified to 0, and the point state is modified to 1 to indicate that the available points are unavailable; and when the first available integral is larger than 6000, counting the sum of integral records before the N position and recording the sum as X, simultaneously modifying the available integral number in the integral records before the N position to be 0, simultaneously subtracting X from 6000 to obtain the residual consumption integral, and subtracting the residual consumption integral from the available integral in the integral information at the N position to obtain a difference integral, namely Y, modifying the available integral number in the integral information at the N position to be a value Y for the difference integral, and finishing the integral processing process.
Further, in some embodiments, when the user's tally record table is as shown in the following table,
| user id | Available integral | Residual integral | Current state | Expiration time | Update time |
| 1111 | 4000 | 4000 | 0 | 11 month and 30 |
11 months and 13 days |
| 1111 | 2000 | 2000 | 0 | 12 month and 30 |
11 months and 13 days |
At this time, the total available points of the user are 6000, if the user consumes 6000 points, the available points of the user are modified to be 0, meanwhile, the point state is modified to be 1, and the corresponding updating time is recorded, and the modified point recording table is as follows:
| user id | Available integral | Residual integral | Current state | Expiration time | Update time |
| 1111 | 4000 | 0 | 1 | 11 month and 30 |
11 months and 13 days |
| 1111 | 2000 | 0 | 1 | 12 month and 30 |
11 months and 13 days |
And when the point consumed by the user is 5000, the point information in the point record table is modified, and the modified point information is shown in the following table:
| record id | User id | Available integral | Residual integral | Current state | Expiration | Update time | |
| 21 | 1111 | 4000 | 0 | 1 | 11 month and 30 |
11 months and 13 days | |
| 22 | 1111 | 2000 | 1000 | 0 | 12 month and 30 |
11 months and 13 days |
It should be noted that when the point information of the user is queried, the available point information of the user can be quickly found only through the expiration time information and the name information, so that the searching workload is effectively reduced, and the data processing efficiency is improved.
The present invention also provides a storage medium having stored thereon a computer program which, when executed by a processor, implements the recording method described above.
The invention also provides a terminal, which comprises a processor and a memory;
the memory is used for storing a computer program;
the processor is configured to execute the computer program stored in the memory to enable the terminal to implement the recording method described above.
Preferably, the memory comprises: various media that can store program codes, such as ROM, RAM, magnetic disk, U-disk, memory card, or optical disk.
Preferably, the Processor may be a general-purpose Processor, including a Central Processing Unit (CPU), a Network Processor (NP), and the like; the Integrated Circuit may also be a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic device, discrete gate or transistor logic device, discrete hardware component.
Although the embodiments of the present invention have been described in detail hereinabove, it is apparent to those skilled in the art that various modifications and variations can be made to these embodiments. However, it is to be understood that such modifications and variations are within the scope and spirit of the present invention as set forth in the following claims. Moreover, the invention as described herein is capable of other embodiments and of being practiced or of being carried out in various ways.
Claims (13)
1. A point data recording system, comprising:
the integral recording module records the integral information of each time of the user in a storage mode of a database table and generates an integral recording table;
the consumption recording module is used for recording the consumption information of the user;
the point updating module is in communication connection with the point recording module and used for updating point information of the user;
the judgment processing module is respectively in communication connection with the integral consumption recording module and the integral recording module and is used for outputting an updating control signal according to the consumption information and the integral information of the user;
the judgment processing module is in communication connection with the integral updating module, and the integral updating module updates and modifies the integral information in the integral recording module according to the updating control signal.
2. The point data recording system according to claim 1, wherein the point recording module includes an ID unit for recording name information of the user, an expiration time unit for recording point expiration time information of the user, a total point unit for recording total points currently owned by the user, a point status unit for recording status information of the point information, and an available point unit for recording available points of the user.
3. The system according to claim 2, wherein the score recording module further includes at least one of a recording sequence number unit, a score source recording unit, and a score update time recording unit, the recording sequence number unit is configured to record sequence number information of each piece of score information of the user, the score source recording unit is configured to record source information of each piece of score information of the user, and the score update time recording unit is configured to record update time information of each piece of score information of the user.
4. The system according to claim 1, wherein the judgment processing module includes a score information calling unit and a control unit, the score information calling unit is in communication connection with the score recording module to call the score recording table, the control unit is in communication connection with the score information calling unit and the consumption recording module, respectively, and the control unit generates a control signal according to the score recording table and the consumption information and transmits the control signal to the score updating module to update and modify the score information in the score recording module through the score updating module.
5. The point data recording system according to claim 4, wherein the consumption recording module comprises a consumption user unit, a consumption point unit and a consumption time unit, the consumption user unit is used for recording consumption user information of consumption points, the consumption point unit is used for recording consumption points, and the consumption time unit is used for recording consumption time information when consumption points are consumed.
6. A point data recording method applied to the point data recording system according to any one of claims 1 to 5, characterized by comprising the steps of:
s1, recording the point information of the user through the point recording module, and recording the consumption information through the consumption recording module;
and S2, the judgment processing module generates a control signal according to the integral information and the consumption information and transmits the control signal to the integral updating module, and the integral updating module updates and modifies the integral information in the integral recording module according to the control signal.
7. The tally data recording method according to claim 6, wherein the tally information recorded in the tally record table includes user's name information, tally expiration time information, total tally, status information, and available tally.
8. The tally data recording method according to claim 6, wherein said tally information further includes at least one of sequence number information, source information, and update time information.
9. The point data recording method according to claim 6, wherein the consumption information includes consumption user information, consumption time information, and consumption points.
10. The integrated data recording method according to claim 6, wherein said step S2 includes:
s21, the control unit acquires the consumption user information, calls the integral information and judges whether the consumption user information is consistent with the user information in the integral information;
s22, when the information of the consuming user is judged to be consistent with the information of the user, the control unit judges the numerical values of the consuming integral and the available integral, and when the consuming integral is larger than the available integral, the control unit outputs a control signal to the integral updating module to prompt the user that the consuming fails;
when the consumption integral is smaller than or equal to the available integral, the control unit outputs a control signal to the integral updating module, and differential updating is carried out in the integral recording module through the integral updating module and a consumption record is added.
11. The integrated data recording method according to claim 10, wherein the process of differentially updating in step S22 includes the steps of:
a1, the control unit searches each integral information in the integral record table and finds the first integral record when the available integral is larger than or equal to the consumption integral for the first time in the integral record table;
a2, if the available points in the first point record are equal to the consumption points, modifying the available points in the first point record and all the previous point records to be 0, and adding a consumption record in the point record module;
and if the available integral in the initial integral record is larger than the consumption integral, modifying the available integral in all integral records before the initial integral record to be 0, and simultaneously modifying the available integral in the initial integral record to be differential integral, wherein the differential integral is the difference value obtained by subtracting the consumption integral from the sum of the available integral in the initial consumption record and all integral records before the initial consumption record, and a consumption record is added into the integral record module.
12. A storage medium on which a computer program is stored, characterized in that the computer program, when executed by a processor, implements a recording method according to any one of claims 6 to 11.
13. A terminal comprising a processor and a memory;
the memory is used for storing a computer program;
the processor is configured to execute the computer program stored in the memory to cause the terminal to implement the recording method according to any one of claims 6 to 11.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011367369.8A CN112541780A (en) | 2020-11-27 | 2020-11-27 | Integral data recording system, recording method, storage medium and terminal |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011367369.8A CN112541780A (en) | 2020-11-27 | 2020-11-27 | Integral data recording system, recording method, storage medium and terminal |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112541780A true CN112541780A (en) | 2021-03-23 |
Family
ID=75016393
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011367369.8A Pending CN112541780A (en) | 2020-11-27 | 2020-11-27 | Integral data recording system, recording method, storage medium and terminal |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112541780A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113807899A (en) * | 2021-10-14 | 2021-12-17 | 东北林业大学 | Carbon emission conversion cloud carbon credit point query ranking system |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2006185368A (en) * | 2004-12-28 | 2006-07-13 | Matsushita Electric Ind Co Ltd | Document database update processor, document database retrieval device, document database index preparation method, and document database retrieval method |
| CN101661491A (en) * | 2008-08-31 | 2010-03-03 | 阿里巴巴集团控股有限公司 | Updating method of wide table inside data warehouse |
| CN101676689A (en) * | 2008-08-21 | 2010-03-24 | 爱信艾达株式会社 | Driving evaluation system and driving evaluation method |
| CN102376160A (en) * | 2010-08-09 | 2012-03-14 | ***通信集团辽宁有限公司 | Method and system for updating real-time traffic information |
| CN103544153A (en) * | 2012-07-10 | 2014-01-29 | 阿里巴巴集团控股有限公司 | Data updating method and system based on database |
| CN105469275A (en) * | 2015-11-12 | 2016-04-06 | 广州优识资讯***有限公司 | Credit data processing method and system based on plurality of merchants |
| CN111639965A (en) * | 2020-05-15 | 2020-09-08 | 浙江口碑网络技术有限公司 | Integral updating method and device |
-
2020
- 2020-11-27 CN CN202011367369.8A patent/CN112541780A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2006185368A (en) * | 2004-12-28 | 2006-07-13 | Matsushita Electric Ind Co Ltd | Document database update processor, document database retrieval device, document database index preparation method, and document database retrieval method |
| CN101676689A (en) * | 2008-08-21 | 2010-03-24 | 爱信艾达株式会社 | Driving evaluation system and driving evaluation method |
| CN101661491A (en) * | 2008-08-31 | 2010-03-03 | 阿里巴巴集团控股有限公司 | Updating method of wide table inside data warehouse |
| CN102376160A (en) * | 2010-08-09 | 2012-03-14 | ***通信集团辽宁有限公司 | Method and system for updating real-time traffic information |
| CN103544153A (en) * | 2012-07-10 | 2014-01-29 | 阿里巴巴集团控股有限公司 | Data updating method and system based on database |
| CN105469275A (en) * | 2015-11-12 | 2016-04-06 | 广州优识资讯***有限公司 | Credit data processing method and system based on plurality of merchants |
| CN111639965A (en) * | 2020-05-15 | 2020-09-08 | 浙江口碑网络技术有限公司 | Integral updating method and device |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113807899A (en) * | 2021-10-14 | 2021-12-17 | 东北林业大学 | Carbon emission conversion cloud carbon credit point query ranking system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7181460B2 (en) | User-defined aggregate functions in database systems without native support | |
| US10216769B1 (en) | Asset catalog management methods and systems | |
| CN107577787B (en) | Method and system for storing associated data information | |
| CN108875077B (en) | Column storage method and device of database, server and storage medium | |
| CN108648092B (en) | Insurance odds ratio calculating method, apparatus, device and computer readable storage medium | |
| CN108415990B (en) | Data quality monitoring method and device, computer equipment and storage medium | |
| WO2020106635A1 (en) | Presenting updated data using persisting views | |
| CN112541780A (en) | Integral data recording system, recording method, storage medium and terminal | |
| CN109344169B (en) | Data processing method and device | |
| CN111984662B (en) | Method and device for updating databases in batches | |
| CN116010345A (en) | Method, device and equipment for realizing table service scheme of flow batch integrated data lake | |
| CN115328917A (en) | Query method, device, equipment and storage medium | |
| US11455286B2 (en) | History of slowly changing dimensions | |
| CN111986006A (en) | Product recommendation method and device based on knowledge graph, computer equipment and storage medium | |
| CN111444185A (en) | Block information updating method and device, computer equipment and storage medium | |
| CN111125229B (en) | Data blood edge generation method and device and electronic equipment | |
| CN112711627B (en) | Data importing method, device and equipment of Greemplum database | |
| CN114490095B (en) | Request result determination method and device, storage medium and electronic device | |
| CN109325031B (en) | Data statistical method, device, equipment and storage medium | |
| US20050198064A1 (en) | Method and apparatus for validating propagation of XML constraints to relations | |
| CN113505115A (en) | Data batch import method and device and electronic equipment | |
| CN114237977A (en) | Transaction rollback method, device, computer equipment and storage medium | |
| CN116975774A (en) | Mechanism name fusion method, terminal equipment and computer readable storage medium | |
| CN118132575A (en) | Data processing method and device, electronic equipment and readable storage medium | |
| CN117971279A (en) | Rollback method and device of system version and server |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210323 |
|
| RJ01 | Rejection of invention patent application after publication |