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. |