Show simple item record

dc.contributor.authorZhang, Mingyien
dc.date2008-11-17 15:35:50.303
dc.date.accessioned2008-11-17T20:52:50Z
dc.date.available2008-11-17T20:52:50Z
dc.date.issued2008-11-17T20:52:50Z
dc.identifier.urihttp://hdl.handle.net/1974/1584
dc.descriptionThesis (Master, Computing) -- Queen's University, 2008-11-17 15:35:50.303en
dc.description.abstractResource allocation in a database management system (DBMS) is a performance management process in which an autonomic DBMS makes resource allocation decisions based on properties like workload business importance. We propose the use of economic models in a DBMS to guide the resource allocation decisions. An economic model is described in terms of business trades and concepts, and it has been successfully applied in some computer system resource allocation problems. In this thesis, we present approaches that use economic models to allocate single and multiple DBMS resources, such as main memory buffer pool space and system CPU shares, to workloads running concurrently on a DBMS based on the workloads’ business importance policies. We first illustrate how economic models can be used to allocate single DBMS resources, namely system CPU shares, to competing workloads on a DBMS. We then extend this approach to using economic models to simultaneously allocate multiple DBMS resources, namely buffer pool memory space and system CPU shares, to competing workloads on a DBMS based on the workload business importance policy in order to achieve their service level agreements. Experiments are conducted using IBM® DB2® databases to verify the effectiveness of our approach.en
dc.format.extent893161 bytes
dc.format.mimetypeapplication/pdf
dc.language.isoengen
dc.relation.ispartofseriesCanadian thesesen
dc.rightsThis publication is made available by the authority of the copyright owner solely for the purpose of private study and research and may not be copied or reproduced except as permitted by the copyright laws without written authority from the copyright owner.en
dc.subjectDatabase Management Systemsen
dc.subjectComputer Scienceen
dc.titleUsing Economic Models to Tune Resource Allocations in Database Management Systemsen
dc.typethesisen
dc.description.degreeM.Sc.en
dc.contributor.supervisorMartin, Patricken
dc.contributor.departmentComputingen
dc.degree.grantorQueen's University at Kingstonen


Files in this item

Thumbnail

This item appears in the following Collection(s)

Show simple item record