TWM596408U - Database Resource Early Warning System - Google Patents

Abstract

A database resource early warning system includes multiple databases, a servo host and at least one operating device. The servo host is communicatively connected to the database and includes a monitoring module and a warning module. The monitoring module is adapted to monitor the database and generate multiple database resource usage information. The alert module is adapted to receive the database resource usage information, including multiple thresholds, and generates an alert message when the database resource usage information exceeds the threshold. The operation device is communicatively connected to the servo host, and is suitable for receiving and displaying the database resource usage information. Wherein, the operation device is also suitable for receiving the warning message.

Description

Database Resource Early Warning System

An early warning system, especially a database resource early warning system.

The database system is a system used by modern organizational units to store various data, which can be used for subsequent extraction and analysis. However, as the database is used for a long time, or the organizational unit grows and expands, the amount of data will gradually increase. A large amount of data is transferred in the database system, which will cause a burden to the system, which will lead to problems such as slow system speed or incomplete data transmission. For some organizational units, such as banking units, the transmission of data is very important. Once a problem occurs in the data system, it will have a serious impact. Therefore, the resource utilization status of the database system needs to be monitored to avoid problems caused by its excessive load. The traditional database monitoring system only collects the resource data of the database and displays it, allowing the monitoring personnel to browse these data. However, the meaning of these data needs to be judged by the monitoring personnel. Specifically, the status of the monitoring database cannot be effectively monitored, and the problems that may arise cannot be prevented. Therefore, how to monitor the database system more efficiently is worth considering by those with ordinary knowledge in the field.

This creation provides a database resource early warning system, which can automatically monitor the database system resource usage status, and provide warning, prediction, and improvement suggestions to improve the efficiency of database system monitoring. This creation provides a database resource early warning system, including multiple databases, a servo host and at least one operating device. The servo host is communicatively connected to the database and includes a monitoring module and a warning module. The monitoring module is adapted to monitor the database and generate multiple database resource usage information. The alert module is adapted to receive the database resource usage information, including multiple thresholds, and generates an alert message when the database resource usage information exceeds the threshold. The operation device is communicatively connected to the servo host, and is suitable for receiving and displaying the database resource usage information. Wherein, the operation device is also suitable for receiving the warning message. In the foregoing database resource early warning system, the server host further includes a prediction module adapted to receive resource usage information of the database and calculate a plurality of resource prediction information. In the above database resource early warning system, the operation device is adapted to receive and display the resource prediction information. In the foregoing database resource early warning system, the server host further includes an analysis module adapted to receive the database resource usage information and calculate multiple improvement suggestion messages. In the aforementioned database resource early warning system, the operation device is adapted to receive and display the improvement suggestion message. The aforementioned database resource early warning system further includes at least one mobile device, which is communicatively connected to the servo host and is suitable for receiving the warning message. In the aforementioned database resource early warning system, the warning message is sent to the operation device and the mobile device by email or push broadcast.

This creation provides a database resource early warning system, which can monitor the resource status of the database, predict the trend of the resource status through analysis and prediction, and provide warning and adjustment suggestions. Please refer to FIG. 1, which is a schematic diagram of a database resource early warning system for this creation. The database resource warning system 100 of the present invention includes a plurality of databases 110, a servo host 120, at least one operating device 130 and at least one mobile device 140. Among them, the servo host 120 is communicatively connected to the plurality of databases 110, and the operation device 130 and the mobile device 140 are communicatively connected to the servo host 120. In one embodiment, multiple data bases 110 are in communication with each other and can transfer data to each other. The database 110 is a database of different types and stores different data files. When the organizational unit uses these data, the data will be transferred between multiple databases 110. The servo host 110 is communicatively connected to these databases 110 and can monitor the data transmission status of these databases 110. In this embodiment, the servo host 120 includes a monitoring module 121, a warning module 122, a prediction module 123, and an analysis module 124. The monitoring module 121 is adapted to monitor multiple databases 110 and generate multiple database resource usage information. In other words, the monitoring module 121 monitors the status of data transmission and data usage among the databases 110, and converts the status of data transmission and data usage into quantitative data, such as data transmission volume, memory usage, and processor load Wait for the database resource usage information. The warning module 122 is adapted to receive database resource usage information, and the warning module 122 includes a plurality of thresholds. When the database resource usage information exceeds the threshold, a warning message is generated. In other words, the alert module 122 has set thresholds for different database resource usage information, such as data transfer threshold, memory usage threshold, and processor load threshold, etc. When the alert system receives a quantified database resource After using the information, it will determine whether the corresponding value exceeds the critical value. If it exceeds, a corresponding warning message is generated. The prediction module 123 is adapted to receive database resource usage information and calculate multiple resource prediction messages. In other words, the prediction module 123 can obtain various types of data according to the monitoring module 121 and use the data to predict the possible trend of database resource usage information through algorithms. For example, the possible changes in memory usage. The analysis module 124 is adapted to receive database resource usage information and calculate multiple improvement suggestion messages. The analysis module 124 determines the resource usage status of the database 110 according to various data obtained by the monitoring module 121, and calculates a suggestion message for improving the resource usage status of the database 110. For example, how to release memory usage. In an embodiment, the warning module 122 further includes a plurality of prediction thresholds. When the resource prediction information generated by the prediction module 123 exceeds the prediction threshold, a warning message is also generated. That is to say, if the database resource early warning system 100 predicts that the database system resource usage may exceed a critical value, an alert will be issued to notify the user. The operation device 130 is communicatively connected to the server host 120, and the operation device 130 is adapted to receive database resource usage information, warning information, resource prediction information, and improvement suggestion messages from the server host 120. In other words, the operating device 130 is a terminal device for the database resource early warning system 100 for the user to operate. The user can browse the operating status of the multiple databases 110 through the operating device 130 to grasp the actual status of each database 110. In this embodiment, the operating device 130 provides an interface equivalent to a dashboard to display database resource usage information. The user can further set the display method of the database resource usage information through the operation device 130. In a preferred embodiment, the operation device 130 can automatically adjust the display method of the database resource usage information by capturing the user's operation records, and display different data with priority according to the user's operation habits. And by receiving the warning information, resource prediction message and improvement suggestion message through the operation device 130, you can know whether the database 110 has a risk of error in the future, and you can eliminate and maintain the risk in advance according to the improvement suggestions given by the database resource early warning system 100. The database system is stable. In one embodiment, the operating device 130 is further adapted to input a threshold setting information, and the threshold setting information is sent to the warning module 122 of the server host 120, and the threshold of the warning module 122 is updated. Therefore, the user can set the threshold of different data through the operation device 130, that is, the user can set the threshold according to the system maintenance experience. The mobile device 140 is communicatively connected to the system host 120, and is adapted to receive information about the usage of the alert system and database resources. The mobile device 140 is, for example, a smart hand or a tablet computer. In addition to operating the device 130, the user can also use the mobile device 140 to alert the system and database resource usage information, that is, even if the user leaves the location, the mobile device 140 can also monitor the status of multiple databases 110, or Receive warning messages. The early warning of the database resource early warning system 100 is more real-time, and the user can receive the warning message at the first time, and make countermeasures. In one embodiment, the warning message is sent to the operation device 130 and the mobile device 140 by email or push broadcast. The database resource early warning system 100 of this creation monitors the resource usage status among multiple databases 110, and the alert module 122 of the server host 120 detects whether the resource usage status exceeds a critical value, and if it exceeds, a warning is issued to the user Messages, and warning messages can be sent to users via e-mail or push messages to achieve real-time warning. Further, the servo host 120 predicts the resource usage trend of the database 110 through the prediction module 123 and the analysis module 124, and provides an appropriate adjustment method so that the user has more reference data to adjust the operation of the database system. It can effectively improve the efficiency of database resource use control. This creation is described above with examples, but it is not intended to limit the scope of patent rights claimed in this creation. The scope of patent protection depends on the scope of the attached patent application and its equivalent fields. Anyone with ordinary knowledge in this field who makes changes or retouching without departing from the spirit or scope of this patent belongs to the equivalent change or design completed under the spirit disclosed in this creation, and shall be included in the scope of the following patent application Inside.

100: database resource early warning system 110: database 120: Servo host 121: Monitoring module 122: Warning module 123: Forecast module 124: Analysis module 130: operating device 140: mobile device

Figure 1 shows a schematic diagram of the database resource early warning system for this creation.

100: database resource early warning system

110: database

120: Servo host

121: Monitoring module

122: Warning module

123: Forecast module

124: Analysis module

130: operating device

140: mobile device

Claims (7)

A database resource early warning system, including: Multiple databases; A servo host, communication connected to the database, including: A monitoring module adapted to monitor the database and generate multiple database resource usage information; and An alert module, adapted to receive the database resource usage information, including multiple thresholds, and when the database resource usage information exceeds the threshold, generate an alert message; and At least one operating device, communicatively connected to the server host, suitable for receiving and displaying the database resource usage information; Wherein, the operation device is also suitable for receiving the warning message. The database resource early warning system as described in item 1 of the patent application scope, wherein the servo host further includes a prediction module adapted to receive resource usage information of the database and calculate a plurality of resource prediction information. The database resource early warning system as described in item 2 of the patent application scope, wherein the operation device is adapted to receive and display the resource prediction information. The database resource early warning system as described in item 1 of the patent application scope, wherein the servo host further includes an analysis module adapted to receive the database resource usage information and calculate a plurality of improvement suggestion messages. The database resource early warning system as described in item 4 of the patent application scope, wherein the operation device is adapted to receive and display the improvement suggestion message. The database resource early warning system as described in item 1 of the patent application scope, which further includes at least one mobile device, is communicatively connected to the servo host, and is suitable for receiving the warning message. The database resource early warning system as described in item 6 of the patent application scope, wherein the warning message is sent to the operation device and the mobile device by email or push broadcast.

Images