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

Database access method and database proxy node

A proxy node and access method technology, applied in database query, electrical digital data processing, special data processing applications, etc., can solve problems such as service stop, response delay, and low work stability

Active Publication Date: 2016-09-21
SHENZHEN LONGRISE SCI & TECH
View PDF5 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The above-mentioned user center websites all provide content support through the back-end database server. When a large number of access requests are concurrent in a short period of time, the database server is often unable to execute all access requests in time due to performance limitations, resulting in delayed response, or even downtime and stop services. The problem of low job stability

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
  • Database access method and database proxy node
  • Database access method and database proxy node
  • Database access method and database proxy node

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0038] The invention provides a database access method, referring to figure 1 , in the first embodiment of the database access method of the present invention, the database access method includes:

[0039] Step S10, when receiving the database access request sent by the user terminal, the database proxy node judges whether it is currently within the high-load period of the database server corresponding to the database access request, if not, proceed to step S20, and if yes, proceed to Step S30 is executed;

[0040] refer to figure 2 , is an example diagram of the database topology structure applied by the database access method of the present invention, such as figure 2 As shown in , the database proxy node provides proxy services for multiple database servers at the backend. For any database server at the backen...

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 database access method, which is applied to a database proxy node. A proxy service is provided for a plurality of database servers at a back end through the database proxy node. The method comprises the following steps: specific to any database server at the back end, if the database proxy node receives a database access request directing to the database server within a high-load time interval of the database server, determining a type of an SQL (Structured Query Language) sentence carried by the database access request firstly, and directly acquiring and transmitting business data directed by the SQL sentence to a source user terminal of the database access request if the carried SQL sentence is a DQL (Data Query Language) sentence; and if the carried SQL sentence is a DML (Data Manipulation Language) sentence, sending the database access request to the database server to execute the database access request when the high-load time interval of the database server is exceeded. The invention also discloses a database proxy node. Through adoption of the database access method and the database proxy node, the working stability of the database servers can be improved.

Description

[0001] technology neighborhood [0002] The invention relates to the technical field of the Internet, in particular to a database access method and a database proxy node. Background technique [0003] With the rapid development of Internet technology, a variety of professional and comprehensive user-centered websites with personalized operations, rich content, and active interactions have emerged, such as various e-commerce websites and microblog websites that have emerged recently. . The above-mentioned user center websites all provide content support through the back-end database server. When a large number of access requests are concurrent in a short period of time, the database server is often unable to execute all access requests in time due to performance limitations, resulting in delayed response, or even downtime and stop services. The problem of low job stability. Contents of the invention [0004] The main purpose of the present invention is to provide a 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
IPC IPC(8): G06F17/30
CPCG06F16/24
Inventor 张锐
Owner SHENZHEN LONGRISE SCI & TECH
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