Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and system for realizing sorting of tree-shaped hierarchical structure report data

A hierarchical structure and report data technology, applied in structured data browsing, structured data retrieval, visual data mining, etc., can solve problems such as inability to reprocess data, affect user experience, and inability to multi-level data

Pending Publication Date: 2019-12-13
江苏优瀛科技有限公司
View PDF6 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] At present, the sorting of statistical data is mainly achieved through the table control to sort simple table data. This table control can only sort single-level data but not multi-level data, and single-level tables reach dozens of columns and thousands of rows. = When there are close to 100,000 data units, sorting will take tens of seconds or even more time, and the processing is very slow, affecting user experience
This sorting method usually cannot process the sorted data again after the current sorting is completed, and when there is a lot of data, the operation is slow, error-prone, and user experience is also low

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system for realizing sorting of tree-shaped hierarchical structure report data
  • Method and system for realizing sorting of tree-shaped hierarchical structure report data
  • Method and system for realizing sorting of tree-shaped hierarchical structure report data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0024] figure 1 It is an application scene diagram of the embodiment of the present invention. Such as figure 1 As shown, the container used to realize the tree-like hierarchical structure report can be located on the browser side.

[0025] The container includes column header area, row header area and data area. The event response is set in the row header area. You can click the row header area to display the tree hierarchy report hierarchically, and then you can click the column header area of ​​the column to be sorted to realize the sorting function. The column header area is set with an event response.

[0026] The working process is as follows: click the column header of a certain column, and the container receives the mouse operation event, that is, it judges that a sorting action is required; the container finds the corresponding sorting algorithm according to the query attribute of the report; the sorting action of the container will collect the sorting column Infor...

Embodiment 2

[0031] figure 2 The embodiment of the present invention provides a flow chart of a method for sorting data in a tree-like hierarchical structure report. This method is applied to the container corresponding to a tree-level report (such as figure 1 shown), the container includes: column header area, row header area and data area, the column header area sets the column header event response, the column header event response is used to respond to the operation of any column in the data area, the row header area sets the row header event response, The row header event is used to respond to the operation of any row in the data area. Such as figure 2 As shown, the method for realizing the sorting of tree-like hierarchical report data includes the following steps:

[0032] Step S201: Obtain the sorting request from the column header area and the row header area, and construct a sorting array according to the sorting request and the data in the tree hierarchy report, wherein the ...

Embodiment 3

[0056] Figure 4 The embodiment of the present invention provides a flow chart of another method for sorting tree-structured report data. Such as Figure 4 As shown, the method for realizing the sorting of tree-like hierarchical report data includes the following steps:

[0057] Step S401: Obtain the data in the tree-like hierarchical structure report according to the sorting request, and create a sorting array corresponding to the data according to the data. The sorting request includes original data information and original data information and tree-like hierarchical structure Report mapping relationship.

[0058] Specifically, the user clicks the column header of a column in the tree hierarchy report to obtain the original data information from the temporary storage area of ​​the column in the container

[0059] It should be noted that the sort order value is stored in the temporary storage area of ​​the column of the container, and each time a sort action is triggered, ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method and system for realizing sorting of tree-shaped hierarchical structure report data, and the method comprises the steps: obtaining a sorting request from a column header region and a row header region, and constructing a sorting array according to the sorting request and a tree-shaped hierarchical structure report, wherein the sorting request comprises original datainformation and the original data information comprises row data under all levels or any level node in the tree-shaped level report corresponding to the column header region and column data corresponding to any region in the column header region; starting from a root node of the tree-shaped hierarchical structure report, marking serial numbers for the data lines, and storing data addresses and serial numbers of the data lines and values of sorting fields into a sorting array; according to the original data information, obtaining data corresponding to the original data information from the sorting array, and carrying out sorting according to values of sorting fields of the data; and writing the sorted data back to the data area.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a method and system for realizing data sorting of a tree-like hierarchical structure report. Background technique [0002] At present, the sorting of statistical data is mainly achieved through the table control to sort simple table data. This table control can only sort single-level data but not multi-level data, and single-level tables reach dozens of columns and thousands of rows. = When there are close to 100,000 data units, sorting will take tens of seconds or more, and the processing is very slow, affecting user experience. This sorting method usually cannot process the sorted data again after the current sorting is completed, and when there is a lot of data, the operation is slow, error-prone, and user experience is low. Contents of the invention [0003] The object of the present invention is to provide a method and system for realizing the sorting of tree-like...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F16/26G06F17/24
Inventor 殷慧敏
Owner 江苏优瀛科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com