CN105373541A - Processing method and system for data operation request of database - Google Patents
Processing method and system for data operation request of database Download PDFInfo
- Publication number
- CN105373541A CN105373541A CN201410419664.1A CN201410419664A CN105373541A CN 105373541 A CN105373541 A CN 105373541A CN 201410419664 A CN201410419664 A CN 201410419664A CN 105373541 A CN105373541 A CN 105373541A
- Authority
- CN
- China
- Prior art keywords
- data
- key word
- hash table
- tables
- request
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a processing method for a data operation request of a database. The processing method comprises the following steps of receiving a data writing request for a specified data table, wherein the data writing request comprises a keyword and update content corresponding to the keyword; searching for the keyword contained in the data writing request in a Hash table stored in a memory and corresponding to the data table; if the keyword contained in the data writing request is found in the Hash table, modifying a record corresponding to the keyword contained in the data writing request according to the update content in the Hash table; generating an SQL statement capable of realizing operation on the Hash table, and inserting the SQL statement into an update statement queue of the data table; and returning a processing result to a requester sending the data writing request. The method can greatly increase the response speed of the data operation request of the database. In addition, the invention provides a processing system for the data operation request of the database.
Description
[technical field]
The present invention relates to database technical field, particularly a kind of disposal route of data operation request of database and system.
[background technology]
Database (Database) be organize according to data structure, the warehouse of store and management data.Along with the development dataset management in infotech and market is no longer only store and management data, and be transformed into the mode of the various data managements required for user.Database has number of different types, is widely used all in all fields from the database the most simply storing various data form to the large-scale database system can carrying out mass data storage.According to the organizational form of the data stored, the kind of database can be divided into hierarchical data storehouse, network database and relevant database.Current widely used database comprises DB2, OracleInformix, Sybase, SQLServer and mySQL etc.
The operations such as user can increase newly the data in database, intercept, upgrade, deletion.But the response speed that database is made for the data operation request of user, extends along with the increase of the data volume of database purchase, especially when database will process the data operation request of magnanimity, response speed is just slower.
[summary of the invention]
Based on this, be necessary to provide a kind of disposal route and the system that improve the data operation request of the database of the response speed of data operation request to database.
A disposal route for the data operation request of database, comprises the following steps:
Receive write data requests to specific data table, write data request comprises key word and update content corresponding to key word;
Described tables of data corresponding be stored in the Hash table of internal memory the key word searched write data request and comprise;
If find the key word that write data request comprises in described Hash table, then the record that the key word comprised according to the request of described update content amendment write data in described Hash table is corresponding;
Generation can realize the SQL statement of the operation to described Hash table, described SQL statement is inserted in the renewal statement queue of described tables of data;
Result is returned to the requesting party sending write data request.
Wherein in an embodiment, described method also comprises:
If do not find the key word that write data request comprises in described Hash table, then in the described tables of data being stored in database, search the key word that write data request comprises;
If find the key word that write data request comprises in described tables of data, then read value corresponding with the key word that write data request comprises in described tables of data, the key word comprise write data request and the value of described correspondence write in described Hash table, and the record that the key word comprised according to the request of described update content amendment write data in described Hash table is corresponding;
If do not find the key word that write data request comprises in described tables of data, then generate value corresponding to key word that write data request comprises according to described update content, the key word comprise write data request and the value of described generation write in described Hash table.
Wherein in an embodiment, described method also comprises:
After described generation can realize the SQL statement to the operation of described Hash table, described SQL statement is written in journal file;
Described tables of data is revised according to the queue of described renewal statement;
After the SQL statement in the queue of described renewal statement is destroyed, revise described tables of data according to described journal file.
Wherein in an embodiment, described method also comprises:
Receive the read data request to specific data table, described read data request comprises key word;
Described tables of data corresponding be stored in the Hash table of internal memory the key word searched described read data request and comprise;
If find the key word that described read data request comprises in described Hash table, then in described Hash table, read the value that key word that described read data request comprises is corresponding;
Value according to described correspondence returns result to the requesting party sending described read data request.
Wherein in an embodiment, described method also comprises:
If do not find the key word that described read data request comprises in described Hash table, then in the described tables of data being stored in database, search the key word that described read data request comprises;
If find the key word that described read data request comprises in described tables of data, then read value corresponding with the key word that described read data request comprises in described tables of data, the key word comprise write data request and the value of described correspondence write in described Hash table, and the value according to described correspondence returns result to the requesting party sending described read data request.
If do not find the key word that described read data request comprises in described tables of data, then return the result representing and search failure to the requesting party sending described read data request.
A disposal system for the data operation request of database, comprising:
Acquisition request module, for receiving the write data requests to specific data table, write data request comprises key word and update content corresponding to key word;
Hash table searches module, for described tables of data corresponding be stored in the Hash table of internal memory the key word searched write data request and comprise;
Hash table update module, if for finding the key word that write data request comprises in described Hash table, then the record that the key word comprised according to the request of described update content amendment write data in described Hash table is corresponding;
SQL statement generation module, for generating the SQL statement of the operation that can realize described Hash table;
Queue writing module, for being inserted in the renewal statement queue of described tables of data by described SQL statement;
Write result and return module, for returning result to the requesting party sending write data request.
Wherein in an embodiment, described system also comprises:
Tables of data searches module, if for not finding the key word that write data request comprises in described Hash table, then search the key word that write data request comprises in the described tables of data being stored in database;
Tables of data read module, if for finding the key word that write data request comprises in described tables of data, then read value corresponding with the key word that write data request comprises in described tables of data;
Described Hash table update module also writes in described Hash table for the value of the key word that write data request comprised and described correspondence, and the record that the key word comprised according to the request of described update content amendment write data in described Hash table is corresponding;
If described Hash table update module also for not finding the key word that write data request comprises in described tables of data, then generate value corresponding to key word that write data request comprises according to described update content, the key word comprise write data request and the value of described generation write in described Hash table.
Wherein in an embodiment, described system also comprises:
Journal file writing module, after can realizing the SQL statement to the operation of described Hash table in described generation, is written in journal file by described SQL statement;
First tables of data update module, for revising described tables of data according to the queue of described renewal statement;
Second tables of data update module, for after the SQL statement in the queue of described renewal statement is destroyed, revises described tables of data according to described journal file.
Wherein in an embodiment, described request acquisition module is also for receiving the read data request to specific data table, and described read data request comprises key word;
Described Hash table search module also for described tables of data corresponding be stored in the Hash table of internal memory the key word searched described read data request and comprise;
Described system also comprises:
Hash table read module, if for finding the key word that described read data request comprises in described Hash table, then reads the value corresponding with the key word that described read data request comprises in described Hash table;
Read result and return module, read result for the value according to described correspondence to the requesting party's return data sending described read data request.
Wherein in an embodiment, if described tables of data searches module also for not finding the key word that described read data request comprises in described Hash table, then in the described tables of data being stored in database, search the key word that described read data request comprises;
If described tables of data read module also for finding the key word that described read data request comprises in described tables of data, then reads value corresponding with the key word that described read data request comprises in described tables of data;
Described Hash table update module also writes in described Hash table for the value of the key word that described read data request comprised and described correspondence;
Described result of reading returns module also for returning result according to the value of described correspondence to the requesting party sending described read data request.
The disposal route of the data operation request of above-mentioned database and system, after getting the write data requests to specific data table, specific data table corresponding be stored in the Hash table of internal memory the key word searched write data requests and comprise, if find, then corresponding to key word in Hash table value upgrades accordingly, in order to the Hash table that ensures to be stored in internal memory and the data consistency of tables of data being stored in database, generation can realize the SQL statement of the operation to Hash table, this SQL statement is inserted in the renewal statement queue of specific data table, follow-up the operation identical with Hash table is carried out to specific data table to facilitate, said method and system, can after corresponding Data Update operation be carried out in corresponding being stored in the Hash table of internal memory of specific data table, and after not needing to carry out this Data Update operation in the tables of data being stored in database, result can be returned to requesting party, because the speed of the Hash table being stored in internal memory being carried out to Data Update operation is far longer than the speed of the tables of data being stored in database being carried out to Data Update operation, therefore, the response speed of the data operation request to database can greatly be improved.
[accompanying drawing explanation]
Fig. 1 is the schematic flow sheet of the disposal route of the data operation request of database in an embodiment;
Fig. 2 is the schematic flow sheet of the disposal route of the data operation request of database in an embodiment;
Fig. 3 A is the schematic flow sheet of the disposal route of the data operation request of database in an embodiment;
Fig. 3 B is the schematic flow sheet of the step from increasing sequence number generating the SQL statement of current generation in an embodiment;
Fig. 3 C is the schematic flow sheet according to the step of the renewal statement queue amendment specific data table of specific data table in an embodiment;
Fig. 3 D is the schematic flow sheet according to the step of journal file amendment specific data table in an embodiment;
Fig. 4 is the schematic flow sheet to the processing procedure of read data request in an embodiment;
Fig. 5 is the schematic flow sheet to the processing procedure of read data request in an embodiment;
Fig. 6 is the structural representation of the disposal system of the data operation request of database in an embodiment;
Fig. 7 is the structural representation of the disposal system of the data operation request of database in an embodiment;
Fig. 8 is the structural representation of the disposal system of the data operation request of database in an embodiment;
Fig. 9 is the structural representation of the disposal system of the data operation request of database in an embodiment;
Figure 10 is the structural representation of the disposal system of the data operation request of database in an embodiment.
[embodiment]
As shown in Figure 1, in one embodiment, a kind of disposal route of data operation request of database, comprises the following steps:
Step S102, receives the write data requests to specific data table, and write data requests comprises key word and update content corresponding to key word.
Write data requests can be newly-increased request, the removal request to data or revises request.
Update content can comprise concrete row name and train value pair, if update content comprises row name and train value pair, then each row name and train value are to representing that value corresponding for key word in this row name respective column is set to this train value by request.Such as update content comprises (name, " Zhang San "), (birthday, row name and the train value pair such as 2014-6-10), its can represent request name is arranged in key word respective value be set to " Zhang San " and key word respective value in age column be set to 20.
Update content also can comprise delete instruction, if update content comprises delete instruction, then can represent that record corresponding to key word is deleted in request.
Step S104, specific data table corresponding be stored in the Hash table of internal memory the key word searched write data requests and comprise.The table name of tables of data is identical with the table name of corresponding Hash table.
In one embodiment, before step S104, the disposal route of the data operation request of above-mentioned database also comprises step: obtain the part or all of record in specific data table, in internal memory, generate the Hash table identical with the table name of specific data table, the part or all of record in specific data table is stored in corresponding Hash table.Concrete, in one embodiment, the access frequency of the record in specific data table can be added up, obtain the front default bar record that access frequency is high, the record of acquisition is stored in corresponding Hash table.
In one embodiment, the disposal route of the data operation request of above-mentioned database also comprises step: arrange Hash table stale data cleaning cycle, within each cycle, add up the access frequency of the record in Hash table, and each week end of term delete access frequency in this cycle low before preset bar record.
Step S106, the key word that write data requests comprises if find in Hash table, the then record that the key word comprised according to update content amendment write data requests in Hash table is corresponding.
If update content comprises row name and train value pair, then corresponding to each row name and train value pair, value corresponding for key word in row name respective column is wherein set to train value wherein, such as, update content comprises (name, " Zhang San ") this row name and train value pair, then in the name of Hash table can being arranged, key word respective value is set to " Zhang San ".
If update content comprises delete instruction, then can delete the record that in Hash table, key word is corresponding.
Step S108, generates the SQL statement of the operation that can realize Hash table, SQL statement is inserted in the renewal statement queue of tables of data.
Such as, the table name of Hash table is STUDENT, represent in Hash table that the row of the row of key word are called StudentID, write data requests comprises key word " 001 " and delete instruction, namely representing that StudentID in Hash table is deleted in request is the record of " 001 ", then can generate following SQL statement: DELETEFROMSTUDENTWHEREStudentID=' 001 '.Because the table name of Hash table is consistent with the table name of corresponding data table, therefore, same SQL statement can realize carrying out identical operation to Hash table and corresponding data table.
The SQL statement that will perform tables of data is contained in the renewal statement queue of tables of data.
Step S110, returns result to the requesting party sending write data requests.
If be successfully made the Data Update operation corresponding with write data requests to Hash table, then can return to requesting party and represent the successful object information of process.If run into exception to the Data Update operation corresponding with write data requests that Hash table carries out, then can return to requesting party the object information representing that process is failed.
As shown in Figure 2, in one embodiment, a kind of disposal route of data operation request of database, comprises the following steps:
Step S202, receives the write data requests to specific data table, and write data requests comprises key word and update content corresponding to key word.
Step S204, specific data table corresponding be stored in the Hash table of internal memory the key word searched write data requests and comprise, and judge whether to find this key word, if so, then perform step S206, otherwise, perform step S208.
Step S206, record corresponding according to the key word that comprises of update content amendment write data requests in Hash table, enters step S214.
Step S208, searches the key word that write data requests comprises in the tables of data being stored in database, and judges whether to find this key word, if so, then performs step S210, otherwise performs step S212.
Step S210, reads value corresponding with the key word that write data requests comprises in specific data table, in the value write Hash table of the key word comprise write data requests and correspondence, enters step S206.
Step S212, generates value corresponding to the key word that comprises of write data requests according to update content, in the value write Hash table of key word write data requests comprised and generation, enters step S214.
If the key word not having write data requests to comprise in specific data table, then can think that this write data requests is the request of newly-increased record.The train value comprised in update content can format according to the data type of respective column in Hash table by step S212, further, and can using the train value after key word and format as in a record write Hash table.Such as, in update content, comprise (birthday, 2014-6-10) this row name and train value pair, and the data type of birthday row to be length the be character string of 8 in Hash table, then 2014-6-10 can be formatted as 20140610.Further, can using key word and 20140610 as in a record write Hash table.
Step S214, generates the SQL statement of the operation that can realize Hash table, SQL statement is inserted in the renewal statement queue of tables of data.
Step S216, returns result to the requesting party sending write data requests.
In one embodiment, the disposal route of the data operation request of above-mentioned database, further comprising the steps of: after generating the SQL statement that can realize the operation of Hash table, SQL statement to be written in journal file; According to the renewal statement queue amendment specific data table of specific data table; After the SQL statement in the queue of renewal statement is destroyed, according to journal file amendment specific data table.
Step according to the renewal statement queue amendment specific data table of specific data table comprises: judge whether also have SQL statement in the renewal statement queue of specific data table, if, then obtain SQL statement from the queue heads of the renewal statement queue of specific data table and delete the SQL statement being positioned at queue heads, specific data table is performed to the SQL statement obtained, judge whether also have SQL statement in the renewal statement queue of specific data table, if not, then to terminate or interval preset duration to perform in the renewal statement queue judging specific data table the step whether also having SQL statement again.
In the present embodiment, the SQL statement that will perform specific data table is placed into be had in the renewal statement queue of first in first out, relative to the renewal rewards theory to Hash table, time delay can be carried out by the renewal rewards theory of specific data table, usually can in the data operation request of database less period or in computer system comparatively idle period, the renewal rewards theory to tables of data is focused on according to the queue of renewal statement, avoid fighting for system resource with the process of data operation request, thus avoid the response speed that slows down to data operation request.
In one embodiment, upgrading statement queue and be stored in internal memory, the speed to upgrading the read-write of statement queuing data can being accelerated, thus accelerate the response speed to the data operation request of database.And at computing machine generation abnormal failure after crashing, the data be stored in the renewal statement queue in internal memory may be destroyed, in the present embodiment, in this case, then can revise specific data table according to journal file, because be also written with the SQL statement of the operation that can realize Hash table in journal file.Therefore, the present embodiment, even if computing machine generation abnormal failure and crashing, also can revise specific data table according to journal file, guarantee that the operation to tables of data should perform is accomplished, thus ensures the accuracy of the result returned to requesting party.
Step S102 ~ S110, according to the step of the renewal statement queue of specific data table amendment specific data table and can be realized by different processes or thread according to the step of journal file amendment specific data table, thus the object that the operation reached Hash table and the operation to tables of data are independent of each other, to accelerate response speed to data operation request, also can reach when computing machine no exceptions the operation of tables of data and the object that is independent of each other to the operation of tables of data when computing machine occurs abnormal.
As shown in Figure 3A, in one embodiment, a kind of disposal route of data operation request of database, comprises step:
Step S302, receives the write data requests to specific data table, and write data requests comprises key word and update content corresponding to key word.
Step S304, specific data table corresponding be stored in the Hash table of internal memory the key word searched write data requests and comprise, and judge whether to find this key word, if so, then perform step S306, otherwise, perform step S308.
Step S306, record corresponding according to the key word that comprises of update content amendment write data requests in Hash table, enters step S314.
Step S308, searches the key word that write data requests comprises in the tables of data being stored in database, and judges whether to find this key word, if so, then performs step S310, otherwise performs step S312.
Step S310, the value that the key word that in reading specific data table, write data requests comprises is corresponding, in the value write Hash table of key word write data requests comprised and correspondence, enters step S306.
Step S312, generates value corresponding to the key word that comprises of write data requests according to update content, in the value write Hash table of key word write data requests comprised and generation, enters step S314.
Step S314, generates the SQL statement that can realize operation to Hash table, and generate the SQL statement of current generation from increasing sequence number.
SQL statement be can the sequence number of unique identification SQL statement from increasing sequence number, and the SQL statement first generated from increasing sequence number be less than the SQL statement of rear generation from increasing sequence number.
In one embodiment, be made up of, before wherein timestamp is positioned at sequence number timestamp and count number two parts from increasing sequence number; Can generate 0 sequence as initial from increasing sequence number, 0 sequence can comprise one or more 0; As shown in Figure 3 B, comprising the following steps from the step of increasing sequence number of the SQL statement of current generation is generated:
Step S1, obtains current time in system stamp.
Step S2, what arrange the SQL statement of current generation equals current time in system stamp from the timestamp of increasing sequence number.
Step S3, judges whether current time in system stamp is greater than the last timestamp from increasing sequence number generated, and if so, then performs step S4, if not, then performs step S5.
Last generate from increasing sequence number for generate in the upper write data requests process of process SQL statement from increasing sequence number.
S4, what arrange the SQL statement of current generation equals 0 from the count number of increasing sequence number, enters step S6.
S5, arrange the SQL statement of current generation from the count number of increasing sequence number equal last generate add 1 from the count number of increasing sequence number, enter step S6.
S6, by arrange above-mentioned timestamp and count number according to preset format hand over word string, and by conversion after timestamp and count number be combined into the SQL statement of current generation from increasing sequence number.
Such as, timestamp is converted to the character string only retaining numeral wherein, count number is converted to the character string that length is 6.Such as, if timestamp is 2014-06-1109:50:20, count number is 0, then timestamp can be converted to 20140611095020, count number is converted to 000000, and splicing obtain the SQL statement of current generation from increasing sequence number: 20140611095020000000.
Step S315, is inserted into SQL statement in the renewal statement queue of specific data table as data from increasing sequence number with corresponding, and being written to SQL statement and correspondence in journal file from increasing sequence correspondence.
Step S316, returns result to the requesting party sending write data requests.
In one embodiment, the disposal route of the data operation request of above-mentioned database also comprises the step of the renewal statement queue amendment specific data table according to specific data table, and as shown in Figure 3 C, this step comprises:
Step S318, judges whether also have SQL statement in the renewal statement queue of specific data table, if so, then performs step S320, if not, then perform step S324.
Step S320, from the queue heads of the renewal statement queue of specific data table obtain SQL statement and correspondence from increasing sequence number, and delete the SQL statement that is positioned at queue heads and correspondence from increasing sequence number.
Step S322, to specific data table perform obtain SQL statement, and record to specific data table perform SQL statement corresponding from increasing sequence number, enter step S318.
In one embodiment, a serial number data table can be generated at database, for recording table name and the corresponding relation from increasing sequence number.Wherein, table name corresponding from increasing sequence number be the SQL statement of up-to-date execution in tables of data that this table name is corresponding from increasing sequence number.Step S322 can arrange in this serial number data table the table name of specific data table corresponding from the increasing sequence number SQL statement that is up-to-date execution on specific data table from increasing sequence number.
Step S324, arranges reminding alarm clock, makes execution thread or the executive process of reminding alarm clock wake-up step S318 after preset duration.
In one embodiment, the disposal route of the data operation request of above-mentioned database also comprises step: after the SQL statement in the queue of renewal statement is destroyed, according to journal file amendment specific data table.As shown in Figure 3 D, comprise the following steps according to the step of journal file amendment specific data table:
Step S326, obtain to the SQL statement of the up-to-date execution of specific data table from increasing sequence number.
In one embodiment, can search in above-mentioned serial number data table the table name of specific data table corresponding from increasing sequence number, can obtain to the SQL statement of the up-to-date execution of specific data table from increasing sequence number.
Step S328, search in journal file the SQL statement of up-to-date execution from increasing sequence number, obtain this from increasing sequence number later from increasing sequence number corresponding SQL statement.
Should from increasing sequence number later be greater than this from increasing sequence number from increasing sequence number; Should from increasing sequence number later from increasing sequence number corresponding SQL statement, for the SQL statement generated after the SQL statement to the up-to-date execution of specific data table, these SQL statement perform on the Hash table that specific data table is corresponding, it also should perform on specific data table, but does not also perform on specific data table.
Step S330, performs the SQL statement of above-mentioned acquisition to specific data table.
In one embodiment, the disposal route of the data operation request of above-mentioned database also comprises the processing procedure to read data request, and as shown in Figure 4, this process comprises the following steps:
Step S402, receive the read data request to specific data table, read data request comprises key word.
Step S404, tables of data corresponding be stored in the Hash table of internal memory the key word searched read data request and comprise.
Step S406, the key word that read data request comprises if find in Hash table, then read the value that key word that read data request comprises is corresponding in Hash table.
Step S408, the value according to correspondence returns result to the requesting party sending read data request.
In one embodiment, the row name that request is read also is comprised in read data request.After step S406, the above-mentioned processing procedure to read data request also comprises step: obtain the data of asking the row name correspondence read in corresponding value.Step S408 can return the data of the key word of acquisition and the row name correspondence of request reading to the requesting party sending read data request.
As shown in Figure 5, in one embodiment, the processing procedure of read data request is comprised the following steps:
Step S502, receive the read data request to specific data table, read data request comprises key word.
Step S504, tables of data corresponding be stored in the Hash table of internal memory the key word searched read data request and comprise, and judge whether to find this key word, if so, then perform step S506, otherwise, perform step S508.
Step S506, reads the value that key word that read data request comprises is corresponding, enters step S514 in Hash table.
Step S508, searches the key word that read data request comprises in the tables of data being stored in database, and judges whether to find this key word, if so, then performs step S510, otherwise performs step S512.
Step S510, the value that the key word that in reading specific data table, read data request comprises is corresponding, in the value write Hash table of key word read data request comprised and correspondence, enters step S514.
Step S512, returns the result representing and search failure to the requesting party sending read data request.
Step S514, the value according to correspondence returns result to the requesting party sending read data request.
As shown in Figure 6, in one embodiment, a disposal system for the data operation request of database, comprises acquisition request module 10, Hash table searches module 20, Hash table update module 30, SQL statement generation module 40, queue writing module 50 and write result and return module 60, wherein:
Acquisition request module 10 is for receiving the write data requests to specific data table, and write data requests comprises key word and update content corresponding to key word.
Write data requests can be newly-increased request, the removal request to data or revises request.
Update content can comprise concrete row name and train value pair, if update content comprises row name and train value pair, then each row name and train value are to representing that value corresponding for key word in this row name respective column is set to this train value by request.
Update content also can comprise delete instruction, if update content comprises delete instruction, then can represent that record corresponding to key word is deleted in request.
Hash table search module 20 for specific data table corresponding be stored in the Hash table of internal memory the key word searched write data requests and comprise.The table name of tables of data is identical with the table name of corresponding Hash table.
In one embodiment, the disposal system of the data operation request of above-mentioned database also comprises Hash table generation module (not shown), for obtaining the part or all of record in specific data table, in internal memory, generate the Hash table identical with the table name of specific data table, the part or all of record in specific data table is stored in corresponding Hash table.Concrete, in one embodiment, the disposal system of the data operation request of above-mentioned database also comprises tables of data access frequency statistical module (not shown), for adding up the access frequency of the record in specific data table; Hash generation module can obtain the high front default bar record of access frequency, is stored into by the record of acquisition in corresponding Hash table.
In one embodiment, the disposal system Hash table cleaning module (not shown) of the data operation request of above-mentioned database, for arranging Hash table stale data cleaning cycle, within each cycle, add up the access frequency of the record in Hash table, and each week end of term delete access frequency in this cycle low before preset bar record.
If the key word that Hash table update module 30 comprises for finding write data requests in Hash table, then corresponding according to the key word that comprises of update content amendment write data requests in Hash table record.
If update content comprises row name and train value pair, then corresponding to each row name and train value pair, value corresponding for key word in row name respective column is wherein set to train value wherein.
If update content comprises delete instruction, then can delete the record that in Hash table, key word is corresponding.
SQL statement, for generating the SQL statement of the operation that can realize Hash table, is inserted in the renewal statement queue of tables of data by SQL statement generation module 40.
Because the table name of Hash table is consistent with the table name of corresponding data table, therefore, same SQL statement can realize carrying out identical operation to Hash table and corresponding data table.
The SQL statement that will perform tables of data is contained in the renewal statement queue of tables of data.
Write result and return module 60 for returning result to the requesting party sending write data requests.
If be successfully made the operation of corresponding with write data requests Data Update to Hash table, then write result and return module 60 and can return to requesting party and represent the successful object information of process.If run into exception to corresponding with the write data requests Data Update operation that Hash table carries out, then write result and return module 60 and can return to requesting party the object information representing that process is failed.
As shown in Figure 7, in one embodiment, the disposal system of the data operation request of above-mentioned database also comprises tables of data and searches module 70 and tables of data read module 80; In the present embodiment:
Tables of data searches module 70, if for not finding the key word that write data requests comprises in Hash table, then search the key word that write data requests comprises in the tables of data being stored in database.
Tables of data read module 80, if for finding the key word that write data requests comprises in tables of data, then reads value corresponding with the key word that write data requests comprises in tables of data.
In the value write Hash table of the correspondence that Hash table update module 30 also reads for the key word that write data requests comprised and tables of data read module 80, and the record that the key word comprised according to update content amendment write data requests in Hash table is corresponding.
If Hash table update module 30 also for not finding the key word that write data requests comprises in tables of data, then generate value corresponding to the key word that comprises of write data requests according to update content, in the value write Hash table of key word write data requests comprised and generation.
If the key word not having write data requests to comprise in specific data table, then can think that this write data requests is the request of newly-increased record.The train value comprised in update content can format according to the data type of respective column in Hash table by Hash table update module 30, further, and can using the train value after key word and format as in a record write Hash table.
As shown in Figure 8, in one embodiment, the disposal system of the data operation request of above-mentioned database also comprises journal file writing module 90, first tables of data update module 100 and the second tables of data update module 110, wherein:
Journal file writing module 90, for after generating the SQL statement that can realize the operation of Hash table, is written to SQL statement in journal file.
First tables of data update module 100, for according to renewal statement queue Update Table table.
Second tables of data update module 110, for after the SQL statement in the queue of renewal statement is destroyed, according to journal file Update Table table.
First tables of data update module 100 for judge specific data table the queue of renewal statement in whether also have SQL statement, if, then obtain SQL statement from the queue heads of the renewal statement queue of specific data table and delete the SQL statement being positioned at queue heads, specific data table is performed to the SQL statement obtained, judge whether also have SQL statement in the renewal statement queue of specific data table and perform corresponding operating according to judged result, if not, then to terminate or interval preset duration to judge in the renewal statement queue of specific data table whether also have SQL statement again.
In the present embodiment, the SQL statement that will perform specific data table is placed into be had in the renewal statement queue of first in first out, relative to the renewal rewards theory to Hash table, time delay can be carried out by the renewal rewards theory of specific data table, usually the first tables of data update module 100 can in the data operation request of database less period or in computer system comparatively idle period, the renewal rewards theory to tables of data is focused on according to the queue of renewal statement, avoid fighting for system resource with the process of data operation request, thus avoid the response speed that slows down to data operation request.
In one embodiment, upgrading statement queue and be stored in internal memory, the speed to upgrading the read-write of statement queuing data can being accelerated, thus accelerate the response speed to the data operation request of database.And at computing machine generation abnormal failure after crashing, the data be stored in the renewal statement queue in internal memory may be destroyed, in the present embodiment, in this case, second tables of data update module 110 can revise specific data table according to journal file, because be also written with the SQL statement of the operation that can realize Hash table in journal file.Therefore, the present embodiment, even if computing machine generation abnormal failure and crashing, also can revise specific data table according to journal file, guarantee that the operation to tables of data should perform is accomplished, thus ensures the accuracy of the result returned to requesting party.
Realize acquisition request module 10, Hash table searches module 20, Hash table update module 30, SQL statement generation module 40 and write thread/process that result returns module 60, thread/the process realizing the first tables of data update module 100 and the thread/process realizing the second tables of data update module 110 can be different thread/processes, thus the object that the operation reached Hash table and the operation to tables of data are independent of each other, to accelerate the response speed to data operation request, also can reach when computing machine no exceptions the operation of tables of data and the object that is independent of each other to the operation of tables of data when computing machine occurs abnormal.
As shown in Figure 9, in one embodiment, the disposal system of the data operation request of above-mentioned database also comprises from increasing sequence generation module 120, for after generating the SQL statement that can realize the operation of Hash table, generate the SQL statement of current generation from increasing sequence number.
SQL statement be can the sequence number of unique identification SQL statement from increasing sequence number, and the SQL statement first generated from increasing sequence number be less than the SQL statement of rear generation from increasing sequence number.
Can be made up of, before wherein timestamp is positioned at sequence number timestamp and count number two parts from increasing sequence number; Can generate 0 sequence as initial from increasing sequence number from increasing sequence generation module 110,0 sequence can comprise one or more 0; Can comprising from the process of increasing sequence number of the SQL statement of current generation is generated from increasing sequence generation module 110:
Obtain current time in system stamp.What arrange the SQL statement of current generation equals current time in system stamp from the timestamp of increasing sequence number.Judge whether current time in system stamp is greater than the last timestamp from increasing sequence number generated, if, what then arrange the SQL statement of current generation equals 0 from the count number of increasing sequence number, if not, then arrange the SQL statement of current generation from the count number of increasing sequence number equal last generate add 1 from the count number of increasing sequence number.By arrange above-mentioned timestamp and count number according to preset format hand over word string, and by conversion after timestamp and count number be combined into the SQL statement of current generation from increasing sequence number.
In the present embodiment, queue writing module 50 is for being inserted in the renewal statement queue of specific data table from increasing sequence number as data with corresponding using SQL statement, and journal file writing module 90 is for being written to SQL statement and correspondence in journal file from increasing sequence correspondence.
In the present embodiment, first tables of data update module 100 for judge specific data table the queue of renewal statement in whether also have SQL statement, if, then from the queue heads of the renewal statement queue of specific data table obtain SQL statement and correspondence from increasing sequence number, and delete the SQL statement that is positioned at queue heads and correspondence from increasing sequence number; Specific data table is performed to the SQL statement obtained, and record to specific data table perform SQL statement corresponding from increasing sequence number, to judge in the renewal statement queue of specific data table whether also have SQL statement and perform corresponding operation according to judged result further, if not, then arrange reminding alarm clock, what make reminding alarm clock after preset duration, wake the first tables of data update module 100 up realizes thread or process.
The disposal system of the data operation request of above-mentioned database also can comprise serial number data table generation module (not shown), for generating a serial number data table at database, this serial number data table is for recording table name and the corresponding relation from increasing sequence number.Wherein, table name corresponding from increasing sequence number be the SQL statement of up-to-date execution in tables of data that this table name is corresponding from increasing sequence number.First tables of data update module 100 can arrange in this serial number data table the table name of specific data table corresponding from the increasing sequence number SQL statement that is up-to-date execution on specific data table from increasing sequence number.
In the present embodiment, second tables of data update module 110 is for after the SQL statement in the queue of renewal statement is destroyed, obtain to the SQL statement of the up-to-date execution of specific data table from increasing sequence number, search in journal file the SQL statement of up-to-date execution from increasing sequence number, obtain this from increasing sequence number later from increasing sequence number corresponding SQL statement, specific data table is performed to the SQL statement of above-mentioned acquisition.
In one embodiment, the second tables of data update module 110 can search in above-mentioned serial number data table the table name of specific data table corresponding from increasing sequence number, can obtain to the SQL statement of the up-to-date execution of specific data table from increasing sequence number.
The SQL statement of up-to-date execution from increasing sequence number later from increasing sequence number be greater than the SQL statement of up-to-date execution from increasing sequence number; The SQL statement of up-to-date execution from increasing sequence number later from increasing sequence number corresponding SQL statement, for the SQL statement generated after the SQL statement to the up-to-date execution of specific data table, these SQL statement perform on the Hash table that specific data table is corresponding, it also should perform on specific data table, but does not also perform on specific data table.
In one embodiment, acquisition request module 10 is also for receiving the read data request to specific data table, and read data request comprises key word.
Hash table search module 20 also for specific data table corresponding be stored in the Hash table of internal memory the key word searched read data request and comprise.
In the present embodiment, as shown in Figure 10, the disposal system of the data operation request of above-mentioned database also comprises Hash table read module 130 and reads result and returns module 140, wherein:
Hash table read module 130, if for finding the key word that read data request comprises in Hash table, then reads the value that key word that read data request comprises is corresponding in Hash table.
Read result and return module 140, read result for the value according to correspondence to the requesting party's return data sending read data request.
In one embodiment, the row name that request is read also is comprised in read data request.Reading result and return module 140, for obtaining the data of asking the row name correspondence read in corresponding value, and returning the data of the key word of acquisition and the row name correspondence of request reading to the requesting party sending read data request.
In one embodiment, if tables of data searches module 70 also for not finding the key word that read data request comprises in Hash table, then in the tables of data being stored in database, the key word that read data request comprises is searched.
If tables of data read module 80 also for finding the key word that read data request comprises in tables of data, then read value corresponding with the key word that read data request comprises in tables of data.
Hash table update module 30 is also in the value write Hash table of the key word that read data request comprised and correspondence.
Read result and return module 140 also for returning result according to the value of correspondence to the requesting party sending read data request.
The disposal route of the data operation request of above-mentioned database and system, after receiving the write data requests to specific data table, specific data table corresponding be stored in the Hash table of internal memory the key word searched write data requests and comprise, if find, then corresponding to key word in Hash table value upgrades accordingly, in order to the Hash table that ensures to be stored in internal memory and the data consistency of tables of data being stored in database, generation can realize the SQL statement of the operation to Hash table, this SQL statement is inserted in the renewal statement queue of specific data table, follow-up the operation identical with Hash table is carried out to specific data table to facilitate, said method and system, can after corresponding Data Update operation be carried out in corresponding being stored in the Hash table of internal memory of specific data table, and after not needing to carry out this Data Update operation in the tables of data being stored in database, result can be returned to requesting party, because the speed of the Hash table being stored in internal memory being carried out to Data Update operation is far longer than the speed of the tables of data being stored in database being carried out to Data Update operation, therefore, the response speed of the data operation request to database can greatly be improved.
The above embodiment only have expressed several embodiment of the present invention, and it describes comparatively concrete and detailed, but therefore can not be interpreted as the restriction to the scope of the claims of the present invention.It should be pointed out that for the person of ordinary skill of the art, without departing from the inventive concept of the premise, can also make some distortion and improvement, these all belong to protection scope of the present invention.Therefore, the protection domain of patent of the present invention should be as the criterion with claims.
Claims (10)
1. a disposal route for the data operation request of database, comprises the following steps:
Receive write data requests to specific data table, write data request comprises key word and update content corresponding to key word;
Described tables of data corresponding be stored in the Hash table of internal memory the key word searched write data request and comprise;
If find the key word that write data request comprises in described Hash table, then the record that the key word comprised according to the request of described update content amendment write data in described Hash table is corresponding;
Generation can realize the SQL statement of the operation to described Hash table, described SQL statement is inserted in the renewal statement queue of described tables of data;
Result is returned to the requesting party sending write data request.
2. the disposal route of the data operation request of database according to claim 1, is characterized in that, described method also comprises:
If do not find the key word that write data request comprises in described Hash table, then in the described tables of data being stored in database, search the key word that write data request comprises;
If find the key word that write data request comprises in described tables of data, then read value corresponding with the key word that write data request comprises in described tables of data, the key word comprise write data request and the value of described correspondence write in described Hash table, and the record that the key word comprised according to the request of described update content amendment write data in described Hash table is corresponding;
If do not find the key word that write data request comprises in described tables of data, then generate value corresponding to key word that write data request comprises according to described update content, the key word comprise write data request and the value of described generation write in described Hash table.
3. the disposal route of the data operation request of database according to claim 1 and 2, is characterized in that, described method also comprises:
After described generation can realize the SQL statement to the operation of described Hash table, described SQL statement is written in journal file;
Described tables of data is revised according to the queue of described renewal statement;
After the SQL statement in the queue of described renewal statement is destroyed, revise described tables of data according to described journal file.
4. the disposal route of the data operation request of database according to claim 1, is characterized in that, described method also comprises:
Receive the read data request to specific data table, described read data request comprises key word;
Described tables of data corresponding be stored in the Hash table of internal memory the key word searched described read data request and comprise;
If find the key word that described read data request comprises in described Hash table, then in described Hash table, read the value that key word that described read data request comprises is corresponding;
Value according to described correspondence returns result to the requesting party sending described read data request.
5. the disposal route of the data operation request of database according to claim 4, is characterized in that, described method also comprises:
If do not find the key word that described read data request comprises in described Hash table, then in the described tables of data being stored in database, search the key word that described read data request comprises;
If find the key word that described read data request comprises in described tables of data, then read value corresponding with the key word that described read data request comprises in described tables of data, the key word comprise write data request and the value of described correspondence write in described Hash table, and the value according to described correspondence returns result to the requesting party sending described read data request.
If do not find the key word that described read data request comprises in described tables of data, then return the result representing and search failure to the requesting party sending described read data request.
6. a disposal system for the data operation request of database, is characterized in that, comprising:
Acquisition request module, for receiving the write data requests to specific data table, write data request comprises key word and update content corresponding to key word;
Hash table searches module, for described tables of data corresponding be stored in the Hash table of internal memory the key word searched write data request and comprise;
Hash table update module, if for finding the key word that write data request comprises in described Hash table, then the record that the key word comprised according to the request of described update content amendment write data in described Hash table is corresponding;
SQL statement generation module, for generating the SQL statement of the operation that can realize described Hash table;
Queue writing module, for being inserted in the renewal statement queue of described tables of data by described SQL statement;
Write result and return module, for returning result to the requesting party sending write data request.
7. the disposal system of the data operation request of database according to claim 6, is characterized in that, described system also comprises:
Tables of data searches module, if for not finding the key word that write data request comprises in described Hash table, then search the key word that write data request comprises in the described tables of data being stored in database;
Tables of data read module, if for finding the key word that write data request comprises in described tables of data, then read value corresponding with the key word that write data request comprises in described tables of data;
Described Hash table update module also writes in described Hash table for the value of the key word that write data request comprised and described correspondence, and the record that the key word comprised according to the request of described update content amendment write data in described Hash table is corresponding;
If described Hash table update module also for not finding the key word that write data request comprises in described tables of data, then generate value corresponding to key word that write data request comprises according to described update content, the key word comprise write data request and the value of described generation write in described Hash table.
8. the disposal system of the data operation request of the database according to claim 6 or 7, is characterized in that, described system also comprises:
Journal file writing module, after can realizing the SQL statement to the operation of described Hash table in described generation, is written in journal file by described SQL statement;
First tables of data update module, for revising described tables of data according to the queue of described renewal statement;
Second tables of data update module, for after the SQL statement in the queue of described renewal statement is destroyed, revises described tables of data according to described journal file.
9. the disposal system of the data operation request of database according to claim 6, is characterized in that, described request acquisition module is also for receiving the read data request to specific data table, and described read data request comprises key word;
Described Hash table search module also for described tables of data corresponding be stored in the Hash table of internal memory the key word searched described read data request and comprise;
Described system also comprises:
Hash table read module, if for finding the key word that described read data request comprises in described Hash table, then reads the value corresponding with the key word that described read data request comprises in described Hash table;
Read result and return module, read result for the value according to described correspondence to the requesting party's return data sending described read data request.
10. the disposal system of the data operation request of database according to claim 9, it is characterized in that, if described tables of data searches module also for not finding the key word that described read data request comprises in described Hash table, then in the described tables of data being stored in database, search the key word that described read data request comprises;
If described tables of data read module also for finding the key word that described read data request comprises in described tables of data, then reads value corresponding with the key word that described read data request comprises in described tables of data;
Described Hash table update module also writes in described Hash table for the value of the key word that described read data request comprised and described correspondence;
Described result of reading returns module also for returning result according to the value of described correspondence to the requesting party sending described read data request.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410419664.1A CN105373541B (en) | 2014-08-22 | 2014-08-22 | The processing method and system of the data operation request of database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410419664.1A CN105373541B (en) | 2014-08-22 | 2014-08-22 | The processing method and system of the data operation request of database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105373541A true CN105373541A (en) | 2016-03-02 |
| CN105373541B CN105373541B (en) | 2019-03-22 |
Family
ID=55375748
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410419664.1A Active CN105373541B (en) | 2014-08-22 | 2014-08-22 | The processing method and system of the data operation request of database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105373541B (en) |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105956166A (en) * | 2016-05-19 | 2016-09-21 | 北京京东尚科信息技术有限公司 | Database reading-writing method and database reading-writing apparatus |
| CN106446272A (en) * | 2016-10-20 | 2017-02-22 | 北京百度网讯科技有限公司 | Method and device for sending data |
| CN106682082A (en) * | 2016-11-23 | 2017-05-17 | 青岛海信移动通信技术股份有限公司 | Writing method and device of database |
| CN106815327A (en) * | 2016-12-29 | 2017-06-09 | 南京欣网互联信息技术有限公司 | One kind is for moving operation data resource regeneration method |
| CN106899654A (en) * | 2016-08-10 | 2017-06-27 | 阿里巴巴集团控股有限公司 | A kind of sequence value generation method, apparatus and system |
| CN106933657A (en) * | 2017-03-10 | 2017-07-07 | 中国银行股份有限公司 | Database deadlocks processing method and processing device |
| CN107357794A (en) * | 2016-05-10 | 2017-11-17 | 北京京东尚科信息技术有限公司 | Optimize the method and apparatus of the data store organisation of key value database |
| CN109471857A (en) * | 2018-09-25 | 2019-03-15 | 中国平安人寿保险股份有限公司 | Data modification method, device and storage medium based on SQL statement |
| CN109597818A (en) * | 2018-11-28 | 2019-04-09 | 优刻得科技股份有限公司 | Data-updating method, device, storage medium and equipment |
| CN110222028A (en) * | 2019-04-30 | 2019-09-10 | 重庆小雨点小额贷款有限公司 | A kind of data managing method, device, equipment and storage medium |
| CN111125129A (en) * | 2019-12-10 | 2020-05-08 | 珠海格力电器股份有限公司 | Data processing method and device, storage medium and processor |
| CN111522827A (en) * | 2020-04-08 | 2020-08-11 | 北京奇艺世纪科技有限公司 | Data updating method and device and electronic equipment |
| CN111581212A (en) * | 2020-05-06 | 2020-08-25 | 深圳市朱墨科技有限公司 | Data storage method, system, server and storage medium of relational database |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20040065464A (en) * | 2003-01-14 | 2004-07-22 | 삼성전자주식회사 | Apparatus and method for duplication of database management system |
| CN101364217A (en) * | 2007-08-08 | 2009-02-11 | 华为技术有限公司 | Data maintenance method, equipment and system thereof in data-base |
| CN101369283A (en) * | 2008-09-25 | 2009-02-18 | 中兴通讯股份有限公司 | Data synchronization method and system for internal memory database physical data base |
| CN101510209A (en) * | 2009-03-30 | 2009-08-19 | 北京金山软件有限公司 | Method, system and server for implementing real time search |
| CN101587476A (en) * | 2008-05-22 | 2009-11-25 | 中兴通讯股份有限公司 | Memory database system for realizing distributed storage and application thereof |
| CN102426611A (en) * | 2012-01-13 | 2012-04-25 | 广州从兴电子开发有限公司 | Database synchronization method and device thereof |
| CN102999522A (en) * | 2011-09-15 | 2013-03-27 | 阿里巴巴集团控股有限公司 | Data storage method and device |
-
2014
- 2014-08-22 CN CN201410419664.1A patent/CN105373541B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20040065464A (en) * | 2003-01-14 | 2004-07-22 | 삼성전자주식회사 | Apparatus and method for duplication of database management system |
| CN101364217A (en) * | 2007-08-08 | 2009-02-11 | 华为技术有限公司 | Data maintenance method, equipment and system thereof in data-base |
| CN101587476A (en) * | 2008-05-22 | 2009-11-25 | 中兴通讯股份有限公司 | Memory database system for realizing distributed storage and application thereof |
| CN101369283A (en) * | 2008-09-25 | 2009-02-18 | 中兴通讯股份有限公司 | Data synchronization method and system for internal memory database physical data base |
| CN101510209A (en) * | 2009-03-30 | 2009-08-19 | 北京金山软件有限公司 | Method, system and server for implementing real time search |
| CN102999522A (en) * | 2011-09-15 | 2013-03-27 | 阿里巴巴集团控股有限公司 | Data storage method and device |
| CN102426611A (en) * | 2012-01-13 | 2012-04-25 | 广州从兴电子开发有限公司 | Database synchronization method and device thereof |
Cited By (20)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107357794A (en) * | 2016-05-10 | 2017-11-17 | 北京京东尚科信息技术有限公司 | Optimize the method and apparatus of the data store organisation of key value database |
| CN107357794B (en) * | 2016-05-10 | 2020-06-05 | 北京京东尚科信息技术有限公司 | Method and device for optimizing data storage structure of key value database |
| CN105956166A (en) * | 2016-05-19 | 2016-09-21 | 北京京东尚科信息技术有限公司 | Database reading-writing method and database reading-writing apparatus |
| CN106899654B (en) * | 2016-08-10 | 2020-02-07 | 阿里巴巴集团控股有限公司 | Sequence value generation method, device and system |
| CN106899654A (en) * | 2016-08-10 | 2017-06-27 | 阿里巴巴集团控股有限公司 | A kind of sequence value generation method, apparatus and system |
| CN106446272A (en) * | 2016-10-20 | 2017-02-22 | 北京百度网讯科技有限公司 | Method and device for sending data |
| CN106682082A (en) * | 2016-11-23 | 2017-05-17 | 青岛海信移动通信技术股份有限公司 | Writing method and device of database |
| CN106815327A (en) * | 2016-12-29 | 2017-06-09 | 南京欣网互联信息技术有限公司 | One kind is for moving operation data resource regeneration method |
| CN106933657A (en) * | 2017-03-10 | 2017-07-07 | 中国银行股份有限公司 | Database deadlocks processing method and processing device |
| CN106933657B (en) * | 2017-03-10 | 2020-12-04 | 中国银行股份有限公司 | Database deadlock processing method and device |
| CN109471857A (en) * | 2018-09-25 | 2019-03-15 | 中国平安人寿保险股份有限公司 | Data modification method, device and storage medium based on SQL statement |
| CN109471857B (en) * | 2018-09-25 | 2023-07-25 | 中国平安人寿保险股份有限公司 | SQL statement-based data modification method, device and storage medium |
| CN109597818A (en) * | 2018-11-28 | 2019-04-09 | 优刻得科技股份有限公司 | Data-updating method, device, storage medium and equipment |
| CN110222028A (en) * | 2019-04-30 | 2019-09-10 | 重庆小雨点小额贷款有限公司 | A kind of data managing method, device, equipment and storage medium |
| CN110222028B (en) * | 2019-04-30 | 2022-11-15 | 重庆小雨点小额贷款有限公司 | Data management method, device, equipment and storage medium |
| CN111125129A (en) * | 2019-12-10 | 2020-05-08 | 珠海格力电器股份有限公司 | Data processing method and device, storage medium and processor |
| CN111522827A (en) * | 2020-04-08 | 2020-08-11 | 北京奇艺世纪科技有限公司 | Data updating method and device and electronic equipment |
| CN111522827B (en) * | 2020-04-08 | 2023-09-05 | 北京奇艺世纪科技有限公司 | Data updating method and device and electronic equipment |
| CN111581212A (en) * | 2020-05-06 | 2020-08-25 | 深圳市朱墨科技有限公司 | Data storage method, system, server and storage medium of relational database |
| CN111581212B (en) * | 2020-05-06 | 2024-05-17 | 深圳市朱墨科技有限公司 | Data storage method, system, server and storage medium of relational database |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105373541B (en) | 2019-03-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105373541A (en) | Processing method and system for data operation request of database | |
| US11334544B2 (en) | Method, apparatus, device and medium for storing and querying data | |
| US7765215B2 (en) | System and method for providing a trustworthy inverted index to enable searching of records | |
| US8924365B2 (en) | System and method for range search over distributive storage systems | |
| CN106407360B (en) | Data processing method and device | |
| CN107977396B (en) | Method and device for updating data table of KeyValue database | |
| US11216516B2 (en) | Method and system for scalable search using microservice and cloud based search with records indexes | |
| JP6982049B2 (en) | Methods, equipment, equipment and storage media for managing indexes | |
| CN111737443B (en) | Answer text processing method and device and key text determining method | |
| CN114564620A (en) | Graph data storage method and system and computer equipment | |
| CN107145538B (en) | Table data query method, device and system | |
| CN108073595B (en) | Method and device for realizing data updating and snapshot in OLAP database | |
| CN106874329A (en) | The implementation method and device of database table index | |
| CN101639851A (en) | Method for storing and querying data and devices therefor | |
| CN113704267A (en) | Data query method, system, equipment and storage medium based on elastic search | |
| CN101853278A (en) | Application method of data storage system | |
| CN112434062A (en) | Quasi-real-time data processing method, device, server and storage medium | |
| CN113918535A (en) | Data reading method, device, equipment and storage medium | |
| CN114840497A (en) | Method, system and device for preprocessing row migration of database and storage medium | |
| CN114218277A (en) | Efficient query method and device for relational database | |
| CN113127660A (en) | Timing graph database storage method and device | |
| CN112685557A (en) | Visualized information resource management method and device | |
| US9323753B2 (en) | Method and device for representing digital documents for search applications | |
| CN115168409B (en) | Data query method and device for database sub-tables and computer equipment | |
| CN116304453A (en) | Information processing method and device, storage medium and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |