CN107704523A - Data multidimensional display control method, device and system - Google Patents
Data multidimensional display control method, device and system Download PDFInfo
- Publication number
- CN107704523A CN107704523A CN201710810741.XA CN201710810741A CN107704523A CN 107704523 A CN107704523 A CN 107704523A CN 201710810741 A CN201710810741 A CN 201710810741A CN 107704523 A CN107704523 A CN 107704523A
- Authority
- CN
- China
- Prior art keywords
- data
- field name
- field
- name
- names
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
- G06F16/2264—Multidimensional index structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/957—Browsing optimisation, e.g. caching or content distillation
- G06F16/9577—Optimising the visualization of content, e.g. distillation of HTML documents
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
Description
ProductName | Rule name | Rule value |
Product A | Regular A | 10 |
Product A | Regular B | 20 |
Product A | Regular C | 30 |
Product B | Regular A | 5 |
Product B | Regular C | 15 |
ProductName | Regular A | Regular B | Regular C |
Product A | 10 | 20 | 30 |
Product B | 5 | -- | 15 |
Claims (15)
- A kind of 1. data multidimensional display control method, it is characterised in that including:Business datum or user data are obtained from database;Searching loop is carried out to data, obtains the field list of file names for including at least two field names;At least the first field name and the second field name are determined from least two field name;The data of at least each second field name are traveled through under each first field name, obtain at least two-dimensional data table;At least two-dimensional data table is shown.
- 2. according to the method for claim 1, it is characterised in that methods described also includes:Preset the priority of various field names;According to the priority of field name from high to low order, at least the first field name and the second field name are determined.
- 3. according to the method for claim 1, it is characterised in that if field list of file names includes three kinds of field names, the three-dimensional The generating process of tables of data is:The second field name data are traveled through under each first field name, and, the 3rd field is traveled through under each second field name Name data, obtain three-dimensional data table.
- 4. according to the method described in any one of claims 1 to 3, it is characterised in that at least two-dimensional data table is shown Before showing, in addition to:Data in the tables of data are converted into html codes;The html codes are rendered to the page.
- 5. according to the method described in any one of claims 1 to 3, it is characterised in that at least two-dimensional data table is shown Show including:User terminal gets at least two-dimensional data table, and the application program by terminal or client from database server End is shown to tables of data.
- A kind of 6. data multidimensional display control unit, it is characterised in that including:Data capture unit, for obtaining business datum or user data from database;Field name obtaining unit, for carrying out searching loop to data, obtain the field list of file names for including at least two field names;Determining unit, for determining at least the first field name and the second field name from least two field name;Tables of data generation unit, for traveling through the data of at least each second field name under each first field name, obtain to Few two-dimensional data table;Display control unit, for being shown at least two-dimensional data table.
- 7. device according to claim 6, it is characterised in that described device also includes:Two priority classes unit, for presetting the priority of various field names, and according to field name priority from up to Low order, determine at least the first field name and the second field name.
- 8. device according to claim 6, it is characterised in that if field list of file names includes three kinds of field names, the data Table generation unit is specifically used for, and the second field name data are traveled through under each first field name, and, in each second field name The 3rd field name data of lower traversal, obtain three-dimensional data table.
- 9. according to the device described in any one of claim 6 to 8, it is characterised in that the display control unit includes:Data conversion subelement, for the data in the tables of data to be converted into html codes;Subelement is rendered, for the html codes to be rendered into the page.
- 10. according to the device described in any one of claim 6 to 8, it is characterised in that the display control unit is specifically used for, Tables of data is shown by the application program or client of user terminal.
- 11. a kind of data multidimensional display control program, it is characterised in that including database server, report control device and use Family terminal, wherein:The report control device, for obtaining business datum or user data from database server, and data are followed Ring travels through, and obtains the field list of file names for including at least two field names;And determined from least two field name to Few first field name and the second field name;The data of at least each second field name are traveled through under each first field name, are obtained At least two-dimensional data table;User terminal, for getting the two-dimensional data table from the report control device and being shown.
- 12. system according to claim 11, it is characterised in that the report control device is additionally operable to:Preset each The priority of kind of field name, and according to field name priority from high to low order, determine at least the first field name and the Two field names.
- 13. system according to claim 11, it is characterised in that if field list of file names includes three kinds of field names, the report Accuse control device to be specifically used for, the second field name data are traveled through under each first field name, and, in each second field name The 3rd field name data of lower traversal, obtain three-dimensional data table.
- 14. according to the system described in any one of claim 11 to 13, it is characterised in that the report control device is additionally operable to, Data in the tables of data are converted into html codes, and the html codes are rendered to the page.
- 15. according to the system described in any one of claim 11 to 13, it is characterised in that the user terminal passes through application program Or client is shown to tables of data.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710810741.XA CN107704523A (en) | 2017-09-11 | 2017-09-11 | Data multidimensional display control method, device and system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710810741.XA CN107704523A (en) | 2017-09-11 | 2017-09-11 | Data multidimensional display control method, device and system |
Publications (1)
Publication Number | Publication Date |
---|---|
CN107704523A true CN107704523A (en) | 2018-02-16 |
Family
ID=61172496
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710810741.XA Pending CN107704523A (en) | 2017-09-11 | 2017-09-11 | Data multidimensional display control method, device and system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107704523A (en) |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20120109877A1 (en) * | 2010-11-02 | 2012-05-03 | International Business Machines Corporation | Character String Aggregation in Numerical Aggregation |
CN104679722A (en) * | 2013-11-29 | 2015-06-03 | 国际商业机器公司 | Method and system for data table multi-dimension |
CN105095249A (en) * | 2014-05-05 | 2015-11-25 | 中国石油化工股份有限公司 | Method generating multi-dimension report form |
CN105630986A (en) * | 2015-12-25 | 2016-06-01 | 中国航天系统工程有限公司 | Method for acquiring multidimensional data from database for grid display |
-
2017
- 2017-09-11 CN CN201710810741.XA patent/CN107704523A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20120109877A1 (en) * | 2010-11-02 | 2012-05-03 | International Business Machines Corporation | Character String Aggregation in Numerical Aggregation |
CN104679722A (en) * | 2013-11-29 | 2015-06-03 | 国际商业机器公司 | Method and system for data table multi-dimension |
CN105095249A (en) * | 2014-05-05 | 2015-11-25 | 中国石油化工股份有限公司 | Method generating multi-dimension report form |
CN105630986A (en) * | 2015-12-25 | 2016-06-01 | 中国航天系统工程有限公司 | Method for acquiring multidimensional data from database for grid display |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
EP3485400B1 (en) | Methods and systems for server-side rendering of native content for presentation | |
US8749553B1 (en) | Systems and methods for accurately plotting mathematical functions | |
US10534635B2 (en) | Personal digital assistant | |
US8332477B1 (en) | Presenting related communications | |
US9262529B2 (en) | Simple web search | |
US9015657B2 (en) | Systems and methods for developing and delivering platform adaptive web and native application content | |
US10810271B2 (en) | Systems and methods for issue tracking systems | |
DE112016003626T5 (en) | Natural language interface to databases | |
US10922282B2 (en) | On-demand collaboration user interfaces | |
KR102454954B1 (en) | Action indicator for search action output element | |
US20240143578A1 (en) | Spreadsheet with dynamic database queries | |
US11023481B2 (en) | Navigation platform for performing search queries | |
US20140082492A1 (en) | Modifiable contextual help content provided in-line within an application | |
EP2741196A1 (en) | Power-saving in a portable electronic device operating in a telecommunication network | |
CN110955803A (en) | Drawing method, device, equipment and medium of relational graph based on graph database | |
US9047300B2 (en) | Techniques to manage universal file descriptor models for content files | |
CN112035555B (en) | Information display method, device and equipment | |
US9158809B2 (en) | Grid queries | |
CN114491354A (en) | Page generation method and device and computer readable storage medium | |
CN110866014A (en) | Standard index data access and display method | |
CN106682228B (en) | A kind of method and apparatus that Visual Dynamic draws cabinet arrangement | |
CN107704523A (en) | Data multidimensional display control method, device and system | |
CN112559914B (en) | Index data display method and device | |
US10969931B2 (en) | Data mapping service | |
US9753901B1 (en) | Identifying important document content using geometries of page elements |
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 | ||
TA01 | Transfer of patent application right | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20200923 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant after: Innovative advanced technology Co.,Ltd. Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant before: Advanced innovation technology Co.,Ltd. Effective date of registration: 20200923 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant after: Advanced innovation technology Co.,Ltd. Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands Applicant before: Alibaba Group Holding Ltd. |
|
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180216 |