CN108959571A - Operation method, device, terminal device and the storage medium of SQL statement - Google Patents
Operation method, device, terminal device and the storage medium of SQL statement Download PDFInfo
- Publication number
- CN108959571A CN108959571A CN201810725679.9A CN201810725679A CN108959571A CN 108959571 A CN108959571 A CN 108959571A CN 201810725679 A CN201810725679 A CN 201810725679A CN 108959571 A CN108959571 A CN 108959571A
- Authority
- CN
- China
- Prior art keywords
- numerical value
- independent variable
- subexpression
- variable numerical
- resolved
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Abstract
The invention discloses the operation method of SQL statement, device, terminal device and storage mediums.The described method includes: splitting expression formula to be resolved in SQL statement according to operator precedence, the priority of operations of subexpression and each subexpression is obtained；Operation obtains current operation as a result, the independent variable numerical value includes the numerical value of non-operation and/or the operation result of subexpression before after being substituted into the independent variable numerical value of current subexpression according to the priority of operations；Continue operation after substituting into the independent variable numerical value of next subexpression and obtain next operation result, until operation obtains the operation result of the SQL statement after the independent variable numerical value of the expression formula to be resolved is substituted into.Using this method, the operation efficiency of expression formula to be resolved can be effectively promoted.
Description
Technical field
The present embodiments relate to technical field of data processing more particularly to the operation method of SQL statement, device, terminals
Equipment and storage medium.
Background technique
Structured query language (Structured Query Language, SQL), is a kind of database manipulation language, is used
In access data and query, update, and manage relational database system.
When existing data base management system calculates the expression formula to be resolved in SQL statement, by the complete of independent variable
Portion's value is successively substituted into expression formula to be resolved and is directly calculated.Which results in duplicate when containing in expression formula to be resolved
When subexpression, duplicate subexpression is computed repeatedly, computational efficiency is lower, reduces the usage experience of user.
Summary of the invention
Operation method, device, terminal device and the storage medium of SQL statement provided by the invention, are able to ascend SQL statement
The execution performance of middle expression formula.
In a first aspect, the embodiment of the invention provides a kind of operation methods of SQL statement, comprising:
Expression formula to be resolved in SQL statement is split according to operator precedence, subexpression is obtained and each sublist reaches
The priority of operations of formula；
Operation obtains current operation knot after being substituted into the independent variable numerical value of current subexpression according to the priority of operations
Fruit, the independent variable numerical value include the numerical value of non-operation and/or the operation result of subexpression before；
Continue operation after substituting into the independent variable numerical value of next subexpression and obtain next operation result, until will it is described to
Operation obtains the operation result of the SQL statement after the independent variable numerical value of analytical expression substitutes into.
Second aspect, the embodiment of the invention also provides a kind of arithmetic units of SQL statement, comprising:
Split module, for according to operator precedence split SQL statement in expression formula to be resolved, obtain subexpression and
The priority of operations of each subexpression；
Current results computing module, for being substituted into the independent variable numerical value of current subexpression according to the priority of operations
Operation obtains current operation as a result, the independent variable numerical value includes the numerical value of non-operation and/or the fortune of subexpression before afterwards
Calculate result；
Next result computing module, for continue operation after substituting into the independent variable numerical value of next subexpression obtain it is next
Operation result, until operation obtains the operation knot of the SQL statement after the independent variable numerical value of the expression formula to be resolved is substituted into
Fruit.
The third aspect, the embodiment of the invention also provides a kind of terminal devices, comprising:
One or more processors；
Storage device, for storing one or more programs；
One or more of programs are executed by one or more of processors, so that one or more of processors
Realize the operation method of SQL statement provided in an embodiment of the present invention.
Fourth aspect, the embodiment of the invention also provides a kind of computer readable storage mediums, are stored thereon with computer
Program, the program realize the operation method of SQL statement provided in an embodiment of the present invention when being executed by processor.
The embodiment of the invention provides the operation method of SQL statement, device, terminal device and storage medium,.It is calculating
In SQL statement when expression formula to be resolved, analytical expression can be treated according to operator precedence first and be split, split out
Each subexpression and the corresponding operator precedence of each subexpression that expression formula to be resolved includes.Then according to operator
Priority chooses current subexpression from each subexpression, and the independent variable numerical value of current subexpression is substituted into current sublist and is reached
Formula operation obtains current operation result；Operation continues the independent variable numerical value of next subexpression substituting into next sublist after completing
Next operation result is obtained up to formula operation, until operation obtains SQL statement after the independent variable numerical value of expression formula to be resolved is substituted into
Operation result.Using above-mentioned technical proposal, the operand that subexpression is repeated in expression formula to be resolved can be efficiently reduced,
Improve the operation efficiency of expression formula to be resolved.When the group number of the initial argument of expression formula to be resolved is multiple groups, Ke Yizhi
Connect by multiple groups independent variable numerical value substitute into until operation obtain the operation result of SQL statement, effectively further reduce different fortune
The expense toggled between calculation greatly improves the execution performance of the SQL statement comprising expression formula.
Detailed description of the invention
Fig. 1 is a kind of flow diagram of the operation method for SQL statement that the embodiment of the present invention one provides；
Fig. 2 is a kind of flow diagram of the operation method of SQL statement provided by Embodiment 2 of the present invention；
Fig. 3 is a kind of structural schematic diagram of the arithmetic unit for SQL statement that the embodiment of the present invention three provides；
Fig. 4 is a kind of structural schematic diagram for terminal device that the embodiment of the present invention four provides.
Specific embodiment
The present invention is described in further detail with reference to the accompanying drawings and examples.It is understood that this place is retouched
The specific embodiment stated is used only for explaining the present invention rather than limiting the invention.It also should be noted that in order to just
Only the parts related to the present invention are shown in description, attached drawing rather than entire infrastructure.
It should be mentioned that some exemplary embodiments are described as before exemplary embodiment is discussed in greater detail
The processing or method described as flow chart.Although operations (or step) are described as the processing of sequence by flow chart,
Many of these operations can be implemented concurrently, concomitantly or simultaneously.In addition, the sequence of operations can be pacified again
Row.The processing can be terminated when its operations are completed, it is also possible to have the additional step being not included in attached drawing.Institute
Stating processing can correspond to method, function, regulation, subroutine, subprogram etc..
Embodiment one
Fig. 1 is a kind of flow diagram of the operation method for SQL statement that the embodiment of the present invention one provides, and this method can fit
The case where for calculating expression formula in SQL statement, this method can be executed by the arithmetic unit of SQL statement, wherein
The device can be implemented by software and/or hardware, and be typically integrated on terminal device, in the present embodiment terminal device include but
It is not limited to: the equipment such as computer, mobile phone or personal digital assistant.
Structured query language (Structured Query Language, SQL), is a kind of programming language of specific purposes
Speech is a kind of data base querying and programming language, for accessing data and querying, updating, and managing relational database system
System；It is simultaneously also the extension name of database script file.SQL statement either type or quantity are all numerous, Hen Duoyu
Sentence is also often to be used.When available data base management system calculates the expression formula to be resolved in SQL statement, it will count
According to each value gradually substitute into expression formula to be resolved and calculate.Such as when data are stored in tables of data, needing will be in tables of data
Data substitute into expression formula to be resolved line by line and calculated, computational efficiency is lower, and needs between nonidentity operation back and forth
Switching.
As shown in Figure 1, a kind of operation method for SQL statement that the embodiment of the present invention one provides, includes the following steps:
S101, expression formula to be resolved in SQL statement is split according to operator precedence, obtains subexpression and each son
The priority of operations of expression formula.
In the present embodiment, expression formula to be resolved can be understood as the medium expression formula to be calculated of SQL statement.Operator is excellent
First grade can be understood as determining the standard of the execution sequence of each operation in expression formula to be resolved.Subexpression can be understood as wait solve
Analyse expression formula included in expression formula.Priority of operations can be understood as determining the standard of each subexpression order of operation.
In an expression formula to be resolved may comprising it is multiple by nonidentity operation symbol connect, have different data class
The data object of type；Since expression formula to be resolved is there are many operation, different order of operation may obtain Different Results.Because working as
When containing a variety of operations in expression formula to be resolved, it is necessary to be combined in certain sequence, just can guarantee the reasonability and result of operation
Correctness, uniqueness.Operator precedence then determines the sequencing that operation executes in expression formula to be resolved.
It, can be based on the minimum of expression formula to be resolved when treating analytical expression based on operator precedence and being split
Arithmetic element and operator precedence are split；The fractionation degree of expression formula to be resolved can also be determined according to actual needs.
Based on after fractionation subexpression and operator precedence can determine the priority of operations of each subexpression.
Illustratively, it is assumed that SQL statement is SELECT*FROM T1WHERE C1/2 > C2；Wherein, have in WHERE clause
Expression formula " C1/2 > C2 " to be resolved, table 1 are the value table of C1 and C2, wherein C1 and C2 is two column of table 1.
| C1 | C2 |
| 1 | 0 |
| 2 | 1 |
The value table of table 1C1 and C2
Seen from table 1, the value of C1 and C2 is (1 0) and (2 1).Using the calculation of existing expression formula to be resolved
When, it needs each row of data value substituting into expression formula to be resolved, obtains an operation result, specifically:
The operation result that C1/2 > C2 obtains expression formula to be resolved can be substituted into first by the second row (1 0).It is specific: first
C1=1 substitution C1/2 is obtained 0.5；Then the operation result 0.5 of C2=0 and C1/2 is substituted into and is calculated, i.e., 0.5 > 0, obtain to
The operation result of analytical expression is true (TRUE).
After the value that C1 and C2 has been calculated is (1 0), by the third line (2 1), substitutes into C1/2 > C2 and obtain expression to be resolved
The operation result of formula.It is specific: C1=2 substitution C1/2 being obtained 1 first；Then the operation result 1 of C2=1 and C1/2 is substituted into
It calculates, i.e., 1 > 1, show that the operation result of expression formula to be resolved is false (FALSE).
In this step, then it can treat analytical expression before calculating expression formula to be resolved and be split, such as be split into
Subexpression C1/2 and C1/2 > C2.Wherein, C1/2 > C2 is expression formula to be resolved, is also considered as a subexpression.Example
Property, when each data are stored into tables of data, interim column can be respectively set in subexpression C1/2 and C1/2 > C2.Table 2 is
The split table of each subexpression.
| C1 | C2 | COL3(C1/2) | COL4(C1/2>C2) |
| 1 | 0 | 0.5 | TRUE |
| 2 | 1 | 1 | FALSE |
The split table of each subexpression of table 2
As can be seen from Table 2, the present embodiment, can be first by expression formula to be resolved when carrying out expression formula to be resolved calculating
It is split, when reaching formula if there is identical sublist, identical sublist can be merged into a column count up to formula, it is only necessary to calculate once i.e.
It can.In addition, the value (1 0) of C1 and C2 and (2 1) can be carried out operation simultaneously when the present embodiment is calculated using batch.
It is specific:
(1 0) substitution COL3 (C1/2) is obtained into operation result 0.5 first, (2 1) are then substituted into COL3 (C1/2) and are obtained
To operation result 1.After having calculated the operation result that C1 and C2 value in COL3 (C1/2) is (1 0) and (2 1), calculating C1 and C2
When value is (1 0) and (2 1), the operation result of COL4 (C1/2 > C2).The operation knot of COL3 (C1/2) can be based on when calculating
Fruit is calculated.Such as C2=0 and C1/2=0.5 is substituted into, i.e., 0.5 > 0, show that operation result is TRUE.By C2=1 and C1/2
=1 substitutes into, i.e., and 1 > 1, show that operation result is FALSE.
To sum up, when the value for calculating C1 and C2 is (1 0) and (2 1), according to existing expression formula to be resolved
Calculation then needs to switch 3 times between nonidentity operation；And it only needs to switch when being calculated by the way of in the present embodiment
1 time.It is understood that when the value of C1 and C2 increases or expression formula to be resolved is complex expression, in the present embodiment
For calculating calculation of the direction compared to existing expression formula to be resolved, opening of toggling can be largely saved between operation
Pin.
This step can carry out operation based on the subexpression after each fractionation, finally after splitting expression formula to be resolved
Obtain the operation result of expression formula to be resolved.
S102, operation after the independent variable numerical value substitution of current subexpression is currently transported according to the priority of operations
It calculates as a result, the independent variable numerical value includes the numerical value of non-operation and/or the operation result of subexpression before.
In the present embodiment, current subexpression is understood that be chosen from each subexpression according to priority of operations
It will be by the subexpression of operation.Independent variable numerical value can be understood as the value of each independent variable in expression formula to be resolved.Wherein, certainly
The initial argument and/or subexpression before that variable may include non-operation.The independent variable numerical value of current subexpression can
To be interpreted as the value of the included independent variable of current subexpression.Current operation result can be understood as the fortune of current subexpression
Calculate result.The numerical value of non-operation can be understood as in subexpression not by the numerical value of the initial argument of operation.Before
Subexpression can be understood as the subexpression before current subexpression by operation.
After splitting out each subexpression, this step can carry out operation to current subexpression according to priority of operations,
Obtain current operation result.Specifically, the independent variable numerical value of current subexpression can be substituted into operation after current subexpression
Obtain current operation result.Wherein, due in current subexpression may the subexpression containing before, therefore current subexpression
Independent variable numerical value may include the numerical value of non-operation and/or the operation result of subexpression before.
Illustratively, if expression formula to be resolved is C1/2+C1/2 > C2, which can be split into sublist
Up to formula C1/2, C1/2+C1/2 and C1/2+C1/2 > C2.It can be for first according to the order of operation of each subexpression of operator precedence
C1/2 is calculated, then calculates C1/2+C1/2, then calculates C1/2+C1/2 > C2.When current subexpression is C1/2+C1/2, when
The independent variable of preceding subexpression may include before subexpression C1/2.Therefore calculating working as current subexpression C1/2+C1/2
When preceding operation result, the operation result of subexpression C1/2 before directly can be substituted into current subexpression operation and obtained currently
Operation result.
From this expression formula (C1/2+C1/2 > C2) to be resolved as can be seen that table to be resolved directly ought be substituted into initial argument
When up to formula, C1/2 needs to calculate twice.It, will be by two when treating analytical expression analysis when using the present embodiment method
C1/2 corresponds to a subexpression, as long as calculating primary.
S103, continue operation after substituting into the independent variable numerical value of next subexpression and obtain next operation result, until will
Operation obtains the operation result of the SQL statement after the independent variable numerical value of the expression formula to be resolved substitutes into.
In the present embodiment, next subexpression is understood that be transported after current subexpression according to priority of operations
The subexpression of calculation.The independent variable numerical value of next subexpression can be understood as taking for the included independent variable of next subexpression
Value.Next operation result can be understood as the operation result of next subexpression.The independent variable numerical value of expression formula to be resolved can be with
It is interpreted as the value of independent variable included in expression formula to be resolved.
The example for being C1/2+C1/2 > C2 based on above-mentioned expression formula to be resolved, when current subexpression is C1/2+C1/2,
Next subexpression can be C1/2+C1/2 > C2.Correspondingly, the independent variable of next subexpression may include non-operation
C2 and before subexpression C1/2+C1/2.It, then can be by non-operation when calculating next subexpression C1/2+C1/2 > C2
The numerical value of C2 and the before operation result of subexpression C1/2+C1/2 substitute into obtain next operation result.It can be seen that next son
Expression formula, that is, expression formula to be resolved, therefore the operation result of next operation result, that is, SQL statement.
A kind of operation method for SQL statement that the embodiment of the present invention one provides, the expression formula to be resolved in calculating SQL statement
When, analytical expression can be treated according to operator precedence first and be split, split out that expression formula to be resolved includes is each
Subexpression and the corresponding operator precedence of each subexpression.Then according to operator precedence from each subexpression
Current subexpression is chosen, the independent variable numerical value of current subexpression is substituted into current subexpression operation and obtains current operation knot
Fruit；Operation continues the next subexpression operation of independent variable numerical value substitution of next subexpression obtaining next operation after completing
As a result, until operation after the independent variable numerical value substitution of expression formula to be resolved is obtained the operation result of SQL statement.Utilize above-mentioned side
Method can efficiently reduce the operand for repeating subexpression in expression formula to be resolved, improve the operation of expression formula to be resolved
Efficiency.When the group number of the initial argument of expression formula to be resolved is multiple groups, directly multiple groups independent variable numerical value can be substituted into straight
The operation result of SQL statement is obtained to operation, effectively further reduces the expense toggled between nonidentity operation, larger amplitude
Improve the execution performance of the SQL statement comprising expression formula to be resolved to degree.
Embodiment two
Fig. 2 is a kind of flow diagram of the operation method of SQL statement provided by Embodiment 2 of the present invention, the present embodiment two
It is optimized on the basis of the various embodiments described above.In the present embodiment, current sublist will be reached according to the priority of operations
Operation obtains current operation as a result, being further detailed as after the independent variable numerical value of formula substitutes into: the never independent variable number of operation
The independent variable numerical value of preset quantity is read in value；According to the operator precedence successively by the independent variable number of the preset quantity
Operation obtains current operation result after the independent variable numerical value of current subexpression in value substitutes into.
Further, the present embodiment will also continue operation after substituting into the independent variable numerical value of next subexpression obtain it is next
Operation result, until operation obtains the operation knot of the SQL statement after the independent variable numerical value of the expression formula to be resolved is substituted into
Fruit advanced optimizes are as follows: the independent variable numerical value for continuing next subexpression in the independent variable numerical value by the preset quantity substitutes into
Operation obtains next operation result afterwards, until expression formula to be resolved described in the independent variable numerical value by the preset quantity becomes certainly
Operation obtains the operation result of the SQL statement after numerical quantity substitutes into.
On the basis of above-mentioned optimization, continue next subexpression in the independent variable numerical value by the preset quantity described
Independent variable numerical value substitute into after operation obtain next operation result, until described in independent variable numerical value by the preset quantity to
After operation obtains the operation result of the SQL statement after the independent variable numerical value of analytical expression substitutes into, optimization includes: continuing
Never the independent variable numerical value of preset quantity is read in the independent variable numerical value of operation and to execute current operation result arithmetic operation straight
It is completed to the equal operation of independent variable numerical value.
Further, the present embodiment, which also optimizes, includes: if calculating current operation result and/or calculating next operation
Error information is received when as a result, then is directly substituted into the numerical value of the initial argument of the expression formula to be resolved described to be resolved
Operation obtains the operation result of the SQL statement after expression formula.The not yet detailed content of the present embodiment please refers to embodiment one.
As shown in Fig. 2, a kind of operation method of SQL statement provided by Embodiment 2 of the present invention, includes the following steps:
S201, expression formula to be resolved in SQL statement is split according to operator precedence, obtains subexpression and each son
The priority of operations of expression formula.
The independent variable numerical value of preset quantity is read in the independent variable numerical value of S202, never operation.
In the present embodiment, the independent variable numerical value of non-operation can be understood as not being substituted into operation in initial argument
Obtain the value of the independent variable of expression solution result to be resolved.
In splitting out expression formula to be resolved after each subexpression, this step can be never in the independent variable numerical value of operation
Read the independent variable numerical value of preset quantity.Wherein, preset quantity can be preset numerical value.The setting of preset quantity can be with
It is set according to the group number of initial argument.Illustratively, C1 and C2 is initial argument, the group number of the initial argument in table 2
It is two groups.That is, the numerical value of initial argument is (1 0) and (2 1).For table 2, expression formula to be resolved is C1/2 > C2, phase
Its initial argument answered i.e. its variable for being included, i.e. C1 and C2.
If the group number of the initial argument is M group, wherein M is positive integer.This step can never operation from
The independent variable numerical value of preset quantity (such as N group, N are the positive integer less than M) is read in variable value.Then by this read out it is pre-
If the independent variable numerical value of quantity substitutes into each subexpression, until batch operation obtains the operation result of the SQL statement.
Illustratively, the value of C1 and C2 in table 2 is extended, referring to table 3, table 3 is C1 and C2 value expansion table.
| C1 | C2 | COL3(C1/2) | COL4(C1/2>C2) |
| 1 | 0 | ||
| 2 | 1 | ||
| 2 | 2 | ||
| 1 | 1 |
Table 3C1 and C2 value expansion table
As can be seen from Table 3, the value group number of initial argument C1 and C2 is 4 groups: (1 0), (2 1), (2 2) and (1
1), 2 can be set by preset quantity herein.At this time, it is assumed that this non-operation of 4 groups of data, then what this step was read becomes certainly
Numerical quantity can be (1 0) and (2 1).This two groups of data can be subjected to batch operation after reading.
Further, the independent variable numerical value of preset quantity is read never in the independent variable numerical value of operation, comprising: if not
The group number of the independent variable numerical value of operation is greater than or equal to preset quantity, then reads never in the independent variable numerical value of operation default
The independent variable numerical value of quantity；Otherwise independent variable numerical value of the independent variable numerical value of all non-operations as preset quantity is read.
It is understood that when reading the independent variable numerical value of preset quantity in the independent variable numerical value of never operation, it can be with
First determine whether the group number of the independent variable numerical value of non-operation is greater than or equal to preset quantity, if so, can therefrom read
The independent variable numerical value of preset quantity carries out batch operation；Otherwise, it may be said that the group number of the independent variable numerical value of bright current non-operation is small
In preset quantity, then when this reads data, the independent variable numerical value of all non-operations can be read directly as present count
The independent variable numerical value of amount carries out batch operation.
S203, according to the operator precedence successively by current subexpression in the independent variable numerical value of the preset quantity
Independent variable numerical value substitute into after operation obtain current operation result.
It, can be by preset quantity after the independent variable numerical value for reading preset quantity in the independent variable numerical value of never operation
The independent variable numerical value of current subexpression in independent variable numerical value substitutes into current subexpression operation and obtains current operation result.It needs
It is noted that the current operation obtained at this time the result is that preset quantity the corresponding operation result of independent variable numerical value.
Based on the example of table 3, when the independent variable numerical value of the preset quantity read out in the independent variable numerical value of never operation
When for (1 0) and (2 1), this step can be when calculating current subexpression C1/2, successively will be current in (1 0) and (2 1)
Independent variable the numerical value C1=1 and C1=2 of subexpression C1/2 substitutes into current subexpression operation and obtains current operation as a result, current
Operation result referring to table 4, table 4 be independent variable numerical value be (1 0) and (2 1) when current operation result table.
| C1 | C2 | COL3(C1/2) | COL4(C1/2>C2) |
| 1 | 0 | 0.5 | |
| 2 | 1 | 1 | |
| 2 | 2 | ||
| 1 | 1 |
Current operation result table when 4 independent variable numerical value of table is (1 0) and (2 1)
By table 4 as it can be seen that current operation when independent variable numerical value is (1 0) and (2 1) has had been calculated at this time as a result, based on this
The operation result of lower subexpression when independent variable numerical value is (1 0) and (2 1) can be calculated.
S204, the independent variable numerical value for continuing next subexpression in the independent variable numerical value by the preset quantity are transported after substituting into
Calculation obtains next operation result, until the independent variable number of expression formula to be resolved described in independent variable numerical value by the preset quantity
Operation obtains the operation result of the SQL statement after value substitutes into.
After the independent variable numerical value based on preset quantity obtains corresponding current operation result, this step can continue will be pre-
If the independent variable numerical value of next subexpression in the independent variable numerical value of quantity, which substitutes into next subexpression, obtains next fortune with operation
Calculate result.
Based on the example of table 4, after the current operation result 0.5 and 1 for having determined current subexpression C1/2, this step can
Successively by the independent variable numerical value C2=0 of subexpression C1/2 > C2 next in (1 0) and (2 1), C1/2=0.5；C2=1,
Operation obtains next operation result TRUE and FALSE after C1/2=1 is substituted into.At this time i.e. obtained independent variable numerical value be (1 0) and
The operation result of SQL statement when (2 1), referring to table 5, table 5 be independent variable numerical value be (1 0) and (2 1) when next operation
As a result.
| C1 | C2 | COL3(C1/2) | COL4(C1/2>C2) |
| 1 | 0 | 0.5 | TRUE |
| 2 | 1 | 1 | FALSE |
| 2 | 2 | ||
| 1 | 1 |
Next operation result when 5 independent variable numerical value of table is (1 0) and (2 1)
By table 5 as it can be seen that at present by independent variable numerical value be (1 0) and (2 1) when expression solution to be resolved completion.This
The independent variable numerical value that embodiment can continue to read preset quantity in the independent variable numerical value of non-operation at present carries out operation.
S205, judge whether receive error information when calculating current operation result and/or calculating next operation result,
If so, executing S206；If it is not, then executing S207.
It is all calculated in advance by the operation result of each subexpression in this present embodiment, in some expression to be resolved
The subexpression for not needing to calculate may also be calculated in advance in formula.It malfunctions when if calculating at this time, this mistake can
It can not need to return to user.However the mode of batch operation can not judge this in the present embodiment.Therefore into
When row batch calculates, if mistake occurs, this batch data (the independent variable numerical value for the preset quantity chosen) is converted to non-batch
Amount operation, it can execute S206；Otherwise, it may be said that the bright corresponding SQL statement of independent variable numerical value in the operation preset quantity
Operation result when there is not mistake, then can execute S207.
S206, it is transported after the numerical value of the initial argument of the expression formula to be resolved is directly substituted into the expression formula to be resolved
Calculation obtains the operation result of the SQL statement.
It, then can be direct when receiving error information when calculating current operation result and/or calculating next operation result
The numerical value of initial argument in expression formula to be resolved is substituted into the direct operation of expression formula to be resolved and obtains the operation knot of SQL statement
Fruit.It should be noted that the initial argument can refer to that generation reports an error when batch operation obtains the operation result of SQL statement
Preset quantity independent variable.
Illustratively, if expression formula to be resolved is CASE WHEN C1 > 1 THEN C1/C2 ELSE C2/C1 END,
When carrying out batch operation using the independent variable numerical value for reading preset quantity in the independent variable numerical value of never operation, can first it calculate
The operation result of subexpression C1 > 1 out, C1/C2, C2/C1, until calculating the CASE WHEN THEN C1/C2 of C1 > 1 ELSE
The operation result of C2/C1 END.
Table 6 is operation result table.It is assumed that the independent variable numerical value of the preset quantity read is (1 0) and (2 1).
6 operation result table of table
As can be seen from Table 6, when calculating subexpression C1/C2, one is produced except zero error, but this mistake is
Without returning to user, because in calculating initial argument C1=1, C2=0, C1 > 1 expression formula CASE WHEN to be resolved
In THEN C1/C2 ELSE C2/C1 END C1 > 1 be FALSE return be C2/C1 operation result 0, without calculating C1/C2
Operation result.Therefore this batch of independent variable numerical value (1 0) in the expression formula to be resolved and (2 1) directly can be substituted into table to be resolved
Direct operation obtains the operation result 0 and 2 of SQL statement after up to formula.
In addition, if expression formula to be resolved in table 6 is revised as the CASE WHEN THEN C1/C2 ELSE of C1 > 0 C2/
C1 END, then should just report an error to user.It is also that mistake can all occur for non-batch calculating that either batch, which calculates, at this time.But
It in the present embodiment, is changed into and this batch data is calculated using non-batch mode, by non-batch when mistake occurs for batch operation
Amount calculation judges whether to report an error to user.Wherein batch operation can be understood as reading in the independent variable numerical value of never operation
The independent variable numerical value of preset quantity is taken until the equal operation of independent variable numerical value is completed.Non- batch operation can be understood as using S206
In operation, i.e., the numerical value of initial argument is directly substituted into expression solution to be resolved and obtains the operation result of SQL statement.
S207, judge that the whether equal operation of independent variable numerical value is completed, if so, executing S208；If it is not, then executing S202.
The numerical value of initial argument expression formula to be resolved is substituted into after not receiving error information or receiving error information to transport
After having obtained the operation result of SQL, this step can further judge that the whether equal operation of independent variable numerical value is completed.I.e. whether also
There is the independent variable numerical value of non-operation.If equal operation is completed, S208 can be executed；Otherwise, it can return and execute S202, continue
Never the independent variable numerical value of preset quantity is read in the independent variable numerical value of operation until the equal operation of independent variable numerical value is completed.It is based on
For table 5, the independent variable numerical value of non-operation is (2 2) and (1 1), this continues to choose two groups, i.e. selection (2 0) and (1 1)
The calculating for continuing current operation result and next operation result, for the result after the completion of calculating referring to table 7, table 7 is most to terminate
Fruit table.
| C1 | C2 | COL3(C1/2) | COL4(C1/2>C2) |
| 1 | 0 | 0.5 | TRUE |
| 2 | 1 | 1 | FALSE |
| 2 | 2 | 1 | FALSE |
| 1 | 1 | 0.5 | TRUE |
7 final result table of table
By table 7 as it can be seen that the equal operation of whole values of the initial argument C1 and C2 of expression formula C1/2 > C2 to be resolved at present is complete
At.
S208, end.
After the completion of judging the equal operation of independent variable, then it can terminate the operation of expression formula to be resolved.
A kind of operation method of SQL statement provided by Embodiment 2 of the present invention embodies current operation result operation behaviour
Make and next operation result arithmetic operation；Also optimization includes report an error processing operation and the determining operation of operation completion.Utilize the party
Method can effectively reduce the operand of duplicate subexpression in expression formula to be resolved, promote the operation effect of expression formula to be resolved
Rate.And when treating analytical expression progress operation, the independent variable numerical value batch of non-operation, which is carried out operation, reduces meter
The expense that calculation machine operational order toggles between nonidentity operation can significantly promote the SQL statement comprising expression formula
Execution performance.
More specifically, the specific implementation process of the operation method of SQL statement can be such that in the present embodiment
This is sentenced for each data store in table form, in calculating SQL statement when expression formula, is taken out in table every time
N row data (N is preset value) disposably carry out expression formula calculating to this N row data, reduce Computing instruction
The expense toggled between nonidentity operation can greatly promote the execution of the SQL statement comprising expression formula to be resolved
Performance.Such as:
The first step is treated analytical expression and is analyzed, and is treated according to the operator precedence that expression formula to be resolved calculates
Analytical expression is split, and is arranged according to the successive of priority (priority of operations) is calculated for intermediate result (each subexpression)
Interim column；
Second step, according to preset batch value N, reads N item number if number of data lines unread in table is greater than N from table
According to, turn third step execution；If unread number of data lines is less than N, all unread data are read, third step is turned；If without not
Data are read, calculates and completes to exit；
Third step, according to the analysis of the first step as a result, carrying out batch operation to all data read in second step.In if
Between have error, turn the 4th step；Otherwise turn second step after the completion of batch operation；
4th step is calculated this batch data by non-batch mode, turns second step after the completion.
Embodiment three
Fig. 3 is a kind of structural schematic diagram of the arithmetic unit for SQL statement that the embodiment of the present invention three provides, which can fit
The case where for calculating expression formula in SQL statement, wherein the device can be implemented by software and/or hardware, and generally collect
At on the terminal device.
As shown in figure 3, the arithmetic unit of the SQL statement includes: to split module 31, current results computing module 32 and next
As a result computing module 33.
Wherein, module 31 is split, for splitting expression formula to be resolved in SQL statement according to operator precedence, obtains son
The priority of operations of expression formula and each subexpression；
Current results computing module 32, for according to the priority of operations by the independent variable numerical value generation of current subexpression
Enter rear operation and obtains current operation as a result, numerical value that the independent variable numerical value includes non-operation and/or subexpression before
Operation result；
Next result computing module 33 obtains down for continuing operation after substituting into the independent variable numerical value of next subexpression
One operation result, until operation obtains the operation of the SQL statement after the independent variable numerical value of the expression formula to be resolved is substituted into
As a result.
In the present embodiment, the arithmetic unit of the SQL statement is torn open by splitting module 31 according to operator precedence first
Divide expression formula to be resolved in SQL statement, obtains the priority of operations of subexpression and each subexpression；Then by current
As a result operation obtains currently after computing module 32 substitutes into the independent variable numerical value of current subexpression according to the priority of operations
Operation result, the independent variable numerical value include the numerical value of non-operation and/or the operation result of subexpression before；Finally by
Next result computing module 33 continues operation after substituting into the independent variable numerical value of next subexpression and obtains next operation result, directly
Operation obtains the operation result of the SQL statement to after substituting into the independent variable numerical value of the expression formula to be resolved.
A kind of arithmetic unit of SQL statement is present embodiments provided, can efficiently reduce in expression formula to be resolved and repeat
The operand of subexpression improves the operation efficiency of expression formula to be resolved.When the group of the initial argument of expression formula to be resolved
When number is multiple groups, can directly multiple groups independent variable numerical value be substituted into until operation obtains the operation result of SQL statement, further be had
Effect ground reduces the expense toggled between nonidentity operation, greatly improves the execution of the SQL statement comprising expression formula
Performance.
Further, current results computing module 32, comprising: numerical value reading unit, the independent variable for never operation
The independent variable numerical value of preset quantity is read in numerical value；Current results arithmetic element is used for according to the operator precedence successively
Operation obtains current operation knot after the independent variable numerical value of subexpression current in the independent variable numerical value of the preset quantity is substituted into
Fruit.
On the basis of above-mentioned optimization, next result computing module 33 is specifically used for: continue by the preset quantity from
Operation obtains next operation result after the independent variable numerical value of next subexpression in variable value substitutes into, until by the present count
Operation obtains the operation knot of the SQL statement after the independent variable numerical value of expression formula to be resolved described in the independent variable numerical value of amount substitutes into
Fruit.
Based on the above-mentioned technical proposal, the arithmetic unit of the SQL statement, also optimization include: determining module 34 is completed in operation,
The independent variable numerical value of preset quantity is read in independent variable numerical value for continuing never operation and executes current operation result fortune
Operation is calculated until the equal operation of independent variable numerical value is completed.
Further, numerical value reading unit is specifically used for: if the group number of the independent variable numerical value of non-operation is greater than or waits
In preset quantity, then the independent variable numerical value of preset quantity is read never in the independent variable numerical value of operation；Otherwise it reads all not
Independent variable numerical value of the independent variable numerical value of operation as preset quantity.
Based on the above-mentioned technical proposal, the arithmetic unit of the SQL statement, also optimization include: the processing module that reports an error 35 is used for
It, directly will be described to be resolved when receiving error information when calculating current operation result and/or calculating next operation result
Operation obtains the operation result of the SQL statement after the numerical value of the initial argument of expression formula substitutes into the expression formula to be resolved.
The operation method of SQL statement provided by any embodiment of the invention can be performed in the arithmetic unit of above-mentioned SQL statement,
Have the corresponding functional module of execution method and beneficial effect.
Example IV
Fig. 4 is a kind of structural schematic diagram for terminal device that the embodiment of the present invention four provides.As shown in figure 4, the present invention is real
The terminal device for applying the offer of example four includes: one or more processors 41 and storage device 42；Processor in the terminal device
41 can be one or more, in Fig. 4 by taking a processor 41 as an example；Storage device 42 is for storing one or more programs；
One or more of programs are executed by one or more of processors 41, so that one or more of processors 41 are realized
The operation method of SQL statement as described in any one of embodiment of the present invention.
The terminal device can also include: input unit 43 and output device 44.
Processor 41, storage device 42, input unit 43 and output device 44 in terminal device can by bus or
Other modes connect, in Fig. 4 for being connected by bus.
Storage device 42 in the terminal device is used as a kind of computer readable storage medium, can be used for storing one or more
A program, described program can be software program, computer executable program and module, such as the embodiment of the present invention one or two institutes
Corresponding program instruction/the module of operation method of SQL statement is provided (for example, in the arithmetic unit of attached SQL statement shown in Fig. 3
Module, comprising: split module 31, current results computing module 32 and next result computing module 33；Further include: operation is completed
Determining module 34 and the processing module 35 that reports an error).Processor 41 is by running the software program being stored in storage device 42, instruction
And module, thereby executing the various function application and data processing of terminal device, i.e. SQL in realization above method embodiment
The operation method of sentence.
Storage device 42 may include storing program area and storage data area, wherein storing program area can storage program area,
Application program needed at least one function；Storage data area, which can be stored, uses created data etc. according to terminal device.
It can also include nonvolatile memory in addition, storage device 42 may include high-speed random access memory, for example, at least one
A disk memory, flush memory device or other non-volatile solid state memory parts.In some instances, storage device 42 can
It further comprise the memory remotely located relative to processor 41, these remote memories can be by network connection to setting
It is standby.The example of above-mentioned network includes but is not limited to internet, intranet, local area network, mobile radio communication and combinations thereof.
Input unit 43 can be used for receiving the number or character information of input, and generate the user setting with terminal device
And the related key signals input of function control.Output device 44 may include that display screen etc. shows equipment.
Also, when one or more included program of above-mentioned terminal device is held by one or more of processors 41
When row, program is proceeded as follows: being split expression formula to be resolved in SQL statement according to operator precedence, is obtained subexpression
With the priority of operations of each subexpression；The independent variable numerical value of current subexpression is substituted into according to the priority of operations
Operation obtains current operation as a result, the independent variable numerical value includes the numerical value of non-operation and/or the fortune of subexpression before afterwards
Calculate result；Continue operation after substituting into the independent variable numerical value of next subexpression and obtain next operation result, until will it is described to
Operation obtains the operation result of the SQL statement after the independent variable numerical value of analytical expression substitutes into.
Embodiment five
The embodiment of the present invention five provides a kind of computer readable storage medium, is stored thereon with computer program, the journey
For executing the operation method of SQL statement when sequence is executed by processor, this method comprises: splitting SQL according to operator precedence
Expression formula to be resolved in sentence obtains the priority of operations of subexpression and each subexpression；According to the operator precedence
Operation obtains current operation as a result, the independent variable numerical value includes not transporting after grade substitutes into the independent variable numerical value of current subexpression
The operation result of the numerical value and/or subexpression before calculated；Continue to transport after substituting into the independent variable numerical value of next subexpression
Calculation obtains next operation result, until operation obtains the SQL language after the independent variable numerical value of the expression formula to be resolved is substituted into
The operation result of sentence.
Optionally, it can be also used for executing SQL provided by any embodiment of the invention when which is executed by processor
The operation method of sentence.
The computer storage medium of the embodiment of the present invention, can be using any of one or more computer-readable media
Combination.Computer-readable medium can be computer-readable signal media or computer readable storage medium.It is computer-readable
Storage medium for example may be-but not limited to-the system of electricity, magnetic, optical, electromagnetic, infrared ray or semiconductor, device or
Device, or any above combination.The more specific example (non exhaustive list) of computer readable storage medium includes: tool
There are electrical connection, the portable computer diskette, hard disk, random access memory (Random Access of one or more conducting wires
Memory, RAM), read-only memory (Read Only Memory, ROM), erasable programmable read only memory (Erasable
Programmable Read Only Memory, EPROM), flash memory, optical fiber, portable CD-ROM, light storage device, magnetic storage
Device or above-mentioned any appropriate combination.Computer readable storage medium, which can be, any includes or storage program has
Shape medium, the program can be commanded execution system, device or device use or in connection.
Computer-readable signal media may include in a base band or as carrier wave a part propagate data-signal,
Wherein carry computer-readable program code.The data-signal of this propagation can take various forms, including but unlimited
In: electromagnetic signal, optical signal or above-mentioned any appropriate combination.Computer-readable signal media can also be that computer can
Any computer-readable medium other than storage medium is read, which can send, propagates or transmit and be used for
By the use of instruction execution system, device or device or program in connection.
The program code for including on computer-readable medium can transmit with any suitable medium, including but not limited to:
Wirelessly, electric wire, optical cable, radio frequency (Radio Frequency, RF) etc. or above-mentioned any appropriate combination.
The computer for executing operation of the present invention can be write with one or more programming languages or combinations thereof
Program code, described program design language include object oriented program language-such as Java, Smalltalk, C++, also
Including conventional procedural programming language-such as " C " language or similar programming language.Program code can be complete
Ground executes on the user computer, partly executes on the user computer, executing as an independent software package, partially existing
Part executes on the remote computer or executes on a remote computer or server completely on subscriber computer.It is being related to
In the situation of remote computer, remote computer can pass through the network of any kind --- including local area network (LAN) or wide area
Net (WAN) --- it is connected to subscriber computer, or, it may be connected to outer computer (such as provided using Internet service
Quotient is connected by internet).
Note that the above is only a better embodiment of the present invention and the applied technical principle.It will be appreciated by those skilled in the art that
The invention is not limited to the specific embodiments described herein, be able to carry out for a person skilled in the art it is various it is apparent variation,
It readjusts and substitutes without departing from protection scope of the present invention.Therefore, although being carried out by above embodiments to the present invention
It is described in further detail, but the present invention is not limited to the above embodiments only, without departing from the inventive concept, also
It may include more other equivalent embodiments, and the scope of the invention is determined by the scope of the appended claims.
Claims (10)
1. a kind of operation method of SQL statement characterized by comprising
Expression formula to be resolved in SQL statement is split according to operator precedence, obtains subexpression and each subexpression
Priority of operations；
Operation obtains current operation as a result, institute after being substituted into the independent variable numerical value of current subexpression according to the priority of operations
State the operation result of the numerical value that independent variable numerical value includes non-operation and/or subexpression before；
Continue operation after substituting into the independent variable numerical value of next subexpression and obtain next operation result, until will be described to be resolved
Operation obtains the operation result of the SQL statement after the independent variable numerical value of expression formula substitutes into.
2. the method according to claim 1, wherein it is described according to the priority of operations by current subexpression
Independent variable numerical value substitute into after operation obtain current operation result, comprising:
Never the independent variable numerical value of preset quantity is read in the independent variable numerical value of operation；
According to the operator precedence successively by the independent variable of subexpression current in the independent variable numerical value of the preset quantity
Operation obtains current operation result after numerical value substitutes into.
3. according to the method described in claim 2, it is characterized in that, described continued the independent variable numerical value generation of next subexpression
Enter rear operation and obtain next operation result, until described in operation obtains after the independent variable numerical value of the expression formula to be resolved is substituted into
The operation result of SQL statement, comprising:
Operation obtains down after continuing the independent variable numerical value substitution of next subexpression in the independent variable numerical value by the preset quantity
One operation result, until after the independent variable numerical value of expression formula to be resolved described in independent variable numerical value by the preset quantity substitutes into
Operation obtains the operation result of the SQL statement.
4. according to the method described in claim 3, it is characterized in that, continuing described by the independent variable numerical value of the preset quantity
In next subexpression independent variable numerical value substitute into after operation obtain next operation result, until by the preset quantity from becoming
After operation obtains the operation result of the SQL statement after the independent variable numerical value of expression formula to be resolved described in numerical quantity substitutes into,
Further include:
Continue to read the independent variable numerical value of preset quantity in the never independent variable numerical value of operation and executes current operation result fortune
Operation is calculated until the equal operation of independent variable numerical value is completed.
5. according to the method described in claim 2, it is characterized in that, being read in the independent variable numerical value of the never operation default
The independent variable numerical value of quantity, comprising:
If the group number of the independent variable numerical value of non-operation is greater than or equal to preset quantity, never the independent variable numerical value of operation
The middle independent variable numerical value for reading preset quantity；Otherwise independent variable numerical value the becoming certainly as preset quantity of all non-operations is read
Numerical quantity.
6. the method according to claim 1, wherein further include:
It, directly will be described if receiving error information when calculating current operation result and/or calculating next operation result
Operation obtains the operation of the SQL statement after the numerical value of the initial argument of expression formula to be resolved substitutes into the expression formula to be resolved
As a result.
7. a kind of arithmetic unit of SQL statement characterized by comprising
Module is split, for splitting expression formula to be resolved in SQL statement according to operator precedence, obtains subexpression and each institute
State the priority of operations of subexpression；
Current results computing module, for being transported after being substituted into the independent variable numerical value of current subexpression according to the priority of operations
Calculation obtains current operation as a result, the independent variable numerical value includes the numerical value of non-operation and/or the operation knot of subexpression before
Fruit；
Next result computing module obtains next operation for continuing operation after substituting into the independent variable numerical value of next subexpression
As a result, until operation after the independent variable numerical value substitution of the expression formula to be resolved is obtained the operation result of the SQL statement.
8. device according to claim 7, which is characterized in that further include:
Report an error processing module, for when calculate current operation result and/or calculate next operation result when receive the letter that reports an error
When breath, operation obtains institute after the numerical value of the initial argument of the expression formula to be resolved is directly substituted into the expression formula to be resolved
State the operation result of SQL statement.
9. a kind of terminal device characterized by comprising
One or more processors；
Storage device, for storing one or more programs；
One or more of programs are executed by one or more of processors, so that one or more of processors are realized
Such as the operation method of SQL statement of any of claims 1-6.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the program is by processor
The operation method such as SQL statement of any of claims 1-6 is realized when execution.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810725679.9A CN108959571B (en) | 2018-07-04 | 2018-07-04 | SQL statement operation method and device, terminal equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810725679.9A CN108959571B (en) | 2018-07-04 | 2018-07-04 | SQL statement operation method and device, terminal equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108959571A true CN108959571A (en) | 2018-12-07 |
| CN108959571B CN108959571B (en) | 2020-12-04 |
Family
ID=64485471
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810725679.9A Active CN108959571B (en) | 2018-07-04 | 2018-07-04 | SQL statement operation method and device, terminal equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108959571B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110032574A (en) * | 2019-03-07 | 2019-07-19 | 北京东方国信科技股份有限公司 | The processing method and processing device of SQL statement |
| WO2021022702A1 (en) * | 2019-08-07 | 2021-02-11 | 平安科技（深圳）有限公司 | Log insertion method and apparatus, computer apparatus and storage medium |
| CN113157720A (en) * | 2020-01-23 | 2021-07-23 | 阿里巴巴集团控股有限公司 | Query statement processing method, device, equipment and medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101763339A (en) * | 2009-12-21 | 2010-06-30 | 金蝶软件（中国）有限公司 | Business bill conversion method, device and system |
| CN102446164A (en) * | 2010-10-12 | 2012-05-09 | 金蝶软件（中国）有限公司 | Analytic method, device and operation system of report formula |
| CN107798025A (en) * | 2016-09-05 | 2018-03-13 | 华为技术有限公司 | Operation, Compilation Method, device and the Database Systems of storing process |
| US20180181680A1 (en) * | 2016-12-22 | 2018-06-28 | Hewlett Packard Enterprise Development Lp | Ordering regular expressions |
-
2018
- 2018-07-04 CN CN201810725679.9A patent/CN108959571B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101763339A (en) * | 2009-12-21 | 2010-06-30 | 金蝶软件（中国）有限公司 | Business bill conversion method, device and system |
| CN102446164A (en) * | 2010-10-12 | 2012-05-09 | 金蝶软件（中国）有限公司 | Analytic method, device and operation system of report formula |
| CN107798025A (en) * | 2016-09-05 | 2018-03-13 | 华为技术有限公司 | Operation, Compilation Method, device and the Database Systems of storing process |
| US20180181680A1 (en) * | 2016-12-22 | 2018-06-28 | Hewlett Packard Enterprise Development Lp | Ordering regular expressions |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110032574A (en) * | 2019-03-07 | 2019-07-19 | 北京东方国信科技股份有限公司 | The processing method and processing device of SQL statement |
| CN110032574B (en) * | 2019-03-07 | 2021-02-02 | 北京东方国信科技股份有限公司 | SQL statement processing method and device |
| WO2021022702A1 (en) * | 2019-08-07 | 2021-02-11 | 平安科技（深圳）有限公司 | Log insertion method and apparatus, computer apparatus and storage medium |
| CN113157720A (en) * | 2020-01-23 | 2021-07-23 | 阿里巴巴集团控股有限公司 | Query statement processing method, device, equipment and medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108959571B (en) | 2020-12-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108090177B (en) | Multi-round question-answering system generation method, equipment, medium and multi-round question-answering system | |
| CN108959571A (en) | Operation method, device, terminal device and the storage medium of SQL statement | |
| CN111242164A (en) | Decision result determination method, device and equipment | |
| CN109960650A (en) | Application assessment method, apparatus, medium and electronic equipment based on big data | |
| CN109710951A (en) | Supplementary translation method, apparatus, equipment and storage medium based on translation history | |
| CN108415939A (en) | Dialog process method, apparatus, equipment and computer readable storage medium based on artificial intelligence | |
| CN111460815A (en) | Rule processing method, apparatus, medium, and electronic device | |
| CN114925651A (en) | Circuit routing determination method and related equipment | |
| CN112506503B (en) | Programming method, device, terminal equipment and storage medium | |
| CN111475165A (en) | Intelligent compiling method, system, terminal and storage medium for application program | |
| CN113568605A (en) | Method, device and system for configuring constrained route | |
| CN109408539A (en) | Data manipulation method, device, server and storage medium | |
| US10606843B2 (en) | Irreducible modules | |
| CN114490969B (en) | Question and answer method and device based on table and electronic equipment | |
| CN114064125B (en) | Instruction analysis method and device and electronic equipment | |
| CN109977011A (en) | Automatic generation method, device, storage medium and the electronic equipment of test script | |
| CN113312025B (en) | Component library generation method and device, storage medium and electronic equipment | |
| CN113778401A (en) | Page generation method and device | |
| CN110532577B (en) | Digital logic circuit compiling method and device | |
| CN113010182B (en) | Method and device for generating upgrade file and electronic equipment | |
| CN111309884A (en) | Robot dialogue method, device, medium, and electronic apparatus | |
| CN114756474B (en) | Method and device for generating random vector in CPU verification and electronic equipment | |
| CN115951936B (en) | Chip adaptation method, device, equipment and medium of vectorization compiler | |
| CN109992714A (en) | Information recommendation method, device, medium and electronic equipment based on financial big data | |
| CN109656728A (en) | Page data operating method, device, equipment and 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |