Data proofreading method and device and readable storage medium

Abstract

The invention discloses a data proofreading method and device and a readable storage medium. The method comprises the steps of obtaining to-be-checked data stored in a transaction host; extracting a transaction type of the to-be-proofreading data from the to-be-proofreading data; based on the transaction type, an account checking strategy of the to-be-checked data is determined, and the account checking strategy is used for indicating a rule for checking the to-be-checked data; based on the account checking strategy, account checking data is obtained from a database, and the account checking data is used for checking the to-be-checked data; according to the reconciliation data and the reconciliation strategy, the data to be proofread is proofread, a proofread result is obtained, and the proofread result is used for indicating the similarity degree between the data to be proofread and the reconciliation data. Through the method and the device, the problem of low data proofreading efficiency in related technologies is solved.

Description

Technical Field

[0001] The present application relates to the field of big data, and in particular, to a data proofreading method, device and readable storage medium. Background Art

[0002] At present, with the requirements of the autonomy of the Internet industry and the advancement of the mainframe under the banking industry, relevant companies have completed the tasks of coordinating account-related applications with the mainframe under the personal settlement account, and have established a group based on a distributed system to provide platform services, and have established the ability to take over the operation and processing of the mainframe. At the same time, they have built core service capabilities in the credit field, including pledge, release, forced sale, loan repayment after forced sale, and fund processing after forced sale. However, due to the high complexity of the system, it is inevitable to encounter various situations such as failure of remote service calls and failure of database preservation, which will lead to data loss or inconsistent data of various service nodes. Especially under the distributed platform, the consistency of transactions and transactions between systems is more complicated, and accounting problems are more likely to occur, and they cannot be discovered and solved in time. The consistency check of business between applications is particularly important.

[0003] In the related technologies, the mainframe-related applications currently mainly rely on batch reconciliation at the end of the day, and the accounting data of the mainframe application and the platform application are relatively isolated. Due to service call failures, empty suspension and other problems, the reconciliation efficiency is low and the processing of doubtful accounts is inaccurate. Therefore, there is a problem of low data proofreading efficiency.

[0004] Currently, no effective solution has been proposed to address the problem of low data proofreading efficiency in related technologies. Summary of the invention

[0005] The main purpose of the present application is to provide a data proofreading method, device and readable storage medium to solve the problem of low data proofreading efficiency in related technologies.

[0006] In order to achieve the above-mentioned purpose, according to one aspect of the present application, a data proofreading method is provided. The method comprises: obtaining the data to be proofread stored in the transaction host; extracting the transaction type of the data to be proofread from the data to be proofread; determining the reconciliation strategy of the data to be proofread based on the transaction type, wherein the reconciliation strategy is used to indicate the rules for proofreading the data to be proofread; obtaining reconciliation data from the database based on the reconciliation strategy, wherein the reconciliation data is used to proofread the data to be proofread; proofreading the data to be proofread according to the reconciliation data and the reconciliation strategy to obtain a proofreading result, wherein the proofreading result is used to indicate the degree of similarity between the data to be proofread and the reconciliation data.

[0007] Optionally, based on the transaction type, determining the reconciliation strategy for the data to be proofread includes: in response to the transaction type being the first transaction type, determining the reconciliation strategy to be a first reconciliation strategy, wherein the first reconciliation strategy is used to indicate a rule for proofreading the data to be proofread using the combined data of two unilateral accounts.

[0008] Optionally, based on the transaction type, determining the reconciliation strategy for the data to be proofread includes: in response to the transaction type being the second transaction type, determining the reconciliation strategy to be the second reconciliation strategy, wherein the second reconciliation strategy is used to indicate rules for proofreading the data to be proofread using the data of the bilateral account.

[0009] Optionally, based on the reconciliation policy, obtaining the reconciliation data from the database includes: determining a reconciliation database based on the reconciliation policy, wherein the reconciliation database is used to store the reconciliation data; and obtaining the reconciliation data from the reconciliation database.

[0010] Optionally, the data to be proofread is proofread according to the reconciliation data and the reconciliation strategy to obtain a proofreading result, including: obtaining a reconciliation template, wherein the reconciliation template is used to indicate a transaction relationship corresponding to the data to be proofread; based on the reconciliation template, the data to be proofread is proofread according to the reconciliation data and the reconciliation strategy to obtain a proofreading result.

[0011] Optionally, the data proofreading method further includes: in response to the proofreading result being an abnormal proofreading result, outputting the proofreading result.

[0012] In order to achieve the above-mentioned purpose, according to another aspect of the present application, a data proofreading device is provided. The device comprises: a first acquisition unit, used to acquire the data to be proofread stored in the transaction host; an extraction unit, used to extract the transaction type of the data to be proofread from the data to be proofread; a determination unit, used to determine the reconciliation strategy of the data to be proofread based on the transaction type, wherein the reconciliation strategy is used to indicate the rules for proofreading the data to be proofread; a second acquisition unit, used to acquire reconciliation data from the database based on the reconciliation strategy, wherein the reconciliation data is used to proofread the data to be proofread; a proofreading unit, used to proofread the data to be proofread according to the reconciliation data and the reconciliation strategy, and obtain a proofreading result, wherein the proofreading result is used to indicate the degree of similarity between the data to be proofread and the reconciliation data.

[0013] In order to achieve the above-mentioned purpose, according to another aspect of the present application, a computer-readable storage medium is provided, which includes a stored program, wherein when the program is executed by a processor, the device where the storage medium is located is controlled to execute the data proofreading method in the embodiment of the present invention.

[0014] In order to achieve the above object, according to another aspect of the present application, an electronic device is provided. A memory stores an executable program; a processor is used to run the program, wherein the data proofreading method in the embodiment of the present invention is executed when the program is run.

[0015] In order to achieve the above-mentioned purpose, according to another aspect of the present application, a computer program product is provided, which includes computer instructions, and when the computer instructions are executed by a processor, the data proofreading method in the embodiment of the present invention is implemented.

[0016] In an embodiment of the present application, data to be proofread stored in a transaction host is obtained; the transaction type of the data to be proofread is extracted from the data to be proofread; based on the transaction type, a reconciliation strategy for the data to be proofread is determined, wherein the reconciliation strategy is used to indicate rules for proofreading the data to be proofread; based on the reconciliation strategy, reconciliation data is obtained from a database, wherein the reconciliation data is used to proofread the data to be proofread; the data to be proofread is proofread according to the reconciliation data and the reconciliation strategy to obtain a proofreading result, wherein the proofreading result is used to indicate a degree of similarity between the data to be proofread and the reconciliation data. Since the present invention can determine the reconciliation strategy according to the transaction type of the data to be proofread stored in the transaction host, thereby proofreading the data to be proofread and the reconciliation data according to the reconciliation strategy, a technical effect of improving data proofreading efficiency is achieved through a variety of reconciliation strategies, and the technical problem of low data proofreading efficiency is solved. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] The drawings constituting a part of the present application are used to provide a further understanding of the present application. The illustrative embodiments and descriptions of the present application are used to explain the present application and do not constitute an improper limitation on the present application. In the drawings:

[0018] Figure 1 It is a hardware structure block diagram of a computer terminal for implementing a data proofreading method provided in an embodiment of the present application;

[0019] Figure 2 is a flow chart of a data proofreading method provided according to an embodiment of the present application;

[0020] Figure 3 is a schematic diagram of a program logic according to an embodiment of the method of the present application;

[0021] Figure 4 It is a flowchart of a general method for multi-platform reconciliation according to an embodiment of the method of the present application;

[0022] Figure 5 is a schematic diagram of a different reconciliation mode according to an embodiment of the method of the present application;

[0023] Figure 6is a schematic diagram of a data proofreading device provided according to an embodiment of the present application;

[0024] Figure 7 It is a structural block diagram of an electronic device provided according to an embodiment of the present application. DETAILED DESCRIPTION

[0025] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present application.

[0026] It should be noted that the terms "first", "second", etc. in the specification and claims of the present application and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchangeable where appropriate, so that the embodiments of the present application described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any of their variations are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device comprising a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0027] It should be noted that the information and data collected in this application are authorized by the user or fully authorized by all parties, and the collection, storage, use, processing, transmission, provision, disclosure and application of relevant data comply with relevant laws, regulations and standards, take necessary confidentiality measures, do not violate public order and good customs, and provide corresponding operation entrances for users to choose to authorize or refuse. For example, an interface is set up between this system and relevant users or institutions to provide users with corresponding operation entrances for users to choose to agree or refuse the results of automated decision-making; if the user chooses to refuse, the expert decision-making process will be entered.

[0028] According to an embodiment of the present application, a data proofreading method embodiment is also provided. It should be noted that the steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, and although a logical order is shown in the flowchart, in some cases, the steps shown or described can be executed in an order different from that shown here.

[0029] The data proofreading method provided in the embodiment of the present application can be executed in a mobile terminal, a computer terminal or a similar computing device. Figure 1 FIG. 1 is a hardware structure block diagram of a computer terminal for implementing a data proofreading method according to an embodiment of the present invention. Figure 1 As shown, the computer terminal 10 (or mobile device) may include one or more (102a, 102b, ..., 102n are used to illustrate) processors 102 (the processor 102 may include but is not limited to a processing device such as a microprocessor MCU or a programmable logic device FPGA), a memory 104 for storing data, and a transmission device 106 for communication functions. In addition, it may also include: a display, an input / output interface (I / O interface), a universal serial bus (USB) port (which may be included as one of the ports of the BUS bus), a network interface, a power supply and / or a camera. It can be understood by those skilled in the art that Figure 1 The structure shown is only for illustration and does not limit the structure of the above electronic device. Figure 1 More or fewer components as shown, or with Figure 1 Different configurations are shown.

[0030] It should be noted that the one or more processors 102 and / or other data processing circuits described above may generally be referred to herein as "data processing circuits". The data processing circuits may be embodied in whole or in part as software, hardware, firmware, or any other combination thereof. In addition, the data processing circuit may be a single independent processing module, or may be incorporated in whole or in part into any of the other components in the computer terminal 10 (or mobile device). As described in the embodiments of the present application, the data processing circuit acts as a processor control (e.g., selection of a variable resistor terminal path connected to an interface).

[0031] The memory 104 can be used to store software programs and modules of application software, such as program instructions / data storage devices corresponding to the data proofreading method in the embodiment of the present application. The processor 102 executes various functional applications and data processing by running the software programs and modules stored in the memory 104, that is, realizing the above-mentioned data proofreading method. The memory 104 may include a high-speed random access memory, and may also include a non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some instances, the memory 104 may further include a memory remotely arranged relative to the processor 102, and these remote memories may be connected to the computer terminal 10 via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0032] The transmission device 106 can be used to receive or send data via a network. The specific example of the above network may include a wireless network provided by a communication provider of the computer terminal 10. In one example, the transmission device 106 includes a network adapter (Network Interface Controller, referred to as NIC), which can be connected to other network devices through a base station so as to communicate with the Internet. In one example, the transmission device 106 can be a radio frequency (RF) module, which is used to communicate with the Internet wirelessly.

[0033] The display may be, for example, a touch screen liquid crystal display (LCD), which enables a user to interact with a user interface of the computer terminal 10 (or mobile device).

[0034] Under the above operating environment, this application provides Figure 2 The proofreading method of the data shown. Figure 2 It is a flow chart of a data proofreading method according to an embodiment of the method of the present application.

[0035] Step S201, obtaining the data to be proofread stored in the transaction host.

[0036] In the technical solution provided in the above step S201 of the present invention, the transaction host may also be referred to as a host, and the data to be proofread may also be referred to as a host file.

[0037] In this embodiment, the data to be proofread stored in the transaction host is obtained, for example, by transmitting and obtaining the data to be proofread through a communication mechanism. This is only an illustrative example and does not limit the specific method of obtaining the data to be proofread stored in the transaction host.

[0038] For example, since the host file communication mechanism supports transmission, and the newly added server application supports the non-recommended direct mounting communication mechanism, the general purpose machine needs to add a general transmission protocol file receiving node, that is, the host file is sent to the communication mechanism, and the communication mechanism is sent to the general transmission protocol file receiving node of the destination machine to obtain the host file.

[0039] Step S202: extracting the transaction type of the data to be proofread from the data to be proofread.

[0040] In the technical solution provided in the above step S202 of the present invention, the transaction types may at least include: forced sale transaction and forced sale followed by replacement transaction.

[0041] In this embodiment, after the data to be proofread stored in the transaction host is acquired in step S201, the transaction type of the data to be proofread is extracted from the data to be proofread. For example, the transaction type field is searched from the data to be proofread, thereby extracting the transaction type of the data to be proofread. This is only an illustrative example, and the specific method of extracting the transaction type of the data to be proofread from the data to be proofread is not limited.

[0042] For example, open the file or database of the data to be collated and find the field or column containing the transaction type. View the data in the field or column to determine the format and location of the transaction type. The transaction type can be presented in the form of text description, code or symbol. Based on the format of the transaction type, use appropriate methods to extract the transaction type information. For example, if the transaction type is presented in the form of text description, you can use text processing functions or regular expressions to extract keywords or phrases. Save the extracted transaction type information to a new field or column for subsequent analysis and processing.

[0043] Step S203: Determine the reconciliation strategy for the data to be verified based on the transaction type.

[0044] In the technical solution provided in the above step S203 of the present invention, the reconciliation strategy is used to indicate the rules for reconciling the data to be reconciled.

[0045] In this embodiment, after extracting the transaction type of the data to be proofread from the data to be proofread in step S202, a reconciliation strategy for the data to be proofread is determined according to the transaction type, wherein the reconciliation strategy may be a unilateral reconciliation strategy or a bilateral reconciliation strategy.

[0046] For example, when the transaction type is a forced sale transaction type, the reconciliation strategy is determined to be a unilateral reconciliation strategy, where the unilateral reconciliation strategy can be that the analysis system related to financial planning and the system related to financial control and accounting provide accounting files, and the destination machine needs to compare the two files to see if the status is consistent. At the same time, as a combining party, it is necessary to compare the two accounting files to see if the accounts are consistent.

[0047] For another example, when the transaction type is forced sale followed by loan repayment, the reconciliation strategy is determined to be a bilateral reconciliation strategy, wherein the bilateral reconciliation strategy may be that the bilateral account interface provider provides an accounting file, and the destination machine only checks the file, and the consistency of the unilateral account is guaranteed by the bilateral account interface provider.

[0048] Optionally, reconciliation strategies can be determined based on specific transaction types, which allows for more efficient verification of data and reduces errors and risks.

[0049] Step S204: based on the reconciliation strategy, obtain reconciliation data from the database.

[0050] In the technical solution provided in the above step S204 of the present invention, the reconciliation data is used to proofread the data to be proofread.

[0051] In this embodiment, after the reconciliation strategy of the data to be checked is determined in step S203, the reconciliation data is obtained from the database according to the reconciliation strategy. The reconciliation data may also be referred to as an accounting file. The database may be a database for storing reconciliation files.

[0052] For example, the accounting file is obtained from a database storing the reconciliation file.

[0053] Step S205: proofread the data to be proofread according to the reconciliation data and the reconciliation strategy to obtain a proofreading result.

[0054] In the technical solution provided in the above step S205 of the present invention, the proofreading result is used to indicate the degree of similarity between the data to be proofread and the reconciliation data.

[0055] In this embodiment, after reconciliation data is obtained from the database in step S204, the data to be reconciled is reconciled according to the reconciliation data and the reconciliation strategy to obtain a reconciliation result. For example, a distributed batch framework is connected, and the batch framework schedules the execution of the reconciliation strategy. This is only an illustrative example, and the specific method of executing the reconciliation strategy is not limited.

[0056] For example, the host reconciliation details are moved to the reconciliation center to trigger reconciliation. The batch execution node transfers the files downloaded by the host to the system used to store and manage files. At the same time, the transaction information in the channel log table and channel failure log table is exported into files and also transferred to the system used to store and manage files. After the files are ready, reconciliation is performed according to the reconciliation strategy and the proofreading results are received.

[0057] It should be noted that the above embodiments can be executed by a data proofreading device.

[0058] In this embodiment, the data to be proofread stored in the transaction host is obtained; the transaction type of the data to be proofread is extracted from the data to be proofread; based on the transaction type, the reconciliation strategy of the data to be proofread is determined, wherein the reconciliation strategy is used to indicate the rules for proofreading the data to be proofread; based on the reconciliation strategy, the reconciliation data is obtained from the database, wherein the reconciliation data is used to proofread the data to be proofread; according to the reconciliation data and the reconciliation strategy, the data to be proofread is proofread to obtain a proofreading result, wherein the proofreading result is used to indicate the degree of similarity between the data to be proofread and the reconciliation data. Since the present invention can determine the reconciliation strategy according to the transaction type of the data to be proofread stored in the transaction host, and thus proofread the data to be proofread and the reconciliation data according to the reconciliation strategy, a technical effect of improving data proofreading efficiency is achieved through a variety of reconciliation strategies, and the technical problem of low data proofreading efficiency is solved.

[0059] The above method of this embodiment is further introduced below.

[0060] As an optional implementation mode, in the data proofreading method provided in the embodiment of the present application, based on the transaction type, the reconciliation strategy of the data to be proofread is determined, including: in response to the transaction type being a first transaction type, determining the reconciliation strategy to be a first reconciliation strategy, wherein the first reconciliation strategy is used to indicate the rules for proofreading the data to be proofread using the combined data of two unilateral accounts.

[0061] In this embodiment, when the transaction type is the first transaction type, the reconciliation strategy is determined to be the first reconciliation strategy. The first transaction type may be a forced sale transaction, and the first reconciliation strategy may be a unilateral reconciliation strategy.

[0062] For example, the first reconciliation strategy is to provide accounting files from a database storing reconciliation files. The destination machine needs to compare the two files, that is, whether the combined data of the two unilateral accounts are consistent. At the same time, as the combining party, it is necessary to compare the two accounting files to see whether the accounts are consistent.

[0063] Optionally, by selecting a corresponding reconciliation strategy based on the specific transaction type, you can check the data more accurately and reduce the possibility of errors.

[0064] As an optional implementation method, in the data proofreading method provided in the embodiment of the present application, the reconciliation strategy for the data to be proofread is determined based on the transaction type, including: in response to the transaction type being a second transaction type, determining that the reconciliation strategy is a second reconciliation strategy, wherein the second reconciliation strategy is used to indicate the rules for proofreading the data of the bilateral account with the data to be proofread.

[0065] In this embodiment, when the transaction type is the second transaction type, the reconciliation strategy is determined to be the second reconciliation strategy, wherein the second transaction type may be forced sale followed by loan repayment, and the second reconciliation strategy may be a bilateral reconciliation strategy.

[0066] For example, the second reconciliation strategy is that the bilateral account interface provider provides the accounting file, and the destination machine only checks with the file, and the consistency of the unilateral account is guaranteed by the bilateral account interface provider.

[0067] Optionally, by selecting an appropriate reconciliation strategy, you can more effectively monitor the risks of transactions, detect abnormal situations in a timely manner and take measures. At the same time, different reconciliation strategies can check data from different angles, helping to ensure the integrity and reliability of the data.

[0068] As an optional implementation method, in the data proofreading method provided in the embodiment of the present application, reconciliation data is obtained from the database based on the reconciliation strategy, including: determining a reconciliation database based on the reconciliation strategy, wherein the reconciliation database is used to store the reconciliation data; and obtaining the reconciliation data from the reconciliation database.

[0069] In this embodiment, the reconciliation database is determined according to the reconciliation strategy, so as to obtain the reconciliation data from the reconciliation database. For example, the reconciliation database may be a database storing reconciliation files.

[0070] Optionally, the reconciliation data is obtained through a reconciliation database to ensure the accuracy and completeness of the reconciliation data, wherein the reconciliation database is a database specifically used to store reconciliation data, which can ensure the accuracy and completeness of the data and reduce the occurrence of errors and omissions.

[0071] As an optional implementation method, in the data proofreading method provided in the embodiment of the present application, the data to be proofread is proofread according to the reconciliation data and the reconciliation strategy to obtain the proofreading result, including: obtaining a reconciliation template, wherein the reconciliation template is used to indicate the transaction relationship corresponding to the data to be proofread; based on the reconciliation template, the data to be proofread is proofread according to the reconciliation data and the reconciliation strategy to obtain the proofreading result.

[0072] In this embodiment, a reconciliation template is obtained. For example, reconciliation is performed according to different business scenarios and different reconciliation templates. According to the reconciliation template, the data to be proofread is proofread according to the reconciliation data and the reconciliation strategy to obtain a proofreading result.

[0073] Optionally, the reconciliation template may clearly indicate the debit and credit relationships of the data to be proofread, which helps the proofreader to accurately check the data and avoid errors.

[0074] As an optional implementation manner, in the data proofreading method provided in the embodiment of the present application, the data proofreading method further includes: in response to the proofreading result being an abnormal proofreading result, outputting the proofreading result.

[0075] In this embodiment, when the proofreading result is a proofreading abnormality, the proofreading result is output, for example, a proofreading file is received, and the proofreading file is checked for abnormal information, and if there is abnormal information, a monitoring alarm is issued.

[0076] Optionally, timely alarms can enable relevant personnel to quickly locate the problem and take correct measures to resolve it, thereby improving work efficiency.

[0077] It should be noted that the above embodiments can be executed by a data proofreading device.

[0078] The data proofreading method provided in the embodiment of the present application obtains the data to be proofread stored in the transaction host; extracts the transaction type of the data to be proofread from the data to be proofread; determines the reconciliation strategy of the data to be proofread based on the transaction type, wherein the reconciliation strategy is used to indicate the rules for proofreading the data to be proofread; obtains the reconciliation data from the database based on the reconciliation strategy, wherein the reconciliation data is used to proofread the data to be proofread; proofreads the data to be proofread according to the reconciliation data and the reconciliation strategy to obtain a proofreading result, wherein the proofreading result is used to indicate the degree of similarity between the data to be proofread and the reconciliation data. Since the present invention can determine the reconciliation strategy according to the transaction type of the data to be proofread stored in the transaction host, and thus proofreads the data to be proofread and the reconciliation data according to the reconciliation strategy, a technical effect of improving data proofreading efficiency is achieved through a variety of reconciliation strategies, and the technical problem of low data proofreading efficiency is solved.

[0079] The technical solution of the embodiment of the present invention is illustrated below in conjunction with preferred implementation modes.

[0080] At present, with the requirements of the autonomy of the Internet industry and the advancement of the mainframe under the banking industry, relevant companies have completed the tasks of coordinating account-related applications with the mainframe under the personal settlement account, and have established a group based on a distributed system to provide platform services, and have established the ability to take over the operation and processing of the mainframe. At the same time, they have built core service capabilities in the credit field, including pledge, release, forced sale, loan repayment after forced sale, and fund processing after forced sale. However, due to the high complexity of the system, it is inevitable to encounter various situations such as failure of remote service calls and failure of database preservation, which will lead to data loss or inconsistent data of various service nodes. Especially under the distributed platform, the consistency of transactions and transactions between systems is more complicated, and accounting problems are more likely to occur, and they cannot be discovered and solved in time. The consistency check of business between applications is particularly important.

[0081] In one implementation, host-related applications mainly rely on batch reconciliation at the end of the day, and the account data of the host application and the platform application are relatively isolated. Due to service call failures, empty suspensions and other issues, the reconciliation efficiency is low and the processing of doubtful accounts is inaccurate. Therefore, there is a problem of low data proofreading efficiency. With respect to the problem of low data proofreading efficiency in related technologies, no effective solution has been proposed so far.

[0082] However, an embodiment of the present invention proposes a general method for multi-platform reconciliation, in which the business data that needs to be reconciled is transmitted to the reconciliation center through a message gateway and a message queue, and the reconciliation center returns the reconciliation result in the form of a return file; thereby achieving the technical effect of improving data proofreading efficiency and solving the technical problem of low data proofreading efficiency.

[0083] The embodiments of the present invention are further described below.

[0084] Figure 3 is a schematic diagram of a program logic according to an embodiment of the method of the present application, such as Figure 3 As shown in the figure, the main logic is: host / platform file download---> batch execution node moves files on the communication mechanism node to the system used to store and manage files, and generates channel log files at the same time---> message queue notifies the reconciliation center that the file is ready and starts reconciliation---> reconciliation---> reconciliation result generation---> message notification of reconciliation completion, reconciliation result analysis---> call the doubtful account processing mechanism or transfer to manual processing.

[0085] In this embodiment, S1 represents file downloading, S2 represents file writing, S3 represents message notification, S4 represents message reception, S5 represents file reading, S6 represents account reconciliation, S7 represents account reconciliation result, S8 represents return analysis, and S9 represents doubtful account handling.

[0086] Figure 4 is a flowchart of a general method for multi-platform reconciliation according to an embodiment of the method of the present application, such as Figure 4 As shown, the general method for multi-platform reconciliation includes the following steps:

[0087] Step S401, downloading host files.

[0088] In this embodiment, the following mode: the host file only supports communication mechanism transmission, and the newly added server application supports the direct mounting communication mechanism, so the destination machine needs to add a general transmission protocol file receiving node.

[0089] Optionally, the host file is downloaded to the communication mechanism, and the communication mechanism is downloaded to a universal transfer protocol file receiving node of the destination machine.

[0090] Optionally, the host application applies for a source communication mechanism interface---> the destination machine applies for a target communication mechanism interface---> the destination machine applies for a universal transmission protocol node, a universal transmission protocol directory, and a universal transmission protocol task (type is a receiving communication mechanism task, and the original communication mechanism is the target communication mechanism interface applied for in the previous step).

[0091] Optionally, the communication mechanism is a mechanism for inter-process communication on the same host by creating a special type of file in the file system through which the processes can communicate. The communication mechanism supports efficient data transfer and communication between processes on the same host.

[0092] Alternatively, the destination machine may be a general-purpose machine that can perform a variety of different tasks. The universal transfer protocol is a universal transfer protocol used to transfer files and data between different computers. Therefore, it is necessary to add a universal transfer protocol file receiving node on the destination machine, which means that a universal transfer protocol node for receiving files needs to be added on the general-purpose machine. In this way, files and data can be easily transferred between different computers.

[0093] Step S402, reconciliation mode.

[0094] In this embodiment, different files are generated according to different settlement interface account processing: divided into calling a unilateral interface (forced sale) and calling a bilateral interface (repaying the loan after forced sale).

[0095] Optionally, Figure 5 is a schematic diagram of a different reconciliation mode according to an embodiment of the method of the present application, such as Figure 5 As shown, two unilateral account interfaces are combined: the database storing the reconciliation file provides the accounting file, and the destination machine needs to compare the two files to see if the status is consistent. At the same time, as the combining party, the two accounting files need to be compared to see if the accounts are consistent.

[0096] Optionally, the bilateral account interface is directly called: the bilateral account interface provider provides the accounting file, the destination machine only checks with the file, and the consistency of the unilateral account is guaranteed by the bilateral account interface provider.

[0097] Alternatively, a forced sell transaction refers to an investor selling a stock or other security in the market without sufficient funds to cover the cost of the transaction. This type of transaction usually results in the investor being forced to close their position, that is, being forced to liquidate their position by the exchange to make up for the lack of funds.

[0098] Alternatively, forced selling and replacement trading means that after the investor is forced to close the position, the exchange will help the investor find other stocks or securities to replace the original position to make up for the lack of funds. This kind of transaction usually occurs in the stock market or futures market and is a remedy for investors.

[0099] Optionally, when checking documents, it is necessary to confirm whether the forced sale transaction and the forced sale and replacement transaction are carried out in accordance with the regulations, and it is necessary to ensure that the relevant documents are recorded accurately. If there are any questions or unclear points, you should contact the relevant department or person in charge in time to ensure the compliance and accuracy of the transaction.

[0100] Alternatively, unilateral account and bilateral account are two commonly used accounting methods in accounting, which represent different accounting methods and processing methods. Unilateral account: Unilateral account refers to an accounting method in which only one account has changed, and there is no corresponding offset account. In a unilateral account, only the debit or credit changes of one account are recorded, and there is no corresponding offset account. Unilateral account is suitable for some relatively simple transactions or accounts, such as cash receipts and payments, fixed asset purchases, etc.

[0101] Optionally, double-sided bookkeeping: Double-sided bookkeeping is a bookkeeping method that records the debit and credit changes of two accounts at the same time to ensure that the accounting equation is always balanced. In a double-sided bookkeeping, each transaction involves two accounts at the same time. When the debit side of one account changes, the credit side of the other account will also change accordingly to ensure that the debit and credit balance. Double-sided bookkeeping is a more complete and accurate bookkeeping method in accounting, which is suitable for most accounting transactions and account processing.

[0102] Step S403: batch scheduling.

[0103] In this embodiment, a distributed batch framework is accessed and scheduled for execution by the batch framework, and the host reconciliation details send a message to the reconciliation center to trigger reconciliation.

[0104] Optionally, the batch controller is the manager responsible for job scheduling and job execution process control in the batch system. It is the brain of the batch framework and the core of job scheduling. The main functions are: generating jobs to be executed daily; arranging job execution plans; triggering job runs (currently supports scheduled (automatic) and dependent); monitoring job execution progress, updating job execution results based on job feedback; job load balancing; monitoring alarms.

[0105] Optionally, the batch executor is a manager in the batch system responsible for receiving the job scheduling instructions initiated by the controller and is the recipient of the batch job. After receiving the controller instruction, the executor interprets the instruction; according to the job instance information, instruction type, etc. in the instruction, it creates a processor instance object and executes the corresponding instruction.

[0106] Step S404: access the reconciliation center.

[0107] In this embodiment, the batch execution node transfers the files downloaded from the host to the system for storing and managing files, and at the same time exports the transaction information in the channel log table and the channel failure log table into files, which are also transferred to the system for storing and managing files. After the files are ready, the message queue is sent to start reconciliation.

[0108] Optionally, compare the status field dictionary according to the reconciliation condition example table configured in the reconciliation center:

[0109] / ***1-Unknown* / UNKNOWN(1,"Unknown or in process"), / ***2-Success (can only change from 1 to 2)* / SUCCESS(2,"Success"), / ***3-Failure (can only change from 1 to 3)* / FAIL(3,"Failure"), / ***4-Framework rollback (can only change from 2 to 4)* / REVERSE(4,"Framework rollback").

[0110] Optionally, by receiving a return file with a return message, check whether the return file has abnormal information, and if so, monitor and alarm.

[0111] Alternatively, timely alarms can allow us to quickly locate problems and take correct measures to solve them, thereby improving work efficiency. At the same time, by checking abnormal alarms, relevant personnel can deal with problems in a timely manner to avoid causing greater losses.

[0112] Step S405, receiving the return file from the reconciliation center.

[0113] In this embodiment, after the consumer switch is turned on, the message queue is monitored.

[0114] Optionally, the reconciliation date needs to be consistent with the date in the file name or directory, otherwise the verification fails. The reconciliation result status is: 0-no error, 1-error, 2-processing, 3-file check failed. When the status is equal to 0 or 1, the template number is not empty, when the status is equal to 2, the template number is empty, and when the status is equal to 3, the template number is non-empty under specific conditions.

[0115] Step S406, error account analysis and doubtful account processing.

[0116] In this embodiment, the format of the return file is: tenant identifier_first file name_period_serial number@tenant identifier_second file name_period_serial number_RST.ZIP.

[0117] Optionally, tenant ID: same as agreed upon by the middle office.

[0118] First file name and second file name: generally have business meanings and are defined by the application.

[0119] Optionally, zip the file inside the file format:

[0120] The error file based on the first file is: tenant ID_first file name_YYYYMMDD_serial number.DIFF.

[0121] The files are compared based on the first file: tenant ID_first file name_YYYYMMDD_serial number.SAME.

[0122] The error file based on the second file is: tenant ID_second file name_YYYYMMDD_serial number.DIFF.

[0123] The files are compared based on the second file: tenant ID_second file name_YYYYMMDD_serial number.SAME.

[0124] In this embodiment, the business data that needs to be reconciled is transmitted to the reconciliation center through the message gateway and message queue, and the reconciliation center returns the reconciliation result in the form of a return file; thereby achieving the technical effect of improving data proofreading efficiency and solving the technical problem of low data proofreading efficiency.

[0125] The embodiment of the present application also provides a data proofreading device. It should be noted that the data proofreading device of the embodiment of the present application can be used to execute the data proofreading method provided by the embodiment of the present application. The data proofreading device provided by the embodiment of the present application is introduced below.

[0126] Figure 6 is a schematic diagram of a data proofreading device provided according to an embodiment of the present application, such as Figure 6 As shown, the data proofreading device 600 includes: a first acquisition unit 601 , an extraction unit 602 , a determination unit 603 , a second acquisition unit 604 and a proofreading unit 605 .

[0127] The first acquisition unit 601 is used to acquire the data to be proofread stored in the transaction host.

[0128] The extraction unit 602 is used to extract the transaction type of the data to be proofread from the data to be proofread.

[0129] The determination unit 603 is used to determine a reconciliation policy for the data to be verified based on the transaction type, wherein the reconciliation policy is used to indicate a rule for verifying the data to be verified.

[0130] The second acquisition unit 604 is used to acquire reconciliation data from the database based on the reconciliation strategy, wherein the reconciliation data is used to collate the data to be reconciled.

[0131] The proofreading unit 605 is used to proofread the data to be proofread according to the reconciliation data and the reconciliation strategy to obtain a proofreading result, wherein the proofreading result is used to indicate the degree of similarity between the data to be proofread and the reconciliation data.

[0132] The data proofreading device provided in the embodiment of the present application obtains the data to be proofread stored in the transaction host; extracts the transaction type of the data to be proofread from the data to be proofread; determines the reconciliation strategy of the data to be proofread based on the transaction type, wherein the reconciliation strategy is used to indicate the rules for proofreading the data to be proofread; obtains the reconciliation data from the database based on the reconciliation strategy, wherein the reconciliation data is used to proofread the data to be proofread; proofreads the data to be proofread according to the reconciliation data and the reconciliation strategy to obtain a proofreading result, wherein the proofreading result is used to indicate the degree of similarity between the data to be proofread and the reconciliation data. Since the present invention can determine the reconciliation strategy according to the transaction type of the data to be proofread stored in the transaction host, and thus proofreads the data to be proofread and the reconciliation data according to the reconciliation strategy, a technical effect of improving data proofreading efficiency is achieved through a variety of reconciliation strategies, and the technical problem of low data proofreading efficiency is solved.

[0133] Optionally, in the data proofreading device provided in the embodiment of the present application, the determination unit 603 may include: a first determination module, used to determine that the reconciliation strategy is a first reconciliation strategy in response to the transaction type being the first transaction type, wherein the first reconciliation strategy is used to indicate a rule for proofreading the combined data of two unilateral accounts with the data to be proofread.

[0134] Optionally, in the data proofreading device provided in the embodiment of the present application, the determination unit 603 may include: a second determination module, used to determine that the reconciliation strategy is a second reconciliation strategy in response to the transaction type being a second transaction type, wherein the second reconciliation strategy is used to indicate rules for proofreading the data of the bilateral account with the data to be proofread.

[0135] Optionally, in the data proofreading device provided in the embodiment of the present application, the second acquisition unit 604 may include: a third determination module, used to determine a reconciliation database based on a reconciliation strategy, wherein the reconciliation database is used to store reconciliation data; and a first acquisition module, used to obtain reconciliation data from the reconciliation database.

[0136] Optionally, in the data proofreading device provided in the embodiment of the present application, the third determination unit 603 may include: a second acquisition module, used to acquire a reconciliation template, wherein the reconciliation template is used to indicate a transaction relationship corresponding to the data to be proofread; a proofreading module, used to proofread the data to be proofread based on the reconciliation template, according to the reconciliation data and the reconciliation strategy, to obtain a proofreading result.

[0137] Optionally, in the data proofreading device provided in the embodiment of the present application, the data proofreading device 600 may include: an output unit, configured to output the proofreading result in response to the proofreading result being an abnormal proofreading result.

[0138] It should be noted that the above-mentioned determination module 100 and sending module 102 correspond to steps S201 to S203 in the method embodiment, and the examples and application scenarios implemented by the two modules and the corresponding steps are the same, but are not limited to the contents disclosed in the above-mentioned embodiment 1. It should be noted that the above-mentioned modules or units can be hardware components or software components stored in a memory (e.g., memory 104) and processed by one or more processors (e.g., processors 102a, 102b, ..., 102n), and the above-mentioned modules can also be run in the computer terminal 10 provided in the embodiment 1 as part of the device.

[0139] An embodiment of the present application may provide an electronic device, Figure 7 is a structural block diagram of an electronic device provided according to an embodiment of the present application. Figure 7 As shown, the electronic device may include: one or more ( Figure 7 (only one is shown) processor 1002, memory 1004, storage controller, and peripheral interface, wherein the peripheral interface is connected to the radio frequency module, audio module and display.

[0140] Among them, the memory can be used to store software programs and modules, such as program instructions / modules corresponding to the methods and devices in the embodiments of the present application, and the processor executes various functional applications and data processing by running the software programs and modules stored in the memory, that is, realizing the above-mentioned method. The memory may include a high-speed random access memory, and may also include a non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some instances, the memory may further include a memory remotely arranged relative to the processor, and these remote memories may be connected to the terminal via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0141] The processor can call the information and application stored in the memory through the transmission device to perform the following steps: obtain the data to be proofread stored in the transaction host; extract the transaction type of the data to be proofread from the data to be proofread; determine the reconciliation strategy of the data to be proofread based on the transaction type, wherein the reconciliation strategy is used to indicate the rules for proofreading the data to be proofread; obtain the reconciliation data from the database based on the reconciliation strategy, wherein the reconciliation data is used to proofread the data to be proofread; proofread the data to be proofread according to the reconciliation data and the reconciliation strategy to obtain the proofreading result, wherein the proofreading result is used to indicate the degree of similarity between the data to be proofread and the reconciliation data.

[0142] The processor can also call the information and application stored in the memory through the transmission device to perform the following steps: in response to the transaction type being the first transaction type, determine that the reconciliation strategy is the first reconciliation strategy, wherein the first reconciliation strategy is used to indicate the use of the combined data of the two unilateral accounts and the data to be proofread for proofreading.

[0143] The processor can also call the information and application stored in the memory through the transmission device to perform the following steps: in response to the transaction type being the second transaction type, determine that the reconciliation strategy is the second reconciliation strategy, wherein the second reconciliation strategy is used to indicate the use of bilateral account data and the data to be reconciled for reconciliation.

[0144] The processor may also call the information and application programs stored in the memory through the transmission device to perform the following steps: based on the reconciliation strategy, determine a reconciliation database, wherein the reconciliation database is used to store reconciliation data; and obtain the reconciliation data from the reconciliation database.

[0145] The processor can also call the information and application stored in the memory through the transmission device to perform the following steps: obtain a reconciliation template, wherein the reconciliation template is used to indicate the debit and credit relationship corresponding to the data to be proofread; based on the reconciliation template, according to the reconciliation data and the reconciliation strategy, proofread the data to be proofread to obtain the proofreading result.

[0146] The processor may also call the information and application program stored in the memory through the transmission device to perform the following steps: in response to the proofreading result being a proofreading abnormality, output the proofreading result.

[0147] By adopting the embodiment of the present application, a data proofreading method is provided. The data to be proofread stored in the transaction host is obtained; the transaction type of the data to be proofread is extracted from the data to be proofread; based on the transaction type, the reconciliation strategy of the data to be proofread is determined, wherein the reconciliation strategy is used to indicate the rules for proofreading the data to be proofread; based on the reconciliation strategy, the reconciliation data is obtained from the database, wherein the reconciliation data is used to proofread the data to be proofread; according to the reconciliation data and the reconciliation strategy, the data to be proofread is proofread to obtain a proofreading result, wherein the proofreading result is used to indicate the degree of similarity between the data to be proofread and the reconciliation data. Since the present invention can determine the reconciliation strategy according to the transaction type of the data to be proofread stored in the transaction host, and thus proofread the data to be proofread and the reconciliation data according to the reconciliation strategy, a technical effect of improving the efficiency of data proofreading is achieved through multiple reconciliation strategies, and the technical problem of low efficiency of data proofreading is solved.

[0148] Figure 7 is a structural block diagram of an electronic device provided according to an embodiment of the present application. A person skilled in the art can understand that Figure 7The structure shown is for illustration only, and the electronic device may also be a smart phone (such as an Android phone, an iOS phone, etc.), a tablet computer, a PDA, a mobile Internet device (Mobile Internet Devices, MID), a PAD, or other terminal devices. Figure 7 The structure of the electronic device is not limited. Figure 7 More or fewer components (such as network interfaces, display devices, etc.) shown in, or having Figure 7 Different configurations shown.

[0149] A person of ordinary skill in the art can understand that all or part of the steps in the various methods of the above embodiments can be completed by instructing the hardware related to the terminal device through a program, and the program can be stored in a computer-readable storage medium, and the storage medium may include: a flash drive, a read-only memory (ROM), a random access memory (RAM), a disk or an optical disk, etc.

[0150] According to an embodiment of the present invention, a processor is further provided. The processor is used to run a program, wherein the program executes the data proofreading method in the embodiment when the program is run by the processor.

[0151] According to an embodiment of the present invention, there is further provided an electronic device, comprising: a memory storing an executable program; and a processor for running the program, wherein the data proofreading method in the embodiment is executed when the program is running.

[0152] According to another aspect of the present invention, a computer-readable storage medium is provided, wherein the computer-readable storage medium includes a stored program, wherein when the program is executed, the device where the computer-readable storage medium is located is controlled to execute the data proofreading method in the embodiment.

[0153] According to an embodiment of the present invention, a computer program product is further provided. The computer program product includes a computer program. When the computer program is executed by a processor, the data proofreading method in the embodiment is implemented.

[0154] According to an embodiment of the present invention, a computer program product is also provided, including a non-volatile computer-readable storage medium, the non-volatile computer-readable storage medium is used to store a computer program, and when the computer program is executed by a processor, the data proofreading method in the embodiment is implemented.

[0155] According to an embodiment of the present invention, a computer program is further provided. When the computer program is executed by a processor, the data proofreading method in the embodiment is implemented.

[0156] The serial numbers of the above-mentioned embodiments of the present application are for description only and do not represent the advantages or disadvantages of the embodiments.

[0157] In the above embodiments of the present application, the description of each embodiment has its own emphasis. For parts that are not described in detail in a certain embodiment, please refer to the relevant description of other embodiments.

[0158] In the several embodiments provided in this application, it should be understood that the disclosed technical content can be implemented in other ways. Among them, the device embodiments described above are only schematic, for example, the division of units is only a logical function division, and there may be other division methods in actual implementation, for example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of units or modules, which can be electrical or other forms.

[0159] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0160] In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.

[0161] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, or the part that contributes to the relevant technology, or all or part of the technical solution can be embodied in the form of a software product. The computer software product is stored in a storage medium, including several instructions for a computer device (which can be a personal computer, server or network device, etc.) to perform all or part of the steps of the methods of various embodiments of the present invention. The aforementioned storage medium includes: U disk, ROM, RAM, mobile hard disk, disk or optical disk and other media that can store program codes.

[0162] The above are only preferred implementations of the present application. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principles of the present application. These improvements and modifications should also be regarded as the scope of protection of the present application.

Claims

1. A data proofreading method, characterized in that: include: Obtain the data to be proofread stored in the trading host; Extracting the transaction type of the data to be proofread from the data to be proofread; Determining, based on the transaction type, a reconciliation policy for the data to be proofread, wherein the reconciliation policy is used to indicate a rule for proofreading the data to be proofread; Based on the reconciliation strategy, reconciliation data is obtained from a database, wherein the reconciliation data is used to check the data to be checked; The data to be proofread is proofread according to the reconciliation data and the reconciliation strategy to obtain a proofreading result, wherein the proofreading result is used to indicate the degree of similarity between the data to be proofread and the reconciliation data.

2. The method according to claim 1, characterized in that Determining a reconciliation strategy for the data to be verified based on the transaction type includes: In response to the transaction type being the first transaction type, the reconciliation strategy is determined to be the first reconciliation strategy, wherein the first reconciliation strategy is used to indicate a rule for performing reconciliation with the data to be reconciled using combined data of two unilateral accounts.

3. The method according to claim 1, characterized in that Determining a reconciliation strategy for the data to be verified based on the transaction type includes: In response to the transaction type being the second transaction type, the reconciliation strategy is determined to be a second reconciliation strategy, wherein the second reconciliation strategy is used to indicate a rule for reconciling the data to be reconciled with the data of the bilateral account.

4. The method according to claim 1, characterized in that: Based on the reconciliation strategy, reconciliation data is obtained from the database, including: Based on the reconciliation strategy, determining a reconciliation database, wherein the reconciliation database is used to store the reconciliation data; The reconciliation data is obtained from the reconciliation database.

5. The method according to claim 1, characterized in that Proofreading the data to be proofread according to the reconciliation data and the reconciliation strategy to obtain a proofreading result includes: Obtaining a reconciliation template, wherein the reconciliation template is used to indicate a transaction relationship corresponding to the data to be checked; Based on the reconciliation template, the data to be proofread is proofread according to the reconciliation data and the reconciliation strategy to obtain a proofreading result.

6. The method according to claim 1, characterized in that The method further comprises: In response to the proofreading result being an abnormal proofreading result, the proofreading result is outputted.

7. A data proofreading device, characterized in that: include: A first acquisition unit, used for acquiring the data to be proofread stored in the transaction host; An extraction unit, used for extracting the transaction type of the data to be proofread from the data to be proofread; A determining unit, configured to determine a reconciliation policy for the data to be proofread based on the transaction type, wherein the reconciliation policy is used to indicate a rule for proofreading the data to be proofread; A second acquisition unit, configured to acquire reconciliation data from a database based on the reconciliation strategy, wherein the reconciliation data is used to check the data to be checked; A proofreading unit is used to proofread the data to be proofread according to the reconciliation data and the reconciliation strategy to obtain a proofreading result, wherein the proofreading result is used to indicate a similarity check between the data to be proofread and the reconciliation data.

8. A computer-readable storage medium, characterized in that: The computer-readable storage medium includes a stored executable program, wherein when the executable program is executed, the device where the computer-readable storage medium is located is controlled to execute the method according to any one of claims 1 to 6.

9. An electronic device, characterized in that: include: A memory storing an executable program; A processor, configured to run the program, wherein the program executes the method according to any one of claims 1 to 6 when running.

10. A computer program product comprising computer instructions, characterized in that: When the computer instructions are executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

Images