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

Method for carrying out online monitoring on database server fault of convertor station control protection system

A control and protection, server technology, applied in database design/maintenance, structured data retrieval, electronic digital data processing, etc., can solve problems such as inability to effectively monitor database login failures, complex implementation, etc., to facilitate fault location, operation and maintenance. The effect of convenient maintenance work and saving recovery time

Active Publication Date: 2015-12-16
CHINA THREE GORGES UNIV
View PDF6 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This method is relatively complicated to implement, and cannot perform real-time fault tracking on the server
[0005] The Chinese patent "ORACLE Database Operation Monitoring System" (publication number CN: 102855319A) proposes a stored procedure that calls the server Trace through the sql language to complete the monitoring of database addition, modification and deletion. It is not effective Other failures such as login failures detected in the database

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 for carrying out online monitoring on database server fault of convertor station control protection system
  • Method for carrying out online monitoring on database server fault of convertor station control protection system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] A method for on-line monitoring of faults in a converter station control and protection system database server, which directly establishes stored procedures for server errors and warning events through sql language, and then directly calls the stored procedures in real time through a VisualBasic application program to obtain information about warning or error events, thereby achieving Quickly locate faults;

[0029] The specific steps and methods are as follows: the system will automatically search for all servers on the host, and provide the operator with the choice of the server to be monitored; the system connects to the server; judges whether the connection is successful; sets the information of the warning and error event data column, and tracks the warning and For error events, obtain warning and fault information; display the data column information of warning and error events, handle faults, save fault information, and complete the monitoring process. If no warn...

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

According to a method for carrying out online monitoring on a database server fault of a convertor station control protection system, a server fault and warning event storage process is directly established by an sql language, then the storage process is directly called in real time by a Visual Basic application and information of a warning or fault event is acquired so as to achieve rapid positioning on a fault. A system automatically searches all servers on a host, all the servers are provided for an operator and the operator selects a server which needs to be monitored; the system is connected with the server; connection is judged whether to be successful; information of a warning and fault event data column is set, a warning and fault event of the server is tracked and warning and fault information is acquired; and the data column information of the warning and fault event is displayed, the fault is processed and the fault information is stored so as to complete the monitoring process. According to the method disclosed by the present invention, the server fault and warning event storage process is directly established by the sql language, then the storage process is directly called in real time by the Visual Basic and the information of the warning or fault event is acquired so as to achieve rapid positioning on the fault.

Description

technical field [0001] The invention relates to an online fault monitoring method for a database server of a converter station control and protection system, which relates to the field of converter station monitoring. Background technique [0002] In the DC converter station system, the control and protection system of the DC converter station is closely coupled with the server. The failure of the server may cause the failure of the host computer, which directly affects the safe operation of the host system of the DC converter station. Any tool for server diagnosis can only be completed with the help of the event detector that comes with the server when it needs to monitor server failures. The event detector that comes with the server is a tool for fault monitoring of all SQL servers used. In order to meet different There are many types of events and the amount of information in each event data column. When the staff of the DC converter station needs to monitor the server, t...

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): G06F17/30G06F11/30
CPCG06F11/3034G06F16/21
Inventor 吉培荣曾怡陈诚张古月许国君
Owner CHINA THREE GORGES UNIV
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