Title :
Generic Methodology for Semantic Data Warehouse Design: From Schema Definition to ETL
Author :
Berkani, Nabila ; Khouri, Selma ; Bellatreche, Ladjel
Author_Institution :
Nat. High Sch. for Comput. Sci. (ESI), Algiers, Algeria
Abstract :
Actually, any company needs to collaborate with others to improve their performance and productivity. Ontologies can provide a way to promote collaboration between companies. They contribute on reducing the syntax and semantic conflicts that may occur during the collaboration process. Data warehouse technology is a serious candidate for data-sharing architecture that may be employed within the collaborating companies. The spectacular adoption of domain ontologies by several communities facilitates the explosion of semantic databases sources (SDB) that become candidate for building the semantic data warehouses (SDW). This situation motivates us to deeply formalize the structure of semantic sources in order to propose an automatic construction of a semantic data warehouse SDW. In this paper, we first proposed a generic framework for handling semantic sources. Secondly, the generic ETL steps are incorporated to our framework. Our proposal is validated through a case study, considering Oracle SDB, where each source references a global ontology of the Lehigh University Bench Mark.
Keywords :
data warehouses; groupware; ontologies (artificial intelligence); productivity; semantic networks; ETL; Lehigh University Bench Mark; Oracle SDB; SDW; automatic construction; collaborating company; collaboration between company; collaboration process; data warehouse technology; data-sharing architecture; domain ontology; generic methodology; global ontology; performance improvement; productivity; schema definition; semantic conflict; semantic data warehouse design; semantic data warehouses; semantic databases sources; semantic sources handling; source references; spectacular adoption; syntax conflict; Data models; Databases; Educational institutions; OWL; Ontologies; Semantics; Silicon; Data Integration Framework; Data Warehouse; ETL process; Oracle; Semantic Data; Semantic Databases;
Conference_Titel :
Intelligent Networking and Collaborative Systems (INCoS), 2012 4th International Conference on
Conference_Location :
Bucharest
Print_ISBN :
978-1-4673-2279-9
DOI :
10.1109/iNCoS.2012.108