Data processing method and data processing device

Abstract

The present application provides a data processing method and a data processing device, which can improve the processing speed of data, provide users with faster query services, and improve user experience. The method includes: obtaining first data of a first time period, the first data including the identification of the first time period, the identification of a bank branch, the identification of an asset, and the amount of asset turnover; accumulating the asset turnover amounts corresponding to the identification of the same bank branch and / or the identification of the same asset in the first data, obtaining the total asset turnover amount, and obtaining second data, the second data including the identification of the bank branch and / or the identification of the asset, and the total asset turnover amount; adding a summary tag and a time tag to the second data to obtain third data; based on the identification of the bank branch and / or the identification of the asset, the summary tag and the time tag in the third data, using the total asset turnover amount to update the statistical data.

Description

Technical Field

[0001] The present application relates to the field of data processing, and in particular to a data processing method and a data processing device. Background Art

[0002] In the daily work of banking business personnel, in order to fully understand information such as product scale, they need to query relevant information by multiple dimensions such as time, institution, and product type.

[0003] However, the above-mentioned multi-dimensional information demand increases the difficulty of data processing, especially when a large amount of data is counted over a long time range. The method of directly querying the database table by relying solely on traditional page statements may result in slow page response speed or even inability to complete the information query due to timeout. Summary of the invention

[0004] The present application provides a data processing method and a data processing device, which can accumulate data within a preset time period according to different dimensions to obtain concise and efficient multi-dimensional summary data, thereby improving the data processing speed, providing users with faster query services, and improving user experience.

[0005] In a first aspect, a data processing method is provided, the method comprising: obtaining first data of a first time period, the first data comprising an identifier of the first time period, an identifier of a bank branch, an identifier of an asset, and an asset turnover amount; accumulating the asset turnover amounts corresponding to the same bank branch identifier and / or the same asset identifier in the first data to obtain a total asset turnover amount, and obtaining second data, the second data comprising an identifier of a bank branch and / or an identifier of an asset, and a total asset turnover amount; adding a summary tag and a time identifier to the second data to obtain third data, the time identifier being determined based on the summary tag and the first time period, the third data comprising an identifier of a bank branch and / or an identifier of an asset, a total asset turnover amount, a summary tag, and a time identifier, the summary tag comprising at least one of a monthly summary tag, a quarterly summary tag, a semi-annual summary tag, or an annual summary tag; based on the bank branch identifier and / or the asset identifier, the summary tag, and the time identifier in the third data, the total asset turnover amount is used to update the statistical data.

[0006] The data processing method provided in the embodiment of the present application counts the first data of the first time period according to the identification of the bank branch and / or the identification of the asset, and obtains the third data after counting to update the counted data. The method only counts the data of the first time period each time, adopts the strategy of accumulating data, updates the counted data by the data of the first time period, and finally completes the statistical task of a large amount of data, obtains concise and efficient multi-dimensional summary data, thereby improving the data processing speed. When the user queries according to business needs, it can provide the user with a faster query service, save the user's query time, improve the query response efficiency, and improve the user experience.

[0007] In combination with the first aspect, in certain implementation methods of the first aspect, the statistical data include the historical statistical bank branch identification and / or asset identification, total asset turnover amount, summary label and time identification; the statistical data is updated using the total asset turnover amount, including: for the first target data in the third data, determining whether there is a second target data in the statistical data, the bank branch identification and / or asset identification, summary label and time identification of the first target data and the second target data are the same; if the second target data exists in the statistical data, adding the total asset turnover amount in the first target data and the total asset turnover amount in the second target data to obtain the target total asset turnover amount; updating the total asset turnover amount in the second target data to the target total asset turnover amount.

[0008] In combination with the first aspect, in certain implementations of the first aspect, the method further includes: if the second target data does not exist in the counted data, adding the first target data to the counted data.

[0009] In combination with the first aspect, in certain implementations of the first aspect, the counted data also includes the asset accumulation days and the average daily amount; the method also includes: if there is second target data in the counted data, increasing the asset accumulation days in the second target data by 1; based on the target total asset liquidity amount and the updated asset accumulation days, calculating and updating the average daily amount in the second target data.

[0010] In combination with the first aspect, in certain implementations of the first aspect, the counted data also includes the cumulative days of assets and the average daily amount; the method also includes: if the second target data does not exist in the counted data, the cumulative days of assets of the first target data is set to 1; based on the total asset liquidity amount and the cumulative days of assets in the first target data, the average daily amount in the first target data is obtained.

[0011] In combination with the first aspect, in certain implementations of the first aspect, the identifier of the bank branch includes a branch code and / or a sub-branch code.

[0012] In combination with the first aspect, in certain implementations of the first aspect, the identifier of the asset includes at least one of a fund code, a fund type, or a fund company.

[0013] In combination with the first aspect, in certain implementations of the first aspect, the asset turnover amount includes at least one of the following: total asset shares, total asset amounts, total asset purchase shares, total asset purchase amounts, total asset sales shares, or total asset sales amounts.

[0014] In combination with the first aspect, in certain implementations of the first aspect, the summary label is a label for monthly summary, and the time identifier in the third data is the value of the year to which the first time period belongs and the value of the month to which the first time period belongs; or, the summary label is a label for quarterly summary, and the time identifier in the third data is the value of the year to which the first time period belongs and the value of the quarter to which the first time period belongs; or, the summary label is a label for semi-annual summary, and the time identifier in the third data is the value of the year to which the first time period belongs and the value of the half year to which the first time period belongs; or, the summary label is a label for yearly summary, and the time identifier in the third data is the value of the year to which the first time period belongs.

[0015] In a second aspect, a data processing device is provided, the device comprising: an acquisition module and a processing module. The acquisition module is used to: acquire first data of a first time period, the first data comprising an identifier of the first time period, an identifier of a bank branch, an identifier of an asset, and an asset turnover amount. The processing module is used to: accumulate the asset turnover amounts corresponding to the same bank branch identifier and / or the same asset identifier in the first data, obtain the total asset turnover amount, and obtain second data, the second data comprising the bank branch identifier and / or the asset identifier, and the total asset turnover amount; add a summary tag and a time tag to the second data, obtain third data, the time tag is determined according to the summary tag and the first time period, the third data comprising the bank branch identifier and / or the asset identifier, the total asset turnover amount, the summary tag and the time tag, the summary tag comprising at least one of a monthly summary tag, a quarterly summary tag, a semi-annual summary tag, or an annual summary tag; based on the bank branch identifier and / or the asset identifier, the summary tag and the time tag in the third data, update the statistical data using the total asset turnover amount.

[0016] In combination with the second aspect, in certain implementations of the second aspect, the statistical data include the historical statistical bank branch identification and / or asset identification, total asset turnover amount, summary label and time identification; the processing module is also used to: for the first target data in the third data, determine whether there is a second target data in the statistical data, the bank branch identification and / or asset identification, summary label and time identification of the first target data and the second target data are the same; if the second target data exists in the statistical data, add the total asset turnover amount in the first target data and the total asset turnover amount in the second target data to obtain the target total asset turnover amount; update the total asset turnover amount in the second target data to the target total asset turnover amount.

[0017] In combination with the second aspect, in some implementations of the second aspect, the processing module is further used to: if the second target data does not exist in the counted data, then add the first target data to the counted data.

[0018] In combination with the second aspect, in certain implementations of the second aspect, the statistical data also includes the cumulative days of assets and the average daily amount; the processing module is also used to: if there is second target data in the statistical data, increase the cumulative days of assets in the second target data by 1; based on the target total asset liquidity amount and the updated cumulative days of assets, calculate and update the average daily amount in the second target data.

[0019] In combination with the second aspect, in certain implementations of the second aspect, the statistical data also includes the cumulative days of assets and the average daily amount; the processing module is also used to: if the second target data does not exist in the statistical data, the cumulative days of assets of the first target data is set to 1; based on the total asset liquidity amount and the cumulative days of assets in the first target data, the average daily amount in the first target data is obtained.

[0020] In combination with the second aspect, in certain implementations of the second aspect, the identifier of the bank branch includes a branch code and / or a sub-branch code.

[0021] In combination with the second aspect, in certain implementations of the second aspect, the identifier of the asset includes at least one of a fund code, a fund type, or a fund company.

[0022] In combination with the second aspect, in certain implementations of the second aspect, the asset turnover amount includes at least one of the following: total asset shares, total asset amounts, total asset purchase shares, total asset purchase amounts, total asset sales shares, or total asset sales amounts.

[0023] In combination with the second aspect, in certain implementations of the second aspect, the summary label is a label for monthly summary, and the time identifier in the third data is the value of the year to which the first time period belongs and the value of the month to which the first time period belongs; or, the summary label is a label for quarterly summary, and the time identifier in the third data is the value of the year to which the first time period belongs and the value of the quarter to which the first time period belongs; or, the summary label is a label for semi-annual summary, and the time identifier in the third data is the value of the year to which the first time period belongs and the value of the half year to which the first time period belongs; or, the summary label is a label for yearly summary, and the time identifier in the third data is the value of the year to which the first time period belongs.

[0024] In a third aspect, another data processing device is provided, comprising a processor and a memory. The processor is used to read instructions stored in the memory to execute the method in any possible implementation of the first aspect.

[0025] Optionally, there are one or more processors and one or more memories.

[0026] Optionally, the memory may be integrated with the processor, or the memory may be provided separately from the processor.

[0027] In the specific implementation process, the memory can be a non-transitory memory, such as a read-only memory (ROM), which can be integrated with the processor on the same chip or can be set on different chips respectively. The embodiments of the present application do not limit the type of memory and the setting method of the memory and the processor.

[0028] The data processing device in the third aspect mentioned above can be a chip. The processor can be implemented by hardware or by software. When implemented by hardware, the processor can be a logic circuit, an integrated circuit, etc.; when implemented by software, the processor can be a general-purpose processor, which is implemented by reading the software code stored in the memory. The memory can be integrated in the processor or can be located outside the processor and exist independently.

[0029] In a fourth aspect, a computer-readable medium is provided, which stores a computer program (also referred to as code or instruction) which, when executed on a computer, enables the computer to execute a method in any possible implementation of any of the above aspects.

[0030] In a fifth aspect, a computer program product is provided, which includes: a computer program (also referred to as code, or instruction), which, when executed, enables a computer to execute a method in any possible implementation of the first aspect. BRIEF DESCRIPTION OF THE DRAWINGS

[0031] Figure 1 is a schematic flow chart of a data processing method provided in an embodiment of the present application;

[0032] Figure 2 This is a schematic diagram of adding summary labels and time stamps to data provided by an embodiment of the present application;

[0033] Figure 3 It is a schematic diagram of updating the statistical data provided by an embodiment of the present application;

[0034] Figure 4 is a schematic block diagram of a data processing device provided in an embodiment of the present application;

[0035] Figure 5 It is a schematic block diagram of a data processing device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0036] The technical solution in this application will be described below in conjunction with the accompanying drawings.

[0037] In the daily work of banking business personnel, in order to fully understand information such as product scale, they need to query relevant information by time, institution, product type, etc. However, this multi-dimensional information demand increases the difficulty of data processing, especially when a large amount of data is counted over a long time range. The traditional method of directly querying the database table by page statements may result in slow page response speed, or even failure to complete the information query due to timeout.

[0038] In view of this, the embodiments of the present application provide a data processing method and a data processing device, which can accumulate data within a preset time period according to different dimensions to obtain concise and efficient multi-dimensional summary data, thereby improving the data processing speed, providing users with faster query services, and improving user experience.

[0039] To facilitate understanding, the network (web) system involved in the embodiments of the present application is first introduced.

[0040] A web system is an application system that can be accessed through the web. In a web system, it generally includes two parts. One part is logic processing, such as page display, logical judgment, database access, etc.; the other part is the database, which stores the data that needs to be displayed on the page. Among them, the database is a collection of data that is stored in a computer for a long time, organized, shared, and uniformly managed.

[0041] When a user queries a page, the web system will send a request to the server. The server is responsible for querying the data in the database and displaying it on the screen for the user to view.

[0042] Figure 1 The following is a schematic flow chart of a data processing method 100 provided in an embodiment of the present application. The method 100 can be implemented by a data processing device deployed with a web system, such as a server or a computer node, which is not limited in the embodiment of the present application. The method 100 can include the following steps:

[0043] S101. Acquire first data of a first time period, where the first data includes an identifier of the first time period, an identifier of a bank branch, an identifier of an asset, and an asset turnover amount.

[0044] In a possible implementation, the first time period may be any time period less than one month, for example, one day, two days or one week.

[0045] The identifier of the first time period can be used to distinguish different time periods. For example, if the first time period is a day and the date is May 1, the identifier of the first time period can be 5.1.

[0046] The identification of a bank branch can be used to distinguish different bank branches. A bank branch can include a branch and / or a sub-branch, so the identification of a bank branch can include a sub-branch code and / or a sub-branch code. The sub-branch code can be composed of three digits and letters, for example, ABOCCNBJ260, but this embodiment of the application is not limited to this.

[0047] The identification of the asset is used to distinguish different assets. Assets may include funds, stocks, loans, etc., so the identification of the asset may include at least one of a fund code, a fund type, or a fund company.

[0048] The asset turnover amount may include at least one of the following: total asset shares, total asset amount, total asset purchase shares, total asset purchase amount, total asset sale shares, or total asset sale amount.

[0049] The asset turnover amount is the asset turnover amount of a certain asset of a certain bank branch at a certain time. Therefore, each piece of data in the above first data may include the identifier of the first time period, the identifier of the bank branch, the identifier of the asset, and the asset turnover amount.

[0050] S102. Accumulate the asset turnover amounts corresponding to the same bank branch identification and / or the same asset identification in the first data to obtain the total asset turnover amount, and obtain the second data, the second data including the bank branch identification and / or the asset identification, and the total asset turnover amount.

[0051] If there are at least two pieces of data in the first data whose bank branch identification and / or asset identification are the same, then the at least two pieces of data are merged, that is, the asset turnover amounts are accumulated to obtain the total asset turnover amount, and a piece of data is obtained. This piece of data is a piece of data in the second data, including the bank branch identification and / or asset identification, and the total asset turnover amount.

[0052] S103. Add a summary tag and a time stamp to the second data to obtain third data, where the time stamp is determined based on the summary tag and the first time period. The third data includes a bank branch ID and / or an asset ID, a total asset turnover amount, a summary tag, and a time stamp. The summary tag includes at least one of a monthly summary tag, a quarterly summary tag, a semi-annual summary tag, or an annual summary tag.

[0053] It should be understood that when the second data is summarized, it can be summarized monthly, quarterly, semi-annually or annually, so different summary labels can be added to the second data according to different summary methods. Exemplarily, the correspondence between the summary method and the summary label can be shown in Table 1. In Table 1, if the data is summarized monthly, the monthly summary label can be 01; if the data is summarized quarterly, the quarterly summary label can be 02; if the data is summarized semi-annually, the quarterly summary label can be 03; if the data is summarized annually, the quarterly summary label can be 04. It should be understood that Table 1 is only an example, and the embodiments of the present application are not limited thereto.

[0054] Table 1

[0055] Aggregation Summary Tags moon 01 Quarter 02 Half a year 03 Year 04

[0056] According to the summary label and the first time period, a time mark may be added to the second data. Exemplarily, the time mark may be YYYYMM, where YYYY represents the value of the year to which the first time period belongs, and MM may represent at least one of the value of the month to which the first time period belongs, the value of the quarter to which the first time period belongs, or the value of the half year to which the first time period belongs.

[0057] Exemplarily, if the first time period is May 1, 2021, the correspondence between the summary label and the time identifier is shown in Table 2. In Table 2, if the summary label is label 01 for monthly summary, the time identifier 202105 is used to indicate that the year to which the first time period belongs is 2021 and the month to which it belongs is May; if the summary label is label 02 for quarterly summary, the time identifier 202102 is used to indicate that the year to which the first time period belongs is 2021 and the quarter to which it belongs is the second quarter; if the summary label is label 03 for half-year summary, the time identifier 202101 is used to indicate that the year to which the first time period belongs is 2021 and the half-year to which it belongs is the first half of the year; if the summary label is label 04 for yearly summary, the time identifier is used to indicate that the year to which the first time period belongs is 2021.

[0058] Table 2

[0059] Summary Tags Time stamp 01 202105 02 202102 03 202101 04 2021

[0060] S104: Based on the bank branch identification and / or asset identification, summary tag and time identification in the third data, the total asset turnover amount is used to update the statistical data.

[0061] The statistical data may include statistical data of a time period before the first time period, or may not include any data.

[0062] If the statistical data include statistical data of the time period before the first time period, the third data of the first time period is newly added data. The bank branch identifier and / or asset identifier, summary label and time identifier in the third data can be used as summary dimensions, and the total asset turnover amount can be used to update the statistical data.

[0063] If the counted data does not include any data, the third data may be used as the counted data.

[0064] The data processing method provided in the embodiment of the present application counts the first data of the first time period according to the identification of the bank branch and / or the identification of the asset, and obtains the third data after counting to update the counted data. The method only counts the data of the first time period each time, adopts the strategy of accumulating data, updates the counted data by the data of the first time period, and finally completes the statistical task of a large amount of data, obtains concise and efficient multi-dimensional summary data, thereby improving the data processing speed. When the user queries according to business needs, it can provide the user with a faster query service, save the user's query time, improve the query response efficiency, and improve the user experience.

[0065] The above-mentioned statistical data include the identification of the bank branch and / or the identification of the asset, the total asset turnover amount, the summary label and the time mark of the historical statistics; the statistical data is updated using the total asset turnover amount, including: for the first target data in the third data, determining whether there is a second target data in the statistical data, the bank branch identification and / or the asset identification, the summary label and the time mark of the first target data and the second target data are the same; if the second target data exists in the statistical data, then the total asset turnover amount in the first target data is added to the total asset turnover amount in the second target data to obtain the target total asset turnover amount; the total asset turnover amount in the second target data is updated to the target total asset turnover amount.

[0066] If the first target data in the third data and the second target data in the counted data have the same bank branch identifier and / or the same asset identifier, the same summary label and the same time identifier, then the total asset turnover amount in the first target data is added to the total asset turnover amount in the second target data to obtain the target total asset turnover amount.

[0067] Optionally, the statistical data may also include the asset accumulation days and the average daily amount; if there is a second target data in the statistical data, the asset accumulation days in the second target data is increased by 1; based on the target total asset liquidity amount and the updated asset accumulation days, the average daily amount in the second target data is calculated and updated.

[0068] It should be understood that the average daily amount is equal to the target total asset liquidity amount divided by the updated cumulative number of days of assets.

[0069] As an optional embodiment, if the second target data does not exist in the statistical data, the first target data is added to the statistical data.

[0070] Optionally, the statistical data may also include the asset accumulation days and the average daily amount; if the second target data does not exist in the statistical data, the asset accumulation days of the first target data is set to 1; based on the total asset turnover amount and the asset accumulation days in the first target data, the average daily amount in the first target data is obtained.

[0071] It should be understood that the average daily amount is equal to the total asset turnover amount divided by the asset accumulation days.

[0072] Below, taking the fund business of the custody business as an example, the data processing method provided in the embodiment of the present application is described in detail.

[0073] In their daily work, fund-related business personnel need to conduct statistical review of fund size and fund shares by time period, asset type, fund company, etc. This application embodiment can provide fund-related business personnel with faster query services, save user query time, improve query response efficiency, and improve user experience.

[0074] Fund-related business personnel can process fund business on the web system page and save the processed fund business data in the fund balance file, which can save the total shares and total amount of each fund in each branch every day. For example, the six-tuple <branch code, branch code, date, fund code, total fund shares, total fund amount> can be used to represent the data in the file. The date can be May 1.

[0075] In this scenario, the data processing method provided in the embodiment of the present application may specifically include the following steps:

[0076] 1) The backend server of the web system can use bcp to save the data in the fund balance file to the table T_FUND_DETAIL in the database. Among them, bcp is a tool provided by Sybase Company specifically for database table data backup. The storage path of the table can be the default path of the backend server. At the same time, the table can only store the data of the day and rebuild the index to facilitate subsequent processing.

[0077] 2) The backend server can use <branch code, fund code> as the summary dimension for the data in table T_FUND_DETAIL (i.e., the first data mentioned above), accumulate the total fund shares and total fund amount corresponding to the same branch code and the same fund code in the table, obtain the accumulated total fund shares and total fund amount, and update the total fund shares and total fund amount to obtain the <branch code, fund code, total fund shares, total fund amount> four-tuple data (i.e., the second data mentioned above).

[0078] 3) The backend server can add a summary tag and a time mark to the four-tuple data to form a six-tuple data of <branch code, summary tag, time mark, fund code, total fund shares, total fund amount> (i.e., the third data mentioned above). The summary tag can include at least one of a monthly summary tag, a quarterly summary tag, a semi-annual summary tag, or an annual summary tag, so four six-tuple data can be formed, such as Figure 2 As shown. Figure 2In the data, the four-tuple data of <branch code, fund code, total fund shares, total fund amount> can form six-tuple data of <branch code, by month, 202105, fund code, total fund shares, total fund amount>, six-tuple data of <branch code, by quarter, 202102, fund code, total fund shares, total fund amount>, six-tuple data of <branch code, by half year, 202101, fund code, total fund shares, total fund amount> and six-tuple data of <branch code, by year, 2021, fund code, total fund shares, total fund amount>.

[0079] The background server may store the four six-tuple data in the T_FUND_SUM_TMP table.

[0080] 4) The backend server can update the statistical data based on the four six-tuple data. The statistical data is stored in the T_FUND_SUM table. The T_FUND_SUM table can store the seven-tuple data of <branch code, fund code, summary label, time mark, total fund amount, cumulative days, average daily amount>.

[0081] The backend server can determine whether there is data in the T_FUND_SUM table that is identical to the <branch code, fund code, summary label, time identifier> in any data in the T_FUND_SUM_TMP table (i.e., the first target data mentioned above) (i.e., the second target data mentioned above). Figure 3 As shown, if it exists, the existing data in the T_FUND_SUM table is updated, that is, the total amount of the fund is updated, and the cumulative number of days is increased by 1, and the average daily amount is calculated and updated; if it does not exist, the data is inserted into the T_FUND_SUM table, and the cumulative number of days is set to 1, and the average daily amount is calculated.

[0082] Optionally, in the front-end page, business personnel can freely set the funds under each fund type, so the fund type can be added to the above tuple data, and then the data is summarized according to the summary dimensions of <branch code, fund type, summary label, time identifier>, and the results are inserted or updated into the T_FUND_SUM_TYPE table.

[0083] Optionally, a fund company may be added to the above tuple data, and then the data is summarized according to the summary dimension of <branch code, fund company, summary label, time identifier>, and the result is inserted or updated into the T_FUND_SUM_COMP_NAME table.

[0084] The data processing method provided in the embodiment of the present application utilizes a multi-level rapid accumulation data processing method to accumulate the basic data received daily according to different dimensions based on the statistical needs of the business, thereby preparing concise and efficient multi-dimensional summary data for the multi-dimensional query function within the page. This method can directly query each accumulated result during business query, saving query time and improving query response efficiency.

[0085] 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 4 and Figure 5 , describes in detail the data processing device of an embodiment of the present application.

[0086] Figure 4 A data processing device 400 provided in an embodiment of the present application is shown. The device 400 includes: an acquisition module 410 and a processing module 420 .

[0087] The acquisition module 410 is used to: acquire first data of a first time period, the first data including the identification of the first time period, the identification of the bank branch, the identification of the asset, and the asset turnover amount. The processing module 420 is used to: accumulate the asset turnover amounts corresponding to the same bank branch identification and / or the same asset identification in the first data, obtain the total asset turnover amount, and obtain second data, the second data including the bank branch identification and / or the asset identification, and the total asset turnover amount; add a summary tag and a time tag to the second data to obtain third data, the time tag is determined according to the summary tag and the first time period, the third data including the bank branch identification and / or the asset identification, the total asset turnover amount, the summary tag and the time tag, the summary tag including at least one of a monthly summary tag, a quarterly summary tag, a semi-annual summary tag, or an annual summary tag; based on the bank branch identification and / or the asset identification, the summary tag and the time tag in the third data, update the statistical data using the total asset turnover amount.

[0088] Optionally, the statistical data include the identification of the bank branch and / or the identification of the asset, the total asset turnover amount, the summary label and the time mark of the historical statistics; the processing module 420 is also used to: for the first target data in the third data, determine whether there is a second target data in the statistical data, and the bank branch identification and / or the asset identification, the summary label and the time mark of the first target data and the second target data are the same; if the second target data exists in the statistical data, add the total asset turnover amount in the first target data and the total asset turnover amount in the second target data to obtain the target total asset turnover amount; update the total asset turnover amount in the second target data to the target total asset turnover amount.

[0089] Optionally, the processing module is further used for: if the second target data does not exist in the statistical data, then adding the first target data to the statistical data.

[0090] Optionally, the statistical data also includes the asset accumulation days and the average daily amount; the processing module 420 is also used to: if there is a second target data in the statistical data, increase the asset accumulation days in the second target data by 1; based on the target total asset liquidity amount and the updated asset accumulation days, calculate and update the average daily amount in the second target data.

[0091] Optionally, the statistical data also includes the asset accumulation days and the average daily amount; the processing module 420 is also used to: if the second target data does not exist in the statistical data, the asset accumulation days of the first target data is set to 1; based on the total asset turnover amount and the asset accumulation days in the first target data, the average daily amount in the first target data is obtained.

[0092] Optionally, the identification of the bank branch includes a branch code and / or a sub-branch code.

[0093] Optionally, the identification of the asset includes at least one of a fund code, a fund type or a fund company.

[0094] Optionally, the asset turnover amount includes at least one of the following: total asset shares, total asset amounts, total asset purchase shares, total asset purchase amounts, total asset sales shares, or total asset sales amounts.

[0095] Optionally, the summary label is a label for monthly summary, and the time identifier in the third data is the value of the year to which the first time period belongs and the value of the month to which the first time period belongs; or, the summary label is a label for quarterly summary, and the time identifier in the third data is the value of the year to which the first time period belongs and the value of the quarter to which the first time period belongs; or, the summary label is a label for semi-annual summary, and the time identifier in the third data is the value of the year to which the first time period belongs and the value of the semi-annual summary; or, the summary label is a label for yearly summary, and the time identifier in the third data is the value of the year to which the first time period belongs.

[0096] It should be understood that the device here is embodied in the form of a functional module. The term "module" here may refer to an application specific integrated circuit (ASIC), an electronic circuit, a processor (such as a shared processor, a proprietary processor or a group processor, etc.) and a memory for executing one or more software or firmware programs, a merged logic circuit and / or other suitable components that support the described functions. In an optional example, those skilled in the art can understand that the device can be specifically a data processing device in the above-mentioned embodiment, or the function of the data processing device in the above-mentioned embodiment can be integrated in the device, and the device can be used to execute the various processes and / or steps corresponding to the data processing device in the above-mentioned method embodiment. To avoid repetition, it will not be repeated here.

[0097] The above-mentioned device has the function of implementing the corresponding steps executed by the data processing device in the above-mentioned method 100; the above-mentioned function can be implemented by hardware, or by hardware executing corresponding software. The hardware or software includes one or more modules corresponding to the above-mentioned function. For example, the above-mentioned acquisition module can be a communication interface, such as a transceiver interface.

[0098] Figure 5 A data processing device 500 provided in an embodiment of the present application is shown. The device 500 includes: a processor 510, a communication interface 520 and a memory 530. The processor, the communication interface and the memory communicate with each other through an internal connection path, the memory is used to store instructions, and the processor is used to execute the instructions stored in the memory to control the communication interface to send signals and / or receive signals.

[0099] The processor 510 is used to: obtain first data of a first time period, the first data including an identifier of the first time period, an identifier of a bank branch, an identifier of an asset, and an asset turnover amount; accumulate the asset turnover amounts corresponding to the same bank branch identifier and / or the same asset identifier in the first data to obtain a total asset turnover amount, and obtain second data, the second data including an identifier of a bank branch and / or an identifier of an asset, and a total asset turnover amount; add a summary tag and a time tag to the second data to obtain third data, the time tag is determined based on the summary tag and the first time period, the third data including an identifier of a bank branch and / or an identifier of an asset, a total asset turnover amount, a summary tag, and a time tag, the summary tag including at least one of a monthly summary tag, a quarterly summary tag, a semi-annual summary tag, or an annual summary tag; based on the identifier of a bank branch and / or an asset identifier, the summary tag, and the time tag in the third data, update the statistical data using the total asset turnover amount.

[0100] It should be understood that the device 500 can be used to execute the various steps and / or processes corresponding to the data processing device in the above-mentioned method embodiment. Optionally, the memory 530 may include a read-only memory and a random access memory, and provide instructions and data to the processor. A part of the memory may also include a non-volatile random access memory. For example, the memory may also store information about the type of device. The processor 510 may be used to execute instructions stored in the memory, and when the processor 510 executes instructions stored in the memory, the processor 510 is used to execute the various steps and / or processes of the above-mentioned method embodiment corresponding to the data processing device. The communication interface 520 may include a transmitter and a receiver, the transmitter may be used to implement the various steps and / or processes corresponding to the above-mentioned communication interface for performing the sending action, and the receiver may be used to implement the various steps and / or processes corresponding to the above-mentioned communication interface for performing the receiving action.

[0101] It should be understood that in the embodiments of the present application, the processor of the above-mentioned device may be a central processing unit (CPU), and the processor may also be other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general-purpose processor may be a microprocessor or the processor may also be any conventional processor, etc.

[0102] In the implementation process, each step of the above method can be completed by an integrated logic circuit of hardware in a processor or an instruction in the form of software. The steps of the method disclosed in conjunction with the embodiment of the present application can be directly embodied as a hardware processor for execution, or a combination of hardware and software units in a processor for execution. The software unit can be located in a storage medium mature in the art such as a random access memory, a flash memory, a read-only memory, a programmable read-only memory or an electrically erasable programmable memory, a register, etc. The storage medium is located in a memory, and the processor executes the instructions in the memory, and completes the steps of the above method in conjunction with its hardware. To avoid repetition, it is not described in detail here.

[0103] The present application provides a computer-readable storage medium, which is used to store a computer program. The computer program is used to implement the data processing method shown in various possible implementations of the above embodiments.

[0104] The present application provides a chip system, which is used to support the data processing methods shown in various possible implementations in the above embodiments.

[0105] The present application provides a computer program product, which includes a computer program (also referred to as code or instruction). When the computer program runs on a computer, the computer can execute various possible data processing methods in the above embodiments.

[0106] Those of ordinary skill in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of this application.

[0107] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0108] In the several embodiments provided in the present application, it should be understood that the disclosed systems, devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0109] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0110] In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit.

[0111] If the functions are implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application can be essentially or partly embodied in the form of a software product that contributes to the prior art. The computer software product is stored in a storage medium and includes several instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods described in the various embodiments of the present application. The aforementioned storage media include: various media that can store program codes, such as USB flash drives, mobile hard disks, read-only memories (ROM), random access memories (RAM), magnetic disks or optical disks.

[0112] The above is only a specific implementation 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 changes or substitutions within the technical scope disclosed in the present application, which should be included in the protection scope of the present application. Therefore, the protection scope of the present application should be based on the protection scope of the claims.

Claims

1. A data processing method, characterized in that: include: Acquire first data of a first time period, the first data including an identifier of the first time period, an identifier of a bank branch, an identifier of an asset, and an asset turnover amount; Accumulating the asset turnover amounts corresponding to the same bank branch identifiers and / or the same asset identifiers in the first data to obtain a total asset turnover amount, thereby obtaining second data, wherein the second data includes the bank branch identifiers and / or the asset identifiers, and the total asset turnover amount; adding a summary tag and a time mark to the second data to obtain third data, wherein the time mark is determined according to the summary tag and the first time period, the third data includes an identifier of the bank branch and / or an identifier of the asset, the total asset turnover amount, the summary tag and the time mark, and the summary tag includes at least one of a monthly summary tag, a quarterly summary tag, a semi-annual summary tag or an annual summary tag; Based on the bank branch identification and / or asset identification, summary tag and time identification in the third data, the total asset turnover amount is used to update the statistical data; The statistical data include the identification of the bank branch and / or the identification of the asset, the total asset flow amount, the summary label and the time identification of the historical statistics; The updating of the statistical data by using the total asset turnover amount includes: For the first target data in the third data, determining whether there is a second target data in the counted data, the first target data and the second target data have the same bank branch identifier and / or asset identifier, summary tag, and time identifier; If the second target data exists in the statistical data, the total asset turnover amount in the first target data is added to the total asset turnover amount in the second target data to obtain the target total asset turnover amount; Updating the total asset turnover amount in the second target data to the target total asset turnover amount; If the second target data does not exist in the statistical data, then adding the first target data to the statistical data; The statistical data also includes the asset accumulation days and the average daily amount; If the second target data exists in the statistical data, the cumulative number of days of assets in the second target data is increased by 1; Calculate and update the average daily amount in the second target data based on the target total asset turnover amount and the updated asset accumulation days; If the second target data does not exist in the statistical data, the cumulative number of days of assets of the first target data is set to 1; Based on the total asset turnover amount and the asset accumulation days in the first target data, obtaining the daily average amount in the first target data; The identification of the bank branch includes a branch code and / or a sub-branch code; The identification of the asset includes at least one of a fund code, a fund type or a fund company; The asset liquidity amount includes at least one of the following: Total asset shares, total asset amount, total asset purchase shares, total asset purchase amount, total asset sales shares or total asset sales amount; The summary label is the monthly summary label, and the time identifier in the third data is the value of the year to which the first time period belongs and the value of the month to which the first time period belongs; or, The summary label is the label summarized by quarter, and the time identifier in the third data is the value of the year to which the first time period belongs and the value of the quarter to which the first time period belongs; or The summary label is the label for the half-year summary, and the time identifier in the third data is the value of the year to which the first time period belongs and the value of the half-year to which the first time period belongs; or The summary label is the label for the yearly summary, and the time identifier in the third data is the value of the year to which the first time period belongs.

2. A data processing device, characterized in that: include: An acquisition module, configured to acquire first data of a first time period, wherein the first data includes an identifier of the first time period, an identifier of a bank branch, an identifier of an asset, and an asset turnover amount; a processing module, configured to accumulate the asset turnover amounts corresponding to the same bank branch identifiers and / or the same asset identifiers in the first data to obtain a total asset turnover amount, and obtain second data, wherein the second data includes the bank branch identifiers and / or the asset identifiers, and the total asset turnover amount; adding a summary tag and a time mark to the second data to obtain third data, wherein the time mark is determined according to the summary tag and the first time period, the third data includes an identifier of the bank branch and / or an identifier of the asset, the total asset turnover amount, the summary tag and the time mark, and the summary tag includes at least one of a monthly summary tag, a quarterly summary tag, a semi-annual summary tag or an annual summary tag; Based on the bank branch identification and / or asset identification, summary tag and time identification in the third data, the total asset turnover amount is used to update the statistical data; The statistical data include the identification of the bank branch and / or the identification of the asset, the total asset flow amount, the summary label and the time identification of the historical statistics; When the processing module is used to update the statistical data using the total asset turnover amount, specifically: For the first target data in the third data, determining whether there is a second target data in the counted data, the first target data and the second target data have the same bank branch identifier and / or asset identifier, summary tag, and time identifier; If the second target data exists in the statistical data, the total asset turnover amount in the first target data is added to the total asset turnover amount in the second target data to obtain the target total asset turnover amount; Updating the total asset turnover amount in the second target data to the target total asset turnover amount; If the second target data does not exist in the statistical data, then adding the first target data to the statistical data; The statistical data also includes the asset accumulation days and the average daily amount; If the second target data exists in the statistical data, the cumulative number of days of assets in the second target data is increased by 1; Calculate and update the average daily amount in the second target data based on the target total asset turnover amount and the updated asset accumulation days; If the second target data does not exist in the statistical data, the cumulative number of days of assets of the first target data is set to 1; Based on the total asset turnover amount and the asset accumulation days in the first target data, obtaining the daily average amount in the first target data; The identification of the bank branch includes a branch code and / or a sub-branch code; The identification of the asset includes at least one of a fund code, a fund type or a fund company; The asset liquidity amount includes at least one of the following: Total asset shares, total asset amount, total asset purchase shares, total asset purchase amount, total asset sales shares or total asset sales amount; The summary label is the label for the monthly summary, and the time identifier in the third data is the value of the year to which the first time period belongs and the value of the month to which the first time period belongs; or, The summary label is the label summarized by quarter, and the time identifier in the third data is the value of the year to which the first time period belongs and the value of the quarter to which the first time period belongs; or, The summary label is the label for the half-year summary, and the time identifier in the third data is the value of the year to which the first time period belongs and the value of the half-year to which the first time period belongs; or, The summary label is the label for the yearly summary, and the time identifier in the third data is the value of the year to which the first time period belongs.

3. A data processing device, characterized in that: include: A processor is coupled to a memory, wherein the memory is used to store a computer program, and when the processor calls the computer program, the device is caused to execute the method of claim 1.

4. A chip system, characterized in that: It comprises: a processor, used to call and run a computer program from a memory, so that a device equipped with the chip system executes the method described in claim 1.

5. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is executed on a computer, the computer is caused to execute the method according to claim 1 .

6. A computer program product, characterized in that The computer program product comprises instructions which, when executed, cause the method of claim 1 to be performed.

Images