An Integrated Use of CWM and Ontological modeling approaches towards ETL Processes

Nowadays, with the wide range of data increased incredibly over the years, extracting and integrating useful data from multiple information sources still has to face significant challenges in semantically integrating heterogeneous sources to data warehouse. Within the scope of this paper, a semantically coupling of a metamodel with an ontology will be applied, describing - at high abstraction levels - applications domains for both schema and semantic integration. Specifically the proposed framework can improve the interoperability in ETL processes by means of the schema-based semantics in CWM-compliant metamodels as well as the ontology-based foundation to better representation and management of the underlying domain semantics. Furthermore, potential approach for the mapping of CWM-based model elements and ontology constructs for the definition of metadata required for ETL processes is introduced, facilitating the extraction, transformation and loading of useful data from distributed and heterogeneous sources.