CN112037003A - File account checking processing method and device - Google Patents
File account checking processing method and device Download PDFInfo
- Publication number
- CN112037003A CN112037003A CN202010980313.3A CN202010980313A CN112037003A CN 112037003 A CN112037003 A CN 112037003A CN 202010980313 A CN202010980313 A CN 202010980313A CN 112037003 A CN112037003 A CN 112037003A
- Authority
- CN
- China
- Prior art keywords
- file
- reconciliation
- account
- files
- unmatched
- 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
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 13
- 238000000034 method Methods 0.000 claims abstract description 37
- 238000012545 processing Methods 0.000 claims abstract description 33
- 238000004590 computer program Methods 0.000 claims description 16
- 238000006243 chemical reaction Methods 0.000 claims description 7
- 238000012163 sequencing technique Methods 0.000 claims description 4
- 238000010586 diagram Methods 0.000 description 18
- 230000006870 function Effects 0.000 description 6
- 230000008569 process Effects 0.000 description 5
- 238000012423 maintenance Methods 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 230000001174 ascending effect Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000005192 partition Methods 0.000 description 1
- 238000011084 recovery Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/17—Details of further file system functions
- G06F16/178—Techniques for file synchronisation in file systems
- G06F16/1794—Details of file format conversion
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Accounting & Taxation (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Finance (AREA)
- Human Computer Interaction (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a file reconciliation processing method and a device, wherein the method comprises the following steps: merging the transaction files participating in the target daily reconciliation to generate a first reconciliation file and a second reconciliation file for reconciliation; splitting the first account checking file and the second account checking file into a plurality of first split files and a plurality of second split files respectively; comparing corresponding file data in the plurality of first split files and the plurality of second split files; and according to the comparison result, acquiring a first account reconciliation unmatched file and a second account reconciliation unmatched file, wherein the first account reconciliation unmatched file is used for storing file data which is present in the first account reconciliation file but not present in the second account reconciliation file, and the second account reconciliation unmatched file is used for storing file data which is present in the second account reconciliation file but not present in the first account reconciliation file. The invention has the advantages of low resource consumption, short time for reconciliation processing of the files and high efficiency.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a file reconciliation processing method and device.
Background
Financial transactions of financial institutions generally need to be cleared in a centralized manner, account checking is an important link in clearing, and with the rapid increase of transaction amount, account checking processing time required by systems using a host platform, a VSAM (Virtual Storage Access Method), a QSAM (Queued Sequential Access Method, a QSAM file is a file system using a Sequential Storage Method) and the like as data Storage tools is longer and longer.
In the prior art, account checking operation is generally performed in a database partition table mode. However, this method may cause lock conflict problem, index use problem, etc., and needs to monitor the performance of the database in real time, and adds maintenance processing, such as backup, recovery, etc., to the database, which requires a long time for processing and is inefficient.
Disclosure of Invention
The embodiment of the invention provides a file reconciliation processing method which has the advantages of low resource consumption, short time required by file reconciliation processing and high efficiency, and the method comprises the following steps:
merging the transaction files participating in the target daily reconciliation to generate a first reconciliation file and a second reconciliation file for reconciliation;
splitting the first account checking file and the second account checking file into a plurality of first split files and a plurality of second split files respectively;
comparing corresponding file data in the plurality of first split files and the plurality of second split files;
and according to the comparison result, acquiring a first account reconciliation unmatched file and a second account reconciliation unmatched file, wherein the first account reconciliation unmatched file is used for storing file data which is present in the first account reconciliation file but not present in the second account reconciliation file, and the second account reconciliation unmatched file is used for storing file data which is present in the second account reconciliation file but not present in the first account reconciliation file.
Optionally, the first reconciliation file and the second reconciliation file are QSAM files;
after generating the first reconciliation file and the second reconciliation file for reconciliation, the method further comprises:
and sequencing the file data in the first reconciliation file and the second reconciliation file.
Optionally, after splitting the first reconciliation file and the second reconciliation file into a plurality of first split files and a plurality of second split files, the method further includes:
and converting the plurality of first split files and the plurality of second split files into VSAM files.
Optionally, after the first reconciliation unmatched file and the second reconciliation unmatched file are obtained according to the comparison result, the method further includes:
and carrying out secondary comparison on the first account-checking unmatched file and the second account-checking unmatched file.
Optionally, the alignment result further includes: the system comprises a first daily account checking file and a second daily account checking file, wherein the first daily account checking file is used for storing file data required by next-day account checking of a target day existing in the first account checking file, and the second daily account checking file is used for storing file data required by next-day account checking of the target day existing in the second account checking file.
The embodiment of the invention also provides a file reconciliation processing device, which has the advantages of low resource consumption, short time required by file reconciliation processing and high efficiency, and the device comprises:
the merging module is used for merging the transaction files participating in the target daily reconciliation so as to generate a first reconciliation file and a second reconciliation file for reconciliation;
the splitting module is used for splitting the first account checking file and the second account checking file into a plurality of first split files and a plurality of second split files respectively;
the comparison module is used for comparing the corresponding file data in the plurality of first split files and the plurality of second split files;
and the file processing module is used for acquiring a first account-tie unmatched file and a second account-tie unmatched file according to the comparison result, wherein the first account-tie unmatched file is used for storing file data which is present in the first account-tie file but not present in the second account-tie file, and the second account-tie unmatched file is used for storing file data which is present in the second account-tie file but not present in the first account-tie file.
Optionally, the first reconciliation file and the second reconciliation file are QSAM files;
the device further comprises:
and the sorting module is used for sorting the file data in the first reconciliation file and the second reconciliation file.
Optionally, the apparatus further comprises:
and the format conversion module is used for converting the formats of the plurality of first split files and the plurality of second split files into VSAM files.
Optionally, the apparatus further comprises:
and the secondary comparison module is used for carrying out secondary comparison on the first account-checking unmatched file and the second account-checking unmatched file.
Optionally, the alignment result further includes: the system comprises a first daily account checking file and a second daily account checking file, wherein the first daily account checking file is used for storing file data required by next-day account checking of a target day existing in the first account checking file, and the second daily account checking file is used for storing file data required by next-day account checking of the target day existing in the second account checking file.
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, in which a computer program for executing the above method is stored.
In the embodiment of the invention, the transaction files participating in the daily reconciliation of the target are merged to generate the first reconciliation file and the second reconciliation file for reconciliation, the first reconciliation file and the second reconciliation file are respectively split into the plurality of first split files and the plurality of second split files, the corresponding file data in the plurality of first split files and the plurality of second split files are compared, the first reconciliation unmatched file and the second reconciliation unmatched file are obtained according to the comparison result, the performance of the database is not required to be monitored in real time, the maintenance processing and the like of the database are added, the resource consumption is low, the time required by the reconciliation processing of the files is short, and the efficiency is high.
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 flowchart of a document reconciliation processing method in an embodiment of the present invention;
FIG. 2 is a flowchart illustrating sorting of file data in a first reconciliation file and a second reconciliation file in accordance with an embodiment of the present invention;
FIG. 3 is a flowchart illustrating format conversion of a plurality of first split files and a plurality of second split files according to an embodiment of the present invention;
FIG. 4 is a flowchart of a file reconciliation processing method according to an embodiment of the present invention;
FIG. 5 is a schematic structural diagram of a document reconciliation processing apparatus according to an embodiment of the present invention;
fig. 6 is a schematic structural diagram illustrating a sorting of file data in a first reconciliation file and a second reconciliation file according to an embodiment of the present invention;
FIG. 7 is a schematic structural diagram illustrating format conversion performed on a plurality of first split files and a plurality of second split files according to an embodiment of the present invention;
FIG. 8 is a schematic structural diagram of a document reconciliation processing apparatus according to an embodiment of the present invention;
FIG. 9 is a diagram illustrating an embodiment of a file reconciliation process performed in an embodiment of the present invention;
FIG. 10 is a diagram illustrating an embodiment of a file reconciliation process performed in an embodiment of the present invention;
FIG. 11 is a schematic diagram of a computer apparatus according to an embodiment of the present invention.
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.
Fig. 1 is a flowchart of a file reconciliation processing method according to an embodiment of the present invention, and as shown in fig. 1, the method includes:
In an embodiment, since the files participating in reconciliation may include multiple transactions, the transaction files participating in the target daily reconciliation include transaction files of each party, for example, a plurality of transaction files requiring reconciliation on the current day of the banking party, a plurality of transaction files requiring reconciliation on the current day of the external system party, and the like. In addition, the file participating in account checking further comprises: and participating in the next day account checking of the target day. In the process, the formats of all files need to be kept consistent, and the keywords of the fields in the files are the same.
During specific implementation, the first account checking file and the second account checking file can be respectively split into a plurality of first split files and a plurality of second split files according to the fixed record number, each first split file and each second split file can be subjected to parameter configuration, and meanwhile, the plurality of first split files and the plurality of second split files can be operated in parallel, so that the data processing time is shortened, and the working efficiency of the system is improved.
In specific implementation, the comparison and parallel processing of the corresponding file data in the plurality of first split files and the plurality of second split files can be performed, and the parallel processed job data can be configured according to the system allowable value.
And 104, acquiring a first account reconciliation unmatched file and a second account reconciliation unmatched file according to the comparison result, wherein the first account reconciliation unmatched file is used for storing file data which is present in the first account reconciliation file but not present in the second account reconciliation file, and the second account reconciliation unmatched file is used for storing file data which is present in the second account reconciliation file but not present in the first account reconciliation file. The flowchart of the specific file reconciliation process can be seen in fig. 10.
As can be seen from fig. 1, in the file reconciliation processing method provided in the embodiment of the present invention, the transaction files participating in the daily reconciliation of the target are merged to generate the first reconciliation file and the second reconciliation file for reconciliation, the first reconciliation file and the second reconciliation file are respectively split into the plurality of first split files and the plurality of second split files, the corresponding file data in the plurality of first split files and the plurality of second split files are compared, and the first reconciliation unmatched file and the second reconciliation unmatched file are obtained according to the comparison result, so that the database performance does not need to be monitored in real time, maintenance processing and the like of the database are added, and therefore, the resource consumption is small, the time required for the reconciliation processing of the files is short, and the efficiency is high.
Fig. 2 is a flowchart of sequencing file data in a first reconciliation file and a second reconciliation file according to an embodiment of the present invention, where the first reconciliation file and the second reconciliation file are QSAM files, and after generating the first reconciliation file and the second reconciliation file for reconciliation as shown in fig. 2, the method further includes:
In specific implementation, the file data (QSAM files) in the first reconciliation file and the second reconciliation file are sequenced by using a DFSORT (operating system command). It should be noted that, due to the processing mechanism of VSAM-KSDS itself, when writing QSAM data into VSAM, the system will automatically perform ascending data reassembly according to its key value, thereby reducing the processing efficiency of the whole reconciliation operation.
Fig. 3 is a flowchart of format conversion performed on a plurality of first split files and a plurality of second split files according to an embodiment of the present invention, in order to facilitate subsequent comparison between two files and improve reconciliation efficiency, as shown in fig. 3, after splitting a first reconciliation file and a second reconciliation file into a plurality of first split files and a plurality of second split files, respectively, the method further includes:
In the embodiment, the VSAM files have key values, so that comparison is convenient, and the formats of the plurality of first split files and the plurality of second split files can be converted into the VSAM files. In particular implementations, the ZOS operating system may be used to command the IDCAMS to convert the QSAM file to a VSAM file.
Fig. 4 is a flowchart of a file reconciliation processing method according to an embodiment of the present invention, and as shown in fig. 4, after acquiring a first reconciliation unmatched file and a second reconciliation unmatched file according to a comparison result, the method further includes:
Because the files are split, the boundary records of the files may be misplaced (for example, a certain record is in a first split file of a first reconciliation file, and a corresponding record is in a second split file of a second reconciliation file), so that in order to ensure the accuracy of the reconciliation result, the first reconciliation unmatched file and the second reconciliation unmatched file can be compared for the second time, and the same record in the two files is deleted.
In an embodiment of the present invention, the comparison result further includes: the system comprises a first daily account checking file and a second daily account checking file, wherein the first daily account checking file is used for storing file data required by next-day account checking of a target day existing in the first account checking file, and the second daily account checking file is used for storing file data required by next-day account checking of the target day existing in the second account checking file.
In specific implementation, the first daily reconciliation file and the second daily reconciliation file may be added to a plurality of transaction files for the next daily reconciliation for processing, which may be specifically referred to in fig. 9.
Based on the same inventive concept, the embodiment of the present invention further provides a file reconciliation processing apparatus, as described in the following embodiments. Because the principle of the file reconciliation processing device for solving the problems is similar to the file reconciliation processing method, the implementation of the file reconciliation processing device can refer to the implementation of the file reconciliation processing method, and repeated parts are not repeated. As used hereinafter, the term "unit" or "module" may be a combination of software and/or hardware that implements a predetermined function. Although the means described in the embodiments below are preferably implemented in software, an implementation in hardware, or a combination of software and hardware is also possible and contemplated.
Fig. 5 is a schematic structural diagram of a file reconciliation processing apparatus according to an embodiment of the present invention, and as shown in fig. 5, the apparatus includes:
a merging module 501, configured to merge transaction files participating in the target daily reconciliation to generate a first reconciliation file and a second reconciliation file for reconciliation.
The splitting module 502 is configured to split the first reconciliation file and the second reconciliation file into a plurality of first split files and a plurality of second split files, respectively.
The comparing module 503 is configured to compare file data corresponding to the plurality of first split files and the plurality of second split files.
The file processing module 504 is configured to obtain, according to the comparison result, a first reconciliation unmatched file and a second reconciliation unmatched file, where the first reconciliation unmatched file is used to store file data that is present in the first reconciliation file but not present in the second reconciliation file, and the second reconciliation unmatched file is used to store file data that is present in the second reconciliation file but not present in the first reconciliation file.
Fig. 6 is a schematic structural diagram of sequencing file data in a first reconciliation file and a second reconciliation file according to an embodiment of the present invention, where the first reconciliation file and the second reconciliation file are QSAM files, and as shown in fig. 6, the apparatus further includes:
the sorting module 601 is configured to sort the file data in the first reconciliation file and the second reconciliation file.
Fig. 7 is a schematic structural diagram of performing format conversion on a plurality of first split files and a plurality of second split files according to an embodiment of the present invention, and as shown in fig. 7, the apparatus further includes:
a format conversion module 701, configured to convert the formats of the multiple first split files and the multiple second split files into VSAM files.
Fig. 8 is a schematic structure of a file reconciliation processing apparatus according to an embodiment of the present invention, and as shown in fig. 8, the apparatus further includes:
and a secondary comparison module 801, configured to perform secondary comparison on the first reconciliation unmatched file and the second reconciliation unmatched file.
In an embodiment of the present invention, the comparison result further includes: the system comprises a first daily account checking file and a second daily account checking file, wherein the first daily account checking file is used for storing file data required by next-day account checking of a target day existing in the first account checking file, and the second daily account checking file is used for storing file data required by next-day account checking of the target day existing in the second account checking file.
To achieve the above object, according to another aspect of the present application, there is also provided a computer apparatus. As shown in fig. 11, the computer device comprises a memory, a processor, a communication interface and a communication bus, wherein a computer program that can be run on the processor is stored in the memory, and the steps of the method of the embodiment are realized when the processor executes the computer program.
The processor may be a Central Processing Unit (CPU). The Processor may also be other general purpose processors, Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field Programmable Gate Arrays (FPGAs) or other Programmable logic devices, discrete Gate or transistor logic devices, discrete hardware components, or a combination thereof.
The memory, which is a non-transitory computer readable storage medium, may be used to store non-transitory software programs, non-transitory computer executable programs, and units, such as the corresponding program units in the above-described method embodiments of the present invention. The processor executes various functional applications of the processor and the processing of the work data by executing the non-transitory software programs, instructions and modules stored in the memory, that is, the method in the above method embodiment is realized.
The memory may include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function; the storage data area may store data created by the processor, and the like. Further, the memory may include high speed random access memory, and may also include non-transitory memory, such as at least one disk storage device, flash memory device, or other non-transitory solid state storage device. In some embodiments, the memory optionally includes memory located remotely from the processor, and such remote memory may be coupled to the processor via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The one or more units are stored in the memory and when executed by the processor perform the method of the above embodiments.
An embodiment of the present invention further provides a computer-readable storage medium, in which a computer program for executing the above method is stored.
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 is 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 (12)
1. A file reconciliation processing method is characterized by comprising the following steps:
merging the transaction files participating in the target daily reconciliation to generate a first reconciliation file and a second reconciliation file for reconciliation;
splitting the first account checking file and the second account checking file into a plurality of first split files and a plurality of second split files respectively;
comparing corresponding file data in the plurality of first split files and the plurality of second split files;
and according to the comparison result, acquiring a first account reconciliation unmatched file and a second account reconciliation unmatched file, wherein the first account reconciliation unmatched file is used for storing file data which is present in the first account reconciliation file but not present in the second account reconciliation file, and the second account reconciliation unmatched file is used for storing file data which is present in the second account reconciliation file but not present in the first account reconciliation file.
2. The method of claim 1, wherein the first and second reconciliation files are QSAM files;
after generating the first reconciliation file and the second reconciliation file for reconciliation, the method further comprises:
and sequencing the file data in the first reconciliation file and the second reconciliation file.
3. The method of claim 2, wherein after splitting the first tie-down file and the second tie-down file into the plurality of first split files and the plurality of second split files, respectively, the method further comprises:
and converting the plurality of first split files and the plurality of second split files into VSAM files.
4. The method of claim 1, wherein after obtaining the first reconciliation unmatched file and the second reconciliation unmatched file according to the comparison result, the method further comprises:
and carrying out secondary comparison on the first account-checking unmatched file and the second account-checking unmatched file.
5. The method of claim 1, wherein the aligning further comprises: the system comprises a first daily account checking file and a second daily account checking file, wherein the first daily account checking file is used for storing file data required by next-day account checking of a target day existing in the first account checking file, and the second daily account checking file is used for storing file data required by next-day account checking of the target day existing in the second account checking file.
6. A file reconciliation processing apparatus comprising:
the merging module is used for merging the transaction files participating in the target daily reconciliation so as to generate a first reconciliation file and a second reconciliation file for reconciliation;
the splitting module is used for splitting the first account checking file and the second account checking file into a plurality of first split files and a plurality of second split files respectively;
the comparison module is used for comparing the corresponding file data in the plurality of first split files and the plurality of second split files;
and the file processing module is used for acquiring a first account-tie unmatched file and a second account-tie unmatched file according to the comparison result, wherein the first account-tie unmatched file is used for storing file data which is present in the first account-tie file but not present in the second account-tie file, and the second account-tie unmatched file is used for storing file data which is present in the second account-tie file but not present in the first account-tie file.
7. The apparatus of claim 6, wherein the first and second reconciliation files are QSAM files;
the device further comprises:
and the sorting module is used for sorting the file data in the first reconciliation file and the second reconciliation file.
8. The apparatus of claim 7, wherein the apparatus further comprises:
and the format conversion module is used for converting the formats of the plurality of first split files and the plurality of second split files into VSAM files.
9. The apparatus of claim 6, wherein the apparatus further comprises:
and the secondary comparison module is used for carrying out secondary comparison on the first account-checking unmatched file and the second account-checking unmatched file.
10. The apparatus of claim 6, wherein the alignment result further comprises: the system comprises a first daily account checking file and a second daily account checking file, wherein the first daily account checking file is used for storing file data required by next-day account checking of a target day existing in the first account checking file, and the second daily account checking file is used for storing file data required by next-day account checking of the target day existing in the second account checking file.
11. 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 5 when executing the computer program.
12. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program for executing the method of any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010980313.3A CN112037003A (en) | 2020-09-17 | 2020-09-17 | File account checking processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010980313.3A CN112037003A (en) | 2020-09-17 | 2020-09-17 | File account checking processing method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112037003A true CN112037003A (en) | 2020-12-04 |
Family
ID=73590084
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010980313.3A Pending CN112037003A (en) | 2020-09-17 | 2020-09-17 | File account checking processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112037003A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113342750A (en) * | 2021-06-29 | 2021-09-03 | 深圳前海微众银行股份有限公司 | File data comparison method, device, equipment and storage medium |
| CN113590553A (en) * | 2021-08-03 | 2021-11-02 | 京东科技控股股份有限公司 | Account checking method and device, electronic equipment and computer readable medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107798109A (en) * | 2017-11-01 | 2018-03-13 | 深圳市牛鼎丰科技有限公司 | Method, apparatus, computer equipment and the storage medium of reconciliation clearance |
| EP3401859A1 (en) * | 2017-05-11 | 2018-11-14 | Amadeus S.A.S. | A system and a method for processing and reconciling an invoice data file |
| CN108961029A (en) * | 2018-07-26 | 2018-12-07 | 阿里巴巴集团控股有限公司 | A kind of distribution reconciliation processing method, system and terminal device |
| CN110287200A (en) * | 2019-07-02 | 2019-09-27 | 江苏满运软件科技有限公司 | Account checking method, system, computer equipment and storage medium |
| CN110390586A (en) * | 2019-07-23 | 2019-10-29 | 中国工商银行股份有限公司 | Account checking method, device and server |
-
2020
- 2020-09-17 CN CN202010980313.3A patent/CN112037003A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP3401859A1 (en) * | 2017-05-11 | 2018-11-14 | Amadeus S.A.S. | A system and a method for processing and reconciling an invoice data file |
| CN107798109A (en) * | 2017-11-01 | 2018-03-13 | 深圳市牛鼎丰科技有限公司 | Method, apparatus, computer equipment and the storage medium of reconciliation clearance |
| CN108961029A (en) * | 2018-07-26 | 2018-12-07 | 阿里巴巴集团控股有限公司 | A kind of distribution reconciliation processing method, system and terminal device |
| CN110287200A (en) * | 2019-07-02 | 2019-09-27 | 江苏满运软件科技有限公司 | Account checking method, system, computer equipment and storage medium |
| CN110390586A (en) * | 2019-07-23 | 2019-10-29 | 中国工商银行股份有限公司 | Account checking method, device and server |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113342750A (en) * | 2021-06-29 | 2021-09-03 | 深圳前海微众银行股份有限公司 | File data comparison method, device, equipment and storage medium |
| WO2023273235A1 (en) * | 2021-06-29 | 2023-01-05 | 深圳前海微众银行股份有限公司 | Data comparison method, apparatus and device for file, and storage medium |
| CN113342750B (en) * | 2021-06-29 | 2023-11-17 | 深圳前海微众银行股份有限公司 | File data comparison method, device, equipment and storage medium |
| CN113590553A (en) * | 2021-08-03 | 2021-11-02 | 京东科技控股股份有限公司 | Account checking method and device, electronic equipment and computer readable medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109034993B (en) | Account checking method, account checking equipment, account checking system and computer readable storage medium | |
| US9986018B2 (en) | Method and system for a scheduled map executor | |
| CN109508326B (en) | Method, device and system for processing data | |
| CN106126601A (en) | A kind of social security distributed preprocess method of big data and system | |
| CN107784030B (en) | Method and device for processing connection query | |
| CN106503974B (en) | Transaction data processing method and device | |
| CN102436408A (en) | Data storage cloud and cloud backup method based on Map/Dedup | |
| US20140222766A1 (en) | System and method for database migration and validation | |
| CN112037003A (en) | File account checking processing method and device | |
| WO2017090475A1 (en) | Information processing system, function creation method, and function creation program | |
| Agarwal et al. | Implementation of an improved algorithm for frequent itemset mining using Hadoop | |
| CN111767320A (en) | Data blood relationship determination method and device | |
| US20150172369A1 (en) | Method and system for iterative pipeline | |
| US20170200153A1 (en) | Technologies for conversion of mainframe files for big data ingestion | |
| CN109241163B (en) | Electronic certificate generation method and terminal equipment | |
| US20160203032A1 (en) | Series data parallel analysis infrastructure and parallel distributed processing method therefor | |
| US10552419B2 (en) | Method and system for performing an operation using map reduce | |
| CN110019169B (en) | Data processing method and device | |
| CN113722600A (en) | Data query method, device, equipment and product applied to big data | |
| CN113010542A (en) | Service data processing method and device, computer equipment and storage medium | |
| CN106843822B (en) | Execution code generation method and equipment | |
| CN111159213A (en) | Data query method, device, system and storage medium | |
| Tiwari | Advanced ETL (AETL) by integration of PERL and scripting method | |
| CN110569315A (en) | Data processing method and device based on data warehouse | |
| CN116010461A (en) | Data blood relationship analysis method and device, storage medium and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |