CN105373541B - The processing method and system of the data operation request of database - Google Patents
The processing method and system of the data operation request of database Download PDFInfo
- Publication number
- CN105373541B CN105373541B CN201410419664.1A CN201410419664A CN105373541B CN 105373541 B CN105373541 B CN 105373541B CN 201410419664 A CN201410419664 A CN 201410419664A CN 105373541 B CN105373541 B CN 105373541B
- Authority
- CN
- China
- Prior art keywords
- data
- keyword
- request
- tables
- hash table
- 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.)
- Active
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A kind of processing method of the data operation request of database, comprising the following steps: receive the write data requests to specified tables of data, include keyword and the corresponding more new content of keyword in write data request；The keyword for including in write data request is searched in the corresponding Hash table for being stored in memory of the tables of data；If finding the keyword for including in write data request in the Hash table, according to the corresponding record of keyword for including in the update content modification write data request in the Hash table；The SQL statement that the operation to the Hash table can be achieved is generated, the SQL statement is inserted into the update sentence queue of the tables of data；Processing result is returned to the requesting party that write data are requested is sent.The above method is greatly improved the response speed to the data operation request of database.In addition, also providing a kind of processing system of the data operation request of database.
Description
[technical field]
The present invention relates to database technical field, in particular to a kind of processing method of the data operation request of database and
System.
[background technique]
Database (Database) is the warehouse for coming tissue, storage and management data according to data structure.With information skill
The management of the development dataset in art and market is only no longer storage and management data, and is transformed into various data pipes required for user
The mode of reason.Database is there are many kinds of type, from the databases of the simplest various data forms of storage to being able to carry out magnanimity
The large-scale database system of data storage is all widely used in all fields.According to the tissue shape of the data of storage
The type of formula, database can be divided into hierarchical data library, network database and relevant database.At present using relatively broad
Database include DB2, Oracle Informix, Sybase, SQL Server and mySQL etc..
User such as can increase to the data in database, intercept, update, deleting newly at the operation.However, database is directed to
The response speed that the data operation request of user is made, extends with the increase of the data volume of database purchase, especially when
When database will handle the data operation request of magnanimity, response speed is just slower.
[summary of the invention]
Based on this, it is necessary to provide a kind of database that the response speed to the data operation request of database can be improved
The processing method and system of data operation request.
A kind of processing method of the data operation request of database, comprising the following steps:
The write data requests to specified tables of data are received, include that keyword and keyword are corresponding in write data request
More new content；
The key for including in write data request is searched in the corresponding Hash table for being stored in memory of the tables of data
Word；
If finding the keyword for including in write data request, the root in the Hash table in the Hash table
According to the corresponding record of keyword for including in the update content modification write data request；
The SQL statement that the operation to the Hash table can be achieved is generated, the SQL statement is inserted into the tables of data
It updates in sentence queue；
Processing result is returned to the requesting party that write data are requested is sent.
In one of the embodiments, the method also includes:
If not finding the keyword for including in write data request in the Hash table, it is being stored in database
The tables of data in search write data request in include keyword；
If finding the keyword for including in write data request in the tables of data, read in the tables of data
With the corresponding value of keyword for including in write data request, by write data request in the keyword that includes and described
Corresponding value is written in the Hash table, and according in update content modification write data request in the Hash table
Including the corresponding record of keyword；
If the keyword for including in write data request is not found in the tables of data, according in the update
Hold generate write data request in include the corresponding value of keyword, by write data request in include keyword and
The value of the generation is written in the Hash table.
In one of the embodiments, the method also includes:
After the generation can be achieved to the SQL statement of the operation of the Hash table, the SQL statement is written to day
In will file；
The tables of data is modified according to the update sentence queue；
After the SQL statement in the update sentence queue is destroyed, the tables of data is modified according to the journal file.
In one of the embodiments, the method also includes:
The read data request to specified tables of data is received, includes keyword in the read data request；
The key for including in the read data request is searched in the corresponding Hash table for being stored in memory of the tables of data
Word；
If finding the keyword for including in the read data request in the Hash table, read in the Hash table
Take the corresponding value of the keyword for including in the read data request；
According to the corresponding requesting party's return processing result being worth to the transmission read data request.
In one of the embodiments, the method also includes:
If not finding the keyword for including in the read data request in the Hash table, it is being stored in database
The tables of data in search the keyword for including in the read data request；
If finding the keyword for including in the read data request in the tables of data, read in the tables of data
Value corresponding with the keyword for including in the read data request, by write data request in the keyword that includes and described
Corresponding value is written in the Hash table, according to the corresponding requesting party's return processing being worth to the transmission read data request
As a result.
If not finding the keyword for including in the read data request in the tables of data, to the transmission reading
The result for indicating to search failure is returned according to the requesting party of request.
A kind of processing system of the data operation request of database, comprising:
Request module includes closing in write data request for receiving the write data requests to specified tables of data
Key word and the corresponding more new content of keyword；
Hash table searching module, for writing number described in the lookup in the corresponding Hash table for being stored in memory of the tables of data
According to the keyword for including in request；
Hash table update module, if for finding the key for including in write data request in the Hash table
Word, then according to the corresponding note of keyword for including in the update content modification write data request in the Hash table
Record；
SQL statement generation module, for generating the SQL statement that the operation to the Hash table can be achieved；
Queue writing module, for being inserted into the SQL statement in the update sentence queue of the tables of data；
Result return module is write, for returning to processing result to the requesting party for sending write data request.
In one of the embodiments, the system also includes:
Tables of data searching module, if for not finding the key for including in write data request in the Hash table
Word then searches the keyword for including in write data request in the tables of data for being stored in database；
Tables of data read module, if for finding the key for including in write data request in the tables of data
Word then reads value corresponding with the keyword for including in write data request in the tables of data；
The Hash table update module be also used to request write data in the keyword that includes and described corresponding
Value is written in the Hash table, and includes according in update content modification write data request in the Hash table
The corresponding record of keyword；
If the Hash table update module is also used to not find in the tables of data in write data request
Keyword, then generate the corresponding value of keyword for including in write data request according to the more new content, write described
The keyword for including in request of data and the value of the generation are written in the Hash table.
In one of the embodiments, the system also includes:
Journal file writing module, for it is described generate can be achieved to the SQL statement of the operation of the Hash table after,
The SQL statement is written in journal file；
First tables of data update module, for modifying the tables of data according to the update sentence queue；
Second tables of data update module, for when it is described update sentence queue in SQL statement be destroyed after, according to described
Journal file modifies the tables of data.
The request module, which is also used to receive, in one of the embodiments, asks the reading data of specified tables of data
It asks, includes keyword in the read data request；
The Hash table searching module is also used to search institute in the corresponding Hash table for being stored in memory of the tables of data
State the keyword for including in read data request；
The system also includes:
Hash table read module, if for finding the key for including in the read data request in the Hash table
Word then reads value corresponding with the keyword for including in the read data request in the Hash table；
Result return module is read, for according to the corresponding requesting party's return number being worth to the transmission read data request
According to reading result.
If the tables of data searching module is also used to not find institute in the Hash table in one of the embodiments,
The keyword for including in read data request is stated, then is searched in the tables of data for being stored in database in the read data request
Including keyword；
If the tables of data read module is also used to find in the read data request in the tables of data
Keyword then reads value corresponding with the keyword for including in the read data request in the tables of data；
The Hash table update module is also used to the keyword that will include in the read data request and described corresponding
Value is written in the Hash table；
The result return module of reading is also used to according to the corresponding requesting party being worth to the transmission read data request
Return to processing result.
The processing method and system of the data operation request of above-mentioned database write data to specified tables of data getting
After request, the keyword for including in write data requests is searched in the specified corresponding Hash table for being stored in memory of tables of data, if
It finds, then the corresponding value of keyword is updated accordingly in Hash table, in order to guarantee the Hash table for being stored in memory
With the data consistency for the tables of data for being stored in database, the SQL statement that the operation to Hash table can be achieved is generated, by the SQL
Sentence is inserted into the update sentence queue of specified tables of data, subsequent identical with Hash table to the progress of specified tables of data to facilitate
Operation；The above method and system can carry out corresponding data more in the corresponding Hash table for being stored in memory of specified tables of data
It, can be to request after carrying out data update operation in the tables of data for being stored in database after new operation
Side returns to processing result, and updating the speed of operation due to carrying out data to the Hash table for being stored in memory is far longer than to being stored in
Therefore the speed that the tables of data of database carries out data update operation is greatly improved to the data operation request of database
Response speed.
[Detailed description of the invention]
Fig. 1 is the flow diagram of the processing method of the data operation request of the database in one embodiment；
Fig. 2 is the flow diagram of the processing method of the data operation request of the database in one embodiment；
Fig. 3 A is the flow diagram of the processing method of the data operation request of the database in one embodiment；
Fig. 3 B be generated in one embodiment the SQL statement being currently generated from increasing row number the step of process signal
Figure；
Fig. 3 C is in one embodiment according to the step of specifying the update sentence queue of tables of data to modify specified tables of data
Flow diagram；
Fig. 3 D is flow diagram the step of modifying specified tables of data according to journal file in one embodiment；
Fig. 4 is in one embodiment to the flow diagram of the treatment process of read data request；
Fig. 5 is in one embodiment to the flow diagram of the treatment process of read data request；
Fig. 6 is the structural schematic diagram of the processing system of the data operation request of the database in one embodiment；
Fig. 7 is the structural schematic diagram of the processing system of the data operation request of the database in one embodiment；
Fig. 8 is the structural schematic diagram of the processing system of the data operation request of the database in one embodiment；
Fig. 9 is the structural schematic diagram of the processing system of the data operation request of the database in one embodiment；
Figure 10 is the structural schematic diagram of the processing system of the data operation request of the database in one embodiment.
[specific embodiment]
As shown in Figure 1, in one embodiment, a kind of processing method of the data operation request of database, including it is following
Step:
Step S102 receives the write data requests to specified tables of data, includes keyword and key in write data requests
The corresponding more new content of word.
Write data requests can be for the newly-increased request of data, removal request or modification request.
More new content may include specific column name and train value pair, each if in more new content including column name and train value pair
Column name and train value are to can indicate that the corresponding value of keyword in the column name respective column sets the train value by request.Such as more new content
Including column name and the train value pair such as (name, " Zhang San "), (birthday, 2014-6-10), can indicate request by name arrange in keyword
Respective value is set as " Zhang San " and sets 20 for keyword respective value in age column.
More new content may also comprise deletion instruction, if including deleting instruction in more new content, can indicate that request is deleted and close
The corresponding record of key word.
Step S104, in the corresponding Hash table for being stored in memory of specified tables of data search write data requests in include
Keyword.The table name of tables of data is identical as the table name of corresponding Hash table.
In one embodiment, before step S104, the processing method of the data operation request of above-mentioned database is also wrapped
Include step: record some or all of in the specified tables of data of acquisition generates identical with the table name of specified tables of data in memory
Hash table, by record storage some or all of in specified tables of data into corresponding Hash table.Specifically, in one embodiment
In, the access frequency of the record in statistics available specified tables of data obtains the high preceding default item record of access frequency, the note that will acquire
Address book stored is into corresponding Hash table.
In one embodiment, the processing method of the data operation request of above-mentioned database further comprises the steps of: setting Hash
Table stale data cleaning cycle counts the access frequency of the record in Hash table within each period, and in each period
Delete the low preceding default item record of access frequency in this period in end.
Step S106, if finding the keyword for including in write data requests in Hash table, the basis in Hash table
Update the corresponding record of keyword for including in content modification write data requests.
If more new content includes column name and train value pair, each column name and train value pair are corresponded to, column name therein is corresponding
The train value that the corresponding value of keyword is arranged in column, for example, more new content includes (name, " Zhang San ") this column name and column
Value pair then can set " Zhang San " for keyword respective value in the name of Hash table column.
If more new content includes deleting instruction, the corresponding record of keyword in Hash table can be deleted.
Step S108 generates the SQL statement that the operation to Hash table can be achieved, SQL statement is inserted into tables of data more
In new sentence queue.
For example, the table name of Hash table is STUDENT, the entitled Student ID of column of the column of keyword is indicated in Hash table,
It include keyword " 001 " and deletion instruction in write data requests, that is, indicating that Student ID in Hash table is deleted in request is " 001 "
Record, then produce following SQL statement: DELETE FROM STUDENT WHERE Student ID=' 001 '.Due to breathing out
The table name of uncommon table is consistent with the table name of corresponding data table, and therefore, same SQL statement can be realized to Hash table and corresponding data table
Carry out identical operation.
The SQL statement that will be executed to tables of data is contained in the update sentence queue of tables of data.
Step S110 returns to processing result to the requesting party for sending write data requests.
If being successfully made data corresponding with write data requests to Hash table updates operation, table can be returned to requesting party
Show the successful result information of processing.If updating operation to the data corresponding with write data requests that Hash table carries out encounters exception,
The result information for indicating processing failure can be then returned to requesting party.
As shown in Fig. 2, in one embodiment, a kind of processing method of the data operation request of database, including it is following
Step:
Step S202 receives the write data requests to specified tables of data, includes keyword and key in write data requests
The corresponding more new content of word.
Step S204, in the corresponding Hash table for being stored in memory of specified tables of data search write data requests in include
Keyword, and judge whether to find the keyword, if so, thening follow the steps S206, otherwise, execute step S208.
Step S206, according to the corresponding note of keyword for including in update content modification write data requests in Hash table
Record, enters step S214.
Step S208 searches the keyword for including in write data requests in the tables of data for being stored in database, and judges
Whether the keyword is found, if so, S210 is thened follow the steps, it is no to then follow the steps S212.
Step S210 reads value corresponding with the keyword for including in write data requests in specified tables of data, will write data
In the keyword for including in request and corresponding value write-in Hash table, S206 is entered step.
Step S212 generates the corresponding value of keyword for including in write data requests according to more new content, will write data and ask
It asks the value of the keyword and generation that include to be written in Hash table, enters step S214.
If there is no the keyword for including in write data requests in specified tables of data, it may be considered that the write data requests are new
Increase the request of record.Step S212 can carry out the train value for including in more new content according to the data type of respective column in Hash table
It formats, it further, can be using keyword and formatted train value as in a record write-in Hash table.For example, more
It include (birthday, 2014-6-10) this column name and train value pair in new content, and the data type that the birthday arranges in Hash table is length
For 8 character strings, then 2014-6-10 can be formatted as 20140610.It further, can be by keyword and 20140610
As in a record write-in Hash table.
Step S214 generates the SQL statement that the operation to Hash table can be achieved, SQL statement is inserted into tables of data more
In new sentence queue.
Step S216 returns to processing result to the requesting party for sending write data requests.
In one embodiment, the processing method of the data operation request of above-mentioned database, it is further comprising the steps of: in life
After it can be achieved to the SQL statement of the operation of Hash table, SQL statement is written in journal file；According to specified tables of data
Update sentence queue modify specified tables of data；After the SQL statement in update sentence queue is destroyed, repaired according to journal file
Change specified tables of data.
The step of modifying specified tables of data according to the update sentence queue of specified tables of data includes: to judge specified tables of data
Update in sentence queue whether there are also SQL statements, if so, obtaining from the queue heads of the update sentence queue of specified tables of data
SQL statement simultaneously deletes the SQL statement for being located at queue heads, and the SQL statement obtained is executed to specified tables of data, judges specified tables of data
Update sentence queue in whether there are also SQL statement, if it is not, then terminating or be spaced preset duration and execute judgement again to specify data
The step of whether there are also SQL statements in the update sentence queue of table.
In the present embodiment, the update with first in first out is placed into specified tables of data SQL statement to be executed
In sentence queue, relative to the update operation to Hash table, it can will be delayed to the update of specified tables of data operation, generally
It can be in the data operation request of database less period or the period more idle in computer system, according to update sentence team
Column centralized processing operates the update of tables of data, avoids the processing with data operation request from fighting for system resource, to avoid subtracting
Slowly to the response speed of data operation request.
In one embodiment, it updates sentence queue to be stored in memory, can accelerate to update sentence queuing data read-write
Speed, to accelerate the response speed to the data operation request of database.And failure is abnormal in computer and is crashed
Afterwards, the data in update sentence queue being stored in memory are likely to be broken, and in the present embodiment, in this case, then may be used
Specified tables of data is modified according to journal file, because being also written with the SQL language that the operation to Hash table can be achieved in journal file
Sentence.Therefore, the present embodiment can also modify specified tables of data even if computer is abnormal failure and crashes according to journal file,
Ensure that the operation that should be executed to tables of data is accomplished, to guarantee the accuracy of the processing result returned to requesting party.
Step S102~S110, according to the step of specifying the update sentence queue of tables of data to modify specified tables of data and
The step of modifying specified tables of data according to journal file can be realized by different process or thread, to reach to Hash table
Operation and the purpose being independent of each other to the operation of tables of data, to accelerate also to can reach the response speed of data operation request
To the behaviour of tables of data to the operation of tables of data and in the case where computer is abnormal in the case where computer no exceptions
Make the purpose being independent of each other.
As shown in Figure 3A, in one embodiment, a kind of processing method of the data operation request of database, including step
It is rapid:
Step S302 receives the write data requests to specified tables of data, includes keyword and key in write data requests
The corresponding more new content of word.
Step S304, in the corresponding Hash table for being stored in memory of specified tables of data search write data requests in include
Keyword, and judge whether to find the keyword, if so, thening follow the steps S306, otherwise, execute step S308.
Step S306, according to the corresponding note of keyword for including in update content modification write data requests in Hash table
Record, enters step S314.
Step S308 searches the keyword for including in write data requests in the tables of data for being stored in database, and judges
Whether the keyword is found, if so, S310 is thened follow the steps, it is no to then follow the steps S312.
Step S310 reads the corresponding value of keyword for including in write data requests in specified tables of data, will write data and ask
It asks the keyword for including and corresponding value to be written in Hash table, enters step S306.
Step S312 generates the corresponding value of keyword for including in write data requests according to more new content, will write data and ask
It asks the value of the keyword and generation that include to be written in Hash table, enters step S314.
Step S314 generates the SQL statement that the operation to Hash table can be achieved, and generates the SQL statement being currently generated
From increasing row number.
SQL statement from increasing row number be can unique identification SQL statement sequence number, and the SQL statement first generated from
The SQL statement that increasing row number generates after being less than from increasing row number.
In one embodiment, it is made of from increasing row number timestamp and count number two parts, wherein timestamp is located at sequence
Before row number；0 sequence is produced as initial from increasing row number, 0 sequence may include one or more 0；As shown in Figure 3B, raw
The step of at the SQL statement being currently generated from increasing row number the following steps are included:
Step S1 obtains current time in system stamp.
Step S2, the timestamp from increasing row number that the SQL statement being currently generated is arranged are stabbed equal to the current time in system.
Step S3, judges whether current time in system stamp is greater than the last timestamp from increasing row number generated, if so,
S4 is thened follow the steps, if it is not, thening follow the steps S5.
Last time generate from increasing row number be the upper write data requests of processing during generation SQL statement from increasing
Row number.
S4, the count number from increasing row number that the SQL statement being currently generated is arranged are equal to 0, enter step S6.
S5, be arranged the SQL statement being currently generated the count number from increasing row number be equal to it is last generate from increasing sequence
Number count number add 1, enter step S6.
S6, by the above-mentioned timestamp of setting and count number according to preset format hand over word string, and by the time after conversion
Stamp and count number be combined into the SQL statement being currently generated from increasing row number.
For example, timestamp to be converted to the character string for only retaining number therein, it is 6 that count number, which is converted to length,
Character string.For example, count number 0 can then be converted to timestamp if timestamp is 2014-06-1109:50:20
20140611095020, count number is converted to 000000, and splice the SQL statement being currently generated from increasing row number:
20140611095020000000。
Step S315 is inserted into specified tables of data more as a data from increasing row number using SQL statement with corresponding
In new sentence queue, and SQL statement and corresponding correspond to from increasing row number are written in journal file.
Step S316 returns to processing result to the requesting party for sending write data requests.
In one embodiment, the processing method of the data operation request of above-mentioned database further includes according to specified tables of data
Update sentence queue the step of modifying specified tables of data, as shown in Figure 3 C, which includes:
Step S318 judges whether there are also SQL statements in the update sentence queue of specified tables of data, if so, executing step
Rapid S320, if it is not, thening follow the steps S324.
Step S320 obtains SQL statement and corresponding from increasing from the queue heads of the update sentence queue of specified tables of data
Row number, and delete and be located at the SQL statement of queue heads and corresponding from increasing row number.
Step S322 executes the SQL statement obtained to specified tables of data, and records the SQL language executed to specified tables of data
Sentence is corresponding from increasing row number, enters step S318.
In one embodiment, a serial number data table can be generated in database, for record table name with from increasing sequence
Number corresponding relationship.Wherein, table name it is corresponding from increasing row number be the corresponding tables of data of the table name on newest execution SQL statement
From increasing row number.The table name that specified tables of data can be arranged in step S322 in the serial number data table is corresponding from increasing row number
For specify the SQL statement of newest execution in tables of data from increasing row number.
Reminding alarm clock is arranged, so that the execution thread of reminding alarm clock wake-up step S318 after preset duration in step S324
Or executive process.
In one embodiment, further comprise the steps of: ought more newspeak for the processing method of the data operation request of above-mentioned database
After SQL statement in sentence queue is destroyed, specified tables of data is modified according to journal file.As shown in Figure 3D, according to journal file
The step of modifying specified tables of data the following steps are included:
Step S326 is obtained to the SQL statement of the newest execution of specified tables of data from increasing row number.
In one embodiment, the table name that specified tables of data can be searched in above-mentioned serial number data table is corresponding from increasing
Row number can be obtained to the SQL statement of the newest execution of specified tables of data from increasing row number.
Step S328, searched in journal file the SQL statement of newest execution from increasing row number, obtaining should be from increasing sequence
It is number later from the corresponding SQL statement of increasing row number.
This is greater than this from increasing row number from increasing row number from increasing row number is later；This is later from increasing from increasing row number
The corresponding SQL statement of row number, for the SQL statement generated after the SQL statement to the newest execution of specified tables of data, these SQL
Sentence executes on the corresponding Hash table of specified tables of data, should also execute in specified tables of data, but not exist also
It is executed in specified tables of data.
Step S330 executes the SQL statement of above-mentioned acquisition to specified tables of data.
In one embodiment, the processing method of the data operation request of above-mentioned database further includes to read data request
Treatment process, as shown in figure 4, the process the following steps are included:
Step S402 receives the read data request to specified tables of data, includes keyword in read data request.
Step S404 searches the key for including in read data request in the corresponding Hash table for being stored in memory of tables of data
Word.
Step S406 is read in Hash table if finding the keyword for including in read data request in Hash table
The corresponding value of the keyword for including in read data request.
Step S408 is worth according to corresponding to the requesting party's return processing result for sending read data request.
It in one embodiment, further include the column name of request reading in read data request.It is above-mentioned right after step S406
The treatment process of read data request further comprises the steps of: the corresponding data of column name for obtaining and requesting to read in corresponding value.Step
The corresponding data of column name that S408 can return to the keyword obtained to the requesting party for sending read data request and request is read.
As shown in figure 5, in one embodiment, treatment process to read data request the following steps are included:
Step S502 receives the read data request to specified tables of data, includes keyword in read data request.
Step S504 searches the key for including in read data request in the corresponding Hash table for being stored in memory of tables of data
Word, and judge whether to find the keyword, if so, thening follow the steps S506, otherwise, execute step S508.
Step S506 reads the corresponding value of keyword for including in read data request in Hash table, enters step S514.
Step S508 searches the keyword for including in read data request in the tables of data for being stored in database, and judges
Whether the keyword is found, if so, S510 is thened follow the steps, it is no to then follow the steps S512.
Step S510 reads the corresponding value of keyword for including in read data request in specified tables of data, will read data and asks
It asks the keyword for including and corresponding value to be written in Hash table, enters step S514.
Step S512 returns to the result for indicating to search failure to the requesting party for sending read data request.
Step S514 is worth according to corresponding to the requesting party's return processing result for sending read data request.
As shown in fig. 6, in one embodiment, a kind of processing system of the data operation request of database, including request
Obtain module 10, Hash table searching module 20, Hash table update module 30, SQL statement generation module 40, queue writing module 50
With write result return module 60, in which:
Request module 10 is used to receive the write data requests to specified tables of data, includes keyword in write data requests
And the corresponding more new content of keyword.
Write data requests can be for the newly-increased request of data, removal request or modification request.
More new content may include specific column name and train value pair, each if in more new content including column name and train value pair
Column name and train value are to can indicate that the corresponding value of keyword in the column name respective column sets the train value by request.
More new content may also comprise deletion instruction, if including deleting instruction in more new content, can indicate that request is deleted and close
The corresponding record of key word.
Hash table searching module 20, which is used to search in the corresponding Hash table for being stored in memory of specified tables of data, writes data
The keyword for including in request.The table name of tables of data is identical as the table name of corresponding Hash table.
In one embodiment, the processing system of the data operation request of above-mentioned database further includes Hash table generation module
(not shown) generates and specified tables of data in memory for some or all of obtaining in specified tables of data record
The identical Hash table of table name, by record storage some or all of in specified tables of data into corresponding Hash table.Specifically,
In one embodiment, the processing system of the data operation request of above-mentioned database further includes tables of data access frequency statistical module
(not shown), for counting the access frequency of the record in specified tables of data；Hash generation module can obtain access frequency
High preceding default item record, the record storage that will acquire is into corresponding Hash table.
In one embodiment, the processing system Hash table cleaning modul of the data operation request of above-mentioned database is (in figure
It is not shown), for Hash table stale data cleaning cycle to be arranged, the access of the record in Hash table is counted within each period
Frequency, and deleted each week end of term and preset item record before access frequency is low in this period.
If Hash table update module 30 is being breathed out for finding the keyword for including in write data requests in Hash table
According to the corresponding record of keyword for including in update content modification write data requests in uncommon table.
If more new content includes column name and train value pair, each column name and train value pair are corresponded to, column name therein is corresponding
The train value that the corresponding value of keyword is arranged in column.
If more new content includes deleting instruction, the corresponding record of keyword in Hash table can be deleted.
SQL statement generation module 40 is used to generate the SQL statement that the operation to Hash table can be achieved, and SQL statement is inserted into
Into the update sentence queue of tables of data.
Since the table name of Hash table is consistent with the table name of corresponding data table, same SQL statement can be realized to Hash table
And corresponding data table carries out identical operation.
The SQL statement that will be executed to tables of data is contained in the update sentence queue of tables of data.
Result return module 60 is write for returning to processing result to the requesting party for sending write data requests.
If being successfully made data corresponding with write data requests to Hash table updates operation, result return module 60 is write
Can return to requesting party indicates to handle successful result information.If to Hash table carry out data corresponding with write data requests more
New operation encounters exception, then the result information for indicating processing failure can be returned to requesting party by writing result return module 60.
As shown in fig. 7, in one embodiment, the processing system of the data operation request of above-mentioned database further includes data
Table searching module 70 and tables of data read module 80；In the present embodiment:
Tables of data searching module 70, if for not finding the keyword for including in write data requests in Hash table,
The keyword for including in write data requests is searched in the tables of data for being stored in database.
Tables of data read module 80, if being read for finding the keyword for including in write data requests in tables of data
Take value corresponding with the keyword for including in write data requests in tables of data.
Hash table update module 30 is also used to the keyword that will include in write data requests and tables of data read module 80
In the corresponding value write-in Hash table read, and according to the key for including in update content modification write data requests in Hash table
The corresponding record of word.
If Hash table update module 30 is also used to not find the keyword for including in write data requests in tables of data,
According to more new content generate write data requests in include the corresponding value of keyword, by the keyword for including in write data requests with
And in the value write-in Hash table generated.
If there is no the keyword for including in write data requests in specified tables of data, it may be considered that the write data requests are new
Increase the request of record.Hash table update module 30 can be by the train value for including in more new content according to the data of respective column in Hash table
Type is formatted, further, can be using keyword and formatted train value as in a record write-in Hash table.
As shown in figure 8, in one embodiment, the processing system of the data operation request of above-mentioned database further includes log
File writing module 90, the first tables of data update module 100 and the second tables of data update module 110, in which:
Journal file writing module 90, for generate can be achieved to the SQL statement of the operation of Hash table after, by SQL
Sentence is written in journal file.
First tables of data update module 100, for modifying tables of data according to update sentence queue.
Second tables of data update module 110, for when update sentence queue in SQL statement be destroyed after, according to log
File modification tables of data.
First tables of data update module 100 is used to judge in the update sentence queue of specified tables of data whether there are also SQL languages
Sentence, if so, obtaining SQL statement from the queue heads of the update sentence queue of specified tables of data and deleting the SQL positioned at queue heads
Sentence executes the SQL statement obtained to specified tables of data, judges whether there are also SQL in the update sentence queue of specified tables of data
Sentence and according to judging result execute corresponding operating, if it is not, then terminate or be spaced preset duration judge again specify tables of data
Update sentence queue in whether there are also SQL statement.
In the present embodiment, the update with first in first out is placed into specified tables of data SQL statement to be executed
In sentence queue, relative to the update operation to Hash table, it can will be delayed to the update of specified tables of data operation, generally
First tables of data update module 100 can the data operation request of the database less period or in computer system it is more idle
Period, the update of tables of data is operated according to sentence queue centralized processing is updated, the processing with data operation request is avoided to strive
Take system resource by force, to avoid slowing down the response speed to data operation request.
In one embodiment, it updates sentence queue to be stored in memory, can accelerate to update sentence queuing data read-write
Speed, to accelerate the response speed to the data operation request of database.And failure is abnormal in computer and is crashed
Afterwards, the data in update sentence queue being stored in memory are likely to be broken, in the present embodiment, in this case, second
Tables of data update module 110 can then modify specified tables of data according to journal file, because being also written in journal file achievable
To the SQL statement of the operation of Hash table.Therefore, the present embodiment can also be according to day even if computer is abnormal failure and crashes
Will file modification specifies tables of data, it is ensured that the operation that should be executed to tables of data is accomplished, to guarantee to return to requesting party
Processing result accuracy.
Realize request module 10, Hash table searching module 20, Hash table update module 30, SQL statement generation module
40 and thread/process of result return module 60 is write, realize thread/process of the first tables of data update module 100 and realizes the
Thread/process of two tables of data update modules 110 can be different thread/process, thus reach operation to Hash table with it is right
The purpose that the operation of tables of data is independent of each other, to accelerate to the response speed of data operation request, also can reach computer not
To the mutual not shadow of the operation of tables of data to the operation of tables of data and in the case where computer is abnormal in the case where being abnormal
Loud purpose.
As shown in figure 9, in one embodiment, the processing system of the data operation request of above-mentioned database further includes increasing certainly
Sequence number generation module 120, for generating and being currently generated after generating and can be achieved to the SQL statement of the operation of Hash table
SQL statement from increasing row number.
SQL statement from increasing row number be can unique identification SQL statement sequence number, and the SQL statement first generated from
The SQL statement that increasing row number generates after being less than from increasing row number.
It can be made of from increasing row number timestamp and count number two parts, wherein timestamp is located at before sequence number；From increasing
Sequence number generation module 110 produces 0 sequence as initial from increasing row number, and 0 sequence may include one or more 0；From increasing
Sequence number generation module 110 generates the process from increasing row number for the SQL statement being currently generated can include:
Obtain current time in system stamp.The timestamp from increasing row number that the SQL statement being currently generated is arranged is equal to system
Current time stamp.Judge whether current time in system stamp is greater than the last timestamp from increasing row number generated, if so, setting
The count number from increasing row number for setting the SQL statement being currently generated is equal to 0, if it is not, oneself for the SQL statement being currently generated then is arranged
The count number of increasing row number is equal to the last count number from increasing row number generated and adds 1.By the above-mentioned timestamp and meter of setting
Several numbers according to preset format hand over word string, and by after conversion timestamp and count number be combined into the SQL statement being currently generated
From increasing row number.
In the present embodiment, queue writing module 50 be used for using SQL statement with it is corresponding from increasing row number as a data
Be inserted into the update sentence queue of specified tables of data, journal file writing module 90 be used for by SQL statement and it is corresponding from
Increasing row number correspondence is written in journal file.
In the present embodiment, the first tables of data update module 100 for being in judging the update sentence queue of specified tables of data
It is no there are also SQL statement, if so, from the queue heads of the update sentence queue of specified tables of data obtain SQL statement and it is corresponding from
Increasing row number, and delete and be located at the SQL statement of queue heads and corresponding from increasing row number；Acquisition is executed to specified tables of data
SQL statement, and it is corresponding from increasing row number, the further specified tables of data of judgement to record the SQL statement executed to specified tables of data
Update sentence queue in whether there are also SQL statement and according to judging result execute corresponding operation, if it is not, prompting is then arranged
Alarm clock, so that reminding alarm clock wakes up the realization thread or process of the first tables of data update module 100 after preset duration.
The processing system of the data operation request of above-mentioned database may also include serial number data table generation module (in figure not
Show), for generating a serial number data table in database, the serial number data table for record table name with from increasing row number
Corresponding relationship.Wherein, table name it is corresponding from increasing row number be newest execution in the table name corresponding tables of data SQL statement
From increasing row number.The table name that specified tables of data can be arranged in first tables of data update module 100 in the serial number data table is corresponding
From increasing row number be in specified tables of data the SQL statement of newest execution from increasing row number.
In the present embodiment, the second tables of data update module 110 is used to be destroyed when the SQL statement updated in sentence queue
Afterwards, it obtains to the SQL statement of the newest execution of specified tables of data from increasing row number, newest execution is searched in journal file
SQL statement from increasing row number, obtain that this is later from the corresponding SQL statement of increasing row number from increasing row number, to specified data
Table executes the SQL statement of above-mentioned acquisition.
In one embodiment, the second tables of data update module 110 can search specified number in above-mentioned serial number data table
It is corresponding from increasing row number according to the table name of table, it can be obtained to the SQL statement of the newest execution of specified tables of data from increasing row number.
The SQL statement of newest execution from the later SQL statement for being greater than newest execution from increasing row number of increasing row number
From increasing row number；The SQL statement of newest execution it is later from the corresponding SQL statement of increasing row number from increasing row number, for right
The SQL statement generated after the SQL statement of the specified newest execution of tables of data, these SQL statements are corresponding in specified tables of data
Hash table on execute, should also execute in specified tables of data, but not executed in specified tables of data also.
In one embodiment, request module 10 is also used to receive the read data request to specified tables of data, reading
According in request include keyword.
Hash table searching module 20 is also used to search reading in the corresponding Hash table for being stored in memory of specified tables of data
According to the keyword for including in request.
In the present embodiment, as shown in Figure 10, the processing system of the data operation request of above-mentioned database further includes Hash table
Read module 130 and reading result return module 140, in which:
Hash table read module 130, if for finding the keyword for including in read data request in Hash table,
The corresponding value of keyword for including in read data request is read in Hash table.
Result return module 140 is read, for being worth according to corresponding to the requesting party's returned data reading for sending read data request
Take result.
It in one embodiment, further include the column name of request reading in read data request.Result return module 140 is read, is used
The corresponding data of column name read are requested in the corresponding value of acquisition, and return to acquisition to the requesting party for sending read data request
The corresponding data of column name that keyword and request are read.
In one embodiment, if tables of data searching module 70 is also used to not find in read data request in Hash table
Including keyword, then in the tables of data for being stored in database search read data request in include keyword.
If tables of data read module 80 is also used to find the keyword for including in read data request in tables of data, read
Take value corresponding with the keyword for including in read data request in tables of data.
Hash table update module 30 is also used to the keyword that will include in read data request and corresponding value write-in Hash
In table.
Result return module 140 is read to be also used to be worth according to corresponding to the requesting party's return processing knot for sending read data request
Fruit.
The processing method and system of the data operation request of above-mentioned database write data to specified tables of data receiving
After request, the keyword for including in write data requests is searched in the specified corresponding Hash table for being stored in memory of tables of data, if
It finds, then the corresponding value of keyword is updated accordingly in Hash table, in order to guarantee the Hash table for being stored in memory
With the data consistency for the tables of data for being stored in database, the SQL statement that the operation to Hash table can be achieved is generated, by the SQL
Sentence is inserted into the update sentence queue of specified tables of data, subsequent identical with Hash table to the progress of specified tables of data to facilitate
Operation；The above method and system can carry out corresponding data more in the corresponding Hash table for being stored in memory of specified tables of data
It, can be to request after carrying out data update operation in the tables of data for being stored in database after new operation
Side returns to processing result, and updating the speed of operation due to carrying out data to the Hash table for being stored in memory is far longer than to being stored in
Therefore the speed that the tables of data of database carries out data update operation is greatly improved to the data operation request of database
Response speed.
The embodiments described above only express several embodiments of the present invention, and the description thereof is more specific and detailed, but simultaneously
Limitations on the scope of the patent of the present invention therefore cannot be interpreted as.It should be pointed out that for those of ordinary skill in the art
For, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to guarantor of the invention
Protect range.Therefore, the scope of protection of the patent of the invention shall be subject to the appended claims.
Claims (10)
1. a kind of processing method of the data operation request of database, comprising the following steps:
The write data requests to specified tables of data are received, include that keyword and keyword are corresponding more in write data request
New content；
The keyword for including in write data request is searched in the corresponding Hash table for being stored in memory of the tables of data；
If the keyword for including in write data request is found in the Hash table, according to institute in the Hash table
State the corresponding record of keyword for updating and including in the request of content modification write data；
The SQL statement that the operation to the Hash table can be achieved is generated, the SQL statement is inserted into the update of the tables of data
In sentence queue；
Processing result is returned to the requesting party that write data are requested is sent；
The method carries out data in the specified corresponding Hash table for being stored in memory of tables of data and updates the rear to request of operation
Side returns to processing result, updates after operation without carrying out the data in the specified tables of data for being stored in database just to asking
The side of asking returns to processing result.
2. the processing method of the data operation request of database according to claim 1, which is characterized in that the method is also
Include:
If the keyword for including in write data request is not found in the Hash table, in the institute for being stored in database
State the keyword searched in tables of data and include in write data request；
If found in the tables of data write data request in include keyword, read in the tables of data with institute
State the corresponding value of the keyword for including in write data requests, by write data request in include keyword and the correspondence
Value be written in the Hash table, and in the Hash table according to the updates content modification write data request in include
The corresponding record of keyword；
It is raw according to the more new content if not finding the keyword for including in write data request in the tables of data
At write data request in include the corresponding value of keyword, by write data request in the keyword that includes and described
The value of generation is written in the Hash table.
3. the processing method of the data operation request of database according to claim 1 or 2, which is characterized in that the side
Method further include:
After the generation can be achieved to the SQL statement of the operation of the Hash table, the SQL statement is written to log text
In part；
The tables of data is modified according to the update sentence queue；
After the SQL statement in the update sentence queue is destroyed, the tables of data is modified according to the journal file.
4. the processing method of the data operation request of database according to claim 1, which is characterized in that the method is also
Include:
The read data request to specified tables of data is received, includes keyword in the read data request；
The keyword for including in the read data request is searched in the corresponding Hash table for being stored in memory of the tables of data；
If finding the keyword for including in the read data request in the Hash table, institute is read in the Hash table
State the corresponding value of the keyword for including in read data request；
According to the corresponding requesting party's return processing result being worth to the transmission read data request.
5. the processing method of the data operation request of database according to claim 4, which is characterized in that the method is also
Include:
If not finding the keyword for including in the read data request in the Hash table, in the institute for being stored in database
State the keyword searched in tables of data and include in the read data request；
If finding the keyword for including in the read data request in the tables of data, read in the tables of data with institute
State the corresponding value of the keyword for including in read data request, by write data request in include keyword and the correspondence
Value be written in the Hash table, according to it is described it is corresponding be worth to the requesting party for sending the read data request return to processing knot
Fruit；
If not finding the keyword for including in the read data request in the tables of data, asked to the reading data are sent
The requesting party asked returns to the result for indicating to search failure.
6. a kind of processing system of the data operation request of database characterized by comprising
Request module includes keyword in write data request for receiving the write data requests to specified tables of data
And the corresponding more new content of keyword；
Hash table searching module is asked for searching write data in the corresponding Hash table for being stored in memory of the tables of data
The keyword for including in asking；
Hash table update module, if for finding the keyword for including in write data request in the Hash table,
According to the corresponding record of keyword for including in the update content modification write data request in the Hash table；
SQL statement generation module, for generating the SQL statement that the operation to the Hash table can be achieved；
Queue writing module, for being inserted into the SQL statement in the update sentence queue of the tables of data；
Result return module is write, for returning to processing result to the requesting party for sending write data request；
The system carries out data in the specified corresponding Hash table for being stored in memory of tables of data and updates the rear to request of operation
Side returns to processing result, updates after operation without carrying out the data in the specified tables of data for being stored in database just to asking
The side of asking returns to processing result.
7. the processing system of the data operation request of database according to claim 6, which is characterized in that the system is also
Include:
Tables of data searching module, if for not finding the keyword for including in write data request in the Hash table,
The keyword for including in write data request is then searched in the tables of data for being stored in database；
Tables of data read module, if for finding the keyword for including in write data request in the tables of data,
Read value corresponding with the keyword for including in write data request in the tables of data；
The Hash table update module be also used to request write data in include keyword and the corresponding value write
Enter in the Hash table, and according to the key for including in the update content modification write data request in the Hash table
The corresponding record of word；
If the Hash table update module is also used to not find the pass in write data request included in the tables of data
Key word then generates the corresponding value of keyword for including in write data request, by write data according to the more new content
The keyword for including in request and the value of the generation are written in the Hash table.
8. the processing system of the data operation request of database according to claim 6 or 7, which is characterized in that the system
System further include:
Journal file writing module, for it is described generate can be achieved to the SQL statement of the operation of the Hash table after, by institute
SQL statement is stated to be written in journal file；
First tables of data update module, for modifying the tables of data according to the update sentence queue；
Second tables of data update module, for when it is described update sentence queue in SQL statement be destroyed after, according to the log
Tables of data described in file modification.
9. the processing system of the data operation request of database according to claim 6, which is characterized in that the request obtains
Modulus block is also used to receive the read data request to specified tables of data, includes keyword in the read data request；
The Hash table searching module is also used to search the reading in the corresponding Hash table for being stored in memory of the tables of data
The keyword for including in request of data；
The system also includes:
Hash table read module, if for finding the keyword for including in the read data request in the Hash table,
Value corresponding with the keyword for including in the read data request is read in the Hash table；
Result return module is read, for according to the corresponding requesting party's returned data reading being worth to the transmission read data request
Take result.
10. the processing system of the data operation request of database according to claim 9, which is characterized in that the data
If table searching module is also used to not find the keyword for including in the read data request in the Hash table, storing
The keyword for including in the read data request is searched in the tables of data of database；
If the tables of data read module is also used to find the key for including in the read data request in the tables of data
Word then reads value corresponding with the keyword for including in the read data request in the tables of data；
The Hash table update module is also used to write the keyword for including in the read data request and the corresponding value
Enter in the Hash table；
The result return module of reading is also used to according to the corresponding requesting party's return being worth to the transmission read data request
Processing result.
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 CN105373541A (en) | 2016-03-02 |
| CN105373541B true 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) |
Families Citing this family (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107357794B (en) * | 2016-05-10 | 2020-06-05 | 北京京东尚科信息技术有限公司 | Method and device for optimizing data storage structure of key value database |
| CN105956166B (en) * | 2016-05-19 | 2020-02-07 | 北京京东尚科信息技术有限公司 | Database reading and writing method and device |
| CN106899654B (en) * | 2016-08-10 | 2020-02-07 | 阿里巴巴集团控股有限公司 | Sequence value generation method, device and system |
| CN106446272B (en) * | 2016-10-20 | 2019-07-09 | 北京百度网讯科技有限公司 | Method and apparatus for sending data |
| CN106682082B (en) * | 2016-11-23 | 2021-03-26 | 青岛海信移动通信技术股份有限公司 | Writing method and device for database |
| CN106815327A (en) * | 2016-12-29 | 2017-06-09 | 南京欣网互联信息技术有限公司 | One kind is for moving operation data resource regeneration method |
| CN106933657B (en) * | 2017-03-10 | 2020-12-04 | 中国银行股份有限公司 | Database deadlock processing method and device |
| 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 |
| 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 |
| CN111522827B (en) * | 2020-04-08 | 2023-09-05 | 北京奇艺世纪科技有限公司 | Data updating method and device and electronic equipment |
| CN111581212B (en) * | 2020-05-06 | 2024-05-17 | 深圳市朱墨科技有限公司 | Data storage method, system, server and storage medium of relational database |
Citations (6)
| 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 |
| CN102999522A (en) * | 2011-09-15 | 2013-03-27 | 阿里巴巴集团控股有限公司 | Data storage method and device |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102426611B (en) * | 2012-01-13 | 2013-09-04 | 广州从兴电子开发有限公司 | Database synchronization method and device thereof |
-
2014
- 2014-08-22 CN CN201410419664.1A patent/CN105373541B/en active Active
Patent Citations (6)
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105373541A (en) | 2016-03-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105373541B (en) | The processing method and system of the data operation request of database | |
| CN105630863B (en) | Transaction control block for multi-version concurrent commit status | |
| US20240078229A1 (en) | Generating, accessing, and displaying lineage metadata | |
| EP2874077B1 (en) | Stateless database cache | |
| WO2020073854A1 (en) | Memory data management method and system and method and system for data maintenance in memory | |
| US8938430B2 (en) | Intelligent data archiving | |
| US8655896B2 (en) | Apparatus and methods for organizing data items having time of life intervals | |
| WO2022057739A1 (en) | Partition-based data storage method, apparatus, and system | |
| CN109471851B (en) | Data processing method, device, server and storage medium | |
| US10089334B2 (en) | Grouping of database objects | |
| US10445370B2 (en) | Compound indexes for graph databases | |
| WO2021073241A1 (en) | Disk storage-based data reading method and device, and apparatus | |
| KR20140067277A (en) | Method for searching, inputting, deleting and garbage collecting of data in database having key-value structure | |
| CN113918535A (en) | Data reading method, device, equipment and storage medium | |
| US6763358B2 (en) | Method and system for activating column triggers in a database management system | |
| CN104794567B (en) | A kind of Infectious Diseases Data management method based on HBase | |
| CN107341198B (en) | Electric power mass data storage and query method based on theme instance | |
| CN110908992A (en) | Design method of block chain core storage algorithm based on big data platform | |
| CN101853278A (en) | Application method of data storage system | |
| CN110704468A (en) | Data updating method and device and controller | |
| CN114218277A (en) | Efficient query method and device for relational database | |
| CN111444194B (en) | Method, device and equipment for clearing indexes in block chain type account book | |
| CN111026764B (en) | Data storage method and device, electronic product and storage medium | |
| CN109063201B (en) | Impala online interactive query method based on mixed storage scheme | |
| CN106909665A (en) | A kind of patent retrieval method based on body |
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 |