Account processing method and device

Abstract

The present invention discloses an account processing method and apparatus, relating to the field of automatic programming technology. The method comprises: obtaining a configuration file, the configuration file including a range of account data table numbers to be processed and database information; reading, based on the database information, an account number corresponding to the range of account data table numbers from a corresponding database; reading, based on the account number, the account data, balance data, and transaction data corresponding to the account number; and performing account processing based on the account data, balance data, and transaction data. The present invention can address existing issues such as high operation and maintenance costs, inability to effectively expand resources, and excessively long batch job runtimes.

Description

Technical Field

[0001] The present invention relates to the technical field of automatic programming, and in particular to an account processing method and device. Background Art

[0002] This section is intended to provide a background or context to the embodiments of the invention that are recited in the claims. No statement herein is admitted to be prior art by virtue of its inclusion in this section.

[0003] Current account processing jobs run on IBM mainframes, storing account data on them and utilizing the computing power of a single machine to traverse and process all account data. Because processing relies on the computing resources of a single machine, processing time increases linearly with increasing data volume. To minimize this increase in processing time, additional computing resources must be added to the single machine. However, IBM mainframe computing resources are expensive, and there is always a limit to the amount of computing resources that can be added to a single machine. Consequently, existing account processing methods suffer from high operational and maintenance costs, an inability to effectively scale resources, and excessively long batch job runtimes.

[0004] To address the above issues, no effective solutions have been proposed so far. Summary of the Invention

[0005] An embodiment of the present invention provides an account processing method to address the existing problems of high operation and maintenance costs, inability to effectively expand resources, and excessively long batch job running times. The method includes:

[0006] Obtaining a configuration file, wherein the configuration file includes a number range of the account data table to be processed and database information;

[0007] According to the database information, the account number corresponding to the account data table number range is read from the corresponding database;

[0008] According to the account number, read the account data, balance data and transaction data corresponding to the account number;

[0009] Account processing is performed based on the account data, balance data and transaction data.

[0010] Furthermore, the configuration file also includes: the number of concurrent accounts;

[0011] Performing account processing according to the account data, balance data and transaction data, including: performing account processing according to the account concurrency number, account data, balance data and transaction data.

[0012] Furthermore, the account data table number range includes: a minimum account data table number and a maximum account data table number;

[0013] The number of concurrent accounts is less than the difference between the maximum value of the account data table number and the minimum value of the account data table number.

[0014] Furthermore, the account processing method further includes:

[0015] Create output table;

[0016] Storing the result of the account processing in the output table;

[0017] The account data table is updated according to the output table.

[0018] Furthermore, the account processing method further includes:

[0019] Establish database constraints for the updated account data table.

[0020] Furthermore, the account processing method further includes:

[0021] Create a database index for the updated account data table.

[0022] Furthermore, the account processing method further includes:

[0023] Collect database statistics for the updated account data tables.

[0024] An embodiment of the present invention provides an account processing device to address the existing problems of high operation and maintenance costs, inability to effectively expand resources, and excessively long batch job running times. The device includes:

[0025] A file acquisition module is used to obtain a configuration file, wherein the configuration file includes the account data table number range and database information to be processed;

[0026] An account number reading module, configured to read the account number corresponding to the account data table number range from the corresponding database according to the database information;

[0027] A data reading module, configured to read the account data, balance data, and transaction data corresponding to the account number according to the account number;

[0028] The account processing module is used to perform account processing based on the account data, balance data and transaction data.

[0029] Furthermore, the configuration file also includes: the number of concurrent accounts;

[0030] The account processing module is further used to perform account processing based on the account concurrency number, account data, balance data and transaction data.

[0031] Furthermore, the account data table number range includes: a minimum account data table number and a maximum account data table number;

[0032] The number of concurrent accounts is less than the difference between the maximum value of the account data table number and the minimum value of the account data table number.

[0033] Furthermore, the account processing device further includes:

[0034] Output table creation module, used for creating output table;

[0035] A result storage module, used for storing the result of account processing into the output table;

[0036] A data table updating module is used to update the account data table according to the output table.

[0037] Furthermore, the account processing device further includes:

[0038] The constraint establishment module is used to establish database constraints for the updated account data table.

[0039] Furthermore, the account processing device further includes:

[0040] The index creation module is used to create a database index for the updated account data table.

[0041] Furthermore, the account processing device further includes:

[0042] The information collection module is used to collect database statistical information for the updated account data table.

[0043] A computer device is also provided in an embodiment of the present invention. The computer device includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the above-mentioned account processing method is implemented.

[0044] An embodiment of the present invention further provides a computer-readable storage medium storing a computer program for executing the above-mentioned account processing method.

[0045] Embodiments of the present invention relate to the field of automated programming technology. A configuration file is obtained, the configuration file including a range of account data table numbers to be processed and database information; based on the database information, the account number corresponding to the range of account data table numbers is read from a corresponding database; based on the account number, the account data, balance data, and transaction data corresponding to the account number are read; and account processing is performed based on the account data, balance data, and transaction data. Compared to existing solutions for performing account processing stored on IBM mainframes, the embodiments of the present invention utilize configuration files to extract account numbers and corresponding data, effectively resolving issues such as high operational and maintenance costs, inability to effectively scale resources, and excessively long batch job runtimes. BRIEF DESCRIPTION OF THE DRAWINGS

[0046] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the following briefly introduces the drawings required for the embodiments or the description of the prior art. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative work. In the drawings:

[0047] Figure 1 This is a flow chart of an account processing method provided in an embodiment of the present invention;

[0048] Figure 2 Schematic diagram of the relationship between the database and the server in an embodiment of the present invention;

[0049] Figure 3 A schematic diagram of an account processing device provided in an embodiment of the present invention;

[0050] Figure 4 A schematic diagram of an electronic device provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0051] To make the purpose, technical solutions and advantages of the embodiments of the present invention more clear, the embodiments of the present invention are further described in detail below with reference to the accompanying drawings. Here, the exemplary embodiments of the present invention and their descriptions are used to explain the present invention, but are not intended to limit the present invention.

[0052] First, the techniques involved in the embodiments of the present invention are explained:

[0053] IBM mainframe: Refers to early IBM computers, primarily used to distinguish them from modern microcomputers. Mainframes are named primarily for their large size and high cost. They are renowned for their stability, security, and powerful data processing capabilities, and are often used in industries such as finance and securities. The term "mainframe" originally referred to large computer systems housed in very large, framed metal boxes, distinguishing them from smaller minicomputers and microcomputers. Although the term has been used in various ways over the years, it most commonly refers to the series of IBM computers starting with the System / 360. The term can also refer to compatible systems manufactured by other manufacturers, such as Amdahl and Hitachi Data Systems (HDS). Mainframes offer performance advantages unmatched by other server types, such as availability, scalability, security, partitioning, and load capacity. Mainframes' exceptional ability to handle complex multitasking results in significantly less downtime than other server types. Mainframes also offer strong I / O capabilities, making them adept at accessing extremely large databases. Dynamic partitioning allows for flexible allocation of system resources based on the size of application workloads. Designed to prevent intrusion from occurring, mainframes offer enhanced security. The above features make mainframes irreplaceable for applications in industries such as finance, telecommunications, transportation, energy, and government that have extremely stringent requirements on system processing power, security, and stability.

[0054] Account: Data with a certain format, which can be imagined as a row of data in several tables. A single table may have thousands of columns and hundreds of millions of rows.

[0055] Job: The term "job" mentioned below refers to a computer program specially written to implement account processing. The main function provided by this job is to read the data in the account table in the database, process it, and update the processed data back to the original account table.

[0056] Database: A database is a "warehouse that organizes, stores, and manages data according to data structures." It is a collection of large amounts of data that is stored in a computer for a long time, organized, shareable, and uniformly managed. A database is a warehouse for storing data. It has a large storage space and can store millions, tens of millions, or even hundreds of millions of data items. However, the database does not store data arbitrarily, but has certain rules, otherwise the query efficiency will be very low. Today's world is an Internet world full of data, filled with a large amount of data. That is, this Internet world is a data world. There are many sources of data, such as travel records, consumption records, browsed web pages, sent messages, and so on. In addition to text-type data, images, music, and sounds are all data. A database is a computer software system that stores and manages data according to data structures. The concept of database actually includes two meanings:

[0057] (1) A database is an entity. It is a "warehouse" that can reasonably store data. Users store the transaction data to be managed in this "warehouse". The two concepts of "data" and "library" are combined to form a database.

[0058] (2) Database is a new method and technology for data management. It can organize data more appropriately, maintain data more conveniently, control data more strictly and use data more effectively.

[0059] As mentioned earlier, the current account processing jobs run on IBM mainframes, which have high operation and maintenance costs. As the number of accounts increases, the architecture cannot be flexibly expanded, resulting in a significant increase in the running time of batch jobs.

[0060] Account data is stored on an IBM mainframe, utilizing the computing power of a single machine to traverse and process all account data. Because processing relies on the computing resources of a single machine, processing time increases linearly with increasing data volume. To minimize this increase in processing time, additional computing resources must be added to the single machine. However, due to the high cost of IBM mainframe computing resources and the inherent upper limit on the amount of computing resources that can be added to a single machine, existing technologies suffer from the following drawbacks: resources cannot be effectively scaled as the number of accounts increases, and operational and maintenance costs are high.

[0061] In order to solve the existing problems of high operation and maintenance costs, inability to effectively expand resources, and long batch job running time, an account processing method is provided in an embodiment of the present invention. Figure 1 A flowchart of an account processing method is provided in an embodiment of the present invention. Figure 1 As shown, the following steps are included:

[0062] Step 101: Obtain a configuration file, wherein the configuration file includes the account data table number range and database information to be processed;

[0063] Step 102: Read the account number corresponding to the account data table number range from the corresponding database according to the database information;

[0064] Step 103: Read the account data, balance data, and transaction data corresponding to the account number according to the account number;

[0065] Step 104: Perform account processing based on the account data, balance data, and transaction data.

[0066] Depend on Figure 1As shown, the embodiment of the present invention obtains a configuration file, which includes the account data table number range to be processed and database information; reads the account number corresponding to the account data table number range from the corresponding database based on the database information; reads the account data, balance data, and transaction data corresponding to the account number based on the account number; and performs account processing based on the account data, balance data, and transaction data. Compared to existing solutions for account processing stored on IBM mainframes, the embodiment of the present invention uses a configuration file to extract account numbers and corresponding data, effectively solving the problems of high operation and maintenance costs, inability to effectively scale resources, and excessive batch job runtimes.

[0067] In this embodiment, account data is distributed across multiple databases, and batch jobs are run using multiple servers, reducing operational costs. Furthermore, as data volume increases, the number of servers and databases can be expanded to ensure that jobs are completed within a fixed timeframe. This distributed technology transforms existing systems, reducing operational costs. As account data grows, servers can theoretically be expanded infinitely to ensure that jobs are completed within a fixed timeframe.

[0068] In an embodiment, a configuration file is obtained, which includes the account data table number range and database information to be processed. According to the database information, the account number corresponding to the account data table number range is read from the corresponding database. According to the account number, the account data, balance data and transaction data corresponding to the account number are read. According to the account data, balance data and transaction data, account processing is performed.

[0069] In practice, for a population of hundreds of millions of accounts, the account data is evenly distributed across M account data tables (numbered 1-M), which are then evenly distributed across N databases (DB1-DBN). Assume that K servers are used, each running a job to process the account data in the database.

[0070] The inventors discovered that when a program reads account data, it also needs to simultaneously read the account's associated transaction data and balance data to complete the processing. To address this scenario, the present invention's embodiment does not first load all account-related data into server memory and then read from memory for processing. Instead, it utilizes the database's "left join" functionality to connect account data, balance data, and transaction data by account number, and then reads and processes them one by one. This approach increases the database's I / O load, but reduces server memory usage, effectively improving job processing efficiency.

[0071] In this embodiment, the configuration file also includes: the number of concurrent accounts;

[0072] Performing account processing according to the account data, balance data and transaction data, including: performing account processing according to the account concurrency number, account data, balance data and transaction data.

[0073] In this embodiment, the account data table number range includes: a minimum account data table number and a maximum account data table number;

[0074] The number of concurrent accounts is less than the difference between the maximum value of the account data table number and the minimum value of the account data table number.

[0075] In specific implementation, when a job starts executing, it first reads the configuration file, which is in the following format:

[0076] <jobid> ＝ <minidx> _ <maxidx>_<Concurrency number>_ <dbid>

[0077] Among them, JobId refers to the job number, which is used to identify the uniqueness of each job I (1 <= JobId <= K), and can be obtained when each job starts. MinIdx and maxIdx refer to the account data table number range that the job needs to process (1 <= minIdx <= maxIdx <= M).

[0078] The concurrency value refers to the number of account tables that the job can process at one time. It is used to control the processing speed of a single job. This value should be smaller than the difference between maxIdx and minIdx, that is, smaller than the number of data tables that the job can process.

[0079] DBID refers to the database number (1 <= DBID <= N) where the data table is stored. By reading this configuration file, each job can determine which database and account data table within which number range it needs to process after it is started. Jobs on multiple servers will process data from one database, and each job will not process account data from two databases at the same time. That is, there is a many-to-one relationship between jobs and databases, such as Figure 2 shown.

[0080] In this embodiment, the account processing method further includes:

[0081] Create output table;

[0082] Storing the result of the account processing in the output table;

[0083] The account data table is updated according to the output table.

[0084] In this embodiment, the account processing method further includes: establishing database constraints on the updated account data table.

[0085] In this embodiment, the account processing method further includes: establishing a database index for the updated account data table.

[0086] In this embodiment, the account processing method further includes: collecting database statistical information for the updated account data table.

[0087] The inventors have discovered that a common method for updating data is to use the database's update statement to directly update the processed account data into the original data. This method is not adopted in the embodiments of the present invention. Instead, the following method is adopted:

[0088] 1. Generate output table T_X for account data table T;

[0089] 2. When the job starts, it reads the T table data, processes it, and outputs the results to the T_X table;

[0090] 3. After the entire account data table is processed, rename table T to T_tmp and T_X to T;

[0091] 4. Rebuild database constraints and indexes for table T;

[0092] 5. Collect database statistics for table T;

[0093] 6. The job is completed.

[0094] This method will greatly improve the processing capacity of the job, without having to worry about data loss, dirty data, and other problems caused by improper operation or unexpected interruptions.

[0095] During implementation, the configuration file is read to determine the range of account table numbers that the current job needs to process, assuming it is from the min account table to the max account table (1 <= min <= max <= M). These tables are then traversed for processing. Assuming the current processing has reached table i (min <= i <= max), and assuming this table is Ti, determine whether the Ti_TMP table exists. If so, delete the T table, rename the T_TMP table to the T table, and proceed to the next step. Create a new table Ti_X, clear the Ti_X table, and after processing the account data, rename the Ti table to Ti_TMP, and rename the Ti_X table to Ti, completing the job execution.

[0096] The account processing method provided by the embodiment of the present invention has the following advantages:

[0097] Configurable solution: This invention provides a unified and flexibly configurable solution. After startup, jobs on multiple servers can effectively cooperate with the database by reading configuration files to jointly process hundreds of millions of account data.

[0098] High-throughput solution: This invention provides a solution that enables jobs to read and update account data more efficiently.

[0099] Support for re-execution scheme: If the job is abnormally interrupted, the re-execution scheme provided by this invention supports manual and multiple re-runs of the job without worrying about data loss, dirty data and other problems.

[0100] High throughput means the system can handle a large number of users simultaneously. This refers to the number of users the entire system can serve simultaneously. This throughput cannot be achieved with a single server; multiple servers collaborate to achieve the required throughput. Furthermore, how to effectively utilize these servers without causing a single server to become a bottleneck, thereby impacting the overall system's processing power, is a distributed system issue that requires careful architectural trade-offs.

[0101] Based on the same inventive concept, the present invention also provides an account processing device, as described in the following embodiments. Since the principle of the device to solve the problem is similar to that of the account processing method, the implementation of the device can refer to the implementation of the method, and the repeated parts will not be repeated.

[0102] Figure 3 A schematic diagram of an account processing device is provided in an embodiment of the present invention. Figure 3 As shown, the account processing device provided in the embodiment of the present invention may include:

[0103] A file acquisition module 301 is used to obtain a configuration file, wherein the configuration file includes the account data table number range and database information to be processed;

[0104] An account number reading module 302 is configured to read the account number corresponding to the account data table number range from the corresponding database according to the database information;

[0105] A data reading module 303 is used to read the account data, balance data and transaction data corresponding to the account number according to the account number;

[0106] The account processing module 304 is used to perform account processing based on the account data, balance data and transaction data.

[0107] In one embodiment, the configuration file further includes: the number of concurrent accounts;

[0108] The account processing module is further used to perform account processing based on the account concurrency number, account data, balance data and transaction data.

[0109] In one embodiment, the account data table number range includes: a minimum account data table number and a maximum account data table number;

[0110] The number of concurrent accounts is less than the difference between the maximum value of the account data table number and the minimum value of the account data table number.

[0111] In one embodiment, the account processing device further includes:

[0112] Output table creation module, used for creating output table;

[0113] A result storage module, used for storing the result of account processing into the output table;

[0114] A data table updating module is used to update the account data table according to the output table.

[0115] In one embodiment, the account processing device further includes:

[0116] The constraint establishment module is used to establish database constraints for the updated account data table.

[0117] In one embodiment, the account processing device further includes:

[0118] The index creation module is used to create a database index for the updated account data table.

[0119] In one embodiment, the account processing device further includes:

[0120] The information collection module is used to collect database statistical information for the updated account data table.

[0121] In summary, the present embodiment obtains a configuration file, which includes the account data table number range to be processed and database information; reads the account number corresponding to the account data table number range from the corresponding database based on the database information; reads the account data, balance data, and transaction data corresponding to the account number based on the account number; and performs account processing based on the account data, balance data, and transaction data. Compared to existing solutions for account processing stored on IBM mainframes, the present embodiment utilizes a configuration file to extract account numbers and corresponding data, effectively resolving issues such as high operational and maintenance costs, inability to effectively scale resources, and excessively long batch job runtimes.

[0122] Based on the same inventive concept, an embodiment of the present invention further provides an electronic device embodiment for implementing all or part of the above-mentioned account processing method. The electronic device specifically includes the following contents:

[0123] A processor, a memory, a communications interface, and a bus; wherein the processor, memory, and communications interface communicate with each other via the bus; the communications interface is used to transmit information between related devices; the electronic device may be a desktop computer, a tablet computer, a mobile terminal, etc., but this embodiment is not limited thereto. In this embodiment, the electronic device may be implemented with reference to the embodiments for implementing the above-mentioned account processing method and the embodiments for implementing the above-mentioned account processing apparatus, the contents of which are incorporated herein and any repetitions are omitted.

[0124] Figure 4 FIG. 1 is a schematic diagram of a system structure of an electronic device provided in an embodiment of the present invention. Figure 4 As shown, the electronic device 40 may include a processor 401 and a memory 402; the memory 402 is coupled to the processor 401. Figure 4 is exemplary; other types of structures may also be used to supplement or replace this structure to implement telecommunication functions or other functions.

[0125] In one embodiment, the functions implemented by the account processing method can be integrated into the processor 401. Specifically, the processor 401 can be configured to perform the following control operations: obtaining a configuration file, the configuration file including the account data table number range to be processed and database information; reading the account number corresponding to the account data table number range from the corresponding database based on the database information; reading the account data, balance data, and transaction data corresponding to the account number based on the account number; and performing account processing based on the account data, balance data, and transaction data.

[0126] As can be seen from the above, the electronic device provided in the embodiments of the present invention obtains a configuration file, which includes the account data table number range and database information to be processed; based on the database information, reads the account number corresponding to the account data table number range from the corresponding database; based on the account number, reads the account data, balance data and transaction data corresponding to the account number; and performs account processing based on the account data, balance data and transaction data.

[0127] The electronic device provided in the embodiment of the present invention can solve the existing problems of high operation and maintenance costs, inability to effectively expand resources, and excessively long running time of batch jobs.

[0128] In another embodiment, the account processing device may be configured separately from the processor 401 . For example, the account processing device may be configured as a chip connected to the processor 401 , and the functions of the account processing method may be implemented under the control of the processor.

[0129] like Figure 4 As shown, the electronic device 40 may further include: a communication module 403, an input unit 404, an audio processing unit 405, a display 406, and a power supply 403. It is worth noting that the electronic device 40 does not necessarily have to include Figure 4 In addition, the electronic device 40 may also include Figure 4 For components not shown, reference may be made to the prior art.

[0130] like Figure 4 As shown, the processor 401 is sometimes also referred to as a controller or an operation control, and may include a microprocessor or other processor devices and / or logic devices. The processor 401 receives inputs and controls the operations of various components of the electronic device 40 .

[0131] Memory 402 may be, for example, one or more of a cache, flash memory, hard drive, removable media, volatile memory, non-volatile memory, or other suitable devices. It may store the aforementioned failure-related information and may also store programs that execute the relevant information. Processor 401 may execute the programs stored in memory 402 to implement information storage or processing.

[0132] Input unit 404 provides input to processor 401. Input unit 404 may be, for example, a keypad or touch input device. Power supply 403 is used to provide power to electronic device 40. Display 406 is used to display objects such as images and text. This display may be, for example, an LCD display, but is not limited thereto.

[0133] The memory 402 may be a solid-state memory, such as a read-only memory (ROM), a random access memory (RAM), a SIM card, or the like. Alternatively, it may be a memory that retains information even when power is off, can be selectively erased, and is provided with more data. Examples of such memory are sometimes referred to as EPROMs. The memory 402 may also be some other type of device. The memory 402 includes a buffer memory 4021 (sometimes referred to as a buffer). The memory 402 may include an application / function storage unit 4022 for storing application programs and function programs or processes for executing the operation of the electronic device 40 via the processor 401.

[0134] The memory 402 may also include a data storage unit 4023 for storing data, such as contacts, digital data, pictures, sounds, and / or any other data used by the electronic device. The driver storage unit 4024 of the memory 402 may include various driver programs for the electronic device for communication functions and / or for executing other functions of the electronic device (such as messaging applications, address book applications, etc.).

[0135] The communication module 403 is a transmitter / receiver that sends and receives signals via the antenna 408. The communication module (transmitter / receiver) 403 is coupled to the processor 401 to provide input signals and receive output signals, which may be the same as the case of a conventional mobile communication terminal.

[0136] Based on different communication technologies, multiple communication modules 403 may be provided in the same electronic device, such as a cellular network module, a Bluetooth module, and / or a wireless local area network module. The communication module (transmitter / receiver) 403 is also coupled to a speaker 409 and a microphone 410 via an audio processing unit 405 to provide audio output via the speaker 409 and receive audio input from the microphone 410, thereby implementing common telecommunication functions. The audio processing unit 405 may include any suitable buffer, decoder, amplifier, etc. Furthermore, the audio processing unit 405 is coupled to the processor 401, enabling local recording via the microphone 410 and playback of stored audio via the speaker 409.

[0137] An embodiment of the present invention further provides a computer-readable storage medium for implementing all the steps of the account processing method in the above embodiment. The computer-readable storage medium stores a computer program. When the computer program is executed by a processor, all the steps of the account processing method in the above embodiment are implemented. For example, when the processor executes the computer program, the following steps are implemented: obtaining a configuration file, the configuration file including the account data table number range and database information to be processed; reading the account number corresponding to the account data table number range from the corresponding database according to the database information; reading the account data, balance data and transaction data corresponding to the account number according to the account number; and performing account processing according to the account data, balance data and transaction data.

[0138] As can be seen from the above, the computer-readable storage medium provided in the embodiments of the present invention obtains a configuration file, wherein the configuration file includes the account data table number range and database information to be processed; based on the database information, reads the account number corresponding to the account data table number range from the corresponding database; based on the account number, reads the account data, balance data, and transaction data corresponding to the account number; and performs account processing based on the account data, balance data, and transaction data.

[0139] The computer-readable storage medium provided in the embodiments of the present invention can solve the existing problems of high operation and maintenance costs, inability to effectively expand resources, and excessively long running time of batch jobs.

[0140] Although the present invention provides method operation steps as described in the embodiments or flowcharts, more or fewer operation steps may be included based on conventional or non-creative work. The order of steps listed in the embodiments is only one way of executing the steps among many steps and does not represent the only execution order. When an actual device or client product is executed, the method can be executed sequentially or in parallel according to the embodiments or the accompanying drawings (for example, in a parallel processor or multi-threaded processing environment).

[0141] Those skilled in the art will appreciate that the embodiments of this specification may be provided as methods, devices (systems), or computer program products. Thus, the embodiments of this specification may take the form of entirely hardware embodiments, entirely software embodiments, or embodiments combining software and hardware. Furthermore, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to magnetic disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0142] The present invention is described with reference to flowcharts and / or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowcharts and / or block diagrams, as well as combinations of processes and / or blocks in the flowcharts and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowcharts and / or block diagrams. Figure 1 a process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0143] These computer program instructions may also be stored in a computer readable memory that can direct a computer or other programmable data processing device to work in a specific manner, so that the instructions stored in the computer readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 a process or multiple processes and / or boxes Figure 1 The function specified in one or more boxes.

[0144] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operational steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing the instructions executed on the computer or other programmable device for implementing the process. Figure 1 a process or multiple processes and / or boxes Figure 1 A step that specifies a function in one or more boxes.

[0145] The various embodiments in this specification are described in a progressive manner. Similar or identical parts between the various embodiments may be referenced to each other. Each embodiment focuses on the differences from the other embodiments. In particular, the system embodiments, since they are generally similar to the method embodiments, are described more simply. For relevant details, refer to the description of the method embodiments. In this document, relational terms such as first and second, etc., are used solely to distinguish one entity or operation from another and do not necessarily require or imply any actual relationship or order between these entities or operations. Furthermore, the terms "comprise," "include," or any other variations thereof are intended to encompass non-exclusive inclusion, such that a process, method, article, or apparatus comprising a list of elements includes not only those elements but also other elements not explicitly listed, or elements inherent to such process, method, article, or apparatus. Terms such as "upper" and "lower" to indicate orientations or positional relationships are based on those shown in the accompanying drawings and are intended solely to facilitate the description of the present invention and simplify the description. They are not intended to indicate or imply that the devices or elements referred to must have, be constructed, or operate in a specific orientation. Therefore, they should not be construed as limiting the present invention. Unless otherwise expressly specified and limited, the terms "installed", "connected" and "connected" should be understood in a broad sense. For example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection, or an indirect connection through an intermediate medium, or it can be internal communication between two components. For those of ordinary skill in the art, the specific meanings of the above terms in the present invention can be understood according to specific circumstances. It should be noted that, unless there is a conflict, the embodiments of the present invention and the features in the embodiments can be combined with each other. The present invention is not limited to any single aspect, nor to any single embodiment, nor to any combination and / or permutation of these aspects and / or embodiments. Each aspect and / or embodiment of the present invention may be used alone or in combination with one or more other aspects and / or other embodiments.

[0146] The above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit the same. Although the present invention has been described in detail with reference to the above embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the above embodiments, or make equivalent replacements for some or all of the technical features therein. These modifications or replacements do not deviate the essence of the corresponding technical solutions from the scope of the technical solutions of the embodiments of the present invention, and they should all be included in the scope of the claims and description of the present invention.< / dbid> < / maxidx> < / minidx> < / jobid>

Claims

1. An account processing method, applied to multiple servers, characterized in that: include: Obtaining a configuration file, wherein the configuration file includes a number range of the account data table to be processed and database information; According to the database information, the account number corresponding to the account data table number range is read from the corresponding database; According to the account number, read the account data, balance data and transaction data corresponding to the account number; Perform account processing based on the account data, balance data and transaction data; The configuration file also includes: the number of concurrent accounts; Performing account processing based on the account data, balance data, and transaction data, including: performing account processing based on the account concurrency number, account data, balance data, and transaction data; The account data table number range includes: the minimum account data table number and the maximum account data table number; the account concurrent number is less than the difference between the maximum account data table number and the minimum account data table number.

2. The account processing method according to claim 1, wherein: Also includes: Create output table; storing the result of the account processing into the output table; The account data table is updated according to the output table.

3. The account processing method according to claim 2, wherein: Also includes: Establish database constraints for the updated account data table.

4. The account processing method according to claim 2, wherein: Also includes: Create a database index for the updated account data table.

5. The account processing method according to claim 2, wherein: Also includes: Collect database statistics for the updated account data tables.

6. An account processing device, applied to multiple servers, characterized in that: include: A file acquisition module, configured to obtain a configuration file, wherein the configuration file includes a number range of the account data table to be processed and database information; An account number reading module, configured to read the account number corresponding to the account data table number range from the corresponding database according to the database information; A data reading module, configured to read the account data, balance data, and transaction data corresponding to the account number according to the account number; An account processing module, configured to perform account processing based on the account data, balance data, and transaction data; The configuration file also includes: the number of concurrent accounts; The account processing module is further configured to: perform account processing based on the account concurrent number, account data, balance data, and transaction data; The account data table number range includes: the minimum account data table number and the maximum account data table number; The number of concurrent accounts is less than the difference between the maximum value of the account data table number and the minimum value of the account data table number.

7. The account processing device according to claim 6, wherein: Also includes: Output table creation module, used for creating output table; A result storage module, used for storing the result of account processing into the output table; A data table updating module is used to update the account data table according to the output table.

8. The account processing device according to claim 7, wherein: Also includes: The constraint establishment module is used to establish database constraints for the updated account data table.

9. The account processing device according to claim 7, wherein: Also includes: The index creation module is used to create a database index for the updated account data table.

10. The account processing device according to claim 7, wherein: Also includes: The information collection module is used to collect database statistical information for the updated account data table.

11. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein: When the processor executes the computer program, the account processing method according to any one of claims 1 to 5 is implemented.

12. A computer-readable storage medium, characterized in that The computer-readable storage medium stores a computer program for executing the account processing method according to any one of claims 1 to 5.

Images