Method and device for generating statistical report, electronic equipment and storage medium

Abstract

The application relates to the technical field of data processing, and discloses a statistical report generation method and device and electronic equipment. The method comprises the following steps: acquiring transaction log information and a transaction flow table; traversing transaction data in the transaction log information to acquire a global event tracking number in the transaction data; if the global event tracking number exists in the transaction flow table, acquiring a transaction complete snapshot according to transaction data in the transaction flow table, and synchronizing transaction data in the transaction complete snapshot to a transaction detail registration table; if the global event tracking number does not exist in the transaction flow table, synchronizing transaction data in the transaction log information to the transaction detail registration table; and generating a statistical report according to transaction data in the transaction detail registration table. In this way, the electronic equipment can obtain a unified statistical report view to see the coverage of system processing business, effectively improves the completeness and comprehensiveness of the statistical report, and improves the accuracy of the statistical report.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of data processing, in particular to a method and device for generating a statistical report, an electronic device and a storage medium. BACKGROUND

[0002] With the development of financial business, banking business innovation emerges in an endless stream. In the process of business testing and running, a complete view report is needed, which can view the situation of the system processing business in a certain period of time, and clearly see the test / running coverage of the system transaction code and function.

[0003] When the application system receives a service request and processes it, some business elements are output to the application system transaction log, which facilitates subsequent positioning analysis when problems are encountered, and can be captured by the monitoring system for statistical analysis. However, the information output by the transaction log of the application system is limited, and only some simple transaction statistical analysis can be performed. For some complex transactions, some data information related to different scenarios and different business types of transactions may be lacking, and a report for comprehensive statistical analysis has not been formed. Moreover, the transaction flow table of the application system mainly records the platform flow of the application system after receiving the account transaction request and the service flow generated by the application system outbound background account system. However, these flow tables can only identify the initiator, processor, backend system and other information of the account transaction, but the business elements related to the transaction itself are not very complete. Therefore, it is also impossible to perform comprehensive statistical analysis on the data information in the transaction flow table to obtain a clear and complete statistical report. SUMMARY

[0004] The present application provides a method and device for generating a statistical report, an electronic device and a storage medium, to solve the problem that only limited simple transaction information can be statistically analyzed in the prior art, and the data information in the transaction flow table cannot be comprehensively statistically analyzed to obtain a clear and complete statistical report.

[0005] In a first aspect, embodiments of the present application provide a method for generating a statistical report, applied to an electronic device, the method comprising: acquiring transaction log information and a transaction flow table; traversing transaction data in the transaction log information to obtain a global event tracking number in the transaction data; if the global event tracking number exists in the transaction flow table, obtaining a transaction complete snapshot according to transaction data in the transaction flow table, and synchronizing transaction data in the transaction complete snapshot to a transaction detail registration table; if the global event tracking number does not exist in the transaction flow table, synchronizing transaction data in the transaction log information to the transaction detail registration table; and generating a statistical report according to transaction data in the transaction detail registration table.

[0006] Thus, the electronic device takes whether the global event tracking number exists in the transaction logbook as a basis for judgment, and through newly building a transaction detail registration table, if the global event tracking number exists in the transaction logbook, a complete transaction snapshot can be directly obtained according to the transaction data in the transaction logbook, and the transaction data in the complete transaction snapshot is synchronized to the transaction detail registration table; if the global event tracking number does not exist in the transaction logbook, it indicates that the transaction data is dispersed in different places after the system processes the business, but these transaction data are stored in the transaction log information of the application system, thus the transaction log information in the application system is directly synchronized to the transaction detail registration table, so that a complete and unified statistical report view can be generated according to the transaction data in the transaction detail registration table to comprehensively and intuitively see the coverage of the system processing various businesses, so as to quickly show the application system function transaction test and running situation.

[0007] According to an embodiment of the present application, the transaction logbook includes a platform logbook and a service party logbook.

[0008] Thus, the transaction logbook in the application system is divided into the platform logbook and the service party logbook. The transaction logbook refers to the deposit and withdrawal transaction record of the bank current account (including the current deposit book and the bank card). The platform logbook can be, for example, the transaction log of the bank, the transaction record on the platform of the bank. The service party logbook can be the transaction record of the customer party.

[0009] According to an embodiment of the present application, the complete transaction snapshot is obtained according to the transaction data in the transaction logbook, including: obtaining the transaction data through the transaction logbook association table to obtain the complete transaction snapshot.

[0010] Because the business elements involved in the transaction itself are not very complete, the association table is needed. The contract table refers to the deposit and withdrawal transaction record of the bank current account (including the current deposit book and the bank card). Through the transaction logbook association table, the transaction logbook can obtain the transaction data in the contract table, and finally obtain the complete transaction snapshot of the complete transaction data.

[0011] According to an embodiment of the present application, the transaction data of the platform logbook includes a global event tracking number, a payment sub-transaction serial number, a remittance contract number, a local service ID, a service response state and a transaction date. The transaction data of the service party logbook includes a global event tracking number, a payment sub-transaction serial number, a remittance contract number, an outbound call service ID, a service response state and a transaction date. The transaction data of the contract table includes a remittance contract number, a work date, a work date, a remittance channel code, a message type, a remittance in-out flag code, a message debit-credit direction code, a payment clearing business type code, and a payment clearing business type code.

[0012] Thus, the platform log table, the service log table and the joint table with the global event tracking number can obtain complete transaction data, and a complete transaction snapshot can be directly obtained, so that corresponding statistical reports can be generated according to the transaction data, and the comprehensiveness and accuracy of the system processing business coverage are improved.

[0013] According to an embodiment of the present application, the transaction data synchronized to the transaction detail registration table includes a global event tracking number, a payment sub-transaction serial number, a remittance contract number, a local service ID, an outbound call service ID, a service response state, a transaction date, a working date, a remittance channel code, a message type, an import / export flag, a message debit / credit direction code, a payment clearing service type code and a payment clearing service type code.

[0014] Thus, the transaction log table does not have a global event tracking number, and the transaction data in the transaction log table is incomplete, so that the transaction data in the transaction detail registration table is directly extracted and registered in a newly created registration table, thereby improving the comprehensiveness of the statistical report, and the system processing business coverage can be completely seen, and the accuracy of the statistical data is improved.

[0015] According to an embodiment of the present application, the transaction data in the transaction detail registration table generates a statistical report, including: generating a statistical report according to the required statistical dimension, and the statistical report includes a report of upstream channel calling the system service, a report of the outbound downstream system and a report of the processing business coverage.

[0016] Thus, the obtained statistical report can completely and comprehensively reflect the transaction situation of the upstream channel of the bank, including various types of deposit sources (institutions, companies, individuals, various social groups, etc.), and the transaction situation of the outbound downstream of the customer transaction operation, including various types of loan demanders (institutions, companies, individuals, various social groups, etc.), and the bank processing business coverage, including various types of transaction business of the bank, the number of pens, etc.

[0017] According to an embodiment of the present application, the report of the upstream channel calling the system service is a statistical report determined based on the local service ID and the service response state, the report of the outbound downstream system is a statistical report determined based on the outbound call service ID and the service response state, and the report of the processing business coverage is a statistical report determined based on the payment clearing service type code, the payment clearing service type code and the service response state.

[0018] Thus, the report of the upstream channel calling the service of the system can clearly know through the report whether a staff of the bank successfully responds to the service at a certain bank, so as to obtain the number of successful transactions and the number of failed transactions, and the proportion of successful transactions and failed transactions in the transaction center.

[0019] The report of the downstream system of the outbound call can clearly know through the report whether the transaction of the customer at a certain bank, such as deposit, successfully responds to the service, so as to obtain the number of successful transactions and the number of failed transactions, and the proportion of successful transactions and failed transactions in the transaction center.

[0020] The report of the processing business coverage can clearly know through the report the message type of the transaction in the bank, the payment clearing business type code and the payment clearing business type code of the exchange, whether the transaction successfully responds to the service, so as to obtain the number of successful transactions and the number of failed transactions, and the proportion of successful transactions and failed transactions in the transaction center.

[0021] According to an embodiment of the present application, the type of the transaction data includes an account transaction and a non-account transaction.

[0022] According to an embodiment of the present application, if the global event tracking number exists in the transaction log table, it is determined that the type of the transaction data is an account transaction; if the global event tracking number does not exist in the platform log table and the service log table, it is determined that the type of the transaction data is a non-account transaction.

[0023] In the present application, if the global event tracking number exists in the transaction log table, the type of the transaction data is an account transaction, and if the global event tracking number does not exist in the transaction log table, the type of the transaction data is a non-account transaction. Whether the transaction is completed can be known through whether the global event tracking number exists in the transaction log table. It is avoided that the statistical report cannot record the transaction that is not completed, so that the statistical report obtained can fully obtain the processing business coverage of the system.

[0024] The device for generating a statistical report provided in the present application is used to execute the method for generating a statistical report provided in the first aspect and / or any possible implementation manner of the first aspect, so that the beneficial effects (or advantages) possessed by the method for generating a statistical report provided in the first aspect can also be achieved.

[0025] In a second aspect, embodiments of the present application provide a statistical report generation apparatus, comprising: a first processing module configured to acquire transaction log information and a transaction flow table; a second processing module configured to traverse transaction data in the transaction log information to acquire a global event tracking number in the transaction data; a third processing module configured to, if the global event tracking number exists in the transaction flow table, acquire a transaction complete snapshot according to transaction data in the transaction flow table, and synchronize transaction data in the transaction complete snapshot to a transaction detail registration table; a fourth processing module configured to, if the global event tracking number does not exist in the transaction flow table, synchronize transaction data in the transaction log information to the transaction detail registration table; and a fifth processing module configured to generate a statistical report according to transaction data in the transaction detail registration table.

[0026] In a third aspect, embodiments of the present application provide an electronic device, comprising: a memory configured to store a computer program, the computer program comprising program instructions; and a processor configured to execute the program instructions to cause the electronic device to perform the statistical report generation method provided in the first aspect and / or any possible implementation manner of the first aspect.

[0027] In a fourth aspect, embodiments of the present application provide a computer readable storage medium, the computer readable storage medium storing a computer program, the computer program comprising program instructions, the program instructions being executed by an electronic device to cause the electronic device to perform the statistical report generation method provided in the first aspect and / or any possible implementation manner of the first aspect.

[0028] In a fifth aspect, embodiments of the present application provide a computer program product, comprising computer program / instructions, the computer program / instructions being executed by a processor to implement the statistical report generation method provided in the first aspect and / or any possible implementation manner of the first aspect.

[0029] It can be understood that the beneficial effects of the second aspect to the fifth aspect described above can also be referred to the related description in the first aspect, which will not be repeated here.

[0030] The method for generating a statistical report provided in the application obtains transaction log information and a transaction flow table from an application system, obtains a global event tracking number from the transaction log information, and determines whether the global event tracking number exists in the transaction flow table. A complete transaction snapshot can be obtained directly from transaction data in the transaction flow table, and transaction data in the complete transaction snapshot can be synchronized to a transaction detail registration table, or information in the application system that is dispersed in different places after the system processes a business can be synchronized to a transaction detail registration table. A unified statistical report view can be obtained from transaction data in the transaction detail registration table to completely see the coverage of the system processing a business, so that the function transaction test / operation situation can be quickly displayed, and the completeness and comprehensiveness of the statistical report are effectively improved, and the accuracy of the statistical data is also improved. BRIEF DESCRIPTION OF DRAWINGS

[0031] In order to more clearly illustrate the technical solutions of the application, the drawings used in the implementation manner description will be briefly introduced.

[0032] Figure 1 According to some embodiments of the application, a flowchart of a method for generating a statistical report provided by the application is shown;

[0033] Figure 2 According to some embodiments of the application, a flowchart of another method for generating a statistical report provided by the application is shown;

[0034] Figure 3 According to some embodiments of the application, a structural block diagram of a method for generating a statistical report provided by the application is shown;

[0035] Figure 4 According to some embodiments of the application, a structural diagram of an electronic device is shown. DETAILED DESCRIPTION

[0036] The technical solutions of the application will be described in further detail below with reference to the drawings. It should be noted that the acquisition, storage, use, processing, etc. of data in the technical solutions of the application all comply with relevant provisions of national laws and regulations.

[0037] Terminology explanation:

[0038] Transaction code: a unique function code defined for a function implemented in the system.

[0039] Transaction log information: a log file that registers summary information of each transaction processed by the system.

[0040] Platform flow table: transaction flow information registered when a peripheral system calls a service of the system.

[0041] Service side flow table: the transaction flow information registered by the system when the application system calls the back-end system.

[0042] Contract table: the transaction snapshot of the basic information of the payee and payer registered by the application system when processing the account transaction.

[0043] With the development of financial business, there are numerous innovations in banking business. During the business testing and operation, a complete view is needed to enable the user to view the situation of the system processing the business in a certain period of time, so that the user can clearly see the test / operation coverage of the system transaction code and function.

[0044] After receiving the account transaction request, the application system generates the request information of the channel system, the basic information of the function service of the application system, the service processing state information, the received request message of the transaction, the response channel message and other information. This flow information is the transaction information registered in the platform flow table. After receiving the account transaction request, if the business needs to call the back-end system through the application system, the transaction information in the service side flow table will be registered. The service side flow table mainly registers the service processing state information, the call request message of the transaction, the response message of the back-end system and other information. The transaction flow mainly registers the platform flow after the application system receives the account transaction request and the service side flow generated when the application system calls the back-end system. This flow can clearly identify the initiator, processor and back-end system of the account transaction, but the information of the business elements involved in the transaction itself is not very complete.

[0045] Therefore, the embodiment of the present application provides a method for generating a statistical report, which is used to solve the problem that the data information involved in the transaction in different scenarios and different business categories is not complete, and the information of the business elements involved in the transaction itself is not complete, so that the report cannot be formed for comprehensive statistical analysis.

[0046] Reference Figure 1 , Figure 1 The flowchart of the method for generating a statistical report is shown. The method is applied to an electronic device, which can be the structure block diagram shown in Figure 3 . The following is executed by the electronic device, as shown in Figure 1 , the flowchart includes S110-S160.

[0047] S110, obtaining transaction log information and transaction flow table.

[0048] Specifically, in the application system running, after receiving the service request and processing, part of the business information is output to the designated application system transaction log for subsequent business troubleshooting. The transaction log information records a snapshot of all transactions received and processed by the system. When the application system receives a service request and processes it, it outputs some business elements to the application system transaction log, which facilitates subsequent positioning analysis when problems occur, and can also be captured by the monitoring system for statistics and analysis.

[0049] In order to realize the statistics of various transaction data in the application system, first of all, the domain definition of the data collection file stored in the transaction log information needs to be performed, and the specification format of the file is set, for example, the data collection file can be set to the format of an excel table, and each column in the table can represent the internal transaction serial number, transaction volume, success rate, processing time, response time, global event tracking number (such as number 1001, etc.) and other information corresponding to the transaction data.

[0050] S120, traversing the transaction data in the transaction log information to obtain the global event tracking number in the transaction data.

[0051] Specifically, the data information of the global event tracking number in the transaction log information is extracted. The method of extracting the global event tracking number can be obtained by field, or the global event tracking number in the system transaction can be obtained by other extraction methods according to the actual situation.

[0052] S130, whether the global event tracking number exists in the transaction flow table.

[0053] Specifically, as long as the platform or service initiates a transaction in the application system, the application system will generate a corresponding global event tracking number according to the transaction, therefore, through the global event tracking number, all operations of the transaction can be corresponded, so as to obtain the transaction situation of the transaction.

[0054] S140, if yes, the transaction complete snapshot is obtained according to the transaction data in the transaction flow table, and the transaction data in the transaction complete snapshot is synchronized to the transaction detail registration table.

[0055] Specifically, if the global event tracking number exists in the transaction flow table, it means that the transaction data in the transaction flow table can generate a transaction complete snapshot, so that a complete and comprehensive statistical report can be generated.

[0056] S150, if not, the transaction data in the transaction log information is synchronized to the transaction detail registration table.

[0057] S160, generating a statistical report according to the transaction data in the transaction detail registration table.

[0058] Specifically, the data in the transaction log table can be collected according to the global event tracking number, and the collected transaction data can be written into a transaction detail registration table with a fixed file name, such as an excel table with a fixed file name determined according to business classification. For example, the transaction data in the application system can be written into a transaction detail level table. The transaction data includes transaction volume, success rate, processing time, response time and other transaction information.

[0059] It should be noted that, in the running of the application system, when the transaction service request is received and processed, part of the transaction service information will be output to the transaction log of the designated application system, so that the transaction log records a snapshot of all transactions received and processed by the system. When the application system receives the transaction service request and processes the transaction, part of the business elements will be output to the transaction log of the application system, so that if a problem occurs in the subsequent transaction, it can be located and the specific situation can be analyzed. The transaction log can also be used by the monitoring system to capture transaction data for subsequent statistical analysis and processing. However, the transaction data in the application system log needs to be analyzed in different dimensions such as different business types, different transaction states, and transaction success rates for complex transactions involving different scenarios. Therefore, when the global event tracking number exists in the transaction log table, the transaction data in the complete snapshot of the transaction obtained from the transaction log table is directly synchronized to the transaction detail registration table to obtain a complete statistical report. When the global event tracking number does not exist in the transaction log table, the transaction may also exist other non-financial transactions and other transaction state information, and a transaction detail registration table can be newly created to count all transaction data in the application system to obtain a complete and comprehensive transaction statistical report.

[0060] In the implementation manner of the present application, the electronic device synchronizes the transaction data in the complete snapshot of the transaction obtained from the transaction log table to the transaction detail registration table based on whether the global event tracking number exists in the transaction log table, or synchronizes the transaction log information in the application system to the transaction detail registration table, so as to generate a complete and unified statistical report view according to the transaction data in the transaction detail registration table, so that the coverage of the system processing various businesses can be comprehensively and intuitively seen, and the application system function transaction test and running situation can be quickly displayed.

[0061] It should be noted that, in the implementation manner of the present application, the transaction log table includes a platform log table and a service provider log table.

[0062] The transaction complete snapshot is obtained according to the transaction data in the transaction log table, including: obtaining the transaction data through the transaction log association table to obtain the transaction complete snapshot.

[0063] The platform flow table is transaction flow information registered when the peripheral system calls the system service. The transaction data of the platform flow table mainly includes global event tracking number, payment sub-transaction serial number, remittance contract number, local service ID, service response status, and transaction date.

[0064] The transaction data stored in the platform flow table is shown in Table 1 (main fields are exemplified) as follows:

[0065]

[0066]

[0067]

[0068] The service flow table is transaction flow information registered when the system outbound call background system is called. The transaction data of the service flow table mainly includes global event tracking number, payment sub-transaction serial number, remittance contract number, outbound call service ID, service response status, and transaction date.

[0069] The transaction data stored in the service flow table is shown in Table 2 (main fields are exemplified) as follows:

[0070]

[0071]

[0072] After receiving the account type business request, the application system will record the channel system request information and the basic information of the application system function service, service processing state information, transaction receiving request message, response channel message, and other information. This flow information is the platform flow. After receiving the account type business request, if the business needs to call the application system outbound call background account system, the service flow will be registered at this time. The service flow mainly records the service processing state information, transaction outbound call request message, and background account system response message.

[0073] The transaction flow table mainly records the platform flow after the application system receives the account type transaction request and the service flow generated when the application system outbound call background account system is called.

[0074] The platform flow table and the service flow table can clearly identify the initiator, processor, and backend system of the account type transaction. However, the business elements and information involved in the transaction are not very complete, so it is necessary to associate the contract table.

[0075] It should be noted that the contract table refers to the bank account (including the bank card and bank card) deposit and withdrawal transaction record. The transaction snapshot is a proof after we make a stock transaction, which records our transaction at that time, and also records our transaction method, etc.

[0076] In this application, the contract table can be associated by the association tool in the database, so that the transaction flow table can obtain the transaction data in the contract table.

[0077] The contract table is a transaction snapshot of the basic information of the payer and the payee registered by the application system when processing the account transaction. The transaction data of the contract table mainly includes the remittance contract number, the work date, the remittance channel code, the message type, the remittance in-out flag code, the message debit-credit direction code, the payment clearing business type code, and the payment clearing business type code.

[0078] The transaction data stored in the contract table is shown in Table 3 (main field example) as follows:

[0079]

[0080]

[0081] In the presence of the platform flow table of the global event tracking number and the service flow table, the complete transaction data can be obtained by associating the contract table, a complete transaction snapshot can be directly obtained, and then the transaction data in the transaction complete snapshot is synchronized to the transaction detail registration table. According to the transaction data in the transaction detail registration table, the required statistical report can be generated, and the coverage of various business processed by the system can be comprehensively and intuitively covered, so that the application system function transaction test and operation can be quickly displayed, including displaying the coverage of the system processing business data, improving the comprehensiveness and accuracy of the statistical report displaying the coverage of the system processing various business.

[0082] The transaction data stored in the transaction snapshot data is shown in Table 4 (main field example) as follows:

[0083]

[0084]

[0085] The transaction data synchronized to the transaction detail registration table mainly includes the global event tracking number, the payment sub-transaction serial number, the remittance contract number, the local service ID, the external call service ID, the service response state, the transaction date, the work date, the remittance channel code, the message type, the remittance in-out flag code, the message debit-credit direction code, the payment clearing business type code, and the payment clearing business type code.

[0086] The transaction detail registration table specifically stores transaction data as shown in Table 5 (main field examples):

[0087]

[0088]

[0089] Meanwhile, the transaction detail registration table can also record detailed fields involved in transaction statistics. Since the transaction log information is a log file processed by the registration system for each transaction summary information, the application system can obtain all transaction data including the global event tracking number, such as transaction serial number, transaction code, etc., by obtaining the key main detailed fields in the transaction log information. The electronic device can determine whether the global event tracking number exists in the transaction flow table according to the obtained global event tracking number, so as to determine whether the transaction data in the transaction log information needs to be registered in the transaction detail registration table.

[0090] If the global event tracking number exists in the transaction flow table, the transaction flow table is associated with the association table to obtain a complete transaction snapshot, so that the transaction data in the complete transaction snapshot is synchronized to the newly created transaction detail registration table. If the global event tracking number does not exist in the transaction flow table, the transaction data in the transaction flow table is missing, and the transaction data existing in the transaction registration table is directly extracted and synchronized to the newly created transaction detail registration table. According to the transaction data in the transaction detail registration table, a statistical report is generated, thereby improving the comprehensiveness of the statistical report, and the system processing business coverage can also be completely seen, and the accuracy of the statistical data is also improved.

[0091] The statistical report includes a report of the upstream channel calling the service of the system, a report of the situation of the outbound system, and a report of the processing business coverage.

[0092] Specifically, the report of the upstream channel calling the service of the system determines the corresponding statistical report based on the local service code and the service response state.

[0093] The report of the upstream channel calling the service of the system is shown in Table 6:

[0094]

[0095]

[0096] The report of the upstream channel calling the service of the system also includes the initiating channel (for example, the employee channel of the bank), the number of transactions, and the transaction proportion. Therefore, the report can clearly know through the report whether a certain employee of the bank successfully responds to the service at a certain bank, as well as the number of successful transactions and the number of failed transactions, and the proportion of successful transactions and failed transactions in the transaction center.

[0097] The out-bound downstream system condition report includes corresponding statistical reports determined based on the out-bound call service ID and the service response status.

[0098] The out-bound downstream system condition report is shown in Table 7 as follows:

[0099]

[0100] The out-bound downstream system condition report also includes user operations (e.g., deposit, withdrawal, and transfer transaction types) of the background service system, the number of transactions, and the transaction proportion. Thus, the report can clearly know through the report that a customer has performed a transaction such as deposit at a certain bank, whether the transaction has successfully responded to the service, the number of successful transactions and the number of failed transactions, and the proportion of successful transactions and failed transactions in the transaction center.

[0101] The report on the business coverage condition is determined based on the payment clearing business type code, the payment clearing business type code, and the service response status.

[0102] The report on the business coverage condition is shown in Table 8 as follows:

[0103]

[0104]

[0105] The report on the business coverage condition also includes the message type, the number of transactions, and the transaction proportion. Thus, the report can clearly know through the report that the message type of the transaction in the bank, the payment clearing business type code and the payment clearing business type code of the exchange, whether the transaction has successfully responded to the service, the number of successful transactions and the number of failed transactions, and the proportion of successful transactions and failed transactions in the transaction center.

[0106] The type of the transaction includes an account transaction and a non-account transaction. If the global event tracking number exists in the transaction log table, the type of the transaction is determined as the account transaction. If the global event tracking number does not exist in the platform log table and the service party log table, the type of the transaction is determined as the non-account transaction.

[0107] The application system transaction log information is analyzed and processed, and the platform stream table and the service party stream table are inquired according to the global event tracking number. If the record exists in the transaction stream table, it is indicated that the transaction is an account transaction, and the subsequent processing condition is used as a criterion for statistics. The transaction type in which the global event tracking number does not exist in the transaction stream table is a non-account transaction. Whether the transaction is completed can be known by whether the global event tracking number exists in the transaction stream table. The problem that the statistical report cannot record the transaction without completed finance is avoided, so that the obtained statistical report can comprehensively cover the system processing business coverage.

[0108] In addition, the related transaction data dispersed in the transaction log file and the transaction stream table can be integrated in a transaction detail registration table through the application, so that according to the transaction data in the transaction detail registration table, the statistical report required by different perspectives and different dimensions is generated by extracting, counting and processing the related transaction data, so that the application management personnel can master the transaction data generated by the service calling relationship between the upstream and downstream systems in the application system through the generated transaction detail registration table, obtain the coverage rate and success rate of the function transaction, and also can quickly and detailedly count the statistical report related to the business dimension according to the user's needs, so as to improve the user experience.

[0109] Reference Figure 2 , Figure 2 Another flowchart of a method for generating a statistical report according to an embodiment of the application is shown. Taking the method applied to an electronic device as an example for description. The following is executed by an electronic device, which can be Figure 3 The flowchart includes S210-S280.

[0110] S210, obtaining transaction log information and transaction stream table. The transaction stream table includes a platform stream table and a service party stream table, and a transaction complete snapshot is obtained according to the transaction data in the transaction stream table, including: obtaining transaction data through the transaction stream table association table to obtain a transaction complete snapshot.

[0111] It should be noted that the transaction stream table refers to the deposit and withdrawal transaction record of the bank current account (including the current deposit book and the bank card). The platform stream table can be, for example, the transaction stream of the bank, and the transaction record on the platform of the bank. The service party stream table can be the transaction record of the customer party.

[0112] The contract table refers to the deposit and withdrawal transaction record of the bank current account (including the current deposit book and the bank card). The transaction snapshot is a proof after we conduct stock transaction, which records the transaction at that time, and also records the transaction mode, etc.

[0113] S220, traverse the transaction data in the transaction log information to obtain the global event tracking number in the transaction data.

[0114] Specifically, data information of the global event tracking number in the transaction log information is extracted.

[0115] S230, whether the global event tracking number exists in the transaction log table.

[0116] Specifically, as long as the platform party or the service party initiates a transaction in the application system, the application system should generate a corresponding global event tracking number for the transaction, and therefore, through the global event tracking number, all operations of the transaction can be corresponded to obtain the transaction condition of the transaction.

[0117] S240, if yes, determine that the type of the transaction data is an accounting transaction.

[0118] S260, obtain a transaction complete snapshot according to the transaction data in the transaction log table, and synchronize the transaction data in the transaction complete snapshot to the transaction detail registration table.

[0119] It should be noted that the accounting transaction refers to a transaction to be accounted for. The financial transaction is a series of transaction conditions that will be used as accounting vouchers, and will generate an accounting transaction log. The accounting refers to the implementation of accounting processing to collect, sort, record, calculate, and report original documents, and requires standardization, accuracy, and guarantee of accounting, accounting supervision, and effective implementation of accounting standards.

[0120] In addition, the application system transaction log information is analyzed and processed, and if the global event tracking number exists in the transaction log table, it indicates that the transaction data is an accounting transaction. The transaction log table only registers the initiator, processor, back-end system, and other information of the accounting transaction, and lacks business elements and other information related to the transaction itself when generating a statistical report. Therefore, by determining that the global event tracking number exists in the transaction log table, a transaction complete snapshot can be obtained according to the transaction data in the transaction log table, and the transaction data in the transaction complete snapshot can be synchronized to the transaction detail registration table.

[0121] S250, if no, determine that the type of the transaction data is a non-accounting transaction.

[0122] S270, synchronize the transaction data in the transaction log information to the transaction detail registration table.

[0123] It should be noted that the transaction data in the transaction log information is directly synchronized to the transaction detail registration table to obtain comprehensive transaction data.

[0124] S280, generating a statistical report according to the transaction data in the transaction detail registration table.

[0125] It should be noted that through all the transaction data synchronized to the transaction detail registration table, the user can generate accurate and comprehensive statistical reports according to the transaction data in the table.

[0126] It should be noted that if the global event tracking number does not exist in the transaction log table, the transaction may have occurred other non-accounting transactions. Non-accounting transactions can be business opened for non-transaction accounts. Non-transaction accounts are deposit accounts opened by customers for the purpose of obtaining interest income or accessing funds safely and conveniently. This type of account cannot issue checks or overdraw, but can obtain deposit interest income. It mainly includes two categories of fixed deposit and savings deposit. Since it does not need to be initiated by the platform or service provider, if a statistical report is to be generated, the relevant transaction data in the transaction log can be obtained according to the global event tracking number, so that a complete and comprehensive statistical report can be generated.

[0127] The transaction data of the platform log table includes the global event tracking number, the payment sub-transaction serial number, the remittance contract number, the local service ID, the service response status and the transaction date; the transaction data of the service log table includes the global event tracking number, the payment sub-transaction serial number, the remittance contract number, the outbound call service ID, the service response status and the transaction date; the transaction data of the contract table includes the remittance contract number, the work date, the work date, the exchange route code, the message type, the in-out flag code, the message debit-credit direction code, the payment clearing business type code, and the payment clearing business type code.

[0128] The transaction data synchronized to the transaction detail registration table includes the global event tracking number, the payment sub-transaction serial number, the remittance contract number, the local service ID, the outbound call service ID, the service response status, the transaction date, the work date, the exchange route code, the message type, the in-out flag code, the message debit-credit direction code, the payment clearing business type code, and the payment clearing business type code.

[0129] It should be noted that the data stored in different tables are described in detail in Tables 1-5 above, which will not be described here. Through the transaction data in the transaction log table and the data in the transaction log information, a complete and comprehensive transaction statistical report can be obtained.

[0130] The statistical report includes a report of the upstream channel calling the system service, a report of the outbound downstream system, and a report of the business coverage.

[0131] It should be noted that the upstream channel of the bank is various sources of deposits (institutions, companies, individuals, various social groups, etc.), and the outbound downstream is various loan demanders (of the same type) that need loans. The processing business coverage report is a statistical report based on the payment clearing business type code, the payment clearing business type code, and the service response state.

[0132] The upstream channel calls the report of the system service based on the local service ID and the service response state. The outbound downstream system report includes a statistical report based on the outbound service ID and the service response state. The processing business coverage report is a statistical report based on the payment clearing business type code, the payment clearing business type code, and the service response state.

[0133] It should be noted that the different focused statistical reports generated are shown in Tables 6-8 above, and will not be described again.

[0134] According to the method of the present application, by obtaining the transaction data in the application system, and based on whether there is a global event tracking number in the transaction log table, the transaction data in the transaction complete snapshot obtained from the transaction data in the transaction log table is synchronized to the transaction detail registration table; or the transaction log information in the application system is synchronized to the transaction detail registration table, so as to generate a complete and unified statistical report view according to the transaction data in the transaction detail registration table, so that the coverage of the system processing various businesses can be comprehensively and intuitively seen, and the application system function transaction test and operation situation can be quickly displayed, solving the problem that in the prior art, only the information of limited simple transactions can be statistically analyzed, and the data information in the transaction log table cannot be comprehensively statistically analyzed to obtain a clear and complete statistical report.

[0135] Please refer to Figure 3 , Figure 3 The structure block diagram of the statistical report generation device 300 provided by the present application is shown in FIG. 6. The device includes a first processing module 301, a second processing module 302, a third processing module 303, a fourth processing module 304, and a fifth processing module 305. The first processing module 301 is used to implement the processing related to the aforementioned step S110, the second processing module 302 is used to implement the processing related to the aforementioned step S120, the third processing module 303 is used to implement the processing related to the aforementioned steps S130 and S140, the fourth processing module 304 is used to implement the processing related to the aforementioned steps S130 and S150, and the fifth processing module 305 is used to implement the processing related to the aforementioned step S160.

[0136] It should be noted that the first processing module 301, the second processing module 302, and the third processing module 303 of the structure block diagram of the interest calculation device 300 provided by the present application can each be implemented by a processor of a computer.

[0137] The first processing module 301 acquires transaction log information and a transaction flow table.

[0138] The second processing module 302 traverses transaction data in the transaction log information to acquire a global event tracking number in the transaction data.

[0139] The third processing module 303 acquires a transaction complete snapshot according to transaction data in the transaction flow table if the global event tracking number exists in the transaction flow table, and synchronizes transaction data in the transaction complete snapshot to a transaction detail registration table.

[0140] The fourth processing module 304 synchronizes transaction data in the transaction log information to the transaction detail registration table if the global event tracking number does not exist in the transaction flow table.

[0141] The fifth processing module 305 generates a statistical report according to transaction data in the transaction detail registration table.

[0142] The application can obtain transaction log information and a transaction flow table from an application system by comprehensively mining registered transaction log information, transaction flow information and transaction contract information after the application system receives a service request for generating a report. A global event tracking number obtained from the transaction log information can be directly used to obtain a transaction complete snapshot according to transaction data in the transaction flow table. The transaction data in the transaction complete snapshot can be synchronized to a transaction detail registration table, or information in the application system dispersed in different places after processing a business can be synchronized to the transaction detail registration table. Thus, a simple and fast view for conveniently and statistically processing a system transaction can be generated to completely see a coverage of processing a business by the system, quickly show a function transaction test / running condition, effectively improve completeness and comprehensiveness of a statistical report, and improve accuracy of statistical data.

[0143] It should be noted that the business confirmation system can include more or fewer modules, sub-modules and units in some other implementations of the application, which can be selected and set as needed. For example, functions of at least two of the first processing module 301, the second processing module 302, the third processing module 303, the fourth processing module 304 and the fifth processing module 305 can also be implemented by one other module, or functions of any one of the modules can also be completed by other at least two other modules, etc.

[0144] Please refer to Figure 4 , Figure 4Fig. 1 illustrates an example of an electronic device that can implement the method for generating a statistical report according to embodiments of the present disclosure. The electronic device can include one or more processors 1002, system control logic 1008 connected to at least one of the processors 1002, system memory 1004 connected to the system control logic 1008, non-volatile memory (NVM) 1006 connected to the system control logic 1008, and a network interface 1010 connected to the system control logic 1008.

[0145] The processor 1002 can include one or more single-core or multi-core processors. The processor 1002 can include any combination of general-purpose processors and dedicated processors (e.g., graphics processors, application processors, baseband processors, etc.). In implementations herein, the processor 1002 can be configured to perform the aforementioned method for financial service confirmation.

[0146] In some implementations, the system control logic 1008 can include any suitable interface controllers to provide for any suitable interface to at least one of the processors 1002 and / or any suitable device or component in communication with the system control logic 1008.

[0147] In some implementations, the system control logic 1008 can include one or more memory controllers to provide an interface to the system memory 1004. The system memory 1004 can be used to load and store data and / or instructions. In some implementations, the system memory 1004 of the electronic device can include any suitable volatile memory, such as suitable dynamic random access memory (DRAM).

[0148] The NVM / memory 1006 can include one or more tangible, non-transitory computer-readable media for storage of data and / or instructions. In some implementations, the NVM / memory 1006 can include any suitable non-volatile storage, such as flash memory, and / or any suitable non-volatile storage device, such as at least one of a hard disk drive (HDD), a Compact Disc (CD) drive, a Digital Versatile Disc (DVD) drive.

[0149] The NVM / memory 1006 can include a portion of the storage resources installed on the device of the electronic device, or it can be accessible by the device but not necessarily a part of the device. For example, the NVM / memory 1006 can be accessed over a network via the network interface 1010.

[0150] In particular, system memory 1004 and NVM / memory 1006 can include, respectively, a temporary copy of instructions 1020 and a permanent copy of instructions 1020. Instructions 1020 can include instructions that, when executed by at least one of processors 1002, cause the electronic device to implement the aforementioned financial transaction validation method. In some implementations, instructions 1020, hardware, firmware, and / or software components thereof can additionally / alternatively be located in system control logic 1008, network interface 1010, and / or processors 1002.

[0151] Network interface 1010 can include a transceiver to provide a radio interface for the electronic device to communicate with any other suitable device (e.g., front end modules, antennas, etc.) over one or more networks. In some implementations, network interface 1010 can be integrated with other components of the electronic device. For example, network interface 1010 can be integrated with at least one of processors 1002, system memory 1004, NVM / memory 1006, and firmware devices (not shown) having instructions that, when executed by at least one of processors 1002, cause the electronic device to implement the aforementioned financial transaction validation method.

[0152] Network interface 1010 can further include any suitable hardware and / or firmware to provide a multiple-input multiple-output radio interface. For example, network interface 1010 can be a network adapter, a wireless network adapter, a telephone modem, and / or a wireless modem.

[0153] In one implementation, at least one of processors 1002 can be packaged with logic for one or more controllers of system control logic 1008 to form a System In a Package (SiP). In one implementation, at least one of processors 1002 can be integrated on the same die with logic for one or more controllers of system control logic 1008 to form a System on Chip (SoC).

[0154] The electronic device can further include an input / output (I / O) device 1012. I / O device 1012 can include a user interface to enable a user to interact with the electronic device; a peripheral component interface to enable peripheral components to interact with the electronic device. In some implementations, the electronic device also includes sensors to determine at least one of environmental conditions and location information related to the electronic device.

[0155] In some implementations, the user interface can include, but is not limited to, a display (e.g., a liquid crystal display, a touch screen display, etc.), a speaker, a microphone, one or more cameras (e.g., still image cameras and / or video cameras), a flashlight (e.g., a light emitting diode flash), and a keypad.

[0156] In some implementations, the peripheral component interface can include, but is not limited to, a non-volatile memory port, an audio jack, and a power supply interface.

[0157] In some implementations, the sensors can include, but are not limited to, a gyroscope sensor, an accelerometer, a proximity sensor, an ambient light sensor, and a positioning unit. The positioning unit can also be part of or interact with the network interface 1010 to communicate with components of a positioning network, such as Global Positioning System (GPS) satellites.

[0158] It can be appreciated that the structure illustrated in the implementations of the present application does not constitute a specific limitation on the electronic device. In other implementations of the present application, the electronic device can include more or fewer components than shown, or combine certain components, or split certain components, or different arrangement of components. The components shown can be implemented in hardware, software, or a combination of software and hardware.

[0159] The program code can be applied to input instructions to perform the functions described herein and generate output information. The output information can be applied to one or more output devices in a known manner. For the purposes of the implementations of the present application, a processing system includes any system that has a processor, such as for example a digital signal processor (DSP), a microcontroller, an application specific integrated circuit (ASIC), or a microprocessor.

[0160] The program code can be implemented in a high level procedural or object oriented programming language to communicate with a processing system. The program code can also be implemented in assembly or machine language, if desired. In fact, the mechanisms described herein are not limited in scope to any particular programming language. In any case, the language can be a compiled or interpreted language.

[0161] One or more aspects of at least one implementation can be implemented by representative instructions stored on a computer-readable storage medium that represents various logic within the processor, which when read by a machine causes the machine to fabricate logic to perform the techniques described herein. Such representations, known as "IP cores" can be stored on a tangible, computer readable storage medium and supplied to various customers or manufacturing facilities to load into the fabrication machines that make the logic or processor.

[0162] It should be noted that in the description of the figures some structural or methodological features can be shown in a particular arrangement and / or order. However, it should be understood that such a particular arrangement and / or order can not be required. Rather, in some implementations, these features can be arranged in a different manner and / or order than shown in the illustrative figures. Additionally, the inclusion of a structural or methodological feature in a particular figure is not meant to imply that such feature is needed in all implementations, and in some implementations, these features can not be included or can be combined with other features.

[0163] While the application has been illustrated and described in detail in the drawings and foregoing description, the same is to be considered as illustrative and not restrictive in character, since the application includes all modifications or equivalents covered by the scope of the claims.

Claims

1. A method of generating a statistical report, the method comprising: The method is applied to an electronic device and comprises the following steps: obtaining transaction log information and a transaction flow table from an application system, wherein the transaction log records snapshots of all transactions received and processed by the application system, and the transaction flow table comprises a platform flow table and a service flow table; traversing transaction data in the transaction log information to obtain a global event tracking number in the transaction data; if the global event tracking number exists in the transaction flow table, associating the transaction data with the transaction flow table according to the transaction flow table to obtain a complete snapshot of the transaction, and synchronizing the transaction data in the complete snapshot of the transaction to a transaction detail registration table, wherein the transaction data in the transaction detail registration table comprises a global event tracking number, a payment sub-transaction serial number, a remittance contract number, a local service ID, an outbound call service ID, a service response status, a transaction date, a working date, a remittance channel code, a message type, a remittance in-out flag code, a message debit-credit direction code, a payment clearing business type code, and a payment clearing business type code; if the global event tracking number does not exist in the transaction flow table, synchronizing the transaction data in the transaction log information to the transaction detail registration table; generating a statistical report according to the transaction data in the transaction detail registration table.

2. The method for generating statistical reports of claim 1, wherein, the transaction data of the platform flow table comprises the global event tracking number, the payment sub-transaction serial number, the remittance contract number, the local service ID, the service response status, and the transaction date; the transaction data of the service flow table comprises the global event tracking number, the payment sub-transaction serial number, the remittance contract number, the outbound call service ID, the service response status, and the transaction date; the transaction data of the contract table comprises the remittance contract number, the working date, the remittance channel code, the message type, the remittance in-out flag code, the message debit-credit direction code, the payment clearing business type code, and the payment clearing business type code.

3. The method for generating statistical reports of claim 1, wherein, the transaction data in the transaction detail registration table generates the statistical report, which comprises: generating the statistical report according to required statistical dimensions, wherein the statistical report comprises a report of upstream channel calling services of the system, a report of the situation of outbound downstream systems, and a report of the coverage of processed businesses.

4. The method for generating statistical reports of claim 3, wherein, the report of the upstream channel calling services of the system is a statistical report determined based on the local service ID and the service response status; the report of the situation of the outbound downstream systems is a statistical report determined based on the outbound call service ID and the service response status; the report of the coverage of processed businesses is a statistical report determined based on the payment clearing business type code, the payment clearing business type code, and the service response status.

5. The method for generating statistical reports of claim 1, wherein, the type of the transaction data comprises an account transaction and a non-account transaction.

6. The method for generating statistical reports of claim 5, wherein, if the global event tracking number exists in the transaction flow table, the type of the transaction data is determined as the account transaction; if the global event tracking number does not exist in the transaction flow table, the type of the transaction data is determined as the non-account transaction.

7. A statistical report generating apparatus characterized by comprising: The method comprises the following steps: a first processing module acquires transaction log information and transaction flow table from an application system, wherein the transaction log records snapshots of all transactions received and processed by the application system, and the transaction flow table comprises a platform flow table and a service party flow table; a second processing module traverses transaction data in the transaction log information to acquire a global event tracking number in the transaction data; a third processing module acquires the transaction data according to the transaction flow table if the global event tracking number exists in the transaction flow table, thereby acquiring a complete transaction snapshot, and synchronizes the transaction data in the complete transaction snapshot to a transaction detail registration table, wherein the transaction data in the transaction detail registration table comprises a global event tracking number, a payment sub-transaction serial number, a remittance contract number, a local service ID, an outbound call service ID, a service response state, a transaction date, a work date, a remittance channel code, a message type, a remittance in-out flag, a message lending direction code, a payment clearing business type code, and a payment clearing business type code; a fourth processing module synchronizes the transaction data in the transaction log information to the transaction detail registration table if the global event tracking number does not exist in the transaction flow table; a fifth processing module generates a statistical report according to the transaction data in the transaction detail registration table.

8. An electronic device, comprising: The method comprises the following steps: a memory for storing a computer program, wherein the computer program comprises program instructions; a processor for executing the program instructions to enable the electronic device to perform the method for generating a statistical report according to any one of claims 1-6.

9. A computer readable storage medium, characterized in that, The computer readable storage medium stores a computer program, wherein the computer program comprises program instructions, and the program instructions are run by an electronic device to enable the electronic device to perform the method for generating a statistical report according to any one of claims 1-6.

10. A computer program product, characterised in that, The computer program / instructions are executed by a processor to implement the method for generating a statistical report according to any one of claims 1-6.

Images