Automated Database Tuning using Dynamic SGA Parameters: A Practical Approach - Couverture souple

Sharma, Hitesh Kumar

 
9783659751127: Automated Database Tuning using Dynamic SGA Parameters: A Practical Approach
Couverture souple
ISBN 10 : 365975112X ISBN 13 : 9783659751127
Editeur : LAP LAMBERT Academic Publishing, 2017

Synopsis

The knowledge of the system, the data stored, the workload and the inter-dependency between them is a major requirement for tuning a Database Management System (DBMS). Due to complexity of the DBMSs and the diversity of their workload, there is a need for automatic tuning of DBMS. Self-managing (or autonomic) databases are intended to reduce the total cost of ownership by automatically adapting to evolving workloads and environments. To reach this goal, commercial DBMSs have recently been equipped with self-management functions, which support the database administrator (DBA) in identifying the appropriate indexes or in sizing the memory areas. However, existing techniques suffer from several problems: First, they are often implemented as off-line tools that have to be explicitly triggered by a DBA. Second, they strictly focus on automating one particular administration task, without considering possible side-effects on other components. This book defines the automated manner to make the system self tune in variable workload.

Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.

Présentation de l'éditeur

The knowledge of the system, the data stored, the workload and the inter-dependency between them is a major requirement for tuning a Database Management System (DBMS). Due to complexity of the DBMSs and the diversity of their workload, there is a need for automatic tuning of DBMS. Self-managing (or autonomic) databases are intended to reduce the total cost of ownership by automatically adapting to evolving workloads and environments. To reach this goal, commercial DBMSs have recently been equipped with self-management functions, which support the database administrator (DBA) in identifying the appropriate indexes or in sizing the memory areas. However, existing techniques suffer from several problems: First, they are often implemented as off-line tools that have to be explicitly triggered by a DBA. Second, they strictly focus on automating one particular administration task, without considering possible side-effects on other components. This book defines the automated manner to make the system self tune in variable workload.

Biographie de l'auteur

Dr. Hitesh Kumar Sharma is an Assistant Professor (Senior Scale) in Dept. of CSE, University of Petroleum & Energy Studies, Dehradun, He has conducted various National Workshops and National/ International Conferences. He has more than 40 Research publications. Currently he is working in Department of Analytics under the umbrella of Dept. of CSE.

Les informations fournies dans la section « A propos du livre » peuvent faire référence à une autre édition de ce titre.

Éditeur
LAP LAMBERT Academic Publishing
Date d'édition
2017
Langue
anglais
ISBN 10 
365975112X
ISBN 13 
9783659751127
Reliure
Broché
Nombre de pages
184
Coordonnées du fabricant
non disponible
Personne responsable
KreGa Onlinehandel GmbH
4950000000000
info@krega-onlinehandel.de

Birkenweg 31
Brakel
33034
Allemagne