CN113469803A - Bank card annual fee collection method and device - Google Patents
Bank card annual fee collection method and device Download PDFInfo
- Publication number
- CN113469803A CN113469803A CN202110799040.7A CN202110799040A CN113469803A CN 113469803 A CN113469803 A CN 113469803A CN 202110799040 A CN202110799040 A CN 202110799040A CN 113469803 A CN113469803 A CN 113469803A
- Authority
- CN
- China
- Prior art keywords
- card
- information
- list
- splitting
- account
- 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 28
- 238000012216 screening Methods 0.000 claims abstract description 76
- 238000005192 partition Methods 0.000 claims description 30
- 238000004590 computer program Methods 0.000 claims description 16
- 238000003860 storage Methods 0.000 claims description 8
- 238000012545 processing Methods 0.000 description 24
- 238000010586 diagram Methods 0.000 description 13
- 238000012163 sequencing technique Methods 0.000 description 6
- 230000009471 action Effects 0.000 description 5
- 238000009826 distribution Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 4
- 238000012423 maintenance Methods 0.000 description 4
- 230000008859 change Effects 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000007730 finishing process Methods 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000000638 solvent extraction Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000026676 system process Effects 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/02—Banking, e.g. interest calculation or account maintenance
-
- 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
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/08—Payment architectures
- G06Q20/10—Payment architectures specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
- G06Q20/108—Remote banking, e.g. home banking
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Development Economics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Marketing (AREA)
- Technology Law (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method and a device for collecting annual fee of a bank card, which can be used in the field of finance, wherein the method comprises the following steps: obtaining a card table splitting parameter file and an account table splitting parameter file; splitting the card table according to the card table splitting parameter file; the split card tables are scanned in parallel to obtain a plurality of groups of bank card information; screening the information of the multiple groups of bank cards to obtain a pre-screening charging list, wherein the pre-screening charging list comprises associated accounts; sorting the pre-screening charging list according to the associated account; splitting the parameter file according to the account table, splitting the sorted pre-screening charging list to obtain a to-be-charged list; and according to the list to be charged, carrying out annual charge collection of the bank card. The invention can charge the annual fee of the bank card, complete the annual fee charging of a large number of associated card accounts within the range of the specified time window, improve the execution efficiency and avoid the problems of overtime or deadlock of the database.
Description
Technical Field
The invention relates to the field of finance, in particular to a method and a device for collecting annual bank card fees. It should be noted that the method and apparatus for collecting the annual fee of the bank card of the present invention can be used in the financial field, and can also be used in any fields other than the financial field.
Background
In the core bank system, when charging a fee for an account associated with a card, a card table storing data related to the card and an account table storing data related to a deposit account need to be updated simultaneously. In the face of increasingly expanded banking business, the number of cards and the number of accounts are continuously increased, the efficiency of manually collecting the annual fee of the cards is low, a large number of operations cannot be accurately and quickly completed in a certain time window, and time and labor are consumed; however, if the job is processed in parallel, the processing partitions may be consistent between the two parallels because the card table and the account table are partitioned according to different conditions, so that database timeout or deadlock occurs, and execution efficiency is seriously affected.
Therefore, there is a need for an annual bank card fee collection scheme that overcomes the above-mentioned problems.
Disclosure of Invention
The embodiment of the invention provides a bank card annual fee collection method, which is used for collecting the annual fee of a bank card, completing the annual fee collection of a large number of associated card accounts within a specified time window range, improving the execution efficiency and avoiding the problems of overtime or deadlock of a database, and comprises the following steps:
obtaining a card table splitting parameter file and an account table splitting parameter file;
splitting the card table according to the card table splitting parameter file;
the split card tables are scanned in parallel to obtain a plurality of groups of bank card information;
screening the information of the multiple groups of bank cards to obtain a pre-screening charging list, wherein the pre-screening charging list comprises associated accounts;
sorting the pre-screening charging list according to the associated account;
splitting the parameter file according to the account table, splitting the sorted pre-screening charging list to obtain a to-be-charged list;
and according to the list to be charged, carrying out annual charge collection of the bank card.
The embodiment of the invention provides a bank card annual fee collecting device, which is used for collecting the annual fee of a bank card, completing the annual fee collection of a large number of associated card accounts within a specified time window range, improving the execution efficiency and avoiding the problems of overtime or deadlock of a database, and comprises the following components:
the parameter file obtaining module is used for obtaining a card table splitting parameter file and an account table splitting parameter file;
the card table splitting module is used for splitting the card table according to the card table splitting parameter file;
the parallel scanning module is used for scanning the split card table in parallel to obtain a plurality of groups of bank card information;
the information screening module is used for screening the information of the plurality of groups of bank cards to obtain a pre-screening charging list, and the pre-screening charging list comprises associated accounts;
the charging list sorting module is used for sorting the pre-screening charging list according to the associated account;
the charge list splitting module is used for splitting the parameter file according to the account table and splitting the sorted pre-screening charge list to obtain a list to be charged;
and the annual fee collection module is used for collecting the annual fee of the bank card according to the list to be collected.
The embodiment of the invention also provides computer equipment which comprises a memory, a processor and a computer program which is stored on the memory and can run on the processor, wherein the processor executes the computer program to realize the bank card annual fee collection method.
An embodiment of the present invention further provides a computer-readable storage medium, where a computer program for executing the above method for collecting annual bank card fees is stored in the computer-readable storage medium.
The embodiment of the invention obtains a card table splitting parameter file and an account table splitting parameter file; splitting the card table according to the card table splitting parameter file; the split card tables are scanned in parallel to obtain a plurality of groups of bank card information; screening the information of the multiple groups of bank cards to obtain a pre-screening charging list, wherein the pre-screening charging list comprises associated accounts; sorting the pre-screening charging list according to the associated account; splitting the parameter file according to the account table, splitting the sorted pre-screening charging list to obtain a to-be-charged list; and according to the list to be charged, carrying out annual charge collection of the bank card. The embodiment of the invention splits the card table through the card table splitting parameter file, and scans the split card table in parallel to realize the balanced parallel distribution of data processing. And splitting the sorted pre-screening charging list according to the splitting parameter file of the account table to obtain a list to be charged, and thus, carrying out annual charge collection on the bank card according to the list to be charged. By the aid of the asynchronous updating idea, under the condition that the database problem does not occur, parallel processing is completed at the highest efficiency, so that annual fee collection of bank cards is effectively performed, annual fee collection of a large number of associated card accounts is completed within a specified time window range, execution efficiency is improved, and the problem of database overtime or deadlock is avoided.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts. In the drawings:
FIG. 1 is a schematic diagram illustrating a method for collecting annual bank card fees according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of another method for collecting annual bank card fees according to an embodiment of the present invention;
FIG. 3 is a diagram illustrating an embodiment of an annual bank card fee collecting device according to the present invention;
FIG. 4 is a structural view of another annual bank card fee collecting device according to an embodiment of the present invention;
fig. 5 is a schematic structural diagram of a computer device according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention are further described in detail below with reference to the accompanying drawings. The exemplary embodiments and descriptions of the present invention are provided to explain the present invention, but not to limit the present invention.
First, terms in the embodiments of the present invention are described:
debit card: the bank card is issued to a card holder by a card issuing bank, has no credit limit, and is a voucher. After the bank issues the debit card, the customer associates the account of the customer in the bank, and the card is bound to the account, for example, the customer deposits and withdraws money through the card, namely deposits and withdraws money to the account bound with the card.
Annual card fee: commercial banks pay a fixed charge per year for bank accounts to which cards are bound. The bank card annual fee is collected once a year, and the bank draws from the account.
Partitioning a database: in order to improve the access performance of data, the database is horizontally partitioned, that is, the data in the database is divided into a plurality of blocks according to the values of certain columns of the database, and only the corresponding blocks are required to be operated during access.
Batch operation: when the same business scene of a large number of accounts is processed, such as settlement, charging and the like, repeated operations can be completed by using batch operation to scan data in the table in sequence. However, when the core system processes such services, there is a certain time window limit, so that the batch job can be split into a corresponding number of parallel executions based on the database partition, and one parallel job processes one partition or several partitions, thereby improving the processing speed without interfering with each other.
As mentioned above, in the face of increasingly expanded banking, the number of cards and the number of accounts are increasing, and the annual cost of the cards is processed by only using one batch job, which cannot meet the requirement of an expected time window; however, if the job is processed in parallel, the situation that the processing partitions are consistent between the two parallels may occur because the card table and the account table are different according to the partitions, so that the database is overtime or deadlock occurs, and meanwhile, if the job is processed according to the card table sequence, the account table is necessarily out of order, and the out-of-order processing efficiency is far lower than the sequential processing efficiency. The prior art has the following problems: 1) the manual card annual fee collection efficiency is low, a large amount of operations cannot be accurately and rapidly completed within a certain time window, and time and labor are consumed. 2) Simply splitting and executing the operation according to a certain table (card table or account table) partition still has database problems, and the other table cannot better optimize the processing efficiency due to the problem of processing disorder (if the card numbers are in sequence, the associated account numbers are necessarily in disorder). If the database is overtime or deadlock, manual intervention is needed to ensure that the final execution is finished, and great challenges and risks are brought to operation and maintenance personnel and batch execution. 3) The parallel split is relatively fixed, the adjustment of the split cannot be completed in a mode of issuing a formal version according to flexible change of data quantity if the change is needed, and the flexibility is relatively poor. Therefore, for the above case, in order to solve the card year charge efficiency problem, the inventors considered the following problems: 1) how to complete the annual fee collection action of a large batch of associated card accounts within a specified time window range. 2) How to improve the execution efficiency as much as possible when charging the fee, and simultaneously, the database timeout or deadlock phenomenon does not occur. 3) How to automatically finish partition splitting makes parallel splitting more intelligent and flexible to satisfy that splitting condition can change along with the adjustment of data volume, reaches balanced treatment's effect.
In order to perform annual fee collection of bank cards, complete annual fee collection of a large number of associated card accounts within a specified time window range, improve execution efficiency, and avoid the problem of database timeout or deadlock, an embodiment of the present invention provides an annual fee collection method of bank cards, which, as shown in fig. 1, may include:
104, screening the multiple groups of bank card information to obtain a pre-screening charging list, wherein the pre-screening charging list comprises associated accounts;
105, sequencing a pre-screening charging list according to the associated account;
and step 107, carrying out annual charge of the bank card according to the list to be charged.
As shown in fig. 1, in the embodiment of the present invention, a card table splitting parameter file and an account table splitting parameter file are obtained; splitting the card table according to the card table splitting parameter file; the split card tables are scanned in parallel to obtain a plurality of groups of bank card information; screening the information of the multiple groups of bank cards to obtain a pre-screening charging list, wherein the pre-screening charging list comprises associated accounts; sorting the pre-screening charging list according to the associated account; splitting the parameter file according to the account table, splitting the sorted pre-screening charging list to obtain a to-be-charged list; and according to the list to be charged, carrying out annual charge collection of the bank card. The embodiment of the invention splits the card table through the card table splitting parameter file, and scans the split card table in parallel to realize the balanced parallel distribution of data processing. And splitting the sorted pre-screening charging list according to the splitting parameter file of the account table to obtain a list to be charged, and thus, carrying out annual charge collection on the bank card according to the list to be charged. By the aid of the asynchronous updating idea, under the condition that the database problem does not occur, parallel processing is completed at the highest efficiency, so that annual fee collection of bank cards is effectively performed, annual fee collection of a large number of associated card accounts is completed within a specified time window range, execution efficiency is improved, and the problem of database overtime or deadlock is avoided.
In the embodiment, a card table splitting parameter file and an account table splitting parameter file are obtained.
In this embodiment, the card table splitting parameter file includes: card table parallel serial numbers and corresponding card table partition starting information; the account table splitting parameter file comprises: and the parallel serial number of the account table and the corresponding account table start partition information.
In specific implementation, when the data volume is greatly adjusted or changed, the card table splitting parameter file and the account table splitting parameter file are configured according to requirements based on the number of each partition of the card table. The file formats of the card table splitting parameter file and the account table splitting parameter file are shown in table 1, and each parallel configuration can be started from the first partition.
TABLE 1
| Parallel serial number | Start partition |
| 1 | 1 |
| …… | …… |
| N | M |
In the embodiment, the card table is split according to the card table splitting parameter file; the split card tables are scanned in parallel to obtain a plurality of groups of bank card information; and screening the information of the plurality of groups of bank cards to obtain a pre-screening charging list, wherein the pre-screening charging list comprises the associated account.
In this embodiment, each group of bank card information includes: card number information, card state information, associated account state information, annual fee arrearage information, annual fee charging time information, associated account number and fee information to be collected; screening the multiple groups of bank card information to obtain a pre-screening toll list, comprising: according to the card state information, correlating account state information, annual fee arrearage information and annual fee collecting time information to screen the multiple groups of bank card information; and associating the account number with the information of the expense to be collected according to the card number information of the screened bank card information to generate a pre-screening toll list.
In specific implementation, the card table is split according to the card table splitting parameter file, and the card table is scanned in parallel to obtain the information of each debit card in the card table. And screening the cards with normal card state information, normal associated account state information, default card annual fee or card annual fee needing to be collected on the same day in the card table, and outputting the card number, the associated account number and the collection fee to a pre-screening charging list.
In the embodiment, a pre-screening charging list is sorted according to the associated account; splitting the parameter file according to the account table, splitting the sorted pre-screening charging list to obtain a to-be-charged list; and according to the list to be charged, carrying out annual charge collection of the bank card.
In this embodiment, as shown in fig. 2, the method for collecting the annual fee of the bank card further includes:
and step 204, updating the card table according to the result list to be updated.
During specific implementation, the associated accounts in the pre-screening charging list are reordered, and the splitting is completed again by splitting the parameter file according to the account table, so that the charging list to be charged is formed. The parallel targets are split according to the accounts, and meanwhile sequencing is completed in each list according to the accounts. And according to the list to be charged, sequentially and parallelly finishing processes such as fee deduction, transaction flow, accounting and the like on the associated account. The mark that the account status is abnormal (such as insufficient amount or frozen) and the charging action cannot be completed is failure of charging, the mark that the account completing normal fee deduction is successful of charging, and a charging result list is output, wherein the content of the list is as follows: card number, associated account number, whether charging is successful, charge to be collected and charge to be collected actually. And reordering the charging result list according to the card number in the list, and completing splitting again according to the splitting parameter file in the card list to form a result list to be updated. The parallel targets of splitting according to the cards are completed, and meanwhile, sequencing is completed in each list according to the card numbers. And according to the result list to be updated, sequentially and parallelly finishing the updating action on the card table. For the list record of successful charging, the arrearage in the card table is cleared, and the next charging date is the same-month and same-day date of the next year, so that the card annual fee can be charged again in the next year; and for the list record of the failure charging, updating the arrearage in the card table, and resetting the same day date of the next month as the next charging date so as to carry out the card annual arrearage additional payment in the next month.
A specific embodiment is given below to illustrate a specific application of the annual bank card fee collection in the embodiment of the present invention. In this embodiment, the annual bank card fee is collected according to the following steps:
1. readjustment and configuration of splitting parameters (card table splitting parameter files and account table splitting parameter files) can be completed by maintenance personnel based on data volume changes of all partitions of the card table and the account table;
2. splitting a parameter file based on a card table at the end of the day, and completing scanning and screening on card table data in parallel to obtain a pre-screening charging list;
3. splitting the parameter file according to the account table, re-splitting and sequencing the pre-screening charging list, and generating a to-be-charged list;
4. according to the generated list to be charged, updating actions such as fee deduction and the like are completed on the account table in parallel, and a charging result list is generated;
5. splitting the parameter file according to the card table, automatically re-splitting and sequencing the charging result list, and generating a result list to be updated;
6. and according to the result list to be updated, updating the card table after charging is completed in parallel.
All the steps are automatic processing processes, and only the operation and maintenance personnel in the step 1 need to adjust and configure when the data volume is greatly changed.
The embodiment of the invention can split certain repeated operation of large data volume based on the data partition condition to realize parallel processing, thereby greatly reducing time windows and realizing batch parallel processing of large data; parallel splitting can be flexibly completed based on table partition splitting parameters configured by operation and maintenance personnel, data of one or more partitions are processed in parallel, balance of data volume processing is flexibly realized as much as possible, and flexible partition splitting is realized; for the operation of the data tables related to a plurality of different partition conditions, the updating operation of the plurality of tables can be completed in sequence through the idea of asynchronous updating and based on the partition conditions of different tables by re-splitting and sequencing, and the parallel processing is completed on the basis of no database deadlock or overtime and ordered data to be processed, so that the asynchronous updating of different partition tables is realized.
The embodiment of the invention has the following advantages:
1) when the partitioned databases are processed in parallel, the splitting action can be flexibly completed according to the partition splitting parameters, and the balanced parallel distribution of data processing is realized.
2) For batch operation involving updating of a plurality of databases in different partitions (for example, annual cost of a card relates to a card table and an account table, and data sequence and partition conditions in the two tables are inconsistent), parallel processing can be completed with highest efficiency through the idea of asynchronous updating under the condition that database problems do not occur.
Based on the same inventive concept, the embodiment of the present invention further provides a device for collecting the annual fee of the bank card, as described in the following embodiments. Because the principle of solving the problems is similar to the method for collecting the annual fee of the bank card, the implementation of the device for collecting the annual fee of the bank card can be referred to the implementation of the method, and repeated details are not repeated.
Fig. 3 is a structural diagram of an annual bank card fee collecting device according to an embodiment of the present invention, and as shown in fig. 3, the annual bank card fee collecting device includes:
a parameter file obtaining module 301, configured to obtain a card table splitting parameter file and an account table splitting parameter file;
the card table splitting module 302 is configured to split a card table according to the card table splitting parameter file;
a parallel scanning module 303, configured to scan the split card table in parallel to obtain multiple sets of bank card information;
the information screening module 304 is configured to screen the multiple sets of bank card information to obtain a pre-screening charging list, where the pre-screening charging list includes an associated account;
a charging list sorting module 305, configured to sort the pre-screening charging list according to the associated account;
the charge list splitting module 306 is configured to split the parameter file according to the account table, split the sorted pre-screening charge list, and obtain a to-be-charged list;
and an annual fee collection module 307, configured to collect the annual fee of the bank card according to the list to be collected.
In one embodiment, each set of bank card information includes: card number information, card state information, associated account state information, annual fee arrearage information, annual fee charging time information, associated account number and fee information to be collected;
the information screening module is further used for: according to the card state information, correlating account state information, annual fee arrearage information and annual fee collecting time information to screen the multiple groups of bank card information; and associating the account number with the information of the expense to be collected according to the card number information of the screened bank card information to generate a pre-screening toll list.
In one embodiment, as shown in fig. 4, the bank card annual fee collection device further includes:
a result list obtaining module 401, configured to obtain a charging result list after the annual fee of the bank card is collected according to the list to be charged, where the charging result list includes card number information, an associated account number, charging result information, fee information to be collected, and real fee information to be collected;
a result list sorting module 402, configured to sort the charging result list according to the card number information;
a result list splitting module 403, configured to split the parameter file according to the card table, split the sorted charging result list, and obtain a result list to be updated;
and a card table updating module 404, configured to update the card table according to the list of results to be updated.
In one embodiment, the card table splitting parameter file includes: card table parallel serial numbers and corresponding card table partition starting information;
the account table splitting parameter file comprises: and the parallel serial number of the account table and the corresponding account table start partition information.
In summary, in the embodiments of the present invention, the card table splitting parameter file and the account table splitting parameter file are obtained; splitting the card table according to the card table splitting parameter file; the split card tables are scanned in parallel to obtain a plurality of groups of bank card information; screening the information of the multiple groups of bank cards to obtain a pre-screening charging list, wherein the pre-screening charging list comprises associated accounts; sorting the pre-screening charging list according to the associated account; splitting the parameter file according to the account table, splitting the sorted pre-screening charging list to obtain a to-be-charged list; and according to the list to be charged, carrying out annual charge collection of the bank card. The embodiment of the invention splits the card table through the card table splitting parameter file, and scans the split card table in parallel to realize the balanced parallel distribution of data processing. And splitting the sorted pre-screening charging list according to the splitting parameter file of the account table to obtain a list to be charged, and thus, carrying out annual charge collection on the bank card according to the list to be charged. By the aid of the asynchronous updating idea, under the condition that the database problem does not occur, parallel processing is completed at the highest efficiency, so that annual fee collection of bank cards is effectively performed, annual fee collection of a large number of associated card accounts is completed within a specified time window range, execution efficiency is improved, and the problem of database overtime or deadlock is avoided.
Based on the aforementioned inventive concept, as shown in fig. 5, the present invention further provides a computer device 500, which includes a memory 510, a processor 520, and a computer program 530 stored on the memory 510 and operable on the processor 520, wherein the processor 520 executes the computer program 530 to implement the aforementioned annual bank card fee collection method.
Based on the foregoing inventive concept, the present invention proposes a computer-readable storage medium storing a computer program which, when executed by a processor, implements the aforementioned bank card annual fee collection method.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are only exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.
Claims (10)
1. A bank card annual fee collection method is characterized by comprising the following steps:
obtaining a card table splitting parameter file and an account table splitting parameter file;
splitting the card table according to the card table splitting parameter file;
the split card tables are scanned in parallel to obtain a plurality of groups of bank card information;
screening the information of the multiple groups of bank cards to obtain a pre-screening charging list, wherein the pre-screening charging list comprises associated accounts;
sorting the pre-screening charging list according to the associated account;
splitting the parameter file according to the account table, splitting the sorted pre-screening charging list to obtain a to-be-charged list;
and according to the list to be charged, carrying out annual charge collection of the bank card.
2. The method for collecting annual bank card fees according to claim 1, wherein each set of bank card information includes: card number information, card state information, associated account state information, annual fee arrearage information, annual fee charging time information, associated account number and fee information to be collected;
screening the multiple groups of bank card information to obtain a pre-screening toll list, comprising: according to the card state information, correlating account state information, annual fee arrearage information and annual fee collecting time information to screen the multiple groups of bank card information; and associating the account number with the information of the expense to be collected according to the card number information of the screened bank card information to generate a pre-screening toll list.
3. The method for collecting an annual bank card fee according to claim 1, further comprising:
acquiring a charging result list after the annual fee of the bank card is charged according to the list to be charged, wherein the charging result list comprises card number information, a related account number, charging result information, fee information to be charged and real fee information to be charged;
sorting a charging result list according to the card number information;
splitting the parameter file according to the card table, splitting the sorted charging result list to obtain a result list to be updated;
and updating the card table according to the result list to be updated.
4. The method for collecting annual fee of bank cards according to claim 1, wherein said card table splitting parameter file includes: card table parallel serial numbers and corresponding card table partition starting information;
the account table splitting parameter file comprises: and the parallel serial number of the account table and the corresponding account table start partition information.
5. A bank card annual fee collection device, comprising:
the parameter file obtaining module is used for obtaining a card table splitting parameter file and an account table splitting parameter file;
the card table splitting module is used for splitting the card table according to the card table splitting parameter file;
the parallel scanning module is used for scanning the split card table in parallel to obtain a plurality of groups of bank card information;
the information screening module is used for screening the information of the plurality of groups of bank cards to obtain a pre-screening charging list, and the pre-screening charging list comprises associated accounts;
the charging list sorting module is used for sorting the pre-screening charging list according to the associated account;
the charge list splitting module is used for splitting the parameter file according to the account table and splitting the sorted pre-screening charge list to obtain a list to be charged;
and the annual fee collection module is used for collecting the annual fee of the bank card according to the list to be collected.
6. The annual bank card fee collection device according to claim 5, wherein each set of bank card information includes: card number information, card state information, associated account state information, annual fee arrearage information, annual fee charging time information, associated account number and fee information to be collected;
the information screening module is further used for: according to the card state information, correlating account state information, annual fee arrearage information and annual fee collecting time information to screen the multiple groups of bank card information; and associating the account number with the information of the expense to be collected according to the card number information of the screened bank card information to generate a pre-screening toll list.
7. The bank card annual fee collection device according to claim 5, further comprising:
a result list obtaining module, configured to obtain a charging result list after the annual bank card fee is collected according to the list to be charged, where the charging result list includes card number information, an associated account number, charging result information, fee information to be collected, and real fee information to be collected;
the result list ordering module is used for ordering the charging result list according to the card number information;
the result list splitting module is used for splitting the parameter file according to the card table and splitting the sorted charging result list to obtain a result list to be updated;
and the card table updating module is used for updating the card table according to the result list to be updated.
8. The apparatus for collecting annual bank card fee according to claim 5, wherein said card table splitting parameter file includes: card table parallel serial numbers and corresponding card table partition starting information;
the account table splitting parameter file comprises: and the parallel serial number of the account table and the corresponding account table start partition information.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of any one of claims 1 to 4 when executing the computer program.
10. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program for executing the method of any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110799040.7A CN113469803A (en) | 2021-07-15 | 2021-07-15 | Bank card annual fee collection method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110799040.7A CN113469803A (en) | 2021-07-15 | 2021-07-15 | Bank card annual fee collection method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113469803A true CN113469803A (en) | 2021-10-01 |
Family
ID=77880504
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110799040.7A Pending CN113469803A (en) | 2021-07-15 | 2021-07-15 | Bank card annual fee collection method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113469803A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113888276A (en) * | 2021-10-12 | 2022-01-04 | 四川新网银行股份有限公司 | Distributed fragment processing method, system and equipment for batch deduction |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2003296641A (en) * | 2002-03-29 | 2003-10-17 | Fujitsu Social Science Laboratory Ltd | Card use control method, customer card processor, customer card and card use control program |
| CN101064024A (en) * | 2006-04-28 | 2007-10-31 | 佛山市顺德区顺达电脑厂有限公司 | Annual fee maintenance system |
| CN106021492A (en) * | 2016-05-20 | 2016-10-12 | 浪潮软件集团有限公司 | Method and device for unloading form data |
| CN107609701A (en) * | 2017-09-11 | 2018-01-19 | 东南大学 | A kind of public bicycles Trip chain extracting method based on IC-card data |
| US10255598B1 (en) * | 2012-12-06 | 2019-04-09 | Consumerinfo.Com, Inc. | Credit card account data extraction |
-
2021
- 2021-07-15 CN CN202110799040.7A patent/CN113469803A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2003296641A (en) * | 2002-03-29 | 2003-10-17 | Fujitsu Social Science Laboratory Ltd | Card use control method, customer card processor, customer card and card use control program |
| CN101064024A (en) * | 2006-04-28 | 2007-10-31 | 佛山市顺德区顺达电脑厂有限公司 | Annual fee maintenance system |
| US10255598B1 (en) * | 2012-12-06 | 2019-04-09 | Consumerinfo.Com, Inc. | Credit card account data extraction |
| CN106021492A (en) * | 2016-05-20 | 2016-10-12 | 浪潮软件集团有限公司 | Method and device for unloading form data |
| CN107609701A (en) * | 2017-09-11 | 2018-01-19 | 东南大学 | A kind of public bicycles Trip chain extracting method based on IC-card data |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113888276A (en) * | 2021-10-12 | 2022-01-04 | 四川新网银行股份有限公司 | Distributed fragment processing method, system and equipment for batch deduction |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7114649B2 (en) | Automatic generation of bank deposits | |
| US8316373B2 (en) | Concurrent data processing and electronic bookkeeping | |
| US7174318B2 (en) | Method and system for an online-like account processing and management | |
| CN110895758B (en) | Screening method, device and system for credit card account with cheating transaction | |
| CN108269184B (en) | Bank institution change management method and system supporting uninterrupted service | |
| CN111738709A (en) | Transaction processing method and device | |
| CN113469803A (en) | Bank card annual fee collection method and device | |
| CN113554509A (en) | Processing method, device, medium and electronic equipment for online payment service | |
| CN112347110A (en) | Data difference determination method, device, equipment and storage medium | |
| CN101271447A (en) | Method and system for completing report forms analysis | |
| CN112214557A (en) | Data matching classification method and device | |
| CN116091258A (en) | Data processing method and device for account checking management | |
| CN110633967A (en) | Payment scheme intelligent adjustment system and method | |
| CN111160885B (en) | Accounting processing method and device | |
| JP2002163458A (en) | Account transfer management method and device | |
| CN113159789A (en) | Cross-bank transfer and remittance method and device | |
| CN113128991A (en) | Public settlement account fund accounting system and working method thereof | |
| CN112581245A (en) | Resource processing method, device and equipment | |
| JP3079170B2 (en) | Cash flow processing device | |
| CN111652714A (en) | Online transaction processing method and system for triggering lunar bottom settlement | |
| CN108920039A (en) | It is a kind of based on configurable cash quota implementation method and device | |
| CN115797037A (en) | Account interest management method and device | |
| CN112801639B (en) | Method and device for determining error transaction scene | |
| CN111179047B (en) | Service data checking method, device, computer equipment and readable storage medium | |
| CN115601186A (en) | Creditor right sorting processing method and device |
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 |