Independent processing method and system for upstream single system data of bank general ledger system

Abstract

The invention discloses an upstream single system data independent processing method and system of a bank general ledger system, and the method comprises the steps: hierarchically configuring parameters of a business system, and configuring business data file receiving and transmitting requirements of the business system; in response to a ready notification of an upstream system, querying configuration information and a file ready state of the service system, and triggering an independent processing flow of a single system when the service system does not complete processing and the file is ready; receiving a business data file of the single system, preprocessing the business data file, checking the business data file, and analyzing and storing the business data file; and updating the processing state of the single system, and recording a whole-process processing track. According to the technical scheme of the invention, the related flow of the single-system data is independently integrated, the flexibility and independence of parameter configuration of each system are improved, the timeliness of problem processing is improved, and the number of daily end file processing is also reduced.

Description

Technical Field

[0001] The present invention relates to the technical field of banking business, and in particular to an upstream single-system data independent processing method of a bank general ledger system and an upstream single-system data independent processing system of a bank general ledger system. Background Art

[0002] When banks perform end-of-day batch processing, the various channels and application systems that are connected to the general ledger may have upstream and downstream data relationships or batch process dependencies. The business volume and complexity of each system are different. The above reasons lead to large differences in the completion time of batch processing of each system, which may vary by several hours. The start time of the batch processing of the general ledger must start when the last docking system is completed. Therefore, those business systems that have completed the processing and supply of corresponding business data to the general ledger in advance need to wait for other systems to provide the corresponding business data files to the general ledger. The general ledger will then process and check the business data of each system to ensure that there are no problems with the business supply data. At present, the system performs unified business processing and inspection after each system has provided the corresponding data at the end of the day.

[0003] Currently, the general ledger batch run requires that all the data provided by the front-end system be received and processed, and the general ledger end-of-day batch run requires the corresponding business data to be checked and the corresponding business data to be fed back for data modification and re-supply. Therefore, it may take several hours to wait after the business system has supplied the corresponding business data to the general ledger. Even if there is a batch run problem in a business system, it may take six or seven hours to feedback that there is a problem with the business data supply. The time difference is too long.

[0004] Therefore, systems that provide data earlier require people to stay on to provide support, or continue to wait for feedback until very late, resulting in a large loss of manpower.

[0005] At present, the system processes data from multiple access systems uniformly at the end of the day, resulting in high pressure on batch processing and relatively long batch processing time.

[0006] Therefore, the general ledger needs to support independent business processing for each system, provide business data early, process the corresponding system early, use the idle time before the batch to promptly process the system that provides business data, conduct corresponding inspection and processing, and provide timely feedback if there are data errors, and conduct inspection and processing on the corresponding business system.

[0007] Based on the above situation, the inability to perform batch processing of data on a single system has a great impact on the manpower investment of upstream personnel and the problem processing time of the entire link system. This has become a major pain point for the current batch processing of banking technology departments. Summary of the invention

[0008] In view of the above problems, the present invention provides a method and system for independently processing data of a single upstream system of a bank general ledger system. By combing the business processing, the relevant configurations of the business data of each upstream system are sorted and grouped, the parameters are analyzed and classified, and distinguishable parameter configurations received by the upstream system are formulated. A batch process for single system processing is formulated, and the relevant configurations are coordinated to flexibly process the business data of each system in an independent and isolated mode, breaking the traditional mode of "overall configuration, unified processing", so that the addition and modification of different access systems can be flexibly and quickly configured, modified and processed without affecting the configuration and processing of other systems, thereby improving the flexibility and independence of the parameter configuration of each system.

[0009] To achieve the above object, the present invention provides an upstream single system data independent processing method of a bank general ledger system, comprising:

[0010] Hierarchically configure the parameters of the business system and configure the business data file sending and receiving transmission requirements of the business system;

[0011] In response to the readiness notification of the upstream system, query the configuration information and file readiness status of the business system, and trigger the independent processing flow of the single system when the business system has not completed the processing and the file is ready;

[0012] Receive and pre-process the business data files of a single system, and parse and store the business data files after checking them;

[0013] Update the processing status of the single system and record the whole process processing track.

[0014] In the above technical solution, preferably, the hierarchical configuration of the parameters of the business system and the configuration of the business data file sending and receiving transmission requirements of the business system include:

[0015] Configure the system-level parameters of the target upstream single system, including defining the system identification, access method and mapping rules;

[0016] Configuring file access parameters of the single system, including file type, access address and naming rules;

[0017] Registering the access file information of the single system, including file type, file name, expected number of records, access address and access status mark;

[0018] The single file access information of the single system is recorded, including the file name, access address, download status and error reason.

[0019] In the above technical solution, preferably, the step of querying the configuration information and file readiness status of the business system in response to the readiness notification of the upstream system includes:

[0020] Verify whether the upstream single system is ready, and notify the general ledger to process the single system business based on the readiness notification;

[0021] The single system queries the corresponding configuration information in the system according to the notification information. If the corresponding system has configuration information, the file processing information of the query system is defined to determine the file readiness status of the business system;

[0022] If the file has been processed successfully, it will not be processed again. If it has not been processed successfully, the single system will handle the operation.

[0023] In the above technical solution, preferably, the business data file of the receiving system is pre-processed, and the business data file is parsed and stored after verification. The specific process includes:

[0024] Receive the business data file of a single system, and perform access preprocessing on the business data file, including data cleaning and parameter checking;

[0025] Based on the internal verification mechanism of the system, the business data file is checked according to the summary file and the detail file to make the summary file consistent with the detail file data;

[0026] The business data files that have been preprocessed and checked are parsed and stored in the database.

[0027] In the above technical solution, preferably, the updating of the processing status of the single system and recording of the whole process processing track specifically includes:

[0028] For the single system that has been processed, update the file processing status of the corresponding single system;

[0029] For a single system that fails data verification, the corresponding system is recorded as a file processing failure status.

[0030] The present invention further proposes an upstream single system data independent processing system of a bank general ledger system, which uses the upstream single system data independent processing method of the bank general ledger system disclosed in any one of the above technical solutions, including:

[0031] A system parameter configuration module, used to hierarchically configure the parameters of the business system and configure the business data file sending and receiving transmission requirements of the business system;

[0032] A file status query module, for querying the configuration information and file readiness status of the business system in response to the readiness notification of the upstream system, and triggering an independent processing flow of a single system when the business system has not completed the processing and the file is ready;

[0033] A file receiving and warehousing module is used to receive and pre-process the business data files of a single system, and parse and store the business data files after checking them;

[0034] The system status update module is used to update the processing status of the single system and record the whole process processing track.

[0035] In the above technical solution, preferably, the system parameter configuration module is specifically used to:

[0036] Configure the system-level parameters of the target upstream single system, including defining the system identification, access method and mapping rules;

[0037] Configuring file access parameters of the single system, including file type, access address and naming rules;

[0038] Registering the access file information of the single system, including file type, file name, expected number of records, access address and access status mark;

[0039] The single file access information of the single system is recorded, including the file name, access address, download status and error reason.

[0040] In the above technical solution, preferably, the file status query module is specifically used to:

[0041] Verify whether the upstream single system is ready, and notify the general ledger to process the single system business based on the readiness notification;

[0042] The single system queries the corresponding configuration information in the system according to the notification information. If the corresponding system has configuration information, the file processing information of the query system is defined to determine the file readiness status of the business system;

[0043] If the file has been processed successfully, it will not be processed again. If it has not been processed successfully, the single system will handle the operation.

[0044] In the above technical solution, preferably, the file receiving and warehousing module is specifically used for:

[0045] Receive the business data file of a single system, and perform access preprocessing on the business data file, including data cleaning and parameter checking;

[0046] Based on the internal verification mechanism of the system, the business data file is checked according to the summary file and the detail file to make the summary file consistent with the detail file data;

[0047] The business data files that have been preprocessed and checked are parsed and stored in the database.

[0048] In the above technical solution, preferably, the system status update module is specifically used to:

[0049] For the single system that has been processed, update the file processing status of the corresponding single system;

[0050] For a single system that fails data verification, the corresponding system is recorded as a file processing failure status.

[0051] Compared with the prior art, the beneficial effects of the present invention are: by combing the business processing, sorting and grouping the relevant configurations of the business data of each upstream system, analyzing and classifying the parameters, formulating distinguishable parameter configurations received by the upstream system, and formulating a batch process for single system processing, coordinating with the relevant configuration, flexibly processing the business data of each system, and the independent and isolated mode breaks the traditional mode of "overall configuration, unified processing", so that the addition and modification of different access systems can be flexibly and quickly configured, modified and processed, without affecting the configuration and processing of other systems, thereby improving the flexibility and independence of the parameter configuration of each system. BRIEF DESCRIPTION OF THE DRAWINGS

[0052] Figure 1 A schematic flow chart of a method for independently processing data in an upstream single system of a bank general ledger system disclosed in an embodiment of the present invention;

[0053] Figure 2 A schematic diagram of a process of parameter configuration and parameter recording disclosed in an embodiment of the present invention;

[0054] Figure 3 A schematic diagram of a single system processing flow disclosed in an embodiment of the present invention;

[0055] Figure 4 The present invention is a schematic diagram of a single system data processing flow disclosed in an embodiment of the present invention. DETAILED DESCRIPTION

[0056] In order to make the purpose, technical solution and advantages of the embodiments of the present invention clearer, the technical solution in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0057] The present invention is further described in detail below in conjunction with the accompanying drawings:

[0058] like Figure 1 As shown, a method for independently processing data of an upstream single system of a bank general ledger system provided by the present invention comprises:

[0059] Configure the parameters of the business system in a hierarchical manner, and configure the business data file sending and receiving transmission requirements of the business system;

[0060] In response to the readiness notification of the upstream system, query the configuration information and file readiness status of the business system, and trigger the independent processing flow of the single system when the business system has not completed the processing and the file is ready;

[0061] Receive business data files from a single system and pre-process them, then parse and store them in the database after checking them;

[0062] Update the processing status of a single system and record the entire processing process.

[0063] The present invention aims to solve the problem that the end-of-day upstream business data processing of the bank general ledger system needs to wait for all upstream systems to provide data, each system cannot process data independently, and cannot flexibly verify and process data according to the upload time.

[0064] In this implementation, by combing through business processing, the business data-related configurations of each upstream system are sorted and grouped, the parameters are analyzed and classified, distinguishable parameter configurations received by the upstream system are formulated, and a batch process for single system processing is formulated. In conjunction with relevant configurations, the business data of each system can be flexibly processed in an independent and isolated mode, breaking the traditional mode of "overall configuration, unified processing", so that the addition and modification of different access systems can be flexibly and quickly configured, modified and processed without affecting the configuration and processing of other systems, thereby improving the flexibility and independence of the parameter configuration of each system.

[0065] like Figure 2 As shown, in the above implementation, preferably, the parameters of the business system are configured hierarchically, and the business data file sending and receiving transmission requirements of the business system are configured. The specific process includes:

[0066] Configure the system-level parameters of the target upstream single system, including defining the system identification, access method and mapping rules;

[0067] Configure file access parameters for a single system, including file type, access address, and naming rules;

[0068] Access file information of the registration form system, including file type, file name, expected number of records, access address and access status mark;

[0069] Records the single file access information of a single system, including file name, access address, download status and error reason.

[0070] Specifically, the method and design of the above parameter configuration include: definition of interactive systems, configuration of access file information of each system, recording and checking of access system files, and registration of access file information details.

[0071] During the implementation process, the definition process of the interactive system includes: the bank general ledger system is connected to many upstream systems, and the interaction designs of each bank are also different. Therefore, in order to carry out the subsequent management of the interactive system, we first sort out and define the system-level configuration of the general ledger access, and define the system definition of each access, including system identification, access method, mapping related configuration, etc., which is the top-level configuration of the single system related configuration.

[0072] The configuration process of the access file information of each system includes: sorting out and configuring the access file types of each system, including file type, file access address, file naming type, etc., which is a further configuration of the receiving content under the system.

[0073] The access file recording and inspection process includes: registering the type, name, number of items, access address, whether it has been provided, and other information of the files that need to be accessed by the system. It is a type registration actually used for system access, used to register the access status of files in each system to meet the needs of single system verification and single system processing. It is a type-level configuration and registration of usage scenarios.

[0074] The access file information details registration process includes: recording a single file access information, including file name, address, download status, error cause and other details, which is a bottom-level file level details registration for single system information reception.

[0075] The above parameter configuration and parameter-related records are the basic configuration for processing business data in a single system. The business implementation of single system processing is met through the definition of business batch processing flow.

[0076] like Figure 3 and Figure 4 As shown, in the above implementation, preferably, in response to the readiness notification of the upstream system, the configuration information and file readiness status of the business system are queried, and the specific process includes:

[0077] Verify whether the upstream single system is ready, and notify the general ledger to process the single system business based on the readiness notification;

[0078] The single system queries the corresponding configuration information in the system according to the notification information. If the corresponding system has configuration information, the file processing information of the query system is defined to determine the file readiness status of the business system;

[0079] If the file has been processed successfully, it will not be processed again. If it has not been processed successfully, the operation will be handled by a single system.

[0080] Specifically, the end-of-day system file readiness verification process includes: verifying the system that has provided data to ensure the validity of subsequent batch processing, and then conducting subsequent batch processing if there is a prepared system.

[0081] In the above implementation, preferably, the business data file of a single system is received and preprocessed, and the business data file is parsed and stored after verification. The specific process includes:

[0082] Receive business data files from a single system and perform access preprocessing on the business data files, including data cleaning and parameter checking;

[0083] Based on the internal verification mechanism of the system, the business data files are checked against the summary files and the detail files to ensure that the data in the summary files and the detail files are consistent;

[0084] Parse and store the pre-processed and verified business data files.

[0085] Specifically, the receiving preprocessing process of each file includes: access preprocessing of the files of each system, including data cleaning, parameter checking, etc., to ensure normal subsequent data processing.

[0086] The file receiving data verification process includes: the system's internal verification mechanism, which verifies the received data based on the summary file and the detail file to ensure that the summary file and the detail file data are consistent, prevent data loss and other problems.

[0087] The detailed parsing and storage process of files includes: business data content files, corresponding parsing and storage to ensure subsequent batch processing information.

[0088] In this implementation, the single system processing flow is distinguished from the end-of-day batch processing flow, and the single system processing flow can perform data processing independently to meet the processing requirements of various business data at different time points.

[0089] In the above implementation, preferably, the processing status of a single system is updated, and the whole process processing track is recorded. The specific process includes:

[0090] For the single system that has been processed, update the file processing status of the corresponding single system;

[0091] For a single system that fails data verification, the corresponding system is recorded as a file processing failure status.

[0092] Specifically, the system file processing status modification process includes: updating the single system processing status, and not processing the subsequent batch processing of the system that has been processed to prevent repeated processing.

[0093] In this implementation, the triggering and starting of single-system business data processing depends on whether the upstream system is ready. Once ready, the upstream system can notify the general ledger to perform single-system business processing. Single-system processing queries the configuration of the corresponding system in the system according to the business system configuration of the corresponding notification information. If it is determined that the notification system has configuration information, it will query the file information definition of the system to query the processing information of the system. If the processing has been successful, no repeated processing will be performed. If the processing has not been successful, it is in the state of unprocessed or failed, then the single-system processing operation is performed. First, it is determined according to the configuration that the system business information file has been provided, and the corresponding business information file is downloaded and processed. The file information is registered in detail to facilitate subsequent inspection and problem location.

[0094] After the file processing is completed, business data verification is performed, including whether the uploaded information is legal, whether it meets the mandatory requirements, whether the value is legal, etc. If all pass, the system confirms that the processing is successful and sets the single system processing status to success. Otherwise, it is set to failure, and you can wait for the corresponding system processing to be called again.

[0095] The present invention further provides an upstream single system data independent processing system of a bank general ledger system, which uses the upstream single system data independent processing method of the bank general ledger system disclosed in any one of the above embodiments, including:

[0096] The system parameter configuration module is used to configure the parameters of the business system in a hierarchical manner and configure the business data file sending and receiving transmission requirements of the business system;

[0097] The file status query module is used to respond to the readiness notification of the upstream system, query the configuration information and file readiness status of the business system, and trigger the independent processing flow of the single system when the business system has not completed the processing and the file is ready;

[0098] The file receiving and warehousing module is used to receive and pre-process the business data files of a single system, and then parse and store the business data files after checking them;

[0099] The system status update module is used to update the processing status of a single system and record the processing trajectory of the entire process.

[0100] In the above implementation, preferably, the system parameter configuration module is specifically used to:

[0101] Configure the system-level parameters of the target upstream single system, including defining the system identification, access method and mapping rules;

[0102] Configure file access parameters for a single system, including file type, access address, and naming rules;

[0103] Access file information of the registration form system, including file type, file name, expected number of records, access address and access status mark;

[0104] Records the single file access information of a single system, including file name, access address, download status and error reason.

[0105] In the above implementation, preferably, the file status query module is specifically used to:

[0106] Verify whether the upstream single system is ready, and notify the general ledger to process the single system business based on the readiness notification;

[0107] The single system queries the corresponding configuration information in the system according to the notification information. If the corresponding system has configuration information, the file processing information of the query system is defined to determine the file readiness status of the business system;

[0108] If the file has been processed successfully, it will not be processed again. If it has not been processed successfully, the operation will be handled by a single system.

[0109] In the above implementation, preferably, the file receiving and warehousing module is specifically used for:

[0110] Receive business data files from a single system and perform access preprocessing on the business data files, including data cleaning and parameter checking;

[0111] Based on the internal verification mechanism of the system, the business data files are checked against the summary files and the detail files to ensure that the data in the summary files and the detail files are consistent;

[0112] Parse and store the pre-processed and verified business data files.

[0113] In the above implementation, preferably, the system status update module is specifically used to:

[0114] For the single system that has been processed, update the file processing status of the corresponding single system;

[0115] For a single system that fails data verification, the corresponding system is recorded as a file processing failure status.

[0116] In the upstream single-system independent data processing system of the bank general ledger system disclosed in the above-mentioned implementation mode, the data reception and processing of each business system of the general ledger are decoupled through the isolated hierarchical business data configuration of each system and the independent business processing flow, so as to achieve the isolation of each system parameter and the single-system processing of the processing flow, meet the independent and on-demand single-system information reception and processing of each system, and can flexibly call the processing flow.

[0117] In the process of configuring the hierarchical business data of each system isolation: through the analysis and classification of parameters, the business data classification of all external systems is summarized. Different parameter configurations can be performed according to different system requirements. Hierarchical configuration is performed from the system, system file type, and file details under the system file type, so that business and technical personnel can clearly view the processing content and processing results of a single system, and can also quickly find, analyze and modify the required system problems.

[0118] The process of independent business processing includes: through the sorting and reconstruction of system business data processing, the single system processing process is separated from the overall end-of-day processing process; through flexible single-system batch processing, the processes involving single-system processing are integrated; combined with the hierarchical parameter configuration of each system isolation, the business data of the single system is processed, so as to realize the process processing of the single system.

[0119] The information processing method of the single-system data processing flow of this patent is different from the traditional unified processing and unified error correction of each access business data at the end of the day. It completely breaks the previous model and is driven by the readiness notification of upstream business data. Through reasonable process planning, the single-system data-related processes are independently integrated. Before the total batch at the end of the day, it can be flexibly run according to the needs of each system and provide timely feedback on data problems, which not only greatly improves the timeliness of problem handling, but also reduces the number of file processing at the end of the day, and uses resources in segments.

[0120] According to the upstream single-system data independent processing system of the bank general ledger system disclosed in the above-mentioned implementation mode, the functions to be implemented by each module thereof correspond to the steps of the upstream single-system data independent processing method of the bank general ledger system disclosed in the above-mentioned implementation mode. During the implementation process, the operation is performed with reference to the above-mentioned implementation mode, which will not be described in detail herein.

[0121] The above are only preferred embodiments of the present invention and are not intended to limit the present invention. For those skilled in the art, the present invention may have various modifications and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.

Claims

1. A method for independently processing data of an upstream single system of a bank general ledger system, characterized in that: include: Hierarchically configure the parameters of the business system and configure the business data file sending and receiving transmission requirements of the business system; In response to the readiness notification of the upstream system, query the configuration information and file readiness status of the business system, and trigger the independent processing flow of the single system when the business system has not completed the processing and the file is ready; Receive and pre-process the business data files of a single system, and parse and store the business data files after checking them; Update the processing status of the single system and record the whole process processing track.

2. The method for independently processing data of an upstream single system of a bank general ledger system according to claim 1, characterized in that: The hierarchical configuration of the parameters of the business system and the configuration of the business data file sending and receiving transmission requirements of the business system specifically include: Configure the system-level parameters of the target upstream single system, including defining the system identification, access method and mapping rules; Configuring file access parameters of the single system, including file type, access address and naming rules; Registering the access file information of the single system, including file type, file name, expected number of records, access address and access status mark; The single file access information of the single system is recorded, including the file name, access address, download status and error reason.

3. The method for independently processing data of an upstream single system of a bank general ledger system according to claim 1, characterized in that: The process of querying the configuration information and file readiness status of the business system in response to the readiness notification of the upstream system includes: Verify whether the upstream single system is ready, and notify the general ledger to process the single system business based on the readiness notification; The single system queries the corresponding configuration information in the system according to the notification information. If the corresponding system has configuration information, the file processing information of the query system is defined to determine the file readiness status of the business system; If the file has been processed successfully, it will not be processed again. If it has not been processed successfully, the operation will be processed by the single system.

4. The method for independently processing data of an upstream single system of a bank general ledger system according to claim 1, characterized in that: The receiving system's business data files are preprocessed, and the business data files are parsed and stored after verification. The specific process includes: Receive the business data file of a single system, and perform access preprocessing on the business data file, including data cleaning and parameter checking; Based on the internal verification mechanism of the system, the business data file is checked according to the summary file and the detail file to make the summary file consistent with the detail file data; The business data files that have been preprocessed and checked are parsed and stored in the database.

5. The method for independently processing data of an upstream single system of a bank general ledger system according to claim 1, characterized in that: The updating of the processing status of the single system and recording of the whole process processing track specifically includes: For the single system that has been processed, update the file processing status of the corresponding single system; For a single system that fails data verification, the corresponding system is recorded as a file processing failure status.

6. An upstream single-system data independent processing system for a bank general ledger system, characterized in that: An upstream single system data independent processing method for a bank general ledger system according to any one of claims 1 to 5, comprising: A system parameter configuration module, used to hierarchically configure the parameters of the business system and configure the business data file sending and receiving transmission requirements of the business system; A file status query module, for querying the configuration information and file readiness status of the business system in response to the readiness notification of the upstream system, and triggering an independent processing flow of a single system when the business system has not completed the processing and the file is ready; A file receiving and warehousing module is used to receive and pre-process the business data files of a single system, and parse and store the business data files after checking them; The system status update module is used to update the processing status of the single system and record the whole process processing track.

7. The upstream single system data independent processing system of the bank general ledger system according to claim 6, characterized in that: The system parameter configuration module is specifically used for: Configure the system-level parameters of the target upstream single system, including defining the system identification, access method and mapping rules; Configuring file access parameters of the single system, including file type, access address and naming rules; Registering the access file information of the single system, including file type, file name, expected number of records, access address and access status mark; The single file access information of the single system is recorded, including the file name, access address, download status and error reason.

8. The upstream single system data independent processing system of the bank general ledger system according to claim 7, characterized in that: The file status query module is specifically used for: Verify whether the upstream single system is ready, and notify the general ledger to process the single system business based on the readiness notification; The single system queries the corresponding configuration information in the system according to the notification information. If the corresponding system has configuration information, the file processing information of the query system is defined to determine the file readiness status of the business system; If the file has been processed successfully, it will not be processed again. If it has not been processed successfully, the operation will be processed by the single system.

9. The upstream single system data independent processing system of the bank general ledger system according to claim 8, characterized in that: The file receiving and warehousing module is specifically used for: Receive the business data file of a single system, and perform access preprocessing on the business data file, including data cleaning and parameter checking; Based on the internal verification mechanism of the system, the business data file is checked according to the summary file and the detail file to make the summary file consistent with the detail file data; The business data files that have been preprocessed and checked are parsed and stored in the database.

10. The upstream single system data independent processing system of the bank general ledger system according to claim 9, characterized in that: The system status update module is specifically used for: For the single system that has been processed, update the file processing status of the corresponding single system; For a single system that fails data verification, the corresponding system is recorded as a file processing failure status.

Images