Interest management method and device, computer device, storage medium and program product

Abstract

The application relates to an interest calculation management method and device, computer equipment, a storage medium and a program product. The method comprises the following steps: obtaining a safe operation parameter of an interest calculation task; the interest calculation task comprises an interest calculation batch task and a log file duplication task; performing the interest calculation task according to the safe operation parameter; in the process of performing the interest calculation task, the running state of a database and the CPU running state of a first server satisfy a preset running condition; the database is used for storing a log file corresponding to the log file duplication task. The interest calculation management method is an automatic interest calculation management method, manual adjustment of related parameters of the interest calculation task and subsequent operation and maintenance operations are not needed, uncertainty caused by manual operation is reduced, and it is ensured that the interest calculation task can be safely operated.

Description

Technical Field

[0001] This application relates to the field of system security technology, and in particular to an interest calculation and management method, apparatus, computer equipment, storage medium, and program product. Background Technology

[0002] With the continuous development of society and the economy, banks are playing an increasingly important role in people's lives and work. Among the many calculation operations in the banking system, interest calculation is one of the core operations. Specifically, interest calculation refers to the bank's operation of calculating the interest on demand deposits in personal accounts.

[0003] Generally, major banks have a huge number of current accounts, and a large amount of interest calculation information for individual accounts needs to be updated within each preset time period (e.g., each quarter), with certain limitations on the update time for each quarter. For example, during the execution of quarterly interest calculation operations, on the one hand, the CPU load remains high, and on the other hand, the interest calculation operation generates a large number of log files, requiring a significant amount of memory. Therefore, both of these factors put enormous pressure on the host machine executing the interest calculation operation, leading to security risks. Therefore, ensuring the secure and stable operation of interest calculation operations is crucial for interest calculation management.

[0004] Traditional methods typically rely on database administrators to adjust parameters and dynamically monitor interest calculation jobs in real time to ensure their secure operation. However, relying solely on manual real-time management of interest calculation jobs can lead to serious performance or capacity issues on the host executing the job if an oversight occurs, ultimately preventing the job from running securely. Therefore, traditional methods relying on manual real-time management of interest calculation jobs have insufficient security. Summary of the Invention

[0005] Therefore, it is necessary to provide an interest management method, apparatus, computer equipment, storage medium, and program product that can reduce costs and improve efficiency in response to the above-mentioned technical problems.

[0006] Firstly, this application provides an interest calculation management method. The method includes:

[0007] Obtain the safe operating parameters for the interest calculation operation; the interest calculation operation includes batch interest calculation operations and log file copying operations.

[0008] The interest calculation operation shall be performed in accordance with the aforementioned safe operating parameters;

[0009] During the execution of the interest calculation operation, the operating status of the control database and the CPU operating status of the first server are controlled to meet preset operating conditions; the database is used to store the log files corresponding to the log file copying operation.

[0010] In one embodiment, obtaining the safe operating parameters of the interest calculation operation includes:

[0011] Obtain the preset queue depth parameter of the interest calculation batch job and the preset data transmission parameter of the log file copy job.

[0012] In one embodiment, performing the interest calculation operation according to the safety operating parameters includes:

[0013] Adjust the initial queue depth parameter of the interest calculation batch operation to the preset queue depth parameter;

[0014] Adjust the initial data transfer parameters of the log file copying job to the preset data transfer parameters;

[0015] The interest calculation batch job is executed according to the preset queue depth parameter, and the log file copy job is executed according to the preset data transmission parameter.

[0016] In one embodiment, the initial data transmission parameters include a first initial data transmission parameter and a second initial data transmission parameter, and the preset data transmission parameters include a first preset data transmission parameter and a second preset data transmission parameter; adjusting the initial data transmission parameters of the log file copying job to the preset data transmission parameters includes:

[0017] Configure the address space corresponding to the data transmission parameters; the address space includes a first address space and a second address space;

[0018] The first initial data transmission parameter stored in the first address space is adjusted to the first preset data transmission parameter, the second initial data transmission parameter stored in the second address space is adjusted to the second preset data transmission parameter, and the first address space and the second address space are started.

[0019] In one embodiment, the database's operating status includes the usage of log files and the memory consumption of log files; during the execution of the interest calculation operation, controlling the database's operating status and the CPU operating status of the first server to meet preset operating conditions includes:

[0020] During the execution of the interest calculation batch job and the log file copy job, the usage of the log files in the database is controlled to meet preset usage conditions and the memory usage of the log files meets preset memory usage conditions.

[0021] Detect whether the interest calculation batch operation is completed within a preset time period;

[0022] If so, the CPU operating state of the first server is controlled to meet the preset CPU operating conditions.

[0023] In one embodiment, the database includes a first database and a second database; controlling the usage of log files in the database to meet preset usage conditions and the memory usage of log files to meet preset memory usage conditions includes:

[0024] The usage of log files in the first database and the memory consumption of log files in the second database are monitored.

[0025] Determine whether the usage of log files in the first database meets the preset usage conditions;

[0026] If not, clean up the log files in the first database until the usage of the log files in the first database meets the preset usage conditions;

[0027] Determine whether the memory usage of the log files in the second database meets the preset memory usage conditions;

[0028] If not, clean up the log files in the second database until the memory usage of the log files in the second database meets the preset memory usage condition.

[0029] In one embodiment, after detecting that the interest calculation batch operation is completed within a preset time period, the method further includes:

[0030] Restore the preset queue depth parameter of the interest calculation batch operation to the initial queue depth parameter;

[0031] Restore the preset data transfer parameters of the log file copying job to the initial data transfer parameters.

[0032] In one embodiment, the CPU operating state of the first server satisfies preset CPU operating conditions, including:

[0033] Monitor the CPU operating status of the first server;

[0034] Determine whether the CPU operating status of the first server meets the preset CPU operating conditions;

[0035] If not, adjust the initial queue depth parameter so that the CPU running state of the first server meets the preset CPU running conditions.

[0036] Secondly, this application also provides an interest calculation management device. The device includes:

[0037] The safe operation parameter acquisition module is used to acquire the safe operation parameters of the interest calculation operation; the interest calculation operation includes batch interest calculation operation and log file copying operation;

[0038] The interest calculation execution module is used to execute the interest calculation operation according to the safe operating parameters;

[0039] The interest calculation job control module is used to control the running status of the database and the CPU running status of the first server to meet preset running conditions during the execution of the interest calculation job; the database is used to store the log files corresponding to the log file copying job.

[0040] Thirdly, this application also provides a computer device. The computer device includes a memory and a processor, the memory storing a computer program, and the processor executing the computer program to implement the steps of the method in any of the embodiments of the first aspect described above.

[0041] Fourthly, this application also provides a computer-readable storage medium. The computer-readable storage medium stores a computer program thereon, which, when executed by a processor, implements the steps of the method in any of the embodiments of the first aspect described above.

[0042] Fifthly, this application also provides a computer program product. The computer program product includes a computer program that, when executed by a processor, implements the steps of the method in any of the embodiments of the first aspect described above.

[0043] The aforementioned interest calculation management method, apparatus, computer equipment, storage medium, and program product acquire secure operating parameters for the interest calculation operation; the interest calculation operation includes batch interest calculation operations and log file copying operations; the interest calculation operation is executed according to the secure operating parameters; during the execution of the interest calculation operation, the operating status of the database and the CPU operating status of the first server are controlled to meet preset operating conditions; the database is used to store the log files corresponding to the log file copying operations. This application, by acquiring secure operating parameters for the interest calculation operation and executing the interest calculation operation according to these parameters, ensures the secure generation and transmission of log files during batch interest calculation operations and log file copying operations. Subsequently, controlling the operating status of the database and the CPU operating status of the first server to meet preset operating conditions ensures that the database storing the log files is in a secure operating state and avoids the CPU of the first server from operating at excessively high levels, thus avoiding excessive pressure on the first server during the execution of the interest calculation operation, thereby ensuring the secure operation of the interest calculation operation. Furthermore, the interest calculation management method of this application is an automated interest calculation management method, which eliminates the need for database administrators to manually adjust the relevant parameters of the interest calculation operation and perform subsequent operation and maintenance, thereby reducing the uncertainty caused by manual operation and ensuring that the interest calculation operation can run safely. Attached Figure Description

[0044] Figure 1 This is an application environment diagram of the interest calculation management method in one embodiment;

[0045] Figure 2 This is a flowchart illustrating an interest calculation management method in one embodiment;

[0046] Figure 3 This is a flowchart illustrating the steps involved in the interest calculation process in one embodiment.

[0047] Figure 4 This is a flowchart illustrating the steps for adjusting preset data transmission parameters in one embodiment.

[0048] Figure 5 This is a flowchart illustrating the interest calculation control steps in one embodiment;

[0049] Figure 6 This is a flowchart illustrating the database control steps in one embodiment;

[0050] Figure 7 This is a flowchart illustrating the interest calculation management method in another embodiment;

[0051] Figure 8 This is a flowchart illustrating the CPU running state control steps in one embodiment;

[0052] Figure 9This is a flowchart illustrating the interest calculation management method in a specific embodiment;

[0053] Figure 10 This is a structural block diagram of the interest calculation management device in one embodiment;

[0054] Figure 11 This is an internal structural diagram of a computer device in one embodiment. Detailed Implementation

[0055] To make the objectives, technical solutions, and advantages of this application clearer, the following detailed description is provided in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative and not intended to limit the scope of this application.

[0056] With the continuous development of society and the economy, banks are playing an increasingly important role in people's lives and work. Among the many calculation operations in the banking system, interest calculation is one of the core operations. Specifically, interest calculation refers to the bank's operation of calculating the interest on demand deposits in personal accounts.

[0057] Generally, major banks have a huge number of current accounts, and a large amount of interest calculation information for individual accounts needs to be updated within each preset time period (e.g., each quarter), with certain limitations on the update time for each quarter. For example, during the execution of quarterly interest calculation operations, on the one hand, the CPU load remains high, and on the other hand, the interest calculation operation generates a large number of log files, requiring a significant amount of memory. Therefore, both of these factors put enormous pressure on the host machine executing the interest calculation operation, leading to security risks. Therefore, ensuring the secure and stable operation of interest calculation operations is crucial for interest calculation management.

[0058] Traditional methods typically rely on database administrators to adjust parameters and dynamically monitor interest calculation jobs in real time to ensure their secure operation. However, relying solely on manual real-time management of interest calculation jobs can lead to serious performance or capacity issues on the host executing the job if an oversight occurs, ultimately preventing the job from running securely. Therefore, traditional methods relying on manual real-time management of interest calculation jobs have insufficient security.

[0059] The interest calculation management method provided in this application embodiment can be applied to, for example, Figure 1The application environment is shown. Host 120 includes a first server 122 and a second server 124, and platform 140 includes an Oracle database, a MySQL database, and a Kafka data processing platform. QREP is a database replication technology based on copying log files within the database. DRP (Distribution Resource Planning) is a near real-time synchronization technology for the host platform, used to ensure accurate and real-time transmission of log files between host 120 and platform 140 during log file replication. Host 120 communicates with platform 140 via a network. QREP can synchronously send log files from the first server 122 to the second server 124, and QREP and DRP can synchronously send log files from the first server 122 to platform 140, storing the replicated log files in the Oracle and MySQL databases. The Oracle and MySQL databases can store the data that platform 140 needs to process. Platform 140 can be integrated on platform 140 or placed in the cloud or on other network servers. The first server 122 obtains the security operation parameters for the interest calculation job; the interest calculation job includes a batch interest calculation job and a log file copying job; the interest calculation job is executed according to the security operation parameters; during the execution of the interest calculation job, the operating status of the database and the CPU operating status of the first server 122 are controlled to meet the preset operating conditions; the database is used to store the log files corresponding to the log file copying job. The first server 122 and the second server 124 can be implemented using independent servers or a server cluster consisting of multiple servers.

[0060] In one embodiment, such as Figure 2 As shown, an interest calculation management method is provided, which is applied to... Figure 1 Taking the first server 122 as an example, the explanation includes the following steps:

[0061] Step 220: Obtain the safe operating parameters for the interest calculation job; the interest calculation job includes the batch interest calculation job and the log file copying job.

[0062] Specifically, the first server 122 can obtain secure operating parameters for the interest calculation operation based on past experience in interest calculation management. The interest calculation operation is the process by which the bank calculates the interest on current deposits in individual accounts within a preset time period. The interest calculation operation includes batch interest calculation operations and log file copying operations. The batch interest calculation operation generates a log file containing interest calculation information by calculating the interest on current deposits in individual accounts within the preset time period. The log file copying operation copies the log file containing interest calculation information to the second server 124, as well as the Oracle and MySQL databases, within the preset time period. The secure operating parameters for the interest calculation operation are parameters that ensure the secure operation of the interest calculation operation.

[0063] Step 240: Perform interest calculation according to the safe operating parameters.

[0064] Specifically, after receiving the interest calculation management start command, the first server 122 can directly execute the interest calculation job using the safe operating parameters. Alternatively, the first server 122 can adjust the initial operating parameters to the safe operating parameters, thereby executing the batch interest calculation job and the log file copying job according to the adjusted safe operating parameters. The safe operating parameters for the interest calculation job are parameters that ensure the safe operation of the interest calculation job, including the safe operating parameters for the batch interest calculation job and the safe operating parameters for the log file copying job. The initial operating parameters are the operating parameters pre-stored in the first server 122 before executing the interest calculation job.

[0065] Step 260: During the execution of the interest calculation operation, the operating status of the database and the CPU operating status of the first server are controlled to meet the preset operating conditions; the database is used to store the log files corresponding to the log file copying operation.

[0066] Specifically, during the interest calculation process, the first server 122 can monitor and control the operating status of the database and the CPU of the first server 122, and ensure that the operating status of the database and the CPU of the first server meet preset operating conditions. The database can store the corresponding copied log file in the log file copying job. The preset operating conditions are those that ensure the safe operation of the database and the CPU of the first server.

[0067] In the aforementioned interest calculation management method, secure operating parameters for the interest calculation job are obtained; the interest calculation job includes batch interest calculation jobs and log file copying jobs; the interest calculation job is executed according to the secure operating parameters; during the execution of the interest calculation job, the operating status of the database and the CPU operating status of the first server are controlled to meet preset operating conditions; the database is used to store the log files corresponding to the log file copying job. This application ensures the secure generation and transmission of log files during batch interest calculation jobs and log file copying jobs by obtaining secure operating parameters for the interest calculation job and executing the interest calculation job according to these parameters. Subsequently, controlling the operating status of the database and the CPU operating status of the first server to meet preset operating conditions ensures that the database storing the log files corresponding to the log file copying job is in a secure operating state, and avoids the CPU of the first server from operating at excessively high levels, thus avoiding excessive pressure on the first server during the execution of the interest calculation job, thereby ensuring the secure operation of the interest calculation job. Furthermore, the interest calculation management method of this application is an automated interest calculation management method, which eliminates the need for database administrators to manually adjust the relevant parameters of the interest calculation operation and perform subsequent operation and maintenance, thereby reducing the uncertainty caused by manual operation and ensuring that the interest calculation operation can run safely.

[0068] The above embodiments describe how to obtain the safe operating parameters of the interest calculation operation. The specific method is described below. In one embodiment, obtaining the safe operating parameters of the interest calculation operation includes:

[0069] Obtain the preset queue depth parameters for the interest calculation batch job and the preset data transfer parameters for the log file copy job.

[0070] Specifically, in this embodiment, the safe operation parameters for the interest calculation operation include the preset queue depth parameter for the interest batch calculation operation and the preset data transmission parameters for the log file copying operation. Therefore, the first server 122 can obtain the preset queue depth parameter for the interest batch calculation operation and the preset data transmission parameters for the log file copying operation based on past interest calculation management experience. The preset queue depth parameter for the interest batch calculation operation is a parameter related to the queue depth of the interest batch queue used during the interest batch calculation operation, which ensures the safe operation of the interest batch calculation operation. The preset data transmission parameters for the log file copying operation are parameters related to the transmission of log files used during the log file copying operation, which ensures the safe operation of the log file copying operation.

[0071] In this embodiment, by obtaining the preset queue depth parameter of the interest calculation batch job and the preset data transmission parameter of the log file copy job, the corresponding safe operation parameters of the two processes in the interest calculation job can be obtained more comprehensively. Thus, it can lay the foundation for the subsequent steps of safely executing the interest calculation job according to the safe operation parameters.

[0072] The above embodiments describe the execution of interest calculation operations according to safe operating parameters. The specific methods are described below. In one embodiment, such as... Figure 3 As shown, the interest calculation operation is performed according to the safe operating parameters, including:

[0073] Step 320: Adjust the initial queue depth parameter of the interest calculation batch job to the preset queue depth parameter.

[0074] Specifically, for the interest calculation batch operation, the first server 122 can adjust the initial queue depth parameter pre-stored in the interest calculation batch operation to a preset queue depth parameter. Secondly, the quick check interval of the log file (LOG) is adjusted, setting the log file check interval to be based on the number of log files generated; preferably, a quick check of the log files is performed every 3,000,000 log files generated. Of course, this application does not limit the number of log files generated. Afterwards, the update of the computationally intensive interest calculation batch is paused, and the current account table is adjusted, updating the location of the interest calculation batch data. The preset queue depth parameter is a parameter related to the queue depth of the interest calculation batch queue used during the interest calculation batch operation, ensuring the safe operation of the interest calculation batch operation.

[0075] Step 340: Adjust the initial data transfer parameters of the log file copy job to the preset data transfer parameters.

[0076] Specifically, for the log file copying job, the first server 122 can adjust the initial data transmission parameters pre-stored in the log file copying job to preset data transmission parameters. These preset data transmission parameters are parameters related to the transfer of log files and are used during the log file copying job to ensure the safe operation of the log file copying job.

[0077] Step 360: Execute the interest calculation batch job according to the preset queue depth parameters, and execute the log file copy job according to the preset data transmission parameters.

[0078] Specifically, after receiving the interest calculation management start instruction, the first server 122 can execute the interest calculation batch job according to the preset queue depth parameters and the log file copy job according to the preset data transmission parameters, based on the adjusted preset queue depth parameters of the interest calculation batch job and the preset data transmission parameters of the log file copy job.

[0079] In this embodiment, the initial queue depth parameter of the interest calculation batch job is adjusted to a preset queue depth parameter; the initial data transmission parameter of the log file copy job is adjusted to a preset data transmission parameter; the interest calculation batch job is executed according to the preset queue depth parameter, and the log file copy job is executed according to the preset data transmission parameter. This embodiment obtains adjusted preset queue depth parameters and preset data transmission parameters that ensure safe operation by adjusting the initial queue depth parameters of the interest calculation batch job and the initial data transmission parameter of the log file copy job respectively. Then, the interest calculation batch job is executed according to the preset queue depth parameter, and the log file copy job is executed according to the preset data transmission parameter, thereby ensuring the safety of the interest calculation batch job and the log file copy job.

[0080] The above embodiments describe adjusting the initial data transfer parameters of a log file copy job to preset data transfer parameters. The specific method is described below. In one embodiment, such as... Figure 4 As shown, the initial data transmission parameters include a first initial data transmission parameter and a second initial data transmission parameter, and the preset data transmission parameters include a first preset data transmission parameter and a second preset data transmission parameter;

[0081] This includes adjusting the initial data transfer parameters of the log file copy job to preset data transfer parameters, including:

[0082] Step 420: Configure the address space corresponding to the data transmission parameters; the address space includes a first address space and a second address space.

[0083] Specifically, firstly, the first server 122 can be configured with a first address space corresponding to the data transmission parameters, that is, the first server 122 downloads the CAPTURE address space corresponding to the data transmission parameters, and determines whether the CAPTURE address space has been successfully downloaded by checking the CAPTURE address space in the log file copying job. Specifically, the CAPTURE address space in the log file copying job is checked once at a preset time interval (e.g., every 10 seconds). The process of checking the CAPTURE address space in the log file copying job needs to be completed within a preset time period (e.g., 2 minutes). Of course, this application does not limit the specific time period. If the check of the CAPTURE address space in the log file copying job within the preset time period has been completed, but the first server 122 still shows that the CAPTURE address space has not been downloaded, then the information "no CAPTURE address space downloaded" is sent to the alarm module to trigger an alarm.

[0084] Second, the first server 122 can check whether the messages in the message queue corresponding to the data transmission parameters have been transmitted. If a message has not been transmitted, the server will send the message "message not transmitted" to the alarm module to trigger an alarm.

[0085] Third, the first server 122 can be configured with a second address space corresponding to the data transmission parameters. Specifically, the first server 122 can download the APPLY address space corresponding to the data transmission parameters and determine whether the APPLY address space download was successful by checking the APPLY address space in the log file copying job. This check is performed once every preset time interval (e.g., every 10 seconds) and must be completed within a preset time period (e.g., 2 minutes). However, this application does not specify a specific time period. If the check of the APPLY address space in the log file copying job within the preset time period has been completed, but the first server 122 still indicates that the APPLY address space has not been downloaded, then the message "No APPLY address space downloaded" will be sent to the alarm module to trigger an alarm.

[0086] Step 440: Adjust the first initial data transmission parameter stored in the first address space to the first preset data transmission parameter, adjust the second initial data transmission parameter stored in the second address space to the second preset data transmission parameter, and start the first address space and the second address space.

[0087] Specifically, firstly, the first server 122 adjusts the first initial data transmission parameters stored in the first address space to the first preset data transmission parameters, that is, the first server 122 adjusts the initial batch processing size parameter (BATCHSIZE parameter) stored in the CAPTURE address space to the preset batch processing size parameter. The first server 122 adjusts the second initial data transmission parameters stored in the second address space to the second preset data transmission parameters, that is, the first server 122 adjusts the initial single transmission size parameter (COMMITCOUNT parameter) stored in the APPLY address space to the preset single transmission size parameter, and adjusts the initial single reception quantity parameter (AGETN parameter) stored in the APPLY address space to the preset single reception quantity parameter, and performs column compression on the interest-bearing current account table.

[0088] Second, the first server 122 can activate the second address space corresponding to the data transmission parameters, that is, the first server 122 activates the APPLY address space corresponding to the data transmission parameters, and determines whether the APPLY address space has been successfully activated by checking the APPLY address space in the log file copying job. Specifically, the APPLY address space in the log file copying job is checked once at a preset time interval (e.g., every 10 seconds). This check needs to be completed within a preset time period (e.g., 2 minutes). However, this application does not specify a specific time period. If the check of the APPLY address space in the log file copying job within the preset time period has been completed, but the first server 122 still indicates that the APPLY address space has not been activated, then the "APPLY address space not activated" message is sent to the alarm module to trigger an alarm.

[0089] Third, the first server 122 can start the first address space corresponding to the data transmission parameters, that is, the first server 122 starts the CAPTURE address space corresponding to the data transmission parameters, and determines whether the CAPTURE address space has been successfully started by checking the CAPTURE address space in the log file copying job. Specifically, the CAPTURE address space in the log file copying job is checked once at a preset time interval (e.g., every 10 seconds). The process of checking the CAPTURE address space in the log file copying job needs to be completed within a preset time period (e.g., 2 minutes). Of course, this application does not limit the specific time period. If the check of the CAPTURE address space in the log file copying job within the preset time period has been completed, but the first server 122 still shows that the CAPTURE address space has not been started, then the information "CAPTURE address space not started" is sent to the alarm module to trigger an alarm.

[0090] In this embodiment, firstly, an address space corresponding to the data transmission parameters is configured; the address space includes a first address space and a second address space. Then, the first initial data transmission parameters stored in the first address space are adjusted to first preset data transmission parameters, and the second initial data transmission parameters stored in the second address space are adjusted to second preset data transmission parameters. The first and second address spaces are then started. The first and second preset data transmission parameters are data transmission parameters that ensure the safe operation of the log file copying job. Therefore, adjusting the first initial data transmission parameters stored in the first address space to the first preset data transmission parameters, and adjusting the second initial data transmission parameters stored in the second address space to the second preset data transmission parameters, ensures the safe operation of the log file copying job.

[0091] The above embodiments describe how, during the execution of interest calculation operations, the operating state of the database and the CPU operating state of the first server are controlled to meet preset operating conditions. The specific methods are described below. In one embodiment, such as... Figure 5 As shown, the database's operational status includes the usage of log files and their memory consumption. During the execution of the interest calculation job, the database's operational status and the CPU operation status of the first server are controlled to meet preset operating conditions, including:

[0092] Step 520: During the execution of the batch interest calculation job and the log file copying job, control the usage of log files in the database to meet the preset usage conditions and the memory usage of log files to meet the preset memory usage conditions.

[0093] Specifically, during the execution of batch interest calculation and log file copying operations, the first server 122 monitors the usage of log files in the database and their memory usage. It controls the log file usage to meet preset usage conditions and the log file memory usage to meet preset memory usage conditions. The database's operating status includes both log file usage and memory usage, and the preset usage and memory usage conditions are designed to ensure the database's safe operation.

[0094] Step 540: Check whether the batch interest calculation operation is completed within the preset time period.

[0095] Specifically, after the interest-calculating batch operation runs for a first preset time period (e.g., 30 minutes), the first server 122 checks whether the interest-calculating batch operation has been completed within a second preset time period (e.g., 2 hours). The preset time periods include the first preset time period and the second preset time period. The first preset time period is the time between the start of the interest-calculating batch operation and the start of checking whether the interest-calculating batch operation is complete; the second preset time period is the time between the start of checking whether the interest-calculating batch operation is complete and the completion of the interest-calculating batch operation. Of course, this embodiment does not limit the specific values ​​of the first and second preset time periods. The specific detection process is that the first server 122 checks whether the interest-calculating batch operation is complete at preset time intervals (e.g., every 5 minutes). If the interest-calculating batch operation is not completed within the preset time period, the information "interest-calculating batch operation not completed within the preset time period" is sent to the alarm module to trigger an alarm; if the interest-calculating batch operation is completed within the preset time period, it indicates that the interest-calculating batch operation was successfully completed within the second preset time period.

[0096] Step 560: If yes, then control the CPU running state of the first server to meet the preset CPU running conditions.

[0097] Specifically, if the first server 122 detects whether the interest calculation batch operation has been successfully completed within a preset time period, the first server 122 can monitor the CPU operating status of the first server 122 and control the CPU operating status of the first server 122 to meet the preset CPU operating conditions. The preset CPU operating conditions are those conditions that ensure the safe operation of the CPU of the first server 122.

[0098] In this embodiment, during the execution of the interest calculation batch job and the log file copying job, the usage of log files in the database is controlled to meet preset usage conditions, and the memory usage of log files is controlled to meet preset memory usage conditions. It also checks whether the interest calculation batch job is completed within a preset time period; if so, the CPU running state of the first server is controlled to meet preset CPU running conditions. This embodiment ensures that the database storing the log files corresponding to the log file copying job is in a safe operating state by controlling the usage of log files in the database to meet preset usage conditions and the memory usage of log files to meet preset memory usage conditions. Furthermore, if it is detected that the interest calculation batch job has successfully completed within a preset time period, the CPU running state of the first server is controlled to meet preset CPU running conditions, avoiding excessive CPU usage on the first server, thus avoiding excessive pressure on the first server during the execution of the interest calculation job and ensuring the safe operation of the interest calculation job.

[0099] The above embodiments describe how to control the usage of log files in the database to meet preset usage conditions and how to control the memory usage of log files to meet preset memory usage conditions. The specific methods are described below. In one embodiment, such as... Figure 6 As shown, the database includes a first database and a second database; the usage of log files in the database is controlled to meet preset usage conditions, and the memory usage of log files is controlled to meet preset memory usage conditions, including:

[0100] Step 602: Monitor the usage of log files in the first database and the memory usage of log files in the second database.

[0101] Specifically, the first server 122 can monitor the usage of log files in the first database and the memory consumption of log files in the second database. The databases include the first database (MySQL) and the second database (Oracle). MySQL is an open-source relational database that frequently uses Structured Query Language (SQL) for management. Oracle is currently the most widely used database in the world. As a general-purpose database system, Oracle has complete data management capabilities; as a relational database, Oracle is a fully relational product; and as a distributed database, Oracle has distributed data processing capabilities.

[0102] Step 604: Determine whether the usage of log files in the first database meets the preset usage conditions.

[0103] Step 606: If not, clean up the log files in the first database until the usage of the log files in the first database meets the preset usage conditions.

[0104] Specifically, based on the monitoring results of the first server 122 on the first database (MySQL database), the usage of log files in the first database (MySQL database) is checked to determine whether the usage of log files in the first database (MySQL database) meets the preset usage conditions. If the log file usage does not meet the preset usage conditions, that is, the usage rate of log files in the MySQL database exceeds the preset usage threshold, the information "The usage rate of log files in the MySQL database exceeds the preset usage threshold" is sent to the alarm module to trigger an alarm, and the first server 122 cleans up the log files in the first database (MySQL database) until the usage of log files in the first database (MySQL database) meets the preset usage conditions. The specific steps for cleaning up the log files in the first database (MySQL database) are as follows: First, clean up log files older than 7 days. Then, check whether the log file usage rate exceeds the preset usage threshold. If an alarm still sounds, continue cleaning up log files older than 6 days, and repeat the step of checking whether the log file usage rate exceeds the preset usage threshold again, until the log file usage rate in the first database (MySQL database) is within the range of the preset usage threshold.

[0105] Step 608: Determine whether the memory usage of the log files in the second database meets the preset memory usage conditions.

[0106] Step 610: If not, clean up the log files in the second database until the memory usage of the log files in the second database meets the preset memory usage conditions.

[0107] Specifically, based on the monitoring results of the first server 122 on the second database (Oracle database), the memory usage of the log files in the second database (Oracle database) is checked to determine whether the memory usage of the log files in the second database (Oracle database) meets the preset memory usage conditions. If the memory usage of the log files does not meet the preset memory usage conditions, that is, the memory usage rate of the log files in the Oracle database exceeds the preset threshold, the information "the memory usage rate of the log files in the Oracle database exceeds the preset threshold" is sent to the alarm module to trigger an alarm, and the first server 122 cleans up the log files in the second database (Oracle database) until the usage of the log files in the second database (Oracle database) meets the preset memory usage conditions. The specific steps for cleaning up the log files in the second database (Oracle database) are as follows: First, query the archived log files and clean up the relevant archived log files using RMAN commands. Next, check again whether the memory usage of the log files in the second database (Oracle database) exceeds the preset threshold. If the alarm still occurs, continue to clean up the archived log files until the memory usage of the log files is within the preset threshold range.

[0108] In this embodiment, the usage of log files in the first database and the memory usage of log files in the second database are monitored. It is determined whether the usage of log files in the first database meets preset usage conditions. If not, the log files in the first database are cleaned up until the usage meets the preset conditions. Similarly, it is determined whether the memory usage of log files in the second database meets preset memory usage conditions. If not, the log files in the second database are cleaned up until the memory usage meets the preset conditions. This embodiment ensures that the database storing log files corresponding to log file replication jobs is in a safe operating state by monitoring the usage of log files in the databases and cleaning up the log files in both the first and second databases.

[0109] The above embodiments describe whether the batch interest calculation operation is completed within a preset time period. Below, another embodiment of the interest calculation management method is described. In one embodiment, such as... Figure 7 As shown, an interest calculation management method is provided, which also includes:

[0110] Step 720: Restore the preset queue depth parameter of the interest calculation batch job to the initial queue depth parameter.

[0111] Step 740: Restore the preset data transfer parameters of the log file copy job to the initial data transfer parameters.

[0112] Specifically, after detecting that the interest calculation batch job has been completed within the preset time period, the following steps are taken: First, pause the update of the computationally intensive interest calculation batch job before execution. Second, restore the previously adjusted quick check interval for the log file (LOG) to once every 5 minutes. Third, restore the preset queue depth parameter of the interest calculation batch job to the initial queue depth parameter.

[0113] Fourth, the first server 122 can be configured with a first address space corresponding to the data transmission parameters. That is, the first server 122 can download the CAPTURE address space corresponding to the data transmission parameters and determine whether the CAPTURE address space download was successful by checking the CAPTURE address space in the log file copying job. Specifically, the CAPTURE address space in the log file copying job is checked once at a preset time interval (e.g., every 10 seconds). This check must be completed within a preset time period (e.g., 2 minutes). However, this application does not specify a specific time period. If the check of the CAPTURE address space in the log file copying job within the preset time period has been completed, but the first server 122 still shows that the CAPTURE address space has not been downloaded, then the message "no CAPTURE address space downloaded" is sent to the alarm module to trigger an alarm.

[0114] Fifth, the first server 122 can check whether the messages in the message queue corresponding to the data transmission parameters have been transmitted. If a message has not been transmitted, the server will send the message "Message transmission not completed" to the alarm module to trigger an alarm.

[0115] Sixth, the first server 122 can be configured with a second address space corresponding to the data transmission parameters. Specifically, the first server 122 can download the APPLY address space corresponding to the data transmission parameters and determine whether the APPLY address space has been successfully downloaded by checking the APPLY address space in the log file copying job. This check is performed once every preset time interval (e.g., every 10 seconds) and must be completed within a preset time period (e.g., 2 minutes). However, this application does not specify a specific time period. If the check of the APPLY address space in the log file copying job within the preset time period has been completed, but the first server 122 still indicates that the APPLY address space has not been downloaded, then the message "No APPLY address space downloaded" will be sent to the alarm module to trigger an alarm.

[0116] Seventh, restore the preset data transmission parameters of the log file copying job to the initial data transmission parameters. That is, the first server 122 adjusts the preset batch processing size parameter (BATCHSIZE parameter) stored in the CAPTURE address space to the initial batch processing size parameter, and the first server 122 adjusts the preset single transmission size parameter (COMMITCOUNT parameter) stored in the APPLY address space to the initial single transmission size parameter, and adjusts the preset single reception quantity parameter (AGETN parameter) stored in the APPLY address space to the initial single reception quantity parameter, and compresses the stop column of the interest-bearing current account table.

[0117] Eighth, the first server 122 can start the second address space corresponding to the data transmission parameters, that is, the first server 122 starts the APPLY address space corresponding to the data transmission parameters, and determines whether the APPLY address space has been successfully started by checking the APPLY address space in the log file copying job. Specifically, the APPLY address space in the log file copying job is checked once at a preset time interval (e.g., every 10 seconds). The process of checking the APPLY address space in the log file copying job needs to be completed within a preset time period (e.g., 2 minutes). Of course, this application does not limit the specific time period. If the check of the APPLY address space in the log file copying job within the preset time period has been completed, but the first server 122 still shows that the APPLY address space has not been started, then the information "APPLY address space not started" is sent to the alarm module to trigger an alarm.

[0118] Ninth, the first server 122 can start the first address space corresponding to the data transmission parameters, that is, the first server 122 starts the CAPTURE address space corresponding to the data transmission parameters, and determines whether the CAPTURE address space has been successfully started by checking the CAPTURE address space in the log file copying job. Specifically, the CAPTURE address space in the log file copying job is checked once at a preset time interval (e.g., every 10 seconds). The process of checking the CAPTURE address space in the log file copying job needs to be completed within a preset time period (e.g., 2 minutes). Of course, this application does not limit the specific time period. If the check of the CAPTURE address space in the log file copying job within the preset time period has been completed, but the first server 122 still shows that the CAPTURE address space has not been started, then the information "CAPTURE address space not started" is sent to the alarm module to trigger an alarm.

[0119] In this embodiment, restoring the preset queue depth parameter of the interest calculation batch job to the initial queue depth parameter and restoring the preset data transmission parameter of the log file copy job to the initial data transmission parameter ensures that after the interest calculation batch job is completed within a preset time period, the preset queue depth parameter and the preset data transmission parameter are restored to the initial queue depth parameter and the initial data transmission parameter, thereby ensuring that the running parameters remain unchanged when performing other jobs.

[0120] The above embodiments describe controlling the CPU operating state of the first server to meet preset CPU operating conditions. The specific method is described below. In one embodiment, such as... Figure 8 As shown, controlling the CPU operating state of the first server to meet preset CPU operating conditions includes:

[0121] Step 820: Monitor the CPU operating status of the first server.

[0122] Step 840: Determine whether the CPU operating status of the first server meets the preset CPU operating conditions.

[0123] Step 860: If not, adjust the initial queue depth parameter so that the CPU running state of the first server meets the preset CPU running conditions.

[0124] Specifically, the first server 122 can monitor the CPU's operating status. The CPU, or Central Processing Unit, is one of the main components of a computer, primarily responsible for interpreting computer instructions and processing data in computer software. The CPU's state can generally be divided into running state and idle state. Running state refers to the CPU currently processing a process or program.

[0125] In actual interest calculation, when the batch interest calculation is completed, the log file copying operation is not completed. That is, the first server 122 will continue to transmit log files to the platform 140 and the second server 124. Therefore, based on the monitoring results of the first server 122 on the CPU running status of the first server, it can be determined whether the CPU running status of the first server meets the preset CPU running conditions, that is, whether the CPU percentage exceeds the preset CPU percentage threshold.

[0126] If the CPU percentage exceeds the preset CPU percentage threshold, the initial queue depth parameter is adjusted to ensure that the CPU operation of the first server meets the preset CPU operating conditions. The specific steps for adjusting the CPU percentage are as follows: Adjust the initial queue depth parameter by decreasing the currently set data queue depth of the log file by 1, and then rest for 3 minutes. If the CPU percentage still exceeds the set threshold after the 3-minute rest, continue adjusting the queue depth parameter by decreasing the currently set data queue depth of the log file by 1 again, and then rest for another 3 minutes. Repeat this process until the CPU percentage does not exceed the preset CPU percentage threshold.

[0127] Afterwards, the first server 122 can check the message queue of the CAPTURE address space. If the page set of the message queue exceeds the preset threshold, the CAPTURE address space is reconfigured, and the configured CAPTURE address space is started after the preset time period of the log file copy job.

[0128] In this embodiment, the CPU operating status of the first server is monitored; it is determined whether the CPU operating status of the first server meets the preset CPU operating conditions; if not, the initial queue depth parameter is adjusted to make the CPU operating status of the first server meet the preset CPU operating conditions. This embodiment, by monitoring the CPU operating status of the first server and controlling the initial queue depth parameter to ensure the CPU operating status meets the preset CPU operating conditions, avoids the CPU of the first server being in an excessively high operating state, thus avoiding excessive pressure on the first server during the execution of interest calculation operations, thereby ensuring the safe operation of the interest calculation operations.

[0129] In a specific embodiment, such as Figure 9 As shown, an interest calculation management method is provided, applied to a first server 122, including:

[0130] Step 902: Obtain the preset queue depth parameters for the interest calculation batch job and the preset data transmission parameters for the log file copy job; the interest calculation job includes the interest calculation batch job and the log file copy job.

[0131] Step 904: Adjust the initial queue depth parameter of the interest calculation batch job to the preset queue depth parameter;

[0132] Step 906: Configure the address space corresponding to the data transmission parameters; the address space includes a first address space and a second address space;

[0133] Step 908: Adjust the first initial data transmission parameter stored in the first address space to the first preset data transmission parameter, adjust the second initial data transmission parameter stored in the second address space to the second preset data transmission parameter, and start the first address space and the second address space;

[0134] Step 910: Execute the interest calculation batch job according to the preset queue depth parameters, and execute the log file copy job according to the preset data transmission parameters;

[0135] Step 912: During the execution of the batch interest calculation job and the log file copying job, the usage of log files in the first database and the memory usage of log files in the second database are monitored; the database is used to store the log files corresponding to the log file copying job; the database includes the first database and the second database;

[0136] Step 914: Determine whether the usage of log files in the first database meets the preset usage conditions;

[0137] Step 916: If not, clean up the log files in the first database until the usage of the log files in the first database meets the preset usage conditions.

[0138] Step 918: Determine whether the memory usage of the log files in the second database meets the preset memory usage conditions;

[0139] Step 920: If not, clean up the log files in the second database until the memory usage of the log files in the second database meets the preset memory usage conditions.

[0140] Step 922: Check whether the batch interest calculation operation is completed within the preset time period;

[0141] Step 924: If yes, restore the preset queue depth parameter of the interest calculation batch job to the initial queue depth parameter;

[0142] Step 926: Restore the preset data transfer parameters of the log file copy job to the initial data transfer parameters;

[0143] Step 928: Monitor the CPU operating status of the first server;

[0144] Step 930: Determine whether the CPU operating status of the first server meets the preset CPU operating conditions;

[0145] Step 932: If not, adjust the initial queue depth parameter so that the CPU running state of the first server meets the preset CPU running conditions.

[0146] In this embodiment, secure operating parameters for the interest calculation operation are obtained. The interest calculation operation includes a batch interest calculation operation and a log file copying operation. The interest calculation operation is executed according to the secure operating parameters. During the execution of the interest calculation operation, the operating status of the database and the CPU operating status of the first server are controlled to meet preset operating conditions. The database is used to store the log files corresponding to the log file copying operation. By obtaining the secure operating parameters for the interest calculation operation and executing the interest calculation operation according to the obtained secure operating parameters, this application ensures that log files can be securely generated and transmitted during the batch interest calculation operation and the log file copying operation. Subsequently, by controlling the operating status of the database and the CPU operating status of the first server to meet preset operating conditions, the database storing the log files corresponding to the log file copying operation is kept in a secure operating state, and the CPU of the first server is prevented from operating at excessively high levels, thus avoiding excessive pressure on the first server during the execution of the interest calculation operation, thereby ensuring the secure operation of the interest calculation operation. In addition, the interest calculation management method of this application is an automated interest calculation management method, which eliminates the need for database administrators to manually adjust the relevant parameters of the interest calculation operation and perform subsequent maintenance operations, reducing the uncertainty caused by manual operation, thereby ensuring the secure operation of the interest calculation operation.

[0147] It should be understood that although the steps in the flowcharts of the above embodiments are shown sequentially according to the arrows, these steps are not necessarily executed in the order indicated by the arrows. Unless explicitly stated herein, there is no strict order restriction on the execution of these steps, and they can be executed in other orders. Moreover, at least some steps in the flowcharts of the above embodiments may include multiple steps or multiple stages. These steps or stages are not necessarily completed at the same time, but can be executed at different times. The execution order of these steps or stages is not necessarily sequential, but can be performed alternately or in turn with other steps or at least some of the steps or stages of other steps.

[0148] Based on the same inventive concept, this application also provides an interest management device for implementing the interest management method described above. The solution provided by this device is similar to the solution described in the above method; therefore, the specific limitations in one or more interest management device embodiments provided below can be found in the limitations of the interest management method described above, and will not be repeated here.

[0149] In one embodiment, such as Figure 10 As shown, an interest calculation management device 1000 is provided, including: a safety operation parameter acquisition module 1020, an interest calculation operation execution module 1040, and an interest calculation operation control module 1060, wherein:

[0150] The safe operation parameter acquisition module 1020 is used to acquire the safe operation parameters of the interest calculation operation; the interest calculation operation includes the batch interest calculation operation and the log file copying operation.

[0151] The interest calculation execution module 1040 is used to execute interest calculation operations according to safe operating parameters.

[0152] The interest calculation operation control module 1060 is used to control the running status of the database and the CPU running status of the first server to meet the preset running conditions during the execution of the interest calculation operation; the database is used to store the log files corresponding to the log file copying operation.

[0153] In one embodiment, the safe operation parameter acquisition module 1020 includes:

[0154] The safe operation parameter acquisition unit is used to acquire the preset queue depth parameters of the interest calculation batch job and the preset data transmission parameters of the log file copy job.

[0155] In one embodiment, the interest calculation execution module 1040 includes:

[0156] The preset queue depth parameter adjustment unit is used to adjust the initial queue depth parameter of the interest calculation batch operation to the preset queue depth parameter;

[0157] The preset data transmission parameter adjustment unit is used to adjust the initial data transmission parameters of the log file copying job to the preset data transmission parameters;

[0158] The job execution unit is used to execute interest-bearing batch jobs according to preset queue depth parameters and to execute log file copy jobs according to preset data transmission parameters.

[0159] In one embodiment, the initial data transmission parameters include a first initial data transmission parameter and a second initial data transmission parameter, and the preset data transmission parameters include a first preset data transmission parameter and a second preset data transmission parameter; the preset data transmission parameter adjustment unit includes:

[0160] The address space configuration subunit is used to configure the address space corresponding to the data transmission parameters; the address space includes a first address space and a second address space.

[0161] The data transmission parameter adjustment subunit is used to adjust the first initial data transmission parameter stored in the first address space to the first preset data transmission parameter, adjust the second initial data transmission parameter stored in the second address space to the second preset data transmission parameter, and start the first address space and the second address space.

[0162] In one embodiment, the database's operating status includes the usage of log files and the memory consumption of log files; the interest calculation job control module 1060 includes:

[0163] The database control unit is used to control the usage of log files in the database to meet preset usage conditions and the memory usage of log files to meet preset memory usage conditions during the execution of batch interest calculation jobs and log file copying jobs.

[0164] The interest calculation batch operation monitoring unit is used to detect whether the interest calculation batch operation is completed within a preset time period;

[0165] The CPU operating status control unit is used to control the CPU operating status of the first server to meet the preset CPU operating conditions if the conditions are met.

[0166] In one embodiment, the database includes a first database and a second database; the database control unit includes:

[0167] The database monitoring subunit is used to monitor the usage of log files in the first database and the memory usage of log files in the second database.

[0168] The preset usage condition judgment subunit is used to determine whether the usage of log files in the first database meets the preset usage conditions;

[0169] The first cleaning subunit is used to clean up the log files in the first database if no, until the usage of the log files in the first database meets the preset usage conditions.

[0170] The preset memory usage condition judgment subunit is used to determine whether the memory usage of the log files in the second database meets the preset memory usage condition.

[0171] The second cleanup subunit is used to clean up the log files in the second database if no, until the memory usage of the log files in the second database meets the preset memory usage conditions.

[0172] In one embodiment, after detecting that the interest calculation batch operation has been completed within a preset time period, the interest calculation management device 1000 further includes:

[0173] The preset queue depth parameter recovery unit is used to restore the preset queue depth parameter of the interest calculation batch operation to the initial queue depth parameter;

[0174] The preset data transfer parameter recovery unit is used to restore the preset data transfer parameters of the log file copy job to the initial data transfer parameters.

[0175] In one embodiment, the CPU operating state control unit includes:

[0176] The CPU monitoring subunit is used to monitor the CPU operating status of the first server.

[0177] A preset CPU operating condition judgment unit is used to determine whether the CPU operating status of the first server meets the preset CPU operating conditions.

[0178] The initial queue depth parameter adjustment unit is used to adjust the initial queue depth parameter if not to ensure that the CPU running state of the first server meets the preset CPU running conditions.

[0179] Each module in the aforementioned interest calculation management device can be implemented entirely or partially through software, hardware, or a combination thereof. These modules can be embedded in the processor of a computer device in hardware form or independent of it, or stored in the memory of a computer device in software form, so that the processor can call and execute the operations corresponding to each module.

[0180] In one embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be as follows: Figure 11 As shown, the computer device includes a processor, memory, and a network interface connected via a system bus. The processor provides computing and control capabilities. The memory includes non-volatile storage media and internal memory. The non-volatile storage media stores the operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The database stores interest management data. The network interface communicates with external terminals via a network connection. When the computer program is executed by the processor, it implements an interest management method.

[0181] Those skilled in the art will understand that Figure 11 The structure shown is merely a block diagram of a portion of the structure related to the present application and does not constitute a limitation on the computer device to which the present application is applied. Specific computer devices may include more or fewer components than those shown in the figure, or combine certain components, or have different component arrangements.

[0182] In one embodiment, a computer device is provided, including a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to perform the following steps:

[0183] Obtain the safe operating parameters for the interest calculation operation; the interest calculation operation includes batch interest calculation operations and log file copying operations;

[0184] Calculate interest according to safe operating parameters;

[0185] During the execution of the interest calculation operation, the operating status of the control database and the CPU operating status of the first server are kept in accordance with the preset operating conditions; the database is used to store the log files corresponding to the log file copying operation.

[0186] In one embodiment, when the processor executes the computer program to obtain the safe operating parameters for the interest calculation operation, it also performs the following steps:

[0187] Obtain the preset queue depth parameters for the interest calculation batch job and the preset data transfer parameters for the log file copy job.

[0188] In one embodiment, when the interest calculation operation is performed according to safe operating parameters, the processor also performs the following steps when executing the computer program:

[0189] Adjust the initial queue depth parameter of the interest calculation batch job to the preset queue depth parameter;

[0190] Adjust the initial data transfer parameters of the log file copy job to the preset data transfer parameters;

[0191] Execute batch interest calculation jobs according to preset queue depth parameters, and execute log file copy jobs according to preset data transmission parameters.

[0192] In one embodiment, the initial data transfer parameters include a first initial data transfer parameter and a second initial data transfer parameter, and the preset data transfer parameters include a first preset data transfer parameter and a second preset data transfer parameter; when the initial data transfer parameters of the log file copying job are adjusted to the preset data transfer parameters, the processor also performs the following steps when executing the computer program:

[0193] Configure the address space corresponding to the data transmission parameters; the address space includes a first address space and a second address space;

[0194] The first initial data transmission parameter stored in the first address space is adjusted to the first preset data transmission parameter, the second initial data transmission parameter stored in the second address space is adjusted to the second preset data transmission parameter, and the first address space and the second address space are started.

[0195] In one embodiment, the database's operating status includes the usage of log files and their memory consumption. During the execution of the interest calculation operation, the database's operating status and the CPU operating status of the first server are controlled to meet preset operating conditions. When the processor executes the computer program, the following steps are also implemented:

[0196] During the execution of batch interest calculation and log file copying operations, the usage of log files in the database is controlled to meet preset usage conditions, and the memory usage of log files is controlled to meet preset memory usage conditions.

[0197] Check whether the batch interest calculation operation is completed within the preset time period;

[0198] If so, the CPU operating state of the first server is controlled to meet the preset CPU operating conditions.

[0199] In one embodiment, the database includes a first database and a second database; to control the usage of log files in the database to meet preset usage conditions and the memory usage of log files to meet preset memory usage conditions, the processor, when executing the computer program, also implements the following steps:

[0200] Monitor the usage of log files in the first database and the memory consumption of log files in the second database;

[0201] Determine whether the usage of log files in the first database meets the preset usage conditions;

[0202] If not, clean up the log files in the first database until the usage of the log files in the first database meets the preset usage conditions;

[0203] Determine whether the memory usage of the log files in the second database meets the preset memory usage conditions;

[0204] If not, clean up the log files in the second database until the memory usage of the log files in the second database meets the preset memory usage conditions.

[0205] In one embodiment, after detecting that the interest calculation batch job has been completed within a preset time period, the processor further performs the following steps when executing the computer program:

[0206] Restore the preset queue depth parameter of the interest calculation batch job to the initial queue depth parameter;

[0207] Restore the preset data transfer parameters of the log file copy job to the initial data transfer parameters.

[0208] In one embodiment, the CPU operating state of the first server is controlled to meet preset CPU operating conditions, and the processor also performs the following steps when executing the computer program:

[0209] Monitor the CPU operating status of the first server;

[0210] Determine whether the CPU operating status of the first server meets the preset CPU operating conditions;

[0211] If not, adjust the initial queue depth parameter to ensure that the CPU running state of the first server meets the preset CPU running conditions.

[0212] In one embodiment, a computer-readable storage medium is provided having a computer program stored thereon, the computer program performing the following steps when executed by a processor:

[0213] Obtain the safe operating parameters for the interest calculation operation; the interest calculation operation includes batch interest calculation operations and log file copying operations;

[0214] Calculate interest according to safe operating parameters;

[0215] During the execution of the interest calculation operation, the operating status of the control database and the CPU operating status of the first server are kept in accordance with the preset operating conditions; the database is used to store the log files corresponding to the log file copying operation.

[0216] In one embodiment, when the computer program is executed by the processor, it also performs the following steps to obtain the safe operating parameters for the interest calculation operation:

[0217] Obtain the preset queue depth parameters for the interest calculation batch job and the preset data transfer parameters for the log file copy job.

[0218] In one embodiment, when the interest calculation operation is performed according to safe operating parameters, the computer program, when executed by the processor, also performs the following steps:

[0219] Adjust the initial queue depth parameter of the interest calculation batch job to the preset queue depth parameter;

[0220] Adjust the initial data transfer parameters of the log file copy job to the preset data transfer parameters;

[0221] Execute batch interest calculation jobs according to preset queue depth parameters, and execute log file copy jobs according to preset data transmission parameters.

[0222] In one embodiment, the initial data transfer parameters include a first initial data transfer parameter and a second initial data transfer parameter, and the preset data transfer parameters include a first preset data transfer parameter and a second preset data transfer parameter; when the initial data transfer parameters of the log file copying job are adjusted to the preset data transfer parameters, the computer program, when executed by the processor, further implements the following steps:

[0223] Configure the address space corresponding to the data transmission parameters; the address space includes a first address space and a second address space;

[0224] The first initial data transmission parameter stored in the first address space is adjusted to the first preset data transmission parameter, the second initial data transmission parameter stored in the second address space is adjusted to the second preset data transmission parameter, and the first address space and the second address space are started.

[0225] In one embodiment, the database's operating status includes the usage of log files and their memory consumption. During the execution of the interest calculation operation, the database's operating status and the CPU operating status of the first server are controlled to meet preset operating conditions. When the computer program is executed by the processor, the following steps are also implemented:

[0226] During the execution of batch interest calculation and log file copying operations, the usage of log files in the database is controlled to meet preset usage conditions, and the memory usage of log files is controlled to meet preset memory usage conditions.

[0227] Check whether the batch interest calculation operation is completed within the preset time period;

[0228] If so, the CPU operating state of the first server is controlled to meet the preset CPU operating conditions.

[0229] In one embodiment, the database includes a first database and a second database; to control the usage of log files in the database to meet preset usage conditions and the memory usage of log files to meet preset memory usage conditions, the computer program, when executed by the processor, further implements the following steps:

[0230] Monitor the usage of log files in the first database and the memory consumption of log files in the second database;

[0231] Determine whether the usage of log files in the first database meets the preset usage conditions;

[0232] If not, clean up the log files in the first database until the usage of the log files in the first database meets the preset usage conditions;

[0233] Determine whether the memory usage of the log files in the second database meets the preset memory usage conditions;

[0234] If not, clean up the log files in the second database until the memory usage of the log files in the second database meets the preset memory usage conditions.

[0235] In one embodiment, after the computer program is executed by the processor after detecting that the interest calculation batch job has been completed within a preset time period, the following steps are also performed:

[0236] Restore the preset queue depth parameter of the interest calculation batch job to the initial queue depth parameter;

[0237] Restore the preset data transfer parameters of the log file copy job to the initial data transfer parameters.

[0238] In one embodiment, the CPU operating state of the first server is controlled to meet preset CPU operating conditions, and the computer program, when executed by the processor, further implements the following steps:

[0239] Monitor the CPU operating status of the first server;

[0240] Determine whether the CPU operating status of the first server meets the preset CPU operating conditions;

[0241] If not, adjust the initial queue depth parameter to ensure that the CPU running state of the first server meets the preset CPU running conditions.

[0242] In one embodiment, a computer program product is provided, including a computer program that, when executed by a processor, performs the following steps:

[0243] Obtain the safe operating parameters for the interest calculation operation; the interest calculation operation includes batch interest calculation operations and log file copying operations;

[0244] Calculate interest according to safe operating parameters;

[0245] During the execution of the interest calculation operation, the operating status of the control database and the CPU operating status of the first server are kept in accordance with the preset operating conditions; the database is used to store the log files corresponding to the log file copying operation.

[0246] In one embodiment, when the computer program is executed by the processor, it also performs the following steps to obtain the safe operating parameters for the interest calculation operation:

[0247] Obtain the preset queue depth parameters for the interest calculation batch job and the preset data transfer parameters for the log file copy job.

[0248] In one embodiment, when the interest calculation operation is performed according to safe operating parameters, the computer program, when executed by the processor, also performs the following steps:

[0249] Adjust the initial queue depth parameter of the interest calculation batch job to the preset queue depth parameter;

[0250] Adjust the initial data transfer parameters of the log file copy job to the preset data transfer parameters;

[0251] Execute batch interest calculation jobs according to preset queue depth parameters, and execute log file copy jobs according to preset data transmission parameters.

[0252] In one embodiment, the initial data transfer parameters include a first initial data transfer parameter and a second initial data transfer parameter, and the preset data transfer parameters include a first preset data transfer parameter and a second preset data transfer parameter; when the initial data transfer parameters of the log file copying job are adjusted to the preset data transfer parameters, the computer program, when executed by the processor, further implements the following steps:

[0253] Configure the address space corresponding to the data transmission parameters; the address space includes a first address space and a second address space;

[0254] The first initial data transmission parameter stored in the first address space is adjusted to the first preset data transmission parameter, the second initial data transmission parameter stored in the second address space is adjusted to the second preset data transmission parameter, and the first address space and the second address space are started.

[0255] In one embodiment, the database's operating status includes the usage of log files and their memory consumption. During the execution of the interest calculation operation, the database's operating status and the CPU operating status of the first server are controlled to meet preset operating conditions. When the computer program is executed by the processor, the following steps are also implemented:

[0256] During the execution of batch interest calculation and log file copying operations, the usage of log files in the database is controlled to meet preset usage conditions, and the memory usage of log files is controlled to meet preset memory usage conditions.

[0257] Check whether the batch interest calculation operation is completed within the preset time period;

[0258] If so, the CPU operating state of the first server is controlled to meet the preset CPU operating conditions.

[0259] In one embodiment, the database includes a first database and a second database; to control the usage of log files in the database to meet preset usage conditions and the memory usage of log files to meet preset memory usage conditions, the computer program, when executed by the processor, further implements the following steps:

[0260] Monitor the usage of log files in the first database and the memory consumption of log files in the second database;

[0261] Determine whether the usage of log files in the first database meets the preset usage conditions;

[0262] If not, clean up the log files in the first database until the usage of the log files in the first database meets the preset usage conditions;

[0263] Determine whether the memory usage of the log files in the second database meets the preset memory usage conditions;

[0264] If not, clean up the log files in the second database until the memory usage of the log files in the second database meets the preset memory usage conditions.

[0265] In one embodiment, after the computer program is executed by the processor after detecting that the interest calculation batch job has been completed within a preset time period, the following steps are also performed:

[0266] Restore the preset queue depth parameter of the interest calculation batch job to the initial queue depth parameter;

[0267] Restore the preset data transfer parameters of the log file copy job to the initial data transfer parameters.

[0268] In one embodiment, the CPU operating state of the first server is controlled to meet preset CPU operating conditions, and the computer program, when executed by the processor, further implements the following steps:

[0269] Monitor the CPU operating status of the first server;

[0270] Determine whether the CPU operating status of the first server meets the preset CPU operating conditions;

[0271] If not, adjust the initial queue depth parameter to ensure that the CPU running state of the first server meets the preset CPU running conditions.

[0272] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, data stored, data displayed, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties.

[0273] Those skilled in the art will understand that all or part of the processes in the methods of the above embodiments can be implemented by a computer program instructing related hardware. The computer program can be stored in a non-volatile computer-readable storage medium. When executed, the computer program can include the processes of the embodiments of the above methods. Any references to memory, databases, or other media used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetic random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM). The databases involved in the embodiments provided in this application may include at least one type of relational database and non-relational database. Non-relational databases may include, but are not limited to, blockchain-based distributed databases. The processors involved in the embodiments provided in this application may be general-purpose processors, central processing units, graphics processing units, digital signal processors, programmable logic devices, quantum computing-based data processing logic devices, etc., and are not limited to these.

[0274] The technical features of the above embodiments can be combined in any way. For the sake of brevity, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0275] The above embodiments are merely illustrative of several implementation methods of this application, and their descriptions are relatively specific and detailed. However, they should not be construed as limiting the scope of this application. It should be noted that those skilled in the art can make various modifications and improvements without departing from the concept of this application, and these all fall within the protection scope of this application. Therefore, the protection scope of this application should be determined by the appended claims.

Claims

1. An interest calculation and management method, characterized in that, Applied to a first server, the method includes: Obtain the safe operation parameters for the interest calculation job; the interest calculation job includes a batch interest calculation job and a log file copying job, and the safe operation parameters include the preset queue depth parameter of the batch interest calculation job and the preset data transmission parameter of the log file copying job; The interest calculation operation shall be performed in accordance with the aforementioned safe operating parameters; During the execution of the interest calculation operation, the operating status of the control database and the CPU operating status of the first server are controlled to meet preset operating conditions; the database is used to store the log files corresponding to the log file copying operation. The database's operating status includes the usage of log files and the memory usage of log files; during the execution of the interest calculation operation, controlling the database's operating status and the CPU operating status of the first server to meet preset operating conditions includes: during the execution of the interest calculation batch operation and the log file copying operation, controlling the usage of log files in the database to meet preset usage conditions and the memory usage of log files to meet preset memory usage conditions. Detect whether the interest calculation batch operation is completed within a preset time period; If so, the CPU operating state of the first server is controlled to meet the preset CPU operating conditions.

2. The method according to claim 1, characterized in that, The step of performing the interest calculation operation according to the safe operating parameters includes: Adjust the initial queue depth parameter of the interest calculation batch operation to the preset queue depth parameter; Adjust the initial data transfer parameters of the log file copying job to the preset data transfer parameters; The interest calculation batch job is executed according to the preset queue depth parameter, and the log file copy job is executed according to the preset data transmission parameter.

3. The method according to claim 2, characterized in that, The initial data transmission parameters include a first initial data transmission parameter and a second initial data transmission parameter, and the preset data transmission parameters include a first preset data transmission parameter and a second preset data transmission parameter; Adjusting the initial data transfer parameters of the log file copying job to the preset data transfer parameters includes: Configure the address space corresponding to the data transmission parameters; the address space includes a first address space and a second address space; The first initial data transmission parameter stored in the first address space is adjusted to the first preset data transmission parameter, the second initial data transmission parameter stored in the second address space is adjusted to the second preset data transmission parameter, and the first address space and the second address space are started.

4. The method according to claim 1, characterized in that, The database includes a first database and a second database; controlling the usage of log files in the database to meet preset usage conditions and the memory usage of log files to meet preset memory usage conditions includes: The usage of log files in the first database and the memory consumption of log files in the second database are monitored. Determine whether the usage of log files in the first database meets the preset usage conditions; If not, clean up the log files in the first database until the usage of the log files in the first database meets the preset usage conditions; Determine whether the memory usage of the log files in the second database meets the preset memory usage conditions; If not, clean up the log files in the second database until the memory usage of the log files in the second database meets the preset memory usage condition.

5. The method according to claim 2, characterized in that, After detecting that the interest calculation batch operation is completed within a preset time period, the method further includes: Restore the preset queue depth parameter of the interest calculation batch operation to the initial queue depth parameter; Restore the preset data transfer parameters of the log file copying job to the initial data transfer parameters.

6. The method according to claim 5, characterized in that, The control of the CPU operating state of the first server to meet preset CPU operating conditions includes: Monitor the CPU operating status of the first server; Determine whether the CPU operating status of the first server meets the preset CPU operating conditions; If not, adjust the initial queue depth parameter so that the CPU running state of the first server meets the preset CPU running conditions.

7. An interest calculation and management device, characterized in that, Applied to a first server, the device includes: The safe operation parameter acquisition module is used to acquire the safe operation parameters of the interest calculation operation; the interest calculation operation includes the interest batch operation and the log file copy operation, and the safe operation parameters include the preset queue depth parameter of the interest batch operation and the preset data transmission parameter of the log file copy operation; The interest calculation execution module is used to execute the interest calculation operation according to the safety operation parameters. The interest calculation operation control module is used to control the operating status of the database and the CPU operating status of the first server to meet preset operating conditions during the execution of the interest calculation operation; the database is used to store the log files corresponding to the log file copying operation. The database's operating status includes the usage of log files and the memory usage of log files; the interest calculation job control module is specifically used to: control the usage of log files in the database to meet preset usage conditions and the memory usage of log files to meet preset memory usage conditions during the execution of the interest calculation batch job and the log file copy job. Detect whether the interest calculation batch operation is completed within a preset time period; If so, the CPU operating state of the first server is controlled to meet the preset CPU operating conditions.

8. A computer device comprising a memory and a processor, wherein the memory stores a computer program, characterized in that, When the processor executes the computer program, it implements the steps of the method according to any one of claims 1 to 6.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 6.

10. A computer program product, comprising a computer program, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 6.

Images