Semantic Integration of Structured and Unstructured Data in Data Warehousing and Knowledge Management Systems
Nowadays, increasing information in enterprises demands new ways of searching and connecting the existing information systems. This chapter describes an approach for the integration of structured and unstructured data focusing on the application to Data Warehousing (DW) and Knowledge Management (KM). Semantic integration is used to improve the interoperability between two well-known and established information systems in the business context of nowadays enterprises. The objective is to introduce a semantic solution in the field of Business Intelligence based on ontology integration. The main focus of this chapter is not to provide a complete literature review of all existing approaches or just to point put the motivation for such an approach. In fact, it presents, under consideration of the most important research approaches, a solution for how a Semantic Integration could be technically achieved in this specific application area. After pointing out the motivation, a short introduction to Semantic Integration, the problems and challenges occurring from it, and the application area of Knowledge Management and Data Warehousing are given. Besides the basic ideas of ontologies and ontology integration are introduced. The approach itself starts with a short overview on the determined requirements, followed by a concept for generating an ontology from a Data Warehouse System (DWS) to be finally integrated with Knowledge Management Systems (KMS) ontology. Finally SENAGATOR, an exemplarily system for semantic navigation based on integrated ontologies, is shortly introduced.