CN111324623A - Resource transfer data checking method and device, computer equipment and storage medium - Google Patents

Resource transfer data checking method and device, computer equipment and storage medium Download PDF

Info

Publication number
CN111324623A
CN111324623A CN202010120921.7A CN202010120921A CN111324623A CN 111324623 A CN111324623 A CN 111324623A CN 202010120921 A CN202010120921 A CN 202010120921A CN 111324623 A CN111324623 A CN 111324623A
Authority
CN
China
Prior art keywords
resource transfer
data
file
target
checking
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202010120921.7A
Other languages
Chinese (zh)
Inventor
陈杰
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
OneConnect Smart Technology Co Ltd
OneConnect Financial Technology Co Ltd Shanghai
Original Assignee
OneConnect Financial Technology Co Ltd Shanghai
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by OneConnect Financial Technology Co Ltd Shanghai filed Critical OneConnect Financial Technology Co Ltd Shanghai
Priority to CN202010120921.7A priority Critical patent/CN111324623A/en
Publication of CN111324623A publication Critical patent/CN111324623A/en
Priority to PCT/CN2020/105029 priority patent/WO2021169169A1/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • G06F16/2358Change logging, detection, and notification
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/02Banking, e.g. interest calculation or account maintenance

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • General Physics & Mathematics (AREA)
  • Development Economics (AREA)
  • Technology Law (AREA)
  • Strategic Management (AREA)
  • General Business, Economics & Management (AREA)
  • Marketing (AREA)
  • Economics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The application relates to a data analysis technology and provides a resource transfer data checking method, a resource transfer data checking device, a computer device and a storage medium. The method comprises the following steps: acquiring a resource transfer-out file, a resource transfer-in file and a resource transfer associated file; calling a pre-configured script function, and respectively writing the resource transfer data in the resource transfer-out file, the resource transfer-in file and the resource transfer associated file into respective corresponding target data tables; creating a database view according to the target data table and the association serial number in the resource transfer association file; and calling a pre-configured data check function, traversing the target resource transfer data matched with a preset check state in the database view according to the associated serial number, and checking the corresponding target resource transfer data according to the check elements in the traversed target resource transfer data. By adopting the method, the checking efficiency of the resource transfer data can be improved.

Description

Resource transfer data checking method and device, computer equipment and storage medium
Technical Field
The present application relates to the field of data analysis technologies, and in particular, to a method and an apparatus for checking resource transfer data, a computer device, and a storage medium.
Background
With the continuous development of computer technology and internet technology, various novel third-party service platforms are continuously emerging, and users can conveniently transfer resources by means of the third-party service platforms, so that great convenience is provided for daily life of people. During the resource transfer process, the business server usually interacts with a plurality of third-party service platforms to realize the transfer of the resource from one account to another account. For the completed resource transfer operation, the service server needs to compare the resource transfer data of both resource transfer parties, so as to locate the abnormal operation condition by checking the resource transfer data generated in the resource transfer operation process.
At present, a piece of resource transfer-out data is generally extracted from a resource transfer-out file, and the resource transfer-out data is matched with each resource transfer-in data in a resource transfer-in file, so as to determine a check result of the resource transfer-out data according to a matching result. Therefore, when the check operation is executed cyclically for each piece of resource roll-out data in the resource roll-out file, a large amount of cycle time is required, and particularly when the number of the resource roll-out data and/or the resource roll-in data is large, the check efficiency is low.
Disclosure of Invention
In view of the above, it is necessary to provide a resource transfer data collation method, apparatus, computer device, and storage medium capable of improving the resource transfer data collation efficiency in view of the above technical problems.
A method of resource transfer data reconciliation, the method comprising:
acquiring a resource transfer-out file, a resource transfer-in file and a resource transfer associated file;
calling a pre-configured script function, and respectively writing the resource transfer data in the resource transfer-out file, the resource transfer-in file and the resource transfer associated file into respective corresponding target data tables;
creating a database view according to the target data table and the association serial number in the resource transfer association file;
and calling a pre-configured data check function, traversing the target resource transfer data matched with a preset check state in the database view according to the associated serial number, and checking the corresponding target resource transfer data according to the check elements in the traversed target resource transfer data.
In one embodiment, the invoking a preconfigured script function, and writing the resource transfer data in the resource roll-out file, the resource roll-in file, and the resource transfer association file into respective corresponding target data tables respectively includes:
calling a pre-configured script function, respectively writing the resource transfer data in the resource transfer-out file, the resource transfer-in file and the resource transfer associated file into respective corresponding target data tables corresponding to the service types according to the service types corresponding to the resource transfer data;
the creating a database view according to the target data table and the association serial number in the resource transfer association file comprises:
and according to a target data table corresponding to the same service type and the associated serial number in the resource transfer associated file, creating a database view corresponding to the same service type.
In one embodiment, the target data table comprises a transfer-out data table, a transfer-in data table and an association data table; the creating a database view according to the target data table and the association serial number in the resource transfer association file comprises:
creating a first view according to the roll-out party data table and the associated data table and according to the roll-out party serial number in the roll-out party data table;
creating a second view according to the transferred party data table and the associated data table and the transferred party serial number in the transferred party data table;
and associating the first view with the second view through the association serial number in the resource transfer association file to obtain a database view.
In one embodiment, after the checking the corresponding target resource transfer data according to the check element in the traversed target resource transfer data, the method further includes:
when the check result corresponding to the currently traversed target resource transfer data is that the check is successful, determining a maximum associated serial number before an associated serial number corresponding to the currently traversed target resource transfer data;
acquiring target resource transfer data corresponding to the maximum associated serial number from the database view;
and when the acquired target resource transfer data does not comprise the resource transfer-out data or the resource transfer-in data corresponding to the maximum association serial number, judging that the check result corresponding to the acquired target resource transfer data is a check failure.
In one embodiment, the obtaining the resource transfer-out file, the resource transfer-in file, and the resource transfer association file includes:
detecting the resource transfer data volume in the resource transfer associated file in real time;
when the resource transfer data amount is larger than or equal to a preset number threshold, triggering and generating a resource transfer data acquisition request;
and acquiring the resource transfer-out file from the first management server according to the resource transfer data acquisition request, and acquiring the resource transfer-in file from the second management server.
In one embodiment, the obtaining the resource transfer-out file, the resource transfer-in file, and the resource transfer association file includes:
acquiring a pre-configured configuration file;
determining a data checking mode according to the configuration file;
when the data checking mode is a rolling checking mode, inquiring and judging whether the execution of the checking process executed last time is finished or not, and if the execution is finished, acquiring an acquired resource transfer-out file, a resource transfer-in file and a resource transfer associated file required by the execution of the checking process at the current time;
and when the data checking mode is a full checking mode, directly acquiring the acquired resource transfer-out file, the resource transfer-in file and the resource transfer associated file required by the current execution of the checking process.
In one embodiment, after the checking the target resource transfer data according to the checking element in the target resource transfer data, the method further includes:
updating the checking state of the resource transfer data corresponding to the target resource transfer data in a corresponding target data table according to the checking result corresponding to the target resource transfer data;
when the check result corresponding to the target resource transfer data is a check failure, updating the rolling times of the resource transfer data corresponding to the target resource transfer data in a corresponding target data table;
and when the updated rolling times accord with the preset checking condition, judging the checking result of the corresponding target resource transfer data as the checking failure.
A resource transfer data reconciliation apparatus, said apparatus comprising:
the acquisition module is used for acquiring the resource transfer-out file, the resource transfer-in file and the resource transfer associated file;
the writing module is used for calling a pre-configured script function, respectively writing the resource transfer data in the resource transfer-out file, the resource transfer-in file and the resource transfer associated file into respective corresponding target data tables;
the creating module is used for creating a database view according to the target data table and the association serial number in the resource transfer association file;
and the checking module is used for calling a preconfigured data checking function, sequentially inquiring target resource transfer data matched with a preset checking state from the database view according to the associated serial number, and checking the target resource transfer data according to checking elements in the target resource transfer data.
A computer device comprising a memory and a processor, wherein the memory stores a computer program, and the processor implements the steps of the resource transfer data checking method described in the above embodiments when executing the computer program.
A computer-readable storage medium, on which a computer program is stored, which, when executed by a processor, implements the steps of the resource transfer data collation method described in the above-described embodiments.
The resource transfer data checking method, the device, the computer equipment and the storage medium call the pre-configured script function, automatically write the acquired resource transfer data in the resource transfer-out file, the resource transfer-in file and the resource transfer associated file into respective corresponding target data tables respectively to obtain the target data tables respectively corresponding to the resource transfer-out file, the resource transfer-in file and the resource transfer associated file, and create corresponding database views according to the target data tables according to the associated serial numbers in the resource transfer associated file. Furthermore, a pre-configured data check function is called, target resource transfer data matched with a preset check state in the database view is traversed according to the associated serial number, and the target resource transfer data is automatically checked according to check elements in the traversed target resource transfer data, so that the situation that a large amount of cycle time is consumed due to cyclic traversal of resource transfer-out files and/or resource transfer-in files is avoided, and the check efficiency can be improved.
Drawings
FIG. 1 is a diagram illustrating an exemplary scenario in which a resource transfer data checking method is applied;
FIG. 2 is a flowchart illustrating a method for checking resource transfer data according to one embodiment;
FIG. 3 is a flowchart illustrating a method for checking resource transfer data according to another embodiment;
FIG. 4 is a block diagram showing the configuration of a resource transfer data collating apparatus according to an embodiment;
FIG. 5 is a diagram illustrating an internal structure of a computer device according to an embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
The resource transfer data checking method provided by the application can be applied to the application environment shown in fig. 1. The business server 102 and the management server 104 communicate with each other through a network. The service server 102 may obtain the resource transfer-out file and the resource transfer-in file from the management server 104, and obtain the resource transfer associated file locally. The service server 102 calls a preconfigured script function, respectively writes resource transfer data in the resource roll-out file, the resource roll-in file and the resource transfer associated file into respective corresponding target data tables, creates a database view according to the plurality of target data tables and the associated serial number in the resource transfer associated file, calls a preconfigured data check function, traverses target resource transfer data matched with a preset check state in the database view according to the associated serial number, and checks the corresponding target resource transfer data according to the check elements in the traversed target resource transfer data. The service server 102 and the management server 104 may be implemented by separate servers or a server cluster composed of a plurality of servers.
In one embodiment, as shown in fig. 2, a resource transfer data checking method is provided, which is described by taking the method as an example applied to the service server in fig. 1, and includes the following steps:
s202, acquiring the resource transfer-out file, the resource transfer-in file and the resource transfer related file.
The resource refers to an object which can be transferred between different accounts, and specifically may be an electronic book, an electronic course, a virtual article, and the like, and the virtual article may be a virtual character, a virtual device, an electronic voucher, or a fund, and the like. A resource roll-out file is a file or collection that includes at least one piece of resource roll-out data. The resource roll-out data is data for describing a resource roll-out record, and specifically may include a roll-out party serial number, a roll-out account identifier, a roll-out user identifier, a roll-out resource numerical sum, a service processing state, and the like. A resource transfer-in file is a file or collection that includes at least one piece of resource transfer-in data. The resource transfer-in data is data used for describing a resource transfer-in record, and specifically can include a transfer-in party serial number, a transfer-in account identifier, a transfer-in user identifier, a transfer-in resource numerical sum, a service processing state and the like. A resource transfer associated file is a file or collection that includes at least one piece of resource transfer associated data. The resource transfer associated data is data for associating the resource transfer-out record with the resource transfer-in record, and may specifically include a transfer-in party serial number, a transfer-out party serial number, an associated serial number, and the like. The resource transfer-out data, the resource transfer-in data and the resource transfer related data can be understood as the resource transfer data. The total amount of resource values refers to the total amount of values required in the resource transfer process.
Specifically, the service server obtains the resource transfer-out file and the resource transfer-in file from the management server, and obtains a pre-stored resource transfer associated file from the local database. The management server may refer to a server corresponding to a bank union or a network union.
In one embodiment, the service server detects a preset trigger condition, and when the preset trigger condition is detected, the service server triggers to generate a resource transfer data acquisition request, and acquires a resource roll-out file and a resource roll-in file from the management server according to the resource transfer data acquisition request. The preset trigger condition may be that the current system time is consistent with the preconfigured checking trigger time, or that the service server receives a resource transfer data checking instruction sent by another computer device, such as an attendant terminal.
In one embodiment, the service server may serially acquire the resource transfer-out file, the resource transfer-in file, and the resource transfer associated file through a single thread, or may acquire the resource transfer-out file, the resource transfer-in file, and the resource transfer associated file through a plurality of threads in parallel.
In one embodiment, the service server may obtain the resource roll-out file and the resource roll-in file from the same management server, or may obtain the resource roll-out file and the resource roll-in file from different management servers, respectively, for example, obtain the resource roll-out file from a first management server and obtain the resource roll-in file from a second management server.
In one embodiment, batch multi-pass reconciliation of resource transfer data can be achieved by configuring reconciliation trigger times. For example, a plurality of check trigger times may be preconfigured in one day, so that the service server triggers a resource transfer data check procedure a plurality of times in one day based on the preconfigured check trigger times. It is understood that the service server may trigger the resource transfer data checking procedure according to a pre-configured checking period. The checking period refers to a time interval, such as 2 hours, between two adjacent triggering resource transfer data checking processes.
S204, calling a pre-configured script function, respectively writing the resource transfer data in the resource transfer-out file, the resource transfer-in file and the resource transfer associated file into respective corresponding target data tables.
The preconfigured script function may be a JDBC (Java DataBase Connectivity) -based function.
Specifically, the service server calls a preconfigured script function, writes the resource transfer data in the resource roll-out file into a preconfigured roll-out data table, writes the resource transfer data in the resource roll-in file into a preconfigured roll-in data table, and writes the resource transfer data in the resource transfer associated file into a preconfigured associated data table. The roll-out data table, the roll-in data table and the associated data table are collectively referred to as a target data table.
In one embodiment, the roll-out party data table includes field names of roll-out party serial numbers, roll-out account identifiers, roll-out user identifiers, roll-out resource value sums, service processing states and the like, and field values corresponding to the field names. The transfer party data table comprises field names of transfer party serial numbers, transfer account identifications, transfer user identifications, transfer resource numerical sum, service processing states and the like, and field values corresponding to the field names. The associated data table includes field names such as the transfer party serial number, the transfer party serial number and the associated serial number, and field values corresponding to the field names.
In one embodiment, the service server writes the resource transfer data in the resource transfer-out file, the resource transfer-in file and the resource transfer association file in parallel into the corresponding target data tables through a plurality of threads.
S206, creating a database view according to the target data table and the association serial number in the resource transfer association file.
Wherein the database view is a virtual table created from one or more target data tables stored in the database.
Specifically, the service server calls a script function to respectively associate the resource transfer data in the resource transfer-out file, the resource transfer-in file and the resource transfer associated file with the respective corresponding target data tables according to the associated serial numbers in the resource transfer associated file to create the corresponding database views.
In one embodiment, each resource transfer data in each target data table corresponds to a respective check state. The service server screens the resource transfer data matched with the preset check state from the target data tables respectively corresponding to the resource transfer-out file, the resource transfer-in file and the resource transfer associated file, and creates a corresponding database view according to the screened resource transfer data and the associated serial number matched with the preset check state in the target data table corresponding to the resource transfer associated file. The checking state includes checked and unchecked, and the preset checking state is not checked. The verified state may be uniquely identified by a verified state identifier, such as by 1 indicating verified and by 0 indicating not verified. It can be understood that the resource transfer data screened from the target data table by the service server according to the preset check state includes the resource transfer data currently written into the target data table, and may also include the resource transfer data which is historically written into the target data table and has not been checked.
S208, calling a pre-configured data check function, traversing the target resource transfer data matched with the preset check state in the database view according to the associated serial number, and checking the corresponding target resource transfer data according to the check elements in the traversed target resource transfer data.
Wherein the data checking function is a pre-configured function for checking the target resource transfer data in the database view. The checking elements comprise the total sum of the transferred-in resource values, the total sum of the transferred-out resource values, the service processing states respectively corresponding to the transferred-out party and the transferred-in party and the like.
Specifically, the service server calls a preconfigured data check function, sequentially traverses the associated serial numbers in the database view according to the sequence of the associated serial numbers from small to large, and compares the check state corresponding to the traversed associated serial numbers with a preset check state. And when the check state corresponding to the traversed associated serial number is matched with the preset check state, the service server acquires target resource transfer data corresponding to the currently traversed associated serial number from the database view so as to traverse the target resource transfer data matched with the preset check state in the database view. And the service server checks the target resource transfer data according to the check elements in the currently traversed target resource transfer data.
In one embodiment, the target resource transfer data corresponding to the associated serial number includes resource roll-out data and resource roll-in data corresponding to the associated serial number. The business server separates out the resource transfer-out data and the resource transfer-in data from the target resource transfer data, compares the check element in the resource transfer-out data with the check element in the resource transfer-in data, and checks the corresponding target resource transfer data according to the comparison result. The checking of the target resource transfer data may be understood as checking of resource transfer-out data and resource transfer-in data in the target resource transfer data.
And when the check element in the resource transferring-out data is matched with the check element in the corresponding resource transferring-in data, judging that the check result of the corresponding target resource transferring data is successful. When the target resource transfer data does not include the resource roll-out data or the resource roll-in data, the target resource transfer data is judged to be the doubt data, namely the resource roll-out data or the resource roll-in data included in the target resource transfer data is judged to be the doubt data. And when the target resource transfer data simultaneously comprises resource transfer-out data and resource transfer-in data, and the check element in the resource transfer-out data is not matched with the check element in the corresponding resource transfer-in data, judging that the check result of the corresponding target resource transfer data is check failure.
In one embodiment, there are a plurality of collation elements. And when any check element in the resource transferring-out data is not matched with the corresponding check element in the corresponding resource transferring-in data, judging that the check result of the corresponding target resource transferring data is check failure. For example, when the total amount of the transferred-in resource value is not matched with the total amount of the transferred-out resource value, and/or the service processing state corresponding to the transferred-out party is not matched with the service processing state corresponding to each of the transferred-in parties, it is determined that the checking result of the corresponding target resource transfer data is checking failure.
In one embodiment, the matching of the check element in the resource export data with the check element in the corresponding resource import data may refer to the consistency of the check elements or the consistency of the meaning represented by the check elements. Suppose that the successful traffic processing state is represented by y in the resource transfer-out data, and the successful traffic processing state is represented by 1 in the resource transfer-in data. And if the service processing state in the resource transferring-out data is y and the service processing state in the corresponding resource transferring-in data is 1, judging that the checking result of the corresponding target resource transferring data is successful.
In one embodiment, when it is determined that the checking result of the currently traversed target resource transfer data is a checking failure, the service server pushes early warning information to a preconfigured service terminal to instruct a service operator to process the abnormal target resource transfer data. The service server can also trigger corresponding early warning information for the target resource transfer data with failed verification based on the verification result when the currently executed verification process is completed. The business server can also automatically perform exception analysis on the target resource transfer data with failed verification.
In one embodiment, the service server determines the result of the check of the target resource transfer data as the result of the check of the resource transfer-out data and the resource transfer-in data included in the target resource transfer data, and the result of the check of the resource transfer-associated data corresponding to the target resource transfer data. And the business server updates the check result corresponding to the resource transfer data corresponding to the target resource transfer data in each target data table according to the check result of the target resource transfer data. And the service server migrates the resource transfer data of which the check result is successful in each target data table to the backup table corresponding to the target data table according to the preset migration condition. The preset migration condition is, for example, when the execution of the currently executed verification process is completed, or when a preset time length is reached since the execution of the previous migration process, or when it is detected that the resource transfer data amount in the target data table is greater than or equal to a preset threshold value.
The resource transfer data checking method calls a pre-configured script function, automatically writes the acquired resource transfer data in the resource transfer-out file, the resource transfer-in file and the resource transfer associated file into respective corresponding target data tables to obtain the target data tables respectively corresponding to the resource transfer-out file, the resource transfer-in file and the resource transfer associated file, and creates corresponding database views according to the target data tables according to the associated serial numbers in the resource transfer associated file. Furthermore, a pre-configured data check function is called, target resource transfer data matched with a preset check state in the database view is traversed according to the associated serial number, and the target resource transfer data is automatically checked according to check elements in the traversed target resource transfer data, so that the situation that a large amount of cycle time is consumed due to cyclic traversal of resource transfer-out files and/or resource transfer-in files is avoided, and the check efficiency can be improved.
In one embodiment, step S204 includes: calling a pre-configured script function, respectively writing resource transfer data in the resource transfer-out file, the resource transfer-in file and the resource transfer associated file into respective corresponding target data tables corresponding to the service types according to the service types corresponding to the resource transfer data; step S206 includes: and creating a database view corresponding to the same service type according to the target data table corresponding to the same service type and the associated serial number in the resource transfer associated file.
The service type refers to a type of service processing for triggering generation of resource transfer data. Taking resources as an example, the service type may specifically refer to a transaction type, such as a local bank recharge, a bank show, a financial product purchase, and the like.
Specifically, the service server is locally configured with corresponding target data tables according to the service type for the resource transfer-out file, the resource transfer-in file and the resource transfer associated file. The service server calls a pre-configured script function, writes the resource transfer data in the resource transfer-out file into a target data table corresponding to the resource transfer-out file and corresponding to the service type corresponding to the resource transfer data according to the service type corresponding to each resource transfer data, writes the resource transfer data in the resource transfer-in file into a target data table corresponding to the resource transfer-in file and corresponding to the service type corresponding to the resource transfer data, and writes the resource transfer data in the resource transfer associated file into a target data table corresponding to the resource transfer associated file and corresponding to the service type corresponding to the resource transfer data. Further, for each service type, the service server associates the resource transfer-out file, the resource transfer-in file and the target data table corresponding to the resource transfer association file under the service type according to the association serial number in the target data table corresponding to the resource transfer association file under the service type, so as to create a database view corresponding to the service type.
In one embodiment, the service server stores the target data tables corresponding to the resource transfer-out file, the resource transfer-in file and the resource transfer association file in the database, and performs partition storage on the target data tables according to the service types, so that partition operation of the database is performed according to the service types, and the checking performance can be improved.
In one embodiment, the management server stores the resource transfer data in a classified manner according to the service types to obtain resource transfer-out files and resource transfer-in files corresponding to the service types. The service server acquires the resource transfer-out file and the resource transfer-in file corresponding to each service type from the management server, and writes the acquired resource transfer-out file and the resource transfer data in the resource transfer-in file into corresponding target data tables according to the service types. The service server can call a script function, and through a plurality of threads, the service server can parallelly transfer each resource out file, resource in file and resource transfer associated file, and write the resource in the corresponding target data table according to the service type.
In the above embodiment, the resource transfer data is written into the corresponding target data table according to the service type, so that the resource transfer data can be checked according to the service type, and the checking efficiency can be improved.
In one embodiment, the target data table comprises a roll-out data table, a roll-in data table and an association data table; step S206 includes: creating a first view according to the roll-out party data table and the associated data table and the roll-out party serial number in the roll-out party data table; creating a second view according to the transferred party data table and the associated data table and the transferred party serial number in the transferred party data table; and associating the first view with the second view through the association serial number in the resource transfer association file to obtain the database view.
The first view is a virtual table constructed according to the roll-out data table and the associated data table. The first view may specifically include an associated serial number, a roll-out account identifier, a roll-out user identifier, a roll-out resource value total, a service processing status, and the like. The second view is a virtual table constructed from the transferor data table and the associated data table. The second view may specifically include an associated serial number, a transfer-in party serial number, a transfer-in account identifier, a transfer-in user identifier, a transfer-in total amount of resource values, a service processing status, and the like.
Specifically, the service server associates the roll-out party data table with the association data table according to the roll-out party serial number in the roll-out party data table to create a corresponding first view. And the service server associates the transferred party data table with the associated data table according to the transferred party serial number in the transferred party data table to create a corresponding second view. And the business server associates the first view with the second view according to the association serial numbers in the first view and the second view so as to create a corresponding database view.
In one embodiment, the service server may sequentially create the first view, the second view, and the database view through a single thread, or may concurrently create the first view and the second view through a dual thread, and then create the database view according to the first view and the second view through a single thread.
In the above embodiment, the first view is created based on the serial number of the roll-out party, the second view is created based on the serial number of the roll-in party, and the database view is created according to the first view and the second view based on the association serial number, so that the accuracy of the database view can be improved, and the accuracy of the checking can be improved when the resource transfer data checking is performed based on the database view.
In one embodiment, after checking the corresponding target resource transfer data according to the check element in the traversed target resource transfer data, the resource transfer data checking method further includes: when the check result corresponding to the currently traversed target resource transfer data is that the check is successful, determining the maximum associated serial number before the associated serial number corresponding to the currently traversed target resource transfer data; acquiring target resource transfer data corresponding to the maximum associated serial number from a database view; and when the acquired target resource transfer data does not comprise the resource transfer-out data or the resource transfer-in data corresponding to the maximum correlation serial number, judging that the check result corresponding to the acquired target resource transfer data is check failure.
Specifically, the association serial numbers in the resource transfer association file are sequentially numbered in increments according to the generation sequence of the corresponding resource transfer data in the resource transfer association file. And when the check result corresponding to the currently traversed target resource transfer data is judged to be successful, the service server determines the maximum associated serial number before the associated serial number corresponding to the currently traversed target resource transfer data from the database view, namely determines the associated serial number traversed at the previous time as the maximum associated serial number before the currently traversed associated serial number. And the service server acquires the target resource transfer data corresponding to the maximum correlation serial number from the database view and judges whether the target resource transfer data simultaneously comprises resource transfer-out data and corresponding resource transfer-in data. And when the target resource transfer data is judged not to simultaneously comprise the resource roll-out data and the corresponding resource roll-in data, the service server judges that the check result corresponding to the target resource transfer data is check failure.
For example, assuming that the checking results of the target resource transfer data corresponding to the association serial No. 1 and the association serial No. 3 are both successful, and the target resource transfer data corresponding to the association serial No. 2 only includes the resource transfer-out data or the resource transfer-in data, it is determined that the checking result of the target resource transfer data corresponding to the association serial No. 2 is a checking failure.
In one embodiment, the database view stores the check result corresponding to each target resource transfer data. And when the check result corresponding to the currently traversed target resource transfer data is judged to be successful, the service server acquires the check result corresponding to the target resource transfer data corresponding to the previously traversed associated serial number from the database view, if the check result is in doubt, the check result corresponding to the corresponding target resource transfer data is judged to be failed, and the check result is correspondingly updated in the database view.
In the above embodiment, the target resource transfer data is checked in the order of the ascending association serial number, so that the checking efficiency can be improved, and unnecessary rechecking of the target resource transfer data is avoided.
In one embodiment, step S202 includes: detecting the resource transfer data volume in the resource transfer associated file in real time; when the resource transfer data amount is larger than or equal to a preset number threshold, triggering and generating a resource transfer data acquisition request; and acquiring the resource transfer-out file from the first management server according to the resource transfer data acquisition request, and acquiring the resource transfer-in file from the second management server.
The resource transfer data amount refers to the amount of resource transfer data included in the resource transfer associated file. The preset quantity threshold value can be customized according to the actual situation, such as 60.
Specifically, the service server detects the resource transfer data amount in the locally pre-stored resource transfer associated file in real time, and compares the detected resource transfer data amount with a preset amount threshold. When the resource transfer data amount is larger than or equal to the preset number threshold, the service server triggers to generate a resource transfer data acquisition request, and sends the resource transfer data acquisition request to the first management server and the second management server respectively so as to acquire a resource transfer-out file from the first management server and acquire a corresponding resource transfer-in file from the second management server.
In one embodiment, each management server stores both resource roll-out files and resource roll-in files. And when the resource roll-out file and the corresponding resource roll-in file are stored in the same management server, the first management server and the second management server are the same management server. When the resource roll-out file and the resource roll-in file are respectively stored in different management servers, the first management server and the second management server are different management servers. Therefore, the service server can also acquire the resource transfer-in file from the first management server and acquire the corresponding resource transfer-out file from the second management server.
In one embodiment, when the detected resource transfer data amount is greater than or equal to the preset number threshold, the service server divides the resource transfer data in the resource export file, the resource transfer file and the resource transfer associated file into the preset number of resource transfer data sets according to the data recording time, and checks the resource transfer data in the preset number of resource transfer data sets according to the preset period.
In the above embodiment, the resource transfer related data amount in the resource transfer related file is dynamically detected, so as to dynamically trigger the resource transfer data checking operation according to the detected resource transfer related data amount, and thus, when the resource transfer data amount is large, a large amount of resource transfer data is divided into a plurality of resource transfer data sets to be respectively checked, so as to reduce the resource transfer data amount for single checking, and thus, the checking efficiency can be achieved.
In one embodiment, step S202 includes: acquiring a pre-configured configuration file; determining a data checking mode according to the configuration file; when the data checking mode is a rolling checking mode, inquiring and judging whether the execution of the checking process executed last time is finished or not, and if the execution is finished, acquiring an acquired resource transfer-out file, a resource transfer-in file and a resource transfer associated file which are required by the execution of the checking process at the current time; and when the data checking mode is a full checking mode, directly acquiring the acquired resource transfer-out file, the resource transfer-in file and the resource transfer associated file required by the current execution of the checking process.
The configuration file is used for designating a data checking mode, and also can be used for designating a preset triggering condition for triggering a resource transfer data checking process, such as designating checking triggering time or checking period. The data matching method is a method for matching the resource transfer data, and may specifically be a rolling matching method or a full matching method. The rolling checking mode refers to that partial overlapping of the resource transfer data to be checked may exist in the two adjacent checking processes, and specifically may refer to that the in-doubt data in the previous checking process can be checked again in the current checking process. The doubt data is resource transfer data which can not judge whether the checking result is successful or failed in the checking process. In the rolling check mode, the data in doubt is checked for Toronto. The total checking mode means that the resource transfer data to be checked in any two checking processes are different. In the full-amount checking mode, the checking result of each piece of resource transfer data is checking success or checking failure.
In one embodiment, for the rolling check mode, the resource transfer data in the target data table that matches the preset check state identifier includes the resource transfer data currently written into the target data table and the resource transfer data that is historically written into the target data table and whose check result is in doubt. And for the full amount checking mode, the resource transfer data matched with the preset checking state identification in the target data table is the resource transfer data currently written into the target data table.
Specifically, when detecting a preset trigger condition, the service server acquires a pre-configured configuration file from the database, and determines a data check mode according to the configuration file. And when the data checking mode is a rolling checking mode, the service server inquires and judges whether the checking process executed last time is finished or not. If the execution is judged to be finished, the business server acquires the resource transfer-out file, the resource transfer-in file and the resource transfer associated file which are required by the current execution of the check process. If the checking mode is a full checking mode, the service server directly acquires the acquired resource transfer-out file, the resource transfer-in file and the resource transfer related file which are required by the current execution of the checking process.
In one embodiment, the corresponding data checking mode can be configured for different data recording time or checking triggering time through a configuration file.
In the above embodiment, the data checking method is divided into a rolling checking method and a full checking method, and a corresponding processing flow is provided for each data checking method, so that an appropriate data checking method is selected for resource transfer data checking, and the checking efficiency can be improved.
In one embodiment, after the target resource transfer data is checked according to the check element in the target resource transfer data, the resource transfer data checking method further includes: updating the check state of the resource transfer data corresponding to the target resource transfer data in the corresponding target data table according to the check result corresponding to the target resource transfer data; when the check result corresponding to the target resource transfer data is a check failure, updating the rolling times of the resource transfer data corresponding to the target resource transfer data in the corresponding target data table; and when the updated rolling times accord with the preset checking condition, judging the checking result of the corresponding target resource transfer data as the checking failure.
The check state is used to indicate whether the corresponding target resource transfer data is checked, and may specifically include checked and unchecked. The number of scrolling times is the number of checks that the corresponding resource transfer data has participated in, or the number of remaining checks that the corresponding resource transfer data has participated in, that is, the number of checks that the resource transfer data can also participate in. The preset check condition is a condition or basis for judging whether to check the corresponding resource transfer data, and specifically may be that the rolling frequency is greater than or equal to a first frequency threshold, or the rolling frequency is less than or equal to a second frequency threshold.
Specifically, the service server determines the check result corresponding to the target resource transfer data as the check result corresponding to the corresponding resource transfer-out data, the resource transfer-in data and the resource transfer associated data. And the service server updates the check state corresponding to the resource transfer-out data in the corresponding target data table according to the check result corresponding to the resource transfer-out data. And when the check result corresponding to the resource transfer-out data is successful, the service server updates the check state corresponding to the resource transfer-out data into a checked state in the corresponding target data table. When the check result corresponding to the resource transfer-out data is a check failure, the service server keeps the check state corresponding to the resource transfer-out data as unchecked in the corresponding target data table, and dynamically updates the rolling times corresponding to the resource transfer-out data. And the service server compares the updated rolling times with a preset check condition, judges the check result of the corresponding resource transfer-out data as check failure when judging that the updated rolling times meet the preset check condition, updates the check result corresponding to the resource transfer-out data into checked result in a corresponding target data table, and updates the check result corresponding to the resource transfer-out data into check failure.
It can be understood that, for the resource transfer-in data and the resource transfer associated data, the service server updates the respective corresponding check state, the rolling times and the check result in the corresponding target data table according to the similar process, which is not described herein again.
For example, assuming that the resource transfer data is checked for the first time and the check result of the resource transfer data is in doubt, the number of scrolling of the resource transfer data is set to 2, and when the resource transfer data is checked for the second time, if the check result is still in doubt, the number of scrolling is updated to 1, and when the check result is checked for the second time and the check result is still in doubt, the number of scrolling is updated to 0, and since the updated number of scrolling 0 is less than or equal to the second time threshold value 0, it is determined that the check result of the resource transfer data is a check failure, and the check state is updated to checked.
For another example, when the check result of the first checking of the resource transfer data is in doubt, the service server may set the scroll number corresponding to the resource transfer data to 1, when the check result of the second checking is in doubt, update the scroll number to 2, and so on, and when the scroll number is 3, determine that the check result of the resource transfer data is a check failure.
It is to be appreciated that in the above example, the resource transfer data may refer to resource roll-out data, resource roll-in data, or resource transfer associated data. When the scroll frequency is once a day, the number of scrolls may also be understood as the number of scrolling days.
In the above embodiment, the check state and the rolling frequency are dynamically updated based on the check result, and the check result of the corresponding resource transfer data is determined according to the dynamically updated rolling frequency, so that occupation of computer resources due to rolling check performed on a certain resource transfer data for too many times is avoided, and the check efficiency can be improved under the condition that the check accuracy is ensured.
As shown in fig. 3, in an embodiment, a method for checking resource transfer data is provided, which specifically includes the following steps:
s302, a pre-configured configuration file is obtained.
S304, determining a data checking mode according to the configuration file.
S306, when the data checking mode is a rolling checking mode, inquiring and judging whether the execution of the checking process executed last time is finished or not, and if the execution is finished, acquiring the resource transfer-out file, the resource transfer-in file and the resource transfer related file required by the execution of the checking process at the current time.
S308, when the data checking mode is the full checking mode, directly acquiring the resource transfer-out file, the resource transfer-in file and the resource transfer related file required by the current execution of the checking process.
S310, calling a pre-configured script function, respectively writing resource transfer data in the resource transfer-out file, the resource transfer-in file and the resource transfer association file into respective corresponding target data tables; the target data table comprises a transfer-out side data table, a transfer-in side data table and an associated data table.
S312, according to the roll-out party data table and the related data table, a first view is created according to the roll-out party serial number in the roll-out party data table.
And S314, creating a second view according to the transferred party serial number in the transferred party data table according to the transferred party data table and the associated data table.
And S316, associating the first view with the second view through the association serial number in the resource transfer association file to obtain the database view.
And S318, calling a pre-configured data check function, traversing the target resource transfer data matched with the preset check state in the database view according to the associated serial number, and checking the corresponding target resource transfer data according to the check elements in the traversed target resource transfer data.
S320, when the check result corresponding to the currently traversed target resource transfer data is that the check is successful, determining the maximum associated serial number before the associated serial number corresponding to the currently traversed target resource transfer data.
S322, obtaining the target resource transfer data corresponding to the maximum correlation serial number from the database view.
S324, when the acquired target resource transfer data does not include the resource transfer-out data or the resource transfer-in data corresponding to the maximum correlation serial number, judging that the check result corresponding to the acquired target resource transfer data is check failure.
It should be understood that although the various steps in the flow charts of fig. 2-3 are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least some of the steps in fig. 2-3 may include multiple sub-steps or multiple stages that are not necessarily performed at the same time, but may be performed at different times, and the order of performance of the sub-steps or stages is not necessarily sequential, but may be performed in turn or alternating with other steps or at least some of the sub-steps or stages of other steps.
In one embodiment, as shown in fig. 4, there is provided a resource transfer data collation apparatus 400 comprising: an acquisition module 402, a write module 404, a creation module 406, and a verification module 408, wherein:
an obtaining module 402, configured to obtain a resource transfer-out file, a resource transfer-in file, and a resource transfer association file;
a write-in module 404, configured to call a preconfigured script function, respectively write resource transfer data in the resource transfer-out file, the resource transfer-in file, and the resource transfer-associated file into respective corresponding target data tables;
a creating module 406, configured to create a database view according to the target data table and the association serial number in the resource transfer association file;
and the checking module 408 is configured to invoke a preconfigured data checking function, sequentially query the target resource transfer data matched with the preset checking state from the database view according to the associated serial number, and check the target resource transfer data according to the checking elements in the target resource transfer data.
In an embodiment, the writing module 404 is further configured to call a preconfigured script function, respectively write resource transfer data in the resource export file, the resource transfer file, and the resource transfer associated file into respective corresponding target data tables corresponding to the service types according to the service types corresponding to the resource transfer data; the creating module 406 is further configured to create a database view corresponding to the same service type according to the target data table corresponding to the same service type and according to the association serial number in the resource transfer association file.
In one embodiment, the target data table comprises a roll-out data table, a roll-in data table and an association data table; the creating module 406 is further configured to create a first view according to the roll-out party serial number in the roll-out party data table according to the roll-out party data table and the associated data table; creating a second view according to the transferred party data table and the associated data table and the transferred party serial number in the transferred party data table; and associating the first view with the second view through the association serial number in the resource transfer association file to obtain the database view.
In an embodiment, the checking module 408 is further configured to determine, when the checking result corresponding to the currently traversed target resource transfer data is that checking is successful, a maximum associated serial number before an associated serial number corresponding to the currently traversed target resource transfer data; acquiring target resource transfer data corresponding to the maximum associated serial number from a database view; and when the acquired target resource transfer data does not comprise the resource transfer-out data or the resource transfer-in data corresponding to the maximum correlation serial number, judging that the check result corresponding to the acquired target resource transfer data is check failure.
In an embodiment, the obtaining module 402 is further configured to detect, in real time, a resource transfer data amount in the resource transfer association file; when the resource transfer data amount is larger than or equal to a preset number threshold, triggering and generating a resource transfer data acquisition request; and acquiring the resource transfer-out file from the first management server according to the resource transfer data acquisition request, and acquiring the resource transfer-in file from the second management server.
In one embodiment, the obtaining module 402 is further configured to obtain a preconfigured configuration file; determining a data checking mode according to the configuration file; when the data checking mode is a rolling checking mode, inquiring and judging whether the execution of the checking process executed last time is finished or not, and if the execution is finished, acquiring an acquired resource transfer-out file, a resource transfer-in file and a resource transfer associated file which are required by the execution of the checking process at the current time; and when the data checking mode is a full checking mode, directly acquiring the acquired resource transfer-out file, the resource transfer-in file and the resource transfer associated file required by the current execution of the checking process.
In one embodiment, the checking module 408 is further configured to update the checking state of the resource transfer data corresponding to the target resource transfer data in the corresponding target data table according to the checking result corresponding to the target resource transfer data; when the check result corresponding to the target resource transfer data is a check failure, updating the rolling times of the resource transfer data corresponding to the target resource transfer data in the corresponding target data table; and when the updated rolling times accord with the preset checking condition, judging the checking result of the corresponding target resource transfer data as the checking failure.
For specific limitations of the resource transfer data checking apparatus, reference may be made to the above limitations of the resource transfer data checking method, which are not described herein again. The modules in the resource transfer data checking device can be wholly or partially realized by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a computer device is provided, which may be a service server, and its internal structure diagram may be as shown in fig. 5. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the computer equipment is used for storing target data tables corresponding to the resource transfer-out file, the resource transfer-in file and the resource transfer association file. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a resource transfer data collation method.
Those skilled in the art will appreciate that the architecture shown in fig. 5 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided, which includes a memory and a processor, the memory stores a computer program, and the processor implements the steps of the resource transfer data checking method in the above embodiments when executing the computer program.
In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored, which when executed by a processor implements the steps of the resource transfer data checking method in the above-described embodiments.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.

Claims (10)

1. A method of resource transfer data reconciliation, the method comprising:
acquiring a resource transfer-out file, a resource transfer-in file and a resource transfer associated file;
calling a pre-configured script function, and respectively writing the resource transfer data in the resource transfer-out file, the resource transfer-in file and the resource transfer associated file into respective corresponding target data tables;
creating a database view according to the target data table and the association serial number in the resource transfer association file;
and calling a pre-configured data check function, traversing the target resource transfer data matched with a preset check state in the database view according to the associated serial number, and checking the corresponding target resource transfer data according to the check elements in the traversed target resource transfer data.
2. The method according to claim 1, wherein the calling the preconfigured script function to write the resource transfer data in the resource roll-out file, the resource roll-in file, and the resource transfer association file into the respective corresponding target data tables, respectively, comprises:
calling a pre-configured script function, respectively writing the resource transfer data in the resource transfer-out file, the resource transfer-in file and the resource transfer associated file into respective corresponding target data tables corresponding to the service types according to the service types corresponding to the resource transfer data;
the creating a database view according to the target data table and the association serial number in the resource transfer association file comprises:
and according to a target data table corresponding to the same service type and the associated serial number in the resource transfer associated file, creating a database view corresponding to the same service type.
3. The method of claim 1, wherein the target data table comprises a roll-out data table, a roll-in data table, and an association data table; the creating a database view according to the target data table and the association serial number in the resource transfer association file comprises:
creating a first view according to the roll-out party data table and the associated data table and according to the roll-out party serial number in the roll-out party data table;
creating a second view according to the transferred party data table and the associated data table and the transferred party serial number in the transferred party data table;
and associating the first view with the second view through the association serial number in the resource transfer association file to obtain a database view.
4. The method of claim 1, wherein after checking the respective target resource transfer data according to the check elements in the traversed target resource transfer data, the method further comprises:
when the check result corresponding to the currently traversed target resource transfer data is that the check is successful, determining a maximum associated serial number before an associated serial number corresponding to the currently traversed target resource transfer data;
acquiring target resource transfer data corresponding to the maximum associated serial number from the database view;
and when the acquired target resource transfer data does not comprise the resource transfer-out data or the resource transfer-in data corresponding to the maximum association serial number, judging that the check result corresponding to the acquired target resource transfer data is a check failure.
5. The method according to claim 1, wherein the obtaining the resource roll-out file, the resource roll-in file and the resource transfer associated file comprises:
detecting the resource transfer data volume in the resource transfer associated file in real time;
when the resource transfer data amount is larger than or equal to a preset number threshold, triggering and generating a resource transfer data acquisition request;
and acquiring the resource transfer-out file from the first management server according to the resource transfer data acquisition request, and acquiring the resource transfer-in file from the second management server.
6. The method according to claim 1, wherein the obtaining the resource roll-out file, the resource roll-in file and the resource transfer associated file comprises:
acquiring a pre-configured configuration file;
determining a data checking mode according to the configuration file;
when the data checking mode is a rolling checking mode, inquiring and judging whether the execution of the checking process executed last time is finished or not, and if the execution is finished, acquiring an acquired resource transfer-out file, a resource transfer-in file and a resource transfer associated file required by the execution of the checking process at the current time;
and when the data checking mode is a full checking mode, directly acquiring the acquired resource transfer-out file, the resource transfer-in file and the resource transfer associated file required by the current execution of the checking process.
7. The method according to any one of claims 1 to 6, wherein after checking the target resource transfer data according to a check element in the target resource transfer data, the method further comprises:
updating the checking state of the resource transfer data corresponding to the target resource transfer data in a corresponding target data table according to the checking result corresponding to the target resource transfer data;
when the check result corresponding to the target resource transfer data is a check failure, updating the rolling times of the resource transfer data corresponding to the target resource transfer data in a corresponding target data table;
and when the updated rolling times accord with the preset checking condition, judging the checking result of the corresponding target resource transfer data as the checking failure.
8. A resource transfer data collation apparatus, said apparatus comprising:
the acquisition module is used for acquiring the resource transfer-out file, the resource transfer-in file and the resource transfer associated file;
the writing module is used for calling a pre-configured script function, respectively writing the resource transfer data in the resource transfer-out file, the resource transfer-in file and the resource transfer associated file into respective corresponding target data tables;
the creating module is used for creating a database view according to the target data table and the association serial number in the resource transfer association file;
and the checking module is used for calling a preconfigured data checking function, sequentially inquiring target resource transfer data matched with a preset checking state from the database view according to the associated serial number, and checking the target resource transfer data according to checking elements in the target resource transfer data.
9. A computer device comprising a memory and a processor, the memory storing a computer program, wherein the processor implements the steps of the method of any one of claims 1 to 7 when executing the computer program.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
CN202010120921.7A 2020-02-26 2020-02-26 Resource transfer data checking method and device, computer equipment and storage medium Pending CN111324623A (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
CN202010120921.7A CN111324623A (en) 2020-02-26 2020-02-26 Resource transfer data checking method and device, computer equipment and storage medium
PCT/CN2020/105029 WO2021169169A1 (en) 2020-02-26 2020-07-28 Resource transfer data checking method and apparatus, computer device, and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010120921.7A CN111324623A (en) 2020-02-26 2020-02-26 Resource transfer data checking method and device, computer equipment and storage medium

Publications (1)

Publication Number Publication Date
CN111324623A true CN111324623A (en) 2020-06-23

Family

ID=71169142

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010120921.7A Pending CN111324623A (en) 2020-02-26 2020-02-26 Resource transfer data checking method and device, computer equipment and storage medium

Country Status (2)

Country Link
CN (1) CN111324623A (en)
WO (1) WO2021169169A1 (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111984677A (en) * 2020-07-30 2020-11-24 招联消费金融有限公司 Resource data checking method and device, computer equipment and storage medium
WO2021169169A1 (en) * 2020-02-26 2021-09-02 深圳壹账通智能科技有限公司 Resource transfer data checking method and apparatus, computer device, and storage medium
CN115509990A (en) * 2022-09-21 2022-12-23 中合数字科技(广东)有限公司 Electronic file archiving method, device, system and computer readable storage medium

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114416805B (en) * 2022-03-10 2022-08-02 深圳高灯计算机科技有限公司 Data checking method and device, computer equipment and storage medium
CN115907986B (en) * 2022-11-15 2023-08-29 支付宝(杭州)信息技术有限公司 Asset checking method and device, medium and computer equipment
CN117435630B (en) * 2023-12-21 2024-03-29 杭银消费金融股份有限公司 Rule preposition-based data verification method and system

Family Cites Families (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7949640B2 (en) * 2008-10-31 2011-05-24 Gravic, Inc. Referential integrity, consistency, and completeness loading of databases
CN107291726A (en) * 2016-03-31 2017-10-24 阿里巴巴集团控股有限公司 information checking method and system
CN106649500A (en) * 2016-10-11 2017-05-10 中国工商银行股份有限公司 Data verification method and system
CN108376364B (en) * 2018-02-07 2021-08-20 深圳市雁联计算系统有限公司 Payment system account checking method and device and terminal device
CN110060140A (en) * 2019-03-15 2019-07-26 深圳壹账通智能科技有限公司 Mass data account checking method, device, medium and computer equipment
CN110390586A (en) * 2019-07-23 2019-10-29 中国工商银行股份有限公司 Account checking method, device and server
CN111324623A (en) * 2020-02-26 2020-06-23 深圳壹账通智能科技有限公司 Resource transfer data checking method and device, computer equipment and storage medium

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2021169169A1 (en) * 2020-02-26 2021-09-02 深圳壹账通智能科技有限公司 Resource transfer data checking method and apparatus, computer device, and storage medium
CN111984677A (en) * 2020-07-30 2020-11-24 招联消费金融有限公司 Resource data checking method and device, computer equipment and storage medium
CN111984677B (en) * 2020-07-30 2023-06-02 招联消费金融有限公司 Resource data checking method, device, computer equipment and storage medium
CN115509990A (en) * 2022-09-21 2022-12-23 中合数字科技(广东)有限公司 Electronic file archiving method, device, system and computer readable storage medium

Also Published As

Publication number Publication date
WO2021169169A1 (en) 2021-09-02

Similar Documents

Publication Publication Date Title
CN111324623A (en) Resource transfer data checking method and device, computer equipment and storage medium
CN108734453B (en) Block chain data processing method and device, computer equipment and storage medium
CN109474578B (en) Message checking method, device, computer equipment and storage medium
CN110647582B (en) Method, device, storage medium and computer equipment for block chain network consensus verification
CN108304554B (en) File splitting method and device, computer equipment and storage medium
CN108427613B (en) Abnormal interface positioning method and device, computer equipment and storage medium
CN110751550B (en) Account checking method and device, computer equipment and storage medium
CN109542428A (en) Method for processing business, device, computer equipment and storage medium
CN110781214A (en) Database reading and writing method and device, computer equipment and storage medium
CN110865927A (en) Block chain call link abnormity detection method and device and computer equipment
CN111026767B (en) Block chain data storage method and device and hardware equipment
CN108965383B (en) File synchronization method and device, computer equipment and storage medium
CN110213326B (en) Method, system, equipment and storage medium for capacity expansion of metadata node cluster
CN112232818A (en) Data reconciliation method and device, computer equipment and storage medium
CN110727698A (en) Database access method and device, computer equipment and storage medium
CN110795171A (en) Service data processing method and device, computer equipment and storage medium
CN110334303A (en) Form validation method, device, computer equipment and storage medium
CN113888299A (en) Wind control decision method and device, computer equipment and storage medium
CN110674145A (en) Data consistency detection method and device, computer equipment and storage medium
CN112613288B (en) Method, device, computer equipment and storage medium for generating bill
CN113837584A (en) Service processing system and abnormal data processing method based on service processing system
CN111966461A (en) Virtual machine cluster node guarding method, device, equipment and storage medium
CN115757172A (en) Test execution method and device, storage medium and computer equipment
CN114020612A (en) Test data construction processing method and device, computer equipment and storage medium
CN113849343A (en) Disaster recovery backup method, device and storage medium

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