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 PDF

Info

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
Application number
CN201810309444.1A
Other languages
Chinese (zh)
Inventor
田丰
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ningbo Nuo Xin Rui Ju Investment Co Ltd
Original Assignee
Ningbo Nuo Xin Rui Ju Investment Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Ningbo Nuo Xin Rui Ju Investment Co Ltd filed Critical Ningbo Nuo Xin Rui Ju Investment Co Ltd
Priority to CN201810309444.1A priority Critical patent/CN108664560A/en
Publication of CN108664560A publication Critical patent/CN108664560A/en
Pending legal-status Critical Current

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

Data query method, apparatus, computer equipment and computer readable storage medium
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.
CN201810309444.1A 2018-04-09 2018-04-09 Data query method, apparatus, computer equipment and computer readable storage medium Pending CN108664560A (en)

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)

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

Patent Citations (4)

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

* Cited by examiner, † Cited by third party
Title
曹大伟: ""基于数据仓库的电信客户数据分析系统的设计与实现"", 《中国优秀硕士学位论文全文数据库 信息科技辑》 *
赵艳艳: ""基于Hadoop的联机分析处理系统关键技术研究"", 《中国优秀硕士学位论文全文数据库 信息科技辑》 *

Similar Documents

Publication Publication Date Title
CN103999049B (en) Method and apparatus for predicting virtual machine demand
CN103383688B (en) Memory headroom database for geocoding/geography processing
CN103365929B (en) The management method of a kind of data base connection and system
US10223437B2 (en) Adaptive data repartitioning and adaptive data replication
CN109997126A (en) Event-driven is extracted, transformation, loads (ETL) processing
CN111639078A (en) Data query method and device, electronic equipment and readable storage medium
CN103902701B (en) A kind of data-storage system and storage method
CN104937544B (en) Method, computer-readable medium and computer system for calculating task result
CN106027593B (en) For dynamically maintaining the method and system of data structure
CN107092701A (en) The data processing method and device of a kind of Multidimensional Data Model
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

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