Method, system, terminal device and storage medium for batch processing based on account dimension

Abstract

The application provides a method and system for batch processing based on account dimension, terminal equipment and storage medium, and relates to the field of computer systems. The application processes according to the customer dimension, which is more in line with the current credit card business demand scene. The current scheme is a scheme that takes into account the highest throughput of the customer processing capability. The file configuration is used to realize processing only for part of the customers, which is convenient for testing. The processing architecture of the application takes the customer as the dimension. All customers in the system are traversed, and then each account under the name of a single customer is processed, so that the customer dimension processing and the account dimension processing can be realized.

Description

Technical Field

[0001] This invention relates to the field of computer systems, and more specifically, to a method, system, terminal device, and storage medium for batch processing based on account dimensions. Background Technology

[0002] Current credit card payment processing primarily operates at the account level, iterating through all accounts in the system and processing each account individually. The processing between accounts is independent and uninterrupted, with each account being processed only once. However, this approach falls short in certain business scenarios requiring a customer-centric perspective. For example, a scenario might require summing the balances of all accounts under a customer's name and then redistributing the new balances to each account using an algorithm. The existing process cannot achieve this because even if the program successfully sums the total amount when processing the last account of a customer, it cannot return to the first account to process the payment.

[0003] Existing technology essentially processes data on an account-by-account basis. That is, assuming there are n accounts in the system (Account 1, Account 2, Account 3… Account n), and these n accounts belong to m customers (n>=m), the system processes Account 1, Account 2… sequentially. This approach results in complete isolation between account processing. If it were then necessary to aggregate a certain amount from all accounts under a customer's name and redistribute it among the accounts, this process would be impossible. Summary of the Invention

[0004] This invention provides a method, system, terminal device, and storage medium for batch processing based on account dimensions.

[0005] A batch processing method based on account dimensions, comprising the following steps:

[0006] S1. Obtain customer information and iterate through and filter all customer information;

[0007] S2. Select any customer and iterate through the account information under that customer's name;

[0008] S3. Summarize the total account data in step S2 and redistribute it to each account based on the summarized data.

[0009] Furthermore, step S1, which involves traversing and filtering customer information, includes:

[0010] ① Set the customer number field for the corresponding customer information;

[0011] ② Add a new configuration file and bind the customer number to the configuration file. This establishes a correspondence between the program and the customer number based on the configuration file. The method for binding the customer number to the configuration file is as follows:

[0012] The server receives the customer ID field information sent by the client. The customer ID field information includes the field name and the configuration data corresponding to the field. Then, it determines the target storage field corresponding to each field. Each field corresponds to a unique target storage field. The association between the target storage field and each field can be determined based on the configuration file associated with each field. Finally, based on the configuration data corresponding to each field, the server configures the configuration file associated with the target storage field to achieve the binding of the customer ID and the configuration file.

[0013] ③ Use the SELECT statement provided by the database to query the account table, sort it based on the customer number, and add a filter for the customer number in the WHERE clause;

[0014] ④ Based on the sorting of customer numbers, the program categorizes all accounts under the same customer and passes them to other programs for use.

[0015] Furthermore, the sorting is in ascending order.

[0016] Furthermore: a batch processing system based on account dimensions, including an acquisition module, a configuration module, and a program application module;

[0017] The acquisition module is used to acquire customer account information and account balance information.

[0018] The configuration module is used to establish a connection between the customer number and the application program;

[0019] The application module performs a traversal and statistical analysis of customer accounts based on the customer number.

[0020] Furthermore, the terminal device may include a processor, a storage medium, and a bus. The storage medium stores machine-readable instructions that can be executed by the processor. When the terminal device is running, the processor communicates with the storage medium via the bus, and the processor executes the machine-readable instructions to perform the steps of the deep learning model training method as described in the foregoing embodiments.

[0021] Further: a storage medium storing a computer program, which, when executed by a processor, performs the steps of the method described above.

[0022] The beneficial effects of this invention are: This invention processes scenarios based on the customer dimension, which is more in line with the current needs of credit card business. The current solution takes into account the highest throughput of processing capacity based on the customer, and the file configuration allows processing only some customers, which is convenient for testing. Attached Figure Description

[0023] To more clearly illustrate the technical solutions of the embodiments of the present invention, the accompanying drawings used in the embodiments will be briefly introduced below. It should be understood that the following drawings only show some embodiments of the present invention and should not be regarded as a limitation on the scope. For those skilled in the art, other related drawings can be obtained based on these drawings without creative effort.

[0024] Figure 1 A flowchart illustrating the method of the present invention is shown;

[0025] Figure 2 A schematic diagram of the system composition of the present invention is shown;

[0026] Figure 3 A schematic diagram of the composition of the terminal device of the present invention is shown; Detailed Implementation

[0027] To make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. It should be understood that the accompanying drawings in the present invention are for illustrative and descriptive purposes only and are not intended to limit the scope of protection of the present invention. Furthermore, it should be understood that the schematic drawings are not drawn to scale. The flowcharts used in this invention illustrate operations implemented according to some embodiments of the present invention. It should be understood that the operations in the flowcharts may not be implemented in sequence, and steps without logical contextual relationships may be reversed or implemented simultaneously. In addition, those skilled in the art, guided by the content of this invention, may add one or more other operations to the flowcharts, or remove one or more operations from the flowcharts.

[0028] Furthermore, the embodiments described herein are merely some, not all, of the embodiments of the invention. The components of the embodiments of the invention described and illustrated herein can typically be arranged and designed in various different configurations. Therefore, the following detailed description of the embodiments of the invention provided in the accompanying drawings is not intended to limit the scope of the claimed invention, but merely to illustrate selected embodiments of the invention. All other embodiments obtained by those skilled in the art based on the embodiments of the invention without inventive effort are within the scope of protection of the invention.

[0029] It should be noted that the term "comprising" will be used in the embodiments of the present invention to indicate the presence of a feature subsequently declared, but does not preclude the addition of other features. It should also be noted that similar reference numerals and letters in the following figures indicate similar items; therefore, once an item is defined in one figure, it does not need to be further defined and explained in subsequent figures. In the description of the present invention, it should also be noted that the terms "first," "second," "third," etc., are used only for distinguishing descriptions and should not be construed as indicating or implying relative importance.

[0030] This solution is primarily applied to data processing, especially batch processing. In batch data operations, not all operations can be processed simultaneously. Some operations, due to shared attributes such as belonging to the same user or account, can only be processed sequentially. Even if multiple threads receive instructions to process these operations simultaneously, only one thread can process a portion of the data operations at any given time; the other threads must wait. Only after the first thread finishes processing can the next thread handle other data operations. This iterative processing approach can improve processing speed to some extent.

[0031] Opposite to it, attached Figure 1 A flowchart illustrating the steps of the method of the present invention is shown.

[0032] The specific steps of the method of the present invention include:

[0033] S1. Obtain customer information and iterate through and filter all customer information;

[0034] S2. Select any customer and iterate through the account information under that customer's name;

[0035] S3. Summarize the total account data in step S2 and redistribute it to each account based on the summarized data.

[0036] Step S1, the process of traversing and filtering customer information, includes:

[0037] ① Set the customer number field for the corresponding customer information;

[0038] ② Add a new configuration file and bind the client number to the configuration file. This ensures that the program runs only for the corresponding client number. The method for binding the client number to the configuration file is as follows:

[0039] The server receives the customer ID field information sent by the client. The customer ID field information includes the field name and the configuration data corresponding to the field. Then, it determines the target storage field corresponding to each field. Each field corresponds to a unique target storage field. The association between the target storage field and each field can be determined based on the configuration file associated with each field. Finally, based on the configuration data corresponding to each field, the server configures the configuration file associated with the target storage field to achieve the binding of the customer ID and the configuration file.

[0040] By identifying the target storage field corresponding to each field, and configuring the configuration file associated with the target storage field based on the configuration data corresponding to each field, the configuration data corresponding to the field is configured. Since the configuration data corresponding to the field is the data entered by the user, and the front-end page provided by the client is relatively simple and intuitive, developers with extensive technical knowledge do not need to enter data on the front-end page. This reduces the business requirements for personnel entering configuration data and lowers the workload, thereby improving the accuracy of the configuration to a certain extent. Furthermore, if the user does not enter configuration data in the input area of ​​the front-end page, that is, if no configuration data is entered in the input area of ​​the front-end page, and the field corresponding to the input area where the user did not enter data does not have corresponding configuration data, then there is no need to fill the configuration data corresponding to the field of the input area where no configuration data was entered into the storage field. This storage field is the storage field corresponding to the field of the input area where no configuration data was entered, thus eliminating the need to configure the configuration file associated with this storage field, achieving automatic configuration file filtering.

[0041] ③ Use the SELECT statement provided by the database to query the account table, sorting it in ascending order based on the customer number, and adding a filter for the customer number in the configuration file in the WHERE condition; the WHERE block in the single-table query statement serves to specify the query filtering conditions; the SELECT statement is a statement in SQL (Structured Query Language, a special-purpose programming language used for accessing, querying, updating, and managing relational database systems) used to select data from the database. SELECT statements include dynamic SQL statements and static SQL statements. Dynamic SQL statements contain dynamic conditions and can generate multiple SQL statements, while static SQL statements do not contain dynamic conditions and can only generate one SQL statement. The SELECT statement file contains all the SELECT statements extracted from the standard mapping file. The SELECT statements in the standard mapping file can be extracted using regular expressions to obtain the SELECT statement file. Regular expressions are logical formulas for string manipulation, using predefined specific characters and combinations of these characters to form a "rule string" used to search for and replace text that matches a certain pattern (rule).

[0042] Typical SQL statements include each condition and the relationships between them. To prevent SQL injection vulnerabilities, the following method is generally used to write WHERE clauses and then pass parameters via encoding for the SQL query. When using this method, all conditions must be passed to complete the query.

[0043] According to the defined writing rules, all query conditions are written into the SQL statement in advance. When actually querying, the parameters are dynamically generated and passed according to the required conditions. Before querying, the SQL statement is dynamically generated according to the defined syntax parsing rules of extended query conditions, and variables are automatically generated to pass parameters for conditional querying. Based on the generated query SQL and query parameters, we obtain our final result.

[0044] ④ Based on the sorting of customer numbers, the program categorizes all accounts under the same customer and passes them to other programs for use.

[0045] like Figure 2 As shown, the system for batch processing based on the account dimension of the present invention includes an acquisition module, a configuration module, and a program application module;

[0046] The acquisition module is used to acquire customer account information and account balance information.

[0047] The configuration module is used to establish a connection between the customer number and the application program;

[0048] The application module performs a traversal and statistical analysis of customer accounts based on the customer number.

[0049] like Figure 3 As shown, the terminal device 6 may include a processor 601, a storage medium 602, and a bus 603. The storage medium 602 stores machine-readable instructions executable by the processor 601. When the terminal device is running, the processor 601 communicates with the storage medium 602 via the bus 603. The processor 601 executes the machine-readable instructions to perform the steps of the deep learning model training method described in the foregoing embodiments. The specific implementation and technical effects are similar and will not be repeated here.

[0050] For ease of explanation, only one processor is described in the terminal device described above. However, it should be noted that in some embodiments, the terminal device of the present invention may also include multiple processors, and therefore the steps performed by one processor described in the present invention may also be performed jointly by multiple processors or individually.

[0051] The above are merely specific embodiments of the present invention, but the scope of protection of the present invention is not limited thereto. Any variations or substitutions that can be easily conceived by those skilled in the art within the technical scope disclosed in the present invention should be included within the scope of protection of the present invention. Therefore, the scope of protection of the present invention should be determined by the scope of the claims.

Claims

1. A method for batch processing based on account dimensions, characterized in that, Includes the following steps: S1. Obtain customer information and iterate through and filter all customer information. The iteration and filtering steps include: ① Set the customer number field for the corresponding customer information; ② Add a new configuration file and bind the client number to the configuration file. This establishes a correspondence between the program and the client number based on the configuration file. The steps for binding the client number to the configuration file include: the server receiving the client number field information sent by the client. This client number field information includes the field name and the corresponding configuration data. Then, the target storage field corresponding to each field is determined. Each field corresponds to a unique target storage field. The association between each target storage field and the target storage field can be determined based on the configuration file associated with each field. Finally, based on the configuration data corresponding to each field, the configuration file associated with the target storage field is configured to achieve the binding between the client number and the configuration file. ③ Use the SELECT statement provided by the database to query the account table and sort it based on the customer number; ④ Based on the customer number sorting, the program categorizes all accounts under the same customer and passes them to other programs for use; S2. Select any customer and iterate through the account information under that customer's name; S3. Summarize the total account data in step S2 and redistribute it to each account based on the summarized data.

2. The method according to claim 1, characterized in that, The customer numbers are sorted in ascending order.

3. The method according to claim 1, characterized in that, During the sorting of customer numbers, a filter for customer numbers in the configuration file is added to the WHERE clause.

4. The method according to claim 1, characterized in that, The number of accounts mentioned is greater than the number of customers.

5. The method according to claim 1, characterized in that, The summarized data refers to account balances.

6. A system for batch processing based on account dimensions, used to implement the method according to any one of claims 1-5, characterized in that, This includes an acquisition module, a configuration module, and a program application module; The acquisition module is used to acquire customer account information and account balance information. The configuration module is used to establish a connection between the customer number and the application program; The application module performs a traversal and statistical analysis of customer accounts based on the customer number.

7. A terminal device, characterized in that, include: The device includes a processor, a storage medium, and a bus, wherein the storage medium stores machine-readable instructions executable by the processor, and when the terminal device is running, the processor communicates with the storage medium via the bus, and the processor executes the machine-readable instructions to perform the steps of the method as described in any one of claims 1 to 5.

8. A storage medium, characterized in that, The storage medium stores a computer program, which, when executed by a processor, performs the steps of the method as described in any one of claims 1 to 5.

9. A computer program product, comprising a computer program and / or instructions, characterized in that, When the computer program and / or instructions are executed by a processor, they implement the steps of the method according to any one of claims 1 to 5.

Images