A method, device and system for controlling database resource access
A resource access and database technology, applied in the field of controlling database resource access, can solve problems such as database resource occupation, inability to effectively control database access, and lack of access control mechanisms
Active Publication Date: 2016-04-06
BEIJING SOHU NEW MEDIA INFORMATION TECH
View PDF3 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0003] However, the current database management system has very limited control over database resources. Once the client is allowed to establish a connection with the database system, the client is also allowed to occupy the database resources in the database system without restriction.
However, for application service providers, such as cloud platforms, the control of database resources is a very important requirement, and it is also an important criterion for their tariffs. After the cloud platform allows a client to establish a connection with the database, it needs to When the client's access service to the database ends, the client's access to the database is promptly restricted. However, because the database management system lacks a control access mechanism for the connected client, it cannot effectively control the database access in time
Even if the database management system modifies the connection limit of the client in time, the service needs to be restarted to take effect, which is not applicable to the requirement that the cloud platform needs to continuously provide services
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0071] In order to make the above objects, features and advantages of the present invention more comprehensible, the embodiments of the present invention will be further described in detail below in conjunction with the accompanying drawings and specific implementation methods.
[0072] Controlling database resources from the perspective of restricting client access to the database includes the following embodiments:
[0073] see figure 1 , is a flow chart of a method for controlling database resource access provided by the present invention, such as figure 1 As shown, the method includes:
[0074] S101. Receive an access request from a client to a database connected to it;
[0075] S102. Determine whether the database resource state corresponding to the client's access request to the database exceeds a preset threshold;
[0076] It should be noted that, in the database resource state corresponding to the client's access request to the database referred to in the present in...
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
Login to View More Abstract
The invention discloses a method, a device and a system for controlling the access to database resources, which aims to obtain a purpose that the access of a client to the database is effectively controlled. The method comprises the following steps: receiving an access request of the client to a database connected with the client; and judging whether the state of the database resources corresponding to the access request of the client to the database is over a preset threshold value or not, if not, the access request is sent to the database, and if yes, the access request is rejected. According to the invention, since the access request of the client to the database is corresponding to the state of the database resources, a purpose that the access of the client to the database resources can be effectively intercepted is obtained when the state of the database resources corresponding to the service customized by a client is over the threshold value.
Description
technical field [0001] The invention relates to the field of databases, in particular to a method, device and system for controlling database resource access. Background technique [0002] Database is an indispensable resource for various application services. At present, the control of database resources is realized by a relatively mature database management system, such as MYSQL database management system. Usually, a database management system is responsible for the creation and access of several databases in the system. . [0003] However, the current database management system has very limited control over database resources. Once a client is allowed to establish a connection with the database system, the client is also allowed to occupy unlimited database resources in the database system. However, for application service providers, such as cloud platforms, the control of database resources is a very important requirement, and it is also an important criterion for their...
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
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30G06F21/62
Inventor 张辉华
Owner BEIJING SOHU NEW MEDIA INFORMATION TECH