By Topic

A Domain Ontology Approach in the ETL Process of Data Warehousing

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$33 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

3 Author(s)
Lihong Jiang ; Sch. of Software, Shanghai JiaoTong Univ., Shanghai, China ; Hongming Cai ; Boyi Xu

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 metadata 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.

Published in:

e-Business Engineering (ICEBE), 2010 IEEE 7th International Conference on

Date of Conference:

10-12 Nov. 2010