CN109189777A - A kind of method, device and equipment stored and inquire multidimensional information - Google Patents
A kind of method, device and equipment stored and inquire multidimensional information Download PDFInfo
- Publication number
- CN109189777A CN109189777A CN201810689230.1A CN201810689230A CN109189777A CN 109189777 A CN109189777 A CN 109189777A CN 201810689230 A CN201810689230 A CN 201810689230A CN 109189777 A CN109189777 A CN 109189777A
- Authority
- CN
- China
- Prior art keywords
- dimensional characteristics
- querying condition
- value
- multidimensional information
- storage
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
This application discloses a kind of storage and the methods of inquiry multidimensional information, of the existing technology may cause the lower storage for not being able to satisfy user for multidimensional information of search efficiency and query demand to solve the problem of.Method includes: to obtain each dimensional characteristics and corresponding dimensional characteristics value of multidimensional information to be stored, in the way of arranging storage, stores to each dimensional characteristics and corresponding dimensional characteristics value, obtains the first table of multidimensional information；Obtain querying condition, the querying condition, including at least dimensional characteristics to be checked；In the way of arranging storage, the querying condition is stored, querying condition table is obtained；By way of comparing querying condition table and the first table of the multidimensional information, the query result for meeting the querying condition is obtained.Disclosed herein as well is a kind of storage and the devices and equipment of inquiry multidimensional information.
Description
Technical field
This application involves computer software technical field more particularly to a kind of storage and method, the dresses of inquiry multidimensional information
It sets, equipment and computer readable storage medium.
Background technique
With the arrival in information explosion epoch, the storage of information and the valued degree of inquiry business are growing day by day, and with
The dimensional characteristics of information be continuously increased, the storage of multidimensional information and inquiry difficulty also constantly rise, how could efficient storage
Become multi-party focus of attention with inquiry multidimensional information." multidimensional information " mentioned here, which refers to, contains at least two dimensional characteristics
Information.For example, the information can have name, age, hobby, affiliated region by taking " personal information of user " as an example
Etc. dimensional characteristics.To which the information is exactly a kind of multidimensional information.
In order to improve search efficiency, existing relationship type information storage and inquiry system are special based on fixed several dimensions
Sign, constructs different multidimensional information storage tables respectively, to realize quick search based on the lesser table of data volume.For example, can be with
Two dimensional characteristics of name and age based on user described above construct multidimensional information storage table 1, which uses for storing
The name and the value at age (i.e. dimensional characteristics value) at family；In addition, hobby, affiliated region based on user construct multidimensional information
Storage table 2, the table 2 are used to store the value of the hobby of user, affiliated region.
Based on the above-mentioned prior art, causing can only be according to the several dimensional characteristics fixed when constructing multidimensional information storage table
Carry out the inquiry of multidimensional information.This mode has problems in that: single beyond certain is constructed in the dimensional characteristics of expectation inquiry
In the case where the several dimensional characteristics fixed when multidimensional information storage table, it can only go again in other multidimensional information storage table,
Inquiry can not complete inquiry in the single multidimensional information storage table, so that efficiency is lower, not be able to satisfy user for multidimensional
The query demand that information is efficiently inquired.
Summary of the invention
The embodiment of the present application provide it is a kind of storage and inquiry multidimensional information method, to solve it is of the existing technology can
The problem of search efficiency can be caused lower, be not able to satisfy storage and query demand of the user for multidimensional information.
The embodiment of the present application also provides a kind of device and equipment stored and inquire multidimensional information, to solve the prior art
It is existing to may cause that search efficiency is lower, the problem of not being able to satisfy storage and query demand of the user for multidimensional information.
The embodiment of the present application also provides a kind of computer readable storage medium, of the existing technology may lead to solve
The problem of causing search efficiency lower, not being able to satisfy storage and query demand of the user for multidimensional information.
The embodiment of the present application adopts the following technical solutions:
In a first aspect, proposing a kind of method stored and inquire multidimensional information, comprising:
Each dimensional characteristics and corresponding dimensional characteristics value for obtaining multidimensional information to be stored, in the way of arranging storage,
Each dimensional characteristics and corresponding dimensional characteristics value are stored, the first table of multidimensional information is obtained；
Obtain querying condition, the querying condition, including at least dimensional characteristics to be checked；
In the way of arranging storage, the querying condition is stored, querying condition table is obtained；
By way of comparing querying condition table and the first table of the multidimensional information, obtain meeting looking into for the querying condition
Ask result.
Second aspect proposes a kind of device multidimensional information storage and inquired, comprising:
Multidimensional information storage unit obtains each dimensional characteristics and corresponding dimensional characteristics value of multidimensional information to be stored,
In the way of arranging storage, each dimensional characteristics and corresponding dimensional characteristics value are stored, multidimensional information first is obtained
Table；
Querying condition acquiring unit obtains querying condition, the querying condition, including at least dimensional characteristics to be checked；
Querying condition storage unit stores the querying condition, obtains querying condition in the way of arranging storage
Table；
Query unit, by way of comparing querying condition table and the first table of the multidimensional information, met described in look into
The query result of inquiry condition.
The third aspect proposes a kind of storage and inquiry multidimensional information equipment, comprising: memory, processor and be stored in
On the memory and the computer program that can run on the processor, the computer program are executed by the processor
The step of for example above-mentioned multidimensional information storage of Shi Shixian and querying method.
Fourth aspect, proposes a kind of computer readable storage medium, and the computer-readable recording medium storage has one
A or multiple programs, one or more of programs can be executed by one or more processor, to realize as above-mentioned more
The step of tieing up information storage and querying method.
As can be seen from the technical scheme provided by the above embodiments of the present application, the embodiment of the present application scheme at least has following one kind
Technical effect:
The side of storage is arranged by the dimensional characteristics that can be included to multidimensional information and querying condition and dimensional characteristics value
Formula is stored, and obtains query result by way of comparing querying condition table and multidimensional information table, has benefited from column storage
Relationship type storage characteristics, can store all dimensional characteristics and dimensional characteristics value of multidimensional information with a big table, and then support
The part for being included to multidimensional information/whole dimensional characteristics are combined inquiry, effectively increase the search efficiency of multidimensional information.
Detailed description of the invention
In order to illustrate the technical solutions in the embodiments of the present application or in the prior art more clearly, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
The some embodiments recorded in application, for those of ordinary skill in the art, in the premise of not making the creative labor property
Under, it is also possible to obtain other drawings based on these drawings.
Fig. 1 is the method idiographic flow schematic diagram of a kind of storage provided by the embodiments of the present application and inquiry multidimensional information；
Fig. 2 is that a kind of multidimensional information first provided by the embodiments of the present application indicates to be intended to；
Fig. 3 is that another multidimensional information first provided by the embodiments of the present application indicates to be intended to；
Fig. 4 is that a kind of querying condition provided by the embodiments of the present application indicates to be intended to；
Fig. 5 is a kind of process schematic inquired based on the second table of multidimensional information provided by the embodiments of the present application；
Fig. 6 is a kind of storage that the embodiment of the present invention provides and the specific structure signal for the device for inquiring multidimensional information
Figure；
Fig. 7 is a kind of storage that the embodiment of the present invention provides and the specific structure signal for the equipment for inquiring multidimensional information
Figure.
Specific embodiment
In order to make those skilled in the art better understand the technical solutions in the application, below in conjunction with the application reality
The attached drawing in example is applied, the technical scheme in the embodiment of the application is clearly and completely described, it is clear that described implementation
Example is merely a part but not all of the embodiments of the present application.Based on the embodiment in the application, this field is common
The application protection all should belong in technical staff's every other embodiment obtained without creative efforts
Range.
Embodiment 1
For solve it is of the existing technology may cause that search efficiency is lower, be not able to satisfy user's depositing for multidimensional information
The problem of storage and query demand, the embodiment of the present application provide a kind of method stored and inquire multidimensional information.
The executing subject of the method for storage and inquiry multidimensional information provided by the embodiments of the present application can be server, example
Such as, the server of information portal website, the server of news portal website, server of shopping website, etc..Certainly, this hair
This method that bright embodiment provides can also be by the other equipment in addition to server as executing subject, and the executing subject is simultaneously
The restriction to the application is not constituted, and for ease of description, the embodiment of the present application is the server of social network sites with executing subject
For be illustrated.
The specific implementation flow schematic diagram of this method is as shown in Figure 1, the specific implementation of this method mainly includes the following steps:
Step 11: obtaining each dimensional characteristics and corresponding dimensional characteristics value of multidimensional information to be stored, stored according to column
Mode, each dimensional characteristics and corresponding dimensional characteristics value are stored, the first table of multidimensional information is obtained.
The dimensional characteristics value refers to the specific value of dimensional characteristics.For example, the multidimensional information of passage form, tool
Hold in vivo as follows: " name: the age: Zhang 18 years old, hobby: sings ", the dimensional characteristics that this section of multidimensional information has are
" name ", " age ", " hobby ", dimensional characteristics value corresponding with " name " are " Zhangs ", and dimension corresponding with " age " is special
Value indicative is " 18 years old ", and dimension values corresponding with " hobby " are " singings ".
In one embodiment, got in the step 11 " each dimensional characteristics of multidimensional information to be stored and
The concrete form of corresponding dimensional characteristics value " can be the form of " dimensional characteristics-dimensional characteristics value ".For example, get " to
Each dimensional characteristics of the multidimensional information of storage and corresponding dimensional characteristics value " includes: " name-Zhang ", " gender-male ", " love
Good-singing ", " hobby-dancing ", " hobby-reading ".
The column storage, refers to when carrying out multidimensional information storage, is carried out by column, i.e., is stored again with first having stored a column
The form of next column is stored.
First table of multidimensional information is arranged comprising more than one dimensional characteristics, wherein the dimensional characteristics are arranged according to column
The mode of storage stores dimensional characteristics value corresponding with the dimensional characteristics.
As shown in Fig. 2, being a kind of concrete form of first table of multidimensional information.Multidimensional information first as shown in Figure 2
Table includes 3 dimensional characteristics column, be respectively used to storage dimensional characteristics name, the age, hobby dimensional characteristics value.
Multidimensional information table as shown in Figure 2 contains three multidimensional information, respectively describe belong to name be " Zhang ",
The age of the natural person of " Mr. Li " and " Mr. Wang " and hobby.For example, as shown in Figure 2, name is the natural person of Zhang
Age is 18 years old, is liked for sing and dance and reading.
In one embodiment, first table of multidimensional information is constituted by being worth for 1 or 0 dimensional characteristics value；For 1 dimension
Degree characteristic value is virtual value, shows that things described in the dimensional characteristics value has the dimensional characteristics；For 0 dimensional characteristics
Value is invalid value, shows that things described in the dimensional characteristics value does not have the dimensional characteristics.
As shown in figure 3, being another avatar of first table of multidimensional information, multidimensional information first as shown in the figure
Table includes 9 dimensional characteristics column, and dimensional characteristics, which arrange described feature, is respectively: name-Zhang, name-Mr. Li, surname
Name-Mr. Wang, gender-male, gender-female, hobby-singing, hobby-dancing, hobby-reading.
Multidimensional information table as shown in Figure 3 contains three groups of multidimensional information, respectively describe belong to name be " Zhang ",
The age of the natural person of " Mr. Li " and " Mr. Wang " and hobby.Such as: dimensional characteristics arrange in " name-Zhang ", the first row
Dimensional characteristics value be 1, illustrate information described in the first row belong to name be " Zhang " natural person, and so on, such as
Information described in the first table of multidimensional information the first row shown in Fig. 3 is: the natural person of entitled Zhang, and the age is 18 years old, love
It is well sing and dance and reading.
It is described to obtain the first table of multidimensional information, it include but is not limited to be with by each dimension of the multidimensional information to be stored
Feature and corresponding dimensional characteristics value are automatically imported the mode in table by server, obtain first table of multidimensional information.
It should be noted that multidimensional information first described in Fig. 2 and Fig. 3 indicates described by multidimensional information included in example
Be natural person dimensional characteristics, in practical applications, the multidimensional information for describing other things can the multidimensional information
The form of one table is stored, and no longer citing repeats herein.
By executing step 11, multidimensional information is stored as to first table of multidimensional information in the form of arranging storage, is realized
One table includes all dimensional characteristics of the multidimensional information and corresponding dimensional characteristics value, to support subsequent to any dimension
Feature and corresponding dimensional characteristics are worth combination to be inquired.
Step 12: obtaining querying condition, the querying condition includes at least dimensional characteristics to be checked；
The inquiry includes but is not limited to be in response in " obtaining first table of multidimensional information includes part/whole dimensions
The request of degree feature and corresponding dimensional characteristics value ", the inquiry that first table of multidimensional information is carried out.
It in one embodiment, may include the dimensional characteristics of expectation inquiry in the querying condition, the expectation is looked into
The dimensional characteristics of the inquiry, that is, dimensional characteristics to be checked.
In another embodiment, the querying condition further includes the value of dimensional characteristics to be checked.
For example, being directed to the first table of multidimensional information as shown in Figure 3, one section of querying condition is obtained, it is specific as follows: inquiry hobby
Whom people for " dancing " is respectively.Then this section of querying condition includes: dimensional characteristics to be checked " hobby-dancing ", and, it is to be checked
The value " 1 " of the dimensional characteristics of inquiry.
Step 13: in the way of arranging storage, the querying condition being stored, querying condition table is obtained；
In one embodiment, the specific embodiment of step 13 may include:
The value of dimensional characteristics to be checked and dimensional characteristics according to included by the querying condition, according to by the dimension
The value of feature as the virtual value in querying condition table mode and it is described column storage mode, to the querying condition into
Row storage, obtains querying condition table.
In the querying condition table, the quantity of the dimensional characteristics value corresponding to same dimensional characteristics to be checked is and described
The quantity of the corresponding dimensional characteristics value of each dimensional characteristics described in step 11 is identical.Wherein, in the querying condition table
The dimensional characteristics to be checked value be virtual value, other dimensional characteristics values be invalid value.It is described to improve search efficiency
Virtual value can be set to 1, and the invalid value can be set to 0.
For example, being directed to the first table of multidimensional information as shown in Figure 3, one section of querying condition is obtained, it is specific as follows: to like and be
Whom the people of " dancing " is respectively.Then to the value of dimensional characteristics and dimensional characteristics to be checked included in the querying condition with
The mode of column storage is stored, and querying condition table shown in Fig. 4 is obtained, it is found that " love from querying condition table shown in Fig. 4
Dimensional characteristics value in good-singing ", " hobby-reading " two dimensional characteristics column is fixed as 0, it is meant that one section of inquiry
Condition has excluded " hobby-singing ", " hobby-reading " the two dimensional characteristics, and the dimensional characteristics to be inquired are " hobby-jump
Dance ".
By executing step 13, the dimensional characteristics value in the querying condition table is limited to the virtual value represented with 1 and 0
And invalid value, it is effectively simplified querying condition table content, and then save memory space, while supporting subsequent based on the inquiry
Condition table carries out mutually improving search efficiency by using the operation mode of suitable machine arithmetic with operation or XOR operation.
Step 14: by way of comparing querying condition table and the first table of the multidimensional information, obtaining meeting the inquiry
The query result of condition.
The comparison, including but not limited to the dimension on corresponding position on the first table of querying condition table and the multidimensional information
It spends characteristic value and carries out operation, query result is obtained according to operation result, the operation rule can be phase and operation.
In one embodiment, the specific embodiment of step 14 may include:
In order to improve search efficiency, by the first table of the comparison querying condition table and multidimensional information, it is converted into comparison inquiry
Condition table and the second table of querying condition generated based on the first table of querying condition.
Second table of multidimensional information is constituted by being worth for 1 or 0 dimensional characteristics value；It is virtual value for 1 dimensional characteristics value；
It is invalid value for 0 dimensional characteristics value.
By the dimension dimension on the corresponding position of the second table of dimensional characteristics value and multidimensional information in the querying condition table
Value carries out phase and operation, obtains the query result.
When the dimensional characteristics value that first table of multidimensional information is included is by being worth the dimensional characteristics value for 1 or 0, i.e. step 11
When the virtual value and invalid value form, second table of multidimensional information is identical as affiliated mostly the first table of information；When described
When the first table of multidimensional information is not made of 1 or 0 dimensional characteristics value, the so-called letter is generated based on first table of multidimensional information
Cease the second table, wherein the concrete form of the second table of multidimensional information storage information is the shape of " dimensional characteristics-dimensional characteristics value "
Formula.
For example, multidimensional information second can be generated as follows based on the first table of multidimensional information as shown in Figure 2
Table:
" surname is obtained based on the first table of multidimensional information as shown in Figure 2 according to the form of " dimensional characteristics-dimensional characteristics value "
Name-Zhang ", " name-Mr. Li " " name-Mr. Wang ", " -18 years old ages ", " -19 years old ages ", " -20 years old ages ", " love
Good-singing ", " hobby-dancing ", " hobby-reading " 9 dimensional characteristics；
Based on 9 dimensional characteristics, again to arrange the form of storage to the first table of multidimensional information as shown in Figure 2
It is stored, obtains form and the second table of multidimensional information as shown in Figure 3, as shown in figure 3, the dimension in the second table of multidimensional information
Characteristic value is made of 1 or 0；It is virtual value for 1 dimensional characteristics value；It is invalid value for 0 dimensional characteristics value.
The phase and operation, specific rules are as follows: when the dimensional characteristics value and the multidimensional information in the querying condition table
When dimension dimension values on the corresponding position of second table are 1, operation result is 1；Dimension in the querying condition table
When dimension dimension values on the corresponding position of the second table of characteristic value and the multidimensional information are not 1, operation result is 0.
For example, carrying out inquiring the querying condition for the first table of multidimensional information as shown in Figure 2 specifically: inquiry, which is liked, is
Whom the people of " dancing " is respectively.
To realize inquiry, firstly, obtaining such as form and shown in Fig. 3 more according to the first table of multidimensional information as shown in Figure 2
Consistent the second table of multidimensional information of the first table of information is tieed up, obtains inquiry item as shown in Figure 4 further according to one section of querying condition
Part table.
Based on the first table of querying condition table and multidimensional information, specific query process is as shown in Figure 5.
As shown in figure 5, to the dimensional characteristics value on second table of multidimensional information and querying condition table first row the first row
It doing mutually and operation, the dimensional characteristics value of second table of multidimensional information on the position is 1, querying condition table is 0 in this position,
0 is then calculated in this position in query result.And so on, operation is carried out to the dimensional characteristics value in other positions, is obtained
Query result as shown in Figure 5.
In one embodiment, the specific embodiment of step 14 may include: required by the querying condition
When query result is the intersection of multiple dimensional characteristics, first in the multidimensional information table on more than one single dimensional characteristics column
It is inquired, then the intermediate result on single dimensional characteristics column is taken into intersection according to the rule of phase and operation, that is, do phase and operation,
Obtain query result required by the inquiry request.
Such as: for the second table of multidimensional information as shown in Figure 3, receive querying condition are as follows: inquiry dimensional characteristics " hobby-
People corresponding to singing " and the intersection of " hobby-dancing ", generating querying condition respectively is " hobby-singing " and " hobby-dancing "
Querying condition table, the querying condition table is done with the table of multidimensional information second shown in Fig. 3 respectively mutually and operation, respectively " love
It is good-to sing " and " hobby-dancing " dimensional characteristics column on obtain " hobby the man who loves to singing is Zhang, Mr. Li, Mr. Wang " and
" artificial Zhang, the Mr. Li of hobby dancing " two is as a result, be " intermediate result ", then two intermediate results are done again
Phase and operation, obtain query result.According to query result, the intersection of dimensional characteristics " hobby-singing " and " hobby-dancing "
Corresponding artificial Zhang, Mr. Li.
In another embodiment, the specific embodiment of step 13 may include: required by the inquiry request
Result when being the intersection of multiple dimensional characteristics, first more than one single dimensional characteristics column are enterprising in the multidimensional information table
Row inquiry, then the intermediate result on all single dimensional characteristics column is taken into intersection, that is, XOR operation is done, the inquiry request is obtained
Required query result.
Such as: for the second table of multidimensional information as shown in Figure 3, receive querying condition are as follows: inquiry dimensional characteristics " hobby-
People corresponding to singing " and the intersection of " hobby-dancing ", generating querying condition respectively is " hobby-singing " and " hobby-dancing "
Querying condition table, the querying condition table is done with the table of multidimensional information second shown in Fig. 3 respectively mutually and operation, respectively " love
It is good-to sing " and " hobby-dancing " dimensional characteristics column on obtain " hobby the man who loves to singing is Zhang, Mr. Li, Mr. Wang " and
" artificial Zhang, the Mr. Li of hobby dancing " two is as a result, be " intermediate result ", then two intermediate results are done exclusive or
Operation obtains query result.According to query result, the intersection institute of dimensional characteristics " hobby-singing " and " hobby-dancing " is right
Artificial Zhang, Mr. Li and the Mr. Wang answered.
In one embodiment, the specific embodiment of step 14 may is that the avatar of the query result is
Meet the Visual Chart of the querying condition.
The Visual Chart, include but is not limited to be at least one dimensional characteristics for including based on the query result and
Line chart, histogram, the sector diagram etc. that corresponding dimension values are drawn.
The method provided using the embodiment of the present application 1, by the dimension that can included to multidimensional information and querying condition
Feature and dimensional characteristics value are stored in a manner of arranging storage, and by way of comparing querying condition table and multidimensional information table
Query result is obtained, the relationship type storage characteristics of column storage is had benefited from, all dimensions of multidimensional information can be stored with a big table
Feature and dimensional characteristics value are spent, and then the part/whole dimensional characteristics for being included to multidimensional information is supported to be combined inquiry, is had
Effect improves the search efficiency of multidimensional information.
Embodiment 2
For solve it is of the existing technology may cause that search efficiency is lower, be not able to satisfy user's depositing for multidimensional information
The problem of storage and query demand, the embodiment of the present application provide a kind of device 60 stored and inquire multidimensional information.The tool of the device
Body structural schematic diagram is as shown in fig. 6, include multidimensional information storage unit 61, querying condition acquiring unit 62, querying condition storage
Unit 63, query unit 64.
Wherein, multidimensional information storage unit 61, for obtaining each dimensional characteristics of multidimensional information to be stored and corresponding
Dimensional characteristics value stores each dimensional characteristics and corresponding dimensional characteristics value, obtains more in the way of arranging storage
Tie up the first table of information；
Querying condition acquiring unit 62, for obtaining querying condition, the querying condition, including at least dimension to be checked
Feature；
Querying condition storage unit 63 stores the querying condition in the way of arranging storage, obtains inquiry item
Part table；
Query unit 64, for being met by way of comparing querying condition table and the first table of the multidimensional information
The query result of the querying condition.
In one embodiment, multidimensional information storage unit 61, for obtaining the first table of multidimensional information, the multidimensional letter
The first table is ceased, is arranged comprising more than one dimensional characteristics, wherein the dimensional characteristics arrange in the way of arranging storage, storage and institute
State the corresponding dimensional characteristics value of dimensional characteristics.
In one embodiment, querying condition acquiring unit 62, for obtaining querying condition, the querying condition is gone back
Value including dimensional characteristics to be checked；
In one embodiment, querying condition storage unit 63, for by arrange storage in the way of, to the inquiry item
Part is stored, and is obtained querying condition table, is specifically included:
The value of dimensional characteristics to be checked and dimensional characteristics according to included by the querying condition, according to by the dimension
The value of feature as the virtual value in querying condition table mode and it is described column storage mode, to the querying condition into
Row storage, obtains querying condition table.
In one embodiment, the query unit 64, for by comparing querying condition table and the multidimensional information
The mode of first table obtains the query result for meeting the querying condition.
In the querying condition table, the quantity of the dimensional characteristics value corresponding to same dimensional characteristics to be checked is and described
The quantity of the corresponding dimensional characteristics value of each dimensional characteristics is identical；Wherein, described to be checked in the querying condition table
The value of dimensional characteristics is virtual value, other dimensional characteristics values are invalid value；The virtual value is 1, and the invalid value is 0；
In one embodiment, the query unit 64, for by comparing querying condition table and the multidimensional information
The mode of first table obtains the query result for meeting the querying condition, specifically includes:
By the dimension dimension on the corresponding position of the second table of dimensional characteristics value and multidimensional information in the querying condition table
Value carries out phase and operation, obtains the query result；
Wherein, second table of multidimensional information is identical as first table of multidimensional information；Alternatively, the multidimensional information second
Table is generated based on first table of multidimensional information；
Second table of multidimensional information is constituted by being worth for 1 or 0 dimensional characteristics value；It is virtual value for 1 dimensional characteristics value；
It is invalid value for 0 dimensional characteristics value.
The device provided using the embodiment of the present application 2, by the dimension that can included to multidimensional information and querying condition
Feature and dimensional characteristics value are stored in a manner of arranging storage, and by way of comparing querying condition table and multidimensional information table
Query result is obtained, the relationship type storage characteristics of column storage is had benefited from, all dimensions of multidimensional information can be stored with a big table
Feature and dimensional characteristics value are spent, and then the part/whole dimensional characteristics for being included to multidimensional information is supported to be combined inquiry, is had
Effect improves the search efficiency of multidimensional information.
Embodiment 3
For solve it is of the existing technology may cause that search efficiency is lower, be not able to satisfy user's depositing for multidimensional information
The problem of storage and query demand, the embodiment of the present invention 3 provide a kind of equipment stored and inquire multidimensional information.
Fig. 7 a kind of storage of each embodiment and hardware configuration signal for the equipment for inquiring multidimensional information to realize the present invention
Figure, which includes but is not limited to: processor 71, memory 72, input unit 73, output unit 74 and power supply 75 etc.
Component, wherein processor 71 includes but is not limited to: receiving unit 711, query unit 712, memory 72 includes but is not limited to:
Storage unit 721, it will be understood by those skilled in the art that the storage of multidimensional information shown in Fig. 7 and query facility structure are not
Constitute to multidimensional data storage and query facility restriction, multidimensional data storage and query facility may include than illustrate it is more or
Less component perhaps combines certain components or different component layouts.In embodiments of the present invention, multidimensional data stores
And query facility includes but is not limited to server etc..
Wherein, receiving unit 711, for obtaining querying condition, the querying condition is special including at least dimension to be checked
Sign；
Query unit 712, for being met by way of comparing querying condition table and the first table of the multidimensional information
The query result of the querying condition；
Storage unit 721 is pressed for obtaining each dimensional characteristics and corresponding dimensional characteristics value of multidimensional information to be stored
According to the mode of column storage, each dimensional characteristics and corresponding dimensional characteristics value are stored, the first table of multidimensional information is obtained；
In the way of arranging storage, the querying condition got to querying condition acquiring unit 711 is stored, and obtains querying condition
Table；
Memory 72 can be used for storing software program and various data.Memory 72 can mainly include storing program area and
Storage data area, wherein application program needed for storing program area can store genetic algorithm, at least one function (for example store
Function etc.) etc.；Storage data area can be stored uses created data (such as more according to multidimensional data storage and query facility
Tie up the first table of information) etc..In addition, memory 72 may include high-speed random access memory, it can also include non-volatile deposit
Reservoir, for example, at least a disk memory, flush memory device or other volatile solid-state parts.
Input unit 73, output unit 74 are the interface that external device (ED) is stored with multidimensional data and query facility 70 is connect.
For example, external device (ED) may include the network port, modem port, wired or wireless data port, memory card port, etc.
Deng.Input unit 73 can be used for receiving input (for example, data information, etc.) from external device (ED) and will receive
Input is transferred to one or more elements in multidimensional data storage and query facility 70, and output unit 74 can be used for multidimensional
Data storage and the output (for example, query result, etc.) of one or more elements in query facility 70 output to outside fill
It sets.
Pushing equipment 70 can also include the power supply 75 (such as battery) powered to all parts, it is preferred that power supply 75 can
To realize the functions such as management charging, electric discharge and power managed by power-supply management system.
In addition, pushing equipment 70 includes some unshowned functional modules, details are not described herein.
The equipment provided using the embodiment of the present application 3, by the dimension that can included to multidimensional information and querying condition
Feature and dimensional characteristics value are stored in a manner of arranging storage, and by way of comparing querying condition table and multidimensional information table
Query result is obtained, the relationship type storage characteristics of column storage is had benefited from, all dimensions of multidimensional information can be stored with a big table
Feature and dimensional characteristics value are spent, and then the part/whole dimensional characteristics for being included to multidimensional information is supported to be combined inquiry, is had
Effect improves the search efficiency of multidimensional information.
Embodiment 4
For solve it is of the existing technology may cause that search efficiency is lower, be not able to satisfy user's depositing for multidimensional information
The problem of storage and query demand, the embodiment of the present invention 4 provide a kind of computer-readable storage medium stored and inquire multidimensional information
Matter, the computer-readable recording medium storage one or more program, the one or more program include instruction, which works as quilt
When electronic equipment including multiple application programs executes, the electronic equipment can be made to execute a kind of storage and inquiry multidimensional information
Method, and be specifically used for executing:
Each dimensional characteristics and corresponding dimensional characteristics value for obtaining multidimensional information to be stored, in the way of arranging storage,
Each dimensional characteristics and corresponding dimensional characteristics value are stored, the first table of multidimensional information is obtained；
Obtain querying condition, the querying condition, including at least dimensional characteristics to be checked；
In the way of arranging storage, the querying condition is stored, querying condition table is obtained；
By way of comparing querying condition table and the first table of the multidimensional information, obtain meeting looking into for the querying condition
Ask result.
The computer readable storage medium provided using the embodiment of the present application 4, since to multidimensional information and item can be inquired
The dimensional characteristics and dimensional characteristics value that part is included are stored in a manner of arranging storage, and by comparing querying condition table and more
The mode of dimension information table obtains query result, has benefited from the relationship type storage characteristics of column storage, can be stored with a big table more
All dimensional characteristics and dimensional characteristics value of information are tieed up, and then support the part/whole dimensional characteristics for being included to multidimensional information
It is combined inquiry, effectively increases the search efficiency of multidimensional information.
The present invention be referring to according to the method for the embodiment of the present invention, the process of equipment (system) and computer program product
Figure and/or block diagram describe.It should be understood that every one stream in flowchart and/or the block diagram can be realized by computer program instructions
The combination of process and/or box in journey and/or box and flowchart and/or the block diagram.It can provide these computer programs
Instruct the processor of general purpose computer, special purpose computer, Embedded Processor or other programmable data processing devices to produce
A raw machine, so that being generated by the instruction that computer or the processor of other programmable data processing devices execute for real
The device for the function of being specified in present one or more flows of the flowchart and/or one or more blocks of the block diagram.
These computer program instructions, which may also be stored in, is able to guide computer or other programmable data processing devices with spy
Determine in the computer-readable memory that mode works, so that it includes referring to that instruction stored in the computer readable memory, which generates,
Enable the manufacture of device, the command device realize in one box of one or more flows of the flowchart and/or block diagram or
The function of being specified in multiple boxes.
These computer program instructions also can be loaded onto a computer or other programmable data processing device, so that counting
Series of operation steps are executed on calculation machine or other programmable devices to generate computer implemented processing, thus in computer or
The instruction executed on other programmable devices is provided for realizing in one or more flows of the flowchart and/or block diagram one
The step of function of being specified in a box or multiple boxes.
In a typical configuration, calculating equipment includes one or more processors (CPU), input/output interface, net
Network interface and memory.
Memory may include the non-volatile memory in computer-readable medium, random access memory (RAM) and/or
The forms such as Nonvolatile memory, such as read-only memory (ROM) or flash memory (flash RAM).Memory is computer-readable medium
Example.
Computer-readable medium includes permanent and non-permanent, removable and non-removable media can be by any method
Or technology come realize information store.Information can be computer readable instructions, data structure, the module of program or other data.
The example of the storage medium of computer includes, but are not limited to phase change memory (PRAM), static random access memory (SRAM), moves
State random access memory (DRAM), other kinds of random access memory (RAM), read-only memory (ROM), electric erasable
Programmable read only memory (EEPROM), flash memory or other memory techniques, read-only disc read only memory (CD-ROM) (CD-ROM),
Digital versatile disc (DVD) or other optical storage, magnetic cassettes, tape magnetic disk storage or other magnetic storage devices
Or any other non-transmission medium, can be used for storage can be accessed by a computing device information.As defined in this article, it calculates
Machine readable medium does not include temporary computer readable media (transitory media), such as the data-signal and carrier wave of modulation.
It should also be noted that, the terms "include", "comprise" or its any other variant are intended to nonexcludability
It include so that the process, method, commodity or the equipment that include a series of elements not only include those elements, but also to wrap
Include other elements that are not explicitly listed, or further include for this process, method, commodity or equipment intrinsic want
Element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including described want
There is also other identical elements in the process, method of element, commodity or equipment.
It will be understood by those skilled in the art that embodiments herein can provide as method, system or computer program product.
Therefore, complete hardware embodiment, complete software embodiment or embodiment combining software and hardware aspects can be used in the application
Form.It is deposited moreover, the application can be used to can be used in the computer that one or more wherein includes computer usable program code
The shape for the computer program product implemented on storage media (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.)
Formula.
The above description is only an example of the present application, is not intended to limit this application.For those skilled in the art
For, various changes and changes are possible in this application.All any modifications made within the spirit and principles of the present application are equal
Replacement, improvement etc., should be included within the scope of the claims of this application.
Claims (10)
1. a kind of method of storage and inquiry multidimensional information characterized by comprising
Each dimensional characteristics and corresponding dimensional characteristics value for obtaining multidimensional information to be stored, in the way of arranging storage, to institute
It states each dimensional characteristics and corresponding dimensional characteristics value is stored, obtain the first table of multidimensional information；
Obtain querying condition, the querying condition, including at least dimensional characteristics to be checked；
In the way of arranging storage, the querying condition is stored, querying condition table is obtained；
By way of comparing querying condition table and the first table of the multidimensional information, the inquiry knot for meeting the querying condition is obtained
Fruit.
2. according to the method described in claim 1, the querying condition, further includes the value of dimensional characteristics to be checked；
In the way of arranging storage, the querying condition is stored, querying condition table is obtained, specifically includes:
The value of dimensional characteristics to be checked and dimensional characteristics according to included by the querying condition, according to by the dimensional characteristics
Value as the virtual value in querying condition table mode and it is described column storage mode, the querying condition is deposited
Storage, obtains the querying condition table.
3. according to the method described in claim 2, it is characterized in that, the dimension to be checked in the querying condition table is special
The value of sign is virtual value, other dimensional characteristics values are invalid value；The virtual value is 1, and the invalid value is 0；
In the querying condition table, corresponding to the virtual value of same dimensional characteristics to be checked and the sum of the invalid value
The total number of mesh, dimensional characteristics value corresponding with dimensional characteristics each in first table of multidimensional information is identical；
By way of comparing querying condition table and the first table of the multidimensional information, the inquiry knot for meeting the querying condition is obtained
Fruit specifically includes:
By the dimensional characteristics value on the corresponding position of the second table of dimensional characteristics value and multidimensional information in the querying condition table into
Row phase and operation, obtain the query result；
Wherein, second table of multidimensional information is identical as first table of multidimensional information；Alternatively, the second table of multidimensional information base
It is generated in first table of multidimensional information；
Second table of multidimensional information is constituted by being worth for 1 or 0 dimensional characteristics value；It is virtual value for 1 dimensional characteristics value；It is 0
Dimensional characteristics value be invalid value.
4. the method according to claim 1, wherein the query result, including embodying query result content
Visual Chart.
5. storage and the inquiry unit of a kind of multidimensional information characterized by comprising
Multidimensional information storage unit obtains each dimensional characteristics and corresponding dimensional characteristics value of multidimensional information to be stored, according to
The mode for arranging storage, stores each dimensional characteristics and corresponding dimensional characteristics value, obtains the first table of multidimensional information；
Querying condition acquiring unit obtains querying condition, the querying condition, including at least dimensional characteristics to be checked；
Querying condition storage unit stores the querying condition, obtains querying condition table in the way of arranging storage；
Query unit obtains meeting the inquiry item by way of comparing querying condition table and the first table of the multidimensional information
The query result of part.
6. device as claimed in claim 5, which is characterized in that the querying condition further includes dimensional characteristics to be checked
Value；
The querying condition storage unit, is specifically used for: the dimensional characteristics to be checked according to included by the querying condition and
The value of dimensional characteristics, by using the value of the dimensional characteristics in the way of the virtual value in querying condition table and the column
The mode of storage stores the querying condition, obtains the querying condition table.
7. device as claimed in claim 5, which is characterized in that the dimensional characteristics to be checked in the querying condition table
Value be virtual value, other dimensional characteristics values be invalid value；The virtual value is 1, and the invalid value is 0；
In the querying condition table, corresponding to the virtual value of same dimensional characteristics to be checked and the sum of the invalid value
The total number of mesh, dimensional characteristics value corresponding with dimensional characteristics each in first table of multidimensional information is identical；
The query unit, is specifically used for:
By the dimensional characteristics value on the corresponding position of the second table of dimensional characteristics value and multidimensional information in the querying condition table into
Row phase and operation, obtain the query result；
Wherein, second table of multidimensional information is identical as first table of multidimensional information；Alternatively, the second table of multidimensional information base
It is generated in first table of multidimensional information；
Second table of multidimensional information is constituted by being worth for 1 or 0 dimensional characteristics value；It is virtual value for 1 dimensional characteristics value；It is 0
Dimensional characteristics value be invalid value.
8. device as claimed in claim 5, which is characterized in that the query result, including embody query result content can
Depending on changing chart.
9. the equipment of a kind of storage and inquiry multidimensional information characterized by comprising memory, processor and be stored in described
It is real when the computer program is executed by the processor on memory and the computer program that can run on the processor
The step of now storing according to any one of claims 1 to 4 and inquire the method for multidimensional information.
10. a kind of computer readable storage medium, the computer-readable recording medium storage one or more program, described one
A or multiple programs are when the electronic equipment for being included multiple application programs executes, so that the electronic equipment is executed as right is wanted
The step of method of storage described in asking any one of 1 to 4 and inquiry multidimensional information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810689230.1A CN109189777A (en) | 2018-06-28 | 2018-06-28 | A kind of method, device and equipment stored and inquire multidimensional information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810689230.1A CN109189777A (en) | 2018-06-28 | 2018-06-28 | A kind of method, device and equipment stored and inquire multidimensional information |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109189777A true CN109189777A (en) | 2019-01-11 |
Family
ID=64948618
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810689230.1A Pending CN109189777A (en) | 2018-06-28 | 2018-06-28 | A kind of method, device and equipment stored and inquire multidimensional information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109189777A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110955686A (en) * | 2019-12-02 | 2020-04-03 | 秒针信息技术有限公司 | Data multidimensional cross processing method and device, electronic equipment and storage medium |
| CN112632061A (en) * | 2020-12-03 | 2021-04-09 | 海腾保险代理有限公司 | Multidimensional data storage method and device |
| WO2024103599A1 (en) * | 2022-11-17 | 2024-05-23 | 浪潮电子信息产业股份有限公司 | Data query method, system, apparatus and device, and non-volatile readable storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103020301A (en) * | 2012-12-31 | 2013-04-03 | 中国科学院自动化研究所 | Multidimensional data query and storage method and system |
| CN103092842A (en) * | 2011-10-28 | 2013-05-08 | 浙江大华技术股份有限公司 | Method for storing and retrieving key area information in video image data file |
| CN104424258A (en) * | 2013-08-28 | 2015-03-18 | 腾讯科技（深圳）有限公司 | Multidimensional data query method and system, query server and column storage server |
| CN104462434A (en) * | 2014-12-15 | 2015-03-25 | 北京国双科技有限公司 | Data inquiring method and device |
| CN107229730A (en) * | 2017-06-08 | 2017-10-03 | 北京奇虎科技有限公司 | Data query method and device |
| WO2017176626A1 (en) * | 2016-04-07 | 2017-10-12 | Quid, Inc. | Boolean-query composer |
-
2018
- 2018-06-28 CN CN201810689230.1A patent/CN109189777A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103092842A (en) * | 2011-10-28 | 2013-05-08 | 浙江大华技术股份有限公司 | Method for storing and retrieving key area information in video image data file |
| CN103020301A (en) * | 2012-12-31 | 2013-04-03 | 中国科学院自动化研究所 | Multidimensional data query and storage method and system |
| CN104424258A (en) * | 2013-08-28 | 2015-03-18 | 腾讯科技（深圳）有限公司 | Multidimensional data query method and system, query server and column storage server |
| CN104462434A (en) * | 2014-12-15 | 2015-03-25 | 北京国双科技有限公司 | Data inquiring method and device |
| WO2017176626A1 (en) * | 2016-04-07 | 2017-10-12 | Quid, Inc. | Boolean-query composer |
| CN107229730A (en) * | 2017-06-08 | 2017-10-03 | 北京奇虎科技有限公司 | Data query method and device |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110955686A (en) * | 2019-12-02 | 2020-04-03 | 秒针信息技术有限公司 | Data multidimensional cross processing method and device, electronic equipment and storage medium |
| CN112632061A (en) * | 2020-12-03 | 2021-04-09 | 海腾保险代理有限公司 | Multidimensional data storage method and device |
| WO2024103599A1 (en) * | 2022-11-17 | 2024-05-23 | 浪潮电子信息产业股份有限公司 | Data query method, system, apparatus and device, and non-volatile readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Rodriguez et al. | Constructions from dots and lines | |
| Kaur et al. | Modeling and querying data in NoSQL databases | |
| CN100504866C (en) | Integrative searching result sequencing system and method | |
| CN103514204B (en) | Information recommendation method and device | |
| US20100250526A1 (en) | Search System that Uses Semantic Constructs Defined by Your Social Network | |
| CN109189777A (en) | A kind of method, device and equipment stored and inquire multidimensional information | |
| KR20120126093A (en) | Method, system and server for managing dynamic information of friends in network | |
| Morozov et al. | Distributed contour trees | |
| CN106911757A (en) | The method for pushing and device of a kind of business information | |
| KR20140140309A (en) | Method for calculating simularity between users and item recommendation method using the same | |
| Qu et al. | Study of decision implications based on formal concept analysis | |
| CN107832392A (en) | A kind of metadata management system | |
| TW201308111A (en) | Method and apparatus for classifying commodities on e-commerce platform | |
| CN105843618A (en) | Desktop system with custom theme edition function | |
| CN102158533B (en) | Distributed web service selection method based on QoS (Quality of Service) | |
| CN110322281A (en) | The method for digging and device of similar users | |
| CN107391537A (en) | Generation method, device and the equipment of data relationship model | |
| ShefaliPatil et al. | Graph databases-an overview | |
| CN110069523A (en) | A kind of data query method, apparatus and inquiry system | |
| Schneck et al. | Accelerating traffic assignment with customizable contraction hierarchies | |
| Shiangjen et al. | An iterative bidirectional heuristic placement algorithm for solving the two-dimensional knapsack packing problem | |
| CN110245978A (en) | Policy evaluation, policy selection method and device in tactful group | |
| KR101526514B1 (en) | Hyper-lattice model for optimized sequencing of online analytical processing (olap) operations on data warehouses | |
| JP6542204B2 (en) | INFORMATION PROCESSING APPARATUS, INFORMATION PROCESSING METHOD, AND PROGRAM | |
| Kannan et al. | Sociomaterial perspective of digital platforms |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for 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: 20190111 |