Optimisation des bases de données Mise en oeuvre sous Oracle

Abstract

The optimization of data bases is at the heart of the issues raised by the database administrator. Its objective is to provide, to different users, an optimal system in terms of cost and use. Optimization fear being reflected at several levels: the conceptual level, the physical infrastructure level and at query execution to achieve the best performance in terms of response time and use of resources. Our PFE consists of applying a set of comparative test son a data base, by varying several parameters in different phases of our study, to achieve the best response time or the lowest cost in terms of material resources.