Semantic Technologies Applying to Data Warehouses Federation

Abstract

Business intelligence is based on the existence of main components including : data warehouses .The data warehouse is a specialized database which main task is to provide quick access to data in analysis objective. But in some cases it is necessary to use a set of data warehouses to provide a complete information. This structure is what we call federation, and even if the components are physically separated, they are logically seen as a single component. Generally, these items are heterogeneous which make it difficult to create the logical federation schema ,and the execution of user queries a complicated mission. In this paper, we will fill this gap by proposing a model for logical federation schema creation based on ontology, in order to treat different schema types (star , snow flack) including the treatment of hierarchies dimension too.

An Integration Model of Multi-Source Heterogeneous Audit Data

“…The data center is a variety of data integration and exchange center,using service oriented architecture system, which is a comprehensive application platform in basic and applied as one of the.The data center to achieve a unified,multisource heterogeneous data hierarchy management,can achieve coordination of spatial data and non spatial data in a unified framework,build support integrated application solutions, provides basic support for application system. Data center is a compatibility data warehouse, which can be in the sameframe,but also has the multi-source heterogeneous data distributed management ability.Data center also has a well-defined function warehouse,supporting in a variety of ways (components,plug-ins,process,dynamic database,program fragment,script) to provide functional application, provide the call and execution of these functions in a consistent way [5][6] .Data center architecture is shown in figure 2.…”