CN108664560A - Data query method, apparatus, computer equipment and computer readable storage medium - Google Patents
Data query method, apparatus, computer equipment and computer readable storage medium Download PDFInfo
- Publication number
- CN108664560A CN108664560A CN201810309444.1A CN201810309444A CN108664560A CN 108664560 A CN108664560 A CN 108664560A CN 201810309444 A CN201810309444 A CN 201810309444A CN 108664560 A CN108664560 A CN 108664560A
- Authority
- CN
- China
- Prior art keywords
- data query
- line analytical
- inquiry
- dimension
- relationship type
- 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
An embodiment of the present invention provides a kind of data query method, apparatus, computer equipment and computer readable storage mediums, wherein this method includes：Receive data query requirements；According to the characteristic of the requested inquiry of the data query requirements, a kind of querying method to match with the characteristic is selected in relationship type on-line analytical processing method and Multi-dimension on-line analytical process method；Data query is carried out according to the data query requirements using the querying method of selection.The program can be directed to different data query demand and advantageous querying method is selected to be inquired, and be conducive to provide faster inquiry velocity, meanwhile, be conducive to freely inquiring between high latitude data and possibility is provided.
Description
Technical field
The present invention relates to data mining technology field, more particularly to a kind of data query method, apparatus, computer equipment and
Computer readable storage medium.
Background technology
Commercial enterprise generally requires to look into face of hundreds of dimension and flexible data during data mining
It askes, meanwhile, index one of of the inquiry velocity as important measurement data digging system is also established data as each enterprise and is dug
Dig system core Consideration.The two different methods progress data mining work of available data digging system generally use, one
Kind is ROLAP, and one kind is MOLAP.
ROLAP is the data digging method based on relational data (bivariate table), and this method is with dimension table and thing
Real table organization's model provides relatively wide in range possibility for inquiry, and has great advantage in search space complexity,
And model is more flexible.But with being continuously increased for data, the complexity of inquiry may be caused costly, the response time compared with
Slowly, the intersection inquiry between especially more analysis themes may cause system burden overweight.
MOLAP is the business intelligence information tissue based on Cube forms, is showed on search efficiency abnormal prominent.But
Because this method is the business intelligence information tissue based on Cube forms, it is very easy to cause to store on memory space quick-fried
Fried, that is, the complexity stored is increased with exponential form.The generation of Cube simultaneously needs a large amount of calculation amount, especially face dimension compared with
For high model, the generation of Cube needs a large amount of time.
Invention content
An embodiment of the present invention provides a kind of data query methods, slow, high to solve data query speed in the prior art
The technical issues of inquiry is by limitation between latitude data.This method includes：
Receive data query requirements；
According to the characteristic of the requested inquiry of the data query requirements, in relationship type on-line analytical processing method and multidimensional
A kind of querying method to match with the characteristic is selected in on-line analytical processing method；
Data query is carried out according to the data query requirements using the querying method of selection.
The embodiment of the present invention additionally provides a kind of computer equipment, including memory, processor and storage are on a memory
And the computer program that can be run on a processor, the processor realize above-mentioned arbitrary number when executing the computer program
According to querying method.To solve the technical issues of data query speed is slowly, inquiry is by limitation between high latitude data in the prior art.
The embodiment of the present invention additionally provides a kind of computer readable storage medium, the computer-readable recording medium storage
There is the computer program for executing above-mentioned arbitrary data query method.To solve, data query speed in the prior art is slow, high latitude
The technical issues of inquiry is by limitation between degrees of data.
The embodiment of the present invention additionally provides a kind of data query arrangement, with solve data query speed in the prior art it is slow,
The technical issues of inquiry is by limitation between high latitude data.The device includes：
Demand receiving module, for receiving data query requirements；
Selecting module, for the characteristic according to the requested inquiry of the data query requirements, in relationship type on-line analysis
A kind of querying method to match with the characteristic is selected in processing method and Multi-dimension on-line analytical process method；
Enquiry module carries out data query for the querying method using selection according to the data query requirements.
In embodiments of the present invention, for each data query requirements, according to the requested inquiry of data query requirements
Characteristic selects one kind to match with the characteristic in relationship type on-line analytical processing method and Multi-dimension on-line analytical process method
Querying method, for example, for according to the characteristic of the requested inquiry of data query requirements, in relationship type on-line analytical processing side
A kind of querying method advantageously handling above-mentioned inquiry relatively is selected in method and Multi-dimension on-line analytical process method, and then is used
The querying method of selection carries out data query so that can with active balance ROLAP (relationship type on-line analytical processing method) and
The Pros and Cons of MOLAP (Multi-dimension on-line analytical process method) select advantageous inquiry for different data query demand
Method is inquired, and in the case where data mining has certain application model and scene mode, is conducive to provide and is looked into faster
Speed is ask, meanwhile, be conducive to freely inquiring between high latitude data and possibility is provided.
Description of the drawings
Attached drawing described herein is used to provide further understanding of the present invention, and is constituted part of this application, not
Constitute limitation of the invention.In the accompanying drawings：
Fig. 1 is a kind of flow chart of data query method provided in an embodiment of the present invention；
Fig. 2 is a kind of structure diagram of data query arrangement provided in an embodiment of the present invention.
Specific implementation mode
To make the objectives, technical solutions, and advantages of the present invention clearer, right with reference to embodiment and attached drawing
The present invention is described in further details.Here, the exemplary embodiment and its explanation of the present invention be for explaining the present invention, but simultaneously
It is not as a limitation of the invention.
In embodiments of the present invention, a kind of data query method is provided, as shown in Figure 1, this method includes：
Step 101：Receive data query requirements；
Step 102：According to the characteristic of the requested inquiry of the data query requirements, in relationship type on-line analytical processing side
A kind of querying method to match with the characteristic is selected in method and Multi-dimension on-line analytical process method；
Step 103：Data query is carried out according to the data query requirements using the querying method of selection.
Flow as shown in Figure 1 according to data it is found that in embodiments of the present invention, for each data query requirements, look into
The characteristic of the requested inquiry of inquiry demand selects in relationship type on-line analytical processing method and Multi-dimension on-line analytical process method
A kind of querying method to match with the characteristic, for example, for the characteristic according to the requested inquiry of data query requirements,
One kind is selected advantageously to handle above-mentioned look into relatively in relationship type on-line analytical processing method and Multi-dimension on-line analytical process method
The querying method of inquiry, and then data query is carried out using the querying method of selection so that it can be with active balance ROLAP (relationships
Type on-line analytical processing method) and MOLAP (Multi-dimension on-line analytical process method) Pros and Cons, for different data inquire
Demand selects advantageous querying method to be inquired, and has the case where certain application model and scene mode in data mining
Under, it is conducive to provide faster inquiry velocity, meanwhile, be conducive to freely inquiring between high latitude data and possibility is provided.
When it is implemented, can be by following two modes in relationship type on-line analytical processing method and multidimensional on-line analysis
A kind of querying method to match with the characteristic is selected in processing method.
For example, first way is：The data query requirements are parsed, get parms information, wherein the parameter information
Indicate the characteristic of the requested inquiry of the data query requirements；Then, based on the parameter information in relationship type on-line analysis
A kind of querying method to match with the characteristic is selected in processing method and Multi-dimension on-line analytical process method.
Specifically, when the Multi-dimension on-line analytical process method supports the calculating of the parameter information, select described more
It ties up on-line analytical processing method and carries out data query according to the data query requirements；Otherwise, online point of the relationship type is selected
It analyses processing method and carries out data query according to the data query requirements, wherein the parameter information includes query result displaying
Dimension and index, participate in filtering dimension and participate in polymerization dimension and index.The parameter information can be by independent member
Data management system manages.
The second way is：It is equal in the relationship type on-line analytical processing method and the Multi-dimension on-line analytical process method
When supporting the inquiry of the data query requirements, for the requested inquiry of the data query requirements, institute is respectively adopted in calculating
It states relationship type on-line analytical processing method and the Multi-dimension on-line analytical process method handles the respective required cost of the inquiry,
Then, it according to the size of required cost, is selected in relationship type on-line analytical processing method and Multi-dimension on-line analytical process method
A kind of querying method to match with the characteristic.
Specifically, can be more than in the cost handled needed for the inquiry using the relationship type on-line analytical processing method
When handling 2 times of the cost needed for the inquiry using the Multi-dimension on-line analytical process method, online point of the multidimensional is selected
Processing method is analysed to handle above-mentioned inquiry.
When it is implemented, can calculate by the following method be respectively adopted the relationship type on-line analytical processing method and
The Multi-dimension on-line analytical process method handles the respective required cost of the inquiry.
It is handled needed for the inquiry using the relationship type on-line analytical processing method for example, being calculated by the following formula
Cost：
A=query times * (CPU elapsed times+period of reservation of number)
Wherein, A is the cost handled using the relationship type on-line analytical processing method needed for the inquiry；Query time
It is the query time handled using the relationship type on-line analytical processing method needed for the inquiry；CPU elapsed times are to use
When the relationship type on-line analytical processing method handles the inquiry the time required to CPU；Period of reservation of number is to use the pass
It is the time that type on-line analytical processing method handles that user's needs of the inquiry foregoing description inquiry wait for；
It is calculated by the following formula the cost handled using the Multi-dimension on-line analytical process method needed for the inquiry：
B=storage times+generated time
Wherein, B is the cost handled using the Multi-dimension on-line analytical process method needed for the inquiry；Storage time is
Time when handling the inquiry using the Multi-dimension on-line analytical process method needed for storage interrogation model；Generated time uses
The Multi-dimension on-line analytical process method handles the time generated when the inquiry needed for interrogation model.
When it is implemented, it is currency list that can all convert the corresponding cost of above two querying method being calculated
Position can calculate price, for example, personnel attrition is calculated with 10 times of CPU times according to mainstream cloud computing platform.
When it is implemented, when computationally stating the corresponding cost of two kinds of querying methods, historical query information (example can be based on
Such as, the Query Information in past 60 days) come obtain query time involved by above-mentioned inquiry, CPU elapsed times, user wait for when
Between, the parameters such as storage time and generated time, and then calculate cost based on these parameters.
When it is implemented, in order to effectively safeguard that capacity that MOLAP is safeguarded and initialization calculate intensity, in MOLAP
CUBE, which should do the best, safeguards the number of dimensions of total number and list CUBE, wherein number of dimensions safeguarded via Capacity Cost, CUBE
Sum is modeled to determine originally by 0.8 times of ROLAP in 30 days in the above cost calculation, and the simulated cost by inquiring in history
Inquiry in ROLAP is at original average acquisition.
When it is implemented, in actual use, MOLAP will meet with cold start-up situation, i.e. MOLAP will in initialization
Not comprising any data query model, for this purpose, according to actual needs, it can be in advance by some prefabricated data of analyst in MOLAP
Interrogation model, in this, as a component part of initialization.A priori scene is provided to improve subsequent search efficiency.
When it is implemented, the process of data query is carried out according to the data query requirements in the querying method using selection
In, inquiry log is collected, that is, inquiring used latitude and the information such as index and elapsed time will be recorded, and be looked into analyze
It askes, following modelling can also be optimized according to inquiry log.
It is inputted when it is implemented, the data query requirements can be realized by sql like language, i.e., above-mentioned data query method
It supports to use sql like language input data query demand.
The example of above-mentioned data query method below, MOLAP by taking Elastic Search are realized as an example, ROLAP with
For Redshift in Amazon Webservice is realized, which includes the following steps：
1) after receiving data query requirements, data query requirements are recorded；
2) by data query requirements objectification, extraction query result needs the dimension shown and index, needs to participate in filtering
Dimension and need participate in polymerization dimension and index；
3) dimension of acquisition and index are combined and is compared with the dimension that has in MOLAP, deposited in MOLAP with confirming
There are the dimension of acquisition and the possibility of index；
If 4) dimension and index that obtain are present in MOLAP, are handled in MOLAP and inquire and obtain result；
If 5) dimension and index obtained is not present in MOLAP, client is notified, and inquiry is handled in ROLAP；
If 6) dimension and index obtained is present in MOLAP and ROLAP also supports the data query requirements, calculating should
Inquiry handles respectively required cost respectively in ROLAP and in MOLAP；
7) it is handled needed for the data query requirements more than MOLAP when ROLAP handles the cost needed for the data query requirements
2 times of cost when, select MOLAP to handle the data query requirements.
A kind of computer equipment is additionally provided in the present embodiment, including memory, processor and storage are on a memory
And the computer program that can be run on a processor, the processor realize above-mentioned arbitrary number when executing the computer program
According to querying method.
A kind of computer readable storage medium, the computer-readable recording medium storage are additionally provided in the present embodiment
There is the computer program for executing above-mentioned arbitrary data query method.
Based on same inventive concept, a kind of data query arrangement is additionally provided in the embodiment of the present invention, such as following implementation
Described in example.Since the principle that data query arrangement solves the problems, such as is similar to data query method, the reality of data query arrangement
The implementation that may refer to data query method is applied, overlaps will not be repeated.It is used below, term " unit " or " mould
The combination of the software and/or hardware of predetermined function may be implemented in block ".Although device described in following embodiment is preferably with soft
Part is realized, but the realization of the combination of hardware or software and hardware is also that may and be contemplated.
Fig. 2 is a kind of structure diagram of the data query arrangement of the embodiment of the present invention, as shown in Fig. 2, the device includes：
Demand receiving module 201, for receiving data query requirements；
Selecting module 202, for according to the characteristic of the requested inquiry of the data query requirements, in online point of relationship type
A kind of querying method to match with the characteristic is selected in analysis processing method and Multi-dimension on-line analytical process method；
Enquiry module 203 carries out data query for the querying method using selection according to the data query requirements.
In one embodiment, above-mentioned selecting module, including：
Resolution unit, for parsing the data query requirements, get parms information, wherein the parameter information indicates
The characteristic of the requested inquiry of data query requirements；
First selecting unit, for information based on the parameter in online point of relationship type on-line analytical processing method and multidimensional
A kind of querying method to match with the characteristic is selected in analysis processing method.
In one embodiment, first selecting unit is specifically used for supporting institute in the Multi-dimension on-line analytical process method
When stating the calculating of parameter information, selects the Multi-dimension on-line analytical process method to carry out data according to the data query requirements and look into
It askes；Otherwise, the relationship type on-line analytical processing method is selected to carry out data query according to the data query requirements, wherein
The parameter information includes the dimension and refer to that dimension and index, the dimension of participation filtering and participation of query result displaying polymerize
Mark.
In one embodiment, above-mentioned selecting module, including：
Computing unit, for equal in the relationship type on-line analytical processing method and the Multi-dimension on-line analytical process method
When supporting the inquiry of the data query requirements, for the requested inquiry of the data query requirements, institute is respectively adopted in calculating
It states relationship type on-line analytical processing method and the Multi-dimension on-line analytical process method handles the respective required cost of the inquiry；
Second selecting unit joins for the size according to required cost in relationship type on-line analytical processing method and multidimensional
A kind of querying method to match with the characteristic is selected in machine analysis and processing method.
In one embodiment, the second selecting unit is specifically used for using the relationship type on-line analytical processing method
It handles the cost needed for the inquiry and is more than the cost handled using the Multi-dimension on-line analytical process method needed for the inquiry
2 times when, select the Multi-dimension on-line analytical process method.
In one embodiment, computing unit is specifically used for, and is calculated by the following formula using online point of the relationship type
Analysis processing method handles the cost needed for the inquiry：
A=query times * (CPU elapsed times+period of reservation of number)
Wherein, A is the cost handled using the relationship type on-line analytical processing method needed for the inquiry；Query time
It is the query time handled using the relationship type on-line analytical processing method needed for the inquiry；CPU elapsed times are to use
When the relationship type on-line analytical processing method handles the inquiry the time required to CPU；Period of reservation of number is to use the pass
It is the time that type on-line analytical processing method handles that user's needs of the inquiry foregoing description inquiry wait for；
It is calculated by the following formula the cost handled using the Multi-dimension on-line analytical process method needed for the inquiry：
B=storage times+generated time
Wherein, B is the cost handled using the Multi-dimension on-line analytical process method needed for the inquiry；Storage time is
Time when handling the inquiry using the Multi-dimension on-line analytical process method needed for storage interrogation model；Generated time uses
The Multi-dimension on-line analytical process method handles the time generated when the inquiry needed for interrogation model.
In one embodiment, the data query requirements are to realize to input by sql like language.
The embodiment of the present invention realizes following technique effect：In embodiments of the present invention, for each data query requirements,
According to the characteristic of the requested inquiry of data query requirements, in relationship type on-line analytical processing method and Multi-dimension on-line analytical process
A kind of querying method to match with the characteristic is selected in method, for example, for being looked into according to data query requirements are requested
The characteristic of inquiry selects one kind relatively advantageously in relationship type on-line analytical processing method and Multi-dimension on-line analytical process method
The querying method of above-mentioned inquiry is handled, and then data query is carried out using the querying method of selection so that can be with active balance
The Pros and Cons of ROLAP (relationship type on-line analytical processing method) and MOLAP (Multi-dimension on-line analytical process method), for not
It selects advantageous querying method to be inquired with data query requirements, there is certain application model and scene mould in data mining
In the case of formula, it is conducive to provide faster inquiry velocity, meanwhile, being conducive to that freely inquiring between high latitude data provide can
It can property.
Obviously, those skilled in the art should be understood that each module of the above-mentioned embodiment of the present invention or each step can be with
It is realized with general computing device, they can be concentrated on a single computing device, or be distributed in multiple computing devices
On the network formed, optionally, they can be realized with the program code that computing device can perform, it is thus possible to by it
Store and be performed by computing device in the storage device, and in some cases, can be to be held different from sequence herein
The shown or described step of row, either they are fabricated to each integrated circuit modules or will be multiple in them
Module or step are fabricated to single integrated circuit module to realize.In this way, the embodiment of the present invention be not limited to it is any specific hard
Part and software combine.
The foregoing is only a preferred embodiment of the present invention, is not intended to restrict the invention, for the skill of this field
For art personnel, the embodiment of the present invention can have various modifications and variations.All within the spirits and principles of the present invention, made by
Any modification, equivalent substitution, improvement and etc. should all be included in the protection scope of the present invention.
Claims (10)
1. a kind of data query method, which is characterized in that including：
Receive data query requirements；
It is online in relationship type on-line analytical processing method and multidimensional according to the characteristic of the requested inquiry of the data query requirements
A kind of querying method to match with the characteristic is selected in analysis and processing method；
Data query is carried out according to the data query requirements using the querying method of selection.
2. data query method as described in claim 1, which is characterized in that looked into according to the data query requirements are requested
The characteristic of inquiry selects one kind and the characteristic phase in relationship type on-line analytical processing method and Multi-dimension on-line analytical process method
Matched querying method, including：
The data query requirements are parsed, get parms information, wherein the parameter information indicates the data query requirements institute
The characteristic of the inquiry of request；
Information selects one kind in relationship type on-line analytical processing method and Multi-dimension on-line analytical process method based on the parameter
The querying method to match with the characteristic.
3. data query method as claimed in claim 2, which is characterized in that information is in online point of relationship type based on the parameter
A kind of querying method to match with the characteristic is selected in analysis processing method and Multi-dimension on-line analytical process method, including：
When the Multi-dimension on-line analytical process method supports the calculating of the parameter information, select at the multidimensional on-line analysis
Reason method carries out data query according to the data query requirements；Otherwise, the relationship type on-line analytical processing method root is selected
According to the data query requirements carry out data query, wherein the parameter information include query result displaying dimension and index,
It participates in the dimension of filtering and participates in the dimension and index of polymerization.
4. data query method as described in claim 1, which is characterized in that looked into according to the data query requirements are requested
The characteristic of inquiry selects one kind and the characteristic phase in relationship type on-line analytical processing method and Multi-dimension on-line analytical process method
Matched querying method, including：
The data query is supported in the relationship type on-line analytical processing method and the Multi-dimension on-line analytical process method
When the inquiry of demand, for the requested inquiry of the data query requirements, the relationship type on-line analysis is respectively adopted in calculating
Processing method and the Multi-dimension on-line analytical process method handle the respective required cost of the inquiry；
According to the size of required cost, one is selected in relationship type on-line analytical processing method and Multi-dimension on-line analytical process method
The querying method that kind matches with the characteristic.
5. data query method as claimed in claim 4, which is characterized in that according to the size of required cost, join in relationship type
A kind of querying method to match with the characteristic, packet are selected in machine analysis and processing method and Multi-dimension on-line analytical process method
It includes：
It is more than using multidimensional connection handling the cost needed for the inquiry using the relationship type on-line analytical processing method
When machine analysis and processing method handles 2 times of the cost needed for the inquiry, the Multi-dimension on-line analytical process method is selected.
6. data query method as claimed in claim 4, which is characterized in that the relationship type on-line analysis is respectively adopted in calculating
Processing method and the Multi-dimension on-line analytical process method handle the respective required cost of the inquiry, including：
It is calculated by the following formula the cost handled using the relationship type on-line analytical processing method needed for the inquiry：
A=query times * (CPU elapsed times+period of reservation of number)
Wherein, A is the cost handled using the relationship type on-line analytical processing method needed for the inquiry；Query time is to adopt
The query time needed for the inquiry is handled with the relationship type on-line analytical processing method；CPU elapsed times are using described
When relationship type on-line analytical processing method handles the inquiry the time required to CPU；Period of reservation of number is to use the relationship type
The user that on-line analytical processing method handles the inquiry foregoing description inquiry needs the time waited for；
It is calculated by the following formula the cost handled using the Multi-dimension on-line analytical process method needed for the inquiry：
B=storage times+generated time
Wherein, B is the cost handled using the Multi-dimension on-line analytical process method needed for the inquiry；Storage time is to use
Time when the Multi-dimension on-line analytical process method handles the inquiry needed for storage interrogation model；Described in generated time use
Multi-dimension on-line analytical process method handles the time generated when the inquiry needed for interrogation model.
7. such as data query method according to any one of claims 1 to 6, which is characterized in that the data query requirements are
Input is realized by sql like language.
8. a kind of computer equipment, including memory, processor and storage are on a memory and the meter that can run on a processor
Calculation machine program, which is characterized in that the processor is realized when executing the computer program described in any one of claim 1 to 7
Data query method.
9. a kind of computer readable storage medium, which is characterized in that the computer-readable recording medium storage has perform claim
It is required that the computer program of 1 to 7 any one of them data query method.
10. a kind of data query arrangement, which is characterized in that including：
Demand receiving module, for receiving data query requirements；
Selecting module, for the characteristic according to the requested inquiry of the data query requirements, in relationship type on-line analytical processing
A kind of querying method to match with the characteristic is selected in method and Multi-dimension on-line analytical process method；
Enquiry module carries out data query for the querying method using selection according to the data query requirements.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810309444.1A CN108664560A (en) | 2018-04-09 | 2018-04-09 | Data query method, apparatus, computer equipment and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810309444.1A CN108664560A (en) | 2018-04-09 | 2018-04-09 | Data query method, apparatus, computer equipment and computer readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108664560A true CN108664560A (en) | 2018-10-16 |
Family
ID=63783436
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810309444.1A Pending CN108664560A (en) | 2018-04-09 | 2018-04-09 | Data query method, apparatus, computer equipment and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108664560A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1551014A (en) * | 2003-03-28 | 2004-12-01 | Systems and methods for proactive caching utilizing olap variants | |
| CN101120340A (en) * | 2004-02-21 | 2008-02-06 | 数据迅捷股份有限公司 | Ultra-shared-nothing parallel database |
| CN103299299A (en) * | 2010-11-22 | 2013-09-11 | 移动解决方案公司 | Highly adaptable query optimizer search space generation process |
| CN104866580A (en) * | 2015-05-26 | 2015-08-26 | 梁猛 | Method for quickly detecting impact caused by database modification to current service |
-
2018
- 2018-04-09 CN CN201810309444.1A patent/CN108664560A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1551014A (en) * | 2003-03-28 | 2004-12-01 | Systems and methods for proactive caching utilizing olap variants | |
| CN101120340A (en) * | 2004-02-21 | 2008-02-06 | 数据迅捷股份有限公司 | Ultra-shared-nothing parallel database |
| CN103299299A (en) * | 2010-11-22 | 2013-09-11 | 移动解决方案公司 | Highly adaptable query optimizer search space generation process |
| CN104866580A (en) * | 2015-05-26 | 2015-08-26 | 梁猛 | Method for quickly detecting impact caused by database modification to current service |
Non-Patent Citations (2)
| Title |
|---|
| 曹大伟: ""基于数据仓库的电信客户数据分析系统的设计与实现"", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
| 赵艳艳: ""基于Hadoop的联机分析处理系统关键技术研究"", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103999049B (en) | Method and apparatus for predicting virtual machine demand | |
| CN105550323B (en) | Load balance prediction method and prediction analyzer for distributed database | |
| CN103383688B (en) | Memory headroom database for geocoding/geography processing | |
| US10223437B2 (en) | Adaptive data repartitioning and adaptive data replication | |
| CN111639078A (en) | Data query method and device, electronic equipment and readable storage medium | |
| CN105843703A (en) | Extraction of system administrator actions to a workflow providing a resolution to a system issue | |
| CN104937544B (en) | Method, computer-readable medium and computer system for calculating task result | |
| CN107092701A (en) | The data processing method and device of a kind of Multidimensional Data Model | |
| CN106027593B (en) | For dynamically maintaining the method and system of data structure | |
| CN109087121A (en) | Marketing message release platform construction method and device | |
| CN107895038A (en) | A kind of link prediction relation recommends method and device | |
| Gupta et al. | Faster as well as early measurements from big data predictive analytics model | |
| CN107820613A (en) | Database index is recommended and created automatically | |
| CN104866408A (en) | Capacity prediction method and device for application system | |
| Zhao et al. | Graph-based Preconditioning Conjugate Gradient Algorithm for" N-1" Contingency Analysis | |
| CN106250457A (en) | The inquiry processing method of big data platform Materialized View and system | |
| CN101963969A (en) | Method and database server for realizing load balancing in Oracle RAC (Real Application Cluster) system | |
| CN108920281A (en) | Extensive image processing method and system | |
| CN105242873B (en) | The acquisition of the performance data of cloud computing system and storage method and device | |
| CN104573074A (en) | High-speed calculating and analyzing method based on hospital data | |
| Ting et al. | Constructing a cloud computing based social networks data warehousing and analyzing system | |
| Domanski et al. | Applications of heterogeneous computing in computational and simulation science | |
| CN110909072B (en) | Data table establishment method, device and equipment | |
| CN108664560A (en) | Data query method, apparatus, computer equipment and computer readable storage medium | |
| CN107609194B (en) | Cloud computing-oriented storage method for time redundancy power load data |
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 |
Application publication date: 20181016 |
|
| RJ01 | Rejection of invention patent application after publication |