Distributed system cache data synchronous configuration method and apparatus

A distributed system and caching data technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of inability to realize distributed data cache synchronization, inability to cache data modification, inability to realize data cache distributed update, etc. Problems, easy to popularize and apply, not easy to make mistakes, and achieve simple effects

Inactive Publication Date: 2008-11-19
RUIJIE NETWORKS CO LTD
View PDF0 Cites 73 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, at present, when SQL Server and Oracle database systems are deployed in a distributed manner, the synchronization of distributed data caches still cannot be achieved.
Therefore, the data cache used by SQL ...

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
  • Distributed system cache data synchronous configuration method and apparatus
  • Distributed system cache data synchronous configuration method and apparatus
  • Distributed system cache data synchronous configuration method and apparatus

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] The method and device for synchronizing configuration of cached data in a distributed system provided by the embodiments of the present invention are applicable to any database, such as SQL Server database or Oracle database.

[0029] like figure 1 As shown, it is a flowchart of an embodiment of a method for synchronizing configuration of cached data in a distributed system of the present invention, which includes the following steps:

[0030] Step 101, when the data table containing the cached data in the database on the server in the distributed system changes, the modification information of the data table is copied to each sub-server in the distributed system through the database replication method, and the server The latest modification time corresponding to the data table name in the cached data update information table on the server is updated to the current time when the data table changes. The cached data update information table includes the name of the data t...

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 discloses a data cache simultaneous configuration method and a device in a distributed system, wherein, the method comprises the following steps: when a datasheet containing cached data changes on a server, the modification information of the datasheet is sent to each sub-server; the latest modification time of the datasheet is updated to the current time; a cached data update information table is enquired at a preset cycle starting time; when the latest modification time of the same data sheet is later than the last update time, the corresponding cached data is updated according to the latest modified datasheet ion the database, and the last update time in the cached data update information table is updated as the latest modification time; the datasheets in the database of each sub-server are updated according to the modification information, and the cached data on each sub-server is also updated through the same method. The invention is independent from the application system and can achieve synchronization update to the cached data in a distributed system, which is simple to be applied and can not easily make a mistake.

Description

technical field [0001] The invention relates to data cache technology, in particular to a method and device for synchronous configuration of cached data in a distributed system, a server and a distributed system. Background technique [0002] Data cache is a temporary container occupied by database data in memory. The temporary container contains a copy of database data in memory and is located between the database and the data access layer. When the application system needs to read database data, it first queries in the cache, which can avoid the performance overhead required for database calls. [0003] A good caching mechanism is particularly important in application systems that require frequent query operations on database data. Distributed cache allows multiple users of different hosts to access and modify the data at the same time, and can perform cache synchronization, which solves the limitation that shared memory can only be used on a single machine, and does not ...

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
IPC IPC(8): G06F17/30
Inventor 杨鑫伟吴俊
Owner RUIJIE NETWORKS CO LTD
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