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

Method and device for automatically collecting blockage information to facilitate post analysis on database blockage

An automatic collection and database technology, applied in the computer field, can solve the problems that traditional processing methods cannot achieve real-time analysis, complex implementation, and difficulty in capturing sufficient information

Inactive Publication Date: 2014-12-17
YONYOU UP INFORMATION TECH
View PDF4 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] In other words, traditional processing methods cannot achieve real-time analysis, so it is difficult to capture enough information when the problem recurs
For the existing patented technology, its implementation is complicated and the collection results need to be parsed from XML before analysis

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
  • Method and device for automatically collecting blockage information to facilitate post analysis on database blockage
  • Method and device for automatically collecting blockage information to facilitate post analysis on database blockage
  • Method and device for automatically collecting blockage information to facilitate post analysis on database blockage

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] In order to understand the above-mentioned purpose, features and advantages of the present invention more clearly, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments. It should be noted that, in the case of no conflict, the embodiments of the present application and the features in the embodiments can be combined with each other.

[0025] In the following description, many specific details are set forth in order to fully understand the present invention. However, the present invention can also be implemented in other ways different from those described here. Therefore, the protection scope of the present invention is not limited by the specific details disclosed below. EXAMPLE LIMITATIONS.

[0026] figure 1 A flow chart of a method for automatically collecting congestion information to facilitate subsequent analysis of database congestion according to an embodiment of the present invent...

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 provides a method for automatically collecting blockage information to facilitate post analysis on database blockage. The method comprises the following steps: adding a collection script to a to-be-analyzed database; opening a collection event of the to-be-analyzed database on the basis of the collection script added to the to-be-analyzed database; during the operation period of the to-be-analyzed database, automatically collecting data in accordance with preset collection conditions in the storage process when the blockage problem reoccurs, and recording the data. The invention also provides a device for automatically collecting the blockage information to facilitate the post analysis on the database blockage. According to the technical scheme, on the basis of an existing blockage information collecting and unblocking mode, a universal and unified collecting and unblocking idea for collecting and unblocking the blockage information of an application scene in the storage process is established by fully utilizing a mode of collecting and unblocking the blockage information by logically and reasonably organizing and storing the collected data as a two-dimensional data table in advance.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method for automatically collecting blocking information to facilitate subsequent analysis of database blocking and a device for automatically collecting blocking information to facilitate subsequent analysis of database blocking. Background technique [0002] The database is an important data storage unit in application software. If the database is blocked, the front end of the application program will not respond, and users will not be able to process business normally, seriously affecting the user experience. The database blocking phenomenon does not occur repeatedly, even if the blocking recurs, real-time analysis cannot be done due to the time factor, which makes it very difficult for DBAs to analyze the blocking phenomenon. [0003] In the existing patented technology, by setting the monitoring time and monitoring configuration parameters, the information is collected a...

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/30
CPCG06F11/3414G06F16/21
Inventor 张刚张红斌尹洪亮
Owner YONYOU UP INFORMATION TECH
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