Ontology-based structured web data warehouses for sustainable interoperability: requirement modeling, design methodology and tool

  • Authors:
  • Khouri Selma;Boukhari IlyèS;Bellatreche Ladjel;Sardet Eric;Jean StéPhane;Baron Michael

  • Affiliations:
  • LIAS/ISAE-ENSMA, Poitiers University, Futuroscope, France and National High School for Computer Science (ESI), Algiers, Algeria;LIAS/ISAE-ENSMA, Poitiers University, Futuroscope, France;LIAS/ISAE-ENSMA, Poitiers University, Futuroscope, France;CRITT Informatique, Futuroscope, France;LIAS/ISAE-ENSMA, Poitiers University, Futuroscope, France;LIAS/ISAE-ENSMA, Poitiers University, Futuroscope, France

  • Venue:
  • Computers in Industry
  • Year:
  • 2012

Quantified Score

Hi-index 0.00

Visualization

Abstract

The spectacular growth of the Internet and its widespread adoption by worldwide corporations lead to an enormous quantity of heterogeneous, distributed and autonomous data sources. To facilitate the access to these huge amounts of data and make these sources interoperable, two technologies may be combined: data warehousing and ontologies. Data warehouses are designed to aggregate data and allow decision makers in these companies to obtain accurate, complete and up to date information. In the past decade, Data Warehouse Technology (DWT) has been successfully applied in several domains such as telecommunication, retail, finance and many other industries. It supports a wide range of applications throughout the enterprise. The DWT has been largely used to offer sustainable solutions for enterprises. On the other hand, ontologies are models for specifying the semantics of concepts used by various heterogeneous sources in a well defined and unambiguous way. Ontologies exist in various domains (E-commerce, Engineering, Tourism, etc.) and are used to increase interoperability between sources. They may be used to improve communication between decision makers and users collaborating together, by specifying the semantics of the used concepts. In this paper, we propose a methodology for designing data warehousing applications from various sources. Each source has its local ontology referencing a global one. The presence of ontologies has three main contributions: (i) each owner of each source may use it to define his/her requirements, (ii) it reduces most important types of conflicts that may exist in sources and requirements (schematic and semantic) and (iii) it facilitates the sustainable urbanization of the target data warehouse. Our methodology is supported by a case tool facilitating the tasks of data warehouse designers.