Abstract | ||
---|---|---|
As database management systems (DBMSs) continue to expand into new application areas, the complexity of the systems and the diversity of database workloads are increasing. Managing the performance of DBMSs via manual adjustment of resource allocations in this new environment has become impractical. Autonomic DBMSs shift the responsibility for performance management onto the systems themselves. This paper serves as a proof of concept, illustrating how autonomic principles can be applied to a DBMS to provide automatic sizing of buffer pools, a key resource in a DBMS. We describe an implementation of our autonomic system in PostgreSQL, an open source database management system, and provide a set of experiments that verify our approach. |
Year | DOI | Venue |
---|---|---|
2005 | 10.1109/ICSMC.2005.1571121 | Systems, Man and Cybernetics, 2005 IEEE International Conference |
Keywords | Field | DocType |
SQL,buffer storage,public domain software,relational databases,resource allocation,PostgreSQL,autonomic buffer pool configuration,open source database management system,performance management,resource management,Autonomic Computing,Database Management Systems,buffer pool configuration,performance,resource management | SQL,Relational database,Computer science,Proof of concept,Resource allocation,Sizing,Performance management,Database,Public domain software | Conference |
Volume | ISSN | ISBN |
1 | 1062-922X | 0-7803-9298-1 |
Citations | PageRank | References |
1 | 0.35 | 8 |
Authors | ||
4 |
Name | Order | Citations | PageRank |
---|---|---|---|
Wendy Powley | 1 | 329 | 28.43 |
patrick martin | 2 | 148 | 18.22 |
Nailah Ogeer | 3 | 1 | 0.35 |
Wenhu Tian | 4 | 22 | 2.42 |