學術產出-學位論文

題名 電子病歷彙總工具之設計與實作
Design and Implementation of a Content Aggregator for Electronic Medical Records
作者 林柏維
Lin, Bo Wei
貢獻者 陳恭
Chen, Kung
林柏維
Lin, Bo Wei
關鍵詞 TMT
電子病歷
XML文件產生器
TMT
EMR
XML Document Generator
日期 2007
上傳時間 19-九月-2009 12:11:02 (UTC+8)
摘要 臺灣電子病歷內容基本格式 (Taiwan Electronic Medical Record Template, TMT)是參考國際相關標準之後,專為臺灣本土需求而設計的電子病歷標準。為了進一步評估TMT的實用性與實施上可能遭遇到的問題,衛生署於民國96年推動了「建構以病人為中心之電子病歷跨院資訊交換環境案」,目前已完成參與該專案各醫院的實地測試工作。
在檢視專案執行的結果後,我們發現TMT資訊系統有三項主要的缺點:一、TMT病歷標準不易閱讀,難以撰寫從醫院醫療資訊系統彙總TMT所需資料的指令集;二、製作TMT系統所須的設定檔程序過於繁複,不但時間攏長而且容易出錯;三、線上實際產生個別病患的TMT資料的時間過長,執行效能有待提昇。有鑑於此,我們設計並實作了一套適用於TMT標準的電子病歷文件產生工具,我們重新設計了規格文件檔及輔助設定檔,並提供了Schema Processor自動化工具產生這些檔案;同時,我們也改進了病歷資料彙總程序,搭配高便利性的設定檔,病歷文件產生工具在執行效能上了有明顯的改善。
在詳細、完整的規格文件檔協助下,資訊人員能更快的了解病歷標準架構及撰寫病歷資料查詢語法,以利產出正確的電子病歷文件;透過自動化工具的輔助,簡化了設定檔的製作程序,改善了耗時且容易出錯的缺點;相較於目前的TMT系統,我們的工具執行效能提昇了80%以上,產出電子病歷文件的時間只要原來的五分之一。
The Taiwan Electronic Medical Record Template (TMT) proposed by Taiwan Association for Medical Informatics (TAMI) aims to provide a suite of standard forms that will become the common basis for developing electronic medical record (EMR) systems in Taiwan. It is specified in the XML standard for facilitating data interchange. In order to further assess the usefulness of TMT, in 2007 the Department of Health lauched the project "Building of an Information Exchange Environment for Cross-Hospital Digital Medical Record" to put the TMT to a filed test. There are in total eleven hospitals in the project and they all successfully implemented a significant subset of TMT using their hospital information systems (HIS).<br>However, towards the end of the project, we have identified three major shortcomings of the content aggregator for TMT provided by the TAMI: First, as the TMT Schema is rather complex, it is very difficult for hospital IT staff to prepare the required query instructions to retrieve the data stored in the HIS database. Although there is a XML data mapping tool provided to simplify the mapping process, we found that it did not ease the mapping task as the TAMI staff had expected. Second, the configuration files for preparing a patient’s EMR are too complicated, making the implementation process not only long time but also error-prone. Third, the time required to produce a single sheet of TMT is much longer than planned. There is an urgent need to improve the performance of the content aggregator.<br>Therefore, we propose to re-engineer the content aggregator of TMT for retrieving the required data from the HIS database. Specifically, we redesigned the specification document files and configuration files, and provided a Schema Processor tool to generate these files in a semi-automatically manner. As a result, the IT staff of hospitals can more quickly understand the structure of TMT Schema and prepare the query instructions effectively. Finally, with the powerful configuration files, our TMT document generator runs much faster than the existing one. According to our experimental results, it enhances the performance of generating a TMT sheet more than 80 percent.
參考文獻 [1] 行政院衛生署,「醫療院所病歷電子化現況調查」,民國91、94年
[2] Health Level Seven, The Clinical Document Architecture Release 2.0,
http://www.hl7.org/library/standards_non1.htm
[3] 簡文山、徐建業、劉孟純、張博論、溫信財、郝德慧、李友專,制訂及推動電子病歷內容基本格式之研究,醫療資訊雜誌,14(2005),pp. 1-10.
[4] 簡文山,建構可攜式資料與資訊透通基礎建設-臺灣電子病歷內容基本格式架構,民國96年
[5] XML Schema, http://www.w3.org/XML/Schema.html
[6] 建構以病人為中心之電子病歷跨院資訊交換環境案,
http://emr.doh.gov.tw/introduce/introduce_1.html
[7] Altova XMLSpy,
http://www.altova.com/products/XMLspy/XML_editor.html
[8] Simple Object Access Protocol, http://www.w3.org/TR/soap/
[9] XML Document Object Model (DOM)
http://msdn.microsoft.com/en-us/library/hf9hbf87.aspx
[10] Document Object Model Level 1 Level 2,
http://www.w3.org/DOM/DOMTR
[11] XML Schema Object Model (SOM) ,
http://msdn.microsoft.com/en-us/library/bs8hh90b.aspx
[12] RDB to XML Mapping Editor, http://www.ibm.com/developerworks/websphere/techjournal/0204_russell/russell.html
[13] Altova MapForce,
http://www.altova.com/products/mapforce/data_mapping.html
[14] XSLT, http://www.w3.org/TR/xslt
描述 碩士
國立政治大學
資訊科學學系
95971013
96
資料來源 http://thesis.lib.nccu.edu.tw/record/#G0095971013
資料類型 thesis
dc.contributor.advisor 陳恭zh_TW
dc.contributor.advisor Chen, Kungen_US
dc.contributor.author (作者) 林柏維zh_TW
dc.contributor.author (作者) Lin, Bo Weien_US
dc.creator (作者) 林柏維zh_TW
dc.creator (作者) Lin, Bo Weien_US
dc.date (日期) 2007en_US
dc.date.accessioned 19-九月-2009 12:11:02 (UTC+8)-
dc.date.available 19-九月-2009 12:11:02 (UTC+8)-
dc.date.issued (上傳時間) 19-九月-2009 12:11:02 (UTC+8)-
dc.identifier (其他 識別碼) G0095971013en_US
dc.identifier.uri (URI) https://nccur.lib.nccu.edu.tw/handle/140.119/37114-
dc.description (描述) 碩士zh_TW
dc.description (描述) 國立政治大學zh_TW
dc.description (描述) 資訊科學學系zh_TW
dc.description (描述) 95971013zh_TW
dc.description (描述) 96zh_TW
dc.description.abstract (摘要) 臺灣電子病歷內容基本格式 (Taiwan Electronic Medical Record Template, TMT)是參考國際相關標準之後,專為臺灣本土需求而設計的電子病歷標準。為了進一步評估TMT的實用性與實施上可能遭遇到的問題,衛生署於民國96年推動了「建構以病人為中心之電子病歷跨院資訊交換環境案」,目前已完成參與該專案各醫院的實地測試工作。
在檢視專案執行的結果後,我們發現TMT資訊系統有三項主要的缺點:一、TMT病歷標準不易閱讀,難以撰寫從醫院醫療資訊系統彙總TMT所需資料的指令集;二、製作TMT系統所須的設定檔程序過於繁複,不但時間攏長而且容易出錯;三、線上實際產生個別病患的TMT資料的時間過長,執行效能有待提昇。有鑑於此,我們設計並實作了一套適用於TMT標準的電子病歷文件產生工具,我們重新設計了規格文件檔及輔助設定檔,並提供了Schema Processor自動化工具產生這些檔案;同時,我們也改進了病歷資料彙總程序,搭配高便利性的設定檔,病歷文件產生工具在執行效能上了有明顯的改善。
在詳細、完整的規格文件檔協助下,資訊人員能更快的了解病歷標準架構及撰寫病歷資料查詢語法,以利產出正確的電子病歷文件;透過自動化工具的輔助,簡化了設定檔的製作程序,改善了耗時且容易出錯的缺點;相較於目前的TMT系統,我們的工具執行效能提昇了80%以上,產出電子病歷文件的時間只要原來的五分之一。
zh_TW
dc.description.abstract (摘要) The Taiwan Electronic Medical Record Template (TMT) proposed by Taiwan Association for Medical Informatics (TAMI) aims to provide a suite of standard forms that will become the common basis for developing electronic medical record (EMR) systems in Taiwan. It is specified in the XML standard for facilitating data interchange. In order to further assess the usefulness of TMT, in 2007 the Department of Health lauched the project "Building of an Information Exchange Environment for Cross-Hospital Digital Medical Record" to put the TMT to a filed test. There are in total eleven hospitals in the project and they all successfully implemented a significant subset of TMT using their hospital information systems (HIS).<br>However, towards the end of the project, we have identified three major shortcomings of the content aggregator for TMT provided by the TAMI: First, as the TMT Schema is rather complex, it is very difficult for hospital IT staff to prepare the required query instructions to retrieve the data stored in the HIS database. Although there is a XML data mapping tool provided to simplify the mapping process, we found that it did not ease the mapping task as the TAMI staff had expected. Second, the configuration files for preparing a patient’s EMR are too complicated, making the implementation process not only long time but also error-prone. Third, the time required to produce a single sheet of TMT is much longer than planned. There is an urgent need to improve the performance of the content aggregator.<br>Therefore, we propose to re-engineer the content aggregator of TMT for retrieving the required data from the HIS database. Specifically, we redesigned the specification document files and configuration files, and provided a Schema Processor tool to generate these files in a semi-automatically manner. As a result, the IT staff of hospitals can more quickly understand the structure of TMT Schema and prepare the query instructions effectively. Finally, with the powerful configuration files, our TMT document generator runs much faster than the existing one. According to our experimental results, it enhances the performance of generating a TMT sheet more than 80 percent.en_US
dc.description.tableofcontents 第1章 緒論 1
1.1 研究背景 1
1.2 研究動機 3
1.3 研究目的 3
1.4 論文貢獻 4
1.5 章節架構 4
第2章 相關研究與技術背景 5
2.1 TMT標準及系統介紹 5
2.1.1 TMT標準介紹 5
2.1.2 TMT系統介紹 9
2.1.3 Data Mapping Gateway 12
2.1.4 病歷單張導入流程 14
2.2 相關技術 17
2.2.1 Microsoft .NET Framework, XML文件物件模型 17
2.2.2 Microsoft .NET Framework, XML結構描述物件模型 18
第3章 系統設計與架構 19
3.1 設計理念 19
3.2 XML Document Generator設計 21
3.3 Sheet Template設計 24
3.4 Datasource SQL設計 28
3.5 Datasource Spec設計 33
3.6 Schema Processor設計 35
3.7 病歷單張導入流程改進 38
第4章 系統實作與展示 40
4.1 Schema Processor 40
4.2 Datasource Spec Help File 45
4.3 SQL Command Editor 47
4.4 Data Mapping Gateway 2.0測試與效能比較 51
4.4.1 效能比較 52
第5章 結論 55
5.1 結論 55
5.2 未來發展 56
第6章 參考文獻 58
附錄A. Datasource SQL XML Schema 60
附錄B. Datasource Spec XML Schema 62
附錄C. Datasource Spec MSDN Style XSLT 66
zh_TW
dc.format.extent 270672 bytes-
dc.format.extent 268575 bytes-
dc.format.extent 272544 bytes-
dc.format.extent 329861 bytes-
dc.format.extent 283314 bytes-
dc.format.extent 816643 bytes-
dc.format.extent 2362808 bytes-
dc.format.extent 1000032 bytes-
dc.format.extent 275179 bytes-
dc.format.extent 272445 bytes-
dc.format.extent 438880 bytes-
dc.format.mimetype application/pdf-
dc.format.mimetype application/pdf-
dc.format.mimetype application/pdf-
dc.format.mimetype application/pdf-
dc.format.mimetype application/pdf-
dc.format.mimetype application/pdf-
dc.format.mimetype application/pdf-
dc.format.mimetype application/pdf-
dc.format.mimetype application/pdf-
dc.format.mimetype application/pdf-
dc.format.mimetype application/pdf-
dc.language.iso en_US-
dc.source.uri (資料來源) http://thesis.lib.nccu.edu.tw/record/#G0095971013en_US
dc.subject (關鍵詞) TMTzh_TW
dc.subject (關鍵詞) 電子病歷zh_TW
dc.subject (關鍵詞) XML文件產生器zh_TW
dc.subject (關鍵詞) TMTen_US
dc.subject (關鍵詞) EMRen_US
dc.subject (關鍵詞) XML Document Generatoren_US
dc.title (題名) 電子病歷彙總工具之設計與實作zh_TW
dc.title (題名) Design and Implementation of a Content Aggregator for Electronic Medical Recordsen_US
dc.type (資料類型) thesisen
dc.relation.reference (參考文獻) [1] 行政院衛生署,「醫療院所病歷電子化現況調查」,民國91、94年zh_TW
dc.relation.reference (參考文獻) [2] Health Level Seven, The Clinical Document Architecture Release 2.0,zh_TW
dc.relation.reference (參考文獻) http://www.hl7.org/library/standards_non1.htmzh_TW
dc.relation.reference (參考文獻) [3] 簡文山、徐建業、劉孟純、張博論、溫信財、郝德慧、李友專,制訂及推動電子病歷內容基本格式之研究,醫療資訊雜誌,14(2005),pp. 1-10.zh_TW
dc.relation.reference (參考文獻) [4] 簡文山,建構可攜式資料與資訊透通基礎建設-臺灣電子病歷內容基本格式架構,民國96年zh_TW
dc.relation.reference (參考文獻) [5] XML Schema, http://www.w3.org/XML/Schema.htmlzh_TW
dc.relation.reference (參考文獻) [6] 建構以病人為中心之電子病歷跨院資訊交換環境案,zh_TW
dc.relation.reference (參考文獻) http://emr.doh.gov.tw/introduce/introduce_1.htmlzh_TW
dc.relation.reference (參考文獻) [7] Altova XMLSpy,zh_TW
dc.relation.reference (參考文獻) http://www.altova.com/products/XMLspy/XML_editor.htmlzh_TW
dc.relation.reference (參考文獻) [8] Simple Object Access Protocol, http://www.w3.org/TR/soap/zh_TW
dc.relation.reference (參考文獻) [9] XML Document Object Model (DOM)zh_TW
dc.relation.reference (參考文獻) http://msdn.microsoft.com/en-us/library/hf9hbf87.aspxzh_TW
dc.relation.reference (參考文獻) [10] Document Object Model Level 1 Level 2,zh_TW
dc.relation.reference (參考文獻) http://www.w3.org/DOM/DOMTRzh_TW
dc.relation.reference (參考文獻) [11] XML Schema Object Model (SOM) ,zh_TW
dc.relation.reference (參考文獻) http://msdn.microsoft.com/en-us/library/bs8hh90b.aspxzh_TW
dc.relation.reference (參考文獻) [12] RDB to XML Mapping Editor, http://www.ibm.com/developerworks/websphere/techjournal/0204_russell/russell.htmlzh_TW
dc.relation.reference (參考文獻) [13] Altova MapForce,zh_TW
dc.relation.reference (參考文獻) http://www.altova.com/products/mapforce/data_mapping.htmlzh_TW
dc.relation.reference (參考文獻) [14] XSLT, http://www.w3.org/TR/xsltzh_TW