CN104408184A - Two-dimensional visual data display method and device based on data cubes - Google Patents

Two-dimensional visual data display method and device based on data cubes Download PDF

Info

Publication number
CN104408184A
CN104408184A CN201410779204.XA CN201410779204A CN104408184A CN 104408184 A CN104408184 A CN 104408184A CN 201410779204 A CN201410779204 A CN 201410779204A CN 104408184 A CN104408184 A CN 104408184A
Authority
CN
China
Prior art keywords
data
dimensional
database
cube
data cube
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
Application number
CN201410779204.XA
Other languages
Chinese (zh)
Inventor
黄佳嘉
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Gridsum Technology Co Ltd
Original Assignee
Beijing Gridsum Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Beijing Gridsum Technology Co Ltd filed Critical Beijing Gridsum Technology Co Ltd
Priority to CN201410779204.XA priority Critical patent/CN104408184A/en
Publication of CN104408184A publication Critical patent/CN104408184A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/248Presentation of query results
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2228Indexing structures
    • G06F16/2264Multidimensional index structures

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention provides a two-dimensional visual data display method and device based on data cubes. The two-dimensional 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 includes data of data units corresponding to the three-dimensional data cubes required to be looked up, and displaying the query result through a virtual two-dimensional model to generate a two-dimensional display image, wherein data structures defined by the data units in the database are identical, structural data corresponding to a database structure of the database are null, and the same data structures are identical in structure attribute and have a recursive call characteristic. The problem of limited display of infinite values is solved by means of the two-dimensional visual data display method and device based on the data cubes.

Description

Based on two-dimentional display packing and the device of the visualized data of data cube
Technical field
The present invention relates to data processing field, in particular to a kind of two-dimentional display packing and device of the visualized data based on data cube.
Background technology
Data cube (Data Cube) is a kind of Technical Architecture for data analysis and index, and it is the process sharp weapon for large data (big data), can carry out any multiple key real time indexing to metadata.After by data cube metadata being analyzed, greatly can accelerate the retrieval and indexing efficiency of data.Data cube outmatches on data storage layer and Database Systems, after being resolved by data cube, greatly can increase the speed of the business such as data query and retrieval, system platform can be allowed to possess advantages such as data are put in storage in real time, real-time query, Query Result real-time Transmission.
Because the model of data cube is more abstract, the reading comparison of data after extraction is difficult and understand, and data are after extraction simultaneously, and the numerical value of data is not identical.In the problem of the combination of abstract unlimited numerical value, fixed numbers, need the limited showing problem solving unlimited numerical value, need the availability of adding users, intelligibility simultaneously, readable, and keep good Consumer's Experience.
For the problem of the limited displaying of numerical value unlimited in prior art, at present effective solution is not yet proposed.
Summary of the invention
Fundamental purpose of the present invention is the two-dimentional display packing and the device that provide a kind of visualized data based on data cube, to solve the problem of the limited displaying of unlimited numerical value.
To achieve these goals, according to an aspect of the embodiment of the present invention, provide a kind of two-dimentional display packing of the visualized data based on data cube.Two-dimentional display packing according to the visualized data based on data cube of the present invention comprises: receive query statement; From three-dimensional data cube set, the three-dimensional data cube needing to check is read according to query statement, obtain and need the dimension of the three-dimensional data cube checked and estimate, wherein, the three-dimensional data cube set comprising at least one three-dimensional data cube is pre-created, further, in pre-defined three-dimensional data cube for the dimension of locator data unit, for defining estimating and dimension and the corresponding relation between estimating of data cell; The dimension of the three-dimensional data cube checked as required and estimating is inquired about from database, obtains the Query Result that database returns, and Query Result comprises the data of data cell corresponding to three-dimensional data cube that needs check; Query Result is shown by virtual two-dimensional display model, generates two-dimensional display image; Wherein, each data structure defined in each data cell in database is same data structure, and the structured data corresponding to wide area information server structure is empty, and wherein, the structure attribute of same data structure is identical, and has 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 two-dimensional device of the visualized data based on data cube.Two-dimensional device according to the visualized data based on data cube of the present invention comprises: receiver module, for receiving query statement; Acquisition module, for reading the three-dimensional data cube needing to check from three-dimensional data cube set according to query statement, obtain and need the dimension of the three-dimensional data cube checked and estimate, wherein, the three-dimensional data cube set comprising at least one three-dimensional data cube is pre-created, further, in pre-defined three-dimensional data cube for the dimension of locator data unit, for defining estimating and dimension and the corresponding relation between estimating of data cell; Enquiry module, inquires about for the dimension of three-dimensional data cube of checking as required and estimating, obtains the Query Result that database returns from database, and Query Result comprises the data of data cell corresponding to three-dimensional data cube that needs check; Two dimension display module, for being shown by virtual two-dimensional display model by Query Result, generates two-dimensional display image; Wherein, each data structure defined in each data cell in database is same data structure, and the structured data corresponding to wide area information server structure is empty, and wherein, the structure attribute of same data structure is identical, and has the characteristic of recursive call.
According to inventive embodiments, by receiving query statement; From three-dimensional data cube set, the three-dimensional data cube needing to check is read according to query statement, obtain and need the dimension of the three-dimensional data cube checked and estimate, wherein, the three-dimensional data cube set comprising at least one three-dimensional data cube is pre-created, further, in pre-defined three-dimensional data cube for the dimension of locator data unit, for defining estimating and dimension and the corresponding relation between estimating of data cell; The dimension of the three-dimensional data cube checked as required and estimating is inquired about from database, obtains the Query Result that database returns, and Query Result comprises the data of data cell corresponding to three-dimensional data cube that needs check; Query Result is shown by virtual two-dimensional display model, generates two-dimensional display image; Wherein, each data structure defined in each data cell in database is same data structure, and the structured data corresponding to wide area information server structure is empty, and wherein, the structure attribute of same data structure is identical, and has the characteristic of recursive call.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 two-dimentional display packing of the visualized data based on data cube according to the embodiment of the present invention one;
Fig. 2 implements schematic diagram in detail according to the two-dimentional display packing of the visualized data based on data cube of the embodiment of the present invention one; And
Fig. 3 is the schematic diagram of the two-dimensional display of the visualized data based on data cube according to the embodiment of the present invention two.
Embodiment
It should be noted that, when not conflicting, the embodiment in the application and the feature in embodiment can combine mutually.Below with reference to the accompanying drawings and describe the present invention in detail in conjunction with the embodiments.
The present invention program is understood better in order to make those skilled in the art person, below in conjunction with the accompanying drawing in the embodiment of the present invention, technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is only the embodiment of a part of the present invention, instead of whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtained under creative work prerequisite, should 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 two-dimentional display packing of the visualized data based on data cube can be provided, it should be noted that, can perform in the computer system of such as one group of computer executable instructions in the step shown in the process flow diagram of accompanying drawing, and, although show logical order in flow charts, in some cases, can be different from the step shown or described by order execution herein.
Embodiments provide a kind of two-dimentional display packing of the visualized data based on data cube.
Fig. 1 is the process flow diagram of the two-dimentional display packing of the visualized data based on data cube according to the embodiment of the present invention one.As shown in Figure 1, it is as follows that the method comprising the steps of:
Step S103, receive query statement, this query statement can be inputted by user and obtain.
In above-mentioned steps S103, create the data cell in three-dimensional data cube dimension and after estimating, by the query statement providing an inputting interface to receive user's input, can be inquired about the specifying information obtaining user and need to inquire about by query statement.
Step S105, reads the three-dimensional data cube needing to check from three-dimensional data cube set according to query statement, obtain and need the dimension of the three-dimensional data cube checked and estimate.
In above-mentioned steps S105, after the query statement receiving user's input, corresponding three-dimensional data cube is read according to query statement, thus get user and need the dimension of the three-dimensional data cube checked and estimating, wherein getting the dimension of three-dimensional data cube and the query statement of user after estimating, can responded.
Preferably, before execution step S103, step S101 can be performed, create and comprise the three-dimensional data cube set of at least one three-dimensional data cube, in definition three-dimensional data cube for the dimension of locator data unit, for defining estimating and dimension and the corresponding relation between estimating of data cell.
In above-mentioned steps S101, by setting up virtual three-dimensional data cube, define the dimension of data cell and estimating of data cell, data cell is the combination of data structure or the data structure obtained due to demand, the combination of data structure or data structure is included among data cell, forms data cell.Wherein, the dimension of data cell can adopt the x-axis of data cell on Spatial Dimension and y-axis to locate, estimating of data cell can adopt the z-axis of data cell on Spatial Dimension to locate, by the dimension of data cell and the setting estimated, define the dimension of data cell and the corresponding relation between estimating.
Data cell in the application's above-mentioned steps can comprise polytype data structure as a kind of virtual container, and data structure can unrestricted choice, splits, calls, combination.Wherein, the realization flow of the minimum unit of information of composition data structure is generation information, transmission information and the information of reception.
It should be noted that herein, in the process creating three-dimensional data cube, in advance multidimensional data can be imported database, thus realize data importing data cube to carry out data processing.
Step S107, the dimension of the three-dimensional data cube checked as required and estimating is inquired about from database, obtains the Query Result that database returns, and Query Result comprises the data of data cell corresponding to three-dimensional data cube that needs check.
The data cell related in above-mentioned steps S107 is a kind of virtual module of virtual settings, due to various data structure can be comprised in " data cell ", Query Result can be the macroscopical scene be made up of micro-data, composition graphs 2 is known, data cell is the equal of the passage between micro-data and macroscopical scene, micro-data is the value of reality corresponding to data cell, and it is the elementary cell forming macroscopical scene, data cell can be changed on exhibition method, and data dimension can be counted as the dimension of more than 1.
Step S109, is shown Query Result by virtual two-dimensional display model, generates two-dimensional display image; Wherein, each data structure defined in each data cell in database is same data structure, and the structured data corresponding to wide area information server structure is empty, namely database 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 2d solid forming macroscopic view is considerable, can show by perception data.In order to meet existing equipment demand, three dimensions needs two dimensionization.The mode of projection is then used to carry out two-dimensional projections.
The 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.
A kind of preferred embodiment, what step S109 realized can comprise the steps: the scheme that described Query Result is undertaken showing by virtual two-dimensional display model
Step S1101, obtains showing paths of Query Result.
Step S1103, obtains the corresponding panorama sketch index that shows paths, and obtains two-dimentional display model according to panorama sketch index.
Step S1105, is presented in two-dimentional display model corresponding to panorama sketch index according to panorama sketch index by Query Result, obtains two-dimensional panoramic figure.
In the scheme that above-mentioned steps S1101 to step S1105 realizes, first showing paths of Query Result is obtained, then the corresponding panorama sketch index that shows paths is obtained, and obtain two-dimentional display model according to panorama sketch index, finally Query Result is presented in two-dimentional display model corresponding to panorama sketch index, to reach the object of acquisition two panorama sketch.
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 two-dimentional display model corresponding to panorama sketch index comprises:
Step S1091, is presented at x and estimates axle and y and estimate on the two-dimentional display plane that axle forms by the data cell of any two dimensions in three-dimensional data cube.
In above-mentioned steps S1091, x estimates axle, y estimates axle and has positioning function, not necessarily has the function forming structure; X estimates axle, y estimates the data cell that axle can obtain required for cross bearing one, thus the inner corresponding data structure of calling data unit and data value thereof.
" data cell " this virtual module due to virtual settings, and " data cell " has Fractals, such that data cell and x estimate axle, y estimates the object that axle locates and match.
Step S1092, projects the data cell that the z of being presented at virtual in three-dimensional data cube estimates axle on two-dimentional display plane.
In above-mentioned steps S1092, set virtual xyz virtual visual cubical time, what z estimated data structure virtual around axle and data cell estimates axle, and when two dimension display, visualized graphs z being estimated axle projects on two dimensional surface.Now, viewing area and xy estimate between axle does not have logic in data structure, has association descriptive.
It can thus be appreciated that, in the scheme that above-mentioned steps S1091 to step S1093 realizes, when two dimension display, visualized graphs z can being estimated axle projects on two dimensional surface, now, viewing area and xy estimate between axle does not have logic in data structure, has association descriptive; Existing equipment demand can be met like this, three dimensions two dimensionization, use the mode of projection to carry out two-dimensional projections particularly, finally reach in the two-dimensional space that hardware determines, can two-dimensional visualization be done.
It should be noted that herein, in above-mentioned preferred embodiment, the control that can be provided by display interface carries out following any one or multiple operation to the data cell of any one dimension: check data cell, Update Table unit, replacement data unit, deletes data cell; And/or the control provided by display interface carries out following any one or multiple operation to the data structure in the data cell of any one dimension: check data cell, Update Table structure, replacement data structure, delete data structure.
It can thus be appreciated that, the control that the application can be provided by display interface is changed data cell and data structure the amendment of the data cell of any one dimension and data structure, replacement and deletion action, flexibly to demonstrate the unlimited numerical value that user needs.
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: the image forming relevant " data structure " according to the data cell behind the location be drawn into, should " data structure " be fixing same data structure, 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.
Step 7: on the basis of virtual three-dimensional display, carries out a dimensionality reduction to data model, forms simple two-dimentional interface.
Concrete, in such scheme, " data structure " this latitude can be used as do not have latitude " point ", by the axle of other latitude carry out identical " data structure " and " data structure " carries out data visualization, formation content regions to identical in location.Wherein, the ways of presentation of fixing " data structure " and rule, change the numerical value of different extracted data.
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 two-dimensional display of the visualized data 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 two-dimentional display module 25.
Receiver module 22, for receiving query statement; Acquisition module 23, for reading the three-dimensional data cube needing to check from three-dimensional data cube set according to query statement, obtains and needs the dimension of the three-dimensional data cube checked and estimate; Enquiry module 24, inquires about for the dimension of three-dimensional data cube of checking as required and estimating, obtains the Query Result that database returns from database, and Query Result comprises the data of data cell corresponding to three-dimensional data cube that needs check; Two dimension display module 25, for being shown by virtual two-dimensional display model by Query Result, generates two-dimensional display image; Wherein, defining in each data cell each data structure defined in database is same data structure, and the structured data corresponding to wide area information server structure is empty, namely database structure is not defined, wherein, the structure attribute of identical data library structure is identical, and has the characteristic of recursive call.
Preferably, as shown in Figure 3, the device that the present embodiment provides can also comprise: creation module 21, for creating the three-dimensional data cube set comprising at least one three-dimensional data cube, in definition three-dimensional data cube for the dimension of locator data unit, for defining estimating and dimension and the corresponding relation between estimating of data cell.
A kind of preferred embodiment, said apparatus also comprises:
Build module, 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 two-dimentional display module also comprises:
First sub-acquisition module, for obtaining showing paths of Query Result;
Second sub-acquisition module, for obtaining the corresponding panorama sketch index that shows paths, and obtains two display models according to panorama sketch index;
3rd sub-acquisition module, for being presented in two-dimentional display model corresponding to panorama sketch index according to panorama sketch index by Query Result, obtains two-dimensional panoramic figure.
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, estimates axle and y and estimates for the data cell of any two dimensions in three-dimensional data cube being presented at x the two-dimentional display plane that axle forms;
Projection module, projects two-dimentional display plane for the data cell that the z of being presented at virtual in three-dimensional data cube is estimated axle.
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, for aforesaid each embodiment of the method, in order to simple description, therefore it is all expressed as a series of combination of actions, but those skilled in the art should know, the present invention is not by the restriction of described sequence of movement, because according to the present invention, some step can adopt other orders or carry out simultaneously.Secondly, those skilled in the art also should know, the embodiment described in instructions all belongs to preferred embodiment, and involved action and module might not be that the present invention is necessary.
In the above-described embodiments, 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 device, the mode by other realizes.Such as, 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 device or unit 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, mobile terminal, 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 foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.

Claims (13)

1., based on a two-dimentional display packing for the visualized data of data cube, it is characterized in that, comprising:
Receive query statement;
From described three-dimensional data cube set, the three-dimensional data cube needing to check is read according to described query statement, obtain the dimension of the three-dimensional data cube that described needs are checked and estimate, wherein, the described three-dimensional data cube set comprising at least one three-dimensional data cube is pre-created, further, in pre-defined described three-dimensional data cube for the dimension of locator data unit, for define described data cell estimate and described dimension and described estimate between corresponding relation;
The dimension of the three-dimensional data cube checked according to described needs and estimating is inquired about from database, obtains the Query Result that described database returns, and described Query Result comprises the data of data cell corresponding to three-dimensional data cube that described needs check;
Described Query Result is shown by virtual two-dimensional display model, generates two-dimensional display image;
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 is undertaken showing by virtual two-dimensional display model is comprised:
Obtain showing paths of described Query Result;
Show paths described in acquisition corresponding panorama sketch index, and obtain two-dimentional display model according to described panorama sketch index;
According to described panorama sketch index, described Query Result is presented in two-dimentional display model corresponding to described panorama sketch index, obtains two-dimensional panoramic figure.
6. method according to claim 5, it is characterized in that, described three-dimensional data cube comprises three dimensions, what each dimension correspondence one was estimated estimates axle, described three-dimensional data cube comprise following three estimate axle form described in show paths: x estimates axle, y estimates axle and z estimates axle, wherein, the step be presented at by described Query Result in two-dimentional display model corresponding to described panorama sketch index comprises:
The data cell of any two dimensions in described three-dimensional data cube is presented at described x to estimate axle and described y and estimate on the two-dimentional display plane that axle forms;
Be presented at the data cell that described z estimates axle project virtual in described three-dimensional data cube on described two-dimentional display plane.
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 two-dimensional display for the visualized data of 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;
Two dimension display module, for being shown by virtual two-dimensional display model by described Query Result, generates two-dimensional display image;
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.
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 same data structure and each same data structure, and according to demand independent assortment between described 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, and for 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, 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, 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 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 two-dimentional display module comprises:
First sub-acquisition module, for obtaining showing paths of described Query Result;
Second sub-acquisition module, for the corresponding panorama sketch index that shows paths described in obtaining, and obtains two-dimentional display model according to described panorama sketch index;
3rd sub-acquisition module, for being presented in two-dimentional display model corresponding to described panorama sketch index according to described panorama sketch index by described Query Result, obtains two-dimensional panoramic figure.
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, estimates axle and described y and estimates for the data cell of any two dimensions in described three-dimensional data cube being presented at described x the two-dimentional display plane that axle forms;
Projection module, for being presented at the data cell that described z estimates axle projecting described two-dimentional display plane by virtual in described three-dimensional data cube.
CN201410779204.XA 2014-12-15 2014-12-15 Two-dimensional visual data display method and device based on data cubes Pending CN104408184A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201410779204.XA CN104408184A (en) 2014-12-15 2014-12-15 Two-dimensional visual data display method and device based on data cubes

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201410779204.XA CN104408184A (en) 2014-12-15 2014-12-15 Two-dimensional visual data display method and device based on data cubes

Publications (1)

Publication Number Publication Date
CN104408184A true CN104408184A (en) 2015-03-11

Family

ID=52645815

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201410779204.XA Pending CN104408184A (en) 2014-12-15 2014-12-15 Two-dimensional visual data display method and device based on data cubes

Country Status (1)

Country Link
CN (1) CN104408184A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108205556A (en) * 2016-12-19 2018-06-26 北京普源精电科技有限公司 The display methods and display device of a kind of measurement data
CN110688539A (en) * 2019-09-30 2020-01-14 北京九章云极科技有限公司 Model management system and method

Citations (4)

* Cited by examiner, † Cited by third party
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

Patent Citations (4)

* Cited by examiner, † Cited by third party
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 (1)

* Cited by examiner, † Cited by third party
Title
SM JI ET AL.: ""A Study on the Generation of OLAP Data Cube Based on 3D Visualization Interaction"", 《INTERNATIONAL CONFERENCE ON COMPUTATIONAL SACIENCE & ITS APPLICATIONS》 *

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108205556A (en) * 2016-12-19 2018-06-26 北京普源精电科技有限公司 The display methods and display device of a kind of measurement data
CN110688539A (en) * 2019-09-30 2020-01-14 北京九章云极科技有限公司 Model management system and method
CN110688539B (en) * 2019-09-30 2020-08-14 北京九章云极科技有限公司 Model management system and method

Similar Documents

Publication Publication Date Title
CN107256265B (en) A kind of search-engine results data visualization methods of exhibiting and system
US20230084389A1 (en) System and method for providing bottom-up aggregation in a multidimensional database environment
CN101004750B (en) Process for selecting objects in a PLM database and apparatus implementing this process
US9934299B2 (en) Systems and methods for interest-driven data visualization systems utilizing visualization image data and trellised visualizations
CN101013425B (en) Process for selecting objects in a PLM database and apparatus implementing this process
JP5230095B2 (en) Processing for displaying an object in a PLM database and a device implementing this processing
WO2015060893A1 (en) Systems and methods for interest-driven data visualization systems utilizing visualization image data and trellised visualizations
JP7249144B2 (en) How to assemble product parts
CN112416494B (en) Virtual resource processing method and device, electronic equipment and storage medium
CN108073682A (en) Based on parameter view functional query database
CN105378797A (en) Three dimensional data visualization
CN102222088A (en) System and method for checking, summarizing and displaying data quality according to multidimensional attribute
CN116992887A (en) Metadata data catalog processing method, device and processing equipment
CN105447098A (en) Information inquiring method and apparatus
US9639587B2 (en) Social network analyzer
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
JP6947503B2 (en) Positioning of 3D objects using quantization
KR100989080B1 (en) Method and System for experiential knowledge associated with spatial and temporal information
Kim et al. Lifecycle management of component catalogs based on a neutral model to support seamless integration with plant 3D design
CN104408196A (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
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

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