1240860 玖、發明說明： 【發明所屬之技術領域】 本發明係關於-種資料庫監控及問題自動回報系统存 別是指-種利用程式語言監控資料庫運作狀況，紀錄並能自 動使用訊息回報之資料庫監控及問題自 【先前技術】 *糸、4。 隨著科技日益發達’各企業為有效掌控其企業資料 料庫之設置以不可或缺’但隨著資料曰益繁多，資：庫的; 理已成為企業所需解決之問題，因資料庫係許多大型 :的核心，資料庫運作的順暢與否關係、著整個資訊系統的威 敗’以往貢料庫監控像依靠資料庫管理員（ Adimmstrator，DBA)每日查看各項資 敕卄+ 土 Ah CO 、犀數據，加以紀錄及調 :，亦或者❹監㈣體由遠端網路連線進 等 庫;據·，上述之方式可達成所需之Li 冰 高耗費人力，使得人事成本增加，另—則需額 外添賭硬體設備’且於網路 ::: 據，甚為不便。 U立即取侍貧料庫數 由此可見，上述習用系統仍有諸多缺失 設計者，而亟待加以改良。 良^ 田力於上述f用系統所衍生的各項缺點，乃 心加以改良創新，並經多年苦 研發完成本件資料庫π及⑽以'明究後，終於成 【發明内容】科庫皿控及問喊自動回報系統。1240860 发明 Description of the invention: [Technical field to which the invention belongs] The present invention relates to-a kind of database monitoring and automatic reporting system storage refers to-a program language to monitor the operation of the database, record and automatically use information to report Database monitoring and problems from [prior art] * 糸, 4. With the development of science and technology, it is indispensable for enterprises to effectively control the setting up of their corporate data bases. However, with the increasing amount of data, data: database and management have become a problem that enterprises need to solve. Many large-scale: the core, whether the database is running smoothly or not, and the failure of the entire information system. CO and rhino data are recorded and adjusted: or the monitoring body is connected to a remote database via a remote network; according to the above method, the required Li-ice consumption can be achieved with high labor and labor costs, increasing personnel costs. In addition-you need to bet on hardware equipment and it is very inconvenient in the Internet ::. U immediately takes the number of poor materials warehouses It can be seen that the above-mentioned conventional system still has many missing designers, and needs to be improved urgently. Good ^ Tian Li made improvements and innovations in the above-mentioned shortcomings derived from the above-mentioned system. After years of hard work, he completed this database π and ⑽ ', and finally became [invention content]. Ask and shout automatic reporting system.
本發明之目的即在於提供一 並利用資料進行中長期分析 種中長期資料庫運行資料紀 ’作為參數調整之依據，使 1240860 貝料庫運行更為穩定順暢之f料庫監控及問題自動回報系 統。 本發明之次一目的係在於提供一種可使資料庫管理員及 使用者能預先了解問題並加以解決，避免㈣庫有無法運作 情形發生之資料庫監控及問題自動回報系統。 本發明之另—目的係在於提供-種可加速解決問題的反 應’間及減少人為疏失之資料庫監控及問題自動回報系統。 本發月之又目的係在於提供一種可大幅提高資料庫 監控效率及效果之資料庫監控及問題自動回報系統。 -種貧料庫監控及問題自動回報系統，係利用資料庫内 建程式語言(Store Procedure)撰寫’其主要包含有一即時監控模 組、定時監控模組、訊息模組、紀錄模組及設㈣組，使用 者可藉由妓模組將監控之項目、數據範圍、回報時間、回 報項目、使用者資訊及回報方式等資料紀錄至系統中，即時 監控模組及定時監控模組則由資料庫中取得監控項目及運 行數據後，將資料送至紀錄模組及訊息模組，紀錄模組則將 資料紀錄在資料庫中，提供未來分析查Hu模組則 §買取使用者資訊’將報表或訊息依照設定方式發送給使用者 (如：電子郵件、簡訊、螢幕顯示等），使其主動發出訊息 回報給指定之使用者或資料庫管理員並加以紀錄，預先了解 問題達到維持資料庫安全及運作順暢之目的。 【實施方式】 1240860 及問題 ΰ月參閱圖一所不，為本發明所提供之資料庫監控 動回報系統之模組關係示意圖，其主要包含有·· 一設定模組1， 12、監控方式及時 料，且能隨時新增 活度； 該設定模組1係設定系統監控項目及範圍 間、使用者資訊及訊息發送方式1 1等資 •刪除各類資料並立即生*，提高系統= 一訊息模組2，該訊息模組2係依據各個使用者所設定之 :收方式(包含電子郵件、簡訊、螢幕顯示‘等)，發出特定訊 心回報給指定之使用者或資料庫管理員6 ; • 一紀錄模組3，該紀錄模組3係紀錄數據及報表於資料庫 或檔案中，並指派單一編號以供未來訊息； 一即時監控模組4，該即時監控模組4係隨時監控資料庫 内特疋運行數據，若其數據超出設^之範圍，則藉由訊息模 組1將報表發送至使用者或資料庫管理員6; 一定時監控模組5，該定時監控模組5係依據使用者設定 之監控項目，定期荒集資料庫運行數據7,藉由紀錄模組3將 數據儲存於資料庫内，再藉由訊息模組2將報表發送至使用 者或資料庫管理員6 ; 士使用者可藉由設定模組1將監控的項目、數據範圍、回報 ¥間、回報項目、使用者資訊及回報方式等資料記錄至系統 中，即時監控模組4及定時監控模組5則由資料庫中取得監控 頁目及運行數據後，將資料送至紀錄模組3及訊息模組2中； …模組2則碩取使用者資訊，將報表或訊息依照設定方式 I送&使用者，使其得以有效加強資料庫維運監控之功能， 1240860 減低資料庫管理員的負擔及人為疏失，強化詞庫運作 全與順暢。 ‘ 清參閱圖二所示，為本發明所提供之資料庫監控及問題 自動回報系統之定時監控模組流程圖，其係由使用者訂定龄 控項目及回報時間’在資料庫端料啟動，在啟動之後，首 先f會先讀取使用者所料之監控項目及順序資料21，再讀 取貧料庫數據22(包含資料庫參數、記憶體使用、磁碟使用、 使用者官理等等），待所有數據皆讀取並送至紀錄模組3儲 存後’取得唯-編號併入報表23中，再送·至訊息模組2將報 表』3錢用者所設定方式發送；其主要目的在於資料庫定期 檢查及1集資料庫運行數據，提供日後分析，作為效能或資 源分配等參數的調整依據。 、 叫參閱圖三所示，為本發明所提供之資料庫監控及問題 自動回報系統之即時監控模組流程圖，其係由使用者訂定監 控項目及數據範圍，在資料庫啟動的同時也_併啟動即時監 控模組，本模組將先讀取監控項目及數據範圍Μ，再讀取資 料庫數據32送至紀錄模組3儲存並加以比對，若超過設定之 範圍則將此資訊送至訊息模組2發送給使用者；其主要的使 用目的在於資料庫障礙偵測，可於第一時間通報設定人員處 理’加強資料庫安全性及穩定性。 請參閱圖四所示，為本發明所提供之資料庫監控及問題 自動回報系統之訊息模組流程圖，在啟動時先讀取訊息或報 表及使用者資訊41，將傳入的報表或訊息依據使用者設定方 1240860 ，發送42，S供多樣化的發送方&，傳送訊息至指定的人 員，亚可連接其他系統達到自動化管理的目的。 睛參閱圖五所示，為本發明所提供之資料庫監控及問題 自動回報系統之紀錄模組流程圖，在啟動時將傳入的報表或 戒息加入唯-編號51後，儲存於資料庫或槽案中，提供未 來查閱及分析之基礎。 本發明所提供之資料庫監控及問題自動回報系統，與其 他習用系統相互比較時，更具有下列之優點： 一 /、 1·本發明可即時主動監控資料庫運行狀況，並自動以訊息 回報資料庫管理員，且不需額外硬體設備。 “ 〜2·本發明可在資料庫發生問題時，第一時間利用預先設定 之方式通報管理人員。 3·本發明可由使用者自動監控項目、監控時間及回報方 儲存於資料庫表袼中5可隨時增刪修改並立即生效，提 高系統靈活度及可用性。 4 ·本發明可紀錄資料庫運行數據，並定時產生報表，提供 未來效能調整之用。 、 上列詳細說明係針對本發明之一可行實施例之具體說 明’惟該實施例並非用以限制本發明之專利範圍，凡未脫離 本1月技藝精神所為之等效實施或變更，均應包含於本案之 專利範圍中。 /紅上所述，本案不但在技術思想上確屬創新，並能較習 用^統增進上述多力效’應、已充分符合新穎性及進步性之 法定發明專利要件，爰依法提出中請，懇％貴局核准本件 發明專利申請案，以勵發明，至感德便。 1240860 【圖式簡單說明】 凊茶閱以下有關本發明一較佳實施例之詳細說明及其附 圖，將可進一步暸解本發明之技術内容及其目的功效；有關 該實施例之附圖為： ^圖一為本發明資料庫監控及問題自動回報系統之模組關 係示意圖； 圖二為本發明資料庫監控及問題自動回報系統之定時監 控模組流程圖； 圖三為本發明資料庫監控及問題自動回報系統之即時監 控模組流程圖； ' 圖四為本發明資料庫監控及問題自動回報系統之訊東 組流程圖；以及 Λ 4圖五為本發明資料庫監控及問題自動回報系 模組流程圖。 、〜 【主要部分代表符號】 1設定模組 11使用者資訊及訊息發送方式 12監控項目及範圍 2訊息模組 21監控項目及順序資料 22讀取資料庫數據 23報表 3紀錄模組 31監控項目及數據範圍 1240860 32資料庫數據 4即時監控模組 41讀取訊息或報表及使用者資訊 42依據使用者設定方式發送 5定時監控模組 51報表或訊息加入唯一編號 6使用者或資料庫管理員 7資料庫運行數據The purpose of the present invention is to provide a medium-to-long-term analysis of the use of data in the long-term and long-term database operation data records as a basis for parameter adjustment, to make the 1240860 shell material warehouse operation more stable and smooth. . A second object of the present invention is to provide a database monitoring and automatic reporting system that enables database administrators and users to understand and solve problems in advance, and to prevent the database from malfunctioning. Another object of the present invention is to provide a database monitoring and automatic problem reporting system that can speed up the response to problem solving and reduce human error. Another purpose of this month 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 library monitoring and automatic problem reporting system, which is written using the database's built-in programming language (Store Procedure), which mainly includes a real-time monitoring module, a timing monitoring module, a message module, a recording module and settings. Users can use the prostitute module to record the monitored items, data range, reporting time, reporting items, user information and reporting methods into the system, and the real-time monitoring module and timing monitoring module are stored in the database. After obtaining monitoring items and operating data, the data will be sent to the recording module and the message module. The recording module will record the data in the database and provide future analysis. Check the Hu module. § Buy user information. The message is sent to the user according to the setting method (such as email, text message, screen display, etc.), so that he can actively send a message to the designated user or database administrator and record it, and understand the problem in advance to maintain the security of the database and The purpose of smooth operation. [Embodiment] 1240860 and the problem month, please refer to Figure 1. It is a schematic diagram of the module relationship of the database monitoring and reporting system provided by the present invention, which mainly includes a setting module 1, 12, and the monitoring method is timely. Data, and can add activity at any time; The setting module 1 is to set system monitoring items and ranges, user information and message sending methods 1 1 etc. • Delete all types of data and generate them immediately *, improving the system = one message Module 2, the message module 2 is based on the settings set by each user: receiving method (including email, text message, screen display, etc.), sends a specific message to the designated user or database administrator 6; • A recording module 3, which records data and reports in a database or file, and assigns a single number for future information; a real-time monitoring module 4, which monitors data at any time Cunette is running data. If the data exceeds the set range, the report is sent to the user or the database manager 6 through the message module 1. The monitoring module 5 is a certain time, and the timing monitoring module 5 is a system. according to According to the monitoring items set by the user, the database is regularly collected to run the data7. The data is stored in the database through the recording module 3, and the report is sent to the user or the database administrator through the message module 2. ; Taxi users can record the monitored items, data range, reported items, reported items, user information and reporting methods into the system by setting module 1, real-time monitoring module 4 and timing monitoring module 5 After the monitoring page and running data are obtained from the database, the data is sent to the record module 3 and the message module 2;… Module 2 obtains the user information and sends the report or message according to the setting method ; The user, so that it can effectively strengthen the database maintenance operation monitoring function, 1240860 reduces the burden on the database administrator and human error, and strengthens the full and smooth operation of the thesaurus. '' Please refer to Figure 2 for a flowchart of the timing monitoring module of the database monitoring and automatic problem reporting system provided by the present invention, which is set by the user to set age control items and reporting time. After starting, f will first read the monitoring items and sequence data 21 expected by the user, and then read the lean database data 22 (including database parameters, memory use, disk use, user management, etc.) Etc.) After all the data is read and sent to the record module 3 for storage, 'Get the unique number and merge it into the report 23, and then send to the message module 2 to send the report' 3 ways set by the user; its main The purpose is to regularly check the database and run a set of database data to provide future analysis as a basis for adjusting parameters such as efficiency or resource allocation. Refer to Figure 3, which is a flowchart of the real-time monitoring module of the database monitoring and automatic problem reporting system provided by the present invention. The monitoring items and data range are set by the user. _ And start the real-time monitoring module. This module will first read the monitoring items and data range M, 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, this information It 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 to deal with it at the first time to strengthen 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 setting party 1240860, send 42, S for a variety of senders & send messages to the designated personnel, Yaco can connect other systems to achieve the purpose of automated management. See Figure 5 for a flow chart of the recording module of the database monitoring and automatic problem reporting system provided by the present invention. At startup, the incoming report or withdrawal is added to the Wei-No. 51 and stored in the database. In case or case, provide the basis for future inspection and analysis. The database monitoring and problem automatic reporting system provided by the present invention has the following advantages when compared with other conventional systems: 1. / 1. The present invention can actively and actively monitor the operating status of the database and automatically report data with information Librarians and no additional hardware equipment required. "~ 2 · The present invention can notify the management personnel in a preset way when a problem occurs in the database. 3. The present invention can automatically monitor the project by the user, the monitoring time and the reporting party are stored in the database table 5 Modifications can be added and deleted at any time and take effect immediately, improving system flexibility and usability. 4 · The present invention can record the database operation data and generate reports regularly to provide future performance adjustments. The detailed description above is one of the feasible for the present invention Specific description of the embodiment 'But 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 spirit of the art in January should be included in the patent scope of this case. It is stated that this case is not only technically innovative, but also enhances the above-mentioned multi-effect effect. It has fully complied with the novel and progressive statutory invention patent requirements, and submitted a request in accordance with the law. Approval of this invention patent application, in order to stimulate the invention, to the sense of virtue. 1240860 [Simplified illustration of the drawing] 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: ^ Figure 1 is a module of the database monitoring and problem automatic reporting system of the present invention Schematic diagram of the relationship; Figure 2 is a flowchart of the timing monitoring module of the database monitoring and automatic problem reporting system of the present invention; Figure 3 is a flowchart of the instant monitoring module of the database monitoring and automatic problem reporting system of the present invention; The flowchart of the Xindong Group of the invention database monitoring and problem automatic reporting system; and Λ 4 Figure 5 is the module flowchart of the database monitoring and problem automatic reporting system of the invention. ～ [Main part representative symbols] 1 Setting module 11 User information and message sending methods 12 Monitoring items and scope 2 Message module 21 Monitoring items and sequence data 22 Reading database data 23 Report 3 Recording module 31 Monitoring items and data range 1240860 32 Database data 4 Real-time monitoring module 41 Read messages or reports and user information 42 Send according to user settings 5 Scheduled monitoring module 51 Reports or messages added No. 6 a user or database administrator to run the data repository 7