CN112037003B - File reconciliation processing method and device - Google Patents
File reconciliation processing method and device Download PDFInfo
- Publication number
- CN112037003B CN112037003B CN202010980313.3A CN202010980313A CN112037003B CN 112037003 B CN112037003 B CN 112037003B CN 202010980313 A CN202010980313 A CN 202010980313A CN 112037003 B CN112037003 B CN 112037003B
- Authority
- CN
- China
- Prior art keywords
- file
- reconciliation
- files
- split
- mismatch
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 10
- 238000000034 method Methods 0.000 claims abstract description 41
- 238000012545 processing Methods 0.000 claims abstract description 41
- 238000004590 computer program Methods 0.000 claims description 16
- 238000006243 chemical reaction Methods 0.000 claims description 7
- 238000010586 diagram Methods 0.000 description 18
- 230000008569 process Effects 0.000 description 7
- 230000006870 function Effects 0.000 description 6
- 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
- 238000005516 engineering process 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
- 238000012544 monitoring process Methods 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
- 230000008521 reorganization Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
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 device, wherein the method comprises the following steps: merging transaction files participating in target day 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 the file data corresponding to the first split files with the second split files; and acquiring a first reconciliation mismatch file and a second reconciliation mismatch file according to the comparison result, wherein the first reconciliation mismatch file is used for storing file data which is in the first reconciliation file and is not in the second reconciliation file, and the second reconciliation mismatch file is used for storing file data which is in the second reconciliation file and is not in the first reconciliation file. The method has the advantages of low resource consumption, short time required by document accounting processing and high efficiency.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a method and an apparatus for document reconciliation processing.
Background
Financial transactions at financial institutions are generally cleared intensively, and checking accounts is an important link in clearing, and as the transaction amount increases sharply, the time of checking accounts required by a system using a host platform, VSAM (Virtual Storage Access Method, a virtual access method), QSAM (Queued Sequential Access, a queuing sequential access method, QSAM file is a file system using a sequential storage method) or the like as a data storage tool becomes longer and longer.
The prior art generally adopts a database partition table mode to perform reconciliation operation. However, this method brings lock conflict problem, index use problem, etc., and needs to monitor the database performance in real time, and adds maintenance processing to the database, such as backup, recovery, etc., and the processing time is long and the efficiency is low.
Disclosure of Invention
The embodiment of the invention provides a file account checking processing method, which has the advantages of low resource consumption, short time required by file account checking processing and high efficiency, and comprises the following steps:
Merging transaction files participating in target day 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 the file data corresponding to the first split files with the second split files;
And acquiring a first reconciliation mismatch file and a second reconciliation mismatch file according to the comparison result, wherein the first reconciliation mismatch file is used for storing file data which is in the first reconciliation file and is not in the second reconciliation file, and the second reconciliation mismatch file is used for storing file data which is in the second reconciliation file and is not in the first reconciliation file.
Optionally, the first reconciliation file and the second reconciliation file are QSAM files;
After generating the first and second reconciliation documents for reconciliation, the method further comprises:
And sorting file data in the first reconciliation file and the second reconciliation file.
Optionally, after splitting the first ledger file and the second ledger file into the plurality of first split files and the plurality of second split files, respectively, the method further includes:
the plurality of first split files and the plurality of second split files are formatted into VSAM files.
Optionally, after the first reconciliation mismatch file and the second reconciliation mismatch file are obtained according to the comparison result, the method further includes:
And performing secondary comparison on the first reconciliation mismatch file and the second reconciliation mismatch file.
Optionally, the comparison result further includes: a first day reconciliation file for storing file data required for next day reconciliation of the target day existing in the first reconciliation file, and a second day reconciliation file for storing file data required for next day reconciliation of the target day existing in the second reconciliation file.
The embodiment of the invention also provides a file account checking processing device, which has the advantages of small resource consumption, short time required by the file account checking processing and high efficiency, and the device comprises:
the merging module is used for merging transaction files participating in target day reconciliation 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 splitting files and a plurality of second splitting 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;
The file processing module is used for acquiring a first reconciliation mismatch file and a second reconciliation mismatch file according to the comparison result, wherein the first reconciliation mismatch file is used for storing file data which are in the first reconciliation file and are not in the second reconciliation file, and the second reconciliation mismatch file is used for storing file data which are in the second reconciliation file and are not in the first reconciliation file.
Optionally, the first reconciliation file and the second reconciliation file are QSAM files;
the apparatus further comprises:
And the ordering module is used for ordering the file data in the first reconciliation file and the second reconciliation file.
Optionally, the apparatus further includes:
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 includes:
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 comparison result further includes: a first day reconciliation file for storing file data required for next day reconciliation of the target day existing in the first reconciliation file, and a second day reconciliation file for storing file data required for next day reconciliation of the target day existing in the second reconciliation file.
The embodiment of the invention also provides computer equipment, which comprises a memory, a processor and a computer program stored on the memory and capable of running on the processor, wherein the processor realizes the method when executing the computer program.
Embodiments of the present invention also provide a computer-readable storage medium storing a computer program for executing the above method.
In the embodiment of the invention, the transaction files participating in the daily reconciliation are combined 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 first split files and the second split files, the corresponding file data in the first split files and the second split files are compared, the first reconciliation unmatched file and the second reconciliation unmatched file are acquired according to the comparison result, the performance of the database is not required to be monitored in real time, maintenance processing and the like of the database are added, the resource consumption is low, the time required for the file reconciliation processing is short, and the efficiency is high.
Drawings
In order to more clearly illustrate the embodiments of the invention or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art. In the drawings:
FIG. 1 is a flow chart of a file reconciliation process methodology in an embodiment of the invention;
FIG. 2 is a flow chart of ordering document data within a first reconciliation document and a second reconciliation document in an embodiment of the invention;
FIG. 3 is a flowchart 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;
FIG. 4 is a flow chart of a file reconciliation process methodology in accordance with an embodiment of the invention;
FIG. 5 is a schematic diagram of a file reconciliation processing apparatus in accordance with an embodiment of the invention;
FIG. 6 is a schematic diagram of a structure for sorting document data in a first reconciliation document and a second reconciliation document in an embodiment of the invention;
FIG. 7 is a schematic diagram of a structure for 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;
FIG. 8 is a schematic diagram of a file reconciliation processing apparatus in accordance with an embodiment of the invention;
FIG. 9 is a diagram illustrating a document reconciliation process in accordance with an embodiment of the invention;
FIG. 10 is a diagram illustrating a document reconciliation process in accordance with an embodiment of the invention;
FIG. 11 is a schematic diagram of a computer device according to an embodiment of the invention.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention will be described in further detail with reference to the accompanying drawings. The exemplary embodiments of the present invention and their descriptions herein are for the purpose of explaining the present invention, but are not to be construed as limiting the invention.
Fig. 1 is a flowchart of a document reconciliation processing method provided in an embodiment of the present invention, as shown in fig. 1, where the method includes:
step 101, merging transaction files participating in the objective daily reconciliation to generate a first reconciliation file and a second reconciliation file for reconciliation.
In an embodiment, since the documents participating in the reconciliation may include multiple documents, the transaction documents participating in the reconciliation on the target day include transaction documents of each party, for example, a plurality of transaction documents requiring the reconciliation on the banking party's day, a plurality of transaction documents requiring the reconciliation on the external system party's day, and so on. In addition, the document participating in reconciliation further includes: a file to participate in the next day reconciliation of the target day. In this process, the formats of all files need to be kept consistent, and the keywords of the fields in the files are the same.
Step 102, splitting the first reconciliation document and the second reconciliation document into a plurality of first split documents and a plurality of second split documents, respectively.
In the 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 of the first split files and the second split files 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.
And 103, comparing the file data corresponding to the plurality of first split files and the plurality of second split files.
In the implementation, the comparison and parallel processing can be performed on the corresponding file data in the plurality of first split files and the plurality of second split files, and the parallel processing job data can be configured according to the system allowable value.
Step 104, obtaining a first reconciliation mismatch file and a second reconciliation mismatch file according to the comparison result, wherein the first reconciliation mismatch file is used for storing file data in the first reconciliation file and file data in the second reconciliation file, and the second reconciliation mismatch file is used for storing file data in the second reconciliation file and file data in the first reconciliation file. A specific document reconciliation process flow diagram may be seen in fig. 10.
As can be seen from fig. 1, in the file reconciliation processing method provided by the embodiment of the present invention, by performing merging processing on transaction files participating in objective day reconciliation to generate a first reconciliation file and a second reconciliation file for reconciliation, splitting the first reconciliation file and the second reconciliation file into a plurality of first split files and a plurality of second split files, comparing file data corresponding to the plurality of first split files and the plurality of second split files, and acquiring a first reconciliation unmatched file and a second reconciliation unmatched file according to a comparison result, without monitoring database performance in real time, adding maintenance processing of a database, etc., resource consumption is small, time required for file reconciliation processing is short, and efficiency is high.
Fig. 2 is a flowchart of sorting file data in a first reconciliation file and a second reconciliation file according to an embodiment of the 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:
Step 201, sorting the file data in the first reconciliation file and the second reconciliation file.
In particular, DFSORT (operating system commands) are used to sort the document data (QSAM documents) within the first and second reconciliation documents. It should be noted that, because of the processing mechanism of the VSAM-KSDS itself, when QSAM data is written into the VSAM, the system automatically performs ascending data reorganization according to its key value, so as to reduce the processing efficiency of the whole reconciliation job.
In fig. 3, according to the flow chart of format conversion of the first split files and the second split files, for convenience in comparing the two files, the reconciliation efficiency is improved, as shown in fig. 3, after splitting the first reconciliation file and the second reconciliation file into the first split files and the second split files, the method further includes:
Step 301, converting the formats of the plurality of first split files and the plurality of second split files into VSAM files.
In an embodiment, since the VSAM file has a key value, comparison is convenient, so that the plurality of first split files and the plurality of second split file formats can be converted into the VSAM file. In particular implementations, the QSAM file may be converted to a VSAM file using the ZOS operating system commands IDCAMS.
Fig. 4 is a flowchart of a document reconciliation processing method provided by an embodiment of the present invention, where, as shown in fig. 4, after a first reconciliation mismatched document and a second reconciliation mismatched document are obtained according to a comparison result, the method further includes:
step 401, performing secondary comparison on the first reconciliation mismatch file and the second reconciliation mismatch file.
Because the file is split, the boundary records of the file 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), in order to ensure the accuracy of the reconciliation result, the first reconciliation mismatched file and the second reconciliation mismatched file may be secondarily compared, and the same record in the two files may be deleted.
In the embodiment of the present invention, the comparison result further includes: a first day reconciliation file for storing file data required for next day reconciliation of the target day existing in the first reconciliation file, and a second day reconciliation file for storing file data required for next day reconciliation of the target day existing in the second reconciliation file.
In specific implementation, the first day account checking file and the second day account checking file can be added into a plurality of transaction files of the next day account checking for processing, and in particular, see fig. 9.
Based on the same inventive concept, the embodiment of the invention also provides a document reconciliation processing device, as described in the following embodiment. Since the principle of the document reconciliation processing apparatus for solving the problem is similar to that of the document reconciliation processing method, implementation of the document reconciliation processing apparatus can refer to implementation of the document reconciliation processing method, and repeated parts are not repeated. As used below, the term "unit" or "module" may be a combination of software and/or hardware that implements the intended function. While the means described in the following embodiments are preferably implemented in software, implementation in hardware, or a combination of software and hardware, is also possible and contemplated.
Fig. 5 is a schematic structural diagram of a document reconciliation processing device according to an embodiment of the present invention, as shown in fig. 5, the device includes:
The merging module 501 is configured to perform merging processing on transaction files participating in the objective day reconciliation, so as 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 comparison 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 a first reconciliation mismatch file and a second reconciliation mismatch file according to the comparison result, where the first reconciliation mismatch file is used for storing file data in the first reconciliation file and file data in the second reconciliation file, and the second reconciliation mismatch file is used for storing file data in the second reconciliation file and file data in the first reconciliation file.
Fig. 6 is a schematic structural diagram of sorting file data in a first reconciliation file and a second reconciliation file according to an embodiment of the 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 file data in the first reconciliation file and the second reconciliation file.
Fig. 7 is a schematic structural diagram of format conversion of a plurality of first split files and a plurality of second split files according to an embodiment of the present invention, where, as shown in fig. 7, the apparatus further includes:
The format conversion module 701 is configured to convert the plurality of first split files and the plurality of second split files into VSAM files.
Fig. 8 is a schematic structural diagram of a document reconciliation processing device provided by an embodiment of the present invention, as shown in fig. 8, where the device further includes:
The secondary comparison module 801 is configured to perform secondary comparison on the first reconciliation mismatch file and the second reconciliation mismatch file.
In the embodiment of the present invention, the comparison result further includes: a first day reconciliation file for storing file data required for next day reconciliation of the target day existing in the first reconciliation file, and a second day reconciliation file for storing file data required for next day reconciliation of the target day existing in the second reconciliation 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 includes a memory, a processor, a communication interface, and a communication bus, where a computer program executable on the processor is stored on the memory, and when the processor executes the computer program, the steps in the method of the above embodiment are implemented.
The processor may be a central processing unit (Central Processing Unit, CPU). The Processor may also be other general purpose processors, digital Signal Processors (DSP), application SPECIFIC INTEGRATED Circuits (ASIC), field-Programmable gate arrays (Field-Programmable GATE ARRAY, FPGA) or other Programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or a combination of the above.
The memory is used as a non-transitory computer readable storage medium for storing non-transitory software programs, non-transitory computer executable programs, and units, such as corresponding program units in the above-described method embodiments of the invention. The processor executes the various functional applications of the processor and the processing of the composition data by running non-transitory software programs, instructions and modules stored in the memory, i.e., implementing the methods of the method embodiments described above.
The memory may include a memory program area and a memory data area, wherein the memory program area may store an operating system, at least one application program required for a function; the storage data area may store data created by the processor, etc. In addition, the memory may include high-speed random access memory, and may also include non-transitory memory, such as at least one magnetic disk storage device, flash memory device, or other non-transitory solid state storage device. In some embodiments, the memory may optionally include memory located remotely from the processor, the remote memory being connectable to the processor through 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, which when executed by the processor, performs the method in the above embodiments.
Embodiments of the present invention also provide a computer-readable storage medium storing a computer program for executing the above method.
It will be appreciated by those skilled in the art that 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 flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations 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 foregoing description of the embodiments has been provided for the purpose of illustrating the general principles of the invention, and is not meant to limit the scope of the invention, but to limit the invention to the particular embodiments, and any modifications, equivalents, improvements, etc. that fall within the spirit and principles of the invention are intended to be included within the scope of the invention.
Claims (8)
1. A document reconciliation processing method, comprising:
Merging transaction files participating in target day reconciliation to generate a first reconciliation file and a second reconciliation file for reconciliation;
Dividing the first account checking file and the second account checking file into a plurality of first divided files and a plurality of second divided files respectively according to the fixed record number; each first split file and each second split file are subjected to parameter configuration;
Comparing the file data corresponding to the first split files with the second split files;
Acquiring a first reconciliation mismatch file and a second reconciliation mismatch file according to the comparison result, wherein the first reconciliation mismatch file is used for storing file data which is in the first reconciliation file and is not in the second reconciliation file, and the second reconciliation mismatch file is used for storing file data which is in the second reconciliation file and is not in the first reconciliation file;
Comparing the file data corresponding to the plurality of first split files and the plurality of second split files, including:
comparing and parallel processing is carried out on the file data corresponding to the plurality of first split files and the plurality of second split files, and the parallel processing operation data is configured according to the system allowable value;
The first reconciliation file and the second reconciliation file are QSAM files;
After generating the first and second reconciliation documents for reconciliation, the method further comprises:
using an operating system command DFSORT to sort file data in the first reconciliation file and the second reconciliation file;
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, respectively, the method further comprises:
the plurality of first split files and the plurality of second split file formats are converted to VSAM files using ZOS operating system commands IDCAMS.
2. The method of claim 1, wherein after obtaining the first reconciliation mismatch file and the second reconciliation mismatch file based on the comparison, the method further comprises:
And performing secondary comparison on the first reconciliation mismatch file and the second reconciliation mismatch file.
3. The method of claim 1, wherein the comparison further comprises: a first day reconciliation file for storing file data required for next day reconciliation of the target day existing in the first reconciliation file, and a second day reconciliation file for storing file data required for next day reconciliation of the target day existing in the second reconciliation file.
4. A document reconciliation processing apparatus, comprising:
the merging module is used for merging transaction files participating in target day reconciliation 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 splitting files and a plurality of second splitting files respectively according to the fixed record number; each first split file and each second split file are subjected to parameter configuration;
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;
the file processing module is used for acquiring a first reconciliation unmatched file and a second reconciliation unmatched file according to the comparison result, wherein the first reconciliation unmatched file is used for storing file data which are in the first reconciliation file and are not in the second reconciliation file, and the second reconciliation unmatched file is used for storing file data which are in the second reconciliation file and are not in the first reconciliation file;
The comparison module is specifically used for comparing and parallel processing corresponding file data in the plurality of first split files and the plurality of second split files, and the parallel processing operation data is configured according to the system allowable value;
The first reconciliation file and the second reconciliation file are QSAM files;
the apparatus further comprises: the ordering module is used for ordering file data in the first reconciliation file and the second reconciliation file by using the operating system command DFSORT;
the apparatus further comprises: and a format conversion module for converting the plurality of first split files and the plurality of second split file formats into VSAM files using the ZOS operating system command IDCAMS.
5. The apparatus of claim 4, wherein the apparatus further comprises:
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.
6. The apparatus of claim 4, wherein the comparison further comprises: a first day reconciliation file for storing file data required for next day reconciliation of the target day existing in the first reconciliation file, and a second day reconciliation file for storing file data required for next day reconciliation of the target day existing in the second reconciliation file.
7. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the method of any of claims 1 to 3 when executing the computer program.
8. 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 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010980313.3A CN112037003B (en) | 2020-09-17 | 2020-09-17 | File reconciliation processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010980313.3A CN112037003B (en) | 2020-09-17 | 2020-09-17 | File reconciliation processing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112037003A CN112037003A (en) | 2020-12-04 |
| CN112037003B true CN112037003B (en) | 2024-10-18 |
Family
ID=73590084
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010980313.3A Active CN112037003B (en) | 2020-09-17 | 2020-09-17 | File reconciliation processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112037003B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113342750B (en) * | 2021-06-29 | 2023-11-17 | 深圳前海微众银行股份有限公司 | File data comparison method, device, equipment and storage medium |
| CN113590553B (en) * | 2021-08-03 | 2024-08-16 | 京东科技控股股份有限公司 | Account checking method, account checking device, electronic equipment and computer readable medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108876491A (en) * | 2017-05-11 | 2018-11-23 | 艾玛迪斯公司 | For handling and the system and method for checking of invoice data file |
| CN107798109A (en) * | 2017-11-01 | 2018-03-13 | 深圳市牛鼎丰科技有限公司 | Method, apparatus, computer equipment and the storage medium of reconciliation clearance |
| CN108961029B (en) * | 2018-07-26 | 2022-05-06 | 创新先进技术有限公司 | Distributed account checking processing method, system and terminal equipment |
-
2020
- 2020-09-17 CN CN202010980313.3A patent/CN112037003B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112037003A (en) | 2020-12-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109034993B (en) | Account checking method, account checking equipment, account checking system and computer readable storage medium | |
| CN108694195B (en) | Management method and system of distributed data warehouse | |
| US9361343B2 (en) | Method for parallel mining of temporal relations in large event file | |
| WO2016022492A1 (en) | Account processing method and apparatus | |
| CN106126601A (en) | A kind of social security distributed preprocess method of big data and system | |
| KR101374533B1 (en) | High performance replication system and backup system for mass storage data, method of the same | |
| CN104021194A (en) | Mixed type processing system and method oriented to industry big data diversity application | |
| CN104317928A (en) | Service ETL (extraction-transformation-loading) method and service ETL system both based on distributed database | |
| CN107784030B (en) | Method and device for processing connection query | |
| CN106503974B (en) | Transaction data processing method and device | |
| CN112037003B (en) | File reconciliation processing method and device | |
| CN111400288A (en) | Data quality inspection method and system | |
| CN111767320A (en) | Data blood relationship determination method and device | |
| US20160203032A1 (en) | Series data parallel analysis infrastructure and parallel distributed processing method therefor | |
| CN109241163B (en) | Electronic certificate generation method and terminal equipment | |
| CN114385188A (en) | Code workload statistical method and device and electronic equipment | |
| CN106843822B (en) | Execution code generation method and equipment | |
| CN106502842A (en) | Data reconstruction method and system | |
| CN107526573B (en) | Method for processing remote sensing image by adopting parallel pipeline | |
| CN115618825A (en) | Financial statement merging method and device, computer readable medium and terminal equipment | |
| CN115344633A (en) | Data processing method, device, equipment and storage medium | |
| CN113568892A (en) | Method and equipment for carrying out data query on data source based on memory calculation | |
| CN112052341A (en) | Knowledge graph pruning method and device | |
| CN112181825A (en) | Test case library construction method and device, electronic equipment and medium | |
| CN110765193A (en) | Method and device for exporting block chain data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |