CN115563943A - Report processing method, device, equipment and storage medium - Google Patents

Report processing method, device, equipment and storage medium Download PDF

Info

Publication number
CN115563943A
CN115563943A CN202211193594.3A CN202211193594A CN115563943A CN 115563943 A CN115563943 A CN 115563943A CN 202211193594 A CN202211193594 A CN 202211193594A CN 115563943 A CN115563943 A CN 115563943A
Authority
CN
China
Prior art keywords
transaction
data
report
information
interface
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202211193594.3A
Other languages
Chinese (zh)
Inventor
翁明俊
赵文武
王一甲
王超
靳彬
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Bank of China Ltd
Original Assignee
Bank of China Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Bank of China Ltd filed Critical Bank of China Ltd
Priority to CN202211193594.3A priority Critical patent/CN115563943A/en
Publication of CN115563943A publication Critical patent/CN115563943A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/174—Form filling; Merging
    • 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
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/20—Natural language analysis
    • G06F40/205—Parsing

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention relates to the technical field of data processing, in particular to a report processing method, a report processing device, report processing equipment and a storage medium, wherein the report processing method comprises the following steps: receiving a plurality of reports sent by an upstream transaction system; analyzing the content of each report to obtain data in each report and storing all the data of each report in a corresponding interface table; selecting an interface table as an execution table, sequentially selecting a piece of data from the execution table as first data according to the sequence of the data, and determining second data from other interface tables according to a transaction primary key of the first data; merging the first data and the second data to obtain transaction proofreading information; and comparing the transaction information corresponding to the transaction key recorded by the downstream transaction system with the transaction verification information, and if the transaction information is the same as the transaction verification information, successfully verifying the transaction information. By the embodiment of the invention, the data of a plurality of reports of the upstream transaction system are integrated to obtain the transaction checking information, and the problem of low efficiency of extracting the transaction information in the upstream report in the prior art is solved.

Description

Report processing method, device, equipment and storage medium
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method, an apparatus, a device, and a storage medium for processing a report.
Background
This section is intended to provide a background or context to the embodiments of the invention that are recited in the claims. The description herein is not admitted to be prior art by inclusion in this section.
Currently, the fund pool transaction check needs to compare a report form recorded in batch by an upstream system with transaction information recorded in a downstream system, but transaction detail information of the upstream system is dispersed in a plurality of different report forms, for example, transaction data of the same type is recorded in one report form, and the report form is stored in the upstream system in a text form. When the report information is required to be corrected, the multiple reports of the upstream system are sent to the downstream system, the downstream system extracts information belonging to the same transaction from the multiple reports, then integrates the extracted information to obtain transaction correction information, then compares the transaction correction information with the transaction information recorded by the downstream system, and if the transaction correction information is the same as the transaction information recorded by the downstream system, the report information is corrected successfully.
In the prior art, when information belonging to the same transaction is extracted, the unique identification of the transaction needs to be used for searching in a plurality of reports, and the searching efficiency is low.
A report processing method is needed to solve the problem of low efficiency of extracting transaction information in an upstream report in the prior art.
Disclosure of Invention
In order to solve the problems in the prior art, embodiments of the present invention provide a report processing method and apparatus, which implement fast integration of data in multiple reports sent by multiple upper transaction systems according to a transaction key of a transaction to obtain transaction checking information of the transaction, and then compare the transaction checking information with transaction information of the transaction stored in a downstream transaction system, thereby checking the transaction information of the downstream transaction system and solving the problem of low efficiency in extracting transaction information in an upstream report in the prior art.
In order to solve the technical problems, the specific technical scheme of the invention is as follows:
the embodiment of the invention provides a report processing method, which comprises the following steps:
receiving a plurality of reports sent by an upstream trading system, wherein each report comprises data of the same element item of a plurality of trades;
analyzing the content of each report to obtain data in each report and storing all the data of each report in a corresponding interface table;
selecting an interface table as an execution table, sequentially selecting a piece of data from the execution table as first data according to the sequence of the data, and determining second data from other interface tables according to a transaction main key of the first data;
merging the first data and the second data to obtain transaction proofreading information;
and comparing the transaction information corresponding to the transaction main key recorded by the downstream transaction system with the transaction verification information, and if the transaction information is the same as the transaction verification information, successfully verifying the transaction information.
Further, the transaction primary key includes a combination of one or more of a transaction party, a transaction number, a combined transaction relationship, and a transaction date.
Further, when the transaction primary key at least comprises a transaction party and a transaction date, determining that the second data further comprises from the other interface table according to the transaction primary key of the first data,
taking other interface tables except the execution table as tables to be merged, comparing the transaction party and the transaction date of the first data with the transaction party and the transaction date in the attribute information of the tables to be merged, and if the transaction party and the transaction date are the same, matching the other contents except the transaction party and the transaction date with the data in the tables to be merged according to the transaction main key of the first data to obtain second data of the tables to be merged;
if not, finishing the lookup of the table to be merged.
Further, after the first data and the second data are merged to obtain the transaction proofreading information, the method further comprises marking the first data and the second data in the corresponding interface table;
when the transaction primary key includes a transaction date, the method further includes,
if the report is received again, determining an interface table which has the same transaction date and element items as the report received again as an interface table to be updated;
determining data to be updated in the data corresponding to the report received again according to the transaction main key of the data marked in the interface table to be updated;
and updating the data to be updated into the transaction proofreading information so as to proofread the transaction information again by using the updated transaction proofreading information.
Further, after determining the interface table corresponding to the element item of the report received again as the interface table to be updated, the method further comprises,
and updating the data in the interface table to be updated by using the data corresponding to the report received again.
Further, the method may further comprise,
traversing data in the interface table according to a preset period;
and when the traversal times of the data in the interface table exceed a preset threshold value, if the data is not marked, deleting the data.
The embodiment of the invention also provides a report processing device, which comprises:
the system comprises a report receiving unit, a transaction processing unit and a processing unit, wherein the report receiving unit is used for receiving a plurality of reports sent by an upstream transaction system, and each report comprises data of the same element item of a plurality of transactions;
the report content analyzing unit is used for analyzing the content of each report to obtain data in each report and storing all the data of each report in the corresponding interface table;
the merged data determining unit is used for selecting an interface table as an execution table, sequentially selecting a piece of data from the execution table as first data according to the sequence of the data, and determining second data from other interface tables according to a transaction primary key of the first data;
the data merging unit is used for merging the first data and the second data to obtain transaction proofreading information;
and the transaction information checking unit is used for comparing the transaction information corresponding to the transaction main key recorded by the downstream transaction system with the transaction checking information, and if the transaction information is the same as the transaction information, the transaction information is checked successfully.
The embodiment of the present invention further provides a computer device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, and the processor implements the method when executing the computer program.
An embodiment of the present invention further provides a computer-readable storage medium, where a computer program is stored, and when the computer program is executed by a processor, the computer program implements the foregoing method.
An embodiment of the present invention further provides a computer program product, where the computer program product includes a computer program, and when the computer program is executed by a processor, the computer program implements the method described above.
By the method, the data in the reports sent by the upper transaction systems are quickly integrated according to the transaction key of one transaction to obtain the transaction check information of the transaction, and then the transaction check information is compared with the transaction information of the transaction stored in the downstream transaction system, so that the transaction information of the downstream transaction system is checked, and the problem of low efficiency of extracting the transaction information in the upstream report in the prior art is solved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts. In the drawings:
FIG. 1 is a schematic diagram of a system for implementing a report processing method according to an embodiment of the present invention;
FIG. 2 is a schematic diagram illustrating a report processing method according to an embodiment of the present invention;
FIG. 3 illustrates steps for updating transaction verification information in accordance with an embodiment of the present invention;
FIG. 4 is a schematic structural diagram of a report processing apparatus according to an embodiment of the present invention;
fig. 5 is a schematic structural diagram of a computer device provided in an embodiment of the present invention.
Description of the symbols of the drawings:
101. a transaction processing terminal;
102. an upstream transaction system;
103. a downstream transaction system;
104. a processor;
401. a report receiving unit;
402. a report content analysis unit;
403. a merged data determining unit;
404. a data merging unit;
405. a transaction information proofreading unit;
502. a computer device;
504. a processor;
506. a memory;
508. a drive mechanism;
510. an input/output module;
512. an input device;
514. an output device;
516. a presentation device;
518. a graphical user interface;
520. a network interface;
522. a communication link;
524. a communication bus.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention are further described in detail below with reference to the accompanying drawings. The exemplary embodiments and descriptions of the present invention are provided to explain the present invention, but not to limit the present invention.
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or described herein. Moreover, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, apparatus, article, or device that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or device.
In the technical scheme of the present application, the data acquisition, storage, use, processing, and the like all conform to the regulations of national laws and regulations.
Fig. 1 is a schematic diagram of an implementation system of a report processing method according to an embodiment of the present invention, which may include a transaction processing terminal 101, an upstream transaction system 102, a downstream transaction system 103, and a processor 104. The transaction processing terminal 101 is responsible for processing transactions of users, in order to count the transactions, the upstream transaction system 102 acquires data of specified element items in the transactions through a transaction data acquisition interface deployed on the transaction processing terminal 101, summarizes transaction data of a plurality of users of one element item, and generates a report of the element item, and the downstream transaction system 103 acquires all transaction data of the users through another transaction data acquisition interface deployed on the transaction processing terminal 101.
When the downstream transaction system sends the transaction information to the upstream transaction system, the upstream transaction system performs corresponding processing again, and if an exception occurs in the processing process, the transaction information of the upstream and downstream is inconsistent. In order to check the transaction content of the same downstream transaction, the upstream transaction system sends all reports to the processor 104 periodically, the processor 104 extracts corresponding transaction data from each report according to the transaction main key, then merges the extracted transaction data to obtain transaction check information, and compares the transaction check information with the transaction information corresponding to the transaction main key acquired from the downstream transaction system 103, thereby checking the transaction information. Alternatively, processors 104 may be nodes of a cloud computing system (not shown), or each processor may be a separate cloud computing system, comprising multiple computers interconnected by a network and operating as a distributed processing system.
In addition, it should be noted that fig. 1 is only one application environment provided by the present disclosure, and in practical applications, other application scenarios may also be included, and this specification is not limited.
In order to solve the problems in the prior art, an embodiment of the present invention provides a report processing method, which can be applied to the processor 104 to check the transaction information. Fig. 2 is a schematic diagram of the steps of report processing provided by the embodiment of the present invention, and the present specification provides the operation steps of the method as described in the embodiment or the flowchart, but more or less operation steps may be included based on conventional or non-creative labor. The order of steps recited in the embodiments is merely one manner of performing the steps in a multitude of orders and does not represent the only order of execution. When an actual system or apparatus product executes, it can execute sequentially or in parallel according to the method shown in the embodiment or the figures. Specifically, as shown in fig. 2, the method may include:
step 201: receiving a plurality of reports sent by an upstream transaction system, wherein each report comprises data of the same element item of a plurality of transactions;
step 202: analyzing the content of each report to obtain data in each report and storing all the data of each report in a corresponding interface table;
step 203: selecting an interface table as an execution table, sequentially selecting a piece of data from the execution table as first data according to the sequence of the data, and determining second data from other interface tables according to a transaction main key of the first data;
step 204: merging the first data and the second data to obtain transaction proofreading information;
step 205: and comparing the transaction information corresponding to the transaction key recorded by the downstream transaction system with the transaction verification information, and if the transaction information is the same as the transaction verification information, successfully verifying the transaction information.
By the method, the data in the reports sent by the upper transaction systems are quickly integrated according to the transaction key of one transaction to obtain the transaction check information of the transaction, and then the transaction check information is compared with the transaction information of the transaction stored in the downstream transaction system, so that the transaction information of the downstream transaction system is checked, and the problem of low efficiency of extracting the transaction information in the upstream report in the prior art is solved.
In the embodiment of the present invention, the report stored in the upstream transaction system includes data of the same element item of multiple transactions, and the element item may be a field in a transaction, for example, the content of the same field in multiple transactions is extracted and added to the report of the field. In addition, in order to facilitate the analysis of the transaction data by the upstream transaction system, a primary key of the transaction is also required to be stored in the report in the upstream transaction system, and the primary key is used for identifying the identity of the transaction, namely, key data of the transaction. And then the upstream transaction system periodically sends the reports to the processor so that the processor can extract and combine the data of the reports to obtain transaction proofreading information.
In the embodiment of the present invention, in order to improve the efficiency of storing data in the interface table, after analyzing a specified number (for example, 1024) of report contents, the analyzed data may be stored in the corresponding interface table, thereby avoiding frequent reading and writing of the interface table and improving the efficiency of storing data in the interface table. In addition, compared with a method for storing all the contents of the report in the corresponding interface table at one time, the method can also avoid database exception caused by inserting a large amount of data at one time.
Then any one interface table is selected as an execution table, one piece of data is sequentially selected from the execution table as first data according to the sequence of the data, second data is determined from other interface tables according to a transaction main key of the first data, and the main key can comprise one or more combinations of a transaction party, a transaction number, a combined transaction relation and a transaction log. Specifically, if the primary key of one piece of data in the other interface table is the same as the primary key of the first data, the piece of data in the other interface table is used as the second data, the first data and the second data belong to one transaction, and then the first data and the second data are merged to obtain transaction proofreading information. And then comparing whether the transaction proofreading information is the same as the transaction information corresponding to the transaction main key, and if so, passing the transaction information proofreading.
In some other embodiments of the present invention, it may also be that an exception occurs when the upstream trading system counts the report, and therefore, if the trading collation information and the trading information are different, it may be that the report of the upstream trading system is incorrect or the trading information of the downstream trading system is incorrect, so that the business personnel can record the essential items with different data, and perform manual collation according to the recorded essential items, and can improve the processing efficiency of the business personnel to a certain extent.
In the embodiment of the present invention, if the transaction primary key includes a plurality of contents (for example, including a transaction party, a transaction number, a combined transaction relationship, and a transaction date), the upstream transaction system may select some important contents in the transaction primary key as attributes of a report, such as a transaction party and a transaction date, when counting the report, and the upstream transaction system stores data of the same transaction party and the same transaction date in one report when counting the report. Therefore, in order to improve the proofreading efficiency, the transaction party and the transaction date in the transaction main key of one piece of data in the execution table can be used for carrying out preliminary comparison with the attributes of other interface tables. Specifically, according to one embodiment of the present invention, when the transaction primary key includes at least a transaction party and a transaction date, determining that the second data further includes from the other interface table according to the transaction primary key of the first data,
taking other interface tables except the execution table as tables to be merged, comparing the transaction party and the transaction date of the first data with the transaction party and the transaction date in the attribute information of the tables to be merged, and if the transaction party and the transaction date are the same, matching other contents except the transaction party and the transaction date with the data in the tables to be merged according to the transaction main key of the first data to obtain second data of the tables to be merged;
if not, finishing the lookup of the table to be merged.
It can be understood that there is a record in each transaction of the transaction party and the transaction date, so that the upstream transaction system can count the transaction data more conveniently and more conveniently by using the transaction party and the transaction date as the attribute information of the report, and the upstream transaction system also conforms to the logical property of the business. In the embodiment of the invention, after a piece of data is extracted from the execution table, whether a transaction party and a transaction date of the data are matched with a transaction party and a transaction date in attribute information of a table to be merged is judged, if yes, second data corresponding to a transaction main key of first data exists in the data of the table to be merged, then other contents except the transaction party and the transaction date of the transaction main key of the first data are matched with the data in the table to be merged, and the matched data are used as the second data. If the transaction party and the transaction date of the data are not matched with the transaction party and the transaction date in the attribute information of the table to be merged, it is indicated that second data corresponding to the transaction primary key of the first data does not exist in the table to be merged, and other tables to be merged can be directly searched without searching in the table to be merged, so that the speed of searching the second data is improved.
According to an embodiment of the present invention, in order to facilitate recording the data already merged in the interface table, after the first data and the second data are merged to obtain the transaction verification information, the first data and the second data are marked in the corresponding interface table in a summary manner. The business personnel can determine the checking progress of the transaction information through the mark.
According to an embodiment of the present invention, if the upstream trading system updates the content of the report, the obtained trading correction information needs to be updated according to the updated report, so as shown in fig. 3, when the trading primary key includes the trading date, the method further includes,
step 301: if the report is received again, determining an interface table which has the same transaction date and the same element items as the report received again as an interface table to be updated;
step 302: determining data to be updated in the data corresponding to the report received again according to the transaction main key of the data marked in the interface table to be updated;
step 303: and updating the data to be updated into the transaction proofreading information so as to carry out proofreading on the transaction information again by using the updated transaction proofreading information.
In the embodiment of the invention, after the report is received again, the interface table which has the same transaction date and element items as the report received again is determined as the interface table to be updated. And then summarizing and determining the data to be updated according to the transaction main key of the marked data in the interface table to be updated in the data corresponding to the report received again, namely determining the data corresponding to the marked data in the report received again as the data to be updated. And finally, updating the data to be updated into the transaction proofreading information so as to carry out proofreading on the transaction information again by using the updated transaction proofreading information.
After determining the interface table corresponding to the element item of the report received again as the interface table to be updated, according to an embodiment of the present invention, the method further includes,
and updating the data in the interface table to be updated by using the data corresponding to the report received again.
It can be understood that, the data in the interface table to be updated is updated by using the data corresponding to the report received again, where the updated data includes the unmarked data and the marked data, then the data corresponding to the marked data is marked to indicate that the updated data has generated the transaction checking information, and then the unmarked data in the interface table is used to generate the transaction checking information.
According to an embodiment of the present invention, if the content analysis of the report is abnormal or the analyzed data does not conform to the corresponding service, the data will not be matched by the data in other reports, that is, the transaction key of the data is different from the transaction keys of the data in other interface tables, and the data can be determined as invalid data. Therefore, the method further comprises the step of,
traversing data in the interface table according to a preset period;
and when the traversal times of the data in the interface table exceed a preset threshold value, if the data is not marked, deleting the data.
In the embodiment of the present invention, the predetermined threshold may be set according to actual requirements, and if the number is not marked after exceeding the predetermined threshold, the data is abnormal or does not conform to the corresponding service, the data is invalid data, and the data is deleted.
Based on the same inventive concept, an embodiment of the present specification further provides a report processing apparatus, as shown in fig. 4, the apparatus includes:
the report receiving unit 401 is configured to receive multiple reports sent by an upstream transaction system, where each report includes data of the same element item of multiple transactions;
a report content analyzing unit 402, configured to analyze the content of each report to obtain data in each report, and store all the data of each report in a corresponding interface table;
a merged data determining unit 403, configured to select an interface table as an execution table, sequentially select a piece of data from the execution table according to an order of the data as first data, and determine second data from other interface tables according to a transaction primary key of the first data;
a data merging unit 404, configured to merge the first data and the second data to obtain transaction proofreading information;
and the transaction information checking unit 405 is configured to compare the transaction information corresponding to the transaction key recorded by the downstream transaction system with the transaction checking information, and if the transaction information is the same as the transaction information, the transaction information is checked successfully.
The advantages obtained by the device are consistent with those obtained by the method, and the embodiments of the present description are not repeated.
As shown in fig. 5, for a computer device provided in this embodiment, an apparatus herein may be a computer device in this embodiment, and performs the method herein, and the computer device 502 may include one or more processors 504, such as one or more Central Processing Units (CPUs), each of which may implement one or more hardware threads. The computer device 502 may also include any memory 506 for storing any kind of information, such as code, settings, data, etc. For example, and without limitation, memory 506 may include any one or combination of the following: any type of RAM, any type of ROM, flash memory devices, hard disks, optical disks, etc. More generally, any memory may use any technology to store information. Further, any memory may provide volatile or non-volatile retention of information. Further, any memory may represent fixed or removable components of computer device 502. In one case, when the processor 504 executes the associated instructions, which are stored in any memory or combination of memories, the computer device 502 can perform any of the operations of the associated instructions. The computer device 502 also includes one or more drive mechanisms 508, such as a hard disk drive mechanism, an optical disk drive mechanism, etc., for interacting with any memory.
Computer device 502 may also include an input/output module 510 (I/O) for receiving various inputs (via input device 512) and for providing various outputs (via output device 514). One particular output mechanism may include a presentation device 516 and an associated Graphical User Interface (GUI) 518. In other embodiments, input/output module 510 (I/O), input device 512, and output device 514 may not be included, but merely as a single computer device in a network. Computer device 502 can also include one or more network interfaces 520 for exchanging data with other devices via one or more communication links 522. One or more communication buses 524 couple the above-described components together.
Communication link 522 may be implemented in any manner, such as through a local area network, a wide area network (e.g., the Internet), a point-to-point connection, etc., or any combination thereof. Communication link 522 may include any combination of hardwired links, wireless links, routers, gateway functions, name servers, etc., governed by any protocol or combination of protocols.
An embodiment of the present invention further provides a computer-readable storage medium, in which a computer program is stored, and the computer program, when executed by a processor, implements the above method.
An embodiment of the present invention further provides a computer program product, where the computer program product includes a computer program, and when the computer program is executed by a processor, the computer program implements the method described above.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention has been described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are only exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.

Claims (10)

1. A report processing method is characterized by comprising the following steps:
receiving a plurality of reports sent by an upstream transaction system, wherein each report comprises data of the same element item of a plurality of transactions;
analyzing the content of each report to obtain data in each report and storing all the data of each report in a corresponding interface table;
selecting an interface table as an execution table, sequentially selecting a piece of data from the execution table as first data according to the sequence of the data, and determining second data from other interface tables according to a transaction main key of the first data;
merging the first data and the second data to obtain transaction proofreading information;
and comparing the transaction information corresponding to the transaction main key recorded by the downstream transaction system with the transaction verification information, and if the transaction information is the same as the transaction verification information, successfully verifying the transaction information.
2. The method of claim 1, wherein the transaction primary key comprises a combination of one or more of a transaction party, a transaction number, a combined transaction relationship, and a transaction date.
3. The method of claim 2, wherein determining second data from the other interface table based on the primary transaction key of the first data when the primary transaction key includes at least a transaction party and a transaction date further comprises,
taking other interface tables except the execution table as tables to be merged, comparing the transaction party and the transaction date of the first data with the transaction party and the transaction date in the attribute information of the tables to be merged, and if the transaction party and the transaction date are the same, matching other contents except the transaction party and the transaction date with the data in the tables to be merged according to the transaction main key of the first data to obtain second data of the tables to be merged;
if not, finishing the lookup of the table to be merged.
4. The method of claim 2, wherein after merging the first data with the second data to obtain the transaction collation information, the method further comprises marking the first data and the second data in corresponding interface tables;
when the transaction primary key includes a transaction date, the method further includes,
if the report is received again, determining an interface table which has the same transaction date and the same element items as the report received again as an interface table to be updated;
determining the data to be updated in the data corresponding to the report received again according to the transaction key of the data marked in the interface table to be updated;
and updating the data to be updated into the transaction proofreading information so as to carry out proofreading on the transaction information again by using the updated transaction proofreading information.
5. The method according to claim 4, wherein after determining the interface table corresponding to the element item of the report received again as the interface table to be updated, the method further comprises,
and updating the data in the interface table to be updated by using the data corresponding to the report received again.
6. The method of claim 4, further comprising,
traversing data in the interface table according to a preset period;
and when the traversal times of the data in the interface table exceed a preset threshold value, if the data is not marked, deleting the data.
7. A report processing apparatus, comprising:
the system comprises a report receiving unit, a transaction processing unit and a processing unit, wherein the report receiving unit is used for receiving a plurality of reports sent by an upstream transaction system, and each report comprises data of the same element item of a plurality of transactions;
the report content analysis unit is used for analyzing the content of each report to obtain data in each report and storing all the data of each report in the corresponding interface table;
the merged data determining unit is used for selecting an interface table as an execution table, sequentially selecting a piece of data from the execution table as first data according to the sequence of the data, and determining second data from other interface tables according to a transaction primary key of the first data;
the data merging unit is used for merging the first data and the second data to obtain transaction proofreading information;
and the transaction information checking unit is used for comparing the transaction information corresponding to the transaction main key recorded by the downstream transaction system with the transaction checking information, and if the transaction information is the same as the transaction information, the transaction information is checked successfully.
8. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of any one of claims 1 to 6 when executing the computer program.
9. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program which, when executed by a processor, implements the method of any one of claims 1 to 6.
10. A computer program product, characterized in that the computer program product comprises a computer program which, when being executed by a processor, carries out the method of any one of claims 1 to 6.
CN202211193594.3A 2022-09-28 2022-09-28 Report processing method, device, equipment and storage medium Pending CN115563943A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202211193594.3A CN115563943A (en) 2022-09-28 2022-09-28 Report processing method, device, equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202211193594.3A CN115563943A (en) 2022-09-28 2022-09-28 Report processing method, device, equipment and storage medium

Publications (1)

Publication Number Publication Date
CN115563943A true CN115563943A (en) 2023-01-03

Family

ID=84742285

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202211193594.3A Pending CN115563943A (en) 2022-09-28 2022-09-28 Report processing method, device, equipment and storage medium

Country Status (1)

Country Link
CN (1) CN115563943A (en)

Similar Documents

Publication Publication Date Title
US9104709B2 (en) Cleansing a database system to improve data quality
CN109241014B (en) Data processing method and device and server
US9025890B2 (en) Information classification device, information classification method, and information classification program
CN112613917A (en) Information pushing method, device and equipment based on user portrait and storage medium
CN110209643A (en) A kind of data processing method and device
US11836331B2 (en) Mathematical models of graphical user interfaces
CN108073707B (en) Financial business data updating method and device and computer readable storage medium
CN111553137A (en) Report generation method and device, storage medium and computer equipment
CN113420057A (en) Account checking data processing method and related device
CN114048129A (en) Automatic testing method, device, equipment and system for software function change
US11899770B2 (en) Verification method and apparatus, and computer readable storage medium
CN112433705A (en) Script generation method and device, electronic equipment and storage medium
CN110019762B (en) Problem positioning method, storage medium and server
CN112463737A (en) System and method for rapidly acquiring data aiming at multi-format data intelligent matching template
CN116132499B (en) Compression method and device for call chain, computer equipment and storage medium
CN115563943A (en) Report processing method, device, equipment and storage medium
WO2021129849A1 (en) Log processing method, apparatus and device, and storage medium
CN113763143A (en) Auditing processing method, computer equipment and storage device
CN113791860A (en) Information conversion method, device and storage medium
CN112698883A (en) Configuration data processing method, device, terminal and storage medium
JP2015165352A (en) analysis candidate display device
CN109582534B (en) Method and device for determining operation entry of system and server
JP2018067040A (en) Test shot creation support apparatus and test shot creation support method
CN114492409B (en) Method and device for evaluating file content, electronic equipment and program product
WO2019030884A1 (en) Reviewer management system and method

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