Method, device and system for synchronizing database with application cache server

A caching server and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as database read and write pressure, peak occurrence, database system access bottlenecks, etc., to meet timeliness and reduce pressure Effect

Inactive Publication Date: 2011-04-20
CHINA MOBILE COMM GRP CO LTD
View PDF4 Cites 45 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] For the method of realizing synchronization through an external synchronization program, if the check period of the external synchronization program is too long, the consistency of the data in the data cache and the database cannot be guaranteed, which will affect the normal use of the data user. If the check period is too short, it will inevitably Read and write pressure on the database
In addition, if the amount of data in the database is huge, the time to complete synchronization, the pressure of reading and writing data, and the computational overhead of retrieving changed data will be unacceptable
[0007] For the method of data synchronization completed by the data visitor, the complexity of the data usage interface is increased; when the data is synchronized for the first time, a large amount of data may need to be synchronized, and the pressure on the database system will peak. This leads to performance problems; if the data expiration time strategy is used, in addition to increasing the complexity of the data usage interface, it will also create a new database system access bottleneck

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, device and system for synchronizing database with application cache server
  • Method, device and system for synchronizing database with application cache server
  • Method, device and system for synchronizing database with application cache server

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] In the technical solution provided by the embodiment of the present invention, a trigger synchronization technology is proposed. When the data in the database changes, the changed data is actively synchronized to the application cache server, so that the data in the application cache server and the data in the database are kept It is consistent, and solves the timeliness problem of synchronizing data in the database to the application cache server and the pressure on the database during data synchronization.

[0029] The following will clearly and completely describe the technical solutions of the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creat...

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 embodiment of the invention discloses a method for synchronizing a database with an application cache server. The method comprises the following steps of: when data in the database is updated, receiving updated data from the database and adding the updated data into a message queue; and updating data in the application cache server according to the updated data added into the message queue. By the embodiment of the invention, the requirement on the timeliness of the synchronization of data in the database to the application cache server is met and the pressure on the database during data synchronization is reduced. The embodiment of the invention also discloses a device and a system using the method.

Description

technical field [0001] The invention relates to the field of data services, in particular to a method, device and system for synchronizing an application cache server and a database. Background technique [0002] With the development of software technology and the needs of enterprise information construction in recent years, the data to be processed by the current application system is becoming larger and larger, and the number of users to be served is also increasing. Most of the data in the application system is stored in the database system for serving users. The increase in the amount of data and the number of users lead to an increase in the database system load and work pressure, making the database system the bottleneck of the entire application system. [0003] In order to improve the performance of the database system, in addition to the evolution of the architecture design of the database system itself, the application system often uses an application cache server...

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 Applications(China)
IPC IPC(8): G06F17/30
Inventor 王磊范晓晖刘越于蓉蓉郑冬冬
Owner CHINA MOBILE COMM GRP 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