Automated Creating a Data Warehouse from Unstructured Semantic Data

Abstract

The use and analysis of unstructured semantic data such as text files, semantic web, and etc which have been included the bulk of the available data sources, such as Internet due to their high volume and the extent of their resources is very complicated and time consuming process. In this context, the ontology for modeling and better understanding this data is used. So far, various methods for creating a relational database from ontology are proposed, however, creating of data warehouse from these unstructured data due to the possibility of using OLAP, top speed of reporting and its other benefits has received much attention. Numerous approaches and implementations of creating data warehouse from semantic data have been introduced. However, they still have the following disadvantages: human-dependence, semiautomatic, losing data and relations, etc. In this paper, a solution for automated creating a data warehouse from unstructured semantic data using ontology is proposed. So that, in the absence of a business analyst, all classes and relationships and data defined in the ontology data is created in a data warehouse format. In this paper, showing ontology using Protege, language OWL and RDF is done. General Terms Data warehouse, Ontology