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

List-based database monitoring method and list-based database monitoring device

A database, new table technology

Active Publication Date: 2014-06-25
HANDAN BRANCH OF CHINA MOBILE GRP HEBEI COMPANYLIMITED
View PDF7 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0010] When the performance of the database deteriorates, there is no effective monitoring method for the extent dispersion of frequently accessed small tables

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
  • List-based database monitoring method and list-based database monitoring device
  • List-based database monitoring method and list-based database monitoring device
  • List-based database monitoring method and list-based database monitoring device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0032] The specific embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings, but it should be understood that the protection scope of the present invention is not limited by the specific embodiments.

[0033] figure 1 It shows the composition structure of general tables (tables without clustering and fragmentation) in the database.

[0034] The specific instructions are as follows:

[0035] Table (table): used to store data. In the absence of clustering and partitioning, a table is generally composed of a storage segment (segment).

[0036] Segment: The data occupying storage space is an object, such as a table, index, rollback segment, etc. A segment consists of one or more extents.

[0037] Extended range (extent): It is a logically contiguous allocated space, and the extent is composed of logically contiguous blocks or pages.

[0038] Block or page (block or page): It is the smallest space allocation unit in th...

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 list-based database monitoring method and a list-based database monitoring device. The method includes colleting extension interval information of a to-be-monitored list, and acquiring a current index value of extension interval dispersion degree of a single list according to the extension interval information; comparing the current index value of the extension interval dispersion degree with an normal value of the extension interval dispersion degree of the single list; if the current index value is not less than the normal value, determining that the to-be-monitored list is in a normal state; if the current index value is less than the normal value, comparing the current index value of the extension interval dispersion degree with the a deterioration value of the extension interval dispersion degree of the single list; if the current index value is not less than the deterioration value, determining that problems exist in the to-be-monitored list; and if the current index value is less than the deterioration value, subjecting the to-be-monitored list to structure reconstruction and optimization. By the method and the device, the continuity of internal blocks or pages of database lists and database operating performance based on the lists are improved, effective monitoring and repairing of database performance are realized, and realization of the database performance is guaranteed.

Description

technical field [0001] The invention relates to the technical field of databases in the communication field, in particular to a table-based database monitoring method and device. Background technique [0002] At present, the database is already the core of most IT applications. With the development of multi-layer architecture and SOA, the application logic has been moved forward. At this time, the performance requirements of the database become more prominent compared with its functions. Therefore, improving the performance of the database and its monitoring means is a major problem at present. [0003] At present, online transaction processing application systems mainly use relational databases. With the advent of the data era, the amount of data is increasing year by year, the database is growing at TB level, and the applications are becoming more and more complex. Generally, the database application system basically meets the system requirements at the initial stage of l...

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): G06F17/30G06F11/34
CPCG06F11/3409G06F16/2282
Inventor 付永振李京红魏春来杨朝晖刘艳青
Owner HANDAN BRANCH OF CHINA MOBILE GRP HEBEI COMPANYLIMITED
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