Cache processing method and system of distributed database

A cache processing and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as the lack of data caching function of distributed database agents, the lack of data caching functions of database agents, and the frequent response of mysql server, etc. Achieve the effect of improving the concurrent processing capability of the system, improving the concurrent processing capability, and improving the utilization rate of system resources

Active Publication Date: 2014-09-17
北京思特奇信息技术股份有限公司
View PDF6 Cites 24 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The same request will be sent to the mysql server multiple times for execution, and the database proxy has no data caching function, which will cause the mysql server to respond frequently and reduce performance
[0005] The same request will be sent to the mysql server multiple times for execution, which will cause a large concurrency of the mysql server and affect performance
[0006] The distributed database proxy lacks the data caching function, so the proxy will frequently call the mysql server to execute commands

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
  • Cache processing method and system of distributed database
  • Cache processing method and system of distributed database
  • Cache processing method and system of distributed database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0051] The principles and features of the present invention are described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.

[0052] Such as figure 1 As shown, it is a cache processing method of a distributed database according to the present invention, which specifically includes the following steps:

[0053] Step 1: Receive a command from the client, judge whether it is the first time to receive a command from the client, if yes, perform step 3; otherwise, perform step 2;

[0054]Step 2: Determine whether there is cached data matching the client's command in the cache, and if so, return the matching cached data to the client and end; otherwise, execute step 3;

[0055] Step 3: analyze the sql structured query language statement in the data package of the mysql relational database management system, and obtain the type of the sql stateme...

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 relates to a cache processing method and system of a distributed database. The system comprises a receiving module, an order matching module, an analyzing module, a judging module, a cache analyzing module, a table name judging module, a routing module and a feedback module. The receiving module is in one-way connection with the analyzing module and the order matching module. The order matching module is in one-way connection with a client side and the analyzing module. The analyzing module is in one-way connection with the judging module. The judging module is in one-way connection with the cache analyzing module and the routing module. The cache analyzing module is connected with the feedback module through the table name judging module. The routing module sends a buffering result to the feedback module. The feedback module returns the buffering result to the client side. According to the cache processing method and system, the system concurrent processing capacity and the system resource utilization ratio are improved, a load on a low-end server is utilized for sharing the storage space of the database to process data, and performance and safety are improved.

Description

technical field [0001] The invention relates to a cache processing method and system of a distributed database. Background technique [0002] The existing distributed database agent will send each sql request sent by the client to be processed to the mysql server for processing, and return the processing result to the client. This method will cause the same sql query statement to be requested to the mysql server for execution multiple times, which will affect the efficiency of mysql. [0003] Existing system processing has the following disadvantages: [0004] The same request will be sent to the mysql server multiple times for execution, and the database proxy has no data caching function, which will cause the mysql server to respond frequently and reduce performance. [0005] The same request will be sent to the mysql server multiple times for execution, which will lead to a large concurrency of the mysql server and affect performance. [0006] The distributed database ...

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
CPCG06F16/24552
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