201019896 九、發明說明: 【發明所屬之技術領域】 本發明是有關於一種資料庫系統及管控方法,特別是 指一種主動式生醫資料庫管理系統及生醫資料即時監控= 法。 " 【先前技術】 由於科技不斷進步,生醫領域的科技產品逐漸由治療 轉向預防,而使用者也趨向以病患為中心。遠距健康照護 Φ 可犬破距離的限制,提供相當的醫療照護服務,醫療行為 也可從醫療院所擴大至使用者日常生活住居、辦公室甚至 是旅遊,可讓使用者隨時掌握自己的健康狀況,適時獲得 醫療照護β 然而,傳統的資料庫管理系統是被動式(Passive),只 有當查詢及交易異動的要求送到系統之後,系統才會執行 這些工作;但是對於生醫領域的資料庫管理系統來說,其 反應時間很緊迫,而且需要設定某些門檻值以決定何種反 _ 貞需要自動被觸發,在這種情況下,傳統被動式的資料庫 管理系統無法符合此種需求。 【發明内容】 因此,本發明之一目的,即在提供一種主動式生醫資 料庫管理系統。 於是,本發明主動式生醫資料庫管理系統包含一記錄 資料庫、一更新程式、一監控程式及一連線程式。 該汜錄資料庫具有一供記錄至少一使用者的多筆生醫 201019896 資料數據之儲存空間;該更新程 數據加入該記錄資料庫;該 ::得-生醫資料 次新增-筆生醫資料數據時,依料庫每 醫資料數據之數值是否為異常,若是,增 息:該連線程式則是透過網路將該緊急訊息通 端0 本發明之另一目的,即在提供— 即時監控方法 #主動式的生醫資料 本發明生醫資料即時監控方法包含下述步驟:⑷將取 自-血糖檢測儀的一生醫資料數據加入一記錄資料庫該 記錄資料庫具有一記錄至少一使用者的多筆生醫資料數據 之儲存空間;(b)偵測該記錄資料庫每次新增一筆生醫資料 數據時,比對該筆生醫資料數據之數值是否為異常,若是 ,立即發出一緊急訊息;及(C)透過網路將該緊急訊息通知 一管理終端。 本發明的主動式生醫資料庫管理系統及生醫資料即時 監控方法,主要是藉由偵測每次新增一筆生醫資料數據時 立刻比對該筆生醫資料數據之數值是否為異常,且異常時 依據預定位址透過網路將該緊急訊息通知管理終端,符合 生醫資料庫管理系統需即時反應的需求。 【實施方式】 有關本發明之前述及其他技術内容、特點與功效,在 以下配合參考圖式之較佳實施例的詳細說明中,將可清楚 的呈現。 201019896 參閱圖1,本發明主動式(Active)生醫資料庫管理系 統1的較佳實施例係安裝於一伺服端,生醫資料庫管理系 統1包含一網站程式1〇、一更新程式u、一記錄資料庫12 、一監控程式13及一連線程式14。 網站程式10是在一連上網路7的使用終端2產生一個 人網路介面21,以及在一連上網路7的管理終端3顯示一 管理網路介面31;個人網路介面21用以讓一使用者61上 傳一生醫檢測儀4之生醫資料數據,網站程式1〇讓一管理 ® 者62能對於使用者資料及事件規則及人員權限進行管理。 本較佳實施例中,生醫檢測儀4是一具備USB連接介 面的血糖機,將血糖機透過USB連接介面與一使用終端2 連接後’可將量取的血糖資料數據透過個人網路介面21上 傳給伺服端1 ;網路7是一網際網路,使用終端2及管理終 端3是與網際網路連線的電腦終端。其他實施例中,網路7 也可以疋一無線通訊網路,使用終端2及管理終端3則是 能與無線通訊網路連線的行動電話或個人數位助理裝置, 〇 &外’生醫檢測儀也可以是量取除了血糖資料數據之外的 如:尿糖等其他生醫資料數據,其類別在此不一一列舉。 .參閱圖2’本發明生醫資料即時監控方法包含下述步驟 將-筆生醫資料數據加入記錄資料庫叫步称2〇1广偵測 新增的該筆生醫資料數據(步驟202),比對該筆生醫資料數 ,之數值是否為異常(步驟2_若無異常,仍持續债測; *異常狀/兄立即透過網路7發出緊急訊息通知管理終 端3 (步驟204)。 、 201019896 參閱圖1,生醫資料庫管理系統1的架構及原理詳述如 下: 更新程式11是自網站程式1〇取得生醫資料數據加入該 記錄資料庫12;記錄資料庫12具有一供記錄使用者61的 多筆生醫資料數據之儲存空間。 需注意的是,更新程式u、記錄資料庫12、監控程式 13及連線程式14都存在於生醫資料庫f理系統i内而非 f放在如丽D0WS的作業系统。存放在作業系統的缺點 疋·程式開啟還須料設定開啟的路#,若是要將資料庫 系統安裝到一個主機,則程式也必須另外放入,增加安裝 的複雜性,更重要的是’若程式沒有存在生醫資料庫管理 f統1内,而是存在作業系,统中,—旦作業系統登入者為 管理者,即使此管理者即使沒有讀取生醫資料庫管理系統! 的權限,則存在作業系統的程式也可能會被修改。 更新程式11是將資料轉換為有意義的格式(年、月、 日、時、分及血糖測量值),再和資料庫進行比對,以區別 何者是已儲存與尚未儲存的血糖記錄,比對資料所使用的 方法是利用 ADODB (ActiveX Data Object DataBase)函式 元件,與本機的資料庫建立連線,將資料庫的資料抓取到 程式内部的虛擬資料集(Rec〇rdset),接著將解碼後的記錄 與此資料集進行比對,若比對的結果相同,則回傳真值。 此外,更新程式11還具有時間同步處理功能:因為當 血糖機損壞有拆機修理的情形,或是不同電腦的系統時間 可能會與血糖機的時間有所不同,須同步個別電腦系統時 201019896 間與血糖機的時間來維護資料存取的正確性。 監控程式13具有一觸發模組131、一判斷模組132及 一整合模組133 ;其中,觸發模組131是偵測記錄資料庫 12新增一筆生醫資料數據產生觸發的事件;判斷模組Η】 受該事件觸發以判斷該筆生醫資料數據之數值是否為異常 ;整合模組133若偵知判斷結果為異常時,自記錄資料庫 12擷取該生醫資料數據之數值及對應的識別資訊以整合為 緊急訊息予連線程式14,然後,由連線程式14透過網路 7將緊急訊息通知管理終端3。201019896 IX. INSTRUCTIONS: [Technical Field of the Invention] The present invention relates to a database system and a control method, and more particularly to an active biomedical database management system and real-time monitoring of biomedical data. " [Previous technology] As technology continues to advance, technology products in the field of biomedical science are gradually shifting from treatment to prevention, and users tend to be patient-centered. Long-distance health care Φ can limit the distance of dogs and provide considerable medical care services. Medical activities can also be extended from medical institutions to users' daily lives, offices and even travel, allowing users to keep abreast of their health. Getting medical care in a timely manner β However, the traditional database management system is passive, and the system will perform these tasks only after the request for query and transaction changes is sent to the system; however, the database management system for the biomedical field In this case, the response time is very urgent, and some threshold values need to be set to determine which anti- 贞 needs to be triggered automatically. In this case, the traditional passive database management system cannot meet this requirement. SUMMARY OF THE INVENTION Accordingly, it is an object of the present invention to provide an active biomedical database management system. Therefore, the active biomedical database management system of the present invention comprises a record database, an update program, a monitor program and a threaded type. The transcript database has a storage space for recording at least one user's biomedical 201019896 data; the update data is added to the record database; the:: biomedical data is newly added - pen biomedical In the case of data, whether the value of the medical data in the database is abnormal or not, if so, the interest rate increase: the threaded type is the emergency message through the network. Another purpose of the present invention is to provide - instant Monitoring method #Active biomedical data The instant monitoring method of the biomedical data of the present invention comprises the following steps: (4) adding a biomedical data from the blood glucose detector to a record database, the record database having a record of at least one use (b) detecting whether the value of the biomedical data is abnormal when the biometric data is added to the record database, and if so, immediately An emergency message; and (C) notifying the management terminal of the emergency message via the network. The active biomedical database management system and the real-time monitoring method for biomedical data of the present invention mainly detect whether the value of the biomedical data is abnormal when the biomedical data is newly added each time. In the case of an abnormality, the emergency message is notified to the management terminal via the network according to the predetermined address, which meets the requirement that the biomedical database management system needs immediate response. The above and other technical contents, features, and advantages of the present invention will be apparent from the following detailed description of the preferred embodiments of the invention. 201019896 Referring to FIG. 1, a preferred embodiment of the active biomedical database management system 1 of the present invention is installed on a server. The biomedical database management system 1 includes a website program, an update program u, A record database 12, a monitoring program 13 and a threaded type 14. The website program 10 generates a human network interface 21 on the connection terminal 2 connected to the network 7, and displays a management network interface 31 on the management terminal 3 connected to the network 7; the personal network interface 21 is used to allow a user 61. Uploading the biomedical data of a biomedical detector 4, the website program allows a management manager 62 to manage user data and event rules and personnel permissions. In the preferred embodiment, the biomedical detector 4 is a blood glucose meter with a USB connection interface. After the blood glucose meter is connected to a user terminal 2 through the USB connection interface, the blood glucose data can be measured through the personal network interface. 21 is uploaded to the server 1; the network 7 is an internet, and the terminal 2 and the management terminal 3 are computer terminals connected to the Internet. In other embodiments, the network 7 can also be a wireless communication network, and the terminal 2 and the management terminal 3 are mobile phones or personal digital assistant devices that can be connected to the wireless communication network, and the external medical detectors It is also possible to measure other biomedical data such as urine sugar other than blood glucose data, the categories of which are not listed here. Referring to FIG. 2', the instant monitoring method for the biomedical data of the present invention comprises the following steps: adding the biomedical data of the pen to the record database, and calling the biometric data of the new biometric data (step 202) Whether the value of the biomedical data is abnormal or not (Step 2_ If there is no abnormality, the debt test is continued; * The abnormality/brother immediately sends an emergency message to the management terminal 3 via the network 7 (step 204). 201019896 Referring to FIG. 1, the structure and principle of the biomedical database management system 1 are as follows: The update program 11 is obtained by adding the biomedical data from the website program 1 to the record database 12; the record database 12 has a record for The storage space of the plurality of biomedical data of the user 61. It should be noted that the update program u, the record database 12, the monitoring program 13 and the threaded type 14 are all present in the biomedical database i instead of the system i f placed in the operating system of the D0WS. Disadvantages stored in the operating system 疋 · program open must also be set to open the road #, if you want to install the database system to a host, the program must be placed separately, increase the installation of Hybrid, more importantly, 'if the program does not exist in the biomedical database management system 1, but there is an operating system, the system, the operating system login is the manager, even if the manager does not read the student The program of the medical database management system!, the program of the operating system may also be modified. The update program 11 converts the data into a meaningful format (year, month, day, hour, minute, and blood glucose measurement), and then The database is compared to distinguish between the stored and unstored blood glucose records. The method used to compare the data is to use the ADODB (ActiveX Data Object DataBase) function component to establish a connection with the local database. The data of the database is captured into the virtual data set (Rec〇rdset) inside the program, and then the decoded record is compared with the data set. If the result of the comparison is the same, the fax value is returned. In addition, the update program 11 It also has time synchronization processing function: because the blood glucose machine is damaged or disassembled, or the system time of different computers may be different from the time of the blood glucose machine, The individual computer system maintains the correctness of data access between 201019896 and the blood glucose machine. The monitoring program 13 has a trigger module 131, a determination module 132 and an integration module 133; wherein the trigger module 131 is a detection The measurement record database 12 adds a bio-information data to generate an event triggered; the judgment module Η is triggered by the event to determine whether the value of the bio-medical data is abnormal; the integration module 133 detects that the judgment result is When the abnormality occurs, the self-recording database 12 retrieves the value of the biomedical data and the corresponding identification information to be integrated into the emergency message 14 and then notifies the management terminal of the emergency message through the network 7 by the threaded system 14. 3.
本較佳實施例中,記錄In the preferred embodiment, recording
只 /fT + X 母蚵增一筆血糖值後 ,判斷模組132馬上取血糖值標準資料表為判斷規則並與 -正常血糖值標準進行比對,其標準是依照例如醫院糖尿 病衛教手冊的血糖值標準:飯前的血糖值標準為i3〇mg/dL 以下,飯後的血糖值標準須介於13〇mg/dL~16()mg/di^ 若血糖值沒有超過標準,判斷模組132繼續監护,若 超出健康標準’整合模組133會去比對記錄資料庫J内的 =歷號碼’並找到對應的病人與其醫護人員;㈣,連線 =式14根據管理終端3的Ip位址,將記錄資料庫η操取 =資料集並傳給-事件派發器(圖未示),讓事件派發器 ^斤傳的資料派送給管理終端3,顯示緊急訊息供 護人員及家屬知悉。 配合圖1’圖3至圖5為個人網路介面21產生的畫面 ’分別介紹如下:After only /fT + X is added to the blood glucose level, the judgment module 132 immediately takes the blood glucose level standard data table as a judgment rule and compares it with the normal blood sugar level standard, and the standard is according to, for example, the blood sugar of the hospital diabetes education manual. Value standard: The blood sugar level before meals is i3〇mg/dL or less, and the blood sugar level after meals should be 13〇mg/dL~16()mg/di^ If the blood sugar level does not exceed the standard, the judgment module 132 Continue to monitor, if the health standard is exceeded, the integration module 133 will compare the = calendar number in the record database J and find the corresponding patient and its medical staff; (4), connection = formula 14 according to the Ip position of the management terminal 3. The address will be recorded in the database η operation = data set and passed to the - event dispatcher (not shown), and the information sent by the event dispatcher will be sent to the management terminal 3 to display the emergency message provider and family members. The pictures generated by the personal network interface 21 in conjunction with FIG. 1' FIG. 3 to FIG. 5 are respectively described as follows:
「個人血糖狀況」畫面301,當使用者登入後 201019896 選冑人血糖資訊」的按鈕之後,系統會顯示如圖所 丁的個人血糖狀況的子畫面3G2,使用者可以知道上次測量 :糖的時間,而在子畫自302還有二項子功能可以點選, 分別為「記錄新數值」及「觀看▲糖變化」,為了方便觀看 起見,其顯不結果出現在個人血糖狀況畫自3〇1下方顯 示結果分別如圖4及圖5。 圖4為出現在「個人血糖狀況」畫面3〇ι下方的「記 錄新數值」的視窗畫面3()3 ’使用者可依預定的格式填寫資 料’使用者在填寫完「本次量測值」後,系統會自動顯示 與血糖機同步後的「量測時間」,接著選擇此次「測量時狀 態」是在飯後還是飯前’最後就可選取「送出記錄」將此 筆記錄上傳至資料庫。 圖5為一血糖變化圖表3〇4,當使用者點選「觀看血糖 變化」就會顯示此血糖變化圖表3〇4,且使用者可在右上方 的子畫面305設定「日期範圍」為X軸範圍,「按測量時間 」或「按測量次」為單位來產生這個圖表如果使用者如 凡成變更’ ’、要再點選「立即更新」,血糖變化圖表便 會變更為以使用者所選擇的項目來顯示。 配口圖1’圖6及圖7為管理網路介面31呈現的畫面 ,分別介紹如下: 參閱圖6’「事件規則與權限管理」的畫面4〇1是提供 高階/-般醫護人員使用的功能’一般醫護人員及高階醫護 人員登入系統後,都有左方的「病換狀態管理」這個項目 可以使用,包括檢視病患血糖狀況、新增病患資料、查看 10 201019896 、修改病患資料;此外,高階醫護人員還多出「醫護管理 」項目’讓南階醫S蔓人員不只可以修改與新增病患資料, 也可以對一般醫護人員進行基本資料的新增與修改;高階 醫護人員並具有血糖異常數值判定的「修改判定規則」、醫 護人員權限的「更換管理人員」及血糖異常時發送訊息的 「修改判定規則」等管理功能。 圖7為一緊急訊息視窗402,訊息内容包括病患的姓名 、血糖值、測量時間與聯絡資料等;每當有新訊送達,視 參 窗會發出震動與鈴聲,提醒醫護人員有新的緊急訊息,設 計鈴聲與震動就是要引起忙碌的醫護人員的注意,又有新 訊息傳進’就會再產生新的視窗,讓醫護人員一目瞭然最 新的訊息與處理過的訊息;當醫護人員處理完訊息之後, 按下確定接受按鈕,讓新的視窗的標籤顏色改變與文字訊 息改變’如此就可知道哪些訊息已經處理完畢。 歸納上述,本發明的主動式生醫資料庫管理系統及生 醫資料即時監控方法具有下述優點: ® h由於生醫檢測儀4可隨身攜帶,但是資料數據上傳 軟體並非隨手可得,本發明只要一台能上網的使用終端2, 無須安裝額外的程式,就能透過個人網路介面21將血糖資 料數據上傳給伺服端丨,對使用者更為便利。 2.藉由偵測每次新增生醫資料數據時立刻比對該筆生 醫資料數據之數值是否為異常,且異常時透過網路將該緊 急訊息通知管理'終端,符合生醫資料庫管理系统需即時反 應及自動化管理的的需求。 11 201019896 惟以上所述者,僅為本發明之較佳實施例而已,當不 能以此限定本發明實施之範圍,即大凡依本發明申請專利 範圍及發明說明内容所作之簡單的等效變化與修飾,皆仍 屬本發明專利涵蓋之範圍内。 【圖式簡單說明】 圖1是一系統方塊圖,說明本發明主動式生醫資料庫 管理系統的較佳實施例; 圖2是一流程圖,說明本發明生醫資料即時監控方法 9 圖3是一示意圖’說明個人網路介面產生的「個人血 糖狀況」畫面; 圖4是一示意圖,說明出現在「個人血糖狀況」畫面 下方的「記錄新數值」的視窗畫面; 圖5是一示意圖,說明個人網路介面產生的血糖變化 圖表; 圖6是一示意圖,說明管理網路介面呈現的「事件規 則與權限管理」的畫面;及 圖7是一示意圖,說明管理網路介面呈現的緊急訊息 視窗。 201019896 【主要元件符號說明】 1 ·· 生醫資料庫管理系統 31 ···· ……管理網路介面 10·· .......網站程式 301 ·· ••…畫面 11 ·· .......更新程式 302、 305子畫面 12·· .......§己錄資料庫 303 .· ••…視窗畫面 13·· .......監控程式 304 ·· …·.血糖變化圖表 131 .......觸發模組 4 ···.· ••…生醫檢測儀 132 .......判斷模組 401 .· ••…畫面 133 .......整合模組 402 ·· ••…緊急訊息視窗 14·· .......連線程式 61 ···. •….使用者 2… .......使用終端 62···· ••…管理者 21·. .......個人網路介面 7 ••… ……網路 3 ··· .......管理終端 13On the "Personal Blood Glucose Status" screen 301, after the user enters the button of 201019896 Selecting Blood Sugar Information, the system will display the sub-screen 3G2 of the individual blood glucose status as shown in the figure, the user can know the last measurement: sugar Time, and there are two sub-functions in the sub-picture from 302, which are “record new value” and “view ▲ sugar change”. For the convenience of viewing, the obvious result appears in the individual blood sugar status. The results shown below 3〇1 are shown in Figures 4 and 5, respectively. Figure 4 is the window screen 3 () 3 of the "record new value" appearing on the "Personal Blood Glucose Status" screen 3〇ι. 'Users can fill in the data according to the predetermined format. 'Users are filling out the current measurement value. After that, the system will automatically display the "measurement time" after synchronizing with the blood glucose machine, and then select whether the "measurement status" is after the meal or before the meal. Finally, the "send record" can be selected to upload the record to database. Fig. 5 is a blood glucose change chart 3〇4. When the user clicks “watch blood sugar change”, the blood glucose change chart 3〇4 is displayed, and the user can set the “date range” to X in the upper right sub-screen 305. Axis range, "by measurement time" or "by measurement" to generate this chart. If the user changes "', and then click "update now", the blood glucose change chart will be changed to the user's The selected item is displayed. Figure 1' Figure 6 and Figure 7 show the screens presented by the management network interface 31, which are described below: Refer to Figure 6 "Event Rules and Rights Management" screen 4〇1 for providing high-level / general medical staff Function 'General medical staff and high-level medical staff are registered in the system. The item "Treatment Status Management" can be used on the left side, including reviewing the patient's blood glucose status, adding new patient data, viewing 10 201019896, and modifying patient data. In addition, high-level medical staff also have more "health management" projects to allow the Southern Medical S staff not only to modify and add patient information, but also to add and modify basic information for general medical staff; high-level medical staff It also has management functions such as "Modification Judgment Rule" for determining the abnormal value of blood sugar, "Replacement Manager" for medical staff authority, and "Modification Judgment Rule" for sending messages when blood sugar is abnormal. Figure 7 is an emergency message window 402. The content of the message includes the patient's name, blood sugar level, measurement time, and contact information. Whenever a new message is delivered, the window will vibrate and ring to remind the medical staff of a new emergency. The message, the design of ringtones and vibrations is to attract the attention of busy medical staff, and new messages are passed in. 'There will be a new window, so that the medical staff can see the latest information and processed messages at a glance; when the medical staff finishes the message After that, press the OK button to change the label color of the new window and change the text message. This will let you know which messages have been processed. In summary, the active biomedical database management system and the biomedical data instant monitoring method of the present invention have the following advantages: ® h can be carried by the biomedical detector 4, but the data uploading software is not readily available, the present invention As long as one terminal 2 can access the Internet, the blood glucose data can be uploaded to the server through the personal network interface 21 without installing an additional program, which is more convenient for the user. 2. By detecting whether the value of the biomedical data is abnormal every time the biomedical data is added, and the emergency message is notified to the management terminal through the network, the biomedical database is met. Management systems require immediate response and the need for automated management. 11 201019896 The above is only the preferred embodiment of the present invention, and the scope of the present invention is not limited thereto, that is, the simple equivalent change of the patent application scope and the description of the invention is Modifications are still within the scope of the invention. BRIEF DESCRIPTION OF THE DRAWINGS FIG. 1 is a system block diagram showing a preferred embodiment of the active biomedical database management system of the present invention; FIG. 2 is a flow chart illustrating the instant monitoring method of the biomedical data of the present invention 9 FIG. It is a schematic diagram illustrating the "personal blood glucose status" screen generated by the personal network interface; FIG. 4 is a schematic diagram showing the window screen of "record new value" appearing at the bottom of the "personal blood glucose status" screen; FIG. 5 is a schematic diagram. A diagram showing the blood glucose changes generated by the personal network interface; FIG. 6 is a schematic diagram showing the "Event Rule and Rights Management" screen of the management network interface; and FIG. 7 is a schematic diagram illustrating the emergency message presented by the management network interface. Windows. 201019896 [Explanation of main component symbols] 1 ·· Biomedical database management system 31 ····...Management network interface 10·· ....... Website program 301 ·· ••...Screen 11 ·· . ... update program 302, 305 sub-screen 12··.......§Record database 303.·••...Window screen 13··.......Monitor program 304· ·...·. Blood glucose change chart 131....... Trigger module 4 ·····••... Biomedical detector 132.......Judgement module 401 .· ••...Screen 133 .......Integration module 402 ·· ••...Emergency message window 14·· ....... even threaded 61 ···. •....user 2... ...... .Using the terminal 62···· ••...Manager 21·.............Personal Network Interface 7 ••... ......Network 3 ··· .......Management Terminal 13