CN105488045A - Data display method and device - Google Patents
Data display method and device Download PDFInfo
- Publication number
- CN105488045A CN105488045A CN201410471870.7A CN201410471870A CN105488045A CN 105488045 A CN105488045 A CN 105488045A CN 201410471870 A CN201410471870 A CN 201410471870A CN 105488045 A CN105488045 A CN 105488045A
- Authority
- CN
- China
- Prior art keywords
- metric
- data
- user
- dimensional information
- 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.)
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- User Interface Of Digital Computer (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a data display method and device, pertaining to the communication field for the purpose of solving defects in data forms in the prior art. The method comprises following steps: setting up a cubic multi-dimensional information model based on a search request inputted by a user; obtaining first data associated with the search request according to the cubic multi-dimensional information model; and displaying dimensional information and measurement value corresponding to dimensional information based on corresponding relations in the image form. The cubic multi-dimensional information model contains dimension information and measurement information. First data comprises measurement values corresponding to measurement information in different dimension information. By adoption of the scheme, data is integrally displayed so that a user can directly and comprehensively have an understanding of data. Data is conveniently analyzed so that practicability is enhanced.
Description
Technical field
The present invention relates to the communications field, particularly a kind of method of data exhibiting and device.
Background technology
Along with the development of Internet technology, database technology is widely used, the data volume of database purchase is rapidly transitioned into present billion T byte and peta-P byte from the million M bytes of the eighties in 20th century and gigabit G byte, naturally, come with large data, also have user to the query demand become increasingly complex of these mass datas and analysis demand.For tackling this demand, On Line Analysis Process technology is arisen at the historic moment.
In an OLAP data model, from application point layering, comprise three partial contents: data Layer, application layer and presentation layer.Wherein presentation layer and customer relationship are the closest, and user knows data message by presentation layer.At present, presentation layer mainly presents in the mode of data sheet, and this mode can be enumerated to user in the mode of numeral analysis result completely, comprises comparatively multi information.But data sheet is static table, there is number of pages time data volume is large a lot, the problems such as page turning difficulty, therefore can only show the information of single-point or some specific dimension sections, cannot represent on the whole data, also intuitively cannot show the trend of data development.There is the problems such as single, uninteresting, not directly perceived.
Summary of the invention
The technical problem to be solved in the present invention is to provide a kind of method and device of data exhibiting, solves data message that OLAP technology of the prior art is presented to user and there is single, uninteresting, not problem intuitively.
For solving the problems of the technologies described above, embodiments of the invention provide a kind of method of data exhibiting, comprising:
According to the inquiry request of user's input, set up cube multi dimension information model, described cube multi dimension information model includes dimensional information and metric;
According to described cube multi dimension information model, obtain first data relevant to described inquiry request, under wherein said first data comprise different dimensions information, the metric that described metric is corresponding respectively;
The metric corresponding with described metric by described dimensional information, according to corresponding relation, is presented to user in a graphical form.
Wherein, the described metric that described dimensional information is corresponding with described metric, according to corresponding relation, before being presented to user in a graphical form, also comprises:
The metric corresponding with described metric by described dimensional information, according to corresponding relation, is presented to user with the form of form, and wherein, the content of described form and described pattern exhibition is consistent.
Wherein, the described metric that described dimensional information is corresponding with described metric, according to corresponding relation, after being presented to user in a graphical form, also comprises:
Receive the operational order to described form or described figure of user's input;
According to described operational order, described dimensional information is changed, and obtain the second dimensional information after conversion;
Under obtaining described second dimensional information, the metric that described metric is corresponding respectively;
By described second dimensional information and described metric, according to corresponding relation, be presented in respectively in described form and described figure.
Wherein, the described metric that described dimensional information is corresponding with described metric, according to corresponding relation, before being presented to user, also comprises with the form of form:
Obtain user's input to after the formatting information of described form and described figure, determine the form of described form and described figure, with by described dimensional information and metric corresponding to described metric, according to corresponding relation, be presented in the described form after determining form and described figure.
Wherein, described by described dimensional information and metric corresponding to described metric, according to corresponding relation, be presented in after in the described form after determining form and described figure, also comprise:
Record is carried out to described cube multi dimension information model and described formatting information, when again receiving described inquiry request, call described cube multi dimension information model, and after obtaining described first data, by the content of described first data, showing according in the form of described formatting information determination form and figure.
Wherein, the described inquiry request according to user's input, before setting up cube multi dimension information model, also comprises:
By extracting-conversion-loading ETL assembly acquisition database file, described database file obtains after described ETL assembly is changed raw data file;
Wherein, described first data obtain from described database file.
For solving the problems of the technologies described above, embodiments of the invention also provide a kind of device of data exhibiting, comprising:
Set up module, for the inquiry request inputted according to user, set up cube multi dimension information model, described cube multi dimension information model includes dimensional information and metric;
First acquisition module, for according to described cube multi dimension information model, obtains first data relevant to described inquiry request, under wherein said first data comprise different dimensions information, and the metric that described metric is corresponding respectively;
First represents module, for by metric corresponding with described metric for described dimensional information, according to corresponding relation, is presented to user in a graphical form.
Wherein, described device also comprises:
Second represents module, for by metric corresponding with described metric for described dimensional information, according to corresponding relation, is presented to user with the form of form, and wherein, the content of described form and described pattern exhibition is consistent.
Wherein, described device also comprises:
Receiver module, for receiving the operational order to described form or described figure of user's input;
Modular converter, for according to described operational order, changes described dimensional information, and obtains the second dimensional information after conversion;
Second acquisition module, under obtaining described second dimensional information, the metric that described metric is corresponding respectively;
3rd represents module, for by described second dimensional information and described metric, according to corresponding relation, is presented in respectively in described form and described figure.
Wherein, described device also comprises:
Determination module, for obtain user's input to after the formatting information of described form and described figure, determine the form of described form and described figure, with by described dimensional information and metric corresponding to described metric, according to corresponding relation, be presented in the described form after determining form and described figure.
Wherein, described device also comprises:
Logging modle, for carrying out record to described cube multi dimension information model and described formatting information, when again receiving described inquiry request, call described cube multi dimension information model, and after obtaining described first data, by the content of described first data, showing according in the form of described formatting information determination form and figure.
Wherein, described device also comprises:
3rd acquisition module, for obtaining database file by extraction-conversion-loading ETL assembly, described database file obtains after described ETL assembly is changed raw data file;
Wherein, described first data obtain from described database file.
The beneficial effect of technique scheme of the present invention is as follows:
The method of the data exhibiting of the embodiment of the present invention, first according to the inquiry request of user's input, set up cube multi dimension information model, wherein cube multi dimension information model includes dimensional information and metric; Then according to cube multi dimension information model, the first data relevant to user's inquiry request are obtained, under wherein the first data comprise different dimensions information, the metric that metric is corresponding respectively; Finally by metric corresponding with metric for dimensional information, according to corresponding relation, be presented to user in a graphical form.Achieve data representing on the whole, the information that user is shown by figure has one intuitively, comprehensively to understand for data, facilitates the analysis of user for data, improves practicality.
Accompanying drawing explanation
Fig. 1 is the method flow diagram of data exhibiting of the present invention;
Fig. 2 is the first schematic diagram of the method one embody rule example of data exhibiting of the present invention;
Fig. 3 is the second schematic diagram of the method one embody rule example of data exhibiting of the present invention;
Fig. 4 is the 3rd schematic diagram of the method one embody rule example of data exhibiting of the present invention;
Fig. 5 is the structural representation of the device of data exhibiting of the present invention.
Embodiment
For making the technical problem to be solved in the present invention, technical scheme and advantage clearly, be described in detail below in conjunction with the accompanying drawings and the specific embodiments.
In prior art, the data volume represented due to form every page is limited, when the result data amount of multidimensional analysis is larger time, if want the overall condition understanding data, needs the operation of lasting page turning.And for the good multidimensional analysis result of continuity, if there have certain data to occur to be abnormal, form cannot show, and is not easy to analysis and the location of problem.
And the method for the data exhibiting of the embodiment of the present invention, by the result presentation of the multidimensional analysis of entirety in a figure, facilitate user for the assurance of data entirety and understanding, avoid the mechanically actuated of lasting page turning, improve practicality.In addition, for the good multidimensional analysis result of continuity, if there have certain data to occur to be abnormal, this discrete point can be highlighted in figure, facilitate analysis and the location of problem.And figure can embody the variation tendency of data, can allow user is open-and-shut sees the situation such as maximal value, minimum value, change fluctuation, user is helped to understand in the past and current multi-faceted information, there is good directiveness for the result that may occur future, make user better can carry out the process such as risk taboo.
As shown in Figure 1, the method for the data exhibiting of the embodiment of the present invention, comprising:
Step 11, according to the inquiry request of user's input, set up cube multi dimension information model, described cube multi dimension information model includes dimensional information and metric.
Step 12, according to described cube multi dimension information model, obtains first data relevant to described inquiry request, under wherein said first data comprise different dimensions information, and the metric that described metric is corresponding respectively;
Step 13, the metric corresponding with described metric by described dimensional information, according to corresponding relation, is presented to user in a graphical form.
The method of the data exhibiting of the embodiment of the present invention, achieve data representing on the whole by graphics mode, the information that user is shown by figure has one intuitively, comprehensively to understand for data, facilitates the analysis of user for data, improves practicality.
Wherein, above-mentioned steps 11 can comprise:
Step 111, receive the inquiry request of user's input, set up a cube multi dimension information model corresponding with described inquiry request, described cube multi dimension information model includes cube title;
Step 112, according to described cube title, obtains described cube multi dimension information model, and according to described inquiry request, arranges dimensional information and the metric of described cube multi dimension information model.
Concrete, dimensional information and metric be the row axle of corresponding cube multi dimension information model, row axle and section respectively.
Although form exists the defects such as page turning difficulty, also there is accurate, careful advantage, therefore, preferably, before above-mentioned steps 13, can also comprise:
Step 14, the metric corresponding with described metric by described dimensional information, according to corresponding relation, is presented to user with the form of form, and wherein, the content of described form and described pattern exhibition is consistent.
Now, the data of multidimensional analysis show user with the form of form and figure simultaneously, make user not only can recognize the information such as the development and change of data intuitively from figure, can also from form fast finding to accurate data, be more convenient for the operation of user, improve practicality.
In addition, user also can directly get accurate data from figure, as for the point in figure, as long as mouse-over gets on just can demonstrate numerical value corresponding to this point, add the approach that user obtains data, make user can select the mode of acquisition according to the custom of oneself, convenient for users to use.
Wherein, figure can be broken line graph, histogram or pie chart etc.
Wherein, after above-mentioned steps 13, can also comprise:
Step 15, receives the operational order to described form or described figure of user's input;
Step 16, according to described operational order, changes described dimensional information, and obtains the second dimensional information after conversion;
Step 17, under obtaining described second dimensional information, the metric that described metric is corresponding respectively;
Step 18, by described second dimensional information and described metric, according to corresponding relation, is presented in described form and described figure respectively.
Now, each operation of user, as drilled through, sorting, filter, subtotal etc., can show in the graph, enables user's Real-time Obtaining to the data wanted, make the ways of presentation mobilism of form and figure, improve practicality and intellectuality.
Wherein, form remains consistent with the content of pattern exhibition, and namely form and figure adopt the mode linking and represent, and guarantee user to be mapped in form and figure the single operation of form or figure simultaneously.
Preferably, before above-mentioned steps 14, can also comprise:
Step 19, obtain user's input to after the formatting information of described form and described figure, determine the form of described form and described figure, with by described dimensional information and metric corresponding to described metric, according to corresponding relation, be presented in the described form after determining form and described figure.
Now, user can carry out formatting according to the demand of oneself to form and figure, is more convenient for the use of user, improves intellectuality and practicality.
Preferably, by described dimensional information and metric corresponding to described metric, according to corresponding relation, be presented in after in the described form after determining form and described figure, can also comprise:
Step 20, record is carried out to described cube multi dimension information model and described formatting information, when again receiving described inquiry request, call described cube multi dimension information model, and after obtaining described first data, by the content of described first data, showing according in the form of described formatting information determination form and figure.
Now, record is carried out by the formatting information of the cube multi dimension information model that will set up and user's input, and when again receiving same queries request, the cube multi dimension information model calling record carries out associative operation, avoid the repetitive operation to same inquiry request, improve the speed of carrying out data feedback to user, improve operating efficiency, add practicality.
Wherein, before above-mentioned steps 11, can also comprise:
Step 21, by extracting-conversion-loading ETL assembly acquisition database file, described database file obtains after described ETL assembly is changed raw data file;
Wherein, described first data obtain from described database file.
Now, get raw data file in advance by ETL assembly, and be inserted into database after corresponding format conversion is carried out to raw data file, for follow-up first data that obtain from database are laid a good foundation, ensure that carrying out smoothly of subsequent operation.
In addition, the conveniently further use of user, the method for the embodiment of the present invention can also comprise:
Step 22, receive user to the derivation instruction of described form or described figure after, according to the operation that described derivation instruction is derived described form or described figure.
Wherein, the mode of derivation can be excel, csv, word mode etc., and often kind of mode can also comprise to be derived current page function and derive all page functions.
The method of the embodiment of the present invention, specifically can be applicable to OLAP assembly, solve OLAP form single,
Uninteresting, not problem intuitively.
Preferably, the method for the embodiment of the present invention, after first carrying out format conversion by ETL assembly to raw data file, obtains database file; Then, after the inquiry request receiving user's input, one corresponding with inquiry request, to comprise cube title cube multi dimension information model is set up; Then according to this cube multi dimension information model of cube name acquiring, and dimensional information and the metric of cube multi dimension information model are set according to inquiry request; Again according to the cube multi dimension information model set, in database file, obtain first data relevant to inquiry request, wherein, under the first data comprise different dimensions information, the metric that metric is corresponding respectively; Again according to user's input to form and graphical format configuration information, after determining the form of form and figure, by dimensional information and metric corresponding to metric, according to corresponding relation, be presented in form and figure simultaneously.And record is carried out, when receiving identical inquiry request next time, to simplify the operation, by data rapid feedback to user to the cube multi dimension information model set up and form configuration information.
Assuming that the graphical format that user selectes is broken line graph, then, after drafting form, graphic plotting can be carried out below form.Concrete, using dimension data as transverse axis, using metric data as the longitudinal axis, in single dimension, the metric that metric data is corresponding is drawn by the mode played up and get ready, and the data point line that will draw, obtain broken line graph.
Receive user's input to after the operational order of form or figure, according to operational order, dimensional information is changed, obtains the second dimensional information after conversion; Then by under the second dimensional information, the metric that metric is corresponding is presented in form and figure respectively.Wherein, operational order can comprise drill through, cut into slices, sort, filter, subtotal etc.Now, each operation of user, can show in the graph, user operation amplificationization, specific, visualize, mobilism.Make form and chart not be lonely representing, but can specifically launch, support again the dynamic chart of convergent-divergent.
Assuming that the operation that user drills through form, during as carried out lower brill, in form, selected father node still represents, the next stage child node of selected father node is launched, simultaneously in broken line graph, the one point data that selected father node is corresponding launches into a line, in detail the data line information of this data point of display composition.When carrying out upper volume, this data line in broken line graph can be packed up automatically, aggregates into a data point, the one point data in display after volume.
Illustrate as follows to an embody rule example of the present invention below.
The method of the data exhibiting of the embodiment of the present invention, is applied to OLAP assembly, 24 hours flows of statistics Long Term Evolution LTE business.During the inquiry request of user's input to 24 hours flows of LTE business, OLAP assembly can carry out data base querying according to the information of record, then Query Result is carried out report display, carries out the getting ready of report data, Rendering operations simultaneously, completes figure display.
When user carries out real-time multidimensional analysis, can arrange the dimension represented and tolerance according to demands of individuals, as arranged row axle for hour dimension, provinces and cities and type of service, arranging row axle is flow, arranges section for the time.Concrete, front components meeting recording user operation also sends multi-dimension organization language MDX statement to backstage, back-end component converts MDX statement to traditional Structured Query Language (SQL) SQL statement, and carry out real-time query in a database, then the result of inquiry is turned back in the form of interface, foreground and carry out Data import, the data loaded are played up in the graphic simultaneously, then the independent digit strong point of playing up is connected into line, complete the drafting of broken line graph, as shown in Figure 2.
From Fig. 2, can observe out the traffic conditions of 24 hours of the LTE business of all districts and cities of Guangdong Province, flow top appears at point in the morning 10, and flow lowest trough appears at 2:00 AM.Data rise from 4:00 AM, occur steady state situations to 6, and flow continues to keep high-order.This illustrates that whole daytime period is all the peak that 4G business uses.Flow to evening 21 time there is settle slightly weaker suddenly, 22 time, occur ascendant trend again, this is a discrete point in complete data and curves, and this data point of reminding user may occur exception, can pay close attention to and analyze.
If user carries out drilling operation to the provinces and cities in form, and the result after drilling through only screens Guangzhou and Liang Ge city, Dongguan.Now data sheet can carry out data filtering, the data only filtering out range and Liang Ge city, Dongguan show, simultaneously, broken line graph first can be launched into the data point of each time granularity point the broken line of all provinces and cities, operate according to the screening of user again, filter out the data point in Guangzhou and Liang Ge city, Dongguan, figure plays up display.As shown in Figure 3.
From Fig. 3, can observe out Guangzhou keeps fluctuating consistent with the data and curves in Liang Ge city, Dongguan substantially, can find out that the data in Guangzhou are more more than Dongguan at each time point simultaneously, this trend represents and may be used for analyzing user habit, provides contrast and with reference to meaning when data variation.
When user carries out upper volume to provinces and cities, when carrying out lower brill to type of service, the business datum flow on figure and form is unfolded is shown as all LTE types of service, comprises the multiple business such as WLAN (wireless local area network) WLAN, set-off type, as shown in Figure 4 simultaneously.
From Fig. 4, the distribution of the use habit of LTE type of service in can observing, the use of WLAN is the most extensive, is maximum at the flow of each time point.But the peak value of WLAN appears at 10 points of at 9 in the morning instead of all types of service, illustrate that the pressure maximum point of the server of WLAN is also different from the pressure maximum point of all LTE types of service.
Certainly, for other operations of user, the mode that all can be linked by chart as sequence, filtration, subtotal etc. is dynamically represented, and does not repeat one by one at this.
By above-mentioned embody rule example, can find out, the method of the embodiment of the present invention, adopt the method for the dynamic demonstrating data of painting shaft type, conventional digital of comparing form, has the advantage of intuitive, globality, has both been convenient to user and has judged development trend and predict, abnormal discrete point can be highlighted again, make representing of olap analysis result more flexibly lively.
As shown in Figure 5, embodiments of the invention additionally provide the device of data exhibiting, comprising:
Set up module, for the inquiry request inputted according to user, set up cube multi dimension information model, described cube multi dimension information model includes dimensional information and metric;
First acquisition module, for according to described cube multi dimension information model, obtains first data relevant to described inquiry request, under wherein said first data comprise different dimensions information, and the metric that described metric is corresponding respectively;
First represents module, for by metric corresponding with described metric for described dimensional information, according to corresponding relation, is presented to user in a graphical form.
The device of the data exhibiting of the embodiment of the present invention, achieve data representing on the whole by graphics mode, the information that user is shown by figure has one intuitively, comprehensively to understand for data, facilitates the analysis of user for data, improves practicality.
In specific embodiment of the invention, described device can also comprise:
Second represents module, for by metric corresponding with described metric for described dimensional information, according to corresponding relation, is presented to user with the form of form, and wherein, the content of described form and described pattern exhibition is consistent.
Now, the data of multidimensional analysis show user with the form of form and figure simultaneously, make user not only can recognize the information such as the development and change of data intuitively from figure, can also from form fast finding to accurate data, be more convenient for the operation of user, improve practicality.
Wherein, described device can also comprise:
Receiver module, for receiving the operational order to described form or described figure of user's input;
Modular converter, for according to described operational order, changes described dimensional information, and obtains the second dimensional information after conversion;
Second acquisition module, under obtaining described second dimensional information, the metric that described metric is corresponding respectively;
3rd represents module, for by described second dimensional information and described metric, according to corresponding relation, is presented in respectively in described form and described figure.
Now, each operation of user, as drilled through, sorting, filter, subtotal etc., can show in the graph, enables user's Real-time Obtaining to the data wanted, make the ways of presentation mobilism of form and figure, improve practicality and intellectuality.
Preferably, described device can also comprise:
Determination module, for obtain user's input to after the formatting information of described form and described figure, determine the form of described form and described figure, with by described dimensional information and metric corresponding to described metric, according to corresponding relation, be presented in the described form after determining form and described figure.
Now, user can carry out formatting according to the demand of oneself to form and figure, is more convenient for the use of user, improves intellectuality and practicality.
Further, described device can also comprise:
Logging modle, for carrying out record to described cube multi dimension information model and described formatting information, when again receiving described inquiry request, call described cube multi dimension information model, and after obtaining described first data, by the content of described first data, showing according in the form of described formatting information determination form and figure.
Now, record is carried out by the formatting information of the cube multi dimension information model that will set up and user's input, and when again receiving same queries request, the cube multi dimension information model calling record carries out associative operation, avoid the repetitive operation to same inquiry request, improve the speed of carrying out data feedback to user, improve operating efficiency, add practicality.
Wherein, described device can also comprise:
3rd acquisition module, for obtaining database file by extraction-conversion-loading ETL assembly, described database file obtains after described ETL assembly is changed raw data file;
Wherein, described first data obtain from described database file.
Now, get raw data file in advance by ETL assembly, and be inserted into database after corresponding format conversion is carried out to raw data file, for follow-up first data that obtain from database are laid a good foundation, ensure that carrying out smoothly of subsequent operation.
The device of the data exhibiting of the embodiment of the present invention, achieve data representing on the whole by graphics mode, the information that user is shown by figure has one intuitively, comprehensively to understand for data, facilitates the analysis of user for data, improves practicality.
It should be noted that, the device of this data exhibiting is the device corresponding with the method for above-mentioned data exhibiting, and wherein in said method embodiment, all implementations are all applicable in the embodiment of this device, also can reach same technique effect.
The above is the preferred embodiment of the present invention; it should be pointed out that for those skilled in the art, under the prerequisite not departing from principle of the present invention; can also make some improvements and modifications, these improvements and modifications also should be considered as protection scope of the present invention.
Claims (12)
1. a method for data exhibiting, is characterized in that, comprising:
According to the inquiry request of user's input, set up cube multi dimension information model, described cube multi dimension information model includes dimensional information and metric;
According to described cube multi dimension information model, obtain first data relevant to described inquiry request, under wherein said first data comprise different dimensions information, the metric that described metric is corresponding respectively;
The metric corresponding with described metric by described dimensional information, according to corresponding relation, is presented to user in a graphical form.
2. method according to claim 1, is characterized in that, the described metric that described dimensional information is corresponding with described metric, according to corresponding relation, before being presented to user in a graphical form, also comprises:
The metric corresponding with described metric by described dimensional information, according to corresponding relation, is presented to user with the form of form, and wherein, the content of described form and described pattern exhibition is consistent.
3. method according to claim 2, is characterized in that, the described metric that described dimensional information is corresponding with described metric, according to corresponding relation, after being presented to user in a graphical form, also comprises:
Receive the operational order to described form or described figure of user's input;
According to described operational order, described dimensional information is changed, and obtain the second dimensional information after conversion;
Under obtaining described second dimensional information, the metric that described metric is corresponding respectively;
By described second dimensional information and described metric, according to corresponding relation, be presented in respectively in described form and described figure.
4. method according to claim 2, is characterized in that, the described metric that described dimensional information is corresponding with described metric, according to corresponding relation, before being presented to user, also comprises with the form of form:
Obtain user's input to after the formatting information of described form and described figure, determine the form of described form and described figure, with by described dimensional information and metric corresponding to described metric, according to corresponding relation, be presented in the described form after determining form and described figure.
5. method according to claim 4, is characterized in that, described by described dimensional information and metric corresponding to described metric, according to corresponding relation, is presented in after in the described form after determining form and described figure, also comprises:
Record is carried out to described cube multi dimension information model and described formatting information, when again receiving described inquiry request, call described cube multi dimension information model, and after obtaining described first data, by the content of described first data, showing according in the form of described formatting information determination form and figure.
6. method according to claim 1, is characterized in that, the described inquiry request according to user's input, before setting up cube multi dimension information model, also comprises:
By extracting-conversion-loading ETL assembly acquisition database file, described database file obtains after described ETL assembly is changed raw data file;
Wherein, described first data obtain from described database file.
7. a device for data exhibiting, is characterized in that, comprising:
Set up module, for the inquiry request inputted according to user, set up cube multi dimension information model, described cube multi dimension information model includes dimensional information and metric;
First acquisition module, for according to described cube multi dimension information model, obtains first data relevant to described inquiry request, under wherein said first data comprise different dimensions information, and the metric that described metric is corresponding respectively;
First represents module, for by metric corresponding with described metric for described dimensional information, according to corresponding relation, is presented to user in a graphical form.
8. device according to claim 7, is characterized in that, described device also comprises:
Second represents module, for by metric corresponding with described metric for described dimensional information, according to corresponding relation, is presented to user with the form of form, and wherein, the content of described form and described pattern exhibition is consistent.
9. device according to claim 8, is characterized in that, described device also comprises:
Receiver module, for receiving the operational order to described form or described figure of user's input;
Modular converter, for according to described operational order, changes described dimensional information, and obtains the second dimensional information after conversion;
Second acquisition module, under obtaining described second dimensional information, the metric that described metric is corresponding respectively;
3rd represents module, for by described second dimensional information and described metric, according to corresponding relation, is presented in respectively in described form and described figure.
10. device according to claim 8, is characterized in that, described device also comprises:
Determination module, for obtain user's input to after the formatting information of described form and described figure, determine the form of described form and described figure, with by described dimensional information and metric corresponding to described metric, according to corresponding relation, be presented in the described form after determining form and described figure.
11. devices according to claim 10, is characterized in that, described device also comprises:
Logging modle, for carrying out record to described cube multi dimension information model and described formatting information, when again receiving described inquiry request, call described cube multi dimension information model, and after obtaining described first data, by the content of described first data, showing according in the form of described formatting information determination form and figure.
12. devices according to claim 7, is characterized in that, described device also comprises:
3rd acquisition module, for obtaining database file by extraction-conversion-loading ETL assembly, described database file obtains after described ETL assembly is changed raw data file;
Wherein, described first data obtain from described database file.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410471870.7A CN105488045A (en) | 2014-09-16 | 2014-09-16 | Data display method and device |
| PCT/CN2015/079410 WO2016041372A1 (en) | 2014-09-16 | 2015-05-20 | Data presentation method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410471870.7A CN105488045A (en) | 2014-09-16 | 2014-09-16 | Data display method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105488045A true CN105488045A (en) | 2016-04-13 |
Family
ID=55532526
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410471870.7A Pending CN105488045A (en) | 2014-09-16 | 2014-09-16 | Data display method and device |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN105488045A (en) |
| WO (1) | WO2016041372A1 (en) |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106372194A (en) * | 2016-08-31 | 2017-02-01 | 杭州追灿科技有限公司 | Method and system for showing search results |
| CN106649431A (en) * | 2016-08-31 | 2017-05-10 | 天津南大通用数据技术股份有限公司 | Method of displaying charts in data visualization |
| CN107562821A (en) * | 2017-08-17 | 2018-01-09 | 平安科技（深圳）有限公司 | Pivot method, apparatus and computer-readable storage medium based on database |
| CN107870969A (en) * | 2017-08-31 | 2018-04-03 | 平安科技（深圳）有限公司 | Dynamic more new relation exploded view method and application server |
| CN107958029A (en) * | 2017-11-17 | 2018-04-24 | 网易乐得科技有限公司 | Link methods of exhibiting, medium, device and computing device |
| CN108170713A (en) * | 2017-11-30 | 2018-06-15 | 东软集团股份有限公司 | The method, apparatus and storage medium and electronic equipment of data displaying |
| CN108268480A (en) * | 2016-12-30 | 2018-07-10 | 亿阳信通股份有限公司 | A kind of big data shows method and apparatus |
| CN110083346A (en) * | 2018-01-25 | 2019-08-02 | 阿里巴巴集团控股有限公司 | Screening configuration method and device based on data visualization interface |
| CN110309208A (en) * | 2018-03-01 | 2019-10-08 | 阿里巴巴集团控股有限公司 | The implementation method and device of data visualization |
| CN110659326A (en) * | 2019-09-25 | 2020-01-07 | 猫岐智能科技（上海）有限公司 | Data display method |
| CN110704516A (en) * | 2019-09-25 | 2020-01-17 | 猫岐智能科技（上海）有限公司 | Data linkage display system |
| CN111046304A (en) * | 2018-10-12 | 2020-04-21 | 阿里巴巴集团控股有限公司 | Data searching method and device |
| CN111352688A (en) * | 2020-03-27 | 2020-06-30 | 西安震有信通科技有限公司 | Method and device for screening line graphs and storage medium |
| CN113220728A (en) * | 2021-05-24 | 2021-08-06 | 跬云(上海)信息科技有限公司 | Data query method, device, equipment and storage medium |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105657680A (en) * | 2016-03-30 | 2016-06-08 | 中国联合网络通信集团有限公司 | Periodic flow-reminding message transmission optimizing method and system |
| CN112148778A (en) * | 2020-09-24 | 2020-12-29 | 普华云创科技(北京)有限公司 | Data statistical result display method and system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102053988A (en) * | 2009-10-30 | 2011-05-11 | 国际商业机器公司 | Method and system for visualization of data set |
| CN102650995A (en) * | 2011-02-25 | 2012-08-29 | 中国银联股份有限公司 | Multi-dimensional data analyzing model generating system and method |
| CN103164222A (en) * | 2013-02-25 | 2013-06-19 | 用友软件股份有限公司 | Multidimensional modeling system and multidimensional modeling method |
| CN103399926A (en) * | 2013-08-05 | 2013-11-20 | 河海大学 | Water conservancy general survey data multidimensional analysis and service system and encapsulation and achieving method thereof |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102207940B (en) * | 2010-03-31 | 2014-11-05 | 国际商业机器公司 | Method and system for checking data |
| CN103955502B (en) * | 2014-04-24 | 2017-07-28 | 科技谷（厦门）信息技术有限公司 | A kind of visualization OLAP application realization method and system |
-
2014
- 2014-09-16 CN CN201410471870.7A patent/CN105488045A/en active Pending
-
2015
- 2015-05-20 WO PCT/CN2015/079410 patent/WO2016041372A1/en active Application Filing
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102053988A (en) * | 2009-10-30 | 2011-05-11 | 国际商业机器公司 | Method and system for visualization of data set |
| CN102650995A (en) * | 2011-02-25 | 2012-08-29 | 中国银联股份有限公司 | Multi-dimensional data analyzing model generating system and method |
| CN103164222A (en) * | 2013-02-25 | 2013-06-19 | 用友软件股份有限公司 | Multidimensional modeling system and multidimensional modeling method |
| CN103399926A (en) * | 2013-08-05 | 2013-11-20 | 河海大学 | Water conservancy general survey data multidimensional analysis and service system and encapsulation and achieving method thereof |
Non-Patent Citations (1)
| Title |
|---|
| 葡萄城技术团队: ""应用系统中交互式报表功能解析"", 《HTTPS://WWW.CNBLOGS.COM/POWERTOOLSTEAM/P/INTERACTIVE_REPORT.HTML》 * |
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106372194B (en) * | 2016-08-31 | 2019-12-20 | 杭州追灿科技有限公司 | Method and system for presenting search results |
| CN106649431A (en) * | 2016-08-31 | 2017-05-10 | 天津南大通用数据技术股份有限公司 | Method of displaying charts in data visualization |
| CN106372194A (en) * | 2016-08-31 | 2017-02-01 | 杭州追灿科技有限公司 | Method and system for showing search results |
| CN108268480A (en) * | 2016-12-30 | 2018-07-10 | 亿阳信通股份有限公司 | A kind of big data shows method and apparatus |
| CN107562821A (en) * | 2017-08-17 | 2018-01-09 | 平安科技（深圳）有限公司 | Pivot method, apparatus and computer-readable storage medium based on database |
| CN107870969A (en) * | 2017-08-31 | 2018-04-03 | 平安科技（深圳）有限公司 | Dynamic more new relation exploded view method and application server |
| CN107958029A (en) * | 2017-11-17 | 2018-04-24 | 网易乐得科技有限公司 | Link methods of exhibiting, medium, device and computing device |
| CN108170713A (en) * | 2017-11-30 | 2018-06-15 | 东软集团股份有限公司 | The method, apparatus and storage medium and electronic equipment of data displaying |
| CN110083346A (en) * | 2018-01-25 | 2019-08-02 | 阿里巴巴集团控股有限公司 | Screening configuration method and device based on data visualization interface |
| CN110309208A (en) * | 2018-03-01 | 2019-10-08 | 阿里巴巴集团控股有限公司 | The implementation method and device of data visualization |
| CN111046304A (en) * | 2018-10-12 | 2020-04-21 | 阿里巴巴集团控股有限公司 | Data searching method and device |
| CN111046304B (en) * | 2018-10-12 | 2023-10-13 | 阿里巴巴集团控股有限公司 | Data searching method and device |
| CN110659326A (en) * | 2019-09-25 | 2020-01-07 | 猫岐智能科技（上海）有限公司 | Data display method |
| CN110704516A (en) * | 2019-09-25 | 2020-01-17 | 猫岐智能科技（上海）有限公司 | Data linkage display system |
| CN111352688A (en) * | 2020-03-27 | 2020-06-30 | 西安震有信通科技有限公司 | Method and device for screening line graphs and storage medium |
| CN113220728A (en) * | 2021-05-24 | 2021-08-06 | 跬云(上海)信息科技有限公司 | Data query method, device, equipment and storage medium |
| CN113220728B (en) * | 2021-05-24 | 2023-11-28 | 跬云(上海)信息科技有限公司 | Data query method, device, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2016041372A1 (en) | 2016-03-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105488045A (en) | Data display method and device | |
| US20220327137A1 (en) | Modifying field definitions to include post-processing instructions | |
| CN108804513A (en) | Automatic visual analysis method for big data platform | |
| US8599203B2 (en) | Systems and methods for presenting visualizations of media access patterns | |
| US8190620B2 (en) | Apparatus and method for visualizing data within a decomposition graph | |
| WO2016041373A1 (en) | Data query method and device | |
| US20120221553A1 (en) | Methods for electronic document searching and graphically representing electronic document searches | |
| US11809446B2 (en) | Visualizing time metric database | |
| CN103984755A (en) | Multidimensional model based oil and gas resource data key system implementation method and system | |
| RU2008103277A (en) | MANAGEMENT OF A CAROUSEL TYPE FOR NAVIGATION AND META-DATA ASSIGNMENT | |
| US20070233666A1 (en) | Drilling on elements in arbitrary ad-hoc reports | |
| CN110019555A (en) | A kind of relation data semantization modeling method | |
| CN107315842A (en) | A kind of unstructured data collection method for visualizing based on clustering | |
| CN114547077A (en) | Intelligent processing system and method for basic government affair form data | |
| CN114610923B (en) | Big data processing method, device, equipment and medium | |
| CN112270628A (en) | Intellectual property theme library management method and system | |
| CN103198078A (en) | Internet news event report trend analysis method and system | |
| CN108959439B (en) | Data template generation method and system | |
| CN114443656A (en) | Customizable automated data model analysis tool and use method thereof | |
| CN107391643B (en) | Service system and service method for displaying thematic map on map | |
| CN104978334A (en) | Processing method and device of spatiotemporal behavior data | |
| CN115098029A (en) | Data processing method and device | |
| CN109902148A (en) | A kind of method of the enterprise name auto-complete of address book contact | |
| Schlegel et al. | Balloon Synopsis: A jQuery plugin to easily integrate the Semantic Web in a website. | |
| KR20100067731A (en) | Digital chronological table |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20160413 |