CN104657368A - Method for generating multi-dimensional report of relational database - Google Patents
Method for generating multi-dimensional report of relational database Download PDFInfo
- Publication number
- CN104657368A CN104657368A CN201310584529.8A CN201310584529A CN104657368A CN 104657368 A CN104657368 A CN 104657368A CN 201310584529 A CN201310584529 A CN 201310584529A CN 104657368 A CN104657368 A CN 104657368A
- Authority
- CN
- China
- Prior art keywords
- data
- generation method
- report generation
- relevant database
- dimensional report
- 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
- 238000000034 method Methods 0.000 title claims abstract description 26
- 238000013507 mapping Methods 0.000 claims abstract description 4
- 238000004458 analytical method Methods 0.000 claims description 7
- 230000002123 temporal effect Effects 0.000 claims description 3
- 238000012216 screening Methods 0.000 abstract description 3
- 230000007423 decrease Effects 0.000 description 3
- 230000003321 amplification Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000003203 everyday effect Effects 0.000 description 2
- 238000003199 nucleic acid amplification method Methods 0.000 description 2
- 238000000926 separation method Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 230000008707 rearrangement Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- 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/2246—Trees, e.g. B+trees
-
- 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/24—Querying
- G06F16/242—Query formulation
- G06F16/2425—Iterative querying; Query formulation based on the results of a preceding query
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Mathematical Physics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method for generating a multi-dimensional report of a relational database. The method comprises the steps of A, setting keywords; B, calibrating and classifying characteristics; C, building a mapping relation; D, searching data to obtain a data report result; E, outputting the data report result according to the set display mode. With the adoption of the method, the shortages in the prior art can be overcome; the data in the database are classified and managed according to the analyzing characteristics, and therefore, the steps and times of data screening can be reduced, and the running speed of the database can be increased.
Description
Technical field
The present invention relates to database technical field, especially a kind of multi-dimensional report generation method of relevant database.
Background technology
At present, for data preparation and the analysis of relevant database, need to carry out the work of a large amount of retrievals, classification and rearrangement.Wherein greatly for repeating operation, this has just increased the weight of the burden of database server greatly, reduces work efficiency.
Summary of the invention
The technical problem to be solved in the present invention is to provide a kind of multi-dimensional report generation method of relevant database, the deficiencies in the prior art can be solved, by the data in database are carried out Classification Management according to analytical characteristic, decrease step and the number of times of data screening, improve the travelling speed of database.
For solving the problems of the technologies described above, the technical solution used in the present invention is as follows.
A kind of multi-dimensional report generation method of relevant database, comprises the following steps:
A, choose the scope of data source according to the Correlation Criteria of data source, by the data source setting keyword chosen;
B, to carry out demarcation classification according to the different characteristic of data in data source;
C, the feature calibrated in step B to be stored, and set up the mapping relations of feature and data source;
D, to search for for data characteristics according to user's request, obtain data sheet result;
E, according to user's request setting data display mode, and export data sheet result according to the display mode of setting.
As a preferred technical solution of the present invention, in step D, before searching for, matching order, summarized manner, Correlation Criteria are set.
As a preferred technical solution of the present invention, in step D, after searching for, according to data time section, Search Results is carried out Data Comparison.
As a preferred technical solution of the present invention, in step D, after searching for, the Combination nova according to data characteristics carries out secondary analysis to Search Results.
As a preferred technical solution of the present invention, in step B, the feature of data comprises temporal characteristics, numerical characteristics, weight feature, provincial characteristics.
As a preferred technical solution of the present invention, in step e, display mode comprises numerical monitor figure place, alignment thereof, sortord, display condition, title languages, formula classification, display width, display format.
The beneficial effect adopting technique scheme to bring is: the present invention, by the data in database being classified, decreases the step of screening; Then according to the display mode Output rusults that user needs, Output rusults information bar is made to put Chu in order, intuitive and convenient, the decrease demand data workload of person and the repetition holding time to database.Through using method provided by the invention, can make reduce more than 20% the search time of database, the average occupancy of database reduces by more than 50%.
Embodiment
A kind of multi-dimensional report generation method of relevant database, is characterized in that comprising the following steps:
A, choose the scope of data source according to the Correlation Criteria of data source, by the data source setting keyword chosen;
B, to carry out demarcation classification according to the different characteristic of data in data source;
C, the feature calibrated in step B to be stored, and set up the mapping relations of feature and data source;
D, to search for for data characteristics according to user's request, obtain data sheet result;
E, according to user's request setting data display mode, and export data sheet result according to the display mode of setting.
It should be noted that in step D, before searching for, matching order, summarized manner, Correlation Criteria are set.
It should be noted that in step D, after searching for, according to data time section, Search Results is carried out Data Comparison.
It should be noted that in step D, after searching for, the Combination nova according to data characteristics carries out secondary analysis to Search Results.
It should be noted that in step B, the feature of data comprises temporal characteristics, numerical characteristics, weight feature, provincial characteristics.
It should be noted that in step e, display mode comprises numerical monitor figure place, alignment thereof, sortord, display condition, title languages, formula classification, display width, display format.
Keyword can be the contents such as table name, another name, adjunct word information, table name: the title of tables of data in relational database; Another name: in relational database, in order to the data that more convenient identification data table stores, often the title of tables of data is all long, so we get one to tables of data simply indicate title, directly can use in use and call; Adjunct word: factor data table may be among the affairs of relational database, now tables of data is in the lock state, just need when reading the data in tables of data to add (nolock) key word after tables of data title, the practical function of adjunct word is exactly that tables of data corresponding to mark is the need of following (nolock) key word.
When adding alternative data source, table name can be an independently tables of data, also can be the association of two or more tables of data, such as: tableA a left join tableB b on a.colA=b.colA; Another name can use simple one or more letter, a in previous examples in tableA a calls exactly, if when tables of data is the association of multiple tables of data, do not need to specify another name separately at another name place, directly use another name given when table name is set.
Because alternative data source is originally as relational database tables of data, so the tables of data of adding can be the tables of data of according to demand particular data being carried out to processing and sorting in advance, as demand needs often to inquire about the combined data of every day, can with the form of database job, in advance the combined data of every day is stored in an independent tables of data, show as data source using this, reduce the calculating process such as to gather of in form use procedure database, improve the extraction efficiency of data.
When there is multiple analytical model at the same time, need to carry out which kind of analytical model of choice for use according to the priority of matching order, matching order marks with numeral, and numerical value is less, and to represent priority higher.It is under will being arranged on which kind of summarized manner that summarized manner is arranged, use this data model, similar with the display condition of data rows, also be arrange when which kind of selecting gather condition just to use corresponding analytical model, during as gathered by A condition, gathering not according to B condition, namely for alternative gather project have selected gather project A and do not have selection to gather project B time, use this analytical model.The Correlation Criteria of each data source, and in alternative data source, use multiple tables of data as similar during an alternative data source, but only need specified associations condition herein, as: a.colA=b.colA and a.colB=c.colB.
When Search Results being carried out Data Comparison according to data time section, the data that project inquires the second time period (reduced time section) are gathered with what select during first time period (main separation time period) data query, and identical numerical value column data is contrasted, calculate amplification amount and amplification amplitude (number percent), and by the data of the second time period (reduced time section), be positioned over first time period (main separation time period) and show afterwards.So directly can draw difference and the differential magnitude information of data, and data are presented on report interface intuitively, the operation of the person that not only simplify demand data and conveniently analyze data.
When secondary analysis being carried out to Search Results according to the Combination nova of data characteristics, gather based on project by current selection, data acquisition is re-started in conjunction with the new project that gathers selected, and continue to use current querying condition, and in the data rows of display, the non-item column that gathers is inquired about as conditional joint, obtains new analysis data, data line in current data can be gathered project for key word split for multirow data with what newly select, data refinement is shown.Demand data person directly can return a dimension and obtain query analysis, does not need to re-start data query, accelerates the speed that demand data person obtains each dimension data, and the person that makes demand data, better to data analysis, draws decision-making.
Use same database to carry out the single operation of three report generations, the control methods that method of the present invention and existing direct search generate contrasted, draws following correlation data:
| The search time (second) of the inventive method | The search time (second) of control methods | The database occupancy (%) of the inventive method | The database occupancy (%) of control methods | |
| For the first time | 0.35 | 0.44 | 3.6 | 5.8 |
| For the second time | 0.76 | 1.05 | 5.7 | 10.1 |
| For the third time | 0.12 | 0.15 | 0.9 | 1.4 |
As can be seen from the above data, through using method provided by the invention, can make reduce more than 20% the search time of database, the average occupancy of database reduces by more than 50%.
The foregoing is only preferred embodiment of the present invention, not in order to limit the present invention, all any amendments done within the spirit and principles in the present invention, equivalent replacement and improvement etc., all should be included within protection scope of the present invention.
Claims (6)
1. the multi-dimensional report generation method of a relevant database, is characterized in that comprising the following steps:
A, choose the scope of data source according to the Correlation Criteria of data source, by the data source setting keyword chosen;
B, to carry out demarcation classification according to the different characteristic of data in data source;
C, the feature calibrated in step B to be stored, and set up the mapping relations of feature and data source;
D, to search for for data characteristics according to user's request, obtain data sheet result;
E, according to user's request setting data display mode, and export data sheet result according to the display mode of setting.
2. the multi-dimensional report generation method of relevant database according to claim 1, is characterized in that: in step D, sets before searching for matching order, summarized manner, Correlation Criteria.
3. the multi-dimensional report generation method of relevant database according to claim 1, is characterized in that: in step D, after searching for, according to data time section, Search Results is carried out Data Comparison.
4. the multi-dimensional report generation method of relevant database according to claim 1, is characterized in that: in step D, and after searching for, the Combination nova according to data characteristics carries out secondary analysis to Search Results.
5. the multi-dimensional report generation method of the relevant database according to claim 1-4 any one, is characterized in that: in step B, and the feature of data comprises temporal characteristics, numerical characteristics, weight feature, provincial characteristics.
6. the multi-dimensional report generation method of the relevant database according to claim 1-4 any one, it is characterized in that: in step e, display mode comprises numerical monitor figure place, alignment thereof, sortord, display condition, title languages, formula classification, display width, display format.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310584529.8A CN104657368A (en) | 2013-11-20 | 2013-11-20 | Method for generating multi-dimensional report of relational database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310584529.8A CN104657368A (en) | 2013-11-20 | 2013-11-20 | Method for generating multi-dimensional report of relational database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104657368A true CN104657368A (en) | 2015-05-27 |
Family
ID=53248515
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310584529.8A Pending CN104657368A (en) | 2013-11-20 | 2013-11-20 | Method for generating multi-dimensional report of relational database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104657368A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107632971A (en) * | 2016-07-19 | 2018-01-26 | 百度在线网络技术（北京）有限公司 | Method and apparatus for generating multidimensional form |
| CN109783476A (en) * | 2019-01-25 | 2019-05-21 | 上海创景信息科技有限公司 | The Matrix Analysis Method and system of multi-dimensional data based on database |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060167924A1 (en) * | 2005-01-24 | 2006-07-27 | Microsoft Corporation | Diagrammatic access and arrangement of data |
| CN101197876A (en) * | 2006-12-06 | 2008-06-11 | 中兴通讯股份有限公司 | Method and system for multi-dimensional analysis of message service data |
| CN103020301A (en) * | 2012-12-31 | 2013-04-03 | 中国科学院自动化研究所 | Multidimensional data query and storage method and system |
-
2013
- 2013-11-20 CN CN201310584529.8A patent/CN104657368A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060167924A1 (en) * | 2005-01-24 | 2006-07-27 | Microsoft Corporation | Diagrammatic access and arrangement of data |
| CN101197876A (en) * | 2006-12-06 | 2008-06-11 | 中兴通讯股份有限公司 | Method and system for multi-dimensional analysis of message service data |
| CN103020301A (en) * | 2012-12-31 | 2013-04-03 | 中国科学院自动化研究所 | Multidimensional data query and storage method and system |
Non-Patent Citations (1)
| Title |
|---|
| 尹呈: "基于语义对象报表工具的研究设计", 《中国优秀硕士学位论文全文数据库》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107632971A (en) * | 2016-07-19 | 2018-01-26 | 百度在线网络技术（北京）有限公司 | Method and apparatus for generating multidimensional form |
| CN109783476A (en) * | 2019-01-25 | 2019-05-21 | 上海创景信息科技有限公司 | The Matrix Analysis Method and system of multi-dimensional data based on database |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11372851B2 (en) | Systems and methods for rapid data analysis | |
| CN106980637B (en) | SQL checking method and device | |
| CN104123346B (en) | A kind of structured data search method | |
| US8122046B2 (en) | Method and apparatus for query rewrite with auxiliary attributes in query processing operations | |
| CN105740333A (en) | Visual advertisement management platform, and implementation method thereof | |
| CN104077407B (en) | A kind of intelligent data search system and method | |
| CN106897285B (en) | Data element extraction and analysis system and data element extraction and analysis method | |
| CN106933906B (en) | Data multi-dimensional query method and device | |
| CN105488048A (en) | Data query method and device | |
| CN101794296B (en) | A kind of method for digging based on Mobile Aerial Target data | |
| CN102810094A (en) | Report generation method and device | |
| CN102867066B (en) | Data Transform Device and data summarization method | |
| CN111813956A (en) | Knowledge graph construction method and device, and information penetration method and system | |
| CN104392010A (en) | Subgraph matching query method | |
| CN102081655A (en) | Information retrieval method based on Bayesian classification algorithm | |
| CN110543477B (en) | Label construction system and method | |
| CN112634004B (en) | Method and system for analyzing blood-cause atlas of credit investigation data | |
| CN103020083B (en) | The automatic mining method of demand recognition template, demand recognition methods and corresponding device | |
| US20230315733A1 (en) | Pre-checking method and pre-checking system based on the olap pre-calculation model | |
| de Almeida et al. | Taxonomy of data quality problems in multidimensional Data Warehouse models | |
| CN104657368A (en) | Method for generating multi-dimensional report of relational database | |
| JP2018037069A (en) | Metadata-based online analytical processing system for analyzing importance of report | |
| CN107291951B (en) | Data processing method, device, storage medium and processor | |
| US9116947B2 (en) | Data-record pattern searching | |
| Rekatsinas et al. | Crowdgather: Entity extraction over structured domains |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150527 |
|
| RJ01 | Rejection of invention patent application after publication |