CN103955486A - Distributed service system as well as data updating method and data query method thereof - Google Patents

Distributed service system as well as data updating method and data query method thereof Download PDF

Info

Publication number
CN103955486A
CN103955486A CN201410148256.7A CN201410148256A CN103955486A CN 103955486 A CN103955486 A CN 103955486A CN 201410148256 A CN201410148256 A CN 201410148256A CN 103955486 A CN103955486 A CN 103955486A
Authority
CN
China
Prior art keywords
data
buffer memory
indexing unit
database
labeled
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
Application number
CN201410148256.7A
Other languages
Chinese (zh)
Other versions
CN103955486B (en
Inventor
李晓鹏
宋宇鹏
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing 58 Information Technology Co Ltd
Original Assignee
Beijing 58 Information Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Beijing 58 Information Technology Co Ltd filed Critical Beijing 58 Information Technology Co Ltd
Priority to CN201710451567.4A priority Critical patent/CN107291869B/en
Priority to CN201410148256.7A priority patent/CN103955486B/en
Publication of CN103955486A publication Critical patent/CN103955486A/en
Application granted granted Critical
Publication of CN103955486B publication Critical patent/CN103955486B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • G06F16/2365Ensuring data consistency and integrity
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution
    • G06F16/24552Database cache management
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2471Distributed queries

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • General Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Computational Linguistics (AREA)
  • Computer Security & Cryptography (AREA)
  • Fuzzy Systems (AREA)
  • Mathematical Physics (AREA)
  • Probability & Statistics with Applications (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Information Transfer Between Computers (AREA)

Abstract

The invention provides a data updating method of a distributed service system. The system comprises a main database, a slave database and a cache. The method comprises the following steps of a, deleting data in the cache; b, placing a mark into a marking unit; c, updating data of the main database; d, deleting data in the cache again, and synchronizing the data in the main database to the slave database; e, deleting the mark. The invention also discloses a data query method of the distributed service system and the distributed service system. Consistency of data in the cache and data in the databases is ensured, and the risk of data inconsistency caused by high concurrency and main-slave synchronization delay is eliminated.

Description

The method of Distributed Services system and Data Update thereof, data query
Technical field
The present invention relates to computer network data renewal technology field, particularly a kind of method of Distributed Services system and Data Update and data query.
Background technology
In large-scale distributed web services, along with being on the increase of customer group, also more and more to the access of infosystem.Each inquiry request of user, infosystem all by searching accordingly in database, the operation such as data calculating, then result is returned.Inquiry amount increases, and the data processing amount of infosystem is linear increase thereupon also.In order to alleviate the access pressure of database server, research and develop database server Data cache technology.The effect of this caching technology is to store the often data of access of user temporarily, data in buffer memory are copies of data in data storage source, in the time that accessing the data of having carried out interim storage again, user just can directly return to this data, and without obtain again these data from database server, reduce thus the burden of database server.
Master-slave synchronisation pattern is a kind of common solution, and two on all four databases of storage content are set, and one of them is that one of master data base is from database.Allly write and upgrade operation and all in master data base, carry out, all query manipulations are all carrying out from database, and master data base writes or the content of upgrading rear variation is updated within a certain period of time from database.
At present, the data-updating method under this master-slave synchronisation pattern is, in the time data being upgraded to operation, first deletes buffer memory, then the master data base of database upgraded.Now, when carrying out data query first query caching of when operation, if there is value in buffer memory, directly return, and if void value in buffer memory; Query Database from database, and the value inquiring is put into buffer memory.
But, under such solution, may cause data in buffer memory and the inconsistent situation of data of database storage, the data in buffer memory are the situation of the legacy data before upgrading.
For example, in the time preparing to upgrade operation, the data in buffer memory are first deleted, then upgrade master data base.If there is one query operation before master data base has been upgraded, now according to the flow process of query manipulation, first can in buffer memory, search, but because data in buffer memory are deleted, so will be inquiring about from database.Suppose that the data of finding from database are the former data of A(), after poll-final, these data will be written into buffer memory, and buffer memory is written into A.To be now B(new data database update and upgrade operation).By inconsistent the data (A) in the data (B) and the buffer memory that occur in database, in buffer memory, preserve misdata so.If no longer upgraded, the data in buffer memory cannot be updated to B, and the data that later query manipulation obtains are all by the misdata A in buffer memory.
Again for example, complete and upgrade after operation, for example, while data A being updated to B in master data base, inquiry request occurs, and first query caching, now because the data in buffer memory are deleted in the time preparing to upgrade operation, in buffer memory, there is no data, thereby will inquire about from database.Because new data B is synchronized to from database and is existed and postpone by master data base, therefore, in the time that B is not also updated to from database, the data from database are still A, and the data that therefore inquire will be A, and A will be written in buffer memory then.So, even if be synchronized to B but the data that after this inquire all will, for inquire data A from buffer memory, cause erroneous results from the data of database afterwards.
Edge this, need a kind of new Distributed Services system and new Data Update, the method for data query, effectively avoid after database update, in buffer memory, still there is the legacy data before renewal.
Summary of the invention
The object of this invention is to provide method and a kind of Distributed Services system of a kind of Distributed Services system database renewal, data query, to keep the consistance of database and buffer memory.
According to an aspect of the present invention, a kind of method that provides Distributed Services system data to upgrade, described system comprises master data base, from database, buffer memory and indexing unit, described method comprises the steps: a) to delete the data in described buffer memory; B) in described indexing unit, put into mark; C) data of described master data base are upgraded; D) again delete the data in described buffer memory, and the data in described master data base are synchronized to described from database; E) delete described mark.
Preferably, putting into and being labeled as in described indexing unit described in step b, gives specific value to certain data bit in described indexing unit, and is labeled as described in deletion described in step e, and above-mentioned data bit is resetted.
Preferably, putting into and being labeled as in described indexing unit described in step b deposits data in described indexing unit, and is labeled as described in deletion described in step e, deletes the described data that deposit in described indexing unit.
Preferably, in step b, described in put into be labeled as and create a file, and in step e, delete the mode of described mark for deleting described file.
Preferably, described indexing unit is arranged in described buffer memory.
According to a further aspect in the invention, a kind of method of Distributed Services system data inquiry is provided, system comprises master data base, from database, buffer memory and indexing unit, when wherein the data of described master data base renewals, in described indexing unit, deposit mark, be synchronized to describedly from database in the data of described master data base, described mark is deleted, and described method comprises the steps:
A) judging in described buffer memory whether have data, is to enter step f; Otherwise enter step b;
B) judging in described indexing unit whether have described mark, is to enter step c; Otherwise enter steps d;
C) data query in described master data base, then enters step e;
D) described from database data query;
E) data that inquire are write to described buffer memory;
F) data in described buffer memory are returned as Query Result.
Preferably, described in, be labeled as particular value that certain data bit of described indexing unit is endowed or for depositing the data of described indexing unit or the file creating in.
According to a further aspect in the invention, provide a kind of Distributed Services system, described system comprises: master data base, for storing data, support the query manipulation to it; From database, for storing data, and according to its data of storing of the Data Update of described master data base, described from database support the query manipulation to it; Buffer memory, for storing data, supports query manipulation and write operation to it, and described buffer memory comprises indexing unit, wherein,
When the data of described master data base are upgraded, the data in described buffer memory are deleted first, and after the data of described master data base are upgraded, the data in described buffer memory are again deleted; And
Indexing unit, deleted first for the data at described buffer memory after, deposit described mark, and be synchronized to describedly from database when the data in described master data base, described mark is deleted.
Preferably, in the time of the data of inquiry in described Distributed Services system, first inquire about described buffer memory, if having data in described buffer memory, the data in described buffer memory are returned as Query Result; If described buffer memory does not have data, judge and in described indexing unit, whether have described mark, be described master data base to be carried out to data query, otherwise carry out data query to described from database, described master data base or described result from data base querying are write described buffer memory.
Preferably, be labeled as the particular value that in described indexing unit, certain data bit is given described in described indexing unit, and, be labeled as described in deletion, above-mentioned data bit is resetted.
Preferably, be labeled as the data that deposit described indexing unit in described in described indexing unit, and, be labeled as the data that deposit described indexing unit described in deletion in described in deletion.
Preferably, be labeled as a file of establishment described in described indexing unit, and, be labeled as the file of deleting described establishment described in deletion.
Preferably, described indexing unit is arranged in described buffer memory.
According to the method for Distributed Services of the present invention and Data Update thereof, data query, can effectively avoid in buffer memory, still having the legacy data before renewal after database update.Data Update of the present invention and data enquire method are specially adapted under the Distributed Services concurrent at height and master-slave database environment, ensure data in buffer memory and the data consistent of database, eliminated because height is concurrent and master-slave synchronisation postpones the inconsistent risk of data of bringing.
Brief description of the drawings
With reference to the accompanying drawing of enclosing, the more object of the present invention, function and advantage are illustrated the following description by embodiment of the present invention, wherein:
Fig. 1 a has schematically shown the structured flowchart of Distributed Services system according to an embodiment of the invention.
Fig. 1 b has schematically shown the structured flowchart of Distributed Services system according to another embodiment of the present invention.
Fig. 2 has schematically shown the process flow diagram of Distributed Services system data update method according to an embodiment of the invention.
Fig. 3 has schematically shown the process flow diagram of Distributed Services system data querying method according to an embodiment of the invention.
Embodiment
By reference to example embodiment, object of the present invention and function and will be illustrated for the method that realizes these objects and function.But the present invention is not limited to following disclosed example embodiment; Can be realized it by multi-form.The essence of instructions is only to help various equivalent modifications Integrated Understanding detail of the present invention.
Hereinafter, embodiments of the invention will be described with reference to the drawings.In the accompanying drawings, identical Reference numeral represents same or similar parts, or same or similar step.
Fig. 1 a has schematically shown the structured flowchart of Distributed Services system according to an embodiment of the invention.As shown in Figure 1a, applying Distributed Services system according to an embodiment of the invention comprises: master data base 110, from database 120, buffer memory 130 and indexing unit 131.Fig. 1 b has schematically shown the structured flowchart of Distributed Services system according to another embodiment of the present invention.Wherein indexing unit 131 is positioned at buffer memory 130.
In the time of system update data, first the data in master data base 110 are upgraded, and according in master data base 110 upgrade after data to upgrading synchronously from database 120.Especially, support the query manipulation to master data base 110, for example, the in the situation that of there is mark in buffer memory 130.About mark, will be described hereinafter.
From database 120, for receiving the synchronously new data more of autonomous database 110, and for example support, to the inquiry (while not finding data to be checked buffer memory 130) from database 120, and after inquiry, Query Result is write in buffer memory 130.
Buffer memory 130, supports query manipulation and write operation to it.Wherein, the data in buffer memory 130, deleted first in the time that master data base 110 is carried out to database update, are carried out after Data Update in master data base, again deleted.
Indexing unit 131 for Mk system in Data Update state.In the time that system is carried out Data Update, after the data of deleting first in described buffer memory 130, in indexing unit 131, put into mark, and be synchronized to described from database, by described tag delete when the data in described master data base.As shown in Fig. 1 a and Fig. 1 b difference, indexing unit 131 can be arranged at outside buffer memory 130 or be positioned at buffer memory 130.
Preferably, in indexing unit 131, put into be labeled as and give particular value to indexing unit 131 certain data bit, and, be labeled as described in deletion above-mentioned data bit is resetted.
Preferably, in indexing unit 131, put into be labeled as at indexing unit 131 and deposit data in, such as but not limited to depositing the data that can play mark function in, and, be labeled as the data that deposit in described in deletion described in deletion.
Preferably, in indexing unit 131, put into be labeled as at indexing unit 131 and create a file, and be labeled as the file that deletion creates described in deleting.
In the time that buffer memory 130 is carried out to query manipulation, if there is Query Result in buffer memory 130, directly return to this Query Result; If there is no Query Result, judge in the indexing unit 131 of buffer memory 130 and whether have mark, to carry out data query in master data base 110, otherwise carrying out the inquiry of data from database 120, after having inquired about, in the future autonomous database 110 or write buffer memory 130 from the Query Result of database 120, and return to this Query Result.
Fig. 2 has schematically shown the method flow diagram that Distributed Services system data upgrades according to an embodiment of the invention.
As shown in Figure 2:
Step 210, in the time that Distributed Services system is carried out Data Update, first, deletes the data in buffer memory 130.According in the master-slave database framework of Distributed Services of the present invention, in the time that needs upgrade database, directly the data in master data base 110 are upgraded.
Step 220 is put into mark in indexing unit 131.Wherein, putting into mark be for example in described indexing unit, give specific value to certain data bit in described indexing unit 131, for example, is 1 by certain data bit assignment in indexing unit 131.In described indexing unit 131, putting into mark is for example again, in indexing unit 131, deposits data in, preferably, deposits the data that can play mark function in, for example, deposit a segment length and the complicated value that can play mark feature in.The described mark of putting into is also for example for creating a file.
Step 230, upgrades the data of master data base 110.
Step 240, is synchronized to the data in master data base 110 from database 120.According to the present invention, as long as master data base 110 has the transactions requests of upgrading operation and upgrade to submit to, will carry out synchronous operation.
Step 250, deletes the data in buffer memory 130.Especially, the mark in the unit of not delete flag here 131.The object of deleting the data in buffer memory 130 is, deletes the legacy data of depositing buffer memory 130 before to this step after step 210.This legacy data specifically comprises: after step 210 to before step 220 by the legacy data that writes buffer memory 130 from database 120.
In the present embodiment, although first carry out step 240, and then carry out step 250, the order of step is not limited to this.For example also can first carry out step 250 and then carry out step 240., step 240 and step 250 are as long as after step 230, before step 260.
Step 260, is arranged on the mark in indexing unit 131 in delete step 220.Especially, master data base 110 is synchronized to and from the operation of database 120, carries out the deletion to mark completing.The mode of delete flag here, for example, reset the data bit that is endowed particular value in step 220 in indexing unit 131, for example, 1 the data bit of being assigned of the indexing unit in step 220 131 is resetted.Delete flag is for example again that the data that deposit in the step 220 in delete flag unit 131, preferably for playing the data of mark function, for example, delete described length and the complicated value that can play mark feature.Also for example, the file creating in delete step 220.
Fig. 3 has schematically shown after master-slave database is upgraded as shown in Figure 2 for example, carries out the process flow diagram of the method for data base querying.
As shown in Figure 3:
Step 310, in the time that needs carry out query manipulation to database, first, query caching 130, judges in buffer memory 130 whether have data to be checked, is to enter step 360 directly to return to Query Result; Otherwise enter step 320.
Whether step 320, there is mark in judge mark unit 131, be to enter step 330; Otherwise enter step 340.Describedly be labeled as the above-mentioned mark of putting in the time that master data base 110 is carried out to Data Update in indexing unit 131.
Step 330, data query in master data base 110, then enters step 350.When judging while there is mark in indexing unit 131, illustrative system is carrying out, in the process of the Data Update operation to master data base 110, now needing the master data base 110 that direct inquiry is being updated just can obtain up-to-date and correct data result.
Step 340, at data query from database 120.When judging while there is not mark in indexing unit 131, illustrative system is not carrying out the Data Update operation to master data base 110.After database update operation each time, capital is synchronized to the data of the master data base 110 after upgrading from database 120, therefore in the time there is not mark in indexing unit 131, master data base 110 is described now and is synchronous from database 120, now only need inquiry can obtain up-to-date and correct data result from database 120.
Step 350, writes described buffer memory 130 by the data that inquire.Write operation can ensure data and master data base and the data consistent from database in buffer memory, thereby in the data base querying after having ensured, in the time there are data in buffer memory, only needs query caching can obtain correct and up-to-date data result.
Step 360, returns to the data in described buffer memory as Query Result.
According to the method and system that in Distributed Services of the present invention, master-slave database is carried out database update, can effectively avoid still having the possibility of the legacy data before renewal in the buffer memory completing after database update.Database update of the present invention and querying method are specially adapted under the Distributed Services concurrent at height and master-slave database environment, ensure data in buffer memory and the data consistent of database, eliminated because height is concurrent and master-slave synchronisation postpones the inconsistent risk of data of bringing.
In conjunction with the explanation of the present invention and the practice that disclose here, other embodiment of the present invention are easy to expect and understand for those skilled in the art.Illustrate with embodiment and be only considered to exemplary, true scope of the present invention and purport limit by claim.

Claims (14)

1. the method that Distributed Services system data upgrades, is characterized in that, described system comprises master data base, from database, buffer memory and indexing unit, and described method comprises the steps:
A) delete the data in described buffer memory;
B) in described indexing unit, put into mark;
C) data of described master data base are upgraded;
D) again delete the data in described buffer memory, and the data in described master data base are synchronized to described from database;
E) delete described mark.
2. method according to claim 1, it is characterized in that, putting into and being labeled as in described indexing unit described in step b, gives specific value to certain data bit in described indexing unit, and described in the deletion described in step e, be labeled as, above-mentioned data bit is resetted.
3. method according to claim 1, it is characterized in that, putting into and being labeled as in described indexing unit described in step b deposits data in described indexing unit, and described in the deletion described in step e, be labeled as, delete the described data that deposit in described indexing unit.
4. method according to claim 1, is characterized in that, in step b, described in put into be labeled as and create a file, and in step e, delete the mode of described mark for deleting described file.
5. method according to claim 1, is characterized in that, described indexing unit is arranged in described buffer memory.
6. the method for a Distributed Services system data inquiry, it is characterized in that, described system comprises master data base, from database, buffer memory and indexing unit, when wherein the data of described master data base renewals, in described indexing unit, deposit mark, be synchronized to describedly from database in the data of described master data base, described mark is deleted, and described method comprises the steps:
A) judging in described buffer memory whether have data, is to enter step f; Otherwise enter step b;
B) judging in described indexing unit whether have described mark, is to enter step c; Otherwise enter steps d;
C) data query in described master data base, then enters step e;
D) described from database data query;
E) data that inquire are write to described buffer memory;
F) data in described buffer memory are returned as Query Result.
7. method according to claim 6, is characterized in that, described in be labeled as particular value that certain data bit of described indexing unit is endowed or for depositing the data of described indexing unit or the file creating in.
8. method according to claim 6, is characterized in that, described indexing unit is arranged in described buffer memory.
9. a Distributed Services system, is characterized in that, described system comprises:
Master data base, for storing data, supports the query manipulation to it;
From database, for storing data, and according to its data of storing of the Data Update of described master data base, described from database support the query manipulation to it;
Buffer memory, for storing data, supports query manipulation and write operation to it, wherein, when the data of described master data base are upgraded, the data in described buffer memory are deleted first, after the data of described master data base are upgraded, the data in described buffer memory are again deleted; And
Indexing unit, deleted first for the data at described buffer memory after, deposit described mark, and be synchronized to describedly from database when the data in described master data base, described mark is deleted.
10. system according to claim 9, is characterized in that, in the time of the data of inquiry in described Distributed Services system, first inquires about described buffer memory, if having data in described buffer memory, the data in described buffer memory are returned as Query Result; If described buffer memory does not have data, judge and in described indexing unit, whether have described mark, be described master data base to be carried out to data query, otherwise carry out data query to described from database, described master data base or described result from data base querying are write described buffer memory.
11. systems according to claim 9, is characterized in that, are labeled as the particular value that in described indexing unit, certain data bit is given described in described indexing unit, and, be labeled as described in deletion, above-mentioned data bit is resetted.
12. systems according to claim 9, is characterized in that, are labeled as the data that deposit described indexing unit in described in described indexing unit, and, be labeled as the data that deposit described indexing unit described in deletion in described in deletion.
13. systems according to claim 9, is characterized in that, are labeled as a file of establishment described in described indexing unit, and, be labeled as the file of deleting described establishment described in deletion.
14. systems according to claim 9, is characterized in that, described indexing unit is arranged in described buffer memory.
CN201410148256.7A 2014-04-14 2014-04-14 Distribution service and its data update, the method for data query Active CN103955486B (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
CN201710451567.4A CN107291869B (en) 2014-04-14 2014-04-14 Distributed service system and data query method thereof
CN201410148256.7A CN103955486B (en) 2014-04-14 2014-04-14 Distribution service and its data update, the method for data query

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201410148256.7A CN103955486B (en) 2014-04-14 2014-04-14 Distribution service and its data update, the method for data query

Related Child Applications (1)

Application Number Title Priority Date Filing Date
CN201710451567.4A Division CN107291869B (en) 2014-04-14 2014-04-14 Distributed service system and data query method thereof

Publications (2)

Publication Number Publication Date
CN103955486A true CN103955486A (en) 2014-07-30
CN103955486B CN103955486B (en) 2017-08-01

Family

ID=51332761

Family Applications (2)

Application Number Title Priority Date Filing Date
CN201710451567.4A Active CN107291869B (en) 2014-04-14 2014-04-14 Distributed service system and data query method thereof
CN201410148256.7A Active CN103955486B (en) 2014-04-14 2014-04-14 Distribution service and its data update, the method for data query

Family Applications Before (1)

Application Number Title Priority Date Filing Date
CN201710451567.4A Active CN107291869B (en) 2014-04-14 2014-04-14 Distributed service system and data query method thereof

Country Status (1)

Country Link
CN (2) CN107291869B (en)

Cited By (18)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104346468A (en) * 2014-11-14 2015-02-11 浪潮(北京)电子信息产业有限公司 Method and device for realizing concurrent I/O (Input/Output) in database system
CN104881444A (en) * 2015-05-14 2015-09-02 微梦创科网络科技(中国)有限公司 Method and system for updating caching server in website
CN105260475A (en) * 2015-10-30 2016-01-20 努比亚技术有限公司 Data searching method, data saving method and related equipment
CN105608229A (en) * 2016-01-29 2016-05-25 锐达互动科技股份有限公司 System and method for synchronizing master-slave databases
CN106202387A (en) * 2016-07-08 2016-12-07 陈光宇 A kind of data consistency concurrent maintenance method
CN106407351A (en) * 2016-09-05 2017-02-15 乐视控股(北京)有限公司 Data processing method and device applied to database
CN106897303A (en) * 2015-12-18 2017-06-27 北京国双科技有限公司 Data query method and device
CN107566434A (en) * 2016-07-01 2018-01-09 北京京东尚科信息技术有限公司 Data cached reading/writing method and system in a kind of distributed system
CN107832401A (en) * 2017-11-01 2018-03-23 郑州云海信息技术有限公司 Database data access method, system, device and computer-readable recording medium
CN108509450A (en) * 2017-02-27 2018-09-07 北京京东尚科信息技术有限公司 For handling the newer method and apparatus of database high concurrent
CN108897495A (en) * 2018-06-28 2018-11-27 北京五八信息技术有限公司 Buffering updating method, device, buffer memory device and storage medium
CN109358805A (en) * 2018-09-03 2019-02-19 中新网络信息安全股份有限公司 A kind of data cache method
CN109992695A (en) * 2019-04-10 2019-07-09 北京奇艺世纪科技有限公司 A kind of video information querying method and device
CN110019340A (en) * 2017-12-08 2019-07-16 北京新媒传信科技有限公司 Data storage/read method, apparatus and system
CN110427386A (en) * 2019-08-05 2019-11-08 广州华多网络科技有限公司 Data processing method, device and computer storage medium
WO2020168878A1 (en) * 2019-02-19 2020-08-27 北京字节跳动网络技术有限公司 Data caching method and device, terminal, and storage medium
CN112364061A (en) * 2020-11-18 2021-02-12 浪潮云信息技术股份公司 Mysql-based high-concurrency database access method
CN113094430A (en) * 2021-03-25 2021-07-09 北京达佳互联信息技术有限公司 Data processing method, device, equipment and storage medium

Families Citing this family (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109710688B (en) * 2018-11-26 2021-10-08 福建天泉教育科技有限公司 Data real-time comparison and verification method and message middleware
CN109871388A (en) * 2019-02-19 2019-06-11 北京字节跳动网络技术有限公司 Data cache method, device, whole electronic equipment and storage medium
CN111177197B (en) * 2019-12-26 2023-03-14 北京仁科互动网络技术有限公司 Cache processing method and system
CN113760860B (en) * 2020-11-12 2023-09-22 北京京东振世信息技术有限公司 Data reading method and device
CN113360571A (en) * 2021-06-03 2021-09-07 广东电网有限责任公司 Characteristic mark-based power grid monitoring system memory database relation database synchronization method
CN113704267A (en) * 2021-08-31 2021-11-26 平安普惠企业管理有限公司 Data query method, system, equipment and storage medium based on elastic search

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5737536A (en) * 1993-02-19 1998-04-07 Borland International, Inc. System and methods for optimized access in a multi-user environment
CN101000619A (en) * 2006-12-25 2007-07-18 华为技术有限公司 Data synchronous method and device based on SQL
CN103345502A (en) * 2013-07-01 2013-10-09 曙光信息产业(北京)有限公司 Transaction processing method and system of distributed type database

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101576921A (en) * 2009-06-15 2009-11-11 用友软件股份有限公司 Data query system and data query engine device
CN102081625B (en) * 2009-11-30 2012-12-26 中国移动通信集团北京有限公司 Data query method and query server
CN102508854A (en) * 2011-09-29 2012-06-20 畅捷通信息技术股份有限公司 Data access device and method
CN102521405B (en) * 2011-12-26 2014-06-25 中国科学院计算技术研究所 Massive structured data storage and query methods and systems supporting high-speed loading
CN102521406B (en) * 2011-12-26 2014-06-25 中国科学院计算技术研究所 Distributed query method and system for complex task of querying massive structured data

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5737536A (en) * 1993-02-19 1998-04-07 Borland International, Inc. System and methods for optimized access in a multi-user environment
CN101000619A (en) * 2006-12-25 2007-07-18 华为技术有限公司 Data synchronous method and device based on SQL
CN103345502A (en) * 2013-07-01 2013-10-09 曙光信息产业(北京)有限公司 Transaction processing method and system of distributed type database

Cited By (30)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104346468A (en) * 2014-11-14 2015-02-11 浪潮(北京)电子信息产业有限公司 Method and device for realizing concurrent I/O (Input/Output) in database system
CN104881444B (en) * 2015-05-14 2018-08-14 微梦创科网络科技(中国)有限公司 The method and system of cache server are updated in website
CN104881444A (en) * 2015-05-14 2015-09-02 微梦创科网络科技(中国)有限公司 Method and system for updating caching server in website
CN105260475A (en) * 2015-10-30 2016-01-20 努比亚技术有限公司 Data searching method, data saving method and related equipment
CN105260475B (en) * 2015-10-30 2019-08-16 努比亚技术有限公司 A kind of data search method, date storage method and related device
CN106897303A (en) * 2015-12-18 2017-06-27 北京国双科技有限公司 Data query method and device
CN106897303B (en) * 2015-12-18 2020-09-15 北京国双科技有限公司 Data query method and device
CN105608229A (en) * 2016-01-29 2016-05-25 锐达互动科技股份有限公司 System and method for synchronizing master-slave databases
CN107566434A (en) * 2016-07-01 2018-01-09 北京京东尚科信息技术有限公司 Data cached reading/writing method and system in a kind of distributed system
CN107566434B (en) * 2016-07-01 2022-01-07 北京京东尚科信息技术有限公司 Cache data reading and writing method and system, electronic equipment and computer readable medium
CN106202387B (en) * 2016-07-08 2019-05-21 苏州超块链信息科技有限公司 A kind of data consistency concurrent maintenance method
CN106202387A (en) * 2016-07-08 2016-12-07 陈光宇 A kind of data consistency concurrent maintenance method
CN106407351A (en) * 2016-09-05 2017-02-15 乐视控股(北京)有限公司 Data processing method and device applied to database
CN108509450A (en) * 2017-02-27 2018-09-07 北京京东尚科信息技术有限公司 For handling the newer method and apparatus of database high concurrent
CN108509450B (en) * 2017-02-27 2022-04-12 北京京东尚科信息技术有限公司 Method and device for processing high-concurrency update of database
CN107832401A (en) * 2017-11-01 2018-03-23 郑州云海信息技术有限公司 Database data access method, system, device and computer-readable recording medium
CN107832401B (en) * 2017-11-01 2021-07-16 郑州云海信息技术有限公司 Database data access method, system, device and computer readable storage medium
CN110019340A (en) * 2017-12-08 2019-07-16 北京新媒传信科技有限公司 Data storage/read method, apparatus and system
CN108897495A (en) * 2018-06-28 2018-11-27 北京五八信息技术有限公司 Buffering updating method, device, buffer memory device and storage medium
CN108897495B (en) * 2018-06-28 2023-10-03 北京五八信息技术有限公司 Cache updating method, device, cache equipment and storage medium
CN109358805A (en) * 2018-09-03 2019-02-19 中新网络信息安全股份有限公司 A kind of data cache method
CN109358805B (en) * 2018-09-03 2021-11-30 中新网络信息安全股份有限公司 Data caching method
WO2020168878A1 (en) * 2019-02-19 2020-08-27 北京字节跳动网络技术有限公司 Data caching method and device, terminal, and storage medium
CN109992695A (en) * 2019-04-10 2019-07-09 北京奇艺世纪科技有限公司 A kind of video information querying method and device
CN109992695B (en) * 2019-04-10 2021-08-27 北京奇艺世纪科技有限公司 Video information query method and device
CN110427386B (en) * 2019-08-05 2023-09-19 广州方硅信息技术有限公司 Data processing method, device and computer storage medium
CN110427386A (en) * 2019-08-05 2019-11-08 广州华多网络科技有限公司 Data processing method, device and computer storage medium
CN112364061A (en) * 2020-11-18 2021-02-12 浪潮云信息技术股份公司 Mysql-based high-concurrency database access method
CN113094430A (en) * 2021-03-25 2021-07-09 北京达佳互联信息技术有限公司 Data processing method, device, equipment and storage medium
CN113094430B (en) * 2021-03-25 2023-10-03 北京达佳互联信息技术有限公司 Data processing method, device, equipment and storage medium

Also Published As

Publication number Publication date
CN107291869A (en) 2017-10-24
CN103955486B (en) 2017-08-01
CN107291869B (en) 2020-04-24

Similar Documents

Publication Publication Date Title
CN103955486A (en) Distributed service system as well as data updating method and data query method thereof
US9251163B2 (en) File sharing system and file sharing method
EP3117349B1 (en) System and method for massively parallel processing database
US9244914B2 (en) Schema versioning for cloud hosted databases
KR102579190B1 (en) Backup and restore in distributed databases using consistent database snapshots
EP3079078B1 (en) Multi-version concurrency control method in database, and database system
JP4414381B2 (en) File management program, file management apparatus, and file management method
US8200624B2 (en) Membership tracking and data eviction in mobile middleware scenarios
EP3519986B1 (en) Direct table association in in-memory databases
US9515878B2 (en) Method, medium, and system for configuring a new node in a distributed memory network
US9171027B2 (en) Managing a multi-version database
CN107590207B (en) Data synchronization method and device and electronic equipment
US20130254240A1 (en) Method of processing database, database processing apparatus, computer program product
CN104021145A (en) Mixed service concurrent access method and device
US20120284244A1 (en) Transaction processing device, transaction processing method and transaction processing program
US20170075775A1 (en) System and Method for Time Parameter Based Database Restoration
WO2011070910A1 (en) Data arrangement/calculation system, data arrangement/calculation method, master device, and data arrangement method
US8600962B2 (en) Transaction processing device, transaction processing method, and transaction processing program
CN104065752A (en) Synchronization method of data between terminals
CN114185991A (en) Method and related device for realizing data synchronization based on distributed database
US8892535B2 (en) Database management method
US20160170869A9 (en) Systems and methods for in-place reorganization of device storage
KR20150097973A (en) Tile image update system for map service and method thereof
CN105550342A (en) Data processing method of completely-transparent distributed database
CN114579559A (en) Data synchronization method and device, computer equipment and storage medium

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