Data processing method and apparatus, and electronic device

Abstract

The application provides a data processing method and device and electronic equipment. Target index information of a target data source table is acquired first, and a linkage configuration table is generated based on the target index information. Then, unique identification information of each index in the linkage configuration table is acquired, and a linkage result table is generated based on the unique identification information of each index in the linkage configuration table and the caliber of each index. After that, a front-end data report is generated based on the linkage result table. Modification of the linkage configuration table triggers updating of the front-end data report. The application can alleviate the technical problems of low modification efficiency and poor modification accuracy in the existing data report modification method.

Description

Technical Field

[0001] This invention relates to the field of computer technology, and in particular to a data processing method, apparatus, and electronic device. Background Technology

[0002] Data reports are used to collect, manage, and analyze data from all aspects of a company. They can save companies labor costs, ensure the effective operation of data management, and provide decision support for business operators and managers. Therefore, the accuracy of report data is particularly important, especially the accuracy of KPIs related to revenue and costs, which is even more crucial for a company.

[0003] Data reports typically contain various metrics (such as the number of transactions and transaction amount), and each metric can contain various calculation factors (such as the number of commercial bill transactions, the number of bank bill transactions, the daily transaction amount, and the daily number of users). Different metrics may contain all of the same calculation factors or some of them. When it is necessary to modify the metrics of multiple data reports (such as adding new metrics or deleting existing metrics), existing technologies usually involve modifying multiple data source tables in the background and refreshing historical data after modification, or performing formula calculations on the dataset of the front-end data report. However, both of these methods require manual modification of different data tables individually, resulting in low modification efficiency, poor accuracy, and a high risk of errors and omissions. This problem is particularly serious when there are many data source tables or when relevant personnel are unfamiliar with the reports. Summary of the Invention

[0004] In view of this, the purpose of the present invention is to provide a data processing method, apparatus and electronic device to alleviate the technical problems of low modification efficiency and poor modification accuracy in existing data report modification methods.

[0005] In a first aspect, embodiments of the present invention provide a data processing method, the method comprising: acquiring target indicator information from a target data source table, and generating a linkage configuration table based on the target indicator information; wherein the target indicator information includes multiple indicators and all calculation factors corresponding to each indicator; the target data source table is a business data report corresponding to a target business in a pre-established data warehouse; each indicator has its own unique identifier information in the linkage configuration table; acquiring the unique identifier information of each indicator in the linkage configuration table, and generating a linkage result table based on the unique identifier information of each indicator in the linkage configuration table and the caliber of each indicator; wherein the caliber characterizes the definition of the indicator and the correspondence between the indicator and the data in the target data source table; generating a front-end data report based on the linkage result table; and updating the front-end data report with the data corresponding to the modification operation in response to a modification operation on the linkage configuration table.

[0006] As one possible implementation, the plurality of indicators includes at least one of the following: atomic indicators, derived indicators, and derived indicators; wherein, atomic indicators are basic indicators corresponding to the target business; derived indicators are generated based on one or more atomic indicators and one or more dimension fields corresponding to the target business; derived indicators are generated based on one or more atomic indicators, or based on one or more derived indicators; the step of obtaining target indicator information from the target data source table and generating a linkage configuration table based on the target indicator information includes: dividing the plurality of indicators into multiple categories according to a preset classification rule, and assigning corresponding unique identification information to each category; wherein, the unique identification information includes a category code and / or a category name.

[0007] As one possible implementation, the steps of dividing the multiple indicators into multiple categories according to preset classification rules and assigning corresponding unique identification information to each category include: taking each atomic indicator in the target indicator information as a primary category, taking each derived indicator or derivative indicator in the target indicator information as a secondary category, dividing each secondary category into one or more tertiary categories according to custom rules; and assigning corresponding unique identification information to each primary category, each secondary category, and each tertiary category.

[0008] As one possible implementation, the step of generating a linkage result table based on the unique identifier information of each indicator in the linkage configuration table and the definition of each indicator includes: periodically obtaining the data corresponding to each indicator in the target data source table according to the definition of each indicator; and mapping the unique identifier information of each indicator in the linkage configuration table and the data corresponding to each indicator in the target data source table to the linkage result table.

[0009] As one possible implementation, the step of generating a front-end data report based on the linkage result table includes: taking the data in the linkage result table corresponding to the unique identifier information of the target indicator in the linkage configuration table as the target data; and generating a front-end data report based on the target data according to a preset report template.

[0010] As one possible implementation, the modification operation is to delete or add an indicator.

[0011] As one possible implementation, if the modification operation is to delete an indicator, the step of updating the front-end data report with the data corresponding to the modification operation in response to the modification operation of the linkage configuration table includes: obtaining the unique identifier information of the target indicator corresponding to the modification operation in the linkage configuration table, and assigning a deletion identifier to the first specified data corresponding to the unique identifier information in the linkage configuration table; wherein, the deletion identifier indicates that the first specified data is invalid; searching the linkage result table based on the unique identifier information to determine the second specified data corresponding to the unique identifier information in the linkage result table, and invalidating the second specified data, thereby updating the linkage result table; updating the front-end data report with the updated linkage result table to obtain the updated front-end data report.

[0012] As one possible implementation, if the modification operation is to add a new indicator, the step of updating the front-end data report with the data corresponding to the modification operation in response to the modification operation of the linkage configuration table includes: adding a new indicator to the linkage configuration table and assigning corresponding unique identification information to the new indicator; obtaining the third specified data corresponding to the new indicator in the target data source table, and mapping the unique identification information of the new indicator in the linkage configuration table and the third specified data to the linkage result table, thereby updating the linkage result table; and updating the front-end data report with the updated linkage result table to obtain the updated front-end data report.

[0013] Secondly, embodiments of the present invention also provide a data processing apparatus, the apparatus comprising: a configuration module, configured to acquire target indicator information from a target data source table and generate a linkage configuration table based on the target indicator information; wherein the target indicator information includes multiple indicators and all calculation factors corresponding to each indicator; the target data source table is a business data report corresponding to a target business in a pre-established data warehouse; each indicator has its own unique identifier information in the linkage configuration table; a first generation module, configured to acquire the unique identifier information of each indicator in the linkage configuration table and generate a linkage result table based on the unique identifier information of each indicator in the linkage configuration table and the caliber of each indicator; wherein the caliber characterizes the definition of the indicator and the correspondence between the indicator and the data in the target data source table; a second generation module, configured to generate a front-end data report based on the linkage result table; and an update module, configured to update the front-end data report with the data corresponding to the modification operation in response to a modification operation on the linkage configuration table.

[0014] Thirdly, embodiments of the present invention also provide an electronic device, including a processor and a memory, wherein the memory stores computer-executable instructions that can be executed by the processor, and the processor executes the computer-executable instructions to implement the above-described data processing method.

[0015] This invention provides a data processing method, apparatus, and electronic device. First, target indicator information from a target data source table is obtained, and a linkage configuration table is generated based on this information. Then, unique identifier information for each indicator in the linkage configuration table is obtained, and a linkage result table is generated based on this unique identifier and the definition of each indicator. Finally, a front-end data report is generated based on the linkage result table. Modifications to the linkage configuration table trigger updates to the front-end data report. Using this technology, when business changes necessitate report modifications, only the linkage configuration table needs to be modified to achieve synchronous updates of related reports. This effectively avoids incorrect and / or missed report modifications, reduces the workload of report modifications, saves resources, and significantly improves the quality of report data. This alleviates the technical problems of low modification efficiency and poor accuracy in existing data report modification methods.

[0016] Other features and advantages of the invention will be set forth in the description which follows, and will be apparent in part from the description, or may be learned by practicing the invention. The objects and other advantages of the invention are realized and obtained in accordance with the structures particularly pointed out in the description, claims and drawings.

[0017] To make the above-mentioned objects, features and advantages of the present invention more apparent and understandable, preferred embodiments are described below in detail with reference to the accompanying drawings. Attached Figure Description

[0018] To more clearly illustrate the specific embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the specific embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present invention. For those skilled in the art, other drawings can be obtained from these drawings without creative effort.

[0019] Figure 1 This is a flowchart illustrating a data processing method according to an embodiment of the present invention;

[0020] Figure 2 This is an example diagram of an indicator factor linkage configuration table in an embodiment of the present invention;

[0021] Figure 3 This is an example diagram of an indicator factor linkage result table in an embodiment of the present invention;

[0022] Figure 4 This is an example diagram of generating a front-end data report based on the indicator factor linkage result table in an embodiment of the present invention;

[0023] Figure 5This is another example diagram of generating a front-end data report based on the indicator factor linkage result table in an embodiment of the present invention;

[0024] Figure 6 This is a schematic diagram of the structure of a data processing device according to an embodiment of the present invention;

[0025] Figure 7 This is a schematic diagram of the structure of an electronic device according to an embodiment of the present invention. Detailed Implementation

[0026] To make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the technical solutions of the present invention will be clearly and completely described below in conjunction with the embodiments. Obviously, the described embodiments are only some embodiments of the present invention, not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0027] Currently, existing methods for modifying data reports typically involve modifying multiple data source tables in the background and then refreshing historical data, or performing formula calculations on the dataset in the front-end data report. However, both of these methods require manual modification of different data tables individually, resulting in low efficiency, poor accuracy, and a high risk of errors and omissions. This problem is particularly severe when there are many data source tables or when personnel are unfamiliar with the reports. Therefore, this invention provides a data processing method, apparatus, and electronic device that can alleviate the technical problems of low efficiency and poor accuracy in existing data report modification methods.

[0028] To facilitate understanding of this embodiment, a data processing method disclosed in this invention will first be described in detail, see [link to relevant documentation]. Figure 1 The diagram shown illustrates a data processing method that may include the following steps:

[0029] Step S102: Obtain the target indicator information from the target data source table and generate a linkage configuration table based on the target indicator information; wherein, the target indicator information includes multiple indicators and all calculation factors corresponding to each indicator; the target data source table is a business data report corresponding to the target business in a pre-established data warehouse; each indicator has its own unique identifier information in the linkage configuration table.

[0030] For a specific business, the business platform records the corresponding business data when the business occurs. Taking transaction business as an example, the business platform records the corresponding transaction details when a transaction occurs, such as the transaction name, transaction time, and transaction volume of each transaction. A data warehouse can be built in advance. For each business, relevant personnel can process the business data corresponding to the business into business data reports and store the business data reports as the data source table of the business in the data warehouse.

[0031] A data warehouse typically stores multiple data source tables, each containing multiple metrics, and each metric containing multiple calculation factors. For example, a metric might be the total number of transactions per day, with calculation factors including the number of commercial paper transactions and bank draft transactions per day. Another example is a metric might be the average daily transaction amount per user, with calculation factors including the daily transaction amount and the number of users making transactions per day. The number of target data source tables can be one or more. Multiple metrics and all corresponding calculation factors for each metric can be obtained from a pre-established data warehouse, and a unique identifier is assigned to each metric. Then, the multiple metrics and all corresponding calculation factors of the target data source tables are used as target metric information, and the target metric information and the unique identifier information for each metric are mapped to a linked configuration table.

[0032] The aforementioned unique identification information may include code, name, remarks, etc., and can be customized according to needs; there are no restrictions on this.

[0033] Step S104: Obtain the unique identifier information of each indicator in the linkage configuration table, and generate a linkage result table based on the unique identifier information of each indicator in the linkage configuration table and the definition of each indicator; wherein, the definition represents the definition of the indicator and the correspondence between the indicator and the data in the target data source table.

[0034] For each metric, the metric's definition essentially defines its data retrieval logic—that is, how the data corresponding to the metric is selected from the target data source table. Given that the definition of each metric is known, data warehouse tools (such as Hive) can be used to retrieve the data corresponding to each metric in the target data source table from the aforementioned data warehouse according to the defined definition. The unique identifier information of each metric in the aforementioned linkage configuration table and the corresponding data in the target data source table are then mapped to a linkage result table. Since the definition of each metric can be customized according to requirements, the data corresponding to each metric in the linkage result table can also be customized accordingly. For example, the data corresponding to each metric may include a sequence number, statistical date, and result value.

[0035] Step S106: Generate a front-end data report based on the linkage result table.

[0036] After obtaining the linkage result table, the required data can be determined based on the unique identifier information of each indicator in the linkage result table, and the data can be processed into a front-end data report according to a custom format and displayed through the front end.

[0037] Step S108: In response to the modification operation on the linkage configuration table, update the front-end data report with the data corresponding to the modification operation.

[0038] Since the data in the front-end data reports all come from the linkage result table, when the business needs to modify one or more indicators, it can modify the data corresponding to the corresponding indicators in the linkage configuration table, determine the unique identifier information corresponding to the modified indicator from the linkage configuration table, and then update the data in the linkage result table corresponding to the determined unique identifier information, thereby changing the corresponding statistical results in the front-end data table to achieve the update of the front-end data table.

[0039] For example, the linkage configuration table might contain metrics such as the number of commercial bill transactions and the number of bank draft transactions. If the business needs to add a financial draft, they can add a financial draft transaction count metric and its corresponding unique code to the linkage configuration table. Then, they can traverse the data warehouse to retrieve the data corresponding to this metric in the data source table, and map the unique code and the corresponding data in the target data source table to the newly added data in the linkage result table. This ensures that the statistical results in the front-end data table for calculating the total number of transactions include the financial draft transaction count. Continuing the previous example, if the business needs to delete the number of commercial bill transactions, they can delete the data corresponding to the unique code of the commercial bill transaction count in the linkage configuration table, and subsequently delete the data corresponding to that unique code in the linkage result table. This ensures that the statistical results in the front-end data table for calculating the total number of transactions do not include the commercial bill transaction count. Continuing from the previous example, if the business needs to delete the number of commercial bill transactions, it can also invalidate the data corresponding to the unique code of the number of commercial bill transactions in the linkage configuration table. This will prevent the invalid data corresponding to the unique code in the linkage result table from participating in the statistics of the total number of transactions in the front end, so that the statistical results in the front end data table that counts the total number of transactions do not include the number of commercial bill transactions.

[0040] This invention provides a data processing method that first obtains target indicator information from a target data source table and generates a linkage configuration table based on the target indicator information. Then, it obtains the unique identifier information for each indicator in the linkage configuration table and generates a linkage result table based on the unique identifier information and the definition of each indicator. Finally, it generates a front-end data report based on the linkage result table. Modifications to the linkage configuration table trigger updates to the front-end data report. Using this technology, when business changes require report modifications, only the linkage configuration table needs to be modified to achieve synchronous updates of related reports. This effectively avoids incorrect and / or missed report modifications, reduces the workload of report modification, saves resources, and significantly improves the quality of report data, thereby alleviating the technical problems of low modification efficiency and poor modification accuracy in existing data report modification methods.

[0041] As one possible implementation, the aforementioned multiple indicators may include at least one of the following: atomic indicators, derived indicators, and derivative indicators; wherein, atomic indicators are basic indicators corresponding to the target business, such as the number of transactions and transaction amount; derived indicators are generated based on one or more atomic indicators and one or more dimension fields corresponding to the target business, such as the number of commercial bill transactions and the number of bank bill transactions; derivative indicators are generated based on one or more atomic indicators, or based on one or more derived indicators, such as the average number of transactions and the average commercial bill transaction amount. Based on this, the aforementioned step S102 (i.e., obtaining the target indicator information from the target data source table and generating a linkage configuration table based on the target indicator information) may include the following operation: dividing multiple indicators into multiple categories according to preset classification rules, and assigning corresponding unique identification information to each category; wherein, the unique identification information includes a category code and / or a category name.

[0042] For example, each atomic indicator in the target indicator information can be treated as a primary category, and each derived or variant indicator in the target indicator information can be treated as a secondary category. Each secondary category can then be further divided into one or more tertiary categories according to custom rules. Corresponding unique identifiers can then be assigned to each primary category, each secondary category, and each tertiary category. For example... Figure 2The indicator factor linkage configuration table shown (i.e., the linkage configuration table mentioned above) has three primary categories, each with classification codes A, B, and C, and classification names User Category, Transaction Volume Category, and Revenue Category, respectively. The table has four secondary categories, each with classification codes A01, B01, C01, and C02, and classification names Platform Users, Transaction Volume, Direct Transaction Revenue, and Value-Added Service Revenue, respectively. The table also has ten tertiary categories, each with classification codes A01_01, B01_01, C01_01, C01_01_01, C01_01_02, C02_01, C02_01_01, C02_01_02, C02_01_03, and C02_01_04, and classification names Indicator 1, Indicator 1, Indicator 1, Indicator 1_Factor 1, Indicator 1_Factor 2, Indicator 1, Indicator 1_Factor 1, Indicator 1_Factor 2, Indicator 1_Factor 3, and Indicator 1_Factor 4, respectively.

[0043] By adopting the above operating method, the relevant equipment can directly and accurately determine the corresponding indicators and obtain the corresponding data based on the unique identification information, which further improves the accuracy and efficiency of the relevant equipment in obtaining relevant data from the linkage configuration table.

[0044] As one possible implementation, the steps of generating a linkage result table based on the unique identifier information of each indicator in the linkage configuration table and the definition of each indicator may include the following operations: periodically obtaining the data corresponding to each indicator in the target data source table according to the definition of each indicator; mapping the unique identifier information of each indicator in the linkage configuration table and the data corresponding to each indicator in the target data source table into a linkage result table.

[0045] For example, the data warehouse already contains data source tables for various business operations. A script can be written to retrieve all calculated factors for each metric and the corresponding data for each factor from the data warehouse daily using Hive, according to the definition of each metric. Then, the unique identifier information of each metric in the linkage configuration table and the corresponding data in the target data source table are mapped in column form to create a metric factor linkage result table. For example... Figure 3 The indicator factor linkage result table shown (i.e., the linkage result table mentioned above) contains the serial number, statistical date, and indicator factor code (as described above) for each calculated factor (also called the indicator factor). Figure 2 The classification codes for the three levels of classification are the same), and the names of the indicator factors are the same as those mentioned above. Figure 2The three levels of classification have the same classification name, result value, and remarks information. For example, if the indicator is the number of commercial bill transactions, the data warehouse already has a wide table of daily transactions (i.e., the data source table). This table contains all transaction information for the day. The definition of the number of commercial bill transactions includes: transaction time as of the current day and bill type as commercial bill. The specific implementation of the script can be a stored procedure, or a Python or shell script. The script can be run through Hive to execute the steps of retrieving the corresponding data from the wide table of daily transactions according to the definition of the number of commercial bill transactions.

[0046] The above operating method further improves the convenience of generating the linkage result table.

[0047] As one possible implementation, step S106 (i.e., generating a front-end data report based on the linkage result table) may include the following operation: taking the data in the linkage result table corresponding to the unique identifier information of the target indicator in the linkage configuration table as the target data; and generating a front-end data report based on the target data and a preset report template.

[0048] For example, since the format of the front-end data report is determined by the corresponding statistical purpose, report templates corresponding to different statistical purposes can be pre-set. After determining the unique identifier information of the target indicator in the linkage configuration table, the data corresponding to the determined unique identifier information in the linkage result table can be used as the target data, and the target data can be filled into a suitable preset report template to generate the corresponding front-end data report. Figure 3 ,by Figure 4 For example, to statistically analyze revenue from value-added services, one can start from... Figure 3 The linked results table shows the data in rows 7-10 as target data, which is then filled into the template of the value-added service revenue table to obtain the corresponding front-end data table (i.e., Figure 4 (Value-added services revenue statement in the table). Based on Figure 3 ,by Figure 5 For example, to compile an overview of business operations, one can start from... Figure 3 The linked results table shows the data in rows 1-3 and 6 as target data. This target data is then entered into the template of the business overview table to obtain the corresponding front-end data table (i.e., ...). Figure 5 The operational overview table (in the database) contains statistics on total users, total transaction volume, and total revenue. To analyze service revenue data, one can refer to... Figure 3 The linked results table shows the data in rows 7 and 9 selected as target data. This target data is then entered into the template of the data service revenue table to obtain the corresponding front-end data table (i.e., ...). Figure 5 (Data service revenue table in China).

[0049] By adopting the above operating method, the accuracy and efficiency of generating front-end data reports are further improved.

[0050] As one possible implementation, the above modification operation can be either deleting or adding an indicator. Exemplary descriptions are provided below for the cases where the modification operation is deleting an indicator and the cases where the modification operation is adding an indicator.

[0051] (1) If the above modification operation is to delete an indicator, the above step S108 (i.e., in response to the modification operation on the linkage configuration table, update the front-end data report with the data corresponding to the modification operation) may include the following operation: obtain the unique identifier information of the target indicator corresponding to the modification operation in the linkage configuration table, and assign a deletion identifier to the first specified data corresponding to the unique identifier information in the linkage configuration table; wherein, the deletion identifier indicates that the first specified data is invalid; search the linkage result table based on the unique identifier information to determine the second specified data corresponding to the unique identifier information in the linkage result table, and invalidate the second specified data, thereby realizing the update of the linkage result table; update the front-end data report with the updated linkage result table to obtain the updated front-end data report.

[0052] For example Figure 2 , Figure 3 and Figure 5 If the business side needs to delete platform user metrics, it can provide... Figure 2 The data in the row containing category code A01_01 in the linked configuration table shown (i.e., the first specified data) is assigned a deletion flag indicating that the data is invalid; use A01_01 to search Figure 3 The linked result table shown determines the data in the row containing indicator factor code A01_01 (i.e., the second specified data) and invalidates the second specified data; since invalid data in the linked result table does not participate in the statistics of the front-end business overview, the front-end data table for statistics of the business overview (i.e. Figure 5 The statistics in the business overview table only include total transaction volume and total revenue, but do not include the total number of users.

[0053] (2) If the above modification operation is to add a new indicator, the above step S108 (i.e., in response to the modification operation on the linkage configuration table, update the front-end data report with the data corresponding to the modification operation) may include the following operation: add a new indicator to the linkage configuration table and assign a corresponding unique identifier to the new indicator; obtain the third specified data corresponding to the new indicator in the target data source table, and map the unique identifier information and the third specified data of the new indicator in the linkage configuration table to the linkage result table, thereby realizing the update of the linkage result table; update the front-end data report with the updated linkage result table to obtain the updated front-end data report.

[0054] For example Figure 2 , Figure 3 and Figure 5 If the business needs to increase the revenue from value-added services, in Figure 2 The linked configuration table shown adds a new value-added service revenue indicator and assigns a corresponding new classification code and new classification name to it. The new classification codes include a first-level classification code, a second-level classification code, and a third-level classification code (C, C02, and C02_01_05, respectively). The new classification names include a first-level classification name, a second-level classification name, and a third-level classification name (revenue category, value-added service revenue, and indicator 1_factor 5, respectively). The data (i.e., the third specified data) corresponding to the new value-added service revenue indicator is obtained from the data source table of this business according to the definition of the new value-added service revenue indicator. The third-level classification code, the third-level classification name, and the third specified data of the new value-added service revenue indicator are then mapped as a new row to... Figure 3 The linked result table shown is updated accordingly; since the newly added data in this linked result table will be included in the statistics of front-end data service revenue, the front-end data table showing the statistical data service revenue (i.e., Figure 5 The statistics in the data service revenue table include this additional portion of new value-added service revenue.

[0055] Based on the above data processing method, this embodiment of the invention also provides a data processing apparatus, see [link to relevant documentation]. Figure 6 As shown, the device may include the following modules:

[0056] The configuration module 602 is used to obtain target indicator information from the target data source table and generate a linkage configuration table based on the target indicator information; wherein, the target indicator information includes multiple indicators and all calculation factors corresponding to each indicator; the target data source table is a business data report corresponding to the target business in a pre-established data warehouse; each indicator has its own unique identifier information in the linkage configuration table.

[0057] The first generation module 604 is used to obtain the unique identification information of each indicator in the linkage configuration table, and generate a linkage result table based on the unique identification information of each indicator in the linkage configuration table and the caliber of each indicator; wherein, the caliber represents the definition of the indicator and the correspondence between the indicator and the data in the target data source table.

[0058] The second generation module 606 is used to generate a front-end data report based on the linkage result table.

[0059] The update module 608 is used to update the front-end data report with the data corresponding to the modification operation in response to the modification operation of the linkage configuration table.

[0060] This invention provides a data processing apparatus that first acquires target indicator information from a target data source table and generates a linkage configuration table based on the target indicator information. Then, it acquires the unique identifier information for each indicator in the linkage configuration table and generates a linkage result table based on the unique identifier information and the definition of each indicator. Finally, it generates a front-end data report based on the linkage result table. Modifications to the linkage configuration table trigger updates to the front-end data report. Using this technology, when business changes require report modifications, only the linkage configuration table needs to be modified to achieve synchronous updates of related reports. This effectively avoids incorrect and / or missed report modifications, reduces the workload of report modification, saves resources, and significantly improves the quality of report data, thereby alleviating the technical problems of low modification efficiency and poor modification accuracy in existing data report modification methods.

[0061] The aforementioned multiple indicators may include at least one of the following: atomic indicators, derived indicators, and derived indicators; wherein, atomic indicators are the basic indicators corresponding to the target business; derived indicators are generated based on one or more atomic indicators and one or more dimension fields corresponding to the target business; derived indicators are generated based on one or more atomic indicators, or based on one or more derived indicators; based on this, the configuration module 602 may also be used to: divide the multiple indicators into multiple categories according to preset classification rules, and assign corresponding unique identification information to each category; wherein, the unique identification information includes a category code and / or a category name.

[0062] The configuration module 602 described above can also be used to: classify each atomic indicator in the target indicator information as a primary category, classify each derived indicator or derivative indicator in the target indicator information as a secondary category, divide each secondary category into one or more tertiary categories according to custom rules, and assign corresponding unique identifier information to each primary category, each secondary category and each tertiary category.

[0063] The first generation module 604 described above can also be used to: periodically obtain the data corresponding to each indicator in the target data source table according to the definition of each indicator; and map the unique identifier information of each indicator in the linkage configuration table and the data corresponding to each indicator in the target data source table into the linkage result table.

[0064] The second generation module 606 described above can also be used to: take the data in the linkage result table corresponding to the unique identifier information of the target indicator in the linkage configuration table as the target data; and generate a front-end data report based on the target data and a preset report template.

[0065] The above modification operations can be used to delete or add indicators.

[0066] If the above modification operation is to delete an indicator, the update module 608 can also be used to: obtain the unique identifier information of the target indicator corresponding to the modification operation in the linkage configuration table, and assign a deletion identifier to the first specified data corresponding to the unique identifier information in the linkage configuration table; wherein, the deletion identifier indicates that the first specified data is invalid; search the linkage result table based on the unique identifier information to determine the second specified data corresponding to the unique identifier information in the linkage result table, and invalidate the second specified data, thereby updating the linkage result table; update the front-end data report with the updated linkage result table to obtain the updated front-end data report.

[0067] If the above modification operation is to add a new indicator, the update module 608 can also be used to: add a new indicator to the linkage configuration table and assign a corresponding unique identifier to the new indicator; obtain the third specified data corresponding to the new indicator in the target data source table, and map the unique identifier of the new indicator in the linkage configuration table and the third specified data to the linkage result table, thereby updating the linkage result table; update the front-end data report with the updated linkage result table to obtain the updated front-end data report.

[0068] The data processing apparatus provided in this embodiment of the invention has the same implementation principle and technical effects as the aforementioned data processing method embodiment. For the sake of brevity, any parts not mentioned in the apparatus embodiment can be referred to the corresponding content in the aforementioned method embodiment.

[0069] This invention also provides an electronic device, such as... Figure 7 The diagram shows the structure of the electronic device 100, which includes a processor 71 and a memory 70. The memory 70 stores computer-executable instructions that can be executed by the processor 71. The processor 71 executes the computer-executable instructions to implement the above-mentioned data processing method.

[0070] exist Figure 7 In the illustrated embodiment, the electronic device further includes a bus 72 and a communication interface 73, wherein the processor 71, the communication interface 73, and the memory 70 are connected via the bus 72.

[0071] The memory 70 may include high-speed random access memory (RAM) or non-volatile memory, such as at least one disk storage device. Communication between this system network element and at least one other network element is achieved through at least one communication interface 73 (which can be wired or wireless), such as the Internet, wide area network, local area network, metropolitan area network, etc. The bus 72 may be an ISA (Industry Standard Architecture) bus, a PCI (Peripheral Component Interconnect) bus, or an EISA (Extended Industry Standard Architecture) bus, etc. The bus 72 can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, Figure 7 The symbol is represented by a single double-headed arrow, but this does not mean that there is only one bus or one type of bus.

[0072] Processor 71 may be an integrated circuit chip with signal processing capabilities. In implementation, each step of the above method can be completed by the integrated logic circuitry in the hardware of processor 71 or by software instructions. The processor 71 can be a general-purpose processor, including a Central Processing Unit (CPU), a Network Processor (NP), etc.; it can also be a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field-Programmable Gate Array (FPGA), or other programmable logic devices, discrete gate or transistor logic devices, or discrete hardware components. The general-purpose processor can be a microprocessor or any conventional processor. The steps of the method disclosed in the embodiments of this invention can be directly implemented by a hardware decoding processor, or implemented by a combination of hardware and software modules in the decoding processor. The software modules can reside in random access memory, flash memory, read-only memory, programmable read-only memory, electrically erasable programmable memory, registers, or other mature storage media in the art. The storage medium is located in the memory, and the processor 71 reads the information in the memory and, in conjunction with its hardware, completes the steps of the data processing method of the aforementioned embodiment.

[0073] This invention also provides a computer-readable storage medium storing computer-executable instructions. When these computer-executable instructions are invoked and executed by a processor, they cause the processor to implement the aforementioned data processing method. For specific implementation details, please refer to the foregoing method embodiments, which will not be repeated here.

[0074] The computer program products of the data processing method, apparatus, and electronic device provided in the embodiments of the present invention include a computer-readable storage medium storing program code. The instructions included in the program code can be used to execute the data processing method described in the preceding method embodiments. For specific implementation, please refer to the method embodiments, which will not be repeated here.

[0075] Unless otherwise specifically stated, the relative steps, numerical expressions, and values ​​of the components and steps described in these embodiments do not limit the scope of the invention.

[0076] If the aforementioned functions are implemented as software functional units and sold or used as independent products, they can be stored in a processor-executable, non-volatile, computer-readable storage medium. Based on this understanding, the technical solution of this invention, essentially, or the part that contributes to the prior art, or a portion of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of this invention. The aforementioned storage medium includes various media capable of storing program code, such as USB flash drives, portable hard drives, read-only memory (ROM), random access memory (RAM), magnetic disks, or optical disks.

[0077] In the description of this invention, it should be noted that the terms "center," "upper," "lower," "left," "right," "vertical," "horizontal," "inner," and "outer," etc., indicate the orientation or positional relationship based on the orientation or positional relationship shown in the accompanying drawings. They are used only for the convenience of describing the invention and for simplifying the description, and do not indicate or imply that the device or element referred to must have a specific orientation, or be constructed and operated in a specific orientation. Therefore, they should not be construed as limitations on the invention. Furthermore, the terms "first," "second," and "third" are used for descriptive purposes only and should not be construed as indicating or implying relative importance.

[0078] Finally, it should be noted that the above-described embodiments are merely specific implementations of the present invention, used to illustrate the technical solutions of the present invention, and not to limit it. The scope of protection of the present invention is not limited thereto. Although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that any person skilled in the art can still modify or easily conceive of changes to the technical solutions described in the foregoing embodiments within the technical scope disclosed in the present invention, or make equivalent substitutions for some of the technical features; and these modifications, changes, or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention, and should all be covered within the scope of protection of the present invention. Therefore, the scope of protection of the present invention should be determined by the scope of the claims.

Claims

1. A data processing method, characterized by, The method includes: Obtain target indicator information from the target data source table, and generate a linkage configuration table based on the target indicator information; wherein, the target indicator information includes multiple indicators and all calculation factors corresponding to each indicator; the target data source table is a business data report corresponding to the target business in a pre-established data warehouse; each indicator has its own unique identifier information in the linkage configuration table; Obtain the unique identifier information of each indicator in the linkage configuration table, and generate a linkage result table based on the unique identifier information of each indicator in the linkage configuration table and the definition of each indicator; wherein, the definition represents the definition of the indicator and the correspondence between the indicator and the data in the target data source table; Generate a front-end data report based on the aforementioned linkage result table; In response to a modification operation on the linkage configuration table, the front-end data report is updated with the data corresponding to the modification operation; The multiple metrics include: atomic metrics, derived metrics, and derived metrics; wherein, atomic metrics are the basic metrics corresponding to the target business; derived metrics are generated based on one or more atomic metrics and one or more dimension fields corresponding to the target business; derived metrics are generated based on one or more atomic metrics, or based on one or more derived metrics. The steps of obtaining target indicator information from the target data source table and generating a linkage configuration table based on the target indicator information include: dividing the multiple indicators into multiple categories according to a preset classification rule, and assigning corresponding unique identification information to each category; wherein, the unique identification information includes a category code and / or a category name; The steps of generating a linkage result table based on the unique identifier information of each indicator in the linkage configuration table and the definition of each indicator include: periodically obtaining the data corresponding to each indicator in the target data source table according to the definition of each indicator; mapping the unique identifier information of each indicator in the linkage configuration table and the data corresponding to each indicator in the target data source table to the linkage result table. The step of generating a front-end data report based on the linkage result table includes: taking the data in the linkage result table corresponding to the unique identifier information of the target indicator in the linkage configuration table as the target data; and generating a front-end data report based on the target data according to a preset report template. The modification operation is either deleting an indicator or adding an indicator. If the modification operation is deleting an indicator, the step of updating the front-end data report with the data corresponding to the modification operation in response to the modification operation of the linkage configuration table includes: obtaining the unique identifier information of the target indicator corresponding to the modification operation in the linkage configuration table, and assigning a deletion identifier to the first specified data corresponding to the unique identifier information in the linkage configuration table; wherein, the deletion identifier indicates that the first specified data is invalid; searching the linkage result table based on the unique identifier information to determine the second specified data corresponding to the unique identifier information in the linkage result table, and invalidating the second specified data, thereby updating the linkage result table; updating the front-end data report with the updated linkage result table to obtain the updated front-end data report.

2. The method of claim 1, wherein, The steps of dividing the multiple indicators into multiple categories according to preset classification rules and assigning corresponding unique identifier information to each category include: Each atomic indicator in the target indicator information is taken as a primary category, and each derived or derivative indicator in the target indicator information is taken as a secondary category. Each secondary category is then divided into one or more tertiary categories according to a custom rule. Each of the first-level categories, each of the second-level categories, and each of the third-level categories is assigned a corresponding unique identifier.

3. The method of claim 1, wherein, If the modification operation is to add a new indicator, the steps of updating the front-end data report with the data corresponding to the modification operation in response to the modification operation of the linkage configuration table include: Add a new indicator to the linkage configuration table and assign a corresponding unique identifier to the new indicator. Obtain the third specified data corresponding to the new indicator in the target data source table, and map the unique identifier information of the new indicator in the linkage configuration table and the third specified data to the linkage result table, thereby realizing the update of the linkage result table; Update the front-end data report with the updated linkage result table to obtain the updated front-end data report.

4. A data processing apparatus, characterized by, The apparatus is used in the method according to any one of claims 1 to 3, the apparatus comprising: The configuration module is used to obtain target indicator information from the target data source table and generate a linkage configuration table based on the target indicator information; wherein, the target indicator information includes multiple indicators and all calculation factors corresponding to each indicator; the target data source table is a business data report corresponding to the target business in a pre-established data warehouse; each indicator has its own unique identifier information in the linkage configuration table; The first generation module is used to obtain the unique identification information of each indicator in the linkage configuration table, and generate a linkage result table based on the unique identification information of each indicator in the linkage configuration table and the definition of each indicator; wherein, the definition represents the definition of the indicator and the correspondence between the indicator and the data in the target data source table; The second generation module is used to generate a front-end data report based on the linkage result table; The update module is used to update the front-end data report with the data corresponding to the modification operation in response to the modification operation of the linkage configuration table.

5. An electronic device, comprising: The method includes a processor and a memory, the memory storing computer-executable instructions executable by the processor, the processor executing the computer-executable instructions to implement the method of any one of claims 1 to 3.

Images