CN104462446A - Data cube based two-dimensional visual data display method and device - Google Patents
Data cube based two-dimensional visual data display method and device Download PDFInfo
- Publication number
- CN104462446A CN104462446A CN201410779415.3A CN201410779415A CN104462446A CN 104462446 A CN104462446 A CN 104462446A CN 201410779415 A CN201410779415 A CN 201410779415A CN 104462446 A CN104462446 A CN 104462446A
- 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/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/9038—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Processing Or Creating Images (AREA)
Abstract
The invention provides a data cube based two-dimensional 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, querying from a database according to the dimension and the measurement of the three-dimensional data cube needing to be viewed, and acquiring a query result returned by the database; displaying the query result through a virtual two-dimensional display model; acquiring display data associated to time from a two-dimensional display image by triggering a time shaft control so as to form a dynamic two-dimensional display image; defining a data structure of each data unit in the database, wherein 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 two-dimentional display packing and device of the visualized data based on data cube.
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 the two-dimentional display packing and the device that provide a kind of visualized data based on data cube, 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 two-dimentional display packing of the visualized data based on data cube.Two-dimentional display packing according to the visualized data based on data cube of 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 two-dimensional display model, generates two-dimensional display image; By triggered time axle control, from two-dimensional display image, obtain the display data with time correlation, the two-dimensional display image 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 two-dimensional display of the visualized data based on data cube.Two-dimensional display according to the visualized data based on data cube of the present invention comprises: receiver module, for receiving the query statement of user's input; 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; Two dimension display module, for being shown by virtual two-dimensional display model by Query Result, generates two-dimensional display image; Dynamic display module, for by triggered time axle control, obtains the display data with time correlation, the two-dimensional display image of formative dynamics from two-dimensional display image; 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 two-dimensional display model, generates two-dimensional display image; By triggered time axle control, from two-dimensional display image, obtain the display data with time correlation, the two-dimensional display image 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, solves the problem of the limited displaying of unlimited numerical value, reaches the visual effect of unlimited numerical value.
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 two-dimentional display packing of the visualized data based on data cube according to the embodiment of the present invention one;
Fig. 2 implements schematic diagram in detail according to the two-dimentional display packing of the visualized data based on data cube of the embodiment of the present invention one; And
Fig. 3 is the schematic diagram of the two-dimensional display of the visualized data 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 bend in 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 two-dimentional display packing of the visualized data 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 two-dimentional display packing of the visualized data 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, 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.
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, 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 two-dimensional display model, generates two-dimensional display image.
Step S111, by triggered time axle control, the display data with time correlation are obtained from two-dimensional display image, the two-dimensional display image 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.
In above-mentioned steps S109, the data structure of above-mentioned different in kind is all bent in free data structure, the feature of the structure tropism 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 2d solid forming macroscopic view is considerable, can show by perception data.In order to meet existing equipment demand, three dimensions needs two dimensionization.The mode of projection is then used to carry out two-dimensional projections.
The data structure that the application relates to is the most basic in 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 two-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 two-dimentional 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 two-dimensional panoramic figure.
In the scheme that above-mentioned steps S1101 to step S1105 realizes, first showing paths of Query Result is obtained, then the corresponding panorama sketch index that shows paths is obtained, and obtain two-dimentional display model according to panorama sketch index, finally Query Result is presented in two-dimentional display model corresponding to panorama sketch index, to reach the object obtaining two-dimensional panoramic figure.
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 two-dimentional 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 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.
Step S1092, projects on two-dimentional display plane by the data cell that the z of being presented at virtual in three-dimensional data cube estimates axle, obtains two-dimensional panoramic figure.
In above-mentioned steps S1092, set virtual xyz virtual visual cubical time, what z estimated data structure virtual around axle and data cell estimates axle, and when two dimension display, visualized graphs z being estimated axle projects on two dimensional surface.Now, viewing area and xy estimate between axle does not have logic in data structure, has association descriptive.
In the application's such scheme, in the two-dimensional space that can be determined by hardware, do two-dimensional visualization, also can by X-Y scheme image and virtual three-dimensional be visual changes.
It can thus be appreciated that, in the scheme that above-mentioned steps S1091 to step S1092 realizes, when two dimension display, visualized graphs z can being estimated axle projects on two dimensional surface, now, viewing area and xy estimate between axle does not have logic in data structure, has association descriptive; Existing equipment demand can be met like this, three dimensions two dimensionization, use the mode of projection to carry out two-dimensional projections particularly, finally reach in the two-dimensional space that hardware determines, can two-dimensional visualization be done.
" data cell " this virtual module due to virtual settings, and " data cell " has Fractals, and the location character unit that data cell and x estimate axle, y estimates axle is matched.
It should be noted that herein, in above-mentioned preferred embodiment, the control that can 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 two-dimensional display image, obtain the display data with time correlation, the scheme of the two-dimensional display image 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, is combined with the dynamic data of time correlation with two-dimentional display model, generates dynamic two-dimensional display image.
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.Preferably, can from the display module of " data structure ", direct replacement 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: on the basis of virtual three-dimensional display, carries out a dimensionality reduction to data model, forms simple two-dimentional interface, generates two-dimensional display image.
Concrete, in such scheme, " data structure " this latitude can be used as do not have latitude " point ", by the axle of other latitude carry out identical " data structure " and " data structure " carries out data visualization, formation content regions to identical in location.Wherein, the ways of presentation of fixing " data structure " and rule, change the numerical value of different extracted data.
Step 8: 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 9: fragment data or the time data two-dimentional display model corresponding with " data structure " or graphical model are combined, " data structure " model of formative dynamics or figure, the i.e. two-dimensional display image 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 two-dimensional display of the visualized data of data cube: receiver module 22, acquisition module 23, enquiry module 24, two-dimentional display module 25 and dynamic display module 26.
Wherein, 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, 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 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; Two dimension display module 25, for being shown by virtual two-dimensional display model by Query Result, generates two-dimensional display image; Dynamic display module 26, for passing through triggered time axle control, the display data with time correlation are obtained from two-dimensional display image, the two-dimensional display image 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, i.e. definition database structure.
Preferably, in said apparatus, creation module 21 can also be comprised, 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.
In above-mentioned creation module 21, 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.
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 two dimension display display module also comprises:
First sub-acquisition module, for obtaining showing paths of Query Result;
Second sub-acquisition module, for obtaining the corresponding panorama sketch index that shows paths, and obtains two-dimentional display model according to panorama sketch index;
3rd sub-acquisition module, for being presented in two-dimentional display model corresponding to panorama sketch index according to panorama sketch index by Query Result, obtains two-dimensional panoramic figure.
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, estimates axle and y and estimates 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; Projection module, projects two-dimentional display plane for the data cell that the z of being presented at virtual in three-dimensional data cube is estimated axle, obtains two-dimensional panoramic figure.
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 being combined with the dynamic data of time correlation with two-dimentional display model, generates dynamic two-dimensional display image.
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, RandomAccess Memory), portable hard drive, magnetic disc or CD etc. various can be program code stored medium.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (16)
1., based on a visualized data two dimension 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 two-dimensional display model, generates two-dimensional display image;
By triggered time axle control, from described two-dimensional display image, obtain the display data with time correlation, the two-dimensional display image 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 described 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 two-dimensional display model is comprised:
Obtain showing paths of described Query Result;
Show paths described in acquisition corresponding panorama sketch index, and obtain described two-dimentional display model according to described panorama sketch index;
According to described panorama sketch index, described Query Result is presented in two-dimentional display model corresponding to described panorama sketch index, obtains two-dimensional panoramic figure.
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 two-dimentional 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;
Be presented at the data cell that described z estimates axle project virtual in described three-dimensional data cube on described two-dimentional display plane, obtain described two-dimensional panoramic figure.
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 two-dimensional display image, obtain the display data with time correlation, the step of the two-dimensional display image 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;
Be combined described with described two-dimentional display model with the described dynamic data of time correlation, generate described dynamic two-dimensional display image.
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 the query statement of user's input;
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;
Two dimension display module, for being shown by virtual two-dimensional display model by described Query Result, generates two-dimensional display image;
Dynamic display module, for by triggered time axle control, obtains the display data with time correlation, the two-dimensional display image of formative dynamics from described two-dimensional display image;
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 described 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 two-dimentional display module comprises:
First sub-acquisition module, for obtaining showing paths of described Query Result;
Second sub-acquisition module, for the corresponding panorama sketch index that shows paths described in obtaining, and obtains described two-dimentional display model according to described panorama sketch index;
3rd sub-acquisition module, for being presented in two-dimentional display model corresponding to described panorama sketch index according to described panorama sketch index by described Query Result, obtains two-dimensional panoramic figure.
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, estimates axle and described y and estimates 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;
Projection module, for being presented at the data cell that described z estimates axle projecting described two-dimentional display plane by virtual in described three-dimensional data cube, obtains described two-dimensional panoramic figure.
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 being combined described with described two-dimentional display model with the described dynamic data of time correlation, generates described dynamic two-dimensional display image.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410779415.3A CN104462446A (en) | 2014-12-15 | 2014-12-15 | Data cube based two-dimensional visual data display method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410779415.3A CN104462446A (en) | 2014-12-15 | 2014-12-15 | Data cube based two-dimensional visual data display method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104462446A true CN104462446A (en) | 2015-03-25 |
Family
ID=52908481
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410779415.3A Pending CN104462446A (en) | 2014-12-15 | 2014-12-15 | Data cube based two-dimensional visual data display method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104462446A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112100157A (en) * | 2020-09-17 | 2020-12-18 | 朱捷 | Cross-platform multi-dimensional database architecture design method and system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102360379A (en) * | 2011-10-10 | 2012-02-22 | 浙江鸿程计算机系统有限公司 | Multi-dimensional data cube increment aggregation and query optimization method |
| CN102521417A (en) * | 2011-12-30 | 2012-06-27 | 南京柏梭信息科技有限公司 | Method for processing multi-dimensional data based on virtual data cube and system of method |
| US20120221510A1 (en) * | 2010-03-31 | 2012-08-30 | International Business Machines Corporation | Method and system for validating data |
| CN103425772A (en) * | 2013-08-13 | 2013-12-04 | 东北大学 | Method for searching massive data with multi-dimensional information |
-
2014
- 2014-12-15 CN CN201410779415.3A patent/CN104462446A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120221510A1 (en) * | 2010-03-31 | 2012-08-30 | International Business Machines Corporation | Method and system for validating data |
| CN102360379A (en) * | 2011-10-10 | 2012-02-22 | 浙江鸿程计算机系统有限公司 | Multi-dimensional data cube increment aggregation and query optimization method |
| CN102521417A (en) * | 2011-12-30 | 2012-06-27 | 南京柏梭信息科技有限公司 | Method for processing multi-dimensional data based on virtual data cube and system of method |
| CN103425772A (en) * | 2013-08-13 | 2013-12-04 | 东北大学 | Method for searching massive data with multi-dimensional information |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112100157A (en) * | 2020-09-17 | 2020-12-18 | 朱捷 | Cross-platform multi-dimensional database architecture design method and system |
| CN112100157B (en) * | 2020-09-17 | 2024-04-02 | 朱景林 | Cross-platform multidimensional database architecture design method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107256265B (en) | A kind of search-engine results data visualization methods of exhibiting and system | |
| US20230013873A1 (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 | |
| CN101425063A (en) | Multi-dimension data set displaying and browsing method and equipment | |
| CN105378797A (en) | Three dimensional data visualization | |
| US11023481B2 (en) | Navigation platform for performing search queries | |
| CN112256790A (en) | WebGL-based three-dimensional visualization display system and data visualization method | |
| CN112416494A (en) | Virtual resource processing method and device, electronic equipment and storage medium | |
| Hauser et al. | State-of-the-art report 2002 in flow visualization | |
| CN104408196A (en) | Two-dimensional visual data display method and device based on data cubes | |
| CN104462450A (en) | Data cube based two-dimensional visual data display method and device | |
| CN104408187A (en) | Visual data display method and device based on data cubes | |
| CN104462440A (en) | Data cube based two-dimensional visual data display method and device | |
| Puolamäki et al. | Interactive visual data exploration with subjective feedback | |
| KR102205267B1 (en) | 3D Visualization System and method for time series data | |
| CN104408184A (en) | Two-dimensional visual data display method and device based on data cubes | |
| CN104462446A (en) | Data cube based two-dimensional visual data display method and device | |
| CN104462453A (en) | Data cube based visual data display method and device | |
| Song et al. | Development of a lightweight CAE middleware for CAE data exchange | |
| CN104408186A (en) | Two-dimensional visual data display method and device based on data cubes | |
| CN104408200A (en) | Visual data display method and device based on data cubes | |
| CN104391997A (en) | Data cube based visual data display method and device | |
| Li et al. | Efficient data modeling and querying system for multi-dimensional spatial data | |
| CN104408181A (en) | 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 |
Application publication date: 20150325 |
|
| RJ01 | Rejection of invention patent application after publication |