國立高雄大學圖資館 |

Language: English

Back

Dynamic, Hardware-Conscious Tuning of Concurrent Multithreaded Analytical Database Queries /

Record Type:	Electronic resources : Monograph/item
Title/Author:	Dynamic, Hardware-Conscious Tuning of Concurrent Multithreaded Analytical Database Queries /Sofia Tijanic.
Author:	Tijanic, Sofia,
Description:	1 electronic resource (97 pages)
Notes:	Source: Masters Abstracts International, Volume: 86-05.
Notes:	Advisors: Jacobsen, Hans-Arno Committee members: Enright Jerger, Natalie; Abdelrahman, Tarek S.; Dawson, Francis.
Contained By:	Masters Abstracts International86-05.
Subject:	Computer engineering.
Online resource:	http://pqdd.sinica.edu.tw/twdaoapp/servlet/advanced?query=30997514
ISBN:	9798342741637

Dynamic, Hardware-Conscious Tuning of Concurrent Multithreaded Analytical Database Queries /
Tijanic, Sofia,

Dynamic, Hardware-Conscious Tuning of Concurrent Multithreaded Analytical Database Queries /Sofia Tijanic. - 1 electronic resource (97 pages)

Source: Masters Abstracts International, Volume: 86-05.

This thesis introduces a framework called PCMonitor that monitors underlying hardware metrics during a program's execution and enables applications to make dynamic, runtime changes in order to achieve better performance. We apply PCMonitor to a custom hash join implementation in order to emulate main-memory database systems and show the performance improvement of concurrently running queries. In modern databases, optimizations in query planning and resource allocation happen before a query executes, thereby disregarding the runtime hardware conditions that are often different than what can be predicted during the optimization process. PCMonitor makes use of performance counter events and memory profiling in order to monitor hardware conditions continuously as a query is executing and then algorithmically makes decisions about certain actions and re-configurations that the query can take in order to improve performance. This takes traditional query optimization one step further by creating elastically adapting queries that act based on real- time conditions. We show that by making runtime decisions using PCMonitor, concurrently running queries can make better decisions about pausing and resuming their execution, sharing memory resources and sharing hardware resources, resulting in up to 50% better performance for individual queries.

English

ISBN: 9798342741637Subjects--Topical Terms:

212944
Computer engineering.
Subjects--Index Terms:

Databases

Dynamic, Hardware-Conscious Tuning of Concurrent Multithreaded Analytical Database Queries /
LDR:02851nmm a22004333i 4500 001 676287
005 20250420214335.5
006 m o d
007 cr|nu||||||||
008 250901s2024 miu||||||m |||||||eng d
020 $a 9798342741637
035 $a (MiAaPQD)AAI30997514
035 $a AAI30997514
040 $a MiAaPQD $b eng $c MiAaPQD $e rda
100 1 $a Tijanic, Sofia, $e author. $0 (orcid)0009-0008-3436-3893 $3 990038
245 1 0 $a Dynamic, Hardware-Conscious Tuning of Concurrent Multithreaded Analytical Database Queries / $c Sofia Tijanic.
264 1 $a Ann Arbor : $b ProQuest Dissertations & Theses, $c 2024
300 $a 1 electronic resource (97 pages)
336 $a text $b txt $2 rdacontent
337 $a computer $b c $2 rdamedia
338 $a online resource $b cr $2 rdacarrier
500 $a Source: Masters Abstracts International, Volume: 86-05.
500 $a Advisors: Jacobsen, Hans-Arno Committee members: Enright Jerger, Natalie; Abdelrahman, Tarek S.; Dawson, Francis.
502 $b M.A.S. $c University of Toronto (Canada) $d 2024.
520 $a This thesis introduces a framework called PCMonitor that monitors underlying hardware metrics during a program's execution and enables applications to make dynamic, runtime changes in order to achieve better performance. We apply PCMonitor to a custom hash join implementation in order to emulate main-memory database systems and show the performance improvement of concurrently running queries. In modern databases, optimizations in query planning and resource allocation happen before a query executes, thereby disregarding the runtime hardware conditions that are often different than what can be predicted during the optimization process. PCMonitor makes use of performance counter events and memory profiling in order to monitor hardware conditions continuously as a query is executing and then algorithmically makes decisions about certain actions and re-configurations that the query can take in order to improve performance. This takes traditional query optimization one step further by creating elastically adapting queries that act based on real- time conditions. We show that by making runtime decisions using PCMonitor, concurrently running queries can make better decisions about pausing and resuming their execution, sharing memory resources and sharing hardware resources, resulting in up to 50% better performance for individual queries.
546 $a English
590 $a School code: 0779
650 4 $a Computer engineering. $3 212944
650 4 $a Information technology. $3 184390
650 4 $a Information science. $3 190425
653 $a Databases
653 $a Distributed systems
653 $a Hardware optimization
653 $a Hash join
653 $a Performance counters
690 $a 0464
690 $a 0489
690 $a 0723
710 2 $a University of Toronto (Canada). $b Electrical and Computer Engineering. $3 795309
720 1 $a Jacobsen, Hans-Arno $e degree supervisor.
773 0 $t Masters Abstracts International $g 86-05.
790 $a 0779
791 $a M.A.S.
792 $a 2024
856 4 0 $u http://pqdd.sinica.edu.tw/twdaoapp/servlet/advanced?query=30997514