The IRMA Community
Newsletters
Research IRM
Click a keyword to search titles using our InfoSci-OnDemand powered search:
|
Toward Autonomic DBMSs: A Self-Configuring Algorithm for DBMS Buffer Pools
|
|
Author(s): Patrick Martin (Queen’s University, Canada), Wendy Powley (Queen’s University, Canada)and Min Zheng (Queen’s University, Canada)
Copyright: 2006
Pages: 22
Source title:
Advanced Topics in Database Research, Volume 5
Source Author(s)/Editor(s): Keng Siau (Singapore Management University, Singapore)
DOI: 10.4018/978-1-59140-935-9.ch012
Purchase
|
Abstract
This chapter introduces autonomic computing as a means to automate the complex tuning, configuration, and optimization tasks that are currently the responsibility of the database administrator. We describe an algorithm called the dynamic reconfiguration algorithm (DRF) that can be implemented as part of an autonomic database management system (DBMS) to manage the DBMS buffer pools, which are a key resource in a DBMS. DRF is an iterative algorithm that uses greedy heuristics to find a reallocation that benefits a target transaction class. DRF uses the principle of goal-oriented resource management. We define and motivate the cost- estimate equations used in the algorithm and present the results of a set of experiments to investigate the performance of the algorithm.
Related Content
|
Renjith V. Ravi, Mangesh M. Ghonge, P. Febina Beevi, Rafael Kunst.
© 2022.
24 pages.
|
|
Manimaran A., Chandramohan Dhasarathan, Arulkumar N., Naveen Kumar N..
© 2022.
20 pages.
|
|
Ram Singh, Rohit Bansal, Sachin Chauhan.
© 2022.
19 pages.
|
|
Subhodeep Mukherjee, Manish Mohan Baral, Venkataiah Chittipaka.
© 2022.
17 pages.
|
|
Vladimir Nikolaevich Kustov, Ekaterina Sergeevna Selanteva.
© 2022.
23 pages.
|
|
Krati Reja, Gaurav Choudhary, Shishir Kumar Shandilya, Durgesh M. Sharma, Ashish K. Sharma.
© 2022.
18 pages.
|
|
Nwosu Anthony Ugochukwu, S. B. Goyal.
© 2022.
23 pages.
|
|
|