A domain ontology approach in the ETL process of Data Warehousing

摘要：

Extract-Transform-Loading (ETL) tools integrate data from source side to target in building data warehouse. However data structure and semantic heterogeneity exits widely in the enterprise information systems. On the purpose of eliminate data heterogeneity so as to construct data warehouse, this paper introduces domain ontology into ETL process of finding the data sources, defining the rules of data transformation, and eliminating the heterogeneity. In this method, the domain ontology is embedded in the met adata of the data warehouse. Hence, the data record could be mapped from data bases to ontology classes of Web Ontology Language (OWL). As result, the accessing of information resources could be done more efficiently. The method is testing in a hospital data warehouse project, and the result shows that ontology method plays an important role in the process of data integration by providing common descriptions of the concepts and relationships of data items, and medical domain ontology in the ETL process is of practical feasibility.

关键词： Domain Ontology ETL Hospital Data Warehouse

作者: Lihong Jiang Hongming Cai Boyi Xu

作者单位: Lihong Jiang School of Software Shanghai JiaoTong University Shanghai, China School of Software Shanghai JiaoTong University Shanghai, China Antai College of Economics&Management Shanghai JiaoTong University Shanghai, China

会议类型: 国际会议

会议名称: 2010 IEEE International Conference on e-Business Engineering(2010年电子商务工程国际研讨会 ICEBE 2010)

会议地点: 上海

会议语种:英文

页码: 30-35

在线出版日期: 2010-11-10（万方平台首次上网日期，不代表论文的发表时间）