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

Database table capacity monitoring method and device

A database and capacity technology, applied in the computer field, can solve problems such as low accuracy and false early warning

Pending Publication Date: 2021-05-11
AGRICULTURAL BANK OF CHINA
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, only relying on the utilization rate of the database table to monitor the database table, the accuracy rate is low, and there will be false alarms

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
  • Database table capacity monitoring method and device
  • Database table capacity monitoring method and device
  • Database table capacity monitoring method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0051] In order to make the above objects, features and advantages of the present application more obvious and understandable, the embodiments of the present application will be further described in detail below in conjunction with the accompanying drawings and specific implementation methods.

[0052] see figure 1 , figure 1 It is a flow chart of a method for monitoring the capacity of a database table provided by the embodiment of the present application. Such as figure 1 As shown, the method includes steps S101-S105:

[0053] S101: Collect target information of a database table at a target time node; the target information includes application attribute information, record number and parameter information; the target time node includes a current time node and a previous time node.

[0054] Establish a monitoring database, and put the collected target information of the database table of the target time node into the database. The target time node includes the current ti...

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 database table capacity monitoring method and device. The method comprises the steps: acquiring the target information of a database table of a target time node, wherein the target time node comprises a current time node and a previous time node; determining the maximum available capacity of the database table of the current time node and the type of the database table of the current time node according to the target information of the database table of the current time node; determining the used capacity of the database table of the target time node according to the target information of the database table of the target time node; calculating the capacity utilization rate and the capacity growth rate of the database table of the current time node according to the maximum available capacity of the database table of the current time node and the used capacity of the database table of the target time node; and when it is determined that the database table meets an early warning condition according to the capacity utilization rate and the capacity growth rate of the database table of the current time node and the type of the database table, generating an early warning signal. The efficiency and the accuracy of database table capacity monitoring are improved.

Description

technical field [0001] The present application relates to the field of computer technology, in particular to a method and device for monitoring the capacity of a database table. Background technique [0002] Large state-owned banks build core business systems based on mainframes, which can meet business operation needs after data concentration. Large data concentration has strict requirements on the capacity of the database. The database contains tens of thousands of tables, and each table has a maximum available space. If the capacity of any table is full, it may cause transaction congestion in the entire core business system. [0003] Currently, the capacity of the database table is monitored by calculating the usage rate of the database table and setting the usage rate threshold of the table. When the utilization rate of the database table exceeds the threshold value of the utilization rate, an early warning signal is generated, and the technicians deal with the databa...

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
IPC IPC(8): G06F11/30G06F11/32G06F16/22
CPCG06F11/302G06F11/327G06F11/3065G06F16/2282
Inventor 乔波陆照信徐建斌刘琨张子君葛志赟何涛张宁子
Owner AGRICULTURAL BANK OF CHINA
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com