Framework of Semantic Data Warehouse for heterogeneous and incomplete data

Abstract

The demand to analyse and extract knowledge derived from the collaboration of various sources has motivated the construction of Semantic Data Warehouse (SDW). The data derived from various external source introduces challenges, because it has heterogeneous structural characteristics, syntax and semantics and gives the possibility of incomplete data sources to provide the data required for analysis. It is possible that the required data is not provided by the original data source, but there are other data that can be used to generate this data. This research proposes a framework for development semantic data warehouse that can handle incomplete data and the heterogeneity data problems (format, syntax, and structure) through the use of ontologies. The framework also provides tools to handle incomplete data source. The available tools function is to transform the relevant objects instances to an external ontology classes to generate the required data. Identification the multidimensional elements and the conceptual design of multidimensional schema uses a hybrid approach that combines requirement-driven and supply-driven. The construction of cube schema using QB4OLAP vocabularies generate multidimensional schema and RDF data cubes that can perform OLAP operations.