Vernier-based database query method and gateway equipment

A gateway device and query method technology, applied in the database field, can solve the problems of slow operation response, not too obvious overall use perception of the system, unable to transform the source code to optimize the query efficiency, etc.

Pending Publication Date: 2021-06-11
CHINA TELECOM CORP LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This reading method is not very obvious to the overall usage perception of the system in a low-latency LAN environment, but if the system is placed in a public cloud operating environment with a delay of more than 5 milliseconds, it will be obvious that the operation response is slow
At the same time, many application software cannot optimize query efficiency through source code modification, or the cost of modification is too high

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
  • Vernier-based database query method and gateway equipment
  • Vernier-based database query method and gateway equipment
  • Vernier-based database query method and gateway equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] The technical solution of the present disclosure will be described in further detail below with reference to the drawings and embodiments.

[0025] When the database is migrated from the local environment to the public cloud environment, the delay between the client and the database will increase significantly, especially when the client needs to use a cursor to extract data from the database one by one, which will result in a particularly long response time for the entire operation.

[0026] The flowchart of some embodiments of the cursor-based database query method of the present disclosure is as follows figure 1 shown.

[0027] In step 101, the connection between the client and the database is monitored. When the database server is located on the public cloud host, the local area network running the client software and the cloud host network are connected through the cloud dedicated line; connected to the local area network, and one end is connected to the cloud ded...

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 cursor-based database query method and gateway equipment, and relates to the technical field of databases. The database query method based on the cursor comprises the steps that connection between a client side and a database is monitored, and a database server is located in a public cloud; when it is determined that the number of times that the client queries the vernier one by one in the preset time exceeds the preset number of times, a first preset number of data starting from the position of the vernier is obtained from a database server and stored in a gateway; and when the client queries the data, the gateway provides the data for the client. By means of the method, on the premise that client software is not improved, data caching based on the vernier position can be achieved through processing at the gateway, the gateway provides data for the client, the situation that time delay of long-distance data transmission is too large is avoided, and database data query efficiency is improved.

Description

technical field [0001] The disclosure relates to the technical field of databases, in particular to a cursor-based database query method and gateway equipment. Background technique [0002] When the user system is running in a LAN environment, it usually does not consider the influence of network transmission delay, and frequently accesses the network during a single operation; especially in the cursor-based database query, it is common to read the cursor line by line. This reading method is not very obvious to the overall usage perception of the system in a low-latency LAN environment, but if the system is placed in a public cloud operating environment with a delay of more than 5 milliseconds, the operation response will be clearly perceived to be slow. At the same time, many application software cannot optimize query efficiency through source code modification, or the cost of modification is too high. Contents of the invention [0003] An object of the present disclosur...

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): G06F16/2455G06F16/25H04L12/66
CPCG06F16/24552G06F16/256H04L12/66
Inventor 张旺财吴德承黄诗嵘
Owner CHINA TELECOM CORP 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