Stream water balance data registration method and device, storage medium and terminal

By matching the transaction record table and account balance table of live broadcast accounts with the same source and sequence, the problem of lack of association identification between the transaction record table and the balance record table is solved, and efficient and accurate account query and balance calculation are achieved.

CN115203201BActive Publication Date: 2025-10-17杭州米络星科技(集团)有限公司
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202210774681.1
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2022-07-01
Publication Date
2025-10-17
Estimated Expiration
2042-07-01

AI Technical Summary

Technical Problem

Since the transaction record table and balance record table of live broadcast accounts lack unified association identifiers, account query and balance calculation are difficult.

Method used

By obtaining the transaction record table and account balance table of the target account, using the change data capture synchronization technology to update in real time, and in the record table with the same source and sequence, using fixed time periods as nodes for alignment, determining the marker nodes and the number of interval records, and finding the corresponding account balance records, a transaction balance alignment table is formed.

Benefits of technology

It achieves efficient and accurate account query and balance calculation, reduces data processing volume, improves the accuracy of registration, and is suitable for journal record tables and account balance tables that do not have unified association identifiers.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN115203201B_ABST
    Figure CN115203201B_ABST
Patent Text Reader

Abstract

The application discloses a kind of water surplus data registration method and device, storage medium and terminal, wherein method includes: determining registration water record;Determine target mark node, so that the water record table in target mark node corresponding water record and the account surplus record in target mark node corresponding account surplus table in account are corresponding record relationship;Determine the interval record number between registration water record and mark water record, find the account surplus record corresponding to registration water record in account surplus table based on mark account surplus record and interval record number, and the account surplus record found is registration account surplus record of target time point;The application has less data processing amount, registration accuracy is high, more convenient for the account query and account balance calculation of water record table and account surplus table without unified association identifier.
Need to check novelty before this filing date? Find Prior Art

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of data processing, in particular to a water balance registration method and device, a storage medium and a terminal. BACKGROUND

[0002] Network live broadcast is a new network social way, and the network live broadcast platform has become a new social media. In the live broadcast process, the audience can send live gifts to the host, and the host can also have other live expenses. In various business scenarios, data records are usually recorded in different ways. For example, in the user's reward event, the live broadcast platform needs to record the user's water record, the user's balance record, and the user's income record. Therefore, once the account has a deposit or expenditure operation, the corresponding user's account water record will be recorded. Corresponding to the water record, there is also a balance record, but the balance record often lags behind the corresponding water record due to bank operations and other problems.

[0003] In order to confirm the balance of the user's account, it is usually necessary to check whether the difference between the account balance records of two time points and the water record of this period of time are matched, but due to the huge amount of user data, the account balance data usually requires a certain execution time, and during this period of time, some users still generate water data, which will cause the account to be unbalanced.

[0004] Usually, the bank operation will mark the same identifier in the corresponding water record and balance record, so as to easily identify the corresponding water record and balance record, but now some live broadcast accounts and the like have no unified identifier to associate the generated water record table and balance record table due to setting defects or demand iteration and the like, and the system is not convenient to modify, so that the water record table and the balance record table of this type are not convenient for account inquiry. SUMMARY

[0005] The technical problem to be solved by the present application is that some existing accounts have no unified association identifier between the generated water record form and the account balance form due to setting defects or demand iteration and the like, so that the water record table and the balance record table of this type are not convenient for account inquiry.

[0006] In order to solve the above technical problem, the present application provides a water balance data registration method, comprising:

[0007] obtaining a water record table and an account balance table of a target account;

[0008] registering the water records of a plurality of time points in the water record table with a plurality of account balance records in the account balance table respectively to obtain a water balance registration table of the target account.

[0009] Preferably, the matching of the flow record of the target time point in the flow record table with the account balance record in the account balance table comprises:

[0010] matching the last flow record of the target time point and the time period before the target time point in the flow record table as the matching flow record of the target time point;

[0011] determining a target landmark node, so that the flow record corresponding to the target landmark node in the flow record table and the account balance record corresponding to the target landmark node in the account balance table are in a corresponding record relationship, taking the flow record corresponding to the target landmark node in the flow record table as a landmark flow record, and taking the account balance record corresponding to the target landmark node in the account balance table as a landmark account balance record;

[0012] determining the number of interval records between the matching flow record and the landmark flow record, finding the account balance record corresponding to the matching flow record in the account balance table based on the landmark account balance record and the number of interval records, and taking the found account balance record as the matching account balance record of the target time point;

[0013] wherein the target time point is any one of a plurality of time points, and the matching flow record and the matching account balance record are in a corresponding record relationship.

[0014] Preferably, the flow records in the flow record table and the account balance records in the account balance table are sorted in the same sorting manner.

[0015] Preferably, the step of obtaining the flow record table and the account balance table of the target account comprises:

[0016] obtaining the flow record table and the account balance table of the target account, and performing real-time updating on the flow record table and the account balance table.

[0017] Preferably, the flow records are received in real time through a change data capture synchronization technology, and the received flow records are recorded in the flow record table to realize real-time updating of the flow record table;

[0018] and the account balance records are received in real time through a change data capture synchronization technology, and the received account balance records are recorded in the account balance table to realize real-time updating of the account balance table.

[0019] Preferably, the target landmark node is determined in the following manner:

[0020] determining a target time period, so that the target time point is located within the target time period;

[0021] calculating the flow time difference between all adjacent flow records in the flow record table within the target time period, and selecting the maximum flow time difference as a flow sign node, and taking the two adjacent flow records corresponding to the flow sign node as a sign flow record pair;

[0022] calculating the balance time difference between all adjacent account balance records in the account balance table within the target time period, and selecting the maximum balance time difference as an account balance sign node, and taking the adjacent account balance records corresponding to the account balance sign node as a sign account balance record pair;

[0023] The flow sign node and the account balance sign node are target sign nodes.

[0024] Preferably, when the flow sign node is located before the target time point, the later flow record in the sign flow record pair is taken as the flow record corresponding to the target sign node, and the later account balance record in the sign account balance record pair is taken as the account balance record corresponding to the target sign node.

[0025] When the flow sign node is located after the target time point, the earlier flow record in the sign flow record pair is taken as the flow record corresponding to the target sign node, and the earlier account balance record in the sign account balance record pair is taken as the account balance record corresponding to the target sign node.

[0026] When the flow sign node contains the target time point, the earlier flow record in the sign flow record pair is taken as the registration flow record of the target time point, and the earlier account balance record in the sign account balance record pair is taken as the registration account balance record of the target time point.

[0027] Preferably, the account balance record corresponding to the registration flow record in the account balance table based on the sign account balance record and the interval record number comprises:

[0028] In the account balance table, the account balance record with an interval record number from the target time direction to the sign account balance record is taken as the account balance record corresponding to the registration flow record.

[0029] Wherein the target time direction is the time direction of the sign flow record to the registration flow record.

[0030] In order to solve the above technical problems, the present application also provides a flow balance registration device, comprising a form acquisition module and a registration module.

[0031] The form acquisition module is configured to acquire a flow record table and an account balance table of the target account.

[0032] The registration module is configured to register the flow records at the plurality of time points in the flow record table with the plurality of account balance records in the account balance table respectively to acquire a flow balance registration table of the target account.

[0033] To solve the above technical problems, the present application further provides a storage medium having a computer program stored thereon, characterized in that the program, when executed by a processor, implements the flow balance data registration method.

[0034] To solve the above technical problems, the present application further provides a terminal, comprising: a processor and a memory in communication connection with the processor.

[0035] The memory is configured to store a computer program, and the processor is configured to execute the computer program stored in the memory to enable the terminal to implement the flow balance data registration method.

[0036] Compared with the prior art, one or more embodiments of the above scheme can have the following advantages or beneficial effects:

[0037] By applying the flow balance data registration method provided by the embodiments of the present application, the flow records at the plurality of time points in the flow record table and the account balance records in the account balance table are registered, so as to facilitate account query and account balance. Specifically, in the homologous and homosequential flow record table and account balance table, the maximum time period in a fixed time period is taken as a corresponding node, the corresponding flow record and account balance record are found in the flow record table and the account balance table, and then the corresponding record is used to register the flow records at the fixed time points in the flow record table with the account balance records, so as to acquire a flow balance registration table. The present application has less data processing amount, high registration accuracy, and is more convenient for account query and account balance calculation of the flow record table and the account balance table without unified association identifier.

[0038] Other features and advantages of the present application will be set forth in the following description, and in part will become apparent to those skilled in the art by reference to the following description and will be apparent from the description or can be learned by practice of the present application. The objects and other advantages of the present application will be realized and attained by the structures particularly pointed out in the written description and claims hereof as well as the appended drawings. BRIEF DESCRIPTION OF DRAWINGS

[0039] The accompanying drawings are included to provide a further understanding of the present application and are incorporated in and constitute a part of the specification, illustrate embodiments of the present application and together with the description serve to explain the present application, but do not limit the present application. In the drawings:

[0040] Figure 1 A flowchart of a water balance data registration method according to an embodiment of the present application is shown in the figure;

[0041] Figure 2 An example of a water record table and an account balance table according to an embodiment of the present application is shown in the figure;

[0042] Figure 3 A structural diagram of a water balance data registration device according to an embodiment of the present application is shown in the figure;

[0043] Figure 4 A structural diagram of a terminal according to an embodiment of the present application is shown in the figure. DETAILED DESCRIPTION

[0044] The embodiments of the present application will be described in detail below with reference to the accompanying drawings and embodiments, so that the technical means by which the present application solves the technical problems and achieves the technical effects can be fully understood and implemented. It should be noted that, as long as there is no conflict, each embodiment in the present application and each feature in each embodiment can be combined with each other, and the technical solutions formed thereby are within the protection scope of the present application.

[0045] In order to confirm the balance of a user's account, it is usually necessary to check whether the difference between the account balance records at two time points and the water record in this period of time match, but due to the huge amount of user data, the account balance data usually requires a certain execution time, and during this period of time, some users still generate water data, which will lead to account imbalance.

[0046] Usually, bank operations will mark the same identifier in the corresponding water record and balance record, so as to easily identify the corresponding water record and balance record, but now some live accounts and the like do not have a unified identifier that can be associated due to setting defects or demand iteration and the like, and the system is not convenient to modify, so that the water record table and the balance record table of this type are not convenient for account inquiry.

[0047] Example One

[0048] To solve the technical problems existing in the prior art, an embodiment of the present application provides a water balance data registration method.

[0049] Figure 1 A flowchart of a water balance data registration method according to an embodiment of the present application is shown in the figure; referring to Figure 1 The water balance data registration method according to the embodiment of the present application includes the following steps.

[0050] Step S101, obtaining a water record table and an account balance table of a target account.

[0051] Figure 2 An example diagram of the flow record table and the account balance table in the embodiment one of the present application is shown; refer to Figure 2 As shown, the flow records in the flow record table of the target account and the account balance records in the account balance table are sorted in the same sorting manner. Preferably, the flow records in the flow record table of the target account are recorded in time sequence, and the account balance records in the account balance table of the target account are also recorded in time sequence, so that the flow records in the flow record table of the target account and the account balance records in the account balance table are in one-to-one correspondence in sequence, and thus the flow record table and the account balance table are homologous and homosequential.

[0052] After obtaining the flow record table and the account balance table of the target account, the flow record table and the account balance table are updated in real time, so that the embodiment can also align the real-time updated flow records and the real-time updated account balance records based on the method to constantly update the flow balance alignment table. The specific updating can be achieved by real-time receiving the flow records through the change data capture synchronization technology and recording the received flow records in the flow record table to realize the real-time updating of the flow record table; similarly, the account balance records can also be real-time received through the change data capture synchronization technology and recorded in the account balance table to realize the real-time updating of the account balance table. It should be noted that the flow record table and the account balance table can also be real-time updated by other reasonable methods, which are not limited herein.

[0053] In step S102, the flow records at multiple time points in the flow record table are respectively aligned with the multiple account balance records in the account balance table to obtain the flow balance alignment table of the target account.

[0054] Specifically, the user account balance problem needs to be confirmed usually every period of time, so it is necessary to align the flow records at multiple time points in the flow record table with the multiple account balance records in the account balance table. In order to facilitate accounting, a fixed time point can be periodically and repeatedly selected as the alignment time point of the flow balance. For example, a certain time point of each day, a certain time point of each week or a certain time point of each month can be selected as the alignment time point, and the selection of the alignment time point can be set based on the actual situation, which is not limited herein.

[0055] The process of aligning the flow record at a certain time point in the flow record table with the account balance record in the account balance table is as follows: setting the time point as a target time point, and the target time point can be any one of the multiple time points.

[0056] Step S201, taking the last flow record in the target time point and the time period before the target time point in the flow record table as the registration flow record of the target time point.

[0057] Specifically, since the time point for registration is set by human, but in the real recording process, the flow record table may not have a record at the target time point, therefore, taking the last flow record in the target time point and the time period before the target time point in the flow record table as the registration flow record of the target time point. Similarly, the registration account balance record corresponding to the registration flow record is registered, and after registration, the account balance record corresponding to the target time point in the flow balance registration table is also registered.

[0058] Step S202, determining the target marker node, so that the flow record corresponding to the target marker node in the flow record table and the account balance record corresponding to the target marker node in the account balance table are in a corresponding record relationship, taking the flow record corresponding to the target marker node in the flow record table as the marker flow record, and taking the account balance record corresponding to the target marker node in the account balance table as the marker account balance record.

[0059] Specifically, the target marker node determined in this step needs to satisfy that the flow record corresponding to the target marker node in the flow record table and the account balance record corresponding to the target marker node in the account balance table are in a corresponding record relationship. Further, the target marker node can be realized by the following process:

[0060] Taking a period of time containing the target time point as the target time period, the selection of the target time period can be based on actual conditions, for example, if the user account changes frequently, a time period formed by 1 hour before and after the target time point can be selected as the target time period, if the user account changes less, a time period formed by 3 hours before and after the target time point can be selected as the target time period, and specific limitations are not made.

[0061] Then, calculating the flow time difference between all adjacent two flow records in the target time period in the flow record table, the flow time difference between adjacent two flow records is the time difference between the adjacent two flow records. And selecting the largest flow time difference in all the calculated flow time differences as the flow marker node, that is, taking the time period with the largest idle time in the flow record table in the target time period as the flow marker node, and taking the adjacent two flow records with the largest flow time difference as the marker flow record pair.

[0062] Similarly, the account balance time difference between any two adjacent account balance records in the account balance record table in the target time period is calculated, and the maximum account balance time difference among all the calculated account balance time differences is selected as the account balance landmark node, i.e., the time period with the maximum idle time in the account balance record table in the target time period is selected as the account balance landmark node, and the two adjacent account balance records corresponding to the maximum account balance time difference are selected as the landmark account balance record pair.

[0063] Since the target account's flow record table and account balance table have the same origin and sequence, the selected flow landmark node and account balance landmark node should also have a corresponding relationship, and the two flow records in the flow landmark record pair and the account balance records in the account balance landmark record pair should also have a one-to-one corresponding relationship. Based on this, the flow landmark node and the account balance landmark node can be used as the target landmark node.

[0064] Meanwhile, the flow record corresponding to the target landmark node in the flow record table is also selected as the landmark flow record, and the account balance record corresponding to the target landmark node in the account balance table is also selected as the landmark account balance record. Further, if the flow landmark node is located before the target time point, to obtain the corresponding registration account balance record, the flow record later in time in the landmark flow record pair can be used as the reference point for calculation, i.e., the flow record later in time in the landmark flow record pair is selected as the flow record corresponding to the target landmark node; at the same time, the flow record later in time in the landmark account balance record pair is also used as the reference point for calculation, i.e., the flow record later in time in the landmark account balance record pair is selected as the account balance record corresponding to the target landmark node, for subsequent calculation of the registration account balance record.

[0065] If the flow landmark node is located after the target time point, to obtain the corresponding registration account balance record, the flow record earlier in time in the landmark flow record pair can be used as the reference point for calculation, i.e., the flow record earlier in time in the landmark flow record pair is selected as the flow record corresponding to the target landmark node; at the same time, the flow record earlier in time in the landmark account balance record pair is also used as the reference point for calculation, i.e., the flow record earlier in time in the landmark account balance record pair is selected as the account balance record corresponding to the target landmark node, for subsequent calculation of the registration account balance record.

[0066] If the flow-water mark node spans the target time point, i.e. the flow-water mark node contains the target time point, the flow-water record with earlier time in the mark flow-water record pair is the registration flow-water record of the target time point, and the account balance record with earlier time in the corresponding mark account balance record pair is the registration account balance record of the target time point. That is, the registration account balance record corresponding to the registration flow-water record can be obtained without subsequent calculation steps.

[0067] It should be noted that the target mark node can also be realized by other reasonable ways.

[0068] In step S203, the interval record number between the registration flow-water record and the mark flow-water record is determined, the account balance record corresponding to the registration flow-water record is found in the account balance table based on the mark account balance record and the interval record number, and the found account balance record is taken as the registration account balance record of the target time point, wherein the target time point is in the time direction from the mark flow-water record to the registration flow-water record.

[0069] Specifically, if the flow-water mark node is located before the target time point, the flow-water record with later time in the mark flow-water record pair is the flow-water record corresponding to the target mark node, and the flow-water record with later time in the mark flow-water record pair is the mark flow-water record, which is located before the registration flow-water record. Similarly, the account balance record with later time in the mark account balance record pair is the account balance record corresponding to the target mark node, and the account balance record with later time in the mark account balance record pair is the mark account balance record, which should also be before the registration account balance record. Based on this, after determining the interval record number between the mark flow-water record and the mark flow-water record, the mark account balance record can be taken as the starting point, and the calculation is carried out backward in the time sequence direction, and the account balance record with interval record number from the mark account balance record is taken as the registration account balance record corresponding to the registration flow-water record.

[0070] If the flow water mark node is located after the target time point, at this time, the flow water record with earlier time in the mark flow water record pair is the flow water record corresponding to the target mark node, and further, the flow water record with earlier time in the mark flow water record pair is the mark flow water record, and the mark flow water record is located after the registration flow water record; similarly, the account balance record with earlier time in the mark account balance record pair is the account balance record corresponding to the target mark node, and further, the account balance record with earlier time in the mark account balance record pair is the mark account balance record, and the mark account balance record should also be after the registration account balance record. Based on this, after determining the interval record number between the mark flow water record and the mark flow water record, the account balance record with the interval record number from the mark account balance record can be taken as the registration flow water record corresponding to the registration account balance record, starting from the mark account balance record and proceeding forward in the time sequence direction.

[0071] In the above manner, the flow water records at multiple time points in the flow water record table and the corresponding multiple account balance records in the account balance table can be obtained. After obtaining a pair of registration flow water record and registration account balance record, the obtained registration flow water record and registration account balance record can be recorded in the registration table to form the flow water balance registration table of the target account.

[0072] The flow water balance data registration method provided by the embodiment of the present application registers the flow water records at multiple time points in the flow water record table and the account balance records in the account balance table, so as to facilitate account inquiry and account balance. Specifically, the corresponding flow water record and account balance record are found in the homologous and homosequential flow water record table and account balance table by taking the maximum time period in the fixed time end as the corresponding node, and then the flow water record at the fixed time point in the flow water record table is registered with the account balance record based on the corresponding record, so as to obtain the flow water balance registration table. The present application has less data processing amount, high registration accuracy, and is more convenient for account inquiry and account balance calculation of the flow water record table and the account balance table without unified association identifier.

[0073] Example Two

[0074] To solve the technical problems in the prior art, the embodiment of the present application further provides a flow water balance data registration device.

[0075] Figure 3 The structure schematic diagram of the flow water balance data registration device of the embodiment of the present application is shown. As shown in Figure 3 The flow water balance data registration device of the embodiment of the present application comprises a table acquisition module and a registration module.

[0076] The table acquisition module is used to acquire the flow water record table and the account balance table of the target account.

[0077] The registration module is used to register the transaction records at multiple time points in the transaction record table with the multiple account balance records in the account balance table to obtain a transaction balance registration table of the target account;

[0078] The step of aligning the transaction records at the target time point in the transaction record table with the account balance records in the account balance table includes:

[0079] The last transaction record at the target time point and the time period before the target time point in the transaction record table is used as the registration transaction record at the target time point;

[0080] Determine a target marker node so that the transaction record corresponding to the target marker node in the transaction record table and the account balance record corresponding to the target marker node in the account balance table are in a corresponding record relationship, use the transaction record corresponding to the target marker node in the transaction record table as the marked transaction record, and use the account balance record corresponding to the target marker node in the account balance table as the marked account balance record;

[0081] Determine the number of interval records between the registration transaction record and the marker transaction record, search the account balance table for the account balance record corresponding to the registration transaction record based on the marker account balance record and the number of interval records, and use the found account balance record as the registration account balance record at the target time point;

[0082] The target time point is any one of the multiple time points, and there is a corresponding record relationship between the registered transaction record and the registered account balance record.

[0083] The present invention provides a flow balance data alignment device that aligns flow records at multiple time points in a flow record table with account balance records in an account balance table to facilitate account query and account balance calculation. Specifically, the device uses the maximum time period within a fixed time end as a corresponding node in the flow record table and the account balance table of the same source and sequence, finds the corresponding flow record and account balance record in the flow record table and the account balance table, and then uses the corresponding record to align the account balance record with the flow record at the fixed time point in the flow record table to obtain a flow balance alignment table. The present invention has a low data processing volume and high alignment accuracy, and is more convenient for account query and account balance calculation in flow record tables and account balance tables that do not have a unified association identifier.

[0084] Example Three

[0085] In order to solve the above technical problems existing in the prior art, an embodiment of the present invention further provides a storage medium storing a computer program. When the computer program is executed by a processor, all the steps in the flow balance data registration method of embodiment 1 can be implemented.

[0086] The specific steps of the water balance data registration method and the beneficial effects obtained by using the readable storage medium provided by the embodiment of the present application are the same as those of the first embodiment, and thus will not be described here.

[0087] It should be noted that the storage medium includes ROM, RAM, magnetic disc or optical disc and various storage program code containing media.

[0088] Example Four

[0089] To solve the above technical problems in the prior art, the embodiment of the present application further provides a terminal.

[0090] Figure 4 The terminal structure of the fourth embodiment of the present application is shown, and with reference to Figure 4 The terminal of the present embodiment includes a processor and a memory connected to each other; the memory is used to store a computer program, and the processor is used to execute the computer program stored in the memory, so that the terminal can implement all steps in the water balance data registration method of the first embodiment when executed.

[0091] The specific steps of the water balance data registration method and the beneficial effects obtained by using the terminal provided by the embodiment of the present application are the same as those of the first embodiment, and thus will not be described here.

[0092] It should be noted that the memory can include random access memory (RAM) and can also include non-volatile memory such as at least one disk memory. Similarly, the processor can be a general-purpose processor including a central processing unit (CPU), a network processor (NP) and the like; it can also be a digital signal processor (DSP), an application specific integrated circuit (ASIC), a field programmable gate array (FPGA) or other programmable logic device, a discrete gate or transistor logic device, a discrete hardware component.

[0093] Although the embodiments disclosed herein are as described above, the contents described herein are merely embodiments for facilitating understanding of the present invention and are not intended to limit the present invention. Any person skilled in the art may make any modifications and variations in the form and details of the embodiments without departing from the spirit and scope of the present invention. However, the scope of protection of the present invention shall remain subject to the scope defined by the appended claims.

Claims

1. A method for registering turnover balance data, comprising: Obtain the target account's transaction record and account balance sheet; aligning the transaction records at multiple time points in the transaction record table with the multiple account balance records in the account balance table to obtain a transaction balance alignment table for the target account; Aligning the flow records at a target time point in the flow record table with the account balance records in the account balance table includes: taking the last flow record at the target time point and the time period before the target time point in the flow record table as the aligned flow record at the target time point; determining a target marker node so that the flow record corresponding to the target marker node in the flow record table and the account balance record corresponding to the target marker node in the account balance table are in a corresponding record relationship, taking the flow record corresponding to the target marker node in the flow record table as the marker flow record, and The account balance record corresponding to the target marker node in the account balance table is used as the marker account balance record; the number of interval records between the registered transaction record and the marker transaction record is determined; based on the marker account balance record and the number of interval records, an account balance record corresponding to the registered transaction record is searched in the account balance table, and the account balance record found is used as the registered account balance record at the target time point; wherein the target time point is any one of a plurality of time points, and there is a corresponding record relationship between the registered transaction record and the registered account balance record; The method for determining the target marking node is as follows: determining a target time period so that the target time point is within the target time period; calculating the flow time difference between all two adjacent flow records in the flow record table within the target time period, and selecting the largest flow time difference among all the flow time differences as the flow marking node, and using the two adjacent flow records corresponding to the flow marking node as a marking flow record pair; calculating the balance time difference between all two adjacent account balance records in the account balance table within the target time period, and selecting the largest balance time difference among all the balance time differences as the account balance record marking node, and using the adjacent account balance records corresponding to the account balance marking node as a marking account balance record pair; the flow marking node and the account balance marking node are the target marking nodes.

2. The registration method according to claim 1, characterized in that The transaction records in the transaction record table and the account balance records in the account balance table are sorted in the same sorting manner.

3. The registration method according to claim 2, characterized in that: The steps to obtain the target account's transaction record and account balance sheet include: Obtain the transaction record table and account balance table of the target account, and update the transaction record table and account balance table in real time.

4. The method according to claim 3, characterized in that Receiving the water flow record in real time through the change data capture synchronization technology, and recording the received water flow record into the water flow record table to achieve real-time update of the water flow record table; The account balance record is received in real time through the change data capture synchronization technology, and the received account balance record is recorded in the account balance table to achieve real-time update of the account balance table.

5. The method according to claim 1, wherein When the transaction mark node is before the target time point, the transaction record with a later time among the transaction mark record pair is used as the transaction record corresponding to the target transaction mark node, and the account balance record with a later time among the account balance record pair is used as the account balance record corresponding to the target transaction mark node; When the transaction mark node is located after the target time point, the transaction record with an earlier time in the transaction mark record pair is used as the transaction record corresponding to the target transaction mark node, and the account balance record with an earlier time in the account balance record pair is used as the account balance record corresponding to the target transaction mark node; When the flow mark node includes the target time point, the flow record with an earlier time in the marked flow record pair is used as the registered flow record for the target time point, and the account balance record with an earlier time in the marked account balance record pair is used as the registered account balance record for the target time point.

6. The registration method according to claim 1, characterized in that: Searching the account balance table for an account balance record corresponding to the registered transaction record based on the marked account balance record and the number of interval records includes: In the account balance table, the account balance record that is the number of record intervals away from the marked account balance record along the target time direction is used as the account balance record corresponding to the registered transaction record; The target time mode is the time direction of the marked pipeline record to the registered pipeline record.

7. A flow balance registration device, characterized in that: Includes form acquisition module and registration module; The form acquisition module is used to obtain the transaction record sheet and account balance sheet of the target account; The registration module is configured to register the transaction records at multiple time points in the transaction record table with the multiple account balance records in the account balance table, respectively, to obtain a transaction balance registration table for a target account; Aligning the flow records at a target time point in the flow record table with the account balance records in the account balance table includes: taking the last flow record at the target time point and the time period before the target time point in the flow record table as the aligned flow record at the target time point; determining a target marker node so that the flow record corresponding to the target marker node in the flow record table and the account balance record corresponding to the target marker node in the account balance table are in a corresponding record relationship, taking the flow record corresponding to the target marker node in the flow record table as the marker flow record, and The account balance record corresponding to the target marker node in the account balance table is used as the marker account balance record; the number of interval records between the registered transaction record and the marker transaction record is determined; based on the marker account balance record and the number of interval records, an account balance record corresponding to the registered transaction record is searched in the account balance table, and the account balance record found is used as the registered account balance record at the target time point; wherein the target time point is any one of a plurality of time points, and there is a corresponding record relationship between the registered transaction record and the registered account balance record; The method for determining the target marking node is as follows: determining a target time period so that the target time point is within the target time period; calculating the flow time difference between all two adjacent flow records in the flow record table within the target time period, and selecting the largest flow time difference among all the flow time differences as the flow marking node, and using the two adjacent flow records corresponding to the flow marking node as a marking flow record pair; calculating the balance time difference between all two adjacent account balance records in the account balance table within the target time period, and selecting the largest balance time difference among all the balance time differences as the account balance record marking node, and using the adjacent account balance records corresponding to the account balance marking node as a marking account balance record pair; the flow marking node and the account balance marking node are the target marking nodes.

8. A storage medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, the method for aligning running balance data according to any one of claims 1 to 6 is implemented.

9. A terminal, characterized in that: include: a processor and a memory, wherein the memory is communicatively connected to the processor; The memory is used to store a computer program, and the processor is used to execute the computer program stored in the memory, so that the terminal performs the turnover balance data registration method according to any one of claims 1 to 6.

Citation Information

Patent Citations

  • Data checking method and device, computer equipment and storage medium

    CN110019194A

  • Account resource data determination method and system

    CN110163742A