Multi-core parallelism in a column-store (Book, 2017) [WorldCat.org]
skip to content
Multi-core parallelism in a column-store Preview this item
ClosePreview this item
Checking...

Multi-core parallelism in a column-store

Author: Mrunal Gawade
Publisher: [S.l. : s.n.], 2017.
Dissertation: Proefschrift Universiteit van Amsterdam.
Series: SIKS dissertation series, no. 2017-04.
Edition/Format:   Thesis/dissertation : Thesis/dissertation : EnglishView all editions and formats
Summary:
"The research reported in this thesis addresses several challenges of improving the efficiency and effectiveness of parallel processing of analytical database queries on modern multi- and many-core systems, using an open-source column-oriented analytical database management system, MonetDB, for validation. In contrast to the existing work we also broaden the research from focusing on individual operators and  Read more...
Rating:

(not yet rated) 0 with reviews - Be the first.

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Material Type: Thesis/dissertation
Document Type: Book
All Authors / Contributors: Mrunal Gawade
ISBN: 9789402804904 9402804900
OCLC Number: 1151530361
Notes: Met samenvatting in het Nederlands.
Description: xiv, 209 p. : ill. ; 24 cm
Series Title: SIKS dissertation series, no. 2017-04.
Responsibility: Mrunal Madhukar Gawade.

Abstract:

"The research reported in this thesis addresses several challenges of improving the efficiency and effectiveness of parallel processing of analytical database queries on modern multi- and many-core systems, using an open-source column-oriented analytical database management system, MonetDB, for validation. In contrast to the existing work we also broaden the research from focusing on individual operators and algorithms to consider the entire system and process holistically. Resource-efficient parallel query execution requires a detailed insight into its query execution affecting parameters. We design and develop new visual analysis techniques and tools that help to identify and rank performance bottlenecks of parallel query execution on multi-core systems. We design and develop a novel learning based adaptive technique for multi-core parallel plan generation using query execution feedback. This techniques proves to be particularly efficient with concurrent workloads, a scenario which is very common in practice but has been largely uncharted in database query parallelization research. We also introduce a simple technique where a multi-socket system is treated as a distributed shared nothing database system, where the remote memory accesses could be constrained thereby having a controlled query execution performance. Many-core system architectures imitate GPU style parallel execution, however, data transfer on the PCle bus which connects Xeon-Phi co-processor to the host, is a bottleneck. We analyze the effect of streaming execution of selected queries, to utilize PCle bandwidth optimally. The lessons, experiences and insights gained in this thesis are valuable for the emerging analytical database systems in the context of multi and many-core systems."--Samenvatting auteur.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.