Using MDE for Teaching Database Query Optimizer

Abdelkader Ouared, Abdelhafid Chadli

2021

Abstract

Query optimization is considered as an important part of Data Base Management Systems (DBMS) and plays a major role in database research community (e.g. SQL, Spark, Map-reduce). Generally, this optimization is done using Cost Base Optimization (CBO), which is difficult to understand due to the complexity of platform, database, query and DBMS. Moreover, database query optimizer is usually a very complex process, with difficult concepts depending on the behaviour of the query engine of DBMS. Therefore, users (e.g. novice user, developer, DB administrator) have difficulties to understand and build a mental image of database query optimizer in order to produce more efficient queries. In this paper, we propose a Framework based on the model-driven engineering (MDE) paradigm to facilitate understanding and improving query performance. Indeed, MDE approach has been proven useful for developing new software applications, and its adoption for a teaching perspective presents a major challenge. We illustrate our proposal with use case and proofofconcept prototype for the whole provided process.

Paper Citation

in Harvard Style

Ouared A. and Chadli A. (2021). Using MDE for Teaching Database Query Optimizer. In Proceedings of the 16th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: MDI4SE, ISBN 978-989-758-508-1, pages 529-536. DOI: 10.5220/0010535105290536

in Bibtex Style

@conference{mdi4se21,
author={Abdelkader Ouared and Abdelhafid Chadli},
title={Using MDE for Teaching Database Query Optimizer},
booktitle={Proceedings of the 16th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: MDI4SE,},
year={2021},
pages={529-536},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0010535105290536},
isbn={978-989-758-508-1},
}

in EndNote Style

TY - CONF

JO - Proceedings of the 16th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: MDI4SE,
TI - Using MDE for Teaching Database Query Optimizer
SN - 978-989-758-508-1
AU - Ouared A.
AU - Chadli A.
PY - 2021
SP - 529
EP - 536
DO - 10.5220/0010535105290536