Ontology Driven Approach for Data Integration in Data Warehousing Systems

Thanh Binh Nguyen
Hue University Information Technology Center

Anh Duong Hoang Thi
Hue University Information Technology Center

Abstract
Nowadays, with the growing importance in improving business analysis and decision making process, extracting and integrating useful and quality data from multiple information sources have become the main issues in data warehousing systems. In that context, an ontology-based data integration framework is proposed for covering schema as well as content integration, aiming at populating data warehousing systems with reliable, timely, and accurate information. Furthermore, in our approach, an ontology-driven data warehouse bus structure is also presented as a uniform suite of conformed dimensions and facts, facilitating the extraction, transformation and loading of data from distributed and heterogeneous sources. Thus, the role of ontology in multidimensional modeling, populating data warehousing systems with quality data and providing data warehouse an integrated and reconciled view of data is highlighted.