CN111639086B - Data reconciliation method, device, equipment and storage medium - Google Patents
Data reconciliation method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN111639086B CN111639086B CN202010454417.0A CN202010454417A CN111639086B CN 111639086 B CN111639086 B CN 111639086B CN 202010454417 A CN202010454417 A CN 202010454417A CN 111639086 B CN111639086 B CN 111639086B
- Authority
- CN
- China
- Prior art keywords
- data
- reconciliation
- missing
- checking
- 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.)
- Active
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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Finance (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Accounting & Taxation (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computing Systems (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Debugging And Monitoring (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
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; checking account according to the checking account data; if the account checking result is that the account checking is not flat, judging whether the account checking data is missing or not; and sending the accounting result information according to the missing condition of the accounting data. According to the technical scheme, the account checking result information can be accurately sent during account checking, the alarm signal is generated, and the situation that the alarm is misreported when the account checking result is unreliable due to the fact that account checking data are missing is avoided.
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 at any time between different systems. For example, the user account system may interact with data in the merchant account system upon purchase, payment, or repayment of the merchandise. When an event occurs between two systems, the data of interaction needs to meet expectations, and whether the data of interaction meet expectations or not is judged, so that the method is implemented by checking accounts.
In the prior art, when checking out different systems, if checking out abnormality occurs, an alarm signal is generated. For example, when the reconciliation result is a reconciliation period, an alarm signal may be generated. However, when checking account data or the system itself is abnormal, checking account is abnormal, and an alarm signal is directly generated, and the alarm signal generated at this time is a false alarm signal, which cannot be avoided in the prior art.
Disclosure of Invention
The embodiment of the invention provides a data checking method, a device, equipment and a storage medium, which can accurately send checking result information and avoid false alarm.
In a first aspect, an embodiment of the present invention provides a data reconciliation method, including:
respectively acquiring corresponding reconciliation data from at least two data sources according to the received data change message;
performing reconciliation operation according to the reconciliation data;
if the account checking result is that the account checking is not flat, judging whether the account checking data is missing or not;
and sending the reconciliation result information according to the missing condition of the reconciliation data.
In a second aspect, an embodiment of the present invention further provides a data reconciliation device, including:
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 checking operation execution module is used for performing checking operation according to the checking data;
the checking data deletion judging module is used for judging whether the checking data is deleted or not if the checking result is that the checking is uneven;
and the information sending module is used for sending a reconciliation failure result message according to the missing condition of the reconciliation data.
In a third aspect, an embodiment of the present invention further provides a reconciliation apparatus, including:
one or more processors;
storage means for storing one or more programs,
the 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 described in any of the embodiments of the invention.
In a fourth aspect, embodiments of the present invention further provide a computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements a data reconciliation method as described in any of the embodiments of the present invention.
According to the invention, corresponding account checking data are respectively obtained from at least two data sources according to the received data change message; checking account according to the checking account data; if the account checking result is that the account checking is not flat, judging whether the account checking data is missing or not; according to the missing condition of the account checking data, the account checking result information is sent, the problem that false alarm is generated when the account checking result is unreliable due to the missing of the account checking data is solved, and the effect of accurately sending the account checking result information and avoiding false alarm is achieved.
Drawings
FIG. 1 is a flow chart of a data reconciliation method provided in accordance with an embodiment of the invention;
fig. 2 is a flowchart of a data reconciliation method provided in a second embodiment of the invention;
fig. 3 is a data flow chart of a data reconciliation system provided in a second embodiment of the invention;
fig. 4 is a data flow chart of a data reconciliation system provided in accordance with an embodiment of the invention;
fig. 5 is a schematic structural diagram of a data reconciliation device according to a third embodiment of the invention;
fig. 6 is a schematic structural diagram of a reconciliation device according to a fourth embodiment of the invention.
Detailed Description
The invention is described in further detail below with reference to the drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting thereof. It should be further noted that, for convenience of description, only some, but not all of the structures related to the present invention are shown in the drawings.
Example 1
Fig. 1 is a flowchart of a data reconciliation method provided in an embodiment of the present invention, where the method is applicable to avoiding a situation of causing a false alarm when data is missing in real-time reconciliation, and the method may be performed by a data reconciliation device, and the device may be implemented in a software and/or hardware manner, and the device may be integrated in a computer apparatus, as shown in fig. 1, and the method specifically includes:
Wherein, normally events will occur in at least two systems, one system will correspond to two databases, one being the master database, for real business use; the other is a backup database for copying and storing the data of the main database, and the backup database is used when the main database has a problem. When the data is synchronized from the main database to the standby database, a data change message is sent to the reconciliation equipment, and when the reconciliation equipment receives the data change message, corresponding reconciliation data is acquired from a data source corresponding to the system. The data source in the embodiment of the invention can be a backup database of stored data corresponding to the system. The reconciliation data may be data associated with the data sources corresponding to the different systems when the event occurs.
By way of example, the event is a loan repayment event, the loan corresponds to an order system, the repayment corresponds to a billing system, and the order system and billing system each have a master database and a backup database. The data source can be a spare database corresponding to the order system of the loan and the bill system for 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.
The reconciliation device performs a reconciliation operation according to the acquired reconciliation data and preset reconciliation rules, wherein the preset reconciliation rules may be scripts for performing the reconciliation operation. For example, the loan data in the backup database corresponding to the order system may be checked out with the repayment data in the backup database corresponding to the billing system.
And 130, if the checking result is that the checking is not flat, judging whether the checking data is missing or not.
The account checking result can be account checking or account checking unevenness. The account checking device shows that the account checking data accords with a preset account checking rule, and no problem exists; the uneven reconciliation indicates that the reconciliation data does not conform to the preset reconciliation rules, and there are problems that may be caused by missing reconciliation data or may be caused by a problem with the reconciliation data itself. When the account is checked out, the account checking equipment sends an account checking out alarm so that a manager of the system can adjust the system to find out the problems of the system. Therefore, it is normal to send an uneven statement because of uneven statement caused by problems with the accounting data itself. However, since the account checking data is not always in the same time due to the lack of the account checking data, the account checking data may not have a problem, but may be in the same time due to the delay of the account checking data caused by the network problem, the large data volume, etc., the manager of the system is not required to adjust the system, and the situation that the account checking alarm needs to be sent is not considered. In this case, sending an uneven statement may cause a false alarm.
In one implementation manner of the embodiment of the present invention, optionally, determining whether there is a missing reconciliation data includes: judging whether the account checking data obtained from all data sources meet preset account checking rules or not; if the account checking data meets a preset account checking rule, determining that no deletion exists in the account checking data; if the reconciliation data does not meet the preset reconciliation rules, determining that the reconciliation data is missing.
Wherein, from the preset checking rules, checking data required by checking operation can be known, and when the acquired checking data meets the requirement of the preset checking rules, the checking data can be judged to have no loss; when the obtained reconciliation data does not meet the requirement of the preset reconciliation rule, for example, the reconciliation rule requires data of two standby databases, but only data of one standby database is obtained, it can be judged that the reconciliation data is missing.
And 140, sending the reconciliation result information according to the missing condition of the reconciliation data.
When the reconciliation data is not missing, the reconciliation device sends reconciliation result information. For example, the reconciliation result information may be a reconciliation unevenness and a reconciliation unevenness alarm. When the account checking data is missing, the account checking device sends account checking result information. For example, the reconciliation result information may be a reconciliation, where there is a loss of reconciliation data, but no reconciliation alarm is sent. The method can accurately send the account checking alarm, and avoid the situation of false alarm when the account checking result is unreliable due to the lack of account checking data.
According to the technical scheme, corresponding reconciliation data are respectively obtained from at least two data sources according to the received data change message; checking account according to the checking account data; if the account checking result is that the account checking is not flat, judging whether the account checking data is missing or not; according to the missing condition of the account checking data, the account checking result information is sent, the problem of false alarm when the account checking result is unreliable due to the missing of the account checking data is solved, the account checking result information is accurately sent, alarm signals are accurately generated, and the false alarm effect is avoided.
Example two
Fig. 2 is a flowchart of a data reconciliation method provided in a second embodiment of the present invention, where the technical solution in this embodiment is further refined, and the technical solution in this embodiment may be combined with each of the alternatives in one or more embodiments described above.
As shown in fig. 2, the method specifically includes:
Step 230, if the account checking result is that the account checking is not flat, judging whether the account checking data acquired from all data sources meet a preset account checking rule; if the account checking data meets a preset account checking rule, determining that no deletion exists in the account checking data; if the reconciliation data does not meet the preset reconciliation rules, 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 has delay; 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 has delay or not can be checked, if the data source has delay, the reconciliation data will also have delay, the delayed reconciliation data can be marked as delay data, and the subsequent reconciliation of the delay data can be facilitated. Other reasons for missing reconciliation data may be eliminated, for example, if the missing reconciliation data is due to a data delay, the manager of the system may not be required to make an adjustment, but if the missing reconciliation data is due to a system failure, the manager of the system may be required to be notified in time. Therefore, it is necessary to further determine whether the absence of reconciliation data is due to delay in reconciliation data, which may be more accurate in the transmission of reconciliation unevenness alarms.
In one implementation of the embodiment of the present invention, optionally, checking whether there is a delay in a data source corresponding to the missing reconciliation data includes: acquiring change time of reconciliation data from a data source corresponding to the non-missing reconciliation data, and acquiring 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 the data source corresponding to the missing reconciliation data has delay; 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; the change time is the time corresponding to the change of each piece of reconciliation data in the data source; the synchronization time is the time when all data in the data source are synchronously backed up.
Wherein each piece of data has a change time, and the change time of the data is the time for synchronizing the data from the main database to the standby database. The data in the backup database also has a synchronization time, and the synchronization time refers to all data before the synchronization time are synchronized from the master database to the backup database.
When judging whether delay exists in the data source corresponding to the missing reconciliation data, 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 may 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, the billing data corresponding to the billing system is missing, the change time of the billing data corresponding to the order system is 35 minutes at 5 points, and the synchronization time of the backup database corresponding to the billing system is 30 minutes at 5 points. When order system data is changed, billing system data should be changed at the same time. However, when the synchronization time is before the change time and the data of the order system is changed, the data of the billing system is not synchronized from the main database to the standby database, and it can be determined that the billing system has delay, so that the corresponding reconciliation data of the billing system is lost.
If the change time is not after the synchronization time, determining that the data source corresponding to the missing reconciliation data has no delay. For example, the order system and the billing system perform reconciliation operation, the billing data corresponding to the billing system is missing, the change time of the billing data corresponding to the order system is 5 points 35 points, and the synchronization time of the backup database corresponding to the billing system is 5 points 40 points. When order system data is changed, billing system data should be changed at the same time. However, when the synchronization time is after the change time, and the data of the order system is changed, the data of the billing system should be synchronized from the main database to the standby database, instead of the corresponding reconciliation data of the billing system due to the delay of the billing system, it may be determined that the billing system has no delay, and the reconciliation data may be lost due to the fault of the billing system.
Step 250, periodically obtaining the synchronization time of the delay data from the data source corresponding to the delay data at preset time intervals; if the synchronization time of the delay data is after the change time, acquiring the missing reconciliation data from the data source corresponding to the delay data to perform reconciliation operation.
In order to perform checking operation on the delay data, the checking device obtains the synchronization time of the delay data at preset time intervals, and judges whether the delay data can be obtained. 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, namely the missing reconciliation data can be acquired. The checking device acquires missing checking data from the standby database corresponding to the delay data, performs checking operation, and sends an uneven checking alarm when checking is uneven.
According to the technical scheme of the embodiment, corresponding reconciliation data are respectively obtained from at least two data sources according to the received data change message; checking account according to the checking account data; if the account checking result is uneven, judging whether account checking data acquired from all data sources meet preset account checking rules; if the account checking data meets a preset account checking rule, determining that no deletion exists in the account checking data; if the account checking data does not meet the preset account checking rule, determining that the account checking data is missing; if the account checking data is missing, checking whether a data source corresponding to the missing account checking 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 delay data is after the change time, missing account checking data is obtained from a data source corresponding to the delay data to perform account checking operation, so that the problem of false alarm when an account checking result is unreliable due to the delay of the account checking data is solved, accurate sending of account checking result information is realized, an alarm signal is accurately generated, and the false alarm effect is avoided.
Fig. 3 is a data flow chart of a data reconciliation system provided in the second embodiment of the present invention, as shown in fig. 3, in a real-time reconciliation process, a reconciliation device obtains reconciliation data of a plurality of data sources for reconciliation, and performs a reconciliation operation according to the obtained reconciliation data. For example, the reconciliation data 1 of the first data source is acquired, the reconciliation data 2 of the second data source is acquired to be missing, real-time reconciliation is performed, and the reconciliation result is reconciliation unevenness. The checking device can check whether the second data source corresponding to the missing checking data 2 has delay, if the second data source has delay, the checking data 2 corresponding to the second data source is marked as delay data, and the checking result information can be accurately sent without sending the checking unevenness alarm, so that an alarm signal is generated, and false alarm is avoided.
Fig. 4 is a data flow chart of a data reconciliation system provided in the second embodiment of the present invention, as shown in fig. 4, delay data is marked for the reconciliation data with delay in real-time reconciliation, and for the delay data, the reconciliation device checks the synchronization time of the corresponding data source at regular time, if the synchronization time meets the expectations, that is, the synchronization time of the data source corresponding to the delay reconciliation data is after the change time of the non-delay reconciliation data, the delay data reconciliation is triggered, and the reconciliation data with abnormal reconciliation result due to delay in real-time reconciliation is re-reconciled. If the synchronization time does not meet the expectation, the synchronization time of the corresponding data source is continuously checked in a timing way until the synchronization time meets the expectation, and checking operation is carried out. And sending the reconciliation result information according to the reconciliation result, wherein the reconciliation result information can be a reconciliation, or can be a reconciliation unevenness, and sending a reconciliation unevenness alarm when the reconciliation is unevenness. The method can accurately send the account checking result information, accurately generate the alarm signal, avoid false alarm and simultaneously perform account checking operation again on delayed account checking data, and improve the accuracy of account checking results.
Example III
Fig. 5 is a schematic structural diagram of a data reconciliation device according to a third embodiment of the 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 loss judgment module 330 and an information transmission module 340.
The reconciliation data obtaining module 310 is configured to obtain corresponding reconciliation data from at least two data sources according to the received data change message;
the reconciliation operation execution module 320 is configured to perform a reconciliation operation according to the reconciliation data;
the checking data missing judging module 330 is configured to judge whether the checking data is missing if the checking result is that the checking is not flat;
and the information sending module 340 is configured to send a reconciliation failure 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 the data source corresponding to the missing reconciliation data has delay or not if the reconciliation data has the missing;
and the delay data marking unit is used for marking the missing reconciliation data as delay data if the data source corresponding to the missing reconciliation data has delay.
Optionally, the delay checking 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;
a delay determining subunit, configured to determine that there is a delay in the 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 the data source corresponding to the missing reconciliation data;
the change time is the time corresponding to the change of each piece of reconciliation data in the data source; the synchronization time is the time when all data in the data source are synchronously backed up.
Optionally, the reconciliation data absence determining module 330 includes:
the checking data missing judging unit is used for judging whether the checking data acquired from all data sources meet a preset checking rule or not; if the account checking data meets a preset account checking rule, determining that no deletion exists in the account checking data; if the reconciliation data does not meet the preset reconciliation rules, determining that the reconciliation data is missing.
Optionally, the device further includes:
the synchronous time periodic acquisition module is used for periodically acquiring the synchronous time of the delay data from the data source corresponding to the delay data at a preset time interval after marking the missing reconciliation data as the delay data if the delay exists in the data source corresponding to the missing reconciliation data;
and the accounting operation proceeding module is used for obtaining the missing accounting data from the data source corresponding to the delay data to proceed accounting 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 the corresponding functional modules and beneficial effects of the execution method.
Example IV
Fig. 6 is a schematic structural diagram of a reconciliation device according to a fourth embodiment of the invention, as shown in fig. 6, which includes:
one or more processors 410, one processor 410 being illustrated in fig. 6;
a memory 420;
the apparatus may further include: an input device 430 and an output device 440.
The processor 410, memory 420, input means 430 and output means 440 in the apparatus may be connected by a bus or otherwise, in fig. 6 by way of example.
The memory 420 is a non-transitory computer readable storage medium, and may be used to store software programs, computer executable programs, and modules, such as program instructions/modules corresponding to a data reconciliation method in an embodiment of the invention (e.g., the reconciliation data acquisition module 310, the reconciliation operation execution module 320, the reconciliation data loss determination module 330, and the information sending module 340 shown in fig. 5). The processor 410 executes various functional applications of the computer device and data processing by running software programs, instructions and modules stored in the memory 420, i.e. implements a data reconciliation method of the method embodiments described above, namely:
respectively acquiring corresponding reconciliation data from at least two data sources according to the received data change message;
performing reconciliation operation according to the reconciliation data;
if the account checking result is that the account checking is not flat, judging whether the account checking data is missing or not;
and sending the reconciliation result information according to the missing condition of the reconciliation data.
Memory 420 may include a storage program area that may store an operating system, at least one application program required for functionality, and a storage data area; the storage data area may store data created according to the use of the computer device, etc. In addition, 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 means 430 may be used to receive entered numeric or character information and to generate key signal inputs related to user settings and function control of the computer device. The output 440 may include a display device such as a display screen.
Example five
The embodiment of the invention provides a computer readable storage medium, on which a computer program is stored, which when executed by a processor, implements a data reconciliation method as provided by the embodiment of the invention:
respectively acquiring corresponding reconciliation data from at least two data sources according to the received data change message;
performing reconciliation operation according to the reconciliation data;
if the account checking result is that the account checking is not flat, judging whether the account checking data is missing or not;
and sending the reconciliation result information according to the missing condition of the reconciliation 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. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any 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 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.
The computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, either 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 of the foregoing. 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 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 ++ 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 kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computer (for example, through the Internet using an Internet service provider).
Note that the above is only a preferred embodiment of the present invention and the technical principle applied. 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, while the invention has been described in connection with the above embodiments, the invention is not limited to the embodiments, but may be embodied in many other equivalent forms without departing from the spirit or scope of the invention, which is set forth in the following claims.
Claims (6)
1. A method of reconciliation of data, comprising:
respectively acquiring corresponding reconciliation data from at least two data sources according to the received data change message; the data source is a backup database for storing data corresponding to the system; the reconciliation data are data which are associated with each other in data sources corresponding to different systems;
performing reconciliation operation according to the reconciliation data;
if the account checking result is that the account checking is not flat, judging whether the account checking data is missing or not;
sending account checking result information according to the missing condition of the account checking data; and sending reconciliation result information according to the missing condition of the reconciliation data, wherein the method comprises the following steps:
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;
the checking whether the data source corresponding to the missing reconciliation data has delay comprises the following steps:
acquiring change time of reconciliation data from a data source corresponding to the non-missing reconciliation data, and acquiring 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 the data source corresponding to the missing reconciliation data has delay;
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;
wherein, the change time is the corresponding time of each piece of reconciliation data in the data source; the synchronous time is the time for carrying out synchronous backup on all data in the data source.
2. 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 meets a preset reconciliation rule;
if the reconciliation data meets a preset reconciliation rule, determining that the reconciliation data is absent;
if the reconciliation data does not meet the preset reconciliation rules, determining that the reconciliation data is missing.
3. The method of claim 1, wherein after the delay exists for the data source corresponding to the missing reconciliation data, marking the missing reconciliation data as delayed 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.
4. 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 data source is a backup database for storing data corresponding to the system; the reconciliation data are data which are associated with each other in data sources corresponding to different systems;
the checking operation execution module is used for performing checking operation according to the checking data;
the checking data deletion judging module is used for judging whether the checking data is deleted or not if the checking result is that the checking is uneven;
the information sending module is used for sending a reconciliation failure result message according to the missing condition of the reconciliation data;
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 the missing;
a delay data marking unit, configured to mark missing reconciliation data as delay data if there is delay in a data source corresponding to the missing reconciliation data;
the delay checking 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;
a delay determining subunit, 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 the data source corresponding to the missing reconciliation data;
wherein, the change time is the corresponding time of each piece of reconciliation data in the data source; the synchronous time is the time for carrying out synchronous backup on all data in the data source.
5. A reconciliation apparatus comprising:
one or more processors;
storage means for storing one or more programs,
when executed by the one or more processors, causes the one or more processors to implement a data reconciliation method as defined in any one of claims 1-3.
6. A computer readable storage medium, on which a computer program is stored, characterized in that the program, when being executed by a processor, implements a data reconciliation method as defined in any one of claims 1-3.
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 CN111639086A (en) | 2020-09-08 |
| CN111639086B true 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) |
Families Citing this family (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 (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Family Cites Families (1)
| 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 |
-
2020
- 2020-05-26 CN CN202010454417.0A patent/CN111639086B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111639086A (en) | 2020-09-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109344170B (en) | Stream data processing method, system, electronic device and readable storage medium | |
| US9645880B2 (en) | Supportability framework for mobile software applications | |
| US20140075357A1 (en) | Enabling real-time opertional environment conformity to an enterprise model | |
| CN111639086B (en) | Data reconciliation method, device, equipment and storage medium | |
| CN109299124B (en) | Method and apparatus for updating a model | |
| CN109471647B (en) | Data updating method and device, electronic equipment and readable medium | |
| CN114328132A (en) | Method, device, equipment and medium for monitoring state of external data source | |
| CN112130781A (en) | Log printing method and device, electronic equipment and storage medium | |
| US10108474B2 (en) | Trace capture of successfully completed transactions for trace debugging of failed transactions | |
| CN114144761A (en) | Publishing system, pushing method, application device, receiving device and service management device | |
| CN112445860A (en) | Method and device for processing distributed transaction | |
| CN111367934B (en) | Data consistency checking method, device, server and medium | |
| CN110704273B (en) | Processing method and device of configuration information, electronic equipment and storage medium | |
| CN113296796A (en) | Project release method, device, system, storage medium and electronic equipment | |
| CN116701053A (en) | Method, device, equipment and medium for restoring data backup of production environment database | |
| CN113485930B (en) | Business process verification method, device, computer system and readable storage medium | |
| CN112084115B (en) | Method and device for flowsheet operation of software defects | |
| CN107909460B (en) | Position synchronization method, device, data center and storage medium | |
| CN110750424B (en) | Resource inspection method and device | |
| CN112765188A (en) | Configuration information processing method, configuration management system, electronic device, and storage medium | |
| CN111310043B (en) | Method and device for pushing information | |
| KR20190130957A (en) | Apparatus, method and computer program for cloud scrapping using pre-scrapped bigdata | |
| CN113590425B (en) | Data processing method, apparatus, device, medium, and program product | |
| CN115906131B (en) | Data management method, system, equipment and storage medium | |
| US11687441B2 (en) | Intelligent dynamic web service testing apparatus in a continuous integration and delivery environment |
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 |