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

Method, device and system for data request

A data request and database technology, applied in the Internet field, can solve problems such as database query request paralysis, and achieve the effect of preventing paralysis

Active Publication Date: 2018-11-09
BEIJING QIANXIN TECH
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of this, the present invention provides a data request method, device and system, which can solve the problem of database paralysis due to too many query requests

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 data request
  • Method, device and system for data request
  • Method, device and system for data request

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0030] In order to prevent the database from being paralyzed due to too many query requests, the embodiment of the present invention provides a data request method, which can suspend the forwarding of query requests when the database is in an overloaded state, thus allowing the database to have sufficient time to process A request has already been processed. Such as figure 1 As shown, the method includes:

[0031] 101. Establish ...

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 method, a device and a system for requesting data, and relates to the technical field of internets, which aims at solving the problem of paralysis caused by excessive query requests of a database. The method comprises the following steps of establishing a first coroutine corresponding to the database, detecting the load state of the database through the first coroutine, and obtaining the detection result; when an query request reported by a terminal is received, establishing a second coroutine corresponding to the query request, and obtaining the detection result from the first coroutine through the second coroutine; when the detection result represents that the database is in the overload state, stopping forwarding the query request to the database. The method is mainly applied to postgresql database systems.

Description

technical field [0001] The present invention relates to the technical field of the Internet, in particular to a data request method, device and system. Background technique [0002] Inside the LAN, the console acts as a bridge between the terminal and the database, responsible for receiving, managing, and forwarding the query requests sent by the terminal to the database, and sending the query content returned by the database to the terminal. Usually, the processing resources allocated by the database server to query tasks are limited, and the number of query requests reported instantaneously in the local area network (hereinafter referred to as the number of concurrent requests) may be relatively large. In this case, the processing resources of the database server cannot handle all All query requests are responded to. At this time, the resource load pressure of the database is relatively high, and it is prone to paralysis. Once the database is paralyzed, it cannot be recov...

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 Patents(China)
IPC IPC(8): G06F17/30G06F11/00
CPCG06F16/951
Inventor 王院生
Owner BEIJING QIANXIN 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