Requirements Driven Database Physical Design

Ouared, Abdelkader; Kharroubi, Fatima Zohra

Models & Optimisation and Mathematical Analysis Journal
Volume 8, Numéro 1, Pages 28-35
2020-12-31

Requirements Driven Database Physical Design

Authors : Ouared Abdelkader . Kharroubi Fatima Zohra .

Abstract

Designing database systems is an inherently complex process, especially with the Big Data Era and the spectacular evolution of conceptual, logical, physical models, deployment platforms, and the complexity of queries. As a result, the database (DB) design often has to compare the goodness performance of hypothetical designs without having to access the full databases and hardware of end-users. Every physical design solution is not valid for every database and workload and is not adequate for every context. To tackle this problem, we propose an approach, based on the Model Driven Architecture (MDA) to facilitate the selection of the right physical design for non-expert users. The approach is based on three different models: (i) a requirements model based on goal-oriented modeling for representing information requirements, (ii) a Database Context model for representing database, and query which will be connected to database materialization and, (iii) a database materialization model for representing physical design details regardless of their implementation technology (e.g. hardware, disk-layout, Deployment-Platform, deployment Architecture). Together with these models, a set of transformations allow us to provides a database without requiring the setup of physical hardware, the deployment of architecture, or the need to configure the database. Finally, a case study is presented.