Real-time monitoring system for database
A real-time monitoring and database technology, applied in the general control system, control/adjustment system, program control, etc., can solve the problems of high cost, data cannot be stored smoothly, and efficiency cannot be improved, so as to achieve the effect of improving work efficiency
Inactive Publication Date: 2009-06-24
INVENTECSHANGHAI TECH
View PDF0 Cites 1 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
However, since the existing practice does not have any mechanism for monitoring the database in the production line, if any problems occur in the production line, all the information will be conveyed by the production line personnel, and then fed back to the information service personnel (ISD) , so that the efficiency of problem solving cannot be improved, and a considerable cost is spent on the transmission of information
[0003] For example, the data in the production line is stored by the database, and the number of links available for access to the database usually maintains a certain number, so when each link wants to access the database at the same time, each link will wait for or occupy each other. Situations that lead to database deadlocks (deadlock)
At this time, the data on the production line cannot be stored smoothly, and the situation of database deadlock cannot be provided to the information service personnel in real time, so that the information service personnel can deal with it as soon as possible
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0017] The present invention proposes a database real-time monitoring system, which actively detects the running status of the production system and discovers potential problems early by monitoring the database in real time. In this way, the administrator can change from passively receiving information to proactively discovering problems, and can ensure the normal operation of the system in real time.
[0018] figure 1 It is a database real-time monitoring system according to the embodiment of the present invention. This database real-time monitoring system 100 is used to monitor the database 102, wherein the database 102 is used to store the data of the production line, and regularly transmit the data or reports that do not require high real-time performance of the production line to the backup and restoration server 104 for the backup and restoration server 104 performs data backup and restoration to reduce the pressure on the database 102 itself to store data, so that the ...
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
Login to View More Abstract
The invention discloses a database real-time monitoring system which comprises a warning device, a deadlock monitoring device and a work monitoring device. The deadlock monitoring device is connected with a database and the warning device and used for detecting the database; when the database is in the case of deadlock, the deadlock monitoring device sends out warning signals to a manager via the warning device; the work monitoring device is connected with the database and the warning device and used for detecting various work executors in process of saving the database; and when the deadlock monitoring device detects that the database is in the case of deadlock, the work monitoring device finds out the work executor which makes a mistake in the course of related data access or transmission, and sends out warning signals to the manager through the warning device. The system can transmit related information and problems of the database to the manager in a real-time manner, thereby helping the manager to rapidly solve the problems, and further improving the integrated work efficiency of the system.
Description
technical field [0001] The invention relates to a monitoring system, in particular to a database real-time monitoring system. Background technique [0002] Generally, for the production line of a factory, a database is usually set up to store the data of the production line. However, since the existing practice does not have any mechanism for monitoring the database in the production line, if any problems occur in the production line, all the information will be conveyed by the production line personnel, and then fed back to the information service personnel (ISD) , so that the efficiency of problem solving cannot be improved, and a considerable cost is spent on the transmission of information. [0003] For example, the data in the production line is stored by the database, and the number of links available for access to the database usually maintains a certain number, so when each link wants to access the database at the same time, each link will wait for or occupy each ot...
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
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G05B19/048
Inventor 孙珺龙建国
Owner INVENTECSHANGHAI TECH