CN106897343A - The lookup method of executive plan, storage method and device - Google Patents
The lookup method of executive plan, storage method and device Download PDFInfo
- Publication number
- CN106897343A CN106897343A CN201610576924.5A CN201610576924A CN106897343A CN 106897343 A CN106897343 A CN 106897343A CN 201610576924 A CN201610576924 A CN 201610576924A CN 106897343 A CN106897343 A CN 106897343A
- Authority
- CN
- China
- Prior art keywords
- sql statement
- literal
- constraints
- executive plan
- parametrization
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
- G06F16/24542—Plan optimisation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Operations Research (AREA)
- Devices For Executing Special Programs (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the present application discloses a kind of lookup method of executive plan, storage method and device.The lookup method of the executive plan includes：Receive SQL statement；According to the SQL statement, parametrization SQL statement corresponding with the SQL statement is generated；Executive plan corresponding with the parametrization SQL statement and constraints that lookup is prestored；If finding, judge whether the parameter corresponding with the constraints in the parametrization SQL statement meets the constraints；If meeting, the executive plan that will be inquired is defined as pending executive plan.The embodiment of the present application can avoid carrying out SQL statement during executive plan is searched the parsing of semanteme, so that the time loss that the search procedure for reducing above-mentioned executive plan is brought, lifts the performance of Database Systems.
Description
Technical field
The application is related to database technical field, more particularly to a kind of lookup method of executive plan, storage method and dress
Put.
Background technology
Generally, the access of database can be by SQL (Structured Query Language, structuralized query language
Speech) realize.Usually, Database Systems are needed according to SQL statement corresponding with the task of access, and how formulation reaches the visit
The implementation procedure of the purpose of task is asked, this process is referred to as " executive plan " (execution plan), and " executive plan " is
One can be used to be performed return to the program example of the result desired by user.
In the prior art, the process for generating executive plan corresponding with SQL statement is generally comprised：First, SQL statement is entered
The parsing of row morphology/grammer, then, the parsing of semanteme is carried out to SQL statement, and based on the principle of optimality, determines optimal to perform meter
Draw, finally, generate the code with above-mentioned optimal execution plan.When certain because the process of above-mentioned generation executive plan can consume
Between, this has influence on the performance of database to a certain extent.In view of this, a solution of the prior art is " plan
Caching " (plan cache).Wherein, some executive plans that will be previously generated are stored, to form " program cache ".It is based on
" program cache ", Database Systems just can be inquired about and worked as from above-mentioned " program cache " after each SQL statement is received
The corresponding executive plan of preceding SQL statement, if inquiring, the access that database is performed according to the executive plan for inquiring is appointed
Business；If not inquiring, plan is generated according to the process of above-mentioned generation executive plan.Due to compared to generation and SQL languages
The process of the corresponding executive plan of sentence, the time from " program cache " consumed in the process of query execution plan is shorter, can be with
Lift the performance of database.
In the above prior art, generally during lookup executive plan corresponding with SQL statement, including to SQL
The step of sentence carries out the parsing of semanteme.However, when the step of parsing of semanteme is carried out to SQL statement need to typically consume certain
Between, this can cause the performance of Database Systems not good.
The content of the invention
The purpose of the embodiment of the present application is to provide a kind of lookup method of executive plan, storage method and device, to solve
Problems of the prior art.
In order to solve the above technical problems, the lookup method of the executive plan of the embodiment of the present application offer, storage method and dress
Put what is be realized in：
A kind of lookup method of executive plan, including：
Receive SQL statement；
According to the SQL statement, parametrization SQL statement corresponding with the SQL statement is generated；The parametrization SQL languages
Sentence includes parameter corresponding with the literal of the SQL statement；
Executive plan corresponding with the parametrization SQL statement and constraints that lookup is prestored；
If finding, judge whether the parameter corresponding with the constraints in the parametrization SQL statement meets institute
State constraints；If meeting, the executive plan that will be inquired is defined as pending executive plan.
A kind of storage method of executive plan, including：
Receive SQL statement；
Generation executive plan corresponding with the SQL statement；
According to the SQL statement, corresponding with the SQL statement parametrization SQL statement and constraints are generated；
The executive plan is mapped and by the executive plan and the constraint with the parametrization SQL statement
Condition is mapped and is stored.
A kind of lookup device of executive plan, including：
Receiving unit, receives SQL statement；
Generation unit, according to the SQL statement, generates parametrization SQL statement corresponding with the SQL statement；The ginseng
Numberization SQL statement includes parameter corresponding with the literal of the SQL statement；
Searching unit, executive plan corresponding with the parametrization SQL statement and constraints that lookup is prestored；
Judging unit, when executive plan corresponding with the parametrization SQL statement and constraints is found, judges institute
Whether the parameter corresponding with the constraints stated in parametrization SQL statement meets the constraints；If meeting, will inquire about
To the executive plan be defined as pending executive plan.
A kind of storage device of executive plan, including：
Receiving unit, receives SQL statement；
First generation unit, generates executive plan corresponding with the SQL statement；
Second generation unit, according to the SQL statement, generates parametrization SQL statement peace treaty corresponding with the SQL statement
Beam condition；
Memory cell, the executive plan is mapped and by the executive plan with the parametrization SQL statement
Mapped and stored with the constraints.
Above-mentioned at least one technical scheme that the embodiment of the present application is used can reach following beneficial effect：
During executive plan is stored in advance, by by executive plan and parametrization SQL statement, constraint bar
Part is mapped and is stored.After SQL statement is received, by generating parametrization SQL statement corresponding with the SQL statement,
Just can search prestore with the presence or absence of with the corresponding executive plan of the parametrization SQL statement and constraints；And looking into
After finding executive plan and constraints, judge to inquire whether executive plan is available (to be according to the constraints
No is pending executive plan).In above process, the foundation of query execution plan is parametrization SQL statement, judges inquiry
To the whether available foundation of executive plan be constraints corresponding with executive plan, it is seen then that either query execution plan
Process, or judge the whether available process of executive plan that inquires without the solution by carrying out semanteme to SQL statement
The mode of analysis is realized, that is to say, that the embodiment of the present application is avoided to be included to SQL statement during executive plan is searched
The step of carrying out the parsing of semanteme, so that the time delay that the search procedure for reducing above-mentioned executive plan is brought, and then lift data
The performance of storehouse system.
Brief description of the drawings
In order to illustrate more clearly of the embodiment of the present application or technical scheme of the prior art, below will be to embodiment or existing
The accompanying drawing to be used needed for having technology description is briefly described, it should be apparent that, drawings in the following description are only this
Some embodiments described in application, for those of ordinary skill in the art, are not paying the premise of creative labor
Under, other accompanying drawings can also be obtained according to these accompanying drawings.
Fig. 1 is a kind of exemplary system block diagram of the application；
The flow chart of the storage method of the executive plan that Fig. 2 is provided for the embodiment of the application one；
The flow chart of the lookup method of the executive plan that Fig. 3 is provided for the embodiment of the application one；
Fig. 4 is the exemplary application scenario diagram of the application one；
The block diagram of the lookup device of the executive plan that Fig. 5 is provided for the embodiment of the application one；
The block diagram of the storage device of the executive plan that Fig. 6 is provided for the embodiment of the application one.
Specific embodiment
In order that those skilled in the art more fully understand the technical scheme in the application, below in conjunction with the application reality
The accompanying drawing in example is applied, the technical scheme in the embodiment of the present application is clearly and completely described, it is clear that described implementation
Example is only some embodiments of the present application, rather than whole embodiments.Based on the embodiment in the application, this area is common
The every other embodiment that technical staff is obtained under the premise of creative work is not made, should all belong to the application protection
Scope.
It is well known that the access operation to database can include：Increase, deletion, reading and change to data etc., one
As above-mentioned access operation can be realized by SQL statement.Because SQL statement is a kind of descriptive language, it is used to indicate use
The thing to be done of family and without indicating how to do the thing, Database Systems need the SQL statement according to user, make
" executive plan " corresponding with SQL statement.One executive plan is general by multiple execution operator and its mutual call relation group
Into.For the database access task realized needed for a SQL statement, typically can be by various different executive plans come real
It is existing.In order to efficiently complete the database access task of user as far as possible, Database Systems typically pass through certain means (such as：
Based on cost or rule), from various executive plans, select the executive plan of an execution efficiency highest to perform, this mistake
Journey is commonly referred to as " executive plan optimization ".Selected executive plan needs to be instantiated, that is, distribute corresponding physical node
And the call relation between corresponding nodal information and node is set, this process is referred to as " code building ".Address herein
Database can be relevant database etc..
Usually, the generating process of executive plan is referred to as " hard parsing ", and the good and bad index bag of measure database performance
Include：The time consumed needed for the implementation procedure of executive plan and consumed needed for " hard parsing " process of generation executive plan when
Between.In some systems to delay requirement more harshness (such as：" On-Line Transaction Processing (online transactions
Processing procedure, OLTP) ") in, the time consumed needed for the implementation procedure of above-mentioned executive plan itself can be shorter, then generation is performed
The time consumed needed for the process of plan can not ignore all the more.
A kind of scheme of conventional lifting database performance is referred to as " program cache ".As previously mentioned, in view of existing skill
The following problems that art is present：During executive plan is searched, due to needing to carry out SQL statement the parsing of morphology/grammer
And the parsing of semanteme, this process can bring larger time delay, cause the performance of Database Systems not good.Set forth herein one kind
The lookup method and storage method of the executive plan parameterized to SQL, to solve the above problems.
Fig. 1 is a kind of exemplary system block diagram of the application.As shown in figure 1, the system can include user terminal 10,
Database server 20, and it is used to realize the network 30 of the communication between user terminal 10 and database server 20, the number
It is connected with a database 40 according to storehouse server 20.Above-mentioned server 20 can be included but is not limited to：One or more processors or
Processing unit 21, I/O interfaces 22, internal memory 23, bus and network adapter 24.Above-mentioned server 20 can with one or more outside
Portion's equipment 25 is (such as：Keyboard, mouse) and display 26 communicated.The network may, for example, be LAN (LAN), wide area network
, and/or public network etc. (WAN).Wherein, one piece of memory space can be opened up in above-mentioned internal memory 23, is held as being used to store
The program cache 230 of row plan.In said system, user terminal 10 sends to database server 20 and carries asking for SQL statement
Ask, database server 20 searches executive plan corresponding with the SQL statement according to the SQL statement from program cache 230
Or generation executive plan, and perform the access to database 40 according to executive plan.Wherein, usually executive plan is stored in
In caching, it is possible to according to the frequency of use of executive plan, the low executive plan of frequency of use is removed from caching.Namely
Say, general conventional executive plan can be stored in caching always, and what is be of little use plans in the case of Out of Memory just
Can be eliminated.Certainly, above-mentioned executive plan is stored in other kinds of storage medium (such as nonvolatile memory).
The flow of the storage method of the executive plan that Fig. 2 is provided for the embodiment of the application one, the executive agent of the method can
To be database server, in the method flow, will introduce in how the executive plan of generation being deposited in into " program cache ",
The storage method of the executive plan may include steps of：
S101：Receive SQL statement.
S102：Generation executive plan corresponding with the SQL statement.
In the embodiment of the present application, based on preformed program cache, database server is used to data receiving
After the SQL statement that storehouse conducts interviews, can first search in above-mentioned program cache with the presence or absence of execution corresponding with current SQL sentence
Plan (will be introduced below on specific query process).If finding executive plan match and available,
The executive plan found then is performed to realize the access to database.If not finding matching and available performing meter
Draw, then database server needs, according to current SQL statement, to generate corresponding executive plan.Certainly, in some cases
(such as：Also without any executive plan, it is necessary to be continuously replenished in the access process in follow-up data storehouse in program cache), it is also possible to
The step of directly skipping lookup executive plan, directly basis receives SQL statement and generates corresponding executive plan.
Process (i.e. " hard parsing " process) on how to generate executive plan, generally comprises following several steps：
1) parsing of morphology/grammer is carried out to SQL statement, such as：It is used to carry out the correctness of the keyword in sql sentences
Check.Certainly, the effect of the step of carrying out the parsing of morphology/grammer to SQL statement also includes：It is every in one SQL statement of identification
The attribute of individual word, e.g., the word is keyword, literal, variable etc..
2) parsing of semanteme is carried out to SQL statement, whether semanteme parsing mainly is used to judge refer to not deposit in SQL statement
Object or whether violate constraints etc. of correlation.
3) an optimal executive plan is created by optimizer.Optimizer can include that logic optimization and physics optimize,
Logic optimization refers to：SQL statement is changed using a variety of algorithms and strategy, many SQL statements of equal value of generation.
Physics optimizes：According to each SQL statement that logic optimization is obtained, respective executive plan is generated respectively, then, by for every
Individual executive plan calculates a cost (Cost), and finally, the executive plan of selection minimum cost (Cost) is held as optimal
Row plan.
4) the optimal executive plan obtained according to selection, generates corresponding code.
It is technology well-known to those skilled in the art on above-mentioned " hard parsing " process, is no longer situated between in detail herein
Continue.In a word, for each SQL statement, if searched less than corresponding execution from program cache (plan cache)
Plan, just can generate an executive plan corresponding with the SQL statement by above-mentioned " hard parsing " process.
S103：According to SQL statement, corresponding with SQL statement parametrization SQL statement and constraints are generated.
In the embodiment of the present application, the process for generating parametrization SQL statement corresponding with SQL statement can be specifically included：
A) morphology parsing is carried out to the SQL morphology/grammer, determines the literal included in the SQL statement.In meter
In calculation machine science, literal (literal) is the representation (notation) for the fixed value in expression code.It is described literal
Amount can include：Integer, floating number and character string etc..
For example, it is assumed that a SQL statement is：
Select c1, c2, c3from t1where c1=1and c2like ' senior% ' order by 3limit
1,20；
Parsed by morphology, it may be determined that the part of speech of each word is (such as in above-mentioned SQL statement：Variable, keyword, literal
Deng), the literal included in above-mentioned SQL statement is (character with underscore)：
Select c1, c2, c3from t1where c1=1and c2like' senior% 'order by 3limit1,20；
B) literal included in above-mentioned SQL statement is replaced with into parameter, obtains parametrization corresponding with the SQL statement
SQL statement；Wherein, the parameter includes sequence number corresponding with the literal.
Continue to continue to use above-mentioned example, the parametrization SQL statement for obtaining is：
Select c1, c2, c3from t1where c1=@1and c2like@2order by@3limit@4 ,@5；
Wherein, above-mentioned parameter@1 ,@2 ,@3 ,@4 ,@5 instead of corresponding literal, and above-mentioned each parameter is taken
One sequence number corresponding with literal of band, the sequence number can represent literal corresponding with parameter and go out in the SQL statement
Existing precedence.Such as：It is with the corresponding literals of@1：Literal " 1 " after " c1=", the literal " 1 " is in above-mentioned SQL
It is first literal of appearance in sentence.
During actually used, SQL statement corresponding with same parametrization SQL statement can include various.Example
Such as：For parametrization SQL statement：
Select c1, c2, c3from t1where c1=@1and c2like@2order by@3limit@4 ,@5；
Corresponding SQL statement can include：
1. select c1, c2, c3from t1where c1=1and c2like ' senior% ' order by
3limit 1,20；
2. select c1, c2, c3from t1where c1=1and c2like ' senior% ' order by
2limit 1,20；
Wherein, above-mentioned SQL statement difference 1. and 2. is：Literal after " order by " is different.
For above-mentioned SQL statement 1. and 2., although they correspond to same one parametrization SQL statement, but they are simultaneously
An executive plan can not be shared.In view of this, in order to realize inquiring about hold corresponding with SQL statement according to parameter SQL statement
The scheme of row plan is, it is necessary to while it is determined that parameterizing SQL statement, generate constraint bar corresponding with the parametrization SQL statement
Part.
In the embodiment of the present application, the process for generating above-mentioned constraints can be specifically included：
C) semantic parsing is carried out to SQL statement, determines the literal related to constraints included in SQL statement.
Wherein, step c can be specifically including but not limited to one of following steps：
Step one：Semantic parsing is carried out to the SQL statement, will be included in the SQL statement positioned at specific character string
Literal afterwards is defined as the literal related to constraints；The specific character string includes：" order by " or
" group by " etc..
For example, for SQL statement：
Select c1, c2, c3from t1where c1=1and c2like ' senior% ' order by 3limit
1,20；
Can by semantic parsing, it is determined that the literal " 3 " being located at after specific character string " order by " be with about
The related literal of beam condition, and the related literal of the constraints can be determined：" 3 " correspond to above-mentioned SQL statement
In the 3rd parameter.
Step 2：Semantic parsing is carried out to the SQL statement, the Accuracy Figure that belongs to that will be included in the SQL statement
Literal is defined as the literal related to constraints.
For example, for following two SQL statements：" select 1.000001 " and " select 1.000002 " is not
With same executive plan is shared, then above-mentioned " 1.000001 " and " 1.000002 " belong to the literal of Accuracy Figure, can be with
It is defined as the literal related to constraints.
Step 3：Semantic parsing is carried out to the SQL statement, logically true/logically false condition in the SQL statement is included
Literal is defined as the literal related to constraints.
For example, if a SQL statement is：
Select*from t1where 1=0and c1=2；
Wherein, " 1=0 " is logically false condition, then can determine that the literal " 1 " that is included in the logically false condition and " 0 " are
The literal related to constraints.
If again for example, above-mentioned SQL statement is：
Select*from t1where 1=1and c1=2；
Wherein, " 1=1 " is logically true condition, then can determine that the literal " 1 " that is included in the logically true condition and " 1 " are
The literal related to constraints.
D) according to the literal related to constraints for determining, generation constraint corresponding with the parametrization SQL statement
Condition.
Continue to continue to use rising example, for SQL statement：
Select c1, c2, c3from t1where c1=1and c2like ' senior% ' order by 3limit
1,20；
The constraints of generation is：" literal corresponding with the 3rd parameter in parametrization SQL statement is equal to 3 ".
Again for example, for SQL statement：
Select*from t1where 1=0and c1=2；
The constraints of generation is：" literal corresponding with the 1st parameter in parametrization SQL statement is not equal to and the 2nd
The corresponding literal of individual parameter ".
It should be noted that the literal corresponding with constraints included in above-mentioned SQL statement can be one and also may be used
Being multiple.Similarly, for a SQL statement, one or more constraintss can be generated, the application is not restricted.This
Outward, the constraints that the application is referred to is not limited to several situations listed above, any to cause for this programme
SQL statement with identical parameters SQL statement can not share the factor of same executive plan, can be as constraints
One kind, is no longer exhaustive herein.
S104：Executive plan is mapped with parametrization SQL statement and executive plan is reflected with constraints
Penetrate and store.
In the embodiment of the present application, the form of the executive plan stored in program cache (plan cache) can for example under
Shown in table 1：
Table 1：
So far, can be formed comprising parametrization SQL statement, executive plan, the plan of the mapping relations of constraints three
Caching.
The flow chart of the lookup method of the executive plan that Fig. 3 is provided for the embodiment of the application one, Fig. 4 is the example of the application one
The application scenario diagram of property, shown in work-in parameters Fig. 3 and Fig. 4, the lookup method of the executive plan may include steps of：
S201：Receive SQL statement.
S202：According to the SQL statement, parametrization SQL statement corresponding with the SQL statement is generated；Wherein, the ginseng
Numberization SQL statement includes parameter corresponding with the literal of the SQL statement.
In the embodiment of the present application, above-mentioned steps S202 can be specifically included：Morphology parsing is carried out to the SQL statement, really
The literal included in the fixed SQL statement；The literal included in the SQL statement is replaced with into parameter, obtain with it is described
The corresponding parametrization SQL statement of SQL statement；Wherein, the parameter includes sequence number corresponding with the literal.
As shown in figure 4, as an example it is assumed that a SQL statement is：
Select c1, c2, c3from t1where c1=1and c2like ' senior% ' order by 3limit
1,20；
Generation corresponding parametrization SQL statement be：
Select c1, c2, c3from t1where c1=@1and c2like@2order by@3limit@4 ,@5；
In the embodiment of the present application, after parametrization SQL statement corresponding with the SQL statement is generated, methods described is also
Comprise the following steps：
Parameter array of the generation comprising literal corresponding with the parameter in the parametrization SQL statement.
For example, for SQL statement：
Select c1, c2, c3from t1where c1=1and c2like ' senior% ' order by 3limit
1,20；
The parameter array of generation is：
{ 1, ' senior% ', 3,1,20 }.
S203：Executive plan corresponding with the parametrization SQL statement and constraints that lookup is prestored.If searching
Arrive, into step S204.
On the premise of generation parameter array, step S203 judges according to the parameter array and the constraints
Whether the literal corresponding with the constraints in the parameter array meets the constraints.
As shown in figure 4, for example, being for parametrization SQL statement：
Select c1, c2, c3from t1where c1=@1and c2like@2order by@3limit@4 ,@5；
If there is corresponding executive plan in program cache being：Plan1 and Plan2 (such as upper table 1), wherein, with
The corresponding constraintss of Plan1 are：" the 3rd corresponding literal of parameter is equal to 3 ", constraints corresponding with Plan2 is：
" the 3rd corresponding literal of parameter is equal to 3 ".
S204：Judge whether the parameter corresponding with the constraints parameterized in SQL statement meets the constraint bar
Part；If meeting, into step S205.
Due to above-mentioned parameter SQL statement：" select c1, c2, c3from t1where c1=@1and
c2like@2order by@3limit@4,@5；" corresponding parameter array is：
{ 1, ' senior% ', 3,1,20 }.
It can be seen that, parameter corresponding with constraints is：@3, can be determined corresponding with parameter@3 literal by parameter array
Amount is 3, it is clear that literal " 3 " corresponding with 3 meets constraints corresponding with Plan1, but and is unsatisfactory for and Plan2 pairs
The constraints answered.That is, Plan1 is executive plan that current SQL sentence matches and available, Plan2 is not
The available executive plan of current SQL sentence.
S205：The executive plan that will be inquired is defined as pending executive plan.
In the above example, the executive plan Plan1 that will be inquired is defined as and SQL statement：“select c1,c2,
C3from t1where c1=1and c2like ' senior% ' order by 3limit 1,20；" corresponding pending
Executive plan, and the plan is performed according to the literal in above-mentioned parameter array, obtain Query Result and feed back to the use
Family terminal.Due to executive plan and the process that obtains Query Result is technology well-known to those skilled in the art, herein no longer
Repeated.It should be noted that literal corresponding with each parameter can be with the other forms beyond above-mentioned parameter array
It is indicated, such as：Mapping table of parameter and literal etc..
It should be noted that the executive agent that various embodiments above provides each step of method may each be same and set
It is standby, or, the method is also by distinct device as executive agent.Such as, the executive agent of step S101 and step S102 can be with
It is equipment 1, the executive agent of step S103 can be equipment 2；Again such as, the executive agent of step S101 can be equipment 1, step
The executive agent of rapid S102 and step S103 can be equipment 2；Etc..
Storage method and lookup method based on above-mentioned executive plan, in the process in advance being stored executive plan
In, mapped and stored by by executive plan and parametrization SQL statement, constraints.After SQL statement is received, lead to
Cross corresponding with the SQL statement parametrization SQL statement of generation, just can search prestore with the presence or absence of with the parametrization
The corresponding executive plan of SQL statement and constraints；And after executive plan and constraints is found, according to the constraint
Whether whether condition available (being pending executive plan) to judge to inquire executive plan.In above process, inquire about
The foundation of executive plan is parametrization SQL statement, and whether the available foundation of executive plan that judgement is inquired is and executive plan
Corresponding constraints, it is seen then that whether the either process of query execution plan, or the executive plan that judgement is inquired can use
Process without be realized by way of carrying out to SQL statement the parsing of semanteme, that is to say, that the embodiment of the present application is avoided
Including the step of parsing of semanteme is carried out to SQL statement during searching executive plan, so as to reduce above-mentioned execution meter
The time delay that the search procedure drawn is brought, and then lift the performance of Database Systems.
What deserves to be explained is, in some systems to delay requirement more harshness (such as：“On-Line Transaction
Processing (Transaction Processing process, OLTP) ") in, although language is carried out to SQL statement during searching program cache
The step of justice parsing consumed time is very short, but, that is brought for said system, the step of semanteme parsing is above-mentioned
Time delay be can not ignore, and particularly, if Database Systems face larger pressure, above-mentioned time delay more be can not ignore.This Shen
Please embodiment can to a certain extent avoid the time delay that above-mentioned steps are brought, lift the performance of Database Systems.
The block diagram of the lookup device of the executive plan that Fig. 5 is provided for the embodiment of the application one.Based on above-mentioned executive plan
Lookup method, the lookup device 100 of the executive plan that the embodiment of the present application is provided can be with software, hardware or software and hardware combining
Mode be present in above-mentioned database server, the device 100 can include：
Receiving unit 101, receives SQL statement；
Generation unit 102, according to the SQL statement, generates parametrization SQL statement corresponding with the SQL statement；It is described
Parametrization SQL statement includes parameter corresponding with the literal of the SQL statement；
Searching unit 103, executive plan corresponding with the parametrization SQL statement and constraint bar that lookup is prestored
Part；
Judging unit 104, when executive plan corresponding with the parametrization SQL statement and constraints is found, sentences
Whether the parameter corresponding with the constraints in the disconnected parametrization SQL statement meets the constraints；If meeting, will
The executive plan for inquiring is defined as pending executive plan.
In the optional embodiment of the application one, described device 100 also includes：
Array generation unit, parameter number of the generation comprising literal corresponding with the parameter in the parametrization SQL statement
Group；
Then the judging unit 104 is according to the parameter array and the constraints, judge in the parameter array with
Whether the corresponding literal of the constraints meets the constraints.
In the optional embodiment of the application one, the generation unit 102 includes：
Literal determining unit, morphology parsing is carried out to the SQL statement, and determine to include in the SQL statement is literal
Amount；
Parameter replacement unit, parameter is replaced with by the literal included in the SQL statement, is obtained and the SQL statement
Corresponding parametrization SQL statement；The parameter includes sequence number corresponding with the literal.
The block diagram of the storage device of the executive plan that Fig. 6 is provided for the embodiment of the application one.Based on above-mentioned executive plan
Storage method, the storage device 200 of the executive plan that the embodiment of the present application is provided can be with software, hardware or software and hardware combining
Mode be present in above-mentioned database server, the storage device 200 of the executive plan can include：
Receiving unit 201, receives SQL statement；
First generation unit 202, generates executive plan corresponding with the SQL statement；
Second generation unit 203, according to the SQL statement, generates parametrization SQL statement corresponding with the SQL statement
And constraints；
Memory cell 204, the executive plan is mapped with the parametrization SQL statement and meter is performed by described
Draw and mapped and stored with the constraints.
In the optional embodiment of the application one, first generation unit 202 is corresponding with the SQL statement without searching
Executive plan when, generate corresponding with SQL statement executive plan.
In the optional embodiment of the application one, second generation unit 203 includes：
Literal determining unit, morphology parsing is carried out to the SQL statement, and determine to include in the SQL statement is literal
Amount；
Parameter replacement unit, parameter, generation and the SQL statement are replaced with by the literal included in the SQL statement
Corresponding parametrization SQL statement；The parameter includes sequence number corresponding with the literal；
Constraint literal determining unit, semantic parsing is carried out to the SQL statement, determines what is included in the SQL statement
The literal related to constraints；
Constraints generation unit, the literal related to constraints according to determining, generation and the parameter
Change the corresponding constraints of SQL statement.
In the optional embodiment of the application one, constraint literal determining unit carries out semantic parsing to the SQL statement, will
The literal after specific character string included in the SQL statement is defined as the literal related to constraints；Its
In, the specific character string includes：" order by " or " group by "；Or,
The constraint literal determining unit carries out semantic parsing to the SQL statement, by what is included in the SQL statement
The literal for belonging to Accuracy Figure is defined as the literal related to constraints；Or,
The constraint literal determining unit carries out semantic parsing to the SQL statement, by the perseverance in the SQL statement
The literal that very/logically false condition is included is defined as the literal related to constraints.
Storage device 100 and lookup device 200 based on above-mentioned executive plan, in advance stored executive plan
During, mapped and stored by by executive plan and parametrization SQL statement, constraints.Receive SQL statement it
Afterwards, by generating parametrization SQL statement corresponding with the SQL statement, just can search prestore with the presence or absence of with it is described
The corresponding executive plan of parametrization SQL statement and constraints；And after executive plan and constraints is found, according to institute
Constraints is stated to judge to inquire whether whether executive plan can use (being pending executive plan).In said process
In, the foundation of query execution plan is parametrization SQL statement, and whether the available foundation of executive plan that judgement is inquired is and holds
The row corresponding constraints of plan, it is seen then that the either process of query execution plan, or judge that the executive plan for inquiring is
No available process by way of the parsing of semanteme is carried out to SQL statement without being realized, that is to say, that the application is implemented
Example is avoided is including the step of parsing of semanteme is carried out to SQL statement during searching executive plan, so as to reduce above-mentioned
The time delay that the search procedure of executive plan is brought, and then lift the performance of Database Systems.
For convenience of description, it is divided into various units with function during description apparatus above to describe respectively.Certainly, this is being implemented
The function of each unit can be realized in same or multiple softwares and/or hardware during application.
It should be understood by those skilled in the art that, embodiments of the invention can be provided as method, system or computer program
Product.Therefore, the present invention can be using the reality in terms of complete hardware embodiment, complete software embodiment or combination software and hardware
Apply the form of example.And, the present invention can be used and wherein include the computer of computer usable program code at one or more
The computer program implemented in usable storage medium (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.) is produced
The form of product.
The present invention is the flow with reference to method according to embodiments of the present invention, equipment (system) and computer program product
Figure and/or block diagram are described.It should be understood that every first-class during flow chart and/or block diagram can be realized by computer program instructions
The combination of flow and/or square frame in journey and/or square frame and flow chart and/or block diagram.These computer programs can be provided
The processor of all-purpose computer, special-purpose computer, Embedded Processor or other programmable data processing devices is instructed to produce
A raw machine so that produced for reality by the instruction of computer or the computing device of other programmable data processing devices
The device of the function of being specified in present one flow of flow chart or multiple one square frame of flow and/or block diagram or multiple square frames.
These computer program instructions may be alternatively stored in can guide computer or other programmable data processing devices with spy
In determining the computer-readable memory that mode works so that instruction of the storage in the computer-readable memory is produced and include finger
Make the manufacture of device, the command device realize in one flow of flow chart or multiple one square frame of flow and/or block diagram or
The function of being specified in multiple square frames.
These computer program instructions can be also loaded into computer or other programmable data processing devices so that in meter
Series of operation steps is performed on calculation machine or other programmable devices to produce computer implemented treatment, so as in computer or
The instruction performed on other programmable devices is provided for realizing in one flow of flow chart or multiple flows and/or block diagram one
The step of function of being specified in individual square frame or multiple square frames.
Also, it should be noted that term " including ", "comprising" or its any other variant be intended to nonexcludability
Comprising so that process, method, commodity or equipment including a series of key elements not only include those key elements, but also wrapping
Include other key elements being not expressly set out, or also include for this process, method, commodity or equipment is intrinsic wants
Element.In the absence of more restrictions, the key element limited by sentence "including a ...", it is not excluded that wanted including described
Also there is other identical element in process, method, commodity or the equipment of element.
It will be understood by those skilled in the art that embodiments herein can be provided as method, system or computer program product.
Therefore, the application can be using the embodiment in terms of complete hardware embodiment, complete software embodiment or combination software and hardware
Form.And, the application can be used to be can use in one or more computers for wherein including computer usable program code and deposited
The shape of the computer program product implemented on storage media (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.)
Formula.
The application can be described in the general context of computer executable instructions, such as program
Module.Usually, program module includes performing particular task or realizes routine, program, object, the group of particular abstract data type
Part, data structure etc..The application can also be in a distributed computing environment put into practice, in these DCEs, by
Remote processing devices connected by communication network perform task.In a distributed computing environment, program module can be with
In local and remote computer-readable storage medium including including storage device.
Each embodiment in this specification is described by the way of progressive, identical similar portion between each embodiment
Divide mutually referring to what each embodiment was stressed is the difference with other embodiment.Especially for system reality
Apply for example, because it is substantially similar to embodiment of the method, so description is fairly simple, related part is referring to embodiment of the method
Part explanation.
Embodiments herein is the foregoing is only, the application is not limited to.For those skilled in the art
For, the application can have various modifications and variations.It is all any modifications made within spirit herein and principle, equivalent
Replace, improve etc., within the scope of should be included in claims hereof.
Claims (14)
1. a kind of lookup method of executive plan, it is characterised in that including：
Receive SQL statement；
According to the SQL statement, parametrization SQL statement corresponding with the SQL statement is generated；The parametrization SQL statement bag
Containing parameter corresponding with the literal of the SQL statement；
Executive plan corresponding with the parametrization SQL statement and constraints that lookup is prestored；
If finding, judge it is described parametrization SQL statement in parameter corresponding with the constraints whether meet it is described about
Beam condition；If meeting, the executive plan that will be inquired is defined as pending executive plan.
2. method according to claim 1, it is characterised in that generating parametrization SQL languages corresponding with the SQL statement
After sentence, before the executive plan corresponding with the parametrization SQL statement and constraints that prestore is searched, the side
Method also includes：
Parameter array of the generation comprising literal corresponding with the parameter in the parametrization SQL statement；
Judge whether the parameter corresponding with the constraints in the parametrization SQL statement meets the constraints, have
Body includes：
According to the parameter array and the constraints, the word corresponding with the constraints in the parameter array is judged
Whether face amount meets the constraints.
3. method according to claim 1, it is characterised in that according to the SQL statement, generation and the SQL statement pair
The parametrization SQL statement answered, specifically includes：
Morphology parsing is carried out to the SQL statement, the literal included in the SQL statement is determined；
The literal included in the SQL statement is replaced with into parameter, parametrization SQL languages corresponding with the SQL statement are obtained
Sentence；The parameter includes sequence number corresponding with the literal.
4. a kind of storage method of executive plan, it is characterised in that including：
Receive SQL statement；
Generation executive plan corresponding with the SQL statement；
According to the SQL statement, corresponding with the SQL statement parametrization SQL statement and constraints are generated；
The executive plan is mapped and by the executive plan and the constraints with the parametrization SQL statement
Mapped and stored.
5. method according to claim 4, it is characterised in that generation executive plan corresponding with the SQL statement, specifically
Including：
When without executive plan corresponding with the SQL statement is searched, executive plan corresponding with the SQL statement is generated.
6. method according to claim 4, it is characterised in that according to the SQL statement, generation and the SQL statement pair
The parametrization SQL statement and constraints answered, specifically include：
Morphology parsing is carried out to the SQL statement, the literal included in the SQL statement is determined；
The literal included in the SQL statement is replaced with into parameter, parametrization SQL languages corresponding with the SQL statement are obtained
Sentence；The parameter includes sequence number corresponding with the literal；
Semantic parsing is carried out to the SQL statement, the literal related to constraints included in the SQL statement is determined；
According to the literal related to constraints for determining, generation constraints corresponding with the parametrization SQL statement.
7. method according to claim 6, it is characterised in that semantic parsing is carried out to the SQL statement, it is determined that described
The literal related to constraints included in SQL statement, specifically includes：
Semantic parsing is carried out to the SQL statement, the literal after specific character string that will be included in the SQL statement
It is defined as the literal related to constraints；The specific character string includes：" order by " or " group by "；Or,
Semantic parsing is carried out to the SQL statement, the literal for belonging to Accuracy Figure that will be included in the SQL statement is defined as
The literal related to constraints；Or,
Semantic parsing is carried out to the SQL statement, the literal that logically true/logically false condition in the SQL statement is included determines
It is the literal related to constraints.
8. the lookup device of a kind of executive plan, it is characterised in that including：
Receiving unit, receives SQL statement；
Generation unit, according to the SQL statement, generates parametrization SQL statement corresponding with the SQL statement；The parametrization
SQL statement includes parameter corresponding with the literal of the SQL statement；
Searching unit, executive plan corresponding with the parametrization SQL statement and constraints that lookup is prestored；
Judging unit, when executive plan corresponding with the parametrization SQL statement and constraints is found, judges the ginseng
Whether the parameter corresponding with the constraints in numberization SQL statement meets the constraints；If meeting, by what is inquired
The executive plan is defined as pending executive plan.
9. device according to claim 8, it is characterised in that described device also includes：
Array generation unit, parameter array of the generation comprising literal corresponding with the parameter in the parametrization SQL statement；
Then the judging unit is according to the parameter array and the constraints, judge in the parameter array with the constraint
Whether the corresponding literal of condition meets the constraints.
10. device according to claim 8, it is characterised in that the generation unit includes：
Literal determining unit, morphology parsing is carried out to the SQL statement, determines the literal included in the SQL statement；
Parameter replacement unit, parameter is replaced with by the literal included in the SQL statement, obtains corresponding with the SQL statement
Parametrization SQL statement；The parameter includes sequence number corresponding with the literal.
A kind of 11. storage devices of executive plan, it is characterised in that including：
Receiving unit, receives SQL statement；
First generation unit, generates executive plan corresponding with the SQL statement；
Second generation unit, according to the SQL statement, generates parametrization SQL statement corresponding with the SQL statement and constraint bar
Part；
Memory cell, the executive plan is mapped and by the executive plan and institute with the parametrization SQL statement
Constraints is stated to be mapped and stored.
12. methods according to claim 11, it is characterised in that first generation unit without search with it is described
During the corresponding executive plan of SQL statement, executive plan corresponding with the SQL statement is generated.
13. devices according to claim 11, it is characterised in that second generation unit includes：
Literal determining unit, morphology parsing is carried out to the SQL statement, determines the literal included in the SQL statement；
Parameter replacement unit, parameter is replaced with by the literal included in the SQL statement, is generated corresponding with the SQL statement
Parametrization SQL statement；The parameter includes sequence number corresponding with the literal；
Constraint literal determining unit, semantic parsing is carried out to the SQL statement, determine to include in the SQL statement with about
The related literal of beam condition；
Constraints generation unit, the literal related to constraints according to determining, generation and the parametrization SQL
The corresponding constraints of sentence.
14. devices according to claim 13, it is characterised in that constraint literal determining unit is entered to the SQL statement
The semantic parsing of row, the literal after specific character string that will be included in the SQL statement is defined as and constraints phase
The literal of pass；The specific character string includes：" order by " or " group by "；Or,
The constraint literal determining unit carries out semantic parsing to the SQL statement, by belonging to for being included in the SQL statement
The literal of Accuracy Figure is defined as the literal related to constraints；Or,
The constraint literal determining unit carries out semantic parsing to the SQL statement, will be logically true/permanent in the SQL statement
The literal that false condition is included is defined as the literal related to constraints.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610576924.5A CN106897343B (en) | 2016-07-20 | 2016-07-20 | Searching method, storing method and device for execution plan |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610576924.5A CN106897343B (en) | 2016-07-20 | 2016-07-20 | Searching method, storing method and device for execution plan |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106897343A true CN106897343A (en) | 2017-06-27 |
| CN106897343B CN106897343B (en) | 2020-08-07 |
Family
ID=59190962
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610576924.5A Active CN106897343B (en) | 2016-07-20 | 2016-07-20 | Searching method, storing method and device for execution plan |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106897343B (en) |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107451203A (en) * | 2017-07-07 | 2017-12-08 | 阿里巴巴集团控股有限公司 | Data bank access method and device |
| CN107508909A (en) * | 2017-09-15 | 2017-12-22 | 无锡南理工科技发展有限公司 | The processing method of multithread real-time management is wireless middleware |
| CN108763536A (en) * | 2018-05-31 | 2018-11-06 | 阿里巴巴集团控股有限公司 | Data bank access method and device |
| CN108804554A (en) * | 2018-05-22 | 2018-11-13 | 上海达梦数据库有限公司 | A kind of data base query method, device, server and storage medium |
| CN109063170A (en) * | 2018-08-17 | 2018-12-21 | 百度在线网络技术（北京）有限公司 | Intelligent inquiry method, device, terminal and computer readable storage medium |
| CN109241101A (en) * | 2018-08-31 | 2019-01-18 | 阿里巴巴集团控股有限公司 | A kind of database inquiry optimization method, apparatus and computer equipment |
| CN109684351A (en) * | 2018-12-18 | 2019-04-26 | 上海达梦数据库有限公司 | A kind of executive plan inspection method, device, server and storage medium |
| CN110069522A (en) * | 2017-11-10 | 2019-07-30 | 阿里巴巴集团控股有限公司 | Data query method and apparatus |
| CN111078670A (en) * | 2019-12-19 | 2020-04-28 | 上海达梦数据库有限公司 | Database execution plan clearing method, device, equipment and storage medium |
| CN111221840A (en) * | 2018-11-23 | 2020-06-02 | 阿里巴巴集团控股有限公司 | Data processing method and device, data caching method, storage medium and system |
| CN111506603A (en) * | 2020-04-23 | 2020-08-07 | 上海达梦数据库有限公司 | Data processing method, device, equipment and storage medium |
| CN111639096A (en) * | 2020-05-29 | 2020-09-08 | 北京奇艺世纪科技有限公司 | SQL statement execution method and device, electronic equipment and storage medium |
| CN111797112A (en) * | 2020-06-05 | 2020-10-20 | 武汉大学 | PostgreSQL preparation statement execution optimization method |
| CN114168620A (en) * | 2022-02-11 | 2022-03-11 | 北京奥星贝斯科技有限公司 | Execution plan processing method and device |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060031189A1 (en) * | 2004-08-05 | 2006-02-09 | International Business Machines Corporation | Method and system for data mining for automatic query optimization |
| US7933894B2 (en) * | 2007-06-15 | 2011-04-26 | Microsoft Corporation | Parameter-sensitive plans for structural scenarios |
| CN102110110A (en) * | 2009-12-28 | 2011-06-29 | ***通信集团公司 | Method and device for data access based on SOA (Service-Oriented Architecture) |
| CN102426612A (en) * | 2012-01-13 | 2012-04-25 | 广州从兴电子开发有限公司 | Condition object query method and system |
| CN102609451A (en) * | 2012-01-11 | 2012-07-25 | 华中科技大学 | SQL (structured query language) query plan generation method oriented to streaming data processing |
| CN103678589A (en) * | 2013-12-12 | 2014-03-26 | 用友软件股份有限公司 | Database kernel query optimization method based on equivalence class |
| TWI507897B (en) * | 2010-05-14 | 2015-11-11 | Alibaba Group Holding Ltd | Search methods and devices |
| CN105224690A (en) * | 2015-10-30 | 2016-01-06 | 上海达梦数据库有限公司 | Generate and select the corresponding method and system containing the executive plan of ginseng statement |
-
2016
- 2016-07-20 CN CN201610576924.5A patent/CN106897343B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060031189A1 (en) * | 2004-08-05 | 2006-02-09 | International Business Machines Corporation | Method and system for data mining for automatic query optimization |
| US7933894B2 (en) * | 2007-06-15 | 2011-04-26 | Microsoft Corporation | Parameter-sensitive plans for structural scenarios |
| CN102110110A (en) * | 2009-12-28 | 2011-06-29 | ***通信集团公司 | Method and device for data access based on SOA (Service-Oriented Architecture) |
| TWI507897B (en) * | 2010-05-14 | 2015-11-11 | Alibaba Group Holding Ltd | Search methods and devices |
| CN102609451A (en) * | 2012-01-11 | 2012-07-25 | 华中科技大学 | SQL (structured query language) query plan generation method oriented to streaming data processing |
| CN102426612A (en) * | 2012-01-13 | 2012-04-25 | 广州从兴电子开发有限公司 | Condition object query method and system |
| CN103678589A (en) * | 2013-12-12 | 2014-03-26 | 用友软件股份有限公司 | Database kernel query optimization method based on equivalence class |
| CN105224690A (en) * | 2015-10-30 | 2016-01-06 | 上海达梦数据库有限公司 | Generate and select the corresponding method and system containing the executive plan of ginseng statement |
Cited By (29)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107451203A (en) * | 2017-07-07 | 2017-12-08 | 阿里巴巴集团控股有限公司 | Data bank access method and device |
| CN107451203B (en) * | 2017-07-07 | 2020-09-01 | 阿里巴巴集团控股有限公司 | Database access method and device |
| CN107508909A (en) * | 2017-09-15 | 2017-12-22 | 无锡南理工科技发展有限公司 | The processing method of multithread real-time management is wireless middleware |
| CN110069522A (en) * | 2017-11-10 | 2019-07-30 | 阿里巴巴集团控股有限公司 | Data query method and apparatus |
| CN108804554A (en) * | 2018-05-22 | 2018-11-13 | 上海达梦数据库有限公司 | A kind of data base query method, device, server and storage medium |
| CN108804554B (en) * | 2018-05-22 | 2021-03-05 | 上海达梦数据库有限公司 | Database query method, database query device, server and storage medium |
| US11243950B2 (en) | 2018-05-31 | 2022-02-08 | Beijing Oceanbase Technology Co., Ltd. | Database query plan selection |
| WO2019228002A1 (en) * | 2018-05-31 | 2019-12-05 | 阿里巴巴集团控股有限公司 | Database access method and device |
| CN108763536B (en) * | 2018-05-31 | 2020-04-14 | 阿里巴巴集团控股有限公司 | Database access method and device |
| CN108763536A (en) * | 2018-05-31 | 2018-11-06 | 阿里巴巴集团控股有限公司 | Data bank access method and device |
| US11080278B2 (en) | 2018-05-31 | 2021-08-03 | Ant Financial (Hang Zhou) Network Technology Co., Ltd. | Database query plan selection |
| CN109063170A (en) * | 2018-08-17 | 2018-12-21 | 百度在线网络技术（北京）有限公司 | Intelligent inquiry method, device, terminal and computer readable storage medium |
| CN109063170B (en) * | 2018-08-17 | 2021-07-30 | 百度在线网络技术（北京）有限公司 | Intelligent query method, device, terminal and computer readable storage medium |
| WO2020042804A1 (en) * | 2018-08-31 | 2020-03-05 | 阿里巴巴集团控股有限公司 | Database query optimization method and apparatus and computer device |
| US11256697B2 (en) | 2018-08-31 | 2022-02-22 | Beijing Oceanbase Technology Co., Ltd. | Database query optimization methods, apparatuses, and computer devices |
| CN109241101B (en) * | 2018-08-31 | 2020-06-30 | 阿里巴巴集团控股有限公司 | Database query optimization method and device and computer equipment |
| CN109241101A (en) * | 2018-08-31 | 2019-01-18 | 阿里巴巴集团控股有限公司 | A kind of database inquiry optimization method, apparatus and computer equipment |
| CN111221840A (en) * | 2018-11-23 | 2020-06-02 | 阿里巴巴集团控股有限公司 | Data processing method and device, data caching method, storage medium and system |
| CN111221840B (en) * | 2018-11-23 | 2023-05-30 | 阿里云计算有限公司 | Data processing method and device, data caching method, storage medium and system |
| CN109684351A (en) * | 2018-12-18 | 2019-04-26 | 上海达梦数据库有限公司 | A kind of executive plan inspection method, device, server and storage medium |
| CN111078670A (en) * | 2019-12-19 | 2020-04-28 | 上海达梦数据库有限公司 | Database execution plan clearing method, device, equipment and storage medium |
| CN111078670B (en) * | 2019-12-19 | 2023-06-20 | 上海达梦数据库有限公司 | Database execution plan clearing method, device, equipment and storage medium |
| CN111506603A (en) * | 2020-04-23 | 2020-08-07 | 上海达梦数据库有限公司 | Data processing method, device, equipment and storage medium |
| CN111506603B (en) * | 2020-04-23 | 2024-03-26 | 上海达梦数据库有限公司 | Data processing method, device, equipment and storage medium |
| CN111639096A (en) * | 2020-05-29 | 2020-09-08 | 北京奇艺世纪科技有限公司 | SQL statement execution method and device, electronic equipment and storage medium |
| CN111639096B (en) * | 2020-05-29 | 2024-03-08 | 北京奇艺世纪科技有限公司 | SQL sentence execution method and device, electronic equipment and storage medium |
| CN111797112A (en) * | 2020-06-05 | 2020-10-20 | 武汉大学 | PostgreSQL preparation statement execution optimization method |
| CN111797112B (en) * | 2020-06-05 | 2022-04-01 | 武汉大学 | PostgreSQL preparation statement execution optimization method |
| CN114168620A (en) * | 2022-02-11 | 2022-03-11 | 北京奥星贝斯科技有限公司 | Execution plan processing method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106897343B (en) | 2020-08-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106897343A (en) | The lookup method of executive plan, storage method and device | |
| CN106547796B (en) | Database execution method and device | |
| CN111177231A (en) | Report generation method and report generation device | |
| CN107644073A (en) | A kind of field consanguinity analysis method, system and device based on depth-first traversal | |
| US9218379B2 (en) | Method, apparatus, and computer-readable medium for efficiently performing operations on distinct data values | |
| EP2608074A2 (en) | Systems and methods for merging source records in accordance with survivorship rules | |
| CN107463632A (en) | A kind of distributed NewSQL Database Systems and data query method | |
| US20050278139A1 (en) | Automatic match tuning | |
| US8156142B2 (en) | Semantically weighted searching in a governed corpus of terms | |
| US11216474B2 (en) | Statistical processing of natural language queries of data sets | |
| US10810643B2 (en) | Method and system for request for proposal (RFP) response generation | |
| US11907806B2 (en) | Parameter calibration method and system, quantum chip control method | |
| US9547646B2 (en) | User-created members positioning for OLAP databases | |
| EP2430520A1 (en) | Operational-related data computation engine | |
| CN110909126A (en) | Information query method and device | |
| CN114579104A (en) | Data analysis scene generation method, device, equipment and storage medium | |
| CN109903050A (en) | Transaction De-weight method, transaction building method, equipment and storage medium | |
| CN111897891B (en) | Data processing method and device | |
| US20030198850A1 (en) | Structured document mapping apparatus and method | |
| US8862609B2 (en) | Expanding high level queries | |
| CN114218266A (en) | Data query method and device, electronic equipment and storage medium | |
| US20230126509A1 (en) | Database management system and method for graph view selection for a relational-graph database | |
| Lai et al. | {GLogS}: Interactive graph pattern matching query at large scale | |
| US11954099B2 (en) | Systems, methods, and program products for providing investment expertise using a financial ontology framework | |
| CN115840738A (en) | Data migration method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20200921 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman, British Islands Patentee after: Innovative advanced technology Co.,Ltd. Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman, British Islands Patentee before: Advanced innovation technology Co.,Ltd. Effective date of registration: 20200921 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman, British Islands Patentee after: Advanced innovation technology Co.,Ltd. Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands Patentee before: Alibaba Group Holding Ltd. |
|
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20210128 Address after: 801-10, Section B, 8th floor, 556 Xixi Road, Xihu District, Hangzhou City, Zhejiang Province 310000 Patentee after: Ant financial (Hangzhou) Network Technology Co.,Ltd. Address before: Ky1-9008 business centre, 27 Hospital Road, Georgetown, grand caiman, UK Patentee before: Innovative advanced technology Co.,Ltd. |
|
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20210902 Address after: 100020 unit 02, 901, floor 9, unit 1, building 1, No.1, East Third Ring Middle Road, Chaoyang District, Beijing Patentee after: Beijing Aoxing Beisi Technology Co.,Ltd. Address before: 801-10, Section B, 8th floor, 556 Xixi Road, Xihu District, Hangzhou City, Zhejiang Province 310000 Patentee before: Ant financial (Hangzhou) Network Technology Co.,Ltd. |
|
| TR01 | Transfer of patent right |