CN111046106A - Cache data synchronization method, device, equipment and medium - Google Patents
Cache data synchronization method, device, equipment and medium Download PDFInfo
- Publication number
- CN111046106A CN111046106A CN201911316095.7A CN201911316095A CN111046106A CN 111046106 A CN111046106 A CN 111046106A CN 201911316095 A CN201911316095 A CN 201911316095A CN 111046106 A CN111046106 A CN 111046106A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- cache
- deleting
- calling
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 49
- 238000012545 processing Methods 0.000 claims abstract description 31
- 230000001360 synchronised effect Effects 0.000 claims abstract description 22
- 238000004590 computer program Methods 0.000 claims description 8
- 238000012986 modification Methods 0.000 description 4
- 230000004048 modification Effects 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 238000007792 addition Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002688 persistence Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
Images
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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a cache data synchronization method, relates to the technical field of data processing, and aims to realize the synchronization of cache data by performing synchronous processing on database data and cache data. The method comprises the following steps: receiving a database calling request; determining a database calling type according to the database calling request; according to the calling type of the database, the synchronous processing is carried out on the database data and the cache data, and the method comprises the following steps: when the data calling type is that data is modified or deleted according to the main key, synchronously modifying or deleting the database data and the cache data in the cache database according to the main key; and when the data calling type is that the data is modified or deleted according to the condition, modifying or deleting the database data and the cache data of the related table in the cache database according to the condition. The invention also discloses a cache data synchronization device, electronic equipment and a computer storage medium.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method, an apparatus, a device, and a medium for synchronizing cache data.
Background
When the system is larger and the concurrency of data is higher and higher, the database cache is an effective method for solving the database reading and writing pressure, so that the application of the cache database is more and more common. And redis is one of cache databases, and is increasingly applied to projects due to AOF persistence, clustering capability and execution efficiency of the cache databases to be used as a global cache of the databases.
At present, the mainstream redis cached by using mybaties creation tool class inheritance Cache interface to realize data access, and the method has the following disadvantages: as long as one data needs to be modified or deleted, all cache data in the current redis database needs to be cleared, so that other cache data which do not need to be modified or deleted are also cleared, and the data needs to be read from the database one by one again when being read subsequently, thereby increasing the calling times of the database.
Disclosure of Invention
In order to overcome the defects of the prior art, an object of the present invention is to provide a cache data synchronization method, which is to perform a synchronization operation on cache data when performing an operation on data in a database, so as to update the cache data, so that the cache data and the data in the database are kept synchronized.
One of the purposes of the invention is realized by adopting the following technical scheme:
a cache data synchronization method comprises the following steps:
receiving a database calling request;
determining a database calling type according to the database calling request;
according to the calling type of the database, carrying out synchronous processing on the database data and the cache data;
when the data calling type is that data is modified or deleted according to the main key, synchronous processing is carried out on database data and cache data, and the method comprises the following steps: modifying or deleting database data according to the primary key, and synchronously modifying or deleting cache data in a cache database according to the primary key;
when the data calling type is that data is modified or deleted according to conditions, synchronous processing is carried out on database data and cache data, and the method comprises the following steps: and modifying or deleting the database data according to the conditions, and modifying or deleting the cache data of the relevant table from the cache database according to the conditions.
Further, the database calling type further comprises the steps of obtaining data according to the main key, obtaining data according to the query condition and adding new data.
Further, according to the database calling type, the synchronous processing is carried out on the database data and the cache data, and the method further comprises the following steps:
when the data calling type is that data are acquired according to a main key, acquiring the data from a cache database according to the main key, if the data are acquired successfully, returning the acquired data, otherwise, acquiring the data from the database according to the main key, storing the data in the cache database and returning the data;
when the database calling type is that data is acquired according to the query condition, acquiring the data from the cache database according to the query condition, if the data is acquired successfully, returning the acquired data, otherwise, acquiring the data from the database according to the query condition, storing the acquired data in the cache database, and returning the acquired data;
and when the data calling type is the newly added data, adding the newly added data into the database, and storing the newly added data into the cache database.
Further, the cache database is redis, and the condition is used as a KEY value, and the cache data of the table corresponding to the KEY value is queried and deleted.
Further, the cache database is redis, the query condition is used as a KEY value, and cache data corresponding to the KEY value in the redis is queried and acquired.
Further, the database data and the cache data are synchronously processed through Spring cache annotation.
Further, synchronously processing the database data and the cache data through Spring cache annotation, including: annotating the returned values of the cached methods or classes by @ Cacheable; synchronously deleting the cached data when deleting the database data through the @ cacheEvict annotation; synchronously updating cache data when database data is updated through the @ CachePut annotation; and acquiring a database data main key through the @ cacheEvict annotation, and processing cache data according to the database data main key.
Another object of the present invention is to provide a cache data synchronization apparatus, which respectively processes database data and cache data according to a database call type, so as to implement synchronization and update of cache data.
The second purpose of the invention is realized by adopting the following technical scheme:
the request receiving module is used for receiving a database calling request;
the request processing module is used for determining a database calling type according to the database calling request;
the execution module is used for carrying out synchronous processing on database data and cache data according to the calling type of the database, and comprises: when the data calling type is that data is modified or deleted according to the main key, modifying or deleting database data according to the main key, and synchronously modifying or deleting cache data in a cache database according to the main key;
and when the data calling type is that the data is modified or deleted according to the condition, modifying or deleting the database data according to the condition, and modifying or deleting the cache data of the relevant table from the cache database according to the condition.
It is a further object of the present invention to provide an electronic device for performing one of the above objects, comprising a processor, a storage medium, and a computer program, the computer program being stored in the storage medium, the computer program, when executed by the processor, implementing the above-mentioned cache data synchronization method.
It is a further object of the present invention to provide a computer-readable storage medium storing one of the objects of the invention, on which a computer program is stored, which, when executed by a processor, implements the above-described cache data synchronization method.
Compared with the prior art, the invention has the beneficial effects that:
according to the method and the device, the cache data is modified or deleted through the main key or the condition, so that only relevant data in the cache database can be modified or deleted when the database data is modified or deleted, the cache database does not need to be emptied, synchronization and updating of the database data and the cache data are achieved, further, when the data is read in the subsequent process, the data can be directly read in the cache database, and the calling times of the database cannot be increased.
Drawings
FIG. 1 is a flow chart of a cache data synchronization method of the present invention;
fig. 2 is a block diagram showing the structure of a cache data synchronization apparatus according to embodiment 2;
fig. 3 is a block diagram of the electronic apparatus of embodiment 3.
Detailed Description
The present invention will now be described in more detail with reference to the accompanying drawings, in which the description of the invention is given by way of illustration and not of limitation. The various embodiments may be combined with each other to form other embodiments not shown in the following description.
Example 1
The embodiment provides a cache data synchronization method, which aims to prevent cache data in a cache database from being emptied when the database is modified or deleted, so that the cache data in the cache database and the database data can be kept synchronous, and data can be directly read from the cache database without recalling the database data when the data is subsequently read, thereby reducing the database recall times and improving the data reading efficiency.
According to the above principle, a cache data synchronization method is introduced, as shown in fig. 1, the cache data synchronization method specifically includes the following steps:
receiving a database calling request;
determining a database calling type according to the database calling request;
according to the calling type of the database, carrying out synchronous processing on the database data and the cache data;
when the data calling type is that data is modified or deleted according to the main key, synchronous processing is carried out on database data and cache data, and the method comprises the following steps: modifying or deleting database data according to the primary key, and synchronously modifying or deleting cache data in a cache database according to the primary key;
when the data calling type is that data is modified or deleted according to conditions, synchronous processing is carried out on database data and cache data, and the method comprises the following steps: and modifying or deleting the database data according to the conditions, and modifying or deleting the cache data of the relevant table from the cache database according to the conditions.
And the application program sends a database calling request to the database through the database calling interface so as to carry out operations such as increasing, deleting, modifying, checking and the like on the database. The database judges the database calling type according to the database calling request to determine the database calling type, so that different operations are executed on the database according to the database calling type. After the operation is performed on the database, the cache data stored in the cache database is also correspondingly operated to ensure the synchronization of the cache data.
Particularly, when data needs to be modified or deleted, firstly, the database is modified or deleted, then, cache data stored in the cache database is modified or deleted according to a main key or a condition, and at the moment, if a data record is deleted according to the main key, a piece of data is deleted in the cache database according to the main key; if the data in the relevant table is modified or deleted according to the condition, the relevant data of the table in the cache database is obtained according to the condition to be modified or deleted.
The primary key is a primary key set by a database table, is a primary key of the table and can be composed of one or more fields, and a row of data or an entity in the table can be uniquely determined through the primary key, so that a piece of data in the database can be operated (added, deleted, changed and checked) through the primary key.
Preferably, the cache database is redis, when data is modified or deleted according to a condition, the condition is used as a KEY value to match all tables, and if matching is successful, related data of the table is obtained in a circulating manner to be modified or deleted without emptying all cache data. For example, the modification condition is that UPDATE user SET generator is 4, the KEY value corresponding to the condition is user, UPDATE user SET generator is 4, the KEY value is used to match the table name and ID cached in the redis, and after the table name is obtained, the relevant data (generator) is modified according to the condition, and other tables in the cached data are not affected. Similarly, if the condition DELETE from user table in the database is used as a condition to DELETE all data of a man, the condition is used as a KEY value (KEY value: user: DELETE from user table) to match user table in the redis, and then data (table-related data) of the man whose user is cyclically acquired to DELETE the data in sequence, so that the operation does not empty the cache data of other tables in the redis.
In this embodiment, when a piece of data in redis is modified or deleted according to the primary key, an operation is performed on a specific piece of data according to the table name + the primary key, and no influence is generated on other cached data.
In other embodiments of the present invention, the cache database may also be a distributed cache tool such as ehcache, memcache, or the like.
Preferably, the database call type further includes acquiring data according to the primary key, acquiring data according to the query condition, and adding new data.
Preferably, according to the database call type, the database data and the cache data are synchronously processed, further comprising:
when the data calling type is that data are acquired according to a main key, acquiring the data from the redis according to the main key, if the data are acquired successfully, returning the acquired data, otherwise, acquiring the data from a database according to the main key, storing the data into the redis and returning the data;
when the calling type of the database is that data is acquired according to a query condition, acquiring the data from the redis by taking the query condition as a KEY value, if the data is acquired successfully, returning the acquired data, otherwise, acquiring the data from the database according to the query condition, storing the acquired data in the redis and then returning the acquired data;
and when the data calling type is the newly added data, adding the newly added data into the database, and storing the newly added data into the redis.
It should be noted that, by taking the query condition as a KEY value, the cache data corresponding to the KEY value in the redis is queried and acquired. The KEY value is: table name in query + all string combinations in query. If the user table needs to be queried for data with user _ name of 2and phone of 15311111111 from the redis, the query condition is that select from front user where user _ name is 2and phone is 15311111111, then KEY value is user: selecting from user name 2and phone 15311111111, obtaining data from redis by using the KEY value, and returning the goods directly if the obtaining is successful; otherwise, if the acquisition fails, acquiring data from the database according to the query condition, storing the acquired data in the redis, and returning the data.
Preferably, the database data and the cache data are processed synchronously through Spring cache annotation.
In this embodiment, the synchronous processing of the database data and the cache data through Spring cache annotation includes: in conjunction with the aop annotation function of ehcache, the returned value of a cached method or class is annotated by @ Cacheable: when the @ Cacheable annotation applies to a method, redis will cache the returned value of the method; when the @ Cacheable annotation applies to a class, redis will cache the return values for all methods of the class. Synchronously deleting cache data in redis when database data is deleted through @ CacheEvict annotation; the cached data in redis synchronously updated when database data is updated is annotated by @ CachePut. And acquiring a database data main key through the @ cacheEvict annotation, wherein the main key can be a data ID or other unique value, and processing the cache data according to the database data main key, namely calling redis to perform addition, deletion, modification and check on the cache data.
Example 2
The present embodiment discloses a cache data synchronization apparatus corresponding to the foregoing embodiment 1, which is a virtual structure apparatus, as shown in fig. 2, and includes:
a request receiving module 210, configured to receive a database call request;
the request processing module 220 is configured to determine a database call type according to the database call request;
and the execution module 230 is configured to perform synchronous processing on the database data and the cache data according to the database call type.
In this embodiment, the cache data is stored in a redis, which is a cache database.
In the executing module 230, the synchronizing process of the database data and the cache data includes:
when the data calling type is that data is modified or deleted according to the main key, modifying or deleting database data according to the main key, and synchronously modifying or deleting cache data in a cache database according to the main key;
and when the data calling type is that data is modified or deleted according to the condition, modifying or deleting the database data according to the KEY by taking the condition as the KEY value, and modifying or deleting the cache data of the relevant table from the cache database according to the condition.
When the data calling type is that data are acquired according to a main key, acquiring the data from the redis according to the main key, if the data are acquired successfully, returning the acquired data, otherwise, acquiring the data from a database according to the main key, storing the data into the redis and returning the data;
when the calling type of the database is that data is acquired according to a query condition, acquiring the data from the redis by taking the query condition as a KEY value, if the data is acquired successfully, returning the acquired data, otherwise, acquiring the data from the database according to the query condition, storing the acquired data in the redis and then returning the acquired data;
and when the data calling type is the newly added data, adding the newly added data into the database, and storing the newly added data into the redis.
Example 3
Fig. 3 is a schematic structural diagram of an electronic device according to embodiment 3 of the present invention, as shown in fig. 3, the electronic device includes a processor 310, a memory 320, an input device 330, and an output device 340; the number of the processors 310 in the computer device may be one or more, and one processor 310 is taken as an example in fig. 3; the processor 310, the memory 320, the input device 330 and the output device 340 in the electronic apparatus may be connected by a bus or other means, and the connection by the bus is exemplified in fig. 3.
The memory 320 is a computer-readable storage medium, and can be used for storing software programs, computer-executable programs, and modules, such as program instructions/modules corresponding to the cache data synchronization method in the embodiment of the present invention (for example, the request receiving module 210, the request processing module 220, and the execution module 230 in the cache data synchronization apparatus). The processor 310 executes various functional applications and data processing of the electronic device by executing software programs, instructions and modules stored in the memory 320, that is, implements the cache data synchronization method of embodiment 1.
The memory 320 may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application program required for at least one function; the storage data area may store data created according to the use of the terminal, and the like. Further, the memory 320 may include high speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid state storage device. In some examples, the memory 320 may further include memory located remotely from the processor 310, which may be connected to the electronic device through a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The input device 330 may be used to receive data call requests and the output device 340 may be used to output queries to data.
In one embodiment of the present invention, the electronic device may be a database server.
Example 4
Embodiment 4 of the present invention provides a storage medium containing computer-executable instructions, where the computer-executable instructions are executed by a computer processor to implement a cache data synchronization method, where the method includes:
receiving a database calling request;
determining a database calling type according to the database calling request;
according to the calling type of the database, carrying out synchronous processing on the database data and the cache data;
when the data calling type is that data is modified or deleted according to the main key, carrying out synchronous processing on database data and cache data: modifying or deleting database data according to the primary key, and synchronously modifying or deleting cache data in a cache database according to the primary key;
when the data calling type is that data is modified or deleted according to conditions, carrying out synchronous processing on database data and cache data: and modifying or deleting the database data according to the conditions, and modifying or deleting the cache data of the relevant table from the cache database according to the conditions.
Of course, the storage medium provided by the embodiment of the present invention contains computer-executable instructions, and the computer-executable instructions are not limited to the method operations described above, and may also perform related operations in the cache data synchronization method provided by any embodiment of the present invention.
From the above description of the embodiments, it is obvious for those skilled in the art that the present invention can be implemented by software and necessary general hardware, and certainly, can also be implemented by hardware, but the former is a better embodiment in many cases. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which may be stored in a computer-readable storage medium, such as a floppy disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a FLASH Memory (FLASH), a hard disk or an optical disk of a computer, and includes instructions for enabling an electronic device (which may be a mobile phone, a personal computer, a server, or a network device) to execute the methods according to the embodiments of the present invention.
It should be noted that, in the foregoing embodiment, each included unit and each included module are only divided according to functional logic, but are not limited to the above division as long as the corresponding functions can be implemented; in addition, specific names of the functional units are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present invention.
Various other modifications and changes may be made by those skilled in the art based on the above-described technical solutions and concepts, and all such modifications and changes should fall within the scope of the claims of the present invention.
Claims (10)
1. A cache data synchronization method is characterized by comprising the following steps:
receiving a database calling request;
determining a database calling type according to the database calling request;
according to the calling type of the database, carrying out synchronous processing on the database data and the cache data;
when the data calling type is that data is modified or deleted according to the main key, synchronous processing is carried out on database data and cache data, and the method comprises the following steps: modifying or deleting database data according to the primary key, and synchronously modifying or deleting cache data in a cache database according to the primary key;
when the data calling type is that data is modified or deleted according to conditions, synchronous processing is carried out on database data and cache data, and the method comprises the following steps: and modifying or deleting the database data according to the conditions, and modifying or deleting the cache data of the relevant table from the cache database according to the conditions.
2. The cache data synchronization method of claim 1, wherein the database call type further comprises obtaining data according to a primary key, obtaining data according to a query condition, and adding data.
3. The cache data synchronization method according to claim 2, wherein the database data and the cache data are synchronized according to a database call type, further comprising:
when the data calling type is that data are acquired according to a main key, acquiring the data from a cache database according to the main key, if the data are acquired successfully, returning the acquired data, otherwise, acquiring the data from the database according to the main key, storing the data in the cache database and returning the data;
when the database calling type is that data is acquired according to the query condition, acquiring the data from the cache database according to the query condition, if the data is acquired successfully, returning the acquired data, otherwise, acquiring the data from the database according to the query condition, storing the acquired data in the cache database, and returning the acquired data;
and when the data calling type is the newly added data, adding the newly added data into the database, and storing the newly added data into the cache database.
4. The cache data synchronization method according to claim 1, wherein the cache database is redis, and the condition is a KEY value, and the cache data of the table corresponding to the KEY value is queried and deleted.
5. The cache data synchronization method according to claim 3, wherein the cache database is redis, and the query condition is a KEY value, and the corresponding cache data of the KEY value in the redis is queried and obtained.
6. The cache data synchronization method according to claim 1, wherein the database data and the cache data are processed by Spring cache annotation synchronization.
7. The cache data synchronization method of claim 6, wherein the processing of the database data and the cache data through Spring cache annotation synchronization comprises: annotating the returned values of the cached methods or classes by @ Cacheable; synchronously deleting the cached data when deleting the database data through the @ cacheEvict annotation; synchronously updating cache data when database data is updated through the @ CachePut annotation; and acquiring a database data main key through the @ cacheEvict annotation, and processing cache data according to the database data main key.
8. A cache data synchronization apparatus, comprising:
the request receiving module is used for receiving a database calling request;
the request processing module is used for determining a database calling type according to the database calling request;
the execution module is used for carrying out synchronous processing on database data and cache data according to the calling type of the database, and comprises: when the data calling type is that data is modified or deleted according to the main key, modifying or deleting database data according to the main key, and synchronously modifying or deleting cache data in a cache database according to the main key;
and when the data calling type is that the data is modified or deleted according to the condition, modifying or deleting the database data according to the condition, and modifying or deleting the cache data of the relevant table from the cache database according to the condition.
9. An electronic device comprising a processor, a storage medium, and a computer program, the computer program being stored in the storage medium, wherein the computer program, when executed by the processor, implements the cache data synchronization method of any one of claims 1 to 7.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, implements the cache data synchronization method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911316095.7A CN111046106A (en) | 2019-12-19 | 2019-12-19 | Cache data synchronization method, device, equipment and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911316095.7A CN111046106A (en) | 2019-12-19 | 2019-12-19 | Cache data synchronization method, device, equipment and medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111046106A true CN111046106A (en) | 2020-04-21 |
Family
ID=70237247
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911316095.7A Pending CN111046106A (en) | 2019-12-19 | 2019-12-19 | Cache data synchronization method, device, equipment and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111046106A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111666305A (en) * | 2020-06-05 | 2020-09-15 | 福建天晴在线互动科技有限公司 | Method and system for realizing association between redis cache and database |
| CN111813791A (en) * | 2020-06-17 | 2020-10-23 | 上海悦易网络信息技术有限公司 | Method and equipment for distributed transaction compensation |
| CN113806389A (en) * | 2021-09-22 | 2021-12-17 | 未鲲(上海)科技服务有限公司 | Data processing method and device, computing equipment and storage medium |
Citations (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060026154A1 (en) * | 2004-07-30 | 2006-02-02 | Mehmet Altinel | System and method for adaptive database caching |
| US20060294088A1 (en) * | 2005-06-27 | 2006-12-28 | International Business Machines Corporation | Method, system, and computer program product for caching dynamically generated queries |
| CN102541927A (en) * | 2010-12-30 | 2012-07-04 | 北京新媒传信科技有限公司 | Method and device for realizing data cache |
| CN102867070A (en) * | 2012-09-29 | 2013-01-09 | 瑞庭网络技术（上海）有限公司 | Method for updating cache of key-value distributed memory system |
| US20140172898A1 (en) * | 2012-12-13 | 2014-06-19 | Microsoft Corporation | Distributed sql query processing using key-value storage system |
| US20140279944A1 (en) * | 2013-03-15 | 2014-09-18 | University Of Southern California | Sql query to trigger translation for maintaining consistency of cache augmented sql systems |
| CN105740383A (en) * | 2016-01-27 | 2016-07-06 | 中国科学院计算技术研究所 | Method and system for realizing data consistency of database and cache in big data platform |
| CN106484734A (en) * | 2015-09-01 | 2017-03-08 | 天脉聚源（北京）科技有限公司 | A kind of data query caching method and system |
| CN106599199A (en) * | 2016-12-14 | 2017-04-26 | 国云科技股份有限公司 | Data caching and synchronization method |
| CN107622115A (en) * | 2017-09-19 | 2018-01-23 | 武大吉奥信息技术有限公司 | A kind of space querying result cache method towards WFS services |
| WO2018040167A1 (en) * | 2016-08-31 | 2018-03-08 | 广州市乐商软件科技有限公司 | Data caching method and apparatus |
| CN108491332A (en) * | 2018-04-04 | 2018-09-04 | 浙江小泰科技有限公司 | A kind of real-time buffering updating method and system based on Redis |
| US20180260435A1 (en) * | 2017-03-13 | 2018-09-13 | Molbase (Shanghai) Biotechnology Co., Ltd. | Redis-based database data aggregation and synchronization method |
| CN109241072A (en) * | 2018-08-31 | 2019-01-18 | 携程计算机技术（上海）有限公司 | Buffering updating method and system based on Canal |
| CN109656957A (en) * | 2018-12-14 | 2019-04-19 | 中国银行股份有限公司 | Data query method and device based on Persistence Layer Framework |
| CN109800272A (en) * | 2019-02-25 | 2019-05-24 | 广州虎牙信息科技有限公司 | Data cached synchronous method, server, application system and storage device |
| CN109871338A (en) * | 2019-03-15 | 2019-06-11 | 北京思特奇信息技术股份有限公司 | A kind of date storage method, device and computer equipment |
-
2019
- 2019-12-19 CN CN201911316095.7A patent/CN111046106A/en active Pending
Patent Citations (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060026154A1 (en) * | 2004-07-30 | 2006-02-02 | Mehmet Altinel | System and method for adaptive database caching |
| US20060294088A1 (en) * | 2005-06-27 | 2006-12-28 | International Business Machines Corporation | Method, system, and computer program product for caching dynamically generated queries |
| CN102541927A (en) * | 2010-12-30 | 2012-07-04 | 北京新媒传信科技有限公司 | Method and device for realizing data cache |
| CN102867070A (en) * | 2012-09-29 | 2013-01-09 | 瑞庭网络技术（上海）有限公司 | Method for updating cache of key-value distributed memory system |
| US20140172898A1 (en) * | 2012-12-13 | 2014-06-19 | Microsoft Corporation | Distributed sql query processing using key-value storage system |
| US20140279944A1 (en) * | 2013-03-15 | 2014-09-18 | University Of Southern California | Sql query to trigger translation for maintaining consistency of cache augmented sql systems |
| CN106484734A (en) * | 2015-09-01 | 2017-03-08 | 天脉聚源（北京）科技有限公司 | A kind of data query caching method and system |
| CN105740383A (en) * | 2016-01-27 | 2016-07-06 | 中国科学院计算技术研究所 | Method and system for realizing data consistency of database and cache in big data platform |
| WO2018040167A1 (en) * | 2016-08-31 | 2018-03-08 | 广州市乐商软件科技有限公司 | Data caching method and apparatus |
| CN106599199A (en) * | 2016-12-14 | 2017-04-26 | 国云科技股份有限公司 | Data caching and synchronization method |
| US20180260435A1 (en) * | 2017-03-13 | 2018-09-13 | Molbase (Shanghai) Biotechnology Co., Ltd. | Redis-based database data aggregation and synchronization method |
| CN107622115A (en) * | 2017-09-19 | 2018-01-23 | 武大吉奥信息技术有限公司 | A kind of space querying result cache method towards WFS services |
| CN108491332A (en) * | 2018-04-04 | 2018-09-04 | 浙江小泰科技有限公司 | A kind of real-time buffering updating method and system based on Redis |
| CN109241072A (en) * | 2018-08-31 | 2019-01-18 | 携程计算机技术（上海）有限公司 | Buffering updating method and system based on Canal |
| CN109656957A (en) * | 2018-12-14 | 2019-04-19 | 中国银行股份有限公司 | Data query method and device based on Persistence Layer Framework |
| CN109800272A (en) * | 2019-02-25 | 2019-05-24 | 广州虎牙信息科技有限公司 | Data cached synchronous method, server, application system and storage device |
| CN109871338A (en) * | 2019-03-15 | 2019-06-11 | 北京思特奇信息技术股份有限公司 | A kind of date storage method, device and computer equipment |
Non-Patent Citations (1)
| Title |
|---|
| HD243608836, pages 1 - 8, Retrieved from the Internet <URL:https://blog.csdn.net/HD243608836/article/details/89308479> * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111666305A (en) * | 2020-06-05 | 2020-09-15 | 福建天晴在线互动科技有限公司 | Method and system for realizing association between redis cache and database |
| CN111666305B (en) * | 2020-06-05 | 2023-03-14 | 福建天晴在线互动科技有限公司 | Method and system for realizing correlation between redis cache and database |
| CN111813791A (en) * | 2020-06-17 | 2020-10-23 | 上海悦易网络信息技术有限公司 | Method and equipment for distributed transaction compensation |
| CN111813791B (en) * | 2020-06-17 | 2024-05-21 | 上海万物新生环保科技集团有限公司 | Distributed transaction compensation method and equipment |
| CN113806389A (en) * | 2021-09-22 | 2021-12-17 | 未鲲(上海)科技服务有限公司 | Data processing method and device, computing equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9928178B1 (en) | Memory-efficient management of computer network resources | |
| CN107977396B (en) | Method and device for updating data table of KeyValue database | |
| CN110737682A (en) | cache operation method, device, storage medium and electronic equipment | |
| CN108255855B (en) | Data storage method and device | |
| CN108140050A (en) | A kind of method and device using Bloom filter filtering file | |
| CN111046106A (en) | Cache data synchronization method, device, equipment and medium | |
| CN104423982A (en) | Request processing method and device | |
| CN111125229A (en) | Data blood margin generation method and device and electronic equipment | |
| CN108037967A (en) | A kind of menu loading method and electronic equipment based on more parent-child structures | |
| CN112699187B (en) | Associated data processing method, device, equipment, medium and product | |
| CN112000649B (en) | Method and device for synchronizing incremental data based on map reduce | |
| CN111651424B (en) | Data processing method, device, data node and storage medium | |
| US10606805B2 (en) | Object-level image query and retrieval | |
| CN111858581B (en) | Paging query method and device, storage medium and electronic equipment | |
| CN113885780A (en) | Data synchronization method, device, electronic equipment, system and storage medium | |
| CN111753141B (en) | Data management method and related equipment | |
| CN110928900B (en) | Multi-table data query method, device, terminal and computer storage medium | |
| CN106202456B (en) | Send the method and device of picture | |
| CN113626449A (en) | Data storage method, data query method and related equipment | |
| CN112527900A (en) | Method, device, equipment and medium for database multi-copy reading consistency | |
| CN111949725A (en) | Data query method and device, electronic equipment and computer readable storage medium | |
| CN110727666A (en) | Cache assembly, method, equipment and storage medium for industrial internet platform | |
| CN115809304A (en) | Method and device for analyzing field-level blood margin, computer equipment and storage medium | |
| CN115480704A (en) | Method, device and equipment for constructing data block group migration mapping table and storage medium | |
| CN113419792A (en) | Event processing method and device, terminal equipment and storage medium |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200421 |