A report rendering method and system based on data analysis
By identifying and extracting report element features, dividing rendering features, and sorting and rendering difficulty values based on client identification, the problem of low rendering efficiency when multiple clients correspond to a single server in the prior art is solved, and more efficient report rendering and better user experience are achieved.
Patent Information
- Application Number
- CN202411162344.2
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-23
- Publication Date
- 2025-02-28
- Estimated Expiration
- 2044-08-23
AI Technical Summary
When multiple clients correspond to a single server, existing report rendering technology is prone to low rendering efficiency and poor user experience due to large data volume or complex hierarchical architecture.
By obtaining the client's request for the page to be rendered, identifying and extracting the target report element information, generating a set of target report element features, and dividing it into a first rendering feature and a second rendering feature. The second rendering feature is sorted and rendered difficulty values are calculated using client identifiers, and rendered in the order of rendering difficulty values from low to high.
It improves report rendering efficiency when multiple clients correspond to a single server, reduces user waiting time and improves user experience.
Smart Images

Figure 00000000_0000_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of report rendering, and in particular to a report rendering method and system based on data analysis. Background Art
[0002] Data visualization is the process of presenting data through charts, graphs and other visualization tools. It helps people better understand and utilize data by converting complex data into visual forms that are easy to understand and analyze. In today's era of data explosion, data visualization has become increasingly important and plays an important role in various fields.
[0003] In real life, there are multiple clients analyzing and viewing the same online report. In the existing rendering technology, a single client corresponds to a single server, which is prone to waste of resources. Using multiple clients to correspond to a single server can avoid waste of resources, but it is easy to cause low rendering efficiency and poor user experience due to the large amount of report data or complex hierarchical structure.
[0004] Therefore, the present invention discloses a report rendering method and system based on data analysis to solve the above problems. Summary of the invention
[0005] The purpose of the present invention is to provide a report rendering method and system based on data analysis to solve the problems raised in the above background technology.
[0006] In order to solve the above technical problems, the present invention provides the following technical solutions: a report rendering method based on data analysis, the method comprising the following steps:
[0007] S1: Obtain page requests to be rendered by clients that use the same online target report, identify target report element information in each page request to be rendered by the client, extract features of the target report element information, generate a target report element feature set of the target report element information, and add a client identifier to the target report element features in the target report element feature set;
[0008] S2: Dividing the target report element feature into a first rendering feature and a second rendering feature, and associating the first rendering feature with the second rendering feature;
[0009] S3: further analyzing and integrating the second rendering features, combining the client information corresponding to the client identifier, sorting the second rendering features, and generating a second rendering feature sequence;
[0010] S4: Rendering each page request to be rendered according to the second rendering feature sequence and the preset report rendering template.
[0011] According to the above solution, in S1, identifying the target report element information in each client's page request to be rendered includes:
[0012] Performing text recognition on the page request to be rendered by the client to obtain text data of each cell in the page request to be rendered by the client, wherein the text data includes cell text content and cell hierarchical relationship; the cell hierarchical relationship is a parent-child relationship between two cells;
[0013] Extracting the cell hierarchical relationship of the online target report and constructing a cell structure tree, the cell structure tree including a plurality of root nodes, a plurality of branch nodes and a plurality of leaf nodes, the root nodes, branch nodes and child nodes corresponding one to one with the cells of the online target report;
[0014] The hierarchical relationship of cells is searched in a preset report rendering template to obtain rendering configuration parameters of the cells; the cell rendering configuration parameters include frame rendering data and text rendering data.
[0015] According to the above scheme, in S1, the features of each cell are extracted, and the target report element feature of the i-th cell in the target report element feature set is denoted as CH i ={FR i , TD i , TR i}; where FR i Represents the frame rendering data of the i-th cell; TD i Represents the cell text content of the i-th cell; TR i Represents the text rendering data of the i-th cell; i∈[1,I], where I represents the total number of cells in the target report element feature set;
[0016] Extract the features of each cell, and provide data support for subsequent analysis of the cells based on the features of each cell;
[0017] Add the client identifier to the target report element feature in the target report element feature set; record the target report element feature of the i-th cell in the target report element feature set after adding the client identifier as ;in Represents the client CL j The target report element feature of the ith cell in the target report element feature set; Represents the client CL j The frame rendering data of the i-th cell in the target report element feature set; Represents the client CL j The cell text content of the i-th cell in the target report element feature set; Represents the client CL j The text rendering data of the i-th cell in the target report element feature set; j∈[1,J], where J represents the total number of clients.
[0018] By adding client identifiers to the target report element features, you can clearly know the client corresponding to the cell, providing data support for the subsequent calculation of the cell rendering difficulty value based on the client priority;
[0019] According to the above scheme, the first rendering feature includes rendering framework data; the second rendering feature includes cell text content and text rendering data; the first rendering feature is rendered by a first rendering engine; and the second rendering feature is rendered by a second rendering engine.
[0020] Separate the rendering frame data and the cell text content from the text rendering data, and use two independent rendering engines to render the first rendering feature and the second rendering feature respectively, using the first rendering engine to speed up the frame rendering, prevent the appearance of a white screen, and improve the user experience;
[0021] According to the above solution, in S3, generating the second rendering feature sequence includes the following steps:
[0022] S301: searching for a first client from a client set, wherein the priority of the first client is higher than the priority of any other client in the client set; the priority of the client is preset by the system;
[0023] By setting priorities for the clients, the second rendering engine can be effectively used for the first client first, thereby improving the user experience of the first client;
[0024] S302: extracting the second rendering features of the first client that are the same as the second rendering features of other clients, wherein the same second rendering features indicate that the cell text content and the text rendering data are the same; arranging the second rendering features of the first client in descending order according to the number of repetitions, to generate a first rendering sequence of the first client;
[0025] Searching for the second rendering features that are identical to the second rendering features of other clients in the second rendering features of the first client, and preferentially rendering the second rendering features that are identical to the second rendering features of other clients in the second rendering features of the first client, so as to take into account clients other than the first client, prevent multiple rendering of duplicate content, and improve overall rendering efficiency;
[0026] S303: extracting second rendering features that are different from second rendering features of other clients from the second rendering features of the first client, wherein the different second rendering features indicate that one of the cell text content or the text rendering data is different or both are different; calculating rendering difficulty values for the different second rendering features in the first client, arranging the different second rendering features in the first client in order from low to high according to the rendering difficulty values, and generating a second rendering sequence for the first client;
[0027] S304: extracting second rendering features that are different from the second rendering features of the first client from the second rendering features of other clients, calculating rendering difficulty values for the different second rendering features of other clients, arranging the different second rendering features of other clients in order from low to high according to the rendering difficulty values, and generating rendering sequences for other clients;
[0028] Calculating rendering difficulty values for different second rendering features, and rendering the second rendering features in order of rendering difficulty values from low to high, can display more rendering results faster, further improving the user experience;
[0029] S305: Integrate the first rendering sequence of the first client, the second rendering sequence of the first client, and the rendering sequences of other clients to generate a second rendering feature sequence.
[0030] According to the above scheme, the specific formula for calculating the rendering difficulty value is as follows:
[0031] ;
[0032] in, Represents the client CL j The rendering difficulty value of the second rendering feature of the i-th cell in the target report element feature set; α 1 , α 2 , α 3 and α 4 Represents the evaluation coefficient of the rendering difficulty value, β j To represent the client CL j The evaluation coefficient and priority score of the rendering difficulty value are both prefabricated constants; Represents the client CL j The character length of the text content of the i-th cell in the target report element feature set; Represents the client CL j The total number of text content formulas in the i-th cell in the target report element feature set; Represents the client CL jThe number of text content data sources for the ith cell in the target report element feature set; Represents the client CL j The number of levels of the i-th cell in the target report element feature set; Represents the client CL j The average rendering time corresponding to the text rendering style of the ith cell in the target report element feature set;
[0033] The number of levels of the root node is a constant preset by the system; the number of levels of a child node is equal to the sum of the number of levels of its parent node and the number of levels coefficient; the number of levels coefficient is a constant preset by the system;
[0034] The text rendering styles include table style, chart style, text report style, dashboard style and waterfall style; from historical data, the rendering time when there is only one text rendering style in p articles is obtained, p is a constant preset by the system, and the average rendering time of each text rendering style is calculated respectively.
[0035] The rendering difficulty value of the second rendering feature of the client is calculated by using the client priority score, text content character length, text content formula calculation score, text content data source number, level number and text rendering style score, so as to accurately calculate the rendering difficulty coefficient and improve the accuracy rate; after accurately judging the rendering difficulty coefficient, the user waiting time can be reduced, and the user experience can be further improved;
[0036] According to the above scheme, in S303 and S304, before the rendering difficulty value is calculated; in the second rendering feature of the same client, if there are adjacent parent nodes and child nodes in a two-level relationship, the parent nodes and child nodes in the two-level relationship are bound;
[0037] In S303 and S304, after the rendering difficulty value is calculated, the smallest rendering difficulty value among the parent node and the child node of the adjacent upper and lower levels is used as the rendering difficulty value after binding.
[0038] By binding the parent node and child node in the adjacent upper and lower levels, the nodes with similar query paths can be partitioned and the data of the same partition can be rendered simultaneously, thus avoiding multiple searches and renderings of similar paths, reducing user waiting time, and further improving the user experience.
[0039] Another aspect of the present application provides a report rendering system based on data analysis, the system is applied to the above-mentioned report rendering method based on data analysis, the system includes a report data collection and marking module, a report data division and association module, a report data analysis and sorting module and a report rendering module;
[0040] The report data collection and marking module is used to obtain page requests to be rendered by clients using the same online target report, identify target report element information in each page request to be rendered by the client, perform feature extraction on the target report element information, generate a target report element feature set of the target report element information, and add a client identifier to the target report element feature in the target report element feature set;
[0041] The report data division and association module is used to divide the target report element feature into a first rendering feature and a second rendering feature, and associate the first rendering feature with the second rendering feature;
[0042] The report data analysis and sorting module further analyzes and integrates the second rendering features, sorts the second rendering features in combination with the client information corresponding to the client identifier, and generates a second rendering feature sequence;
[0043] The report rendering module renders each page request to be rendered according to the second rendering feature sequence and a preset report rendering template.
[0044] According to the above solution, the report data collection and marking module includes a report data collection unit and a report data marking unit;
[0045] The report data collection unit is used to obtain a page request to be rendered by a client using the same online target report; perform text recognition on the page request to be rendered by the client to obtain text data of each cell in the page request to be rendered by the client, wherein the text data includes cell text content and cell hierarchical relationship; search the hierarchical relationship of the cell in a preset report rendering template to obtain rendering configuration parameters of the cell; the cell rendering configuration parameters include frame rendering data and text rendering data;
[0046] The report data marking unit is used to extract the features of each cell and add a client identifier to the target report element features in the target report element feature set.
[0047] According to the above scheme, the report data analysis and sorting module includes a feature search and comparison unit, a rendering difficulty calculation unit, and a rendering feature sorting unit;
[0048] The searching and comparing unit searches for the first client from the client set, and extracts the second rendering features of the first client that are the same as the second rendering features of other clients, wherein the same second rendering features indicate that the cell text content and the text rendering data are the same;
[0049] The rendering difficulty calculation unit is used to bind the parent node and the child node in the adjacent upper and lower levels relationship if there are parent nodes and child nodes in the adjacent upper and lower levels relationship in the second rendering feature of the same client; calculate the rendering difficulty value of the different second rendering features; and use the smallest rendering difficulty value among the parent nodes and child nodes in the adjacent upper and lower levels relationship as the rendering difficulty value after binding;
[0050] The rendering feature sorting unit is used to arrange the second rendering features of the first client in descending order according to the number of repetitions to generate a first rendering sequence of the first client; arrange the different second rendering features in the first client in descending order according to the rendering difficulty value to generate a second rendering sequence of the first client; arrange the different second rendering features in other clients in descending order according to the rendering difficulty value to generate rendering sequences of other clients; and perform sequence integration in the order of the first rendering sequence of the first client, the second rendering sequence of the first client and the rendering sequences of other clients to generate a second rendering feature sequence.
[0051] Compared with the prior art, the beneficial effects achieved by the present invention are as follows: for the case where multiple clients correspond to a single server; adding a client identifier to the target report element feature can clearly know the client corresponding to the cell, and provide data support for the subsequent calculation of the rendering difficulty value of the cell according to the client priority; by setting the priority of the client, the second rendering engine can be effectively used for the first client first, thereby improving the user experience of the first client; searching for the second rendering feature of the first client that is the same as the second rendering feature of other clients, and giving priority to the second rendering feature of the first client that is the same as the second rendering feature of other clients By using a plurality of evaluation items to calculate the rendering difficulty value of the second rendering feature of the client, the rendering difficulty coefficient can be accurately calculated to improve the accuracy rate; after accurately judging the rendering difficulty coefficient, the user waiting time can be reduced, and the user experience can be further improved; by binding the parent node and the child node in the adjacent upper and lower levels, the nodes with similar query paths can be partitioned, and the data of the same partition can be rendered simultaneously, so as to avoid multiple searches and renderings of similar paths, reduce the user waiting time, and further improve the user experience. BRIEF DESCRIPTION OF THE DRAWINGS
[0052] The accompanying drawings are used to provide a further understanding of the present invention and constitute a part of the specification. Together with the embodiments of the present invention, they are used to explain the present invention and do not constitute a limitation of the present invention. In the accompanying drawings:
[0053] Figure 1 It is a flow chart of a report rendering method based on data analysis of the present invention;
[0054] Figure 2 It is a structural schematic diagram of a report rendering system based on data analysis of the present invention. DETAILED DESCRIPTION
[0055] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0056] See also Figure 1 The present invention provides a technical solution: a report rendering method based on data analysis, the method comprising the following steps:
[0057] S1: Obtain page requests to be rendered by clients that use the same online target report, identify target report element information in each page request to be rendered by the client, extract features of the target report element information, generate a target report element feature set of the target report element information, and add a client identifier to the target report element features in the target report element feature set;
[0058] S2: Dividing the target report element feature into a first rendering feature and a second rendering feature, and associating the first rendering feature with the second rendering feature;
[0059] S3: further analyzing and integrating the second rendering features, combining the client information corresponding to the client identifier, sorting the second rendering features, and generating a second rendering feature sequence;
[0060] S4: Rendering each page request to be rendered according to the second rendering feature sequence and the preset report rendering template.
[0061] According to the above solution, in S1, identifying the target report element information in each client's page request to be rendered includes:
[0062] Performing text recognition on the page request to be rendered by the client to obtain text data of each cell in the page request to be rendered by the client, wherein the text data includes cell text content and cell hierarchical relationship; the cell hierarchical relationship is a parent-child relationship between two cells;
[0063] Embodiment 1: respectively obtain the row number range and column number range of two adjacent cells; in this embodiment, the row number range and column number range of the first cell are expressed as {1, 3; 1, 2}; wherein {1, 3} indicates that the row number range of the first cell is 1 to 3 (not included); {1, 2} indicates that the column number range of the first cell is 1 to 2 (not included); the row number range and column number range of the first cell are expressed as {1, 2; 2, 3}; wherein {1, 2} indicates that the row number range of the second cell is 1 to 2 (not included); {2, 3} indicates that the column number range of the second cell is 2 to 3 (not included);
[0064] Therefore, the first unit is the parent cell of the second unit; the second unit is the child cell of the first unit;
[0065] Extract the cell hierarchical relationship of the online target report and construct a cell structure tree. The cell structure tree includes a number of root nodes, a number of branch nodes and a number of leaf nodes. The root nodes, branch nodes and child nodes correspond to the cells of the online target report one by one.
[0066] The hierarchical relationship of cells is searched in the preset report rendering template to obtain the rendering configuration parameters of the cells; the cell rendering configuration parameters include frame rendering data and text rendering data.
[0067] According to the above scheme, in S1, the features of each cell are extracted, and the target report element feature of the i-th cell in the target report element feature set is denoted as CH i ={FR i , TD i , TR i}; where FR i Represents the frame rendering data of the i-th cell; TD i Represents the cell text content of the i-th cell; TR i Represents the text rendering data of the i-th cell; i∈[1,I], where I represents the total number of cells in the target report element feature set;
[0068] Add the client identifier to the target report element feature in the target report element feature set; record the target report element feature of the i-th cell in the target report element feature set after adding the client identifier as ;in Represents the client CL j The target report element feature of the ith cell in the target report element feature set; Represents the client CL j The frame rendering data of the i-th cell in the target report element feature set; Represents the client CL jThe cell text content of the i-th cell in the target report element feature set; Represents the client CL j The text rendering data of the i-th cell in the target report element feature set; j∈[1,J], where J represents the total number of clients.
[0069] According to the above scheme, the first rendering feature includes rendering framework data; the second rendering feature includes cell text content and text rendering data; the first rendering feature is rendered by the first rendering engine; and the second rendering feature is rendered by the second rendering engine.
[0070] According to the above solution, in S3, generating the second rendering feature sequence includes the following steps:
[0071] S301: searching for a first client from a client set, wherein the priority of the first client is higher than the priority of any other client in the client set; the priority of the client is preset by the system;
[0072] S302: extracting the second rendering features of the first client that are the same as the second rendering features of other clients, wherein the same second rendering features indicate that the cell text content and the text rendering data are the same; arranging the second rendering features of the first client in descending order according to the number of repetitions, to generate a first rendering sequence of the first client;
[0073] Embodiment 2: The second rendering feature of the first client: {(daily turnover, histogram), (weekly turnover, histogram), (monthly turnover, histogram)}; the second rendering feature of the second client: {(weekly turnover, histogram), (monthly turnover, histogram), (annual turnover, histogram)}; the second rendering feature of the third client: {(weekly turnover change rate, histogram), (monthly turnover, histogram), (annual turnover, histogram)};
[0074] In this embodiment, the second rendering feature of the first client is compared with the second rendering features of other clients; the second rendering feature: (weekly turnover, bar graph) is repeated 1 times; the second rendering feature: (monthly turnover, bar graph) is repeated 2 times;
[0075] Therefore, the first rendering sequence of the first client is: {(monthly turnover, bar chart), (weekly turnover, bar chart)};
[0076] S303: extracting second rendering features that are different from second rendering features of other clients from among the second rendering features of the first client, wherein the different second rendering features indicate that one of the cell text content or the text rendering data is different or both are different; calculating rendering difficulty values for the different second rendering features in the first client, arranging the different second rendering features in the first client in order from low to high according to the rendering difficulty values, and generating a second rendering sequence for the first client;
[0077] S304: extracting second rendering features that are different from the second rendering features of the first client from the second rendering features of other clients, calculating rendering difficulty values for the different second rendering features of other clients, arranging the different second rendering features of other clients in order from low to high according to the rendering difficulty values, and generating rendering sequences for other clients;
[0078] S305: Integrate the first rendering sequence of the first client, the second rendering sequence of the first client, and the rendering sequences of other clients to generate a second rendering feature sequence.
[0079] The specific formula for calculating the rendering difficulty value is as follows:
[0080] ;
[0081] in, Represents the client CL j The rendering difficulty value of the second rendering feature of the i-th cell in the target report element feature set; α 1 , α 2 , α 3 and α 4 Represents the evaluation coefficient of the rendering difficulty value, β j To represent the client CL j The evaluation coefficient and priority score of the rendering difficulty value are both prefabricated constants; Represents the client CL j The character length of the text content of the i-th cell in the target report element feature set; Represents the client CL j The total number of text content formulas in the i-th cell in the target report element feature set; Represents the client CL j The number of text content data sources for the ith cell in the target report element feature set; Represents the client CL j The number of levels of the i-th cell in the target report element feature set; Represents the client CL jThe average rendering time corresponding to the text rendering style of the ith cell in the target report element feature set;
[0082] Embodiment 3: In this embodiment, the text content formula in the cell includes 1 addition, 2 subtractions and 2 sums;
[0083] but ;
[0084] Example 4: In this example, cell B1=A1×A2+A3; the calculation formula in cell B1 indicates that the data of cell B1 is calculated from the data of cells A1, A2, and A3; therefore, the number of data sources of the text content of cell B1 is 3;
[0085] The number of levels of the root node is a constant preset by the system; the number of levels of a child node is equal to the sum of the number of levels of its parent node and the number of levels coefficient; the number of levels coefficient is a constant preset by the system;
[0086] The text rendering styles include table style, chart style, text report style, dashboard style and waterfall style; from historical data, the rendering time when there is only one text rendering style in p articles is obtained, p is a constant preset by the system, and the average rendering time of each text rendering style is calculated respectively.
[0087] According to the above scheme, in S303 and S304, before the rendering difficulty value is calculated; in the second rendering feature of the same client, if there are adjacent parent nodes and child nodes in a two-level relationship, the parent nodes and child nodes in the two-level relationship are bound;
[0088] In S303 and S304, after the rendering difficulty value is calculated, the smallest rendering difficulty value among the parent node and the child node of the adjacent upper and lower levels is used as the rendering difficulty value after binding.
[0089] See also Figure 2 , the present invention provides a technical solution: Another aspect of the present application provides a report rendering system based on data analysis, the system is applied to the implementation of the above-mentioned report rendering method based on data analysis, the system includes a report data collection and marking module, a report data division and association module, a report data analysis and sorting module and a report rendering module;
[0090] The report data collection and marking module is used to obtain page requests to be rendered by clients using the same online target report, identify target report element information in each client page request to be rendered, perform feature extraction on the target report element information, generate a target report element feature set of the target report element information, and add a client identifier to the target report element feature in the target report element feature set;
[0091] The report data division and association module is used to divide the target report element feature into a first rendering feature and a second rendering feature, and associate the first rendering feature with the second rendering feature;
[0092] The report data analysis and sorting module further analyzes and integrates the second rendering features, sorts the second rendering features in combination with the client information corresponding to the client identifier, and generates a second rendering feature sequence;
[0093] The report rendering module renders each page request to be rendered according to the second rendering feature sequence and a preset report rendering template.
[0094] According to the above solution, the report data collection and marking module includes a report data collection unit and a report data marking unit;
[0095] The report data collection unit is used to obtain a page request to be rendered by a client using the same online target report; perform text recognition on the page request to be rendered by the client to obtain text data of each cell in the page request to be rendered by the client, the text data including cell text content and cell hierarchical relationship; search for the hierarchical relationship of the cell in the preset report rendering template to obtain the rendering configuration parameters of the cell; the cell rendering configuration parameters include frame rendering data and text rendering data;
[0096] The report data marking unit is used to extract the features of each cell and add a client identifier to the target report element features in the target report element feature set.
[0097] According to the above scheme, the report data analysis and sorting module includes a feature search and comparison unit, a rendering difficulty calculation unit, and a rendering feature sorting unit;
[0098] The searching and comparing unit searches for the first client from the client set, and extracts the second rendering features of the first client that are the same as the second rendering features of other clients, wherein the same second rendering features indicate that the cell text content and the text rendering data are the same;
[0099] The rendering difficulty calculation unit is used to bind the parent nodes and child nodes in the adjacent upper and lower levels in the second rendering features of the same client if there are parent nodes and child nodes in the adjacent upper and lower levels; calculate the rendering difficulty values of the different second rendering features; and use the smallest rendering difficulty value among the parent nodes and child nodes in the adjacent upper and lower levels as the rendering difficulty value after binding;
[0100] The rendering feature sorting unit is used to arrange the second rendering features of the first client in descending order according to the number of repetitions to generate a first rendering sequence of the first client; arrange the different second rendering features in the first client in descending order according to the rendering difficulty value to generate a second rendering sequence of the first client; arrange the different second rendering features in other clients in descending order according to the rendering difficulty value to generate rendering sequences of other clients; and perform sequence integration in the order of the first rendering sequence of the first client, the second rendering sequence of the first client and the rendering sequences of other clients to generate a second rendering feature sequence.
[0101] It should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device.
[0102] Finally, it should be noted that the above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art can still modify the technical solutions described in the aforementioned embodiments or replace some of the technical features therein by equivalents. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.
Claims
1. A report rendering method based on data analysis, characterized in that: The method comprises the following steps: S1: Obtain page requests to be rendered by clients that use the same online target report, identify target report element information in each page request to be rendered by the client, extract features of the target report element information, generate a target report element feature set of the target report element information, and add a client identifier to the target report element features in the target report element feature set; S2: Dividing the target report element feature into a first rendering feature and a second rendering feature, and associating the first rendering feature with the second rendering feature; S3: further analyzing and integrating the second rendering features, combining the client information corresponding to the client identifier, sorting the second rendering features, and generating a second rendering feature sequence; S4: Rendering each page request to be rendered according to the second rendering feature sequence and the preset report rendering template; In S3, generating a second rendering feature sequence includes the following steps: S301: searching for a first client from a client set, wherein the priority of the first client is higher than the priority of any other client in the client set; the priority of the client is preset by the system; S302: extracting the second rendering features of the first client that are the same as the second rendering features of other clients, wherein the same second rendering features indicate that the cell text content and the text rendering data are the same; arranging the second rendering features of the first client in descending order according to the number of repetitions, to generate a first rendering sequence of the first client; S303: extracting second rendering features that are different from second rendering features of other clients from the second rendering features of the first client, wherein the different second rendering features indicate that one of the cell text content or the text rendering data is different or both are different; calculating rendering difficulty values for the different second rendering features in the first client, arranging the different second rendering features in the first client in order from low to high according to the rendering difficulty values, and generating a second rendering sequence for the first client; S304: extracting second rendering features that are different from the second rendering features of the first client from the second rendering features of other clients, calculating rendering difficulty values for the different second rendering features of other clients, arranging the different second rendering features of other clients in order from low to high according to the rendering difficulty values, and generating rendering sequences for other clients; S305: Integrate the first rendering sequence of the first client, the second rendering sequence of the first client, and the rendering sequences of other clients to generate a second rendering feature sequence.
2. A report rendering method based on data analysis according to claim 1, characterized in that: In S1, identifying target report element information in each client page request to be rendered includes: Performing text recognition on the page request to be rendered by the client to obtain text data of each cell in the page request to be rendered by the client, wherein the text data includes cell text content and cell hierarchical relationship; the cell hierarchical relationship is a parent-child relationship between two cells; Extracting the cell hierarchical relationship of the online target report and constructing a cell structure tree, the cell structure tree including a plurality of root nodes, a plurality of branch nodes and a plurality of leaf nodes, the root nodes, branch nodes and child nodes corresponding one to one with the cells of the online target report; The hierarchical relationship of cells is searched in a preset report rendering template to obtain rendering configuration parameters of the cells; the cell rendering configuration parameters include frame rendering data and text rendering data.
3. A report rendering method based on data analysis according to claim 2, characterized in that: In S1, the features of each cell are extracted, and the target report element feature of the i-th cell in the target report element feature set is denoted as CH i ={FR i , TD i , TR i }; where FR i Represents the frame rendering data of the i-th cell; TD i Represents the cell text content of the i-th cell; TR i Represents the text rendering data of the i-th cell; i∈[1, I], where I represents the total number of cells in the target report element feature set; Add the client identifier to the target report element feature in the target report element feature set; record the target report element feature of the i-th cell in the target report element feature set after adding the client identifier as ;in Represents the client CL j The target report element feature of the ith cell in the target report element feature set; Represents the client CL j The frame rendering data of the i-th cell in the target report element feature set; Represents the client CL j The cell text content of the i-th cell in the target report element feature set; Represents the client CL j The text rendering data of the i-th cell in the target report element feature set; j∈[1,J], where J represents the total number of clients.
4. A report rendering method based on data analysis according to claim 3, characterized in that: In S2, the first rendering feature includes rendering framework data; the second rendering feature includes cell text content and text rendering data; the first rendering feature is rendered by a first rendering engine; and the second rendering feature is rendered by a second rendering engine.
5. A report rendering method based on data analysis according to claim 4, characterized in that: The specific formula for calculating the rendering difficulty value is as follows: ; in, Represents the client CL j The rendering difficulty value of the second rendering feature of the i-th cell in the target report element feature set; α1, α2, α3 and α4 represent the evaluation coefficients of the rendering difficulty value, β j To represent the client CL j The evaluation coefficient and priority score of the rendering difficulty value are both prefabricated constants; Represents the client CL j The character length of the text content of the ith cell in the target report element feature set; Represents the client CL j The total number of text content formulas in the i-th cell in the target report element feature set; Represents the client CL j The number of text content data sources for the ith cell in the target report element feature set; Represents the client CL j The number of levels of the i-th cell in the target report element feature set; Represents the client CL j The average rendering time corresponding to the text rendering style of the ith cell in the target report element feature set; The number of levels of the root node is a constant preset by the system; the number of levels of a child node is equal to the sum of the number of levels of its parent node and the number of levels coefficient; the number of levels coefficient is a constant preset by the system; The text rendering styles include table style, chart style, text report style, dashboard style and waterfall style; from historical data, the rendering time when there is only one text rendering style in p articles is obtained, p is a constant preset by the system, and the average rendering time of each text rendering style is calculated respectively.
6. A report rendering method based on data analysis according to claim 5, characterized in that: In S303 and S304, before the rendering difficulty value is calculated; in the second rendering feature of the same client, if there are adjacent parent nodes and child nodes in a two-level relationship, the parent nodes and child nodes in the two-level relationship are bound; In S303 and S304, after the rendering difficulty value is calculated, the smallest rendering difficulty value among the parent node and the child node of the adjacent upper and lower levels is used as the rendering difficulty value after binding.
7. A report rendering system based on data analysis, the system is applied to implement a report rendering method based on data analysis as described in any one of claims 1 to 6, characterized in that: The system includes a report data collection and marking module, a report data division and association module, a report data analysis and sorting module, and a report rendering module; The report data collection and marking module is used to obtain page requests to be rendered by clients using the same online target report, identify target report element information in each page request to be rendered by the client, perform feature extraction on the target report element information, generate a target report element feature set of the target report element information, and add a client identifier to the target report element feature in the target report element feature set; The report data division and association module is used to divide the target report element feature into a first rendering feature and a second rendering feature, and associate the first rendering feature with the second rendering feature; The report data analysis and sorting module further analyzes and integrates the second rendering features, sorts the second rendering features in combination with the client information corresponding to the client identifier, and generates a second rendering feature sequence; The report rendering module renders each page request to be rendered according to the second rendering feature sequence and a preset report rendering template.
8. A report rendering system based on data analysis according to claim 7, characterized in that: The report data collection and marking module includes a report data collection unit and a report data marking unit; The report data collection unit is used to obtain page requests to be rendered by the client using the same online target report; Performing text recognition on the page request to be rendered by the client to obtain text data of each cell in the page request to be rendered by the client, wherein the text data includes cell text content and cell hierarchical relationship; Searching for the hierarchical relationship of cells in a preset report rendering template, and obtaining rendering configuration parameters of the cells; the cell rendering configuration parameters include frame rendering data and text rendering data; The report data marking unit is used to extract the features of each cell and add a client identifier to the target report element features in the target report element feature set.
9. A report rendering system based on data analysis according to claim 7, characterized in that: The report data analysis and sorting module includes a feature search and comparison unit, a rendering difficulty calculation unit, and a rendering feature sorting unit; The searching and comparing unit searches for the first client from the client set, and extracts the second rendering features of the first client that are the same as the second rendering features of other clients, wherein the same second rendering features indicate that the cell text content and the text rendering data are the same; The rendering difficulty calculation unit is used for binding the parent node and the child node in the adjacent upper and lower levels relationship if there are adjacent parent nodes and child nodes in the upper and lower levels relationship in the second rendering feature of the same client; Calculating rendering difficulty values for different second rendering features; taking the smallest rendering difficulty value between the parent node and the child node of the adjacent upper and lower levels as the rendering difficulty value after binding; The rendering feature sorting unit is used to arrange the second rendering features of the first client in descending order according to the number of repetitions to generate a first rendering sequence of the first client; arrange the different second rendering features of the first client in descending order according to the rendering difficulty value to generate a second rendering sequence of the first client; The different second rendering features of other clients are arranged in order from low to high according to the rendering difficulty value to generate rendering sequences of other clients; the sequences are integrated in the order of the first rendering sequence of the first client, the second rendering sequence of the first client and the rendering sequences of other clients to generate a second rendering feature sequence.
Citation Information
Patent Citations
Data rendering method and device, medium and electronic equipment
CN111523295A