CN112487107B - Processing method for presenting data index hierarchy and classification in electronic form - Google Patents

Processing method for presenting data index hierarchy and classification in electronic form Download PDF

Info

Publication number
CN112487107B
CN112487107B CN202011365236.7A CN202011365236A CN112487107B CN 112487107 B CN112487107 B CN 112487107B CN 202011365236 A CN202011365236 A CN 202011365236A CN 112487107 B CN112487107 B CN 112487107B
Authority
CN
China
Prior art keywords
index
area
library
classification description
information
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202011365236.7A
Other languages
Chinese (zh)
Other versions
CN112487107A (en
Inventor
李银生
吴峰
张朝宗
聂永川
王红
任雁
刘淼
张金龙
陈娟
张碟
蒋倩男
张聪
高原
高银珍
毋鹏杰
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Hebei Academy Of Science And Technology Information Hebei Academy Of Science And Technology Innovation Strategy
Original Assignee
Hebei Academy Of Science And Technology Information Hebei Academy Of Science And Technology Innovation Strategy
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Hebei Academy Of Science And Technology Information Hebei Academy Of Science And Technology Innovation Strategy filed Critical Hebei Academy Of Science And Technology Information Hebei Academy Of Science And Technology Innovation Strategy
Priority to CN202011365236.7A priority Critical patent/CN112487107B/en
Publication of CN112487107A publication Critical patent/CN112487107A/en
Application granted granted Critical
Publication of CN112487107B publication Critical patent/CN112487107B/en
Priority to US17/704,105 priority patent/US11615237B2/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2228Indexing structures
    • G06F16/2246Trees, e.g. B+trees
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • G06F16/285Clustering or classification
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/12Use of codes for handling textual entities
    • G06F40/137Hierarchical processing, e.g. outlines
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048Interaction techniques based on graphical user interfaces [GUI]
    • G06F3/0484Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
    • G06F3/04842Selection of displayed objects or displayed text elements

Abstract

The invention discloses a processing method for presenting data index levels and classifications in an electronic form, which presents indexes and levels, index classification description and levels, application scenes of the index and the index classification description and other hidden attributes in the form of the electronic form by constructing an index structure S and according to the personalized selection of a user, so that the index expression is simpler and the readability is stronger, the accurate expression of two-dimensional form data can be realized, and the presented form is easier to understand; based on the method, the indexes and the index classification description can be flexibly and variously combined and displayed, so that the presented results are more diversified, flexible and personalized.

Description

Processing method for presenting data index hierarchy and classification in electronic form
Technical Field
The invention belongs to the technical field of big data processing, and particularly relates to a processing method for presenting data index levels and classifications in a spreadsheet.
Background
In the big data governance process, the sources of data are diversified, and a table data file is one of the common types.
Most of the existing statistical data are presented in a two-dimensional table, and the actual meaning represented by each numerical value in the table needs to be understood by combining the title of the table and the index of the horizontal and vertical coordinates corresponding to the numerical value, for example, in fig. 1, the index area of the table may be divided into an X-coordinate area and a Y-coordinate area, that is, the index of the X-coordinate area is "number of enterprises (number)", "# number of enterprises with R & D activities", "# number of enterprises with technology organization", and the index of the Y-coordinate area is "total", "large", "medium", "small", "micro", and currently, the data presentation methods all adopt XY (or YX) direct combination methods. For example, the index presented by the numerical value "348" is "large-scale enterprise number", the actual meaning thereof is "enterprise number (number) divided into large-scale enterprises according to enterprise scale", the meaning can be accurately understood only by combining the original table, if the index "large-scale enterprise number (number)" is interpreted, the classification information implied by the index is difficult to accurately express and describe by calculation, in this example, the classification according to enterprise scale also includes "medium-sized", "small-sized" and "micro", and the accurate index classification description information is lost in the conventional index presentation form.
At present, the table processing technology is usually presented in a direct combination mode of abscissa indexes and ordinate indexes, for example, as shown in fig. 2, the index "large number of enterprises" is presented, and the real index is the classification description of "number of enterprises" and "large" is the index "number of enterprises". Most of new indexes formed by the XY (or YX) direct combination mode are not standard (or customary) indexes, and have the defects of overlong index names, unnormality, inaccuracy, poor readability, tarnishment and the like. Particularly, in the process of fusing multi-source data, indexes formed in such a way are difficult to form a uniform index library, large-scale combination operation of data and mining of implicit information such as the relation between indexes are not facilitated, and requirements of displaying and flexibly combining according to needs are difficult to realize.
Disclosure of Invention
The technical problem to be solved by the invention is to provide a processing method for presenting data index levels and classifications in a spreadsheet, which can enable indexes to be more concise, index level relations to be explicit and numerical expression to be clearer and more accurate.
In order to solve the technical problems, the technical scheme adopted by the invention is as follows.
A processing method for presenting data index hierarchy and classification in a spreadsheet is realized based on a D library storing numerical items, an I library storing index unit information, a C library storing index classification description unit information and an R library storing application scenes, and specifically comprises the following steps:
A1. constructing an index structure S;
A2. reading information in the I library, the C library, the D library and the R library by using an index structure builder in combination with the selection of a user, and filling an index structure S;
A3. according to the selection of a user, utilizing a hierarchical classification result presenter to iteratively extract corresponding information in the I library, the C library, the D library and the R library;
A4. and rendering the information extracted by the hierarchical classification result presenter and presenting the information to a user.
In the above processing method for presenting data index hierarchy and classification in electronic form, the index indexing structure S in step a1 includes an index area, an index classification description area, a relationship area, and a selected index area; the index area is an IA area presenting indexes and index hierarchical relations, the index classification description area is a CA area presenting index classification descriptions and hierarchical relations, the relation area is an RA area presenting application scenes between the index units and the index classification description units, corresponding source base tables and other hidden attributes, and the selected index area is an SA area presenting indexes and index classification description information selected by a user.
The processing method for presenting the data index hierarchy and classification in the electronic form includes the specific implementation method of step a 2:
A21. initializing an index structure S;
A22. reading index unit information in the I library, filling an IA area of an index structure S to form a tree-shaped hierarchical structure of indexes for a user to select;
A23. reading the corresponding relation of the index i in an R library according to the index i selected by a user, and filling an RA (random access) area of an index structure S to form an application scene R;
A24. according to the corresponding relation of the index i read from the R library, reading the index classification description C in the C library, filling a CA (certificate Authority) area of the index structure S, and forming a tree-shaped hierarchical structure of the index classification description for a user to select;
A25. and filling an SA area of the index structure S according to the index i selected by the user, the index classification description c and the application scene r.
The processing method for presenting the data index hierarchy and classification in the electronic form includes the specific implementation method of step a 3:
A31. initializing a data storage container matrix M;
A32. reading SA area information in an index structure S;
A33. reading index unit information from an I library according to the selected index information of the user in the SA area, and filling an X-axis index area of the matrix M;
A34. reading related data in a D library according to index unit information of an X-axis index area of the matrix M to generate a temporary data set DS 1;
A35. reading an index classification description unit from a C library according to the user selected index classification description information of the SA area, and filling a Y-axis index classification description area of the matrix M;
A36. reading related data in a D library according to index classification description unit information of a Y-axis index classification description area of the matrix M to generate a temporary data set DS 2;
A37. intersection of the temporary data set DS1 and the temporary data set DS2 is obtained to obtain a matrix data set DS3, and the matrix M is filled with the matrix data set DS 3.
Due to the adoption of the technical scheme, the technical progress of the invention is as follows.
The two-dimensional spreadsheet data presented by the invention can well solve the problem of dominance of implicit information such as index levels, index classification description levels and the like, has the characteristics of standardization, normalization, hierarchy and the like, is simpler in index expression, stronger in readability and easier to understand, and can realize accurate expression of the two-dimensional spreadsheet data; based on the method, the indexes and the index classification description can be flexibly and variously combined and displayed, so that the presented result is more diversified, flexible and personalized.
Drawings
FIG. 1 is a tabular representation of a conventional manual statistical data processing of the present invention;
FIG. 2 is a diagram of a prior art combined representation of statistical data;
FIG. 3 is a flow chart of the present invention;
FIG. 4 is a diagram illustrating the index structure S in step A1 according to the present invention;
FIG. 5 is a flowchart of step A2 according to the present invention;
FIG. 6 is a flowchart of step A3 according to the present invention;
FIG. 7 is a diagram illustrating an example of a padded index structure S';
FIG. 8 is a diagram of an example spreadsheet format ultimately presented by an embodiment.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and specific embodiments.
A processing method for presenting data index levels and classifications in an electronic form is realized on the basis of calling data with attributes, numerical items, indexes and levels corresponding to the numerical values, index classification descriptions and levels, application scenes of the index and the index classification descriptions and other hidden attributes are presented in the form of the electronic form according to personalized selection of a user by constructing an index structure, and accurate expression of two-dimensional form data is realized.
The data in the two-dimensional table of the invention comprises feature class data, noun class data, classification class data and statistic class data. After the data are granulated, numerical values containing self attributes are obtained, and the self attributes comprise indexes, index classification description, application scenes and the like; the index consists of five elements of index name, metering unit, time limit, space limit and application limit, and the index and the hierarchical relation thereof form an index unit; the index classification description refers to an angle for describing the index, and the index classification description and the hierarchical relationship thereof form an index classification description unit; the application scene refers to the corresponding relation between the index unit and the index classification description unit in the specific two-dimensional table, and the information of the source, the library, the table and the like corresponding to the index unit and the index classification description unit.
The attribute information is respectively stored in a numerical value library, an index classification description library and a relation library. The numerical database is a Data database, referred to as D database for short, and is used for storing numerical items, including abscissa values, ordinate values, numerical values and the like; the Index database is an Index database, called I database for short, and is used for storing Index unit information and the like; the index Classification description library is a Classification database, referred to as C library for short, and is used for storing index Classification description unit information and the like; the relational database is a relationship database, referred to as an R database for short, and is used for storing application scenarios and the like.
The processing method of the present invention has a flow as shown in fig. 3, and specifically includes the following steps.
A1. And constructing an index structure S.
The index structure S is shown in fig. 4 and includes an index area, an index classification description area, a relationship area, and a selected index area. Wherein the Index Area is an Index Area, referred to as IA Area for short, and presents an Index unit, i.e. presents the Index and the Index hierarchical relationship; the index Classification description Area is a Classification Area, called CA Area for short, and presents an index Classification description unit, namely presents index Classification description and hierarchical relationship thereof; the Relation Area is a Relation Area, namely an RA Area for short, and presents application scenes between the index unit and the index classification description unit and corresponding implicit attributes such as a source, a library, a table and the like; the Selected index Area is a Selected Area, referred to as an SA Area for short, and presents information such as indexes and index classification descriptions which have been Selected by the user.
A2. And reading information in the I library, the C library, the D library and the R library by using an index structure builder in combination with the selection of a user, and filling an index structure S.
The flow of this step is shown in fig. 5, and specifically includes the following.
A21. Index structure S is initialized.
A22. And reading the index unit information in the I library, filling an IA area of the index structure S, and forming a tree-shaped hierarchical structure of indexes for a user to select.
A23. And reading the corresponding relation of the index i in the R library according to the index i selected by the user, filling the RA area of the index structure S, and forming an application scene R.
A24. And reading the index classification description C in the C library according to the corresponding relation of the index i read in the R library, filling a CA (conditional access) area of the index structure S, and forming a tree-shaped hierarchical structure of the index classification description for a user to select.
A25. And filling an SA area of the index structure S according to the index i selected by the user, the index classification description c and the application scene r.
In the invention, no matter the tree-shaped hierarchical structure of the index or the tree-shaped hierarchical structure of the index classified description, the index hierarchy is clear, and the distribution condition of the index on different classified descriptions can be visually seen when a user selects the index, so that the required data can be found more quickly and accurately; and the index structure S after being filled can more accurately express the meaning of the data. In this embodiment, the indicator index structure S' after being filled is as shown in fig. 7.
A3. And according to the selection of the user, utilizing a hierarchical classification result presenter to iteratively extract corresponding information in the I library, the C library, the D library and the R library.
The flow of this step is shown in fig. 6, and specifically includes the following.
A31. The data storage container matrix M is initialized.
A32. The SA area information in the index structure S is read.
A33. And reading the index unit information from the I library according to the user selected index information in the SA area, and filling an X-axis index area of the matrix M.
A34. And reading related data in a D library according to the index unit information of the X-axis index area of the matrix M to generate a temporary data set DS 1.
A35. And reading an index classification description unit from the C library according to the index classification description information selected by the user in the SA area, and filling a Y-axis index classification description area of the matrix M.
A36. And reading related data in a D library according to the index classification description unit information of the Y-axis index classification description area of the matrix M to generate a temporary data set DS 2.
A37. Intersection of the temporary data set DS1 and the temporary data set DS2 is obtained to obtain a matrix data set DS3, and the matrix M is filled with the matrix data set DS 3.
A4. And rendering the information extracted by the hierarchical classification result presenter and presenting the information to a user.
The table representation presented to the user in this embodiment is shown in fig. 8, and is basically the same as the presentation manner shown in fig. 1, so that accurate expression of two-dimensional table data is realized.
According to the invention, by calling and presenting the data information stored in the four repositories, when a user freely selects and presents data, one (one) or more (multiple) groups of indexes are randomly selected in the tree-shaped hierarchical structure, one (one) or more (multiple) groups of indexes are simultaneously selected for classified description, and then the result is rapidly presented according to the selection of the user, so that the data attribute relationship in the presented table is clear and clear, and the personalized selection and presentation are realized.

Claims (2)

1. A processing method for presenting data index hierarchy and classification in a spreadsheet is characterized in that the processing method is realized based on a D library storing numerical items, an I library storing index unit information, a C library storing index classification description unit information and an R library storing application scenes,
the data in the two-dimensional table comprises feature class data, noun class data, classification class data and statistic class data; after the data are granulated, numerical values containing self attributes are obtained, and the self attributes comprise indexes, index classification description and application scenes; the index consists of five elements of index name, metering unit, time limit, space limit and application limit, and the index and the hierarchical relation thereof form an index unit; the index classification description refers to an angle for describing the index, and the index classification description and the hierarchical relationship thereof form an index classification description unit; the application scene refers to the corresponding relation between the index unit and the index classification description unit in the specific two-dimensional table and the source, library and table information corresponding to the index unit and the index classification description unit;
the treatment method specifically comprises the following steps:
A1. constructing an index structure S;
the index structure S comprises an index area, an index classification description area, a relation area and a selected index area; the system comprises an index area, an index classification description area, a relation area and a selected index area, wherein the index area is an IA area presenting indexes and index hierarchical relations, the index classification description area is a CA area presenting index classification descriptions and hierarchical relations, the relation area is an RA area presenting application scenes between an index unit and an index classification description unit and corresponding hidden attributes of a source library table, and the selected index area is an SA area presenting indexes and index classification description information selected by a user;
A2. reading information in the I library, the C library, the D library and the R library by using an index structure builder in combination with the selection of a user, and filling an index structure S;
A3. according to the selection of a user, utilizing a hierarchical classification result presenter to iteratively extract corresponding information in the I library, the C library, the D library and the R library;
A31. initializing a data storage container matrix M;
A32. reading SA area information in an index structure S;
A33. reading index unit information from an I library according to the selected index information of the user in the SA area, and filling an X-axis index area of the matrix M;
A34. reading related data in a D library according to index unit information of an X-axis index area of the matrix M to generate a temporary data set DS 1;
A35. reading an index classification description unit from a C library according to the user selected index classification description information of the SA area, and filling a Y-axis index classification description area of the matrix M;
A36. reading related data in a D library according to index classification description unit information of a Y-axis index classification description area of the matrix M to generate a temporary data set DS 2;
A37. intersection of the temporary data set DS1 and the temporary data set DS2 is obtained to obtain a matrix data set DS3, and the matrix M is filled with a matrix data set DS 3;
A4. and rendering the information extracted by the hierarchical classification result presenter and presenting the information to a user.
2. The method as claimed in claim 1, wherein the step a2 is implemented by:
A21. initializing an index structure S;
A22. reading index unit information in the I library, filling an IA area of an index structure S to form a tree-shaped hierarchical structure of indexes for a user to select;
A23. reading the corresponding relation of the index i in an R library according to the index i selected by a user, and filling an RA (random access) area of an index structure S to form an application scene R;
A24. according to the corresponding relation of the index i read from the R library, reading the index classification description C in the C library, filling a CA (certificate Authority) area of the index structure S, and forming a tree-shaped hierarchical structure of the index classification description for a user to select;
A25. and filling an SA area of the index structure S according to the index i selected by the user, the index classification description c and the application scene r.
CN202011365236.7A 2020-11-28 2020-11-28 Processing method for presenting data index hierarchy and classification in electronic form Active CN112487107B (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
CN202011365236.7A CN112487107B (en) 2020-11-28 2020-11-28 Processing method for presenting data index hierarchy and classification in electronic form
US17/704,105 US11615237B2 (en) 2020-11-28 2022-03-25 Processing method for presenting indicator hierarchy and classification of data in spreadsheet

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011365236.7A CN112487107B (en) 2020-11-28 2020-11-28 Processing method for presenting data index hierarchy and classification in electronic form

Publications (2)

Publication Number Publication Date
CN112487107A CN112487107A (en) 2021-03-12
CN112487107B true CN112487107B (en) 2021-11-23

Family

ID=74936864

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011365236.7A Active CN112487107B (en) 2020-11-28 2020-11-28 Processing method for presenting data index hierarchy and classification in electronic form

Country Status (2)

Country Link
US (1) US11615237B2 (en)
CN (1) CN112487107B (en)

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6701313B1 (en) * 2000-04-19 2004-03-02 Glenn Courtney Smith Method, apparatus and computer readable storage medium for data object matching using a classification index
CN102467559A (en) * 2010-11-19 2012-05-23 金蝶软件(中国)有限公司 Multilevel and multidimensional method and device for analyzing data attributes
CN105894193A (en) * 2016-03-31 2016-08-24 中国银行股份有限公司 Index configuration method and device
CN108874762A (en) * 2018-06-05 2018-11-23 北京圣康汇金科技有限公司 Online display system and method are reported in a kind of investment research
CN110750581A (en) * 2019-09-24 2020-02-04 贝壳技术有限公司 Data display method and device of table component, storage medium and electronic equipment
CN111078703A (en) * 2019-12-19 2020-04-28 烟台汽车工程职业学院 Data processing and risk control method based on customs declaration form draft
CN111949658A (en) * 2020-08-06 2020-11-17 浙江工业大学 Method for constructing operable graph perspective table facing data cube

Family Cites Families (23)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7542979B2 (en) * 2004-05-25 2009-06-02 Schlumberger Technology Corporation System, method and apparatus for loading text data in a database
WO2006095365A2 (en) * 2005-03-11 2006-09-14 Suresh Sambandam A system and method of defining a hierarchical datamodel and related computation and instruction rules using spreadsheet like user interface
US7779000B2 (en) * 2005-08-29 2010-08-17 Microsoft Corporation Associating conditions to summary table data
US8689137B2 (en) * 2005-09-07 2014-04-01 Microsoft Corporation Command user interface for displaying selectable functionality controls in a database application
US7925989B2 (en) * 2007-05-09 2011-04-12 Sap Ag System and method for simultaneous display of multiple tables
US9852428B2 (en) * 2007-08-20 2017-12-26 Oracle International Corporation Business unit outsourcing model
US8127223B2 (en) * 2008-01-23 2012-02-28 Mellmo Inc. User interface method and apparatus for data from data cubes and pivot tables
WO2012021660A1 (en) * 2010-08-10 2012-02-16 Accenture Global Services Limited Sales and operations planning interface tool
US8548992B2 (en) * 2010-10-28 2013-10-01 Cary Scott Abramoff User interface for a digital content management system
US20120159297A1 (en) * 2010-12-21 2012-06-21 Sap Ag System and method for generating a pivot table
US9053082B2 (en) * 2011-11-03 2015-06-09 Knowledge Inside Spreadsheet data processing method and system
US8949819B2 (en) * 2012-09-27 2015-02-03 International Business Machines Corporation Rationalizing functions to identify re-usable services
AU2014277620B2 (en) * 2013-06-07 2020-03-05 University Of South Australia Method and system for information integration in industrial systems
US9430469B2 (en) * 2014-04-09 2016-08-30 Google Inc. Methods and systems for recursively generating pivot tables
CN105320690B (en) * 2014-07-30 2018-09-25 北京中海纪元数字技术发展股份有限公司 A kind of statistics list rapid generation and system based on metadata
US9244899B1 (en) * 2014-10-03 2016-01-26 Addepar, Inc. Systems and user interfaces for dynamic and interactive table generation and editing based on automatic traversal of complex data structures including time varying attributes
US10732810B1 (en) * 2015-11-06 2020-08-04 Addepar, Inc. Systems and user interfaces for dynamic and interactive table generation and editing based on automatic traversal of complex data structures including summary data such as time series data
US20170286455A1 (en) * 2016-03-31 2017-10-05 Splunk Inc. Technology Add-On Packages Controlling a Data Input and Query System
US20190311034A1 (en) * 2018-04-04 2019-10-10 NetBrain Technologies, Inc. Multiple network device type support using variable mapping
CN109117467A (en) * 2018-07-27 2019-01-01 广东讯飞启明科技发展有限公司 Generation method, system, equipment and the medium of configurable dynamic data report
US10977246B2 (en) * 2018-09-13 2021-04-13 Sigma Computing, Inc. Generating a database query using a dimensional hierarchy within a graphical user interface
US20210209559A1 (en) * 2020-01-06 2021-07-08 Adp, Llc Table grid with multi-level header and value
US20210286845A1 (en) * 2020-03-13 2021-09-16 Jpmorgan Chase Bank, N.A. Method and apparatus for implementing an n-dimensional hypercube visualization module

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6701313B1 (en) * 2000-04-19 2004-03-02 Glenn Courtney Smith Method, apparatus and computer readable storage medium for data object matching using a classification index
CN102467559A (en) * 2010-11-19 2012-05-23 金蝶软件(中国)有限公司 Multilevel and multidimensional method and device for analyzing data attributes
CN105894193A (en) * 2016-03-31 2016-08-24 中国银行股份有限公司 Index configuration method and device
CN108874762A (en) * 2018-06-05 2018-11-23 北京圣康汇金科技有限公司 Online display system and method are reported in a kind of investment research
CN110750581A (en) * 2019-09-24 2020-02-04 贝壳技术有限公司 Data display method and device of table component, storage medium and electronic equipment
CN111078703A (en) * 2019-12-19 2020-04-28 烟台汽车工程职业学院 Data processing and risk control method based on customs declaration form draft
CN111949658A (en) * 2020-08-06 2020-11-17 浙江工业大学 Method for constructing operable graph perspective table facing data cube

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
"分布式统计信息基础数据库统计报表查询子系统的设计与实现";曾瑾;《中国优秀硕士学位论文全文数据库 信息科技辑》;20150615(第6期);I138-371 *

Also Published As

Publication number Publication date
US11615237B2 (en) 2023-03-28
US20220215162A1 (en) 2022-07-07
CN112487107A (en) 2021-03-12

Similar Documents

Publication Publication Date Title
US7840891B1 (en) Method and system for content extraction from forms
US9436672B2 (en) Representing and manipulating hierarchical data
US20050091206A1 (en) Method and system for handling data available in multidimensional databases using a spreadsheet
US7467125B2 (en) Methods to manage the display of data entities and relational database structures
WO2008094848A2 (en) Apparatus and method for data charting with an extensible visualization library
CN105373541A (en) Processing method and system for data operation request of database
CN115544183A (en) Data visualization method and device, computer equipment and storage medium
CN112486989B (en) Multi-source data granulation fusion and index classification and layering processing method
CN108304527B (en) Data extraction method
CN112487107B (en) Processing method for presenting data index hierarchy and classification in electronic form
CN109213776B (en) Report form display method and device
CN112988142A (en) Attribute table generation method and device
US8326812B2 (en) Data search device, data search method, and recording medium
CN110362591B (en) Report form display method and device
CN113254455B (en) Dynamic configuration method and device of database, computer equipment and storage medium
CN107391533A (en) Generate the method and device of graphic data base Query Result
CN111159991B (en) Report modeling design device and method
CN113569114A (en) Visual display method and device for system data
CN107291679A (en) A kind of poster management method, device and system
US20180357297A1 (en) Rdb system
CN111985015A (en) System and method for automatically generating BOM (Bill of Material) by using VBA (visual basic Access) function
CN112364090A (en) Data attribute display method and device and electronic equipment
CN117392294B (en) Animation file checking and repairing method, system, electronic equipment and storage medium
CN114860734B (en) Processing method for data presentation of multi-source index structure fusion and scene reduction
CN117033438A (en) Data display method, device and equipment of main sub-table based on dynamic attribute

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant