Title :
The Design and Implementation of System Monitoring Component of Workload Adaptation Framework in Autonomic DBMSs
Author :
Yan Qiang ; Jun-jie Chen ; Xiao-Gang Wang
Author_Institution :
Coll. of Comput. & Software, Taiyuan Univ. of Technol., Taiyuan, China
Abstract :
The workload adaptation is a performance management process in autonomic database management system (DBMS). In the workload adaptation framework, the system monitoring component monitors the database resources consumption at SQL command level, and feed back the monitoring information to other related components in this framework. This paper analyzes the functional structure of the system monitoring component, and studies the implementation method. How to reduce the resources consumption of database induced by the monitoring component is partially considered in this paper. Experiments with Oracle 10 are conducted to show the effectiveness of the design and implementation.
Keywords :
database management systems; system monitoring; SQL command level; autonomic DBMS; database management system; database resource consumption; performance management process; system monitoring component design; system monitoring component implementation; workload adaptation framework; Adaptive systems; Clustering algorithms; Computerized monitoring; Control systems; Database systems; Feedback; Feeds; Object oriented modeling; Optimization; Stability; monitoring component; performance monitoring; workload adaptation;
Conference_Titel :
Information Science and Engineering (ISISE), 2009 Second International Symposium on
Conference_Location :
Shanghai
Print_ISBN :
978-1-4244-6325-1
Electronic_ISBN :
978-1-4244-6326-8
DOI :
10.1109/ISISE.2009.134
