Data manipulation method and systemTechnical field
The present invention relates to technical field of data processing, be specifically related to a kind of data manipulation method and system.
Background technology
Prior art is when externally providing data, mainly by data base, and not by caching.Of the prior art slowDeposit be after update caching, after i.e. calling data from data base, just can be stored in caching, when next time re-uses, just can from cacheCall this data.
In prior art, only part data just can walk caching, and caching of the prior art, is only to preserve to be madeUsed data, the data having not been used in data base, even if data newly-built, that revise and delete, also will not be at cachingMiddle preservation.When next time calls data, inquire about the most in the buffer and call this data, when there are not these data in caching,Again to inquiry in data base with call data, simultaneously by this data syn-chronization to caching, when re-using these data next time, fromCaching goes inquire about this data.Owing to caching is interim mostly, therefore, when next time inquires about these data in the buffer, it is possible toAlso can inquire about less than, at this moment, also can go again in data base inquire about.In this case, caching can quickly return Query Result, butBeing that data base can be slow, when this situation is more, data base is easily collapsed.I.e. prior art may comprise twice inquiry andThe thread called, so, on the one hand can cause occupying system resources, and reduce the efficiency of inquiry and invoked procedure；The opposing partyFace, typically uses hard disk array to preserve data so that access speed, significantly lower than caching, also reduces data due to data baseCall efficiency.
Summary of the invention
The purpose of the embodiment of the present invention is to provide one and operates data in data base, and will operate the number formedAccording to sending to caching, when calling data, directly search from caching and call data, to improve data access speed and dataCall data manipulation method and the device of efficiency.
According to an aspect of the present invention, it is provided that a kind of data manipulation method, including: refer to based on the data manipulation receivedThe data that data manipulation instruction is corresponding are operated with data after formation operation in data base by order；By number after described operationAccording to being sent to caching；Based on the data call instruction received, search and invocation target data from described caching.
Further, described method also includes: when finding described target data in the buffer, described target data is madeClient is returned for lookup result；When not finding described target data in described caching, return inquiry failure.
Further, when described data manipulation instruction is newdata instruction, described in data base, data manipulation is referred toThe step that the data of order correspondence carry out operating includes: instructs based on newdata, carries out newdata operation, shape in data baseBecome newdata；Described newdata is sent to caching.
Further, when described data manipulation instruction is for amendment data command, described in data base, data manipulation is referred toThe step that the data of order correspondence carry out operating includes: based on amendment data command, corresponding to amendment data command in data baseData modify, formed amendment after data；Data after described amendment are sent to caching.
Further, when described data manipulation instruction is for deleting data command, described in data base, data manipulation is referred toThe step that the data of order correspondence carry out operating includes: based on deleting data command, will delete data command corresponding in data baseData deletion；Send data cached deletion to caching to instruct；Corresponding data is deleted from described caching.
According to another aspect of the present invention, it is provided that a kind of data call device, including: data base, for based on receptionThe data that data manipulation instruction is corresponding are operated with data after formation operation by the data manipulation instruction arrived, and by describedAfter operation, data are sent to caching；Caching, for based on the data call instruction received, searching and invocation target data.
Further, described in be buffered in when finding described target data, described target data is returned as lookup resultClient；When not finding described target data in described caching, return inquiry failure.
Further, when described data manipulation instruction is newdata instruction, described data base instructs based on newdata,Carry out newdata to operate to form newdata, and described newdata is sent to caching.
Further, when described data manipulation instruction for amendment data command time, described data base based on amendment data command,The data that amendment data command is corresponding are modified with data after formation amendment, and is sent to delay by data after described amendmentDeposit.
Further, when described data manipulation instruction for delete data command time, described data base based on delete data command,By data deletion corresponding for described deletion data command, send data cached deletion to caching and instruct.
Further, described caching, it is further used for instructing based on described data cached deletion, corresponding data is deleted.
The embodiment of the present invention, by based on data manipulation instruction, carries out corresponding operating in data base to data, forms behaviourData after work, and the data after operation are sent to caching.When needs call data, directly transmit data call instruct toCaching, searches and calls data from caching, and by caching, Query Result is returned client.When caching in search less than with numberDuring data corresponding according to call instruction, then it represents that these data do not exist, it is not necessary to go again to access data base, thus solve existingIn technology when not inquiring data in the buffer, then inquire about in data base, owing to database response speed is relatively slow, causeData base does not finds the situation of data more time, the problem that data base is easily collapsed.And prior art may comprise twoSecondary inquiry and the thread called, cause occupying system resources, the problem reducing the efficiency of inquiry and invoked procedure, and due to dataStorehouse typically uses hard disk array to preserve data so that access speed, significantly lower than caching, also reduces the efficiency of calling of dataProblem.Achieve and have only to one query and invoked procedure just can complete to find in data call process, and caching and numberDuring data corresponding according to call instruction, data can quickly be returned by caching, improves data access speed；When caching is searchedLess than when instructing corresponding data with data call, it is not necessary to go again to access data base, it is possible to quickly return Query Result, improveThe effect of data call efficiency.
Accompanying drawing explanation
Fig. 1 is the method flow schematic diagram inquiring about and calling data in prior art；
Fig. 2 is the schematic flow sheet of a kind of data manipulation method of the embodiment of the present invention one；
Fig. 3 is the schematic flow sheet of a kind of data manipulation method of the embodiment of the present invention two；
Fig. 4 is the schematic flow sheet of a kind of embodiment of the embodiment of the present invention one；
Fig. 5 is the schematic flow sheet of the another embodiment of the embodiment of the present invention one；
Fig. 6 is the schematic flow sheet of the another embodiment of the embodiment of the present invention one；
Fig. 7 is the structural representation of a kind of data operation device of the embodiment of the present invention three.
Detailed description of the invention
For making the object, technical solutions and advantages of the present invention of greater clarity, below in conjunction with detailed description of the invention and joinAccording to accompanying drawing, the present invention is described in more detail.It should be understood that these describe the most exemplary, and it is not intended to limit thisBright scope.Additionally, in the following description, eliminate the description to known features and technology, to avoid unnecessarily obscuring thisThe concept of invention.
Fig. 1 is the method flow schematic diagram inquiring about and calling data in prior art.
As it is shown in figure 1, the method inquired about in prior art and call data, comprise the following steps:
S101, instructs based on data query, searches target data in the buffer；Wherein, target data is and data queryThe data that instruction is corresponding；
S102, when finding target data in the buffer, then invocation target data；When not finding target in the bufferDuring data, then send data query and instruct to data base, and return inquiry failure；
S103, instructs based on data query, inquires about target data in data base；
S104, when finding target data in data base, then invocation target data, and target data is sent to slowDeposit；When not finding target data in data base, then return inquiry failure.
Above-mentioned steps S101 to step S104 is to inquire about and call the process of data in prior art, in prior art, byUpdate the most afterwards caching, the most only data called in data base after, just can write caching, when using data next time, thenGo caching calls data.And owing to caching of the prior art is all interim, therefore, use data when next time, then go to delayWhen calling data in depositing, it is possible to also can inquire about less than data, now, caching can return an inquiry failure to clientEnd, then client goes search in data base and call data again.In this case, twice lookup and the mistake called just are containedJourney, if also searched less than data in data base, then data base is also required to return an inquiry failure to client.Owing to cache responses is fast, therefore, caching can quickly return Query Result, but database response is relatively slow, the response of data baseRelatively will be delayed, when this situation is more, data base is possible to collapse phenomenon occur.In order to avoid collapsing occurs in data baseRouted phenomenon, present invention employs following data manipulation method and device, to solve above-mentioned technical problem.
Fig. 2 is the schematic flow sheet of the data manipulation method of the embodiment of the present invention one.
As in figure 2 it is shown, a kind of data manipulation method, including:
The data that data manipulation instruction is corresponding, based on the data manipulation instruction received, are carried out in data base by S201Operate with data after formation operation；
Data after operation are sent to caching by S202；
S203, based on the data call instruction received, searches and invocation target data from caching.
It should be noted that the caching in the embodiment of the present invention is permanent caching.
The embodiment of the present invention one, by based on data manipulation instruction, carries out corresponding operating to data in data base, is formedData after operation, and the data after operation are sent to caching.When needs call data, directly transmit data call instructionGive caching, from caching, search and call data, and by caching, Query Result is returned client.Owing to the operation of data is allData base completes, then synchronizes to caching.Therefore, when caching in search less than with data call instruct corresponding dataTime, then it represents that these data do not exist, now, it is not necessary to go to inquire about in data base again, are directly returned by caching and inquire about disappearing unsuccessfullyBreath, whole data query and invoked procedure so far terminate.Solve when not inquiring data in the buffer in prior art, then arriveIn data base during inquiry, owing to database response speed is relatively slow, when the situation that causes not finding data in data base is more,The problem that data base is easily collapsed.And prior art may comprise twice inquiry and the thread called, cause and take system moneySource, the problem reducing the efficiency of inquiry and invoked procedure, and typically use hard disk array to preserve data due to data base so that visitAsk that speed is significantly lower than caching, also reduce the problem calling efficiency of data.Achieve when caching finding and data tuneWith when instructing corresponding data, data can quickly be returned by caching, it is not necessary to goes to access data base again, improves data accessSpeed；And when searching less than when instructing corresponding data with data call in caching, caching also is able to quickly return Query Result,Improve the effect of data call efficiency.
Fig. 3 is the schematic flow sheet of the data manipulation method of the embodiment of the present invention two.
As it is shown on figure 3, the embodiment of the present invention two except step S201 to step S203 that comprise embodiment one step itOutward, also comprise the steps:
S204, when finding target data in the buffer, returns target data to client as lookup result；WhenWhen caching does not finds target data, return inquiry failure.
Wherein, target data refers to the data corresponding with data call instruction.Step S204 is in the specific implementation: when fromWhen caching finding with the data call corresponding data of instruction, then directly data are returned by caching.Now, data query knotFruit is to instruct corresponding data with data call；When from caching in search less than with data call instruct corresponding data time, thenData query result being returned by caching, now, data query result is inquiry failure.
Wherein, in step S1, data manipulation instruction at least includes newdata instruction, amendment data command or deletes dataInstruction.It should be appreciated that data manipulation instruction can also instruct for other, and these instructions are also implemented all without departing from the present inventionThe scope of example.
Based on above-mentioned data manipulation instruction, in the above embodiment of the present invention one, step S101 can have different embodiment partyFormula.
Fig. 4 is the schematic flow sheet of a kind of embodiment of step S101 in the embodiment of the present invention one.
As shown in Figure 4, when data manipulation instruction is newdata instruction, step S101 comprises the following steps:
S401, receives newdata instruction；
S402, instructs based on newdata, carries out newdata operation in data base, forms newdata；
S403, is sent to caching by newdata.
Fig. 5 is the schematic flow sheet of the another embodiment of step S101 in the embodiment of the present invention one.
As it is shown in figure 5, when data manipulation instruction is for amendment data command, corresponding to data manipulation instruction in data baseData carry out the step that operates particularly as follows:
S501, receives amendment data command；
The data that amendment data command is corresponding, based on amendment data command, are modified in data base, are formed by S502Data after amendment；
Data after amendment are sent to caching by S503.
Fig. 6 is the schematic flow sheet of another embodiment of step S101 in the embodiment of the present invention one.
As shown in Figure 6, when data manipulation instruction is data deletion instruction, corresponding to data manipulation instruction in data baseData carry out the step that operates particularly as follows:
S601, receives data deletion instruction；
S602, instructs based on data deletion, data deletion corresponding by deleting data command in data base；
S603, sends data cached deletion to caching and instructs；
S604, is removed from the cache corresponding data.
It is all provisional for caching in prior art, after only data are called in data base, just can put into caching.AndIn the embodiment of the present invention, caching is permanent storage, when having newdata, amendment data and deleting the data manipulations such as data,After corresponding data is operated by data base, then will operation after data syn-chronization to caching in, thus when need inquiry and callDuring data, it is only necessary to once search and call the process of data, search the most in the buffer and call, when caching does not exist and to adjustData time, then it represents that these data do not exist, it is not required that go to search in data base and call again, directly by caching return numberIt is investigated that inquiry failure i.e. terminates to client, data search and the process called.Decrease and once search and call dataProcess.Caching and data base each divide the work, and work in coordination, and solve in prior art when not inquiring data in the bufferTime, then inquire about in data base, owing to database response speed is relatively slow, cause in data base, not finding the situation of data relativelyTime many, the problem that data base is easily collapsed.On the other hand, solve and prior art may comprise twice inquiry and the line calledJourney, causes occupying system resources, the problem reducing the efficiency of inquiry and invoked procedure.Another aspect, owing to data base typically adoptsData are preserved so that database access speed, significantly lower than caching, reduces the problem calling efficiency of data with hard disk array.
In above-described embodiment based on data manipulation instruction carry out in data base newly-built, revise and delete the operation such as data,Forming data after operation, and data after operation sent to when caching, after specifically can selecting will operate in real time, data sendTo caching, it is also possible to after selecting will operate at set time intervals, data send to caching, it is also possible to be selected at cachingAfter operating time idle, data send to caching.It is to be understood, however, that this is only the part enforcement of the embodiment of the present inventionMode, the other kinds of embodiment being sent to cache by data after operation is also without departing substantially from the scope of the present invention.
As a kind of preferred implementation, the embodiment of the present invention can arrange multiple caching and form array cache, cachingArray is permanent caching.
Fig. 7 is the structural representation of a kind of embodiment of a kind of data operation device of the embodiment of the present invention three.
As it is shown in fig. 7, a kind of data operation device, including data base 10 and caching 11；Data base 10, for based on receptionThe data that data manipulation instruction is corresponding are operated with data after formation operation by the data manipulation instruction arrived, and will operationRear data are sent to cache 11；Caching 11, for based on the data call instruction received, searching and invocation target data.ItsIn, target data refers to the data corresponding with data call instruction.
It should be noted that the caching in the embodiment of the present invention is permanent caching.
The embodiment of the present invention three, by based on data manipulation instruction, carries out corresponding operating to data in data base, is formedData after operation, and the data after operation are sent to caching.When needs call data, directly transmit data call instructionGive caching, from caching, search and call data, and by caching, Query Result is returned client.Owing to the operation of data is allData base completes, then synchronizes to caching.Therefore, when caching in search less than with data call instruct corresponding dataTime, then it represents that these data do not exist, now, it is not necessary to go to inquire about in data base again, are directly returned by caching and inquire about disappearing unsuccessfullyBreath, whole data query and invoked procedure so far terminate.Solve when not inquiring data in the buffer in prior art, then arriveIn data base during inquiry, owing to database response speed is relatively slow, when the situation that causes not finding data in data base is more,The problem that data base is easily collapsed.And prior art may comprise twice inquiry and the thread called, cause and take system moneySource, the problem reducing the efficiency of inquiry and invoked procedure, and typically use hard disk array to preserve data due to data base so that visitAsk that speed is significantly lower than caching, also reduce the problem calling efficiency of data.Achieve when caching finding and data tuneWith when instructing corresponding data, data can quickly be returned by caching, it is not necessary to goes to access data base again, improves data accessSpeed；And when searching less than when instructing corresponding data with data call in caching, caching also is able to quickly return Query Result,Improve the effect of data call efficiency.
Wherein, target data, when finding target data, is returned client as lookup result by caching 11；When slowDeposit when not finding target data in 11, return inquiry failure.
When data manipulation instruction is newdata instruction, data base 10 instructs based on newdata, carries out newdataOperation is to form newdata, and is sent to cache 11 by newdata.
When data manipulation instruction is for amendment data command, amendment data, based on amendment data command, are referred to by data base 10The data of order correspondence are modified with data after formation amendment, and are sent to cache 11 by data after amendment.
When data manipulation instruction is for deleting data command, deletion data, based on deleting data command, are referred to by data base 10The data deletion that order is corresponding, sends data cached deletion instruction to caching.
Caching 11, is further used for deleting instruction based on data cached, is deleted by corresponding data.
As a kind of preferred implementation, the embodiment of the present invention can arrange multiple caching 11 and form array cache, slowDepositing array is permanent caching.
In above-described embodiment data base based on data manipulation instruction carry out newly-built, revise and delete the operation such as data, formedData after operation, and data after operation are sent to when caching, after specifically can selecting will operate in real time, data send to slowDeposit, it is also possible to after selecting will operate at set time intervals, data send to caching, it is also possible to be selected at caching idleTime will operation after data send to caching.It is to be understood, however, that this is only a part of embodiment party of the embodiment of the present inventionFormula, the other kinds of embodiment being sent to cache by data after operation is also without departing substantially from the scope of the present invention.
In the embodiment of the present invention, data base is based on data manipulation instruction, and data carry out corresponding operating, forms number after operationAccording to, and data after operation are sent to caching.When needs call data, directly transmit data call and instruct to caching, postponeDeposit middle lookup and call data, and by caching, Query Result being returned client.Owing to the operation of data is all in data baseComplete, be subsequently sent to caching.Therefore, when caching being searched less than when instructing corresponding data with data call, then it represents that shouldData do not exist, now, it is no longer necessary to go to inquire about in data base, directly returned inquiry failure, whole data by cachingInquiry and invoked procedure so far terminate.Solve in prior art when not inquiring data in the buffer, then in data baseInquiry, owing to database response speed is relatively slow, when the situation that causes not finding data in data base is more, data base is easily collapsedThe problem burst.And prior art may comprise twice inquiry and the thread called, cause occupying system resources, reduce inquiryWith the problem of the efficiency of invoked procedure, and typically use due to data base hard disk array preserve data so that access speed is obviousLess than caching, also reduce the problem calling efficiency of data.Achieve when caching finds corresponding to data call instructionData time, caching can quickly by data return, it is not necessary to again go access data base, improve data access speed；And work asSearching in caching less than when instructing corresponding data with data call, caching also is able to quickly return Query Result, improves numberAccording to the effect calling efficiency.
It should be appreciated that the above-mentioned detailed description of the invention of the present invention is used only for exemplary illustration or explains the present invention'sPrinciple, and be not construed as limiting the invention.Therefore, that is done in the case of without departing from the spirit and scope of the present invention is anyAmendment, equivalent, improvement etc., should be included within the scope of the present invention.Additionally, claims purport of the present inventionWhole within containing the equivalents falling into scope and border or this scope and border change and repairChange example.
Those skilled in the art are it should be appreciated that embodiments of the invention can be provided as method, system or computer programProduct.Therefore, the reality in terms of the present invention can use complete hardware embodiment, complete software implementation or combine software and hardwareExecute the form of example.And, the present invention can use at one or more computers wherein including computer usable program codeThe upper computer program product implemented of usable storage medium (including but not limited to disk memory, CD-ROM, optical memory etc.)The form of product.
The present invention is with reference to method, equipment (system) and the flow process of computer program according to embodiments of the present inventionFigure and/or block diagram describe.It should be understood that can the most first-class by computer program instructions flowchart and/or block diagramFlow process in journey and/or square frame and flow chart and/or block diagram and/or the combination of square frame.These computer programs can be providedInstruction arrives the processor of general purpose computer, special-purpose computer, Embedded Processor or other programmable data processing device to produceA raw machine so that the instruction performed by the processor of computer or other programmable data processing device is produced for realThe device of the function specified in one flow process of flow chart or multiple flow process and/or one square frame of block diagram or multiple square frame now.
These computer program instructions may be alternatively stored in and computer or other programmable data processing device can be guided with spyDetermine in the computer-readable memory that mode works so that the instruction being stored in this computer-readable memory produces and includes referring toMake the manufacture of device, this command device realize at one flow process of flow chart or multiple flow process and/or one square frame of block diagram orThe function specified in multiple square frames.
These computer program instructions also can be loaded in computer or other programmable data processing device so that at meterPerform sequence of operations step on calculation machine or other programmable devices to produce computer implemented process, thus at computer orThe instruction performed on other programmable devices provides for realizing at one flow process of flow chart or multiple flow process and/or block diagram oneThe step of the function specified in individual square frame or multiple square frame.