Database operation and maintenance method and device thereof

A database and operation and maintenance technology, applied in the field of data processing, can solve problems such as DBA's inability to respond in a timely manner, affect business, and system downtime, and achieve the effect of realizing automatic data operation and maintenance requirements, improving management efficiency, and improving work efficiency

Pending Publication Date: 2022-01-04
AOWANG INFORMATION TECH (XIAMEN) CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] After the database alarm is completed, the DBA needs to intervene to release the alarm. Generally, the core database of an enterprise needs to run 24 hours a day.

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 operation and maintenance method and device thereof
  • Database operation and maintenance method and device thereof
  • Database operation and maintenance method and device thereof

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0029] The following will clearly and completely describe the technical solutions in the embodiments of the present application with reference to the accompanying drawings in the embodiments of the present application. Obviously, the described embodiments are only some of the embodiments of the present application, not all of them. The components of the embodiments of the application generally described and illustrated in the figures herein may be arranged and designed in a variety of different configurations. Accordingly, the following detailed description of the embodiments of the application provided in the accompanying drawings is not intended to limit the scope of the claimed application, but merely represents selected embodiments of the application. Based on the embodiments of the present application, all other embodiments obtained by those skilled in the art without making creative efforts belong to the scope of protection of the present application.

[0030] It should ...

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 operation and maintenance method and a database operation and maintenance device, which are applied to a monitoring server and are used for executing the following processing on each monitored database client: establishing a monitoring channel between the monitoring server and the monitored database client, creating a monitoring task aiming at the monitored database client, and monitoring the monitored database client through the established monitoring channel, acquiring monitoring data corresponding to the monitoring task of the monitored database client, and judging whether the acquired monitoring data meets an automatic operation and maintenance triggering condition; and if the automatic operation and maintenance triggering condition is met, triggering an automatic operation and maintenance instruction, and sending the automatic operation and maintenance instruction to the monitored database client, so that the monitored database client executes an automatic operation and maintenance operation. By the adoption of the technical method, the system can achieve automatic operation and maintenance under the condition that a database administrator is absent, the situation that the database crashes due to the fact that processing is not conducted in time is solved, part of services are prevented from being affected, the availability and convenience of the system are improved, and the working efficiency is improved.

Description

technical field [0001] The present application relates to the technical field of data processing, in particular, to a database operation and maintenance method and a device thereof. Background technique [0002] In the database operation and maintenance work, the operation and maintenance of the database mainly depends on the third-party monitoring system or the tools of the database itself. For example, Oracle uses OEM (Oracle Enterprise Manager, database manager) for monitoring, and then sends an alarm when a problem occurs Information to DBA (Database Administrator, database administrator) for processing. [0003] After the database alarm is completed, the DBA needs to intervene to release the alarm. Generally, the core database of an enterprise needs to run 24 hours a day. The database cannot respond in time, which may cause the client to wait for a long time, affecting some services, or cause system downtime, affecting the use of all users. Contents of the invention ...

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/32
CPCG06F11/302G06F11/3051G06F11/327
Inventor 吴志强郭靖魏陈强吴有林
Owner AOWANG INFORMATION TECH (XIAMEN) CO LTD
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