200525344 玖、發明說明: 【發明所屬之技術領域】200525344 发明, Description of the invention: [Technical field to which the invention belongs]
本發明係關於一種資舰7¾ M 抖庫i控及問題自動回報系統,特 別是指一種利用程式語言監抑祖 口 I &貝枓庫運作狀況,紀錄並能自 動使用訊息回報之資料庫監批 【先前技術】 庫皿控及問喊自動回報系統。 隨著科技曰益發達,各企業為有效掌控其企業資料,資 枓庫之設置以不可或缺,但隨著資料曰益繁多,資料庫的管 理已成為企業所需解決之問題’因資料庫係許多大型資訊系 統的核心,資料庫運作的順暢與否關係著整個資訊系統的成 敗,以往資料庫監控係依靠資料庫管理員(Da—The present invention relates to an automatic reporting system for the control and problem of a 7¾ M jitter library in a capital ship, and particularly to a database monitor that uses a programming language to monitor the operating status of the ancestral I & Beyer library, and records and can automatically use message reporting. Batch [prior art] Tray control and questioning automatic reporting system. With the development of science and technology, in order to effectively control their corporate data, the establishment of the asset database is indispensable. However, with the increasing amount of information, the management of the database has become a problem that enterprises need to solve. It is the core of many large information systems. The smooth operation of the database is related to the success of the entire information system. In the past, the database monitoring system relied on the database administrator (Da-
Admini福。r,DBA)每日查冑各項㈣庫數據加以紀錄及調 整’亦或者使用監控軟體由遠端網路連線進入資料庫,笼集 並紀錄資料庫數據;雖然上述之方式可達成所需之要求,:曰 兩種方式其—需㈣人力’使得人事成本增加另—則需額 外添購硬體設備’且於網路不穩定時無法立即取得資料庫數 據,甚為不便。 由此可見,上述習用系統仍有諸多缺失,實非一良善之 設計者,而亟待加以改良。 ^Admini Fu. r, DBA) daily check all database data to record and adjust 'or use monitoring software to access the database from a remote network connection, collect and record database data; although the above method can achieve the required The requirements are as follows: There are two ways—there is a need for manpower, which increases personnel costs, and it requires additional hardware equipment. When the network is unstable, the database data cannot be obtained immediately, which is very inconvenient. It can be seen that there are still many shortcomings in the conventional system, which is not a good designer and needs to be improved urgently. ^
本案發明人鑑於上述習用系統所衍生的夂$ A 7生的各項缺點,乃亟 思加以改良創新,並經多年苦心孤詣潛 曰、研究後,終於成功 研發完成本件資料庫監控及問題自動回報系统。 【發明内容】 'In view of the various shortcomings of the above-mentioned conventional system, the inventor of this case was eager to improve it and innovate. After years of hard work and research, he finally successfully developed the database monitoring and automatic problem reporting system. . [Summary of the invention] ''
本發明之目的即在於提供一種中長期資料^ | 並利用資料進行中長期分析β作為參數調整 運行資料紀 之依據,使 200525344 動回報系 資料庫運行更為穩定順暢之資料庫監控及問題自 統 本1¾月之夂目的係在於提供一種可使資料庫管理員及 使用者能預先了解問題並加以解決,避免資料庫有無法運作 情形發生之資料庫監控及問題自動回報系統。 本么月之3目的係在於提供一種可力口速解決問題的反 應時間及減少人為疏失之資料庫監控及問題自動回報系統。 本發明之又一目的係在於提供一種可大幅提高資料庫 監啦效率及效果之資料庫監控及問題自動回報系統。 -種貧料庫監控及問題自動回報系統,係則資料庫内 建程式語言(storeprocedure)撰寫,其主要包含有一即時監控模 組、定時監控模組、訊息模組、紀錄模組及設定模組,使用 者可藉由設定模組將監控之項目、數據範圍、回報時間、回 報項目、使用者資訊及吨方式等資料域至系統中,即時 監控模組及定時監控模組則由資料庫中取得監控項目及運 行數據後’將資料送至紀錄模組及訊息模組,紀錄模組則將 資料紀錄在資料庫中,提供未來分析㈣之用,訊息模組則 讀取使用者資訊,將報表或訊息依照設定方式發送給使用者 (如:電子料、簡訊 '螢幕顯示等),使其主動發出訊息 回報給減之使用者或資料庫管理員並加以紀錄,預先了解 問題達到維持資料庫安全I運作㈣之目的。 【實施方式】 200525344 請參閱圖一所示,為本發明所提供之資料庫監控及問題 自動回報系統之模組關係示意圖,其主要包含有: & 一設定模組1,該設定模組丨係設定系統監控項目及範圍 12、監控方式及時間、使用者資訊及訊息發送方式η等資 料,且能隨時新增、刪除各類資料並立即生效, 二 活度; 攸阿糸統簠 Λ息模組2,該訊息模組2係依據各個使用者所設定之 接收方式(包含電子郵件、簡訊、螢幕顯示等),發出^定訊 息回報給指定之使用者或資料庫管理員6 ; 一紀錄模組3,該紀錄模組3係紀錄數據及報表於資料庫 或囀案中,並指派單一編號以供未來訊息; 、 一即時監控模組4,該即時監控模組4係隨時監控資料庫 内特定運行數據’若其數據超出設定之範圍,則藉由訊息模 .組1將報表發送至使用者或資料庫管理員6; —一定時監控模組5,該定時監控模組5係依據使用者設定 之監控項目,定期蒐集資料庫運行數據7,藉由紀錄模組3將 數據儲存於貝料庫内,再藉由訊息模組2將報表發送至使用 者或資料庫管理員6 ; 使用者可藉由设定模組丨將監控的項目、數據範圍、回報 時間、回報項目、使用者資訊及回報方式等資料記錄至系統 中即時監控模組4及定時監控模組5則由資料庫中取得監控 項目及運行數據後,將資料送至紀錄模組3及訊息模組2中; 汛息杈組2則讀取使用者資訊,將報表或訊息依照設定方式 I达給使用者;使其得以有效加強資料庫維運監控之功能, 200525344 強化資料庫運作的安 減低資料庫管理員的負擔及人為疏失 全與順暢。 明食_二所示’為本發明所提供之資料庫監控及問題 動回報系統之定時監控模組流程圖,其係由使用者訂定監 控項目相報時間’在資料庫端定時啟動,在啟動之後,首 先將曰先項取使用者所訂定之監控項目及順序資料2卜再讀 取資料數據22(包含資料庫參數、記憶體使用、磁碟使用、 使用者&理等等),待所有數據皆讀取並送至紀錄模組3储 存後,取得准-編號併人報表23中,再送至訊息模組2將報 表23依使用者所設定方式發送;其主要目的在於資料庫定期 檢查及E集資料庫運行數據,提供日後分析,作為效能或資 源分配等參數的調整依據。 * •命 明參閱圖二所不,為本發明所提供之資料庫監控及問題 自動回報系統之即時監控模組流程圖,其係由使用者訂定監 控項目及數據範圍,在資料庫啟動的同時也一併啟動即時監 控杈組;本模組將先讀取監控項目及數據範圍31,再讀取資 料庫數據32送至紀錄模組3儲存並加以比對,若超過設定之 範圍則將此資訊送至訊息模組2發送給使用者;其主要的使 用目的在於資料庫障礙偵測,可於第一時間通報設定人員處 理,加強資料庫安全性及穩定性。 請參閱圖四所示,為本發明所提供之資料庫監控及問題 自動回報系統之訊息模組流程圖,在啟動時先讀取訊息或報 表及使用者資訊41,將傳入的報表或訊息依據使用者設定方 200525344 式發送42,提供多樣化的發送方式,傳送訊息至指定的人 員,並可連接其他系統達到自動化管理的目的。 請參閱圖五所示,為本發明所提供之資料庫監控及問題 自動回報系統之紀錄模組流程圖,在啟動時將傳人的報表或 訊息加入唯一編f虎51後,储存於資料庫或檔案中,提供 來查閱及分析之基礎。 μ 本發明所提供之資料庫監控及問題自動回報㈣,與其 他習用系統相互比較時,更具有下列之優點·· 1.本發明彳即時主動監控資料庫運行狀況,並自動以訊息 回報資料庫管理員,且不需額外硬體設備。 “ 1本發明可在資料庫發生問題時’第—時間利用預先設定 之方式通報管理人員。 。3.本發明可由使用者自動監控項目、監控時間及回報方 式,儲存於資料庫表格中,可隨時增刪修改並立即生效,提 高系統靈活度及可用性。 4.本發明可紀錄資料庫運行數據,並定時產生報表,提供 未來效能調整之用。 上列詳細說明係針對本發明之一可行實施例之具體說 明,惟該實施例並非用以限制本發明之專利範圍,凡未脫離 本發明技藝精神所為之等效實施或變更,均應包含於本案之 專利範圍中。 ^ 綜上所述,本案不但在技術思想上確屬創新,並能較習 用系統增進上述多項功效,應已充分符合新穎性及進步性之 法定發明專利要件,爰依法提出",料#局核准本件 發明專利申請案,以勵發明,至感德便。 200525344 【圖式簡單說明】 請參閱以下有關本發明一較佳實施例之詳細說明及其附 圖,將可進一步瞭解本發明之技術内容及其目的功效;有關 該實施例之附圖為: 圖為本發明資料庫監控及問題自動回報系統之模組關 係示意圖; 圖一為本發明資料庫監控及問題自動回報系統之定時監 控模組流程圖; 圖二為本發明資料庫監控及問題自動回報系統之即時監 _ 控模組流程圖; 圖四為本發明資料庫監控及問題自動回報系統之訊息模 組流程圖;以及 圖五為本發明資料庫監控及問題自動回報系統之紀錄 模組流程圖。 【主要部分代表符號】 > 1設定模組 11使用者資訊及訊息發送方式 12監控項目及範圍 2訊息模組 21監控項目及順序資料 22讀取資料庫數據 23報表 3紀錄模組 31監控項目及數據範圍 10 200525344 32資料庫數據 4即時監控模組 41讀取訊息或報表及使用者資訊 42依據使用者設定方式發送 5定時監控模組 51報表或訊息加入唯一編號 6使用者或資料庫管理員 7資料庫運行數據The purpose of the present invention is to provide a medium-to-long-term data ^ | and use the data for medium-to-long-term analysis β as a parameter to adjust the operating data discipline to make 200525344 dynamic reporting system more stable and smooth database monitoring and problem autonomy. The purpose of the month of January is to provide a database monitoring and automatic reporting system that enables database administrators and users to understand and resolve problems in advance, and to prevent the database from malfunctioning. The third objective of this month is to provide a database monitoring and automatic problem reporting system that can solve problems at a rapid pace and reduce human error. Another object of the present invention is to provide a database monitoring and automatic problem reporting system that can greatly improve the efficiency and effectiveness of database monitoring. -A kind of poor material warehouse monitoring and automatic problem reporting system, written in the database's built-in programming language (storeprocedure), which mainly includes a real-time monitoring module, timing monitoring module, message module, recording module and setting module , Users can set the monitored items, data range, report time, report items, user information, and ton way into the system by setting the module. The real-time monitoring module and timing monitoring module are stored in the database. After obtaining the monitoring items and operating data, the data is sent to the recording module and the message module. The recording module records the data in the database for future analysis. The message module reads user information and The report or message is sent to the user according to the setting method (such as: electronic materials, text messages, screen display, etc.), so that he or she can actively send a message to the reduced user or database administrator and record it, and understand the problem in advance to maintain the database The purpose of safe operation. [Embodiment] 200525344 Please refer to FIG. 1, which is a schematic diagram of the module relationship of the database monitoring and automatic problem reporting system provided by the present invention, which mainly includes: & a setting module 1, the setting module 丨Set system monitoring items and scope 12, monitoring method and time, user information and message sending method η and other data, and can add, delete various types of data at any time and take effect immediately, two activities; Module 2, the message module 2 is based on the receiving method set by each user (including e-mail, text messages, screen display, etc.), send a ^ message to the designated user or database administrator 6; a record Module 3, the recording module 3 records data and reports in a database or case, and assigns a single number for future information; a real-time monitoring module 4, which monitors the database at any time Within the specific operating data 'If the data exceeds the set range, the report is sent to the user or the database manager 6 through the message module. Group 1-monitoring module 5 at a certain time, the timing The control module 5 collects the database operation data 7 according to the monitoring items set by the user, stores the data in the shell material database through the recording module 3, and sends the report to the user through the message module 2. Database manager 6; users can record the monitored items, data range, report time, report items, user information and report methods to the system by real-time monitoring module 4 and regular monitoring by setting the module Module 5 obtains the monitoring items and operating data from the database, and sends the data to record module 3 and message module 2. The flood information branch group 2 reads user information, and reports or messages according to the setting method I reach users; it can effectively strengthen the function of database maintenance and monitoring. 200525344 Strengthen the security of database operation and reduce the burden on database administrators and human error. Mingshi_Second 'is a flowchart of the timing monitoring module of the database monitoring and problem reporting system provided by the present invention, which is set by the user to set the reporting time of the monitoring items. After startup, firstly take the monitoring items and sequence data set by the user first, and then read the data 22 (including database parameters, memory use, disk use, user & management, etc.), After all the data is read and sent to the record module 3 for storage, obtain the quasi-number and merge it into the report 23, and then send it to the message module 2 to send the report 23 in the way set by the user; its main purpose is to regularly store the database Check and run data of the E-set database to provide future analysis as a basis for adjusting parameters such as efficiency or resource allocation. * • Mingming refer to Figure 2 for the real-time monitoring module flowchart of the database monitoring and automatic problem reporting system provided by the present invention, which is set by the user to set monitoring items and data ranges and is started in the database. At the same time, the real-time monitoring branch group is also started; this module will first read the monitoring items and data range 31, and then read the database data 32 and send it to the recording module 3 for storage and comparison. If it exceeds the set range, it will This information is sent to the message module 2 and sent to the user; its main purpose is to detect the obstacles in the database, and it can be notified to the setting personnel for processing at the first time to enhance the security and stability of the database. Please refer to Figure 4, which is a flowchart of the message module of the database monitoring and automatic problem reporting system provided by the present invention. At startup, the message or report and user information 41 are read first, and the incoming report or message is imported. According to the user-set method 200525344, the sender 42 provides a variety of sending methods, sends messages to designated personnel, and can be connected to other systems for the purpose of automated management. Please refer to Figure 5, which is a flowchart of the recording module of the database monitoring and automatic problem reporting system provided by the present invention. At the time of startup, the report or message transmitted by the user is added to the unique editor 51 and stored in the database or The file provides the basis for inspection and analysis. μ The database monitoring provided by the present invention and automatic report of problems ㈣, when compared with other conventional systems, it has the following advantages ... 1. The present invention 彳 real-time and active monitoring of the operating status of the database, and automatically report the database with information Administrator, and no additional hardware is required. "1 The present invention can notify the management personnel in the first time when a problem occurs in the database. 3. The present invention can automatically monitor the project by the user, the monitoring time and the return method, stored in the database table, can be Modifications are added at any time and take effect immediately, improving system flexibility and usability. 4. The present invention can record the operating data of the database and generate reports on a regular basis to provide future performance adjustments. The detailed description above is directed to one of the feasible embodiments of the present invention Specifically, this embodiment is not intended to limit the patent scope of the present invention, and any equivalent implementation or change that does not depart from the technical spirit of the present invention should be included in the patent scope of this case. ^ In summary, this case Not only is it technically innovative, but it can also enhance the above-mentioned multiple effects compared with conventional systems. It should have fully met the requirements for statutory invention patents that are novel and progressive. To inspire the invention, to the sense of virtue. 200525344 [Brief description of the diagram] Please refer to the following comparison of the present invention. The detailed description of the embodiment and the accompanying drawings will further understand the technical content of the present invention and its purpose and effectiveness. The drawings related to this embodiment are: The diagram is a schematic diagram of the module relationship of the database monitoring and automatic report system of the present invention. Figure 1 is a flowchart of the timing monitoring module of the database monitoring and automatic problem reporting system of the present invention; Figure 2 is a flowchart of the real-time monitoring and control module of the database monitoring and automatic problem reporting system of the present invention; Figure 4 is the present invention Information module flowchart of the database monitoring and automatic problem reporting system; and Figure 5 is a flowchart of the recording module of the database monitoring and automatic problem reporting system of the present invention. [Main part representative symbols] > 1 setting module 11 use Information and message sending methods 12 monitoring items and ranges 2 message modules 21 monitoring items and sequence data 22 reading database data 23 reports 3 recording modules 31 monitoring items and data ranges 10 200525344 32 database data 4 real-time monitoring modules 41 Read messages or reports and user information 42 Send according to user settings 5 Scheduled monitoring module 51 Report or Interest to join a unique number 6 user or database administrator to run the data repository 7