CN107562851A - A kind of update method of data, device and electronic equipment - Google Patents
A kind of update method of data, device and electronic equipment Download PDFInfo
- Publication number
- CN107562851A CN107562851A CN201710750743.4A CN201710750743A CN107562851A CN 107562851 A CN107562851 A CN 107562851A CN 201710750743 A CN201710750743 A CN 201710750743A CN 107562851 A CN107562851 A CN 107562851A
- Authority
- CN
- China
- Prior art keywords
- data
- sector
- request
- internal memory
- renewal
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Abstract
This application provides a kind of update method of data,Device and electronic equipment,By the way that the data received are updated into request deposit internal memory cache region,It can avoid directly being updated when receiving a data renewal request in database table,To perform a data renewal operation according to the more new content of database table,And when the data renewal request number that record is stored in internal memory cache region reaches preset limit value,The multiple data renewal request being stored into internal memory cache region carries out sector classification and ordination according to the indexed sequential of database table,Generation includes the sector classification chart of multiple sectors classification sublist,The number of the data renewal number of operations for making Database Systems be performed in data updating process contained sector classification sublist after being updated with database table is equal,And then reduce number and time that Database Systems update request progress data renewal operation according to data,Improve the operating efficiency of Database Systems processing data renewal request and the handling capacity of Database Systems.
Description
Technical field
The present invention relates to technical field of data processing, in particular, be related to a kind of update method of data, device and
Electronic equipment.
Background technology
With the fast development of informationization technology, database uses all kinds of letters of the effective management and use of computer as people
The technological means of resource is ceased, is widely used.And in order to ensure the data that sector is stored in database are current latest data,
Database Systems need to upgrade in time the data that sector in database deposited according to the demand of user.
At present, the existing method being updated to data is mainly the priority for the reception time that request is updated according to data
Sequentially, a data renewal request is only chosen every time, and is updated in database table, so that Database Systems are according to data
The content of storehouse table renewal, sector that this needs modifies is determined in whole sectors out of database to be counted accordingly
Operated according to renewal, when completing the renewal operation of data according to data renewal request, then by next number received
According to renewal request renewal into database table, to carry out the behaviour of data renewal next time for sector stored data in database
Make, and then ensure that the real-time of data in database.However, using during existing data-updating method, it is necessary to perform number
The data renewal operation equal with the data renewal number of requests received can just make in database sector stored data according to connecing
Data renewal operation corresponding to the total data renewal request completion received, so as to cause the renewal of Database Systems processing data please
The time asked is longer, reduces the operating efficiency of Database Systems processing data renewal request and handling up for Database Systems indirectly
Amount.
The content of the invention
In view of this, the invention provides a kind of update method of data, device and electronic equipment, data base set is reduced
The time of processing data of uniting renewal request, and then improve the operating efficiency and data of the renewal request of Database Systems processing data
The handling capacity of storehouse system.
To achieve the above object, the present invention provides following technical scheme：
A kind of update method of data, including：
When receiving data renewal request, the data are updated into request deposit internal memory cache region；
Record is stored in the data renewal request number in the internal memory cache region；
When the data renewal request number that record is stored in the internal memory cache region reaches preset limit value, according to data
The indexed sequential of storehouse table, the data renewal request being stored in record in the internal memory cache region carry out sector classification and ordination, generation
Sector classification chart, the sector classification chart include at least one sector classification sublist, and each described sector classification sublist includes
The corresponding data of data renewal operation are carried out to same sector stored data and update request；
The database table is arrived into sector classification chart renewal, carries out data renewal.
Preferably, after the data renewal request number being stored in record in the internal memory cache region, in addition to：
Start timer and carry out timing, and generate timer timing time；
Judge whether the timer timing time reaches preset time value；
If the timer timing time reaches the preset time value, perform described suitable according to the index of database table
Sequence, the data renewal request being stored in record in the internal memory cache region carry out sector classification and ordination, generate sector classification chart.
Preferably, the indexed sequential according to database table, to the data in the record deposit internal memory cache region more
New request carries out sector classification and ordination, generates sector classification chart, including：
According to the indexed sequential of the database table, will record the data renewal that is stored in the internal memory cache region ask into
Row sector is classified, at least one sector classification sublist of generation；
The sector classification sublist of generation is arranged according to genesis sequence, generates sector classification chart.
Preferably, it is described that the database table is arrived into sector classification chart renewal, after carrying out data renewal, also wrap
Include：
Result is completed in generation renewal.
A kind of updating device of data, including：
Preserving module, for when receiving data renewal request, the data to be updated into request deposit internal memory cache region；
Logging modle, for recording the data being stored in internal memory cache region renewal request number；
Classification and ordination module, the data for being stored in when logging modle record in the internal memory cache region update request
When number reaches preset limit value, according to the indexed sequential of database table, the data in the internal memory cache region are stored in record
Renewal request carries out sector classification and ordination, generates sector classification chart, and the sector classification chart includes at least one sector classification
Table, each described sector classification sublist, which includes, carries out the corresponding data of data renewal operation to same sector stored data
Renewal request；
Update module, for sector classification chart renewal to be arrived into the database table, carry out data renewal.
Preferably, described device also includes：
Timing module, timing is carried out for starting timer, and generate timer timing time；
Judge module, for judging whether the timer timing time reaches preset time value；
The classification and ordination module, it is additionally operable to when the judge module judges that the timer timing time reaches default
Between be worth after, according to the indexed sequential of database table, the data renewal request being stored in record in the internal memory cache region is carried out
Sector classification and ordination, generate sector classification chart.
Preferably, the classification and ordination module includes：
Sector sort module, for the indexed sequential according to the database table, record is stored in the internal memory cache region
In data renewal request carry out sector classification, at least one sector classification sublist of generation；
Sector order module, for the sector classification sublist of generation to be arranged according to genesis sequence, generation fan
Region class table.
Preferably, described device also includes：
Generation module, for sector classification chart renewal to be arrived into the database table in the update module, enter line number
After renewal, result is completed in generation renewal.
A kind of electronic equipment, including：Transceiver, memory and processor；
The transceiver, for receiving data renewal request；
The memory includes internal memory cache region and database table；
The processor, for when the transceiver receives data renewal request, data renewal please to be sought survival
Enter the internal memory cache region, record is stored in the data renewal request number in the internal memory cache region；In record deposit is described
The data renewal request number in buffer area is deposited when reaching preset limit value, according to the indexed sequential of the database table, to note
The data renewal request recorded in the internal memory cache region carries out sector classification and ordination, generates sector classification chart, the sector
Classification chart includes at least one sector classification sublist, and each described sector classification sublist is included to same sector stored data
Carry out the corresponding data renewal request of data renewal operation；The database table is arrived into sector classification chart renewal, carried out
Data update.
Preferably, the electronic equipment also includes：Timer；
The timer, for timing, generate timer timing time；The processor, it is additionally operable to judge the timing
Whether device timing time reaches preset time value；If the timer timing time reaches the preset time value, according to described
The indexed sequential of database table, sector classification and ordination is carried out to the data renewal request in the internal memory cache region, generates sector
Classification chart.
Via above-mentioned technical scheme understand, compared with prior art, the invention provides a kind of update method of data,
Device and electronic equipment, by the way that the data received are updated into request deposit internal memory cache region, it is possible to prevente effectively from receiving
The data are directly updated into request renewal into database table during one data renewal request, so that Database Systems are according to data
The more new content of storehouse table performs a data renewal and operated, and the data renewal request number in internal memory cache region is stored in record
When reaching preset limit value, the multiple data renewal request being stored into internal memory cache region is entered according to the indexed sequential of database table
Row sector classification and ordination, generation include the sector classification chart of multiple sectors classification sublist, are advantageous to Database Systems in data more
The data renewal number of operations performed during new and the sector classification sublist in the sector classification chart of database table renewal gained
Number it is equal, it becomes possible to complete data renewal request need Database Systems perform total data renewal operation, and then solve
Determine because the equal data renewal operation of the data renewal number of requests for performing with receiving just can be deposited sector in database
Data complete the problem of data renewal of the corresponding total data renewal request received, effectively reduce Database Systems according to
Data renewal request carries out number and the time of data renewal operation, improves the renewal request of Database Systems processing data indirectly
Operating efficiency and Database Systems handling capacity.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are only this
The embodiment of invention, for those of ordinary skill in the art, on the premise of not paying creative work, can also basis
The accompanying drawing of offer obtains other accompanying drawings.
Fig. 1 is a kind of method flow diagram of the update method of data provided in an embodiment of the present invention；
Fig. 2 is a kind of method flow diagram of the generation method of sector classification chart provided in an embodiment of the present invention；
Fig. 3 is the method flow diagram of the update method of another data provided in an embodiment of the present invention；
Fig. 4 is a kind of structural representation of the updating device of data provided in an embodiment of the present invention；
Fig. 5 is a kind of structural representation of the generating means of sector classification chart provided in an embodiment of the present invention；
Fig. 6 is the structural representation of the updating device of another data provided in an embodiment of the present invention；
Fig. 7 is the structural representation of a kind of electronic equipment provided in an embodiment of the present invention；
Fig. 8 is the structural representation of another electronic equipment provided in an embodiment of the present invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete
Site preparation describes, it is clear that described embodiment is only part of the embodiment of the present invention, rather than whole embodiments.It is based on
Embodiment in the present invention, those of ordinary skill in the art are obtained every other under the premise of creative work is not made
Embodiment, belong to the scope of protection of the invention.
The embodiment of the invention discloses a kind of update method of data, accompanying drawing 1 is referred to, methods described specifically includes following
Step：
S101：When receiving data renewal request, the data are updated into request deposit internal memory cache region；
Specifically, database belongs to a shared resource, multiple users for possessing shared resource right can be allowed to the number
The data resource deposited according to sector in storehouse is written and read operation.And each possesses the user of shared resource right by data
Storehouse system sends a data renewal request has user to need to enter the data resource in it so that Database Systems are known currently
Row write operation, i.e. renewal operation, follow-up related number is carried out so that Database Systems are directed to the data received renewal request
Operated according to renewal.
Database Systems just in time please seek survival data renewal after the data renewal request that user sends is received
Enter into internal memory cache region.Wherein, the internal memory cache region in Database Systems can pre-establish, and be mainly used in storage and receive
Data renewal request.Storage data renewal request can be sent by same user or by different user
Send.
Access time this programme of data renewal request does not limit, and can be the identical or different time interval deposit in interval
Data renewal request, such as Database Systems are in " time T " deposits " " the data renewal request a ", in the time that user A " is sent
" T+1 " deposit " user A " send " data renewal request b ", time " T+4 " deposit " user B " send " data are more
New request c ".
S102：Record is stored in the data renewal request number in the internal memory cache region；
Specifically, whether to know the number of the data renewal request currently preserved in time for the ease of Database Systems
The condition that meets to carry out sector classification and ordination to internal memory cache region, it is necessary to after the renewal request of data is stored in every time, in time
Recorded.
For example, after Database Systems receive and store a data renewal request, record current memory caching
The number of contained data renewal request is " 1 " in area, afterwards, if receiving again and storing next data renewal request,
Recorded again so that the number of contained data renewal request is changed to " 2 " in current memory buffer area, and records successively
To go, the number that request is updated until the data in the internal memory cache region recorded meets the condition for carrying out sector classification and ordination,
That is the number of the data renewal request in the internal memory cache region recorded reaches preset limit value.
S103：When the data renewal request number that record is stored in the internal memory cache region reaches preset limit value, press
According to the indexed sequential of database table, the data renewal request being stored in record in the internal memory cache region carries out sector classification row
Sequence, sector classification chart is generated, the sector classification chart includes at least one sector classification sublist, each described sector classification
Table includes the data carried out to same sector stored data corresponding to data renewal operation and updates request；
Specifically, the data renewal request number being stored in recording in internal memory cache region reaches preset limit value as can
The execution foundation of subsequent sectors classification and ordination operation is carried out, Database Systems can be avoided to receive a data renewal request
When, just updated immediately in database table, so that Database Systems perform a data according to the database table after renewal
The problem of renewal operates, condition is provided for the follow-up data renewal number of operations that reduces.Wherein, internal memory cache region is to build in advance
Stand in Database Systems, be mainly used in the data renewal request that storage receives, and fan is performed in the internal memory cache region
The associative operation of region class sequence.
The data stored in data base table recording database on all sectors, and the indexed sequential of database table is mainly used
The specific deposit position of the total data recorded in database of record table, i.e. sector belonging to data.Therefore, database is utilized
The indexed sequential of table, required data resource can be quickly got in corresponding sector from database.Wherein, different number
There can be the indexed sequential of identical or different database table according to storehouse table, indexed sequential can be pre-set.
Using database table indexed sequential to this record deposit internal memory cache region in total data renewal ask into
Row sector classification and ordination, total data can be updated to request according in its targeted database that carry out data renewal operation
Specific sector carry out classification and ordination, so as to obtain the sector classification chart for containing multiple sectors classification sublists, wherein, classification row
The number of the sector classification sublist of gained will be less than the number of the total data renewal request stored in internal memory cache region after sequence, from
And when the follow-up multiple data for being directed to reception and storing update request, Database Systems can be according to the database table after renewal
Contained sector classification chart carries out the process of data renewal, and then reduces the number for performing data renewal operation.
Secondly, record and include to enter some sector in Database Systems in each data renewal request of deposit
The relevant information of row data renewal operation, quickly will so as to which request during the classification and ordination of sector, can be updated according to data
Belong to the total data renewal request that data renewal request operation is carried out to same sector, be put into a sector classification sublist
In.
Be exemplified below, this record deposit internal memory cache region in data renewal request for " request 1 ", " request 2 ",
" request 3 ", " ask 4 " and " ask 5 ", the number that the data in now record deposit internal memory cache region update request has reached
" preset limit value 5 ", then according to the indexed sequential of database table to " asking 1 ", " request 2 ", " request 3 ", " asking 4 " and " ask
5 " progress sector classification and ordinations are sought, are generated comprising " sector classification sublist 1 ", " sector classification sublist 2 " and " sector classification sublist 3 "
The sector classification chart of this 3 sector classification sublists, wherein, " sector classification sublist 1 " includes deposits number for sector 1 in database
" ask 1 " according to progress data renewal operation and " ask 2 ", " sector classification sublist 2 " includes is deposited for sector 2 in database
Data carry out " asking 3 " and " request 5 ", " sector classification sublist 3 " is included for the institute of sector 3 in database for data renewal operation
Deposit data carries out the " request 4 " of data renewal operation.
Sector number this programme in database does not limit, it can be set according to the storage characteristics of database contained by
The number of sector, such as 5,27 or 50 it is therein any one.
S104：The database table is arrived into sector classification chart renewal, carries out data renewal；
Specifically, because Database Systems are to perform the number to sector stored data according to contained content in database table
According to renewal operation, therefore, upgraded demand to complete the data of user in time, it is necessary to which the sector classification chart renewal of generation is arrived
In database table, so as to database according to sector classification sublist contained after database table renewal successively to corresponding in database
Sector stored data performs data renewal operation.
Still with sector classification chart include " sector classification sublist 1 ", " sector classify sublist 2 " and " sector classification sublist 3 " be
Example is specifically addressed, wherein, " sector classification sublist 1 ", which includes, " asks 1 " and " request 2 ", " sector classification sublist 2 " includes
" request 3 " and " request 5 ", " and sector classification sublist 3 " include " request 4 ", by the renewal of sector classification chart to after database table, data
Storehouse system is with regard to according to " sector classification sublist 1 ", " sector classification sublist 2 " and " sector point contained in the database table after renewal
Class sublist 3 ", successively to " stored data of sector 1 ", " stored data of sector 2 " and " stored data of the sector 3 " progress in database
Data renewal operation, and then successfully the data renewal operation for performing 5 times will be needed to be reduced to 3 data renewal behaviour originally
Make, number and the time of request progress data renewal operation are updated so as to effectively reduce Database Systems according to data, indirectly
Improve the operating efficiency of Database Systems processing data renewal request and the handling capacity of Database Systems.
The update method of a kind of data disclosed in the embodiment of the present invention, by the way that the data received are updated into request deposit
Internal memory cache region, it is possible to prevente effectively from the data directly are updated into request renewal to number when receiving a data renewal request
According in the table of storehouse, so that Database Systems perform a data renewal operation according to the more new content of database table, and deposited in record
Enter the data renewal request number in internal memory cache region when reaching preset limit value, the multiple data being stored into internal memory cache region
Renewal request carries out sector classification and ordination according to the indexed sequential of database table, and generation includes the sector of multiple sectors classification sublist
Classification chart, be advantageous to data renewal number of operations and database table renewal institute that Database Systems perform in data updating process
The number of sector classification sublist in the sector classification obtained is equal, it becomes possible to which completing data renewal request needs Database Systems to hold
Capable total data renewal operation, and then solve because the equal data of the data renewal number of requests for performing with receiving update
Operation can just make sector stored data in database complete asking for the data renewal that the corresponding total data renewal received is asked
Topic, number and time that Database Systems update request progress data renewal operation according to data are effectively reduced, is improved indirectly
The operating efficiency of Database Systems processing datas renewal request and the handling capacity of Database Systems.
Accompanying drawing 2 is referred to, the specific implementation process of the S103 in embodiment corresponding to above-mentioned Fig. 1 comprises the following steps：
S201：According to the indexed sequential of the database table, the data recorded in the deposit internal memory cache region are updated
Request carries out sector classification, at least one sector classification sublist of generation；
Specifically, according to the indexed sequential of database table, will record the data renewal that is stored in internal memory cache region ask into
Row sector is classified, and can ensure that the data renewal request that each sector classification sublist of generation is included is for same
On the basis of individual sector stored data carries out data renewal operation, make multiple sector classification sublists suitable according to the index of database table
The putting in order for the affiliated sector of data originally recorded in sequence sequentially generates.For example, wrapped in the indexed sequential of database table
Containing 4 tactic sectors, it respectively is and " sector 1 ", " sector 2 ", " sector 3 ", " sector 4 ", deposits in internal memory cache region
Storage data renewal request bag containing " request 1 ", " request 2 ", " request 3 ", " request 4 ", " request 5 ", " request 6 ", wherein, " please
Ask 1 " and " request 2 " is to be directed to the stored data of sector 1 in database to carry out data renewal operation, and " request 3 " is to be directed to database
The middle stored data of sector 2 carries out data renewal operation, and " request 4 " is to be directed to the stored data of sector 3 in database to carry out data more
It is new to operate, " ask 5 " and " request 6 " is to be directed to the stored data of sector 4 progress data in database to update operation, is now recorded
Internal memory cache region in data renewal request number reach " preset limit value 6 ", then according to the indexed sequential of database table,
Sequentially generate comprising " request 1 " with " request 2 " " sector classify sublist 1 ", include " request 3 " " sector classify sublist 2 ", bag
Containing " request 4 " " sector classify sublist 3 ", and include " request 5 " with " request 6 " " sector classify sublist 4 ".
S202：The sector classification sublist of generation is arranged according to genesis sequence, generates sector classification chart；
Specifically, because one or more sectors classification sublist is sequentially generated according to the indexed sequential of database table,
Therefore it regard the classify genesis sequence of sublist of sector as arrangement standard, whole sectors of generation classification sublist is arranged, so that
The consistent sector classification chart of sector arrangement position in the indexed sequential with database table can be obtained, so as to follow-up data storehouse system
It can be rapidly completed according to the database table after renewal and a data are performed more to each sector for needing to carry out data renewal
New operation, to realize that the data to sector stored data update.
In the embodiment of the present invention, by the indexed sequential according to database table to the data in record deposit internal memory cache region
Renewal request carries out sector classification, obtains multiple sector classification sublists, then arranged according to the genesis sequence of sector classification sublist
Row, sector in the arrangement position of sector classification sublist and the indexed sequential of database table in the sector classification chart of generation can be made
Arrangement position is consistent, make indirectly sector in the classification chart of sector classify sublist arrangement position and database table in store number
According to arrangement position it is consistent, and then accelerate by the renewal of sector classification chart into database table, and Database Systems are according to more
Database table after new performs the speed of data renewal operation, improves the work of Database Systems processing data renewal request indirectly
Make the handling capacity of efficiency and Database Systems.
Optionally, it is further comprising the steps of after the S104 in embodiment corresponding to above-mentioned Fig. 1：
Result is completed in generation renewal.
In the embodiment of the present invention, by updating it in the corresponding data of the total data renewal request for completing with being stored in
Afterwards, result is completed in generation renewal, is easy to follow-up work personnel to transfer the result to know whether the renewal operation of this data is suitable
Profit is completed, so reduce in data updating process because occur it is unexpected cause staff in time not know to be handled
Situation Probability.
On the basis of embodiment corresponding to above-mentioned Fig. 1, the embodiment of the invention discloses the update method of another data,
Accompanying drawing 3 is referred to, methods described specifically includes following steps：
S301：When receiving data renewal request, the data are updated into request deposit internal memory cache region.
S302：Record is stored in the data renewal request number in the internal memory cache region.
S303：Start timer and carry out timing, and generate timer timing time；
Specifically, deposit partial data renewal request has been recorded in internal memory cache region, but the data renewal request being stored in
Number fail in the case of reaching preset limit value, if fail to continue to for a long time and record be stored in new data renewal please
Ask, can lead to not carry out follow-up sector classification and ordination operation, so as to which the part with having deposited in internal memory cache region can not be performed
Data update data renewal operation corresponding to request, cause data to update the problem of postponing.
Therefore, in order to avoid the generation of above mentioned problem, a timer can be pre-set, for being stored in internal memory in record
When the number of data renewal request in buffer area is not 0, it is triggered carries out timing in time, regularly to make the part being stored in
Data renewal request carries out sector classification and ordination, updates operation so as to continue executing with the data of follow-up correlation, avoids data from updating
The generation of delay issue.
S304：Judge whether the timer timing time reaches preset time value, if so, S305 is then performed, if it is not, then
Return and perform S303；
Specifically, the preset time value of timer can be preset, such as 5s, 10s or 20s.
S305：According to the indexed sequential of database table, the data being stored in record in the internal memory cache region update request
Sector classification and ordination is carried out, generates sector classification chart, and perform S306；
Specifically, when judging that timer timing time reaches preset time value, just in time according to the rope of database table
Draw order, generate sector classification chart, and then effectively reduce Database Systems and carry out data renewal operation according to data renewal request
Time.
S306：The database table is arrived into sector classification chart renewal, carries out data renewal.
A kind of update method of data disclosed in the embodiment of the present invention, timing is carried out by starting timer, and fixed
When device timing time when reaching preset time value, the data renewal request in order record deposit internal memory cache region is according to database table
Indexed sequential carry out sector classification and ordination, and then generate sector classification chart, so as to Database Systems using database table renewal
The data that the contained corresponding sector of sector classification chart renewal is deposited afterwards, so as to effectively prevent the number in internal memory cache region is stored in
Preset limit value is not up to according to renewal request number, and is not continued for a long time on the premise of being stored in new data renewal request, institute
Caused can not perform asks asking for corresponding data renewal operation with the partial data renewal being stored in internal memory cache region
Topic.
The embodiment of the invention discloses a kind of updating device of data, accompanying drawing 4 is referred to, described device includes：
Preserving module 401, for when receiving data renewal request, the data to be updated into request deposit memory cache
Area；
Logging modle 402, for recording the data being stored in internal memory cache region renewal request number；
Classification and ordination module 403, for recording the data being stored in the internal memory cache region more when the logging modle 402
When new request number reaches preset limit value, according to the indexed sequential of database table, record is stored in the internal memory cache region
Data renewal request carry out sector classification and ordination, generate sector classification chart, the sector classification chart includes at least one sector
Classify sublist, each described sector classification sublist, which includes, to be carried out to same sector stored data corresponding to data renewal operation
Data renewal request；
Update module 404, for sector classification chart renewal to be arrived into the database table, carry out data renewal.
A kind of updating device of data disclosed in the embodiment of the present invention, the data that will be received by preserving module 401
Renewal request deposit internal memory cache region, it is possible to prevente effectively from directly updating the data when receiving a data renewal request
Request renewal is into database table, so that Database Systems perform a data renewal behaviour according to the more new content of database table
Make, and data renewal request number of the classification and ordination module 403 in logging modle 402 records deposit internal memory cache region reaches pre-
If during boundary value, the multiple data renewal request being stored into internal memory cache region carries out sector according to the indexed sequential of database table
Classification and ordination, generation include the sector classification chart of multiple sectors classification sublist, are advantageous to Database Systems in data updating process
The data renewal number of operations of middle execution and the number of the sector classification sublist in the sector classification chart of database table renewal gained
It is equal, it becomes possible to complete data renewal request need Database Systems perform total data renewal operation, and then solve because
Performing the data renewal operation equal with the data renewal number of requests received can just make sector stored data in database complete
Into the corresponding total data renewal request received data renewal the problem of, effectively reduce Database Systems according to data more
New request carries out number and the time of data renewal operation, improves the work of Database Systems processing data renewal request indirectly
The handling capacity of efficiency and Database Systems.
The course of work of modules provided in an embodiment of the present invention, the method flow diagram corresponding to accompanying drawing 1 is refer to, had
Body running process repeats no more.
Accompanying drawing 5 is referred to, the classification and ordination module 403 being related in embodiment corresponding to above-mentioned Fig. 4 specifically includes：
Sector sort module 4031, for the indexed sequential according to the database table, record is stored in the internal memory and delayed
Deposit the data renewal request in area and carry out sector classification, at least one sector classification sublist of generation；
Sector order module 4032, it is raw for the sector classification sublist of generation to be arranged according to genesis sequence
Into sector classification chart.
In the embodiment of the present invention, by sector sort module 4031 according to the indexed sequential of database table in record deposit
The data renewal request deposited in buffer area carries out sector classification, obtains multiple sector classification sublists, then by sector order module
The genesis sequence of 4032 foundation sector classification sublists is arranged, and can make the sector classification sublist in the sector classification chart of generation
Arrangement position and database table indexed sequential in sector arrangement position be consistent, make the sector in the classification chart of sector indirectly
The arrangement position for sublist of classifying is consistent with the arrangement position of data storage in database table, and then accelerates sector classification chart more
Newly into database table, and Database Systems perform the speed of data renewal operation according to the database table after renewal, indirectly
Improve the operating efficiency of Database Systems processing data renewal request and the handling capacity of Database Systems.
The course of work of modules provided in an embodiment of the present invention, the method flow diagram corresponding to accompanying drawing 2 is refer to, had
Body running process repeats no more.
On the basis of embodiment corresponding to above-mentioned Fig. 4, the embodiment of the invention discloses the updating device of another data,
Accompanying drawing 6 is referred to, described device includes：
Preserving module 401, logging modle 402, classification and ordination module 403, update module 404, timing module 405, judge
Module 406, generation module 407；
Wherein, the timing module 405, timing is carried out for starting timer, generates timer timing time；
The judge module 406, for judging whether the timer timing time reaches preset time value；
The classification and ordination module 403, it is additionally operable to judge that the timer timing time reaches in the judge module 406
After preset time value, according to the indexed sequential of database table, the data renewal being stored in record in the internal memory cache region please
Ask and carry out sector classification and ordination, generate sector classification chart.
The generation module 407, for sector classification chart renewal to be arrived into the database in the update module 404
Table, after carrying out data renewal, result is completed in generation renewal.
A kind of updating device of data disclosed in the embodiment of the present invention, timer is started by timing module 405 and carried out
Meter, timer timing time is generated, and when judge module 406 judges that timer timing time reaches preset time value, point
Data renewal request in the order deposit internal memory cache region of class order module 403 carries out sector point according to the indexed sequential of database table
Class sorts, and then generates sector classification chart, and the sector classification chart contained by after being updated so as to Database Systems using database table is more
The data that new corresponding sector is deposited, so as to effectively prevent the number for the data renewal request that deposit is recorded in internal memory cache region
Not up to preset limit value, and do not continue for a long time on the premise of being stored in new data renewal request, caused can not perform
Corresponding data are asked to update the problem of operating with the partial data renewal being stored in internal memory cache region.
The course of work of modules provided in an embodiment of the present invention, the method flow diagram corresponding to accompanying drawing 3 is refer to, had
Body running process repeats no more.
The embodiment of the invention discloses a kind of electronic equipment, refers to accompanying drawing 7, and the electronic equipment includes：
Transceiver 501, memory 502 and processor 503；
Wherein, the transceiver 501, for receiving data renewal request；
The memory 502 includes internal memory cache region and database table；
The processor 503, for when the transceiver 501 receives data renewal request, the data to be updated
Request is stored in the internal memory cache region, and record is stored in the data renewal request number in the internal memory cache region；When record is stored in
When data renewal request number in the internal memory cache region reaches preset limit value, the index according to the database table is suitable
Sequence, the data renewal request being stored in record in the internal memory cache region carry out sector classification and ordination, generate sector classification chart, institute
State sector classification chart and include at least one sector classification sublist, each described sector classification sublist is included to same sector institute
Deposit data carries out the corresponding data renewal request of data renewal operation；The data are arrived into sector classification chart renewal
Storehouse table, carry out data renewal.
A kind of electronic equipment disclosed in the embodiment of the present invention, the data for being received transceiver 501 by processor 503
Renewal request deposit internal memory cache region, it is possible to prevente effectively from processor 503 directly will when receiving a data renewal request
Data renewal request renewal is to the database table in memory 502, so that more new content of the processor 503 according to database table
A data renewal operation is performed, and processor 503 reaches in the data renewal request number that record is stored in internal memory cache region
During preset limit value, the rope according to database table is asked in multiple data renewal that internal memory cache region in memory 502 has been stored in
Draw order and carry out sector classification and ordination, generation includes the sector classification chart of multiple sectors classification sublist, is advantageous to processor 503 and exists
The data renewal number of operations performed in data updating process and the sector point in the sector classification chart of database table renewal gained
The number of class sublist is equal, it becomes possible to completes the total data renewal for needing processor 503 to perform corresponding to data renewal request
Operation, and then solve because the equal data renewal operation of the data renewal number of requests for performing with receiving can just make database
Interior sector stored data completes the problem of data renewal of the corresponding total data renewal request received, effectively reduces processing
Device 503 updates request according to data and carries out number and the time that data renewal operates, and improves the processing data of processor 503 indirectly
Update the operating efficiency and handling capacity of request.
On the basis of embodiment corresponding to above-mentioned Fig. 7, the embodiment of the invention discloses another electronic equipment, refer to
Accompanying drawing 8, the electronic equipment include：
Transceiver 501, memory 502, processor 503 and timer 504；
The timer 504, for timing, generate timer timing time；
Processor 503, it is additionally operable to judge whether the timer timing time reaches preset time value；If the timer
Timing time reaches the preset time value, according to the indexed sequential of the database table, to the number in the internal memory cache region
Ask to carry out sector classification and ordination according to renewal, generate sector classification chart.
A kind of electronic equipment disclosed in the embodiment of the present invention, judge to be generated by the timing of timer 504 by processor 503
Timer timing time when reaching preset time value, the data renewal in the order record deposit internal memory cache region of processor 503 please
Ask and carry out sector classification and ordination according to the indexed sequential of database table, and then generate sector classification chart, so as to subsequent processor 503
The data that the contained corresponding sector of sector classification chart renewal is deposited after being updated using database table, so as to effectively prevent in internal memory
The number of the data renewal request stored in buffer area is not up to preset limit value, and does not continue to be stored in new data more for a long time
On the premise of new request, caused processor 503 can not perform please with the partial data renewal being stored in internal memory cache region
The problem of asking corresponding data to update operation.
The foregoing description of the disclosed embodiments, professional and technical personnel in the field are enable to realize or using the present invention.
A variety of modifications to these embodiments will be apparent for those skilled in the art, as defined herein
General Principle can be realized in other embodiments without departing from the spirit or scope of the present invention.Therefore, it is of the invention
The embodiments shown herein is not intended to be limited to, and is to fit to and principles disclosed herein and features of novelty phase one
The most wide scope caused.
Claims (10)
- A kind of 1. update method of data, it is characterised in that including：When receiving data renewal request, the data are updated into request deposit internal memory cache region；Record is stored in the data renewal request number in the internal memory cache region；When the data renewal request number that record is stored in the internal memory cache region reaches preset limit value, according to database table Indexed sequential, the data renewal request being stored in record in the internal memory cache region carries out sector classification and ordination, generates sector Classification chart, the sector classification chart include at least one sector classification sublist, and each described sector classification sublist is included to same One sector stored data carries out the corresponding data renewal request of data renewal operation；The database table is arrived into sector classification chart renewal, carries out data renewal.
- 2. according to the method for claim 1, it is characterised in that the data being stored in record in the internal memory cache region After renewal request number, in addition to：Start timer and carry out timing, and generate timer timing time；Judge whether the timer timing time reaches preset time value；If the timer timing time reaches the preset time value, the indexed sequential according to database table is performed, it is right The data renewal request that record is stored in the internal memory cache region carries out sector classification and ordination, generates sector classification chart.
- 3. according to the method for claim 1, it is characterised in that the indexed sequential according to database table, record is deposited The data renewal request entered in the internal memory cache region carries out sector classification and ordination, generates sector classification chart, including：According to the indexed sequential of the database table, the data renewal request recorded in the deposit internal memory cache region is fanned Region class, at least one sector classification sublist of generation；The sector classification sublist of generation is arranged according to genesis sequence, generates sector classification chart.
- 4. according to the method for claim 1, it is characterised in that described that the data are arrived into sector classification chart renewal Storehouse table, after carrying out data renewal, in addition to：Result is completed in generation renewal.
- A kind of 5. updating device of data, it is characterised in that including：Preserving module, for when receiving data renewal request, the data to be updated into request deposit internal memory cache region；Logging modle, for recording the data being stored in internal memory cache region renewal request number；Classification and ordination module, for the data renewal request number being stored in when logging modle record in the internal memory cache region When reaching preset limit value, according to the indexed sequential of database table, the data being stored in record in the internal memory cache region update Request carries out sector classification and ordination, generates sector classification chart, and the sector classification chart includes at least one sector classification sublist, often One sector classification sublist includes the data corresponding to the progress data renewal operation of same sector stored data and updated Request；Update module, for sector classification chart renewal to be arrived into the database table, carry out data renewal.
- 6. device according to claim 5, it is characterised in that also include：Timing module, timing is carried out for starting timer, and generate timer timing time；Judge module, for judging whether the timer timing time reaches preset time value；The classification and ordination module, it is additionally operable to judge that the timer timing time reaches preset time value in the judge module Afterwards, according to the indexed sequential of database table, the data renewal request being stored in record in the internal memory cache region carries out sector Classification and ordination, generate sector classification chart.
- 7. device according to claim 5, it is characterised in that the classification and ordination module includes：Sector sort module, for the indexed sequential according to the database table, record is stored in the internal memory cache region Data renewal request carries out sector classification, at least one sector classification sublist of generation；Sector order module, for the sector classification sublist of generation to be arranged according to genesis sequence, generation sector point Class table.
- 8. device according to claim 5, it is characterised in that also include：Generation module, for sector classification chart renewal to be arrived into the database table in the update module, carry out data more After new, result is completed in generation renewal.
- 9. a kind of electronic equipment, it is characterised in that including：Transceiver, memory and processor；The transceiver, for receiving data renewal request；The memory includes internal memory cache region and database table；The processor, for when the transceiver receives data renewal request, the data to be updated into request deposit institute Internal memory cache region is stated, record is stored in the data renewal request number in the internal memory cache region；Delay when record is stored in the internal memory The data renewal request number in area is deposited when reaching preset limit value, according to the indexed sequential of the database table, record is deposited The data renewal request entered in the internal memory cache region carries out sector classification and ordination, generates sector classification chart, the sector classification Table includes at least one sector classification sublist, and each described sector classification sublist includes to be carried out to same sector stored data The corresponding data renewal request of data renewal operation；The database table is arrived into sector classification chart renewal, carries out data Renewal.
- 10. electronic equipment according to claim 9, it is characterised in that also include：Timer；The timer, for timing, generate timer timing time；The processor, it is additionally operable to judge whether the timer timing time reaches preset time value, if the timer meter When the time reach the preset time value, according to the indexed sequential of the database table, the internal memory cache region is stored in record In data renewal request carry out sector classification and ordination, generate sector classification chart.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710750743.4A CN107562851B (en) | 2017-08-28 | 2017-08-28 | Data updating method and device and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710750743.4A CN107562851B (en) | 2017-08-28 | 2017-08-28 | Data updating method and device and electronic equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107562851A true CN107562851A (en) | 2018-01-09 |
| CN107562851B CN107562851B (en) | 2020-10-23 |
Family
ID=60977461
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710750743.4A Active CN107562851B (en) | 2017-08-28 | 2017-08-28 | Data updating method and device and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107562851B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109933590A (en) * | 2019-03-19 | 2019-06-25 | 上海达梦数据库有限公司 | A kind of data-updating method, device, server and storage medium |
| CN110442579A (en) * | 2019-08-02 | 2019-11-12 | 杭州复杂美科技有限公司 | A kind of State Tree date storage method, synchronous method and equipment and storage medium |
| CN111459893A (en) * | 2020-04-03 | 2020-07-28 | 北京字节跳动网络技术有限公司 | File processing method and device and electronic equipment |
| CN113037853A (en) * | 2021-03-22 | 2021-06-25 | 北京字节跳动网络技术有限公司 | Data processing method, device, equipment and storage medium |
| CN115237927A (en) * | 2022-09-20 | 2022-10-25 | 神州医疗科技股份有限公司 | Method and system for updating data table based on cache and data processing rule |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8606575B1 (en) * | 2011-09-06 | 2013-12-10 | West Corporation | Method and apparatus of providing semi-automated classifier adaptation for natural language processing |
| CN104182441A (en) * | 2014-02-27 | 2014-12-03 | 无锡天脉聚源传媒科技有限公司 | Data sheet synchronization method and device |
| CN106528871A (en) * | 2016-12-06 | 2017-03-22 | 爱普（福建）科技有限公司 | Method for updating information of engineering data points in industrial control system on line |
-
2017
- 2017-08-28 CN CN201710750743.4A patent/CN107562851B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8606575B1 (en) * | 2011-09-06 | 2013-12-10 | West Corporation | Method and apparatus of providing semi-automated classifier adaptation for natural language processing |
| CN104182441A (en) * | 2014-02-27 | 2014-12-03 | 无锡天脉聚源传媒科技有限公司 | Data sheet synchronization method and device |
| CN106528871A (en) * | 2016-12-06 | 2017-03-22 | 爱普（福建）科技有限公司 | Method for updating information of engineering data points in industrial control system on line |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109933590A (en) * | 2019-03-19 | 2019-06-25 | 上海达梦数据库有限公司 | A kind of data-updating method, device, server and storage medium |
| CN109933590B (en) * | 2019-03-19 | 2021-04-20 | 上海达梦数据库有限公司 | Data updating method, device, server and storage medium |
| CN110442579A (en) * | 2019-08-02 | 2019-11-12 | 杭州复杂美科技有限公司 | A kind of State Tree date storage method, synchronous method and equipment and storage medium |
| CN110442579B (en) * | 2019-08-02 | 2022-06-28 | 杭州复杂美科技有限公司 | State tree data storage method, synchronization method and equipment and storage medium |
| CN111459893A (en) * | 2020-04-03 | 2020-07-28 | 北京字节跳动网络技术有限公司 | File processing method and device and electronic equipment |
| CN111459893B (en) * | 2020-04-03 | 2023-08-22 | 北京字节跳动网络技术有限公司 | File processing method and device and electronic equipment |
| CN113037853A (en) * | 2021-03-22 | 2021-06-25 | 北京字节跳动网络技术有限公司 | Data processing method, device, equipment and storage medium |
| CN113037853B (en) * | 2021-03-22 | 2023-01-06 | 北京字节跳动网络技术有限公司 | Data processing method, device, equipment and storage medium |
| CN115237927A (en) * | 2022-09-20 | 2022-10-25 | 神州医疗科技股份有限公司 | Method and system for updating data table based on cache and data processing rule |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107562851B (en) | 2020-10-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107562851A (en) | A kind of update method of data, device and electronic equipment | |
| CN102651009B (en) | Method and equipment for retrieving data in storage system | |
| CN104809179B (en) | The device and method for accessing Hash table | |
| US6961835B2 (en) | System and method for autonomically reallocating memory among buffer pools | |
| CN110837513B (en) | Cache updating method, device, server and storage medium | |
| CN101826107B (en) | Hash data processing method and device | |
| CN103927261A (en) | Efficient Allocation And Reclamation Method For Thin-provisioned Storage And System Thereof | |
| CN107632784A (en) | The caching method of a kind of storage medium and distributed memory system, device and equipment | |
| CN110555001B (en) | Data processing method, device, terminal and medium | |
| US20120089625A1 (en) | Incremental conversion of database objects during upgrade of an original system | |
| CN106445835A (en) | Memory allocation method and apparatus | |
| US20170160940A1 (en) | Data processing method and apparatus of solid state disk | |
| CN106649146A (en) | Memory release method and apparatus | |
| CN108228110A (en) | A kind of method and apparatus for migrating resource data | |
| CN110413413A (en) | A kind of method for writing data, device, equipment and storage medium | |
| CN104965793B (en) | A kind of cloud storage data node device | |
| CN106980471B (en) | Method and device for improving hard disk writing performance of intelligent equipment | |
| CN102724301B (en) | Cloud database system and method and equipment for reading and writing cloud data | |
| CN109992526A (en) | A kind of read-write management method and relevant apparatus | |
| US20230394307A1 (en) | Data caching method and apparatus for multiple concurrent deep learning training tasks | |
| CN106899558A (en) | The treating method and apparatus of access request | |
| CN112650449A (en) | Release method and release system of cache space, electronic device and storage medium | |
| CN107172222A (en) | A kind of date storage method and device based on distributed memory system | |
| CN108572930A (en) | Buffer control method and device | |
| CN106407347A (en) | Data caching method and apparatus |
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 |