CN104408200A - Visual data display method and device based on data cubes - Google Patents
Visual data display method and device based on data cubes Download PDFInfo
- Publication number
- CN104408200A CN104408200A CN201410779622.9A CN201410779622A CN104408200A CN 104408200 A CN104408200 A CN 104408200A CN 201410779622 A CN201410779622 A CN 201410779622A CN 104408200 A CN104408200 A CN 104408200A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- dimensional
- cube
- dimensional data
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/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
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 provides a visual data display method and device based on data cubes. The visual data display method comprises the steps of receiving a query instruction, reading three-dimensional data cubes required to be looked up from a three-dimensional data cube set according to the query instruction, obtaining the dimensionality and measurement of the three-dimensional data cubes required to be looked up, querying a database according to the dimensionality and measurement of the three-dimensional data cubes required to be looked up to obtain a query result which is returned by the database, and displaying the query result through a virtual three-dimensional mode, wherein data structures defined by data units in the database are identical, and structural data corresponding to a database structure of the database are null. The problem of limited display of infinite values is solved by means of the visual data display method and device based on the data cubes.
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 user's query statement; From three-dimensional data cube set, read the three-dimensional data cube needing to check according to query statement, obtain and need the dimension of the three-dimensional data cube checked and estimate; 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 in the mode of virtual three-dimensional; Wherein, define the data structure of each data cell in database, do not define database structure.
To achieve these goals, according to the another one 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, obtains and needs the dimension of the three-dimensional data cube checked and estimate; 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, for showing Query Result in the mode of virtual three-dimensional; Wherein, define the data structure of each data cell in database, do not define database structure.
According to inventive embodiments, by receiving user's query statement; From three-dimensional data cube set, read the three-dimensional data cube needing to check according to query statement, obtain and need the dimension of the three-dimensional data cube checked and estimate; 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 in the mode of virtual three-dimensional; Wherein, define the data structure of each data cell in database, do not define database structure, solve the problem of the limited displaying of unlimited numerical value, reach 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 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, 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, shows Query Result in the mode of virtual three-dimensional; 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.
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 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, the dimension of the three-dimensional data cube checked as required is inquired about from database with estimating, and 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, the scheme that Query Result carries out showing in the mode of virtual three-dimensional can comprise the steps:
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.
Below just 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, form new data structure, 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.
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 and 3-D display module 25.
Wherein, receiver module 22, for receiving the query statement of user's input; 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; 3-D display module 25, for showing Query Result in the mode of virtual three-dimensional; 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.
Preferably, the application can also comprise creation module, 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.
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 (14)
1., based on a visualized data display packing for data cube, it is characterized in that, comprising:
Receive query statement;
From 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 in the mode of virtual three-dimensional;
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 carries out showing in the mode of virtual three-dimensional 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 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., 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, for showing described Query Result in the mode of virtual three-dimensional;
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.
9. device according to claim 8, 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.
10. device according to claim 9, 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.
11. devices according to claim 10, 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.
12. devices according to claim 8, 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.
13. devices according to claim 12, 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.
14. devices according to claim 13, is characterized in that, described 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 described display interface to the data structure in the data cell of any one dimension: Update Table structure, replacement data structure, delete data structure.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410779622.9A CN104408200A (en) | 2014-12-15 | 2014-12-15 | Visual data display method and device based on data cubes |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410779622.9A CN104408200A (en) | 2014-12-15 | 2014-12-15 | Visual data display method and device based on data cubes |
Publications (1)
Publication Number | Publication Date |
---|---|
CN104408200A true CN104408200A (en) | 2015-03-11 |
Family
ID=52645831
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410779622.9A Pending CN104408200A (en) | 2014-12-15 | 2014-12-15 | Visual data display method and device based on data cubes |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104408200A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107092701A (en) * | 2017-05-02 | 2017-08-25 | 山东浪潮通软信息科技有限公司 | The data processing method and device of a kind of Multidimensional Data Model |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20080221958A1 (en) * | 2007-03-07 | 2008-09-11 | Microsoft Corporation | Techniques to manage information for dynamic reports using time periods for a business model |
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 |
-
2014
- 2014-12-15 CN CN201410779622.9A patent/CN104408200A/en active Pending
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20080221958A1 (en) * | 2007-03-07 | 2008-09-11 | Microsoft Corporation | Techniques to manage information for dynamic reports using time periods for a business model |
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 (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107092701A (en) * | 2017-05-02 | 2017-08-25 | 山东浪潮通软信息科技有限公司 | The data processing method and device of a kind of Multidimensional Data Model |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107256265B (en) | A kind of search-engine results data visualization methods of exhibiting and system | |
US10817534B2 (en) | Systems and methods for interest-driven data visualization systems utilizing visualization image data and trellised visualizations | |
US9934299B2 (en) | Systems and methods for interest-driven data visualization systems utilizing visualization image data and trellised visualizations | |
CN101004750B (en) | Process for selecting objects in a PLM database and apparatus implementing this process | |
CN101017492A (en) | Process for displaying objects of a PLM database and apparatus implementing this process | |
CN101446952A (en) | 3d model retrieval method and system | |
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 | |
CN112416494B (en) | Virtual resource processing method and device, electronic equipment and storage medium | |
CN105447098A (en) | Information inquiring method and apparatus | |
CN116992887A (en) | Metadata data catalog processing method, device and processing equipment | |
Shan et al. | Interactive visual exploration of halos in large-scale cosmology simulation | |
CN104408184A (en) | Two-dimensional visual data display method and device based on data cubes | |
CN104408187A (en) | Visual data display method and device based on data cubes | |
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 | |
CN104462440A (en) | Data cube based two-dimensional visual data display method and device | |
KR102205267B1 (en) | 3D Visualization System and method for time series data | |
Song et al. | Development of a lightweight CAE middleware for CAE data exchange | |
CN111078782B (en) | Industrial big data visualization system and method | |
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 | |
CN104391997A (en) | Data cube based visual data display method and device | |
CN104462453A (en) | Data cube based visual data display method and device |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150311 |
|
RJ01 | Rejection of invention patent application after publication |