Method and system for refreshing database cache data

A technology for caching data and databases, applied in the field of databases, can solve problems such as spending a lot of energy, increasing the development cost of database cache data refresh, and increasing regular tasks to check the development code, so as to reduce the development cost.

Active Publication Date: 2019-03-12
唯品会(广州)软件有限公司
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In the current existing solutions, the modified information is usually recorded in the master database, and then the data in the slave database is checked by scheduled task checking. If there is an update, the cache is refreshed, otherwise continue to wait for the task check. Therefore, developers need to spend a lot of effort to increase the development code of scheduled task checking to realize the refresh of cached data, thereby increasing the development cost of database cached data refresh

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system for refreshing database cache data
  • Method and system for refreshing database cache data
  • Method and system for refreshing database cache data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] In order to make the purpose, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings.

[0018] see figure 1 A schematic flowchart of a method for refreshing database cache data in an embodiment.

[0019] A method for refreshing database cache data, comprising:

[0020] S102. Receive a data update message of the master database, the message includes the time of this update and the updated data object, and record the time as the update time of the master database.

[0021] By receiving the data update message of the master database, determine the update time of the master database and the updated data objects, and provide a benchmark for the comparison of subsequent update times.

[0022] S104. Obtain the latest update time of the corresponding data object in the slave library, record it as the update time of the slave library, and compare the updat...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention provides a refreshing method and system of database caching data. The refreshing method comprises the following steps: receiving a primary library update message which contains primary library update time which is updated at the time and an updated data object, obtaining the auxiliary library update time of a corresponding data object in an auxiliary library, then, comparing the primary library update time and the auxiliary library update time, and executing a caching data refreshing operation if the auxiliary library update time is longer than the primary library update time. Therefore, the refreshing of the caching data can be realized without a situation that development personnel increase development codes of timing task inspection so as to lower the development cost of the refreshing of the database caching data.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method and system for refreshing cached data in a database. Background technique [0002] In the scenario where the database reads and writes are separated, there will be a certain delay in replicating data from the database, and the source of the cached data is from the database. When the data is modified and the cache needs to be refreshed, it takes a long time to wait. [0003] In the current existing solutions, the modified information is usually recorded in the main library, and then the data in the slave library is checked by a scheduled task check. If there is an update, the cache is refreshed, otherwise continue to wait for the task check. Therefore, developers need to spend a lot of energy to increase the development code of scheduled task checking to realize the refreshing of cached data, thereby increasing the development cost of refreshing the database cached data. Conten...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/23G06F16/27
CPCG06F16/23G06F16/27
Inventor 刘嘉扬程彦
Owner 唯品会(广州)软件有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap