CN112613964A - Account checking method, account checking device, account checking equipment and storage medium - Google Patents
Account checking method, account checking device, account checking equipment and storage medium Download PDFInfo
- Publication number
- CN112613964A CN112613964A CN202011567021.3A CN202011567021A CN112613964A CN 112613964 A CN112613964 A CN 112613964A CN 202011567021 A CN202011567021 A CN 202011567021A CN 112613964 A CN112613964 A CN 112613964A
- Authority
- CN
- China
- Prior art keywords
- account checking
- data
- checking data
- target
- reconciliation
- 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
- 238000000034 method Methods 0.000 title claims abstract description 36
- 230000015654 memory Effects 0.000 claims abstract description 57
- 238000012163 sequencing technique Methods 0.000 claims abstract description 27
- 238000004590 computer program Methods 0.000 claims description 10
- 238000010586 diagram Methods 0.000 description 9
- 230000003287 optical effect Effects 0.000 description 8
- 230000006870 function Effects 0.000 description 7
- 238000011161 development Methods 0.000 description 6
- 238000012545 processing Methods 0.000 description 5
- 238000004891 communication Methods 0.000 description 4
- 238000011835 investigation Methods 0.000 description 3
- 239000013307 optical fiber Substances 0.000 description 3
- 238000003491 array Methods 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 230000002093 peripheral effect Effects 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 239000004065 semiconductor Substances 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000004140 cleaning Methods 0.000 description 1
- 230000008707 rearrangement Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012546 transfer 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
- G06Q40/125—Finance or payroll
-
- 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/13—File access structures, e.g. distributed indices
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses a reconciliation method, a reconciliation device, a reconciliation equipment and a storage medium. The method comprises the following steps: receiving a first party account checking data file sent by a first terminal and a second party account checking data file sent by a second terminal; sequencing the first party account checking data files to obtain first target account checking data; sequencing the second party account checking data files to obtain second target account checking data, wherein the field identifications of the same positions of the first target account checking data and the second target account checking data are the same; according to the technical scheme, the account checking can be performed according to the first target account checking data and the second target account checking data, the bill account checking with a higher data magnitude can be performed by using the file aiming at the account checking scene with a larger data magnitude, the account checking efficiency is greatly improved, and meanwhile, the consumption of resources such as machines and memories is reduced.
Description
Technical Field
The embodiment of the invention relates to the technical field of computers, in particular to a reconciliation method, a reconciliation device, a reconciliation equipment and a storage medium.
Background
With the rapid development of internet finance, loan businesses developed based on the internet are more and more, the transaction modes of the loan businesses are more and more complex, the related roles are more and more, and the requirement on account checking after loan is higher and more. On one hand, as the business increases and the data volume rises, the time for the system to perform account checking is longer and longer, and the pressure on a database and a machine is also larger and larger; on the other hand, development/operation personnel need to spend more and more time maintaining the data with bad accounts. Internet finance has urgent needs for improving the system efficiency of post-loan reconciliation and for facilitating the user experience of maintenance.
Disclosure of Invention
Embodiments of the present invention provide a reconciliation method, an apparatus, a device, and a storage medium, so as to implement reconciliation with a higher data level by using a file to execute a higher data level bill, thereby greatly improving the efficiency of reconciliation and reducing the consumption of resources such as a machine and a memory. And the account checking source file and the result file are stored, so that the efficiency of solving account checking difference data by development/operation investigation is further improved, and the user experience is improved.
In a first aspect, an embodiment of the present invention provides an account checking method, including:
receiving a first party account checking data file sent by a first terminal and a second party account checking data file sent by a second terminal;
sequencing the first party account checking data files to obtain first target account checking data;
sequencing the second party account checking data files to obtain second target account checking data, wherein the field identifications of the same positions of the first target account checking data and the second target account checking data are the same;
and checking according to the first target checking data and the second target checking data.
In a second aspect, an embodiment of the present invention further provides an account checking device, where the device includes:
the receiving module is used for receiving a first party account checking data file sent by a first terminal and a second party account checking data file sent by a second terminal;
the first sequencing module is used for sequencing the first party account checking data file to obtain first target account checking data;
the second sequencing module is used for sequencing the second party account checking data file to obtain second target account checking data, wherein the field identifications of the same positions of the first target account checking data and the second target account checking data are the same;
and the reconciliation module is used for performing reconciliation according to the first target reconciliation data and the second target reconciliation data.
In a third aspect, an embodiment of the present invention further provides a computer device, including a memory, a processor, and a computer program stored on the memory and executable on the processor, where the processor executes the computer program to implement the reconciliation method according to any one of the embodiments of the present invention.
In a fourth aspect, the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the reconciliation method according to any one of the embodiments of the present invention.
The method comprises the steps of receiving a first party account checking data file sent by a first terminal and a second party account checking data file sent by a second terminal; sequencing the first party account checking data files to obtain first target account checking data; sequencing the second party account checking data files to obtain second target account checking data, wherein the field identifications of the same positions of the first target account checking data and the second target account checking data are the same; and checking accounts according to the first target account checking data and the second target account checking data so as to solve account checking scenes with large data magnitude.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present invention and therefore should not be considered as limiting the scope, and for those skilled in the art, other related drawings can be obtained according to the drawings without inventive efforts.
Fig. 1 is a flowchart of a reconciliation method in a first embodiment of the present invention;
FIG. 1a is a flow chart of a sorting method according to a first embodiment of the present invention;
FIG. 1b is a flowchart illustrating reconciliation according to a first embodiment of the present invention;
FIG. 1c is a core reconciliation flow chart according to a first embodiment of the present invention;
fig. 2 is a schematic structural diagram of an account checking device in a second embodiment of the present invention;
fig. 3 is a schematic structural diagram of a computer device in a third embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, it need not be further defined and explained in subsequent figures. Meanwhile, in the description of the present invention, the terms "first", "second", and the like are used only for distinguishing the description, and are not to be construed as indicating or implying relative importance.
Example one
Fig. 1 is a flowchart of an account checking method provided in an embodiment of the present invention, where this embodiment is applicable to a case of performing account checking, and the method may be executed by an account checking apparatus in an embodiment of the present invention, and the apparatus may be implemented in a software and/or hardware manner, as shown in fig. 1, the method specifically includes the following steps:
s110, receiving a first party account checking data file sent by a first terminal and a second party account checking data file sent by a second terminal.
For example, the first party reconciliation data file may be a my party reconciliation data file, or may be an external reconciliation data file, which is not limited in this embodiment of the present invention.
Illustratively, two parties agree on account checking time, and when the account checking time is up, an account checking instruction is generated, wherein the account checking instruction carries account checking information; the first terminal determines a first party account checking data file according to the account checking information, and the first terminal sends the first party account checking data file to the server; the second party account checking data file can be acquired by appointing account checking time for both parties, and when the account checking time is up, an account checking instruction is generated, wherein the account checking instruction carries account checking information; and the second terminal determines a second party account checking data file according to the account checking information, the second terminal sends the second party account checking data file to the server, and the server receives the first party account checking data file sent by the first terminal and the second party account checking data file sent by the second terminal.
And S120, sequencing the first party account checking data files to obtain first target account checking data.
Illustratively, the manner of sorting the first party reconciliation data file to obtain the first target reconciliation data may be an external sorting of the first party reconciliation data file; and merging and sorting the first party account checking data files after external sorting to obtain first target account checking data. For example, an algorithm "External Sort + Merge Sort" may be used, so that disk space may be utilized to save memory. When the data size is large, all the file data are stored in the memory for sorting, so the condition of oom (out of memory) is very easy to occur. The specific algorithm is shown in fig. 1a, taking a file of 900MB as an example, 1. firstly, the file is cut into small files of equal amount and multiple copies and written into a disk; 2. sorting the cut files; 3. reading the first 10MB (the specific size can be adjusted by self) data of all the cut and sequenced files to a memory space; 4. outputting the data with the top sequence in the memory to a new file one by one; 5. when a line of data is output, new data of the corresponding cut and sequenced file needs to be read and put into a memory; 6. and repeating the steps 4 and 5 until all the file data are sorted.
S130, sorting the second party account checking data files to obtain second target account checking data, wherein the field identifications of the same positions of the first target account checking data and the second target account checking data are the same.
The field identifier may be an order number, the field identifier may also be an order number and a term, and the field identifier may also be other unique identifier fields, which is not limited in this embodiment of the present invention.
Illustratively, the second party reconciliation data file is sorted out; and merging and sorting the externally sorted second party account checking data files to obtain second target account checking data. For example, an algorithm "External Sort + Merge Sort" may be used, so that disk space may be utilized to save memory. When the data size is large, all the file data are stored in the memory for sorting, so the condition of oom (out of memory) is very easy to occur. The specific algorithm is shown in fig. 1a, taking a file of 900MB as an example, 1. firstly, the file is cut into small files of equal amount and multiple copies and written into a disk; 2. sorting the cut files; 3. reading the first 10MB (the specific size can be adjusted by self) data of all the cut and sequenced files to a memory space; 4. outputting the data with the top sequence in the memory to a new file one by one; 5. when a line of data is output, new data of the corresponding cut and sequenced file needs to be read and put into a memory; 6. and repeating the steps 4 and 5 until all the file data are sorted.
And S140, checking according to the first target checking data and the second target checking data.
Optionally, performing reconciliation according to the first target reconciliation data and the second target reconciliation data includes:
reading the first target account checking data and the second target account checking data line by line;
and checking accounts according to the reading state.
Optionally, reconciling according to the read status includes:
if the reading state of the first target account checking data is empty and the reading state of the second target account checking data is empty, the account checking is finished;
if the reading state of the first target account checking data is null and the reading state of the second target account checking data is not null, recording a multi-account difference;
and if the reading state of the second target account checking data is null and the reading state of the first target account checking data is not null, recording the account-less difference.
Optionally, the method further includes:
if the reading state of the first target account checking data is not null and the reading state of the second target account checking data is not null, comparing the sequencing fields;
if the asset number of the first target reconciliation data is greater than the asset number of the second target reconciliation data, recording the account-less difference;
and if the asset number of the first target account checking data is smaller than the asset number of the second target account checking data, recording the multi-account difference.
Optionally, sorting the first party reconciliation data file to obtain first target reconciliation data, including:
performing external sorting on the first party reconciliation data file;
and merging and sorting the first party account checking data files after external sorting to obtain first target account checking data.
Optionally, sorting the second party reconciliation data file to obtain second target reconciliation data, including:
carrying out external sorting on the reconciliation data files of the second party;
and merging and sorting the externally sorted second party account checking data files to obtain second target account checking data.
Optionally, the external sorting of the second party reconciliation data file includes:
cutting the second party reconciliation data file into at least two equivalent sub-files;
writing at least two sub-files into a magnetic disk;
sorting at least two sub-files;
reading data which are sequenced to be a preset size in the cut and sequenced files, and storing the data to a memory space;
outputting the data with the top sequence in the memory to a target file one by one;
reading new data of the cut and sequenced files corresponding to the line data and putting the new data into a memory while outputting each line of data;
until all file data sorting is completed.
Optionally, the external sorting of the first party reconciliation data file includes:
cutting the first party account checking data file into at least two sub-files with equal quantity;
writing at least two sub-files into a magnetic disk;
sorting at least two sub-files;
reading data which are sequenced to be a preset size in the cut and sequenced files, and storing the data to a memory space;
outputting the data with the top sequence in the memory to a target file one by one;
reading new data of the cut and sequenced files corresponding to the line data and putting the new data into a memory while outputting each line of data;
until all file data sorting is completed.
In a specific example, fig. 1b is a main flow chart of the technical solution of the present invention. As shown in fig. 1b, the reconciliation method provided by the invention with high efficiency and easy maintenance comprises the following steps:
(1) my reconciliation data files are generated from the big data platform (required reconciliation files can also be generated from other data sources, but suggestions are isolated from the underlying database of the business, and do not influence the main process of the business).
(2) And acquiring an external reconciliation data file, and if necessary, performing format conversion and data cleaning on the external data file so as to convert the external reconciliation data file into a unified standard and reduce the complexity of the reconciliation logic.
(3) And (4) ordering the two pieces of file data, wherein the ordered fields need to be consistent, such as an order number or an order number plus the period number or other unique identification fields.
When the file data is sorted, an algorithm of 'External Sort + Merge Sort' is used, so that the memory space can be saved by using the disk space. When the data size is large, all the file data are stored in the memory for sorting, so the condition of oom (out of memory) is very easy to occur. Taking a file of 900MB as an example, 1, firstly, cutting the file into small files of a plurality of equal parts, and writing the small files into a disk; 2. sorting the cut files; 3. reading the first 10MB (the specific size can be adjusted by self) data of all the cut and sequenced files to a memory space; 4. outputting the data with the top sequence in the memory to a new file one by one; 5. when a line of data is output, new data of the corresponding cut and sequenced file needs to be read and put into a memory; 6. and repeating the steps 4 and 5 until all the file data are sorted.
(4) And reading the account checking data file of the party and the external account checking data file line by line, and executing core account checking logic. The core reconciliation logic is shown in fig. 1 c. The specific process is as follows: 1. reading the sorted account checking file data of the party and the external account checking file data line by line; 2. and judging the data reading condition, and if the data reading condition is empty, ending the account checking. If one party is empty, the account is more than or less than the account; 3. if none of the data is empty, the order number (sort field) is compared. The external part of my > is a low account, the external part of my < is a high account, and the external part of my indicates an order, which needs to be compared.
(5) Writing the account checking result into an account checking result file according to the account checking result in the step (4);
(6) recording the account checking result into a database according to the account checking result in the step (4);
(7) saving the account checking data file of the party, the external account checking data file and the account checking result file in the steps (3) and (5);
the embodiment of the invention generates the reconciliation data file of the principal and the reconciliation data file of the principal according to the dimension of the principal. And then sorting according to the order number, and reducing the memory consumption of the machine by using an external sorting algorithm and a merging sorting algorithm during sorting. Then, the core reconciliation logic is executed on the two files, and a reconciliation result file is generated. For the data with uneven account checking, development/operation personnel only need to check and communicate with the outside according to the account checking result file.
Compared with the traditional method for checking account by using a database, the method and the device for checking account by using the file greatly improve the efficiency of checking account and reduce the consumption of data and machine resources. The sorting of the file data uses an algorithm of 'External Sort) + Merge Sort', so that the occurrence of a large file reconciliation OOM (out of memory) scene is avoided, and the use of machine memory resources is greatly reduced. According to the technical scheme of the embodiment, a first party account checking data file sent by a first terminal and a second party account checking data file sent by a second terminal are received; sequencing the first party account checking data files to obtain first target account checking data; sequencing the second party account checking data files to obtain second target account checking data, wherein the field identifications of the same positions of the first target account checking data and the second target account checking data are the same; and checking accounts according to the first target account checking data and the second target account checking data so as to realize the purpose of performing the bill account checking with higher data magnitude by using the file aiming at the account checking scene with larger data magnitude, thereby greatly improving the account checking efficiency and reducing the consumption of resources such as machines, memories and the like. And the account checking source file and the result file are stored, so that the efficiency of solving account checking difference data by development/operation investigation is further improved, and the user experience is improved.
Example two
Fig. 2 is a schematic structural diagram of an account checking device according to a second embodiment of the present invention. The embodiment is applicable to the case of account checking, the apparatus may be implemented in a software and/or hardware manner, and the apparatus may be integrated in any device providing an account checking function, as shown in fig. 2, where the account checking apparatus specifically includes: a receiving module 210, a first ordering module 220, a second ordering module 230, and a reconciliation module 240.
The receiving module 210 is configured to receive a first party account checking data file sent by a first terminal and a second party account checking data file sent by a second terminal;
the first ordering module 220 is configured to order the first party account checking data file to obtain first target account checking data;
a second sorting module 230, configured to sort the second-party reconciliation data file to obtain second target reconciliation data, where field identifiers of the same positions of the first target reconciliation data and the second target reconciliation data are the same;
and a reconciliation module 240, configured to perform reconciliation according to the first target reconciliation data and the second target reconciliation data.
The product can execute the method provided by any embodiment of the invention, and has corresponding functional modules and beneficial effects of the execution method.
According to the technical scheme of the embodiment, a first party account checking data file sent by a first terminal and a second party account checking data file sent by a second terminal are received; sequencing the first party account checking data files to obtain first target account checking data; sequencing the second party account checking data files to obtain second target account checking data, wherein the field identifications of the same positions of the first target account checking data and the second target account checking data are the same; and checking accounts according to the first target account checking data and the second target account checking data so as to realize the purpose of performing the bill account checking with higher data magnitude by using the file aiming at the account checking scene with larger data magnitude, thereby greatly improving the account checking efficiency and reducing the consumption of resources such as machines, memories and the like. And the account checking source file and the result file are stored, so that the efficiency of solving account checking difference data by development/operation investigation is further improved, and the user experience is improved.
EXAMPLE III
Fig. 3 is a schematic structural diagram of a computer device in a third embodiment of the present invention. FIG. 3 illustrates a block diagram of an exemplary computer device 12 suitable for use in implementing embodiments of the present invention. The computer device 12 shown in FIG. 3 is only an example and should not impose any limitation on the scope of use or functionality of embodiments of the present invention.
As shown in FIG. 3, computer device 12 is in the form of a general purpose computing device. The components of computer device 12 may include, but are not limited to: one or more processors or processing units 16, a system memory 28, and a bus 18 that couples various system components including the system memory 28 and the processing unit 16.
The system Memory 28 may include computer system readable media in the form of volatile Memory, such as Random Access Memory (RAM) 30 and/or cache Memory 32. Computer device 12 may further include other removable/non-removable, volatile/nonvolatile computer system storage media. By way of example only, storage system 34 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown in FIG. 3, and commonly referred to as a "hard drive"). Although not shown in FIG. 3, a magnetic disk drive for reading from and writing to a removable, nonvolatile magnetic disk (e.g., a "floppy disk") and an optical disk drive for reading from or writing to a removable, nonvolatile optical disk (a Compact disk-Read Only Memory (CD-ROM)), Digital Video disk (DVD-ROM), or other optical media may be provided. In these cases, each drive may be connected to bus 18 by one or more data media interfaces. Memory 28 may include at least one program product having a set (e.g., at least one) of program modules that are configured to carry out the functions of embodiments of the invention.
A program/utility 40 having a set (at least one) of program modules 42 may be stored, for example, in memory 28, such program modules 42 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which examples or some combination thereof may comprise an implementation of a network environment. Program modules 42 generally carry out the functions and/or methodologies of the described embodiments of the invention.
The processing unit 16 executes various functional applications and data processing by executing programs stored in the system memory 28, for example, implementing the reconciliation method provided by the embodiment of the invention:
receiving a first party account checking data file sent by a first terminal and a second party account checking data file sent by a second terminal;
sequencing the first party account checking data files to obtain first target account checking data;
sequencing the second party account checking data files to obtain second target account checking data, wherein the field identifications of the same positions of the first target account checking data and the second target account checking data are the same;
and checking according to the first target checking data and the second target checking data.
Example four
A fourth embodiment of the present invention provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the reconciliation method provided in all the embodiments of the present invention:
receiving a first party account checking data file sent by a first terminal and a second party account checking data file sent by a second terminal;
sequencing the first party account checking data files to obtain first target account checking data;
sequencing the second party account checking data files to obtain second target account checking data, wherein the field identifications of the same positions of the first target account checking data and the second target account checking data are the same;
and checking according to the first target checking data and the second target checking data.
Any combination of one or more computer-readable media may be employed. The computer readable medium may be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.
Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
In some embodiments, the clients, servers may communicate using any currently known or future developed network Protocol, such as HTTP (Hyper Text Transfer Protocol), and may interconnect with any form or medium of digital data communication (e.g., a communications network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), the Internet (e.g., the Internet), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future developed network.
The computer readable medium may be embodied in the electronic device; or may exist separately without being assembled into the electronic device.
Computer program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + +, or the like, as well as conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units described in the embodiments of the present disclosure may be implemented by software or hardware. Where the name of an element does not in some cases constitute a limitation on the element itself.
The functions described herein above may be performed, at least in part, by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: field Programmable Gate Arrays (FPGAs), Application Specific Integrated Circuits (ASICs), Application Specific Standard Products (ASSPs), systems on a chip (SOCs), Complex Programmable Logic Devices (CPLDs), and the like.
In the context of this disclosure, a machine-readable medium may be a tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (10)
1. A reconciliation method, comprising:
receiving a first party account checking data file sent by a first terminal and a second party account checking data file sent by a second terminal;
sequencing the first party account checking data files to obtain first target account checking data;
sequencing the second party account checking data files to obtain second target account checking data, wherein the field identifications of the same positions of the first target account checking data and the second target account checking data are the same;
and checking according to the first target checking data and the second target checking data.
2. The method of claim 1, wherein reconciling from the first targeted reconciliation data and the second targeted reconciliation data comprises:
reading the first target account checking data and the second target account checking data line by line;
and checking accounts according to the reading state.
3. The method of claim 2, wherein reconciling based on the read status comprises:
if the reading state of the first target account checking data is empty and the reading state of the second target account checking data is empty, the account checking is finished;
if the reading state of the first target account checking data is null and the reading state of the second target account checking data is not null, recording a multi-account difference;
and if the reading state of the second target account checking data is null and the reading state of the first target account checking data is not null, recording the account-less difference.
4. The method of claim 3, further comprising:
if the reading state of the first target account checking data is not null and the reading state of the second target account checking data is not null, comparing the sequencing fields;
if the asset number of the first target reconciliation data is greater than the asset number of the second target reconciliation data, recording the account-less difference;
and if the asset number of the first target account checking data is smaller than the asset number of the second target account checking data, recording the multi-account difference.
5. The method of claim 1, wherein sorting the first party reconciliation data file to obtain first target reconciliation data comprises:
performing external sorting on the first party reconciliation data file;
and merging and sorting the first party account checking data files after external sorting to obtain first target account checking data.
6. The method of claim 1, wherein sorting the second party reconciliation data file to obtain second target reconciliation data comprises:
carrying out external sorting on the reconciliation data files of the second party;
and merging and sorting the externally sorted second party account checking data files to obtain second target account checking data.
7. The method of claim 6, wherein the out-ordering the second party reconciliation data file comprises:
cutting the second party reconciliation data file into at least two equivalent sub-files;
writing at least two sub-files into a magnetic disk;
sorting at least two sub-files;
reading data which are sequenced to be a preset size in the cut and sequenced files, and storing the data to a memory space;
outputting the data with the top sequence in the memory to a target file one by one;
reading new data of the cut and sequenced files corresponding to the line data and putting the new data into a memory while outputting each line of data;
until all file data sorting is completed.
8. A reconciliation apparatus, comprising:
the receiving module is used for receiving a first party account checking data file sent by a first terminal and a second party account checking data file sent by a second terminal;
the first sequencing module is used for sequencing the first party account checking data file to obtain first target account checking data;
the second sequencing module is used for sequencing the second party account checking data file to obtain second target account checking data, wherein the field identifications of the same positions of the first target account checking data and the second target account checking data are the same;
and the reconciliation module is used for performing reconciliation according to the first target reconciliation data and the second target reconciliation data.
9. 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 according to any of claims 1-7 when executing the program.
10. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the method according to any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011567021.3A CN112613964A (en) | 2020-12-25 | 2020-12-25 | Account checking method, account checking device, account checking equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011567021.3A CN112613964A (en) | 2020-12-25 | 2020-12-25 | Account checking method, account checking device, account checking equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112613964A true CN112613964A (en) | 2021-04-06 |
Family
ID=75247906
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011567021.3A Pending CN112613964A (en) | 2020-12-25 | 2020-12-25 | Account checking method, account checking device, account checking equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112613964A (en) |
Cited By (3)
| 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 |
| CN113450114A (en) * | 2021-07-14 | 2021-09-28 | 中国银行股份有限公司 | Block chain-based data file acquisition method and device |
| CN113590553A (en) * | 2021-08-03 | 2021-11-02 | 京东科技控股股份有限公司 | Account checking method and device, electronic equipment and computer readable medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110443690A (en) * | 2019-08-15 | 2019-11-12 | 深圳乐信软件技术有限公司 | A kind of method, apparatus, server and the storage medium of variance data reconciliation |
| CN111325617A (en) * | 2020-01-22 | 2020-06-23 | 北京开科唯识技术有限公司 | File-based account checking method and device, computer equipment and readable storage medium |
-
2020
- 2020-12-25 CN CN202011567021.3A patent/CN112613964A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110443690A (en) * | 2019-08-15 | 2019-11-12 | 深圳乐信软件技术有限公司 | A kind of method, apparatus, server and the storage medium of variance data reconciliation |
| CN111325617A (en) * | 2020-01-22 | 2020-06-23 | 北京开科唯识技术有限公司 | File-based account checking method and device, computer equipment and readable storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 汪荣峰: "空间态势可视化与分析技术", 30 April 2017, 国防工业出版社, pages: 325 - 326 * |
Cited By (6)
| 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 |
| CN113450114A (en) * | 2021-07-14 | 2021-09-28 | 中国银行股份有限公司 | Block chain-based data file acquisition method and device |
| CN113590553A (en) * | 2021-08-03 | 2021-11-02 | 京东科技控股股份有限公司 | Account checking method and device, electronic equipment and computer readable medium |
| CN113590553B (en) * | 2021-08-03 | 2024-08-16 | 京东科技控股股份有限公司 | Account checking method, account checking device, electronic equipment and computer readable medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112613964A (en) | Account checking method, account checking device, account checking equipment and storage medium | |
| CN111813804B (en) | Data query method and device, electronic equipment and storage medium | |
| CN113238843B (en) | Task execution method, device, equipment and storage medium | |
| CN113378855A (en) | Method for processing multitask, related device and computer program product | |
| CN113076304A (en) | Distributed version management method, device and system | |
| WO2022174734A1 (en) | Method and apparatus for storing data | |
| CN115408391A (en) | Database table changing method, device, equipment and storage medium | |
| CN111028074A (en) | Overdue bill updating and inquiring method, system, server and storage medium | |
| US8612451B1 (en) | Searching for data structures | |
| CN112073395B (en) | File distribution method and device | |
| CN112948410A (en) | Data processing method, device, equipment and medium | |
| CN113051055A (en) | Task processing method and device | |
| CN112258244A (en) | Method, device, equipment and storage medium for determining task of target object | |
| CN115905322A (en) | Service processing method and device, electronic equipment and storage medium | |
| CN113220237B (en) | Distributed storage method, device, equipment and storage medium | |
| CN112887426B (en) | Information stream pushing method and device, electronic equipment and storage medium | |
| CN115639966A (en) | Data writing method and device, terminal equipment and storage medium | |
| CN115330540A (en) | Method and device for processing transaction data | |
| CN112860796B (en) | Method, apparatus, device and storage medium for synchronizing data | |
| CN114217790A (en) | Interface scheduling method and device, electronic equipment and medium | |
| CN113722389A (en) | Data management method and device, electronic equipment and computer readable storage medium | |
| CN114265966A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN113326038A (en) | Method, apparatus, device, storage medium and program product for providing service | |
| CN110134691B (en) | Data verification method, device, equipment and medium | |
| CN113569144B (en) | Method, device, equipment, storage medium and program product for searching promotion content |
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 | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20211013 Address after: 518000 1801, China energy storage building, 3099 Keyuan South Road, high tech community, Yuehai street, Nanshan District, Shenzhen, Guangdong Applicant after: Shenzhen Lexin Information Service Co.,Ltd. Address before: 26th floor, China energy storage building, 3099 Keyuan South Road, Yuehai street, Nanshan District, Shenzhen, Guangdong 518000 Applicant before: SHENZHEN DINGSHENG COMPUTER TECHNOLOGY Co.,Ltd. |
|
| TA01 | Transfer of patent application right |