Design and Manage Data Warehouse using Metadata－an example of Medical Quality Indicators Project

• Main Authors: Jia-bin Ling, 凌嘉賓
• Other Authors: Hsueh-Chi Shih
• Format: Others
• Language: zh-TW
• Published: 2003
• Online Access: http://ndltd.ncl.edu.tw/handle/98538807496742863154

碩士 === 國立雲林科技大學 === 資訊管理系碩士班 === 91 === Abstract In order to improve the medical quality, the medical society of Taiwan successively adopt TQIP and THIS these indicator systems. However, they both meet a problem that data of indicators are hard to apply in management area. Therefore, they use data warehouse technology to integrate and analyze the data of indicators to improve the above problem. In a hospital, they usually waste a lot of strength, resource and time to design, construct and maintain their data warehouse. As a result, some researches propose the concepts and methods of using metadata to construct data warehouse for the purpose of reducing the cost of construct the data warehouse. This research focuses on raising the efficiency and increasing successful opportunity of a hospital when they construct a data warehouse of their indicator project. Therefore, we propose a framework for designing and management data warehouse based on metadata. We establish metadata by XML structure due to its properties and features of strictness and flexibility. The users could comprehend the structure of their data warehouse and manage it simultaneously while they design a data warehouse by the way of recording metadata information of indicators and the structure of the data warehouse. So, the hospital can design and manage the metadata and exchange their experience and thoughts with each other by the way of importing and exporting metadata to the XML documents. Finally, this research implements a prototype system based on the proposed framework to explain the framework’s feasibility, and then proposes our perspectives and questions in the light of a result of examine and evaluate the prototype system and confer the possible future research aspects.