Database table space capacity monitoring method and device

A capacity monitoring and database technology, applied in database indexing, hardware monitoring, structured data retrieval, etc., can solve problems such as hidden capacity risks, user economic losses, social reputation losses, etc.

Pending Publication Date: 2019-09-27
INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF4 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Due to the upper limit of the capacity of the database table space, it is easy to cause a certain capacity hidden danger
If the monitoring and planning of the database table space capacity cannot be done well, when the database table space capacity reaches the upper limit capacity, a major production accident will be caused, which will bring heavy economic losses and social reputation losses to users

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0099] In order to make the purpose, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments It is a part of the embodiments of this application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of this application.

[0100] Considering that the capacity of the database table space has an upper limit, it is easy to cause certain capacity hidden dangers. The existing monitoring methods for the capacity of the database table space cannot effectively predict and monitor the capacity of the table space in real time. When the capacity of the database table space reaches the upper...

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 embodiment of the invention provides a database table space capacity monitoring method and device, and the method comprises the steps: obtaining the space change information of a database table according to the spatial capacity information change of the database table after at least one expected time interval; performing database table space capacity prediction according to the space change information of the database table, and performing early warning according to a database table space capacity prediction result. The spatial capacity of the database table can be effectively and automatically monitored, the spatial capacity of the database table is accurately predicted by combining the spatial change information of the database table, the accuracy and reliability of monitoring the spatial capacity of the database table are improved, and the production safety and stability of a user are guaranteed.

Description

technical field [0001] The present application relates to the technical field of data monitoring, in particular to a method and device for monitoring the capacity of a database table space. Background technique [0002] As a high-concurrency system that can process massive transactions in real time, the bank's mainframe system is a key link to support the smooth operation of the bank's core business. With the rapid development of the bank's own business, the comprehensive electronicization of various businesses, and the normalization of high-concurrency business scenarios such as "second killing", the pressure on the database operation on the host system has become increasingly prominent. According to the host database design, for each defined database table in the database, the system will automatically allocate a dedicated physical space, which we set as the database table space. The size of this space is limited by system settings and parameter definitions. For the maxim...

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 Applications(China)
IPC IPC(8): G06F11/30G06F11/32G06F16/22
CPCG06F11/302G06F11/3065G06F11/327G06F16/2282
Inventor 周湉王卓林晖陈诚
Owner INDUSTRIAL AND COMMERCIAL BANK OF CHINA
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