CN110515971A - Program statement processing method, device, computer equipment and computer storage medium - Google Patents
Program statement processing method, device, computer equipment and computer storage medium Download PDFInfo
- Publication number
- CN110515971A CN110515971A CN201910734559.XA CN201910734559A CN110515971A CN 110515971 A CN110515971 A CN 110515971A CN 201910734559 A CN201910734559 A CN 201910734559A CN 110515971 A CN110515971 A CN 110515971A
- Authority
- CN
- China
- Prior art keywords
- sentence
- statement
- program
- query result
- repeat
- 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/24539—Query rewriting; Transformation using cached or materialised query results
-
- 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/2455—Query execution
- G06F16/24552—Database cache management
Abstract
This application involves a kind of program statement processing method, device, computer equipment and computer storage mediums.Method includes: acquisition program statement；Determine the repeat statement in program statement；When repeat statement is the first sentence for inquiry, the corresponding query result of the first sentence is obtained；Caching query results；When detecting containing target program sentence identical with field is inquired in the first sentence, corresponding objective result is inquired from the query result of caching according to target program sentence.It can be improved the treatment effeciency of program statement using the scheme of the application.
Description
Technical field
This application involves field of computer technology, set more particularly to a kind of program statement processing method, device, computer
Standby and computer storage medium.
Background technique
With the development of computer technology, program is more and more perfect, and therefore, the sentence quantity in each program is also increasingly
It is more.When there is redundancy in while statement, it may appear that the case where calling repeatedly.Current program statement processing method, there are treatment effeciencies
Low problem.
Summary of the invention
Based on this, it is necessary in view of the above technical problems, provide a kind of program that can be improved program statement treatment effeciency
Sentence processing method, device, computer equipment and computer storage medium.
A kind of program statement processing method, method include: acquisition program statement；Determine the repeat statement in program statement；
When repeat statement is the first sentence for inquiry, the corresponding query result of the first sentence is obtained；Caching query results；Work as inspection
When measuring containing with the identical target program sentence of field is inquired in the first sentence, according to target program sentence from the inquiry of caching
As a result the corresponding objective result of inquiry in.
In one of the embodiments, when repeat statement is the first sentence for inquiry, it is corresponding to obtain the first sentence
Query result, comprising: when repeat statement is the first sentence for inquiry, and the parameter in repeat statement does not change
When, obtain the corresponding query result of the first sentence.
In one of the embodiments, when repeat statement is the first sentence for inquiry, it is corresponding to obtain the first sentence
Query result, comprising: when repeat statement is the first sentence for inquiry, and the parameter in repeat statement changes, and
Repeat statement not in the circulating cycle when, obtain the corresponding query result of the first sentence.According to target program sentence from the inquiry of caching
As a result the corresponding objective result of inquiry in, comprising: according in target program sentence inquiry field and corresponding parameter postpone
Corresponding objective result is inquired in the query result deposited.
In one of the embodiments, when repeat statement is the first sentence for inquiry, it is corresponding to obtain the first sentence
Query result, comprising: when repeat statement is the first sentence for inquiry, and the parameter in repeat statement changes, and
Repeat statement in the circulating cycle when, execute the corresponding circulation of repeat statement；When circulation is finished, circulation result is obtained；According to
It recycles result and obtains the corresponding query result of the first sentence.
The mode of detection repeat statement in the circulating cycle in one of the embodiments, comprising: obtain following in program statement
Ring beginning label and corresponding circulation terminate label；When repeat statement is that circulation beginning label and corresponding circulation terminate mark
When sentence between note, determine repeat statement in the circulating cycle.
The corresponding query result of the first sentence is obtained in one of the embodiments, comprising: it is corresponding to obtain the first sentence
The information content of query result；When the information content of query result is less than or equal to information content threshold value, query result is obtained.
The repeat statement in program statement is determined in one of the embodiments, comprising: when the execution number of program statement
When greater than default execution number, by the repetition ratio for calling program statistics program sentence at least twice；When the ratio of repetition is greater than
When preset ratio, determine that program statement is repeat statement.
Program statement processing method in one of the embodiments, further include: when repeat statement is for update
Two sentences, and the second sentence in the circulating cycle when, execute the corresponding circulation of the second sentence；It is reached when executing the corresponding circulation of the second sentence
When to preset loop number, the corresponding database of the second sentence is updated.
A kind of program statement processing unit, described device include:
First obtains module, for obtaining program statement；
Determining module, for determining the repeat statement in program statement；
Second obtains module, for it is corresponding to obtain the first sentence when repeat statement is the first sentence for inquiry
Query result；
Cache module is used for caching query results；
Enquiry module, for when detecting containing with the identical target program sentence of field is inquired in the first sentence, root
Corresponding objective result is inquired from the query result of caching according to target program sentence.
A kind of computer equipment, including memory and processor, the memory are stored with computer program, the processing
Device performs the steps of acquisition program statement when executing the computer program；Determine the repeat statement in program statement；When weight
When multiple sentence is the first sentence for inquiry, the corresponding query result of the first sentence is obtained；Caching query results；When detecting
When containing with inquiring the identical target program sentence of field in the first sentence, according to target program sentence from the query result of caching
It is middle to inquire corresponding objective result.
A kind of computer readable storage medium, is stored thereon with computer program, and the computer program is held by processor
Acquisition program statement is performed the steps of when row；Determine the repeat statement in program statement；When repeat statement is for inquiry
When the first sentence, the corresponding query result of the first sentence is obtained；Caching query results；When detect containing with looked into the first sentence
When asking the identical target program sentence of field, corresponding target knot is inquired from the query result of caching according to target program sentence
Fruit.
Above procedure sentence processing method, device, computer equipment and storage medium are determined by obtaining program statement
Repeat statement in program statement can obtain the redundant code in program statement；When repeat statement is the first language for inquiry
When sentence, obtain the corresponding query result of the first sentence, caching query results, when detect containing with inquire field in the first sentence
When identical target program sentence, corresponding objective result is inquired from the query result of caching according to target program sentence, then
When encountering the repeat statement in program, not needing to traverse entire database or file path etc., it is only necessary to inquiry is primary, after
It is continuous directly to obtain improving the treatment effeciency of program statement as a result, optimize the program from caching.
Detailed description of the invention
Fig. 1 is the applied environment figure of program statement processing method in one embodiment；
Fig. 2 is the flow diagram of program statement processing method in one embodiment；
Fig. 3 is the flow diagram that repeat statement is determined in one embodiment；
Fig. 4 is the flow diagram of program statement processing method in another embodiment；
Fig. 5 is the structural block diagram of program statement processing unit in one embodiment；
Fig. 6 is the internal structure chart of computer equipment in one embodiment.
Specific embodiment
It is with reference to the accompanying drawings and embodiments, right in order to which the objects, technical solutions and advantages of the application are more clearly understood
The application is further elaborated.It should be appreciated that specific embodiment described herein is only used to explain the application, not
For limiting the application.
The program statement method provided in the embodiment of the present application, can be applied in the computer equipment such as Fig. 1.The calculating
Machine equipment can be terminal or server.Wherein, terminal can be, but not limited to be various personal computers, laptop, intelligence
It can mobile phone, tablet computer and portable wearable device.Server can use independent server either multiple server groups
At server cluster realize.
In one embodiment, as shown in Fig. 2, providing a kind of program statement processing method, it is applied to Fig. 1 in this way
Computer equipment for be illustrated, comprising the following steps:
Step 202, program statement is obtained.
Wherein, program statement refers to the sentence write as with program language.Program language for example can be C language, C++ or
SQL (Structured Query Language, structured query language) etc. is without being limited thereto.So program statement can be C language
Speech sentence, C++ sentence or SQL statement etc. are without being limited thereto.Program statement can be by number, letter, one of symbol or a variety of
Composition.
Specifically, computer equipment obtains all journeys in a certain program from third party device or the computer equipment
Sequence sentence.
Step 204, the repeat statement in program statement is determined.
Wherein, repeat statement refers to the sentence repeated in this procedure.The quantity of repeat statement is unlimited.
Specifically, computer equipment traverses the program, determines the sentence repeated in all program statements.
In the present embodiment, computer equipment traverses a secondary program, is greater than when detecting in program statement in the presence of execution number
When default execution number, determine that the program statement is repeat statement.
For example, circulation 1:(is recycled 10 times)
Label (circulation 1 starts)
Select*from id=4
Label (circulation 1 terminates)
So, select*from id=4 has been recycled 10 times, which can be repeat statement.
In the present embodiment, computer equipment traverses a secondary program, and it is big to there is execution number in storage or label program statement
In the default program statement for executing number.Alternatively, computer equipment calls the program at least twice, the weight of the program statement is counted
Again several repetition ratios with call number determine that the program statement is repeat statement when the ratio of repetition is greater than preset ratio.
Step 206, when repeat statement is the first sentence for inquiry, the corresponding query result of the first sentence is obtained.
Wherein, it for example can be the first sentence for inquiring content from database for the first sentence of inquiry, or
Person inquires the first sentence of content from alternative document path, or inquires the first sentence of content from network by network.With
It is without being limited thereto that banner string, such as " select " etc. may be present in the sentence of inquiry.
Specifically, when the repeat statement is the first sentence for inquiry, computer equipment is looked into according to first sentence
Inquiry obtains corresponding query result.
Step 208, the query result is cached.
Wherein, caching refers to the memory that can carry out high-speed data exchange.
Specifically, computer equipment can directly cache the query result.
In the present embodiment, computer equipment obtains the information content of the query result.When the information content of the query result is less than
Or when being equal to presupposed information amount, cache the query result.When containing much information when presupposed information amount for the query result, issues and accuse
Alert information.
Step 210, when detecting containing target program sentence identical with field is inquired in the first sentence, according to target
Program statement inquires corresponding objective result from the query result of caching.
Wherein, for may include inquiry field and parameter in the first sentence of inquiry.Inquiry field can be in the first language
With the content of query function in sentence.Parameter refers to data constant or variable in the first sentence.Parameter under prescribed conditions can
Take fixed value.For example, parameter can be 1.Or parameter is variable i, i=i+1 etc. is without being limited thereto.Target program sentence is and
The identical sentence of inquiry field in one sentence.The identical target program sentence of inquiry field may include that inquiry field and parameter are equal
Identical program statement, or field is identical but the different program statement of parameter for inquiry.
Specifically, the identical content sources for illustrating inquiry of inquiry field are identical.When detect containing in first sentence
When inquiring the identical target program sentence of field, corresponding target is inquired from the query result of caching according to target program sentence
As a result.
In the present embodiment, when computer equipment detect containing with that field is inquired in the first sentence is identical and parameter is identical
When target program sentence, the query result of the caching is directly acquired according to target program sentence.
In the present embodiment, when computer equipment detect containing from that field is inquired in first sentence is identical but parameter is different
Target program sentence when, corresponding objective result is inquired from the query result of caching according to target program sentence.Wherein, when
When in the parameter including regular expression, inquired from the query result of caching according to the regular expression in target program sentence
Corresponding objective result.
In the present embodiment, when corresponding objective result can not be inquired from the query result of caching according to object statement
When, which is inquired from source path according to the inquiry field of object statement.
For example, the first sentence is " select from table 1where name in difilterArray ", wherein
IdfilterArray is parameter, and inquiry field is " select from table 1where name " or " select from table
1where name in”。
The result inquired according to the first sentence is recorded in Result and is cached.
Target program sentence is " select from table 1where name=1 ", then traverses in Result, work as Result
In there are name=1, then obtain the corresponding objective result of target program sentence.
When name=1 is not present in Result, then inquiring " select from table 1where name=1 " in table 1.
In above procedure sentence processing method, by obtaining program statement, determines the repeat statement in program statement, can obtain
Redundant code into program statement；When repeat statement is the first sentence for inquiry, obtain that the first sentence is corresponding to be looked into
It askes as a result, caching query results, when detecting containing target program sentence identical with inquiry field in the first sentence, according to
Target program sentence inquires corresponding objective result from the query result of caching, then when encountering the repeat statement in program,
Do not need to traverse entire database or file path etc., it is only necessary to inquiry is primary, it is subsequent can directly be obtained from caching as a result,
Optimize the program, improves the treatment effeciency of program statement.
In one embodiment, a kind of program statement processing method, this method comprises: obtaining SQL statement；Determine SQL language
Repeat statement in sentence；When repeat statement is the first sentence for inquiry, the corresponding query result of the first sentence is obtained；It is slow
Deposit query result；When detecting containing target program sentence identical with field is inquired in first sentence, according to target
Program statement inquires corresponding objective result from the query result of caching.
In above procedure sentence processing method, by obtaining program statement, determines the repeat statement in program statement, can obtain
Redundant code into program statement；When repeat statement is the first sentence for inquiry, obtain that the first sentence is corresponding to be looked into
It askes as a result, caching query results, when detecting containing target program sentence identical with inquiry field in the first sentence, according to
Target program sentence inquires corresponding objective result from the query result of caching, then when encountering the repeat statement in program,
It does not need repeatedly to call SQL database or file path etc., it is only necessary to it calls once, it is subsequent directly to be tied from caching
Fruit optimizes the program, improves the treatment effeciency of program statement.
In one embodiment, when repeat statement is the first sentence for inquiry, obtain that the first sentence is corresponding to be looked into
Ask result, comprising: when repeat statement is the first sentence for inquiry, and the parameter in repeat statement does not change, obtain
Take the corresponding query result of the first sentence.
Such as repeat statement is " select from table 1where name=1 ", the parameter in repeat statement is " 1 ", and
" 1 " does not change, and repeat statement is " select from table 1where name in difilterArray ", then repeating
Parameter in sentence is " difilterArray ".
Specifically, computer equipment detects whether the repeat statement is the first sentence for inquiry.When repeat statement is
When the first sentence for inquiry, whether the parameter in computer equipment detection repeat statement changes.When in repeat statement
Parameter when not changing, computer equipment inquires to obtain corresponding query result according to the first sentence.
In the present embodiment, when the information content of the query result is less than or equal to presupposed information amount, the query result is cached.
In the present embodiment, the repetition in circulation includes querying condition and all identical circulation of content in circulation, such as:
It recycles 1:(to recycle 10 times)
Label (circulation 1 starts)
Select*from id=4
Label (circulation 1 terminates)
Wherein, select*from id=4 is repeat statement, and parameter therein is " 4 ", is not changed, then computer
For equipment when executing the circulation for the first time, computer equipment obtains the corresponding query result of the first sentence, and caches.
Above procedure sentence processing method, when repeat statement is the first sentence for inquiry, and the ginseng in repeat statement
When number does not change, the corresponding query result of the first sentence is obtained, and cache the query result, can be used in optimizing the journey
Sequence improves the treatment effeciency of program statement.
In one embodiment, when repeat statement is the first sentence for inquiry, obtain that the first sentence is corresponding to be looked into
Ask result, comprising: when repeat statement is the first sentence for inquiry, and the parameter in repeat statement changes, and repeats
Sentence not in the circulating cycle when, obtain the corresponding query result of the first sentence.According to target program sentence from the query result of caching
The corresponding objective result of middle inquiry, comprising: according in target program sentence inquiry field and corresponding parameter from caching
Corresponding objective result is inquired in query result.
Wherein, circulation refers to circulation, such as " for " or " while " sentence in C language sentence of program etc..It repeats
It is an independent sentence in any one circulation that sentence does not refer to the repeat statement not in the circulating cycle.
Specifically, computer equipment detects whether the repeat statement is the first sentence for inquiry.When repeat statement is
When the first sentence for inquiry, whether the parameter in computer equipment detection repeat statement changes.When in repeat statement
Parameter when changing, computer equipment inquires to obtain corresponding query result according to the first sentence.Cache the query result.
Computer equipment according in the target program sentence inquiry field and corresponding parameter inquired from the query result of caching
Corresponding objective result.
In the present embodiment, when the information content of query result is less than or equal to presupposed information amount, the query result is cached.
Above procedure sentence processing method, when repeat statement is the first sentence for inquiry, and the ginseng in repeat statement
Number changes, and repeat statement not in the circulating cycle when, obtain the corresponding query result of the first sentence, can directly store parameter
The corresponding query result of changed repeat statement, can be used in optimizing the program, improves the treatment effeciency of program statement.
In one embodiment, when repeat statement is the first sentence for inquiry, obtain that the first sentence is corresponding to be looked into
Ask result, comprising: when repeat statement is the first sentence for inquiry, and the parameter in repeat statement changes, and repeats
Sentence in the circulating cycle when, execute the corresponding circulation of repeat statement；When circulation is finished, circulation result is obtained；According to circulation
As a result the corresponding query result of the first sentence is obtained.
Specifically, computer equipment detects whether the repeat statement is the first sentence for inquiry.When repeat statement is
When the first sentence for inquiry, whether the parameter in computer equipment detection repeat statement changes.When in repeat statement
Parameter when changing, whether in the circulating cycle computer equipment detects repeat statement.When repeat statement in the circulating cycle when, calculate
Machine equipment executes the circulation where repeat statement.When the circulation is finished, circulation result is obtained.Computer equipment is according to following
Ring result obtains the corresponding query result of the first sentence.
For example,
State a set idfilterArray
State array array
Circulation: traversal array, current cycle time i
idfilterArray.add(array.get(i))
Circulation terminates
Select*from table 1where name in difilterArray
So, it is only necessary to call the table 1 in a database that query result can be obtained.
Above procedure sentence processing method, when repeat statement is the first sentence for inquiry, and the ginseng in repeat statement
Number changes, and repeat statement in the circulating cycle when, execute the corresponding circulation of repeat statement；When circulation is finished, obtain
Circulation can inquire primary as a result, according to the corresponding query result of circulation result the first sentence of acquisition to avoid every circulation primary
Database, but a database is just inquired at the end of circulation, improve program statement treatment effeciency.
In one embodiment, detection repeat statement mode in the circulating cycle, comprising: obtain circulation beginning label and right
The circulation answered terminates to mark；When repeat statement is to recycle the sentence between beginning label and corresponding circulation end label,
Determine repeat statement in the circulating cycle.
Specifically, computer equipment obtains circulation beginning label and corresponding circulation end label in program statement.
When repeat statement after recycling beginning label and circulation terminate label before when, determine the repeat statement in the circulating cycle.
Example is as follows:
Circulation 1:
Mark cycle 1 starts
Circulation 2:
Mark cycle 2 starts
Sentence 1
Sentence 2
…
Mark cycle 2 terminates
Mark cycle 1 terminates
It is also the first sentence for inquiry, then computer equipment can determine that sentence 1 exists if sentence 1 is repeat statement
In circulation 2.
In the present embodiment, computer equipment, which obtains circulation beginning label and corresponding circulation, terminates label.When the repetition
When sentence is that target circulation beginning label and corresponding target circulation terminate the sentence between label, wherein the target circulation
Beginning label and corresponding target circulation terminate label for marking target circulation, determine the repeat statement in the target circulation
In.
In above procedure sentence processing method, can by cycle labeling so that it is determined that repeat statement whether in the circulating cycle,
Improve program statement treatment effeciency.
In one embodiment, the corresponding query result of the first sentence is obtained, comprising: obtain the corresponding inquiry of the first sentence
As a result information content；When the information content of the query result is less than or equal to information content threshold value, query result is obtained.
Wherein, information content is the how many measurement of information.The memory size that information content, that is, information occupies.The unit of information content has
It is without being limited thereto that body can be KB (kilobyte, kilobytes), MB (Mebibyte, Mbytes) etc..The information content of query result can
It is calculated according to the attribute size of query result and data volume.Data volume specifically can be the item number for referring to data.
Specifically, computer equipment obtains the information content of the corresponding query result of the first sentence.Computer equipment judgement is looked into
Whether the information content for asking result is greater than presupposed information amount threshold value.When computer equipment detects that the information content of the query result is less than
Or when being equal to presupposed information amount threshold value, query result is obtained, the query result is cached.
In the present embodiment, query result is made of attribute, and attribute is a kind of data, and data have the data type of oneself, than
Such as varchar [20].The maximum length of Varchar [20] is 20.Such as the content of record is remarks, and the length of remarks is not
Limit may be 5, may be 8, therefore calculate by maximum length 20.Each several bits of length representative, the two product are exactly one
Memory shared by attribute.All attributes sum it up after calculating shared memory in such a way, this and be exactly memory shared by a data
Size.It is multiplied again with the data volume of query result, obtains the occupied memory size of query result, the i.e. information of query result
Amount.It is when containing much information when information content threshold value for the query result, then exceeded.
In the present embodiment, when containing much information when information content threshold value for query result, warning information is issued.
In above procedure sentence processing method, the information content of the corresponding query result of the first sentence is obtained, when the inquiry knot
When the information content of fruit is less than or equal to information content threshold value, query result is obtained, the query result is cached, can be avoided because caching is looked into
It askes result and causes data volume excessive, avoid the operation for influencing other programs, improve program statement processing speed.
In one embodiment, the repeat statement in described program sentence is determined, comprising: when the execution number of program statement
When greater than default execution number, by the repetition ratio for calling program statistics program sentence at least twice；When the ratio of repetition is greater than
When preset ratio, determine that program statement is repeat statement.
Wherein, presetting execution number can be in computer equipment or the preset number critical value of server.Preset ratio
It can be the preset ratio threshold in computer equipment or server.Repeat ratio can be the program statement number and
The ratio of the number of caller.
Specifically, computer equipment calls a secondary program, and the execution number of the program statement in determining program.When the journey
The execution number of sequence sentence in the database is greater than default execution number, and by calling, program counts the program intermediate range at least twice
The repetition ratio of sequence sentence.When the repetition ratio is greater than preset ratio, determine that the program statement is repeat statement.
In the present embodiment, computer equipment calls a method, the duplicate SQL statement of a certain item occurs, records duplicate
SQL statement.If it is q that this, which repeats SQL statement, computer equipment continues to determine, determination method are as follows: computer equipment call method A
Secondary, the number that q is judged as repeating SQL statement in A times is n, and n is more than that preset ratio then determines that q is to repeat SQL statement.N herein
It can also be more than that preset ratio is replaced with n/A more than threshold value.Wherein, method is the concept of computer thread, and thread is by a series of steps
Rapid composition.Computer equipment calls a method, that is, computer equipment to call a thread.
In the present embodiment, such as the default number that executes is 1, then the sentence in circulation is then to execute number to be greater than default hold
The sentence of row number.Computer equipment passes through the repetition ratio for calling program statistics program sentence at least twice, when the ratio of repetition
When greater than preset ratio, determine that the circulation is repeat statement.
In the present embodiment, there may be different API when calling the program every time due to computer equipment
(Application Programming Interface, application programming interface).So, computer equipment is called multiple
When program, different program statements may be obtained.Therefore, the repetition ratio after having called program every time may not be identical.
In the present embodiment, as shown in figure 3, for the flow diagram for determining repeat statement in one embodiment, comprising:
Step 302, program statement is obtained.
Step 304, it is determined whether there is the program statement not detected.
Specifically, when there is the program statement not detected, step 306 is executed；When there is no the program statements not detected
When, terminate.
Step 306, when the program statement is the first sentence for inquiry, judge that the execution number of the program statement is
It is no to be greater than default execution number.
Specifically, when the execution number of the program statement is greater than default execution number, step 308 is executed；When the program
When the execution number of sentence is less than or equal to default execution number, 304 are returned to step.
Step 308, by calling program statistics repetition ratio at least twice.
Step 310, judge to repeat whether ratio is greater than default repetition ratio.
Specifically, when the repetition ratio is less than or equal to default repetition ratio, 304 are returned to step.
Step 312, when the ratio of repetition is greater than default repetition ratio, determine that the program statement is repeat statement, and record.
Above procedure sentence processing method passes through calling when the execution number of program statement is greater than default execution number
The repetition ratio of program statistics program sentence at least twice determines that program statement is attached most importance to when the ratio of repetition is greater than preset ratio
Multiple sentence, can determine the repeat statement in program statement, and optimize processing to repeat statement, improves the place of program statement
Manage efficiency.
In one embodiment, program statement processing method further include: when the repeat statement is second for update
Sentence, and second sentence in the circulating cycle when, execute the corresponding circulation of the second sentence；It is reached when executing the corresponding circulation of the second sentence
When to preset loop number, the corresponding database of the second sentence is updated.
Wherein, refer to for the second sentence of update for carrying out increase operation, delete operation, modification behaviour in the database
The sentence of at least one of work.When the second sentence in the circulating cycle when, illustrate that the second sentence needs batch updating.Preset loop number
The cycle-index that can be stored in computer equipment or server.Preset loop number for example can be 5 times, it is 10 inferior.
Specifically, for single method, i.e. computer equipment calls a secondary program.When the repeat statement is for update
Second sentence, and second sentence in the circulating cycle when, execute the corresponding circulation of the second sentence.When computer equipment executes the second language
When the corresponding circulation of sentence reaches preset loop number, the corresponding database of the second sentence of batch updating.For example, the second sentence is corresponding
Circulation be 30 times, then updating the corresponding data of the second sentence when executing the corresponding circulation of the second sentence and often reaching 10 times
Library.Alternatively, the corresponding circulation of the second sentence is 30 times, then executing the second sentence corresponding circulation when reaching 30 times, that is, recycle
Last time when, update the corresponding database of the second sentence.When being directed to multiple method, i.e. multiple threads, repeat statement can
It records in the database, becomes hot spot data.
In above procedure sentence processing method, when the repeat statement is the second sentence for update, and second sentence
When in the circulating cycle, the corresponding circulation of the second sentence is executed, i.e. second sentence needs batch updating, then when executing the second sentence
Corresponding circulation updates the corresponding database of the second sentence when reaching preset loop number, is avoided that circulation just updates every time for execution
Once, database update number is reduced, program statement treatment effeciency is improved.
In one embodiment, program statement processing method further include: when the repeat statement is second for update
When sentence, in the storehouse that computer equipment display is called.
Wherein, storehouse refers to the data structure of arranged in sequence, can only data item is inserted into and be deleted at one end.Storehouse
It can refer to what repeat statement was generated in which position of which method.It may include method, audit, position etc. in storehouse.Its
In, audit can be used for tracking and recording the event occurred in SQL Server example or database.Audit mainly includes audit pair
As (Audit) and audit specification (Audit Specification).
In above procedure sentence processing method, when the repeat statement is the second sentence for update, set in computer
The storehouse that standby display is called, can intuitively display data renewal process, and be easy to find loophole, improve what data updated
Efficiency and safety.
In one embodiment, as shown in figure 3, the process for program statement processing method in another embodiment is illustrated
Figure, comprising:
Step 402, computer equipment obtains repeat statement.
Step 404, computer equipment judges whether the repeat statement is that additions and deletions change sentence.
Specifically, the equipment of computer judges whether the repeat statement is the second sentence for update.
Step 406, when the repeat statement is that additions and deletions change sentence, warning information is issued to prompt operation maintenance personnel.
Step 408, computer equipment obtains the instruction whether optimized.
Step 410, when computer equipment gets optimization instruction, sentence is changed to the additions and deletions and carries out batch processing.
Step 412, when the repeat statement is not that additions and deletions change sentence, i.e., the repeat statement is query statement, judge that this is heavy
Whether the parameter in multiple sentence is identical.
Specifically, i.e. computer equipment judges whether the parameter in the repeat statement changes.
Step 414, computer equipment judges query result according to query result parameter type maximum value and result set quantity
It is whether exceeded.
Specifically, the information of query result can be obtained according to query result parameter type maximum value and result set quantity
Amount.It is whether exceeded as whether more than presupposed information amount.
Step 416, when the query result is exceeded, computer equipment issues warning information to prompt operation maintenance personnel.
Step 418, when the query result is not exceeded, the query result is cached.If subsequent identical in the presence of inquiry field
Sentence then uses this result.
Specifically, when getting target program sentence identical in the presence of inquiry field, the target journey is obtained from caching
The corresponding query result of sequence sentence.
Step 420, when the parameter in the repeat statement is not identical, judge the repeat statement whether in the circulating cycle.
Step 422, when the repeat statement in the circulating cycle when, retrospect reference, by circulation level organizational parameter.
Specifically, when the repeat statement in the circulating cycle when, corresponding circulation is executed according to the parameter in circulation.
Step 424, computer equipment judges query result according to query result parameter type maximum value and result set quantity
It is whether exceeded.
Step 426, when the query result is exceeded, computer equipment issues warning information to prompt operation maintenance personnel.
Step 428, when the query result is not exceeded, the query result is cached.If it is subsequent exist inquiry field it is identical but
The different sentence of parameter then calls this as a result, carrying out parameter matching, and lookup result.
In above procedure sentence processing method, by determining the repeat statement in program statement, it can obtain in program statement
Redundant code；Change the judgement of sentence, parameter, circulation by additions and deletions, can different sentences be done with different processing, then when encountering journey
It when repeat statement in sequence, does not need repeatedly to call database or file path etc., it is only necessary to call primary, judge inquiry knot
The data volume of fruit, the caching query results when data volume is not exceeded avoid occupying excessive memory, subsequent to obtain directly from caching
To as a result, optimize the program, the treatment effeciency of program statement is improved.
In one embodiment, a kind of program statement processing method, comprising:
Step (a1) obtains database program sentence.
Step (a2), determines the repeat statement in database program sentence.
Step (a3), when repeat statement is the first sentence for inquiry, and the parameter in repeat statement does not change
When, obtain the corresponding query result of the first sentence.
Step (a4), when repeat statement is the first sentence for inquiry, and the parameter in repeat statement changes, and
Repeat statement not in the circulating cycle when, obtain the corresponding query result of the first sentence.
Step (a5), when repeat statement is the first sentence for inquiry, and the parameter in repeat statement changes, and
Repeat statement in the circulating cycle when, execute the corresponding circulation of repeat statement；When circulation is finished, circulation result is obtained；According to
It recycles result and obtains the corresponding query result of the first sentence.
Step (a6), caching query results.
Step (a7), when detecting containing target program sentence identical with field is inquired in the first sentence, according to mesh
Mark program statement inquires corresponding objective result from the query result of caching.
Step (a8), when repeat statement is the second sentence for update, and the second sentence in the circulating cycle when, execute second
The corresponding circulation of sentence；When the corresponding circulation of the second sentence of execution reaches preset loop number, it is corresponding to update the second sentence
Database.
In above procedure sentence processing method, by obtaining program statement, determines the repeat statement in program statement, can obtain
Redundant code into program statement；When repeat statement is the first sentence for inquiry, obtain that the first sentence is corresponding to be looked into
It askes as a result, caching query results, when detecting containing target program sentence identical with inquiry field in the first sentence, according to
Target program sentence inquires corresponding objective result from the query result of caching, then when encountering the repeat statement in program,
Do not need to traverse entire database or file path etc., it is only necessary to inquiry is primary, it is subsequent can directly be obtained from caching as a result,
Optimize the program, improves the treatment effeciency of program statement.
It should be understood that although each step in the flow chart of Fig. 3 and Fig. 4 is successively shown according to the instruction of arrow,
But these steps are not that the inevitable sequence according to arrow instruction successively executes.Unless expressly state otherwise herein, these
There is no stringent sequences to limit for the execution of step, these steps can execute in other order.Moreover, in Fig. 3 and Fig. 4
At least part step may include that perhaps these sub-steps of multiple stages or stage are not necessarily same to multiple sub-steps
One moment executed completion, but can execute at different times, and the execution in these sub-steps or stage sequence is also not necessarily
Be successively carry out, but can at least part of the sub-step or stage of other steps or other steps in turn or
Alternately execute.
In one embodiment, Fig. 5 is the structural block diagram of program statement processing unit in one embodiment.As shown in figure 5,
Provide a kind of program statement processing unit, comprising: first obtains module 502, determining module 504, second obtains module 506,
Cache module 508 and enquiry module 510, in which:
First obtains module 502, for obtaining program statement.
Determining module 504, for determining the repeat statement in program statement.
Second obtains module 506, for it is corresponding to obtain the first sentence when repeat statement is the first sentence for inquiry
Query result.
Cache module 508 is used for caching query results.
Enquiry module 510, for when detecting containing with the identical target program sentence of field is inquired in the first sentence,
Corresponding objective result is inquired from the query result of caching according to target program sentence.
In above procedure sentence processing unit, by obtaining program statement, determines the repeat statement in program statement, can obtain
Redundant code into program statement；When repeat statement is the first sentence for inquiry, obtain that the first sentence is corresponding to be looked into
It askes as a result, caching query results, when detecting containing target program sentence identical with inquiry field in the first sentence, according to
Target program sentence inquires corresponding objective result from the query result of caching, then when encountering the repeat statement in program,
Do not need to traverse entire database or file path etc., it is only necessary to inquiry is primary, it is subsequent can directly be obtained from caching as a result,
Optimize the program, improves the treatment effeciency of program statement.
In one embodiment, the first acquisition module 502 is for obtaining SQL statement.Determining module 504 is for determining SQL
Repeat statement in sentence.Second, which obtains module 506, is used to obtain first when repeat statement is the first sentence for inquiry
The corresponding query result of sentence.Cache module 508 is used for caching query results.Enquiry module 510 be used for when detect containing with
When inquiring the identical target program sentence of field in the first sentence, inquired from the query result of caching according to target program sentence
Corresponding objective result.
In above procedure sentence processing unit, by obtaining program statement, determines the repeat statement in program statement, can obtain
Redundant code into program statement；When repeat statement is the first sentence for inquiry, obtain that the first sentence is corresponding to be looked into
It askes as a result, caching query results, when detecting containing target program sentence identical with inquiry field in the first sentence, according to
Target program sentence inquires corresponding objective result from the query result of caching, then when encountering the repeat statement in program,
It does not need repeatedly to call SQL database or file path etc., it is only necessary to it calls once, it is subsequent directly to be tied from caching
Fruit can optimize the program in the case where there is program statement redundancy, improve the treatment effeciency of program statement.
In one embodiment, second module 506 is obtained for being the first sentence for inquiry when repeat statement, and again
When parameter in multiple sentence does not change, the corresponding query result of the first sentence is obtained.
Above procedure sentence processing unit, when repeat statement is the first sentence for inquiry, and the ginseng in repeat statement
When number does not change, the corresponding query result of the first sentence is obtained, and cache the query result, can be used in optimizing the journey
Sequence improves the treatment effeciency of program statement.
In one embodiment, second module 506 is obtained for being the first sentence for inquiry when repeat statement, and again
Parameter in multiple sentence changes, and repeat statement not in the circulating cycle when, obtain the corresponding query result of the first sentence.Inquiry
Module 510 be used for according in target program sentence inquiry field and corresponding parameter inquired from the query result of caching pair
The objective result answered.
Above procedure sentence processing unit, when repeat statement is the first sentence for inquiry, and the ginseng in repeat statement
Number changes, and repeat statement not in the circulating cycle when, obtain the corresponding query result of the first sentence, can directly store parameter
The corresponding query result of changed repeat statement, can be used in optimizing the program, improves the treatment effeciency of program statement.
In one embodiment, second module 506 is obtained for being the first sentence for inquiry when repeat statement, and again
Parameter in multiple sentence changes, and repeat statement in the circulating cycle when, execute the corresponding circulation of repeat statement；When circulation executes
When finishing, circulation result is obtained；The corresponding query result of the first sentence is obtained according to circulation result.
Above procedure sentence processing unit, when repeat statement is the first sentence for inquiry, and the ginseng in repeat statement
Number changes, and repeat statement in the circulating cycle when, execute the corresponding circulation of repeat statement；When circulation is finished, obtain
Circulation can inquire primary as a result, according to the corresponding query result of circulation result the first sentence of acquisition to avoid every circulation primary
Database, but a database is just inquired at the end of circulation, improve program statement treatment effeciency.
In one embodiment, the second acquisition module 506 is for taking circulation beginning label and corresponding circulation to terminate mark
Note；When repeat statement is to recycle the sentence between beginning label and corresponding circulation end label, determine that repeat statement exists
In circulation.
In above procedure sentence processing unit, can by cycle labeling so that it is determined that repeat statement whether in the circulating cycle,
Improve program statement treatment effeciency.
In one embodiment, the second acquisition module 506 is used to obtain the information content of the corresponding query result of the first sentence；
When the information content of the query result is less than or equal to information content threshold value, query result is obtained.
In above procedure sentence processing unit, the information content of the corresponding query result of the first sentence is obtained, when the inquiry knot
When the information content of fruit is less than or equal to information content threshold value, query result is obtained, the query result is cached, can be avoided because caching is looked into
It askes result and causes data volume excessive, avoid the operation for influencing other programs, improve program statement processing speed.
In one embodiment, determining module 504 is used for when the execution number of program statement is greater than default execution number,
By the repetition ratio for calling program statistics program sentence at least twice；When the ratio of repetition is greater than preset ratio, program is determined
Sentence is repeat statement.
In above procedure sentence processing unit, the information content of the corresponding query result of the first sentence is obtained, when the inquiry knot
When the information content of fruit is less than or equal to information content threshold value, query result is obtained, the query result is cached, can be avoided because caching is looked into
It askes result and causes data volume excessive, avoid the operation for influencing other programs, improve program statement processing speed.
In one embodiment, which further includes update module.Update module is used to work as the repetition
Sentence is the second sentence for update, and second sentence in the circulating cycle when, execute the corresponding circulation of the second sentence；Work as execution
When the corresponding circulation of second sentence reaches preset loop number, the corresponding database of the second sentence is updated.
In above procedure sentence processing unit, when the repeat statement is the second sentence for update, and second sentence
When in the circulating cycle, the corresponding circulation of the second sentence is executed, i.e. second sentence needs batch updating, then when executing the second sentence
Corresponding circulation updates the corresponding database of the second sentence when reaching preset loop number, is avoided that circulation just updates every time for execution
Once, database update number is reduced, program statement treatment effeciency is improved.
In one embodiment, which further includes display module.The display module is used for when this is heavy
When multiple sentence is the second sentence for update, in the storehouse that terminal display is called.
In above procedure sentence processing unit, when the repeat statement is the second sentence for update, shown in terminal
The storehouse of calling, can intuitively display data renewal process, and be easy to find loophole, improve the efficiency that data update with
And safety.
Specific about program statement processing unit limits the limit that may refer to above for program statement processing method
Fixed, details are not described herein.Modules in above procedure sentence processing unit can fully or partially through software, hardware and its
Combination is to realize.Above-mentioned each module can be embedded in the form of hardware or independently of in the processor in computer equipment, can also be with
It is stored in the memory in computer equipment in a software form, in order to which processor calls the above modules of execution corresponding
Operation.
In one embodiment, a kind of computer equipment is provided, which can be terminal, internal structure
Figure can be as shown in Figure 6.The computer equipment includes processor, the memory, network interface, display connected by system bus
Screen and input unit.Wherein, the processor of the computer equipment is for providing calculating and control ability.The computer equipment is deposited
Reservoir includes non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with operating system and computer journey
Sequence.The built-in storage provides environment for the operation of operating system and computer program in non-volatile memory medium.The calculating
The network interface of machine equipment is used to communicate with external terminal by network connection.When the computer program is executed by processor with
Realize a kind of program statement processing method.The display screen of the computer equipment can be liquid crystal display or electric ink is shown
Screen, the input unit of the computer equipment can be the touch layer covered on display screen, be also possible on computer equipment shell
Key, trace ball or the Trackpad of setting can also be external keyboard, Trackpad or mouse etc..
It will be understood by those skilled in the art that structure shown in Fig. 6, only part relevant to application scheme is tied
The block diagram of structure does not constitute the restriction for the computer equipment being applied thereon to application scheme, specific computer equipment
It may include perhaps combining certain components or with different component layouts than more or fewer components as shown in the figure.
In one embodiment, a kind of computer equipment, including memory and processor are provided, is stored in memory
Computer program, the processor realize the step in above-mentioned each embodiment of the method when executing computer program.
In one embodiment, a kind of computer readable storage medium is provided, computer program is stored thereon with, is calculated
Machine program realizes the step in above-mentioned each embodiment of the method when being executed by processor.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, the computer program can be stored in a non-volatile computer
In read/write memory medium, the computer program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein,
To any reference of memory, storage, database or other media used in each embodiment provided herein,
Including non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), programming ROM
(PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include
Random access memory (RAM) or external cache.By way of illustration and not limitation, RAM is available in many forms,
Such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate sdram (DDRSDRAM), enhancing
Type SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM
(RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..
Each technical characteristic of above embodiments can be combined arbitrarily, for simplicity of description, not to above-described embodiment
In each technical characteristic it is all possible combination be all described, as long as however, the combination of these technical characteristics be not present lance
Shield all should be considered as described in this specification.
The several embodiments of the application above described embodiment only expresses, the description thereof is more specific and detailed, but simultaneously
It cannot therefore be construed as limiting the scope of the patent.It should be pointed out that coming for those of ordinary skill in the art
It says, without departing from the concept of this application, various modifications and improvements can be made, these belong to the protection of the application
Range.Therefore, the scope of protection shall be subject to the appended claims for the application patent.
Claims (11)
1. a kind of program statement processing method, which comprises
Obtain program statement；
Determine the repeat statement in described program sentence；
When the repeat statement is the first sentence for inquiry, the corresponding query result of first sentence is obtained；
Cache the query result；
When detecting containing target program sentence identical with field is inquired in first sentence, according to the target program
Sentence inquires corresponding objective result from the query result of caching.
2. the method according to claim 1, wherein described when the repeat statement is the first language for inquiry
When sentence, the corresponding query result of first sentence is obtained, comprising:
When the repeat statement is the first sentence for inquiry, and the parameter in the repeat statement does not change, obtain
Take the corresponding query result of first sentence.
3. the method according to claim 1, wherein described when the repeat statement is the first language for inquiry
When sentence, the corresponding query result of first sentence is obtained, comprising:
When the repeat statement is the first sentence for inquiry, and the parameter in repeat statement changes, and the repetition
Sentence not in the circulating cycle when, obtain the corresponding query result of first sentence；
It is described that corresponding objective result is inquired from the query result of caching according to the target program sentence, comprising:
According in the target program sentence inquiry field and corresponding parameter inquired from the query result of caching
Corresponding objective result.
4. the method according to claim 1, wherein described when the repeat statement is the first language for inquiry
When sentence, the corresponding query result of first sentence is obtained, comprising:
When the repeat statement is the first sentence for inquiry, and the parameter in the repeat statement changes, and described
Repeat statement in the circulating cycle when, execute the corresponding circulation of the repeat statement；
When the circulation is finished, circulation result is obtained；
The corresponding query result of first sentence is obtained according to the circulation result.
5. according to the method described in claim 4, it is characterized in that, the mode of detection repeat statement in the circulating cycle, comprising:
The circulation beginning label and corresponding circulation obtained in program statement terminates label；
When the repeat statement is to recycle the sentence between beginning label and corresponding circulation end label, determine described heavy
Multiple sentence is in the circulating cycle.
6. according to claim 1 to method described in 5 any one, which is characterized in that acquisition first sentence is corresponding
Query result, comprising:
Obtain the information content of the corresponding query result of first sentence；
When the information content of the query result is less than or equal to information content threshold value, query result is obtained.
7. method according to any one of claims 1 to 5, which is characterized in that the weight in the determining described program sentence
Multiple sentence, comprising:
When the execution number of described program sentence is greater than default execution number, by calling the program statistics journey at least twice
The repetition ratio of sequence sentence；
When the repetition ratio is greater than preset ratio, determine that described program sentence is repeat statement.
8. method according to any one of claims 1 to 5, which is characterized in that the method also includes:
When the repeat statement is the second sentence for update, and second sentence in the circulating cycle when, execute described second
The corresponding circulation of sentence；
When the corresponding circulation of execution second sentence reaches preset loop number, the corresponding data of second sentence are updated
Library.
9. a kind of program statement processing unit, which is characterized in that described device includes:
First obtains module, for obtaining program statement；
Determining module, for determining the repeat statement in described program sentence；
Second obtains module, for obtaining first sentence pair when the repeat statement is the first sentence for inquiry
The query result answered；
Cache module, for caching the query result；
Enquiry module, for when detecting containing with the identical target program sentence of field is inquired in first sentence, root
Corresponding objective result is inquired from the query result of caching according to the target program sentence.
10. a kind of computer equipment, including memory and processor, the memory are stored with computer program, feature exists
In the step of processor realizes any one of claims 1 to 8 the method when executing the computer program.
11. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program
The step of method described in any item of the claim 1 to 8 is realized when being executed by processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910734559.XA CN110515971B (en) | 2019-08-09 | 2019-08-09 | Program statement processing method, device, computer equipment and computer storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910734559.XA CN110515971B (en) | 2019-08-09 | 2019-08-09 | Program statement processing method, device, computer equipment and computer storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110515971A true CN110515971A (en) | 2019-11-29 |
| CN110515971B CN110515971B (en) | 2022-03-11 |
Family
ID=68624576
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910734559.XA Active CN110515971B (en) | 2019-08-09 | 2019-08-09 | Program statement processing method, device, computer equipment and computer storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110515971B (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103020146A (en) * | 2012-11-22 | 2013-04-03 | 华为技术有限公司 | Data processing method and equipment |
| CN104572979A (en) * | 2014-12-31 | 2015-04-29 | 北京锐安科技有限公司 | SQL (Structured Query Language) processing method and device |
| US20170153979A1 (en) * | 2014-03-04 | 2017-06-01 | International Business Machines Corporation | Dynamic result set caching with a database accelerator |
| CN107391730A (en) * | 2017-08-02 | 2017-11-24 | 郑州云海信息技术有限公司 | A kind of SQL statement processing method and processing device |
| CN109857760A (en) * | 2018-12-22 | 2019-06-07 | 中国平安人寿保险股份有限公司 | Quick response search method and device, computer installation and storage medium |
| CN110032574A (en) * | 2019-03-07 | 2019-07-19 | 北京东方国信科技股份有限公司 | The processing method and processing device of SQL statement |
-
2019
- 2019-08-09 CN CN201910734559.XA patent/CN110515971B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103020146A (en) * | 2012-11-22 | 2013-04-03 | 华为技术有限公司 | Data processing method and equipment |
| US20170153979A1 (en) * | 2014-03-04 | 2017-06-01 | International Business Machines Corporation | Dynamic result set caching with a database accelerator |
| CN104572979A (en) * | 2014-12-31 | 2015-04-29 | 北京锐安科技有限公司 | SQL (Structured Query Language) processing method and device |
| CN107391730A (en) * | 2017-08-02 | 2017-11-24 | 郑州云海信息技术有限公司 | A kind of SQL statement processing method and processing device |
| CN109857760A (en) * | 2018-12-22 | 2019-06-07 | 中国平安人寿保险股份有限公司 | Quick response search method and device, computer installation and storage medium |
| CN110032574A (en) * | 2019-03-07 | 2019-07-19 | 北京东方国信科技股份有限公司 | The processing method and processing device of SQL statement |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110515971B (en) | 2022-03-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20080052488A1 (en) | Method for a Hash Table Lookup and Processor Cache | |
| US9235514B2 (en) | Predicting outcomes for memory requests in a cache memory | |
| US20110191544A1 (en) | Data Storage and Access | |
| US10789262B2 (en) | Progressive chart rendering | |
| CN106527966A (en) | Garbage collection in ssd drives | |
| US20130173509A1 (en) | Method and arrangement for processing data | |
| CN112035528A (en) | Data query method and device | |
| CN110096334A (en) | Method for caching and processing, device, equipment and computer readable storage medium | |
| CN109446225B (en) | Data caching method and device, computer equipment and storage medium | |
| CN111488736B (en) | Self-learning word segmentation method, device, computer equipment and storage medium | |
| US11036740B2 (en) | Database management system query plan cache management | |
| EP3859536B1 (en) | Method and device for buffering data blocks, computer device, and computer-readable storage medium | |
| CN110515977A (en) | Data query method, apparatus, computer equipment and storage medium | |
| AU2017268604A1 (en) | Accumulated retrieval processing method, device, terminal, and storage medium | |
| CN109656947A (en) | Data query method, apparatus, computer equipment and storage medium | |
| CN110515971A (en) | Program statement processing method, device, computer equipment and computer storage medium | |
| US11100001B2 (en) | Techniques for improving space utilization in a cache | |
| CN115544007A (en) | Label preprocessing method and device, computer equipment and storage medium | |
| CN109800247A (en) | Data search method, device, computer equipment and storage medium | |
| CN110874360A (en) | Ordered queue caching method and device based on fixed capacity | |
| US20140115246A1 (en) | Apparatus, system and method for managing empty blocks in a cache | |
| CN108121504A (en) | Data-erasure method and device | |
| CN112199400A (en) | Method and apparatus for data processing | |
| CN114860783B (en) | Graph database caching method and device, electronic equipment and readable storage medium | |
| CN117235088B (en) | Cache updating method, device, equipment, medium and platform of storage system |
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 |