CN111639086A - Data reconciliation method, device, equipment and storage medium - Google Patents
Data reconciliation method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN111639086A CN111639086A CN202010454417.0A CN202010454417A CN111639086A CN 111639086 A CN111639086 A CN 111639086A CN 202010454417 A CN202010454417 A CN 202010454417A CN 111639086 A CN111639086 A CN 111639086A
- Authority
- CN
- China
- Prior art keywords
- data
- reconciliation
- account checking
- missing
- delay
- 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.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2358—Change logging, detection, and notification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Abstract
The embodiment of the invention discloses a data reconciliation method, a device, equipment and a storage medium. The method comprises the following steps: respectively acquiring corresponding reconciliation data from at least two data sources according to the received data change message; carrying out account checking operation according to the account checking data; if the account checking result is that the account checking is not smooth, whether the account checking data is missing or not is judged; and sending account checking result information according to the missing condition of the account checking data. The technical scheme of the embodiment of the invention can accurately send the account checking result information and generate the alarm signal when the account checking is carried out, thereby avoiding the situation of false alarm when the account checking result is unreliable due to account checking data loss.
Description
Technical Field
The embodiment of the invention relates to the technical field of data reconciliation, in particular to a data reconciliation method, a device, equipment and a storage medium.
Background
With the development of internet technology, a large amount of data for generating interaction exists among different systems. For example, when an item is purchased, paid or paid, the user account system interacts with data in the merchant account system. When an event occurs between two systems, the interactive data needs to meet expectations, whether the interactive data meets expectations is judged, and the implementation means is reconciliation.
In the prior art, when account checking is performed on different systems, if account checking is abnormal, an alarm signal is generated. For example, when the account checking result is that the account checking is not normal, an alarm signal is generated. However, when account checking is performed under the condition that account checking data or the system itself is abnormal, account checking is abnormal, and an alarm signal is directly generated, and the generated alarm signal is a false alarm signal, which cannot be avoided in the prior art.
Disclosure of Invention
The embodiment of the invention provides a data reconciliation method, a device, equipment and a storage medium, which can accurately send reconciliation result information and avoid false alarm.
In a first aspect, an embodiment of the present invention provides a data reconciliation method, where the method includes:
respectively acquiring corresponding reconciliation data from at least two data sources according to the received data change message;
performing account checking operation according to the account checking data;
if the account checking result is that the account checking is not smooth, whether the account checking data is missing or not is judged;
and sending account checking result information according to the missing condition of the account checking data.
In a second aspect, an embodiment of the present invention further provides a data reconciliation apparatus, where the apparatus includes:
the account checking data acquisition module is used for respectively acquiring corresponding account checking data from at least two data sources according to the received data change message;
the account checking operation execution module is used for carrying out account checking operation according to the account checking data;
the account checking data missing judging module is used for judging whether the account checking data is missing or not if the account checking result is that the account checking is not smooth;
and the information sending module is used for sending the account checking non-result message according to the missing condition of the account checking data.
In a third aspect, an embodiment of the present invention further provides a reconciliation device, where the reconciliation device includes:
one or more processors;
a storage device for storing one or more programs,
when executed by the one or more processors, cause the one or more processors to implement a data reconciliation method according to any embodiment of the invention.
In a fourth aspect, the embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements a data reconciliation method according to any embodiment of the present invention.
The method comprises the steps of respectively acquiring corresponding account checking data from at least two data sources according to received data change messages; carrying out account checking operation according to the account checking data; if the account checking result is that the account checking is not smooth, whether the account checking data is missing or not is judged; the account checking result information is sent according to the missing condition of the account checking data, the problem of false alarm generated when the account checking result is unreliable due to the missing of the account checking data is solved, the accurate sending of the account checking result information is realized, and the effect of false alarm is avoided.
Drawings
Fig. 1 is a flowchart of a data reconciliation method according to an embodiment of the present invention;
fig. 2 is a flowchart of a data reconciliation method according to a second embodiment of the present invention;
fig. 3 is a data flow chart of a data reconciliation system according to a second embodiment of the present invention;
fig. 4 is a data flow chart of a data reconciliation system according to a second embodiment of the present invention;
fig. 5 is a schematic structural diagram of a data reconciliation apparatus according to a third embodiment of the present invention;
fig. 6 is a schematic structural diagram of a reconciliation device according to a fourth embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.
Example one
Fig. 1 is a flowchart of a data reconciliation method according to an embodiment of the present invention, where the embodiment is applicable to a situation where a false alarm is avoided when data is missing in a real-time reconciliation, and the method may be executed by a data reconciliation apparatus, where the apparatus may be implemented in a software and/or hardware manner, and the apparatus may be integrated in a computer device, as shown in fig. 1, where the method specifically includes:
and step 110, acquiring corresponding reconciliation data from at least two data sources respectively according to the received data change message.
Wherein, the common events will occur in at least two systems, one system will correspond to two databases, one is the main database, for the real business use; the other one is a standby database which is used for copying and storing the data of the main database and is used when the main database has problems. When the data is synchronized to the standby database from the main database, a data change message is sent to the account checking device, and when the account checking device receives the data change message, corresponding account checking data is obtained from a data source corresponding to the system. The data source in the embodiment of the present invention may be a backup database of the stored data corresponding to the system. The reconciliation data can be data associated with data sources corresponding to different systems when an event occurs.
Illustratively, the event is a loan repayment event, a loan-to-order system, a repayment-to-billing system, an order system, and a billing system each having a master database and a backup database. The data source can be a spare database corresponding to an order system of loan and a bill system of repayment respectively, and the reconciliation data is loan data in the spare database corresponding to the order system and repayment data in the spare database corresponding to the bill system.
And step 120, performing account checking operation according to the account checking data.
The account checking equipment can perform account checking operation according to the acquired account checking data and preset account checking rules, wherein the preset account checking rules can be scripts for executing the account checking operation. For example, the loan data in the standby database corresponding to the order system and the repayment data in the standby database corresponding to the billing system may be subjected to reconciliation.
And step 130, if the account checking result is that the account checking is not smooth, judging whether the account checking data is missing.
Wherein, the account checking result can be account checking level or account checking unevenness. The account checking level shows that the account checking data accords with a preset account checking rule, and no problem exists; the account checking unevenness indicates that the account checking data does not conform to the preset account checking rule, so that problems exist, and the existing problems can be caused by the missing of the account checking data or the problems of the account checking data. When the account checking is not flat, the account checking equipment sends an account checking alarm so that a manager of the system can adjust the system to find out the problems of the system. Therefore, when the account checking data has problems to cause account checking irregularity, it is normal to send an account checking irregularity alarm. However, when the account checking data is not in level due to missing of the account checking data, the account checking data may not have problems, but the account checking data may be delayed due to network problems, large data volume and the like, so that the account checking data does not need to be adjusted by a system administrator, and the situation that an account checking non-level alarm needs to be sent is avoided. In this case, sending an account tie-out alarm may result in a false alarm.
In an implementation manner of the embodiment of the present invention, optionally, the determining whether the reconciliation data is missing includes: judging whether reconciliation data acquired from all data sources meet a preset reconciliation rule or not; if the account checking data meet the preset account checking rule, determining that the account checking data are not missing; and if the reconciliation data does not meet the preset reconciliation rule, determining that the reconciliation data is missing.
The account checking data required by account checking operation can be known from the preset account checking rule, and when the acquired account checking data meets the requirement of the preset account checking rule, the account checking data can be judged to be absent; when the acquired reconciliation data does not meet the requirement of the preset reconciliation rule, for example, the reconciliation rule needs data of two standby databases, but only the data of one standby database is acquired, so that the missing of the reconciliation data can be judged.
And step 140, sending account checking result information according to the missing condition of the account checking data.
And when the account checking data is not missing, the account checking equipment sends account checking result information. For example, the reconciliation result information can be a non-tie-up and a non-tie-up alarm. And when the account checking data is missing, the account checking equipment sends account checking result information. For example, the account checking result information may be account checking unevenness, and account checking data is missing, but an account checking unevenness alarm is not sent. The account checking and alarming method can accurately send account checking and alarming, and avoid the situation of false alarm and alarming when account checking results are unreliable due to account checking data missing.
According to the technical scheme of the embodiment of the invention, corresponding account checking data are respectively obtained from at least two data sources according to the received data change message; carrying out account checking operation according to the account checking data; if the account checking result is that the account checking is not smooth, whether the account checking data is missing or not is judged; the account checking result information is sent according to the missing condition of the account checking data, the problem of false alarm when the account checking result is unreliable due to the missing of the account checking data is solved, the accurate sending of the account checking result information is realized, the alarm signal is accurately generated, and the effect of false alarm is avoided.
Example two
Fig. 2 is a flowchart of a data reconciliation method provided in the second embodiment of the present invention, which is a further refinement of the above technical solution, and the technical solution in the second embodiment may be combined with various alternatives in one or more of the above embodiments.
As shown in fig. 2, the method specifically includes:
And step 220, performing account checking operation according to the account checking data.
Step 230, if the reconciliation result is that the reconciliation is not smooth, judging whether the reconciliation data acquired from all the data sources meet a preset reconciliation rule; if the account checking data meet the preset account checking rule, determining that the account checking data are not missing; and if the reconciliation data does not meet the preset reconciliation rule, determining that the reconciliation data is missing.
Step 240, if the reconciliation data is missing, checking whether a data source corresponding to the missing reconciliation data is delayed; and if the data source corresponding to the missing reconciliation data has delay, marking the missing reconciliation data as delay data.
When the reconciliation data is missing, whether the data source corresponding to the missing reconciliation data is delayed or not can be checked, if the data source is delayed, the reconciliation data is delayed, the delayed reconciliation data can be marked as delayed data, and the delayed data can be conveniently reconciled. The missing of the reconciliation data caused by other reasons can be eliminated, for example, if the missing of the reconciliation data is caused by data delay, the adjustment by a manager of the system may not be needed, but if the missing of the reconciliation data is caused by system failure, the manager of the system may need to be informed in time. Therefore, it is necessary to further determine whether the missing of the reconciliation data is caused by the delay of the reconciliation data, which may be that the sending of the tie-up alarm is more accurate.
In an implementation manner of the embodiment of the present invention, optionally, the checking whether there is a delay in a data source corresponding to the missing reconciliation data includes: acquiring the change time of the reconciliation data from a data source corresponding to the non-missing reconciliation data, and acquiring the synchronization time of the reconciliation data from a data source corresponding to the missing reconciliation data; if the change time is after the synchronization time, determining that a delay exists in a data source corresponding to the missing reconciliation data; if the change time is not behind the synchronization time, determining that no delay exists in the data source corresponding to the missing reconciliation data; wherein, the change time is the time corresponding to the change of each piece of account checking data in the data source; the synchronization time is the time for performing synchronous backup of all data in the data source.
Each piece of data has a change time, and the change time of the data is the time for synchronizing the data from the master database to the slave database. The data in the standby database also has a synchronization time, and the synchronization time refers to that all data before the synchronization time are synchronized to the standby database from the main database.
When judging whether the data source corresponding to the missing reconciliation data has delay, acquiring the change time of the reconciliation data from the data source corresponding to the non-missing reconciliation data and acquiring the synchronization time of the reconciliation data from the data source corresponding to the missing reconciliation data; if the change time is after the synchronization time, it can be determined that there is a delay in the data source corresponding to the missing reconciliation data. For example, the order system and the billing system perform reconciliation operation, reconciliation data corresponding to the billing system is missing, the change time of the reconciliation data corresponding to the order system is 5 o 'clock 35 minutes, and the synchronization time of the backup database corresponding to the billing system is 5 o' clock 30 minutes. When the order system data is changed, the billing system data should be changed at the same time. However, when the synchronization time is before the change time, which indicates that the data of the order system is changed, the data of the billing system is not synchronized from the master database to the backup database, and it can be determined that there is a delay in the billing system, thereby causing the reconciliation data corresponding to the billing system to be missing.
And if the change time is not after the synchronization time, determining that no delay exists in the data source corresponding to the missing reconciliation data. For example, the order system and the billing system perform reconciliation operation, reconciliation data corresponding to the billing system is missing, the change time of the reconciliation data corresponding to the order system is 5 o 'clock 35 minutes, and the synchronization time of the backup database corresponding to the billing system is 5 o' clock 40 minutes. When the order system data is changed, the billing system data should be changed at the same time. However, at this time, when the synchronization time is after the change time, which indicates that the data of the order system is changed, the data of the billing system should be synchronized from the master database to the backup database, it is not the case that the reconciliation data corresponding to the billing system is lost due to the delay of the billing system, and it can be determined that the reconciliation data is not lost due to the failure of the billing system.
Step 250, regularly acquiring the synchronization time of the delay data from the data source corresponding to the delay data at preset time intervals; and if the synchronization time of the delay data is after the change time, acquiring missing reconciliation data from a data source corresponding to the delay data to perform reconciliation operation.
In order to perform reconciliation operation on the delayed data, the reconciliation equipment acquires the synchronization time of the delayed data at a preset time interval, and judges whether the delayed data can be acquired. When the synchronization time of the delay data is after the change time, the delay data is considered to be synchronized from the main database to the standby database, and the delay data can be acquired, that is, the missing reconciliation data can be acquired. And the reconciliation equipment acquires the missing reconciliation data from the standby database corresponding to the delay data, performs reconciliation operation, and sends a non-reconciliation alarm when the reconciliation is not normal.
According to the technical scheme of the embodiment, corresponding reconciliation data are respectively acquired from at least two data sources according to the received data change message; carrying out account checking operation according to the account checking data; if the account checking result is that the account checking is not smooth, whether account checking data acquired from all data sources meet a preset account checking rule is judged; if the account checking data meet the preset account checking rule, determining that the account checking data are not missing; if the reconciliation data does not meet the preset reconciliation rule, determining that the reconciliation data is missing; if the reconciliation data is missing, checking whether a data source corresponding to the missing reconciliation data has delay or not; if the data source corresponding to the missing reconciliation data has delay, marking the missing reconciliation data as delay data; periodically acquiring the synchronization time of the delay data from a data source corresponding to the delay data at preset time intervals; if the synchronization time of the delayed data is after the change time, missing account checking data is obtained from the data source corresponding to the delayed data for account checking operation, so that the problem of false alarm when the account checking result is unreliable due to the delay of the account checking data is solved, the accurate sending of the account checking result information is realized, the accurate generation of the alarm signal is realized, and the effect of false alarm is avoided.
Fig. 3 is a data flow chart of a data reconciliation system according to a second embodiment of the present invention, and as shown in fig. 3, in a real-time reconciliation process, a reconciliation device may acquire reconciliation data of a plurality of data sources for reconciliation, and perform a reconciliation operation according to the acquired reconciliation data. For example, the account checking data 1 obtained from the first data source exists, the account checking data 2 obtained from the second data source is missing, and the real-time account checking is performed, and the account checking result is that the account checking is not flat. The reconciliation equipment can check whether the second data source corresponding to the missing reconciliation data 2 has delay, if the second data source has delay, the reconciliation data 2 corresponding to the second data source can be marked as delay data, and the reconciliation uneven alarm is not sent, so that the reconciliation result information can be accurately sent, the alarm signal can be generated, and the false alarm can be avoided.
Fig. 4 is a data flow chart of a data reconciliation system according to a second embodiment of the present invention, and as shown in fig. 4, for the reconciliation data with delay in the real-time reconciliation, the reconciliation equipment will mark as delay data, for the delay data, the reconciliation equipment will regularly check the synchronization time of the corresponding data source, if the synchronization time is expected, that is, the synchronization time of the data source corresponding to the delayed reconciliation data is after the change time of the non-delayed reconciliation data, the delayed data reconciliation will be triggered, and the reconciliation data with abnormal reconciliation result due to delay in the real-time reconciliation will be reconciled. And if the synchronization time is not in accordance with the expectation, the synchronization time of the corresponding data source is continuously checked at regular time until the synchronization time is in accordance with the expectation, and the reconciliation operation is carried out. And sending account checking result information according to the account checking result, wherein the account checking result information can be the account checking level or the account checking level, and sending an account checking level alarm when the account checking level is not level. The account checking result information can be accurately sent, the alarm signal can be accurately generated, the false alarm and the alarm can be avoided, meanwhile, the account checking operation can be carried out on the delayed account checking data again, and the accuracy of the account checking result is improved.
EXAMPLE III
Fig. 5 is a schematic structural diagram of a data reconciliation device according to a third embodiment of the present invention. With reference to fig. 5, the apparatus comprises: the system comprises a reconciliation data acquisition module 310, a reconciliation operation execution module 320, a reconciliation data missing judgment module 330 and an information sending module 340.
The reconciliation data obtaining module 310 is configured to obtain, according to the received data change message, corresponding reconciliation data from at least two data sources, respectively;
the account checking operation executing module 320 is used for performing account checking operation according to the account checking data;
the reconciliation data missing judgment module 330 is configured to judge whether the reconciliation data is missing or not if the reconciliation result is that the reconciliation is not smooth;
and the information sending module 340 is configured to send a reconciliation non-result message according to the missing condition of the reconciliation data.
Optionally, the information sending module 340 includes:
the delay checking unit is used for checking whether a data source corresponding to the missing reconciliation data has delay or not if the reconciliation data has loss;
and the delayed data marking unit is used for marking the missing reconciliation data as delayed data if the data source corresponding to the missing reconciliation data has delay.
Optionally, the delay check unit includes:
the time acquisition subunit is used for acquiring the change time of the reconciliation data from the data source corresponding to the non-missing reconciliation data and acquiring the synchronization time of the reconciliation data from the data source corresponding to the missing reconciliation data;
the delay determining subunit is used for determining that the data source corresponding to the missing reconciliation data has delay if the change time is after the synchronization time; if the change time is not behind the synchronization time, determining that no delay exists in the data source corresponding to the missing reconciliation data;
wherein, the change time is the time corresponding to the change of each piece of account checking data in the data source; the synchronization time is the time for performing synchronous backup of all data in the data source.
Optionally, the reconciliation data missing determining module 330 includes:
the account checking data missing judging unit is used for judging whether the account checking data acquired from all the data sources meet a preset account checking rule or not; if the account checking data meet the preset account checking rule, determining that the account checking data are not missing; and if the reconciliation data does not meet the preset reconciliation rule, determining that the reconciliation data is missing.
Optionally, the apparatus further includes:
the synchronous time regular acquisition module is used for regularly acquiring the synchronous time of the delayed data from the data source corresponding to the delayed data at preset time intervals after the missing reconciliation data is marked as the delayed data if the data source corresponding to the missing reconciliation data has delay;
and the reconciliation operation performing module is used for acquiring missing reconciliation data from a data source corresponding to the delay data and performing reconciliation operation if the synchronization time of the delay data is after the change time.
The data reconciliation device provided by the embodiment of the invention can execute the data reconciliation method provided by any embodiment of the invention, and has corresponding functional modules and beneficial effects of the execution method.
Example four
Fig. 6 is a schematic structural diagram of a reconciliation device provided in the fourth embodiment of the present invention, and as shown in fig. 6, the reconciliation device includes:
one or more processors 410, one processor 410 being exemplified in FIG. 6;
a memory 420;
the apparatus may further include: an input device 430 and an output device 440.
The processor 410, the memory 420, the input device 430 and the output device 440 of the apparatus may be connected by a bus or other means, for example, in fig. 6.
The memory 420 is used as a non-transitory computer-readable storage medium, and can be used to store software programs, computer-executable programs, and modules, such as program instructions/modules corresponding to a data reconciliation method in the embodiment of the present invention (for example, the reconciliation data acquisition module 310, the reconciliation operation execution module 320, the reconciliation data missing determination module 330, and the information sending module 340 shown in fig. 5). The processor 410 executes various functional applications and data processing of the computer device by executing software programs, instructions and modules stored in the memory 420, namely, a data reconciliation method for implementing the above method embodiments, namely:
respectively acquiring corresponding reconciliation data from at least two data sources according to the received data change message;
performing account checking operation according to the account checking data;
if the account checking result is that the account checking is not smooth, whether the account checking data is missing or not is judged;
and sending account checking result information according to the missing condition of the account checking data.
The memory 420 may include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function; the storage data area may store data created according to use of the computer device, and the like. Further, the memory 420 may include high speed random access memory, and may also include non-transitory memory, such as at least one magnetic disk storage device, flash memory device, or other non-transitory solid state storage device. In some embodiments, memory 420 may optionally include memory located remotely from processor 410, which may be connected to the terminal device via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The input device 430 may be used to receive input numeric or character information and generate key signal inputs related to user settings and function control of the computer apparatus. The output device 440 may include a display device such as a display screen.
EXAMPLE five
An embodiment of the present invention provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements a data reconciliation method according to an embodiment of the present invention:
respectively acquiring corresponding reconciliation data from at least two data sources according to the received data change message;
performing account checking operation according to the account checking data;
if the account checking result is that the account checking is not smooth, whether the account checking data is missing or not is judged;
and sending account checking result information according to the missing condition of the account checking data.
Any combination of one or more computer-readable media may be employed. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.
Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Computer program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (10)
1. A data reconciliation method, comprising:
respectively acquiring corresponding reconciliation data from at least two data sources according to the received data change message;
performing account checking operation according to the account checking data;
if the account checking result is that the account checking is not smooth, whether the account checking data is missing or not is judged;
and sending account checking result information according to the missing condition of the account checking data.
2. The method of claim 1, wherein the sending reconciliation result information according to the missing condition of the reconciliation data comprises:
if the reconciliation data is missing, checking whether a data source corresponding to the missing reconciliation data has delay;
and if the data source corresponding to the missing reconciliation data has delay, marking the missing reconciliation data as delay data.
3. The method of claim 2, wherein checking whether a data source corresponding to the missing reconciliation data has a delay comprises:
acquiring the change time of the reconciliation data from a data source corresponding to the non-missing reconciliation data, and acquiring the synchronization time of the reconciliation data from a data source corresponding to the missing reconciliation data;
if the change time is after the synchronization time, determining that a delay exists in a data source corresponding to the missing reconciliation data;
if the change time is not after the synchronization time, determining that no delay exists in a data source corresponding to the missing reconciliation data;
wherein the change time is the time corresponding to the change of each piece of account checking data in the data source; the synchronous time is the time for synchronously backing up all data in the data source.
4. The method of claim 1, wherein the determining whether the reconciliation data is missing comprises:
judging whether the reconciliation data acquired from all the data sources meet a preset reconciliation rule or not;
if the account checking data meet a preset account checking rule, determining that the account checking data are not missing;
and if the account checking data do not meet the preset account checking rule, determining that the account checking data are missing.
5. The method of claim 3, wherein after the marking the missing reconciliation data as deferred data if there is a delay in the data source corresponding to the missing reconciliation data, further comprising:
periodically acquiring the synchronization time of the delay data from a data source corresponding to the delay data at preset time intervals;
and if the synchronization time of the delay data is after the change time, acquiring missing reconciliation data from a data source corresponding to the delay data to perform reconciliation operation.
6. A data reconciliation apparatus, comprising:
the account checking data acquisition module is used for respectively acquiring corresponding account checking data from at least two data sources according to the received data change message;
the account checking operation execution module is used for carrying out account checking operation according to the account checking data;
the account checking data missing judging module is used for judging whether the account checking data is missing or not if the account checking result is that the account checking is not smooth;
and the information sending module is used for sending the account checking non-result message according to the missing condition of the account checking data.
7. The apparatus of claim 6, wherein the information sending module comprises:
the delay checking unit is used for checking whether a data source corresponding to the missing reconciliation data has delay or not if the reconciliation data has missing;
and the delayed data marking unit is used for marking the missing reconciliation data as delayed data if the data source corresponding to the missing reconciliation data has delay.
8. The apparatus of claim 7, wherein the delay check unit comprises:
the time acquisition subunit is used for acquiring the change time of the reconciliation data from the data source corresponding to the non-missing reconciliation data and acquiring the synchronization time of the reconciliation data from the data source corresponding to the missing reconciliation data;
the delay determining subunit is configured to determine that a delay exists in a data source corresponding to the missing reconciliation data if the change time is after the synchronization time; if the change time is not after the synchronization time, determining that no delay exists in a data source corresponding to the missing reconciliation data;
wherein the change time is the time corresponding to the change of each piece of account checking data in the data source; the synchronous time is the time for synchronously backing up all data in the data source.
9. A reconciliation apparatus, comprising:
one or more processors;
a storage device for storing one or more programs,
when executed by the one or more processors, cause the one or more processors to implement a data reconciliation method as claimed in any one of claims 1-5.
10. A computer-readable storage medium, on which a computer program is stored, which program, when being executed by a processor, carries out a data reconciliation method according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010454417.0A CN111639086B (en) | 2020-05-26 | 2020-05-26 | Data reconciliation method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010454417.0A CN111639086B (en) | 2020-05-26 | 2020-05-26 | Data reconciliation method, device, equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111639086A true CN111639086A (en) | 2020-09-08 |
| CN111639086B CN111639086B (en) | 2023-06-09 |
Family
ID=72329429
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010454417.0A Active CN111639086B (en) | 2020-05-26 | 2020-05-26 | Data reconciliation method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111639086B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112734450A (en) * | 2021-01-14 | 2021-04-30 | 上海尧信惠达信息科技有限公司 | Double-sided accounting method and system based on online guarantee and electronic equipment |
| US11526491B1 (en) * | 2022-02-21 | 2022-12-13 | Clari Inc. | Method and system for collecting data from data sources with commit lag to maintain data consistency in a data store |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150081481A1 (en) * | 2013-09-16 | 2015-03-19 | International Business Machines Corporation | Analytics-driven automated reconciliation of financial transactions |
| CN104462568A (en) * | 2014-12-26 | 2015-03-25 | 山东中创软件商用中间件股份有限公司 | Data reconciliation method, device and system |
| CN109325028A (en) * | 2018-08-22 | 2019-02-12 | 平安普惠企业管理有限公司 | A kind of reconciliation file verification method and terminal device |
| CN110458681A (en) * | 2019-08-15 | 2019-11-15 | 深圳乐信软件技术有限公司 | A kind of method, apparatus, server and the storage medium of data reconciliation decision |
-
2020
- 2020-05-26 CN CN202010454417.0A patent/CN111639086B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150081481A1 (en) * | 2013-09-16 | 2015-03-19 | International Business Machines Corporation | Analytics-driven automated reconciliation of financial transactions |
| CN104462568A (en) * | 2014-12-26 | 2015-03-25 | 山东中创软件商用中间件股份有限公司 | Data reconciliation method, device and system |
| CN109325028A (en) * | 2018-08-22 | 2019-02-12 | 平安普惠企业管理有限公司 | A kind of reconciliation file verification method and terminal device |
| CN110458681A (en) * | 2019-08-15 | 2019-11-15 | 深圳乐信软件技术有限公司 | A kind of method, apparatus, server and the storage medium of data reconciliation decision |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112734450A (en) * | 2021-01-14 | 2021-04-30 | 上海尧信惠达信息科技有限公司 | Double-sided accounting method and system based on online guarantee and electronic equipment |
| US11526491B1 (en) * | 2022-02-21 | 2022-12-13 | Clari Inc. | Method and system for collecting data from data sources with commit lag to maintain data consistency in a data store |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111639086B (en) | 2023-06-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111314141B (en) | Route updating method and device | |
| CN109492013B (en) | Data processing method, device and system applied to database cluster | |
| US20160077910A1 (en) | Supportability framework for mobile software applications | |
| US10313441B2 (en) | Data processing system with machine learning engine to provide enterprise monitoring functions | |
| US10747776B2 (en) | Replication control using eventually consistent meta-data | |
| CN107992537B (en) | Service attribute transmission method, device, computer equipment and storage medium | |
| CN111639086B (en) | Data reconciliation method, device, equipment and storage medium | |
| CN111338834B (en) | Data storage method and device | |
| CN114144761A (en) | Publishing system, pushing method, application device, receiving device and service management device | |
| CN113220342A (en) | Centralized configuration method and device, electronic equipment and storage medium | |
| CN116701053B (en) | Method, device, equipment and medium for restoring data backup of production environment database | |
| CN115629909A (en) | Service data processing method and device, electronic equipment and storage medium | |
| CN110750424B (en) | Resource inspection method and device | |
| US20180063242A1 (en) | Method and apparatus for operating infrastructure layer in cloud computing architecture | |
| CN112463887A (en) | Data processing method, device, equipment and storage medium | |
| CN107909460B (en) | Position synchronization method, device, data center and storage medium | |
| CN112241332B (en) | Interface compensation method and device | |
| CN111310043B (en) | Method and device for pushing information | |
| CN110262756B (en) | Method and device for caching data | |
| CN107783852B (en) | Dump file generation method and terminal | |
| CN115391827B (en) | Log information storage method, apparatus, device, computer readable medium and product | |
| US11953995B1 (en) | Centralized data backup platform supporting multiple data environments | |
| CN110532322B (en) | Operation and maintenance interaction method, system, computer readable storage medium and equipment | |
| CN114297295A (en) | Data synchronization method and device, electronic equipment and computer readable storage medium | |
| CN115705258A (en) | Test method, test device, storage medium and electronic equipment |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |