2014 | OriginalPaper | Chapter
Requirements Driven Data Warehouse Design: We Can Go Further
Authors : Selma Khouri, Ladjel Bellatreche, Stéphane Jean, Yamine Ait-Ameur
Published in: Leveraging Applications of Formal Methods, Verification and Validation. Specialized Techniques and Applications
Publisher: Springer Berlin Heidelberg
Activate our intelligent search to find suitable subject content or patents.
Select sections of text to find matching patents with Artificial Intelligence. powered by
Select sections of text to find additional relevant content using AI-assisted search. powered by
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.