Device and method for controlling database resources
A control device and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as system performance impact, system failure, complex database environment, etc., and achieve stable and reliable operation
Active Publication Date: 2012-02-08
ZTE CORP
View PDF0 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0003] However, according to the analysis of the actual production and operation database environment, it is found that some database management environments are more complicated or unpredictable
For example, when out-of-control queries or 4,000,000 rows of data are returned due to negligence, the research on the detailed list may affect the performance of the system, and in severe cases, it will cause system failure. Although the database alarm log information records all this, it is obvious that is too late, and there is no effective solution in the existing technology
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
[0032] The present invention will be further described in detail below with reference to the drawings and specific embodiments:
[0033] The control device for database resources in this embodiment includes a resource limit configuration module, a resource limit monitoring module, and a resource limit log recording module; the functions of each functional module are as follows:
[0034] Resource limit configuration module: used to configure resource limit information, including each monitoring object and its corresponding limit trigger conditions, limit methods, and monitoring time;
[0035] Resource limit monitoring module: used to separately monitor each monitored object according to the resource limit information, and use the corresponding restriction method to restrict the behavior of the monitored object for the monitored object that meets the corresponding limit trigger condition;
[0036] The resource limit log recording module is used to record the relevant information of the m...
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 database resource control device and method. The control device includes a resource limit configuration module and a resource limit monitoring module; the corresponding control method is: pre-configure resource limit information through the resource limit configuration module, including each monitoring object and its corresponding limit trigger conditions and limit methods; then, run the resource The restriction monitoring module monitors each of the monitoring objects respectively according to the resource restriction information, and restricts the behavior of the monitoring object by using a corresponding restriction method for the monitoring object satisfying the corresponding restriction triggering condition. The present invention adopts the method of monitoring various objects running in the database system, and limits the database resources occupied by the monitoring objects that may cause abnormalities in the database system, thereby ensuring the stable and reliable operation of the database system.
Description
Technical field [0001] The invention relates to the field of database system management, in particular to a device and method for regulating and controlling database resources. Background technique [0002] As the infrastructure in the system, the database serves the entire software system for a long time, and the data in it may be stored for 3 years, 5 years or longer. Therefore, in the database field, no matter what kind of database management system is used, it is unavoidable how to achieve high availability of the database. Although different database vendors provide corresponding functions, such as: database memory structure (database resource management process, database diagnosis process) and unplanned downtime (system failure, data abnormality) to planned downtime maintenance (system changes) , Data changes). [0003] However, based on the analysis of the actual production and operation database environment, it is found that some database management environments are more ...
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/30
Inventor 邵旭辉
Owner ZTE CORP