skip to main content
Ngôn ngữ:
Giới hạn tìm kiếm: Giới hạn tìm kiếm: Dạng tài nguyên Hiển thị kết quả với: Hiển thị kết quả với: Chỉ mục

The role of user requirements in data repository design

Boukhari, Ilyès ; Jean, Stéphane ; Ait-Sadoune, Idir ; Bellatreche, Ladjel

International Journal on Software Tools for Technology Transfer, 2018, Vol.20(1), pp.19-34 [Tạp chí có phản biện]

ISSN: 1433-2779 ; E-ISSN: 1433-2787 ; DOI: 10.1007/s10009-016-0443-0

Toàn văn sẵn có

Trích dẫn Trích dẫn bởi
  • Nhan đề:
    The role of user requirements in data repository design
  • Tác giả: Boukhari, Ilyès ; Jean, Stéphane ; Ait-Sadoune, Idir ; Bellatreche, Ladjel
  • Chủ đề: Requirements engineering ; Database ; Data warehouse ; Ontology ; B method ; Query optimization
  • Là 1 phần của: International Journal on Software Tools for Technology Transfer, 2018, Vol.20(1), pp.19-34
  • Mô tả: Requirements engineering plays a crucial role in the development process of an information system as it aims at providing a complete and accurate requirement specification. In the life cycle of a Data Repository ( \mathcal {D}}{\mathcal {R}} D R ) such as a database or a data warehouse, the requirements are mainly used to define the conceptual model once they have been identified from the informal specification. In this paper, we study the interest of requirements in the other phases of the \mathcal {D}}{\mathcal {R}} D R life cycle. As the data integration problem, handled in the Extract , Transform , Load (ETL) phase, comes from the heterogeneity of requirements, we introduce a requirement integration framework based on ontologies and a generic model to unify the used vocabularies and requirement languages. Then we propose an approach to check the consistency of the requirements, w.r.t. the integrity constraints defined on the logical schema using the formal B method. We also show that requirements help define appropriate access structures such as indexes and materialized views to optimize SQL queries of a \mathcal {D}}{\mathcal {R}} D R . Our approach is based on transformation rules that identify important queries that will be executed on a \mathcal {D}}{\mathcal {R}} D R directly from the requirements. The experiments conducted on the Star Schema Benchmark (SSB) confirm the interest of this approach for the selection of different optimization structures. Finally, we present the OntoReqTool that implements the previous functionality on top of the OntoDB/OntoQL platform.
  • Ngôn ngữ: English
  • Số nhận dạng: ISSN: 1433-2779 ; E-ISSN: 1433-2787 ; DOI: 10.1007/s10009-016-0443-0

Đang tìm Cơ sở dữ liệu bên ngoài...