Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and system for centralized management of database caches

A centralized management and database technology, applied in the field of centralized management of database cache, can solve the problems of high performance, difficulty in ensuring the timeliness of synchronization, etc., and achieve the effect of saving system resources

Active Publication Date: 2010-05-12
广东北斗南方科技有限公司
View PDF1 Cites 24 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

But these methods all need to consume considerable performance, especially each table in the database has many record items, if the data in a certain record item changes, the database caches on all servers must be changed accordingly, so It is difficult to ensure the timeliness of synchronization

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 centralized management of database caches
  • Method and system for centralized management of database caches
  • Method and system for centralized management of database caches

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] The object of the present invention is to provide a method and system for centralized management of database cache, which avoids the problem of needing to synchronize database cache when synchronizing databases, and saves system resources.

[0030] The present invention will be described below in conjunction with the accompanying drawings. The present invention provides a centralized management method for database cache, image 3 A schematic diagram of Embodiment 1 of a database cache centralized management method according to the present invention is given, and the method includes:

[0031] Step S1, the database server sends database operation information to the database cache server;

[0032] The database server includes a database, and the cache server is used for caching some entries in the database, and is connected to one or more database servers.

[0033] The database operation information may include a database table name, a database entry primary key, a databa...

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 method and a system for the centralized management of database caches. The method comprises the following steps that: step S1, a database server sends database operating information to a database cache server; step S2, the database cache server performs corresponding operations on the database caches according to the database operating information, and returns an operating result to a database server; and step S3, the database server performs corresponding operations on a database according to the operating result. Through the centralized management of the database caches, the method and the system deploy a unified database cache server for a plurality of database servers, have no need to maintain one database cache on each database server, and perform corresponding operations on the database caches before operating the database, so the problem that a plurality of the database caches are synchronized while the database is synchronized is avoided, and the system resource is saved.

Description

technical field [0001] The invention relates to a database cache centralized management method and system, belonging to the technical field of data communication. Background technique [0002] A cluster (Cluster) is a loosely coupled collection of computing nodes composed of two or more node machines (servers), providing users with a single customer view of network services or applications (including databases, web services, and file services, etc.) , while providing a fault recovery capability close to that of a fault-tolerant machine. A cluster system is generally interconnected through two or more node server systems through corresponding hardware and software, and each cluster node is an independent server running its own process. These processes can communicate with each other and appear to network clients as a single system, working together to provide applications, system resources, and data to users. [0003] Network load balancing is that two or more servers form ...

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/30H04L29/08
Inventor 毛琦
Owner 广东北斗南方科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com