Requirements Driven Data Warehouse Design: We Can Go Further

  • Selma Khouri
  • Ladjel Bellatreche
  • Stéphane Jean
  • Yamine Ait-Ameur
Conference paper

DOI: 10.1007/978-3-662-45231-8_49

Part of the Lecture Notes in Computer Science book series (LNCS, volume 8803)
Cite this paper as:
Khouri S., Bellatreche L., Jean S., Ait-Ameur Y. (2014) Requirements Driven Data Warehouse Design: We Can Go Further. In: Margaria T., Steffen B. (eds) Leveraging Applications of Formal Methods, Verification and Validation. Specialized Techniques and Applications. ISoLA 2014. Lecture Notes in Computer Science, vol 8803. Springer, Berlin, Heidelberg

Abstract

Data warehouses (\(\mathcal{D}\mathcal{W}\)) are defined as data integration systems constructed from a set of heterogeneous sources and user’s requirements. Heterogeneity is due to syntactic and semantic conflicts occurring between used concepts. Existing \(\mathcal{D}\mathcal{W}\) design methods associate heterogeneity only to data sources. We claim in this paper that heterogeneity is also associated to users’ requirements. Actually, requirements are collected from heterogeneous target users, which can cause semantic conflicts between concepts expressed. Besides, requirements can be analyzed by heterogeneous designers having different design skills, which can cause formalism heterogeneity. Integration is the process that manages heterogeneity in \(\mathcal{D}\mathcal{W}\) design. Ontologies are recognized as the key solution for ensuring an automatic integration process. We propose to extend the use of ontologies to resolve conflicts between requirements. A pivot model is proposed for integrating requirements schemas expressed in different formalisms. A \(\mathcal{D}\mathcal{W}\) design method is proposed for providing the target \(\mathcal{D}\mathcal{W}\) schema (star or snowflake schema) that meets a uniformed and consistent set of requirements.

Keywords

Data warehouse semantic heterogeneity formalism heterogeneity integration ontology-based design 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Springer-Verlag Berlin Heidelberg 2014

Authors and Affiliations

  • Selma Khouri
    • 1
    • 2
  • Ladjel Bellatreche
    • 1
  • Stéphane Jean
    • 1
  • Yamine Ait-Ameur
    • 3
  1. 1.LIAS/ISAE-ENSMAPoitiers UniversityFrance
  2. 2.National High School for Computer Science (ESI)AlgiersAlgeria
  3. 3.ENSEEIHT/IRITToulouseFrance

Personalised recommendations