Data processing method and related device

Abstract

The present invention discloses a data processing method and related devices, wherein the method comprises: obtaining transaction flow data and intermediary business income account data from a data warehouse; performing data processing on the transaction flow data and the intermediary business income account data respectively, and obtaining corresponding intermediary business income driver data and account integration information; obtaining a parameter configuration table between the account and the driver data, and inputting the driver data, the account integration information and the parameter configuration table into a simulation engine for simulation operation to obtain an operation result, which is the amount of intermediary business income for each account; and generating intermediary business income statements of various dimensions by upward convolution with the amount of intermediary business income for each account. The present invention can solve the problem that the quality of the intermediary business income data in the prior art is low and it is difficult to meet the needs of incremental refined management.

Description

Technical Field

[0001] The present invention belongs to the field of data processing technology, and in particular, relates to a data processing method, device, equipment, storage medium and computer program product. Background Art

[0002] The refined measurement of customer-level operating income, net profit and EVA (Economic Value Added) indicators of large and medium-sized commercial banks is related to operational decisions, and the measurement of these indicators is inseparable from the refined measurement of intermediary business income.

[0003] At present, most banks can only obtain intermediary business income at the account level. The comprehensive customer analysis required for business decision-making, such as peak season customer marketing strategy and customer input-output analysis, cannot give full play to the data effect of intermediary business income. Therefore, the existing intermediary business income data is of low quality and difficult to meet the needs of incremental refined management. Summary of the invention

[0004] The embodiment of the present invention provides a data processing method and related devices, which can solve the problem that the quality of intermediary business income data in the prior art is low and it is difficult to meet the needs of incremental refined management.

[0005] In a first aspect, a data processing method is provided, comprising:

[0006] Obtain transaction flow data and intermediary business income account data from the data warehouse;

[0007] Processing the transaction flow data and the intermediary business income account data respectively to obtain intermediary business income motivation data and account integration information, wherein the account integration information includes the accumulated intermediary business income amount of all accounts under each of the accounts;

[0008] Obtaining a parameter configuration table between the subject and the driver data, and inputting the driver data, the subject integration information and the parameter configuration table into a simulation engine for simulation calculation to obtain a calculation result, wherein the calculation result is the amount of intermediary business income of each of the accounts;

[0009] The intermediary business income amount of each of the accounts is convolved upward to generate an intermediary business income report of each dimension, wherein the dimension includes transaction products, business categories, at least one of the transaction institution to which the account belongs, and the client to which the account belongs.

[0010] Optionally, the inputting of the motivation data, the subject integration information and the parameter configuration table into a simulation engine for simulation calculation to obtain a calculation result includes:

[0011] Input the motivation data, the subject integration information and the parameter configuration table into the simulation engine for a calculation to obtain a first calculation result, where the first calculation result is the unit price of the intermediary business income of each account;

[0012] The unit price of the intermediary business income of each account and the motivation data are input into the simulation engine for secondary calculation to obtain a second calculation result, which is the calculation result.

[0013] Optionally, the inputting the intermediary business income unit price of each account and the motivation data into the simulation engine for secondary calculation to obtain a second calculation result includes:

[0014] Obtaining motivation factor data corresponding to each of the accounts from the motivation data;

[0015] The driving factor data corresponding to each of the accounts and the unit price of the intermediary business income of each of the accounts are input into the multiplication operator of the simulation engine to perform a multiplication operation to obtain the second operation result.

[0016] Optionally, the driver data includes accumulated transaction data corresponding to each business category, and the driver data, the subject integration information and the parameter configuration table are input into the simulation engine for one operation to obtain a first operation result, including:

[0017] Controlling the simulation engine to read the parameter configuration table, so as to splice each of the subjects and the accumulated transaction data corresponding to the business category in the driver data mapped to each of the subjects according to the parameter configuration table, so as to form a data processing statement;

[0018] The simulation engine is controlled to execute the data processing statement, and the execution result of the data processing statement and the accumulated intermediary business income amount of all accounts under each of the subjects in the subject integration information are calculated to obtain the first calculation result.

[0019] Optionally, the intermediary business income amount of each account is convolved upward to generate an intermediary business income report of each dimension, including:

[0020] Obtain the target dimensions of the account basic data table and the intermediary business income report;

[0021] Using the target dimension as an index, searching the account basic data table for a target account containing the target dimension;

[0022] Generate the intermediary business income report based on the intermediary business income amount of the target account.

[0023] Optionally, the acquiring of transaction flow data and intermediary business income account data from the data warehouse includes:

[0024] Sending a data call request to each source system so that each source system reads the transaction flow data and intermediary business income account data corresponding to the data call request from the corresponding data warehouse;

[0025] Receive the transaction flow data and the intermediary business income account data sent by the source system.

[0026] Optionally, after generating the intermediary business income statements of each dimension, the method further includes:

[0027] Display the intermediary business income report, and / or,

[0028] The intermediary business income report is sent to the user terminal.

[0029] In a second aspect, a data processing device is provided, comprising:

[0030] The acquisition module is used to obtain transaction flow data and intermediary business income account data from the data warehouse;

[0031] A processing module, used to process the transaction flow data and the intermediary business income subject data respectively, and obtain the intermediary business income motivation data and subject integration information accordingly, wherein the subject integration information includes the accumulated intermediary business income amount of all accounts under each of the subjects;

[0032] A calculation module, used for obtaining a parameter configuration table between the account and the driver data, and inputting the driver data, the account integration information and the parameter configuration table into a simulation engine for simulation calculation to obtain a calculation result, wherein the calculation result is the amount of intermediary business income of each account;

[0033] The convolution module is used to convolve upward the intermediary business income amount of each account to generate an intermediary business income report of each dimension, wherein the dimension includes transaction products, business categories, at least one of the transaction institution to which the account belongs, and the customer to which the account belongs.

[0034] In a third aspect, a data processing device is provided, the data processing device comprising a memory, a processor, and a computer program stored in the memory and running on the processor, the computer program executing the data processing method of the first aspect.

[0035] According to a fourth aspect, a computer storage medium is provided, which implements the data processing method according to the first aspect when executed by a processor.

[0036] According to a fifth aspect, a computer program product is provided. The computer program product includes a computer program. When the computer program is executed by a processor, the data processing method according to the first aspect is implemented.

[0037] Compared with the prior art, the data processing method and related device provided in the embodiment of the present application obtain transaction flow data and intermediary business income account data from the data warehouse, and process the transaction flow data and intermediary business income account data to obtain the corresponding intermediary business income motivation data and account integration information, and then combine the parameter configuration table to input them into the simulation engine for simulation operation, so as to obtain the intermediary business income of each account, and finally convolute the amount of intermediary business income of each account upward to generate the intermediary business income report of each dimension, and the dimension includes at least one of the transaction product, business category, account-to-account transaction institution and account-to-account customer. In this way, the data related to the intermediary business income is not only the intermediary business income account data, but also provides a directional intermediary business income report for each dimension after data processing operation and convolution processing, with high data quality, which can provide guidance for business decisions, thereby meeting the needs of incremental refined management, thereby solving the problem that the quality of the intermediary business income data of the prior art is low and it is difficult to meet the needs of incremental refined management. BRIEF DESCRIPTION OF THE DRAWINGS

[0038] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for use in the embodiments of the present invention are briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0039] Figure 1 It is a schematic flow chart of an embodiment of a data processing method of the present invention.

[0040] Figure 2 It is a detailed flow chart of S120 in an embodiment of the data processing method of the present invention.

[0041] Figure 3 It is a detailed flow chart of S130 in an embodiment of the data processing method of the present invention.

[0042] Figure 4 is a schematic block diagram of a data processing device according to an embodiment of the present invention.

[0043] Figure 5 is a schematic block diagram of a data processing device according to an embodiment of the present invention. DETAILED DESCRIPTION

[0044] The features and exemplary embodiments of various aspects of the application will be described in detail below. In the detailed description below, many specific details are proposed to provide a comprehensive understanding of the application. However, it is obvious to those skilled in the art that the application can be implemented when some details in these specific details are not needed. The following description of the embodiments is only to provide a better understanding of the application by illustrating the example of the application.

[0045] It should be noted that, in the absence of conflict, the embodiments and features in the embodiments of the present application can be combined with each other. The embodiments will be described in detail below in conjunction with the accompanying drawings.

[0046] Intermediary business refers to the business of commercial banks handling payment and collection and other entrusted matters for customers and providing various financial services. When handling such business, the bank is neither a debtor nor a creditor, but is in the position of an entrusted agent, carrying out various business activities as an intermediary.

[0047] When handling such business, the income obtained by commercial banks is intermediary business income. At present, there are many types of intermediary business income. There are also many ways to charge intermediary business income. For example, when charging, cash transactions are used instead of using accounts as actual media. Such settings bring certain difficulties to subsequent measurement and analysis.

[0048] In addition, the frequency and time of charging for intermediary business income of banks are not fixed, and the charging standards are not uniform. For example, there may be exemptions or discounts for different business volumes, or the extent of exemptions and discounts may be inconsistent among branches or outlets.

[0049] In summary, it is difficult to accurately measure intermediary business income in large and medium-sized commercial banks. However, as mentioned in the background technology, the measurement of intermediary business income of commercial banks is related to customer-level operating income, net profit and EVA indicators, which in turn affects the bank's business management decisions. However, the existing technology can only provide intermediary business income at the account level, and the data quality is poor, which cannot provide effective help for incremental and refined management.

[0050] In order to solve the above problems, the present application provides a data processing method. Figure 1 In an optional embodiment, the method includes:

[0051] S110, obtaining transaction flow data and intermediary business income account data from the data warehouse;

[0052] S120, respectively processing the transaction flow data and the intermediary business income subject data to obtain intermediary business income motivation data and subject integration information, wherein the subject integration information includes the accumulated intermediary business income amount of all accounts under each subject;

[0053] S130, obtaining a parameter configuration table between the account and the driver data, and inputting the driver data, the account integration information and the parameter configuration table into a simulation engine for simulation calculation to obtain a calculation result, wherein the calculation result is the amount of intermediary business income of each account;

[0054] S140, convolute upward the intermediary business income amount of each of the accounts to generate an intermediary business income report of each dimension, wherein the dimension includes transaction products, business categories, at least one of the transaction institution to which the account belongs, and the client to which the account belongs.

[0055] The embodiment of the present application obtains transaction flow data and intermediary business income account data from a data warehouse, processes the transaction flow data and the intermediary business income account data, and obtains corresponding intermediary business income driver data and account integration information, which are then combined with a parameter configuration table and input into a simulation engine for simulation calculation, thereby obtaining the intermediary business income of each account, and finally convolving upward with the amount of intermediary business income of each account to generate intermediary business income reports of various dimensions, wherein the dimensions include at least one of transaction products, business categories, the trading institution to which the account belongs, and the customer to which the account belongs.

[0056] With such a setting, the data related to the intermediary business income is not only the intermediary business income account data, but also provides targeted intermediary business income reports for each dimension after data processing operations and convolution processing. The data quality is high and can provide guidance for business decisions, thereby meeting the needs of incremental refined management, thereby solving the problem that the intermediary business income data quality of the existing technology is low and it is difficult to meet the needs of incremental refined management.

[0057] In addition, since transaction flow data is the most detailed flow data with a huge amount of data, it is first processed by data aggregation processing and then input into the simulation engine for calculation, which improves calculation efficiency.

[0058] It should be noted that transaction flow data and intermediary business income account data can be generated by systems other than data processing equipment, among which transaction flow data can come from the business system, and intermediary business income account data can come from the general ledger system. After the data is generated, it can be copied and stored in the data warehouse for subsequent reading and calling.

[0059] Therefore, in S110, the data processing device (hereinafter referred to as the device) can directly obtain the relevant account details data required for data processing from the data warehouse. The relevant account details data includes not only transaction flow data and intermediary business income account data, but also basic account data.

[0060] Transaction flow data refers to the transaction records / transaction information of each account in each business system stored in the data warehouse. For example, transaction flow data may include financial transaction records, fund transaction records, bond transaction records, third-party payment transaction records, etc.

[0061] The intermediary business income account data refers to the intermediary business income data corresponding to each accounting account recorded by the bank's general ledger system during accounting, which records the annual cumulative amount of the intermediary business income account.

[0062] It should also be noted that, when configuring the data warehouse, it can be configured so that a single or multiple business systems correspond to one data warehouse. In an optional example, when data processing is required, a data call request can be initiated to the business system involved in the data (also known as the source system), and the data call request can include information such as the time period when the requested data was generated, the data type, and the data identifier.

[0063] Each of the source systems can, according to the data call request, read out the transaction flow data and intermediary business income account data within the generation period required to be included in the request from the data warehouse corresponding to the source system; then each source system sends the read data so that the device can receive the transaction flow data and intermediary business income account data sent by the source system.

[0064] Specifically, the device can obtain the above data through Perl scripts, which is easy to implement. On this basis, the data arrival time can be set for each source system. There are only a fixed number of source systems in a single time, such as the data arrival of one source system. When the data arrival time of any source system arrives, the corresponding Perl script is flexibly called to achieve an efficient and load-balanced processing mode.

[0065] This example implements the acquisition of data in the data warehouse, which can improve the integrity and standardization of data, is beneficial to improving the effectiveness of data, and is quick and convenient to obtain. In addition, the setting of the data warehouse does not depend on the category and number of the front-end transaction system and has good independence.

[0066] Optionally, after the data from the source system arrives, the data that has arrived can be set to be processed, and this status can be eliminated after the data has been processed.

[0067] In S120, after obtaining the intermediary business income account data and transaction flow data from the data warehouse, data processing technology can be used to integrate and process the data table. The process of processing the transaction flow data can be to integrate and classify the transaction flow data that needs to be simulated and calculated, and then form the motivation data for data processing. The motivation data is the data of bank products that affect the bank's intermediary business income.

[0068] In one example, the motivation data may include the accumulated transaction data within a certain transaction period, such as the accumulated transaction data including the accumulated transaction amount and the accumulated number of transactions. The motivation data may also include the business categories of bank products, such as the business categories including bank financial management, precious metals, etc. The integrated motivation data may also include the accumulated transaction data corresponding to each business category.

[0069] In another example, based on the above example, data-related descriptive information can be added. For example, the driver data can also include information items of the bank products to which the data belongs, and the information items can describe the bank products; the driver data can also include the transaction institutions that generate the transaction flows of the data, the source system of the current driver data, the processing frequency of the data indicators (also called the generation cycle), and so on.

[0070] It should also be noted that the above-mentioned data processing of the intermediate business income account data to obtain the account integration information is similar to the above-mentioned processing of the motivation data, and can be implemented using Perl scripts. During the optional script running process, it can also be displayed in the form of a configuration page for users to set the data objects required for data processing.

[0071] Account integration information is the accumulated intermediary business income amount within a certain transaction period, such as a fiscal year, obtained by processing the intermediary business income account data. It is also called the accumulated amount. It can include the accumulated intermediary business income amount of all accounts, and can also include the accumulated intermediary business income amount of each account.

[0072] In S130, the relationship between the subject of the intermediate business income and the driver data, that is, the parameter configuration table, can also be maintained. The parameter configuration table can reflect which subject of the intermediate business income is to be allocated according to which driver data. The user can configure and maintain the parameters in the parameter configuration table.

[0073] For example, the parameter configuration table may include a mapping between the intermediary business income account and the business category and the accumulated transaction data corresponding to the business category. The intermediary business income account may be represented by a unique identification number (also known as an account number) in the accounting account, and the accumulated transaction data may be used as a measurement indicator of the driver data.

[0074] In a specific example, the parameter configuration table may include: accounts A1 to A5 correspond to business category A, and accounts A1 to A5 also correspond to the cumulative transaction amount of business category A; accounts B1 to B3 correspond to business category B, and accounts B1 to B3 also correspond to the cumulative transaction amount of business category B; accounts C1 to C6 correspond to business category C, and accounts C1 to C6 also correspond to the cumulative transaction amount and cumulative number of transactions of business category C.

[0075] The above simulation engine can pre-set the parameter configuration table, the driving factor data and the operation relationship between the subject integration information. In an optional example, see Figure 2 , the operation process of the simulation engine, that is, S120 may include:

[0076] S221, inputting the motivation data, the account integration information and the parameter configuration table into a simulation engine for a calculation to obtain a first calculation result, where the first calculation result is the unit price of the intermediary business income of each account;

[0077] S222, inputting the unit price of the intermediary business income of each account and the motivation data into the simulation engine for secondary calculation to obtain a second calculation result, which is the calculation result.

[0078] In this example, the calculation of the intermediary business income of each account is mainly divided into two stages. The first stage is to obtain the unit price of the intermediary business income of each account, and the second stage is to obtain the intermediary business income of each account based on the unit price of the intermediary business income and the factors affecting the account's intermediary business income (i.e., the motivation of each account).

[0079] The device can control the simulation engine to read the parameter configuration table to associate the motivation data input into the simulation engine with the corresponding motivation, and then dynamically calculate the unit price of the intermediary business income of each account based on the operation relationship. The intermediary business income of a single account can be calculated by multiplying the unit price of the intermediary business income of the same account by the motivation data of the account.

[0080] Where the motivation data includes the accumulated transaction data corresponding to each business category, the process of the simulation engine performing a calculation to obtain the unit price of the intermediary business income may include:

[0081] Controlling the simulation engine to read the parameter configuration table, so as to splice each of the subjects and the accumulated transaction data corresponding to the business category in the driver data mapped to each of the subjects according to the parameter configuration table, so as to form a data processing statement;

[0082] The simulation engine is controlled to execute the data processing statement, and the execution result of the data processing statement and the accumulated intermediary business income amount of all accounts under each of the subjects in the subject integration information are calculated to obtain the first calculation result.

[0083] For example, the intermediary business income driver data and the subject integration data can be associated according to the parameter configuration table, and spliced ​​through SQL (Structured Query Language) to form a data processing statement. For example, the data processing statement can include the subject, the annual cumulative transaction amount of the business organization, and the annual cumulative number of transactions. Then, according to the subject integration information and the execution result of the data processing statement, the unit price of the intermediary business income is processed according to the organization and the subject, that is, the first operation result is obtained.

[0084] On the basis of obtaining the unit price of the intermediary business income, the driver factor data corresponding to each of the accounts can be obtained from the driver data; the driver factor data corresponding to each of the accounts and the unit price of the intermediary business income of each of the accounts are input into the multiplication operator of the simulation engine to perform a multiplication operation to obtain the second operation result.

[0085] It is understandable that different accounts execute different transactions. When processing data through transaction flow data, it is actually possible to form the driving factor data corresponding to each account for different transactions of different accounts. The combination of the driving factor data of all accounts constitutes the driving factor data.

[0086] On the basis of the unit price of the intermediary business income, the multiplication operation is performed in combination with the motivation data of each account to process the amount of intermediary business income at the account level. It should be noted that the multiplication operator here is not a simple multiplication of two numbers, but is obtained by processing each account based on the multiplication idea based on its different motivations.

[0087] For the detailed simulation calculation process of intermediary business income, the unit price of intermediary business income and the acquisition of intermediary business income can be realized based on the actual bank products and the motivation data of each account, the parameter configuration relationship, and the calculation method of the accounting industry, which will not be elaborated here.

[0088] In this example, the data execution link from data processing to obtaining the intermediary business income of each account is designed and defined, taking into account the complexity of intermediary business income, and can be flexibly configured according to the parameter configuration table, with strong adaptability and scalability. From the most fine-grained intermediary business income data at the subject level to the account level, the availability of data is improved.

[0089] In addition, after obtaining the intermediary business income amounts of all accounts, a result table of the intermediary business income amounts of all accounts can be sorted out, so that the intermediary business income amounts of required accounts can be quickly found.

[0090] It should also be noted that the above data processing and simulation engine calculation process can also be performed in sequence according to different source systems, that is, when the data in the data warehouse corresponding to the source system arrives, this part of the data is processed and the simulation engine is calculated to calculate the amount of intermediary business income of the account belonging to this part of the source system. In this way, the simulation calculation can be distributed and executed in parallel according to the data source time of the business system, thereby improving efficiency.

[0091] It is understandable that when obtaining the intermediary business income at the account level, it is still difficult to provide banks with references for operational analysis such as marketing and input-output analysis. On this basis, it is possible to convolute upward based on the account granularity to form an intermediary business income report in at least one dimension, such as customers, transaction products, transaction institutions, business categories, etc., for users to query and use.

[0092] See Figure 3 In an optional example, S130 may include:

[0093] S331, obtaining the target dimension of the account basic data table and the intermediary business income report;

[0094] S332, using the target dimension as an index, searching the account basic data table for a target account containing the target dimension;

[0095] S333, generating the intermediary business income report according to the intermediary business income amount of the target account.

[0096] It should be noted that the above-mentioned account basic data table is the data result obtained based on the account information of various business systems of the bank, including the basic information of all bank accounts. The account information can be obtained by means of Perl script processing using the account number as the unique identifier. In addition to the account number, the account basic data table also includes information such as the accounting organization department to which the account belongs and the account balance.

[0097] The generation of the account basic data table may be performed together with the data warehouse data extraction and data processing process of S110 and S120. Exemplarily, the generation of the account basic data table may include obtaining account information of all accounts from the data warehouse; performing data processing on the account information to obtain the account basic data table.

[0098] When it is necessary to convolve upward to form an intermediary business income report, the generated account basic data table can be obtained, and the target dimension of the intermediary business income report can be obtained at the same time. Exemplarily, the process of obtaining the target dimension may include: displaying a configuration page, the configuration page may include a configuration control, the configuration control is used to set the target dimension from all optional dimensions, at this time the user can generate an input to the configuration control, so that the device responds to the input, and then obtains the target dimension set by the configuration control.

[0099] The target dimension may include a single or multiple ones, which may be set by the user similar to the above process, or may be fixed. By using the target dimension as an index, the target account defined by the intermediate business report to be generated can be located, which plays a role in screening out the required target accounts, and thus the intermediate business income report of the target dimension can be generated according to the intermediate business income amount of the screened target accounts.

[0100] Subsequently, the intermediary business income report can be directly displayed on the display panel of the device, and / or can be pushed to the user terminal for the user to query and use.

[0101] This example obtains reports of various dimensions through upward convolution at the account-level granularity. It can ultimately convert the intermediary business income data at the subject level into intermediary business income report data that can be used as a reference for users, providing powerful data reference for business decisions with high data value.

[0102] Combined with the above Figures 1 to 3 , describes in detail the data processing method of the embodiment of the present application, and will be combined with Figure 4 , describes in detail the data processing device of an embodiment of the present application.

[0103] See also Figure 4 In one embodiment, the data processing device may include:

[0104] The acquisition module 410 is used to acquire transaction flow data and intermediary business income account data from the data warehouse;

[0105] A processing module 420 is used to process the transaction flow data and the intermediary business income subject data respectively, and obtain intermediary business income motivation data and subject integration information correspondingly, wherein the subject integration information includes the accumulated intermediary business income amount of all accounts under each of the subjects;

[0106] A calculation module 430 is used to obtain a parameter configuration table between the account and the driver data, and input the driver data, the account integration information and the parameter configuration table into a simulation engine for simulation calculation to obtain a calculation result, wherein the calculation result is the amount of intermediary business income of each account;

[0107] The convolution module 440 is used to convolve upward the intermediary business income amount of each account to generate an intermediary business income report of each dimension, wherein the dimension includes transaction products, business categories, at least one of the transaction institution to which the account belongs, and the customer to which the account belongs.

[0108] In an optional example, the operation module may include:

[0109] A first operation unit, used for inputting the motivation data, the subject integration information and the parameter configuration table into a simulation engine for one operation to obtain a first operation result, wherein the first operation result is a unit price of the intermediary business income of each account;

[0110] The second operation unit is used to input the unit price of the intermediary business income of each account and the motivation data into the simulation engine for secondary operation to obtain a second operation result, which is the operation result.

[0111] In another optional example, the second operation unit includes:

[0112] An acquisition subunit, used for acquiring the motivation factor data corresponding to each of the accounts from the motivation data;

[0113] The operation subunit is used to input the driving factor data corresponding to each of the accounts and the unit price of the intermediary business income of each of the accounts into the multiplication operator of the simulation engine to perform a multiplication operation to obtain the second operation result.

[0114] In another optional example, the motivation data includes accumulated transaction data corresponding to each business category, and the first operation unit includes:

[0115] A control subunit, used for controlling the simulation engine to read the parameter configuration table, so as to splice each of the subjects and the accumulated transaction data corresponding to the business category in the driver data mapped to each of the subjects according to the parameter configuration table, so as to form a data processing statement;

[0116] The operation subunit is used to control the simulation engine to execute the data processing statement, and to calculate the execution result of the data processing statement and the accumulated intermediary business income amount of all accounts under each of the subjects in the subject integration information to obtain the first operation result.

[0117] In yet another optional example, the convolution module may include:

[0118] An acquisition unit, used for acquiring a target dimension of an account basic data table and the intermediary business income report;

[0119] A search unit, configured to use the target dimension as an index to search the target account containing the target dimension from the account basic data table;

[0120] A generating unit is used to generate the intermediary business income report according to the intermediary business income amount of the target account.

[0121] In yet another optional example, the acquisition module includes:

[0122] A sending unit, used for sending a data call request to each source system, so that each source system reads the transaction flow data and intermediary business income account data corresponding to the data call request from the corresponding data warehouse;

[0123] A receiving unit is used to receive the transaction flow data and the intermediary business income account data sent by the source system.

[0124] In yet another optional example, the data processing device may further include:

[0125] A display module is used to display the intermediary business income report, and / or

[0126] The sending module is used to send the intermediary business income report to the user terminal.

[0127] Figure 5 The hardware structure diagram of the data processing device provided in the embodiment of the present application is shown. The data processing device may include a processor 501 and a memory 502 storing computer program instructions.

[0128] Specifically, the processor 501 may include a central processing unit (CPU), or an application specific integrated circuit (ASIC), or may be configured to implement one or more integrated circuits of the embodiments of the present application.

[0129] The memory 502 may include a large capacity memory for data or instructions. By way of example and not limitation, the memory 502 may include a hard disk drive (HDD), a floppy disk drive, a flash memory, an optical disk, a magneto-optical disk, a magnetic tape, or a universal serial bus (USB) drive or a combination of two or more of these. In appropriate cases, the memory 502 may include a removable or non-removable (or fixed) medium. In appropriate cases, the memory 502 may be inside or outside the integrated gateway disaster recovery device. In a specific embodiment, the memory 502 is a non-volatile solid-state memory.

[0130] The memory 502 may include a read-only memory (ROM), a flash memory device, a random access memory (RAM), a magnetic disk storage medium device, an optical storage medium device, an electrical, optical or other physical / tangible memory storage device. Thus, typically, the memory 502 includes one or more tangible (non-transitory) computer-readable storage media (e.g., a memory device) encoded with software including computer-executable instructions, and when the software is executed (e.g., by one or more processors), it is operable to perform the operations described with reference to the methods according to the above aspects of the present disclosure.

[0131] The processor 501 implements any one of the data processing methods in the above embodiments by reading and executing computer program instructions stored in the memory 502 .

[0132] In one example, the data processing device may further include a communication interface 503 and a bus 510. Figure 5 As shown, the processor 501, the memory 502, and the communication interface 503 are connected via a bus 510 and communicate with each other.

[0133] The communication interface 503 is mainly used to implement communication between various modules, devices, units and / or equipment in the embodiments of the present application.

[0134] Bus 510 includes hardware, software or both, and the parts of data processing equipment are coupled to each other. For example, but not limitation, bus may include accelerated graphics port (AGP) or other graphics bus, enhanced industrial standard architecture (EISA) bus, front side bus (FSB), hypertransport (HT) interconnection, industrial standard architecture (ISA) bus, infinite bandwidth interconnection, low pin count (LPC) bus, memory bus, micro channel architecture (MCA) bus, peripheral component interconnection (PCI) bus, PCI-Express (PCI-X) bus, serial advanced technology attachment (SATA) bus, video electronics standard association local (VLB) bus or other suitable bus or two or more of these combinations. In appropriate cases, bus 510 may include one or more buses. Although the present application embodiment describes and shows a specific bus, the application considers any suitable bus or interconnection.

[0135] The data processing device can be based on the data processing method to achieve the combination Figures 1 to 4 The data processing method and device described.

[0136] In addition, in combination with the data processing method in the above embodiments, the present application embodiment can provide a computer storage medium for implementation. The computer storage medium stores computer program instructions; when the computer program instructions are executed by a processor, any one of the data processing methods in the above embodiments is implemented.

[0137] In addition, an embodiment of the present application also provides a computer program product, including a computer program, which can implement the steps and corresponding contents of the aforementioned method embodiment when executed by a processor.

[0138] In addition, the term "and / or" in this article is only a description of the association relationship between the associated objects, indicating that there can be three relationships. For example, A and / or B can represent: A exists alone, A and B exist at the same time, and B exists alone. In addition, the character " / " in this article generally indicates that the associated objects before and after are in an "or" relationship.

[0139] It should be understood that in the embodiment of the present application, "B corresponding to A" means that B is associated with A, and B can be determined according to A. However, it should also be understood that determining B according to A does not mean determining B only according to A, and B can also be determined according to A and / or other information.

[0140] The above are only specific implementations of the present application, but the protection scope of the present application is not limited thereto. Any technician familiar with the technical field can easily think of various equivalent modifications or replacements within the technical scope disclosed in the present application, and these modifications or replacements should be included in the protection scope of the present application. Therefore, the protection scope of the present application shall be based on the protection scope of the claims.

Claims

1. A data processing method, characterized in that: include: Obtain transaction flow data and intermediary business income account data from the data warehouse; Processing the transaction flow data and the intermediary business income account data respectively to obtain intermediary business income motivation data and account integration information, wherein the account integration information includes the accumulated intermediary business income amount of all accounts under each of the accounts; Obtaining a parameter configuration table between the subject and the driver data, and inputting the driver data, the subject integration information and the parameter configuration table into a simulation engine for simulation calculation to obtain a calculation result, wherein the calculation result is the amount of intermediary business income of each of the accounts; Convolve upward the intermediary business income amount of each of the accounts to generate intermediary business income statements of various dimensions, wherein the dimensions include transaction products, business categories, and at least one of the transaction institution to which the account belongs and the client to which the account belongs; The step of inputting the motivation data, the subject integration information and the parameter configuration table into a simulation engine for simulation calculation to obtain calculation results includes: Input the motivation data, the subject integration information and the parameter configuration table into the simulation engine for a calculation to obtain a first calculation result, where the first calculation result is the unit price of the intermediary business income of each account; The unit price of the intermediary business income of each account and the motivation data are input into the simulation engine for secondary calculation to obtain a second calculation result, which is the calculation result.

2. The method according to claim 1, characterized in that The step of inputting the intermediary business income unit price of each account and the motivation data into the simulation engine for secondary calculation to obtain a second calculation result includes: Obtaining motivation factor data corresponding to each of the accounts from the motivation data; The driving factor data corresponding to each of the accounts and the unit price of the intermediary business income of each of the accounts are input into the multiplication operator of the simulation engine to perform a multiplication operation to obtain the second operation result.

3. The method according to claim 1, characterized in that The driver data includes the accumulated transaction data corresponding to each business category. The driver data, the subject integration information and the parameter configuration table are input into the simulation engine for a calculation to obtain a first calculation result, including: Controlling the simulation engine to read the parameter configuration table, so as to splice each of the subjects and the accumulated transaction data corresponding to the business category in the driver data mapped to each of the subjects according to the parameter configuration table, so as to form a data processing statement; The simulation engine is controlled to execute the data processing statement, and the execution result of the data processing statement and the accumulated intermediary business income amount of all accounts under each of the subjects in the subject integration information are calculated to obtain the first calculation result.

4. The method according to any one of claims 1 to 3, characterized in that: The intermediary business income amount of each account is convolved upward to generate intermediary business income statements of various dimensions, including: Obtain the target dimensions of the account basic data table and the intermediary business income report; Using the target dimension as an index, searching the account basic data table for a target account containing the target dimension; Generate the intermediary business income report based on the intermediary business income amount of the target account.

5. The method according to any one of claims 1 to 3, characterized in that: The acquisition of transaction flow data and intermediary business income account data from the data warehouse includes: Sending a data call request to each source system so that each source system reads the transaction flow data and intermediary business income account data corresponding to the data call request from the corresponding data warehouse; Receive the transaction flow data and the intermediary business income account data sent by the source system.

6. The method according to any one of claims 1 to 3, characterized in that: After generating the intermediary business income statements of each dimension, the method further includes: Display the intermediary business income report, and / or, The intermediary business income report is sent to the user terminal.

7. A data processing device, characterized in that: The device comprises: The acquisition module is used to obtain transaction flow data and intermediary business income account data from the data warehouse; A processing module, used to process the transaction flow data and the intermediary business income subject data respectively, and obtain the intermediary business income motivation data and subject integration information accordingly, wherein the subject integration information includes the accumulated intermediary business income amount of all accounts under each of the subjects; A calculation module, used for obtaining a parameter configuration table between the account and the driver data, and inputting the driver data, the account integration information and the parameter configuration table into a simulation engine for simulation calculation to obtain a calculation result, wherein the calculation result is the amount of intermediary business income of each account; A convolution module, configured to generate intermediary business income statements of various dimensions by upward convolution of the intermediary business income amount of each of the accounts, wherein the dimensions include transaction products, business categories, at least one of the transaction institution to which the account belongs, and the client to which the account belongs; The operation module comprises: A first operation unit, used for inputting the motivation data, the subject integration information and the parameter configuration table into a simulation engine for one operation to obtain a first operation result, wherein the first operation result is a unit price of the intermediary business income of each account; The second operation unit is used to input the unit price of the intermediary business income of each account and the motivation data into the simulation engine for secondary operation to obtain a second operation result, which is the operation result.

8. A data processing device, characterized in that: The data processing device comprises a memory, a processor, and a computer program stored in the memory and running on the processor, wherein the computer program executes the data processing method according to any one of claims 1 to 6.

9. A computer storage medium, characterized in that: When the computer storage medium is executed by a processor, the data processing method according to any one of claims 1 to 6 is implemented.

10. A computer program product, characterized in that The computer program product comprises a computer program, and when the computer program is executed by a processor, the steps of the data processing method according to any one of claims 1 to 6 are implemented.

Images