<?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-22T14:40:35Z</responseDate><request verb="GetRecord" identifier="oai:uwspace.uwaterloo.ca:10012/8531" metadataPrefix="dim">https://dspacemainprd01.lib.uwaterloo.ca/server/oai/request</request><GetRecord><record><header><identifier>oai:uwspace.uwaterloo.ca:10012/8531</identifier><datestamp>2017-03-21T13:58: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="author" authority="a3124fa7-3f92-4c00-ad5d-8ef48f5ee0de" confidence="600">Liu, Xin</dim:field>
   <dim:field mdschema="dc" element="date" qualifier="accessioned">2014-06-17T18:19:44Z</dim:field>
   <dim:field mdschema="dc" element="date" qualifier="available">2014-06-17T18:19:44Z</dim:field>
   <dim:field mdschema="dc" element="date" qualifier="issued">2014-06-17</dim:field>
   <dim:field mdschema="dc" element="date" qualifier="submitted">2014-05-22</dim:field>
   <dim:field mdschema="dc" element="identifier" qualifier="uri">http://hdl.handle.net/10012/8531</dim:field>
   <dim:field mdschema="dc" element="description" qualifier="abstract" lang="en">Caching is a classical but effective way to improve system performance.&#xd;
To improve system performance, servers, such as database servers and storage servers, contain&#xd;
significant amounts of memory that act as a fast cache.&#xd;
Meanwhile, as new storage devices such as flash-based solid state drives (SSDs)&#xd;
are added to storage systems over time, using the&#xd;
memory cache is not the only way to improve system performance.&#xd;
In this thesis, we address the problems of how to manage the cache of a storage server and&#xd;
how to utilize the SSD in a hybrid storage system. &#xd;
&#xd;
Traditional caching policies are known to perform poorly for storage&#xd;
server caches.  One promising approach to solving this problem is to use hints&#xd;
from the storage clients to manage the storage server cache.  Previous&#xd;
hinting approaches are ad hoc, in that a predefined reaction to&#xd;
specific types of hints is hard-coded into the caching policy.  With&#xd;
ad hoc approaches, it is difficult to ensure that the best hints are&#xd;
being used, and it is difficult to accommodate multiple types of hints&#xd;
and multiple client applications.  In this thesis, we propose&#xd;
CLient-Informed Caching (CLIC), a generic hint-based technique for&#xd;
managing storage server caches.  CLIC automatically interprets hints&#xd;
generated by storage clients and translates them into a server caching&#xd;
policy.  It does this without explicit knowledge of the&#xd;
application-specific hint semantics.  We demonstrate using trace-based&#xd;
simulation of database workloads that CLIC outperforms hint-oblivious&#xd;
and state-of-the-art hint-aware caching policies.&#xd;
We also demonstrate that the space required to track and interpret&#xd;
hints is small.&#xd;
&#xd;
SSDs are becoming a part of the storage system. &#xd;
Adding SSD to a storage system not only raises the question of how to manage the SSD,&#xd;
but also raises the question of whether current buffer pool algorithms will still work effectively.&#xd;
We are interested in the use of hybrid storage systems, consisting of SSDs and hard disk drives (HDD),&#xd;
for database management.&#xd;
We present cost-aware replacement algorithms for both the DBMS buffer pool and the SSD.&#xd;
These algorithms are aware of the different I/O performance &#xd;
of HDD and SSD. &#xd;
In such a hybrid storage system, the physical access pattern to the SSD depends on the management of the DBMS buffer pool.&#xd;
We studied the impact of the buffer pool caching policies on the access patterns of the SSD.&#xd;
Based on these studies, we designed a caching policy to effectively manage the SSD. &#xd;
We implemented these algorithms in MySQL&amp;apos;s InnoDB storage engine&#xd;
and used the TPC-C workload to demonstrate that these cost-aware algorithms&#xd;
outperform previous algorithms.</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="subject" lang="en">Database</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">Storage management</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">Cache management</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">Hybrid storage</dim:field>
   <dim:field mdschema="dc" element="subject" lang="en">SSD</dim:field>
   <dim:field mdschema="dc" element="subject" qualifier="program" lang="en">Computer Science</dim:field>
   <dim:field mdschema="dc" element="title" lang="en">Optimizing Hierarchical Storage Management For Database System</dim:field>
   <dim:field mdschema="dc" element="type" lang="en">Doctoral Thesis</dim:field>
   <dim:field mdschema="dc" element="pending">false</dim:field>
   <dim:field mdschema="uws-etd" element="degree" qualifier="department" lang="en">School of Computer Science</dim:field>
   <dim:field mdschema="uws-etd" element="degree" lang="en">Doctor of Philosophy</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>