CN104462453A - Data cube based visual data display method and device - Google Patents
Data cube based visual data display method and device Download PDFInfo
- Publication number
- CN104462453A CN104462453A CN201410779664.2A CN201410779664A CN104462453A CN 104462453 A CN104462453 A CN 104462453A CN 201410779664 A CN201410779664 A CN 201410779664A CN 104462453 A CN104462453 A CN 104462453A
- Authority
- CN
- China
- Prior art keywords
- data
- dimensional
- cube
- database
- dimension
- 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/24—Querying
- G06F16/248—Presentation of query results
-
- 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
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)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data cube based visual data display method and device. The method includes: receiving a query instruction; reading a three-dimensional data cube needing to be viewed from a three-dimensional data cube set according to the query instruction, and acquiring dimension and measurement of the three-dimensional data cube needing to be viewed, wherein the three-dimensional data cube set including at least one three-dimensional data cube is pre-created; querying from a database according to the dimension and the measurement of the three-dimensional data cube needing to be viewed, displaying a query result through a virtual three-dimensional display model, and generating a three-dimensional display image; acquiring display data associated to time from the three-dimensional display image to form a dynamic three-dimensional display image. A data structure of each data unit is defined in the database, and structural data corresponding to the database structure of the database are null. Through the method and device, the problem about limited display of infinite values is solved.
Description
Technical field
The present invention relates to data processing field, in particular to a kind of visualized data display packing based on data cube and device.
Background technology
Data cube (Data Cube) is a kind of Technical Architecture for data analysis and index, and it is the process sharp weapon for large data (big data), can carry out any multiple key real time indexing to metadata.After by data cube metadata being analyzed, greatly can accelerate the retrieval and indexing efficiency of data.Data cube outmatches on data storage layer and Database Systems, after being resolved by data cube, greatly can increase the speed of the business such as data query and retrieval, system platform can be allowed to possess advantages such as data are put in storage in real time, real-time query, Query Result real-time Transmission.
Because the model of data cube is more abstract, the reading comparison of data after extraction is difficult and understand, and data are after extraction simultaneously, and the numerical value of data is not identical.In the problem of the combination of abstract unlimited numerical value, fixed numbers, need the limited showing problem solving unlimited numerical value, need the availability of adding users, intelligibility simultaneously, readable, and keep good Consumer's Experience.
For the problem of the limited displaying of numerical value unlimited in prior art, at present effective solution is not yet proposed.
Summary of the invention
Fundamental purpose of the present invention is to provide a kind of visualized data display packing based on data cube and device, to solve the problem of the limited displaying of unlimited numerical value.
To achieve these goals, according to an aspect of the embodiment of the present invention, provide a kind of visualized data display packing based on data cube.Visualized data display packing based on data cube according to the present invention comprises: receive query statement; From three-dimensional data cube set, the three-dimensional data cube needing to check is read according to query statement, obtain and need the dimension of the three-dimensional data cube checked and estimate, wherein, the three-dimensional data cube set comprising at least one three-dimensional data cube is pre-created, further, in pre-defined three-dimensional data cube for the dimension of locator data unit, for defining estimating and dimension and the corresponding relation between estimating of data cell; The dimension of the three-dimensional data cube checked as required and estimating is inquired about from database, obtains the Query Result that database returns, and Query Result comprises the data of data cell corresponding to three-dimensional data cube that needs check; Query Result is shown by virtual three-dimensional display model, generates three dimensional rendered images; By triggered time axle control, from three dimensional rendered images, obtain the display data with time correlation, the three dimensional rendered images of formative dynamics; Wherein, define the data structure of each data cell in database, the structured data corresponding to wide area information server structure is empty.
To achieve these goals, according to the another aspect of the embodiment of the present invention, provide a kind of visualized data display device based on data cube.Visualized data display device based on data cube according to the present invention comprises: receiver module, for receiving query statement; Acquisition module, for reading the three-dimensional data cube needing to check from three-dimensional data cube set according to query statement, obtain and need the dimension of the three-dimensional data cube checked and estimate, wherein, the three-dimensional data cube set comprising at least one three-dimensional data cube is pre-created, further, in pre-defined three-dimensional data cube for the dimension of locator data unit, for defining estimating and dimension and the corresponding relation between estimating of data cell; Enquiry module, inquires about for the dimension of three-dimensional data cube of checking as required and estimating, obtains the Query Result that database returns from database, and Query Result comprises the data of data cell corresponding to three-dimensional data cube that needs check; 3-D display module, is shown Query Result by virtual three-dimensional display model, generates three dimensional rendered images; Dynamic display module, for passing through triggered time axle control, the display data with time correlation are obtained from three dimensional rendered images, the three dimensional rendered images of formative dynamics, wherein, define the data structure of each data cell in database, the structured data corresponding to wide area information server structure is empty.
According to inventive embodiments, by receiving query statement; From three-dimensional data cube set, the three-dimensional data cube needing to check is read according to query statement, obtain and need the dimension of the three-dimensional data cube checked and estimate, wherein, the three-dimensional data cube set comprising at least one three-dimensional data cube is pre-created, further, in pre-defined three-dimensional data cube for the dimension of locator data unit, for defining estimating and dimension and the corresponding relation between estimating of data cell; The dimension of the three-dimensional data cube checked as required and estimating is inquired about from database, obtains the Query Result that database returns, and Query Result comprises the data of data cell corresponding to three-dimensional data cube that needs check; Query Result is shown by virtual three-dimensional display model, generates three dimensional rendered images; By triggered time axle control, from three dimensional rendered images, obtain the display data with time correlation, the three dimensional rendered images of formative dynamics; Wherein, define the data structure of each data cell in database, the structured data corresponding to wide area information server structure is empty.Solve the problem of the limited displaying of unlimited numerical value, reach scene and express and select and carry out expression effect according to entity device and demand.
Accompanying drawing explanation
The accompanying drawing forming a application's part is used to provide a further understanding of the present invention, and schematic description and description of the present invention, for explaining the present invention, does not form inappropriate limitation of the present invention.In the accompanying drawings:
Fig. 1 is the process flow diagram of the visualized data display packing based on data cube according to the embodiment of the present invention one;
Fig. 2 implements schematic diagram in detail according to the visualized data display packing based on data cube of the embodiment of the present invention one; And
Fig. 3 is the schematic diagram of the visualized data display device based on data cube according to the embodiment of the present invention two.
Embodiment
It should be noted that, when not conflicting, the embodiment in the application and the feature in embodiment can combine mutually.Below with reference to the accompanying drawings and describe the present invention in detail in conjunction with the embodiments.
The present invention program is understood better in order to make those skilled in the art person, below in conjunction with the accompanying drawing in the embodiment of the present invention, technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is only the embodiment of a part of the present invention, instead of whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtained under creative work prerequisite, should belong to the scope of protection of the invention.
It should be noted that, term " first ", " second " etc. in instructions of the present invention and claims and above-mentioned accompanying drawing are for distinguishing similar object, and need not be used for describing specific order or precedence.Should be appreciated that the data used like this can be exchanged, in the appropriate case so that embodiments of the invention described herein.In addition, term " comprises " and " having " and their any distortion, intention is to cover not exclusive comprising, such as, contain those steps or unit that the process of series of steps or unit, method, system, product or equipment is not necessarily limited to clearly list, but can comprise clearly do not list or for intrinsic other step of these processes, method, product or equipment or unit.
Embodiment 1
According to the embodiment of the present invention, a kind of visualized data display packing based on data cube can be provided, it should be noted that, can perform in the computer system of such as one group of computer executable instructions in the step shown in the process flow diagram of accompanying drawing, and, although show logical order in flow charts, in some cases, can be different from the step shown or described by order execution herein.
Fig. 1 is the process flow diagram of the visualized data display packing based on data cube according to the embodiment of the present invention one.As shown in Figure 1, it is as follows that the method comprising the steps of:
Step S103, receive query statement, this query statement can be inputted by user and obtain.
In above-mentioned steps S103, create the data cell in three-dimensional data cube dimension and after estimating, by the query statement providing an inputting interface to receive user's input, can be inquired about the specifying information obtaining user and need to inquire about by query statement.
Step S105, reads the three-dimensional data cube needing to check from three-dimensional data cube set according to query statement, obtain and need the dimension of the three-dimensional data cube checked and estimate.
In above-mentioned steps S105, after the query statement receiving user's input, corresponding three-dimensional data cube is read according to query statement, thus get user and need the dimension of the three-dimensional data cube checked and estimating, wherein getting the dimension of three-dimensional data cube and the query statement of user after estimating, can responded.
Preferably, as shown in Figure 1, before execution step S103, step S101 can be performed, create and comprise the three-dimensional data cube set of at least one three-dimensional data cube, in definition three-dimensional data cube for the dimension of locator data unit, for defining estimating and dimension and the corresponding relation between estimating of data cell.
In above-mentioned steps S101, by setting up virtual three-dimensional data cube, define the dimension of data cell and estimating of data cell, data cell is the combination of data structure or the data structure obtained due to demand, the combination of data structure or data structure is included among data cell, forms data cell.Wherein, the dimension of data cell can adopt the x-axis of data cell on Spatial Dimension and y-axis to locate, estimating of data cell can adopt the z-axis of data cell on Spatial Dimension to locate, by the dimension of data cell and the setting estimated, define the dimension of data cell and the corresponding relation between estimating.
Data cell in the application's above-mentioned steps can comprise polytype data structure as a kind of virtual container, and data structure can unrestricted choice, splits, calls, combination.Wherein, the realization flow of the minimum unit of information of composition data structure is generation information, transmission information and the information of reception.
It should be noted that herein, in the process creating three-dimensional data cube, in advance multidimensional data can be imported database, thus realize data importing data cube to carry out data processing.
Step S107, the dimension of the three-dimensional data cube checked as required and estimating is inquired about from database, obtains the Query Result that database returns, and Query Result comprises the data of data cell corresponding to three-dimensional data cube that needs check.
The data cell related in above-mentioned steps S107 is a kind of virtual module of virtual settings, due to various data structure can be comprised in " data cell ", Query Result can be the macroscopical scene be made up of micro-data, composition graphs 2 is known, data cell is the equal of the passage between micro-data and macroscopical scene, micro-data is the value of reality corresponding to data cell, and it is the elementary cell forming macroscopical scene, data cell can be changed on exhibition method, and data dimension can be counted as the dimension of more than 1.
Step S109, is shown Query Result by virtual three-dimensional display model, generates three dimensional rendered images.
Step S111, by triggered time axle control, the display data with time correlation are obtained from three dimensional rendered images, the three dimensional rendered images of formative dynamics, wherein, define the data structure of each data cell in database, the structured data corresponding to wide area information server structure is empty, does not namely define wide area information server structure.
In above-mentioned steps S109, the data structure of above-mentioned different in kind all belongs to free data structure, the feature of the structure attribute of each free data structure is not identical, in the embodiment that the application provides, because Query Result has different nature and characteristics in macroscopic aspect, database structure and fixing graphical representation can not be imported in advance, but free called data structure independent assortment according to demand, there is structural relation between data structure.Because different scenes needs the Query Result that gets different, the data therefore needed are different, by scene matching data, and do not set fixing data structure, thus realize scene and express upper selection and express according to entity device and demand.
In above-mentioned steps S111, realize the function of space-time sneakerization by increasing time shaft control.For data space, the mobility of time is down to minimum, from cumulative data to brand-new data, by the operation to the time, obtains the data rule relevant with the time.
It should be noted that, the data cell in the application is separated completely with this data structure herein, and data structure is identical, but data cell is as the carrier of carrying data structure, be variable, finally affect data exhibiting, and data structure is not affected to some extent.And the application does not define database structure, only possess minimum data dimension, i.e. 0 to 1 dimension, data structure can input in advance, and the dimension of data dimension and structure are freely.
Also it should be noted that herein, data structure in the above-mentioned data cell of the application can the minimum unit of composition data display element, inquiring about from database according to the data cell of three-dimensional data cube definition herein, obtain the expression process that Query Result process is exactly the macroscopical scene from microscopic information to information aggregation, thus form infinite expanding Multi information space, and the 3D solid forming macroscopic view is considerable, can show by perception data.
The data structure that the application relates to is the most basic of cell call, and the simplest one is called and visual means, and the direct locking data structure when data structure location, decreases the degree of freedom of data structure.
A kind of preferred embodiment, at execution step S107, inquire about from database with estimating in the dimension of the three-dimensional data cube checked as required, before the Query Result that acquisition database returns, the method can also comprise step S1061 and step S1063:
Step S1061, build database, database comprises multiple data cell, and wherein, each data cell comprises: the structural relation between multiple data structure and each data structure, and according to demand independent assortment between each data structure.
Concrete, the database that the application's above-mentioned steps builds can comprise multiple data dimension, and the carrying container of virtual single-dimensional data or data structure, i.e. data cell, wherein, data cell has bearing function and tag location function, and each data cell can comprise two class use-patterns: 1, can carry the structural relation between the data structure of independent assortment and each data structure, and according to demand independent assortment between each data structure; 2, the incidence relation between each data cell and data cell can be located.
Step S1063, the data cell of loading of databases definition, not loading of databases structure.
In such scheme, can determine that the data structure comprised in data cell is minimum unit of information, data cell can be divided into microscopic information to form and macroscopic information is formed.Composition graphs 2 is known, and microscopic information can be the minimum information unit comprised in data cell, and then can be converted to the expression of macroscopical scene of oriented manipulation object, forms operation and the function of associated scenario eventually through the Query Result in corresponding data.Such as, it can be keyword that microscopic information is formed, url, click volume, and mouse clicks space, virtual neuron, cell, the amount of money etc.; Macroscopic information is configured to virtual detection scene, and entity detection scene, interactive detection scene etc., in being all summarised in.In the process that database imports, not rigid importing data structure, but the multidimensional dimension and the minimum information unit that only import data, the restructuring of data structure trends towards liberalization on this basis, and recombinates according to actual conditions.
In macroscopical scene, data representation not necessarily has structure, but it is declarative to have scene.Displaying presentation data, makes data move towards macroscopic aspect from microcosmic point, is more easily understood.Can progressively dissect to microcosmic point from macroscopic aspect, find practical problems, thus play the true value of small data.
A kind of preferred embodiment, at execution step S103, before receiving the query statement of user's input, the method can also comprise step S1031: step S1031, configuration data scene according to demand, determines the three-dimensional data cube needing to check, data scene is the data structure of combination in any;
Wherein, the dimension of the three-dimensional data cube checked as required is inquired about from database with estimating, the step obtaining the Query Result that database returns comprises: according to the combination of the determined data structure of data scene, and from database, inquiry obtains corresponding data cell.
In above-mentioned steps S1031, the determined data structure of above-mentioned data scene is free data structure, namely fixing data structure is not set, this data scene has changeability, the combination of free data structure can be selected to implant according to scene, thus realize scene expression is selected to express according to entity device and demand.This mode is different from legacy data and expresses concept, is expression data and expression data, but is this data scene and expression data, the preferred realistic price embodying data.Data cell, when structure macrostructure, has versatility and the associativity of particular range, determines because of actual conditions.
It should be noted that, the data scene related in such scheme has diversity herein, which determines the data structure that the data matched with scene can generate combination in any.
A kind of optional embodiment, at execution step S101, create after comprising the three-dimensional data cube set of at least one three-dimensional data cube, the method can also perform step S102:
Step S102, three-dimensional data cube in the set of definition three-dimensional data cube and the linking relationship of database, wherein, configuring different data scenes according to demand, after determining the combination of new data structure, inquire about from database according to linking relationship and obtain new data cell.Wherein, data cell can carry related data, data structure, default number, or is empty.
In above-mentioned steps S102, due in macroscopical scene, data cell and macroscopical scene of data structure and formation thereof have matching, common reflection macroscopic view scene, simultaneously can independent assortment data structure according to demand, then can be in use in different data scenes and go, form the part forming macro-data.The application, after the combination determining new free data structure according to demand, can directly import data structure result, so that make based on the judgement of the macroscopic view of data and the effect size that produces in the different data scale of constructions; After data structure being implanted, the result of observed data value in the different data scale of constructions, to make quantum chemical method.
It should be noted that herein, can also by the data of adjustment microcosmic, the phenomenon that observation macroscopic aspect occurs, and predict the result in many ways that may cause, so that make the judgement of the macroscopic view based on data.Also can observe the variation in macroscopical direction, dissect to micro-data, thus find the definite dimension causing change, reach precision discrimination.
A kind of preferred embodiment, step S109, can comprise the steps: the scheme that Query Result is undertaken showing by virtual three-dimensional display model
Step S1101, obtains showing paths of Query Result.
Step S1103, uses 3-D view process software to obtain the corresponding panorama sketch index that shows paths, and obtains 3-D display model according to panorama sketch index.
Step S1105, is presented in 3-D display model corresponding to panorama sketch index according to panorama sketch index by Query Result, obtains cubic panorama.
In the scheme that above-mentioned steps S1101 to step S1105 realizes, first showing paths of Query Result is obtained, then 3-D view process software is used to obtain the corresponding panorama sketch index that shows paths, and obtain 3-D display model according to panorama sketch index, finally Query Result is presented in 3-D display model corresponding to panorama sketch index, to reach the object obtaining cubic panorama.
Preferably, three-dimensional data cube in above-mentioned embodiment can comprise three dimensions, what each dimension correspondence one was estimated estimates axle, three-dimensional data cube comprises following three and estimates showing paths of axle formation: x estimates axle, y estimates axle and z estimates axle, wherein, the step be presented at by Query Result in 3-D display model corresponding to panorama sketch index comprises:
Step S1091, is presented at x and estimates axle and y and estimate on the two-dimentional display plane that axle forms, and estimated on axle by virtual for the data cell of another dimension in the three-dimensional data cube z of being presented at by the data cell of any two dimensions in three-dimensional data cube.
In above-mentioned steps S1091, x estimates axle, y estimates axle and has positioning function, not necessarily has the function forming structure; X estimates axle, y estimates the data cell that axle can obtain required for cross bearing one, thus the inner corresponding data structure of calling data unit and data value thereof.
" data cell " this virtual module due to virtual settings, and " data cell " has Fractals, such that data cell and x estimate axle, y estimates the object that axle locates and match.
Concrete, above-mentioned 3-D display model is one and sets up virtual image three-dimensional coordinate system, be different from three-dimensional data cube, three-dimensional data cube does not have aerial image character, and 3-D display model estimates axle for the xyz tri-setting virtual three-dimensional coordinate system, and intersect deduction xyz and estimate related data information on axle, the final stereo data model forming three-dimensional visible.
It should be noted that herein, according to existing stereoscopic imaging apparatus, the stereo data model of three-dimensional visible can be carried out space plane projection.Such as goods electronic sand map is by anatomy projection more than two sides.
In above-mentioned preferred embodiment, the control that can also be provided by display interface carries out following any one or multiple operation to the data cell of any one dimension: check data cell, Update Table unit, replacement data unit, deletes data cell; And/or the control provided by display interface carries out following any one or multiple operation to the data structure in the data cell of any one dimension: check data cell, Update Table structure, replacement data structure, delete data structure.
It can thus be appreciated that, the control that the application can be provided by display interface is changed data cell and data structure the amendment of the data cell of any one dimension and data structure, replacement and deletion action, flexibly to demonstrate the unlimited numerical value that user needs.
A kind of optional embodiment, step S111, by triggered time axle control, from three dimensional rendered images, obtain the display data with time correlation, the scheme of the three dimensional rendered images of formative dynamics can comprise the steps:
Step S1111, triggered time axle control, the moment on positioning time axle or time period.
Step S1113, carries out cutting according to the moment on time shaft or time period to the data in data cell, obtains the dynamic data with time correlation, wherein, according to demand independent assortment between each data structure that data cell comprises.
Preferably, the dynamic data in above-mentioned embodiment can comprise any one data following: time slice data, time data, cumulative time data, hopping time data and parallel time data.
Step S1115, by dynamic data and 3-D display models coupling with time correlation, generates dynamic three dimensional rendered images.
The scheme that above-mentioned steps S1111 to step S1115 provides can realize the combination of data and figure, after joining day dimension, occur due to the variation of time diversified and spatiotemporal, make in concrete implementation process, data can be generated dynamic data according to the chopping rule on time shaft, chopping rule can be time data, time slice data, accumulated time data, hopping time data, parallel time data etc., add that the data of time dimension will present dynamic data rule.Data are made to have more observation.Increase the visibility of data on this basis, availability, readable, predictability.
As from the foregoing, in Virtual Space, large data regarded as in an overall process, space estrangement greatly reduces, in Virtual space, the acting in space has been down to minimum, but time dimension does not still become, but for time dimension, the time will have reversibility, detectivity, alternative, and predictability, the variability adding increase display data of time dimension.Now data will become dynamic data from static data, and representing of dynamic data represents difficulty by what increase data, visually will meet dynamic reading habit.
Below with regard to composition graphs 1 and Fig. 2, based on data cube, to realize data image on Webpage, be described in detail as follows to the step that the application's said method embodiment realizes:
Step 1: based on data cube, setting can form the three-dimensional data axle of data cube, and set up a three-dimensional system of coordinate, wherein, x estimates axle, y estimates axle and have positioning function, z estimates axle for characterizing located data.These three data axles have and can be added polarization.Wherein, have a data axle to be identical " data structure ", this identical data structure is applicable to being added random positioned one " data cell " with two other data axle.
Step 2: creation database, multiple data cell is saved in database, and define " data structure " of data and the setting comprised in " data cell " for free, the data structure of demand can be formed arbitrarily, " data structure " after combination can be used any one " data cell ", but data value is different.Data structure after combination can change, and changes its composition data type.
Step 3: receive query statement, thus determine the dimension of the three-dimensional data cube needing to check and estimate.
Step 4: the dimension of the three-dimensional data cube checked as required extracts the data cell behind location with estimating from database.
Step 5: the image forming relevant " data structure " according to the data cell behind the location be drawn into, should " data structure " be free data structure result, can change the numerical value of different extracted data according to ways of presentation and rule.
Step 6: the image got is shown in the mode of virtual three-dimensional, namely shows three dimensional rendered images.Preferably, can from the display module of " data structure ", direct replacement data data type, forms new data structure, and data type herein refers to the relationship type between the data element in data structure, namely the internal sorting of data structure is represented, such as, bubble classification, Shell sort, Fast Classification, merge sort, heap classification and radix sort, wherein, define the data structure of each data cell in database, do not define database structure.
Step 7: time shaft control is provided, can obtain the moment location on time shaft and time period location by triggered time axle control, thus cutting is carried out to the data in existing identical " data structure ", thus obtain relevant " data structure " fragment or time data to time correlation.
Step 8: fragment data or the time data 3-D display model corresponding with " data structure " or graphical model are combined, " data structure " model of formative dynamics or figure, the i.e. three dimensional rendered images of formative dynamics.
Embodiment 2
According to the embodiment of the present invention, additionally provide a kind of for corresponding to the device implementing said method embodiment one, in the configuration that it is the most basic, Fig. 3 is the schematic diagram of the visualized data display device based on data cube according to the embodiment of the present invention two.For purposes of illustration, the architecture of painting is only an example of proper environment, not proposes any limitation to the usable range of the application or function.This computing system should be interpreted as, to the arbitrary assembly shown in Fig. 1 or its combination, there is any dependence or demand yet.
As shown in Figure 3, following functional module can should be comprised based on the visualized data display device of data cube: receiver module 22, acquisition module 23, enquiry module 24,3-D display module 25 and dynamic display module 26.
Receiver module 22, for receiving query statement; Acquisition module 23, for reading the three-dimensional data cube needing to check from three-dimensional data cube set according to query statement, obtains and needs the dimension of the three-dimensional data cube checked and estimate; Enquiry module 24, inquires about for the dimension of three-dimensional data cube of checking as required and estimating, obtains the Query Result that database returns from database, and Query Result comprises the data of data cell corresponding to three-dimensional data cube that needs check; 3-D display module 25, is shown Query Result by virtual three-dimensional display model, generates three dimensional rendered images; Dynamic display module 26, for passing through triggered time axle control, the display data with time correlation are obtained from three dimensional rendered images, the three dimensional rendered images of formative dynamics, wherein, define the data structure of each data cell in database, the structured data corresponding to wide area information server structure is empty, does not namely define database structure.
Preferably, device provided by the invention can also comprise creation module 21, for creating the three-dimensional data cube set comprising at least one three-dimensional data cube, in definition three-dimensional data cube for the dimension of locator data unit, for defining estimating and dimension and the corresponding relation between estimating of data cell.
A kind of preferred embodiment, said apparatus also comprises:
Build module, for building database, database comprises multiple data cell, and wherein, each data cell comprises: the structural relation between multiple data structure and each data structure, and according to demand independent assortment between each data structure;
Database processing module, for the data cell of loading of databases definition, not loading of databases structure.
A kind of preferred embodiment, said apparatus also comprises:
Determination module, for configuration data scene according to demand, determine the three-dimensional data cube needing to check, data scene is the data structure of combination in any;
Wherein, enquiry module comprises: subquery module, and for the combination according to the determined data structure of data scene, from database, inquiry obtains corresponding data cell.
A kind of preferred embodiment, said apparatus also comprises:
Definition module, for defining the linking relationship of three-dimensional data cube in three-dimensional data cube set and database, wherein, configuring different data scenes according to demand, after determining the combination of new data structure, inquire about from database according to linking relationship and obtain new data cell.
A kind of preferred embodiment, above-mentioned 3-D display module also comprises:
First sub-acquisition module, for obtaining showing paths of Query Result;
Second sub-acquisition module, for using 3-D view process software to obtain the corresponding panorama sketch index that shows paths, and obtains 3-D display model according to panorama sketch index;
3rd sub-acquisition module, for being presented in 3-D display model corresponding to panorama sketch index according to panorama sketch index by Query Result, obtains cubic panorama.
Preferably, three-dimensional data cube in above-mentioned possibility can comprise three dimensions, what each dimension correspondence one was estimated estimates axle, three-dimensional data cube comprises following three and estimates showing paths of axle formation: x estimates axle, y estimates axle and z estimates axle, wherein, above-mentioned 3rd sub-acquisition module can comprise:
Sub-display module, estimate axle and y and estimate for the data cell of any two dimensions in three-dimensional data cube being presented at x the two-dimentional display plane that axle forms, and virtual for the data cell of another dimension in the three-dimensional data cube z of being presented at is estimated on axle.
A kind of preferred embodiment, above-mentioned sub-display module also comprises:
First operating unit, carries out following any one or multiple operation for the control that provided by display interface to the data cell of any one dimension: Update Table unit, replacement data unit, delete data cell;
And/or the second operating unit, carries out following any one or multiple operation for the control that provided by display interface to the data structure in the data cell of any one dimension: Update Table structure, replacement data structure, delete data structure.
A kind of preferred embodiment, above-mentioned dynamic display module can comprise:
Locating module, for triggered time axle control, the moment on positioning time axle or time period;
Cutting module, for carrying out cutting according to the moment on time shaft or time period to the data in data cell, obtains the dynamic data with time correlation, wherein, according to demand independent assortment between each data structure that data cell comprises;
Generation module, for by the dynamic data and 3-D display models coupling with time correlation, generates dynamic three dimensional rendered images.
Preferred or optional embodiment corresponding to the application's device embodiment and the embodiment of the method that embodiment one provides preferably or the application scenarios of embodiment identical, example is also identical, but is not limited to the preferred or embodiment that embodiment one provides.
It should be noted that, the visualized data display device based on data cube of the embodiment of the present invention may be used for performing the visualized data display packing based on data cube that the embodiment of the present invention provides, and the visualized data display device based on data cube that the visualized data display packing based on data cube of the embodiment of the present invention also can be provided by the embodiment of the present invention performs.
The invention described above embodiment sequence number, just to describing, does not represent the quality of embodiment.
In the above embodiment of the present invention, the description of each embodiment is all emphasized particularly on different fields, in certain embodiment, there is no the part described in detail, can see the associated description of other embodiments.
In several embodiments that the application provides, should be understood that, disclosed client, the mode by other realizes.Wherein, device embodiment described above is only schematic, the such as division of described unit, be only a kind of logic function to divide, actual can have other dividing mode when realizing, such as multiple unit or assembly can in conjunction with or another system can be integrated into, or some features can be ignored, or do not perform.Another point, shown or discussed coupling each other or direct-coupling or communication connection can be by some interfaces, and the indirect coupling of unit or module or communication connection can be electrical or other form.
The described unit illustrated as separating component or can may not be and physically separates, and the parts as unit display can be or may not be physical location, namely can be positioned at a place, or also can be distributed in multiple network element.Some or all of unit wherein can be selected according to the actual needs to realize the object of the present embodiment scheme.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, also can be that the independent physics of unit exists, also can two or more unit in a unit integrated.Above-mentioned integrated unit both can adopt the form of hardware to realize, and the form of SFU software functional unit also can be adopted to realize.
If described integrated unit using the form of SFU software functional unit realize and as independently production marketing or use time, can be stored in a computer read/write memory medium.Based on such understanding, the part that technical scheme of the present invention contributes to prior art in essence in other words or all or part of of this technical scheme can embody with the form of software product, this computer software product is stored in a storage medium, comprises all or part of step of some instructions in order to make a computer equipment (can be personal computer, server or the network equipment etc.) perform method described in each embodiment of the present invention.And aforesaid storage medium comprises: USB flash disk, ROM (read-only memory) (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), portable hard drive, magnetic disc or CD etc. various can be program code stored medium.
The above is only the preferred embodiment of the present invention; it should be pointed out that for those skilled in the art, under the premise without departing from the principles of the invention; can also make some improvements and modifications, these improvements and modifications also should be considered as protection scope of the present invention.
Claims (16)
1., based on a visualized data display packing for data cube, it is characterized in that, comprising:
Receive query statement;
From described three-dimensional data cube set, the three-dimensional data cube needing to check is read according to described query statement, obtain the dimension of the three-dimensional data cube that described needs are checked and estimate, wherein, the described three-dimensional data cube set comprising at least one three-dimensional data cube is pre-created, further, in pre-defined described three-dimensional data cube for the dimension of locator data unit, for define described data cell estimate and described dimension and described estimate between corresponding relation;
The dimension of the three-dimensional data cube checked according to described needs and estimating is inquired about from database, obtains the Query Result that described database returns, and described Query Result comprises the data of data cell corresponding to three-dimensional data cube that described needs check;
Described Query Result is shown by virtual three-dimensional display model, generates three dimensional rendered images;
By triggered time axle control, from described three dimensional rendered images, obtain the display data with time correlation, the three dimensional rendered images of formative dynamics;
Wherein, define the data structure of each data cell in described database, the structured data corresponding to described wide area information server structure is empty.
2. method according to claim 1, is characterized in that, inquires about from database in the dimension and estimating of the three-dimensional data cube checked according to described needs, and before obtaining the Query Result that described database returns, described method also comprises:
Build described database, described database comprises multiple data cell, and wherein, each described data cell comprises: the structural relation between multiple data structure and each data structure, and according to demand independent assortment between each data structure;
Load the data cell of described database definition, not loading of databases structure.
3. method according to claim 2, it is characterized in that, before the query statement receiving user's input, described method also comprises: configuration data scene according to demand, determine the three-dimensional data cube that described needs are checked, described data scene is the data structure of combination in any;
Wherein, the dimension of the three-dimensional data cube checked according to described needs and estimating is inquired about from database, and the step obtaining the Query Result that described database returns comprises:
According to the combination of the determined data structure of data scene, from described database, inquiry obtains corresponding data cell.
4. method according to claim 3, is characterized in that, after establishment comprises the three-dimensional data cube set of at least one three-dimensional data cube, described method also comprises:
Define the linking relationship of three-dimensional data cube in described three-dimensional data cube set and database, wherein, configuring different data scenes according to demand, after determining the combination of new data structure, inquiring about from described database according to described linking relationship and obtain new data cell.
5. method according to claim 1, is characterized in that, the step that described Query Result is undertaken showing by virtual three-dimensional display model is comprised:
Obtain showing paths of described Query Result;
Show paths described in use 3-D view process software obtains corresponding panorama sketch index, and obtain described 3-D display model according to described panorama sketch index;
According to described panorama sketch index, described Query Result is presented in 3-D display model corresponding to described panorama sketch index, obtains cubic panorama.
6. method according to claim 5, it is characterized in that, described three-dimensional data cube comprises three dimensions, what each dimension correspondence one was estimated estimates axle, described three-dimensional data cube comprise following three estimate axle form described in show paths: x estimates axle, y estimates axle and z estimates axle, wherein, the step be presented at by described Query Result in 3-D display model corresponding to described panorama sketch index comprises:
The data cell of any two dimensions in described three-dimensional data cube is presented at described x to estimate axle and described y and estimate on the two-dimentional display plane that axle forms, and is presented at described z estimates virtual for the data cell of another dimension in described three-dimensional data cube on axle.
7. method according to claim 6, is characterized in that, the control provided by display interface carries out following any one or multiple operation to the data cell of any one dimension: Update Table unit, replacement data unit, delete data cell; And/or the control provided by described display interface carries out following any one or multiple operation to the data structure in the data cell of any one dimension: Update Table structure, replacement data structure, delete data structure.
8. method according to claim 1, is characterized in that, by triggered time axle control, from described three dimensional rendered images, obtain the display data with time correlation, the step of the three dimensional rendered images of formative dynamics comprises:
Trigger described time shaft control, the moment on positioning time axle or time period;
According to the moment on described time shaft or time period, cutting is carried out to the data in described data cell, obtain the dynamic data with time correlation, wherein, according to demand independent assortment between each data structure that described data cell comprises;
By described described dynamic data with time correlation and described 3-D display models coupling, generate described dynamic three dimensional rendered images.
9. method according to claim 8, is characterized in that, described dynamic data comprises any one data following: time slice data, time data, cumulative time data, hopping time data and parallel time data.
10., based on a visualized data display device for data cube, it is characterized in that, comprising:
Receiver module, for receiving query statement;
Acquisition module, for reading the three-dimensional data cube needing to check from described three-dimensional data cube set according to described query statement, obtain the dimension of the three-dimensional data cube that described needs are checked and estimate, wherein, the described three-dimensional data cube set comprising at least one three-dimensional data cube is pre-created, further, in pre-defined described three-dimensional data cube for the dimension of locator data unit, for define described data cell estimate and described dimension and described estimate between corresponding relation;
Enquiry module, dimension for the three-dimensional data cube checked according to described needs is inquired about from database with estimating, obtain the Query Result that described database returns, described Query Result comprises the data of data cell corresponding to three-dimensional data cube that described needs check;
3-D display module, is shown described Query Result by virtual three-dimensional display model, generates three dimensional rendered images;
Dynamic display module, for by triggered time axle control, obtains the display data with time correlation, the three dimensional rendered images of formative dynamics from described three dimensional rendered images,
Wherein, define the data structure of each data cell in described database, the structured data corresponding to described wide area information server structure is empty.
11. devices according to claim 10, is characterized in that, described device also comprises:
Build module, for building described database, described database comprises multiple data cell, wherein, each described data cell comprises: the structural relation between multiple data structure and each data structure, and according to demand independent assortment between each data structure;
Database processing module, for loading the data cell of described database definition, not loading of databases structure.
12. devices according to claim 11, is characterized in that, described device also comprises: determination module, and for configuration data scene according to demand, determine the three-dimensional data cube that described needs are checked, described data scene is the data structure of combination in any;
Wherein, described enquiry module comprises: subquery module, and for the combination according to the determined data structure of data scene, from described database, inquiry obtains corresponding data cell.
13. devices according to claim 12, is characterized in that, described device also comprises:
Definition module, for defining the linking relationship of three-dimensional data cube in described three-dimensional data cube set and database, wherein, different data scenes is being configured according to demand, after determining the combination of new data structure, inquire about from described database according to described linking relationship and obtain new data cell.
14. devices according to claim 10, is characterized in that, described 3-D display module comprises:
First sub-acquisition module, for obtaining showing paths of described Query Result;
Second sub-acquisition module, for use 3-D view process software obtain described in show paths corresponding panorama sketch index, and obtain 3-D display model according to described panorama sketch index;
3rd sub-acquisition module, for being presented in 3-D display model corresponding to described panorama sketch index according to described panorama sketch index by described Query Result, obtains cubic panorama.
15. devices according to claim 14, it is characterized in that, described three-dimensional data cube comprises three dimensions, what each dimension correspondence one was estimated estimates axle, described three-dimensional data cube comprise following three estimate axle form described in show paths: x estimates axle, y estimates axle and z estimates axle, wherein, described 3rd sub-acquisition module comprises:
Sub-display module, estimate axle and described y and estimate for the data cell of any two dimensions in described three-dimensional data cube being presented at described x the two-dimentional display plane that axle forms, and be presented at described z estimate virtual for the data cell of another dimension in described three-dimensional data cube on axle.
16. devices according to claim 10, is characterized in that, described dynamic display module comprises:
Locating module, for triggering described time shaft control, the moment on positioning time axle or time period;
Cutting module, for carrying out cutting according to the moment on described time shaft or time period to the data in described data cell, obtains the dynamic data with time correlation, wherein, according to demand independent assortment between each data structure that described data cell comprises;
Generation module, for by described described dynamic data with time correlation and described 3-D display models coupling, generates described dynamic three dimensional rendered images.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410779664.2A CN104462453A (en) | 2014-12-15 | 2014-12-15 | Data cube based visual data display method and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410779664.2A CN104462453A (en) | 2014-12-15 | 2014-12-15 | Data cube based visual data display method and device |
Publications (1)
Publication Number | Publication Date |
---|---|
CN104462453A true CN104462453A (en) | 2015-03-25 |
Family
ID=52908488
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410779664.2A Pending CN104462453A (en) | 2014-12-15 | 2014-12-15 | Data cube based visual data display method and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104462453A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105844689A (en) * | 2016-03-29 | 2016-08-10 | 浪潮(苏州)金融技术服务有限公司 | Method of using dimensional space technology for multidimensional data synchronization management |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2001033254A1 (en) * | 1999-11-04 | 2001-05-10 | Phillips Petroleum Company | Automated seismic isochron analysis |
CN102521417A (en) * | 2011-12-30 | 2012-06-27 | 南京柏梭信息科技有限公司 | Method for processing multi-dimensional data based on virtual data cube and system of method |
CN103605739A (en) * | 2013-11-19 | 2014-02-26 | 北京国双科技有限公司 | Method and device for displaying thermodynamic diagrams |
CN104077303A (en) * | 2013-03-28 | 2014-10-01 | 国际商业机器公司 | Method and device for displaying data |
-
2014
- 2014-12-15 CN CN201410779664.2A patent/CN104462453A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2001033254A1 (en) * | 1999-11-04 | 2001-05-10 | Phillips Petroleum Company | Automated seismic isochron analysis |
CN102521417A (en) * | 2011-12-30 | 2012-06-27 | 南京柏梭信息科技有限公司 | Method for processing multi-dimensional data based on virtual data cube and system of method |
CN104077303A (en) * | 2013-03-28 | 2014-10-01 | 国际商业机器公司 | Method and device for displaying data |
CN103605739A (en) * | 2013-11-19 | 2014-02-26 | 北京国双科技有限公司 | Method and device for displaying thermodynamic diagrams |
Non-Patent Citations (2)
Title |
---|
SU MI JI ET AL,: ""A Study on the Generation of OLAP Data Cube Based on 3D Visualization Interaction"", 《2011 INTERNATIONAL CONFERENCE ON COMPUTATIONAL SCIENCE AND ITS APPLICATIONS》 * |
杨玉珍 等,: "《黄河三角洲生态与资源数字化集成研究》", 31 July 2004, 黄河水利出版社 * |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105844689A (en) * | 2016-03-29 | 2016-08-10 | 浪潮(苏州)金融技术服务有限公司 | Method of using dimensional space technology for multidimensional data synchronization management |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107256265B (en) | A kind of search-engine results data visualization methods of exhibiting and system | |
US10621762B2 (en) | Systems and methods for high dimensional 3D data visualization | |
CN101004750B (en) | Process for selecting objects in a PLM database and apparatus implementing this process | |
Fairbairn et al. | Representation and its relationship with cartographic visualization | |
CN101017492B (en) | Process for displaying objects of a PLM database and apparatus implementing this process | |
CN101425063A (en) | Multi-dimension data set displaying and browsing method and equipment | |
CN105378797A (en) | Three dimensional data visualization | |
CN112256790A (en) | WebGL-based three-dimensional visualization display system and data visualization method | |
US20150205840A1 (en) | Dynamic Data Analytics in Multi-Dimensional Environments | |
CN105447098A (en) | Information inquiring method and apparatus | |
CN116992887A (en) | Metadata data catalog processing method, device and processing equipment | |
CN104408187A (en) | Visual data display method and device based on data cubes | |
CN104462450A (en) | Data cube based two-dimensional visual data display method and device | |
CN104408196A (en) | Two-dimensional visual data display method and device based on data cubes | |
CN104462440A (en) | Data cube based two-dimensional visual data display method and device | |
CN104408184A (en) | Two-dimensional visual data display method and device based on data cubes | |
KR102205267B1 (en) | 3D Visualization System and method for time series data | |
CN104462453A (en) | Data cube based visual data display method and device | |
CN111078782B (en) | Industrial big data visualization system and method | |
Song et al. | Development of a lightweight CAE middleware for CAE data exchange | |
CN104462446A (en) | Data cube based two-dimensional visual data display method and device | |
KR20090052970A (en) | Method and system for experiential knowledge associated with spatial and temporal information | |
CN104391997A (en) | Data cube based visual data display method and device | |
CN104408200A (en) | Visual data display method and device based on data cubes | |
CN104408186A (en) | Two-dimensional visual data display method and device based on data cubes |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150325 |