CN107291869A - A kind of method of distribution service data query - Google Patents
A kind of method of distribution service data query Download PDFInfo
- Publication number
- CN107291869A CN107291869A CN201710451567.4A CN201710451567A CN107291869A CN 107291869 A CN107291869 A CN 107291869A CN 201710451567 A CN201710451567 A CN 201710451567A CN 107291869 A CN107291869 A CN 107291869A
- Authority
- CN
- China
- Prior art keywords
- data
- caching
- database
- mark
- indexing unit
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24552—Database cache management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2471—Distributed 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 present invention provides a kind of method of distribution service data query, the system includes primary database, from database, caching and indexing unit, when being wherein updated to the data of primary database, storage has mark in indexing unit, primary database data syn-chronization to after database, mark is deleted, and methods described comprises the following steps：A) judge to whether there is data in the caching, be then to enter step f；Otherwise step b is entered；B) judge to whether there is the mark in the indexing unit, be then to enter step c；Otherwise step d is entered；C) data are inquired about in the primary database, subsequently into step e；D) data are inquired about from database described；E) data inquired are write into the caching；F) data in the caching are returned as Query Result.This invention ensures that the data in caching are consistent with the data of database, eliminate because of the inconsistent risk of data that high concurrent and master-slave synchronisation delay are brought.
Description
It is on 04 14th, 2014 the applying date that the application, which is, Application No. CN201410148256.7, entitled point
Cloth service system and its data update, the divisional application of the method for data query.
Technical field
The present invention relates to computer network data update method field, particularly a kind of distribution service data query
Method.
Background technology
In large-scale distributed web services, with being on the increase for customer group, to the access of information system also increasingly
It is many.Each inquiry request of user, information system all by being searched accordingly in database, data calculate etc. operation,
Then result is returned.Queries increase, the data processing amount of information system is also linearly increasing therewith.In order to mitigate database clothes
The access pressure of business device, have developed database server Data cache technology.The effect of the caching technology is interim storage user
Data in the data often accessed, caching are the copies of data in data storage source, are had been carried out when user accesses again
Just the data can be directly returned to during the data of interim storage, without obtaining the data from database server again, thus
Reduce the burden of database server.
Master-slave synchronisation pattern is a kind of common solution, that is, sets the completely the same database of two storage contents,
One of them is that primary database one is from database.All write-in and renewal operations are carried out all in primary database, Suo Youcha
Ask operation all carrying out from database, the content that primary database occurs write-in or after updating changed is updated within a certain period of time
To from database.
At present, the data-updating method under this master-slave synchronisation pattern is, when being updated operation to data first
Caching is deleted, then the primary database to database is updated.Now, inquire about slow first when carrying out data query operation
Deposit, directly returned if having value in caching, inquired about in caching if void value database from database, and will inquire
Value be put into caching.
However, under such solution, the data that may result in the data in caching and database purchase differ
The situation of cause, that is, the data in caching are the situation of the legacy data before updating.For example, when preparing to update operation, in caching
Data are deleted first, then update primary database.If being updated in primary database and completing preceding generation one query operation, now press
According to the flow of inquiry operation, can be searched in the buffer first, but due in caching data it is deleted, so will be
Inquired about from database.It is assumed that the data found from database are A (former data), this data will be written into after poll-final
Caching, i.e. caching are written into A.And it is now B (new data) database update to update operation.To so occur in database
Data (B) with caching in data (A) it is inconsistent, that is, cache in save wrong data.If no longer updated, caching
In data will be unable to be updated to data obtained by B, later inquiry operation all by for the wrong data A in caching.
In another example, after primary database completes to update operation, such as when data A being updated into B, occur inquiry request,
Will query caching first, now because the data in caching are deleted when preparing to update operation, there is no data in caching, because
And will inquire about from database.Postpone because new data B is synchronized to exist from database by primary database, therefore do not updated also in B
To from database when, remain as A from the data in database, therefore the data inquired will be A, then A will be written into caching
In.Even if in this way, the data for being synchronized to B from the data of database afterwards but hereafter inquiring all will be to be inquired from caching
Data A, causes result mistake.
Edge this, it is necessary to a kind of new distribution service and new data update, the method for data query, come effective
Ground avoids the legacy data for still having before updating in being cached after database update.
The content of the invention
It is an object of the invention to provide a kind of method of distribution service data query, the system includes master data
Storehouse, from database, caching and indexing unit, wherein when being updated to the data of the primary database, in the indexing unit
Storage have mark, the primary database data syn-chronization to described after database, it is described mark be deleted, methods described bag
Include following steps：
A) judge to whether there is data in the caching, be then to enter step f；Otherwise step b is entered；
B) judge to whether there is the mark in the indexing unit, be then to enter step c；Otherwise step d is entered；
C) data are inquired about in the primary database, subsequently into step e；
D) data are inquired about from database described；
E) data inquired are write into the caching；
F) data in the caching are returned as Query Result.
Preferably, the mark is the particular value that is endowed of some data bit of indexing unit or is deposit institute
State the data of indexing unit or be create file.
Preferably, the indexing unit is located in the caching.
Preferably, the system includes：
Primary database, for data storage, is supported to its inquiry operation；
From database, its data stored, institute are updated for data storage, and according to the data of the primary database
State and supported from database to its inquiry operation；
Caching, for data storage, supports the inquiry operation to it and write operation, wherein, to the primary database
Data when being updated, the data in the caching are deleted first, described after the data of the primary database are updated
Data in caching are deleted again；And
Indexing unit, after being deleted first for the data in the caching, deposits the mark, and when the main number
According to the data syn-chronization in storehouse to described after database, the mark is deleted；
When inquiring about the data in the distribution service, the caching is inquired about first, if having in the caching
Data, then the data in the caching returned as Query Result；If the caching does not have data, judge that the mark is single
It whether there is the mark in member, be then, to primary database progress data query, otherwise from database to enter line number to described
It is investigated that asking, in writing the caching to the primary database or the result from data base querying.
Preferably, the mark in the indexing unit be the indexing unit in some data bit assign it is specific
Value, also, delete the mark to reset above-mentioned data bit.
Preferably, the mark in the indexing unit is the data of the indexing unit, also, deletes described
Labeled as the data for deleting the deposit indexing unit.
Preferably, the file that the mark in the indexing unit is, also, delete it is described mark be
Except the file of the establishment.
Preferably, the indexing unit is located in the caching.
A kind of method of distribution service data query of the present invention, can be effectively prevented from caching after database update
In still have update before legacy data.The data of the present invention update the distribution being particularly suitable for use in data query method in high concurrent
Under formula service and master-slave database environment, it is ensured that the data in caching are consistent with the data of database, eliminate because of high concurrent
The inconsistent risk of data brought with master-slave synchronisation delay.
Brief description of the drawings
With reference to the accompanying drawing enclosed, the present invention more purpose, function and advantages will pass through the as follows of embodiment of the present invention
Description is illustrated, wherein：
Fig. 1 a diagrammatically illustrate the structured flowchart of distribution service according to an embodiment of the invention.
Fig. 1 b diagrammatically illustrate the structured flowchart of distribution service according to another embodiment of the present invention.
Fig. 2 diagrammatically illustrates the flow of distribution service data-updating method according to an embodiment of the invention
Figure.
Fig. 3 diagrammatically illustrates the flow of distribution service data query method according to an embodiment of the invention
Figure.
Embodiment
By reference to one exemplary embodiment, the purpose of the present invention and function and the side for realizing these purposes and function
Method will be illustrated.However, the present invention is not limited to one exemplary embodiment as disclosed below；Can by multi-form come
It is realized.The essence of specification is only to aid in the detail of the various equivalent modifications Integrated Understanding present invention.
Hereinafter, embodiments of the invention will be described with reference to the drawings.In the accompanying drawings, identical reference represents identical
Or similar part, or same or like step.
Fig. 1 a diagrammatically illustrate the structured flowchart of distribution service according to an embodiment of the invention.Such as Fig. 1 a institutes
Show, include using distribution service according to an embodiment of the invention：Primary database 110, from database 120, caching 130
And indexing unit 131.Fig. 1 b diagrammatically illustrate the structural frames of distribution service according to another embodiment of the present invention
Figure.Wherein indexing unit 131 is located in caching 130.
In system update data, first the data in primary database 110 are updated, and according in primary database 110
Data after renewal from database 120 to being updated synchronization.Especially, the inquiry operation to primary database 110 is supported, for example
In the case of there is mark in caching 130.On mark, it will be described hereinafter.
From database 120, carry out the synchronized update data of autonomous database 110 5 for receiving, and support to from database
120 inquiry (such as when not finding data to be checked in caching 130), and by Query Result write-in caching 130 after inquiry
In.
Caching 130, supports the inquiry operation to it and write operation.Wherein, the data in caching 130 are when to main number
It is deleted, after primary database carries out data renewal, is deleted again first when carrying out database update according to storehouse 110.
Indexing unit 131 is used for Mk system and is in data more new state.When system carries out data renewal, deleted first
After the data in the caching 130, mark is put into indexing unit 131, and the data in the primary database are same
Walk it is described after database, by it is described mark delete.Such as Fig. 1 a and Fig. 1 b is respectively shown in, and indexing unit 131 can be arranged at
Caching 130 is outer or in caching 130.
Preferably, it is put into indexing unit 131 and assigns particular value labeled as to some data bit in indexing unit 131,
Also, the mark is deleted to reset for above-mentioned data bit.
Preferably, it is put into indexing unit 131 labeled as data are stored in indexing unit 131, such as, but not limited to
Deposit can play the data of mark function, also, delete data of the mark for the deposit.
Preferably, it is put into labeled as one file of establishment in indexing unit 131, and deletes in indexing unit 131
The file for marking to be created.
When carrying out inquiry operation to caching 130, if there is Query Result in caching 130, the inquiry knot is directly returned to
Really；If without Query Result, judging with the presence or absence of mark in the indexing unit 131 of caching 130, being then in primary database 110
Carry out data query, the inquiry of data otherwise carried out from database 120, after the completion of inquiry, future autonomous database 110 or from
The Query Result write-in caching 130 of database 120, and return to the Query Result.
Fig. 2 diagrammatically illustrates the method flow that distribution service data according to an embodiment of the invention update
Figure.As shown in Figure 2：Step 210, when distribution service carries out data renewal, first, the data in caching 130 are deleted.
In the master-slave database framework of the Distributed Services according to the present invention, when needing to be updated database, directly to master
Data in database 110 are updated.
Step 220, mark is put into indexing unit 131.Wherein, being put into mark in the indexing unit is, for example,
Specific value is assigned to some data bit in the indexing unit 131, for example, is entered as some data bit in indexing unit 131
1.Mark is put into the indexing unit 131 in another example being to be stored in data in indexing unit 131, it is preferred that deposit can
The data of mark function are played, for example, are stored in the value that one section of long and complicated energy plays mark feature.It is described be put into mark be also, for example,
Create a file.
Step 230, the data to primary database 110 are updated.
Step 240, by the data syn-chronization in primary database 110 to from database 120.According to the present invention, as long as master data
Storehouse 110 has the transactions requests for updating operation and updating submitted, will synchronize operation.
Step 250, the data in caching 130 are deleted.Especially, the mark in indexing unit 131 is not deleted here.Delete
The purpose of data in caching 130 is, deletes after step 210 to the old number deposited in caching 130 before this step
According to.The legacy data is specifically included：After from step 210 to before step 220 by writing the old of caching 130 from database 120
Data.
In the present embodiment, although first carry out step 240, step 250 is then carried out again, but the order of step is not limited
In this.It for example can also first carry out step 250 and then carry out step 240 again.That is, as long as step 240 and step 250 is in step
After 230, before step 260.Step 260, the mark in indexing unit 131 is arranged in delete step 220.Especially
Primary database 110, the deletion carried out after the operation of database 120 to mark is synchronized in completion by ground.Here mark is deleted
Mode, for example by indexing unit 131 particular value is endowed in step 220 data bit reset, for example will be in step
The data bit reset for being assigned 1 of indexing unit 131 in 220.Mark is deleted in another example being, is deleted in indexing unit 131
Step 220 in the data that are stored in, preferably can play the data of mark function, for example, delete described length and complexity
The value of mark feature can be played.Further for example, the file created in delete step 220.
Fig. 3 diagrammatically illustrate when for example it is as shown in Figure 2 master-slave database is updated after, carry out database look into
The flow chart of the method for inquiry.
As shown in Figure 3：Step 310, when needing to carry out inquiry operation to database, first, query caching 130 judges
It whether there is data to be checked in caching 130, be then to enter step 360 directly to return to Query Result；Otherwise step 320 is entered.
Step 320, it is then to enter step 330 with the presence or absence of mark in judge mark unit 131；Otherwise step is entered
340.The mark is the mark being put into when carrying out data renewal to primary database 110 in indexing unit 131.
Step 330, data are inquired about in primary database 110, subsequently into step 350.When judging in indexing unit 131
During in the presence of mark, explanation system is being carried out during updating operation to the data of primary database 110, now needs directly to look into
Newest and correct data result can just be obtained by asking the primary database 110 being updated.
Step 340, data are being inquired about from database 120.When judging mark is not present in indexing unit 131, say
Bright system is not carrying out updating operation to the data of primary database 110.After database update operation each time, all
The data 10 of primary database 110 after renewal can be synchronized to from database 120, therefore be not present when in indexing unit 131
During mark, illustrate now primary database 110 and be synchronous from database 120, now only need to inquiry from database 120
It can obtain newest and correct data result.
Step 350, by the data inquired the write-in caching 130.Write operation can ensure caching in data with
Primary database and consistent from the data in database, so that in 15 data base queryings after ensure that, when existing in caching
During data, query caching is only needed to can obtain correct and newest data result.
Step 360, the data in the caching are returned as Query Result.
According to the method and system for carrying out database update in the Distributed Services of the present invention to master-slave database, Neng Gouyou
Avoid to effect the possibility for still having the legacy data before updating in the caching after completing database update.The database of the present invention
Update and querying method is particularly suitable for use under the Distributed Services and master-slave database environment of high concurrent, it is ensured that in caching
Data are consistent with the data of database, eliminate because of the inconsistent risk of data that high concurrent and master-slave synchronisation delay are brought.
With reference to the explanation of the invention disclosed here and practice, other embodiment of the invention is for those skilled in the art
It all will be readily apparent and understand.Illustrate and embodiment is to be considered only as exemplary, of the invention true scope and purport is equal
It is defined in the claims.
Claims (8)
1. a kind of method of distribution service data query, it is characterised in that the system includes primary database, from data
Storehouse, caching and indexing unit, wherein when being updated to the data of the primary database, storage has mark in the indexing unit
Note, the primary database data syn-chronization to described after database, the mark is deleted, and methods described includes following step
Suddenly：
A) judge to whether there is data in the caching, be then to enter step f；Otherwise step b is entered；
B) judge to whether there is the mark in the indexing unit, be then to enter step c；Otherwise step d is entered；
C) data are inquired about in the primary database, subsequently into step e；
D) data are inquired about from database described；
E) data inquired are write into the caching；
F) data in the caching are returned as Query Result.
2. according to the method described in claim 1, it is characterised in that the mark is some data bit quilt of indexing unit
The particular value of imparting or to be stored in the data of the indexing unit or being the file created.
3. according to the method described in claim 1, it is characterised in that the indexing unit is located in the caching.
4. a kind of distribution service for claims 1 to 3 any claim methods described, it is characterised in that institute
The system of stating includes：
Primary database, for data storage, is supported to its inquiry operation；
From database, its data stored is updated for data storage, and according to the data of the primary database, it is described from
Database is supported to its inquiry operation；
Caching, for data storage, supports the inquiry operation to it and write operation, wherein, to the number of the primary database
During according to being updated, the data in the caching are deleted first, after the data of the primary database are updated, the caching
In data be deleted again；And
Indexing unit, after being deleted first for the data in the caching, deposits the mark, and when the primary database
In data syn-chronization to described after database, the mark is deleted；
When inquiring about the data in the distribution service, the caching is inquired about first, if having data in the caching,
Then the data in the caching are returned as Query Result；If the caching does not have data, judge in the indexing unit
It is that data query then is carried out to the primary database with the presence or absence of the mark, is otherwise looked into from database progress data described
Ask, in writing the caching to the primary database or the result from data base querying.
5. system according to claim 4, it is characterised in that the mark in the indexing unit is the mark
The particular value that the data bit of some in unit is assigned, also, delete the mark to reset above-mentioned data bit.
6. system according to claim 4, it is characterised in that the mark in the indexing unit is the mark
Remember the data of unit, also, delete data of the mark for the deposit indexing unit.
7. system according to claim 4, it is characterised in that be one of the mark in the indexing unit
File, also, delete file of the mark for the establishment.
8. system according to claim 4, it is characterised in that the indexing unit is located in the caching.
Priority Applications (1)
| 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 |
Applications Claiming Priority (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 |
Related Parent Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410148256.7A Division CN103955486B (en) | 2014-04-14 | 2014-04-14 | Distribution service and its data update, the method for data query |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107291869A true CN107291869A (en) | 2017-10-24 |
| CN107291869B CN107291869B (en) | 2020-04-24 |
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 After (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410148256.7A Active CN103955486B (en) | 2014-04-14 | 2014-04-14 | Distribution service and its data update, the method for data query |
Country Status (1)
| Country | Link |
|---|---|
| CN (2) | CN107291869B (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109710688A (en) * | 2018-11-26 | 2019-05-03 | 福建天泉教育科技有限公司 | A kind of real-time Inspection method of data and message-oriented middleware |
| CN109828980A (en) * | 2019-02-19 | 2019-05-31 | 北京字节跳动网络技术有限公司 | Data cache method, device, terminal and storage medium |
| CN109871388A (en) * | 2019-02-19 | 2019-06-11 | 北京字节跳动网络技术有限公司 | Data cache method, device, whole electronic equipment and storage medium |
| CN111177197A (en) * | 2019-12-26 | 2020-05-19 | 北京仁科互动网络技术有限公司 | Cache processing method and system |
| 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 |
| CN113760860A (en) * | 2020-11-12 | 2021-12-07 | 北京京东振世信息技术有限公司 | Data reading method and device |
Families Citing this family (17)
| 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 |
| CN105260475B (en) * | 2015-10-30 | 2019-08-16 | 努比亚技术有限公司 | A kind of data search method, date storage method and related 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 |
| 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 |
| CN106407351A (en) * | 2016-09-05 | 2017-02-15 | 乐视控股（北京）有限公司 | Data processing method and device applied to database |
| CN108509450B (en) * | 2017-02-27 | 2022-04-12 | 北京京东尚科信息技术有限公司 | Method and device for processing high-concurrency update of database |
| 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 |
| CN108897495B (en) * | 2018-06-28 | 2023-10-03 | 北京五八信息技术有限公司 | Cache updating method, device, cache equipment and storage medium |
| CN109358805B (en) * | 2018-09-03 | 2021-11-30 | 中新网络信息安全股份有限公司 | Data caching method |
| 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 |
| CN112364061A (en) * | 2020-11-18 | 2021-02-12 | 浪潮云信息技术股份公司 | Mysql-based high-concurrency database access method |
| CN113094430B (en) * | 2021-03-25 | 2023-10-03 | 北京达佳互联信息技术有限公司 | Data processing method, device, equipment and storage medium |
Citations (7)
| 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 |
| CN101576921A (en) * | 2009-06-15 | 2009-11-11 | 用友软件股份有限公司 | Data query system and data query engine device |
| CN102081625A (en) * | 2009-11-30 | 2011-06-01 | ***通信集团北京有限公司 | Data query method and query server |
| CN102508854A (en) * | 2011-09-29 | 2012-06-20 | 畅捷通信息技术股份有限公司 | Data access device and method |
| CN102521405A (en) * | 2011-12-26 | 2012-06-27 | 中国科学院计算技术研究所 | Massive structured data storage and query methods and systems supporting high-speed loading |
| CN102521406A (en) * | 2011-12-26 | 2012-06-27 | 中国科学院计算技术研究所 | Distributed query method and system for complex task of querying massive structured data |
| CN103345502A (en) * | 2013-07-01 | 2013-10-09 | 曙光信息产业(北京)有限公司 | Transaction processing method and system of distributed type database |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100454311C (en) * | 2006-12-25 | 2009-01-21 | 华为技术有限公司 | Data synchronous method and device based on SQL |
-
2014
- 2014-04-14 CN CN201710451567.4A patent/CN107291869B/en active Active
- 2014-04-14 CN CN201410148256.7A patent/CN103955486B/en active Active
Patent Citations (7)
| 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 |
| CN101576921A (en) * | 2009-06-15 | 2009-11-11 | 用友软件股份有限公司 | Data query system and data query engine device |
| CN102081625A (en) * | 2009-11-30 | 2011-06-01 | ***通信集团北京有限公司 | Data query method and query server |
| CN102508854A (en) * | 2011-09-29 | 2012-06-20 | 畅捷通信息技术股份有限公司 | Data access device and method |
| CN102521405A (en) * | 2011-12-26 | 2012-06-27 | 中国科学院计算技术研究所 | Massive structured data storage and query methods and systems supporting high-speed loading |
| CN102521406A (en) * | 2011-12-26 | 2012-06-27 | 中国科学院计算技术研究所 | Distributed query method and system for complex task of querying massive structured data |
| CN103345502A (en) * | 2013-07-01 | 2013-10-09 | 曙光信息产业(北京)有限公司 | Transaction processing method and system of distributed type database |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109710688A (en) * | 2018-11-26 | 2019-05-03 | 福建天泉教育科技有限公司 | A kind of real-time Inspection method of data and message-oriented middleware |
| CN109710688B (en) * | 2018-11-26 | 2021-10-08 | 福建天泉教育科技有限公司 | Data real-time comparison and verification method and message middleware |
| CN109828980A (en) * | 2019-02-19 | 2019-05-31 | 北京字节跳动网络技术有限公司 | Data cache method, device, terminal and storage medium |
| CN109871388A (en) * | 2019-02-19 | 2019-06-11 | 北京字节跳动网络技术有限公司 | Data cache method, device, whole electronic equipment and storage medium |
| CN111177197A (en) * | 2019-12-26 | 2020-05-19 | 北京仁科互动网络技术有限公司 | Cache processing method and system |
| CN111177197B (en) * | 2019-12-26 | 2023-03-14 | 北京仁科互动网络技术有限公司 | Cache processing method and system |
| CN113760860A (en) * | 2020-11-12 | 2021-12-07 | 北京京东振世信息技术有限公司 | Data reading method and device |
| 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 |
| WO2022252322A1 (en) * | 2021-06-03 | 2022-12-08 | 广东电网有限责任公司珠海供电局 | Method for synchronizing memory database and relational database of feature tag-based power grid monitoring system |
| CN113704267A (en) * | 2021-08-31 | 2021-11-26 | 平安普惠企业管理有限公司 | Data query method, system, equipment and storage medium based on elastic search |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103955486B (en) | 2017-08-01 |
| CN103955486A (en) | 2014-07-30 |
| CN107291869B (en) | 2020-04-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103955486B (en) | Distribution service and its data update, the method for data query | |
| CN103678556B (en) | The method and processing equipment of columnar database processing | |
| JP4414381B2 (en) | File management program, file management apparatus, and file management method | |
| US20140358859A1 (en) | File sharing system and file sharing method | |
| TWI262406B (en) | System, method and program storage device for dynamic caching of data based on queries performed by a local application | |
| CN103026355B (en) | Data base management system | |
| CN102402596B (en) | A kind of reading/writing method of master slave separation database and system | |
| EP3519986B1 (en) | Direct table association in in-memory databases | |
| CN102640151B (en) | Transformed data recording method and system | |
| WO2018113580A1 (en) | Data management method and server | |
| JP2008533612A5 (en) | ||
| CN102110121A (en) | Method and system for processing data | |
| US8380663B2 (en) | Data integrity in a database environment through background synchronization | |
| JP5724735B2 (en) | Database update control device, database management system, and database update control program | |
| CN104423982B (en) | The processing method and processing equipment of request | |
| WO2016074370A1 (en) | Keyvalue database data table updating method and data table updating device | |
| WO2011070910A1 (en) | Data arrangement/calculation system, data arrangement/calculation method, master device, and data arrangement method | |
| CN104516974A (en) | Management method and device for file system directory entry | |
| CN107870954A (en) | The extended method and device of a kind of distributed data base | |
| CN108897868A (en) | Cache synchronization method and device, calculating equipment and storage medium based on trigger | |
| KR20140047448A (en) | Client and database server for resumable transaction and method thereof | |
| CN114185991A (en) | Method and related device for realizing data synchronization based on distributed database | |
| US8892535B2 (en) | Database management method | |
| CN110895547A (en) | Multi-source heterogeneous database data synchronization system and method based on DB2 federal characteristics | |
| CN106055646A (en) | Lock-free operation method of concurrent hash tables |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CP02 | Change in the address of a patent holder |
Address after: Room 210-02, 2nd Floor, Block C, Office Building, Comprehensive Service Zone, Nangang Industrial Zone, Economic and Technological Development Zone, Binhai New Area, Tianjin 300450 Patentee after: 58Tongcheng Information Technology Co.,Ltd. Address before: Building 105, Yard 10, Jiuxianqiao North Road, Jiangtai, Chaoyang District, Beijing 100015 Patentee before: 58Tongcheng Information Technology Co.,Ltd. |
|
| CP02 | Change in the address of a patent holder |