<?xml version="1.0" encoding="UTF-8"?><?xml-stylesheet type="text/xsl" href="static/style.xsl"?><OAI-PMH xmlns="http://www.openarchives.org/OAI/2.0/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.openarchives.org/OAI/2.0/ http://www.openarchives.org/OAI/2.0/OAI-PMH.xsd"><responseDate>2026-11-22T23:39:49Z</responseDate><request verb="GetRecord" identifier="oai:uwspace.uwaterloo.ca:10012/17426" metadataPrefix="dim">https://dspacemainprd01.lib.uwaterloo.ca/server/oai/request</request><GetRecord><record><header><identifier>oai:uwspace.uwaterloo.ca:10012/17426</identifier><datestamp>2025-03-26T23:36:57Z</datestamp><setSpec>com_10012_9924</setSpec><setSpec>com_10012_1</setSpec><setSpec>col_10012_9930</setSpec><setSpec>col_10012_6</setSpec></header><metadata><dim:dim xmlns:dim="http://www.dspace.org/xmlns/dspace/dim" xmlns:doc="http://www.lyncode.com/xoai" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.dspace.org/xmlns/dspace/dim http://www.dspace.org/schema/dim.xsd">
   <dim:field mdschema="dc" element="contributor" qualifier="advisor">Salem, Ken</dim:field>
   <dim:field mdschema="dc" element="contributor" qualifier="author" authority="6cbb5cc0-abb2-46ae-ae0a-951c7b883ce3" confidence="600">Sethi, Udhav</dim:field>
   <dim:field mdschema="dc" element="date" qualifier="accessioned">2021-09-20T23:36:37Z</dim:field>
   <dim:field mdschema="dc" element="date" qualifier="available">2021-09-20T23:36:37Z</dim:field>
   <dim:field mdschema="dc" element="date" qualifier="issued">2021-09-20</dim:field>
   <dim:field mdschema="dc" element="date" qualifier="submitted">2021-08-25</dim:field>
   <dim:field mdschema="dc" element="identifier" qualifier="uri">http://hdl.handle.net/10012/17426</dim:field>
   <dim:field mdschema="dc" element="description" qualifier="abstract" lang="en">Servers are typically sized to accommodate peak loads, but in practice, they remain under-utilized for much of the time. During periods of low load, there is an opportunity to save power by quickly adjusting processor performance to match the load. Many systems do this by using Dynamic Voltage and Frequency Scaling (DVFS) to adjust the processor’s execution frequency. In transactional database systems, workload-aware approaches running in the DBMS have proved to be able to manage DVFS more effectively than the underlying operating system, as they have more information about the workload and more control over the workload. In this thesis, we ask whether databases can learn to manage DVFS effectively by observing the effects of DVFS on their workload. We present an approach that uses reinforcement learning (RL) to learn in-DBMS frequency governors. Our results show that governors learned using our technique are competitive with state-of-the-art methods, and are able to adapt to a variety of workload conditions. We also show that our method has an added advantage - it allows flexibility in tuning frequency governance to balance a power-performance trade-off. Finally, we discuss the challenges associated with using RL in this setting due to the overheads of using a learned frequency governor.</dim:field>
   <dim:field mdschema="dc" element="language" qualifier="iso" lang="en">en</dim:field>
   <dim:field mdschema="dc" element="publisher" lang="en">University of Waterloo</dim:field>
   <dim:field mdschema="dc" element="relation" qualifier="uri" lang="en">https://github.com/udhavsethi/learned-freq-gov</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">data systems</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">energy efficiency</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">latency-critical</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">machine learning</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">reinforcement learning</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">transactions</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">databases</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">OLTP</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">performance</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">latency</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">energy-aware</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">deep learning</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">policy gradient</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">REINFORCE</dim:field>
   <dim:field mdschema="dc" element="title" lang="en">Learning Energy-Aware Transaction Scheduling in Database Systems</dim:field>
   <dim:field mdschema="dc" element="type" lang="en">Master Thesis</dim:field>
   <dim:field mdschema="dc" element="pending">false</dim:field>
   <dim:field mdschema="uws-etd" element="degree" qualifier="department" lang="en">David R. Cheriton School of Computer Science</dim:field>
   <dim:field mdschema="uws-etd" element="degree" qualifier="discipline" lang="en">Computer Science</dim:field>
   <dim:field mdschema="uws-etd" element="degree" qualifier="grantor" lang="en">University of Waterloo</dim:field>
   <dim:field mdschema="uws-etd" element="degree" lang="en">Master of Mathematics</dim:field>
   <dim:field mdschema="uws-etd" element="embargo" qualifier="terms" lang="en">0</dim:field>
   <dim:field mdschema="uws" element="contributor" qualifier="advisor">Salem, Ken</dim:field>
   <dim:field mdschema="uws" element="contributor" qualifier="affiliation1" lang="en">Faculty of Mathematics</dim:field>
   <dim:field mdschema="uws" element="published" qualifier="city" lang="en">Waterloo</dim:field>
   <dim:field mdschema="uws" element="published" qualifier="country" lang="en">Canada</dim:field>
   <dim:field mdschema="uws" element="published" qualifier="province" lang="en">Ontario</dim:field>
   <dim:field mdschema="uws" element="typeOfResource" lang="en">Text</dim:field>
   <dim:field mdschema="uws" element="peerReviewStatus" lang="en">Unreviewed</dim:field>
   <dim:field mdschema="uws" element="scholarLevel" lang="en">Graduate</dim:field>
   <dim:field mdschema="others" element="access-status">open.access</dim:field>
</dim:dim>
</metadata></record></GetRecord></OAI-PMH>