Data updating method, device, equipment and storage medium based on multidimensional cross table

By performing virtual web page screenshots and splicing with other documents on multi-dimensional crosstabs, the problem of multi-dimensional crosstabs being unable to be merged with other content documents is solved, and the integrity and comprehensiveness of the report is improved.

CN111858634BActive Publication Date: 2025-08-15CHINA PING AN PROPERTY INSURANCE CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202010729119.8
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2020-07-27
Publication Date
2025-08-15
Estimated Expiration
2040-07-27

AI Technical Summary

Technical Problem

In the prior art, multi-dimensional cross-tabs and other content documents cannot be merged, resulting in incomplete and comprehensive reports.

Method used

By obtaining data processing requests, calling the preset browser to take screenshots of the multi-dimensional cross-tab, reading the virtual element nodes and rendering them into stream files, splicing them with other documents according to the data splicing request identifier, generating the target stream file to be sent and transmitting to the server.

Benefits of technology

The merger of multi-dimensional cross-tab and other content documents is realized, improving the integrity and comprehensiveness of the target stream files to be sent.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN111858634B_ABST
    Figure CN111858634B_ABST
Patent Text Reader

Abstract

The present invention relates to the field of big data technology, and discloses a data update method, device, equipment and storage medium based on a multidimensional cross-tabulation, which is used to solve the problem of being unable to merge a multidimensional cross-tabulation with other documents and to improve the integrity and comprehensiveness of the target stream file to be sent. The data update method based on a multidimensional cross-tabulation includes: obtaining a data processing request and a multidimensional cross-tabulation; calling a preset browser to take a screenshot of the multidimensional cross-tabulation to obtain a screenshot of a target virtual web page; reading a plurality of virtual element nodes to be processed, and rendering the plurality of virtual element nodes to be processed as a target stream file to be processed; splicing the target stream file to be processed with other preset documents to be spliced to obtain a target stream file to be sent; transmitting the target stream file to be sent to a target preset server. In addition, the present invention also relates to blockchain technology, and the target stream file to be sent can be stored in a blockchain node.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of big data, and in particular to a data updating method, device, equipment and storage medium based on a multidimensional cross table. Background Art

[0002] Reports are typically based on data in a relational model, presented in a table format or as a multi-dimensional combination of rows and columns. Currently, many companies need to create reports, such as those on bond issuance rates and financial product yields, and then distribute these reports for project reporting or meetings.

[0003] In the prior art, the multidimensional crosstab and other content documents in a report are displayed separately, and the multidimensional crosstab cannot be merged with the other content documents, resulting in an incomplete and incomplete report. Summary of the Invention

[0004] The main purpose of the present invention is to solve the problem that a multidimensional cross table cannot be merged with other content documents, resulting in incomplete and incomplete reports.

[0005] The first aspect of the present invention provides a data update method based on a multidimensional cross-table, comprising: obtaining a data processing request and a multidimensional cross-table, the data processing request at least including a data interception request identifier and a data splicing request identifier; calling a preset browser to take a screenshot of the multidimensional cross-table according to the data interception request identifier to obtain a target virtual web page screenshot; reading multiple virtual element nodes to be processed from the target virtual web page screenshot, and rendering the multiple virtual element nodes to be processed to obtain a target stream file to be processed; splicing the target stream file to be processed with other preset documents to be spliced according to the data splicing request identifier to obtain a target stream file to be sent; transmitting the target stream file to be sent to a target preset server.

[0006] Optionally, in a first implementation method of the first aspect of the present invention, the reading of multiple virtual element nodes to be processed from the target virtual web page screenshot and rendering of the multiple virtual element nodes to be processed to obtain a target stream file to be processed includes: reading multiple virtual element nodes to be processed from the target virtual web page screenshot, the virtual element nodes to be processed are used to constitute the target virtual web page screenshot; performing preset processing on the multiple virtual element nodes to be processed to generate a virtual document object; rendering the virtual document object to generate a target stream file to be processed.

[0007] Optionally, in a second implementation method of the first aspect of the present invention, the preset processing of the multiple virtual element nodes to be processed to generate a virtual document object includes: cloning the multiple virtual element nodes to be processed to obtain multiple initial cloned element nodes; using a preset style function to add styles to the multiple initial cloned element nodes to obtain multiple target cloned element nodes; and performing virtual node processing on the multiple target cloned element nodes to obtain a virtual document object.

[0008] Optionally, in a third implementation method of the first aspect of the present invention, rendering the virtual document object and generating a target to-be-processed stream file includes: performing recursive operations on the virtual document object based on the parent-child nodes and stacking relationships in the virtual document object to obtain a target rendering queue, wherein the target rendering queue includes multiple target rendering items arranged in sequence; reading target style information corresponding to each target clone element node from the multiple target clone element nodes to obtain multiple target style information; calling a preset style setting function in a preset browser to render the target rendering queue based on the multiple target style information to obtain a target file encoding; calling a preset read and write function in the preset browser to convert the target file encoding into a target to-be-processed stream file.

[0009] Optionally, in a fourth implementation method of the first aspect of the present invention, the target to-be-processed stream file is spliced with other preset to-be-spliced documents according to the data splicing request identifier to obtain the target to-be-sent stream file, including: obtaining other preset documents to be spliced, and extracting multiple other virtual element nodes from the other preset documents to be spliced; splicing the multiple other virtual element nodes with the multiple to-be-processed virtual element nodes to obtain a spliced virtual element node list; processing the spliced virtual element node list to generate a spliced virtual document object; rendering the spliced virtual document object to generate the target to-be-sent stream file.

[0010] Optionally, in the fifth implementation of the first aspect of the present invention, after the target to-be-sent stream file is transmitted to the target preset server, the data update method based on the multidimensional cross-table further includes: reading a data adjustment request identifier from the data processing request, obtaining a target adjusted stream file based on the data adjustment request identifier and the target to-be-processed stream file, and transmitting the target adjusted stream file to the target preset server; or, reading a security addition request identifier from the data processing request, obtaining a target security stream file based on the security addition request identifier and the target to-be-processed stream file, and transmitting the target security stream file to the target preset server.

[0011] Optionally, in a sixth implementation method of the first aspect of the present invention, the data adjustment request identifier is read from the data processing request, a target adjusted stream file is obtained based on the data adjustment request identifier and the target to-be-processed stream file, and the target adjusted stream file is transmitted to the target preset server, including: when the data adjustment request identifier is read from the data processing request, the order of the multiple to-be-processed virtual element nodes is adjusted or multiple target to-be-processed virtual element nodes in the multiple to-be-processed virtual element nodes are spliced to obtain an adjusted virtual element node list; the adjusted virtual element node list is rendered to generate a target adjusted stream file, and the target adjusted stream file is transmitted to the preset server.

[0012] The second aspect of the present invention provides a data updating device based on a multidimensional cross-table, comprising: an acquisition module for acquiring a data processing request and a multidimensional cross-table, wherein the data processing request includes at least a data interception request identifier and a data splicing request identifier; a screenshot module for calling a preset browser to take a screenshot of the multidimensional cross-table according to the data interception request identifier to obtain a target virtual web page screenshot; a rendering module for reading a plurality of virtual element nodes to be processed from the target virtual web page screenshot, and rendering the plurality of virtual element nodes to be processed to obtain a target stream file to be processed; a splicing module for splicing the target stream file to be processed with other preset documents to be spliced according to the data splicing request identifier to obtain a target stream file to be sent; and a transmission module for transmitting the target stream file to be sent to a target preset server.

[0013] Optionally, in a first implementation method of the second aspect of the present invention, the rendering module includes: a reading unit, used to read multiple virtual element nodes to be processed from the target virtual web page screenshot, and the virtual element nodes to be processed are used to constitute the target virtual web page screenshot; a node processing unit, used to perform preset processing on the multiple virtual element nodes to be processed to generate a virtual document object; and a rendering unit, used to render the virtual document object to generate a target stream file to be processed.

[0014] Optionally, in a second implementation method of the second aspect of the present invention, the node processing unit is specifically used to: clone the multiple virtual element nodes to be processed to obtain multiple initial clone element nodes; use a preset style function to add styles to the multiple initial clone element nodes to obtain multiple target clone element nodes; perform virtual node processing on the multiple target clone element nodes to obtain virtual document objects.

[0015] Optionally, in a third implementation method of the second aspect of the present invention, the rendering unit is specifically used to: perform recursive operations on the virtual document object based on the parent-child nodes and stacking relationships in the virtual document object to obtain a target rendering queue, wherein the target rendering queue includes multiple target rendering items arranged in sequence; read the target style information corresponding to each target clone element node from the multiple target clone element nodes to obtain multiple target style information; call the preset style setting function in the preset browser to render the target rendering queue based on the multiple target style information to obtain the target file encoding; call the preset read and write function in the preset browser to convert the target file encoding into a target to-be-processed stream file.

[0016] Optionally, in a fourth implementation method of the second aspect of the present invention, the splicing module is specifically used to: obtain other preset documents to be spliced, and extract multiple other virtual element nodes from the other preset documents to be spliced; splice the multiple other virtual element nodes with the multiple virtual element nodes to be processed to obtain a spliced virtual element node list; process the spliced virtual element node list to generate a spliced virtual document object; render the spliced virtual document object to generate a target stream file to be sent.

[0017] Optionally, in a fifth implementation of the second aspect of the present invention, the data update device based on a multidimensional cross-table further includes: an adjustment module, configured to read a data adjustment request identifier from the data processing request, obtain a target adjusted stream file based on the data adjustment request identifier and the target to-be-processed stream file, and transmit the target adjusted stream file to the target preset server; or, an adding module, configured to read a security addition request identifier from the data processing request, obtain a target security stream file based on the security addition request identifier and the target to-be-processed stream file, and transmit the target security stream file to the target preset server.

[0018] Optionally, in a sixth implementation method of the second aspect of the present invention, the adjustment module is specifically used to: when reading a data adjustment request identifier from the data processing request, adjust the order of the multiple virtual element nodes to be processed or splice multiple target virtual element nodes to be processed among the multiple virtual element nodes to be processed to obtain an adjusted virtual element node list; render the adjusted virtual element node list, generate a target adjusted stream file, and transmit the target adjusted stream file to the preset server.

[0019] The third aspect of the present invention provides a data update device based on a multidimensional cross-tabulation, comprising: a memory and at least one processor, wherein instructions are stored in the memory, and the memory and the at least one processor are interconnected via lines; the at least one processor calls the instructions in the memory so that the data update device based on the multidimensional cross-tabulation executes the above-mentioned data update method based on the multidimensional cross-tabulation.

[0020] A fourth aspect of the present invention provides a computer-readable storage medium, wherein the computer-readable storage medium stores instructions, which, when executed on a computer, enable the computer to execute the above-mentioned data updating method based on the multidimensional cross-tabulation table.

[0021] In the technical solution provided by the present invention, a data processing request and a multidimensional cross-tab are obtained, and the data processing request includes at least a data interception request identifier and a data splicing request identifier; a preset browser is called to take a screenshot of the multidimensional cross-tab according to the data interception request identifier to obtain a target virtual web page screenshot; multiple virtual element nodes to be processed are read from the target virtual web page screenshot, and the multiple virtual element nodes to be processed are rendered to obtain a target stream file to be processed; the target stream file to be processed is spliced with other preset documents to be spliced according to the data splicing request identifier to obtain a target stream file to be sent; the target stream file to be sent is transmitted to a target preset server. In an embodiment of the present invention, a virtual web page screenshot is taken of the multidimensional cross-tab according to the data processing request, a target stream file to be processed is generated according to the virtual web page screenshot, and the target stream file to be processed is spliced with other content documents according to the data processing request and the virtual element node to obtain a target stream file to be sent; the problem of being unable to merge the multidimensional cross-tab with other content documents is solved, and the integrity and comprehensiveness of the target stream file to be sent are improved. BRIEF DESCRIPTION OF THE DRAWINGS

[0022] Figure 1 A schematic diagram of an embodiment of a data updating method based on a multidimensional cross table according to an embodiment of the present invention;

[0023] Figure 2 Schematic diagram of another embodiment of a data updating method based on a multidimensional cross table according to an embodiment of the present invention;

[0024] Figure 3 A schematic diagram of an embodiment of a data updating device based on a multidimensional cross table according to an embodiment of the present invention;

[0025] Figure 4 Schematic diagram of another embodiment of a data updating device based on a multidimensional cross table in an embodiment of the present invention;

[0026] Figure 5The figure is a schematic diagram of an embodiment of a data updating device based on a multidimensional cross table in an embodiment of the present invention. DETAILED DESCRIPTION

[0027] An embodiment of the present invention provides a data update method, apparatus, device and storage medium based on a multidimensional cross-tabulation, which is used to take a virtual web page screenshot of the multidimensional cross-tabulation according to a data processing request, generate a target to-be-processed stream file according to the virtual web page screenshot, and splice the target to-be-processed stream file with other content documents according to the data processing request and the virtual element node to obtain a target to-be-sent stream file; solves the problem of being unable to merge the multidimensional cross-tabulation with other content documents, and improves the integrity and comprehensiveness of the target to-be-sent stream file.

[0028] The terms "first," "second," "third," "fourth," and the like (if any) in the description and claims of the present invention and in the accompanying drawings are used to distinguish similar objects and are not necessarily used to describe a particular order or precedence. It should be understood that the terms used in this manner are interchangeable where appropriate so that the embodiments described herein can be implemented in an order other than that illustrated or described herein. In addition, the terms "including" or "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product, or apparatus that includes a series of steps or units is not necessarily limited to those steps or units explicitly listed, but may include other steps or units that are not explicitly listed or that are inherent to these processes, methods, products, or apparatus.

[0029] For ease of understanding, the specific process of the embodiment of the present invention is described below. Figure 1 In one embodiment of the present invention, a data updating method based on a multidimensional cross table includes:

[0030] 101. Obtain a data processing request and a multidimensional crosstab. The data processing request includes at least a data interception request identifier and a data splicing request identifier.

[0031] The server obtains a multidimensional cross table and a data processing request including at least a data interception request identifier and a data splicing identifier.

[0032] A multidimensional crosstab is set in a multidimensional crosstab area. The data processing request includes at least a data interception request identifier and a data splicing request identifier. The data interception request identifier can be intercepting data report A or intercepting data report B. The data splicing request identifier can be splicing data report A to be sent with a preset document to be spliced A. Both data report A and data report B are intercepted from the multidimensional crosstab.

[0033] It is understandable that the execution subject of the present invention can be a data updating device based on a multidimensional cross table, or a terminal or a server, which is not limited here. The embodiment of the present invention is described by taking the server as the execution subject as an example.

[0034] 102. Calling a preset browser to take a screenshot of the multidimensional cross table according to the data interception request identifier to obtain a screenshot of a target virtual web page;

[0035] The server calls the preset browser to intercept the multidimensional cross table according to the data interception request identifier to obtain a screenshot of the target virtual web page.

[0036] In this embodiment, the preset browser is phantomjs, and phantomjs can be regarded as a script version of the WebKit browser. The virtual web page content corresponding to the multidimensional cross-table is loaded through the preset browser phantomjs, and then the corresponding virtual web page content is intercepted in the preset graphic container according to the data interception request identifier to obtain a screenshot of the target virtual web page.

[0037] For example, the data interception request identifier is to intercept data report A1. The server further parses the data interception request identifier to obtain the size and starting item of the data report A1. Then the server calls phantomjs to load the virtual web page content A2 corresponding to the size and starting item of the data report A1, intercepts the virtual web page content A2, and converts the virtual web page content A2 into the target virtual web page screenshot A3.

[0038] 103. Read multiple virtual element nodes to be processed from the target virtual webpage screenshot, and render the multiple virtual element nodes to be processed to obtain a target stream file to be processed;

[0039] The server obtains the target stream file to be processed according to the multiple virtual element nodes to be processed in the target virtual webpage screenshot. The target stream file to be processed can be integrated and spliced with other documents.

[0040] The server reads multiple virtual element nodes to be processed from the target virtual web page screenshot, fills the multiple virtual element nodes to be processed into a read-write list, and then reads the attribute information of each virtual element node to be processed. Secondly, the multiple virtual element nodes to be processed in the read-write list are sorted according to the attribute information of each virtual element node to be processed to obtain a target rendering queue. Then, the server renders the target queue according to the order of the target rendering queue based on the preset style function to obtain a set of target file encodings, and finally calls the preset read-write function in the preset browser to process the target file encoding into a target stream file to be processed.

[0041] It should be noted that in this embodiment, the attribute information is the time information of the virtual element node to be processed. The virtual element node information with an earlier time is placed in front of the target rendering queue, and the virtual element node information with a later time is placed in the back of the target rendering queue. In other embodiments, the attribute information can also be other information.

[0042] 104. Splice the target stream file to be processed with other preset documents to be spliced according to the data splicing request identifier to obtain the target stream file to be sent;

[0043] The server identifies the target stream file to be processed and other preset documents to be spliced according to the data splicing request, and obtains the target stream file to be sent.

[0044] The essence of splicing the data in the multidimensional cross table with other preset documents to be spliced is to combine the virtual element nodes to be processed in the target stream file to be processed with other virtual nodes in other preset documents to be spliced, so as to obtain the spliced virtual element nodes, and then clone, render and other processes are performed based on the spliced virtual element nodes to obtain the target stream file object to be sent.

[0045] For example, the data splicing request is identified as merging the target to-be-processed stream file B1 with the preset to-be-spliced document B2. The server obtains multiple to-be-processed virtual element nodes B3 from the target to-be-processed stream file B1, and the service obtains multiple other element nodes B4 from the preset to-be-spliced document B2. The multiple to-be-processed virtual element nodes B3 and the multiple other element nodes B4 are then spliced together to obtain multiple spliced virtual element nodes B5. The server finally renders the multiple spliced virtual element nodes B5 into the target to-be-sent stream file B6.

[0046] 105. Transmit the target stream file to be sent to the target pre-configured server.

[0047] The server obtains an application programming interface (API) interface address of a target pre-configured server, and transmits the target stream file to be sent to the target pre-configured server according to the API interface address.

[0048] It should be noted that the target stream file to be sent can be transmitted to multiple target pre-configured servers.

[0049] In an embodiment of the present invention, a virtual web page screenshot is taken of a multidimensional cross-tab according to a data processing request, a target stream file to be processed is generated according to the virtual web page screenshot, and the target stream file to be processed is spliced with other content documents according to the data processing request and the virtual element node to obtain a target stream file to be sent; this solves the problem of being unable to merge a multidimensional cross-tab with other content documents, and improves the integrity and comprehensiveness of the target stream file to be sent.

[0050] See also Figure 2 Another embodiment of the data updating method based on the multidimensional cross table in the embodiment of the present invention includes:

[0051] 201. Obtain a data processing request and a multidimensional cross table. The data processing request includes at least a data interception request identifier and a data splicing request identifier.

[0052] The server obtains a multidimensional cross table and a data processing request including at least a data interception request identifier and a data splicing identifier.

[0053] A multidimensional crosstab is set in a multidimensional crosstab area. The data processing request includes at least a data interception request identifier and a data splicing request identifier. The data interception request identifier can be intercepting data report A or intercepting data report B. The data splicing request identifier can be splicing data report A to be sent with a preset document to be spliced A. Both data report A and data report B are intercepted from the multidimensional crosstab.

[0054] 202. Calling a preset browser to take a screenshot of the multidimensional cross table according to the data interception request identifier to obtain a screenshot of a target virtual web page;

[0055] The server calls the preset browser to intercept the multidimensional cross table according to the data interception request identifier to obtain a screenshot of the target virtual web page.

[0056] In this embodiment, the preset browser is phantomjs, and phantomjs can be regarded as a script version of the WebKit browser. The virtual web page content corresponding to the multidimensional cross-table is loaded through the preset browser phantomjs, and then the corresponding virtual web page content is intercepted in the preset graphic container according to the data interception request identifier to obtain a screenshot of the target virtual web page.

[0057] For example, the data interception request identifier is to intercept data report A1. The server further parses the data interception request identifier to obtain the size and starting item of the data report A1. Then the server calls phantomjs to load the virtual web page content A2 corresponding to the size and starting item of the data report A1, intercepts the virtual web page content A2, and converts the virtual web page content A2 into the target virtual web page screenshot A3.

[0058] Specifically, the server loads the content of the virtual web page corresponding to the multidimensional cross table through phantomjs, then parses the data interception request identifier to obtain the data interception size and the starting interception identifier, intercepts from the virtual web page content corresponding to the multidimensional cross table according to the data interception size and the starting interception identifier, thereby obtaining the target virtual web page content, and converts the target virtual web page content into a target virtual web page screenshot.

[0059] For example, if the data interception request identifier is "intercept data report A1," the server parses the data interception request identifier and determines that the data interception size is 350mm*530mm, with the starting interception identifier being A4. The server intercepts the virtual webpage content corresponding to the multidimensional crosstab, starting from the starting identifier A4 and sized at 350mm*530mm, to obtain the target virtual webpage content and convert it into a target webpage screenshot.

[0060] 203. Read multiple virtual element nodes to be processed from the target virtual webpage screenshot, and render the multiple virtual element nodes to be processed to obtain a target stream file to be processed;

[0061] The server obtains the target stream file to be processed according to the multiple virtual element nodes to be processed in the target virtual webpage screenshot. The target stream file to be processed can be integrated and spliced with other documents.

[0062] The server reads multiple virtual element nodes to be processed from the target virtual web page screenshot, fills the multiple virtual element nodes to be processed into a read-write list, and then reads the attribute information of each virtual element node to be processed. Secondly, the multiple virtual element nodes to be processed in the read-write list are sorted according to the attribute information of each virtual element node to be processed to obtain a target rendering queue. Then, the server renders the target queue according to the order of the target rendering queue based on the preset style function to obtain a set of target file encodings, and finally calls the preset read-write function in the preset browser to process the target file encoding into a target stream file to be processed.

[0063] It should be noted that the screenshot of the target virtual web page can be understood as a screenshot of the virtual web page content loaded by the phantomjs browser, and the multiple virtual element nodes to be processed can be understood as multiple DOM elements obtained from the screenshot of the virtual web page content by calling the browser's standard API interface through the phantomjs browser, which are HTML tags.

[0064] Specifically, the server first recursively extracts multiple virtual element nodes to be processed from the target web page screenshot, and then clones, adds styles and processes virtual nodes based on the multiple virtual element nodes to be processed to obtain a virtual document object. Finally, the server renders according to the node relationship and target style information in this virtual document object to obtain the target stream file to be processed.

[0065] The specific process of obtaining a virtual document object is:

[0066] First, the server clones multiple virtual element nodes to be processed to obtain multiple initial clone element nodes; then the server adds styles to the multiple initial clone element nodes to obtain multiple target clone element nodes; finally, the server performs virtual node processing on the multiple target clone element nodes, that is, uses the VirtualDom algorithm to process the multiple target clone element nodes to obtain virtual document objects.

[0067] Virtual node processing can be understood as the initial rendering process: first, using the VirtualDom algorithm to render data into a Virtual DOM, then processing the Virtual DOM into a DOM. When data is updated, a new Virtual DOM is rendered. The new Virtual DOM is then diffed with the previous one to determine any required DOM changes. These changes are then applied to the DOM during the patch process to synchronize the UI. Finally, the canvas instance is called to convert these changes into Base64 encoding, which is then converted into a virtual document object using the node read and write streams.

[0068] The specific process of obtaining the target stream file to be processed is:

[0069] First, the server performs recursive operations based on the stacking relationship between parent-child nodes and nodes in the virtual document object, thereby obtaining a target rendering queue including multiple target rendering items arranged in sequence. Secondly, the server calls a preset style setting function to render multiple virtual element nodes to be processed in the order of the target rendering queue according to the target style information obtained above, and obtains a set of target file encodings. Finally, the server calls a preset read and write function to convert the target file encoding into a target stream file to be processed.

[0070] 204. Splice the target stream file to be processed with other preset documents to be spliced according to the data splicing request identifier to obtain the target stream file to be sent;

[0071] The server identifies the target stream file to be processed and other preset documents to be spliced according to the data splicing request, and obtains the target stream file to be sent.

[0072] The essence of splicing the data in the multidimensional cross table with other preset documents to be spliced is to combine the virtual element nodes to be processed in the target stream file to be processed with other virtual nodes in other preset documents to be spliced, so as to obtain the spliced virtual element nodes, and then clone, render and other processes are performed based on the spliced virtual element nodes to obtain the target stream file object to be sent.

[0073] For example, the ultimate purpose of the data splicing request identifier is to merge the target to-be-processed stream file B1 of the bond issuance rate with the preset to-be-spliced document B2 of the financial product yield. The server obtains multiple to-be-processed virtual element nodes B3 from the target to-be-processed stream file B1 of the bond issuance rate, and the service obtains multiple other element nodes B4 from the preset to-be-spliced document B2 of the financial product yield. The multiple to-be-processed virtual element nodes B3 and the multiple other element nodes B4 are then spliced together to obtain multiple spliced virtual element nodes B5. The server finally renders the multiple spliced virtual element nodes B5 into the target to-be-sent stream file B6 that combines the bond issuance rate and the financial product yield. The target to-be-sent stream file B6 obtained after merging the bond issuance rate and the financial product yield is an important indicator for macroeconomic analysis and provides an important basis for macroeconomic research.

[0074] Specifically, the server extracts multiple other virtual element nodes from multiple other preset documents to be spliced, splices the multiple other element nodes and the multiple virtual element nodes to be processed, and obtains a list of spliced virtual element nodes; then the server obtains the spliced virtual document object based on the spliced virtual element nodes in accordance with the method of step 203, and finally renders the spliced virtual document object into the target stream file to be sent in accordance with the rendering method of step 203.

[0075] 205. Transmit the target stream file to be sent to the target pre-configured server;

[0076] The server obtains the API interface address of the target pre-configured server and transmits the target stream file to be sent to the target pre-configured server according to the API interface address.

[0077] It should be noted that the target stream file to be sent may be transmitted to a plurality of different target pre-configured servers.

[0078] 206. Read the data adjustment request identifier from the data processing request, obtain the target adjusted stream file based on the data adjustment request identifier and the target stream file to be processed, and transmit the target adjusted stream file to the target pre-configured server;

[0079] or,

[0080] 207 . Read the security addition request identifier from the data processing request, obtain a target security stream file based on the security addition request identifier and the target stream file to be processed, and transmit the target security stream file to the target pre-configured server.

[0081] The data processing request may also include a data adjustment request identifier or a security addition request identifier. The data adjustment request identifier can be used to adjust the order of content data in the target to-be-processed stream file. The security addition request identifier can be used to add a security identifier to the target to-be-processed stream file. The specific security identifier can be the user name and the date of addition.

[0082] Specifically, since the data adjustment request identifier and the security addition request identifier read from the data processing request ultimately result in different data results, the following description will be made based on two cases.

[0083] When a data adjustment request identifier is read from a data processing request, the server adjusts the order of multiple virtual element nodes to be processed or splices some of the multiple virtual element nodes to be processed, that is, multiple target virtual element nodes to be processed, thereby obtaining an adjusted virtual element node list; the server renders the adjusted virtual element node list according to the rendering method of the above step 203, generates a target adjusted stream file, and transmits the target adjusted stream file to the preset server.

[0084] When a security addition request identifier is read from a data processing request, the server reads multiple virtual element nodes to be processed and fills the multiple virtual element nodes to be processed into a read-write list to obtain a list of virtual element nodes to be processed. The server then extracts the security virtual element node corresponding to the preset security request identifier and adds the security virtual element node to the list of virtual element nodes to be processed to obtain a list of security virtual element nodes. Finally, the server renders the adjusted virtual element node list according to the rendering method of step 203 to obtain the target security stream file and transmits the target security stream file to the preset server.

[0085] For example, if the security addition request is identified as "Add 123456 security watermark", the server obtains the security virtual element node C1 corresponding to the "123456 security watermark", and then the server adds the security virtual element node C1 to the list of virtual element nodes to be processed C2, and obtains the security virtual element node list C3. Finally, the server renders the security virtual element node list, obtains the target security stream file C4, and transmits the target security stream file to the preset server.

[0086] In an embodiment of the present invention, a virtual web page screenshot is taken of a multidimensional cross-tab according to a data processing request, a target stream file to be processed is generated according to the virtual web page screenshot, and the target stream file to be processed is spliced with other content documents according to the data processing request and the virtual element node to obtain a target stream file to be sent; this solves the problem of being unable to merge a multidimensional cross-tab with other content documents, and improves the integrity and comprehensiveness of the target stream file to be sent.

[0087] The above describes the data updating method based on the multidimensional cross table in the embodiment of the present invention. The following describes the data updating device based on the multidimensional cross table in the embodiment of the present invention. Figure 3 In one embodiment of the present invention, a data updating device based on a multidimensional cross table includes:

[0088] An acquisition module 301 is configured to acquire a data processing request and a multidimensional cross-tabulation table, wherein the data processing request includes at least a data interception request identifier and a data splicing request identifier;

[0089] A screenshot module 302 is configured to call a preset browser to take a screenshot of the multidimensional cross table according to the data interception request identifier, thereby obtaining a screenshot of a target virtual web page;

[0090] The rendering module 303 is configured to read a plurality of virtual element nodes to be processed from the target virtual webpage screenshot, and render the plurality of virtual element nodes to be processed to obtain a target stream file to be processed;

[0091] A splicing module 304 is configured to splice the target stream file to be processed with other preset documents to be spliced according to the data splicing request identifier to obtain a target stream file to be sent;

[0092] The transmission module 305 is configured to transmit the target stream file to be sent to a target pre-configured server.

[0093] In an embodiment of the present invention, a virtual web page screenshot is taken of a multidimensional cross-tab according to a data processing request, a target stream file to be processed is generated according to the virtual web page screenshot, and the target stream file to be processed is spliced with other content documents according to the data processing request and the virtual element node to obtain a target stream file to be sent; this solves the problem of being unable to merge a multidimensional cross-tab with other content documents, and improves the integrity and comprehensiveness of the target stream file to be sent.

[0094] See also Figure 4 Another embodiment of the data updating device based on the multidimensional cross table in the embodiment of the present invention includes:

[0095] An acquisition module 301 is configured to acquire a data processing request and a multidimensional cross-tabulation table, wherein the data processing request includes at least a data interception request identifier and a data splicing request identifier;

[0096] A screenshot module 302 is configured to call a preset browser to take a screenshot of the multidimensional cross table according to the data interception request identifier, thereby obtaining a screenshot of a target virtual web page;

[0097] The rendering module 303 is configured to read a plurality of virtual element nodes to be processed from the target virtual webpage screenshot, and render the plurality of virtual element nodes to be processed to obtain a target stream file to be processed;

[0098] A splicing module 304 is configured to splice the target stream file to be processed with other preset documents to be spliced according to the data splicing request identifier to obtain a target stream file to be sent;

[0099] The transmission module 305 is configured to transmit the target stream file to be sent to a target pre-configured server.

[0100] Optionally, the rendering module 303 includes:

[0101] A reading unit 3031 is configured to read a plurality of to-be-processed virtual element nodes from the target virtual webpage screenshot, where the to-be-processed virtual element nodes are used to constitute the target virtual webpage screenshot;

[0102] The node processing unit 3032 is configured to perform preset processing on the plurality of virtual element nodes to be processed to generate a virtual document object;

[0103] The rendering unit 3033 is configured to render the virtual document object and generate a target stream file to be processed.

[0104] Optionally, the node processing unit 3032 may also be specifically configured to:

[0105] Cloning the multiple virtual element nodes to be processed to obtain multiple initial cloned element nodes;

[0106] Adding styles to the multiple initial cloned element nodes using a preset style function to obtain multiple target cloned element nodes;

[0107] The multiple target clone element nodes are processed as virtual nodes to obtain virtual document objects.

[0108] Optionally, the rendering unit 3033 may also be specifically configured to:

[0109] Based on the parent-child nodes and the stacking relationship in the virtual document object, recursively operate the virtual document object to obtain a target rendering queue, wherein the target rendering queue includes a plurality of target rendering items arranged in sequence;

[0110] Reading target style information corresponding to each target clone element node from the multiple target clone element nodes to obtain multiple target style information;

[0111] Calling a preset style setting function in a preset browser, rendering the target rendering queue based on the multiple target style information, and obtaining a target file encoding;

[0112] The preset read and write functions in the preset browser are called to convert the target file encoding into a target stream file to be processed.

[0113] Optionally, the splicing module 304 may also be specifically configured to:

[0114] Obtaining other preset documents to be spliced, and extracting a plurality of other virtual element nodes from the other preset documents to be spliced;

[0115] splicing the multiple other virtual element nodes with the multiple virtual element nodes to be processed to obtain a spliced virtual element node list;

[0116] Processing the spliced virtual element node list to generate a spliced virtual document object;

[0117] Render the spliced virtual document object to generate a target stream file to be sent.

[0118] Optionally, the data updating device based on the multidimensional cross table further includes:

[0119] An adjustment module 306 is configured to read a data adjustment request identifier from the data processing request, obtain a target adjusted stream file based on the data adjustment request identifier and the target stream file to be processed, and transmit the target adjusted stream file to the target pre-configured server;

[0120] Alternatively, the adding module 307 is configured to read a security adding request identifier from the data processing request, obtain a target security stream file based on the security adding request identifier and the target stream file to be processed, and transmit the target security stream file to the target pre-set server.

[0121] Optionally, the adjustment module 306 may also be specifically configured to:

[0122] When the data adjustment request identifier is read from the data processing request, the order of the plurality of to-be-processed virtual element nodes is adjusted or a plurality of target to-be-processed virtual element nodes among the plurality of to-be-processed virtual element nodes are spliced to obtain an adjusted virtual element node list;

[0123] Rendering the adjusted virtual element node list, generating a target adjusted stream file, and transmitting the target adjusted stream file to the preset server.

[0124] In an embodiment of the present invention, a virtual web page screenshot is taken of a multidimensional cross-tab according to a data processing request, a target stream file to be processed is generated according to the virtual web page screenshot, and the target stream file to be processed is spliced with other content documents according to the data processing request and the virtual element node to obtain a target stream file to be sent; this solves the problem of being unable to merge a multidimensional cross-tab with other content documents, and improves the integrity and comprehensiveness of the target stream file to be sent.

[0125] above Figure 3 and Figure 4 The data updating device based on the multidimensional cross table in the embodiment of the present invention is described in detail from the perspective of modular functional entities. The data updating device based on the multidimensional cross table in the embodiment of the present invention is described in detail from the perspective of hardware processing.

[0126] Figure 5 : This is a structural diagram of a data update device based on a multidimensional cross-tabulation provided by an embodiment of the present invention. The data update device 500 based on a multidimensional cross-tabulation may have relatively large differences due to different configurations or performances, and may include one or more processors (central processing units, CPU) 510 (for example, one or more processors) and a memory 520, and one or more storage media 530 (for example, one or more massive storage devices) for storing application programs 533 or data 532. Among them, the memory 520 and the storage medium 530 can be short-term storage or permanent storage. The program stored in the storage medium 530 may include one or more modules (not shown in the figure), and each module may include a series of instruction operations in the data update device 500 based on a multidimensional cross-tabulation. Furthermore, the processor 510 may be configured to communicate with the storage medium 530 to execute a series of instruction operations in the storage medium 530 on the data update device 500 based on a multidimensional cross-tabulation.

[0127] The data updating device 500 based on the multidimensional cross-table may further include one or more power supplies 540, one or more wired or wireless network interfaces 550, one or more input and output interfaces 560, and / or one or more operating systems 531, such as Windows Server, Mac OS X, Unix, Linux, FreeBSD, etc. It will be understood by those skilled in the art that Figure 5 The illustrated structure of the data update device based on the multidimensional cross table does not limit the data update device based on the multidimensional cross table, and may include more or fewer components than shown in the figure, or combine certain components, or arrange the components differently.

[0128] The present invention also provides a computer-readable storage medium, which can be a non-volatile computer-readable storage medium or a volatile computer-readable storage medium. The computer-readable storage medium stores instructions, which, when executed on a computer, enable the computer to execute the steps of the data update method based on a multidimensional cross-tabulation table.

[0129] Furthermore, the computer-usable storage medium may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application required for at least one function, etc.; the data storage area may store data created according to the use of the blockchain node, etc.

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

[0131] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention is essentially or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product. The computer software product is stored in a storage medium and includes several instructions for enabling a computer device (which can be a personal computer, server, or network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM), random access memory (RAM), magnetic disk or optical disk, etc., various media that can store program code.

[0132] Blockchain, as used in this article, refers to a novel application model for computer technologies such as distributed data storage, peer-to-peer transmission, consensus mechanisms, and encryption algorithms. Blockchain is essentially a decentralized database, a series of data blocks generated using cryptographic methods. Each block contains information about a batch of online transactions, used to verify the validity of this information (to prevent counterfeiting) and generate the next block. Blockchain can include the underlying blockchain platform, the platform product service layer, and the application service layer.

[0133] As described above, the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit the same. Although the present invention has been described in detail with reference to the above embodiments, those skilled in the art should understand that the technical solutions described in the above embodiments can still be modified, or some of the technical features thereof can be replaced by equivalents. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A data updating method based on a multidimensional cross table, characterized in that: The data updating method based on the multidimensional cross table includes: Obtaining a data processing request and a multidimensional cross table, wherein the data processing request at least includes a data interception request identifier and a data splicing request identifier; Calling a preset browser to take a screenshot of the multidimensional cross table according to the data interception request identifier to obtain a screenshot of a target virtual web page; Reading a plurality of to-be-processed virtual element nodes from the target virtual webpage screenshot, and rendering the plurality of to-be-processed virtual element nodes to obtain a target to-be-processed stream file; splicing the target stream file to be processed with other preset documents to be spliced according to the data splicing request identifier to obtain a target stream file to be sent; Transmitting the target stream file to be sent to the target pre-configured server; The method of reading multiple to-be-processed virtual element nodes from the target virtual web page screenshot and rendering the multiple to-be-processed virtual element nodes to obtain a target to-be-processed stream file includes: reading multiple to-be-processed virtual element nodes from the target virtual web page screenshot, where the to-be-processed virtual element nodes are used to constitute the target virtual web page screenshot; cloning the multiple to-be-processed virtual element nodes to obtain multiple initial cloned element nodes; adding styles to the multiple initial cloned element nodes using a preset style function to obtain multiple target cloned element nodes; performing virtual node processing on the multiple target cloned element nodes to obtain a virtual document object; recursively operating the virtual document object based on the parent-child nodes and stacking relationships in the virtual document object to obtain a target rendering queue, where the target rendering queue includes multiple target rendering items arranged in sequence; reading target style information corresponding to each target cloned element node from the multiple target cloned element nodes to obtain multiple target style information; calling a preset style setting function in a preset browser to render the target rendering queue based on the multiple target style information to obtain a target file code; and calling a preset read-write function in the preset browser to convert the target file code into a target to-be-processed stream file.

2. The data updating method based on multidimensional cross table according to claim 1, characterized in that: The step of splicing the target stream file to be processed with other preset documents to be spliced according to the data splicing request identifier to obtain the target stream file to be sent includes: Obtaining other preset documents to be spliced, and extracting a plurality of other virtual element nodes from the other preset documents to be spliced; splicing the multiple other virtual element nodes with the multiple virtual element nodes to be processed to obtain a spliced virtual element node list; Processing the spliced virtual element node list to generate a spliced virtual document object; Render the spliced virtual document object to generate a target stream file to be sent.

3. The data updating method based on a multidimensional cross table according to any one of claims 1 to 2, characterized in that: After transmitting the target stream file to be sent to the target preset server, the data updating method based on the multidimensional cross table further includes: Reading a data adjustment request identifier from the data processing request, obtaining a target adjusted stream file based on the data adjustment request identifier and the target stream file to be processed, and transmitting the target adjusted stream file to the target pre-configured server; or, A security addition request identifier is read from the data processing request, a target security stream file is obtained based on the security addition request identifier and the target stream file to be processed, and the target security stream file is transmitted to the target pre-set server.

4. The data updating method based on multidimensional cross table according to claim 3 is characterized in that: The step of reading a data adjustment request identifier from the data processing request, obtaining a target adjusted stream file based on the data adjustment request identifier and the target stream file to be processed, and transmitting the target adjusted stream file to the target pre-configured server includes: When the data adjustment request identifier is read from the data processing request, the order of the plurality of to-be-processed virtual element nodes is adjusted or a plurality of target to-be-processed virtual element nodes among the plurality of to-be-processed virtual element nodes are spliced to obtain an adjusted virtual element node list; Rendering the adjusted virtual element node list, generating a target adjusted stream file, and transmitting the target adjusted stream file to the preset server.

5. A data updating device based on a multidimensional cross table, characterized in that: The data updating device based on the multidimensional cross table includes: An acquisition module, configured to acquire a data processing request and a multidimensional cross table, wherein the data processing request includes at least a data interception request identifier and a data splicing request identifier; A screenshot module, configured to call a preset browser to take a screenshot of the multidimensional cross table according to the data interception request identifier, and obtain a screenshot of a target virtual web page; A rendering module, configured to read a plurality of to-be-processed virtual element nodes from the target virtual webpage screenshot, and render the plurality of to-be-processed virtual element nodes to obtain a target to-be-processed stream file; A splicing module, configured to splice the target stream file to be processed with other preset documents to be spliced according to the data splicing request identifier to obtain a target stream file to be sent; A transmission module, configured to transmit the target stream file to be sent to a target pre-set server; The method of reading multiple to-be-processed virtual element nodes from the target virtual web page screenshot and rendering the multiple to-be-processed virtual element nodes to obtain a target to-be-processed stream file includes: reading multiple to-be-processed virtual element nodes from the target virtual web page screenshot, where the to-be-processed virtual element nodes are used to constitute the target virtual web page screenshot; cloning the multiple to-be-processed virtual element nodes to obtain multiple initial cloned element nodes; adding styles to the multiple initial cloned element nodes using a preset style function to obtain multiple target cloned element nodes; performing virtual node processing on the multiple target cloned element nodes to obtain a virtual document object; recursively operating the virtual document object based on the parent-child nodes and stacking relationships in the virtual document object to obtain a target rendering queue, where the target rendering queue includes multiple target rendering items arranged in sequence; reading target style information corresponding to each target cloned element node from the multiple target cloned element nodes to obtain multiple target style information; calling a preset style setting function in a preset browser to render the target rendering queue based on the multiple target style information to obtain a target file code; and calling a preset read-write function in the preset browser to convert the target file code into a target to-be-processed stream file.

6. A data updating device based on a multidimensional cross table, characterized in that: The data updating device based on the multidimensional cross table includes: a memory and at least one processor, wherein the memory stores instructions, and the memory and the at least one processor are interconnected via a line; The at least one processor calls the instructions in the memory to enable the multidimensional cross-table-based data updating device to execute the multidimensional cross-table-based data updating method according to any one of claims 1 to 4.

7. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the data updating method based on a multidimensional cross table according to any one of claims 1 to 4 is implemented.

Citation Information

Patent Citations

  • Method, client and system for loading screenshot into file

    CN102663793A

  • Page conversion method and page conversion device

    CN110442343A