CN104391997A - Data cube based visual data display method and device - Google Patents
Data cube based visual data display method and device Download PDFInfo
- Publication number
- CN104391997A CN104391997A CN201410779009.7A CN201410779009A CN104391997A CN 104391997 A CN104391997 A CN 104391997A CN 201410779009 A CN201410779009 A CN 201410779009A CN 104391997 A CN104391997 A CN 104391997A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- cube
- dimensional
- 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/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)
Abstract
The invention provides a data cube based visual data display method and device. The method comprises steps as follows: an inquiry instruction is received, a three-dimensional data cube required to be checked is read from a three-dimensional data cube set according to the inquiry instruction, dimensionality and measure of the three-dimensional data cube required to be checked are acquired, inquiry is performed from a database according to dimensionality and measure of the three-dimensional data cube required to be checked, an inquiry result comprises data of a corresponding data unit of the three-dimensional data cube required to be checked, the inquiry result returned by the database is acquired and displayed in a virtual three-dimensional manner, data structures defined in each data unit in the database are identical, and corresponding structured data of a database structure of the database are empty. By means of the method and the device, the problem of finite display of infinite numerical values is solved.
Description
Technical field
The present invention relates to data processing field, in particular to a kind of visualized data display packing based on data cube and device.
Background technology
Data cube (Data Cube) is a kind of Technical Architecture for data analysis and index, and it is the process sharp weapon for large data (big data), can carry out any multiple key real time indexing to metadata.After by data cube metadata being analyzed, greatly can accelerate the retrieval and indexing efficiency of data.Data cube outmatches on data storage layer and Database Systems, after being resolved by data cube, greatly can increase the speed of the business such as data query and retrieval, system platform can be allowed to possess advantages such as data are put in storage in real time, real-time query, Query Result real-time Transmission.
Because the model of data cube is more abstract, the reading comparison of data after extraction is difficult and understand, and data are after extraction simultaneously, and the numerical value of data is not identical.In the problem of the combination of abstract unlimited numerical value, fixed numbers, need the limited showing problem solving unlimited numerical value, need the availability of adding users, intelligibility simultaneously, readable, and keep good Consumer's Experience.
For the problem of the limited displaying of numerical value unlimited in prior art, at present effective solution is not yet proposed.
Summary of the invention
Fundamental purpose of the present invention is to provide a kind of visualized data display packing based on data cube and device, to solve the problem of the limited displaying of unlimited numerical value.
To achieve these goals, according to an aspect of the embodiment of the present invention, provide a kind of visualized data display packing based on data cube.Visualized data display packing based on data cube according to the present invention comprises: receive query statement, from three-dimensional data cube set, the three-dimensional data cube needing to check is read according to query statement, obtain and need the dimension of the three-dimensional data cube checked and estimate, the dimension of the three-dimensional data cube checked as required is inquired about from database with estimating, obtain the Query Result that database returns, 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, the each data structure defined in each data cell in database is same data structure, structured data corresponding to wide area information server structure is empty, wherein, the structure attribute of same data structure is identical, and there is the characteristic of recursive call.
To achieve these goals, according to the another aspect of the embodiment of the present invention, provide a kind of visualized data display device based on data cube.Visualized data display device based on data cube according to the present invention comprises: receiver module, for receiving query statement, acquisition module, for reading the three-dimensional data cube needing to check from three-dimensional data cube set according to query statement, obtain and need the dimension of the three-dimensional data cube checked and estimate, enquiry module, dimension for the three-dimensional data cube checked as required is inquired about from database with estimating, obtain the Query Result that database returns, Query Result comprises the data of data cell corresponding to three-dimensional data cube that needs check, 3-D display module, for Query Result is shown in the mode of virtual three-dimensional, wherein, the each data structure defined in each data cell in database is same data structure, structured data corresponding to wide area information server structure is empty, wherein, the structure attribute of same data structure is identical, and there is the characteristic of recursive call.
According to inventive embodiments, by the visualized data display packing based on data cube, 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, the each data structure defined in each data cell in database is same data structure, structured data corresponding to wide area information server structure is empty, namely wide area information server structure is not defined, wherein, the structure attribute of same data structure is identical, and has the characteristic of recursive call.
In above-mentioned steps S109, the data structure of above-mentioned different in kind all belongs to same data structure, same data structure has the identical characteristic of structure attribute, because Query Result has different nature and characteristics in macroscopic aspect, but there is identical data structure, now can continue to use same data structure, and set different nature and characteristics, to observe, and there is no impact, thus realize fixed data structure and do not fix exhibition method.Data display mode has duplicating property of logic, but visual effect can have more effect.
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.
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 same 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, before execution step S107, 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 same data structure and each same data structure, and according to demand independent assortment between each same 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 same data structure of independent assortment and each same data structure, and according to demand independent assortment between each same 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, wherein, each data cell defined in database is called by demand and is loaded same data structure.
In above-mentioned steps S1061, 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, set identical data structure on this basis, or directly import identical data structure, to use, such as, use in tree-shaped non-space-time structure.
A kind of preferred embodiment, before execution step S103, the method can also comprise step S1031:
Step S1031, according to demand configuration data scene, determine the three-dimensional data cube needing to check, data scene is the same 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 can be realized by following scheme: according to the combination of the determined same 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 same data structure, namely each data structure will continue to use identical data structure, but the nature and characteristic in data structure can define according to demand, then this data scene has changeability, but can do the implantation of same data structure, if data cell can be continued to use, continue to use, data cell cannot be continued to use, and does not continue to use.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, after execution step S101, 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 same 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, data structure is identical simultaneously, then can be in use in different data scenes and go, and forms the part forming macro-data.The application, after the combination determining new same 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 institute implementation 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 be expressed by 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 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, saves multiple data cell in database, and " data structure " that define data and the setting comprised in " data cell " is identical, 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; Form the image of relevant " data structure " according to the data cell behind the location be drawn into, should " data structure " be fixing same data structure, the numerical value of different extracted data can be changed according to ways of presentation and rule.
Step 6; The image got is shown in the mode of virtual three-dimensional, namely shows three dimensional rendered images.Preferably, can from the display module of " data structure ", direct replacement data 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.
Embodiment 2
According to the embodiment of the present invention, additionally provide a kind of for corresponding to the device implementing said method embodiment, in the configuration that it is the most basic, Fig. 3 is the schematic diagram of the visualized data display device based on data cube according to the embodiment of the present invention two.For purposes of illustration, the architecture of painting is only an example of proper environment, not proposes any limitation to the usable range of the application or function.This computing system should be interpreted as, to the arbitrary assembly shown in Fig. 1 or its combination, there is any dependence or demand yet.
As shown in Figure 3, following functional module can should be comprised based on the visualized data display device of data cube: receiver module 22, acquisition module 23, enquiry module 24,3-D display module 25.
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; 3-D display module 25, for showing Query Result in the mode of virtual three-dimensional; Wherein, defining in each data cell each data structure defined in database is same data structure, structured data corresponding to wide area information server structure is empty, namely wide area information server structure is not defined, wherein, the structure attribute of identical data library structure is identical, and has the characteristic of recursive call.
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, inquire about from database with estimating for the dimension at the three-dimensional data cube checked as required, before the Query Result that acquisition database returns, build database, database comprises multiple data cell, wherein, each data cell comprises: the structural relation between multiple same data structure and each same data structure, and according to demand independent assortment between each same data structure;
Database processing module, for the data cell of loading of databases definition, not loading of databases structure, wherein, each data cell defined in database is called by demand and is loaded same data structure.
A kind of preferred embodiment, said apparatus also comprises:
Determination module, for before the query statement receiving user's input, 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, enquiry module comprises: subquery module, and for the combination according to the determined same data structure of data scene, from database, inquiry obtains corresponding data cell.
A kind of preferred embodiment, said apparatus also comprises:
Definition module, after comprising the three-dimensional data cube set of at least one three-dimensional data cube in establishment, three-dimensional data cube in the set of definition three-dimensional data cube and the linking relationship of database, wherein, different data scenes is being configured according to demand, after determining the combination of new same 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 can comprise:
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.
A kind of preferred embodiment, above-mentioned three-dimensional data cube comprises three dimensions, and what each dimension correspondence one was estimated estimates axle, and 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 3rd sub-acquisition module comprises:
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 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 in the mode of virtual three-dimensional;
Wherein, the each data structure defined in each data cell in described database is same data structure, and the structured data corresponding to described wide area information server structure is empty, wherein, the structure attribute of described same data structure is identical, and has the characteristic of recursive call.
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, wherein, each described data cell comprises: the structural relation between multiple same data structure and each same data structure, and according to demand independent assortment between each same data structure;
Load the data cell of described database definition, not loading of databases structure, wherein, each data cell defined in described database is called by demand and is loaded described same data 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 same 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 same 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, different data scenes is being configured according to demand, after determining the combination of new same data structure, inquire 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 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, defining in each data cell each data structure defined in described database is same data structure, and the structured data corresponding to described wide area information server structure is empty, wherein, the structure attribute of described identical data library structure is identical, and has the characteristic of recursive call.
9. device according to claim 8, is characterized in that, described device also comprises:
Build module, inquire about from database with estimating for the dimension at the three-dimensional data cube checked according to described needs, before obtaining the Query Result that described database returns, build described database, described database comprises multiple data cell, wherein, each described data cell comprises: the structural relation between multiple same data structure and each same data structure, and according to demand independent assortment between each same data structure;
Database processing module, for loading the data cell of described database definition, not loading of databases structure, wherein, each data cell defined in described database is called by demand and is loaded described same data structure.
10. device according to claim 9, is characterized in that, described device also comprises:
Determination module, for before the query statement receiving user's input, configuration data scene according to demand, determines 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 same 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, after comprising the three-dimensional data cube set of at least one three-dimensional data cube in establishment, define 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 same 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 |
|---|---|---|---|
| CN201410779009.7A CN104391997A (en) | 2014-12-15 | 2014-12-15 | Data cube based visual data display method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410779009.7A CN104391997A (en) | 2014-12-15 | 2014-12-15 | Data cube based visual data display method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104391997A true CN104391997A (en) | 2015-03-04 |
Family
ID=52609901
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410779009.7A Pending CN104391997A (en) | 2014-12-15 | 2014-12-15 | Data cube based visual data display method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104391997A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107463661A (en) * | 2017-07-31 | 2017-12-12 | 小草数语（北京）科技有限公司 | The introduction method and device of data |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102509350A (en) * | 2011-09-30 | 2012-06-20 | 北京航空航天大学 | Cube-based sports event information visualization 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 CN201410779009.7A patent/CN104391997A/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 |
| CN102509350A (en) * | 2011-09-30 | 2012-06-20 | 北京航空航天大学 | Cube-based sports event information visualization 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 |
Non-Patent Citations (2)
| Title |
|---|
| SU MI JI ET AL: "A Study on the Generation of OLAP Data Cube Based on 3D Visualization Interaction", 《2011 INTERNATIONAL CONFERENCE ON COMPUTATIONAL SCIENCE AND ITS APPLICATIONS》 * |
| 陈磊等: "基于Cube的数据展现结构的研究", 《计算机工程与设计》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107463661A (en) * | 2017-07-31 | 2017-12-12 | 小草数语（北京）科技有限公司 | The introduction method and device of data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107256265B (en) | A kind of search-engine results data visualization methods of exhibiting and system | |
| CN101004750B (en) | Process for selecting objects in a PLM database and apparatus implementing this process | |
| US20190005104A1 (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 | |
| JP5230095B2 (en) | Processing for displaying an object in a PLM database and a device implementing this processing | |
| WO2017186774A1 (en) | Systems and methods for querying databases | |
| CN105378797A (en) | Three dimensional data visualization | |
| CN108073682A (en) | Based on parameter view functional query database | |
| CN112416494B (en) | Virtual resource processing method and device, electronic equipment and storage medium | |
| US20150205840A1 (en) | Dynamic Data Analytics in Multi-Dimensional Environments | |
| CN116992887A (en) | Metadata data catalog processing method, device and processing equipment | |
| CN105447098A (en) | Information inquiring method and apparatus | |
| Wawrzynek et al. | An edge-based data structure for two-dimensional finite element analysis | |
| 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 | |
| CN104391997A (en) | Data cube based visual data display method and device | |
| CN104408200A (en) | Visual data display method and device based on data cubes | |
| CN104408186A (en) | Two-dimensional visual data display method and device based on data cubes | |
| CN104462453A (en) | Data cube based visual data display method and device | |
| Li et al. | Efficient data modeling and querying system for multi-dimensional spatial data |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150304 |