CN108932257A - The querying method and device of multi-dimensional data - Google Patents
The querying method and device of multi-dimensional data Download PDFInfo
- Publication number
- CN108932257A CN108932257A CN201710379694.8A CN201710379694A CN108932257A CN 108932257 A CN108932257 A CN 108932257A CN 201710379694 A CN201710379694 A CN 201710379694A CN 108932257 A CN108932257 A CN 108932257A
- Authority
- CN
- China
- Prior art keywords
- dimension
- combination
- data
- indicator
- target
- 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.)
- Granted
Links
Abstract
The present invention provides a kind of querying method of multi-dimensional data and devices,It is grouped by dimension to data and index,Obtain multiple dimension indicator combinations,And the corresponding dimension achievement data table of each dimension indicator combination,The dimension achievement data table is used to store the data of dimension and index that corresponding dimension indicator combination includes,It is inquired under at least one target dimension after the data inquiry request of at least one target indicator corresponding data obtaining,By the dimensional information table prestored by inquiry and combination definition table,Quickly determine at least one target dimension indicator combination where at least one target dimension,At this time,Only need from the corresponding dimension achievement data table of the target dimension indicator combination,The corresponding data of each target indicator under target dimension can be inquired,Simply and conveniently,Since inquiry data volume is only related to the dimension that target dimension indicator combination includes,It is unrelated with other dimensions,Greatly reduce inquiry data volume,Improve efficiency data query.
Description
Technical field
The present invention relates to technical field of data processing, a kind of querying method more particularly to multi-dimensional data and
Device.
Background technique
With the arrival of big data era, people are frequently necessary to carry out data query from multiple dimensions, and data storage knot
The difference of structure often will affect inquiry and the analysis efficiency of data.
In the prior art, it will usually preset a tables of data for data to be stored, and according to data to be stored
Dimension and index, tables of data is divided into multicolumn, so that the data to be stored of acquisition is directly stored pair into tables of data
Position is answered, the storage organization of the tables of data is simple, and when data storage dimension is smaller, inquiry is more convenient.
However, the increase of the number of dimensions with storing data, will lead to the tables of data of existing this storage organization
Data query amount exponentially increases, and greatly reduces search efficiency.
Summary of the invention
In view of the above problems, it proposes the present invention one kind is provided and overcome the above problem or at least be partially solved above-mentioned ask
The querying method and device of the multi-dimensional data of topic.
A kind of querying method of multi-dimensional data, the method includes：
Obtain the data inquiry request for inquiring at least one target indicator corresponding data under at least one target dimension；
The dimensional information table that prestores and combination definition table are inquired, to determine where at least one described target dimension extremely
A few target dimension indicator combination；
It obtains prestoring with the one-to-one dimension achievement data table of at least one target dimension indicator combination；
From the dimension achievement data table of acquisition, it is corresponding to inquire at least one described target indicator under corresponding target dimension
Data.
Preferably, the method also includes：
It generates and combines mark correspondingly with the dimension indicator combination；
Between the combination mark of each dimension for including using dimension indicator combination described in each and the dimension indicator combination
Corresponding relationship, generate the dimensional information table.
Preferably, described to inquire the dimensional information table prestored and combination definition table, to determine at least one described target
At least one target dimension indicator combination where dimension, including：
The dimensional information table prestored is inquired, to determine the corresponding objective cross mark of at least one described target dimension；
The combination definition table prestored is inquired, identifies one-to-one target dimension index group with the objective cross to obtain
Close, the combination definition table includes combination parameter for distinguishing each dimension indicator combination, the combination parameter include with accordingly
Dimension indicator combination combines mark, combination title and memory cell identification correspondingly；
It is described to obtain the one-to-one dimension achievement data table of at least one target dimension indicator combination prestored, packet
It includes：
Data query is carried out to the corresponding storage unit of the memory cell identification of acquisition, obtains the storage unit storage
Dimension achievement data table, the dimension achievement data table include each under at least one dimension that corresponding dimension indicator combination includes
The data of index.
Preferably, the method also includes：
Between the combination mark of each index for including using dimension indicator combination described in each and the dimension indicator combination
Corresponding relationship, generate indication information table；
According to the dimensional information table, the indication information table and the combination definition table prestored, each storage unit is created
Identify corresponding storage unit；
At least one dimension and at least one index for including using the corresponding dimension indicator combination of the storage unit,
Generate the dimension achievement data table of the dimension indicator combination；
The dimension achievement data table is stored to the storage unit.
Preferably, the method also includes：
Data storage request is obtained, the data storage request carries index and dimension belonging to data to be stored；
The dimensional information table and the indication information table are inquired, judges index belonging to the data to be stored and dimension
It whether there is；
If it does, determining the affiliated index of the data to be stored and the corresponding dimension indicator combination of dimension, and will be described
Data to be stored is stored to dimension achievement data table corresponding with the determining dimension indicator combination；
If it does not, the dimension indicator combination that dimension belonging to the data to be stored and index is new as one,
Combination mark, combination title and the storage unit of the new dimension indicator combination are sequentially added in the combination definition table
Mark, and update the dimensional information table and the indication information table.
A kind of inquiry unit of multi-dimensional data, described device include：
Inquiry request obtains module, corresponds to number for obtaining at least one target indicator under at least one target dimension of inquiry
According to data inquiry request；
Query composition module, for inquiring the dimensional information table prestored and combination definition table, to determine described at least one
At least one target dimension indicator combination where a target dimension；
Tables of data obtain module, for obtain prestore described at least one target dimension indicator combination tie up correspondingly
Spend achievement data table；
Data inquiry module, for from the dimension achievement data table of acquisition, inquire under corresponding target dimension it is described extremely
Few corresponding data of a target indicator.
Preferably, described device further includes：
First generation module combines mark with the dimension indicator combination for generating correspondingly；
Second generation module, each dimension and the dimension index group for including using dimension indicator combination described in each
Corresponding relationship between the combination mark of conjunction, generates the dimensional information table.
Preferably, the query composition module includes：
First query unit, for inquiring the dimensional information table prestored, to determine that at least one described target dimension is corresponding
Objective cross mark；
Second query unit, it is a pair of with objective cross mark one to obtain for inquiring the combination definition table prestored
The target dimension indicator combination answered, the combination definition table includes the combination parameter for distinguishing each dimension indicator combination, described
Combination parameter includes combining mark, combination title and memory cell identification correspondingly with respective dimensions indicator combination；
The tables of data obtains module, specifically for carrying out data to the corresponding storage unit of the memory cell identification of acquisition
Inquiry obtains the dimension achievement data table of the storage unit storage, and the dimension achievement data table includes that corresponding dimension refers to
The data of each index under at least one dimension that mark combination includes.
Preferably, described device further includes：
Third generation module, each index and the dimension index group for including using dimension indicator combination described in each
Corresponding relationship between the combination mark of conjunction, generates indication information table；
Creation module, for according to the dimensional information table, the indication information table and the combination definition table prestored, wound
Build the corresponding storage unit of each memory cell identification；
4th generation module, at least one dimension for including using the corresponding dimension indicator combination of the storage unit
Under each index data, generate the dimension achievement data table of the dimension indicator combination；
Memory module, for storing the dimension achievement data table to the storage unit.
Preferably, described device further includes：
Storage request obtains module, and for obtaining data storage request, the data storage request carries data to be stored
Affiliated index and dimension；
Inquiry judging module inquires the dimensional information table and the indication information table, judges the data to be stored institute
The index and dimension of category whether there is；
First update module, it is described wait store for determining in the presence of the judging result of the inquiry judging module is
The affiliated index of data and the corresponding dimension indicator combination of dimension, and the dimension indicator combination is updated using the data to be stored
Corresponding dimension achievement data table；
Second update module, in the absence of the judging result of the inquiry judging module is, by described wait store
Dimension belonging to data and the index dimension indicator combination new as one sequentially add described new in the combination definition table
Dimension indicator combination combination mark, combination title and memory cell identification, and update the dimensional information table and institute
State indication information table.
By above-mentioned technical proposal, the present invention provides a kind of querying method of multi-dimensional data and device, the application is logical
It crosses and the dimension and index of data is grouped, obtain multiple dimension indicator combinations, and each dimension indicator combination corresponding one
A dimension achievement data table, the dimension achievement data table only store the number of dimension and index that corresponding dimension indicator combination includes
According to, in this way, inquired under at least one target dimension after the data inquiry request of at least one target indicator corresponding data obtaining,
The dimensional information table prestored by inquiry and combination definition table are quickly determined at least one target dimension place by the application
At least one target dimension indicator combination, at this time, it is only necessary to from the corresponding dimension achievement data of the target dimension indicator combination
In table, the corresponding data of each target indicator under target dimension can be inquired, simply and conveniently, due to inquiry data volume only with mesh
The dimension that mark dimension indicator combination includes is related, unrelated with other dimensions, greatly reduces inquiry data volume, improves data and look into
Ask efficiency.
The above description is only an overview of the technical scheme of the present invention, in order to better understand the technical means of the present invention,
And it can be implemented in accordance with the contents of the specification, and in order to allow above and other objects of the present invention, feature and advantage can
It is clearer and more comprehensible, the followings are specific embodiments of the present invention.
Detailed description of the invention
By reading the following detailed description of the preferred embodiment, various other advantages and benefits are common for this field
Technical staff will become clear.The drawings are only for the purpose of illustrating a preferred embodiment, and is not considered as to the present invention
Limitation.And throughout the drawings, the same reference numbers will be used to refer to the same parts.In the accompanying drawings：
Fig. 1 shows a kind of querying method flow chart of multi-dimensional data provided in an embodiment of the present invention；
Fig. 2 shows the querying method flow charts of another multi-dimensional data provided in an embodiment of the present invention；
Fig. 3 shows the querying method flow chart of another multi-dimensional data provided in an embodiment of the present invention；
Fig. 4 shows a kind of inquiry unit structural block diagram of multi-dimensional data provided in an embodiment of the present invention；
Fig. 5 shows the inquiry unit structural block diagram of another multi-dimensional data provided in an embodiment of the present invention；
Fig. 6 shows the inquiry unit structural block diagram of another multi-dimensional data provided in an embodiment of the present invention；
Fig. 7 shows the inquiry unit structural block diagram of another multi-dimensional data provided in an embodiment of the present invention；
Fig. 8 shows a kind of hardware structural diagram of the inquiry unit of multi-dimensional data provided in an embodiment of the present invention.
Specific embodiment
Exemplary embodiments of the present disclosure are described in more detail below with reference to accompanying drawings.Although showing the disclosure in attached drawing
Exemplary embodiment, it being understood, however, that may be realized in various forms the disclosure without should be by embodiments set forth here
It is limited.On the contrary, these embodiments are provided to facilitate a more thoroughly understanding of the present invention, and can be by the scope of the present disclosure
It is fully disclosed to those skilled in the art.
The analysis of technology segment based on the above background, the present invention is illustrated by taking monitoring of the advertisement system as an example herein, at this
Under application scenarios, the differences such as intention, media, channel, operating system and device type can be set for data to be stored
The different indexs such as dimension, and exposure, click, separate exposures, independent click in practical applications can be by checking difference
The data of each index under dimension, to assess advertising results.
It should be noted that other corresponding dimensions and index can be set in other application scenarios, it is not limited to
The above-mentioned dimension and index enumerated only carries out scheme explanation, other application field by taking this application scenarios of monitoring of the advertisement as an example herein
The data processing scheme application process of scape is similar, and the present invention no longer illustrates one by one.
In the prior art, usually by determining all dimensions together with all indexs composition, a tables of data is generated,
As shown in table 1 below：
Table 1
Based on the data store organisation that above-mentioned data represent, since determining all dimensions are stored in a data by it
In table, this will will lead to the quantity product that daily data volume is all dimensions.By taking the dimension in above-mentioned table 1 as an example, it is assumed that have
100 intention, 20 media, 10 channels, 20 operating systems, device type in 8, then daily data volume is 100*20*
10*20*8=3200000, the data volume less than one month will have query performance, influence each finger inquired under dimension
Target efficiency.
In order to reduce data volume, efficiency data query is improved, the present invention provides a kind of new data store organisations, use
The method that the data storage of metadata management adds dynamic generation data, while meeting the needs of multidimensional data query,
It solves the problems, such as query performance, the experience of user query data is provided, specific implementation is referred to retouching for following embodiments
It states.
As shown in Figure 1, being a kind of flow chart of the querying method embodiment of multi-dimensional data provided by the invention, this implementation
Example mainly describes the process for how fast and accurately inquiring data, can specifically include following steps：
Step S11 obtains the data query for inquiring at least one target indicator corresponding data under at least one target dimension
Request；
In practical applications, in order to learn product service condition, it will usually to the various data in product use process into
Row analysis, to judge product service condition, based on the analysis results to propose improvement project etc. for product.For example, in order to
The advertising results for solving various initiative advertisements, by meeting to ad click situation, user to advertising feedback situation, electronic equipment is received
Case of advertisements etc. is analyzed, so that designer accordingly adjusts ad content and form etc. based on the analysis results.
Based on this, in order to obtain the data in above-mentioned various situations, corresponding data query can be initiated to electronic equipment
Request, in practical applications, in order to fast and accurately obtain required data, it will usually according to data dimension and/or refer to
Mark, to inquire required data, therefore, data inquiry request may include that at least one target under at least one target dimension refers to
Mark, that is to say, that user wishes to inquire the corresponding data of at least one target indicator under at least one target dimension at this time.
By taking monitoring of the advertisement system as an example, for the advertising results for understanding each initiative advertisement, this dimension of intention can be added
It is sent into data inquiry request；If desired in more each channel advertisement effect, channel can be added to number by this dimension
According to transmission etc. in inquiry request, it might even be possible to multiple dimensions such as intention, channel, media are added in data inquiry request,
And the specific targets for needing to inquire according to dimension own characteristic addition, such as exposure, click index.
It can be seen that can be carried in data inquiry request at least one target dimension for inquiring data to be checked and
At least one target indicator under it comprising content can determine that the present invention is not another herein according to data analysis requirements
One enumerates.Furthermore, it is desirable to which explanation, the application do not limit the generating mode and the way of output of data inquiry request
It is fixed.
Step S12 inquires the dimensional information table prestored and combination definition table, determines at least one target dimension place
At least one target dimension indicator combination；
In this application, in order to improve efficiency data query, multiple dimensions and index that data are related to are divided into more
A dimension indicator combination, making each dimension indicator combination includes at least one dimension and at least one index.It needs to illustrate
It is that the application is not construed as limiting the specific division mode of dimension indicator combination, it can be according to dimension the application characteristic and reality
Inquiry such as needs to realize at the factors, and the application is no longer described in detail one by one herein.
Optionally, the application can make a dimension indicator combination only include a dimension and multiple indexs, thus maximum
Improve to degree efficiency data query, but however, it is not limited to this for the dimension indicator combination number of dimensions that includes.
In addition, in practical applications, in order to identify each dimension indicator combination, it is a pair of that each dimension indicator combination one can be generated
The combination parameter answered, such as combination mark (such as combination ID), combination title, memory cell identification, the application is to the combination parameter
Including content be not construed as limiting, as long as can be used to distinguish each dimension indicator combination, the application will not enumerate herein.
Optionally, the present embodiment can also according to the combination parameter of different dimensions indicator combination, generate combination define table into
Row storage as shown in table 2 below, but is not limited to combine the way of output of definition table shown in table 2.Wherein, combination mark can
To be that continuous number or letter, memory cell identification can be continuous storage address etc., it should be noted that the combination is fixed
In adopted table and duplicate combination parameter is not present, i.e. each combination ID be it is unique, each combination title is also unique
, and each memory cell identification is also unique.
Table 2
| Combine ID | Combine title | Memory cell identification |
| 1 | Intention | C0001 |
| …… | …… | …… |
In the present embodiment, the dimension that different dimensions indicator combination includes usually is different, for convenience according to dimension
Its corresponding dimension indicator combination is searched, the application can be by any one group of dimension indicator combination where multiple dimensions and its
Parameter association is closed, to generate dimensional information table.As shown in table 3 below, the group of each dimension and dimension indicator combination where it is established
Close the corresponding relationship between ID.
Table 3
| Combine ID | Dimension |
| 1 | Intention |
| 2 | Channel |
| …… | …… |
By upper table 3 it is found that in practical applications, the dimension that different dimensions indicator combination includes can be determined by combination ID
Content and quantity, it is also possible to according to the target dimension to be inquired, the combination of dimension indicator combination where determining it
ID, and then table is defined by inquiry combination, learn combination title, the storage unit of the dimension indicator combination where the target dimension
The information such as mark, it is very convenient.
Step S13 is obtained prestoring with the one-to-one dimension index number of at least one target dimension indicator combination
According to table；
Step S14 inquires at least one described target under corresponding target dimension from the dimension achievement data table of acquisition
The corresponding data of index.
In the present embodiment, in order to improve efficiency data query, will include for the combination of each dimension achievement data
Each dimension and the corresponding data of index, as soon as generation and one-to-one dimension achievement data table of the dimension indicator combination,
It is to say, each dimension achievement data table is only used to store the corresponding data of corresponding dimension indicator combination, as shown in table 4 below,
But it is not limited to the way of output of dimension achievement data table shown in table 4.
Table 4
| Date | Intention | Exposure | It clicks | Separate exposures | It is independent to click |
| 2016-9-23 | Large-size screen monitors | 2 | 1 | 1 | 1 |
| …… | …… | …… | …… | …… | …… |
As shown in Table 4, when storing collected data, it will usually by the acquisition time of one group of data to be stored of acquisition
Corresponding storage is carried out, such as be large-size screen monitors by intention, exposure is 2, click is 1, separate exposures 1, independent this group for being 1 of clicking are wait deposit
The acquisition time 2016-9-23 of data is stored up, as shown in table 4, so as to user or can be set by this group of data storage into a line
It is standby to find out data to be checked by row, but it is not limited to storage mode listed above.
Based on above-mentioned analysis it is found that when needing to inquire the data of at least one index under some or multiple dimensions,
Only it needs to be determined that corresponding dimension achievement data table, it will be able to quickly find required data.It can be seen that data query
Data volume it is only related with the dimension that dimension indicator combination includes, it is unrelated with other dimensions, greatly reduce data volume, improve
Efficiency data query.
In order to realize above-mentioned data query scheme, the application is determining multiple dimension indicator combinations, and generates one-to-one correspondence
Dimension achievement data table it is various, can be according to the dimension and index for including in each dimension achievement data table, by corresponding data
It is filled up in dimension achievement data table.
Wherein it is determined that before dimension indicator combination, it will usually first carry out dimension to the data that needs store and index is drawn
Point, and then dimension achievement data table etc. is generated according still further to the mode of above-described embodiment description.Optionally, the present invention can be for not
Corresponding multiple dimensions are set with application scenarios, by taking monitoring of the advertisement application scenarios as an example, set multiple dimensions may include
The specific intention of advertisement, affiliated media, the operating system of the channel played and institute's suitable device and device type etc..
For different application scene, the content of set multiple dimensions can be different, and the present invention is no longer described in detail one by one herein.
Moreover, the specific targets data of acquisition are generally also different, such as according to the different application demand in application scenarios
In order to evaluate advertising efficiency, data that are available but being not limited to the indexs such as exposure, click, separate exposures, independent click.
It should be noted that the dimension and achievement data for needing to acquire will accordingly change in other application scenarios,
The application is no longer described in detail one by one herein.
Based on foregoing description, as shown in Fig. 2, present invention also provides the querying method embodiments of another multi-dimensional data
Flow chart, this method may include：
Step S21 determines the multiple dimensions and multiple indexs of data to be collected；
, can be according to data to be collected feature itself and purpose etc. in the present embodiment practical application, determination needs to acquire
Which achievement data under which dimension determines data collecting rule, so that equipment realizes number according to the data collecting rule
According to acquisition.
Wherein, the application is to the data type of data to be collected and content etc., and there are also in the data collecting rule determined
Appearance and the way of output etc. are not construed as limiting.
Step S22 is combined division to this multiple dimension and multiple indexs, generates multiple dimension indicator combinations；
In this application, multiple dimensions can be divided according to each actual data analysis purpose, in conjunction with dimension sheet
Body feature and corresponding data analyze purpose, the index that each dimension group needs are determined, to generate multiple dimension index groups
It closes.
Wherein, each dimension indicator combination includes at least one dimension and at least one index.Optionally, in order to mention
The efficiency of high subsequent query target data can make each dimension indicator combination include a dimension and multiple indexs, but simultaneously
It is not limited to this.
Step S23, determining and each one-to-one combination parameter of dimension indicator combination, and generate and show that each dimension refers to
The combination for marking combined combination parameter defines table, which includes combination ID, combination title and memory cell identification；
In practical applications, the dimension that can include according to dimension indicator combination, determines the combination of the dimension indicator combination
Title, and combination ID of multiple serial numbers as each dimension indicator combination is sequentially generated, as shown in Table 1, but do not limit to
In this.
It moreover, multiple storage units can be divided into after the memory space for determining data to be collected, and is each
A storage unit writes corresponding number, as the memory cell identification, corresponding data of each dimension indicator combination for identification
Storage location.It in the present embodiment, can be by the dimension achievement data table storage generated for the dimension indicator combination to correspondence
The storage unit of memory cell identification, it is accurate to obtain accordingly so as to the subsequent memory cell identification based on the dimension indicator combination
Dimension achievement data table, and then inquire from the dimension achievement data table data of needs.
Step S24, generates the dimensional information table for the dimension for showing that each dimension indicator combination includes, and shows that each dimension refers to
The indication information table for the index that mark combination includes；
Optionally, due to being one-to-one relationship between any combination parameter and dimension indicator combination, the present embodiment can be with
Indicate its corresponding dimension indicator combination using any one combination parameter, thus using dimension indicator combination and its include tie up
Inclusion relation between degree and index, establishes the corresponding relationship between a combination thereof parameter and the dimension and index, to generate phase
The dimensional information table and indication information table answered, shown in table 3 as above and the following table 5, selected combination parameter can be combination ID, but simultaneously
It is not limited to this.
Table 5
| Combine ID | Index |
| 1 | Exposure |
| 1 | It clicks |
| …… | …… |
It can be seen that can determine the corresponding combination of the dimension by inquiry table 3 after determining the dimension of inquired data
ID, and then by inquiry table 2, combination title corresponding with combination ID is learnt, it can be learnt which dimension is inquired dimension belong to
Spend indicator combination.Similarly, after learning the index that needs are inquired, corresponding combination ID can be learnt by inquiry table 5, and then pass through
Inquiry table 2 is learnt and dimension indicator combination belonging to the index.
Wherein, since the usually presence overlapping of the pointer type of different dimensions is even identical, in practical applications, lead to
Chang Buhui only obtains required data by target indicator.Certainly, if needing to inquire the data of target indicator under each dimension,
It can also realize in the manner described above.
Step S25, the dimension and index for including using same dimension indicator combination generate corresponding with the dimension indicator combination
Dimension achievement data table；
Shown in table 4 as above, the dimension of respective dimensions indicator combination and each pointer type can be filled in into the dimension and referred to
The specific value of index each under collected respective dimensions is filled up to by the first row of mark tables of data according to this division mode
In respective cells, to realize that data store.
Step S26, after collecting data to be stored, inquiry dimensional information table, indication information table and combination define table, really
The corresponding storage unit of dimension indicator combination where its fixed dimension and index；
Step S27 stores the data to be stored corresponding in the dimension achievement data table into the storage unit
Position；
In conjunction with above-mentioned analysis, such as obtain exposure, click, separate exposures and the independent click index of large-size screen monitors initiative advertisement
Data after, can by inquire above table, determine dimension be large-size screen monitors where dimension indicator combination, and then determine its dimension
Storage unit where achievement data table, to accurately storing these data to dimension achievement data table respective cells.
Step S28 obtains the data query for inquiring at least one target indicator corresponding data under at least one target dimension
Request；
Step S29 inquires above-mentioned dimensional information table, determines the corresponding objective cross ID of at least one target dimension；
Step S210, inquiry said combination define table, obtain and identify one-to-one target dimension with the objective cross
The combination title and memory cell identification of indicator combination；
Step S211 obtains the dimension of target dimension indicator combination from respective memory unit according to the memory cell identification
Achievement data table；
In the present embodiment practical application, the storage unit with the memory cell identification can be first determined, and then obtain
The storage unit storage dimension achievement data table, i.e., with the one-to-one dimension achievement data of target dimension indicator combination
Table comprising the data of each index under at least one dimension that the target dimension indicator combination includes.
Step S212 inquires at least one described mesh under corresponding target dimension from the dimension achievement data table of acquisition
Mark the corresponding data of index；
Step S213 is generated according to the data inquired and is exported analysis report.
The present embodiment can determine corresponding parser come to the data inquired according to the actual needs of inquiry data
It is analyzed, to generate corresponding analysis report based on the analysis results.Wherein, the application is to parser content and analysis
Content and the way of output of report etc. are not construed as limiting.
To sum up, data multiple dimensions and index are divided into more by the application using a kind of new data storage scheme
A dimension indicator combination, and one dimension achievement data table is set for each dimension indicator combination, it is stored separately on one
In storage unit, for collected data, which dimension indicator combination will be belonged to determining its, then updated corresponding
In dimension achievement data table, in this way, can also directly be arrived where it in the manner described above when needing to certain data queries
It inquires in dimension achievement data table, is looked into the prior art from the tables of data of all data comprising the various indexs of various dimensions
The mode of data needed for asking is compared, and is greatly reduced the data volume of inquiry, is improved efficiency data query.
It is the querying method flow chart of another multi-dimensional data provided in an embodiment of the present invention, the present embodiment referring to Fig. 3
It is realized as a kind of optional implementation of data storage, but is not limited to this kind of implementation described herein,
It can be adaptively adjusted according to actual needs.Then method provided in this embodiment may include：
Step S31 obtains data storage request；
Wherein, data storage request carries index and dimension belonging to data to be stored.In practical applications, dimension is generated
After achievement data table, data storage request can be initiated at any time, and collected data are stored to the dimension of corresponding storage unit
It spends in achievement data table.
Step S32 inquires dimensional information table and indication information table, judges whether are index belonging to data to be stored and dimension
In the presence of if it does, executing step S33；If it does not, executing step S35；
In practical applications, the dimension as belonging to new collected data and index are not present before may be, this
When cannot directly be stored in dimension achievement data table, it may be necessary to new dimension achievement data table is established, alternatively, more
Dimension and pointer type in new existing dimension achievement data table, the application are not especially limited this.
Step S33 determines the affiliated index of data to be stored and the corresponding dimension indicator combination of dimension；
Wherein, on how to utilize the affiliated index of data to be stored and dimension, the mistake of corresponding dimension indicator combination is determined
Journey is referred to the description of above-described embodiment corresponding portion, and this will not be detailed here for the present embodiment.
Step S34 updates the dimension achievement data of the corresponding storage of the determining dimension indicator combination using data to be stored
Table；
In conjunction with above-mentioned analysis, the dimension as belonging to collected data to be stored and index are had existed, and are illustrated original
Existing corresponding data in dimension achievement data table, at this point it is possible to will new collected data to be stored update respective dimensions and
The corresponding data of index, i.e., realization dimension achievement data table and update.
Step S35, using dimension belonging to data to be stored and index the dimension indicator combination new as one；
Step S36, combination definition table in sequentially add the new dimension indicator combination combination mark, combination title with
And memory cell identification, and accordingly update dimensional information table and indication information table；
It wherein, can about definition table, the content that dimensional information table and indication information table include and generating mode etc. is combined
With according to the description of above-described embodiment corresponding portion, this will not be detailed here for the present embodiment.
Step S37 is generated for new dimension indicator combination in the corresponding storage unit of newly added memory cell identification
Corresponding dimension indication information table, and data to be stored is stored to the dimension indication information table corresponding position.
In the present embodiment, store about new dimension indication information table and by data to the mistake of the dimension indication information table
Journey is referred to the description of above-described embodiment corresponding portion, and this will not be detailed here for the present embodiment.
In conclusion, when there is new data to need to store, the data proposed based on the application store knot in the present embodiment
Structure can directly be updated in existing respective dimensions achievement data table, or one is constructed in new storage unit
New dimension achievement data table, it is very convenient, be conducive to the later period to the quick search of the data.
The structure of the inquiry unit of multi-dimensional data provided by the invention is described by forming from functional module below.
It is a kind of structural block diagram of the inquiry unit of multi-dimensional data provided in an embodiment of the present invention, the device referring to Fig. 4
May include：
Inquiry request obtains module 401, inquires at least one target indicator pair under at least one target dimension for obtaining
Answer the data inquiry request of data；
Query composition module 402 determines at least one mesh for inquiring the dimensional information table prestored and combination definition table
At least one target dimension indicator combination where marking dimension；
Wherein, it is corresponding to be referred to above method embodiment for the generating mode about dimensional information table and combination definition table
Partial description, this will not be detailed here for the present embodiment.
In the present embodiment, can be according to the actual needs of data query and each data dimension itself the characteristics of etc., really
Surely the multiple dimensions and multiple indexs for the data that may be inquired, and different data query requirements are directed to, to this multiple dimension
It is divided with multiple indexs, to generate multiple dimension indicator combinations.It should be noted that the application refers to each dimension
The type of dimension and index that mark combination includes is not construed as limiting with quantity.
Tables of data obtains module 403, ties up correspondingly for obtaining at least one the target dimension indicator combination prestored
Spend achievement data table；
In the present embodiment, corresponding dimension achievement data table will be generated for each dimension indicator combination, for storing
The dimension and the corresponding data of index that the dimension indicator combination includes, and dimension achievement data table storage is stored to individual
Unit, so that each storage unit be made only to store a dimension achievement data table.
Data inquiry module 404, for from the dimension achievement data table of acquisition, inquiring under corresponding target dimension this extremely
Few corresponding data of a target indicator.
Optionally, referring to Figure 5, device provided by the present application can also include：
First generation module 405 combines mark with the dimension indicator combination for generating correspondingly；
In practical applications, for each dimension indicator combination, corresponding combination parameter can be determined, such as combination mark
Know, combination title and memory cell identification etc., and each of these combination parameter is all unique, so as to according to
Each combination parameter distinguishes different dimension indicator combinations.
Second generation module 406, each dimension and the dimension index group for including using each dimension indicator combination
Corresponding relationship between the combination mark of conjunction, generates dimensional information table；
Optionally, the application can also utilize pair where dimension and its between other combination parameters of dimension indicator combination
It should be related to, generate the dimensional information table including other combination parameters and dimension.As it can be seen that the application includes to the dimensional information table
Content is not construed as limiting.
Third generation module 407, each index and the dimension index group for including using each dimension indicator combination
Corresponding relationship between the combination mark of conjunction, generates indication information table；
Referring to upper table 5, which can use combination mark to characterize between each index and dimension indicator combination
Relationship, of course it is possible to use other combination parameters indicate its corresponding dimension indicator combination, it is generally the case that dimension letter
The combination parameter ceased in table can be identical with the combination parameter in indication information table, but does not limit.
Creation module 408, for according to dimensional information table, indication information table and the combination definition table prestored, creation to be each
The corresponding storage unit of memory cell identification；
Wherein, the combination parameter that combination definition table can use each dimension indicator combination generates, shown in table 2 as above,
However, it is not limited to this.
4th generation module 409, at least one dimension for including using the corresponding dimension indicator combination of storage unit
Under each index data, generate dimension indicator combination dimension achievement data table；
Memory module 410, for storing dimension achievement data table to storage unit.
Wherein, each dimension indicator combination only corresponds to a dimension achievement data table, each dimension achievement data table
Store an individual storage unit.
Based on this, referring to Fig. 6, said combination enquiry module 402 may include
First query unit 4021 determines at least one described target dimension pair for inquiring the dimensional information table prestored
The objective cross mark answered；
Second query unit 4022 is obtained with objective cross mark one by one for inquiring the combination definition table prestored
Corresponding target dimension indicator combination；
Wherein, the combination definition table includes the combination parameter for distinguishing each dimension indicator combination, the combination parameter
Including combining mark, combination title and memory cell identification correspondingly with respective dimensions indicator combination；
Then tables of data obtains module 403 and specifically can be used for carrying out the corresponding storage unit of the memory cell identification of acquisition
Data query obtains the dimension achievement data table of the storage unit storage, and the dimension achievement data table includes corresponding dimension
The data of each index under at least one dimension that degree indicator combination includes.
Optionally, as shown in fig. 7, device provided by the present application can also include：
Storage request obtains module 411, and for obtaining data storage request, the data storage request carries number to be stored
According to affiliated index and dimension；
Inquiry judging module 412 inquires the dimensional information table and the indication information table, judges the data to be stored
Affiliated index and dimension whether there is；
First update module 413, it is described wait deposit for determining in the presence of the judging result of the inquiry judging module is
The affiliated index of data and the corresponding dimension indicator combination of dimension are stored up, and updates the dimension index group using the data to be stored
Close corresponding dimension achievement data table；
Second update module 414, in the absence of the judging result of the inquiry judging module is, by described wait deposit
Store up dimension belonging to data and the index dimension indicator combination new as one, define and sequentially added in table in the combination described in
Combination mark, the combination title and memory cell identification of new dimension indicator combination, and update the dimensional information table and
The indication information table.
In conclusion in the present embodiment, by obtaining multiple dimension index groups for the dimension of data and indexing group
It closes, and a dimension achievement data list is generated to each dimension indicator combination and is solely stored, and be only used to deposit respective dimensions and refer to
The dimension and the corresponding data of index that mark combination includes.In this way, at least in the case where determination needs to inquire some or multiple dimensions
When the data of one index, it is only necessary to find corresponding dimension achievement data table, it will be able to quickly find required data.
As it can be seen that the data volume of data query is only related with the dimension that the dimension indicator combination includes, and it is unrelated with other dimensions, greatly reduce
Data volume, improves efficiency data query.
Referring to Fig. 8, the embodiment of the invention also provides a kind of hardware structural diagram of the inquiry unit of multi-dimensional data,
May include：Processor 81, memory 82, communication interface 83 and communication bus 84 etc..Wherein, processor 81, memory 82
And communication interface 83 can be connected by communication bus 84.
Memory 82 can store above-mentioned from from the inquiry unit embodiment for the multi-dimensional data that function structure describes
The program of each functional module is read corresponding program from the memory 82 by processor 81 and is executed, to realize that data are deposited
The functions such as storage and inquiry.
In the present embodiment, memory 82 may include the non-volatile memory in computer-readable medium, deposit at random
The forms such as access to memory (RAM) and/or Nonvolatile memory, such as read-only memory (ROM) or flash memory (flash RAM), storage
Device includes at least one storage chip.
Processor 81 can be central processor CPU etc., may include kernel, be gone in memory 82 to transfer phase by kernel
The program answered.Wherein, one or more can be set in kernel, divides by adjusting kernel parameter to realize data storage and inquire
Analysis etc., specific implementation process is referred to the description of above method embodiment corresponding part, and details are not described herein for the present embodiment.
The present invention also provides a kind of computer program products, can execute the program code of following method and step：
Obtain the data inquiry request for inquiring at least one target indicator corresponding data under at least one target dimension；
It inquires the dimensional information table prestored and combines definition table, where at least one determining described target dimension at least
One target dimension indicator combination；
It obtains prestoring with the one-to-one dimension achievement data table of at least one target dimension indicator combination；
From the dimension achievement data table of acquisition, it is corresponding to inquire at least one described target indicator under corresponding target dimension
Data.
To sum up, data processing scheme provided by the invention provides a kind of new data store organisation, is deposited based on the data
Storage structure, in the data query method of proposition, the data volume of inquiry only with dimension indicator combination where the dimension of inquired data
The number of dimensions for including is related, unrelated with other dimensions, substantially increases efficiency data query, and avoid number of dimensions and increase
Afterwards, to the adverse effect of data query performance.
It should be understood by those skilled in the art that, the embodiment of the present invention can provide as method, apparatus or computer program
Product.Therefore, complete hardware embodiment, complete software embodiment or reality combining software and hardware aspects can be used in the present invention
Apply the form of example.Moreover, it wherein includes the computer of computer usable program code that the present invention, which can be used in one or more,
The computer program implemented in usable storage medium (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.) produces
The form of product.
The present invention be referring to according to the method for the embodiment of the present invention, the flow chart of device and computer program product and/or
Block diagram describes.It should be understood that each process that can be realized by computer program instructions in flowchart and/or the block diagram and/or
The combination of process and/or box in box and flowchart and/or the block diagram.It can provide these computer program instructions to arrive
General purpose computer, special purpose computer, Embedded Processor or other programmable data processing devices processor to generate one
Machine, so that being generated by the instruction that computer or the processor of other programmable data processing devices execute for realizing flowing
The device for the function of being specified in journey figure one process or multiple processes and/or block diagrams one box or multiple boxes.
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 Jie
The example of matter.
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.
The above is only the embodiment of the present invention, are not intended to restrict the invention.To those skilled in the art,
The invention may be variously modified and varied.It is all within the spirit and principles of the present invention made by any modification, equivalent replacement,
Improve etc., it should be included within scope of the presently claimed invention.
Claims (10)
1. a kind of querying method of multi-dimensional data, which is characterized in that the method includes：
Obtain the data inquiry request for inquiring at least one target indicator corresponding data under at least one target dimension；
The dimensional information table prestored and combination definition table are inquired, to determine at least one where at least one described target dimension
A target dimension indicator combination；
It obtains prestoring with the one-to-one dimension achievement data table of at least one target dimension indicator combination；
From the dimension achievement data table of acquisition, the corresponding number of at least one described target indicator under corresponding target dimension is inquired
According to.
2. the method according to claim 1, wherein the method also includes：
It generates and combines mark correspondingly with the dimension indicator combination；
Pair between each dimension for including using dimension indicator combination described in each and the combination mark of the dimension indicator combination
It should be related to, generate the dimensional information table.
3. according to the method described in claim 2, it is characterized in that, described inquire the dimensional information table prestored and combination definition
Table, to determine at least one target dimension indicator combination where at least one described target dimension, including：
The dimensional information table prestored is inquired, to determine the corresponding objective cross mark of at least one described target dimension；
The combination definition table prestored is inquired, identifies one-to-one target dimension indicator combination with the objective cross to obtain,
The combination definition table includes combination parameter for distinguishing each dimension indicator combination, and the combination parameter includes and respective dimensions
Indicator combination combines mark, combination title and memory cell identification correspondingly；
The one-to-one dimension achievement data table of at least one target dimension indicator combination that the acquisition prestores, including：
Data query is carried out to the corresponding storage unit of the memory cell identification of acquisition, obtains the dimension of the storage unit storage
Achievement data table, the dimension achievement data table include each index under at least one dimension that corresponding dimension indicator combination includes
Data.
4. according to the method described in claim 2, it is characterized in that, the method also includes：
Pair between each index for including using dimension indicator combination described in each and the combination mark of the dimension indicator combination
It should be related to, generate indication information table；
According to the dimensional information table, the indication information table and the combination definition table prestored, each memory cell identification is created
Corresponding storage unit；
At least one dimension and at least one index for including using the corresponding dimension indicator combination of the storage unit generate
The dimension achievement data table of the dimension indicator combination；
The dimension achievement data table is stored to the storage unit.
5. according to the method described in claim 4, it is characterized in that, the method also includes：
Data storage request is obtained, the data storage request carries index and dimension belonging to data to be stored；
The dimensional information table and the indication information table are inquired, judges whether are index belonging to the data to be stored and dimension
In the presence of；
If it does, determining the affiliated index of the data to be stored and the corresponding dimension indicator combination of dimension, and by described wait deposit
Storage data are stored to dimension achievement data table corresponding with the determining dimension indicator combination；
If it does not, the dimension indicator combination that dimension belonging to the data to be stored and index is new as one, in institute
State combination mark, combination title and the storage unit mark that the new dimension indicator combination is sequentially added in combination definition table
Know, and updates the dimensional information table and the indication information table.
6. a kind of inquiry unit of multi-dimensional data, which is characterized in that described device includes：
Inquiry request obtains module, inquires at least one target indicator corresponding data under at least one target dimension for obtaining
Data inquiry request；
Query composition module, for inquiring the dimensional information table prestored and combination definition table, to determine at least one described mesh
At least one target dimension indicator combination where marking dimension；
Tables of data obtain module, for obtain prestore described at least one one-to-one dimension of target dimension indicator combination refer to
Mark tables of data；
Data inquiry module, for from the dimension achievement data table of acquisition, inquiring described at least one under corresponding target dimension
The corresponding data of a target indicator.
7. device according to claim 6, which is characterized in that described device further includes：
First generation module combines mark with the dimension indicator combination for generating correspondingly；
Second generation module, each dimension and the dimension indicator combination for including using dimension indicator combination described in each
Corresponding relationship between combination mark, generates the dimensional information table.
8. device according to claim 7, which is characterized in that the query composition module includes：
First query unit, for inquiring the dimensional information table prestored, to determine the corresponding mesh of at least one described target dimension
Mark combination mark；
Second query unit, it is one-to-one with objective cross mark to obtain for inquiring the combination definition table prestored
Target dimension indicator combination, the combination definition table include the combination parameter for distinguishing each dimension indicator combination, the combination
Parameter includes combining mark, combination title and memory cell identification correspondingly with respective dimensions indicator combination；
The tables of data obtains module, looks into specifically for carrying out data to the corresponding storage unit of the memory cell identification of acquisition
It askes, obtains the dimension achievement data table of the storage unit storage, the dimension achievement data table includes corresponding dimension index
The data of each index under at least one dimension that combination includes.
9. device according to claim 7, which is characterized in that described device further includes：
Third generation module, each index and the dimension indicator combination for including using dimension indicator combination described in each
Corresponding relationship between combination mark, generates indication information table；
Creation module, for according to the dimensional information table, the indication information table and the combination definition table prestored, creation to be each
The corresponding storage unit of memory cell identification；
4th generation module, it is each under at least one dimension for including using the corresponding dimension indicator combination of the storage unit
The data of index generate the dimension achievement data table of the dimension indicator combination；
Memory module, for storing the dimension achievement data table to the storage unit.
10. device according to claim 9, which is characterized in that described device further includes：
Storage request obtains module, and for obtaining data storage request, the data storage request is carried belonging to data to be stored
Index and dimension；
Inquiry judging module is inquired the dimensional information table and the indication information table, is judged belonging to the data to be stored
Index and dimension whether there is；
First update module, for determining the data to be stored in the presence of judging result of the inquiry judging module is
Affiliated index and the corresponding dimension indicator combination of dimension, and update the dimension indicator combination using the data to be stored and correspond to
Dimension achievement data table；
Second update module, in the absence of the judging result of the inquiry judging module is, by the data to be stored
The affiliated dimension and index dimension indicator combination new as one sequentially adds the new dimension in the combination definition table
Combination mark, combination title and the memory cell identification of indicator combination are spent, and updates the dimensional information table and the finger
Mark information table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710379694.8A CN108932257B (en) | 2017-05-25 | 2017-05-25 | Multi-dimensional data query method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710379694.8A CN108932257B (en) | 2017-05-25 | 2017-05-25 | Multi-dimensional data query method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108932257A true CN108932257A (en) | 2018-12-04 |
| CN108932257B CN108932257B (en) | 2021-10-08 |
Family
ID=64450587
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710379694.8A Active CN108932257B (en) | 2017-05-25 | 2017-05-25 | Multi-dimensional data query method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108932257B (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109614402A (en) * | 2018-12-11 | 2019-04-12 | 北京京东金融科技控股有限公司 | Multidimensional data query method and device |
| CN109635075A (en) * | 2018-12-11 | 2019-04-16 | 广州市西美信息科技有限公司 | A kind of content of text draws the method and device of word mark |
| CN109783585A (en) * | 2018-12-27 | 2019-05-21 | 益萃网络科技（中国）有限公司 | Multidimensional data rendering method, device, computer equipment and readable storage medium storing program for executing |
| CN109902100A (en) * | 2019-01-31 | 2019-06-18 | 平安科技（深圳）有限公司 | Report form inquiring method, device and storage medium |
| CN109947838A (en) * | 2019-03-26 | 2019-06-28 | 中国联合网络通信集团有限公司 | A kind of method and device of storing data |
| CN110413634A (en) * | 2019-06-27 | 2019-11-05 | 北京奇艺世纪科技有限公司 | Data query method, system, device and computer readable storage medium |
| CN112559914A (en) * | 2020-12-21 | 2021-03-26 | 北京搜房科技发展有限公司 | Index data display method and device |
| CN112632061A (en) * | 2020-12-03 | 2021-04-09 | 海腾保险代理有限公司 | Multidimensional data storage method and device |
| CN113393190A (en) * | 2021-06-10 | 2021-09-14 | 北京京东振世信息技术有限公司 | Storage information processing method and device, electronic equipment and readable medium |
| CN113782162A (en) * | 2021-03-26 | 2021-12-10 | 北京京东拓先科技有限公司 | Method, device, equipment and storage medium for allocating inquiry fee |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2010087782A2 (en) * | 2009-01-31 | 2010-08-05 | Eng Lee Soh | Dynamic multidimensional knowledge clustering, management and representation system |
| CN106528787A (en) * | 2016-11-09 | 2017-03-22 | 合网络技术（北京）有限公司 | Mass data multi-dimensional analysis-based query method and device |
| CN106557498A (en) * | 2015-09-25 | 2017-04-05 | 北京国双科技有限公司 | Date storage method and device and data query method and apparatus |
| CN106682180A (en) * | 2016-12-29 | 2017-05-17 | 广州华多网络科技有限公司 | Data inquiry method and device |
-
2017
- 2017-05-25 CN CN201710379694.8A patent/CN108932257B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2010087782A2 (en) * | 2009-01-31 | 2010-08-05 | Eng Lee Soh | Dynamic multidimensional knowledge clustering, management and representation system |
| CN106557498A (en) * | 2015-09-25 | 2017-04-05 | 北京国双科技有限公司 | Date storage method and device and data query method and apparatus |
| CN106528787A (en) * | 2016-11-09 | 2017-03-22 | 合网络技术（北京）有限公司 | Mass data multi-dimensional analysis-based query method and device |
| CN106682180A (en) * | 2016-12-29 | 2017-05-17 | 广州华多网络科技有限公司 | Data inquiry method and device |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109614402B (en) * | 2018-12-11 | 2020-09-29 | 京东数字科技控股有限公司 | Multidimensional data query method and device |
| CN109635075A (en) * | 2018-12-11 | 2019-04-16 | 广州市西美信息科技有限公司 | A kind of content of text draws the method and device of word mark |
| CN109614402A (en) * | 2018-12-11 | 2019-04-12 | 北京京东金融科技控股有限公司 | Multidimensional data query method and device |
| CN109783585A (en) * | 2018-12-27 | 2019-05-21 | 益萃网络科技（中国）有限公司 | Multidimensional data rendering method, device, computer equipment and readable storage medium storing program for executing |
| CN109902100A (en) * | 2019-01-31 | 2019-06-18 | 平安科技（深圳）有限公司 | Report form inquiring method, device and storage medium |
| CN109947838A (en) * | 2019-03-26 | 2019-06-28 | 中国联合网络通信集团有限公司 | A kind of method and device of storing data |
| CN110413634A (en) * | 2019-06-27 | 2019-11-05 | 北京奇艺世纪科技有限公司 | Data query method, system, device and computer readable storage medium |
| CN110413634B (en) * | 2019-06-27 | 2022-03-29 | 北京奇艺世纪科技有限公司 | Data query method, system, device and computer readable storage medium |
| CN112632061A (en) * | 2020-12-03 | 2021-04-09 | 海腾保险代理有限公司 | Multidimensional data storage method and device |
| CN112559914A (en) * | 2020-12-21 | 2021-03-26 | 北京搜房科技发展有限公司 | Index data display method and device |
| CN113782162A (en) * | 2021-03-26 | 2021-12-10 | 北京京东拓先科技有限公司 | Method, device, equipment and storage medium for allocating inquiry fee |
| CN113393190A (en) * | 2021-06-10 | 2021-09-14 | 北京京东振世信息技术有限公司 | Storage information processing method and device, electronic equipment and readable medium |
| CN113393190B (en) * | 2021-06-10 | 2023-12-05 | 北京京东振世信息技术有限公司 | Warehouse information processing method and device, electronic equipment and readable medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108932257B (en) | 2021-10-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108932257A (en) | The querying method and device of multi-dimensional data | |
| CN106970958B (en) | A kind of inquiry of stream file and storage method and device | |
| CN108572991A (en) | Data base processing method, device and storage medium | |
| US11429636B2 (en) | Smart elastic scaling based on application scenarios | |
| CN110413634A (en) | Data query method, system, device and computer readable storage medium | |
| CN105550270B (en) | Data base query method and device | |
| CN108959510B (en) | Partition level connection method and device for distributed database | |
| CN106326309A (en) | Data query method and device | |
| CN108153776A (en) | Data query method and device | |
| CN111813804A (en) | Data query method and device, electronic equipment and storage medium | |
| US20140019454A1 (en) | Systems and Methods for Caching Data Object Identifiers | |
| CN108647235A (en) | A kind of data analysing method, equipment and medium based on data warehouse | |
| CN108021333A (en) | The system of random read-write data, device and method | |
| CN115048254B (en) | Simulation test method, system, equipment and readable medium for data distribution strategy | |
| CN105468644A (en) | Method and device for performing query in database | |
| CN109471874A (en) | Data analysis method, device and storage medium | |
| CN110457182A (en) | A kind of load balancing cluster example operating index monitoring system | |
| CN108399175A (en) | A kind of storage of data, querying method and its device | |
| CN113810234A (en) | Micro-service link topology processing method and device and readable storage medium | |
| US9852166B2 (en) | Task handling in a multisystem environment | |
| US11645283B2 (en) | Predictive query processing | |
| CN107453950A (en) | A kind of information processing method and monitoring system | |
| US20220292077A1 (en) | Scalable interactive data collection system | |
| CN109960695B (en) | Management method and device for database in cloud computing system | |
| CN112052330B (en) | Application keyword distribution method and device |
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 | ||
| CB02 | Change of applicant information |
Address after: 100080 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing Applicant after: Beijing Guoshuang Technology Co.,Ltd. Address before: 100086 Cuigong Hotel, 76 Zhichun Road, Shuangyushu District, Haidian District, Beijing Applicant before: Beijing Guoshuang Technology Co.,Ltd. |
|
| CB02 | Change of applicant information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |