Method and device for flow control on database

A flow control and database technology, applied in the computer field, can solve problems such as inability to relieve database access pressure, long processing time, database crash, etc., and achieve the effect of relieving access pressure, avoiding crashes, and realizing flow control.

Active Publication Date: 2020-01-17
ALIBABA CLOUD COMPUTING LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, because the user has too many access requests at this time, some access requests are killed, and new access requests access the database, the above method of repeatedly killing user access requests is a current limiting method based on the upper application The processing time required is long, and repeated killing (kill) access requests cannot relieve the access pressure of the database, and the database is still prone to crashes

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 and device for flow control on database
  • Method and device for flow control on database
  • Method and device for flow control on database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] Embodiments of the present application are described in detail below, examples of which are shown in the drawings, wherein the same or similar reference numerals denote the same or similar elements or elements having the same or similar functions throughout. The embodiments described below by referring to the figures are exemplary, and are intended to explain the present application, and should not be construed as limiting the present application.

[0018] At present, in the process of users accessing the server through the client, most of them involve access to the database. In some special periods, such as Double Eleven or the Spring Festival travel season, there are usually high concurrent access requests. At this time, a large number of SQL statements will frequently access the database, and each SQL statement needs to process a lot of data. Due to the Its own processing capability is limited, and it is easy to respond slowly to access requests, or even crash. There...

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 method and device for flow control over a database. The method includes the steps that a data access request from a client is received, and a corresponding rule set is loaded for the data access request, wherein the rule set comprises at least one rule item; whether the corresponding data access request is executed or not is judged according to the rule set; if yes, the corresponding data access request is executed, and an execution result is returned to the client; if not, a refuse response is returned to the client. According to the method and device for flow control over the database, flow control over the database is achieved in the database, so that access pressure of the database is relieved, and breakdown of the database is avoided.

Description

technical field [0001] The present application relates to the field of computer technology, in particular to a method and device for flow control of a database. Background technique [0002] With the development of computer networks, there are more and more users using the network. Since the information required by many users is stored in the database (Database, DB), the database needs to handle more and more user visits, and the access pressure of the database getting bigger. [0003] When there are highly concurrent access requests, a large number of SQL (Structured Query Language, Structured Query Language) statements frequently access the database. For each SQL, the database needs to process more data. Due to the limited processing capacity of the database itself, the database responds The speed of user access requests slows down, and even the database is prone to crashes. [0004] At present, when there are highly concurrent access requests, in order to ensure that th...

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): G06F16/242H04L29/06
CPCG06F16/2433H04L63/10
Inventor 黄欢欢
Owner ALIBABA CLOUD COMPUTING 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