相关文章推荐
踏实的烤地瓜  ·  SAP Sybase IQ - Tableau·  1 年前    · 
踏实的烤地瓜  ·  利用Sybase ...·  1 年前    · 
踏实的烤地瓜  ·  Sybase.Database - ...·  1 年前    · 

目的:以InfoMaker設計輸出文件,解決ARIA癌症資訊系統資料統計及輸出問題。 材料與方法:使用InfoMaker程式,依照ARIA癌症資訊系統(ARIA)內資訊位置,及該資料庫內資料表間相關組成之關聯結構,於圖形模式結構化查絢語言(SQL)下重新編輯資料表間的框架及資訊報表編輯,並將編輯完成的結果報表,轉換成可於所有工作站端電腦執行的可執行檔。 結果:利用InfoMaker自行設計臨床作業所需報表,可自ARIA資料庫輸出輔助臨床作業所需的作業表單,且可同時檢視輸入於資料庫中資訊是否正確。透過InfoMaker輸出,也可避免ARIA無法直接輸出中文的問題。此外,透過可執行檔的建立,達到於各工作站單一點擊(one-click)輸出報表的便利。因此,ARIA除做為治療作業中資訊傳輸與驗證外,並可利用,InfoMaker編輯臨床作業所需報表,更進一步直接輸出統計表,進行統計作業。 結論:使用回InfoMaker設計臨床作業所需報表,可克服讀取及輸出ARIA內存資料的困難,並提供各工作站皆能點擊輸出報表及快速獲取統計資料的便利,免除另行建立統計資料庫的工作,顯著提升系統使用效率並減少資料處理的工作。

Purpose: To explore a resolution to export data of ARIA oncology information (ARIA) system by InfoMaker. Materials and Methods: According to the data Location in the ARIA and Linking structures between each database, we used InfoMaker program to reconstruct and edit new information report and data sheet frame by the Structured Query Language. These reports were further transformed to executive files so that each report can be retrieved at every terminal computer at each work station. Results: Through customized report and data sheet by InfoMaker, we could export nearly all information in the ARIA with self-designed format for clinical service. The language output was correct through InfoMaker program, and we could also validate the data. Besides, after transforming those document to executive files, we achieved the convenience such as one-click execution and accessible at all workstation terminals. Through InfoMaker, ARIA could not only manage the radiation therapy information, but also direct export document for clinical service, statistical report, and customized form with extreme convenience. Conclusion: Customizing documents, reports, and forms by InfoMaker, could overcome the difficulty and error in retrieving data from ARIA. It could also provide the one-click and accessible at every terminals convenience, and avoid the burden of establishing other database or program for exporting or processing data.